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

What to Expect on an Employer's Excel Workbook Test (Analyst, FP&A, Admin)

For analyst, FP&A, pricing, operations and office roles, the Excel test is usually not a vendor product but a workbook the team built: a few sheets of raw data, a list of questions, and 20 to 60 minutes to answer them in your own Excel, sometimes while sharing your screen. Finance roles stretch the same idea to one-to-three-hour modeling tests and take-home cases. There is no published rubric; graders look for accuracy first, then completeness, then structure, then formatting.

Datos del formato

Time
Most analyst screens run 20–60 minutes (Interview Query, May 2026). Live screen-share tests of about 30 minutes and emailed one-hour assignments are common; investment-banking and private-equity modeling tests run 1–3 hours; take-home cases are due in 24–72 hours and take 4–8 hours of work.
Material
One workbook or several CSV files: transactions, a lookup table (products, customers, regions), sometimes a half-built summary sheet. Data is deliberately imperfect.
Tasks
A handful of written questions. Recurring ones: join the tables, total by category and period, clean the dates, remove duplicates, build a summary or PivotTable, chart one series, and write two or three sentences on what the numbers mean.
Tools
Your Excel (or Google Sheets), occasionally the employer's laptop. Finance teams expect Windows Excel and keyboard speed; some forbid macros.
Grading
No published rubric. The order graders describe: accuracy (does the balance sheet balance, do the totals tie), completeness, model or sheet structure, formatting. Training vendors report median scores below 50% on timed modeling tests.
Follow-up
Expect to explain the result: a written answer box, a verbal walk-through on the call, or a presentation of a take-home. The right number without the reasoning scores poorly.

¿Qué preguntan?

Across analyst guides, Big Four and bank interview reports, the same seven tasks appear. Candidate reports from EY, J.P. Morgan and Deloitte name SUMIF, VLOOKUP and COUNTIF and a one-hour live finance case; data-analyst guides add pivot summaries, date standardization and QA checks.

  • Lookups and joins

    Bring the product category or customer segment onto the transactions with VLOOKUP, XLOOKUP or INDEX and MATCH, and check the key for duplicates first.

    Practicar: Replace VLOOKUP with XLOOKUP
  • Criteria sums and counts

    Revenue by region and month, orders above a threshold, conversion rates per channel: SUMIFS and COUNTIFS, sometimes AVERAGEIFS.

    Practicar: Sales by region and product with SUMIFS
  • Flags with IF

    Late deliveries, margins below target, eligibility rules: IF with AND or OR, IFERROR around divisions.

    Practicar: Bonus eligibility with IF and AND
  • PivotTable summary

    Sales by rep by quarter, grouped rates, a top-10 list. Build it, or rebuild it with formulas when the test forbids PivotTables.

    Practicar: Pivot without a pivot: revenue by category and month with SUMIFS
  • Date cleanup

    Dates stored as text in two formats, month and year columns, working days between two dates.

    Practicar: Turn text dates into real dates and group by month
  • Duplicates, blanks and categories

    Remove duplicate rows, treat "N/A" and blanks consistently, unify "West" and "west ".

    Practicar: List unique customers (UNIQUE) — remove duplicates
  • Percentages and a chart

    Share of total, growth versus last year, a column or line chart of one series with a sensible title.

    Practicar: Year-over-year % change

¿Cómo me preparo?

Speed on messy data is the whole skill. Practise on datasets with dirt in them, keep a QA habit (totals, duplicate keys, impossible values), and rehearse saying what a number means in one sentence.

  1. 1

    Do the lookups track: exact and approximate VLOOKUP, XLOOKUP, INDEX and MATCH, and the #N/A handling exercise. Then practise counting duplicates on the key before any join.

    Practicar: VLOOKUP
  2. 2

    Do the SUMIFS and COUNTIFS exercises with two and three criteria.

    Practicar: SUMIF and SUMIFS
  3. 3

    Rebuild a PivotTable with formulas, the way out when the test says formulas only: a category-by-month grid with one SUMIFS, then a summary by region with GROUPBY in Excel 365.

    Practicar: Pivot tables
  4. 4

    Work the text and date exercises: text to real dates, EOMONTH due dates, NETWORKDAYS, split and trim names.

    Practicar: Date functions
  5. 5

    Do the UNIQUE and FILTER exercises and the conditional-formatting rules for overdue items.

    Practicar: Remove duplicates
  6. 6

    Time yourself. Give every practice session a clock of 20 minutes for five tasks, and write one line of interpretation under each answer, as if the grader will read it.

  7. 7

    Learn the keyboard moves that finance tests assume: Ctrl + Shift + Arrow to select, F4 to lock a reference, F2 to edit, Alt + = for AutoSum, Ctrl + 1 for the format dialog.

