We are looking for an experienced **Excel Expert** to repair and maintain our business financial spreadsheets. Our current workbook has multiple broken formulas that must be fixed, cleaned up, and restructured before automation can be implemented.
This role will also involve integrating Excel with QuickBooks, automating workflows, and ensuring data flows correctly across multiple sheets. The goal is to deliver a clean, accurate, and reliable tool that can be supported long-term. This is an ongoing, hourly project and long-term support needed.
**Responsibilities**
* Repair & Troubleshoot broken formulas in a multi-sheet workbook.
* Identify and correct broken or misapplied formulas.
* Ensure all calculations are accurate across linked sheets.
* Simplify overly complex formulas for stability and readability.
* Clean & Reorganize Data for accuracy and readability.
* Automate Processes using advanced Excel formulas & functions.
* Integrate with QuickBooks to sync financial data automatically.
* Link multiple spreadsheets for streamlined reporting and communication.
* Provide ongoing support for updates and troubleshooting..
**Required Skills**
* Advanced Excel formulas (INDEX/MATCH, XLOOKUP, SUMIFS, etc.)
* Ability to troubleshoot complex errors in multi-sheet workbooks.
* Proficiency with Excel automation (including VBA & Macros)
* Spreadsheet clean-up and restructuring
* QuickBooks integration with Excel
* Data linking across multiple spreadsheets
* Strong attention to detail and accuracy
**Experience:**
* Advanced Excel formulas & proven track record fixing broken or complex formulas in multi-sheet workbooks.
* Business or financial reporting experience.
* Proven ability to integrate QuickBooks with Excel.
* Strong background troubleshooting complex, multi-sheet workbooks.
* Experience implementing Excel automation tools
**Availability:** Able to start immediately.
**Engagement:** Ongoing, hourly project-based work (long-term support)
**Success Criteria**
* Broken formulas fully repaired.
* Spreadsheets are fully functional, accurate, and easy to use.
* Automated processes reduce manual updates.
* QuickBooks integration is reliable and consistent.
* Ownership of the system can be transferred for long-term use.
**Specifics:**
* This is a remote role
...small projects like residential homes to large military and oil refinery projects. We specialize in power quality, lightning protection... ...Install lightning protection systems. Hands-on training- no experience necessary. ALP Systems, Inc. provides all vehicles, uniforms,...
...Adult Care Minimum 2 years of clinical experience in a comparable setting Strong knowledge of primary care, weight loss, sexual health, HRT , and ADHD management Excellent interpersonal and communication skills A holistic, patient-centered approach to care...
Join to apply for the Senior Architectural Healthcare Project Manager role at STV2 days ago Be among the first 25 applicantsJoin to apply for the... ...$120,000.00 2 weeks agoSr Project Manager - Finance (100% Remote) Waltham, MA $95,000.00-$105,000.00 3 days agoOwners...
...Job Description Clean Harbors is looking for a Regional Class A Dry Van Driver to join their safety conscious team in Clackamas, OR ! This route runs from Clackamas, OR to Southern California and averages 1800-2200 miles per week. About the role: ~ Drivers...
...Robotics Software Engineer At Formic, we're on a mission to revolutionize American manufacturing and create more abundance in the world. We believe in continuing the American legacy of innovation by making automation accessible to all manufacturers and increasing their...