Purchase any WEBINAR and get
10% Off
Validity : 26th Mar'25 to 05th Apr'25
Excel continues to evolve, introducing powerful new features that enhance productivity, accuracy, and data analysis. Whether you’re a finance professional, accountant, analyst, or compliance specialist, staying up to date with Excel’s latest tools can help you work smarter and more efficiently.
In this one-hour webinar, we’ll explore cutting-edge updates that can streamline workflows, improve governance, and reduce risk—essential for GRC professionals. You’ll discover how Artificial Intelligence and Copilot can create pivot tables in seconds, how Excel Labs can simplify complex formula structures, and how Python integration unlocks new possibilities for automation and advanced analytics.
We’ll dive into new functions like GROUPBY and PIVOTBY with Eta Lambda, as well as HSTACK, to efficiently summarize and analyze large datasets. Learn how checkboxes in Excel enhance interactivity, how to prevent numbers from changing during imports or replacements, and how to monitor performance to keep workbooks running smoothly.
Visual data representation has also improved with the IMAGE function and the ability to store pictures inside cells, making reports more dynamic. We’ll also cover significant PivotTable enhancements, including default settings, numeric formatting from the source, and improved date grouping.
By the end of this session, you’ll have a clear understanding of how these new features can help you increase efficiency, improve data integrity, and enhance decision-making in your Excel workflows.
Are you making the most of Excel’s latest innovations? Join us for this exclusive one-hour webinar where we’ll explore new game-changing features designed to enhance efficiency, accuracy, and insight in your spreadsheets.
Discover how AI and Copilot can automate pivot table creation, how Excel Labs can simplify complex formulas, and how Python integration is revolutionizing data analysis. Learn about GROUPBY and PIVOTBY functions, checkboxes, and stale value formatting, all designed to enhance control and compliance—critical for GRC professionals.
We’ll also cover import stability, performance checks, and new pivot table improvements that streamline workflows. Plus, see how to use IMAGE functions for dynamic visuals and lookup pictures within cells for richer reports.
If you work with data in Excel, this webinar is essential—stay ahead of the curve and leverage Excel’s newest capabilities to enhance accuracy, governance, and efficiency.
Don’t miss out—register today!
Bill Jelen is the host of MrExcel.com and the author of 69 books about Microsoft Excel including Excel Gurus Gone Wild, Pivot Table Data Crunching, and Microsoft Excel Inside Out. He was an ESPN commentator for the World Excel Championships, has made over 80 guest appearances on TV's Call for Help with Leo Laporte and was voted guest of the year on the Computer America radio show. He writes the Excel column for Strategic Finance magazine. He has produced over 2500 episodes of his video podcast Learn Excel from MrExcel. Bill will entertain you while showing you the powerful tricks in Excel. Before founding MrExcel.com in 1998, Jelen spent twelve years “in the trenches”, as a financial analyst for the accounting, finance, marketing, and operations departments of a publicly held company. Since then, his company automates Excel reports for hundreds of clients around the world. The website answers over 30,000 questions a year – for free – for readers all over the world. Jelen joins us from Merritt Island, Florida.