Visually Effective Excel Dashboards (Udemy.com)

Actionable Excel Tips (Templates Included) You Can Use Right Now to Create Eye-Catching Microsoft Excel Dashboards

( 100 Reviews )

Created by: Leila Gharani

Produced in 2021

What you will learn

How to approach an Excel dashboard project from idea to delivery
How to add interactivity to your Excel reports - No VBA required
Impress management with reports that make the decision-making process faster
Clever use of Excel core functionality for responsive spreadsheets
Learn how to create a professional KPI dashboard from scratch
Create impressive, non-standard Excel charts using smart techniques
Build Pivot Table-based dashboards for easy interactivity
Use powerful visual techniques so your content has more effect

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 96 / 100

Course Description

Creating an impressive, interactive Microsoft Excel Dashboard from scratch is not easy!
I used to stare at my empty sheet and wonder where do I even start?
You need a structured process in place to go from idea to outcome in a smooth way.
You'll find out all about it in the course. We setup two fully functioning dashboards from scratch.
This course doesn't just teach you a set of functions and features, but how you can use them together to create impressive reports.
It teaches you how to approach a new Dashboard project and how to structure your work so maintaining the dashboard becomes very easy not just for yourself but for anyone else.
Note: Course recently updated to include new content on dependent combo-boxes and info-graphic charts in Excel
What students are saying
"This course provides a lot of great tips which you can immediately apply to your spreadsheets, no matter what standard of user you are. I have been working in excel for a number of years and I am amazed at the number of simple tips I have learnt in such a short time. Fantastic." -- Carl Postians
"I learned something new and very useful in the first 10 minutes...awesome!" -- Nancy Bowens

What you learn
This course teaches you to create well-designed Excel dashboards so you and your colleagues can see trends and make quick decisions informed by data.
This Microsoft Excel Dashboard course comes with templates, tools and checklists that can be applied directly to your Excel reports.

Excel dashboard & Report templates
Checklists and design guidelines
Excel workbook to follow along

What differentiates this course from the other Microsoft Excel Dashboard courses?
It includes:

The entire process from idea to delivery - every single step without skipping key points.
Tried-and-trusted techniques that are not only applicable to Excel dashboards but any Excel report.
Includes Excel templates, tools and checklists that you can use for your own Excel reports.
Relevant and up-to-date with industry needs right now, as it's based on feedback and suggestions from finance professionals.
Lots of ideas and inspiration to help you come up with own report design

Complex topics are taught in a simple way by an instructor with 17 years of experience.
The course is designed to have an even balance between talking head and screen-cast.
Content is clearly organised so more advanced learners can jump in at any point and follow along with the relevant project file.Who this course is for:

Business Professionals who use Excel to create dashboards and reports
Data analysts
You currently use Excel and want to improve your skills
You'd like to learn how to create interactive reports
You'd like to improve the design of your existing Excel reports

Time: 11h

Instructor Details

Leila Gharani

4.8 Rating
100 Reviews

Leila Gharani is a Microsoft Excel MVP (Most Valuable Professional) dedicated to helping you create outstanding tools and reports in Excel. Her courses are for those who want to learn Excel, accelerate their careers and achieve more in less time.
Leila' background is Masters in Economics, Economist, Consultant, Oracle HFM Accounting Systems Expert & Project Manager. For over 15 years she has worked in the Finance and IT departments implementing reporting systems based on Oracle and SAP. All the while using Excel VBA to automate and improve processes.
Since 5 years, Leila runs her own Excel site and has an active YouTube channel with many engaging, high quality videos. She provides customized Excel dashboard seminars, enhanced visualization techniques, and advanced Excel seminars to large corporations. She also teaches at the University of Applied Sciences in Upper Austria.
Her courses include examples based on her experience as well as the consulting work she has done for international companies. Many of the Excel tips and tricks she shares is based on the questions received from experienced professionals in her Excel training sessions.
She places great value on keeping her Excel courses not only informative but also engaging. For this reason, students will find enough challenges, exercises and downloadable files to practice so they can maximize the value gained from each course.
Leila's p

Excel Basics (2017)

4.9 (15 Reviews)

