Saltar al contenido
GridBelt
  • Prueba de Excel
  • Práctica
  • Programas
  • Precios
Iniciar sesión
Empezar la prueba gratuita
  • Prueba de Excel
  • Práctica
  • Programas
  • Precios
Iniciar sesiónCrear cuenta
Empezar la prueba gratuita
GridBelt

Practica Excel en tu navegador.

Prueba de Excel

  • Nivel 1: Principiante
  • Nivel 2: Intermedio
  • Nivel 3: Experto
  • Prueba de Excel en 7 días
  • Clasificación
  • Prueba de Excel para entrevistas
  • Evaluación de Excel de Indeed

Práctica

  • Todos los ejercicios
  • Programas
  • Para principiantes

Guías

  • Fórmulas de Excel
  • Atajos de Excel

Empresa

  • Acerca de
  • Precios
  • Cómo corregimos

© GridBelt. Todos los derechos reservados.

  • Política de privacidad
  • Términos de uso
  • Política de reembolso

Excel es una marca comercial de Microsoft Corporation. Indeed, TestGorilla, SHL y otras marcas son propiedad de sus respectivos titulares. GridBelt es un sitio de práctica independiente y no está afiliado a Microsoft, TestGorilla, SHL ni Indeed, ni respaldado ni patrocinado por ellos.

  1. Práctica
  2. Programas

Programa · 11 días · 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 días
  • 30 ejercicios con corrección
  • 15–22 min al día
  • Prueba final: nivel 1, 12 min
  • Gratis, sin registro
Empezar el día 1

Gratis, sin registro. Tu progreso se guarda en este navegador.

Contenido del programa en inglés

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

T: día de prueba · P: día de proyecto

La meta

Prueba del nivel 1 · 15 tareas · unos 12 min · una categoría entre Necesita práctica y Experto

Cada intento elige sus tareas al azar, con números nuevos, así que algunas tareas pueden repetirse; los niveles 2 y 3 también eligen al azar sus libros y proyectos.

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.

¿Es para ti?

Para quién es

  • 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

Lo que podrás hacer

  • 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

Lo que aún no cubre

  • 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

Día a día

11 días, 30 ejercicios con corrección. Los minutos son una estimación para un intento; nada se bloquea, así que avanza a tu ritmo.

✓ hecho · ◐ empezado · ○ pendiente

Días 1–5

  1. Día 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

      Lectura opcional · 5 min

  2. Día 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. Día 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. Día 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. Día 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

Días 6–11

  1. Día 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. Día 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. Día 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. Día 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. Día 10

    Project day: a shared tracker nobody can break

    Día de proyecto · 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. Día 11

    Final test: Level 1

    Prueba 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.

    • Prueba final: nivel 1 · 15 tareas · 12 min

      →
    • How we grade the test

      Lectura opcional · 5 min

Preguntas sobre este 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.

Otros programas

  • 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 es una marca comercial del grupo de empresas Microsoft. Indeed, TestGorilla, SHL, iMocha, Adaface, Criteria y otras marcas son propiedad de sus respectivos titulares. GridBelt es independiente y no está afiliado a ninguno de ellos, ni respaldado ni patrocinado por ellos.