Seize the opportunity to gain new skills and reshape your career!

Choose a free learning path and get valuable insights from first-rate courses
watching now
3 Students
23 Lessons
Beginner

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

Curriculum

2h 54m
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

Description

Requirements

  • Microsoft Excel

About the Instructor

Reviews 2
Students 109
Courses 4

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.I am passionate to teach those who want to learn online and want to develop their skills during their study or job.

BitDegree platform reviews

Our students say Excellent
9.5 out of 10
trustpilot logo 1 trustpilot logo