Please note javascript is required for full website functionality.

Blog

VBA Blogs: Looking Up and Down

11 May 2018

Last week we set the After parameter for the Find method to distinguish which cell we wanted to start from. But it defaulted to go across the row. It can be set in order to go down the columns first using the SearchOrder parameter.


Power BI Blog: Just Speculate Over Numbers - Part 2

10 May 2018

Power BI exercise focusing on JSON files using the NY Powerball data.


Power Query: X Marks the Spot

9 May 2018

This week, I look at a simple method to convert a check box into a name (next time I will move up a gear!).


Power Pivot Principles: Drawing a BLANK on Error Traps

8 May 2018

How to include error traps in our measure formulae.


A to Z of Excel Functions: The DBCS Function

7 May 2018

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


VBA Blogs: After You

4 May 2018

Having stumbled upon the Find method last week, we’re going to lay fingers on some of the parameters. Last time we did the basic search looking for a simple string within a Range. Let’s go back to our worksheet last week: ...


Power BI Blog: Just Speculate Over Numbers - Part 1

3 May 2018

Power BI exercise focusing on JSON files using the NY Powerball data.


Power Query: Thanks for the Memory

2 May 2018

This week, I look at what to do if you are short of memory.


Power Pivot Principles: Measure Creation in Practice

1 May 2018

Today we discuss proper practices we should adopt when creating measures.


Monday Morning Mulling: April 2018 Challenge

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


Newsletter