Excel training Smallman Excel Training Courses

Thesmallman.com offers Excel financial modelling courses, Excel dashboard courses, Excel PowerPivot and Power BI courses and Excel VBA courses. The Excel courses on offer and the details are on the Excel Training section of the site. Please email me (bottom of page) if you wish to engage in training at your workplace.

My Schedule is below the list of courses: Smallman Scheldule

Current courses include:

I will train up to 20 people for a fixed daily rate, which is considerably more economical than engaging a large training establishment.


Full day courses I conduct for CPA Australia.

3 Statement Modelling in Excel

Advanced Dashboard Design

Visual Analytics

VBA for the Financial Analyst

Advanced Financial Modelling

Financial Modelling in Excel

Project Financial Modelling

Power BI Desktop

Smallman Excel Workshops

2018 Education Program to be uploaded shortly.

The following is a link to CPA Australia courses where you can enrol for face to face training.

CPA Australia Excel Resource


CPA Australia Webinars 2017

The following are Excel online webinars I will conduct for CPA Australia.  They occur at lunch time and go for 1 hour on topics which heavily focus on Excel.  This is the third year I have conducted these webinars and there are 34 on the CPA site in addition to what is listed below.

Webinar Location Date
Budgeting in Excel Online 14 February 17
Exception Reporting in Excel Online 14 March 17
Analyzing and Managing Data Online 11 April 17
Time Saving Excel Shortcuts Online 9 May 17
An Amortization Schedule in Excel Online 13 June 17
Lookups, Indexes and Pivot Tables Online 11 July 17
Summarizing and Consolidating Financial Data Online 8 August 17
Creating Linked Combo Boxes to Generate Reports Online 10 September 17
Forecast Development Using Excel Online 10 October 17
Financial Dashboard Design Online 14 November 17
Automating PDF and Email from Excel Reports Online 12 December 17
* Blue Denotes Completed Course

The following is a link to CPA Australia courses where you can enrol in the webinars.

CPA Australia Excel Resource


CPA Australia Recorded Webinars (2015/16)

The following are Excel online webinars I have previously conducted for CPA Australia.  These webinars are available on the CPA website.    CPA Australia Excel Resource

Webinar   Location   Type  
Dashboarding using linked pivot tables Online Recording
Create a balanced scorecard using Excel     Online Recording
Dashboarding with heat maps     Online Recording
Advanced financial modelling techniques   Online Recording
The whole of organisation dashboard      Online Recording
Essential Excel formulas for the finance professional     Online Recording
Introduction to financial infographics using Excel    Online Recording
What if analysis using Excel      Online Recording
Advanced Financial Modelling in Excel     Online Recording
Revenue and Expense Infographics Using Excel    Online Recording
Rolling Forecasts Using Excel     Online Recording
Whole Of Organisation Infographic Using Excel     Online Recording
Business Valuation Using Excel      Online Recording
An Introduction To Simplistic Vba      Online Recording
Charting For Trend Analysis     Online Recording
Filtering, Sorting And Consolidation Using Vba     Online Recording
Create A Fixed Asset Register In Excel    Online Recording
Looping And Working With Vba Change Events    Online Recording
Monthly Cash Flow Projections Using Excel     Online Recording
An Introduction To Big Data And Business Analytics     Online Recording
Linking The Income Statement And Balance Sheet In Forecasting   Online Recording
Business Modelling Using Big Data     Online Recording
Reporting Key Performance Indicators Using Excel     Online Recording
Dax Analytics And Dashboarding Results     Online Recording
Project Depreciation Schedule Using Excel     Online Recording
Spreadsheet Risks    Online Recording
Long Service Leave Calculator Using Excel    Online Recording
Automating Batch Reporting Using Excel    Online Recording
Discounted Cash Flow Modelling Using Excel    Online Recording
Connecting Financial Statements from Excel to Word    Online Recording
Activity Based Costing Using Excel   Online Recording
Create a FIFO Calculation Model Using Excel    Online Recording
Project Costing Model   Online Recording

Training materials and files will be provided. Laptops will be needed with preferably Excel 2007 or later installed. You can contact me via email: marcussmall@thesmallman.com