About

We need an Excel expert to create a one-time, standalone sales report solution for our manufacturing company. You’ll import sales data from our T-SQL Azure database into Excel, creating dynamic reports comparing periods (e.g., Sept 2025 vs. Sept 2024, this quarter vs. last quarter vs. same quarter last year). The report must work offline without Azure dependency. Our team, with over 30 years of programming experience for clients like Dow Chemical and Exxon, now focuses on our growing manufacturing operations and needs a polished, user-friendly Excel solution. Description We are a Sarnia Canada-based manufacturer selling to distributors, seeking an Excel specialist to build automated sales reports. You’ll: Extract sales data (~1,000–5,000 rows) from our Azure T-SQL database using Power Query or VBA. Create a standalone Excel workbook with dynamic tables, charts, and formulas for year-over-year (e.g., Sept 2025 vs. Sept 2024) and quarter-over-quarter comparisons (e.g., Q3 2025 vs. Q2 2025 vs. Q3 2024). Ensure the report is user-friendly, with features like refresh buttons and error handling. Deliver a fully functional file with sample data and instructions, requiring no ongoing Azure connection.