Data Analysis and Visualization with Microsoft Excel

Formats: 8-hour virtual course  |  2-day instructor-led onsite

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. You will use tools such as Power Pivot and the Data Analysis ToolPak to analyze and visualize data and insights.

Learning Objectives »

  • Perform data analysis fundamentals.
  • Visualize data with Excel.
  • Analyze data with formulas, functions & PivotTables.
  • Present visual insights with dashboards in Excel.
  • Create geospatial visualization with Excel.
  • Perform statistical analysis and transform data.
  • Model and analyze data with Power Pivot.

Course Agenda »

Data Analysis Fundamentals

  1. Introduction to Data Science
  2. Create and Modify Tables
  3. Sort and Filter Data

Visualizing Data with Excel

  1. Visualize Data with Charts
  2. Modify and Format Charts
  3. Best Practices in Chart Design

Analyzing with Formulas & Functions

  1. Formulas and Named Ranges
  2. Functions
  3. Data Validation, Forms, and Controls
  4. Conditional Visualizations with Lookup

Analyzing Data with PivotTables

  1. Create a PivotTable
  2. Analyze PivotTable Data

Visual Insights with Dashboards

  1. Visualize Data with PivotCharts
  2. Filter Data Using Slicers and Timelines
  3. Create a Dashboard in Excel

Creating Geospatial Visualizations

  1. Create Map Charts in Excel
  2. Customize Map Charts in Excel

Performing Statistical Analysis

  1. Visualize Trendlines and Sparklines
  2. Analyze Data with the Data Analysis ToolPak

Getting and Transforming Data

  1. Connect to Data with Queries
  2. Clean and Combine Data
  3. Shape and Transform Data

Modeling & Analyzing with Power Pivot

  1. Install Power Pivot in Excel
  2. Create Data Models with Power Pivot
  3. Create Power Pivots
  4. Advanced Data Analysis and Visualization

Presenting Insights with Reports

  1. Plan a Report
  2. Create a Report