Intermediate Excel Specialist

SUMMARY:
We are seeking a detail-oriented and proficient Intermediate Excel Specialist to join our team. The successful candidate will be responsible for utilising advance-level Excel and Power Query skills to maintain the Excel system and support various business functions, including data analysis, reporting, and spreadsheet management. The ideal candidate should have a strong understanding of Excel functions, formulas, and data manipulation techniques to enhance operational efficiency and decision-making processes within the organisation.

POSITION INFO:
Responsibilities:

• 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.

• 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.
• Familiarity with Smartsheet is a plus.

NB! This job is now closed. You can apply for other jobs by uploading your CV.