What you'll learn:
- Create 7 Professional Interactive Microsoft Excel Dashboards from scratch
- Create over 10 Amazing Interactive Non-Standard Excel Charts in Microsoft Excel. BONUS: Excel Workbook files + Sample files included
- Improve general Excel knowledge - Pivot Tables and Pivot Charts, Conditional Formatting, Functions, Formulas and Macros
- Build Interactive Dashboard Reports with Buttons and Drop Down Menus
- Learn how to create a professional KPI dashboard from scratch
- Analyze Data with Excel PivotTables and Pivot Charts
- Understand and Identify the Principles of Data Analysis
- Analyze Excel data using Excel's based Functions
- Learn from an instructor with over 20 years of experience with Microsoft Excel, teaching thousands of students in his own computer learning school
- Quizzes and exercises
COMPLETELY UPDATED IN MARCH 2024 WITH OVER 40 BRAND-NEW VIDEOS!
Microsoft Excel dashboards are a powerful way to leverage Excel functionality, build and manage better presentations and improve your Excel and data visualization skills. In this course, I will use my 20+ years of Excel training to show you how to turn Excel into your personal Business Intelligence tool and create Interactive Charts and awesome Dashboards in Microsoft Excel.
Learn how to make six well-designed Dashboards from Scratch!
Content and Overview
Hi!
Welcome to the 2024 brand-new version of The Excel Dashboard and Data Analysis Course, Udemy's best-selling dashboards course.
This course was completely overhauled to prepare students for the 2024 job market, with over 17+ hours of brand-new content. This is the only course you need to learn excel dashboards and data analysis.
There are many options for online Excel training, but this course is undoubtedly the most comprehensive and practical on the market. Here's why:
This is the only Udemy course taught by a professional Bootcamp instructor-teacher with over 20 years of experience in Excel and a track record of success.
I just spent four months redoing this behemoth of a course! Everything I cover is up-to-date and relevant to 2024's Excel data analysis job market. This course does not cut any corners.
We build 7 projects and seven complete dashboards. No other course walks you through creating a dashboard with such details.
The course is constantly updated with new content, projects, and modules. Think of it as a subscription to a never-ending supply of developer training.
Throughout the brand new version of the course, we cover tons of Excel tools:
We'll start by covering the critical Design principles of dashboards, the creation process, color tips, and layouts.
Then I'll walk you through all the methods of importing data into Excel.
After that, I'll explain over 25 functions and formulas we use in dashboards.
Then we'll dive into basic charts, advanced charting techniques, and dashboard components, like sparklines, data bars, color scales, icon sets, etc.
Once we've mastered the basics, I'll walk you through all the advanced dashboards components, like drop-down lists, filters, panel charts, rollover method, etc.
Also, I'll walk you through over ten interactive advanced charts, like bullet graphs, small multiples, and infographics.
After that, I'll explain all the form controls with a demo and detailed examples.
The following section is about data analysis using pivot tables and charts.
Once you complete a few sections, you will enter the first significant milestone project. We combine all the methods you learned to create a social media dashboard.
Finally, you're going to create with me four dashboards from scratch, starting with planning and setup.
• Business sales dashboard
• Financial KPI Dashboard
• Balanced Scorecard dashboard
• Pivot Slicer Dashboard
• Traffic lights Dashboard
• KPI Dashboard
All these come with templates and samples that can be applied directly to your business.
After that, you will enter the second major milestone project and create an auto part sales dashboard with me.
I also cover protecting and sharing your dashboard with the outside world.
Also, you'll learn advanced topics, like how with the aid of a macro and straightforward VBA code, little touches will help make the perusal of your dashboard a bit more pleasant.
Once you complete every section, you'll have quizzes and exercises to solve and fully understand the theory.
If you want to study offline, I have over 100 pages of documentation, and a detailed table of contents, so you can easily find anything in the course.
You will get access to over 50 examples and files that apply to your work. You can immediately download and use them with the code-free version so that you can follow along with me.
This course is also unique in the way that it is structured and presented. I've incorporated everything I learned in my years of teaching to make this course more effective and engaging.
If you have any questions, please don't hesitate to contact me. I got into this industry because I love working with people and helping students learn.
Enroll now and enjoy the course!
So, if you are a professional looking to become more efficient at building Excel reports and dashboards, sign up today for immediate lifetime access to over 17 hours of high-quality video content, downloadable project files, quizzes, homework exercises, and one on one support.
And by the way, at the end of the course don't forget to print out the certificate of completion.
If you're not 100% satisfied, there is a 30-day money-back guarantee!
Now, don't just take my word for it. Check out what my past students had to say about my courses:
Testimonials for this Course
"I learned so many new Excel tricks from this course. It covers almost everything. Andreas impressed me by updating his course so often! It is worth every cent. Great job!" - Chris K
"Outstanding course! Very thorough and easy to understand. Sample spreadsheets make it very simple to follow along and provide hands-on work. I would highly recommend this course." - Kelli Kellen.
"I strongly recommend the course for all types of Excel users. The lecturer follows a systematic and inspiring approach to present the most important techniques for data visualization with Excel." - Tommy Kalman.
*** learning is more effective when it is an active rather than a passive process ***
Euripides Ancient Greek dramatist
