Populate a Userform with VBA

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

Read More

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.

Read More

Excel VBA Remove Duplicates Multiple Columns

Remove Duplicates from multiple columns in Excel with VBA.

Read More

The Tennis Chart

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.

Read More

Smallman Interview

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

Read More

Excel Summit South 2019

The Excel Summit South run by Sumproduct.

Read More

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.

Read More

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. 

Read More

Excel Dashboard by City

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.

Read More

Excel Timesheet Example

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

Read More

When TRIM Doesn't Work in Excel

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.

Read More

Excel Now Has 3D Pictures

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

Read More

Using Index as a Dynamic Range

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

Read More

Advanced Excel Skills

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

Read More

Excel Dashboard Reports and Courses

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.

Read More

Convert Formula to Relative or Absolute

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

Read More

Convert Entire Excel Workbook to Values

Convert an entire workbook from formulas to numbers instantly.

Read More

Evaluate with Excel to Extract Sequence

Use the Evaluate function in Excel to populate a cell from a number sequence.

Read More