Learn how to explore and analyze your data by creating an interactive dashboard in Excel using pivot tables and Visual Basic. In this course, you will learn how to create a dynamic template to generate business reports for customers and to better understand your own data. You’ll learn how to import external data, design a template using pivot tables, and add slicers, macros, and action buttons to make the template more interactive.
- Defining your requirements
- Setting up data
- Adding reference tables
- Creating hierarchy in the layout
- Choosing color and typography
- Importing data
- Inserting slicers
- Recording a macro
- Editing VBA code
- Improving the user experience
- Analysing data with Goal Seek and Solver
All participants will receive a Certificate of Completion from Tertiary Courses after achieved at least 75% attendance.
Funding and Grant Applications
Click the links below to apply. Note that you need to register the course first.
For WSQ funding, please checkout the details at NICF – Create Interactive Dashboard Using Excel
Courses are provided by tertiarycourses.com.sg