SUM to sort and filter: the formulas and sheet skills every job expects on day one.
15 упражнений с автопроверкой в 6 темах, всего около 67 мин. Каждое открывает настоящую таблицу с реалистичными данными, проверяет результат и формулу и подсказывает, что исправить. Бесплатно, без регистрации.
Every beginner screening and the Microsoft Office Specialist Associate outline draw most of their items from this track: totals, counting, absolute references, percentages, number formats, freeze panes, sort and filter. It is also most of our free Level 1 test.
Six graded exercises on the functions behind every total and summary line. Each one runs on a realistic dataset of 48 to 80 rows, checks your result and your formula, and explains the fix when something is off.
Lock a rate or a price with $ so one formula fills down and across without breaking.
Share of total and year-over-year change, graded with the number format included.
Keep the header visible on a long export. The grader reads the sheet state, not a screenshot.
Merge a title across the report and wrap long header text; apply currency and date formats.
Sort by two columns and count the visible rows of a filtered list with SUBTOTAL.
9 упражнений из этого раздела
Day 1: the free timed test at your level. Days 2–6: three graded exercises a day. Day 7: retake it and compare.
2 упражнения из этого раздела
For analyst work and the Level 3 project test: summary grids, cleanup, expert lookups and pivot-style reports.
10 упражнений из этого раздела
For office and admin work: tidy exports, counts, IF rules, lookups, due dates and a tracker that rejects bad input.
3 упражнения из этого раздела
For AP/AR, bookkeeping and month-end work: tax lines, due dates, overdue invoices, SUMIFS by month and lookups.
14 упражнений из этого раздела
For complete beginners: from the first SUM to lookups, IF rules and a tidy tracker, in 14 short days of graded practice.
16 упражнений, около 96 мин
IF, AND, OR, COUNTIF, SUMIFS: decide and total by condition.
11 упражнений, около 77 мин
VLOOKUP, XLOOKUP, INDEX and MATCH: pull values from other tables and sheets.
9 упражнений, около 59 мин
Split, clean and join text; count days, deadlines and working days.
7 упражнений, около 56 мин
UNIQUE, FILTER, SORTBY, conditional formatting and data validation.
11 упражнений, около 91 мин
Pivot-style summaries with SUMIFS and GROUPBY, PivotTable screens, and picking, reading and fixing charts.
Бесплатно, без регистрации и без установки.
Excel — товарный знак группы компаний Microsoft. Indeed, TestGorilla, SHL, iMocha, Adaface, Criteria и другие товарные знаки принадлежат их владельцам. GridBelt — независимый проект: он не связан ни с одной из этих компаний, не одобрен и не спонсируется ими.