Last week we finished creating our queries and got our Powerball data together. Let’s have a look at the field pane to see what tables are available to use.

Welcome to our Power Query blog. This week, I look at an example where data comes in one Excel column and needs to be converted to a table.

Can we use more than one criteria with the CALCULATE function?

On the final Friday of each month, we set an Excel problem for you to puzzle over for the weekend. On the Monday, we publish a solution. If you think there is an alternative answer, feel free to email us. We’ll feel free to ignore you.

On the final Friday of each month, we’re going to set an Excel challenge for you to puzzle over so that you can get your “Excel fix”. Challenge your office colleagues to see who can solve the puzzle quickest. There’s no prizes at this stage, you’re playing for bragging rights only!

Last week, we successfully extracted the names of the columns from the metadata of the JSON file. Now it’s time to put the two queries together!

Welcome to our Power Query blog. This week, I look at splitting data using a variety of delimiters.

Welcome back to our Power Pivot blog series. Today we discuss a function that we can use in developing measures.

Welcome back to our regular A to Z of Excel Functions blog. Today we look at the DCOUNTA function.

Last week we ran into the SearchOrder parameter of the Find function. We knew that we could go right across the row or down the column. But what if we wanted to manipulate the direction of which we searched? Instead of going down the columns using xlByColumns what if we wanted to go up?