Automated Dashboard in Excel Updates

Position: Excel Expert - KPI Dashboard Specialist Location: Remote Type: Contract for Small Project (Can lead to more) Application Deadline: 8/2 About Us: We are a dynamic team dedicated to achieving excellence through data-driven insights. We rely on our comprehensive KPI Dashboard to track performance and drive strategic decisions. We are currently seeking an Excel expert to enhance and maintain our KPI Dashboard, ensuring seamless conditional formatting and data integrity across all pages. Role Overview: As an Excel Expert, you will be responsible for updating and optimizing our existing KPI Dashboard. Your primary focus will be on ensuring that conditional formatting is consistently applied across all pages, improving the overall functionality and user experience. You will collaborate with our team to understand the requirements and implement solutions that enhance the dashboard's effectiveness. Key Responsibilities: - Review and update the current KPI Dashboard in Excel. - Ensure conditional formatting is consistently applied across all pages. - Identify and fix any issues related to data integration and formatting. - Optimize the dashboard for better performance and usability. - Collaborate with team members to gather requirements and implement changes. - Provide training and support to team members on using the updated dashboard. Requirements: - Proven experience as an Excel Expert with a strong portfolio of complex Excel projects. - Proficiency in advanced Excel functions, formulas, and data analysis tools. - Expertise in conditional formatting and its application across multiple pages. - Strong problem-solving skills and attention to detail. - Ability to work independently and meet deadlines. - Excellent communication skills and ability to collaborate with team members. Preferred Qualifications: -Experience with KPI Dashboards and performance metrics. - Knowledge of VBA (Visual Basic for Applications) for Excel automation. - Background in data analysis or related fields. How to Apply: If you are an Excel expert with a passion for optimizing data-driven tools, we would love to hear from you! Please submit your resume, a cover letter detailing your relevant experience, and examples of your previous Excel projects. Join us in making data work for excellence!