Creating pivot table

Basic Microsoft Excel Course Introduction to Pivot chart and tables
1 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
€95.46
List Price:  €133.64
You save:  €38.18
£79.41
List Price:  £111.18
You save:  £31.76
CA$141.89
List Price:  CA$198.66
You save:  CA$56.76
A$157.04
List Price:  A$219.87
You save:  A$62.82
S$134.12
List Price:  S$187.77
You save:  S$53.65
HK$777.87
List Price:  HK$1,089.05
You save:  HK$311.18
CHF 90.02
List Price:  CHF 126.04
You save:  CHF 36.01
NOK kr1,112.44
List Price:  NOK kr1,557.46
You save:  NOK kr445.02
DKK kr712.12
List Price:  DKK kr996.99
You save:  DKK kr284.87
NZ$174.36
List Price:  NZ$244.12
You save:  NZ$69.75
د.إ367.26
List Price:  د.إ514.18
You save:  د.إ146.91
৳12,105.95
List Price:  ৳16,948.82
You save:  ৳4,842.86
₹8,684.86
List Price:  ₹12,159.16
You save:  ₹3,474.29
RM443.35
List Price:  RM620.71
You save:  RM177.36
₦150,965.90
List Price:  ₦211,358.30
You save:  ₦60,392.40
₨27,811.37
List Price:  ₨38,937.03
You save:  ₨11,125.66
฿3,371.46
List Price:  ฿4,720.18
You save:  ฿1,348.72
₺3,622.49
List Price:  ₺5,071.63
You save:  ₺1,449.14
B$570.27
List Price:  B$798.40
You save:  B$228.13
R1,845.09
List Price:  R2,583.20
You save:  R738.11
Лв186.54
List Price:  Лв261.16
You save:  Лв74.62
₩144,306.56
List Price:  ₩202,034.95
You save:  ₩57,728.39
₪355.60
List Price:  ₪497.86
You save:  ₪142.25
₱5,802.07
List Price:  ₱8,123.13
You save:  ₱2,321.06
¥15,178.98
List Price:  ¥21,251.18
You save:  ¥6,072.20
MX$2,039.44
List Price:  MX$2,855.30
You save:  MX$815.86
QR363.22
List Price:  QR508.53
You save:  QR145.30
P1,374.27
List Price:  P1,924.04
You save:  P549.76
KSh12,913.70
List Price:  KSh18,079.70
You save:  KSh5,166
E£5,058.12
List Price:  E£7,081.57
You save:  E£2,023.45
ብር12,761.59
List Price:  ብር17,866.75
You save:  ብር5,105.15
Kz91,357.53
List Price:  Kz127,904.19
You save:  Kz36,546.66
CLP$94,330.18
List Price:  CLP$132,066.03
You save:  CLP$37,735.84
CN¥726.04
List Price:  CN¥1,016.49
You save:  CN¥290.44
RD$6,193.25
List Price:  RD$8,670.79
You save:  RD$2,477.54
DA13,478.85
List Price:  DA18,870.93
You save:  DA5,392.08
FJ$229.55
List Price:  FJ$321.38
You save:  FJ$91.83
Q769.15
List Price:  Q1,076.84
You save:  Q307.69
GY$20,845.38
List Price:  GY$29,184.37
You save:  GY$8,338.98
ISK kr14,042.59
List Price:  ISK kr19,660.19
You save:  ISK kr5,617.60
DH994.70
List Price:  DH1,392.63
You save:  DH397.92
L1,864.97
List Price:  L2,611.03
You save:  L746.06
ден5,870.98
List Price:  ден8,219.61
You save:  ден2,348.63
MOP$798.78
List Price:  MOP$1,118.33
You save:  MOP$319.54
N$1,830.78
List Price:  N$2,563.17
You save:  N$732.38
C$3,666.26
List Price:  C$5,132.92
You save:  C$1,466.65
रु13,820.16
List Price:  रु19,348.78
You save:  रु5,528.62
S/370.17
List Price:  S/518.25
You save:  S/148.08
K400.70
List Price:  K560.99
You save:  K160.29
SAR375
List Price:  SAR525.02
You save:  SAR150.01
ZK2,807.24
List Price:  ZK3,930.24
You save:  ZK1,123
L475.17
List Price:  L665.26
You save:  L190.08
Kč2,391.05
List Price:  Kč3,347.56
You save:  Kč956.51
Ft38,427.50
List Price:  Ft53,800.04
You save:  Ft15,372.53
SEK kr1,071.67
List Price:  SEK kr1,500.39
You save:  SEK kr428.71
ARS$105,609.97
List Price:  ARS$147,858.18
You save:  ARS$42,248.21
Bs688.43
List Price:  Bs963.83
You save:  Bs275.40
COP$413,458.90
List Price:  COP$578,859.01
You save:  COP$165,400.10
₡50,520.61
List Price:  ₡70,730.88
You save:  ₡20,210.26
L2,540.02
List Price:  L3,556.13
You save:  L1,016.11
₲785,045.76
List Price:  ₲1,099,095.47
You save:  ₲314,049.71
$U4,333.83
List Price:  $U6,067.53
You save:  $U1,733.70
zł397.42
List Price:  zł556.40
You save:  zł158.98
Already have an account? Log In

Transcript

Today, I'll show you all how to analyze data using the most efficient and powerful feature of Excel that is the tables and charts. I have a data over here of employees, their gender, joining dates, resignation dates, leaving dates the service period that they had served in months and the program in which they belong to with this normal data, we can analyze it in many different ways using a pivot table. Let us see how let us first select the entire table, go to insert pivot table there are say yes because we want to create it in a new worksheet. And the range is what we had selected. When we click on Oh It takes us to sheet two and a blank pivot table.

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.