by John Legge | Jan 22, 2020 | Excel Tips, Hints and Tips
Formula Auditing in Excel: two ways in which you can use it for checking formulas in your worksheets This week’s hint and tip is on Formula Auditing in Excel. This is a section which is briefly covered in our Intermediate Excel course but isn’t covered in... by John Legge | Dec 11, 2019 | Excel Tips, Hints and Tips
IF Statement in Excel – do you know how to create one? Watch our video hint and tip to learn how This week’s hint and tip is about looking at the IF Statement. Some of you might have heard of the IF Statement before, but for some of you this might be a new... by John Legge | Dec 5, 2019 | Excel Tips, Hints and Tips
SUM function in Excel – the different ways to generate it, have you tried them all? This week’s hint and tip is about the SUM function in Excel and the different ways that you can go about creating it. This function is covered on the Basic Excel course and... by John Legge | Nov 27, 2019 | Excel Tips, Hints and Tips
Three Simple Excel Tips – there are lots in Excel, but have you heard of these three? Whilst training Excel in Worcestershire and Herefordshire recently, we had a good chat on the course with the people attending about shortcuts. There are many in Office let... by John Legge | Nov 22, 2019 | Excel Tips, Hints and Tips
Excel Visio Add in – the new Visio Data Visualizer add-in that has appeared in a recent Microsoft Office update This hint is for those people who are Office 365 subscribers and want to know what’s around the corner. Nowadays most people have the 365 version of... by John Legge | Nov 7, 2019 | Excel Tips, Hints and Tips
Absolute References in Excel – do you know how to make a cell reference absolute in your spreadsheets? In an Excel spreadsheet (the technical name being a worksheet) there are many cell references that are used in calculations and formulas. A cell reference is...