EthicsComputerCourses
Join training
  1. Tutorials
  2. Excel Tutorial

Excel Tutorial

Learn Excel from your first formula to XLOOKUP, dynamic arrays and PivotTables, with sheets you can rebuild cell by cell.

17 free lessons Beginner to Advanced Covers Microsoft Excel (Microsoft 365) & Google Sheets

Start the first lesson

Getting Started

  1. 1Excel Introduction
  2. 2The Interface & Workbooks
  3. 3Entering & Editing Data
  4. 4Formatting & Indian Number Format

Formulas & Functions

  1. 5Formulas & Operators
  2. 6Relative & Absolute References
  3. 7SUM, AVERAGE, COUNT, MIN & MAX
  4. 8IF, IFS, AND & OR
  5. 9COUNTIF, SUMIF & SUMIFS
  6. 10Text Functions
  7. 11Date & Time Functions

Lookups & Modern Formulas

  1. 12VLOOKUP & XLOOKUP
  2. 13INDEX & MATCH
  3. 14Dynamic Arrays: FILTER, SORT, UNIQUE & SEQUENCE
  4. 15LET & LAMBDA

Working with Data

  1. 16Sorting & Filtering
  2. 17Conditional Formatting
  3. 18Data Validation & Drop-down Lists (coming soon)
  4. 19Excel Tables (coming soon)
  5. 20Charts (coming soon)
  6. 21PivotTables (coming soon)
  7. 22Power Query Basics (coming soon)
  8. 23What-If Analysis & Goal Seek (coming soon)

Productivity & Automation

  1. 24Protecting & Printing (coming soon)
  2. 25Keyboard Shortcuts (coming soon)
  3. 26Google Sheets Differences (coming soon)
  4. 27Macros, VBA & Office Scripts (coming soon)
  5. 28Copilot & Python in Excel (coming soon)

Templates & Project

  1. 29Templates: Attendance, Marks & GST Invoice (coming soon)
  2. 30Project: Monthly Sales & Expense Report (coming soon)

Learn Excel with a mentor

Free lessons get you started. Our Excel & Office Skills training adds real projects and code reviews from working developers.

  • Project-based learning
  • Mentor code reviews
  • Free counselling call
Get course details +91 90532 10052