This one-day workshop will help intermediate Microsoft Excel users to advance their skills. You’ll learn how to use some of Excel’s more powerful features so that you can complete your work more effectively and quickly.
Entry Requirements
You must have some basic knowledge about Excel.
What will you learn?
• Workbook and worksheet protection
• Cell referencing
• Using functions – including SUMIF, COUNTIF, COUNTIFS and TODAY
• Introduction to charts
• Data tools
• Excel tables
• Cell linking within worksheets and workbooks
• Sorting and filtering
• Auditing and error checking
• Using outlines
How will you learn?
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 contact 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
£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
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.
