Please note javascript is required for full website functionality.
MVP

Blog

Blog

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


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.


VBA Blog: 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 Tips: 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.


Newsletter