August 8, 2025

Live Webcast

NYSED 4

Introduction to Excel Data Analytics, Accelerated by ChatGPT Webcast

August 8, 2025
Live Webcast
NYSED 4

Introduction to Excel Data Analytics, Accelerated by ChatGPT Webcast

  • Instructor

    Donald
    Tomoff

  • 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

Learning Objectives

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.

Major Topics

  • 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

CPE Credits Available

NYSED 4
4
Specialized Knowledge / Industries (NYSED) - NYSED

Things to Know About This Course

Course Level

  • Intermediate

Professional Area of Focus

  • Specialized Knowledge / Industries (NYSED)

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.

Advanced Preparation

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.

Intended Audience

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.

Provider

AICPA

This event has ended.