Download Udemy – Microsoft Excel Dashboard and Data Analysis Masterclass

Description

Microsoft Excel Dashboard and Data Analysis Masterclass is a free course on Excel dashboards and data analysis published by Udemy Academy. Microsoft Excel dashboards are a powerful way to leverage Excel’s functionality, build and manage better presentations, and improve your Excel and data visualization skills. In this course, I’ll use my 20+ years of Excel training to show you how to turn Excel into your personal business intelligence tool and create great interactive charts and dashboards in Microsoft Excel. We’ll start by covering the essential dashboard design principles, the creation process, color tips, and layout. Then I’ll walk you through all the ways to import data into Excel. After that, I’ll explain over 25 functions and formulas that 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, and more. After you master the basics, I will introduce you to all the advanced dashboard components like dropdown lists, filters, panel charts, navigation, etc. I will also guide you through more than ten advanced interactive charts, such as bullet charts, pie charts, and infographics. After that, I will explain all the form controls with a demo and detailed examples. The following section is about analyzing data using tables and pivot charts. After completing a few sections, you will enter your first major milestone project. We will combine all the methods you learned to create a social media dashboard. Finally, I will start with four dashboards from scratch, planning and setting them up.

What you will 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 pivot tables and pivot charts
• Understand and identify the principles of data analysis
• Analyze Excel data using Excel-based functions
• Learn from an instructor with over 20 years of experience with Microsoft Excel and has taught thousands of students at his own computer learning school.
• Tests and exercises

Who is this course suitable for?

• Everyone who wants to master Excel dashboards
• Business professionals
• Students
• Entrepreneurs
• Students who are eager to learn

Microsoft Excel Dashboard and Data Analysis Masterclass Course Details

• Publisher: Udemy
• Instructor: Andreas Exadaktylos
• Language: English
• Education level: All levels
• Number of lessons: 181
• Training duration: 19 hours and 53 minutes

Course chapters

Course prerequisites

• 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

Pictures

Sample video

Installation Guide

After Extract, view with your favorite player.

Subtitles: English

Quality: 720p

The 2025/5 version has increased by 7 hours and 41 minutes compared to 2021/1.

Download link