A training course on Microsoft Excel to help ensure conservators have the skills to efficiently manage their scientific data. The course will be run by Andie Mills from the IT training hub, a professional training company who aim to give participants confidence in Excel and how to use Excel’s features correctly to improve efficiency, leaving more time to concentrate on important tasks, and less time battling with the software.
The course will be pitched at an Intermediate to Advanced level, therefore directed toward users who are already able to create, format and structure spreadsheets and are confident with basic formulas. The course will recap absolute referencing and build skills on further-level functions that enable the cross-referencing and categorizing of data. Delegates will also explore database features such as sorting and filtering and analysis of large data sets using PivotTables.
Topics include:
- Recap of Basic Formula essentials: absolute referencing and statistical functions
- Charts: create, edit and bar chart, create a combination dual axis line chart
- Further Formulas: link across sheets, VLOOKUP, IF, IFS (version 2016 above) COUNTIF/COUNTIFS
- Data analysis tools: sort, filter, format as table, conditional formatting, pivot data
Equipment
It is strongly advised to attend with 2 screens, laptop with external monitor or PC with iPad/tablet for the call so you can work in comfort whilst following the call. Delegate will also require the desktop version of Excel as the online/Teams version will not have all the required features.
