Course Content
Course Introduction
0/5
Intro
02:07
Setting expectation
00:42
Data Visualization Concepts
00:34
Using Exercise Files
00:39
Office Version
00:35
01-Data visualization best practices
0/9
01-Introduction
02:29
02-Data visualization 101
02:31
03-The 10 second rule
01:54
04-3 Keys questions
04:27
05-Essential visuals
06:26
06-Chart formatting tips
02:29
07-Story telling with data
01:46
08-Common error
05:15
09-Best practice in data visualization
02:10
02-US music
0/5
Chapter Intro
00:47
Download the Exercise files
01-Creating the chart in excel
05:46
02-Applying chart format
05:47
03-Telling the story
08:08
03-Dashboard design principles
0/7
01-Introduction
01:39
02-DashBoard 101
01:07
03-Types of Dashboard
02:31
04-Defining a purpose
02:12
05-Visual elements
03:48
06-Adding context
03:06
07-Dashboard layouts
03:06
04-Careers
0/18
Chapter Intro
02:01
Download the Exercise files
01-Preparing the filters
05:38
02-Using Average ifs for conditional calculations
04:33
03-Creating bar chart
02:38
04-Sorting based on formulas
02:39
05-Creating donut chart
02:27
06-Grouping donut slices
04:56
07-Creating a combo chart
08:13
08-Splitting combo chart elements
08:48
09-Creating a filled map
04:11
10-Adding new data with data types
03:10
11-Switching between series in map
08:19
12-Setting up the dashboard layout
15:49
13-Using color strategically
05:54
14-Dynamically highlighting series
05:20
15-Inserting Form control
10:24
16-Protecting the dashboard
02:58
05-Toys Factory
0/18
Chapter Intro
01:54
Download the Exercise files
01-Data Preparing
08:48
02-Using name range
02:04
03-Calculating KPIs
07:04
04-Applying conditional formatting rules
03:04
05-Inserting linked pictures
01:19
06-Using absolute structured
03:55
07-Creating a line chart
04:53
08-Hiding zero Values in a line chart
02:17
09-Creating Bar Chart
08:41
10-Dynamically sorting data
09:20
11-Creating top Bottom tables
07:57
12-setting up the dashboard layout
16:25
13-Coloring dashboard
12:10
14-Using the titles to tell a story
05:04
15-Sharing the dashboard online
03:17
16-Formulas based formatting
05:14
06-Sales Dashboard
0/11
Chapter intro
00:27
Download the Exercise files
01-Dashboard layout
03:39
02-Preparing cards
03:40
03-Prepating tables
05:14
04-Preparing charts
09:32
05-Dynamic chart title
01:20
06-Dashboard preparation
05:49
07-Tables Creating
06:24
08-Charts setup
02:42
09-Finanlize dashboard
06:50
Conclusion
0/1
Good bye
00:33
Excel Dashboard Bootcamp: Build Interactive Reports
Previous
Next
0% Complete
Kindly provide your credentials to gain access to your account.

Google reCaptcha: Invalid site key.

Forget your password? Lost password

Don’t have account? Register