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

OXNIKytvTFdnMVJOV055RVcrV25SU2NHS3c9PQ==
  • 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

NCAB Group

Account Manager-Entry Level Job at NCAB Group

 ...Entry Level Account Manager- Ontario, California Entry Level Position Do you desire a...  ...to gain valuable experience with inside sales/account management? Do you have a desire...  ...with your customers, outside sales and technical sales team members Develop strong relationships... 

Magellan Federal

On Site New Parent Support Home Visitor, LCSW/LMFT any state, RN/BSN, JBLM, Washington - Magellan Federal - United States Job at Magellan Federal

 ...work. Must hold a current and active license as an LCSW, LMFT or RN. Licensed Clinical Social Workers must possess a current,...  ...On Site New Parent Support Home Visitor, LCSW/LMFT any state, RN/BSN, JBLM, Washington Grade 24 Work Experience - Required... 

Avers Pizza

Dough Maker - Early morning shift Job at Avers Pizza

 ...looking for a responsible and friendly team member to prepare from scratch our award winning, made in-house pizza dough and transport the dough to our 2 locations using a company provided vehicle. Hours are set to be early - 7am start time and weekend availability is a must.

Navajo Nation Gaming Enterprise

Shuttle Driver Job at Navajo Nation Gaming Enterprise

 ...the general direction of the Director of Sales or Director of Security (based on property location), provides safe, reliable, courteous...  ...transporting individuals. Must be twenty-one (21) years of age. Valid drivers license and clean driving record for all property locations.... 

Liberty Healthcare Management

HOSPICE REGISTERED NURSE Job at Liberty Healthcare Management

 ...families will play an indispensable role in their hospice experience. This position demands a highly sensitive and caring approach to address all physical, emotional, and spiritual needs of the patient, ensuring their comfort and quality of life during their remaining days.