Essential Excel Skills for Geologists – DRAFT

We draw from many years of experience, having learned the hard way, to provide you with the key Excel techniques to really save you time and effort.

You will learn how to present data graphically to best advantage, how to use pivot tables, navigation, sorting and advanced filtering techniques to get valuable information out of massive data sets and how to generate key graphs (such as Q-Q plots).

The outcome will be that you are aware of and able to use a whole range of labour-saving tools to present messages more clearly and to derive meaningful information from data.

We provide each attendee with a toolbox of spreadsheets guaranteed to enhance productivity.

Course outline

• Overview of the basics of Excel and revision of the fundamentals
• What you as a geologist, need Excel to do for you
• Navigation keys and shortcuts; filtering and processing large data sets
• Presenting your data – tips, tricks, what works visually, what doesn’t
• Reporting and reconciliation applications
• QAQC examples
• Key skills in Excel; named ranges, lookup tables; pivot tables
• How to present data in Excel for passing on and work by others
• Forum – what are your key requirements for Excel?
• A toolbox of templates and functions

Course outcomes – you will:

• Receive a refresher on basic Excel skills and fundamentals
• Learn or revise a host of time-saving tips and short-cut keys for navigation, data manipulation and formulae
• Appreciate the best ways and tools for presenting your data in charts and graphs
• Discover the best ways to filter and manipulate large data sets
• Learn the best ways and tools for tonnage-grade reporting and reconciliation
• Take away a toolbox of time-saving templates and functions

Contact us for further details