Guest Preview: 6 starter lessons (18 exercises) unlocked. Upgrade to Pro for all 91 lessons.
Lesson Exercises
Learn:
Hint:
SUM & Conditional Totals · Lesson Guide
Core Concept

AutoSum automatically detects adjacent contiguous numbers directly above (or to the left of) your active cell and inserts a ready-to-confirm =SUM(...) formula.

Syntax & Key Pattern
Ribbon ∑ AutoSum button OR Keyboard Shortcut: Alt + =

Select the empty cell right below a column (or right of a row), press Alt+=, verify the range, and confirm.

Pro Tip

Select multiple empty total cells across a row at once before clicking AutoSum to drop SUM formulas across every column simultaneously.

Common Mistake to Avoid

Leaving an empty row above the total stops AutoSum from scanning higher cells—always check the range bounds.

Excel Exercise Curriculum

No lessons match your current filter.

Try clearing your search keyword or switching status filters.

Module 01 · Foundations

Getting Started in Excel

Master cells, coordinates, live formula entry, and referencing values instead of typing static numbers.

Module 02 · Core Math

SUM & Conditional Totals

Build everything from simple totals and AutoSum to multi-criteria SUMIFS and broken-formula debugging.

Totaling Ranges with the SUM Function Free L1
Add contiguous lists, combine multiple ranges inside a single SUM call, and total horizontal rows cleanly. =SUM(number1, [number2], ...)
Module 03 · Data Auditing

COUNT Family Mastery

Quantify records cleanly with COUNT, COUNTA, COUNTBLANK, wildcards, and multi-condition COUNTIFS.

Counting Numeric Entries with COUNT Free L1
Understand what COUNT counts (numbers and dates) vs what it skips (text and blanks). =COUNT(value1, [value2], ...)
Module 04 · Decision Logic

Logical Decisions & Error Guards

Create branching business rules with TRUE/FALSE, AND/OR/XOR, IF, IFS, SWITCH, IS functions, and nested logic.

Conditional Branching with IF Free L1
Return custom text labels, tiered calculations, and dynamic rates based on an IF test. =IF(logical_test, value_if_true, value_if_false)
Module 05 · Lookups

Modern & Classic Lookups

Pull matching records across pricing tables, tax brackets, and rows with XLOOKUP, VLOOKUP, and HLOOKUP.

Module 06 · Flexible Lookup

INDEX & MATCH Precision

Decouple position lookup from return columns for leftward, exact, and threshold lookups.

Module 07 · String Extraction

Text Parsing & Search

Extract SKUs, domains, codes, and delimiters with LEN, LEFT, RIGHT, MID, FIND, SEARCH, TEXTBEFORE, and TEXTAFTER.

Module 08 · Data Hygiene

Text Cleanup & Formatting

Standardize messy CRM exports using CONCAT, TEXTJOIN, UPPER, LOWER, PROPER, and SUBSTITUTE.

Module 09 · Analytics

Statistical & Rounding Functions

Summarize distributions and pricing tiers using AVERAGE, MIN/MAX, LARGE/SMALL, MEDIAN, MODE, FLOOR/CEILING, and ODD/EVEN.

Module 10 · Date Math

Dates, Timelines & Tenures

Calculate project durations, SLA deadlines, and employee tenure with DATE, TODAY, DAYS, and DATEDIF.

Module 11 · Tables & BI

Filters & PivotTable Summaries

Slice tabular datasets dynamically with Table Filters and multi-dimensional PivotTables.

Module 12 · Excel 365

Dynamic Array Formulas

Build spilling live extracts and deduplicated lists automatically with UNIQUE and FILTER.

Module 13 · Workbook Polish

Worksheets & Conditional Formatting

Organize multi-tab workbooks, link sheets with Sheet!A1 refs, and highlight exceptions visually.

Module 14 · Keyboard Flow

Speed & Formatting Shortcuts

Replace slow mouse clicks with Bold, Number formats, Cut/Copy/Paste, Fill Down (Ctrl+D), Fill Right (Ctrl+R), and Data shortcuts.

Essential Workbook Productivity Shortcuts Free L1
Eliminate repetitive mouse travel using Ctrl+S (Save), Ctrl+Z (Undo), and F2 (Edit Active Cell). F2 = Edit cell in place | Ctrl+Z = Undo | Ctrl+S = Save workbook
Module 15 · Grid Mastery

Rapid Range & Table Selection

Jump across large tables with Ctrl+Arrows, select contiguous ranges via Ctrl+Shift+Arrows, and select rows/columns instantly.

Module 16 · Capstones

Real-World Case Projects & Exam Prep

Combine formulas, cleanups, lookups, and summaries in end-to-end Finance, Hospital, Environmental, UFO, Wine, and Interview exams.

📂

Workbook not extracted yet

First save the attachment from David's email in Outlook, then extract the ZIP archive in File Explorer.

Remove Duplicates

To delete duplicate values, select one or more columns that contain duplicates.

Columns
Microsoft Excel
ℹ️

Insert Function
Conditional Formatting Rule
Create PivotTable
Rename Worksheet
O Outlook FULL SCREEN

Account Information

you@deskademy.co
Microsoft Exchange · Connected
Focused · By Date
🛡️ Report as Phishing
Report this message as a phishing attempt?

Reporting sends a copy of to your IT Security team and moves the message to your Junk Email folder.

💾 Save Attachment
Save in folder:
File name:
📎 Insert File — This PC
Look in:
🗂️ ×
🗜️ Compressed Folder Tools
FULL SCREEN
Name Size
· 1 item selected
🗜️ Extract Compressed (Zipped) Folders
Select a Destination and Extract Files

Files will be extracted to this folder:

W
✓ PDF Published () FULL SCREEN

Export

Create a PDF/XPS Document

  • Preserves layout, formatting, fonts, and images
  • Content cannot be easily changed
  • Free viewers are available on the web

Change File Type

Select a file type or export as PDF:

Save As

Save a copy of your document to this PC or export as a PDF:

Print

Document Information

Words
PDF Status
1·2·3·4·5·6
Page 1 of 1
Print Layout
📕 Publish as PDF or XPS
Save in:
File name:
Save as type:
Optimize for:
Workplace AI
Quick Beginner Guide

How to Use

%

Here is how your answer was marked:
Save My Progress (Free Account) →
Deskademy
Desktop Workspace Required

Desktop or Laptop Required

Our simulators replicate a real office working environment — complete with full Microsoft 365 ribbons, live Excel formula bars, multi-pane Outlook inboxes, Word page formatting, and Windows 11 File Explorer shortcuts.

Because these tasks require a physical keyboard and full desktop workspace, simulators cannot be opened or previewed on mobile devices. Please open this link on a desktop or laptop computer.

Simulated Desktop Environment
X Excel W Word O Outlook 📁 Files ✦ AI
Paid Plan Required

The Practice Library is a paid feature. Free and guest mode allows 1 test per app. Upgrade to Career Pro ($9/mo) or Bootcamp Pass ($49) to unlock all 50 skill topics, all 500+ repeated practice tests, 100 simulations, and official CV credentials.

Upgrade to Career Pro with PayPal ($9/mo) Compare All Plans ($9/mo & $49 Bootcamp)
Already have a paid account? Log in here