Skip to Main Content

Excel: Everything You Wanted to Know but Were Afraid to Ask

Excel: Getting Started

GCFLearnFree's excellent playlist, Excel: Getting Started, provides you with 29 easy-to-follow tutorials on nearly all of the core concepts you'll learn in your class.

These videos cover everything from the beginning steps of creating a brand new Excel workbook, modifying columns and rows, and formatting cells—before transitioning to more complex skills like conditional formatting, sorting and filtering data, using relative and absolute cell references, creating pivot tables, and running a what-if analysis.

Note: these are Excel 2016 tutorials, but still apply to Excel 2019!

Want to see all of the videos, but follow along with text as well? GCFLearnFree has you covered! Click the links below to see the full YouTube playlist and its companion textbook tutorials.

Free Excel Basics Course

Excel Basics offers you 25 free tutorials on all the core Excel skills you’ll need, including:

  • creating formulas
  • using excel functions like VLOOKUP & IF
  • setting up pivot tables
  • applying number formatting 
  • using sort, filter and flash fill
  • creating charts, graphs, and other data visualizations
  • understanding defined names and ranges
  • using mixed & absolute cell references
Click the link below to see the full playlist!

Excel Basics (from Leila Gharani)

Another awesome playlist, also called Excel Basics, offers 30 tutorials covering things like:

  • filtering & sorting data
  • cell references (absolute vs. relative. vs. mixed)
  • VLOOKUP & HLOOKUP
  • everything about the IF function (including nested IF, AND, OR, etc.)
  • common formulas (like how to calculate percentages)
  • common workbook formatting tasks like formatting text, copying & pasting items, inserting headers & footers, setting the default workbook theme, hiding (and unhiding) worksheets, using the find & replace tool, and printing worksheets

Click the link below to see the full playlist!