We have just released the next section of the lesson guides in connection with Excel covering Name Ranges and Conditional Formatting! They can be found within our Excel Section.

Our next releases within the the Excel section looks at creating Charts and Graphs and using Pivot Tables to further advance your Excel skills. See the Lesson Guide for the following chapters we look to release as we continuously roll out more content to the site.

We also are in the process of rolling out project examples to combine the excel lessons to creating efficient spreadsheets and completing common exercises that should be applicable to most applications and industries that use Excel. But we focus on generalising these so they can be applicable to as many users to see your potential in using Excel but also using python as an additional tool.

We are excited to announce that we have just released a series of introductory articles on Excel and Python. These articles are designed to help beginners get started with these tools and provide a foundation for further learning.

In addition to these new articles, we uploaded articles on using converting OneNote pages to Obsidian and on creating websites with Jekyll. We also have a handy markdown worksheet to help you get started with this versatile formatting language which is used in Obsidian and building websites with Jekyll. They can be found at our Tech Tutorials Page.

Why use Python?

Digitisation of data is rapidly developing with the need of managing bulk geotechnical data and analysis. This evolution still involves engineering judgement but requires the adoption of available technology and tools to handle data outside an Excel spreadsheet. The visualisation of data brings insights into information we acquire from logs, field tests, laboratory tests and correlations. Completing repetitive calculations and summarising projects with big data reduces the efficiency whilst using conventional practices and this is where Python is a great tool.

I thought I should start with my journey and why I started to document my learning and progress in my professional field. Starting in the industry as an undergrad I definitely felt like I was taught the skills to continue my professional development beyond the classroom. Learning from senior colleagues and the projects I got to be part of really enhanced my knowledge but also gave me ideas where processes and tools that could be improved. I was always thinking there’s got to be a better way of doing this, and a matter of fact there always is!