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...
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...
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...
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...
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...
We have placed cookies on your device to help make this website better.
You can use this tool to change your cookie settings. Otherwise, we’ll assume you’re OK to continue.
Some of the cookies we use are essential for the site to work.
We also use some non-essential cookies to collect information for making reports and to help us improve the site. The cookies collect information in an anonymous form.
