This 1 day course is delivered online and is split into 2 half days.
Dates and timings
20 & 22 November 2023, 9.00am-1.00pm
20-21 February 2024, 9.00am-1.00pm

Learn Productivity Tips That’ll Save You Time, Money and Stress
Just the mention of Excel creates fear in many Office Professionals. Some say Microsoft Word is just for boring letters. And PowerPoint is just old fashioned!
All of these Office products have become staples for business for one good reason. They all do their jobs exceedingly well but only when you scratch beneath the surface. In one day, we will be looking at over 300 tips. But don’t panic! Everything is contained in the comprehensive handouts, step-by-step, and in Plain English.
In this intense session, your Certified Microsoft Master will cover:
Key productivity areas
Excel
- Understanding your worksheets
- Linking worksheets
- Freezing pane
- Paste special and clearing cells
- Wrapping text
- Editing multiple sheets
- Tables
- Conditional Formatting
- Printing sheets in depth
- Using Shift and F3 to find formulas
- Cheating with Flash Fill
- Referencing cells
- Text to columns
- Vlookup
- Pivot Tables
- 23 Essential Formulas
- Charting
- Sparklines
Word
- Editing a PDF within Word
- Auto recovering every minute
- Removing difficult formatting
- Next level Format Painter
- Autocorrect cheats
- Changing text from portrait to landscape
- Personalised bullets
- Mastering long documents with styles (Cover page, Table of Contents)
PowerPoint
- Stop using bullets and start using SmartArt
- Slide Masters
- Hyperlinking your slides
- Eye Dropper Fill
- Advanced formatting of pictures
- Inserting audio/video
- Animations & Transitions
- Live Subtitles (in multiple languages)
- Charting
- Jaw dropping presentation shortcuts
How is this course delivered?
- This course can be delivered at your venue
- This course can be delivered online at the date and time convenient to you
- This course is delivered online and is split into 2 half days
Dates and timings
20 & 22 November 2023, 9.00am-1.00pm
20-21 February 2024, 9.00am-1.00pm

Why choose this course?
- Taught by Certified Microsoft Master
- Over 70 pages of handouts
- 2 years of FREE post course support
- Endorsed by the IAM
- Absolutely no PowerPoint slides (except in PowerPoint session!)
- Certificate of attendance
- 1000s of satisfied clients
- This course has been developed and refined over 17 years, keeping pace with the ever-changing role of the Office Professionals
Your trainer
PAul Pennant
Founder & Owner of Today’s PA
