Power BI can be set up to automatically refresh reports, grids, pivots and charts when a file is dropped into a folder.

Summing Excel cells by color: an "easy" way and a "hard" way.

The Invalid Use of Nulls error message is common in VBA code when using Microsoft Access. Find out how to write code to deal with it.

Discover three types of dynamic drop-down lists in Excel, and how to create them.

VB Script and VBA are two different things - do you know which is which? What will happen now that VB Script is deprecated?

Is Microsoft Access right for you? Here are several reasons why I often recommend Access to my clients.

Three ways to see your Top 3 <<things>> in Excel using conditional formatting, the RANK function, and Pivot Table filters.

Here are 3 good reasons to use named ranges in Excel.

Create a stopwatch on your Excel worksheet to track hours, minutes or seconds for your task.