Tips for Trainers
Pages Shortcut Keys
31 October 2010:
Using shortcut keys is a great way to speed up your work and become more productive, but no matter how familiar you are with Pages, it’s not easy to remember them all. Luckily there’s a comprehensive list of Pages shortcut keys available.
Word Shortcut Keys
31 October 2010:
Using shortcut keys is a great way to speed up your work and become more productive, but no matter how familiar you are with Word, it’s not easy to remember them all. Luckily there’s a comprehensive list of Word shortcut keys available.
Numbers Shortcut Keys
14 October 2010:
A comprehensive list of shortcut keys for iWork’s Numbers ’09.
Excel Shortcut Keys
14 October 2010:
Using shortcut keys is a great way to speed up your work and become more productive, but no matter how familiar you are with Excel, it’s not easy to remember them all. Luckily there’s a comprehensive list of Excel shortcut keys available.
Keynote Shortcut Keys
28 September 2010:
Using shortcut keys is a great way to speed up your work and become more productive, but no matter how familiar you are with Keynote, it’s not easy to remember them all. Luckily there’s a comprehensive list of Keynote shortcut keys available.
PowerPoint Shortcut Keys
28 September 2010:
Using shortcut keys is a great way to speed up your work and become more productive, but no matter how familiar you are with PowerPoint, it’s not easy to remember them all. Luckily there’s a comprehensive list of PowerPoint shortcut keys available.
Presenter View in Keynote
18 September 2010:
Since I spend a large part of my professional life creating and delivering presentations I need be to intimately familiar with the slideware application I use. My software of choice is Apple’s Keynote which is part of the iWork suite.
Excel 2010 New Features
16 September 2010:
What’s new in Microsoft Excel 2010? This short tutorial covers two new features: Sparklines and Slicers. Sparklines enable you to create high level overview charts, whilst Slicers allow you to analyse data from Pivot Tables in new and exciting ways. Introductory Video
Presenter View in PowerPoint
13 September 2010:
Almost all of the training courses that I deliver involve PowerPoint. Let me be clear, I don’t mean that I solely deliver PointPoint training, rather, most of the courses require the use of PowerPoint. I have a few introductory slides (with not a single bullet point in sight!), I have a slide with contact details [...]
Screen Capture Shortcut Keys in Mac OS X
1 September 2010:
While there are many applications that provide a wide range of fantastic screen capturing features OS X also has built in shortcut keys for making many different types of screen captures.
Screen Capture on Windows
31 August 2010:
At the recent NWIITT Screen Capture event on 26 August 2010, one of the topics that we covered was the built-in methods of screen capturing on Windows.
Business Contact Manager Shortcuts
31 August 2010:
Do you use Business Contact Manager for Microsoft Outlook 2003? If you do then take a look at this great list of keyboard shortcuts from Microsoft to help you become more productive.
Site Definitions in Dreamweaver CS5
22 August 2010:
In previous versions of Dreamweaver creating a Site Definition was a process fraught with difficult questions. With Dreamweaver CS5 Adobe have massively simplified the creation of Site Definitions. Accessing the Site Setup Dialog Box via the Menu There are several ways to access the Site Setup Dialog Box. Selecting Site, New Site… from the Menu [...]
Changing the Default Font in Word
22 August 2010:
Every Word document is based on a template and it is likely that most documents are based on the NORMAL template. This short tutorial demonstrates how to change the default font for all new documents based on the Normal template in Word 2007. The instructions also apply to Word 2010 Open the Font Dialog Box [...]
Defining and Using Range Names in Excel
23 May 2010:
Excel allows you to assign a name to an individual cell or a range of cells. That name can be used in a formula and can help to make the formula easier to understand. Names can also make it easier to navigate around a large spreadsheet. In Excel 2007 and 2010, names have a scope [...]
Amending Alternative Image Text in Word
20 May 2010:
The Save As PDF command in MS Office 2007 allows you to create a PDF from a Microsoft Office document even if you haven’t got Adobe Acrobat installed. However, if the Office document contains images (and the images have been inserted using the Insert > Image command rather than copy and paste), the image in [...]
Using The Conditional Sum Wizard
3 May 2010:
The Conditional Sum Wizard allows you to create totals for cell ranges based on multiple criteria. The SUMIF Function – Single Criteria Only In Excel, the SUMIF function adds up all the numbers in a range of cells, based on a given criteria. The screenshot is a sample spreadsheet that records details of training courses. [...]