2026 AI-Powered Excel Masterclass: Copilot, Automation and Beyond

LIVE ONLINE TRAINING COURSE Artificial Intelligence in Excel: From Smart Features to Copilot Discover how artificial intelligence can make Excel smarter, faster, and more efficient. This practical online training session with David Ringstrom, CPA and author of Excel for Dummies, explores Excel’s built-in intelligent features along with the latest AI capabilities in Microsoft 365 and Copilot. You’ll learn how to clean and analyze data, automate repetitive tasks, create formulas, extract information from pictures and websites, and build reusable spreadsheet solutions using Excel’s AI-powered tools. What You’ll Learn • Use Flash Fill to quickly recognize patterns and automatically complete data. • Explore Recommended PivotTables and Recommended Charts to analyze and visualize data efficiently. • Use Analyze Data to uncover trends, patterns, and useful insights. • Extract data from pictures and web pages and bring it directly into Excel. • Understand the fundamentals and capabilities of AI agents. • Copy and reuse named LAMBDA functions across workbooks and verify them through Name Manager. • Use the COPILOT worksheet function for data analysis and automation. • Convert COPILOT formulas into reusable custom functions with LAMBDA. • Combine LAMBDA and COPILOT to automate AI-powered requests. • Explore Microsoft’s evolving AI roadmap and emerging Excel capabilities. Session Highlights The session focuses on practical techniques you can apply immediately, including: • Quickly navigating worksheets, ranges, and objects using search and links. • Understanding how AI agents can assist with spreadsheet tasks. • Creating reusable Excel functions with LAMBDA. • Bringing online data into workbooks and creating automatic links. • Using Recommended Charts to select suitable visualizations with minimal effort. • Combining Excel functions and AI to create smarter, repeatable workflows. Why Attend? By the end of the session, you’ll be able to: • Explain what Flash Fill does and when to use it. • Describe the purpose of Excel’s Forecast feature. • Identify how dynamic-array formulas are displayed in Excel’s formula bar and worksheet. • Recognize opportunities to use AI for data cleaning, analysis, categorization, and automation. • Apply Copilot and LAMBDA techniques to create more efficient and reusable spreadsheets.