Excel Bundle

Learn about the Microsoft Excel basics, charts, and pivot tables.
9
views
Share the link to this page
Copied

Items in this Bundle

Learn how to build your first Microsoft Excel spreadsheet from scratch.
Recorded
Duration:
1 hour 30 minutes
Included:
2 videos
Level:
Beginner
Learn how to create Excel Pivot Tables, Pivot Charts, PowerQuery and PowerPivot to generate great reports from your data.
Recorded
Duration:
1 hour 22 minutes
Included:
2 videos
Level:
Intermediate
Learn how to create Microsoft Excel charts.
Recorded
Duration:
57 minutes
Included:
2 videos
Level:
Intermediate

About the Bundle

Microsoft Excel is the main program that people use to build spreadsheets on their computer, phone, or device. It is essential in many office jobs, and it is an invaluable skill to learn. It can be confusing and overwhelming, as there are many things that can be used for. This bundle will show you how to get started with Excel, and it will show you all of the important skills you need to build your first spreadsheet, and many spreadsheets after that.

What will you learn in this bundle?

  • Tour of the screen entering text autofill/speed fill saving the spreadsheet
  • AutoSum basic formulas
  • Relative formulas
  • Formatting the spreadsheet
  • Managing the sheets
  • Linking the sheets
  • Introduction to functions
  • Absolute formulas
  • Creating a chart from Excel data
  • Customizing a chart 
  • Adding data labels, titles, and trendlines 
  • Formatting a chart
  • Pie charts
  • Sparklines
  • Saving a re-using a chart template
  • Getting started with pivot tables 
  • Growing the pivot table sorting and filtering slicers
  • Creating a report by day, month, qtr, and year
  • Updating the pivot table with new data, adding your own calculations the power of the filter sections
  • PowerQuery
  • PowerPivot

Requirements

There are no additional requirements.

Author

Tom Fragale - Microsoft Certified Trainer

Tom Fragale - Microsoft Certified Trainer - PCWebinars.com
Tom Fragale is a computer professional with over 30 years of professional experience. He is a Microsoft Certified Trainer, a Microsoft Certified Office Master, and a Microsoft Certified Expert in Word and Excel., and a Microsoft Certified Specialist in Access, Outlook, and PowerPoint. He has trained over 30,000 business people in on-line...

School

Tom Fragale - Microsoft Certified Trainer's School

