If you use Excel Filters then you’ll love this time saving tip. This tip was sent in by Mohammed Mustafa of Jeddah, Saudi Arabia. Once you’ve set up your filters it requires at least a few clicks to apply them, but not anymore. With AutoFilter you can do it in two clicks! Taking the example [...]
June 2012
How to Create a Reverse PivotTable – this is genius. This tutorial was sent in by Bryon Smedley of Bristol, Tennessee. There comes a time when you are presented with data in a cross-tabular format but your analysis requires that the data be formatted into a traditional table (or normalized) structure. Your report is in [...]
Got a cool Excel trick you’re proud of? I thought it’d be fun to hold an Excel Factor competition. Think X-factor (the TV show) but instead of massive fame and prize money (sorry, the budget doesn’t extend that far yet), the prize is that you get to ‘share the knowledge’ with your Excel community and [...]
Want to calculate the number of months between two dates? You’ll be needing the secret DATEDIF function. Try typing =DATEDIF into Excel and it will pretend it doesn’t recognise it – see how it’s not in the list of functions to the left. But if you know the syntax, which I’ll share with you in [...]
... I would highly recommend My Online Training Hub for all your Microsoft Office needs .... Geniuses
