Professional Training

Office IT Extras - CPD Certified

Course Access for 12 months. Typical completion time 2 to 3 months.
240 GBP
Next course start
Immediate Start See details
Course delivery
Self-Paced Online
Course Access for 12 months. Typical completion time 2 to 3 months.
240 GBP
Next course start
Immediate Start See details
Course delivery
Self-Paced Online
Leave your details so the provider can get in touch

Course description





The Office IT Extrascourse introduces Access and Publisher from first principles for beginners whilst building your Excel and Word skills to an intermediate / advanced level.  All course material is based on the very latest version of MS Office(Office 365 /2016).

This CPD Certified course builds on the Office IT Essentials course giving you more advanced skills in Excel and Word whilst introducing Access and Publisher.  Together with the Office IT Essentials course this will give you knowledge of all the main applications within the MS Office 365 suite.  It covers the following:

  • Excel 2 (intermediate to advanced)
  • Word 2 (intermediate to advanced)
  • Publisher (beginner to intermediate)
  • Access (beginner to intermediate)

You study this course entirely at home (or work or wherever you choose!) via our intuitive Online Learning Portal and we provide tutor support throughout the course.


Upon successful completion of this course you will receive the Executive PA School Office IT Extras Certificate with CPD Certification.  Throughout the course are a series of assesments (quizes and Tutor Marked Exercises) and your mark on each exercise contirbutes towards your overall grade of Pass, Merit or Distinction.


You will have access to the course material via our Online Learning Portal for 12 months.  Students typically complete this course in 10 to 12 weeks.


The course material is based on the very latest version of MS Office.  You will cover Word and Excel from an intermediate to advanced level with Access and Publisher beng from beginner to intermediate.  As with all our courses we provide full tutor support.  Further details are in our course prospectus and in the course content section below.

Do you work at this organisation and want to update this page?

Is there out-of-date information about your organisation or courses published here? Fill out this form to get in touch with us.

Upcoming start dates

1 start date available

Immediate Start

  • Self-Paced Online
  • Online
  • English

Suitability - Who should attend?

If you need to enhance or update your MS Office skills this course is for you.

Outcome / Qualification etc.

Upon successful completion of the course you will receive the Executive PA School "Office IT Extras" certificate with your grade (PASS, MERIT or DISTINCTION) and the appropriate CPD Certification as well.

Training Course Content


1 – Basics

  • Introduction to Desktop Publishing
  • Templates
  • Opening, Closing and Saving Publications

2 – Design

  • Publication Objects
  • Multiple Pages
  • Publication Types
  • Design Styles
  • Colour and Font Schemes
  • Layout
  • Business Information

3- Creating Publications

  • Creating a Blank Publication
  • Entering Text
  • Importing Text Files
  • Alternative Text Entry

4 – Text Formatting

  • Editing Text
  • Find and Replace
  • Formatting
  • Styles and Schemes
  • Fit and Alignment
  • Margins
  • Columns

5 – Pictures

  • Image Files
  • Online Pictures
  • WordArt
  • Inserting, Formatting and Manipulating Shapes

6 – Other Objects

  • Tables
  • Objects from Files
  • Linked Objects
  • Hyperlinks

7 – Page Layout

  • Object Properties
  • Layout Guides
  • Pictures in Text and Columns
  • Linking Text Boxes
  • Borders
  • Templates
  • Multi-Page Layouts


1 – Basics

  • Database Principles
  • Opening, Closing and Saving
  • Database Objects and Views

2 – Database Design

  • Design Considerations
  • Creating a New Database
  • Creating a Table
  • Using Data Types
  • Using Field Properties
  • AutoNumber
  • Entering Records in a Table
  • Adding/Deleting Fields

3- Editing Data

  • Adding/Deleting Records
  • Editing Records in a Table
  • Primary Keys
  • Data Validation

