Excel Data Analysis Dashboards

  1. Home
  2. Excel-analytics
  3. Excel Data Analysis Dashboards

Tags: Excel Analytics

Master Advanced MS Excel topics - Excel Formulas, Excel Formatting, Excel Pivot Tables, Excel Dashboards & Analytics

Last updated 2022-01-10 | 4.5

- Learn about basic formatting in excel.
- Learn about sorting and filtering functions in excel.
- Learn about UPPER
- LOWER
- PROPER
- LEFT
- RIGHT
- SEARCH
- CONCATENATE functions in excel.

What you'll learn

Learn about basic formatting in excel.
Learn about sorting and filtering functions in excel.
Learn about UPPER
LOWER
PROPER
LEFT
RIGHT
SEARCH
CONCATENATE functions in excel.
Learn how to find outliers and missing values in Excel.
Learn how to find standard deviation and percentiles in data using Excel.
Learn about IF
IF ERROR
COUNTIF
SUMIF and AVERAGEIF functions in excel.
Learn about using Color Bars and Color scales in excel.
Learn applying VLOOKUP and HLOOKUP functions and merge datasets using them in excel.
Learn how to merge datasets using Index and match.
Learn making Pivot Tables and Pivot charts in excel.
Learn making interactive dashboards in excel.
Learn about What-if analysis in excel.
Learn how to perform linear regression in excel.
Quizzes and exercises.
Turn real world data into business insights in Excel.
Best Practices for dashboard development
table and graph design.
Discover the most Powerful tool in Excel to transform your Data into Insight and intelligence.

* Requirements

* No prior knowledge required.
* Determination and Desire to learn new things.
* A positive attitude to success.
* A willingness to learn and practice.

Description

  • Learn about basic formatting in excel.
  • Learn about sorting and filtering functions in excel.
  • Learn about UPPER, LOWER, PROPER, LEFT, RIGHT, SEARCH, CONCATENATE functions in excel.
  • Learn how to find outliers and missing values in Excel.
  • Learn how to find standard deviation and percentiles in data using Excel.
  • Learn about IF, IF ERROR, COUNTIF, SUMIF and AVERAGEIF functions in excel.
  • Learn about using Color Bars and Color scales in excel.
  • Learn applying VLOOKUP and HLOOKUP functions and merge datasets using them in excel.
  • Learn how to merge datasets using Index and match.
  • Learn making Pivot Tables and Pivot charts in excel.
  • Learn making interactive dashboards in excel.
  • Learn about What-if analysis in excel.
  • Learn how to perform linear regression in excel.
  • Quizzes and exercises.
  • Turn real world data into business insights in Excel.
  • Best Practices for dashboard development, table and graph design.
  • Discover the most Powerful tool in Excel to transform your Data into Insight and intelligence.

Course content

14 sections • 88 lectures

Excel Basics 7 lectures

How is Excel important to businesses Preview 02:34

Understanding the excel interface Preview 02:21

Basic Formatting in Excel Preview 02:08

Insertion and Deletion in Excel Preview 02:07

Data Types in Excel Preview 06:15

Quiz on Excel Basics

Quiz Solution Preview 03:01

Sort and Filter 7 lectures

Applying the sort function Preview 02:09

Applying the filter function Preview 01:38

Applying the advanced filter function Preview 02:48

Quiz on Sort and Filter

Quiz Solution Preview 03:04

Exercise on Filters Preview 02:26

Solution on Filters Preview 04:10

Text functions 7 lectures

Using the UPPER, LOWER and PROPER functions Preview 03:16

Using the LEFT, RIGHT and SEARCH functions Preview 03:20

Using the TRIM, CONCAT and LEN functions Preview 02:46

Quiz on Text functions

Quiz Solution Preview 04:37

Exercise on Text Functions Preview 03:27

Solution on Text Functions Preview 06:18

Statistical functions 11 lectures

Using the MIN, MAX AVERAGE functions Preview 02:13

Finding the Standard deviations Preview 03:03

Find the percentiles of data Preview 02:58

Finding the Outliers present in data Preview 03:38

Finding the Missing values in data Preview 01:49

Quiz on Statistical functions

Quiz Solution Preview 04:32

Exercise on Descriptive Statistics Preview 03:08

Solution on Descriptive Statistics Preview 04:53

Exercise on Data Cleaning Preview 02:44

Solution on Data Cleaning Preview 07:19

Logical Functions 9 lectures

Using the IF function Preview 01:38

Using the IF ERROR function Preview 02:12

Applying the COUNTIF function Preview 02:10

Applying the SUMIF function Preview 01:55

Applying the AVERAGEIF function Preview 01:56

Quiz on Logical functions

Quiz Solution Preview 03:29

Exercise on Logical Functions Preview 03:36

Solution on Logical Functions Preview 07:21

Conditional Formatting 6 lectures

Using Colorbars for formatting Preview 01:47

Using Colorscales for formatting Preview 01:39

Quiz on Conditional Formatting

Quiz Solution Preview 03:59

Exercise on Conditional Formatting Preview 03:03

Solution on Conditional Formatting Preview 04:29

Lookup Functions 6 lectures

Applying VLOOKUP function Preview 03:32

Applying HLOOKUP function Preview 02:03

Quiz on Lookup Functions

Quiz Solution Preview 03:10

Exercise on Lookup Functions Preview 02:07

Solution on Lookup Functions Preview 04:55

Index and Match 6 lectures

Why to use Index and Match? Preview 02:29

Applying Index and Match Preview 02:37

Quiz on Index and Match

Quiz Solution Preview 03:10

Exercise on Index and Match Functions Preview 02:54

Solution on Index and Match Functions Preview 06:59

Pivot Tables 6 lectures

Making Pivot Tables Preview 03:40

Making Pivot Charts Preview 01:58

Quiz on Pivot Tables

Quiz Solution Preview 03:02

Exercise on Pivot Tables Preview 02:56

Solution on Pivot Tables Preview 04:07

Dashboards 11 lectures

Basics of Data Visualizations Preview 02:09

Making Charts in Excel Preview 03:44

Making Dashboards Preview 02:31

Adding Slicers in Dashbaords Preview 02:33

Formatting dashboards Preview 01:55

Quiz on Dashboards

Quiz Solution Preview 02:51

Exercise on Data Visualizations Preview 02:50

Solution on Data Visualizations Preview 03:55

Exercise on Dashboards Preview 01:54

Solution on Dashboards Preview 05:50

What If Analysis 5 lectures

Goal Seek Analysis Preview 02:54

Data Tables Preview 02:45

Scenario Management Preview 03:17

Quiz on What If Analysis

Quiz Solution Preview 04:00

Regression 4 lectures

Understanding Regression Preview 01:58

Performing Linear Regression Preview 02:19

Quiz on Regression

Quiz Solution Preview 04:58

Outro Section 2 lectures

Conclusion Preview 02:11

How to Get Your Certificate of Completion Preview 00:16

Bonus Section 1 lectures

Bonus Lecture Preview 01:00