FormulaCamp
Completed
← All paths
Learning paths

Excel for Students & Your First Job

Excel for students and first-time employees: the skills every office job expects, from formulas and charts to PivotTables, in a short, practical path.

25 lessons · about 6.3 h · 23 lessons are free

0 of 25 lessons done

Start the path

Who it is for

Students, interns and recent graduates who want solid everyday Excel skills before the first day at work, with no prior experience needed.

What you will be able to do

  • Move around Excel fast with shortcuts, AutoFill and Find and Replace
  • Write correct formulas with SUM, IF, COUNTIF and absolute references
  • Look up data with VLOOKUP, sort and filter lists, and build clean charts
  • Summarize a table with a PivotTable and fix the formula errors you meet along the way

Lessons in this path

  1. 1What Excel Is and How It Is OrganizedFreetheory and quiz10 min
  2. 2Cells, Rows and RangesFreelesson15 min
  3. 3Data Types: Numbers, Text, Dates, LogicFreelesson15 min
  4. 4Copy, Paste and AutoFillFreelesson15 min
  5. 5Files, Formats and SavingFreetheory and quiz10 min
  6. 6Keyboard Shortcuts and Common Beginner MistakesFreetheory and quiz10 min
  7. 7Find and ReplaceFreelesson15 min
  8. 8Cell FormatsFreelesson15 min
  9. 9Your First FormulaFreelesson15 min
  10. 10Arithmetic and PercentagesFreelesson15 min
  11. 11Absolute References ($)Freelesson15 min
  12. 12The SUM FunctionFreelesson15 min
  13. 13AVERAGE, MIN, MAXFreelesson15 min
  14. 14Counting: COUNT, COUNTA, COUNTBLANKFreelesson15 min
  15. 15The IF FunctionFreelesson15 min
  16. 16COUNTIF and SUMIFlesson15 min
  17. 17Text: & and UPPERlesson15 min
  18. 18The VLOOKUP FunctionFreelesson15 min
  19. 19Sorting DataFreelesson15 min
  20. 20Filter and SUBTOTALFreelesson15 min
  21. 21ChartsFreelesson15 min
  22. 22PivotTableFreelesson15 min
  23. 23Formula Errors and How to Fix ThemFreelesson20 min
  24. 24IFERROR and Checking FunctionsFreelesson15 min
  25. 25Project P01: Personal Finance TrackerFreeproject30 min

Interview-style questions

Typical tasks and questions for this role. Each one is taught in a lesson of the path.

  1. What does the dollar sign in $A$1 do, and when do you need it?

    Learn it in: Absolute References ($)

  2. How do you count how many students passed and sum their points in one table?

    Learn it in: COUNTIF and SUMIF

  3. A formula shows #N/A or #DIV/0!. What do these errors mean and how do you fix them?

    Learn it in: Formula Errors and How to Fix Them

  4. Name five keyboard shortcuts that speed up your work in Excel.

    Learn it in: Keyboard Shortcuts and Common Beginner Mistakes

Practice

Other paths