Copyright © Optimise Consultancy Ltd

What people think

"Gave me a good knowledge to be able to use this software for work."


Amy Hicks - Trent & Dove Housing.

One Day Excel and PowerPoint

Microsoft Excel 1 Day - General User

 Simple formula

 Basic Functions

 Sorting & Filtering data lists

 Absolute and Relative references

 Counting functions

 Printing and managing large spreadsheets



Microsoft Excel 1 Day – Formula and Functions

 Using Insert Function
Lookups and references

 Multiple worksheets and workbooks

 Automatic formatting of your workbook

 Creating graphs



Microsoft Excel 1 Day – Macros and Automation

 The benefits of automating your workbook

 Recording macros

 Editing macros

 Input boxes

 Creating forms



Microsoft Excel 1 Day –

Data Analysis and Pivot Tables

 Working with large tables

 Lookups

 Nesting functions

 Creating pivot tables

 Formatting pivot tables

 Using Slicers

 Adding formula to pivot tables



Microsoft PowerPoint 1 Day –

Creating Presentations

 Getting started

 Creating a presentation

 Importing images

 Using Graphs

 Using slide transitions

 Using Animation

 Adding notes

 Printing your presentation

 Editing and creating a template



Microsoft PowerPoint 1 Day –

PowerPoint Ninja!

 Using Smart Art

 Editing graphics

 Importing sound and video

 Creating Ninja! Slides


On-site and Off-site training  

Training to suit you and your business

Need Help?

Your place or mine?

What do you need?

'The course was excellent, there were areas which I didn't know about.  The Trainer was very helpful.'


Shirley Cole - South Staffordshire Council

Book training with us now.

Course Outlines