ABOUT COURSE

From June 2013, this course will be taught on laptops preloaded with MS Office 2010 and the workbook material will be updated to be based on the 2010 version, too. References will still be made to MS Office 2007 to show the differences between the two versions.

This popular course isn’t just any old MS Office training course – our trainer has years of administration and office management experience as well as over 10 years worth of IT training experience, and will give you practical hands on examples which apply directly to your day to day work.

If you are looking to significantly improve your MS Office skills, in a way that is relevant to your role, then Advanced MS OFFICE for EAs, PAs and Office Managers is a must attend to keep you up to date with the latest best practice and skills you need to know.

LEARNING OUTCOMES

• Take control of your inbox and calendar with MS Outlook
• Learn how to use the features and functions of the spreadsheet tool MS Excel
• Develop professional looking presentations in MS PowerPoint
• Improve your word processing with advanced tools and techniques in MS Word
• Gain an understanding of how the entire MS Office suite works together

COURSE OUTLINE

MS Word

• Differences between Word 2010 & 2007
• Mastering Tabs and Indents
• Document Formatting and Styles
• Working with tables, graphics and objects
• Using and creating templates
• Using mail merge for mass mailings
• Reviewing and comparing documents
• Keyboard shortcuts
• Creating Macros
• Compatibility Mode

MS PowerPoint

• Differences between Word 2010 & 2007
• Creating and formatting a presentation
• Using SmartArt and Shapes
• Working with Slide Masters
• Working with Multimedia – movies, sound
• Using animations and transitions
• Presenting and printing presentations

MS Excel

• Differences between Word 2010 & 2007

• Commonly used Formulas and Functions
• Sorting and Filtering data
• Using Excel Tables
• Using Conditional Formatting
• Creating Outlines
• Sharing and Protecting data
• Creating and modifying charts
• Creating Macros
• Tips for working with large worksheets
• Using Pivot Tables to analyse data

MS Outlook

• Differences between Outlook 2010 and 2007
• Tools and techniques to reduce and manage the size of your inbox
• Using search folders and rules to organise and manage your email
• Using the calendar to create appointments and meetings
• Tips for using shared Calendars
• Working with Contacts, Tasks and Notes
• Using RSS to keep track of blogs, newspapers and commonly read websites

Other Programmes

• Access
• OneNote
• Project
• Visio
• SharePoint