Excel Essentials: Beginner to Advanced
From your first formula to lookups, text, dates and SUMIFS: 10 hands-on labs, every cell checked instantly.
The first 2 lessons are free — no account needed.
About this course
Excel Essentials is a set of ten Excel practice exercises you do online, in a spreadsheet in your browser, with no Excel licence needed. You start with data entry and your first formulas and work up to relative and absolute references, IF and IFERROR, VLOOKUP, INDEX/MATCH and XLOOKUP, text and date functions, SUMIFS and data cleaning, and finish with a monthly sales report project. The first two lessons are free.
Lessons
- Entering Data & Your First FormulasFree
- Relative, Absolute & Mixed ReferencesFree
- Math & Stats Functions: SUM, AVERAGE, COUNT, MEDIAN Pro
- Logical Functions: IF, AND, OR, IFS, IFERROR Pro
- Lookups: VLOOKUP, HLOOKUP, INDEX/MATCH, XLOOKUP Pro
- Text Functions: LEFT, MID, TRIM, PROPER, TEXT & Joining Pro
- Date Functions: DATE, EDATE, EOMONTH, NETWORKDAYS Pro
- SUMIFS, COUNTIFS & AVERAGEIFS Pro
- Data Cleaning: Split Codes, Fix Case, Convert Text to Numbers Pro
- Final Project: Monthly Sales Report Pro