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.

Most Popular Author

• December 14, 2023
• Marcus Small

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.

Updating Excel Dashboards

• September 29, 2023
• Marcus Small

An updated Excel dashboard created entirely in Power Pivot.

TheSmallman in Another Top Blog Rank

• April 24, 2023
• Marcus Small

An Excel blog ranking website that has TheSmallman included in a distinguished list of Excel VBA blogs.

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.

Hiding Rows Quickly with VBA

• May 20, 2022
• Marcus Small

Hiding rows with Excel VBA the simple way using a union range. Typically if you want to hide rows very fast with VBA the autofilter is the tool of choice, in a single line with one swift move thousands of rows can be hidden. Amazing.

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.

Find And Replace in Excel - Hidden Issue

• July 2, 2021
• Marcus Small

The Replace function in Excel is fast - really fast and it works very nicely on a range of data to find and replace data. However, the replace function has a hidden bug and this article explores the problem with an example and a video.

Power BI Dashboard Examples

• June 1, 2021
• Marcus Small

Anyone attending any of the CPA Australia Power BI courses that I run will know that I place a lot of emphasis on the final product in Power BI. A well designed dashboard simplifies the data and presents it in a logical manner. The dashboard spins by department.

Highlight Non Formula Text with Conditional Formatting

• May 16, 2021
• Marcus Small

A tutorial on how to highlight cells that have been hard coded as opposed to entered with formula. It allows users to quickly see cells that have had their formula over written.

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.

Multi-National Excel Dashboard

• December 29, 2020
• Marcus Small

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

• 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.

Change Pivot Table Filter From Cell

• October 17, 2020
• Marcus Small

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

• 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.