Foundations of Microsoft Excel Dashboards, Data Analysis and Visualization

Integrate complex analysis and visualization into interactive dashboards using MS Excel with this free online course.

Published by

Saved For Later

Confident you have the skills to certify without completing the course content?

Learning Outcomes

In this free course, you will learn how to:

Identify the various tips for formula editing in MS Excel
Describe the working principle behind the MS Excel calculation engine
Describe how to write better formulas in Microsoft Excel
Identify the main rules and the advantages of using MS Excel tables
Distinguish between the sorting and decision functions
Analyse the pros and cons of MS Excel Form and ActiveX controls
Discuss the notion of formula-driven development
Explain the concept of dashboards
Discuss the dynamics of information–transformation–presentation in the context of interactivity
Describe the importance of visual perception in the process of presenting information
Identify the various tips for using special and bullet charts
Explain the advantages of infographics in MS Excel

Published by

Positive learner ratings

Learners Courses

Earn credentials that matter: Anyone can say they’re learning. A CPD-accredited Alison Certificate proves you followed through.
Get an edge over others: Add your Certificate to your CV, LinkedIn, and Alison Profile to strengthen job applications and promotion opportunities.
Show you’re serious about growth: A Certificate signals initiative, commitment, and a willingness to keep learning; qualities employers actively look for.