Charity Data Geek

This is a post I wrote specifically to support my entry to the Storytelling With Data's community monthly challenge for June, which is t...

If you're familiar with Excel before moving to Power Query then it's a little maddening to find that PowerQuery doesn't have a b...

↑ This is a temporary one and not designed to be viewed large as the lines are a bit wobbly. But I couldn't find a better one out...

If you've ever imported data from a US supplier into a (UK) spreadsheet you may have found that the dates and times have gone wrong in E...

Back October I showed how to run a quick sum of a column in Power Query. But I curious to know how I could see this total alongside a count...

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...