Suitable participants
Who should attend
- Students
- Beginners
- Accountants
- Administrators
- General clerks
- Entrepreneurs and small-business owners
Office productivity
Microsoft Excel
Develop a solid Excel foundation and use spreadsheets more effectively for calculations, analysis, reporting and daily administration.
Published feeRM900
Duration14 hours
Published feeRM900
Duration14 hours
DeliveryInstructor-led · Demonstration · Practical
FundingHRD Corp claimable
Course objectives
What this course is designed to achieve
The course introduces Excel step by step, from worksheets and formatting to calculations, data analysis, charts and more advanced productivity features. It is designed to help participants use Excel confidently for real workplace data.
Course fit and results
Who should attend and what they will learn
Learning outcomes
After completing the course
- Navigate the Excel interface
- Create, modify and format worksheets
- Use formulas and functions
- Sort, filter and conditionally format data
- Create charts and graphs
- Use data validation
- Apply efficiency tips
- Understand PivotTables and macros
Detailed syllabus
Course outline
The learning areas below are carried over from ITPA’s existing course information and organised for easier review.
Section 1
Complete course outline
- Introduction to Excel
- Windows features
- Enter and format data
- Basic formulas
- Formula functions
- Sort and filter
- Additional features
- Charts
- Sparklines
- Conditional formatting
- PivotTables
- What-if analysis
- Excel functions
Employer enquiry
Discuss Microsoft Excel with ITPA.
Ask about the latest schedule, group arrangements, customisation, quotation and HRD Corp claim documentation.