by John Legge | Jun 9, 2020 | Company News, Microsoft Office Courses Northamptonshire, On line Excel training, Remote Training
On-line Microsoft Office Training from the team at JPL IT Training Limited Since the middle of March 2020 and the start of the Coronavirus we have been able to deliver via Webex a series of short on-line Microsoft Office training courses in Excel, Word and PowerPoint.... 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...