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.
Course Information Last Updated On: July 18, 2025 9:26 am
