Creating and using calculated fields

Basic Microsoft Excel Course Introduction to Pivot chart and tables
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
€92.43
List Price:  €129.41
You save:  €36.97
£78.64
List Price:  £110.11
You save:  £31.46
CA$137.12
List Price:  CA$191.98
You save:  CA$54.85
A$151.09
List Price:  A$211.53
You save:  A$60.44
S$135.09
List Price:  S$189.14
You save:  S$54.04
HK$781.70
List Price:  HK$1,094.41
You save:  HK$312.71
CHF 90.65
List Price:  CHF 126.92
You save:  CHF 36.26
NOK kr1,054.77
List Price:  NOK kr1,476.72
You save:  NOK kr421.95
DKK kr689.49
List Price:  DKK kr965.32
You save:  DKK kr275.82
NZ$163.75
List Price:  NZ$229.26
You save:  NZ$65.50
د.إ367.26
List Price:  د.إ514.17
You save:  د.إ146.91
৳11,746.32
List Price:  ৳16,445.31
You save:  ৳4,698.99
₹8,326.85
List Price:  ₹11,657.93
You save:  ₹3,331.07
RM470.35
List Price:  RM658.51
You save:  RM188.16
₦139,564.04
List Price:  ₦195,395.24
You save:  ₦55,831.20
₨27,858.04
List Price:  ₨39,002.38
You save:  ₨11,144.33
฿3,674.88
List Price:  ฿5,144.98
You save:  ฿1,470.10
₺3,229.98
List Price:  ₺4,522.10
You save:  ₺1,292.12
B$520.22
List Price:  B$728.33
You save:  B$208.11
R1,863.40
List Price:  R2,608.83
You save:  R745.43
Лв180.83
List Price:  Лв253.17
You save:  Лв72.34
₩137,547.26
List Price:  ₩192,571.67
You save:  ₩55,024.40
₪371.76
List Price:  ₪520.48
You save:  ₪148.72
₱5,850.51
List Price:  ₱8,190.95
You save:  ₱2,340.43
¥15,690.93
List Price:  ¥21,967.93
You save:  ¥6,277
MX$1,704.41
List Price:  MX$2,386.24
You save:  MX$681.83
QR366.40
List Price:  QR512.98
You save:  QR146.57
P1,361.25
List Price:  P1,905.81
You save:  P544.55
KSh13,048.69
List Price:  KSh18,268.69
You save:  KSh5,220
E£4,726.59
List Price:  E£6,617.42
You save:  E£1,890.82
ብር5,771.53
List Price:  ብር8,080.38
You save:  ብር2,308.84
Kz85,432.22
List Price:  Kz119,608.52
You save:  Kz34,176.30
CLP$90,957.90
List Price:  CLP$127,344.70
You save:  CLP$36,386.80
CN¥710
List Price:  CN¥994.04
You save:  CN¥284.03
RD$5,917.99
List Price:  RD$8,285.42
You save:  RD$2,367.43
DA13,475.15
List Price:  DA18,865.75
You save:  DA5,390.60
FJ$225.87
List Price:  FJ$316.23
You save:  FJ$90.35
Q777.63
List Price:  Q1,088.72
You save:  Q311.08
GY$20,940.90
List Price:  GY$29,318.10
You save:  GY$8,377.20
ISK kr13,781.62
List Price:  ISK kr19,294.82
You save:  ISK kr5,513.20
DH998.11
List Price:  DH1,397.40
You save:  DH399.28
L1,770.37
List Price:  L2,478.58
You save:  L708.21
ден5,686.25
List Price:  ден7,960.98
You save:  ден2,274.72
MOP$805.41
List Price:  MOP$1,127.60
You save:  MOP$322.19
N$1,835.51
List Price:  N$2,569.79
You save:  N$734.27
C$3,698.08
List Price:  C$5,177.46
You save:  C$1,479.38
रु13,345.87
List Price:  रु18,684.75
You save:  रु5,338.88
S/376.83
List Price:  S/527.57
You save:  S/150.74
K389.14
List Price:  K544.81
You save:  K155.67
SAR375.01
List Price:  SAR525.03
You save:  SAR150.02
ZK2,729.87
List Price:  ZK3,821.92
You save:  ZK1,092.05
L459.98
List Price:  L643.99
You save:  L184.01
Kč2,290.69
List Price:  Kč3,207.05
You save:  Kč916.36
Ft36,007.06
List Price:  Ft50,411.33
You save:  Ft14,404.26
SEK kr1,062.87
List Price:  SEK kr1,488.06
You save:  SEK kr425.19
ARS$89,349.55
List Price:  ARS$125,092.95
You save:  ARS$35,743.39
Bs691.63
List Price:  Bs968.31
You save:  Bs276.68
COP$385,247.22
List Price:  COP$539,361.52
You save:  COP$154,114.30
₡51,971.60
List Price:  ₡72,762.33
You save:  ₡20,790.72
L2,481.76
List Price:  L3,474.56
You save:  L992.80
₲754,290.36
List Price:  ₲1,056,036.69
You save:  ₲301,746.32
$U3,854.56
List Price:  $U5,396.54
You save:  $U1,541.97
zł396.62
List Price:  zł555.29
You save:  zł158.66
Already have an account? Log In

Transcript

Let us take one more example that is go back to our data, select the entire data go to insert pivot table there are select OK. Now, the new pivot table has been created in sheet three. This time there is analyze, how many employees have resigned from each of the programs. So, our data should have the program names on the left hand side with the number of employees that have resigned in the following column. So, for that we will select the program names as rows and employee code as summation of values because only want the count of the employees. Again, we will change the field settings to count. As you can see, there are many other options over here like average maximum minimum product, and some which was selected by default.

We can use this based on our requirement. After clicking on Ok, I can see that from ABC program, there were 20 employees who had resigned from KLM program there were two employees who are designed. In this way, we can analyze the data from different perspectives and arrive at conclusions. Also, it is a good way to represent the data using charts. There are many options in Excel that we can use To represent the data

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.