Office Apps and Data
Tests on Excel, Microsoft Word, and data entry: formulas and pivot tables, document styles and layout, accurate input and checks.
The everyday toolkit of office work. Spreadsheets hold numbers and lists, documents hold contracts and letters, and data entry keeps both clean enough to trust.
Three topics, three levels each. Beginner covers what a new employee does on the first day, intermediate covers routine reports and documents, advanced covers tasks that save a team hours.
Topics
Tests
Bulk imports and test loads, reconciling counts and control totals, encodings and data types, splitting fields, international formats, sampling, bulk corrections, incidents, and retention of personal data.
Double entry and check digits, correcting records with history, normalizing formats, duplicates, sorting and validation lists, error rates, conflicting source values, and handling personal data.
Reading source documents, standard formats for dates, codes, and phones, common keying errors, batch control, spreadsheet input, and keeping data private at the desk.
Tracked changes and restricted editing, mail merge rules and field formats, templates and Normal, navigation and table of contents settings, section numbering, linked tables, Combine, forms, and bookmarks with REF fields.
Heading styles and an automatic table of contents, multilevel numbering, sections and orientation, tables and pictures, captions, Inspect Document, Compare, fields, and mail merge.
Text and paragraph formatting, lists, page breaks and margins, headers and page numbers, tables, and saving as PDF.
INDEX and MATCH, XLOOKUP search modes, dynamic arrays, SUMPRODUCT and date conditions, data validation and cleanup, Power Query, and reports that survive new data.
Lookups with VLOOKUP and XLOOKUP, SUMIFS and COUNTIF, text and dates, conditional formatting, Excel tables, and pivot tables.
Formulas and cell references, copying formulas, common errors, sorting and filters, basic counting functions, and picking a chart.
Закрытие месяца и реформация баланса, дата запрета изменений, поиск расхождений с банком и поставщиками, экспресс-проверка, корректировка реализации, порядок документов во времени, учётная политика, амортизация и права пользователей.
Загрузка банковских выписок и договоры в оплатах, УПД и счета-фактуры, отчёты по счетам 62 и 51, возвраты, дубли контрагентов, акт сверки, сальдо по счёту 60, проведение нескольких документов сразу и отборы в журналах.
Справочники контрагентов и номенклатуры, «Записать» и «Провести», пометка на удаление, проводки документа, оплата от покупателя, выдача наличных под отчёт, копирование документов и ОСВ.