All Levels
16 hours
Java Tutorial for Complete Beginners
Learn to program using the Java programming language
John Purcell
What you'll learn:
- ✓Learn to program in Java
16 hours
73 lectures
Access on mobile and TV
Certificate
DevelopmentJava
All LevelsOffice ProductivityExcel Dashboard
Microsoft Excel Data Analysis and Dashboard Reporting
Build Dynamic, Interactive Microsoft Excel Dashboards (Excel 2010, 2013, 2016) with a Best Selling Excel Instructor
Created by Kyle Pew • 2,000,000+ Students, Office Newb
3.5 hours
Video Content
40
Lectures
58,476
Students
4.7
Rating
4.7
(58,476 students enrolled)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
Course Content
9 sections • 40 lectures • 03:36:44 total length
Getting Started
4 lectures • 12:19
Getting Started
4 lectures • 12:19
Welcome to the Course02:01
Dealing with Raw Data04:03
The Magic of an Excel Dashboard05:17
Let's get Started!00:58
Analyzing Data Effectively with Microsoft Excel
6 lectures • 28:25
Analyzing Data Effectively with Microsoft Excel
6 lectures • 28:25
DOWNLOAD THIS FILE FIRST01:14
Using Excels PROPER() Function on Text04:41
Create Consistency with Excels UPPER() Function02:54
Microsoft Excels Paste Special Feature03:52
Replace Meaningless Data with Excels CHOOSE() Function09:14
+1 more lectures
Building the Excel Dashboard - LOOK UP DATA - Part 1
6 lectures • 41:15
Building the Excel Dashboard - LOOK UP DATA - Part 1
6 lectures • 41:15
Looking Up Customer Info02:14
Preparing the Data Using Format As Table04:54
Creating a Drop Down Menu with Data Validation03:52
Looking Up Data with Excels VLOOKUP() Function07:55
Cleaning Up Data with Excels IF() Function07:15
+1 more lectures
Building the Excel Dashboard - FILTERING DATA - Part 2
6 lectures • 41:36
Building the Excel Dashboard - FILTERING DATA - Part 2
6 lectures • 41:36
Adding the Order History Table05:46
Formatting Orders as a Table04:19
Using Excels Advanced Filter Feature07:30
Record Macro for Advanced Filter09:11
Filter Order Records On Change of Customer (VBA)06:25
+1 more lectures
Building the Excel Dashboard - SUBTOTALS - Part 3
2 lectures • 13:40
Building the Excel Dashboard - SUBTOTALS - Part 3
2 lectures • 13:40
Why Use Excels SUBTOTAL() Function07:00
Implementing the SUBTOTAL() Function06:40
Building the Excel Dashboard - PivotTables and Pivot Charts - Part 4
9 lectures • 51:29
Building the Excel Dashboard - PivotTables and Pivot Charts - Part 4
9 lectures • 51:29
Why Use PivotTables06:43
Summarizing Order Info with PivotTables07:52
Prepare PivotTable for Customer Filter05:20
Creating the VBA Procedure03:54
Declaring VBA Variables04:27
+4 more lectures
Building the Excel Dashboard - Interactive Buttons - Part 5
2 lectures • 06:15
Building the Excel Dashboard - Interactive Buttons - Part 5
2 lectures • 06:15
Creating Interactive Charts with Slicers04:21
Modifying the Chart Slicer01:54
Building the Excel Dashboard - Final Touches - Part 6
4 lectures • 20:24
Building the Excel Dashboard - Final Touches - Part 6
4 lectures • 20:24
Hiding Extra Worksheets and Columns04:50
Cleaning Up the Excel Default Settings02:23
Hiding the Chart and Resetting the Slicer (VBA)07:53
Protecting the Dashboard05:18
Congratulations and Bonus!
1 lectures • 01:21
Congratulations and Bonus!
1 lectures • 01:21
Congratulations You Finished the Course01:21
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
This course includes:
- 3.5 hours on-demand video 0
- 6 downloadable resources
- Access on mobile and TV
- ∞Full lifetime access
- Certificate of completion
Instructors
Kyle Pew • 2,000,000+ Students
Office Newb
Students also download
Explore related courses to expand your learning journey.
All Levels
22 hours
The Complete Python Bootcamp From Zero to Hero in Python
Learn Python like a Professional Start from the basics and go all the way to creating your own applications and games
Jose Portilla
What you'll learn:
- ✓You will learn how to leverage the power of Python to solve tasks.
- ✓You will build games and programs that use Python libraries.
- ✓You will be able to use Python for your own work problems or personal projects.
- +9 more skills
22 hours
156 lectures
Access on mobile and TV
Certificate
DevelopmentPython
All Levels
52 hours
100 Days of Code: The Complete Python Pro Bootcamp
Master Python by building 100 projects in 100 days. Learn data science, automation, build websites, games and apps!
Dr. Angela Yu, Developer and Lead Instructor
What you'll learn:
- ✓You will master the Python programming language by building 100 unique projects over 100 days.
- ✓You will learn automation, game, app and web development, data science and machine learning all using Python.
- ✓You will be able to program in Python professionally
- +6 more skills
56.5 hours
592 lectures
Access on mobile and TV
Certificate
DevelopmentPython