Instructor-led training

Excel for Microsoft 365/2021 – Level 4 – Extract, Analyze, and Visualize Data Training in Desert Hot Springs, California

Microsoft Office training from Hartmann Software Group, delivered onsite in Desert Hot Springs, California or live online.

Request a Training Proposal View Course Outline

What you'll learn

This course teaches participants how to extract and prepare raw data for analysis, perform data analysis to gather necessary outputs and KPIs, and create visual data dashboards by assembling these outputs with other elements.

Prerequisites

Participants should have an intermediate understanding of Excel, including working with shapes, formulas, functions, and tables, as well as some familiarity with data analysis concepts.

Course Outline

Course Overview
1. Course Flow
2. Course Flow Graphical Objectives
Working with Data Extraction, Transformation, and Loading
1. Understanding the Extract, Transform, and Load Process
2. Power Query Overview
3. Getting Started with Power Query
4. Managing Query Results
5. Reorganizing Data
6. Combing Data
7. Working with Web Data
Working with Data Analysis and Dashboards
1. Data Analysis and Dashboard Overview
2. Getting Started with Dashboards
3. Data Analysis for Dashboard Objects
4. Completing and Using Dashboards
Supplemental Topics
1. Working with Slicers in Dashboards
2. Course Data Folder Location

Training locations

Excel for Microsoft 365/2021 – Level 4 – Extract, Analyze, and Visualize Data training across the U.S. and beyond.

We provide Excel for Microsoft 365/2021 – Level 4 – Extract, Analyze, and Visualize Data training onsite and live online for organizations throughout the United States and internationally.

View all Excel for Microsoft 365/2021 – Level 4 – Extract, Analyze, and Visualize Data training locations

Ready to train your team?

Let's customize this training for your organization.

Tell us about your employees, your goals, and your preferred schedule. We'll prepare a training proposal covering scope, delivery format, and pricing.

Request a Training Proposal

or call 303.377.6176