Free Online Microsoft Training
Free tips and tricks for using Microsoft 365 and Windows
Free Online Microsoft Training
Of all the features available within Microsoft Excel, the AutoFill tool has to be high up on the list of those used most frequently. Often though the AutoFill feature is
A common question I see during training is “Why do my files say [Compatibility Mode] in the title bar area?” and this is a good question. Today I want to
So you’ve discovered Sparklines in Microsoft Excel and now you want to jazz them up? You’ve come to the right place. In my previous post (link here) I outlined what
I can hear you asking it now, what is a Sparkline? It’s a very good question which I’m going to answer for you now. Sparklines were introduced in Excel 2010
The VLOOKUP function in Excel is one of the most widely used lookup functions, but it can sometimes be tricky to get it working. The VLOOKUP function is a fantastic
For years I have been creating screenshots for various reasons; for use in training courseware; to illustrate to a remote user a button I want them to press; to relay
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 Excel graph. Either way
Microsoft Excel is a fantastic program allowing you to collate, analyse and make sense of data quickly. If you’re just starting on your Excel journey, then it is worth learning
One feature that MOST users are familiar with is the Cut, Copy and Paste function. The ability to cut, copy and paste within any of the Microsoft applications or third-party
At the start of almost every Microsoft course I teach, I discuss the options you have to customise any of the Microsoft 365 products. The Quick Access toolbar (QAT) is
This week, someone asked me how to use concatenate with Excel to allow them to join text together from different columns into one cell. The CONCATENATE function is perfect for
If you’re new to Excel, learning how to use basic Excel formulas is an essential skill. Here I will step you through the process I use when teaching Excel to