Skip to content
GridBelt
  • Excel Test
  • Practice
  • Programs
  • Pricing
Sign in
Start the free test
  • Excel Test
  • Practice
  • Programs
  • Pricing
Sign inCreate account
Start the free test
GridBelt

Practice Excel in your browser.

Excel Test

  • Level 1: Beginner
  • Level 2: Intermediate
  • Level 3: Expert
  • Excel test in 7 days
  • Leaderboard
  • Excel test for interview
  • Indeed Excel assessment

Practice

  • All exercises
  • Programs
  • For beginners

Guides

  • Excel formulas
  • Excel shortcuts

Company

  • About
  • Pricing
  • How we grade

© GridBelt. All rights reserved.

  • Privacy Policy
  • Terms of Use
  • Refund Policy

Excel is a trademark of Microsoft Corporation. Indeed, TestGorilla, SHL and other marks are the property of their owners. GridBelt is an independent practice site and is not affiliated with, endorsed by or sponsored by Microsoft, TestGorilla, SHL or Indeed.

  1. Practice
  2. Programs

Program · 11 days · free

Excel for Administrative Assistants: an 11-Day Practice Program

30 graded exercises over 10 practice days, about 17 minutes a day, then the free 12-minute Level 1 test as the finish line. You make exports readable, count and total lists, write IF rules, look values up, tidy names and dates, and build a tracker that rejects bad input. Free, no sign-up.

  • 11 days
  • 30 graded exercises
  • 15–22 min a day
  • Final test: Level 1, 12 min
  • Free, no sign-up
Start Day 1

Free, no sign-up. Progress stays in this browser.

  1. 1 Day 1: First formulas: averages, a locked rate, days to a date
  2. 2 Day 2: Count what is in a list: COUNTIF and SUBTOTAL
  3. 3 Day 3: Rules in a cell: IF, AND and OR
  4. 4 Day 4: Totals: by region, across sheets, as shares
  5. 5 Day 5: Readable sheets: formats, a frozen header, a chart
  6. 6 Day 6: Names and codes: full names, a tier, SKU parts
  7. 7 Day 7: Reports: a two-level sort, a title, a PivotTable
  8. 8 Day 8: Clean lists: missing IDs, messy names, Not found
  9. 9 Day 9: Deadlines and contacts: due dates, working days
  10. P Day 10: Project day
  11. T Day 11: Test day

T: test day · P: project day

Finish line

Level 1 test · 15 tasks · about 12 min · a band from Needs practice to Expert

Each attempt draws its tasks at random, with new numbers, so some tasks can come up again; Levels 2 and 3 also draw their workbooks and projects at random.

No program can promise a pass: employers set their own pass marks and rarely publish them. Our bands and pass lines are our own cutoffs.

Is this for you?

Who it’s for

  • Office and admin assistants, executive assistants, receptionists and coordinators
  • Job seekers whose application includes a basic Excel screening test
  • You can type data and write a simple SUM; nothing else is assumed

You’ll be able to

  • Make an export readable: currency and date formats, a merged title, wrapped headers, a frozen header and a two-level sort
  • Count and total any list with COUNTIF, SUMIF, AVERAGE and a SUBTOTAL that follows the filter
  • Write IF rules with AND and OR, lock a rate with $ and pull values from another sheet with VLOOKUP
  • Tidy names, codes and dates: TRIM and PROPER, LEFT/MID/RIGHT, email domains, due dates and working days
  • Set up a tracker that rejects bad input: a drop-down list, a whole-number rule and an overdue highlight

Not covered yet

  • Mail merge, Word and Outlook
  • Printing, page setup and sheet protection
  • Building PivotTables and charts by hand: the grid asks about pictured reports instead
  • Excel tables (Ctrl+T), macros and Power Query

Day by day

11 days, 30 graded exercises. Minutes are estimates for one attempt; nothing locks, so go at your own pace.

✓ done · ◐ started · ○ to do

Days 1–5

  1. Day 1

    First formulas: averages, a locked rate, days to a date

    15 min

    AVERAGE, MIN and MAX, one tax rate locked with $ for every line, and the days left to a deadline.

    • AVERAGE, MIN and MAX of exam scores

      Beginner · 4 min

    • Apply one tax rate to every line ($ reference)

      Beginner · 5 min

    • Days to deadline and tenure in years (TODAY, DATEDIF)

      Beginner · 6 min

    • Excel shortcuts cheat sheet

      Reading, optional · 5 min

  2. Day 2

    Count what is in a list: COUNTIF and SUBTOTAL

    15 min

    Count numbers, names and blanks, count orders per status, and count only the rows a filter shows.

    • Count orders, names and blanks (COUNT, COUNTA, COUNTBLANK)

      Beginner · 4 min

    • Orders per status with COUNTIF

      Beginner · 5 min

    • Filter one region and count visible rows with SUBTOTAL

      Beginner · 6 min

  3. Day 3

    Rules in a cell: IF, AND and OR

    15 min

    Pass or fail with IF, a bonus that needs two conditions, and a free-shipping flag that needs one of two.

    • Pass or Fail with IF

      Beginner · 4 min

    • Bonus eligibility with IF and AND

      Beginner · 5 min

    • Free-shipping flag with IF and OR

      Beginner · 6 min

  4. Day 4

    Totals: by region, across sheets, as shares

    15 min

    Sales by region with SUMIF, a total across three sheets, and each region's share of the total as a percentage.

    • Sales by region with SUMIF

      Beginner · 5 min

    • Total across three regional sheets

      Beginner · 5 min

    • Share of total per region, formatted as %

      Beginner · 5 min

  5. Day 5

    Readable sheets: formats, a frozen header, a chart

    16 min

    Currency and date formats, a header row that stays in view, and the chart that fits each question.

    • Apply currency and date formats

      Beginner · 4 min

    • Freeze the header row of a long export

      Beginner · 3 min

    • Pick the right chart for each question

      Beginner · 9 min

