Make Excel Your Data Visualization Powerhouse:
Learn to Design 6 Interactive Professional Excel Dashboards from Scratch (Excel Dashboard Templates Included) - 2024 Updated!
In my course, you will be able to create Excel dashboards that are not only visually appealing but also data-driven and actionable.
In this course I will teach you the simple techniques you can apply in Excel to make killer dashboards that will set your skill level apart from the crowd. Furthermore, the course covers:
The basics of data preparation and analysis
How to choose the right chart type for your Dashboard
Create 6 Interactive Dashboards from Scratch! (Project files included!)
“It was the BEST! I was a little bit worried at first since I wasn't a complete beginner when I started but I learned a bunch of new stuff with even the first lessons”
“It is great to have your own time to learn what you want to learn at your own pace, it also allows you to go back if some topic you are still not familiar. Great!”
“I have never imagined before that Excel may be so useful; practical & usable for so many things”
“Get knowledge from basic to advance level in excel and the course explanation with examples and templates are awesome. Thank You!”
“Loved it, Learned so much from this course in-depth!”
Welcome to the Course!
FREE PREVIEWDownload Project Files
What is a dashboard?
FREE PREVIEW❓QUIZ 1: Introduction
Design Principles & Tips
FREE PREVIEWDashboard Creation Process
FREE PREVIEWColor Tips & Layouts
Building an Effective Data Model
❓QUIZ 2: Understanding the Dashboard Design Principles
Introduction
FREE PREVIEWCreate A Dates Table
Dates Method
FREE PREVIEWCreating Number Patterns
Summing Data Through Shortcuts
Create A Chart Through Shortcuts Keys
Isolate Any Part Of A Chart & Chart Templates
Manipulate Filter Data And Paste Special
Icon Sets With Words
Camera Tool
Pivot Tables Creation Shortcuts
The Advanced Filter
FREE PREVIEWTables and Charts
Keyboard Shortcuts & Ninja Tips
❓QUIZ 3: Using Shortcuts for Speed and Accuracy
Introducing Excel Charts
FREE PREVIEWIntroducing Charting Techniques
Advanced Chart Formatting Options
Advanced Charting Techniques
Trend-based Conditional Formats
Value-based Conditional Formats
❓QUIZ 4: Practicing Charting Techniques
Introduction
Relative and Absolute reference
Range Names in Formulas
VLOOKUP Function
INDEX and MATCH Functions
OFFSET Function
SUMIFs Function
SUMPRODUCT Function
SMALL and LARGE Functions (& INDEX-MATCH Example)
IF and NESTED IF Formulas
INT and MOD Functions
Text Functions: LEFT, RIGHT, MID, LEN, TEXT, TRIM, LOWER, UPPER, PROPER, REPT
Advanced Custom Number Formatting
CHOOSE Function
ROUND, ROUNDUP and ROUNDDOWN
❓QUIZ 5: Functions
Introduction
Importing External Data from Text File
Importing Data from Excel Spreadsheet
Importing Data from Microsoft Access
Loading Data with Power Query (Get & Transform)
Useful Sources of Data
❓QUIZ 6: Dashboard Source Data
This course will get your skills up to date by teaching you how to create Dashboards that will wow your boss (or your prospective employer)
You’ll take this course in your own time. It is a completely self-paced online course – so you decide when you start and when you finish.
You can use your credit card, Paypal account (if you have one)
If you aren't happy with the course within the first 30 days, just contact us for a full refund. All we ask is that you really give the course a good go. Watch the videos, go through the workbooks, ask us questions. If you honestly feel it wasn't worth it, just get in touch.
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like – across any and all devices you own.
Yes! Most online courses leave you on your own, but not here at Mellon Training! We have a team of helpful teaching assistants ready to answer your questions about each lesson. Below each lesson, you’ll find a comment section where you can ask a question about the topic. Our TA’s will chime in and do their best to help you.
We get it, there are lots of great options to choose from. We’ve got Excel, Power BI, Finance, Python & Gmail courses
Excel Financial Modelling from scratch: Financial Statements, Project Costing, Discounted Cash Flow (DCF), Accounting
$39
Become a proficient Excel Macros and Excel VBA Programmer in a very short time. Excel 2019 Macros & VBA Examples included.
$29
Master Microsoft Power BI Desktop, Create Interactive Dashboards & Learn Advanced Analytics with DAX and Power Query
$29
Master 20+ Advanced Dynamic Excel Charts & Create Impressive Excel Graphs, Infographics & Data Visualization
$19
Master Excel with 100+ Excel Tips & Hacks, from an Excel Best Seller Instructor. Excel Project Files included.
$19
Boost your Productivity with 25+ Gmail Techniques like Gmail Filters , Security , IFTTT . Master Email Communication
$9
A Python 3 Practical Programming Course for Absolute Beginners - Learn how to Code in Python 3.9 (2022 Edition)
$19