D.A.V.E. - Data Analysis and Visualization with Microsoft® Excel (Instructor-Led, Online)

Current Status

Not Enrolled

Price

950.00

Get Started

This course is currently closed

Please download this ZIP file and extract it to a NEW FOLDER named "Data Analysis and Visualization with Microsoft® Excel" that you have created in your "My Documents"

Course Content

Expand All

Data Analysis and Visualization with Microsoft® Excel

Lesson 1: Data Analysis Fundamentals 3 Topics

Expand

Lesson Content

0% Complete 0/3 Steps

Topic A: Introduction to Data Science

Topic B: Create and Bodify Tables

Topic C: Sort and Filter Data

Lesson 2: Visualizing Data with Excel 3 Topics

Expand

Lesson Content

0% Complete 0/3 Steps

Topic A: Visualize Data with Charts

Topic B: Modify and Format Charts

Topic C: Apply Best Practices in Chart Design

Lesson 3: Analyzing Data with Formulas and Functions 4 Topics

Expand

Lesson Content

0% Complete 0/4 Steps

Topic a: Analyze Data with Formulas and Named Ranges

Topic B: Analyze Data with Functions

Topic C: Implement Data Validation, Forms, and Controls

Topic D: Crate Conditional Visualizations with Lookup Functions

Lesson 4: Analyzing Data with PivotTables 2 Topics

Expand

Lesson Content

0% Complete 0/2 Steps

Topic A: Create a PivotTable

Topic B: Analyze PivotTable Data

Lesson 5: Presenting Visual Insights with Dashboards in Excel 3 Topics

Expand

Lesson Content

0% Complete 0/3 Steps

Topic A: Visualize Data with PivotCharts

Topic B: Filter Data Using Slicers and Timelines

Topic C: Create a Dashboard in Excel

Lesson 6: Creating Geospatial Visualizations with Excel 2 Topics

Expand

Lesson Content

0% Complete 0/2 Steps

Topic A: Create Map Charts in Excel

Topic B: Customize Map Charts in Excel

Lesson 7: Performing Statistical Analysis 2 Topics

Expand

Lesson Content

0% Complete 0/2 Steps

Topic A: Visualize Trendlines and Sparklines with Excel

Topic B: Analyze Data with the Data Analysis ToolPak

Lesson 8: Getting and Transforming Data 3 Topics

Expand

Lesson Content

0% Complete 0/3 Steps

Topic A: Connect to Data with Queries

Topic B: Clean and Combine Data

Topick C: Shape and Transform Data

Lesson 9: Modeling and Analyzing Data with Power Pivot 4 Topics

Expand

Lesson Content

0% Complete 0/4 Steps

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 10: Presenting Insights with Reports (Optional) 2 Topics

Expand

Lesson Content

0% Complete 0/2 Steps

Topic A: Plan a Report

Topic B: Create a Report

D.A.V.E. – Data Analysis and Visualization with Microsoft® Excel (Instructor-Led, Online)

Course Content

Recent Posts

Recent Comments