Earning MOS certification validates that you have the expertise to work with Microsoft Office programs. Companies that have hired MOS certified candidates have found better performance, competence and increased productivity.

 

Since MOS certification has become an employee selection and hiring criteria, it is now a must for individuals considering this IT field as their career paths. The 2-week training program offered in London Waterloo Academy is instructor-led, hands-on, with unlimited practice hours and a practice test that mocks the real exam.

 

Microsoft Office Specialist Course Content 

·         Lesson 1

·  Microsoft Office Word 2007
• Create custom styles for text, tables, and lists
• Format, position, and resize graphics using advanced layout features
• Insert and modify objects
• Create and modify diagrams and charts using data from other source
• Organizing Content
• Perform calculations in tables
• Summarize document content using automated tools
• Merge letters with other data sources
• Merge labels with other data sources
• Structure documents using XML

Lesson 2

• Create and modify forms
• Create and modify document background
• Create and modify document indexes and tables
• Insert and modify endnotes, footnotes, captions, and cross-references
• Publish and edit Web documents
• Manage document versions
• Protect and restrict forms and documents
• Attach digital signatures to documents
• Customize document properties
• Create, edit, and run macros
• Customize menus and toolbars

Lesson 3

· Microsoft Office Excel 2007
• Use subtotals
• Define and apply advanced filters
• Group and outline data
• Use data validation
• Create and modify list ranges
• Create PivotTable and PivotChart reports
• Use Database functions
• Trace formula precedents, dependents, and errors
• Watch and evaluate formulas
• Define, modify, and use named ranges
• Create and modify custom data formats
• Use conditional formatting
• Format and resize graphics

Lesson 4

·  Collaborating
• Protect cells, worksheets, and workbooks
• Apply workbook security settings
• Merge workbooks
• Track, accept, and reject changes to workbooks
• Import data to Excel
• Export data from Excel
• Publish and edit Web worksheets and workbooks
• Create and edit templates
• Consolidate data
• Define and modify workbook properties
• Customize toolbars and menus
• Create, edit, and run macros

Lesson 5

·  Microsoft Office PowerPoint 2007
• Create new presentations from templates
• Insert and edit text-based content
• Insert tables, charts, and diagrams
• Insert pictures, shapes, and graphics
• Insert objects
• Format text-based content
• Format pictures, shapes, and graphics
• Format slides
• Apply animation schemes
• Apply slide transitions
• Customize slide templates

Lesson 6

·    Collaborating
• Track, accept, and reject changes in a presentation
• Add, edit, and delete comments in a presentation
• Compare and merge presentations
• Organize a presentation
• Set up slide shows for delivery
• Rehearse timing
• Deliver presentations
• Prepare presentations for remote delivery
• Save and publish presentations

Lesson 7

·  Microsoft Office Access 2007
• Create Microsoft Access databases
• Create and modify tables
• Define and modify field types
• Modify field properties
• Create and modify one-to-many relationships
• Enforce referential integrity
• Create and modify queries
• Create forms
• Add and modify form controls and properties
• Create reports
• Add and modify report control properties
• Create a data access page
• Enter, edit, and delete records
• Find and move among records

Lesson 8

• Create and modify calculated fields and aggregate functions
• Modify form layout
• Modify report layout and page setup
• Format datasheets
• Sort records
• Filter records
• Identify object dependencies
• View objects and object data in other views
• Print database objects and data
• Export data from Access
• Back up a database

Lesson 9

·  Microsoft Office Outlook 2007
• Originate and respond to e-mail and instant messages
• Attach files to items
• Create and modify a personal signature for messages
• Modify e-mail message settings and delivery options
• Create and edit contacts
• Accept, decline, and delegate tasks
• Create and modify appointments, meetings, and events
• Update, cancel, and respond to meeting requests
• Customize Calendar settings
• Create, modify, and assign tasks

Lesson 10

• Create and modify distribution lists
• Link contacts to other items
• Create and modify notes
• Organize items
• Organize items using folders
• Search for items
• Save items in different file formats
• Assign items to categories

·         After Course

·    Free Lab Access