Excel Webinars for CPA Australia

In 2015 I will be conducting a series of webinars for CPA Australia. These events will be held monthly for approximately 1 hour.  The target audience is accountants and finance professionals who want to improve their Excel knowledge.  For accountants the webinar provides the added advantage of providing CPD hours.  
 
Just released

CPA 2016 Excel Webinar Series

  • Dashboarding using linked pivot tables (19 Jan 2016)
  • Create a balanced scorecard using Excel (09 Feb 2016)
  • Dashboarding with heat maps (16 Feb 2016)
  • Advanced financial modelling techniques (08 Mar 2016)
  • The whole of organisation dashboard (15 Mar 2016)
  • Essential Excel formulas for the finance professional (12 Apr 2016)
  • Introduction to financial infographics using Excel (19 Apr 2016)
  • What if analysis using Excel (10 May 2016)
  • Revenue and expense infographics using Excel (17 May 2016)
  • Rolling forecasts using Excel (14 Jun 2016)
  • Whole of organisation infographic using Excel (21 Jun 2016)
  • Business valuation using Excel (12 Jul 2016)
  • An introduction to simplistic VBA (19 Jul 2016)
  • Charting for trend analysis (09 Aug 2016)
  • Filtering, sorting and consolidation using VBA (16 Aug 2016)
  • Create a fixed asset register in Excel (13 Sep 2016)
  • Looping and working with VBA change events (20 Sep 2016)
  • Monthly cash flow projections using Excel (11 Oct 2016)
  • An introduction to big data and business analytics (18 Oct 2016)
  • Linking the income statement and balance sheet in forecasting (08 Nov 2016)
  • Business modelling using big data (15 Nov 2016)
  • Reporting key performance indicators using Excel (13 Dec 2016)
  • DAX analytics and dashboarding results (20 Dec 2016)

CPA 2015 Excel Webinar Series

The webinars from 1 - 11 are as follows;
  • Forecast Development Using Excel (4 Feb 2015)
  • Financial Dashboard Design (4 March 2015)
  • Project Depreciation Schedule Using Excel (1 April 2015)
  • Long Service Leave Calculator Using Excel (6 May 2015)
  • Spreadsheet Risks  (3 June 2015)
  • Automating Batch Reporting Using Excel  (1 July 2015)
  • Discounted Cash Flow Modelling Using Excel  (5 Aug 2015)
  • Connecting Financial Statements from Excel to Word  (2 Sep 2015)
  • Activity Based Costing Using Excel  (7 Oct 2015)
  • Create a FIFO Calculation Model Using Excel  (4 Nov 2015)
  • Project Costing Model  (2 Dec 2015)

Blue are complete and if you are interested can be downloaded from the CPA site.
 
The webinars will be practical as I intend to design a model for each course.  Learning is best facilitated by doing in my opinion and these webinars will be practically focused with almost 100% crowd participation.  I expect even the most hardened Excel criminals to learn new things in these webinars.

For more information about courses or to customise a course contact:
marcussmall@thesmallman.com