- 6 hours
- 6 lessons
- Online Interactive
- Classroom
RM320
What You Will Learn
- Effective design principles when creating dashboards and presenting data
- Smart techniques to create impressive Excel charts and tables
- Pivot Tables and Pivot Charts, Conditional Formatting, Functions, Formulas and Macros
- How to create a professional dashboard from scratch
- How to add interactivity to your reports on Excel with buttons and drop down menus
- How to use the integrated Microsoft Excel tools to create impressive dashboard reports
Course Outline
- About This Course
- First Steps of Creating Excel Dashboard
- Data Sources
- Basic Design Principles
- Layout of Report
- Color Schemes
- INDEX() and MATCH()
- OFFSET()
- VLOOKUP() and HLOOKUP()
- MID(), LEN(), TEXT(), and TRIM()
- Structure of Pivot Tables
- Formatting Pivot Tables
- Sparklines
- Highlight Comparison
- In-Cell Charts
- Creating Pivot Charts
- Formatting Pivot Charts
- Active X and Form Controls
- Combo Box
- Checkbox
- Spin Button
- Option Button
- List Box
- Scroll Bar
- Basic Preparations
- Sorting Procedure
- Visualization
- Final Touches