Creating an Interactive Excel Dashboards for Business Analytics | WSQ Courses

Originally published at: Creating an Interactive Excel Dashboards for Business Analytics | WSQ Courses – WSQ courses | SkillsFuture Courses

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.

Course Highlights

  • 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

Certificate

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