Please note javascript is required for full website functionality.
MVP

Blog

Blog

A to Z of Excel Functions: the DDB Function

4 June 2018

Depreciation is a method of allocating costs over the useful economic life of an asset (e.g. a building, a car, a computer). This function returns the depreciation of an asset for a specified period using what is known as the fixed-declining balance method...


VBA Blog: Finding the Part of a Whole

1 June 2018

Last week we looked at using the After, SearchDirection and SearchOrder parameters of the Find method.


Just Speculate Over Numbers – Part 5

31 May 2018

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.


Power Query: Candid Columns

30 May 2018

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.


Power Pivot Principles: Doing More with CALCULATE

29 May 2018

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


Monday Morning Mulling: May 2018 Challenge

28 May 2018

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.


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


Power BI Tips: 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.


Newsletter