Intermediate Course on Excel
Venue: Remote Delivery
Duration: full day
Dates & Times: Please contact info@getsetacademy.co.uk for more information.
Cost: Free – Subject to eligibility
Overview: This full day workshop will help expand your skills on this Intermediate Excel training course. It is a hands-on course and includes plenty of time for trying out what you are being taught and asking questions.
Overview
This full day workshop will help expand your skills on this Intermediate Excel training course. It is a hands-on course and includes plenty of time for trying out what you are being taught and asking questions.
What will I study?
This is a hands-on course which is designed for regular day-to-day users. Having practised these new skills during the course you will be able to hit the ground running on your return to work and complete your Excel work far more quickly. Learn to use some of Excel’s more powerful features like conditional formatting, creating Pivot tables and using more complex functions.
- Introducing learners to more advanced functions of Excel
- Using relative, mixed and absolute cell referencing
- Using icon sets to format cells
- Using advanced functions; Logical, Mathematical and Statistical functions such as NETWORKDAYS, DAYS, Logical, IF OR, AND, TODAY, NOW
- Creating pivot tables using dynamic ranges
- Using macros & Protecting worksheets
Entry Requirements
Learners must be employed by organisations located in Greater Manchester or Lancashire.