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 | Nov 19, 2018 | Microsoft Excel, Tips and Tricks
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...
by Colin Foster | Oct 8, 2018 | Microsoft Excel, Tips and Tricks
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...
