Skip to main content

IT Courses – Advanced Excel

This one-day workshop is designed to give individuals who already have a good understanding of Excel's key features the opportunity to learn more advanced skills.

Apply Now

Course Summary

Subject Area: Professional Training
Adult and Community
Location: Ilkeston
Full Time or Part Time: PT
Level: N/A
Number Of Years: 1
Interview Required?: N
Weeks: 1
Hours: 7.00
Start: Flexible
Tuition: £180
Ilkeston

Apply now at: https://www.derby-college.ac.uk/course/it-courses-advanced-excel
QR Code

Course Information for Students

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.

You must already have a good understanding of Excel’s key features. 

•          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

The course will be delivered on-site.

For more information, contact dcgprofessional@dcg.ac.uk  

Course 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 the 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

£24776

Bank and Post Office Clerks

£0

Local Government Administrative Occupations

£23997

Local Government Administrative Occupations

Sales Administrators

£23972

Sales Administrators

Financial Administrative Occupations

£22154

Financial Administrative Occupations

Other Administrative Occupations

£19423

Other Administrative Occupations

Officers of Non-governmental Organisations

£22297

Officers of Non-governmental Organisations

School Secretaries

£20468

School Secretaries

£0

Teachers of English as a Foreign Language

£36091

Teachers of English as a Foreign Language

Pensions and Insurance Clerks and Assistants

£22006

Pensions and Insurance Clerks and Assistants

More Careers Information at: https://www.derby-college.ac.uk/career-pathways
QR Code

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.

role model

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.

View Role Models

online application form

Get Started...

Use our online application form to apply for this course.

Apply Now

Course Information Last Updated On: April 9, 2025 10:14 am