Excel training Smallman Excel Training Courses

Thesmallman.com offers Excel financial modelling courses, Excel dashboard 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


Smallman Excel Workshops

Course   Location   Date  
Three Statement Financial Modelling     Sydney 5 April 17
Three Statement Financial Modelling     Melbourne 6 April 17
Dashboard Design in Excel         Melbourne 4 May 17
Advanced Dashboard Design in Excel     Melbourne 5 May 17
Advanced Financial Modelling Using Excel     Melbourne 10 May 17
Dashboard Design in Excel     Sydney 11 May 17
Advanced Dashboard Design in Excel     Sydney 12 May 17
Financial Modelling in Excel     Sydney 15 May 17
Advanced Financial Modelling in Excel     Sydney 16 May 17
Financial Modelling Using VBA     Melbourne 21 August 17
Project Modelling in Excel     Melbourne 22 August 17
Financial Modelling Using VBA     Sydney 24 August 17
Project Modelling in Excel     Sydney 25 August 17
Dashboard Design in Excel     Melbourne 15 November 17
Financial Modelling in Excel     Melbourne 16 November 17
Three Statement Financial Modelling     Melbourne 17 November 17
Dashboard Design in Excel     Sydney 20 November 17
Financial Modelling in Excel     Sydney 21 November 17
Three Statement Financial Modelling     Sydney 22 November 17
Advanced Dashboard Design in Excel     Sydney 4 December 17
Advanced Financial Modelling in Excel   Sydney 5 December 17
Advanced Dashboard Design in Excel     Melbourne 7 December 17
Advanced Financial Modelling in Excel   Melbourne 8 December 17
* Blue Denotes Completed Course      

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
Creating an ABA File in Excel Online 11 July 17
Summarizing and Consolidating Financial Data Online 8 August 17
Financial Modelling in Excel Online 10 September 17
Creating Linked Combo Boxes to Generate Reports Online 10 October 17
Forecast Development Using Excel Online 14 November 17
Financial Dashboard Design 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

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