Loading

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

Claim My 25% OFF

Interactive Dashboards and Data Visualization in Excel

Explore the methods to get the most out of data visualization and infographics using excel with this free online course.

Publisher: Jordan Goldmeier
Do you know that over 60% of people use Excel for data exploration and chart creation because of its flexibility and ease of use? Communicating data-driven results, motivation and detection of defects are the important components of data analysis. Get the skills needed to produce graphs and diagrams that are effective and professional. Find out how the data can be understandable by visual attraction for the human mind.
Interactive Dashboards and Data Visualization in Excel
  • Duration

    1.5-3 Hours
  • Students

    232
  • Accreditation

    CPD

Description

Modules

Outcome

Certification

View course modules

Description

Have you ever wondered how to make a presentation that completely captivates and holds the audience's attention? Or, instead, how can you bring the knowledge closer to you so that you can fully comprehend it? First and foremost, you must become acquainted with the fundamental concept of visual perception. This is exactly what this course aims to accomplish. It begins by outlining the importance of utilising Excel and debunking some frequent misunderstandings about it. You will learn how to use Excel to organise, filter, and visualise massive volumes of data. The concept of dashboards is then discussed. The concept of dashboards is then discussed. The various elements of dashboards such as reports, data, tables, charts, and other interactive components are highlighted.

The concept of visual perception is explained in the following section. It brings to light the idea that what we see in the visual world enters our brain and is processed differently depending on the context. You will comprehend the interactions that occurred between the visual world and our brain. There are psychological reasons why some data visualisation strategies work better than others. You will ascertain the need for applying Gestalt Principles during the process of visualising data. These principles play a significant role in creating graphics that effectively communicate information. Following that, you will discover that the preattentive qualities are concerned with how we see the information. Their importance in understanding the methods of distinguishing information from other data is explained. Additionally, You will also learn the distinctions between data visualisation and infographics.

Finally, the procedure for creating customised charts are illustrated. You will explore when and how to use dual-axis banding, area chart banding, limit and bullet charts in data visualisation. The final section depicts the various types of infographics. You will understand how infographics help in conveying an existing tale and why narration is their primary purpose. The steps for making a progress bar, doughnut, and waffle chart are also outlined. You will also learn how to use the camera tool to integrate various kinds of infographics. Understand how to use Microsoft Excel and related tools to analyse and visualise data effectively.

Start Course Now

Careers