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. Cost EUR 95
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
Online: 1 day; 9.30 AM - 4.30PM
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