4 – Forms

  • Quick Forms
  • Using Forms
  • Removing Fields
  • Form Wizard
  • Editing Form Design
  • Form Properties
  • Data Testing

5 – Queries

  • Creating a Query
  • Multiple Selection Criteria
  • Using a Range of Values in a Query
  • Using Dates in Queries
  • AND – OR Queries

6 – Creating Reports

  • Automatic Reports
  • Report Wizard
  • Grouped Reports
  • Creating a Report from a Query
  • Printing a Report

7 – Formatting Reports

  • Creating a Report in Design View
  • Moving Fields and Labels
  • Aligning Fields and Labels
  • Formatting Data in Reports
  • Using Graphics and Images in Reports
  • Headers, Footers and Page Setup


1 – Formatting and Manipulating Data

  • Custom Number Formats
  • Conditional Formatting
  • Styles and Views
  • Find and Replace
  • Protection and Hiding Data
  • Printing Formulas and Selections

2 – Advanced Saving

  • Archiving
  • Saving to Different Formats
  • Publishing a Spreadsheet
  • Creating and Using Templates

3- Importing and Exporting Data

  • Importing Data into a Spreadsheet
  • Importing from Access
  • Exporting Data to Other Applications
  • Object Linking

4 – Consolidating Data

  • Linking Worksheets and Workbooks
  • Pivot Tables
  • Data Consolidation

5 – Outlines and Complex Functions

  • Creating and Working with Outlines
  • Adding Automatic Subtotals
  • Lookup, Statistical, Maths and Trig Functions
  • Nested Functions
  • Array Formulas

6 – Forecasting

  • Goal Seek
  • Scenarios
  • Scenario Summary Reports
  • Data Tables

7 – Advanced Filtering

  • Custom AutoFilter
  • Advanced Filter
  • Filtering using Complex Criteria
  • Extracting Filtered Data

8 - Charts

  • Adding Data to Charts
  • Formatting Charts
  • Printing Charts
  • Limits and Intervals on Axes
  • Two Chart Types on One Axis

9 - Auditing

  • Precedents and Dependents
  • Data Validation and Errors

10 – Sharing Workbooks

  • Tracking Changes
  • Shared Workbooks
  • Merging Workbooks

11 - Designing Solutions

  • Macros
  • Testing


1 – Templates

  • Creating and Using Templates
  • Setting Save Options and Using Different File Types
  • Document Security
  • Document Properties
  • Word Options and User Preferences

2 – Styles

  • Creating Styles
  • Setting Spacing, Alignment and Format
  • Creating and Using Templates

3- Tables and Columns

  • Manipulating and Managing Tables
  • Table Properties
  • Nested Tables
  • Formulas in Tables
  • Sorting and Sections
  • Manging Columns
  • Column Breaks

4 – Macros

  • Recording Simple Macros
  • Running Macros
  • Assigning a Macro
  • Multiple Action Macros

5 – Forms

  • Creating and Editing Forms
  • Form Fields
  • Protecting Forms

6 – Using Objects

  • Importing Text, Data, Graphics and Charts
  • Formatting Imported Objects
  • Linking External Data
  • Creating Drawings & Artwork

7 – Further Automation

  • Creating a Table of Contents
  • Creating an Index
  • AutoText
  • Bookmarks
  • Hyperlinks

8 - Mail Merge

  • Creating a Main Document
  • Creating a Data Source
  • Merge Fields and Merging

9 - Multiple Users

  • Collaboration
  • Tracking
  • Compare and Combine
  • Creating and Managing Master Documents and Subdocuments

10 – Checking Your Document

  • Page Setup
  • Spelling and Grammar
  • Proofing, Editing and Previewing a Document


The course fee is fully inclusive with no hidden extras.  You will need MS Office 365 installed on your lap top or PC.

Request info

Contact course provider

Before we redirect you to this supplier's website, do you mind filling out this form so that we can stay in touch? You can unsubscribe at any time.
Country *

reCAPTCHA logo This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.