top of page

TRAINING

Instantly improve your spreadsheeting productivity

Improve your spreadsheeting productivity and design.

​

Discover new depths of Excel funtionality and power.

EXCEL MODULES

  • Modular course design allows a flexible approach

  • Learn simple ways to improve productivity in daily spreadsheet use

  • Avoid using poor, time consuming methods

  • Improve design and integrity of spreadsheets

  • Learn new formulae for everyday use

  • Unleash the untapped power of Excel

ADVANTAGES

  • I can come to you 

  • Courses are tailored to fit your needs

  • Courses are not subject to cancellation due to insufficient numbers

  • I am not just a technical expert, but have over 25 years of real-world commercial experience

  • Meets CAANZ structured on-going professional development requirements

  • You will have fun - strange, but true

“Dean should present more courses - he is the best presenter at any of these courses I have experienced”

Excel training course participant

ARTICLES
VIDEOS
Anchor Training Detail
ADVANTAGES OF JOHNSON MATTHEWS EXCEL TRAINING

  • I can come to you. I can present Excel training at your premises, allowing you and your colleagues to come and go easily for the various modules, all tailored to your requirements.  Alternatively, we can use one of several suitable external venues.

  • Courses are tailored to fit your needs. Rather than you having to fit into a trainer’s schedule of courses and dates, we can put together a training day or part day, to fit your specific requirements, all for a flat fee.

  • Courses are not subject to cancellation due to insufficient numbers. Imagine booking on a course, keeping the date free in order to attend, only to discover the course was cancelled due to factors outside your control, because there were not enough other external bookings.

  • As your trainer, I am not just a technical expert, but also have over 25 years of real-world commercial experience, applying spreadsheet solutions to real-world business issues.

  • CAANZ qualified members of your finance team are required to undergo a level of continuing professional development each year. The fact is, many struggle to find training courses which provide direct benefit and application to their jobs.  Excel training will serve most extremely well and provide tools for use on a daily basis, ensuring optimal value for your training budget.

  • You will have fun! Strange, but true.  I take what could be a very dry subject and teach it in an engaging way which aids learning and the retention of knowledge.

I also have a series of two hour hands-off courses, suitable for larger audiences.  Clients often work these into conferences.  These are educational and, believe it or not, entertaining. 

"Move over Jamie Oliver, here comes Dean"
 

Excel training course participant

Anchor Training Modules
EXCEL TRAINING MODULES

Don't simply learn formulae and techniques, but learn how and why to APPLY them in practical, commercial situations

FOUNDATION

  • Learn the basic concepts of spreadsheeting

  • Learn the SUM formula

  • Learn the IF formula

  • Learn to copy and paste

  • Learn to paste formulae, formats or values

  • Learn the quick keys (shortcuts)

DATA PART I

  • Learn the VLOOKUP formula to extract a value from a table

  • Learn the HLOOKUP formula

  • Learn the OFFSET formula to return a value from one cell relative to another cell

  • learn the MATCH formula to establish the position of a value within a range of cells

  • Learn the SUMIF and SUMIFS formulae for conditional summing

  • Learn the SUBTOTAL formula and how and why to apply it

NAVIGATION

  • Eifficient ways to move between sheets/tabs

  • Move instantly through large tracts of contiguous data

  • Learns shortcut navigation keys

  • Learn the superior transition navigation keys 

  • Navigate instanly using Named Ranges

  • Navigate via hyperlinks

FORMULA ATRIBUTES

  • Learn how and when to use Absolute vs Relative addressing

  • Learn how and why to create and use Named Ranges

  • Learn how to establish Variable Named Ranges

  • Learn how to use nested formulae

DATA PART II

  • Learn how to dynamically analyse data through the phenomenal power of the Pivot Table

  • Learn ODBC links to automatically import and update data from external sources 

  • Learn how to import data automatically from websites

ERROR PREVENTION

  • Learn the optional additional argument in the VLOOKUP and HLOOKUP formulae and when to apply it

  • Learn how to use Data Validation to limit entries in cells to a valid range of options

  • Learn about cross checks to improve spreadsheet integrity

  • Use the IF formula to predict and deal with Divide by Zero issues

  • Use a combination if IF, MATCH and ISNA  to predict and prevent errors

CUSTOMISATION

  • Modify the Quick Access Toolbar to make frequently used icons always avaialable

  • Modify the Ribbon to suit the way YOU  use Excel

  • Understand Office Themes for standardised formatting and presentation

  • Set the defualt number of sheets in a new workbook

  • Create standard templates for your most frequently used formatting styles

  • Alter the view options to make zero values and gridlines visible or invisible

SENSITIVITY

  • Learn how to use Goal Seek

  • learn to create and use Scenarios

  • Learn to use data tables

DATES

  • Understand dates as numeric vlaues and how to format them

  • Perform calculations using dates

  • Learn date attributes and how to work with them

  • Learn TODAY, DATE, DATEVALUE, WEEKDAY, EDATE and EOMONTH formulae

GRAPHS

  • Create basic and complex graphs

  • Understand different graph types

  • Format the graph axis

  • Format the series colour, shading and chart type

  • Add a secondary Y axis for different value sets

  • Add data tables, data labels and trend lines

FINANCIAL FUNCTIONS

  • Become familiar with Internal Rate of Return, Present Value, Net Present Value and Payment functions and the relationships between them

  • Learn how and when to appy finance functions

  • Learn when and how to ignore the built-in finance functions and revert to first principles

FILTERS

  • Learn how to apply filters to a list of data

  • Understand how =SUM and =SUBTOTAL behave with filtered and hidden rows

  • Learn to use advanced filters to extract a unique set of records

"Excellent presenter - best one yet!  learned heaps"

"Very enthusiastic"
 

Excel training course participants

bottom of page