Excel remains the most critical tool in any accounting professional's arsenal—but the platform keeps evolving, and most practitioners aren't tapping into even half of what's now possible. This specialized conference cuts through the noise to focus exclusively on Microsoft Excel's latest capabilities that matter most to your daily workflow. From dynamic arrays and LAMBDA functions to Power Query automation and modern data manipulation tools, you'll discover features that can genuinely transform how you work. These aren't theoretical exercises—they're real-world techniques you can implement immediately to handle larger datasets, reduce errors, and reclaim hours every week. Whether you're still relying on methods from five years ago or you're already pushing Excel's boundaries, these sessions will equip you with practical skills that make an immediate difference. With two opportunities to attend in 2026, you can choose the timing that works best or revisit the material as Excel continues its rapid evolution. Don't let your Excel knowledge stagnate while the platform races ahead.
Learning Objectives
- Apply advanced Excel functions and features released in recent updates to streamline common accounting tasks and improve accuracy in financial analysis
- Implement Power Query and modern data manipulation techniques to automate repetitive processes and handle increasingly complex datasets Utilize
- PivotTables and dynamic array functions to create more flexible, maintainable reports that adapt to changing business requirements
- Recognize overlooked built-in tools and shortcuts that can significantly reduce time spent on routine Excel operations
- Build more efficient workflows using contemporary Excel capabilities designed specifically for data-intensive professional environments
Major Topics
- Excel Blocking and Tackling – Often Overlooked Tools
- Advanced Excel Functions and Latest Features
- Power Query and Other Data Manipulation Tools
- PivotTables – Excel's Best Feature Is Now Even Better
- Modern Dynamic Arrays and Formulas
- Techniques Workflow Optimization Strategies for Financial Professionals
