by John Legge | Jan 22, 2020 | Excel Tips, Hints and Tips, Microsoft Office Courses Northamptonshire
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 section is covered briefly in our Intermediate Excel course. It isn’t covered in a lot of... by John Legge | Nov 7, 2019 | Excel Tips, Hints and Tips, Microsoft Office Courses Northamptonshire
Absolute References in Excel – do you know how to make a cell reference absolute in your spreadsheets? In an Excel spreadsheet (technical name – worksheet) there are many cell references that are used in calculations and formulas. A cell reference is... by John Legge | Jan 30, 2019 | Excel Tips, Hints and Tips, Microsoft Office Courses Northamptonshire
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...