Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Skillshare

Advanced Excel Dashboarding for 2023

via Skillshare

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

If you love working on Data and love to identify Insights for your team, management or for yourself then this class is all you need.

In this course, we will take you on a journey with a group of friends who are struggling to make sense of their data. With your help, they will transform into data professionals and create stunning dashboards that will impress their bosses and clients.

Throughout the course, you will learn the best practices for creating effective and visually appealing dashboards.

During this class you will Learn the following

  • Data preparation,
  • Formatting
  • Data Structuring
  • Principles of Dashboard Design
  • How to choose the right chart types
  • How to choose the right colors, and fonts
  • How to use them to tell a compelling story.
  • Coloring and Theming
  • Create interactive and user-friendly dashboards using advanced pivot tables and slicers.

In addition, you will learn how to generate actionable insights from your data and present them in a meaningful way.

We will show you how to use various tools and techniques to analyze and visualize your data, and how to use these insights to drive business decisions.

By the end of this course, you will have the skills and knowledge to create world-class dashboards that will wow your audience.

You’ll be creating:

  • A visually stunning Dashboard with Interactive Tools

You will also gain a deep understanding of the principles and techniques behind effective data visualization, and how to apply them in your own work.

Whether you are a beginner or an experienced Excel user, this course will take your data analysis skills to the next level. So come join us on this exciting journey and become a data professional today!

Syllabus

  • Course Introduction
  • Introduction to the Story For Dashboard
  • Creating Business Questions for Dashboard
  • Setting up the Environment
  • Generating Business Answers and Questions
  • Choosing Charts
  • Aligning and Resizing the Charts
  • Removing Distractions
  • Bringing the Insights Out
  • Contextual Charting | Complex Dashboard
  • Slicers and Timelines
  • Coloring and Theming
  • Final Creative Touches before Publishing
  • Managing Blanks and Views | Complex Dashboard
  • Aligning Complex Chart and Customizing Slicers | Complex Dashboard
  • Grouping or Categorization | Complex Dashboard
  • Customizing Everything and Hidden Chart Options
  • Customizing the Slicer Colors
  • Data Summarization for your Dashboards
  • Course Conclusion

Taught by

Kadhiravan Jayachandiran

Reviews

Start your review of Advanced Excel Dashboarding for 2023

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.