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 | Oct 31, 2019 | Excel Tips, Hints and Tips, Microsoft Office Courses Buckinghamshire
Excel 365 Maps – didn’t maps appear before in Excel? You might be thinking, “hang on, they’ve spoken about maps before in Excel haven’t they?” Well you would be right to think that as we have! However, in Excel 365 there are a few...
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...
by John Legge | Jan 9, 2019 | Company News, Excel training in Gloucestershire
Excel training in Gloucestershire From Farmers spouses to manufactures to Snow film set providers they all use Excel in Gloucestershire! Excel training these days comes in all flavours and here at JPL we seek to meet a variety of needs; we have 5 ‘flavours’ of Excel...
by John Legge | Feb 6, 2018 | Company News
Introductory VBA Programming – Master Class Excel Silver content We are delighted to introduce a section on introductory Excel VBA programming into our new Excel Master Class Silver course. This session takes the scope of PowerPoint illustrations, worked...
