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.
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.
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.