by John Legge | Feb 26, 2020 | Excel Tips, Hints and Tips
Replicating your spreadsheet layout…surely there must be a quick way? This week’s hint and tip is about replicating your spreadsheet layout in Excel. These are topics mentioned on both our Basic and Intermediate Excel courses and are firm favourites with... by John Legge | Feb 21, 2020 | Excel Tips, Hints and Tips
Using Borders and Fill Colour in your spreadsheets to make them stand out This week’s hint and tip is about using borders and fill colour in your spreadsheets. This is a section in our Basic Excel course and both can be used effectively to make your spreadsheets... by John Legge | Feb 7, 2020 | Excel Tips, Hints and Tips
Text manipulation in Excel, how to do it and how it can save you time working in your spreadsheets! This week’s hint and tip is on Text Manipulation in Excel. This is a section which is covered in our Advanced Excel course. On this course we look at other... by John Legge | Jan 22, 2020 | Excel Tips, Hints and Tips
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 | Dec 11, 2019 | Excel Tips, Hints and Tips
IF Statement in Excel – do you know how to create one? Watch our video hint and tip to learn how This week’s hint and tip is about looking at the IF Statement. Some of you might have heard of the it before, but for some of you this might be a new... by John Legge | Dec 5, 2019 | Excel Tips, Hints and Tips
SUM function in Excel – the different ways to generate it, have you tried them all? This week’s hint and tip is about the SUM function in Excel and the different ways that you can go about creating it. This function is covered on the Basic Excel course...