Excel Dashboard And Data Analysis Masterclass
Excel Dashboard And Data Analysis Masterclass
Last updated 3/2023
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 8.60 GB | Duration: 15h 27m
[center]Create 6 Interactive Microsoft Excel Dashboards from Scratch (Excel Dashboard Templates Included) - 2022 Updated!
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
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
Requirements
This course was recorded with Excel 365, Excel 2019 and Excel 2016 but it's compatible also with Excel 2007, 2010 and 2013
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
Description
COMPLETELY REDONE IN FEB 2023 WITH OVER 30 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 OverviewHi!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.• Business sales dashboard• Financial KPI Dashboard• Balanced Scorecard dashboard• Pivot Slicer Dashboard• Traffic lights Dashboard• KPI DashboardAll 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