English | 2019 | ISBN: ‎ 1509305882 | 881 pages | True PDF | 150.21 MB

Master business modeling and analysis techniques with Microsoft Excel 2019 and Office 365 and transform data into bottom-line results.

Written by award-winning educator Wayne Winston, this hands-on, scenario-focused guide helps you use Excel to ask the right questions and get accurate, actionable answers. New coverage ranges from Power Query/Get & Transform to Office 365 Geography and Stock data types. Practice with more than 800 problems, many based on actual challenges faced by working analysts. 

Solve real business problems with Excel-and build your competitive advantage:

• Quickly transition from Excel basics to sophisticated analytics 
  
  
• Use PowerQuery or Get & Transform to connect, combine, and refine data sources 
  
  
• Leverage Office 365's new Geography and Stock data types and six new functions 
  
  
•  Illuminate insights from geographic and temporal data with 3D Maps 
  
  
• Summarize data with pivot tables, descriptive statistics, histograms, and Pareto charts 
  
  
• Use Excel trend curves, multiple regression, and exponential smoothing 
  
  
• Delve into key financial, statistical, and functions 
  
  
• Master all of Excel's great charts 
  
  
• Quickly create forecasts from historical -based data 
  
  
• Use Solver to optimize product mix, logistics, work schedules, and investments-and even rate sports teams 
  
  
• Run Monte Carlo simulations on stock prices and bidding models 
  
  
• Learn about basic probability and Bayes' Theorem 
  
  
• Use the Data Model and Power Pivot to effectively build and use relational data sources inside an Excel workbook 
  
  
• Automate repetitive analytics tasks by using macros