Loading

Smashing September Sale - Get 25% Off Certificates and Diplomas! Limited-time Offer - ends Friday, 17th September 2021

Claim My 25% OFF

Foundations of Microsoft Excel Dashboards, Data Analysis and Visualization

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

Publisher: Jordan Goldmeier
Microsoft Excel is a fantastic data analysis, data visualisation, and dashboarding tool. Consider how much easier our daily tasks would be if we learned to create and understand complex Excel features. This course teaches you how to use hundreds of valuable Excel functions correctly. Learn about the advanced formulas and functions that turn Excel into powerful and interactive analytics and data visualisation tools.
Foundations of Microsoft Excel Dashboards, Data Analysis and Visualization
  • Duration

    6-10 Hours
  • Students

    672
  • Accreditation

    CPD

Description

Modules

Outcome

Certification

View course modules

Description

Dashboard aids in tracking key performance indicators or metrics and making decisions based on them. They can be created with a variety of different tools. However, due to its ease of use and universal availability, Microsoft Excel is an excellent choice for creating and distributing dashboards. This course aims at illustrating the process of developing interactive dashboards using Excel. It starts by discussing the need to start thinking about challenges differently to make incredible things in Excel. You will understand how important it is to move away from the old and outdated way of using excel towards new and innovative techniques. A scope of methods and strategies for working efficiently with formulas is explained. Also, you will learn how excel uses a calculation engine to integrate multiple inputs to execute calculations on a spreadsheet. You will comprehend the methods of searching for a specific value in a column to return a value from a different column in the same row using the VLOOKUP function. The formula for doing various computations on one or more array objects is also explained.

The significance of sorting functions in the systematic ordering of data is explained in the following section. You will discover although the used functions are not specifically designed to sort data, they perform admirably in this capacity. Following that, the course explains how decision functions are not functions such as if or choose functions but rather functions such as aggregate that assists us in bringing data together to make the best decision. It is explained how to filter a segment of data within a table to isolate the important parts. Following that, you will understand why Sumproduct is a function that allows us to perform function-wise aggregation. The course also goes over the many sorts of Excel controls. You will explore the distinctions between Excel form controls and ActiveX controls. The course then moves on to discussing formula-driven development.

The final section will demonstrate how to construct a dashboard that will completely attract and hold the viewer's attention. You will discover the significance of comprehending the fundamental notion of visual perception. Following that, the attributes of Preattentive features and Gestalt grouping laws are explained. You will learn about the methods of defining and using interactive dashboards to visualise data in the form of a narrative. In addition, the procedure for creating customised charts and lists with bulleted lists is also highlighted. The last part depicts several types of infographics. You will explore the ways of developing and integrating different kinds of infographics using the camera tool. Discover how to turn a data range into a dashboard so you can operate more efficiently and productively.

Start Course Now

Careers