Intermediate Excel Course
Excel Skills for Business Specialization – Macquarie University (Coursera)
Course Overview:
This course is part of the Excel Skills for Business Specialization and focuses on enhancing Excel skills for business applications.
Key Topics:
Working with multiple worksheets and workbooks
Text and date functions
Named ranges
Summarising data
Tables
Pivot tables, charts, and slicers
Duration:
Approximately 27 hours
Cost:
Free to audit; certificate available for a fee
Link:
Excel 365 Intermediate – One Education
Course Overview:
An accredited course designed to enhance Excel skills, focusing on intermediate functions and features.
Key Topics:
Linking workbooks and worksheets
Range names
Sorting and filtering lists
Creating and formatting tables
Conditional formatting
Charts and pivot tables
Duration:
Self-paced
Cost:
£17.99
Link:
Microsoft Excel Intermediate Training – Future Savvy
Course Overview:
A one-day instructor-led course focusing on practical Excel skills for intermediate users.
Key Topics:
Advanced formulas and functions
Named ranges
Conditional formatting
Excel tables
Worksheet manipulation
Duration:
1 day
Cost:
£199
Link:
Microsoft Excel 2016 – Intermediate Training Course – Virtual College
Course Overview:
An online interactive course focusing on intermediate Excel skills using Excel 2016.
Key Topics:
Logical and text functions
Advanced sorting and filtering
Data splitting
Cell referencing
Duration:
12-13 hours
Cost:
£99
Link:
Intermediate Certificate in Microsoft Excel – The Career Academy UK
Course Overview:
A comprehensive course aimed at professionals seeking to enhance their Excel skills for business applications.
Key Topics:
Data analysis and organisation
Advanced functions and formulas
Data validation
Pivot tables and charts
Reporting techniques
Duration:
Approximately 30 hours
Cost:
£499
Link: