Develop and maintain complex Excel spreadsheets and databases to support business operations.
Analyse large datasets using pivot tables, XLOOKUP, and other Excel and Power Query functions to extract meaningful insights and trends.
Create and format charts, graphs, and visualisations to present data in a clear and concise manner.
Collaborate with cross-functional teams to gather data requirements and provide Excel-based solutions to meet their needs.
Ensure data accuracy and integrity by implementing validation checks and conducting regular audits.
Preparation of reports, presentations, and dashboards.
Provide training and support to the team on advanced Excel techniques and best practices.
Stay updated on the latest Excel features and functionalities to optimise productivity and efficiency.
Requirements:
Proven experience as an Intermediate Excel Specialist or similar role. Candidate will be required to take an Excel test to demonstrate their skills and experience.
Intermediate knowledge of Excel functions, formulas, and macros.
Proficiency in data analysis techniques such as pivot tables, XLOOKUP, and conditional formatting.
Knowledge and experience using Power Query.
Strong analytical and problem-solving skills with a keen attention to detail.
Excellent communication and interpersonal abilities.
Ability to work independently and collaboratively in a fast-paced environment.