Cranford Training

Tel: 01823 421140 Mobile: 07549 874139 Email: info@cranfordtraining.co.uk

Home

Course Details

Course Outlines

Welcome to our website

Established in 1990, we provide customised, on-site Microsoft Office training to all types and sizes of companies in Somerset and the South West of England.

Training courses have been arranged with Government bodies, the NHS Trust, pension companies, solicitors, accountants, manufacturing companies, and many other types of organisations.

Read More

Course Outlines

	An Introduction to Computers

	Outlook – Overview

	Outlook – Introduction

	Excel Introduction

	Excel Intermediate

	Excel Advanced

	Further Excel Advanced

	Word Introduction

	Word Intermediate

	Word Advanced

	Further Word Advanced

	Access Introduction

	Access Intermediate

	PowerPoint Introduction

	PowerPoint Intermediate

Title:	Excel Advanced
Duration:	1 day
Level:	The course is designed for delegates who have attended the Intermediate course, or who have a very good knowledge of Excel, to include most of the features in that outline. They should be able to insert formulas and functions and understand the difference between a relative and absolute cell reference
Objective:	At the end of the course, delegates will be able to use different ways to consolidate and link data, use Lookup Tables, Pivot Tables and other features which speed up and increase efficiency when working with Excel.
Topics:	Customising and creating toolbars Custom views Advanced filtering Templates Sub-totalling Pivot table reports Data validation Lookup tables Methods of consolidating and linking (including using the data consolidate feature) Workspace file Hyperlinks

Home

Course Details

Course Outlines