Skip to content
Learn Netverks

Track

excel

Excel

36 lessons: formulas, lookups, pivots, charts, Power Query—read-focused local workbook practice and 108 MCQs.

Mode
none
Practice
Read / quiz
Lessons
36 units

Before you start

Spreadsheet skills: formulas, tables, pivots, and lightweight data analysis in Excel.

Business users and analysts still live in Excel—developers interface with their models daily.

Finance, operations, reporting, and quick what-if analysis before a full BI stack.

Task walkthrough lessons and MCQs you practice in your local spreadsheet app.

Anytime you exchange data with non-engineering stakeholders—parallel to SQL for analysts.

Lesson order

Sequential — follow top to bottom

36 lessons are live in this track. Start from step 01 for the smoothest path.

  1. 01 intro Introduction to Excel

    beginner

    Open →
  2. 02 what-is-excel What is Excel?

    beginner

    Open →
  3. 03 excel-vs-google-sheets-preview Excel vs Google Sheets (Preview)

    beginner

    Open →
  4. 04 excel-interface-workbook Workbook Interface and Navigation

    beginner

    Open →
  5. 05 excel-workflow-analysts Analyst Workflow in Excel

    beginner

    Open →
  6. 06 cells-rows-columns Cells, Rows, and Columns

    beginner

    Open →
  7. 07 data-entry-editing Data Entry and Editing

    beginner

    Open →
  8. 08 number-formats Number Formats

    beginner

    Open →
  9. 09 dates-times-excel Dates and Times in Excel

    beginner

    Open →
  10. 10 excel-tables-intro Excel Tables (Ctrl+T)

    beginner

    Open →
  11. 11 freeze-panes-views Freeze Panes and Views

    beginner

    Open →
  12. 12 formulas-basics Formulas and the Formula Bar

    beginner

    Open →
  13. 13 cell-references Relative, Absolute, and Mixed References

    beginner

    Open →
  14. 14 sum-average-count SUM, AVERAGE, COUNT, MIN, MAX

    beginner

    Open →
  15. 15 if-ifs-functions IF and IFS

    beginner

    Open →
  16. 16 text-functions-excel Text Functions (LEFT, RIGHT, MID, TRIM)

    intermediate

    Open →
  17. 17 formula-errors Understanding Formula Errors

    beginner

    Open →
  18. 18 vlookup-intro VLOOKUP Basics

    intermediate

    Open →
  19. 19 xlookup-preview XLOOKUP (Preview)

    intermediate

    Open →
  20. 20 index-match-preview INDEX and MATCH (Preview)

    intermediate

    Open →
  21. 21 sort-filter-basics Sort and Filter

    beginner

    Open →
  22. 22 conditional-formatting Conditional Formatting

    beginner

    Open →
  23. 23 data-validation Data Validation

    intermediate

    Open →
  24. 24 pivot-tables-intro Pivot Tables Introduction

    intermediate

    Open →
  25. 25 pivot-fields-slicers Pivot Fields, Filters, and Slicers

    intermediate

    Open →
  26. 26 charts-basics-excel Charts in Excel

    beginner

    Open →
  27. 27 chart-best-practices Chart Best Practices

    intermediate

    Open →
  28. 28 sparklines-preview Sparklines (Preview)

    beginner

    Open →
  29. 29 what-if-goal-seek-preview What-If Analysis (Preview)

    advanced

    Open →
  30. 30 power-query-intro Power Query (Get & Transform) Intro

    intermediate

    Open →
  31. 31 import-export-csv Import and Export CSV

    beginner

    Open →
  32. 32 excel-python-preview Excel with Python (Preview)

    intermediate

    Open →
  33. 33 excel-sql-data-science-bridge Excel, SQL, and Data Science

    intermediate

    Open →
  34. 34 interview-essentials-excel Interview Essentials: Excel

    intermediate

    Open →
  35. 35 production-checklist-excel Production Checklist for Spreadsheet Models

    beginner

    Open →
  36. 36 data-science-bridge-lesson Bridge to Data Science and SQL

    beginner

    Open →