Skip to main content

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

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/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, please visit Ikki.Kaur@derby-college.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 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...

Office Managers

£27894

Office Managers

Bank and Post Office Clerks

£20270

Bank and Post Office Clerks

Human Resources Administrative Occupations

£17762

Human Resources Administrative Occupations

National Government Administrative Occupations

£21740

National Government Administrative Occupations

Sales Administrators

£20787

Sales Administrators

Financial Administrative Occupations

£19054

Financial Administrative Occupations

Other Administrative Occupations

£16206

Other Administrative Occupations

Local Government Administrative Occupations

£22442

Local Government Administrative Occupations

School Secretaries

£18470

School Secretaries

Business, Research and Administrative Professionals

£32508

Business, Research and Administrative Professionals

Senior Professionals of Educational Establishments

£50748

Senior Professionals of Educational Establishments

Pensions and Insurance Clerks and Assistants

£18650

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: October 26, 2023 2:10 pm