Getting Ready for Power BI
Duration: 3 Hours
By the end of this course participants will be prepared to move onto Power BI. You will be able to create multiple levels of nested functions, as well as being able to select the proper functions in building an entire project. In this training, Power BI concepts will be integrated for practical understanding.
Prerequisites: To ensure your success, we recommend an intermediate level of Excel experience. If you have experience with Power BI, this can be helpful, but is not required.
Creating and Formatting basic Charts
- Creating a chart
- Formatting a chart
- Working with Charts
Creating Sparklines
- What are sparklines
- Types of Sparklines
- Formatting and Clearing Sparklines
In-Cell Charts and Formatting
- What is Conditional Formatting
- How to highlight duplicates
- How to add colour scales
- How to add data bars
- How to add icon sets
- How to view/edit conditional formatting
- How to create an in-cell progress bar
- How to highlight every other row using a formula
- How to highlight cells based on range
Intermediate Functions
- Index
- Match
- Xlookup
Basic Pivot Table Functionality
- Sum function
- Count function
- Average function
- Max function
- Min function
- Format the results
>For deeper insights, some content may be closely related to Power BI features and approaches.
These lab exercises provide an excellent opportunity to practice skills that are important for anyone using Power BI in real-world scenarios.