Please note javascript is required for full website functionality.

Blog

Final Friday Fix: May 2018 Challenge

25 May 2018

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!


Power BI Blog: Just Speculate Over Numbers - Part 4

24 May 2018

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!


Power Query: Splendid Splitting

23 May 2018

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


Power Pivot Principles: Introducing CALCULATE

22 May 2018

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


A to Z of Excel Functions: The DCOUNTA Function

21 May 2018

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


VBA Blogs: Digging Up

18 May 2018

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?


Power BI Blog: Just Speculate Over Numbers - Part 3

17 May 2018

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.


Power Query: X Marks the Spot - Unleashed

16 May 2018

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


Power Pivot Principles: Power PivotTables

15 May 2018

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


A to Z of Excel Functions: The DCOUNT Function

14 May 2018

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.


Newsletter