IT Courses – Intermediate Microsoft Excel
This one-day workshop aims to further enhance the skills of intermediate Microsoft Excel users.
Course Summary
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
Career Information
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.
Find out what funding could be available to you:
Thinking about returning to education or developing new skills? Use our funding calculator below to get an estimate of the financial support you may be eligible for based on where you live.
Whether you’re looking to retrain, progress in your career, or try something new, funding could make your next step more accessible than you think.
Simply enter your postcode into the calculator to see an estimate of the funding that may be available in your area. This is based on regional funding allocations and typical eligibility criteria for adult learners.
Important:
The results shown are a guide only and are not a guarantee of funding.
Funding availability can vary depending on:
- Your personal circumstances (such as age, employment status, and prior qualifications)
- The course you choose
- Government and local funding rules at the time of enrolment
If you’re considering adult learning, there’s never been a better time to explore your options.
Our courses are designed to fit around your life, with flexible study options and expert support every step of the way.
Find out more about the courses available. Adult Courses
If you have any questions about funding, eligibility, or courses, our team is here to help. Contact Us
Course Information Last Updated On: January 14, 2026 9:05 am
