Enhancing Skills with Excel (23/24)
Course Overview
This course is suitable for anyone who has completed our Beginners Excel course. We run this at various times and dates throughout the year at both our Somer Valley and City Centre campus.
Learners on this course will already know how to use the plus/minus/multiplication formulas and the SUM and AVERAGE functions.
During the workshop you will cover:
Refresh building block functions
Refresh replicating formulas along rows and columns
Customise the cell format such as how a date is displayed
Use 'Absolute referencing'.
Explore the 'IF' and 'Or' and 'SUMIF' functions
Applying functions to real life projects
Refresh use of page set-up tools
Frequently asked questions
This course is suitable for anyone who has completed our Beginners Excel course. We run this at various times and dates throughout the year at both our Somer Valley and City Centre campus.
Learners on this course will already know how to use the plus/minus/multiplication formulas and the SUM and AVERAGE functions.
During the workshop you will cover:
Refresh building block functions
Refresh replicating formulas along rows and columns
Customise the cell format such as how a date is displayed
Use 'Absolute referencing'.
Explore the 'IF' and 'Or' and 'SUMIF' functions
Applying functions to real life projects
Refresh use of page set-up tools
Alll course materials will be provided.