Advanced Excel Dashboard Crash Course

Section 1: Introduction

0101 Introduction to Dashboard Course

Preview

0102 Introduction to 1st Dashboard

Preview

Practice Files

Section 2: 1st Dashboard using Pivot

0201 Understanding the Data

0202 Text Function

0203 Dynamic Data Create Table

Naming the dynamic data and using it in the function

Preparing 1st Pivot & updating data

Classic View & Filling blank with zero in Pivot

Create Chart for comparison from the Pivot

Create Trend Line from the Pivot

Creating Pie Chart from Slab Report from Pivot

Preparing Framework for Dashboard

Inserting Slicer using Chart

Customize Slicer Settings

Section 3: 2nd Dashboard using Functions

0301 Brief on 2nd Dashboard

0302 Importing Data from the Internet

0303 Converting Line Item into a Currency Table

0304 Calculation of Currency using INDEX & MATCH

0305 Creating Slabs using Vlookup True Parameter

0306 Creating Qtrs based on Financial or Calendar Selection

0307 Preparing the base by removing duplicates for Dashboard

0308 AverageIF for calculating Country Wise Salary

0309 Substituting ERROR with zero using IFERROR

0310 Introduction to Function INDIRECT Part 1 & 2

0311 Using Function INDIRECT to Retrieve AverageIF from relevant sheet

0312 Using Function CountIF with INDIRECT to calculate No. of Emp

0313 Calculating Contribution Country wise No Of Emp

0314 Using NameRange to simplify calculation

0315 Using NameRange with formula in 2nd Dashboard

0316 Introduction to Offset Function

0317 Offset Function in Excel

0318 Using Offset Function in Dashboard

0319 Use of MINIF in Dashboard

0320 Use of MAXIF in Dashboard

0321 Using Average to get Designation Wise Experience result

0322 Using MAXIF with multiple conditions

0323 Using MINIF with multiple conditions

0324 Dynamic Dropdown List

0325 Longitude and latitude with plotting data on dashboard

0326 Using REPT Function based on the percentage calculation

0327 Activation of Developer Tab and creating Scroll Bar

0328 Inserting Trend chart based on data

0329 Advance INDEX and MATCH with multiple references

0330 Inserting Spark Line

0331 Insert World Map into the chart

0332 Plotting Data on Map Chart

0333 Controlling Map Preview from dropdown

0334 Summarising 2nd Dashboard

Section 4: 3rd Dashboard using Functions $ Macros

0401 Brief on 3rd Dashboards

0402 Implementation of OFFSET for dynamic data

0403 Creating Trend Chart from 2 Pivot Table

0404 Modifying the Chart Settings for better view

0405 Using Macro recording for Trend Chart 01

0406 Using macro to update pivot based on the Job Type

0407 Triggering macro with any change in sheets

0408 Creating Name Range using shortcut

0409 Use of MAXIF and MINIF with single and multiple parameters

0410 Create chart to represent multiple parameters effectively 01

0411 Create chart to represent multiple parameters effectively 02

0412 Preparing data for Spiderweb chart and change the graph setting

0413 Using macro to Hide and Unhide working sheets

0414 Inserting Trend-line and formatting for better view

Conclusion

Conclusion of all 3 dashboard

Practice Files

Advanced Excel Dashboard Crash Course Section 1: Introduction

By: Yoda Learning

Share the link to this page

Copied

Facebook

Twitter

Add the class to your calendar

Add to Google Calendar

Add to Apple Calendar

Add to Yahoo Calendar

Add to Outlook Calendar

Completed

You need to have access to the item to view this lesson.

One-time Fee

$99.99

List Price: $139.99

You save: $40

€94.79

List Price: €132.71

You save: €37.92

£78.97

List Price: £110.56

You save: £31.59

CA$139.89

List Price: CA$195.85

You save: CA$55.96

A$153.73

List Price: A$215.23

You save: A$61.50

S$134.32

List Price: S$188.05

You save: S$53.73

HK$778.26

List Price: HK$1,089.59

You save: HK$311.33

CHF 88.57

List Price: CHF 124

You save: CHF 35.43

NOK kr1,105.08

List Price: NOK kr1,547.16

You save: NOK kr442.07

DKK kr706.99

List Price: DKK kr989.82

You save: DKK kr282.82

