COGS and Sales Dashboard

A COGS and Sales Dashboard made exclusively in Excel. The dashboard is mostly from a single data source and has a slicer to change the region upon clicking everything will change.

Tags Excel, Dashboard, Sales, COGS, Cost of goods

XLookup to the Party

How to use the XLookup function in Excel.

Tags Xlookup, Excel

Populate a Userform with VBA

This excel article shows you how to populate a user form automatically based on a unique identifier.

Excel Custom Sort

Create a customised sort with the help of Excel. Excel can create custom sorting lists and will sort according to the list which has been created. This article shows you how.

Excel VBA Remove Duplicates Multiple Columns

Remove Duplicates from multiple columns in Excel with VBA.

Tags remove, duplicates, Vba, Excel

I happened across this article on the Brisbane Times website which outlined the dominance of Federer, Nadal and Djokovic in recent memory. This article outlines how the interesting chart is created in Excel.

Tags chart, graph, Tennis, Excel

Smallman Interview

I recently gave an interview for a blog regarding my Excel journey. Here are some snippets from that Blog.

Sales Excel Dashboard

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

Tags excel, dashboard, Sales

Using the Wildcard with SUMPRODUCT

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.

Tags Excel, Sumproduct, Wildcard