Please note: for Attend from Anywhere customers an additional screen is required for this course to work through remote desktop labs and view training information.
With our three day professional business skills course you'll learn the key things you need to work in the highly demanding and challenging roles of Executive Assistant, PA or senior administrator.
Day 1 will cover the key features of Word and PowerPoint, covering shortcuts such as efficiently creating long business documents and creating and modifying existing presentations.
We concentrate on Excel and Outlook on day 2. Utilising the best of Excel for data analysis and reporting and in Outlook covering quick steps and rules, managing your appointments and others.
On day 3 we'll cover taking minutes and having a great insight into how an organisation runs at a senior level. You'll be able to take your existing personal skills and combine them with great practical business skills - making you an asset to any company.
Note: this course uses Microsoft Office 2013. Alternative versions can be requested for tailored events.
This course is aimed primarily at the role of Executive Assistants, PAs and senior administrators. Your job is likely to involve research, communications, correspondence and overall office management and you may support senior executives, CEOs or general managers.
Before attending this course, delegates should be existing Microsoft Office users who will be required to use Microsoft Office 2013. They should already be using the Office 2013 applications within their roles and have a good basic knowledge of the core applications of Word, Excel, PowerPoint and Outlook. Delegates should have an understanding of the File/Backstage functions of saving, opening and closing documents and finding files and folders using Windows Explorer.
In Word, they should already know how to create documents and format text. In Excel, how to create basic spreadsheets, select and edit data and perform basic formulas and functions such as Autosum. In Outlook, how to send/reply/delete and add attachments to emails.
It should be noted that this is not a course for delegates who are completely new to the Office 2013 applications and their functionality.
- Document Editing
- Inserting Graphics
- Controlling Text Flow
- Headers and Footers
- Spelling and Synonyms
- Document Styles and Themes
- Document Referencing
- Quick Parts and Autocorrect
- Bullets and Numbering
- Mail Merge
- Reviewing Documents - Tables of Contents
- Building Presentations
- Slide Layouts
- Master Slides
- Formatting Slides
- Slide Design
- Reuse Slides
- Setting Up a Slide Show
- Custom Shows - Timing a show
- Managing Worksheets - Inserting, Renaming, Copying
- Formatting Cells
- Print Options
- Absolute Cell Referencing
- Flash Fill
- Advanced Functions - IF Statements, vLookups
- Drop Down Lists
- Conditional Formatting
- Sorting and Filtering
- Inbox Views
- Auto Signature
- Mail Options
- Automatic Replies
- Quick Steps
- Searching and Organising Messages
- Calendar Options - Making Appointments, Recurring Appointments
- Scheduling Meetings
- Sharing Calendars
Practical Soft Skills
- List what you need to do to prepare for meetings prior to, during and after the event
- Demonstrate setting a well-structured agenda
- State common barriers to effective listening and demonstrate your own listening skills
- Identify a method of note-taking that suits your preferred style
- Select the important and relevant points from a discussion
- State agreed accepted conventions for the format of minutes
- Produce an accurate set of minutes, clearly and concisely