About this course

Course type Performance Plus
Course code QAEAPBS
Duration 3 Days

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.

Prerequisites

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.

Outline

Word

  • Document Editing
  • Inserting Graphics
  • Watermarks
  • Controlling Text Flow
  • Headers and Footers
  • Spelling and Synonyms
  • Document Styles and Themes
  • Document Referencing
  • Quick Parts and Autocorrect
  • Templates
  • Bullets and Numbering
  • Mail Merge
  • Reviewing Documents - Tables of Contents

PowerPoint

  • Building Presentations
  • Slide Layouts
  • Master Slides
  • Formatting Slides
  • Slide Design
  • Reuse Slides
  • Transitions
  • Animations
  • Setting Up a Slide Show
  • Custom Shows - Timing a show

Excel

  • Managing Worksheets - Inserting, Renaming, Copying
  • Formatting Cells
  • Print Options
  • Absolute Cell Referencing
  • Flash Fill
  • Templates
  • Advanced Functions - IF Statements, vLookups
  • Drop Down Lists
  • Tables
  • Conditional Formatting
  • Sorting and Filtering
  • Charts
  • PivotTables

Outlook

  • 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

Performance Plus

3 Days

Duration

This course is authored by QA

Delivery Method

Delivery method

Classroom

Face-to-face learning in the comfort of our quality nationwide centres, with free refreshments and Wi-Fi.

Trusted, awarded and accredited

Fully accredited to ensure we provide the highest possible standards in learning

All third party trademark rights acknowledged.