Presented by David H. Ringstrom, CPA
 

In this presentation, CPA and author of "Microsoft 365 Excel for Dummies" David Ringstrom demonstrates how to build financial statements in Power BI using data exported from QuickBooks Online. You will learn how to prepare trial balance and chart of accounts data, combine and transform multiple files with Power Query, model financial statements with custom sorting, and create formatted matrix visuals for reporting. The session concludes by showing how to refresh Power BI reports as source data changes, providing a repeatable workflow for ongoing financial reporting.
 
David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Microsoft 365 (formerly Office 365) version of Excel. David draws your attention to any differences in the older versions of Excel (2021, 2019, 2016 and earlier) during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast.
 
Microsoft 365 is a subscription-based product that provides new feature updates as often as monthly. Conversely, the perpetual licensed versions of Excel have feature sets that don't change. Perpetual licensed versions have year numbers, such as Excel 2021, Excel 2019, and so on.
 
Who should attend:
Accounting professionals, financial analysts, and Excel users who want to create dynamic financial statements in Power BI using QuickBooks Online data.
 
Topics typically covered:
 
• Merging two queries together to create a combined list.
 
• Arranging rows, columns, and values in a Matrix visual using the same concepts as Excel PivotTables.
 
• Exporting the Chart of Accounts report from QuickBooks Online.
 
• Formatting and removing columns within Power Query results.
 
• Applying number formatting to columns within a Power BI matrix.
 
• Importing an individual Excel workbook into Power Query.
 
• Comparing the free versions of Power BI to the paid versions.
 
• Splitting columns by delimiter, such as commas, spaces, periods, and so on.
 
• Adding calculated columns to Power Query results by way of Custom Columns.
 
• Contrasting Microsoft Excel to Power Query and Power BI
 
• Stacking two or more Excel worksheets together then transforming the results.
 
• Tracing through a typical Power BI workflow.
 
Learning objectives:
 
• State what the equivalent of a PivotTable in Microsoft Excel is within Power BI.
 
• Name the natural language tool in Power BI that enables you to create visualizations by way of written questions or search terms.
 
• State which Power BI task pane enables you to add features to a report.