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?

Remember last week we brought in our JSON file and focused on transforming and preparing the dataset portion. This time, we’re going to retrieve the column names from the metadata.

Welcome to our Power Query blog. This week, I look at a more comprehensive method to convert a check box into a name.

After importing data into Power Pivot, we may wish to create a PivotTable.

Today we look at the DCOUNT function. This function counts the cells that contain numbers [not text which looks like numbers] in a field (that’s jargon for a column!) of records in a list or table that match one or more conditions you specify.