Copyright © Optimise Consultancy Ltd

Home / Start

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

Delegates bring their own laptops to the session, so you using equipment you are familiar with.

We can have emailed any course files to you in advance.