Spreadsheet Training Courses
Secretarial Courses

Executive / PA
Medical Secretary
Legal Secretary

OCR / RSA Qualification Courses

OCR / RSA Level 1
OCR / RSA Level 2
OCR / RSA Level 3
OCR / RSA Diploma Courses

Typing

Typing Skills

Applications

Accounts
Databases
DTP / Graphics
Spreadsheets
Word Processing

Please click the links below for more information on the courses that we have available. For additional information click to contact us

 

FD8 - Microsoft®Excel Introduction

Using Microsoft® Excel this course is suitable if you have little or no experience of the program.  Please specify version required.

Available as a distance learning / home study course.

Topics include:

Before You Start
What is a Spreadsheet Program?
Getting Started with Microsoft Excel
Windows and Views
Basic Spreadsheet Skills
Using the Help System
Opening, Saving and Closing Workbooks
Creating New Workbooks
Selecting Cells
Cell Referencing
AutoSum and AutoFill
Formatting Numbers
Formatting Cells
Cell Alignment
Cells, Rows and Columns
Working with Worksheets
Edit, Undo, Cut, Copy and Paste
Proofing and Previewing Workbooks
Page Layout
Printing Workbooks
E-mailing Worksheets
Basic Options

Course manual supplied.  Certificate upon completion.

Email the course tutor or telephone 0116 232 5166 for more information.

 

FD9 - Microsoft® Excel Intermediate

Using Microsoft® Excel this course is suitable if you have a basic experience of the program and are able to set up a basic spreadsheet inputting basic formulas.  Please specify version required.

Available as a distance learning / home study course.

Topics include:

Before You Start
Chart Basics and Inserting Charts
Chart Design
Chart Layout
Chart Format and Themes
Find and Replace
Sort and Filter
Defined Names
Introduction to Functions
Date Functions
Logical Functions
Information Functions
Financial Functions
Adding Comments
Headers and Footers
Illustrations, Text Boxes and WordArt
Conditional Formatting

Course manual supplied.  Certificate upon completion.

Email the course tutor or telephone 0116 232 5166 for more information.

 

FD10 - Microsoft® Excel Advanced

Using Microsoft® Excel this course is suitable if you have a good knowledge of the program and are proficient with the topics covered in the intermediate course.  Please specify version required.

Available as a distance learning / home study course.

Topics include:

Before You Start
Text to Columns
Remove Duplicates
Data Validation
Consolidate Data
What-if Analysis; Data Tables
What-if Analysis; Scenarios
What-if Analysis; Goal Seek
Subtotals and Grouping
Text Functions
Lookup Functions
Maths and Trig Functions
Database Functions
Auditing and Error Tracing
Excel Tables
Linking Data
Getting External Data
Pivot Tables and Pivot Charts
Protecting and Sharing Worksheets and Workbooks
Workbook Properties and Inspection
Encrypting and Finalising Workbooks
Digital Signatures
An Introduction to Macros

Course manual supplied.  Certificate upon completion.

Email the course tutor or telephone 0116 232 5166 for more information.

sage training courses
ms excel training
ms word training
powerpoint training
outlook training
publisher training