Skillshareintermediateen

Microsoft Excel Intermediate - Creating a Dashboard

Master Microsoft Excel! This project-based course boosts your skills for work & personal use. Learn practical Excel techniques & enhance productivity.

4.5(6)
419students
1h 15m
Certificate
Learnhoot Professional
Learnhoot ProfessionalHelping Students Develop Professional Skills

Course Content

Microsoft Excel Intermediate - Creating a Dashboard is an intermediate-level Skillshare course taught by Learnhoot Professional. It runs 1h 15m, is taught in English, and includes a certificate of completion. Learners rate it 4.5 out of 5 from 6 reviews, with 419 students enrolled. It is a paid course, first published November 2020.

Are you ready to transform your data into compelling visuals? This project-based course is designed for anyone who wants to master Microsoft Excel dashboards, regardless of your current skill level. We'll build a real-world dashboard from start to finish, simulating a workplace scenario. No prior Excel experience is required – we'll begin with the fundamentals and progress at a comfortable pace.

Here's what you'll learn:

  • Pivot Tables for Dashboards: Understand the power of Pivot Tables and how to leverage them effectively to create insightful dashboards.
  • Chart Creation: Master the art of creating all the necessary charts for a professional-looking dashboard.
  • Slicers: Learn to design and implement effective slicers to enhance data filtering and interactivity. We'll focus on making them visually appealing!
  • Data Refresh: Discover how to automate your dashboard so it automatically updates with new data using basic VBA (Visual Basic for Applications).
  • Dashboard Design Principles: Explore techniques for creating visually appealing dashboards, including how to create fantastic gradients and design beautiful slicers.
  • Data Transformation: Learn how to transform a large, complex data set into clear, informative charts and visualizations.
  • Sales Dashboard Design: Specifically learn how to design a powerful sales dashboard to track key performance indicators.

By the end of this course, you'll be able to confidently take raw data and create visually engaging, insightful, and user-friendly dashboards in Microsoft Excel. You'll gain the skills to transform large datasets into actionable intelligence.

$ whoami — the devs behind tutorialsearch.io

Hire the developers behind TutorialSearch.io

We built this site — full-stack web apps, AI integration & automation. Tell us what you need and we'll build yours.

5.0(235)
4h 19m
intermediate
skillshare
5.0(308)
6h 52m
intermediate
skillshare
5.0(462)
3h 57m
intermediate
skillshare
5.0(234)
1h 36m
all
skillshare
skillshare