One-time Fee
$49.99
List Price:  $399.99
You save:  $350
€47.40
List Price:  €379.33
You save:  €331.92
£39.63
List Price:  £317.11
You save:  £277.48
CA$70.49
List Price:  CA$564.04
You save:  CA$493.55
A$77.37
List Price:  A$619.08
You save:  A$541.71
S$67.17
List Price:  S$537.46
You save:  S$470.29
HK$389.19
List Price:  HK$3,114.12
You save:  HK$2,724.92
CHF 44.40
List Price:  CHF 355.29
You save:  CHF 310.88
NOK kr554.33
List Price:  NOK kr4,435.48
You save:  NOK kr3,881.15
DKK kr353.82
List Price:  DKK kr2,831.12
You save:  DKK kr2,477.30
NZ$85.27
List Price:  NZ$682.28
You save:  NZ$597.01
د.إ183.60
List Price:  د.إ1,469.12
You save:  د.إ1,285.51
৳5,991.87
List Price:  ৳47,943.42
You save:  ৳41,951.54
₹4,220.67
List Price:  ₹33,771.29
You save:  ₹29,550.61
RM223.48
List Price:  RM1,788.15
You save:  RM1,564.67
₦83,303.55
List Price:  ₦666,545.11
You save:  ₦583,241.55
₨13,921.50
List Price:  ₨111,391.53
You save:  ₨97,470.03
฿1,739.54
List Price:  ฿13,918.76
You save:  ฿12,179.22
₺1,720.60
List Price:  ₺13,767.25
You save:  ₺12,046.65
B$289.78
List Price:  B$2,318.72
You save:  B$2,028.93
R909.97
List Price:  R7,281.05
You save:  R6,371.08
Лв92.85
List Price:  Лв743
You save:  Лв650.14
₩69,782.29
List Price:  ₩558,356.04
You save:  ₩488,573.75
₪187.44
List Price:  ₪1,499.80
You save:  ₪1,312.36
₱2,936.62
List Price:  ₱23,497.11
You save:  ₱20,560.48
¥7,715.70
List Price:  ¥61,736.47
You save:  ¥54,020.76
MX$1,017.05
List Price:  MX$8,137.85
You save:  MX$7,120.80
QR182.78
List Price:  QR1,462.53
You save:  QR1,279.75
P685.46
List Price:  P5,484.66
You save:  P4,799.20
KSh6,448.71
List Price:  KSh51,598.71
You save:  KSh45,150
E£2,467.50
List Price:  E£19,743.50
You save:  E£17,276
ብር6,072.05
List Price:  ብር48,584.93
You save:  ብር42,512.87
Kz45,590.88
List Price:  Kz364,790.88
You save:  Kz319,200
CLP$49,006.69
List Price:  CLP$392,122.19
You save:  CLP$343,115.50
CN¥361.55
List Price:  CN¥2,892.92
You save:  CN¥2,531.37
RD$3,021.06
List Price:  RD$24,172.73
You save:  RD$21,151.67
DA6,659.60
List Price:  DA53,286.19
You save:  DA46,626.58
FJ$113.77
List Price:  FJ$910.35
You save:  FJ$796.58
Q387.24
List Price:  Q3,098.49
You save:  Q2,711.25
GY$10,485.31
List Price:  GY$83,897.19
You save:  GY$73,411.88
ISK kr6,881.12
List Price:  ISK kr55,058.62
You save:  ISK kr48,177.50
DH499.87
List Price:  DH3,999.71
You save:  DH3,499.83
L903.32
List Price:  L7,227.89
You save:  L6,324.56
ден2,920.80
List Price:  ден23,370.52
You save:  ден20,449.71
MOP$402.05
List Price:  MOP$3,217.02
You save:  MOP$2,814.96
N$912.20
List Price:  N$7,298.89
You save:  N$6,386.69
C$1,844.96
List Price:  C$14,762.32
You save:  C$12,917.35
रु6,740.29
List Price:  रु53,931.79
You save:  रु47,191.50
S/190.34
List Price:  S/1,523.03
You save:  S/1,332.69
K201.60
List Price:  K1,613.15
You save:  K1,411.55
SAR187.76
List Price:  SAR1,502.41
You save:  SAR1,314.64
ZK1,376.61
List Price:  ZK11,014.84
You save:  ZK9,638.23
L236.21
List Price:  L1,890.03
You save:  L1,653.82
Kč1,198.05
List Price:  Kč9,586.12
You save:  Kč8,388.06
Ft19,357.37
List Price:  Ft154,886.12
You save:  Ft135,528.75
SEK kr548.82
List Price:  SEK kr4,391.33
You save:  SEK kr3,842.51
ARS$49,915.01
List Price:  ARS$399,390.01
You save:  ARS$349,475
Bs346.47
List Price:  Bs2,772.29
You save:  Bs2,425.82
COP$224,908.77
List Price:  COP$1,799,585.16
You save:  COP$1,574,676.39
₡25,517.62
List Price:  ₡204,176.70
You save:  ₡178,659.08
L1,266.25
List Price:  L10,131.84
You save:  L8,865.58
₲391,225.14
List Price:  ₲3,130,349.02
You save:  ₲2,739,123.87
$U2,143.94
List Price:  $U17,154.52
You save:  $U15,010.58
zł204.79
List Price:  zł1,638.64
You save:  zł1,433.85

Additional Details

Language: English
Level: Intermediate
Skills: Excel Charts, Microsoft Excel, Excel, MS Excel, Excel Basics, Pivot Tables
Age groups: All ages

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.