In this course, author and Excel expert David H. Ringstrom, CPA, will explore advanced techniques for managing and consolidating data using Power Query and modern Excel functions. Attendees will learn how to create flexible workbook links, efficiently combine multiple worksheets, and utilize the VSTACK and HSTACK functions available in Microsoft 365. David will also cover essential Power Query properties, address external data security warnings, and demonstrate how to consolidate multiple entities seamlessly. Additionally, participants will discover the power of using the SUMIF and INDIRECT functions alongside monthly worksheets to streamline their data analysis processes. Join us to enhance your Excel skills and unlock new efficiencies in your data management tasks.
David is the author of “Exploring Microsoft Excel's Hidden Treasures: Turbocharge your Excel proficiency with expert tips, automation techniques, and overlooked features”. He demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Excel for Microsoft 365. David draws your attention to any differences in Excel 2021, 2019 or 2016 during the course and in his detailed handouts. The handouts include an Excel workbook with most of the examples he uses during his demonstrations.
Excel for Microsoft 365 is a subscription-based product that receives periodic feature updates. Conversely, perpetually licensed versions have year numbers in their names and do not receive any feature updates.