Advanced Certificate in Microsoft Excel
Info Systems
A course by
The Career Academy
Advance your Excel skills with an industry-accredited online course covering importing data, advanced lookups, pivot tables, reporting, and dashboard creation—perfect for those seeking roles in business analysis or administration.
NZ$793
inc GST
Enquire about international pricing
Core skills this course teaches
Master advanced Excel data management
Learn how to import, manipulate, and prepare complex data using advanced text, CSV, and dynamic table features.
Develop advanced lookup and referencing skills
Utilise HLOOKUP, VLOOKUP, and cross-referencing functions to retrieve, connect, and process data efficiently.
About This Course
This advanced, 100% online Microsoft Excel course prepares you for in-demand workforce roles by teaching you how to import, manage, analyse, and present data in professional contexts. Accredited by leading industry organisations, it guides students through advanced Excel features such as pivot tables, horizontal and vertical lookups, cross-referencing, and dashboard creation. Flexible study options and unlimited tutor support enable you to upskill for business and finance roles at your own pace. Suitable for those pursuing career advancement in accounting, business intelligence, administration, or analytics.
Course Content
- Importing and saving plain text and CSV files
- Exporting data from Excel
- Lookup and cross-referencing: HLOOKUP and VLOOKUP
- Preparing data for reporting
- Introduction to dynamic tables
- Creating and using pivot tables
- Generating pivot charts
- Data modelling fundamentals
- Dashboard development
- Process automation basics
- Table filtering and slicers
- Analysing data using Total Row
- Formatting and inserting tables
- Error indicators and cell format conversion
Entry Requirements
Recommended: Intermediate Certificate in Microsoft Excel or equivalent experience
Build towards these roles
Excel AnalystAnalytics DeveloperReporting Solutions SpecialistData Modelling AssistantBusiness Intelligence TechnicianProcess Automation SpecialistFinancial ModellerDashboard DeveloperOperations AnalystSystems Reporting CoordinatorOffice Administrator
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.
