• Authored Course

About this Course

Special Notices

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.

Learn from the UK's leading Microsoft training provider

  • Comprehensive curriculum

    We deliver over 20,000 Microsoft training courses in the UK each year

  • Experienced experts

    Our first-class learning specialists all have a minimum of 5 years training experience

  • Superb satisfaction scores

    99% of our delegates are satisfied with their Microsoft course

  • Trusted training

    We are the largest Microsoft Gold Learning Partner in the UK

  • Microsoft Partner Gold Learning

Why people choose QA

Locations

There are over 20 QA learning centres and many other sites spread across the UK, providing a convenient choice of learning locations and ensuring that over 90% of the population is within 45 minutes of a training destination. Learn more

  • London

    London

    International House

  • Manchester

    Manchester

    Oxford Street

Delegate portal

Booking courses with QA has always been easy, but now we've made it even easier. With myQA you can book, administer and manage all your bookings online, in one place. Login / sign-up

Detailed Information

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

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.

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.

Microsoft
Microsoft Certifications

Take the next step in your career by achieving certification in Microsoft Technologies.

Microsoft Azure
Microsoft Azure

Master Azure with QA, the 2015 Microsoft Worldwide Learning Partner of the Year.

Windows Server
Windows Server 2016

Learn to efficiently manage corporate IT infrastructures with Windows Server 2016.

MOC on Demand

Delivers Microsoft Official Curriculum (MOC) courses online straight to your device.