Days 6–11

  1. Day 6

    Names and codes: full names, a tier, SKU parts

    15 min

    Join first and last names, look up a customer tier on another sheet, and cut a product code into its parts.

    • Full name with CONCAT or &

      Beginner · 4 min

    • Look up a customer tier from another sheet

      Beginner · 5 min

    • Extract category, year and serial from SKU

      Beginner · 6 min

  2. Day 7

    Reports: a two-level sort, a title, a PivotTable

    16 min

    Sort by region and then by sales, merge a report title, and read a PivotTable report correctly.

    • Sort by Region, then Sales descending

      Beginner · 4 min

    • Merge and center the title; wrap header text

      Beginner · 4 min

    • Read a PivotTable report and check one of its cells

      Beginner · 8 min

  3. Day 8

    Clean lists: missing IDs, messy names, Not found

    18 min

    Flag rows with missing data, clean padded names, and show Not found instead of #N/A.

    • Flag rows with missing data

      Intermediate · 5 min

    • Clean padded, lower-case names with TRIM and PROPER

      Intermediate · 6 min

    • Show "Not found" instead of #N/A

      Intermediate · 7 min

  4. Day 9

    Deadlines and contacts: due dates, working days

    20 min

    Invoice due dates at month end, working days to close a ticket, and the domain of each email address.

    • Invoice due dates with EOMONTH and EDATE

      Intermediate · 6 min

    • Working days to resolve tickets (NETWORKDAYS)

      Intermediate · 7 min

    • Split email into user and domain (FIND/LEFT/RIGHT or TEXTBEFORE/TEXTAFTER)

      Intermediate · 7 min

  5. Day 10

    Project day: a shared tracker nobody can break

    Project day · 22 min

    A drop-down list of approved regions, a rule that accepts whole quantities only, and an overdue highlight: a tracker colleagues can fill in safely.

    • Drop-down list of regions (data validation)

      Intermediate · 7 min

    • Restrict quantity to whole numbers 1–100

      Intermediate · 7 min

    • Highlight overdue invoices (conditional formatting)

      Intermediate · 8 min

  6. Day 11

    Final test: Level 1

    Final test · 12 min

    The free Level 1 test: 15 tasks with a 90-second limit each, about 12 minutes. Aim for the Highly proficient band, 80% or more.

    • Final test: Level 1 · 15 tasks · 12 min

      →
    • How we grade the test

      Reading, optional · 5 min

Questions about this plan

How long does Excel for Admin Assistants take?

11 days: 10 practice days of 15 to 22 minutes, then the 12-minute Level 1 test. Go at your own pace; nothing locks, and exercises you already solved count.

Do I need Excel experience for the admin program?

Only typing data into cells and a simple SUM. Day 1 starts with averages and a locked tax rate, and every exercise has hints and a worked solution.

Does Excel for Admin Assistants cover mail merge?

No. Mail merge runs in Word and Outlook, which the practice grid cannot open. The program covers the Excel side: clean names and emails, joined and split text, and lists ready to merge.

How do I know the admin program worked?

The finish line is the free Level 1 test: 15 tasks with a 90-second limit each. Aim for the Highly proficient band (80% or more). After it, the 7-day Level 2 plan is the natural next step.

Other programs

  • Prepare for your Excel test in 7 days

    Day 1: the free timed test at your level. Days 2–6: three graded exercises a day. Day 7: retake it and compare.

  • Excel for Sales and Marketing

    For sales and marketing ops: totals by region and rep, commission tiers, lookups, clean customer lists and live reports.

  • Excel for Accounting and Bookkeeping

    For AP/AR, bookkeeping and month-end work: tax lines, due dates, overdue invoices, SUMIFS by month and lookups.

Excel is a trademark of the Microsoft group of companies. Indeed, TestGorilla, SHL, iMocha, Adaface, Criteria and other marks are the property of their owners. GridBelt is independent and is not affiliated with, endorsed by or sponsored by any of them.