Excel Dashboard and Data Analysis Masterclass
What you'll learn
- Create 6 Professional Interactive Excel Dashboards from scratch
- Create over 10 Amazing Interactive Non-Standard 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
- Analyze Data with Excel PivotTables and Pivot Charts
- Learn how to create a professional KPI dashboard from scratch
- Build Interactive Dashboard Reports with Buttons and Drop Down Menus
- Learn from an instructor with over 20 years of experience with Microsoft Excel, teaching thousands of students in his own computer learning school
- Understand and Identify the Principles of Data Analysis
- Analyze Excel data using Excel's based Functions
- Quizzes and exercises
- This course was recorded with Excel 2019, Excel 2016 and Excel 2013 but it's compatible also with Excel 2007 and 2010
- It is also compatible with Microsoft Office for Mac
- Only basic prior experience in Excel or spreadsheets is required to get the most out of this Excel course
COMPLETELY REDONE IN NOV 2022 WITH OVER 20 BRAND-NEW VIDEOS!
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
Welcome to the 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 2022 job market, with over 13+ 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 2021's excel data analysis job market. This course does not cut any corners.
We build 6 projects and six 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 20 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.
• A business sales dashboard
• A KPI dashboard
• A Pivot Slicer Dashboard
• A Traffic lights 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 you will 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 simple 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 10 hours of high-quality video content, downloadable project files, quizzes and 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
Who this course is for:
- Everyone who wants to master Excel Dashboards
- Business Professionals
- Students with a willingness for learning
Hi, I am Andreas and I'm a Best Selling Teacher. I really love learning and teaching whenever I can.
I have a Master's Degree in Computer Science and a Degree in Electronic Engineering.
I have over 20 years of experience in teaching as an instructor, especially in Microsoft Excel. I have my own computer learning school, called Futurekids, from 2001 to now. I am the founder of Mellon Training, an online video tutorials learning school.
I always wanted to create my own business. Being your own boss is an incredibly liberating experience but difficult as well.
I have a passion for software products that make people's lives easier. I teach Python Programming, Microsoft Excel and all Microsoft software products for over 20 years. I am a professional Forex Trader for over 5 years.
I love to create websites and optimize them with Search Engine Optimization techniques. I created my online e-shop, called Bite me not jewels, with my wife.
I live in Rodos, a beautiful Greek island. When I am not working, I love being with my family, my two kids and my lovely dog. Travel, forex trading, and reading books are my favorite hobbies.