Skip to main content
D C G Logo

Derby College Group (DCG)
Telephone: 0800 028 0289
https://www.derby-college.ac.uk
enquiries@derby-college.ac.uk

0800 028 0289

  • Contact
  • Jobs
  • How to Apply
  • About DCG
  • Home
  • Courses & Careers
    Course SearchSubject Areas at DCGCourse Types at DCGCampuses & Course LocationsDCG Success StoriesCareer SearchCareer PathwaysDownload a ProspectusFree – ESF Fully Funded Course
  • Employers
  • Student Support
  • Parents
  • News/Events
    EventsNewsEvent Registration
DCG Courses IT Courses – Intermediate Microsoft Excel

IT Courses – Intermediate Microsoft Excel

This one-day workshop aims to further enhance the skills of intermediate Microsoft Excel users.

Apply Now

Course Summary

Subject Area: Adult Digital
Course Type: 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: £150
Ilkeston

Apply now at: https://www.derby-college.ac.uk/course/it-courses-intermediate-excel
QR Code
  • Information for Students
  • Information for Employers
  • Related Careers
  • Success Stories

Course Information for Students

Who is this course for?

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?

Course content 

Working with Functions

  • Understanding cell addressing
  • Mathematical and Statistical functions: COUNTIF, COUNTIFS, SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS, GROUPBY, and PIVOTBY

Conditional Formatting

  • Pre-set conditional formatting rules
  • Data bars, colour scales and icon sets
  • Creating your own rules
  • Using conditional formatting with check boxes

Data Validation

  • Building data validation rules
  • Creating drop-down lists
  • Using information messages
  • Working with warning messages

PivotTables

  • Working with data sets
  • Building PivotTables
  • Formatting PivotTables
  • Working with slicers and timelines
  • Auto updating PivotTables

Data Analysis

  • Recap on chart basics
  • Creating combination KPI charts
  • Building Gantt charts
  • Working with Sparklines

How will you learn?

What will you need to bring with you?

How will you be assessed?

Where next?

You may want to progress to our Microsoft Advanced Excel course.

Who do you contact for more information?

For more information, contact dcgprofessional@dcg.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 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

£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

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: July 18, 2025 9:26 am

Modal title

  • Overview
  • Knowledge & Skills
  • Employment & Salary
  • DCG Courses
career thumbnail

Overview

An overview of the career

Knowledge and Skills Required

Skills

These are the skills that are commonly needed in this career.

SkillImportance
Knowledge

These are the ten most import areas of knowledge commonly needed for this career.

KnowledgeImportance

Employment Data

Annual Job Openings

Currently Employed

Annual Earnings

This shows the current annual learnings for this career.

Starting Salary

Average Salary

High Salary

PercentileSalary
Age of the Workforce

This is the breakdown of ages who work in this career.

Age GroupPercentage
Education Level of the Workforce

This is the education level of the workforce.

Education LevelPercentage
Employment Forecast

This is the projected number of jobs available.

YearNumber Employed
Employment Proportion by Sex

This shows the proportion of males and females who work in this career.

Male/FemalePercentage

Suitable Courses

Suitable Courses

D C G Logo
  • Derby College Facebook
  • Derby College Youtube
  • Derby College Instagram

Courses

  • Course Search
  • Career Search
  • Subject Areas at DCG
  • Career Pathways
  • Course Types at DCG
  • Campuses & Course Locations at DCG
  • Download a Prospectus
  • Chart Your Future

Students

  • Student Support
  • Student Services
  • Login to inTouch
  • Report an Absence or Lateness
  • Moodle VLE
  • Think Alumni
  • Student Bursary

Staff

  • Staff Intranet
  • Remote Desktop
  • Systems Hub
  • Email

DCG

  • Governance
  • Policies and Papers
  • Why work for us?
  • Meet the Governors
  • Who’s Who
  • Website Accessibility Statement
  • Data Protection
  • Freedom of Information
  • Equality, Diversity & Inclusion Statement
  • Modern Slavery Statement
  • Environmental and Sustainability at DCG
  • DCG-Annual-Accountability-Statement-2024-25
  • DCG Strategy and Regulation – Accountability Statement 2025-26

Study with Us

  • DCG Success Stories
  • DCG Covid Safety

Student Life

  • Derby College Students Union

More

  • Covid Safety
  • Apprenticeship Vacancies
  • Open to the Public
  • Term Dates
  • College Calendar 2025-26

Quick Links

  • Contact Us
  • How to Apply
  • Make a Payment
  • Report an Absence or Lateness
  • Jobs at DCG
DCG Logo Derby College Group
Manage Consent
To provide the best experiences, we use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us to process data such as browsing behaviour or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions.
Functional Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes. The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
Manage options Manage services Manage {vendor_count} vendors Read more about these purposes
View preferences
{title} {title} {title}