+252619884564  info@hankab.com

Project Data Visualization for Reporting in Excel Dashboards

By admin Categories: Microsoft Excel
Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

In this advanced Excel Dashboards course, you will learn how to create interactive, eye-catching dashboards in Excel. This course will cover the fundamentals of data visualization before delving into the theory and concepts that drive data visualization. You will learn how to create compelling narratives through the optimal selection, design, and presentation of charts and graphs. You will finally learn how to construct the ideal chart and graph to effectively convey the story behind your data.

What Will You Learn?

  • Regarding Dashboard design and motivation
  • How to organize data for analysis (cleaning data)
  • Excel formulas for the creation of dashboards
  • Step-by-step lecture on creating and editing pivot tables.
  • How to generate pivot tables from pivot charts
  • Advanced chart techniques in Excel
  • How to add form controls (interactive elements) to your dashboards
  • How to build a Sales Dashboard from scratch
  • How to create a human resources dashboard from scratch

Student Ratings & Reviews

No Review Yet
No Review Yet