Inflation Over Multiple Years in a Single Cell

• January 10, 2025
• Marcus Small

A financial model often estimates the financial results for a single company within the broader economy, focussing on microeconomic difficulties. This article outlines how to add inflation over multiple periods in a single cell.

Hubspot Dashboard

• October 3, 2024
• Marcus Small

Monthly Dashboard With Supporting Metrics

• September 25, 2024
• Marcus Small

A guide to dashboard design. Outlining several crucial phases that are involved in creating an Excel dashboard:

Run Macro Overnight Automatically

• June 24, 2024
• Marcus Small

Split File into Parts and Save to Directory

• April 20, 2024
• Marcus Small

In this article we will split a file into many different subsets and save each subset to the directory of your choice.

Creating an Excel Dashboard - A Guide with Templates

• December 8, 2023
• Marcus Small

Real Estate Excel Dashboard

• October 11, 2023
• Marcus Small

An Excel dashboard that displays USA real estate data USA.

Project Tracking Dashboard

• March 25, 2023
• Marcus Small

Project tracking dashboards are a great way to monitor the progress of a project over time. This is an example of a well laid out dashboard with a number of key operational metrics.

Excel Unique Formula

• September 17, 2022
• Marcus Small

The UNIQUE formula has really changed the game in Excel as a way to interrogate a list and return all of the unique items in that list.

Horizontal Range to Vertical Range in Excel

• June 15, 2022
• Marcus Small

With the advent of Power Pivot the task of flipping data is made very simple. The Unpivot Other Columns command is a bit of a game changer. It easily moves data from horizontal to the more database friendly vertical range very nicely.

Cascading Combo Boxes 3 and 4 Layer

• April 24, 2022
• Marcus Small

Create 3 and 4 level dynamic lists into an Excel data validation on the fly by managing a vertical list with no named ranges. This is the data validation list management tool you have been looking for.

Dashboard Upgrade

• December 30, 2021
• Marcus Small

This is a new Excel Dashboard from an older dashboard I have upgraded. The transformation is complete.

Excel Dashboard Charting with Shapes

• March 6, 2021
• Marcus Small

An Excel dashboard created using excel charts in the form of shapes. It compares data from prior periods with actual data in a beautiful final output.

Excel Dashboard Example

• November 7, 2020
• Marcus Small

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.

Excel Dashboard Designs

• September 23, 2020
• Marcus Small

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.

Connect Slicer to Multiple Data Sources

• May 19, 2020
• Marcus Small

Connect Slicer to multiple data sources

Transfer Data Between Arrays with VBA

• May 12, 2020
• Marcus Small

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.

Scripting Dictionary with Ranges

• April 23, 2020
• Marcus Small

Check to see if folder exists, VBA.

Excel vba Scripting Dictionary

• April 20, 2020
• Marcus Small

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

List All Sheets in a Excel Workbook

• April 17, 2020
• Marcus Small

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