Author Archives: colinfoster

Sections in your slideshow

Break up your presentation into Sections You may recall that back in October’s tips for Word we looked at setting up Sections to allow a change between Portrait & Landscape mode in a document; if not, here’s a link: http://www.us4b.co.uk/2018/10/section-breaks-in-word/ We can similarly use Sections in a PowerPoint slide show to break it down into […]

Creating Forms in Word

The other day, I was approached by one of my training contacts – Audrey Bodman from the Outshine Group – for some assistance with one of her Word Questionnaires as, rather than getting her delegates to complete the form by hand (with the challenges that reading other people’s handwriting brings!) Audrey wanted the delegates to […]

Analysing Tables with Slicers

A brief reminder In this Tip, we first remind ourselves some of the basic analysis tools for tables before moving on to discuss Slicers. Tables, you’ll hopefully recall, are Excel’s way of holding data in a clear & structured manner; If you need a “refresher”, here’s a link to November’s tip when we discussed Tables […]

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