🚨 Time is Running Out: Reserve Your Spot in the Lucky Draw & Claim Rewards! START NOW
watching now
4 Students

Description

What Will You Learn?

  • How to create dashboard layout
  • How to add and format text boxes in the dashboard
  • How to insert formulas in the text boxes to extract data from the data source
  • How to add and format charts in the dashboard
  • How to create drop-down lists in the dashboard

Requirements

  • Microsoft Excel
  • NFT Certificate
  • 71 Lessons
  • Beginner
  • English
  • 4.3 Rating
  • +100 XP

Share Course on Social media

Curriculum

Course consist of total 8h 29min of content, in total.

Section 1: Dashboard Layout Design 1:Create Sales Dashboard
1:02:14
Creating Dashboard Layout
07:41
Creating Drop Down List and Linking Index and Match Functions with it
09:38
Adding and Formatting Donut Charts in the Dashboard
09:55
Adding and Formatting Text Boxes and Extracting Revenue and Quantity Ordered Values
11:44
Creating and Formatting Column and Line Charts in the Dashboard
07:26
Section 2: Dashboard Layout Design 2:Create Financial Dashboard
1:55:39
Introduction to Financial Dashboard
01:17
Creating Layout of Dashboard Part 1
05:24
Creating Layout of Dashboard Part 2
05:35
Calculating Financial Data
03:53
Connecting Drop Down List to the IF Function
09:54
Calculating Variation Values Between Months by Using IF Function
05:15
Adding Text Box and Inserting Formulas Inside
09:57
Applying Conditionally Formatting Rules on Variation Values
05:22
Using Camera Commands in Dashboard
07:43
Creating Donut Charts
09:42
Adding Donut Charts and Inserting Text Boxes Inside
11:26
Inserting Text Boxes Inside the Donut Charts
08:19
Creating Income Statement in the Dashboard
08:41
Adding Column and Line Charts in the Dashboard
10:45
Creating Drop Down List in the Dashboard
06:58
Removing Errors From Formulas
05:28
Section 3: Dashboard Layout Design 3:Create Sales Performance Dashboard
1:07:13
Introduction to Sales Performance Dashboard
01:36
Creating Pivot Tables and Progress Chart Part 1
05:18
Creating Pivot Tables and Progress Chart Part 2
09:23
Creating Layout of Dashboard
08:19
Inserting Text and Formulas Inside the Text Boxes
08:55
Inserting Icons inside the Dashboard Layout
08:02
Adding Progress Chart and Slicers in the Dashboard
08:18
Adding Column, Line and Pie Charts Inside the Dashboard
10:08
Removing Formula Errors from the Text Boxes
07:14
Section 4: Dashboard Layout Design 4:Create Sales Dashboard
51:30
Introduction to Sales Dashboard
01:01
Creating Dashboard Layout
05:26
Adding Icons in the Dashboard Layout and Creating Line Chart
06:51
Creating Column and Bar Charts
07:53
Creating Map Chart
05:24
Inserting Formulas Inside the Text Boxes Part 1
07:31
Inserting Formulas Inside the Text Boxes Part 2
02:59
Adding Slicers in the Dashboard
03:54
Grouping the Layers and Removing Errors From Formulas
10:31
Section 5: Dashboard Layout Design 5:Create Sales Dashboard
1:23:47
Introduction to Sales Dashboard
01:50
Loading Data in the Pivot Table and Creating Validation List
04:20
Inserting Index and Match Functions in the Data Validation List (Drop Down List)
05:55
Calculating Percentage Sales Values
01:48
Creating Layout of Dashboard
12:16
Adding and Formatting Donuts Charts in the Dashboard
10:37
Adding Text Box and Inserting Formulas inside
15:05
Linking Another Pivot Table to the Drop Down List
12:22
Adding and Formatting Line and Column Charts
13:17
Linking Drop Down List from Dashboard to the Data Source
06:17
Section 6: Dashboard Layout Design 6:Create Sales Dashboard
2:08:53
Creating Dashboard Layout
10:43
Adding Shapes and Text Boxes in Each Widgets of Dashboard
04:36
Adding Icons in Each Widgets of Dashboard
02:03
Adding and Formatting Line Chart in the Dashboard
05:52
Overlap Two Line Charts in the Dashboard
05:21
Adding and Formatting Map Chart in the Dashboard
04:37
Adding and Formatting Waterfall Chart in the Dashboard
05:13
Adding and Formatting Donut Charts in the Dashboard
06:01
Adding Text Boxes Inside the Donut Charts and Extracting Numerical Values Inside
13:51
Adding and Formatting Bar Chart in the Dashboard
06:26
Creating Custom Slicers Style in the Dashboard
11:39
Creating Collapse and Toggle Buttons in the Dashboard Part 1
10:53
Creating Collapse and Toggle Buttons in the Dashboard Part 2
09:56
Creating Collapse and Toggle Buttons in the Dashboard Part 3
07:50
Creating Collapse and Toggle Buttons in the Dashboard Part 4
09:31
Creating Collapse and Toggle Buttons in the Dashboard Part 5
07:50
Removing Reference Errors from the Formulas
05:02

About the Instructor

I have completed master degree in science (applied physics) but now I am teaching Microsoft Excel and Microsoft Power BI online and hundreds of students have enrolled in my courses. I love teaching online as well as I am teaching data analysis and data visualization.

See All Instructor Courses

BitDegree platform reviews