• One-Day Course

    6 Hours
    of training

  • 6 to 16 Participants

    6 to 16
    participants from
    your organization

  • On-Site or Virtual

    On-Site at your
    place of business or
    Virtual via Zoom / Teams

COURSE DESCRIPTION

Microsoft Excel has become the de facto spreadsheet application for business. This versatile software package can help you manage virtually any type of data. Whether you are tracking orders, working with budgets, or analyzing a database – Excel is the powerful and flexible solution your job requires.

This hands-on course will teach you the important functions of this industry-standard software.

Courses offered for Excel 2010, 2013, 2016, 365

Other workshops on this topic: Excel – Basic | Excel – Intermediate | Excel Advanced (Data Management) | Excel Advanced (Spreadsheet Analysis)

Microsoft Excel Training

WHO SHOULD ATTEND:

  • Experienced Excel Users

Prerequisites:

YOU WILL LEARN:

  • Understand the process of data extraction, transformation, and loading, data analysis, and dashboard creation
  • Apply the ELT process, perform it manually with Excel, using Power Query with a variety of data types, cleaning and shaping transformations, and loading options
  • Understand various dashboard layout and design considerations, analyze data, and create visual dashboard objects
  • Create and customize Slicers to extend filtering capabilities and enhance the usage and appearance of a dashboard, as well as update the default data folder path for data files with external connections (if required)

COURSE OUTLINE

Course Overview

  • Course Flow
  • Course Flow Graphical Objectives

Working with Data Extraction, Transformation, and Loading

  • Understanding the Extract, Transform, and Load Process
  • Power Query Overview ; Getting Started with Power Query
  • Managing Query Results ; Reorganizing Data
  • Combining Data
  • Working with Web Data

Working with Data Analysis and Dashboards

  • Data Analysis and Dashboard Overview
  • Getting Started with Dashboards
  • Data Analysis for Dashboard Objects
  • Completing and Using Dashboards

Supplemental Topics

  • Working with Slicers in Dashboards
  • Course Data Folder Location

Summary and Evaluations

METHODOLOGY

  • Live, instructor-led training with hands-on exercises

Participants are requested to bring their computers to the session.

Back to all Microsoft Courses

For more details, customization, or pricing…

Please complete the form below and we will respond to you by the next business day!

-MB-