Microsoft Excel Data Analysis and Dashboard Reporting

4.0 /5

(1 Rating)

Offered byUDEMY

Microsoft Excel Data Analysis and Dashboard Reporting
at
UDEMY
Overview

Build Dynamic, Interactive Microsoft Excel Dashboards with a Best Selling Excel Instructor

Duration	4 hours
Total fee	₹649
Mode of learning	Online
Credential	Certificate

Microsoft Excel Data Analysis and Dashboard Reporting
at
UDEMY
Highlights

Earn a Certificate of completion from Udemy
Learn from 6 downloadable resources
Get full lifetime access of the course material
Comes with 30 days money back guarantee

Microsoft Excel Data Analysis and Dashboard Reporting
at
UDEMY
Course details

Skills you will learn

Excel Macros Vlookup Data analysis

Who should do this course?

For Experienced Microsoft Excel users

What are the course deliverables?

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

More about this course

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 skills you learn will help streamline your efforts in managing and presenting Microsoft Excel data

Microsoft Excel Data Analysis and Dashboard Reporting
at
UDEMY
Curriculum

Getting Started

Welcome to the course

Dealing with Raw Data

The Magic of an Excel Dashboard

Let's get Started!

Analyzing Data effectively with Microsoft Excel

Using Excels PROPER() Function on Text

Create Consistency with Excels UPPER() Function

Microsoft Excels Paste Special Feature

Replace Meaningless Data with Excels CHOOSE() Function

Extract Date Values Using Excels TEXT() Function

Building the Excel Dashboard - LOOK UP DATA - Part 1

Looking Up Customer Info

Preparing the Data Using Format As Table

Creating a Drop Down Menu with Data Validation

Looking Up Data with Excels VLOOKUP() Function

Cleaning Up Data with Excels IF() Function

INDEX() and MATCH() an Alternative to VLOOKUP()

Building the Excel Dashboard - Filtering Data - Part 2

Adding the Order History Table

Formatting Orders as a Table

Using Excels Advanced Filter Feature

Record Macro for Advanced Filter

Filter Order Records On Change of Customer (VBA)

Modify the VBA Filter Code

Building the Excel Dashboard - Subtotals - Part 3

Why Use Excels SUBTOTAL() Function

Implementing the SUBTOTAL() Function

Building the Excel Dashboard - PivotTables and Pivot Charts

Why Use PivotTables

Summarizing Order Info with PivotTables

Prepare PivotTable for Customer Filter

Creating the VBA Procedure

Declaring VBA Variables

Assigning Values to VBA Variables

Connecting the Filter to the PivotTable

Update Pivot Chart Based on Customer Selected (VBA)

Customers with No Orders Error

Microsoft Excel Data Analysis and Dashboard Reporting
at
UDEMY
Faculty details

Kyle Pew

Kyle is a Microsoft Certified Trainer (MCT) and a certified Microsoft Office Master Instructor and has been teaching and consulting for the past 20+ years on various computer applications, including; Microsoft Office Suite 1997, 2000, XP, 2003, 2007, 2010, 2013 Excel, Word, PowerPoint, Outlook, Access and Visio.