Microsoft Excel Data Analysis and Busin

Quickly transition from Excel basics to sophisticated analytics

Use PowerQuery or Get & Transform to connect, combine, and refine data sources

Leverage Office 365s 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 Excels 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

Reviews