Course Length: 2 days

Target Student:

This course is designed for students who already have foundational knowledge and skills in Excel and who wish to perform robust and advanced data and statistical analysis with Microsoft Excel using Pivot Tables, use tools such as Power Pivot and the Data Analysis ToolPak to analyze data, and visualize data and insights using advanced visualizations in charts and dashboards in Excel.

Prerequisites:

Excel Level 1 Foundation

Excel Level 2 Intermediate

Excel Level 3 Advanced

Course Content

Lesson 1: Analyzing and Visualizing Data for Business

  • Topic A: Data Analysis Scenarios
  • Topic B: Visualize Data with Charts
  • Topic C: Modify and Format Charts

Lesson 2: Analyzing Data with Formulas and Functions

  • Topic A: Analyze Data with Formulas
  • Topic B: Analyze Data with Functions
  • Topic C: Analyze Data with Data Validation, Forms, and Controls

Lesson 3: Creating Conditional Visualizations

  • Topic A: Use Lookup Functions
  • Topic B: Combine Functions

Lesson 4: Creating PivotTables, PivotCharts, and Slicers

  • Topic A: Create a PivotTable
  • Topic B: Analyze PivotTable Data
  • Topic C: Visualize Data with PivotCharts
  • Topic D: Filter Data Using Slicers

Lesson 5: Presenting Data in an Excel Dashboard

  • Topic A: Dashboard Planning
  • Topic B: Create a Dashboard in Excel

Lesson 6: Performing Statistical Analysis

  • Topic A: Visualize Trendlines and Sparklines with Excel
  • Topic B: Install and Activate the Data Analysis ToolPak

Lesson 7: Getting and Transforming Data

  • Topic A: Connect to Data with Queries
  • Topic B: Clean and Combine
  • Topic C: Shape and Transform Data

Lesson 8: Modeling and Analyzing Data with Power Pivot

  • Topic A: Install Power Pivot in Excel
  • Topic B: Create Data Models with Power Pivot
  • Topic C: Create Power Pivots
  • Topic D: Perform Advanced Data Analysis and Visualization

Lesson 9: Creating Geospatial Visualizations with Excel

  • Topic A: Create Map Charts in Excel
  • Topic B: Format and Customize Map Charts in Excel