Publications : Online Learning

Convert Messy Spreadsheets into Beautiful Systems

Online Learning
Published in 2018

Stephen Gay Presenter: Stephen Gay comes from a science/engineering background, and has developed large software systems for mineral processing analysis. In 2015 he started MIDAS Tech International Pty Ltd, 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. Stephen also focused on creating add-ins that made Excel much more efficient, for example, automated hyperlinking between named ranges and flowcharts. Stephen is currently collaborating with Process IQ in delivering professional development courses.

This webinar will not make you an expert, but it will help you identify which areas that could help you in your daily tasks and the areas that you may need more in-depth training on. Most (if not all) engineers and scientists use Excel; but are often self-trained in how to use the program in an efficient manner. Since there is no standard way to use it, there are multiple ways to approach it, to get your results you need. This leads to spreadsheets that are often:

  • Difficult to understand
  • Error prone
  • Excessively manual

Such spreadsheets can be difficult for anyone to understand, including the person who created it once further data is added, and over time it becomes messy and cumbersome. In contrast by using various methods, one can significantly make a spreadsheet 'beautiful'. That is:

  • Easy to follow
  • Decreased error
  • Automated

In this webinar, the speaker (Stephen Gay) will provide a very simple overview of these methods.

Duration: 1 Hour

Location: Webinar

PD category: Technical

Career stage: Early - Mature

Terms and Conditions:

By purchasing this content viewing you acknowledge that you will not reproduce, distribute or forward this content without the express written permission of The AusIMM.

You also acknowledge that the link provided to view this content is for your (single) use only, and will not be watched by more people than have purchased their own viewing of the content.

Mobile data warning: Streaming videos can use large amounts of data.

Australia Overseas
Member $27.50 $25.00
Member - Student $16.50 $15.00
Non-Member $38.50 $35.00