In this course, you will :
- Learn about business intelligence and dashboards for analysing information. Create a basic dashboard and master data setup to get the most out of it.
- Learn how to format specific cells on your dashboard using rules based on criteria you specify. As the values in the cells change, the formatting changes.
- how to prepare your data and use the Data Validation and VLookup formulas to target specific data for charting
- Learn how to use Conditional Formatting to apply a format to a cell or range of cells based on specific criteria, and then how to create a dashboard that displays plots and data together.
- Business Intelligence and Using Dashboards
- Efficient Column Charts
- Dashboard Controls
- Other Charts for Your Dashboard
- Conditional Formatting