Microsoft Excel Data Analysis and Dashboard Reporting
33,553 students enrolled
Microsoft Excel Data Analysis and Dashboard Reporting
Build Dynamic, Interactive Microsoft Excel Dashboards (Excel 2010, 2013, 2016) with a Best Selling Excel Instructor
Bestseller
33,553 students enrolled
Created by
Kyle Pew
Last updated 4/2018
English
English [Auto],
Indonesian [Auto],
4 more
- Italian [Auto]
- Polish [Auto]
- Romanian [Auto]
- Thai [Auto]
Current price: $69.99
Original price: $99.99
Discount:
30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
- 3.5 hours on-demand video
- 6 downloadable resources
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
Training 5 or more people?
Get your team access to 4,000+ top Udemy courses anytime, anywhere.
Try Udemy for Business
What you'll learn
- Understand and Identify the principles of data analysis
- Effectively summarize and present data clearly
- Use effective design principles when creating and presenting data
- Take full advantage of the built in tools Microsoft Excel offers in order to analyze and build dashboard reports
- Build interactive dashboard reports
- Analyze Excel data using Excels TEXT based Functions
- Data Mine using Excels Array Functions
- Build Interactive Dashboard Reports with Buttons and Drop Down Menus
- Streamline and Analyze Data with Excel PivotTables and Pivot Charts
Requirements
- Experience working with Microsoft Excel on a Windows system
- Videos were recorded using Excel 2016, but concepts and features will also work with Excel 2010, Excel 2013
Description
Microsoft Excel is one of the most powerful and popular data analysis desktop application on the market today. By participating in this Microsoft Excel Data Analysis and Dashboard Reporting course you'll gain the widely sought after skills necessary to effectively analyze large sets of data. Once the data has been analyzed, clean and prepared for presentation, you will learn how to present the data in an interactive dashboard report.
The Excel Analysis and Dashboard Reporting course covers some of the most popular data analysis Excel functions and Dashboard tools, including;
- VLOOKUP() Function for Looking up Information
- INDEX()/MATCH() Functions a Powerful Alternative to VLOOKUP
- TEXT() Function for Formatting
- CHOOSE() for Ultimate Flexibility in Presenting Data
- Advanced Filtering
- Summarizing Data with PivotTables and Pivot Charts
- Interactive Features to Create User Friendly Reports
- VBA Magic to Create Dynamic Content
- and more...
What's Included in the Course:
- 30+ Video Lectures to Follow Along and Practice the Concepts of Excel Data Analysis and Dashboard Reporting
- Downloadable Exercise Files
- Instructor Support through the QA Section Found within the Course - Ask Your Questions!
- Build a Real World Excel Dashboard
- 30 Day Money Back Guarantee
Join me in this course and take your Microsoft Excel skills to new heights. The skills you learn will help streamline your efforts in managing and presenting Microsoft Excel data.
See you in the course!
Who this course is for:
- Experienced Microsoft Excel users who are looking to efficiently analyze large data sets and create dynamic dashboard reports
Featured review
Alessandra Coppo
(
4 courses,
4 reviews
)
9 months ago
Before starting this course I always felt my Excel knowledge was never good enough.
Thanks to the skills I acquired by taking this course I feel more confident and interested in learning even more functions. Hence, I fully recommend this course to all of those who don't have much confidence in their Excel-skills and need a slow step-by-step guide, that will gently guide them to a better understanding.
Course content
Expand all
40 lectures
03:36:44
+
–
Getting Started
4 lectures
12:19
+
–
Analyzing Data Effectively with Microsoft Excel
6 lectures
28:25
DOWNLOAD THIS FILE FIRST
01:14
Microsoft Excels Paste Special Feature
03:52
Replace Meaningless Data with Excels CHOOSE() Function
09:14
Extract Date Values Using Excels TEXT() Function
06:30
+
–
Building the Excel Dashboard - LOOK UP DATA - Part 1
6 lectures
41:15
Looking Up Customer Info
02:14
Preparing the Data Using Format As Table
04:54
Creating a Drop Down Menu with Data Validation
03:52
Looking Up Data with Excels VLOOKUP() Function
07:55
Cleaning Up Data with Excels IF() Function
07:15
INDEX() and MATCH() an Alternative to VLOOKUP()
15:05
+
–
Building the Excel Dashboard - FILTERING DATA - Part 2
6 lectures
41:36
Adding the Order History Table
05:46
Formatting Orders as a Table
04:19
Using Excels Advanced Filter Feature
07:30
Record Macro for Advanced Filter
09:11
Filter Order Records On Change of Customer (VBA)
06:25
Modify the VBA Filter Code
08:25
+
–
Building the Excel Dashboard - SUBTOTALS - Part 3
2 lectures
13:40
Why Use Excels SUBTOTAL() Function
07:00
Implementing the SUBTOTAL() Function
06:40
+
–
Building the Excel Dashboard - PivotTables and Pivot Charts - Part 4
9 lectures
51:29
Why Use PivotTables
06:43
Summarizing Order Info with PivotTables
07:52
Prepare PivotTable for Customer Filter
05:20
Creating the VBA Procedure
03:54
Declaring VBA Variables
04:27
Assigning Values to VBA Variables
07:27
Connecting the Filter to the PivotTable
05:08
Update Pivot Chart Based on Customer Selected (VBA)
04:41
Customers with No Orders Error
05:57
+
–
Building the Excel Dashboard - Interactive Buttons - Part 5
2 lectures
06:15
Creating Interactive Charts with Slicers
04:21
Modifying the Chart Slicer
01:54
+
–
Building the Excel Dashboard - Final Touches - Part 6
4 lectures
20:24
Hiding Extra Worksheets and Columns
04:50
Cleaning Up the Excel Default Settings
02:23
Hiding the Chart and Resetting the Slicer (VBA)
07:53
Protecting the Dashboard
05:18
+
–
Congratulations and Bonus!
1 lecture
01:21
Congratulations You Finished the Course
01:21