Category Archives: Tips and Tricks

Placeholder text in PowerPoint

Placeholder text to help with drafting your presentation There will be times when, whilst you might have decided on the topics of your presentation, you’ve still not sorted out all of the detailed text that you want to include – perhaps you’ve an image & you need to find an ideal quotation that sums up […]

Word’s “Backward P” and why it’s useful

Looking at formatting in Word In last month’s Word Tips, I mentioned the “Show/Hide button” or Pilcrow (or “backward P”) & how it can be used to reveal the various formatting features that have been used in a Word document, so here we go… First of all, a reminder of where to find it… it’s […]

Tables in Excel

What are Tables Tables are Excel’s way of allowing you to manage and analyse a group of related data in a structured way. You can turn a range of cells into an Excel table at the click of a couple of buttons & this then provides a wide range of analysis possibilities. They also make […]

Modifying the Quick Access Toolbar

The Quick Access Toolbar in PowerPoint I briefly touched on the Quick Access Toolbar a couple of months ago in the “Quick Tips” section of the newsletter, but earlier today I was working on a PowerPoint presentation for a client & was making use of the ability to quickly add & remove items from it, […]

Section Breaks in Word

Using Section Breaks to split up your document I had a call from a client last week who needed his Word document to have both Portrait and Landscape pages within the same document as, in addition to narrative information, he had to include some large tables of data, so we needed to use Section Breaks […]

Changing case in Excel

Changing case to help printing I’ve recently been doing some consultancy work which has involved copying some data from another software program into Excel. Unfortunately, the text was all in upper case & not only is this difficult to read, it physically takes up more space, so I decided to change its case it to […]

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