Derby College Group (DCG) Telephone: 0800 028 0289 https://www.derby-college.ac.uk enquiries@derby-college.ac.uk
0800 028 0289
Advanced Excel
This one-day workshop is designed to give individuals who already have a good understanding of the programme's key features the opportunity to learn more advanced skills
Extend your knowledge of Excel’s advanced features and learn how to perform more complex tasks. This workshop will help put the full power and potential of Excel at your fingertips.
Entry Requirements
You must already have a good understanding of Excel’s key features.
What will you learn?
• Pivot tables
• Data consolidation
• Using outlines
• Lookup functions
• Statistical, Math and Trigs functions
• Nested and Array functions
• Data tables
• Data validation
• Auditing spreadsheets
• Introduction to Macros
How will you learn?
The course will be delivered on-site.
What will you need to bring with you?
How will you be assessed?
Where next?
Who do you contact for more information?
For more information, please visit Ikki.Kaur@derby-college.ac.uk
Course Information for Employers
Information for Employers
If you are an employer and would like to know more about the apprenticeships and professional training we deliver or how you can get involved in co-creating and co-delivering curriculum, please contact us via email on businessenquiries@derby-college.ac.uk, call us on 01332 387 421 or visit our employer pages here.
Career Information
This course could lead to one of these careers...
£0
Bank and Post Office Clerks
£21976
£0
Local Government Administrative Occupations
£20738
Sales Administrators
£23495
Financial Administrative Occupations
£20308
Other Administrative Occupations
£18258
Officers of Non-governmental Organisations
£25352
School Secretaries
£19058
£0
Teachers of English as a Foreign Language
£35706
Pensions and Insurance Clerks and Assistants
£23232
More Careers Information at: https://www.derby-college.ac.uk/career-pathways
DCG Success Stories
Discover how our students have achieved success. Their hard work and dedication to learning has enabled them to succeed in rewarding careers or progress onto higher education.
We encourage progress and aspirational outcomes by guiding people onto learning pathways that lead to positive destinations. Our students have gone on to achieve great things since leaving the College. We would like to share some of their inspiring success stories with you.
