MICROSOFT EXCEL

Save time! Pin a file to the Open list in Microsoft Office
At the start of every training course, I show participants a few really useful features of the Microsoft Office programs. These features save you time dur...
Fri, 5 Nov, 2021 at 5:00 PM
Use conditional formatting to identify dates older than today
Conditional formatting is one of my favourite parts of Excel. I am a very visual person and would much rather look at colour charts or visual representati...
Fri, 5 Nov, 2021 at 5:11 PM
Insert Excel into a Word document
Did you know that you can insert Excel into Word? That’s right, you can have the functionality of an Excel worksheet sitting inside your Word document. Th...
Fri, 5 Nov, 2021 at 5:27 PM
The best keyboard shortcuts in Microsoft Excel
Below is a list of my favourite shortcuts to use in Microsoft Excel. Don’t worry about writing these ones down, you can receive a PDF copy of all keyboard...
Fri, 5 Nov, 2021 at 5:31 PM
How to disable the Start Screen at startup in Office programs
For some users, the preference may be to skip this step and go straight into the application and begin working immediately whilst others are happy with th...
Fri, 5 Nov, 2021 at 5:40 PM
Create a Vlookup in Excel
The Lookup Function is a fantastic time-saver. It is a perfect example of how Excel can “do the work for you”. For those who have not heard of the lookup ...
Fri, 5 Nov, 2021 at 6:58 PM
Create an Excel graph or chart in under 30 sec
Microsoft Excel provides a great way to summarise and analyse data using charts. The terminology used can differ between referring to them as charts or an...
Fri, 5 Nov, 2021 at 7:47 PM
Formula Basics in Excel
For anyone who is completely new to Excel or is wanting to venture into the world of formulas and functions, this post is here to give you some basic tips...
Fri, 5 Nov, 2021 at 9:16 PM
The Office Clipboard – a hidden treasure
A common feature used within all of the Microsoft Office applications is the cut, copy and paste feature. I personally use this A LOT. The ability to cut,...
Fri, 5 Nov, 2021 at 9:30 PM
Customise the Quick Access Toolbar
At the start of almost every Microsoft course I teach, I discuss the options you have to customise any of the Microsoft Office products. The Quick Access ...
Mon, 8 Nov, 2021 at 6:21 PM