Monthly Archives: September 2020

Microsoft Excel – RAG icon sets

Posted on September 23, 2020 by jdonbavand

I had a client who had typed in as text, R, A or G depending on whether a certain indicator should be classified as Red, Amber or Green. They then wanted to use conditional formatting to show the relevant colour … Continue reading →

Posted in Excel 365, Microsoft Excel, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016, Uncategorized | Tagged , , | Leave a comment

Crystal Reports – Financial Year formula when Financial year starts in April

Posted on September 17, 2020 by jdonbavand

Sometimes you may want to know what financial year an invoice was in based on the Invoice date (or some other date). If the table is called Invoice and the field is called InvoiceDate, you could set up a new formula … Continue reading →

Posted in Crystal Reports | Tagged , | Leave a comment

Microsoft PowerPoint – seeing bulleted list, one bullet at a time

Posted on September 14, 2020 by jdonbavand

When you are giving a PowerPoint presentation, it is sometimes useful to talk about one bullet point, before your audience sees the next one. You can use animation to bring a bulleted list, one point at a time. On the … Continue reading →

Posted in Microsoft PowerPoint, Microsoft PowerPoint 2007, Microsoft PowerPoint 2010, Microsoft PowerPoint 2013, Microsoft PowerPoint 2016, Uncategorized | Tagged , , , | Leave a comment

Microsoft Word – adding a footnote

Posted on September 2, 2020 by jdonbavand

When using Microsoft Word, you may want to add a footnote to text; a footnote appears at the bottom of the page in which the referenced information appears. To create a footnote : Position the insertion point immediately after the … Continue reading →

Posted in Microsoft Word, Microsoft Word 2010, Microsoft Word 2013, Microsoft Word 2016 | Tagged , | Leave a comment