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
Please note:
Our training programmes are designed to support individuals who are currently employed and participating through their organisations. For this reason, places on our courses are available to employees who are nominated by their companies.
Unfortunately, we are not able to offer places on these programmes to individuals who are not currently in employment.
If you are currently unemployed and interested in developing your skills, we encourage you to explore our Skills Connect programme, which is specifically designed to support people who are seeking employment.
This course is for highly experienced Excel users who have either completed the Intermediate course or who have sufficient experience to be familiar with the Intermediate topics.
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
