Automating Excel-based Financial Statements: Power BI

In this course, author and Excel expert David H. Ringstrom, CPA, will introduce participants to creating financial statements with Power BI on an introductory level. David will use trial balance and chart of accounts reports from QuickBooks Online as sample materials for concepts that can be applied to any accounting software. He'll discuss common stumbling blocks that accounting reports can cause, as well as how to create self-updating financial statements by connecting Power BI to a folder of reports. You'll see how to transform trial balance reports into the basis for creating an income statement with a Power BI matrix. Additionally, David will demonstrate the Power BI matrix drill down/drill up feature, providing valuable insights into data analysis and visualization. Don't miss this opportunity to enhance your analytical skills and improve your financial reporting capabilities. 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 desktop app for Power BI. The handouts include the Excel workbooks that he will use during his demonstrations.