by John Legge | Dec 16, 2020 | Excel Tips, Hints and Tips, Microsoft Office Courses Buckinghamshire
Useful Excel Features – how can I use the flash fill and text to columns features in my spreadsheets? Watch the video to learn more This week’s hint and tip is on the some Excel useful features. The features we take a look at are flash fill and text to...
by John Legge | Oct 28, 2020 | Excel Tips, Hints and Tips, Microsoft Office Courses Buckinghamshire
Ways to view a Formula in Excel – how can I see what is actually in my formulas? Watch the video to learn more This week’s hint and tip is about ways to view a formula in Excel. This is mentioned in our Basic course but we decided to create a hint and tip...
by John Legge | Jul 15, 2020 | Excel Tips, Hints and Tips, Microsoft Office Courses Buckinghamshire
Dynamic Arrays in Excel 365 – how can I use this in my worksheets? This week’s hint and tip is about dynamic arrays in Excel 365 and how you can use it in your worksheets. This feature isn’t covered in our courses, so we wanted to create a hint and...
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 | Mar 21, 2019 | Excel Tips, Hints and Tips, Microsoft Office Courses Buckinghamshire
Learning Excel through games – Episode 1 Excel is used on a daily basis by people all over the world with most of them constantly learning Excel in their work. It has lots of features that can be used from a basic to a more advanced level, with one of these features...
by John Legge | Sep 20, 2018 | Excel Tips, Hints and Tips, Microsoft Office Courses Buckinghamshire
MS Excel course – looking at the VLOOKUP function and the different arguments available This week we are bringing you a hint and tip on the VLOOKUP function in Excel. VLOOKUP Function The VLOOKUP function. It is a function that a lot of people either use...
