Skip to content
Sabaqاردو

Excel for the Workplace (GCF LearnFree)

By LearnFree

Course audio
Course audio: English
Level
Beginner
Length
44 lessons · 2.3 hours

What you'll be able to do

  • Format, organise and print worksheets
  • Write formulas and use common functions
  • Sort, filter and summarise data with tables, charts and PivotTables

About this course

GCF LearnFree's Excel series: 26 short, calm lessons followed by 18 quick tips, about 2.3 hours. The lessons go in order from getting started, saving and sharing, cell basics, rows and columns, formatting and number formats, multiple worksheets and find and replace, to page layout and printing, formulas, relative and absolute references, functions, freeze panes, sorting, filtering, groups and subtotals, tables, charts, conditional formatting, comments, protecting workbooks, PivotTables and what-if analysis. The tips cover the fill handle, format painter, AutoSum, Quick Analysis, named ranges and more. Plain English and slow pace make it a good first Excel course for office job seekers.

Syllabus

44 lessons · 2:17:05 in total

  1. 1Excel: Getting Started4:21
  2. 2Excel Saving and Sharing Tutorial: How to Save, AutoRecover, Export and Share Workbooks3:43
  3. 3Excel: Cell Basics4:28
  4. 4Excel: Modifying Columns, Rows, and Cells4:48
  5. 5Excel: Formatting Cells3:55
  6. 6Excel: Understanding Number Formats5:44
  7. 7Excel: Working with Multiple Worksheets3:54
  8. 8Excel: Using Find and Replace1:55
  9. 9Excel: Page Layout and Printing5:37
  10. 10Excel: Intro to Formulas3:39
  11. 11Excel: Creating More Complex Formulas5:11
  12. 12Excel: Relative and Absolute Cell References5:25
  13. 13Excel: Functions5:16
  14. 14Solving Real-Life Problems in Excel4:19
  15. 15Excel: Freeze Panes and View Options4:22
  16. 16Excel: Sorting Data4:31
  17. 17Excel: Filtering Data4:46
  18. 18Excel: Groups and Subtotals4:24
  19. 19Excel: Tables3:20
  20. 20Excel: Charts4:31
  21. 21Excel: Conditional Formatting3:46
  22. 22Excel: Comments and Co-authoring4:14
  23. 23Excel: Inspecting and Protecting Workbooks3:13
  24. 24Excel: Intro to PivotTables4:35
  25. 25Excel: Doing More with PivotTables3:29
  26. 26Excel: What-if Analysis3:28
  27. 27Excel Quick Tip: Add the Current Date to a Cell0:54
  28. 28Excel Quick Tip: A Faster Way to Use the Fill Handle0:54
  29. 29Excel Quick Tip: Two Ways to Use the Format Painter1:34
  30. 30Excel Quick Tip: A Shortcut to AutoSum1:16
Show all 44 lessons
  1. 31Excel Quick Tip: Quick Access Toolbar Shortcuts1:27
  2. 32Excel Quick Tip: How to Quickly Duplicate a Sheet0:52
  3. 33Excel Quick Tip: Jump to Any Sheet with a Shortcut0:58
  4. 34Excel Quick Tip: Select an Entire Row or Column1:27
  5. 35Excel Quick Tip: Find a Sum Without Using a Formula1:11
  6. 36Excel Quick Tip: Why You Should Avoid Merging Cells2:31
  7. 37Excel Quick Tip: Using the Quick Analysis Tool1:33
  8. 38Excel Quick Tip: How to Make Charts Auto Update1:31
  9. 39Excel Quick Tip: Use Transpose to Flip Data on its Side1:22
  10. 40Excel Quick Tip: Absolute References with the F4 Key1:40
  11. 41Excel Quick Tip: Add a New Row with a Shortcut1:00
  12. 42Excel Quick Tip: Use an Entire Column as a Cell Range1:48
  13. 43Excel Quick Tip: What are Named Ranges?2:22
  14. 44Excel Quick Tip: A Trick for Finding Inconsistent Data1:51

What to take next

Videos by LearnFree, played from their official YouTube channel. Subscribe on YouTube

Official upload by the teacher or institution on their own channel, shown with YouTube's embedded player.

Lessons listed from the official YouTube playlist. Full playlist on YouTube

Lessons last checked Oct 2026. Course summary and lesson structure by Sabaq.

Report a problem or a rights request