by admin | Mar 8, 2021 | Excel | Useful tricks
Ah, yes that joyful scenario. You have a list – a great big juicy list and you want to scroll down that list but oh no my headings have disappeared…WHAT DO I DOOOOO? Well I *have* heard of people who have sellotaped the headings onto their...
by admin | Apr 28, 2015 | Excel | General, Excel | Useful tricks
Anyone get that song reference? I give you a clue down the bottom of the post… Well have to say I do love my students (in a good way…not a weird way I hasten to add. :-).). I recently had a woman in class who had the following Excel conundrum… She...
by admin | Aug 11, 2014 | Excel | General, Excel | Useful tricks
Not so long ago I was asked by a user for help with her file. She wanted people to be able to sort and filter but not do ANYTHING else with it. Of course I went to try my usual things of setting up protection Review – Protect Sheet – tick Sort, tick...
by admin | Jun 2, 2014 | Excel Pivot tables | Introduction, Excel | Case Studies, Excel | Useful tricks
I was recently teaching a class on Powerpivot and the subject came up of how to use Excel to construct an aging analysis. The person had already created some serious serious formulas to do what he needed to do so no point in re-inventing the wheel. His big interest...
by admin | Oct 24, 2013 | Excel | Useful tricks
I recently came across an interesting problem. A student in one of my classes asked me to help her set up some If functions which I did and which worked fine. It was a function to say that if a cell was blank, then the answer was to show today minus the days in F2,...
by admin | Sep 3, 2013 | Excel | General, Excel | Useful tricks
In a previous post, I covered some of the basics of using hyperlinks to link to other documents but today I’m going to show you how to link to specific cells (or if you are feeling a bit adventurous :-)) to some named ranges. Also note that you can hyperlink to...