With more than a decade of experience, I am highly proficient in harnessing Excel's power to analyze and transform data, which makes me an exceptional candidate for this project. From my previous work, including my current role as a Data Viz Consultant at Inetum, I have continually been tasked with producing dynamic, user-friendly reports like what you envision.
Synchronizing data from multiple sheets to a master sheet and establishing efficient formulas are some of my core strengths. By carefully linking around 60-70 other sheets to your master sheet, I can ensure seamless reporting and data monitoring. Additionally, I am well-versed in setting up conditional formatting and formulas so that key data is effectively highlighted and calculations are streamlined.
My prowess extends beyond mere data manipulation - I excel at presenting insightful narratives. This means that with your dataset of medium size, containing between 1000 to 10,000 rows of data, I can create engaging and visually stimulating dashboards and charts. I believe in giving information not just numbers; thus, my visualizations will surely provide you with the analysis you need. Combining skills in Excel, VBA and Python automation with a deep understanding of Power BI for impactful visualizations, I will transform your static Excel sheets into dynamic tools that truly add value.