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.

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 exercise focusing on JSON files using the NY Powerball data.

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

How to include error traps in our measure formulae.

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

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 exercise focusing on JSON files using the NY Powerball data.

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