All courses

Level 2

Essential Formulas & Everyday Logic

Stop calculating by hand. Automate everyday math with core formulas and cell references.

New course(0 reviews) 11 modules · 85 lessons 17 knowledge checks About 3 hours of hands-on practice
View pricing

What you’ll learn

  • Write formulas with the right syntax, order of operations and relative/absolute references
  • Summarise data with SUM, AVERAGE, COUNT, COUNTA, MIN, MAX and ROUND
  • Make decisions with IF, AND, OR and NOT
  • Turn raw data into formatted Excel Tables, charts and print-ready reports

Course overview

This is where Excel starts doing the work for you. You'll write your first formulas, understand relative and absolute references, and learn the functions people use every day (SUM, AVERAGE, COUNT, MIN, MAX and ROUND) before teaching Excel to make decisions with IF, AND, OR and NOT.

You'll also learn to make your work look professional and easy to read: number and cell formatting, sorting and filtering, Excel Tables, charts and print-ready page layouts, plus the shortcuts that save time on every task.

How you’ll learn

Watch, then do it yourself

Short guided demos narrated by Kyle, then you repeat each step on the same live spreadsheet, right in your browser.

Instant feedback

“Check my work” grades your sheet the moment you finish, and knowledge checks every few lessons lock it in.

Help when you're stuck

Owl, your AI tutor, sees exactly what's on your sheet. Members can also message Kyle directly through 'Ask Kyle'.

Your course project

Northstar Solutions: Monthly Sales Report

Northstar has started logging every sale. Starting from the product list you built in Level 1, you'll add a monthly sales log and turn it into a finished report: line totals, tax and commission, summary statistics, IF-based flags, professional formatting, a sorted and filtered Excel Table, charts and a print-ready page.

Every course in the academy works with the same company, so each project builds on the skills, and the data, from the last.

Course content

11 modules · 85 lessons · 17 knowledge checks
  • Interactive lesson
  • Step-by-step guide
  • Knowledge check

Where this course fits

Level 2 of the five-level core track. Each level builds on the one before it.

  1. Level 1Excel Foundations
  2. Level 2Essential Formulas & Everyday LogicYou are here
  3. Level 3Intermediate Lookups & Data Summaries
  4. Level 4Advanced Dynamic Arrays & Logic
  5. Level 5Expert Techniques & Workbook Architecture

Before you start

Level 1: Excel Foundations, or comfort with the Excel window, entering data and copy/paste.

Who this course is for

  • People who still do the math with a calculator or by hand
  • Anyone who wants to write formulas without second-guessing them
  • Learners who have finished Excel Foundations

Meet your instructor

Kyle Stott

Kyle Stott

Certified Microsoft Excel Expert

Kyle has worked professionally with Microsoft Excel for over a decade, consulting on and teaching best practices to over 400 companies across 30+ countries.

He built My Excel Academy so learners can practice in the same window they are learning in, with instant checks alongside an AI tutor, all while offering 1-on-1 instructor support when something doesn't add up.

Student reviews New course

This course doesn’t have reviews yet. Here’s what students say about the academy — rated 5.0 out of 5 across 3 reviews.

“My experience with My Excel Academy was excellent! The instructor was knowledgeable, engaging and provided plenty of hands-on practice. The course was perfect for beginners as it clearly outlined the workspace as well as some basic features that excel has to offer. I highly recommend this course for anyone looking to improve their excel skills or to begin their journey of learning excel.”
MarioMicrosoft Excel – Overview · April 21, 2023
“Really enjoyed this course! Packed full of useful insights. Even though I consider myself somewhat experience with Excel, I still took away new learnings.”
JackMicrosoft Excel – Overview · April 14, 2023
“I really appreciate the refresher of key basics. I use Excel daily and learned new tools, lingo and strategies. It’s tempting to skip past these foundational elements to tackle the sticky and more complex problems. With these basics in hand I’ll have a much easier time navigating the system and bringing efficiency to my work! Time to customize my Quick Access Toolbar!”
AleksandraMicrosoft Excel – Overview · April 13, 2023