
Mastering Excel Formulas and Functions
24/09/2024




Duration 2-Days Time: 9:00 Am – 5:00 Pm
This course is best suited to anyone in Business Intelligence, data managers, data analysts, or Project Managers. This course would also suit anyone looking to extend their knowledge of Excel to understand some of the more advanced features and how they can be used to work together.
Like a car dashboard, the objective of dashboard reporting is to provide clear and concise information of the key drivers of business performance. Dashboards are a synopsis of business operations and they provide information in visual format that is easy to read, remembered and understood by key decision makers in a business. This should in turn, improve decision making.
Dashboard reports allow managers to get high-level overview of the business and help them make quick decisions. Excel is an excellent tool to make powerful dashboards that can provide analysis, insight and alert managers in timely manner.
Must be able to perform or have working experience with the following functions:
Unit 1: What is a dashboard?
Unit 2: PivotTables & PivotCharts
Unit 3: Useful functions
Unit 4: Conditional Formatting
Unit 5: Form Controls
Unit 6: Working with Charts
Unit 7: Working with Sparklines
Unit 8: Design & Layout