Use the Data Analysis and Visualization with Excel course and lab to learn the skills of excel data visualization. The course and lab provide knowledge and skills required for analyzing data with formulas and functions; analyzing data with PivotTables, presenting visual insights with dashboards in excel, and many more. This course also provides knowledge related to analyzing data with the data analysis ToolPak, connecting to Data with Queries and many more.

starstarstarstarstar

* Actual course outline may vary depending on offering center. Contact your sales representative for more information.

Learning Objectives

Use the Data Analysis and Visualization with Excel course and lab to learn the skills of excel data visualization. The course and lab provide knowledge and skills required for analyzing data with formulas and functions; analyzing data with PivotTables, presenting visual insights with dashboards in excel, and many more. This course also provides knowledge related to analyzing data with the data analysis ToolPak, connecting to Data with Queries and many more.

1

  • Introduction

  • Course Description
    How to Use This Course
    Course-Specific Technical Requirements
2

  • Data Analysis Fundamentals

  • Topic A: Introduction to Data Science
    Topic B: Create and Modify Tables
    Topic C: Sort and Filter Data
    Summary
3

  • Visualizing Data with Excel

  • Topic A: Visualize Data with Charts
    Topic B: Modify and Format Charts
    Topic C: Apply Best Practices in Chart Design
    Summary
4

  • Analyzing Data with Formulas and Functions

  • 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: Create Conditional Visualizations with Lookup Functions
    Summary
5

  • Analyzing Data with PivotTables

  • Topic A: Create a PivotTable
    Topic B: Analyze PivotTable Data
    Summary
6

  • Presenting Visual Insights with Dashboards in Excel

  • Topic A: Visualize Data with PivotCharts
    Topic B: Filter Data Using Slicers and Timelines
    Topic C: Create a Dashboard in Excel
    Summary
7

  • Creating Geospatial Visualizations with Excel

  • Topic A: Create Map Charts in Excel
    Topic B: Customize Map Charts in Excel
    Summary
8

  • Performing Statistical Analysis

  • Topic A: Visualize Trendlines and Sparklines with Excel
    Topic B: Analyze Data with the Data Analysis ToolPak
    Summary
9

  • Getting and Transforming Data

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

  • 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
    Summary
11

  • Presenting Insights with Reports

  • Topic A: Plan a Report
    Topic B: Create a Report
    Summary

Audience

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 Excel using PivotTables, use tools such as Power Pivot and the Analysis ToolPak to analyze data, and visualize data and insights using advanced visualizations in charts and dashboards in Excel.

Language

English

Prerequisites

While there are no prerequisites for this course, please ensure you have the right level of experience to be successful in this training.

Length: 365.0 days ( hours)

Level:

Not Your Location? Change

Course Schedule:

To request a custom delivery, please chat with an expert.

Loading...