Excel Expert Needed - Formula Repair, Data Organization & QuickBooks Integration Job at Pageant Planet, Boston, MA

Y0pPQnNJVGRmMVowS1JrU25BSVV1SmVQVGc9PQ==
  • Pageant Planet
  • Boston, MA

Job Description

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

Job Tags

Hourly pay, Contract work, Immediate start, Remote work,

Similar Jobs

Watermark at Bellevue AL/MC

Music Specialist (Community Life Associate) Job at Watermark at Bellevue AL/MC

 ...you!We have been a leader in senior housing for over 30 years, but we are not content to rest on our reputation. As a Watermark associate, you will have the opportunity to deploy your talents to their fullest as we drive the next 30 years of innovation in the senior... 

Cafe Mado

Barista Job at Cafe Mado

 ...a neighborhood we have called home for over six years. Job Summary: As a Barista atCafe Mado, you will be the heart of our customer experience, responsible for crafting delicious coffee and tea beverages and serving our baked pastries and breads while providing friendly... 

Health Systems Management

Patient Care Technician Job at Health Systems Management

 ...Care Technicians (PCTs) at Health Systems Management support and work under the guidance of RNs to provide dialysis treatment to...  ...previous treatment. Report any concerns or observations to the lead nurse. Assist with and prepare the patient's vascular access for treatment... 

Firma de Reclutamiento en PR

Mensajero (Temp) Job at Firma de Reclutamiento en PR

Requisitos: Diploma de escuela superior. Licencia de conducir de Puerto Rico vigente. Experienciaen tareas similares. Buenas destrezas de servicio al cliente. Debe tener habilidad de levantar 50lb. o ms. Habilidad para trabajar en ambiente dinmico...

Sager Electronics

Inside Sales Representative Job at Sager Electronics

As a growing company with more than 400 employees across North America, we take pride in our high-performing team and our customer first vision. Due to our continued success, were looking for an Inside Sales Representative with at least two years of related experience...