1 2 3 4 5 6 7 8 9 1 2 3 4 5 6 7 8 9 1 2 3 4 5 6 7 8 9

Microsoft IT Training Excel, PowerPoint and Word

Contact Us

Helping you get professional results fast & move you towards frustration-free computing

MS-Office TimeSavers

Top Tips & Hidden Tricks

Increase your productivity and make your computing frustration-free.

Based on our e- book - “TimeSavers” as featured on ‘PC Answers’ magazine cover cd.

Enquire about this course now and download your FREE GIFT - Our e-book “Twelve Top Tips & Hidden Tricks”

General TimeSavers

Excel TimeSavers

Outlook TimeSavers

PowerPoint TimeSavers

Word TimeSavers

· Taking control of Office 2007’s ribbon

· Moving and copying objects

· Keeping a document on the Office Button “File menu”

· Creating shortcuts

· Making the most of the Quick Access Toolbar

· Macros

· Format Painter

· Redo your last command with one key press!

· Charts with one key press!

· Paste Special

· Goto

· Workbook manipulation – moving, copying, colouring, hiding & Grouping sheets

· Quick ways to insert rows & columns

· Creating a data series – fast!

· Customising data series

· Freezing rows/columns

· Seeing two parts of a spreadsheet - splitting the screen

· Conditional formatting

· Data validation

· Filtering data

· Subtotalling data

· Analysing data with Pivot Tables

· Macros

· Goal Seek

· Solver

· Scenarios

· Custom views

· Custom Reports

· Create calendar & task entries from emails with just one click

· Keyboard shortcuts to start new entries

· Use Flags to mark entries

· Easily find emails to & from a contact

· Advanced Find

· Create draft “stationery” messages

· Use Rules to control your email

· Colour-code entries

· Categorise entries

· Using Outline View to create a presentation

· Moving, copying, sizing & rotating objects

· Creative objects – shadows & other effects

· Temporarily turn off projector with one key press

· Drawing perfect circles, squares

· Creative Animations

· Insert a video clip into a show

· Link to other presentations, files & websites

· Set shape default colours

· Making your slides stand out

· Aligning objects

· Distributing objects equidistant to each other

· “SmartArt”

· Create a photo album

· Using sounds creatively

· Hyperlinks

· Action buttons

· Slide Transitions

· Changing case with just two key presses!

· Get it all on one page – with just two mouse clicks.

· Store & recall text & graphics - Autotext

· Conquer Word’s Numbered & Bulleted lists

· Use Outline View to easily create a long document

· Document Map

· Automatically correct your typos - Autocorrect

· Working with Tables

· Paragraph Styles

· Table of Contents

· Creating an index

· Formatting text & graphics copied from the internet

· Controlling graphics & text

· MailMerge

· Watermarks

· Full Screen reading view

Extra topics can be covered at students request, time permitting.

Top Tips 'n' Hidden Tricks

Tips 'n' Tricks Videos