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...
Creating a pivot table and chart in Excel – how do I do this? Find out how this week below… One of the most useful and powerful features companies can use in Excel is the ability through Pivot Tables to analyse and summarise data. We deliver the following...
Microsoft Office Specialist – looking at 3D Maps in Excel, have you used them? Here at JPL we continually strive to improve the variety of Microsoft Office courses in the Midlands and further afield. We thought you may like to see a short video of the towns...
Excel exposure: Colour in Excel Excel – gone colour mad!! This week’s blog focusses on colour in Excel. We’ve done this before so it contains a new feature in Excel 365 as well as recapping on a traditional one that we have covered already in a previous hint and tip....
BODMAS in Excel This week was a first for John on a Basic Excel training session he delivered for 6 people in Hereford. You may know the concept of BODMAS from your days back at school in the maths classroom, which dictates the order in which calculations are...
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.