Master business modeling and analysis techniques with Microsoft Excel, and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables--and how to effectively build a relational data source inside an Excel workbook.
"Mathletics shows readers how to use simple mathematics to analyze a range of statistical and probability-related questions in professional baseball, basketball, football, soccer, lacrosse, and golf, and in sports gambling. The authors describe the mathematical methods that top coaches and managers use to evaluate players and improve team performance, and give math enthusiasts the practical tools they need to enhance their understanding and enjoyment of their favorite sports - and maybe even gain the outside edge to winning bets. Mathletics blends fun and challenging math problems with sports stories of actual games, teams, and players, along with personal anecdotes from Winston's work as a sports consultant. The book includes easy-to-read tables and illustrations to illuminate the techniques and ideas presented, and all the necessary mathematical concepts - such as arithmetic, basic statistics and probability, and Monte Carlo simulations - are fully explained in the examples. The revised edition will include about 75 pages of revised text and roughly 40 new figures. The book will include updates to the data and inclusion of more recent players and teams throughout all the chapters. It will also include new chapters on soccer, lacrosse, and golf, as well as new findings on regression, game theory, and optimization"--
Written by award-winning educator Wayne Winston, this hands-on, scenario-focused guide will help you apply Excel 2016's most valuable innovations for data analysis and business modeling. It's packed with realistic problems and solutions to help you gain mastery -- including over 150 that are new or revised. Coverage includes: Quickly transitioning from basic Excel to more sophisticated analytics Summarizing data with PivotTables and Descriptive Statistics Exploring new trends in predictive and prescriptive analytics Using Excel Trend Curves, multiple regression, and exponential smoothing Mastering advanced Excel functions such as OFFSET and INDIRECT Delving into key financial, statistical, and time functions Making charts more effective with Power View Tame complex optimization problems with Excel Solver Running Monte Carlo simulations on stock prices and bidding models Using Excel 2016's new FORECAST and Power Map tools Working with the AGGREGATE function and Table Slicers Creating multiple PivotTables from a filter Using HYPERLINKS, ISFORMULA, and UNICODE Performing sensitivity analyses with more than two variables Making the most of the Inquire add-in And much more "
Opanuj techniki modelowania biznesowego i analizy z wykorzystaniem Microsoft Excel, przekształcając dane w użyteczne wnioski. Wayne Winston, doświadczony akademik, pokazuje, jak zadawać właściwe pytania i uzyskiwać precyzyjne odpowiedzi. Nowe wydanie, znacznie rozszerzone, obejmuje tematy od analizy jednym kliknięciem po HISTORIA.AKCJI, dynamiczne tabele, Power Query oraz sześć nowych rozdziałów. Rozwijaj umiejętności, rozwiązując ponad 900 rzeczywistych problemów analitycznych. Zyskaj przewagę konkurencyjną, rozwiązując konkretne wyzwania biznesowe w Excelu. Szybko przejdź od podstaw do zaawansowanych analiz, korzystając z ulepszeń Power Query do pobierania danych z różnych źródeł. Wykorzystaj funkcję LAMBDA do tworzenia własnych funkcji bez VBA oraz nowe typy danych do importowania informacji o cenach akcji, pogodzie, geografii, filmach i muzyce. Buduj zaawansowane wykresy oraz stosuj nową funkcję XLOOKUP do rewolucji w formułach wyszukiwania. Odkryj dynamiczne formuły tablicowe do sortowania, filtrowania danych i wyszukiwania unikalnych wartości. Usprawnij podejmowanie decyzji przez analizy prawdopodobieństwa, symulacje Monte Carlo oraz regresję wielokrotną w analizach predykcyjnych. Wykorzystaj model danych i Power Pivot do efektywnego zarządzania relacyjnymi źródłami danych.