Advanced MS OFFICE for EAs, PAs, Office Managers & Administrators

About

This course isn’t just any old MS Office training course – our trainer has years of administration and office management experience as well as 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.

Training Methodology
This two-day course will use case study examples and group exercises, as well as tutorial sessions. All participants will be provided with a laptop pre loaded with MS Office 2007 software, ensuring that this course will be practical and hands on, rather than lectures.  Expect a fun and interactive two days, where you will learn and apply skills that you can take back to the office – tomorrow!

Who Should Attend
• Executive Assistants
• Executive Secretaries
• Management Assistants
• Personal Assistants
• Legal Secretaries
• Office Managers
• Other support staff who wish to learn MS Office best practice

Agenda

MS Word
You probably use Word every day, but how well do you know this programme, and how much time and effort could you save if you knew all the tips and tricks to make Word work for you?  The first half of day one will look at Word, and give you the advanced skills you need to take your Word knowledge to the next level.
• Layout and design of Word
• Differences between Word 2003 and 2007
• Formatting and Style
• Using templates
• Tables
• Headers and footers
• Table of Contents
• Review documents and track changes
• Using mail merge for mass mailings
• Keyboard shortcuts
 • MS Word and security
• Using Macros
• XML Documents
• Compatibility Mode

MS PowerPoint
Often you will be called upon to develop PowerPoint presentations for your team.  This session will give you the skills to take advantage of the advanced tools available in PowerPoint for truly professional presentations. 
• PowerPoint tour and the user interface
• Creating a presentation
- Slides and text
- Pictures & ClipArt
- Smart Art
- Applying themes
- Handouts and notes
• Charts diagrams and tables
- Using data from Excel
- Using graphics
- Organisation charts
• Adding sound
• Adding video clips
• Using animation
• Using SharePoint libraries
• Proofing printing and preparing for presentation
• Creating & using Slide Masters
• Photo Albums

MS Excel
Most of us know how to use the basics of Excel, but very few understand more than 10% of its functionality.  With more and more jobs for PAs being advertised requiring an advanced knowledge of Excel, stay ahead of the rest with you’re newly acquired skills in spread sheeting!
• Differences between 2003 and 2007 versions
• Commonly used Formulas and Functions
• Working with dates
• Creating charts
• Using pivot tables to analyse data
• Sorting and Filtering data
• Sharing data with your colleagues
• Linking Excel to SharePoint
• Keyboard shortcuts
• Security and Macros
• Tips for working with large worksheets
• Conditional Formatting
• Protection

MS Outlook
Outlook is more than just an email programme – it’s a full time management suite. And who could benefit more from effective time management than busy EAs and PAs.  This session will give you the tools and techniques you need to save time while using Outlook and take control of your inbox.
• Differences between Outlook 2003 and 2007
• Finding and organising email effectively
• Creating custom signatures and Out of Office Responses
• Using RSS to keep track of blogs, newspapers and commonly read websites
• Tools and techniques to reduce the size of your inbox
• Storage: Archive and personal folders
• Retrieving, backing up and sharing messages
• Using search folders to organise your email
• Using the calendar to create appointments and meetings
• Sharing your calendar
• Using multiple calendars
• Managing your contacts effectively
• Reducing spam

Other Programmes
The final session will give you a brief  insight into other Office Programmes available, and their uses in an office environment.
• Access
• OneNote
• Project
• Visio
• SharePoint

Facilitator

In-house Training

Prices and Registration

* Early bird price available when you register and pay before the dates listed.