Excel 2021 Full Course Tutorial

Excel 2021 Full Course Tutorial

Learnit Training via YouTube Direct link

Introduction

37 of 48

37 of 48

Introduction

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Excel 2021 Full Course Tutorial

Automatically move to the next video in the Classroom when playback concludes

  1. 1 Start
  2. 2 Introduction
  3. 3 Start Screen
  4. 4 Excel Interface
  5. 5 Zooming, Navigating, and Shortcuts
  6. 6 Performing Excel Calculations
  7. 7 Simple Excel Functions
  8. 8 ABS, REF, and AutoFill Functions
  9. 9 Checking Compatibility
  10. 10 Inserting, Moving, and Cutting
  11. 11 Cell Styles
  12. 12 Themes
  13. 13 Showing and Hiding Worksheets
  14. 14 Grouping Worksheets
  15. 15 Freeze Panes
  16. 16 Custom Views
  17. 17 Saving Templates
  18. 18 Spell Check
  19. 19 Print Preview
  20. 20 Conclusion
  21. 21 Introduction
  22. 22 Formatting Lists as Tables
  23. 23 Flash Fill
  24. 24 Custom Sorting
  25. 25 Subtotals
  26. 26 QA Tool
  27. 27 Data Charts
  28. 28 Sparklines
  29. 29 Introduction to Pivot Tables
  30. 30 Advanced Pivot Tables Options
  31. 31 Data Validation
  32. 32 Conditional Formats
  33. 33 Comments and Notes
  34. 34 Linking Data
  35. 35 Privacy and Protection
  36. 36 Conclusion
  37. 37 Introduction
  38. 38 Nesting Functions
  39. 39 Database Functions
  40. 40 XLOOKUP
  41. 41 UNIQUE
  42. 42 SORT and SORTBY
  43. 43 FILTER
  44. 44 LET
  45. 45 Consolidate
  46. 46 Introduction to Macros
  47. 47 Recording and Playing Macros
  48. 48 Conclusion

Never Stop Learning.

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

Someone learning on their laptop while sitting on the floor.