Exam Preparation

Microsoft Office Specialist – Exam Preparation Course

Video preview
No available sessions at this moment.
Get in touch with our Training Advisior to find out about the next available sessions.
DownloadDownload Brochure

Course Overview

This course builds on the skills and concepts of Microsoft Office Suite (MS Word, MS Excel, MS PowerPoint, MS Outlook and MS OneNote). Students will learn how to navigate through the Microsoft Office ecosystem efficiently, and they will start working with intermediate to advanced functions, where they will focus on preparing projects, where they will start with MS Word which is mainly used for writing – where they will focus on preparing the drafts and reports of the project, after which they will start working on MS Excel which is mainly used for data analytics – where they will analyze all of the data related the project, after which the delegates will work with MS PowerPoint – which is mainly used for presentation – where they will prepare and present the findings, finally the participants will work with MS Outlook – which is the emailing system of Microsoft where the participants will understand how to submit their projects.

Key Takeaways

The participants will learn how to work more collaboratively and more effectively using a suite of productivity-enhancing applications.
Create and maintain professional-looking reports, multi-column newsletters, résumés, and business correspondence.
Create a spreadsheet, work with formulas and functions, make your spreadsheets look professional, and print a spreadsheet.
The participants will learn how to create, save, and present a basic presentation; apply the basics of formatting; and add multimedia to a presentation.

Brand Logo
At Skillsoft, we believe every individual has the poten-tial to be amazing. Our vision is to unleash that poten-tial through the power of learning. As the world’s largest provider of professional digital learning, Skill-soft delivers:
• Online learning that includes a broad catalogue of in-demand topics, built with deep expertise in the subject matter and scientifically proven learning science;
• Engaging learning experiences ranging from micro-learning to complete journeys and professional certifications that have impacted nearly half a billion people worldwide and certified more IT professionals than any firm on the planet; and
• A powerful, flexible, and engaging cloud-native plat-form designed to seamlessly integrate both with lead-ing HCM solutions and the natural flow of work.
Unlike other providers, Skillsoft is inclusive, with learning options for all. Our effectiveness, variety and global reach are unmatched.

Course Outline

Day 1 – MS Excel
Unit 1: Pivot Tables and Pivot charts

Topic A: Working with PivotTables
Topic B: Rearranging PivotTables
Topic C: Formatting PivotTables
Topic D: Using Pivot Charts

Unit 2: Cell And Range Names

Topic A: Creating and using names
Topic B: Managing names

Unit 3: Advanced Formatting

Topic A: Using special number formats
Topic B: Using functions to format text
Topic C: Working with styles
Topic D: Working with themes
Topic E: Other advanced formatting

Unit 4: Macros and Custom Functions

Topic A: Running and recording a macro
Topic B: Working with VBA code
Topic C: Creating functions

Unit 5: Logical And Statistical Functions

Topic A: Logical functions
Topic B: Math and statistical functions

Unit 6: Financial And Date Functions

Topic A: Financial functions
Topic B: Date and time functions
Topic C: Array formulas
Topic D: Displaying and printing formulas

Unit 7: Advanced Data Management

Topic A: Validating cell entries
Topic B: Exploring database functions

Day 2 – MS Excel
Unit 8: Lookups and Data Tables

Topic A: Using lookup functions
Topic B: Using MATCH and INDEX
Topic C: Creating data tables

Unit 9: Advanced Charting

Topic A: Chart formatting options
Topic B: Combination charts
Topic C: Graphical elements

Unit 9: Organizing items

Topic A: Folders & Rules
Topic B: Basic & Advanced Search
Topic C: Filtering
Topic D: Categories

Unit 10: Mailbox management

Topic A: Managing your mailbox
Topic B: Archiving your mail

Unit 11: Sharing Calendars and contacts

Topic A: share your calendar
Topic B: Share your contacts
Topic C: Delegate Access to Outlook Folders

Unit 12: Mail merges and templates

Topic A: Performing mail merges
Topic B: Working with templates

Day 3 – MS PPT
Unit 1: Getting Started with PowerPoint

Topic A: Navigate the PowerPoint Environment
Topic B: Create and Save a Presentation
Topic C: Use Help

Unit 2: Developing a PowerPoint Presentation

Topic A: Select a Presentation Type
Topic B: View and Navigate a Presentation
Topic C: Edit Text
Topic D: Build a Presentation

Unit 3: Customizing Design Templates

Topic A: Modify Slide Masters and Slide Layouts
Topic B: Add Headers and Footers
Topic C: Modify the Notes Master and the Handout Master

Unit 4: Adding Graphical Elements to Your Presentation

Topic A: Insert Clip Art and Images
Topic B: Insert Shapes

Unit 5: Adding Tables to Your Presentation

Topic A: Create a Table
Topic B: Format a Table
Topic C: Insert a Table from Other Microsoft Office Applications

Unit 6: Adding Charts to Your Presentation

Topic A: Create a Chart
Topic B: Format a Chart
Topic C: Insert a Chart from Microsoft Excel

Unit 7: Preparing to Deliver Your Presentation

Topic A: Review Your Presentation
Topic B: Apply Transitions
Topic C: Print Your Presentation
Topic D: Deliver Your Presentation

Unit 8: Modifying the PowerPoint Environment

Topic A: Customize the User Interface
Topic B: Set PowerPoint 2013 Options

Unit 9: Adding SmartArt to a Presentation

