Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Coddy

Learn Excel

via Coddy

Overview

A free, interactive online Excel course. You work in a real spreadsheet on every lesson - typing formulas, not watching them - with a free certificate when you finish.

  • Write formulas with absolute and relative cell references
  • Use SUM, AVERAGE, IF, COUNTIF, and the text functions
  • Look up and match data with VLOOKUP, XLOOKUP, and INDEX/MATCH
  • Sort, filter, and summarize a dataset into a readable report

Syllabus

Fundamentals

  • Meet the Spreadsheet
  • Entering Data
  • Your First Formula
  • Cell References
  • Basic Functions
  • Working with Text
  • Decisions with IF
  • Project: Grade Book

Formulas and Data Analysis

  • Reusable Formulas
  • Logical Decisions
  • Conditional Summaries
  • Lookup Tables
  • Cleaning Imported Data
  • Final Challenges

Reviews

Start your review of Learn Excel

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.