HARTMANN software group

Excel for Microsoft 365/2021 – Level 4 – Extract, Analyze, and Visualize Data Training in Salt Lake City

Enroll in or hire us to teach our Excel for Microsoft 365/2021 – Level 4 – Extract, Analyze, and Visualize Data class in Salt Lake City, Utah by calling us @303.377.6176. Like all HSG classes, Excel for Microsoft 365/2021 – Level 4 – Extract, Analyze, and Visualize Data may be offered either onsite or via instructor led virtual training. Consider looking at our public training schedule to see if it is scheduled: Public Training Classes
Provided there are enough attendees, Excel for Microsoft 365/2021 – Level 4 – Extract, Analyze, and Visualize Data may be taught at one of our local training facilities.
We offer private customized training for groups of 3 or more attendees.
get pricing information

Course Description

  

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.

Course Length: 1 Days
Course Tuition: $250 (US)

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

  
  1. Course Overview
    1. Course Flow
    2. Course Flow Graphical Objectives
  2. 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
  3. 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
  4. Supplemental Topics
    1. Working with Slicers in Dashboards
    2. Course Data Folder Location

Course Directory [training on all levels]

Technical Training Courses
Software engineer/architect, System Admin ... Welcome!
Business Training Courses
Project Managers, Business Analysts, Paralegals ... Welcome!
Upcoming Classes
Gain insight and ideas from students with different perspectives and experiences.

Interesting Reads Take a class with us and receive a book of your choosing for 50% off MSRP.