Key features

• •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 time functions
• •Master all of Excel’s great charts
• •Quickly create forecasts from historical time-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