Power BI Desktop Dashboard

A Power BI Desktop example using Power BI

Read More

New Excel Dashboard Tools

This is a list of Excel dashboards - the best I have produced to date.  These are time saving Excel tools.

Read More

Watch This Space

No Spaces in Excel sheet names is a good habit to get into.

Read More

The Fuzzy World of Financial Modelling

This post is about financial modelling, how to do it and what is important when it comes to manipulating Excel data.

Read More

Excel Autofill - Fill Down to Bottom of Range

In Excel you may wish to drill down on a range which has a header value not already contained in the rows.  The following article shows a practical example of how to generate a unique row name based on the heading in a specific place.  The procedure is in VBA.

Read More

Social Media Dashboard in Excel

This is a social media dashboard created in Excel.  It is free to download and has all of the graphs and source formula in the file.

Read More

Range Areas in Excel with VBA

Trap a range area with VBA and loop to next range area.  This little used Excel VBA technique is awesome and a real win when you learn the mechanics of it.

Read More
Tags , , ,

Revenue and Expense Infographic Construction Industry

This is an Excel infographic covering he construction industry.  It displays revenue and expenses with some relevant pictures and charts.  You should be able to modify it to your industry.

Read More

More Dashboard Updates

This is a post about updates to the Excel Dashboard section of the smallman site.

Read More

Find Closest Match in Excel

Find the closest match in a range of cells and highlight that match.

Read More

Delete Blank and Zero Value Cells from Columns

Remove blank or zero values from a range of cells in one swift movement with the help of Excel VBA.

Read More

Make Excel Speak

Make Excel talk or speak words from text in a cell.  Use Excel's voice commands to have a bit of fun with your friends.

Read More

Excel - Too Many Different Cell Formats

Excel too many different cell formats - this VBA solution will fix the problem.

Read More

Project Modelling in Excel

An Excel model which focuses on a wind farm in Brisbane.

Read More

Excel Looping Through Sheet Code Names

This is an Excel VBA procedure to loop through worksheets using the worksheet code name.

Read More

CPA Australia's Management Accounting Conference

Presenting at the Management Accounting Conference 2017.

Read More

12 Month Rolling Chart

A 12 month rolling chart in Excel which will update both forwards and backwards dynamically on a chart.

Read More

Life on the Road

This years travel has finally commenced.  It has been a long time since I hit the road in any real way late last year from memory but once it starts it is the gift that keeps on giving.

Read More