Advanced Excel Dashboard Crash Course

Learn Microsoft Excel dashboard for data analytics with visual using Excel tools, functions and Excel macros.
00:00
00:00

Advanced Excel Dashboard Crash Course

Learn Microsoft Excel dashboard for data analytics with visual using Excel tools, functions and Excel macros.
467
views
1
Save
Share the link to this page
Copied

About the Class

Dashboard help user visualizes complex scenarios and problem better, with the help of advanced Excel dashboard one can make better business decisions.

Our course is meant for professionals working at different levels of careers, i.e., From MIS executive to Data Analyst.

MS Excel made it easy to make Dashboards for any Analytics. Business users can easily analyze data to create powerful reports and dashboards in a fraction of the time of traditional spreadsheets.

In this course, you'll learn to make a dashboard in Excel in different ways:

  1. Dashboard using Pivot Table like Multiple Pivot, Interlinked Pivot, Slicer buttons to control charts, Advanced Charts, etc.
  • Text function in Excel.
  • Naming the dynamic data and using it in function.
  • Create a chart for comparison from the pivot table.
  • Create a trend line from the pivot table.
  • Creating a pie chart from the slab report from a pivot table.
  • Inserting slicer using a chart and customize slicer set.
  1. 2 Dashboard using Excel Functions:
  • Importing data from the internet.
  • Converting line item into a currency table.
  • Calculation of currency using INDEX and MATCH.
  • AVERAGEIF for calculating country-wise salary.
  • Dynamic dropdown
  • List longitude and latitude with plotting data on a dashboard.
  • Using the REPT function based on the percentage calculation.
  • Advanced INDEX and MATCH with multiple references.
  • Insert world map into the chart.
  • Plotting data on map chart and Controlling map preview from the drop-down.
  • Preparing the base by removing duplicate for a dashboard.
  1. 3 Dashboard using Excel macros and Functions:
  • Implementation of OFFSET for dynamic data.
  • Using a macro to update the pivot table based on the job type.
  • Preparing data for the Spiderweb chart and change the graph setting.
  • Use of Array functions like MAXIF and MINIF with single and multiple parameters.
  • Creating Name Range using a shortcut.

This course is for all business users who want to learn how to create management reports, analyze data, and create interactive dashboards using Excel 2010 and later versions.

Who should take this course?

  • People who analyze data and create new insight
  • People who do reporting and create dashboards
  • Professionals working with a large amount of data

Benefits Of Excel Dashboard Crash Course:

  • It provides an overview of your problem.
  • You get to avail of total visibility into your business.
  • Excel dashboards provide extreme flexibility.
  • Saves more time at work.
  • Increased profits.
  • You’ll get improved results with interactive dashboards.

 What will you learn in this course?

  • Analyze data and create reports in a fraction of the time of spreadsheets.
  • Create new powerful calculations, KPIs, and key metrics.
  • Plot data on a map in the advanced Excel dashboard.
  • Learn three types of dashboards in this course.
  • Learn to make an Excel dashboard using pivot tables.
  • Learn to create an Excel dashboard using functions.
  • Learn to create an Excel dashboard using macros and functions.
  • Get a conclusion of all 3 Excel dashboards.

Author

Yoda Learning

Director, Yoda Learning | Previously J.P. Morgan, Futures First, KPMG
I have tried three work profiles in 4.5 yrs. before I settled on the fourth one (9.5 yrs). I transformed from a College Fresher to a polished professional by working for a Big Four (Audit). I traded Interest Rates Futures & Options and learnt what is greed, fear and stop loss. I worked for an I-Bank and understood how to pitch for new...

School

Yoda Learning's School

Requirements

You should have basic understanding of Microsoft Excel.

Class Contents

