Skip to content
Sabaqاردو

Excel Basics for the Workplace (Leila Gharani)

By Leila Gharani

Course audio
Course audio: English
Level
Beginner
Length
37 lessons · 5.9 hours

What you'll be able to do

  • Use absolute and relative references correctly
  • Sort, filter and validate data with drop-down lists
  • Look up values and fix common formula errors
  • Prepare spreadsheets for printing and PDF

About this course

Leila Gharani's beginner Excel playlist: 37 clear tutorials, about 6 hours. It opens with a full Excel tutorial for beginners, then cell references, cell modes, filters and advanced filter, sorting, smart drop-down lists and custom data validation, themes, headers and footers, notes, percentages, find and replace, changing case, locking cells, and printing large sheets properly. Later videos cover VLOOKUP and HLOOKUP, the formulas everyone needs, Excel interview questions, combining text and numbers, common errors, splitting data, duplicates, removing blank rows, PDF export, navigation shortcuts and what a pivot table is. Each video stands alone, but together they build solid office Excel habits.

Syllabus

37 lessons · 5:55:57 in total

  1. 1Excel Tutorial for Beginners | How to Use Excel15:54
  2. 2Excel Cell Reference: Absolute, Relative or Mixed?7:46
  3. 3How Familiar Are You With Excel Cell Modes? (Ready, Enter, Point, Edit)7:48
  4. 4How to Filter Data in Excel (Beginner’s Guide)10:46
  5. 5Advanced Filter Excel (And, Or, Between Conditions for Criteria Range)7:24
  6. 6Excel Sort Data (by Value, Color, Icon, Own List) & How to Unsort11:09
  7. 7Create SMART Drop Down Lists in Excel (with Data Validation)15:42
  8. 8Excel Custom Data Validation (Use formulas to check for text, numbers & length)14:16
  9. 9How to Change a Theme and Make it the Default in Excel5:42
  10. 10Excel Header & Footer (& Quickly Copy to other Sheets)8:00
  11. 11How to Add Notes in Excel | Shortcut Keys, Customize Background & More7:48
  12. 12Calculate Percentage in Excel the Right Way | Percentage Difference Formula4:28
  13. 13Find or Replace Text and Numbers in Excel (surprising features)6:41
  14. 14Easily Change CASE of Text in Excel (3 ways including NO Formulas)7:56
  15. 15Lock Cells & Protect Excel Worksheet - EVEN by Cell Color!5:17
  16. 16Stop Your Excel Printing Nightmares! Fix Margins, Scaling & Fit to Page10:51
  17. 17Properly Print a Large Spreadsheet on Multiple Pages in Excel (Repeat Headers)4:57
  18. 18Don’t Use VLOOKUP Until You Watch This! (VLOOKUP vs HLOOKUP Explained)10:36
  19. 19Excel Formulas and Functions You NEED to KNOW!10:47
  20. 20How to ACE Excel Interview Questions (Based on YOUR feedback & by Position)8:22
  21. 21How to Add Text to the Beginning of Values in Excel (Includes a Hidden Trick)6:53
  22. 22Should You Upgrade to Office 2021? Excel Users MUST Watch...15:32
  23. 23What's on My Quick Access Toolbar in Excel? You'll Probably be Surprised!12:41
  24. 24Easily Combine Text & Numbers into ONE Cell in Excel | NO CONCATENATE7:31
  25. 257 Excel Mistakes You Must Stop Making15:22
  26. 26Most Common Excel Errors #️⃣ and How To Fix Them - Avoid Broken Formulas7:27
  27. 27TEXTSPLIT in Excel: The Formula Version of Text to Columns7:28
  28. 28How an Excel Expert Sets Up Their Spreadsheet (6 Settings)10:15
  29. 29How to use Analyze Data in Excel (AI Creates Pivot Tables and Charts)8:16
  30. 30How to Find Duplicates in Excel (Fastest 4 Methods)8:40
Show all 37 lessons
  1. 31How to PROPERLY Convert Excel to PDF8:07
  2. 32Excel Time-Savers - 5 Hidden Features for Busy People14:24
  3. 33The Only VLOOKUP Guide You’ll Ever Need. (No More Errors)15:15
  4. 34Stop Wasting Time! 3 Easy Ways to Remove Blank Rows in Excel10:20
  5. 35Stop Doing Extra Work in Excel! (8 Hidden Features)11:48
  6. 36Stop Scrolling! 4 Pro Ways to Navigate Excel9:56
  7. 37What Actually IS a Pivot Table?3:52

What to take next

Videos by Leila Gharani, 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