Convert workbooks to the latest file format in Excel
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
Free tips and tricks for using Microsoft Office and Windows
Free tips and tricks for using Microsoft Office and Windows
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
Do you know how to create a Vlookup in Excel? The Vlookup function in Excel is a very popular function but sometimes can be a little tricky to work out.
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 sort data in various formats. Gone are the days of needing a calculator beside you to manually work
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 Office products. The Quick Access toolbar (QAT) is
This week I had a request to show how to join text together from different columns in Excel. For this example, the Concatenate function in Excel works perfectly as it