0307 Preparing the base by removing duplicates for Dashboard

Advanced Excel Dashboard Crash Course Section 3: 2nd Dashboard using Functions
2 minutes
Share the link to this page
Copied
  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
€85.95
List Price:  €120.33
You save:  €34.38
£74.39
List Price:  £104.15
You save:  £29.75
CA$137.25
List Price:  CA$192.16
You save:  CA$54.90
A$153.37
List Price:  A$214.72
You save:  A$61.35
S$128.39
List Price:  S$179.75
You save:  S$51.36
HK$784.82
List Price:  HK$1,098.78
You save:  HK$313.96
CHF 80.25
List Price:  CHF 112.35
You save:  CHF 32.10
NOK kr1,020.27
List Price:  NOK kr1,428.42
You save:  NOK kr408.15
DKK kr641.51
List Price:  DKK kr898.14
You save:  DKK kr256.63
NZ$167.58
List Price:  NZ$234.61
You save:  NZ$67.03
د.إ367.26
List Price:  د.إ514.18
You save:  د.إ146.91
৳12,096.15
List Price:  ৳16,935.10
You save:  ৳4,838.94
₹8,615.32
List Price:  ₹12,061.80
You save:  ₹3,446.47
RM424.20
List Price:  RM593.90
You save:  RM169.70
₦152,576.74
List Price:  ₦213,613.54
You save:  ₦61,036.80
₨28,392.19
List Price:  ₨39,750.20
You save:  ₨11,358.01
฿3,238.17
List Price:  ฿4,533.57
You save:  ฿1,295.40
₺4,037.56
List Price:  ₺5,652.75
You save:  ₺1,615.18
B$554.92
List Price:  B$776.92
You save:  B$221.99
R1,768.01
List Price:  R2,475.29
You save:  R707.27
Лв168.01
List Price:  Лв235.22
You save:  Лв67.21
₩139,117.17
List Price:  ₩194,769.60
You save:  ₩55,652.43
₪335.51
List Price:  ₪469.72
You save:  ₪134.21
₱5,705.14
List Price:  ₱7,987.43
You save:  ₱2,282.28
¥14,869.88
List Price:  ¥20,818.42
You save:  ¥5,948.54
MX$1,872.89
List Price:  MX$2,622.13
You save:  MX$749.23
QR363.36
List Price:  QR508.72
You save:  QR145.36
P1,346.30
List Price:  P1,884.87
You save:  P538.57
KSh12,918.70
List Price:  KSh18,086.70
You save:  KSh5,168
E£4,940.77
List Price:  E£6,917.28
You save:  E£1,976.50
ብር13,831.14
List Price:  ብር19,364.16
You save:  ብር5,533.01
Kz91,186.38
List Price:  Kz127,664.58
You save:  Kz36,478.20
CLP$96,483.35
List Price:  CLP$135,080.55
You save:  CLP$38,597.20
CN¥717.74
List Price:  CN¥1,004.87
You save:  CN¥287.12
RD$5,995.27
List Price:  RD$8,393.63
You save:  RD$2,398.35
DA13,027.96
List Price:  DA18,239.67
You save:  DA5,211.70
FJ$225.35
List Price:  FJ$315.50
You save:  FJ$90.15
Q764.68
List Price:  Q1,070.58
You save:  Q305.90
GY$20,841.82
List Price:  GY$29,179.38
You save:  GY$8,337.56
ISK kr12,203.77
List Price:  ISK kr17,085.77
You save:  ISK kr4,882
DH903.06
List Price:  DH1,264.32
You save:  DH361.26
L1,700.80
List Price:  L2,381.20
You save:  L680.39
ден5,287.33
List Price:  ден7,402.48
You save:  ден2,115.14
MOP$805.72
List Price:  MOP$1,128.04
You save:  MOP$322.32
N$1,784.47
List Price:  N$2,498.33
You save:  N$713.86
C$3,667.66
List Price:  C$5,134.88
You save:  C$1,467.21
रु13,721.45
List Price:  रु19,210.58
You save:  रु5,489.13
S/353.53
List Price:  S/494.96
You save:  S/141.42
K419.14
List Price:  K586.82
You save:  K167.67
SAR375.05
List Price:  SAR525.09
You save:  SAR150.03
ZK2,329.49
List Price:  ZK3,261.38
You save:  ZK931.88
L436.05
List Price:  L610.48
You save:  L174.43
Kč2,116.74
List Price:  Kč2,963.52
You save:  Kč846.78
Ft34,300.12
List Price:  Ft48,021.54
You save:  Ft13,721.42
SEK kr967.79
List Price:  SEK kr1,354.95
You save:  SEK kr387.15
ARS$127,361.82
List Price:  ARS$178,311.64
You save:  ARS$50,949.82
Bs688.53
List Price:  Bs963.97
You save:  Bs275.43
COP$399,686.48
List Price:  COP$559,577.07
You save:  COP$159,890.58
₡50,284.66
List Price:  ₡70,400.54
You save:  ₡20,115.87
L2,613.46
List Price:  L3,658.95
You save:  L1,045.49
₲771,393
List Price:  ₲1,079,981.06
You save:  ₲308,588.06
$U4,030.02
List Price:  $U5,642.19
You save:  $U1,612.17
zł365.16
List Price:  zł511.24
You save:  zł146.08
Already have an account? Log In

Transcript

Hello, everybody. Welcome back to the second dashboard. In this video, we will create a base data for our dashboard. So the first thing we will need is all the unique countries that we have in our existing data. To do so, first we'll take the data will select the whole country column we have in one of the sheets, so I'll be getting 2013 data's for now we'll copy the entire country column, I've created a new sheet named data for the dashboard. So I'll just paste it.

Starting at the fourth row of column A and after I've done that, I will remove all duplicate entries. To do so I go to the Data tab. On the Data tab, I'll choose the option remove duplicates, in which in turn will select the entire column if it's not selected, and it will give me the option for multiple columns depends On my selection, as of now it's only one column. So only column A has been selected. I'll click on OK and automatically if there are multiple records in the same list, it will remove all the duplicates and I'll have just the individual values now as we can see that out of 11,943 there are 102 unique values in the data. Once done, click on OK. And now this is all the countries now I wish to calculate the average salary.

So I'll just name average salary. I also wish to see the minimum salary also, we want to see the maximum number of employees and the percentage contribution, so percentage number of employees that that should do it. So I wish to see the number of employees and the percentage, which we will be doing in the calculation part in the next video. Till then keep practicing. See you in the next video. Thank you

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.