Course Description:
Learn Excel from the comfort of your office or home.
This two-hour LIVE Instructor-led course will give you the tools to create dashboards to display key business performance indicators that are relevant to a business process. A dashboard is a visual interface that shows data at a glance, and often includes conclusions that alleviate the need for the viewer to analyze the data being presented.
In Dashboards Part 1 we will look at building formulas, use Data Validation with the VLOOKUP function, and create Combo Boxes with the INDEX function to create our Dashboard. Topics include:
- Create advanced formulas using range names and specialized functions
- Automate workbook functionality by applying Data Validation and working with Forms and Controls
- Apply conditional logic using LOOKUP functions and combining functions.
Prerequisites
Excel 2016 Intro to Formulas, Excel 2016 Advanced Formulas or prior knowledge of the topics covered in those classes