Intermediate Certificate in Microsoft Excel
Info Systems
A course by
The Career Academy
Gain an industry-recognised intermediate certificate in Microsoft Excel, designed for those seeking to advance their data organisation and analysis skills. Flexible online learning. Accredited by leading international organisations.
NZ$660
inc GST
Enquire about international pricing
Core skills this course teaches
Organise and analyse data with intermediate Excel tools
Learn how to efficiently prepare, sort, and filter data using Excel’s intermediate features.
Apply conditional formatting and time-saving functions
Understand and utilise conditional formatting, and discover functions to improve productivity.
About This Course
The Intermediate Certificate in Microsoft Excel builds on basic Excel knowledge to develop stronger abilities in data organisation, analysis, and automation. Learn practical skills including managing large data sets, troubleshooting formulas, using multiple worksheets, time-saving functions, macros, and Microsoft 365 features. Accredited by ICOES and the CPD Standards Office, this course is ideal for those in accounting, administration, business, and similar roles wanting to build their confidence and employability in offices or organisations that rely on Excel.
Course Content
- Working with large tables of data
- Troubleshooting formulas
- Using multiple worksheets
- Time saving functions
- Conditional formatting
- Introduction to recording macros
- Protecting workbooks and data
- Microsoft 365 Excel functions
Entry Requirements
Basic Microsoft Excel skills
Build towards these roles
Data Reporting OfficerExcel Reporting SpecialistOperations Support AnalystFinancial Reporting AssistantBusiness Intelligence AssistantProject Reporting CoordinatorBudget Monitoring OfficerData Quality CoordinatorSpreadsheet DeveloperProcess Automation AssistantAdministration Officer
The Career Academy is here to transform your future. As an internationally recognised online education provider, they partner with industry to deliver courses that are practical, flexible, and designed to get results. With expert tutors, a 4.8/5 star student rating, and graduates in New Zealand, Australia, Ireland and the UK, The Career Academy has already helped over 25,000 learners each year gain the skills, confidence, and qualifications to take their next step. You could be next.
