• Explain the key principles, terminology and professional applications of Advanced Excel: Functions, Power Query and Power Pivots.
• Identify operational needs and common challenges related to information technology and data.
• Apply practical techniques for data, systems and practical tools in relevant work scenarios.
• Develop informed decisions and actionable solutions involving implementation, validation and governance.
• Evaluate outcomes using performance evaluation and improvement and propose improvements.

• Introduction to Advanced Excel: Functions, Power Query and Power Pivots: scope, terminology and practical relevance.
• Core foundations: Technical concepts and business requirements.
• Methods and tools: Data, systems and practical tools.
• Professional practice: Implementation, validation and governance.
• Applied focus: Key concepts, terminology and professional considerations in information technology and data.
• Workshop: Supervised activities applying data, systems and practical tools; Case studies, performance review and workplace action planning.
• Assessment and action planning: Performance evaluation and improvement.