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

Description

What Will You Learn?

  • How to create the dashboard layout
  • How to add and format text boxes in the dashboard
  • How to insert formulas in the text boxes to extract numerical values
  • How to create drop-down lists in the dashboard
  • How to add key performance indicators in the dashboard

Requirements

  • Microsoft Excel
  • NFT Certificate
  • 23 Lessons
  • Beginner
  • English
  • +100 XP

Share Course on Social media

Curriculum

Course consist of total 2h 54min of content, in total.

Section 1: Dashboard Layout Design 1:KPIs Financial Dashboard
2:18:07
Creating Dashboard Layout
12:21
Calculating Financial Data
04:42
Creating and Linking Drop Down List to the Data Source
09:35
Applying Conditionally Formatting Rules
07:47
Extracting Numerical Values in the Text Boxes
09:29
Adding Conditionally Formatted Values and KPIs in the Dashboard
11:44
Adding Line Charts in the Text Boxes
08:00
Adding Donut Charts in the Dashboard
10:00
Adding Text Boxes Inside Donut Charts
05:06
Adding Conditionally Formatted Values and Symbols Inside Donut Charts
03:25
Creating Income Statement in the Dashboard
11:56
Adding Column Charts in the Dashboard
08:15
Adding Line Chart in the Dashboard
04:34
Creating Drop Down List in the Dashboard and Linking to the Data Source
07:28
Removing Errors from Formulas
05:16
Section 2: Dashboard Layout Design 2:KPIs Financial Dashboard
36:14
Creating Navigation Pane
18:22
Creating Dashboard Layout
08:58
Adding All Data in the Dashboard
07:54

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