Перейти к содержимому
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. Программы

Программа · 10 дней · бесплатно

Excel for Sales and Marketing: a 10-Day Practice Program

27 graded exercises over 9 practice days, about 22 minutes a day, then the free 25-minute Level 2 test as the finish line. You total and rank sales by region, product and rep, build commission tiers, look up prices, clean lead lists and produce live reports with FILTER and SORTBY. Free, no sign-up.

  • 10 дней
  • 27 упражнений с автопроверкой
  • 16–28 мин в день
  • Итоговый тест: уровень 2, 25 мин
  • 5 упражнений используют функции, которых нет в Excel 2019 и более ранних версиях
  • Бесплатно, без регистрации
Начать день 1

Бесплатно, без регистрации. Прогресс хранится в этом браузере.

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

  1. 1 День 1: Order boards and a price grid: COUNTIF, SUMIF, $
  2. 2 День 2: Flags and joins: IF with AND and OR, another sheet
  3. 3 День 3: Commission and rep results: tiers, SUMIFS, MAXIFS
  4. 4 День 4: Lookups beyond VLOOKUP: XLOOKUP, bands, INDEX/MATCH
  5. 5 День 5: Clean lead lists: names, email domains, customers
  6. 6 День 6: Highlights and shares: overdue, top 10%, % of total
  7. 7 День 7: Pivot-style reports: GROUPBY, Count vs Sum, series
  8. 8 День 8: Text dates, weighted totals, two-way lookups
  9. P День 9: День проекта
  10. T День 10: День теста

T: день теста · P: день проекта

Финиш

Тест уровня 2 · 20 заданий · 25 мин · наш проходной порог — 80%

В каждой попытке задания выбираются случайно, с новыми числами, поэтому некоторые могут повториться; на уровнях 2 и 3 рабочие книги и проекты тоже выбираются случайно.

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.

Подходит ли это вам?

Для кого

  • Sales operations, inside sales, account and marketing coordinators
  • People who work with order exports, pipelines, price lists and contact lists
  • Candidates facing an intermediate, SHL-style simulation test or a sales-ops interview task
  • You already use SUM, a simple IF and the $ sign

Вы сможете

  • Total, count and average by region, product, rep and stage with COUNTIF, SUMIF, SUMIFS, AVERAGEIFS and MAXIFS
  • Price and enrich orders with VLOOKUP, XLOOKUP, INDEX/MATCH, price bands and a two-way lookup
  • Clean lead and customer lists: TRIM and PROPER, email domains, one row per customer with UNIQUE
  • Build commission tiers, AND/OR flags and highlight rules for overdue invoices and the top 10%
  • Produce live reports: large orders with FILTER, products ranked with SORTBY, GROUPBY by region, the last order per account

Чего пока нет

  • CRM imports and Power Query
  • Dashboards with slicers and timelines, and charts built by hand
  • Forecasting (FORECAST, TREND), quota and territory models
  • Ad metrics such as cost per click and return on ad spend: marketing is covered as list hygiene and segment counts

По дням

10 дней, 27 упражнений с автопроверкой. Время примерное, в расчёте на одну попытку; ничего не блокируется, так что занимайтесь в своём темпе.

✓ выполнено · ◐ начато · ○ не начато

Дни 1–5

  1. День 1

    Order boards and a price grid: COUNTIF, SUMIF, $

    17 мин

    Orders per status, sales by region, and a price grid that copies across with mixed references.

    • Orders per status with COUNTIF

      Начальный · 5 мин

    • Sales by region with SUMIF

      Начальный · 5 мин

    • Price grid for quantities × discounts (mixed references)

      Начальный · 7 мин

    • Excel formulas cheat sheet

      Чтение, необязательно · 6 мин

  2. День 2

    Flags and joins: IF with AND and OR, another sheet

    16 мин

    A bonus flag that needs two conditions, free shipping that needs one of two, and a customer tier from another sheet.

    • Bonus eligibility with IF and AND

      Начальный · 5 мин

    • Free-shipping flag with IF and OR

      Начальный · 6 мин

    • Look up a customer tier from another sheet

      Начальный · 5 мин

  3. День 3

    Commission and rep results: tiers, SUMIFS, MAXIFS

    23 мин

    Commission tiers with nested IF, sales by region and product, and the average and largest deal per rep.

    • Commission tiers with nested IF, IFS or a lookup

      Средний · 8 мин

    • Sales by region and product with SUMIFS

      Средний · 7 мин

    • Average and largest deal per rep (AVERAGEIFS, MAXIFS)

      Средний · 8 мин

  4. День 4

    Lookups beyond VLOOKUP: XLOOKUP, bands, INDEX/MATCH

    19 мин

    XLOOKUP for an exact price, approximate-match shipping bands, and INDEX with MATCH.

    • Replace VLOOKUP with XLOOKUP

      Средний · 6 минExcel 365

    • Shipping cost bands with approximate VLOOKUP

      Средний · 7 мин

    • INDEX and MATCH exact lookup

      Средний · 6 мин

  5. День 5

    Clean lead lists: names, email domains, customers

    21 мин

    Padded and mis-cased names, the domain of each email, and one row per customer with UNIQUE.

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

      Средний · 6 мин

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

      Средний · 7 мин

    • List unique customers (UNIQUE) — remove duplicates

      Средний · 8 минExcel 365

