GFC Learning
Is it between?
What do you mean, Excel doesn't have a Between function?
Tips & Tricks for Excel Dynamic Spilled Arrays
The new dynamic spilled arrays and the new Excel calculation engine allow us to do so much more with data now. Here are some tips and tricks I have learnt over the past few months
Visualising UK Covid-19 Data - Part 4
A recent news report suggested that Covid-19 cases in England and Wales are increasing once more. Here we look at actual numbers in the data for 2023
Visualising UK Covid-19 Data - Part 3
A recent news report suggested that Covid-19 cases in England and Wales are increasing once more. Here we look at data for 2023 and show the data on a UK map
Visualising UK Covid-19 Data - Part 2
A recent news report suggested that Covid-19 cases in England and Wales are increasing once more. Here we look at data for 2023.
Visualising UK Covid-19 Data - Part One
A recent news report suggested that Covid-19 cases in England and Wales are increasing once more.
Making non-pivot tables summaries - Part 3
Sometimes people will mess up your pivot tables. Sometimes people will be terrified of pivot tables. In this third part of this series on non-pivot pivot tables, we look at the two new functions - HSTACK and VSTACK - combine them both with LET and we have true one cell reports.
Using comments in Power Query
Comments are essential when developing power query items. They help to remind users what is happening and also for you develop the initial query.
Making non-pivot tables summaries - Part 2
Sometimes people will mess up your pivot tables. Sometimes people will be terrified of pivot tables. In this second part of this series on non-pivot pivot tables, we look at the LET function to create one cell reports
What do these even mean?
A project manager from a few years ago was very fond of management speak. Here are some of his classics
Making non-pivot tables summaries - Part 1
Sometimes people will mess up your pivot tables. Sometimes people will be terrified of pivot tables.
Adding Multiple Columns in Power Query
Adding multiple columns in Power Query can involve adding may steps. How about if it was possible to add many columns in one step?
Presidential Donations
How much were donations made to Presidential Campaigns?.
Making parameters a record
Using a record to store your worksheet parameters.
How to parameterise
There are many ways to use parameters in Power Query. Here's my favourite method
Zooming
Zooming the Power Query Editor Window
Welcome to GFC Learning
Welcome to my blog, GFC Learning.