An Excel sales dashboard which focuses on quarter and YTD data. It has a slicer and spins on a monthly combo box.

The wildcard character and SUMPRODUCT are like oil and water, they just don’t gel well together.  The beauty of SUMPRODUCT is somewhat tarnished with its inability to play nicely with the Wildcard * character.  The focus of this article will be to demonstrate how to work around this constraint using a number of examples. 

The following Excel dashboard is a trending dashboard which highlights some key organisational metrics by city. As the data is displayed by city I thought I might present the data with some infographics around the cityscape relevant to each city.

Creating an excel timesheet is easier with a template to start with. This blog post provides the template and the instructions for using it.

This article will focuses on what to do when the TRIM formula does not work as expected. It looks at alternatives to solve the problem.

Excel now has moveable changeable 3D image library just for you!!! Adding the library pictures to your reports is a simple task.

Creating a dynamic range formula without getting volatile. Using the INDEX formula in a creative way to make dynamic calculations.

Excel advanced skills - what do you need to know to have advanced Excel techniques.

Excel Dashboards can make life a lot easier when they are ready made. Take the design and structural setup out of the dashboard process and purchase these premium Excel Dashboards.

Convert an Excel range from one reference to relative or absolute referencing.