Excel analytics
Excel for Data Analysis and Presentation
Use Excel for descriptive, statistical, and predictive analysis with PivotTables, Power Query, Power Pivot, Analysis ToolPak, What-If Analysis, and forecasting tools.
Move from spreadsheet reporting to structured analytics.
Designed for professionals who analyze operational or performance data and need to interpret results clearly for business decisions.
Understand descriptive, statistical, and predictive analytics.
Analyze large datasets with advanced PivotTables.
Prepare and model data using Power Query and Power Pivot.
Perform statistics, forecasting, and clear analytical presentations.
Course overview
A practical, instructor-led program with guided exercises and workplace examples. Open a topic to see the coverage.
Part 1. Fundamentals of Data Analytics
- Data Analytics Process Flow and Cycle
- Types of Data Analytics
Part 2. Deep Dive on PivotTables
- Review of Basic Pivot Table Features
- Grouping Dates and Text Data
Part 3. Data Modeling using Power Query and PowerPivot
- Importing Data to Power Pivot
- Introduction to Power Query
Part 4. Performing Statistical Analysis
- Using the Analysis Toolpak
- Descriptive Statistics
Part 5. Forecasting or Predictive Analysis
- Using What If Analysis Tools
- Goal Seek and Solver
Full course outline
Review the complete legacy course outline, including all detailed subtopics.
View full outline
- Part 1. Fundamentals of Data Analytics
- Data Analytics Process Flow and Cycle
- Types of Data Analytics
- Descriptive Analytics
- Statistical Analytics
- Predictive Analytics
- Part 2. Deep Dive on PivotTables
- Review of Basic Pivot Table Features
- Grouping Dates and Text Data
- Formatting Numbers
- Creating Slicers and Timelines
- Changing Data Presentation
- Show Values as
- Changing Calculation
- Creating Formulas: Calculated Fields and Items
- Adding Texts in the Pivot Table Value Area
- Part 3. Data Modeling using Power Query and PowerPivot
- Importing Data to Power Pivot
- Introduction to Power Query
- Choosing Only Needed Columns
- Basic Data Wrangling in Power Query
- Modifying Text Data
- Creating Conditional Columns
- Creating PivotTables from PowerPivot
- Creating Calculated Columns in a Power Pivot Table
- Introduction to DAX Formulas
- Part 4. Performing Statistical Analysis
- Using the Analysis Toolpak
- Descriptive Statistics
- Understanding Standard Deviation
- Understanding the Empirical Rule (68-95-99.7 Rule)
- Visualizing Data Distribution using Histogram
- Using Skewness and Kurtosis to Analyze Data
- Analyzing Variance
- Understanding Variance and Formulating the Null Hypothesis
- ANOVA Test
- Performing F-Test
- Part 5. Forecasting or Predictive Analysis
- Using What If Analysis Tools
- Goal Seek and Solver
- Scenario Manager
- Forecasting Tools in MS Excel
- Types of Forecast: Regression Analysis and Exponential Smoothing
- Analyzing Trend using Excel Functions (FORECAST.LINEAR, CORREL, etc.)
- Regression Analysis using Analysis Toolpak
- Identifying the R-Square
- P-Value
- Calculating Trend Manually
- Presenting Regression using Scatter Chart
- Creating a Forecast Sheet (Exponential Smoothing)