Charity Data Geek

If you're working in Power Query, and you need to add a whole bunch of blank rows, or rows based on the value from another column. How d...

Power Query has a "Count Rows" button, but there's no equivalent button for when you want to quickly get the total of your val...

I couldn't find a direct answer to this question, so thought, once I'd managed to piece it together I'd post it here for any fut...

I've had an iPad for over a decade and always found it's keyboard, particularly the lack of backwards and forwards keys, frustrating...

Often you have a lot of files in a folder and for some reason you want to paste them in Word, Excel, Notepad or something else, but a straig...

Say you run a series of events and want to display registration, attendance etc on a bar chart in Power BI. The length of the event names an...

As per my previous post sometimes, for tidiness you just want to do something in a single step. So how do you do this with merging / joining...

If you like keeping things neat and understandable in Power BI then you probably like to minimise things to one line. So there are times whe...

If you're working with both Google Analytics and Google Search Console you've probably tried at some stage to get your head around r...

There's a useful blog post here  on how to convert text formatted in a certain way in MS Word with something else. What it doesn't d...