Дни 6–10

  1. День 6

    Highlights and shares: overdue, top 10%, % of total

    23 мин

    Highlight overdue invoices and the top 10% of sales, then each channel's share of the grand total.

    • Highlight overdue invoices (conditional formatting)

      Средний · 8 мин

    • Highlight the top 10 % of sales

      Средний · 8 мин

    • Share of revenue by channel: % of Grand Total with formulas

      Средний · 7 мин

  2. День 7

    Pivot-style reports: GROUPBY, Count vs Sum, series

    25 мин

    A sales report by region with GROUPBY, a PivotTable that counts instead of sums, and chart series read both ways.

    • A pivot-style sales report by region with GROUPBY

      Средний · 6 минExcel 365

    • Fix a PivotTable that counts instead of sums

      Средний · 12 мин

    • Series or categories? Read a chart both ways and flip its table

      Средний · 7 мин

  3. День 8

    Text dates, weighted totals, two-way lookups

    28 мин

    Order dates typed as text turned into real dates, a weighted average price, and a monthly sales figure looked up by month and region.

    • Turn text dates into real dates and group by month

      Продвинутый · 12 мин

    • Weighted average price with SUMPRODUCT

      Продвинутый · 8 мин

    • Two-way lookup in a matrix

      Продвинутый · 8 мин

  4. День 9

    Project day: a live sales report

    День проекта · 28 мин

    A live list of large West orders with FILTER, products ranked with SORTBY, and the last order date per customer for a churn watch-list.

    • Orders over $1,000 in West with FILTER

      Продвинутый · 10 минExcel 365

    • Products ranked by sales with SORTBY

      Продвинутый · 8 минExcel 365

    • Last order date per customer

      Продвинутый · 10 мин

  5. День 10

    Final test: Level 2

    Итоговый тест · 25 мин

    The free Level 2 test: 20 tasks in 25 minutes. It draws 2 of 4 workbook families at random, so it may use other data than this program.

    • Итоговый тест: уровень 2 · 20 заданий · 25 мин

      →
    • How we grade the test

      Чтение, необязательно · 5 мин

Вопросы об этом плане

How long does Excel for Sales and Marketing take?

10 days: 9 practice days of 16 to 28 minutes (about 22 on average), then the 25-minute Level 2 test. Nothing locks, and exercises you already solved count.

What should I know before the sales program?

SUM, a simple IF and the $ sign. If those are new, start with the 7-day Level 1 plan or Learn Excel From Scratch.

Does Excel for Sales and Marketing cover dashboards?

Not as a dashboard tool. You build the formulas a sales dashboard runs on (totals by region, top products, the latest order per account, shares of the total) and read charts and PivotTables as pictured screens. Slicers and timelines are not covered.

How do I know the sales program worked?

The finish line is the free Level 2 test: 20 tasks in 25 minutes, with our pass line at 80%. No program can promise a pass: employers set their own pass marks, and our cutoffs are our own.

Do I need Excel 365 for the sales program?

Five exercises use newer functions: XLOOKUP, UNIQUE, FILTER and SORTBY need Excel 2021 or later, or Microsoft 365, and GROUPBY needs Microsoft 365. The practice grid runs them in your browser; Excel 2019 and older do not have them.

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

  • 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 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 — товарный знак группы компаний Microsoft. Indeed, TestGorilla, SHL, iMocha, Adaface, Criteria и другие товарные знаки принадлежат их владельцам. GridBelt — независимый проект: он не связан ни с одной из этих компаний, не одобрен и не спонсируется ими.