cartcloseinfolockmenuplayplayplayplayadd to playlistremove from playlistplaylist
Home/Webinars/Convert Messy Spreadsheets into Beautiful Systems

Convert Messy Spreadsheets into Beautiful Systems

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.

Stephen Gay

Principal MIDAS Tech International


Technology and Digital