Pular para o conteúdo
GridBelt
  • Teste de Excel
  • Prática
  • Programas
  • Preços
Entrar
Começar o teste gratuito
  • Teste de Excel
  • Prática
  • Programas
  • Preços
EntrarCriar conta
Começar o teste gratuito
GridBelt

Pratique Excel no seu navegador.

Teste de Excel

  • Nível 1: Iniciante
  • Nível 2: Intermediário
  • Nível 3: Avançado
  • Teste de Excel em 7 dias
  • Ranking
  • Teste de Excel para entrevista
  • Avaliação de Excel da Indeed

Prática

  • Todos os exercícios
  • Programas
  • Para iniciantes

Guias

  • Fórmulas do Excel
  • Atalhos do Excel

Empresa

  • Sobre nós
  • Preços
  • Como corrigimos

© GridBelt. Todos os direitos reservados.

  • Política de Privacidade
  • Termos de Uso
  • Política de Reembolso

Excel é uma marca comercial da Microsoft Corporation. Indeed, TestGorilla, SHL e outras marcas pertencem aos seus respectivos proprietários. O GridBelt é um site de prática independente e não tem afiliação com Microsoft, TestGorilla, SHL ou Indeed, nem é endossado ou patrocinado por eles.

  1. Prática
  2. Programas

Programa · 11 dias · grátis

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 dias
  • 30 exercícios com correção
  • 15–22 min por dia
  • Teste final: nível 1, 12 min
  • Grátis, sem cadastro
Começar o dia 1

Grátis e sem cadastro. Seu progresso fica neste navegador.

Textos do programa em inglês

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

T: dia de teste · P: dia de projeto

Linha de chegada

Teste do nível 1 · 15 tarefas · cerca de 12 min · uma faixa entre Precisa praticar e Especialista

Cada tentativa sorteia as tarefas, com números novos, então algumas tarefas podem se repetir; nos níveis 2 e 3, as pastas de trabalho e os projetos também são sorteados.

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.

É para você?

Para quem é

  • 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

O que você vai conseguir fazer

  • 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

O que ainda não abordamos

  • 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

Dia a dia

11 dias, 30 exercícios com correção. Os minutos são estimativas para uma tentativa; nada fica bloqueado, então siga no seu ritmo.

✓ concluído · ◐ em andamento · ○ a fazer

Dias 1–5

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

      Iniciante · 4 min

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

      Iniciante · 5 min

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

      Iniciante · 6 min

    • Excel shortcuts cheat sheet

      Leitura opcional · 5 min

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

      Iniciante · 4 min

    • Orders per status with COUNTIF

      Iniciante · 5 min

    • Filter one region and count visible rows with SUBTOTAL

      Iniciante · 6 min

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

      Iniciante · 4 min

    • Bonus eligibility with IF and AND

      Iniciante · 5 min

    • Free-shipping flag with IF and OR

      Iniciante · 6 min

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

      Iniciante · 5 min

    • Total across three regional sheets

      Iniciante · 5 min

    • Share of total per region, formatted as %

      Iniciante · 5 min

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

      Iniciante · 4 min

    • Freeze the header row of a long export

      Iniciante · 3 min

    • Pick the right chart for each question

      Iniciante · 9 min

Dias 6–11

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

      Iniciante · 4 min

    • Look up a customer tier from another sheet

      Iniciante · 5 min

    • Extract category, year and serial from SKU

      Iniciante · 6 min

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

      Iniciante · 4 min

    • Merge and center the title; wrap header text

      Iniciante · 4 min

    • Read a PivotTable report and check one of its cells

      Iniciante · 8 min

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

      Intermediário · 5 min

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

      Intermediário · 6 min

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

      Intermediário · 7 min

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

      Intermediário · 6 min

    • Working days to resolve tickets (NETWORKDAYS)

      Intermediário · 7 min

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

      Intermediário · 7 min

  5. Dia 10

    Project day: a shared tracker nobody can break

    Dia de projeto · 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)

      Intermediário · 7 min

    • Restrict quantity to whole numbers 1–100

      Intermediário · 7 min

    • Highlight overdue invoices (conditional formatting)

      Intermediário · 8 min

  6. Dia 11

    Final test: Level 1

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

    • Teste final: nível 1 · 15 tarefas · 12 min

      →
    • How we grade the test

      Leitura opcional · 5 min

Perguntas sobre este plano

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.

Outros 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 é uma marca comercial do grupo de empresas Microsoft. Indeed, TestGorilla, SHL, iMocha, Adaface, Criteria e outras marcas pertencem aos seus respectivos proprietários. O GridBelt é independente e não tem afiliação com nenhum deles, nem é endossado ou patrocinado por eles.