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

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

303 Party Bus LLC

Class B Part time Party Bus Drivers Class A or B with Passenger endorsement Job Job at 303 Party Bus LLC

Class B Part time Party Bus Drivers Class A or B with Passenger endorsement JobPart time CDL drivers needed immediately, Class A or B with Passenger endorsement (P2) for reputable party bus company. Positions are part time as needed. Flexible scheduling and weekends... 

JPMorgan Chase Bank, N.A.

Control Manager, Executive Director - Consumer and Community Banking Product and Experience Job at JPMorgan Chase Bank, N.A.

 ...anti-fraud awareness to detect potential threats and maintain the security of our network, applications, and data.+ Oversee the execution of operational plans and strategic projects, ensuring alignment with broader functional and organizational strategy.+ Leverage expert... 

St. Catherine of Siena Parish

Youth Director Job at St. Catherine of Siena Parish

Position Summary:The Youth Director is tasked with creating and implementing a comprehensive Faith Formation and Youth Ministry program...  ...management, and budgeting. Knowledge of adolescent spiritual and personal development, youth culture, and sociology. Must... 

Dental Metrics Maven

Orthodontic Laboratory Technician Job at Dental Metrics Maven

 ...Orthodontic Technician Dental Laboratory Location: Philadelphia, PA We are seeking a talented Orthodontic Technician to join...  ...environment. Participate in ongoing improvements to workflows and lab processes. Qualifications Previous experience in... 

SeekTeachers

Middle/High School Business/Economics Job at SeekTeachers

Description Business/Economics Teacher | Teach in Saudi Arabia | Teacher Abroad NB: Chances are very...  ...the email: ****@*****.*** Requirements to apply ~A Degree in Business or a related subject from an accredited...