Microsoft Office Specialist (MOS) Exam Preparation: Word, Excel and PowerPoint
Knowing Office well and proving it under exam conditions are two different things.
About this course
Knowing Office well and proving it under exam conditions are two different things. This five-day course turns everyday experience with Word, Excel and PowerPoint into the precise, fast skills the Microsoft Office Specialist associate exams expect.
Each application is covered against the published exam objectives, with plenty of timed, project-based practice and clear feedback on common mistakes. Exam fees are separate and paid to the exam provider. You leave confident, well practised and ready to book your exams.
What you'll learn
- Understand the format, timing and project-based style of the MOS associate exams
- Manage documents and apply text, paragraph and section formatting in Word
- Insert and format tables, lists, references and graphic elements in Word
- Manage worksheets, cell ranges, tables and data in Excel
- Perform operations with formulas and functions and create charts in Excel
- Create and manage slides, text, graphics, tables, charts and media in PowerPoint
- Apply transitions and animations and prepare presentations for delivery
- Work quickly and accurately under timed exam conditions
Curriculum
- How MOS exams are structured
- Project-based tasks and scoring
- Time management strategies
- Setting up for practice
- Navigating within documents
- Formatting documents and sections
- Saving and sharing documents
- Inspecting documents for issues
- Inserting and replacing text
- Formatting text, paragraphs and styles
- Creating and modifying tables and lists
- References: footnotes, endnotes and tables of contents
- Inserting and formatting graphic elements
- Adding and managing comments
- Tracking changes
- Reviewing and accepting edits
- Managing workbooks and worksheets
- Importing and organising data
- Formatting cells and ranges
- Named ranges
- Creating and formatting tables
- Filtering and sorting data
- Relative, absolute and mixed references
- Calculating and transforming data with functions
- Formatting and modifying text with functions
- Creating charts
- Modifying chart elements
- Formatting charts
- Conditional formatting
- Modifying slide masters and layouts
- Configuring presentation options
- Inserting and arranging slides
- Formatting text
- Inserting and formatting images and shapes
- Inserting tables, charts and SmartArt
- Inserting and managing media
- Ordering and grouping objects
- Applying slide transitions
- Animating slide content
- Setting timing for transitions and animations
- Full practice exams for each application
- Reviewing common mistakes
- Final exam-readiness checklist
Who it's for
For regular Office users, administrators, students and job seekers who want to earn the Microsoft Office Specialist credential.
Before you start
- Regular hands-on use of Word, Excel and PowerPoint
Prepares for
Related courses
More in Microsoft Office & 365 Apps →55205 Mastering Microsoft Project 2016
Microsoft Office & 365 Apps
View course →55234 SharePoint 2016 Site Collections and Site Owner Administration
Microsoft Office & 365 Apps
View course →55238 SharePoint Online for Administrators
Microsoft Office & 365 Apps
View course →55301 Mastering Microsoft Project 2019
Microsoft Office & 365 Apps
View course →55342 Supporting and Troubleshooting Windows 11
Microsoft Office & 365 Apps
View course →Access - Customize Tables
Microsoft Office & 365 Apps
View course →Let's plan your next step together.
Tell us the course or certification you have in mind and we'll send the outline, upcoming dates, fees and private-team options.