Excel VBA to Select Sheets

Excel VBA to select sheets and print out the selected sheets using PDF.

Power BI Desktop Dashboard

A Power BI Desktop example using Power BI

New Excel Dashboard Tools

This is a list of Excel dashboards - the best I have produced to date. These are time saving Excel tools which you can purchase from Eloquens.

Tags Excel, Dashboards, Tools, Premium Models

Watch This Space

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

Tags Excel, Sheet names, No Spaces

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.

Tags Excel, Financial Modelling, Dashboards

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.

Tags Excel, VBA, Drill down, Fill down, filldown, autofilter

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.

Tags Excel, Dashboard, Social media

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.

Tags Excel, Range, Area, Loop

Construction Industry Infographic

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.

Tags Excel, indographic, construction, Revenue, Expense, Asset

More Dashboard Updates

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

Tags Excel, Dashboard, Reports

Find Closest Match in Excel

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

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.

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.

Excel - Too Many Different Cell Formats

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

Project Modelling in Excel

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

Excel Looping Through Sheet Code Names

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

Select First Item in a List Box Automatically with VBA

CPA Australia's Management Accounting Conference

Presenting at the Management Accounting Conference 2017.

Full and Part Summaries with the Dictionary

Creating summaries using the Excel VBA scripting dictionary is something you will want to learn. The dictionary is powerful and can summarise data very quickly. This blog post takes you through the process of using the Excel Scripting Dictionary.

Tags Excel, scripting dictionary, Sum, Multiple, Columns