Aller au contenu
GridBelt
  • Test Excel
  • Exercices
  • Programmes
  • Tarifs
Se connecter
Commencer le test gratuit
  • Test Excel
  • Exercices
  • Programmes
  • Tarifs
Se connecterCréer un compte
Commencer le test gratuit
GridBelt

Entraînez-vous sur Excel dans votre navigateur.

Test Excel

  • Niveau 1 : Débutant
  • Niveau 2 : Intermédiaire
  • Niveau 3 : Expert
  • Test Excel en 7 jours
  • Classement
  • Test Excel en entretien d’embauche
  • Évaluation Excel d’Indeed

Exercices

  • Tous les exercices
  • Programmes
  • Pour débutants

Guides

  • Formules Excel
  • Raccourcis Excel

Entreprise

  • À propos
  • Tarifs
  • Comment nous corrigeons

© GridBelt. Tous droits réservés.

  • Politique de confidentialité
  • Conditions d’utilisation
  • Politique de remboursement

Excel est une marque commerciale de Microsoft Corporation. Indeed, TestGorilla, SHL et les autres marques sont la propriété de leurs détenteurs respectifs. GridBelt est un site d’entraînement indépendant ; il n’est affilié ni à Microsoft, ni à TestGorilla, ni à SHL, ni à Indeed, et n’est ni cautionné ni sponsorisé par ces sociétés.

  1. Exercices
  2. Programmes

Programme · 11 jours · gratuit

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 jours
  • 30 exercices corrigés
  • 15–22 min par jour
  • Test final : niveau 1, 12 min
  • Gratuit, sans inscription
Commencer le jour 1

Gratuit, sans inscription. Votre progression reste dans ce navigateur.

Texte du programme en anglais

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

T : jour de test · P : jour de projet

Ligne d’arrivée

Test de niveau 1 · 15 tâches · environ 12 min · un palier de « Besoin d’entraînement » à « Expert »

Chaque tentative tire ses tâches au hasard, avec de nouveaux nombres, donc certaines tâches peuvent revenir ; les niveaux 2 et 3 tirent aussi au sort leurs classeurs et leurs projets.

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.

Est-ce fait pour vous ?

Pour qui

  • 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

Vous saurez

  • 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

Pas encore couvert

  • 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

Jour par jour

11 jours, 30 exercices corrigés. Les durées sont estimées pour une tentative ; rien n’est verrouillé, avancez donc à votre rythme.

✓ terminé · ◐ commencé · ○ à faire

Jours 1–5

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

      Débutant · 4 min

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

      Débutant · 5 min

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

      Débutant · 6 min

    • Excel shortcuts cheat sheet

      Lecture facultative · 5 min

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

      Débutant · 4 min

    • Orders per status with COUNTIF

      Débutant · 5 min

    • Filter one region and count visible rows with SUBTOTAL

      Débutant · 6 min

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

      Débutant · 4 min

    • Bonus eligibility with IF and AND

      Débutant · 5 min

    • Free-shipping flag with IF and OR

      Débutant · 6 min

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

      Débutant · 5 min

    • Total across three regional sheets

      Débutant · 5 min

    • Share of total per region, formatted as %

      Débutant · 5 min

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

      Débutant · 4 min

    • Freeze the header row of a long export

      Débutant · 3 min

    • Pick the right chart for each question

      Débutant · 9 min

Jours 6–11

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

      Débutant · 4 min

    • Look up a customer tier from another sheet

      Débutant · 5 min

    • Extract category, year and serial from SKU

      Débutant · 6 min

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

      Débutant · 4 min

    • Merge and center the title; wrap header text

      Débutant · 4 min

    • Read a PivotTable report and check one of its cells

      Débutant · 8 min

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

      Intermédiaire · 5 min

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

      Intermédiaire · 6 min

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

      Intermédiaire · 7 min

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

      Intermédiaire · 6 min

    • Working days to resolve tickets (NETWORKDAYS)

      Intermédiaire · 7 min

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

      Intermédiaire · 7 min

  5. Jour 10

    Project day: a shared tracker nobody can break

    Jour de projet · 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)

      Intermédiaire · 7 min

    • Restrict quantity to whole numbers 1–100

      Intermédiaire · 7 min

    • Highlight overdue invoices (conditional formatting)

      Intermédiaire · 8 min

  6. Jour 11

    Final test: Level 1

    Test final · 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 final : niveau 1 · 15 tâches · 12 min

      →
    • How we grade the test

      Lecture facultative · 5 min

Questions sur ce 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.

Autres programmes

  • 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 est une marque commerciale du groupe de sociétés Microsoft. Indeed, TestGorilla, SHL, iMocha, Adaface, Criteria et les autres marques sont la propriété de leurs détenteurs respectifs. GridBelt est indépendant : il n’est affilié à aucun d’entre eux, et aucun d’entre eux ne le cautionne ni ne le sponsorise.