InfoparkDailyCAREER TOOLS

Beginner 8 lessons · free

Excel tutorial Formulas, lookups, pivots and reports.

MS Excel — formulas, lookups and reports for office jobs. Every lesson has a sample sheet with the formulas and their results, key points, a practice task, a quiz and interview questions.

Start learning Excel Not started

Lessons

What you'll learn

  1. 01Excel introductionWorkbooks, sheets, cells, ranges and entering your first formula.
  2. 02SUM, AVERAGE, COUNT & ROUNDThe everyday functions for totals, averages, counts and rounding.
  3. 03Relative & absolute referencesWhy formulas change when copied, and how $ locks a cell.
  4. 04IF, AND, OR, IFS & COUNTIFMaking decisions in formulas and counting or summing with conditions.
  5. 05Lookups: XLOOKUP, VLOOKUP & INDEX/MATCHFetching matching values from another table — the most asked Excel interview topic.
  6. 06Text & date functionsCleaning text and working with dates: TRIM, PROPER, TEXT, LEFT, TODAY, DATEDIF and more.
  7. 07Sorting, filtering & pivot tablesTurning raw data into summaries with tables, filters and PivotTables.
  8. 08Conditional formatting, validation & chartsHighlighting what matters, preventing bad input, and presenting with charts.