Excel Dashboards: Tracking a Crisis

A free Excel Dashboard webinar on how to build a data tracking document from scratch. It is a highly interactive Excel dashboard that has automation embedded into it.

Tags Excel, Dashboards, Webinar, Free

Premium Excel Dashboard Models

Premium Excel dashboards video demonstration of functionality.

Tags Excel, dashboards, premium models

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

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

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

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.

Tags trim, clean, Excel, won't work, doesn't work

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.

Tags Excel, Index, Offset, Dynamic, Ranges, Dynamic formula

Advanced Excel Skills

Excel advanced skills - what do you need to know to have advanced Excel techniques. The type of Excel skills that will help you be considered advanced amongst your peers. These Excel skills are a great place to start.

Tags Excel, Advanced, Features, Skills, Advanced Excel Skills, conditional formatting

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.

Tags Excel, Dashboard, Dashboards, Course, Beautiful Dashboards