by admin | Aug 14, 2015 | Case Studies - How To
A reader of this newsletter (who wishes to remain anonymous), send me a really interesting file which he uses to quickly enter dates and times. Dates and times can be a bit fiddly to enter as they have to be entered with / for dates and : for times. He came up with a...
by admin | Aug 4, 2015 | Case Studies - How To
Array formulas…one of those things I get asked about maybe once a year. Also the very word “array” makes me go looking for bad puns… One thing it tells me is that the questioner is a serious Excel head. They ain’t no Excel sissy, no...
by admin | Jul 8, 2015 | Case Studies - How To
Quite recently I was teaching a class, afterwards I got chatting to one of the participants and it turned out that she does a lot of coaching with runners. Of course I picked her brains about some stretching techniques and she gave me some great tips about pre-running...
by admin | May 25, 2015 | Case Studies - How To
Well, in Ireland recently we had an historic day when same sex marriage was voted in (first country in the world to do so…). It was also known as the Thirty-fourth Amendment of the Constitution (Marriage Equality) Bill 2015. You can read more about it at...
by admin | May 19, 2015 | Case Studies - How To
I recently met with a friend of a customer and after I let him into the secret of pivot tables, he asked me about helping him create two dropdown lists. The idea being that the contents of the second one would depend on what was chosen in the first one. In the example...
by admin | May 18, 2015 | Case Studies - How To
I recently got asked this in class..one of the students had received a file from one of their customers (who had hidden some of the rows) and he wanted to only get the total for the visible, filtered rows. I tried a couple of things – including Visible Cells...
