Office skills test guides
What the tests cover, what to learn first, and how to get ready.
What's on an Excel skills test, and how to prepare
What employers usually test in an Excel skills assessment, from basic formulas to lookups and PivotTables, and how to practice before test day.
The Excel formulas to know before a job skills test
The Excel formulas that come up most in job skills tests, including SUM, IF, COUNTIF and VLOOKUP, with plain examples of what each one does.
What's on a Word skills test, and how to prepare
What a Word skills assessment usually covers, from formatting and styles to tables, Track Changes and mail merge, and how to practice for it.
What's on a PowerPoint skills test, and how to prepare
What a PowerPoint skills assessment usually asks for, including layouts, charts, Slide Master and animations, and how to practice before you take it.
What's on an Outlook skills test, and how to prepare
What an Outlook skills test usually covers, including email, rules, calendar invitations and contacts, and how to practice before your assessment.
What's on an Access skills test, and how to prepare
What an Access skills assessment usually covers, from tables and field types to queries, relationships, forms and reports, and how to practice for it.
The keyboard shortcuts to learn before an office skills test
The keyboard shortcuts worth learning before an office skills test, for Excel, Word, PowerPoint and Outlook, with what each one does and how to practice.
How to pass an office skills test: a 7-day plan
A simple 7-day plan to prepare for an office skills assessment, with what to practice each day and practical tips for test day.