Перейти к содержимому
GridBelt
  • Тест по Excel
  • Упражнения
  • Программы
  • Цены
Войти
Начать бесплатный тест
  • Тест по Excel
  • Упражнения
  • Программы
  • Цены
ВойтиСоздать аккаунт
Начать бесплатный тест
GridBelt

Тренируйте навыки Excel прямо в браузере.

Тест по Excel

  • Уровень 1: Начальный
  • Уровень 2: Средний
  • Уровень 3: Продвинутый
  • Подготовка к тесту по Excel за 7 дней
  • Таблица лидеров
  • Тест по Excel на собеседовании
  • Тест по Excel от Indeed

Упражнения

  • Все упражнения
  • Программы
  • Для начинающих

Материалы

  • Формулы Excel
  • Горячие клавиши Excel

Компания

  • О проекте
  • Цены
  • Как мы проверяем

© GridBelt. Все права защищены.

  • Политика конфиденциальности
  • Условия использования
  • Политика возврата средств

Excel — товарный знак корпорации Microsoft. Indeed, TestGorilla, SHL и другие товарные знаки принадлежат их владельцам. GridBelt — независимый сайт для практики: он не связан с Microsoft, TestGorilla, SHL или Indeed, не одобрен и не спонсируется ими.

  1. Упражнения
  2. Программы

7-дневный план · бесплатно

Prepare for Your Excel Test in 7 Days

Day 1: take the free timed test at your level. Days 2–6: three graded exercises a day on the skills that test weighs most, about 15 to 30 minutes each. Day 7: retake the same test and compare your score and five sub-scores with Day 1. Free, no sign-up.

  • 7 дней
  • 15 упражнений с автопроверкой
  • 15–30 мин в день
  • Бесплатно, без регистрации
Посмотреть план уровня 1Какой уровень у моего теста? ↓

Текст программы на английском

How the week works

  1. T
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. T
Day 1
The free timed test at your level, taken once without preparing: your baseline.
Days 2–6
Three graded exercises a day on the skills that test weighs most.
Day 7
The same test again, compared with Day 1, sub-score by sub-score.

Which level is your test?

Each level mirrors a family of hiring tests (Level 2 covers two). Pick the one closest to yours; if you are not sure, start with Level 1.

  • 1

    План уровня 1: Начальный

    15 заданий · 12 мин · 15–16 мин в день

    Повторяет: Timed multiple-choice screening

    Дни практики

    1. День 2Averages, totals across sheets, text pieces
    2. День 3Lock a cell: a tax rate, shares, counts per status
    3. День 4Count and total: COUNT, SUMIF, SUBTOTAL on a filter
    4. День 5Number formats, a frozen header, the right chart
    5. День 6IF, merged titles, a chart's rows and columns
    Посмотреть план уровня 1 →
  • 2

    План уровня 2: Средний

    20 заданий · 25 мин · 16–30 мин в день

    Повторяет: Simulated spreadsheet test, Employer workbook test

    Дни практики

    1. День 2Joins and flags: other sheets, IF with AND, INDEX/MATCH
    2. День 3Lookups that hold up: bands, Not found, COUNTIFS
    3. День 4Summary grids and clean lists: SUMIFS, TRIM, UNIQUE
    4. День 5Rules and pivots: overdue flags, series, Count vs Sum
    5. День 6SUMPRODUCT, text dates and FILTER
    Посмотреть план уровня 2 →
  • 3

    План уровня 3: Продвинутый

    25 заданий · 50 мин · 19–30 мин в день

    Повторяет: MOS-style project exam

    Дни практики

    1. День 2Formats and rule formulas: highlights, input checks
    2. День 3Ordered rules, working days, clean names
    3. День 4Pivot-style tables and duplicates
    4. День 5PivotTable fields and two-key lookups
    5. День 6Ranked reports, text dates and a combo chart
    Посмотреть план уровня 3 →

How Day 1 and Day 7 work

Day 1 is your first attempt at the level's test, taken without preparing. Its score and five sub-scores show what to practice; the plan's days cover the skills the test weighs most.

Day 7 is a second attempt, compared with Day 1. Every attempt draws its tasks at random with new numbers (some tasks can come up again), and Levels 2 and 3 also draw their workbooks and projects at random, so a few points up or down is normal. Look at the sub-scores and at the tasks you now solve.

Чего пока нет

  • A specific employer's questions: test vendors keep their question banks private
  • Power Query, macros and VBA
  • Building PivotTables and charts by hand: the practice grid asks about pictured reports instead

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.

Ваш план работы над слабыми местами

Pro · Скоро

Every plan here is free and the same for everyone. When Pro opens, its weak-spot plan will rebuild the practice days of the 7-day plan from your own sub-scores and the tasks you missed. Pro is not on sale yet, and no program needs it.

Посмотреть, что войдёт в Pro

Пример

Вопросы о 7-дневном плане

Which level should I take on Day 1?

Take the level that matches the test you expect; the level cards above say which hiring tests each one resembles. If you are not sure, start with Level 1: it takes about 12 minutes, and at 70% or more the Level 2 plan fits you better.

How much time does the 7-day plan take each day?

Practice days take 15 to 16 minutes at Level 1, 16 to 30 at Level 2 and 19 to 30 at Level 3. The tests take about 12, 25 or 50 minutes. Estimates are for one attempt; a first try can take longer.

My test is in 3 days. What should I do?

Take the Day 1 test today, then do two practice days a day, starting with the days that cover your lowest sub-scores. If time runs out, skip the Day 7 retake: the test that counts is your employer's.

Will this plan get me through my employer's test?

No program can promise that: employers set their own pass marks and rarely publish them, and their questions differ from ours. The plan trains the skills timed Excel tests check most often and shows honestly how your score moves between Day 1 and Day 7.

What will the Pro weak-spot plan add?

The plans on this page are the same for everyone at a level. When Pro opens, the weak-spot plan will rebuild Days 2–6 from your own sub-scores and the tasks you missed. Pro is not on sale yet, and nothing in these plans needs it.

Другие программы

  • Excel for Data Analysts

    For analyst work and the Level 3 project test: summary grids, cleanup, expert lookups and pivot-style reports.

  • Excel for Administrative Assistants

    For office and admin work: tidy exports, counts, IF rules, lookups, due dates and a tracker that rejects bad input.

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

  • Learn Excel From Scratch

    For complete beginners: from the first SUM to lookups, IF rules and a tidy tracker, in 14 short days of graded practice.

Excel — товарный знак группы компаний Microsoft. Indeed, TestGorilla, SHL, iMocha, Adaface, Criteria и другие товарные знаки принадлежат их владельцам. GridBelt — независимый проект: он не связан ни с одной из этих компаний, не одобрен и не спонсируется ими.