Our Level 2 test puts 20 tasks into two business workbooks of two to three sheets with one 25-minute clock, the closest free rehearsal for this family.

  • Prepárate en 7 días: el plan del nivel 2 →
  • Practica para el trabajo: Excel for Data Analysts →
  • Practica para el trabajo: Excel for Accounting and Bookkeeping →
Hacer la prueba gratuita de nivel 2

¿Qué errores restan puntos?

  • Row multiplication from a join

    A lookup key that appears twice in the reference table doubles every matching row. Analyst guides call it the hidden risk; count the key with COUNTIF before you join, and compare totals before and after.

  • The denominator is wrong

    "Most spreadsheet mistakes are really filtering mistakes": a rate computed over all rows when the question asked about one region, or over filtered rows when it asked about all.

  • Running out of time

    Candidates report tests that took two to three hours when the email said 30 to 60 minutes. Answer every question roughly first, then refine; a blank question scores nothing.

  • Hard-coded values

    A total typed in, a tax rate inside a formula, a copied number instead of a link: graders check formulas, and a number nobody can trace fails the accuracy test.

  • Over-building and over-formatting

    A full three-statement model when a growth table was asked for, colours and borders before the numbers are right. Structure and formatting rank after accuracy and completeness.

  • Not reading the prompt

    Modeling-test guides list "did not read the prompt" next to hard-coding as the most common failure: wrong period, wrong unit, wrong definition of margin.

Preguntas que hacen los candidatos

How long is an Excel test for an analyst interview?

Most are 20–60 minutes. Live screen-share versions run about 30 minutes; emailed assignments are often an hour; investment-banking and private-equity modeling tests run one to three hours; take-home cases give you 24–72 hours for four to eight hours of work.

How is it graded?

Against the team's own answer key, in roughly this order: accuracy, completeness, structure, formatting. Interview guides for banks say balance sheets that do not balance and hard-coded numbers are the most damaging errors, and that reasoning is weighed as heavily as the final numbers.

Do I need PivotTables?

Often, yes, for a summary by category and period. Know how to build one and how to produce the same table with SUMIFS and COUNTIFS when the test says formulas only.

Can I use Google Sheets?

Only if the employer offers it. Finance teams expect Excel on Windows and keyboard speed; data teams are often flexible. Ask before the test, not during it.

Will I have to explain my answers?

Usually. Expect a written-answer cell or a conversation about why you chose a method and what the number means for the business. Practise saying it in one or two sentences.

Los otros formatos de prueba

FormatoDuración y extensiónCómo es
  • Timed multiple-choice screening

    TestGorilla-style, iMocha, Adaface, Mettl, Testlify

    10–30 minutes 10–30 questions

    One question per screen with a clock, usually no going back. The first filter after the CV.

    Qué esperar de esta prueba
  • Simulated spreadsheet test

    SHL-type, eSkill, Criteria Interactive, Testlify, Vervoe

    25–35 minutes 20–30 tasks

    A mock Excel window with a task under it. One attempt per task, graded on the end result, some shortcuts switched off.

    Qué esperar de esta prueba
  • MOS-style project exam

    Microsoft Office Specialist exams MO-210 and MO-211 (Certiport)

    50 minutes 23–37 tasks

    Several projects in live Excel, each a workbook with 4–7 tasks. Scored 1–1000, 700 to pass.

    Qué esperar de esta prueba

Pruébalo en una hoja de cálculo real

Gratis, sin cuenta y sin instalar nada.

Hacer la prueba gratuita de nivel 2Ver ejercicios de práctica

Facts checked on November 15, 2026 against Interview Query's data-analyst Excel assessment guide (May 1, 2026), investment-banking modeling-test guides (updated November 3, 2026), Mergers & Inquisitions on timed LBO tests, the AFP's FP&A case-interview article (updated May 7, 2024), and candidate interview reports for EY, Deloitte and J.P. Morgan. Employers do not publish rubrics; the grading order is how those guides describe it.

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.