Category Archives: Tips and Tricks

Nudging around the PowerPoint Grid

Using Gridlines for better positioning A little while back, we looked at the various ways of lining up images relative to each other (http://www.us4b.co.uk/2018/06/lining-up-images-in-powerpoint/) , however, there will be times when there’s only one image or you want to overlay a number of images & so that method won’t work. Fortunately, help is at hand […]

Using Wildcards in Word Find and Replace

Wildcards to extend the Find & Replace options Last month, you’ll recall, I took you through the process of using Find & Replace to help complete a sorting process within a document (as a reminder… http://www.us4b.co.uk/2018/08/sorting-in-word/) In addition to the basic options, we can use Wildcards to represent certain characters within our search to quickly […]

Errors in Excel and how to use them effectively

Making use of errors OK, so logic says that you don’t want to have any errors in your spreadsheet & broadly speaking, that’s correct… however, there can be occasions when an “error” can be helpful. As we saw in last month’s tip, the #N/A error in a VLOOKUP Function means that the item that you’re […]

Screenshots in PowerPoint

Easily capture Screenshots in PowerPoint There may be occasions when the image that you need in your presentation is best served by screenshots of your screen – this can be especially true if you’re demonstrating some software. Ideally, you’d have the software itself available for an ideal demo, but perhaps this is part of the […]

Sorting in Word

What do you mean, Sorting in Word – that’s Excel, surely? Normally, I’d agree with you – we use Excel for “Number crunching”, working with lists, etc and we use Word for writing articles or letters – or even Blog posts – but occasionally, it can be very useful to take advantage of the ability […]

Dealing with Errors in Lookups

The #N/A Error If we use the VLOOKUP Function to match between two sets of data – then occasionally, Excel will return an #N/A error where it can’t find the value in one list in the other one In this example, we have two lists of employee data where in the “Month #2” block, there’s […]

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 […]