course description
this course is the second of a two-part series. click here to register for the first part.
power bi is a microsoft product that empowers you to create interactive business intelligence tools, such as dashboards. in this session author and excel expert david h. ringstrom, cpa builds on the concepts covered in part 1 of this 2-part series, explaining some of the nuances of power bi and demonstrating how to use it to create interactive dashboards. david will also compare the limitations of the free power bi platform to the capabilities of the subscription-based paid power bi platform.
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 presentation 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.
who should attend: professionals who would like to learn how to create interactive reporting tools in power bi and/or microsoft excel.
level: basic
topics typically covered:
- interacting with power bi reports
- comparing the free versions of power bi to the paid versions
- adding tables to a power bi canvas
- resizing slicers within power bi and creating charts
- formatting power bi data
- running an a/r aging summary report in quickbooks online
- creating mobile layouts and sharing power bi reports
- tracing through a typical power bi workflow
learning objectives:
- state which power bi task pane that you use to select objects that will appear on a power bi report
- define hierarchy form for dates within power query tables
- state which power bi view you use to apply number formatting
review our course policies and procedures page for further information