by John Legge | Jul 18, 2019 | Excel Tips, Hints and Tips
Excel Basics Conditional Formatting – how to use it in Excel and the ‘Stop if True’ option Conditional formatting is an option within Excel that can be used to bring some colour to your spreadsheet and allow you to highlight parts of the data in your... 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...