Multi-National Excel Dashboard

Excel dashboards are fantastic and a wonderful way to show a point in time snap shot of any number of corporate, customer, household positions. They convey high level information in a succinct one page data collection point

Excel Dashboard Example

This Excel dashboard is a summary of seven departments within a banking environment. It summarises the financial performance by region showing sales, commission, performance against plan and prior year to data and some human resources metrics by each department.

Tags Excel, Dashboards

Change Pivot Table Filter From Cell

Changing a pivot table filter when a cell changes in Excel. This can be done with a data validation list or a slicer connected to a different data source.

Excel Dashboard Designs

An Excel dashboard split into three levels the dashboard displays information by state and gives some of the key performance indicators for each of the business areas.

Tags Excel, Construction, Dashboard

Upload Data with Power Query

Uploading data with Power Query from multiple files into a single Excel database is really simple these days. The process is embedded inside Power Query and once the process is set up, it is just a matter of refreshing the query and new data will be instantly imported.

Excel File Picker VBA

Choosing a file with as an Excel file picker can be useful if you want to be able to pick a specific file to edit in a VBA procedure.

Tags excel, file, Dialog, picker, open, directory

Connect Slicer to Multiple Data Sources

Connect Slicer to multiple data sources

Tags Excel, PowerPivot, Slicer, Connect, Multiple, Tables

Transfer Data Between Arrays with VBA

Transfer data in a VBA range into an array and then output part of the array into another array. Push the information back into Excel seamlessly.

Tags Excel, Array, Transfer, data

Checking if Folder Exists with VBA

Checking if a folder exists with the use of VBA. This blog post takes you through the steps of checking if a folder exists and if not creating a new folder.

Scripting Dictionary with Ranges

Check to see if folder exists, VBA.

Tags Excel, scripting dictionary, Range

Excel vba Scripting Dictionary

The Excel scripting dictionary from the ground up. This blog post explains how the dictionary interacts with practical examples with an explanatory video series .

Tags Excel, scripting dictionary, How to

List All Sheets in a Excel Workbook

Creating worksheet tab names in a distinct and uneatable list is a tedious task. Using Excel VBA is the answer to this problem.

Tags Excel, VBA, Name all sheets, In Workbook

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

Advanced Filter - Child Sheets

Using the Advanced filter in Excel to dynamically create child sheets from a parent list.

Telling a Story with an Excel Dashboard

Inspiring Excel dashboards that are functional and tell a compelling story.

Tags excel, Dashboards, Income statement

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