Category Archives: Tips and Tricks

PowerPoint connections

Connections to make it work So, you’ve built your PowerPoint presentation, it’s looking good, you’ve even tested that the various effects work seamlessly… and then you turn up at the venue only to find that you’re unable to connect your laptop to the projector that the venue has available & this is in spite of […]

Table of Contents in Word

When do you need a Table of Contents? In my view, it doesn’t really make sense to go to the trouble of creating a Table of Contents (easy though the process is) until you’ve a document that’s a few pages long that incorporates a number of headings. Even multi page letters would probably look a […]

Conditional Formatting in Excel

Highlighting cells in accordance with a set of rules That is, in a “nutshell” what Conditional Formatting is all about – the formatting changes based on a set of rules that you specify. This could be whether a cell value is higher or lower than a target, or a date before or after another or […]

Lining up images in PowerPoint

Images in PowerPoint As Telly Savalas used to sing (using the word “sing” in it’s widest context, and showing my age at the same time): “A picture paints a thousand words” and many of us, when designing PowerPoint presentations make use of images. In some cases, the image IS the slide & when delivering our […]

Styles in Word

What are Styles in Word? At their most basic, Styles in Word are a quick way of applying a number of formats to a font in one go. By applying a Style to a block of text, you can, at a single click, change it from the default “Calibri 11” to Arial, Size 16, Bold, […]

Comments in Excel

Making your spreadsheet understandable and easy to update For many of us, building a spreadsheet can be a one-off exercise to answer a specific issue or calculate a value. However, for others, spreadsheets can be designed to capture a year’s worth (or more) of data. And then there can be an added issue… whilst we […]

Customising Word’s Themes to match corporate colours

What are Themes? When using Word, whether you’re aware of it or not, you’re using a Theme – usually the Office default one. This decides what the basic fonts & colours will be and, used with Styles (which will be the subject of our next Word tip), can enable you to create a Word Template […]

Dealing with multiple slide masters

Multiple Slide Masters You can end up with multiple slide masters in your PowerPoint presentation in two ways – intentionally (and there are two ways that this can happen) and unintentionally (in which case, you may want to remove one or more of them). You’ll recall that in last month’s PowerPoint tip we talked about […]

Fixing cell references with a $ sign

Fixing cell references Fixing cell references (otherwise known as Absolute Referencing) is something that seems to confuse a lot of people – being able to change a cell reference within a formula to a fixed Cell, Row or Column… The reason why you’d want to consider doing this is where part of your formula always […]

Using the Slide Master

When watching a PowerPoint presentation, one of those little irritations you can get is when a logo in the corner of a slide moves around. It doesn’t need to be much, but just enough to be distracting; or perhaps it’s the Slide heading that moves a little, or is slightly smaller or further to one […]