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:
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