Category Archives: Tips and Tricks

Creating an interactive menu with Zoom Slide in PowerPoint

In last month’s tip we created some Sections within our Presentation to pull together slides into logical groupings, we’re now going to make use of those, via a Zoom slide in PowerPoint to create an interactive menu Here we can see 5 of the sections in our presentation… Using a Zoom Slide As we’re going […]

Printing address labels with MailMerge

In addition to all the “techie” stuff that I do, I’m also the Membership Secretary for a national road transport modelling group & each quarter a full colour, A5 sized printed magazine goes out to all members. As I have the contact details, I produce the address labels that go onto the envelopes. Recently, I’ve […]

Analysing data with Excel Pivot Tables

In the past couple of tips, we’ve looked at how to create Tables & use the tools that then become available (such as Filters and Slicers) to begin to extract information from the data that we hold. We’re now going to look at how to take this much further by looking at Pivot Tables. What […]

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