Learning Objectives:
• Identify and use the newest Excel features including checkboxes, Focus Cell, improved
PivotTables, dynamic ranges, new worksheet functions, Power Query in Excel for the
web, and tools to prevent unwanted CSV conversions.
• Apply AI-powered Excel tools such as Copilot, Planning Mode, Agentic AI, the COPILOT
function, AI-generated PivotTables, formula explanations, data cleanup, image
extraction, and Python-assisted analysis.
• Improve productivity with advanced modern Excel techniques including GROUPBY,
PIVOTBY, ETA Lambda, LAMBDA replacements for repeated formulas, REGEX pattern
matching, reshaping arrays, and building custom GPTs for Excel workflows.