Vai al contenuto
GridBelt
  • Test Excel
  • Esercizi
  • Programmi
  • Prezzi
Accedi
Inizia il test gratuito
  • Test Excel
  • Esercizi
  • Programmi
  • Prezzi
AccediCrea un account
Inizia il test gratuito
GridBelt

Esercitati con Excel nel tuo browser.

Test Excel

  • Livello 1: Principiante
  • Livello 2: Intermedio
  • Livello 3: Esperto
  • Test Excel in 7 giorni
  • Classifica
  • Test Excel per il colloquio
  • Valutazione Excel di Indeed

Esercizi

  • Tutti gli esercizi
  • Programmi
  • Per principianti

Guide

  • Formule Excel
  • Scorciatoie Excel

Azienda

  • Chi siamo
  • Prezzi
  • Come valutiamo

© GridBelt. Tutti i diritti riservati.

  • Informativa sulla privacy
  • Termini di utilizzo
  • Politica di rimborso

Excel è un marchio di Microsoft Corporation. Indeed, TestGorilla, SHL e gli altri marchi appartengono ai rispettivi proprietari. GridBelt è un sito di esercitazione indipendente e non è affiliato a Microsoft, TestGorilla, SHL o Indeed, né approvato o sponsorizzato da queste società.

  1. Esercizi
  2. Programmi

Programma · 11 giorni · gratis

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 giorni
  • 30 esercizi con correzione
  • 15–22 min al giorno
  • Test finale: livello 1, 12 min
  • Gratis, senza registrazione
Inizia il giorno 1

Gratis, senza registrazione. I progressi restano in questo browser.

Testo del programma in inglese

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

T: giorno di test · P: giorno del progetto

Traguardo

Test di livello 1 · 15 attività · circa 12 min · una fascia da «Serve più pratica» a «Esperto»

Ogni tentativo estrae le attività a caso, con numeri nuovi, quindi alcune attività possono ripetersi; i livelli 2 e 3 estraggono a caso anche le cartelle di lavoro e i progetti.

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.

Fa per te?

Per chi è

  • 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

Cosa saprai fare

  • 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

Cosa non tratta ancora

  • 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

Giorno per giorno

11 giorni, 30 esercizi con correzione. I minuti sono una stima per un tentativo; non si blocca nulla, quindi procedi al tuo ritmo.

✓ fatto · ◐ iniziato · ○ da fare

Giorni 1–5

  1. Giorno 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

      Principiante · 4 min

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

      Principiante · 5 min

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

      Principiante · 6 min

    • Excel shortcuts cheat sheet

      Lettura facoltativa · 5 min

  2. Giorno 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)

      Principiante · 4 min

    • Orders per status with COUNTIF

      Principiante · 5 min

    • Filter one region and count visible rows with SUBTOTAL

      Principiante · 6 min

  3. Giorno 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

      Principiante · 4 min

    • Bonus eligibility with IF and AND

      Principiante · 5 min

    • Free-shipping flag with IF and OR

      Principiante · 6 min

  4. Giorno 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

      Principiante · 5 min

    • Total across three regional sheets

      Principiante · 5 min

    • Share of total per region, formatted as %

      Principiante · 5 min

  5. Giorno 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

      Principiante · 4 min

    • Freeze the header row of a long export

      Principiante · 3 min

    • Pick the right chart for each question

      Principiante · 9 min

Giorni 6–11

  1. Giorno 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 &

      Principiante · 4 min

    • Look up a customer tier from another sheet

      Principiante · 5 min

    • Extract category, year and serial from SKU

      Principiante · 6 min

  2. Giorno 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

      Principiante · 4 min

    • Merge and center the title; wrap header text

      Principiante · 4 min

    • Read a PivotTable report and check one of its cells

      Principiante · 8 min

  3. Giorno 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

      Intermedio · 5 min

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

      Intermedio · 6 min

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

      Intermedio · 7 min

  4. Giorno 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

      Intermedio · 6 min

    • Working days to resolve tickets (NETWORKDAYS)

      Intermedio · 7 min

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

      Intermedio · 7 min

  5. Giorno 10

    Project day: a shared tracker nobody can break

    Giorno del progetto · 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)

      Intermedio · 7 min

    • Restrict quantity to whole numbers 1–100

      Intermedio · 7 min

    • Highlight overdue invoices (conditional formatting)

      Intermedio · 8 min

  6. Giorno 11

    Final test: Level 1

    Test finale · 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.

    • Test finale: livello 1 · 15 attività · 12 min

      →
    • How we grade the test

      Lettura facoltativa · 5 min

Domande su questo piano

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.

Altri programmi

  • 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 è un marchio del gruppo di società Microsoft. Indeed, TestGorilla, SHL, iMocha, Adaface, Criteria e gli altri marchi appartengono ai rispettivi proprietari. GridBelt è indipendente: non è affiliato a nessuno di loro, né approvato o sponsorizzato da alcuno di essi.