by John Legge | Sep 4, 2019 | Excel Tips, Hints and Tips
Excel Tables – how you can use them within Excel to make named ranges more flexible This week’s hint and tip is about creating a table from your data in Excel and how it makes named ranges more flexible this way than just selecting and naming the range of cells.... by John Legge | Aug 22, 2019 | Excel Tips, Hints and Tips
Excel Environment – setting it up in Excel to personalise the experience you have This week’s hint and tip is about setting up the ‘Excel Environment’. This is a section in our Basic Excel course and covers a number of options you can use or... 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...