Topic A: Create SmartArt
Topic B: Modify SmartArt

Day 4 – MS Word
Unit 1: Styles and Outlines

Topic A: Examining formatting
Topic B: Creating styles
Topic C: Modifying styles
Topic D: Working with outlines

Unit 2: Sections and Columns

Topic A: Creating and formatting sections
Topic B: Working with columns

Unit 3: Templates and Building Blocks

Topic A: Template basics
Topic B: Building blocks
Topic C: Document properties

Unit 4: Using Mail Merge

Topic A: Form letters
Topic B: Data sources for the recipient list
Topic C: Mailing labels and envelope

Unit 5: Using macros

Topic A: Recording and running macros
Topic B: Modifying and deleting macros

Unit 6: Working with forms

Topic A: Creating forms
Topic B: Protecting forms
Topic C: Sharing and securing documents

Unit 7: Customizing Word

Topic A: Customizing the Ribbon
Topic B: Customizing the Quick Access toolbar
Topic C: Customizing keyboard shortcuts

Unit 8: Long documents

Topic A: Master documents
Topic B: Tables of contents and figures
Topic C: Indexes, bibliographies, and other references
Topic D: Bookmarks and cross-references
Topic E: Web frames

Day 5 – MS Outlook
Unit 1: Getting started

Topic A: The program window
Topic B: Outlook Today
Topic C: Getting help

Unit 2: E-mail management

Topic A: Setting message options
Topic B: Managing junk e-mail
Topic C: Using Search folders
Topic D: Printing messages and attachments

Unit 3: Customizing messages

Topic A: Message appearance
Topic B: Signatures
Topic C: Voting buttons
Topic D: Out-of-office messages

Unit 4: Contacts

Topic A: Working with contacts
Topic B: Using contact groups
Topic C: Using the People Pane

Unit 5: Tasks

Topic A: Working with tasks
Topic B: Managing tasks

Unit 6: Appointments and events

Topic A: Creating and sending appointments
Topic B: Modifying appointments
Topic C: Working with events
Topic D: Using Calendar views

Unit 7: Meeting requests and responses

Topic A: Scheduling meetings
Topic B: Managing meetings

Unit 8: Customizing Outlook

Topic A: The Outlook environment
Topic B: General options
Topic C: Language and keyboard options
Topic D: Quick Steps
Topic E: The Navigation pane

Unit 9: Organizing items

Topic A: Folders & Rules
Topic B: Basic & Advanced Search
Topic C: Filtering
Topic D: Categories

Unit 10: Mailbox management

Topic A: Managing your mailbox
Topic B: Archiving your mail

Unit 11: Sharing Calendars and contacts

Topic A: share your calendar
Topic B: Share your contacts
Topic C: Delegate Access to Outlook Folders

Unit 12: Mail merges and templates

Topic A: Performing mail merges
Topic B: Working with templates

Day 5 – MS One note
Unit 1: Getting Started with Onenote

Topic A: Navigate the OneNote 2016 Environment
Topic B: Use Templates
Topic C: Customize the OneNote User Interface

Unit 2: Adding and Formatting Notebook Content

Topic A: Apply Formatting to Notebook Content
Topic B: Insert Images and Audio into a Notebook
Topic C: Add Quick Notes and Links
Topic D: Use Drawing Tools

Unit 3: Embedding and Attaching Files

Topic A: Embed Excel Spreadsheets
Topic B: Attach Other File Types

Unit 4: Organizing and Searching Notebooks

Topic A: Use Tags
Topic B: Organize and Search Notebooks

Unit 5: Finalizing a Notebook

Topic A: Proof and Print a Notebook
Topic B: Configure Password Protection and Notebook Properties

Unit 6: Managing Notebook Files

Topic A: Export Content from OneNote Notebooks
Topic B: Back Up and Restore Notebook Content

Unit 7: Sending and Sharing One note content

Topic A: Send OneNote Content in Other Formats
Topic B: Share OneNote Content by Using OneDrive

Who Should Attend?

This highly practical and interactive course has been specifically designed for
This course is intended for every modern day professional who wishes to get a better understanding on the Microsoft Office package, through which will utilize fully the functions of the Microsoft Ecosystem.

Related Courses


What language will the course be taught in and what level of English do I need to take part in an LEORON training program?
Most of our public courses are delivered in English language. You need to be proficient in English to be able to fully participate in the workshop and network with other delegates. For in-house courses we have the capability to train in Arabic, Dutch, German and Portuguese.
Are LEORON Public courses certified by an official body/organization?
LEORON Institute partners with 20+ international bodies and associations.We also award continuing professional development credits (CPE/PDUs) for:1. NASBA (National Association of State Boards of Accountancy) 2. Project Management Institute PDUs 3. CISI credits 4. GARP credits 5. HRCI recertification credits 6. SHRM recertification credits
What is the deadline for registering to a public course?
The deadline to register for a public course is 14 days before the course starts. Kindly note that occasionally we do accept late registrations as well, but this needs to be confirmed with the project manager of the training program or with our registration desk that can be reached at +91 4 95 5711 or
What does the course fee cover?
The course fee covers a premium training experience in a 5-star hotel, learning materials, lunches & refreshments, and for some courses, the certification fee and membership with the accrediting bodies.
Does LEORON give discounts?
Yes, we can provide discounts for group bookings. If you would like to discuss a discount on a corporate level, we will be happy to talk to you.