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

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

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

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

Extract the First Item from a Horizontal List

In Excel extract the left most item from a horizontal list using INDEX and MATCH.

Read More

Create Number Sequence with VBA Custom Function

An Excel custom function that allows sequental number sequences to be created.

Read More

Countifs Across Sheets

Add a count formula across multiple sheets in Excel.

Read More

New Excel Dashboard Tools

This is a list of Excel dashboards - the best I have produced to date.  These are time saving Excel tools which you can purchase from Eloquens.

Read More

Watch This Space

No Spaces in Excel sheet names is a good habit to get into.

Read More

The Fuzzy World of Financial Modelling

This post is about financial modelling, how to do it and what is important when it comes to manipulating Excel data.

Read More

Excel Autofill - Fill Down to Bottom of Range

In Excel you may wish to drill down on a range which has a header value not already contained in the rows.  The following article shows a practical example of how to generate a unique row name based on the heading in a specific place.  The procedure is in VBA.

Read More

Social Media Dashboard in Excel

This is a social media dashboard created in Excel.  It is free to download and has all of the graphs and source formula in the file.

Read More

Range Areas in Excel with VBA

Trap a range area with VBA and loop to next range area.  This little used Excel VBA technique is awesome and a real win when you learn the mechanics of it.

Read More
Tags , , ,