Excel for Beginners

Excel for Beginners

Kevin Stratvert via YouTube Direct link

9-1. Pivot tables: All about pivot tables

37 of 60
Previous
Next

37 of 60

9-1. Pivot tables: All about pivot tables

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Excel for Beginners

Automatically move to the next video in the Classroom when playback concludes
  1. 1 1-1. Introduction: Welcome to Excel for Beginners
  2. 2 1-2. Introduction: What is Excel
  3. 3 1-3. Introduction: How to get Excel
  4. 4 2-1. Main interface: Start screen
  5. 5 2-2. Main interface: Workbook and worksheet
  6. 6 2-3. Main interface: Tabs and ribbon
  7. 7 2-4. Main interface: Navigate through a worksheet
  8. 8 2-5. Main interface: Navigate through a workbook
  9. 9 2-6. Main interface: Help
  10. 10 3-1. Enter data: Numbers
  11. 11 3-2. Enter data: Column width and row height
  12. 12 3-3. Enter data: Dates and times
  13. 13 3-4. Enter data: Select cells to enter data quickly
  14. 14 4-1. Save workbook: Save workbook
  15. 15 4-2. Save workbook: Benefits of saving a workbook in the cloud
  16. 16 5-1. Format, layout, and design: Basic formatting
  17. 17 5-2. Format, layout, and design: Tables
  18. 18 5-3. Format, layout, and design: Insert rows and columns
  19. 19 5-4. Format, layout, and design: Copy and move
  20. 20 5-5. Format, layout, and design: Conditional formatting
  21. 21 5-6. Format, layout, and design: Hide rows and columns
  22. 22 5-7. Format, layout, and design: Find and replace
  23. 23 6-1. Formulas and functions: Status bar for basic metrics
  24. 24 6-2. Formulas and functions: Enter a basic formula with addition and subtraction
  25. 25 6-3. Formulas and functions: Repeat formulas
  26. 26 6-4. Formulas and functions: Relative and absolute references
  27. 27 6-5. Formulas and functions: Division
  28. 28 6-6. Formulas and functions: Order of operations
  29. 29 6-7. Formulas and functions: Commons functions including SUM, MAX, MIN, COUNT, and AVERAGE
  30. 30 6-8. Formulas and functions: VLOOKUP function
  31. 31 6-9. Formulas and functions: XLOOKUP function
  32. 32 7-1. Charts: Insert and format charts
  33. 33 7-2. Charts: Analyze data to generate charts
  34. 34 8-1. Sorting and filtering: Sort
  35. 35 8-2. Sorting and filtering: Filter
  36. 36 8-3. Sorting and filtering: Worksheet views
  37. 37 9-1. Pivot tables: All about pivot tables
  38. 38 10-1. Flash fill: Separate and merge data using flash fill
  39. 39 11-1. Adjust worksheet views: Freeze panes
  40. 40 11-2. Adjust worksheet views: Split panes
  41. 41 12-1. Multiple worksheets and workbooks: Rename and color worksheets
  42. 42 12-2. Multiple worksheets and workbooks: Add and delete worksheets
  43. 43 12-3. Multiple worksheets and workbooks: Hide and unhide worksheets
  44. 44 12-4. Multiple worksheets and workbooks: Move and copy worksheets
  45. 45 12-5. Multiple worksheets and workbooks: Worksheet groups
  46. 46 13-1. Share and collaborate: Protect worksheet
  47. 47 13-2. Share and collaborate: Protect workbook
  48. 48 13-3. Share and collaborate: Password protect workbook
  49. 49 13-4. Share and collaborate: Share workbook
  50. 50 13-5. Share and collaborate: Version history
  51. 51 14-1. Print: Print selection
  52. 52 14-2. Print: Set print area
  53. 53 14-3. Print: Hide column
  54. 54 14-4. Print: Page settings
  55. 55 14-5. Print: Adjust columns
  56. 56 14-6. Print: Repeat headers
  57. 57 14-7 Print: Headers and footers
  58. 58 14-8. Print: Show gridlines
  59. 59 14-9. Print: Page break view
  60. 60 15-1. Wrap up: Wrap up

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.