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

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