NZ$170.06

List Price: NZ$238.10

You save: NZ$68.03

د.إ367.26

List Price: د.إ514.17

You save: د.إ146.91

৳11,906.24

List Price: ৳16,669.22

You save: ৳4,762.97

₹8,436.24

List Price: ₹11,811.08

You save: ₹3,374.83

RM447.10

List Price: RM625.96

You save: RM178.86

₦167,464.25

List Price: ₦234,456.65

You save: ₦66,992.40

₨27,687.73

List Price: ₨38,763.93

You save: ₨11,076.20

฿3,470.35

List Price: ฿4,858.63

You save: ฿1,388.28

₺3,445.98

List Price: ₺4,824.51

You save: ₺1,378.53

B$578.68

List Price: B$810.17

You save: B$231.49

R1,810.53

List Price: R2,534.81

You save: R724.28

Лв185.34

List Price: Лв259.49

You save: Лв74.14

₩139,691.42

List Price: ₩195,573.58

You save: ₩55,882.15

₪373.67

List Price: ₪523.15

You save: ₪149.48

₱5,901.36

List Price: ₱8,262.14

You save: ₱2,360.78

¥15,574.86

List Price: ¥21,805.43

You save: ¥6,230.57

MX$2,020.46

List Price: MX$2,828.72

You save: MX$808.26

QR363.35

List Price: QR508.71

You save: QR145.35

P1,355.53

List Price: P1,897.79

You save: P542.26

KSh12,948.70

List Price: KSh18,128.70

You save: KSh5,180

E£4,969.50

List Price: E£6,957.50

You save: E£1,988

ብር12,262.61

List Price: ብር17,168.15

You save: ብር4,905.53

Kz91,256.94

List Price: Kz127,763.36

You save: Kz36,506.42

CLP$97,119.28

List Price: CLP$135,970.88

You save: CLP$38,851.60

CN¥724.58

List Price: CN¥1,014.45

You save: CN¥289.86

RD$6,000.34

List Price: RD$8,400.72

You save: RD$2,400.37

DA13,341.73

List Price: DA18,678.95

You save: DA5,337.22

FJ$227.04

List Price: FJ$317.87

You save: FJ$90.82

Q769.16

List Price: Q1,076.85

You save: Q307.69

GY$20,834.51

List Price: GY$29,169.15

You save: GY$8,334.63

ISK kr13,772.62

List Price: ISK kr19,282.22

You save: ISK kr5,509.60

DH995.44

List Price: DH1,393.66

You save: DH398.21

L1,819.82

List Price: L2,547.83

You save: L728

ден5,825.40

List Price: ден8,155.79

You save: ден2,330.39

MOP$798.74

List Price: MOP$1,118.27

You save: MOP$319.52

N$1,801.35

List Price: N$2,521.97

You save: N$720.61

C$3,666.61

List Price: C$5,133.40

You save: C$1,466.79

रु13,462.23

List Price: रु18,847.67

You save: रु5,385.43

S/378.10

List Price: S/529.35

You save: S/151.25

K400.90

List Price: K561.28

You save: K160.37

SAR375.38

List Price: SAR525.55

You save: SAR150.16

ZK2,752.36

List Price: ZK3,853.42

You save: ZK1,101.05

L471.69

List Price: L660.38

You save: L188.69

Kč2,395.79

List Price: Kč3,354.20

You save: Kč958.41

Ft38,840.72

List Price: Ft54,378.57

You save: Ft15,537.84

SEK kr1,099.74

List Price: SEK kr1,539.68

You save: SEK kr439.94

ARS$100,165.56

List Price: ARS$140,235.79

You save: ARS$40,070.23

Bs690.96

List Price: Bs967.37

You save: Bs276.41

COP$440,690.82

List Price: COP$616,984.78

You save: COP$176,293.95

₡50,645.88

List Price: ₡70,906.26

You save: ₡20,260.37

L2,517.41

List Price: L3,524.47

You save: L1,007.06

₲775,966.15

List Price: ₲1,086,383.66

You save: ₲310,417.50

$U4,274.58

List Price: $U5,984.58

You save: $U1,710

zł411.21

List Price: zł575.71

You save: zł164.50

Already have an account? Log In

Advanced Excel Dashboard Crash Course

Practice Files

Sign Up

Sign Up

Share