Excel Engineering now offers Excel Error Detection System

Learn more

Convert messy spreadsheets into beautiful systems

There are many courses and books on how to use Excel.  Most of these books provide information on the functionality of Excel.  Seldom do these books explain how to use Excel in a logical and structured manner.  Hence it is for common, even for advanced Excel users to create 'messy' spreadsheets. A messy automate suffers from the following limitations.

Our Professional Excel Course is a strategic course that provides guidance on how to create a "beautiful" spreadsheet

The style of the approach is sometimes referred to as "Spreadsheet Engineering" meaning a logical, structured, efficient and automated rather than an adhoc manual approach.

Who is this course suited for?

The target participants are professional staff who use Excel as a common data analysis and manipulation tool, and generally share their workbooks with colleagues.  Although the course is slanted toward engineers and scientists, other quantitative professional such as financial modellers are welcome and should contact the organisers directly if interested.  The course is of most value when participants include both technical managers and their staff.  The course is of course essential for new graduates involved in routine Excel analysis.  The courses are mainly designed to be made available to corporations, and from time to time will be made available for individual participation.

The course is divided into three days

Day 1

Excel Revision

It is presumed that most participants already have a basic understanding of Excel.  The first day will go over many concepts you may already be familiar with, but may not be using to their full potential and provides the foundations for completing the second day. For example most users know how to use Named ranges, but very few know how to use named ranges in a manner that provides the basis for automation, that is avoiding reformatting the same type of data.

Day 2

Advanced Excel

In the second day, we introduce Advanced topics such as VBA and databases.  That is, the sort of methods that are available to all Excel users – but are seldom taught.

Day 3

Professional Excel

On the third day we move toward Professional Excel.  Professional Excel will teach you concepts that you may never have known were possible.  In particular there is a strong emphasis on data flowcharts. In the course not only do we teach you macros and formulae, we also teach how to assign macros to flowsheet shapes.  Hence the user can create an extremely impressive flowchart based calculation system that can be run automatically.

The Speaker

The course is provided by Stephen Rayward from Midas Tech International.

Stepehen Rayward

Dr Stephen Rayward

Stephen comes from a science/engineering background, and has developed large software systems for mineral processing analysis.  In 2015 he created his own independent Company:  MIDAS Tech International, with original primary focus being mineral processing software.  Stephen developed many of his new methods in Excel, and has a passion for flowchart based simulation. In 2015 Stephen focused on creating add-ins that made Excel much more efficient, for example, automated hyperlinking between named ranges and flowcharts.

We have run courses for companies both big and small

Some of the companies we’ve helped

Frequently Asked Questions

Who is this course best suited for?

We have identified that although there are many Excel courses they are in general: unsuitable to professionals from engineering and science backgrounds, and non-strategic. That is most other Excel courses focus on using Excel functionality – rather than how to use Excel efficiently. We have targeted the course to be suitable for participants from 3rd year graduates to Chief Technical Officers – primarily from engineering, consulting and science-based industries. The course is also suited to other quantitative professionals such as Financial Modelling and Business Analysts.

Are strong mathematical skills required?

The course requires cognitive understanding of mathematics. That is when we consider a model there are four ways that one can model:

  1. Visually.
  2. Mathematically.
  3. Computationally.
  4. Numerically.

The course links and utilises all these four approaches, whereas most Excel modelling courses focus only on Numerical calculations (i.e. applying formulas using A1 notation). Most professionals from science/engineering backgrounds will find the cognitive jumps and links regarding the four modelling approaches as straightforward whereas others may find this a challenge. The course explains these concepts from the very basic level and builds on these to provide the framework for automation approaches.

How do I arrange a course

You may fill in the attached form to initiate communication. We will then provide you with a brochure and identify whether your interest is corporate-based or individual-based. If corporate based you will need to get formal approval. Course costs vary on location. We generally provide an informal quote first and then we provide a formal quote after discussing.

There are various extension courses which are also included in the brochure.

Upcoming courses

Outline of the Course (Video)

Register your interest

Register your interest, or get in touch below.