Provider: YouTube
Time: 12h

Free

Microsoft Excel - Online Tutorial for Beginners (2010)

0.0 (0 Reviews)

Provider: Chandoo.org
Time: 1h 30m

Free

Excel Power Pivot and Power Query For Dummies

Excel Power Pivot and Power Query For Dummies (2016)

0.0 (0 Reviews)

Provider: Amazon

$14.53

More Courses

More courses by Leila Gharani

Unlock Excel VBA and Excel Macros (2021)
4.7 (412 Reviews)

- Provider: Udemy
- Time: 22.5h

$11.99

Excel Essentials for the Real World (Complete Excel Course)

Excel Essentials for the Real World (Complete Excel Course) (2021)
4.8 (410 Reviews)

- Provider: Udemy
- Time: 10h

$11.99

Excel Charts: Visualization Secrets for Impressive Charts

Excel Charts: Visualization Secrets for Impressive Charts (2021)
4.7 (393 Reviews)

- Provider: Udemy
- Time: 8.5h

$11.99

Excel Dynamic Arrays - Beginner to Expert (Microsoft 365)

Excel Dynamic Arrays - Beginner to Expert (Microsoft 365) (2021)
4.9 (216 Reviews)

- Provider: Udemy
- Time: 7h

$11.99

Ultimate Excel Waterfall Chart Course (2021)
4.8 (185 Reviews)

- Provider: Udemy
- Time: 5h

$11.99

Advanced Excel: Top Excel Tips & Formulas

Advanced Excel: Top Excel Tips & Formulas (2021)
4.7 (101 Reviews)

- Provider: Udemy
- Time: 7h

$11.99

All courses by Leila Gharani

Reviews

4.8

100 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

By Siddharth

It's really helpful to learn from scratch to advance level Excel and everything is explained briefly.

By Chandramuni Prakash Hanwate

Its very usefully while preparing business reports, use of slicer is matched with my need.

By Darryl Morgan

Amazing Tutor i always learn something new from Leila!

By Jeremy Bright

Great Style, easy to follow, professional presentation. I'm enjoying her classes.

By Norbert Wupona

Unfortunately there are only 5 starts available... You deserve it. Thanks for all the insights you bring to me. Now I can trust you and be ready for your other courses as well. Because I do believe there are free room to improve. Thank you again for sharing us all of your knowledge mixed with real experiences. Chapeau bas - this is in french :)

By Olli V

Leila has very good understanding of Excel and all its nooks and crannies. She is a good teacher and was able to go through various topics covered by the course very well. I picked up various useful things from this course. I can recommend this if you want to deepen your skills on MS Excel.

By Charles Mendelson

This course taught me how to build a dashboard that took a 20 hour weekly workload into a 15 minute weekly task.

By Jarrett Betts

I very much enjoyed taking this course. I learned a number of useful tricks and methods to improve my excel dashboards, and I highly recommend it to those who want to do the same

By Daniel Mnisi

best course, informative and skillfull

By Shaun Morris

I am an Excel VBA consultant and I thought that I was just taking this course just as a refresher before a new contract to ensure that I was fully ready for anything that could be thrown at me in the new role. Much as when first discovering ExcelisFun on YouTube I have been very pleasantly surprised at how much I am picking up that I did not previously know, or reading what I know in a new context. Very impressive course as is Unlocking VBA and Excel Macro's although with that one I was doing the excercises my way then seeing how Leila did it. We seldom did things the same way but it felt as though neither of us was wrong. I certainly think that the two courses together have really improved my existing skillset. Really nice job Leila, thankyou.

By Marco Ramos

Sim, atendendendo plenamente minhas expectativas!!
Curso excepcional!!

By Allan David E

There is nothing I can add to the acclamation that thousands have said about the instructor. Leila is very proficient in excel and she has a knack for teaching the concepts in a clear and understandable fashion to help guys like me (I'm a pretty average person) excel in using xls. The course has helped me get better in my profession since my job demands fluency in using excel formulas and analytical techniques. I have done Leila's Macro and VBA course (also excellent), but this one, in my opinion, is more useful in a professional environment due to the simplicity of formulas over macros and coding.