top of page
Intermediate Microsoft Excel Training
Do you feel like your journey of discovery about Microsoft Excel has only just begun? This course could be just right for you!
Designed to help you advance your skills, you'll have the opportunity to expand your knowledge and explore some of Excel's more useful features.
It aims to give you further essential knowledge, skills and expertise to build practical, functional spreadsheets that aid your productivity both in the workplace and at home.
What will you learn?
01
Working with Functions
-
Understanding cell addressing
-
Mathematical and Statistical functions: COUNTIF, COUNTIFS, SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS, GROUPBY, and PIVOTBY
03
Data Validation
-
Building data validation rules
-
Creating drop-down lists
-
Using information messages
-
Working with warning messages
05
Data Analysis
-
Recap on chart basics
-
Creating combonation KPI charts
-
Building Gantt charts
-
Working with Sparklines
02
Conditional Formatting
-
Pre-set conditional formatting rules
-
Data bars, colour scales and icon sets
-
Creating your own rules
-
Using conditional formatting with check boxes
04
PivotTables
-
Working with data sets
-
Building PivotTables
-
Formatting PivotTables
-
Working with slicers and timelines
-
Auto updating PivotTables
How can you learn?
Want to book? Get in touch today!
bottom of page