Try our short training sessions – one and a half hours long, you have four in a day and different people can attend each session or whichever session they need. The topics can be mixed and matched to create your own customised training and if you don’t see what you need other topics can be included. Contact us for more in depth outlines, we have short courses on Excel, Word and PowerPoint.
Excel Short Sessions
Starting Excel
Create a workbook, enter data and use simple calculations.
Introducing Calculations
Work with simple calculations and statistical functions.
Manage Worksheets & Workbooks
View and navigate data in large worksheets and set up a worksheet to print.
Functions, Linking & Protecting Data
Review and find functions in a worksheet, link data from one worksheet to another and protect your data.
Manipulating Data
Use features related to large amounts of data (e.g. sorting, filtering, grouping, subtotals).
Charts & Sparklines
Create and change charts and sparklines
Functions (IFS)
Explore the IF functions.
Functions (Looking Up Data)
Explore the Vlookup, Hlookup, Index & Match functions.
Exploring More Useful Functions
Use Text, Date and Database functions
PivotTables & PivotChart
Create and change PivotTables and PivotCharts
Introduction to Macros
Record a macro to automate your worksheet
Word Short Sessions
Starting Microsoft Word
Create, save and print a document containing text.
Bullets, Numbers & Tabulation
Work with simple and complex lists.
Tables
Create, format and change a table.
Styles & Table of Contents
Create and modify styles to have consistency throughout your document, add an automatic table of contents to the beginning of the document.
Page Layout & Printing
Use features related to printing and working with large documents (e.g. headers and footers, page and section breaks, columns)
Mail Merge
Merge names and addresses to a document or labels.
Using Graphics in a Document
Insert pictures, SmartArt, WordArt and cover pages.
Manage Long Documents
Work with the long document features
PowerPoint Short Sessions
Starting PowerPoint
Create a presentation containing a variety of slides.
Tables & Charts
Insert tables and charts into a presentation.
Pictures & Drawing Tools
Working with graphics
Multimedia & SmartArt
Add and format videos and SmartArt graphics.
Templates, Masters & Slide Layouts
Create your own template and make global changes to your presentation.
Slide Show Techniques
Set your slide show up for presenting to an audience.
Prices
£299 per day incorporating four short training sessions, price includes one person per session and course notes relating to the session.
Each additional person: £10 per session.
We come to you. Courses take place at your offices.