by Colin Foster | Jan 13, 2021 | Microsoft Excel, Microsoft Excel, Microsoft Excel
There are three ways that we can calculate price increases. The first calculates the increase & then adds this to the original value; the second calculates the new price only (though, of course, we can use that & the original price to work out the difference)....
by Colin Foster | Nov 3, 2020 | Microsoft Excel, Microsoft Excel, Microsoft Excel
I suspect that many of us are familiar with being able to type numbers in Excel cells and then have them fill down incrementing by one (or whatever our series may be), but what if we want to use Autofill with letters, so typing A & B with Excel completing the...
by Colin Foster | Apr 18, 2019 | Microsoft Excel, Tips and Tricks
To insert blank rows in an Excel spreadsheet is a relatively straightforward process, as is inserting a block of consecutive rows, but what if you need to insert them alternatively? If it’s a small spreadsheet, than that’s fine, you can work your way down...
by Colin Foster | Mar 18, 2019 | Microsoft Excel, Tips and Tricks
When formatting your Excel spreadsheet (changing colours, backgrounds, gridlines, alignment, etc) how you do it can have a massive impact on its file size. What’s more you may even be unaware of the impact (being honest, how many of us actually check file sizes...
by Colin Foster | Feb 20, 2019 | Microsoft Excel, Tips and Tricks
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...
by Colin Foster | Jan 22, 2019 | Microsoft Excel, Tips and Tricks
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...
