Course ID: IEDA

Introduction to Excel Data Analytics, Accelerated by ChatGPT

About & Customize

Popular Options

  • In-Person
  • Live Webcast

After completing this course, participants will have:

  • Gained awareness in proper Excel data structure, advanced formulas, including dynamic arrays, and data validation techniques to manipulate and analyze data effectively.
  • Learned how to extract, clean, transform, and model data using Power Query (Get and Transform). Understand the Power Pivot data model and apply DAX functions for advanced calculations, and create effective structured models for analysis.
  • Become familiar with the skills necessary to design interactive dashboards using Pivot Tables, Pivot Charts, slicers, and timelines to represent data in a visually engaging manner.
  • Recall how to leverage ChatGPT to accelerate their workflow in formula development, troubleshooting, and data visualization brainstorming to enhance productivity in Excel-based data analysis tasks.

Course topics include:

  • Introductions and Course Overview
  • Excel Data Structures
  • Essential Data-Related Excel Functions
  • Pivot Tables and Pivot Charts
  • Power Query and M-Code
  • Power Pivot and DAX
  • Accelerating Processes with ChatGPT
  • Demonstration – Automated File Directory List
Designed For

Any professional interested in gaining an understanding of Excel’s data related specific features and learning how generative AI/Chatgpt can serve as an assistant to accelerate our Excel workflow.

Field of Study
Computer Software & Applications
Prerequisites

The participant should be comfortable using Excel, navigating the Excel interface, entering formulas, etc. This is an introductory course delving into some of the intermediate data analysis tools and concepts of Excel.

Course Producer
Business Learning Institute
CPE Credits
4
Level
Intermediate
Available Formats
In-Person, Live Webcast

This course, like all courses in the BLI catalog, is customizable for your organization. Format, length, and content customizations are available.

To get started, contact BLI:
(888) 777-7077
team@blionline.org