One-time Fee
$99.99
List Price:  $139.99
You save:  $40
€84.65
List Price:  €118.52
You save:  €33.86
£72.58
List Price:  £101.62
You save:  £29.03
CA$136.02
List Price:  CA$190.44
You save:  CA$54.41
A$151.83
List Price:  A$212.57
You save:  A$60.74
S$127.07
List Price:  S$177.90
You save:  S$50.83
HK$784.91
List Price:  HK$1,098.91
You save:  HK$313.99
CHF 78.85
List Price:  CHF 110.40
You save:  CHF 31.54
NOK kr1,001.25
List Price:  NOK kr1,401.79
You save:  NOK kr400.54
DKK kr631.59
List Price:  DKK kr884.25
You save:  DKK kr252.66
NZ$163.51
List Price:  NZ$228.92
You save:  NZ$65.41
د.إ367.26
List Price:  د.إ514.18
You save:  د.إ146.91
৳12,272.48
List Price:  ৳17,181.96
You save:  ৳4,909.48
₹8,552.54
List Price:  ₹11,973.90
You save:  ₹3,421.36
RM419.80
List Price:  RM587.74
You save:  RM167.94
₦153,673.63
List Price:  ₦215,149.23
You save:  ₦61,475.60
₨28,372.16
List Price:  ₨39,722.16
You save:  ₨11,350
฿3,241.02
List Price:  ฿4,537.56
You save:  ฿1,296.54
₺3,986.05
List Price:  ₺5,580.63
You save:  ₺1,594.58
B$544.95
List Price:  B$762.95
You save:  B$218
R1,756.77
List Price:  R2,459.56
You save:  R702.78
Лв165.53
List Price:  Лв231.75
You save:  Лв66.22
₩135,323.61
List Price:  ₩189,458.47
You save:  ₩54,134.86
₪337
List Price:  ₪471.81
You save:  ₪134.81
₱5,631.83
List Price:  ₱7,884.79
You save:  ₱2,252.96
¥14,297.10
List Price:  ¥20,016.52
You save:  ¥5,719.41
MX$1,869.50
List Price:  MX$2,617.38
You save:  MX$747.87
QR364.11
List Price:  QR509.76
You save:  QR145.65
P1,330.60
List Price:  P1,862.89
You save:  P532.29
KSh12,923.70
List Price:  KSh18,093.70
You save:  KSh5,170
E£4,943.64
List Price:  E£6,921.29
You save:  E£1,977.65
ብር13,533.64
List Price:  ብር18,947.64
You save:  ብር5,414
Kz91,186.38
List Price:  Kz127,664.58
You save:  Kz36,478.20
CLP$93,154.68
List Price:  CLP$130,420.28
You save:  CLP$37,265.60
CN¥716.11
List Price:  CN¥1,002.59
You save:  CN¥286.47
RD$5,943.36
List Price:  RD$8,320.95
You save:  RD$2,377.58
DA12,931.03
List Price:  DA18,103.96
You save:  DA5,172.93
FJ$223
List Price:  FJ$312.21
You save:  FJ$89.21
Q768.92
List Price:  Q1,076.52
You save:  Q307.60
GY$20,920.18
List Price:  GY$29,289.09
You save:  GY$8,368.90
ISK kr12,035.79
List Price:  ISK kr16,850.59
You save:  ISK kr4,814.80
DH901.05
List Price:  DH1,261.51
You save:  DH360.45
L1,678.82
List Price:  L2,350.41
You save:  L671.59
ден5,202.98
List Price:  ден7,284.39
You save:  ден2,081.40
MOP$808.56
List Price:  MOP$1,132.01
You save:  MOP$323.45
N$1,772.12
List Price:  N$2,481.04
You save:  N$708.91
C$3,677.13
List Price:  C$5,148.13
You save:  C$1,471
रु13,729.19
List Price:  रु19,221.42
You save:  रु5,492.22
S/354.38
List Price:  S/496.15
You save:  S/141.77
K412.52
List Price:  K577.54
You save:  K165.02
SAR375
List Price:  SAR525.01
You save:  SAR150.01
ZK2,387.35
List Price:  ZK3,342.39
You save:  ZK955.03
L429.61
List Price:  L601.48
You save:  L171.86
Kč2,090.64
List Price:  Kč2,926.98
You save:  Kč836.34
Ft33,796.85
List Price:  Ft47,316.95
You save:  Ft13,520.09
SEK kr942.85
List Price:  SEK kr1,320.03
You save:  SEK kr377.18
ARS$120,438.47
List Price:  ARS$168,618.67
You save:  ARS$48,180.20
Bs692.42
List Price:  Bs969.41
You save:  Bs276.99
COP$407,094.86
List Price:  COP$569,949.09
You save:  COP$162,854.23
₡50,462.55
List Price:  ₡70,649.59
You save:  ₡20,187.03
L2,619.73
List Price:  L3,667.73
You save:  L1,048
₲797,914.11
List Price:  ₲1,117,111.67
You save:  ₲319,197.56
$U3,994.64
List Price:  $U5,592.65
You save:  $U1,598.01
zł359.09
List Price:  zł502.74
You save:  zł143.65

What's Included

Language: English
Level: All levels
Skills: Data Analysis, Data Visualization, Microsoft Excel, Dashboards, Macros, Data Analytics, Pivot Tables
Age groups: 18+ years, All ages
Duration: 3 hours 56 minutes
63 Videos
1 Document
1
Save
467
Views
This class has not been saved

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.