There is something about this time of year for solving old problems!  Last week I just suddenly swung into action buying something I should have bought years ago?  I am a lefty and recently been getting a little sore in …

Left-Handed Mouse Read More »

I wanted to see if I could get Excel’s Power Query (Get & Transform on the ribbon of course) to drive the showing or hiding of columns in a report.   In the past I would do this with VBA effectively …

Hide and Show columns with Power Query Read More »

Matt Allington the well known Power Pivot, Power BI and Power Query expert and author has recently posted a great off topic article How I Manage My Day with Microsoft ToDo on using Microsoft To Do effectively.  It’s really worth …

5 Tips on better using Microsoft To Do Read More »

So in my previous post I was banging on about the new Dynamic Array formulas only fairly recently released to Office 365 Excel.  I reckon FILTER() is the star but as I used it, I became a little disappointed as …

Use new FILTER() formula and retrieve only the columns you want Read More »

The new Dynamic Array functions are now in Office 365 Excel!  I have been playing around with some of them namely FILTER, UNIQUE and SORT which are awesome! Excel MVPs have helped us all with a ton of videos and …

Taking the new Dynamic Array functions out for a spin Read More »

You may get a laugh from this hilarious compilation from the IT Crowd’s recurring theme so many people working in IT can relate to … “have you tried turning it off and on again” The equivalent in the Excel world …

IT Crowd – Have you tried turning it off and on again Read More »

We recently put solar panels on our roof and so I have become interested in solar energy and how it all works.  If anything lends itself to being set out in a spreadsheet or financial model it is this subject!  …

Household Solar Energy Spreadsheet Read More »

I do data cleaning day in day out.  We all do.  This technique from Leila Gharani on You Tube is just so awesomely simple and effective you just wonder why you haven’t thought of this before.  It works on the …

Really good, simple data cleaning technique from Leila Gharani Read More »

Here is a quick but really useful coffee break tip. I used this handy INDEX + MATCH based formula the other day and thought it was a good one to share… Say you have this typical accounting situation where you …

Dynamic sum formula for summing between two dynamic columns Read More »

If you are new to workbooks with macros here is a short 2 min video on the quick setup needed to work with them on your PC’s Excel and some basic points in which to be aware.  

I don’t often re-post, but hard not to with this really good post from Kevin Roper of the Society of Actuaries on Excel VBA speed and efficiency  Well worth the read. https://www.soa.org/news-and-publications/newsletters/compact/2012/january/com-2012-iss42/excel-vba-speed-and-efficiency/

I hope you enjoy this YouTube from Matt Parket’s stand up routine on Excel spreadsheeting