by John Legge | May 2, 2019 | Excel Tips, Hints and Tips
SUBTOTAL vs SUM – which do you use in Excel? This week’s hint and tip is about looking at the SUBTOTAL function vs. the SUM function. Most of you will have heard of the SUM function and probably use it on a daily basis, but you might not have known that... by John Legge | Apr 5, 2019 | Excel Tips, Hints and Tips
Excel Charts – How do you create a chart from a Data Subtotals sheet? This is how… On a course last week, we had a good request from an attendee. They asked how to create a chart from a Data Subtotal sheet but only showing the subtotals and not the... by John Legge | Mar 21, 2019 | Excel Tips, Hints and Tips
Learning Excel through games – Episode 1 Excel is used on a daily basis by people all over the world with most of them constantly learning Excel in their work. It has lots of features that can be used from a basic to a more advanced level, with one of these features... by John Legge | Mar 15, 2019 | Excel Tips, Hints and Tips, IT training Herefordshire
IT training Herefordshire – how do you create a pivot table and chart? Find out how this week below…One of the most useful and powerful features companies can use in Excel is the ability through Pivot Tables to analyse and summarise data. We deliver the... by John Legge | Feb 20, 2019 | Excel Tips, Hints and Tips
Excel training basics – the BODMAS ‘concept’ BODMAS. The word that tends to divide a room of people on one of our Excel courses up in to one of four groups: Have no idea what we are talking about and never heard of BODMAS Vaguely remember being told... by John Legge | Jan 30, 2019 | Excel Tips, Hints and Tips
Excel names – using naming cells and ranges within formulas and calculations In this weeks hint and tip we are going to be looking at the concept of Excel names. This concept is where you are able to name a cell or a range of cells to then use them within a formula or...