Description
This course is for users who have either completed the Beginner course or who have gained sufficient experience to be familiar with the Beginner topics.
Duration
Classroom: 1 day
Online: 1 day
Content
- Be comfortable with the content of the Beginner course – revision of this if required
- Revision of use of absolute and fixed cells references
- Be able to insert and delete rows and columns
- Be able to create a chart in a number of different formats
- Insert, rename, move, copy sheets within and between spreadsheets
- Be able to link sheets, so that changes in one are automatically updated in another
- Set up a list, do simple and complex sorting (including multiple levels, by colour and by icon)
- Use basic If Function
- Introduction to Conditional Formatting
- Introduction to VLookup Function
- Formatting a list as a table – why and when you do it
- Introduction to Pivot Tables
- (If time allows) Introduction to Countif/Sumif/Countifs/Sumifs
This training will be delivered by Claire Commins - Study Focus
