HARTMANN software group

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

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.