Data Analysis and Visualization with Microsoft Excel (D.A.V.E.)

 

Course Overview

Data is the lifeblood of every business and understanding data through descriptive, predictive, and prescriptive analytics is critical to driving business success in a data driven economy. Creating great visualizations is another key to extracting maximum value out of their data. You will learn how to perform robust data analysis and create stunning visualizations using advanced Microsoft Excel tools.

Prerequisites

To ensure success, you should have baseline skill using Microsoft Excel worksheets, particularly in creating workbooks with formulas and functions.

Course Objectives

After completing this course, students will be able to:

  • Data Analysis Fundamentals
  • How to Visualize Data in Excel
  • Using Formulas and Functions to Analyze Data
  • Analyzing data with PivotTables
  • Presenting Dashboards
  • Creating Geospatial Visualizations
  • Statistical Analysis
  • Getting and Transforming Data
  • Modelling Data with Power Pivot
  • Presenting Insight with Reports

Outline: Data Analysis and Visualization with Microsoft Excel (D.A.V.E.)

Module 1: Data Analysis Fundamentals

Lessons

  • Topic A: Data Analysis Scenarios
  • Topic B: Tables
  • Topic C: Sort and Filter Data

Module 2: Visualizing Data with Excel

Lessons

  • Topic A: Visualize Data with Charts
  • Topic B: Modify and Format Charts
  • Topic C: Best Practices for Selecting Charts

Module 3: Analyzing Data with Formulas and Functions

Lessons

  • Topic A: Analyze Data with Formulas
  • Topic B: Analyze Data with Functions
  • Topic C: Analyze Data with Data Validation, Forms, and Controls
  • Topic D: Create Conditional Visualization with Lookup Functions

Module 4: Analyzing Data with PivotTables

Lessons

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

Module 5: Presenting Visual Insights with Dashboards in Excel

Lessons

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

Module 6: Creating Geospatial Visualizations with Excel

Lessons

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

Module 7: Performing Statistical Analysis

Lessons

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

Module 8: Getting and Transforming Data

Lessons

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

Module 9: Modeling and Analyzing Data with Power Pivot

Lessons

  • 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

Module 10: Presenting Insights with Reports

Lessons

  • Topic A: Planning a Report
  • Topic B: Creating a Report

Prices & Delivery methods

Online Training

Duration
2 days

Price
  • Online Training: CAD 590
  • Online Training: US$ 590
Classroom Training

Duration
2 days

Price
  • Canada: CAD 590

Click on town name or "Online Training" to book Schedule

This is an Instructor-Led Classroom course
Guaranteed date:   We will carry out all guaranteed training regardless of the number of attendees, exempt from force majeure or other unexpected events, like e.g. accidents or illness of the trainer, which prevent the course from being conducted.
Instructor-led Online Training:   This computer icon in the schedule indicates that this date/time will be conducted as Instructor-Led Online Training.
*   This class is delivered by a partner.

United States

Online Training 09:00 US/Eastern * Enroll
Guaranteed to Run Online Training 09:00 US/Eastern * Enroll