0345 4506120

Professional IT and Business Admin Skills

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.

Reset

Pre-Requisites

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.

Course Content

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

Privacy Notice

In order to provide you with the service requested we will need to retain and use your contact information in accordance with our Privacy Notice. If you choose to provide us with this information you explicitly consent to us using the information as necessary to provide the request service to you. If you do not agree please do not proceed to request the service from us.

Marketing Permissions

Would you like to receive our newsletter and other information on products and services which we think will be of interest to you by email. We will always treat your information with care and in accordance with our Privacy Notice. You are free to withdraw this permission at any time.

 

Our Customers Include