Advanced Excel Specialist

Updated: April 06, 2024 01:33 AM GMT

Edge Executives

Lanseria

Responsibilities:
• Design and develop advanced Excel spreadsheets and models to automate data processing, analysis, and reporting tasks.
• Utilise Power Query to extract, transform, and load (ETL) data, ensuring accuracy and consistency.
• Create complex calculations, formulas, and macros in Excel to manipulate and analyse large datasets efficiently.
• Collaborate with management to understand data requirements and provide customised solutions to meet their needs.
• Create and format charts, graphs, and visuals to present data in a clear and concise manner.
• Optimise data workflows and processes to improve efficiency.
• Provide training and support to the team on advanced Excel techniques and best practices.
• Stay updated on the latest Excel and Power Query features, tools, and techniques to drive continuous improvement and innovation.
• Conduct quality assurance checks and data validation to ensure data integrity and reliability.
Â
Requirements:
• Proven experience (3+ years) as... More Detail