November 19, 2018 – 11:01 pm 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 […]
By colinfoster | Also posted in Microsoft PowerPoint | Tagged For the fallen, lorem ipsum, Placeholder, placeholder text, PowerPoint, Presentation, Rand(), random text, Somme, They shall not grow old, Thiepval Memorial | November 19, 2018 – 10:49 pm 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 […]
By colinfoster | Also posted in Microsoft Word | Tagged anchors, Backward P, cell markers, Formatting, Keep lines together, Keep with next, line break, Nonprinting characters, Page break before, pagination breaks, Paragraph formatting, Paragraph marks, Plicrow, Show/Hide button, Space after, Space before, space characters, Suppress line numbers, tabs | November 19, 2018 – 10:10 pm 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 […]
October 8, 2018 – 4:58 pm 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, […]
October 8, 2018 – 1:25 pm 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 […]
October 8, 2018 – 12:41 pm 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 […]
September 14, 2018 – 9:17 pm 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 […]
September 14, 2018 – 9:13 pm 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 […]
September 14, 2018 – 9:08 pm 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 […]
August 14, 2018 – 10:48 am 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 […]
