Excel Formula Update and Formatting Cleanup
Budget: $30 – $250 USD
I need a skilled Excel professional to clean up the formatting in my Excel document so that "amount" and "total" columns are formatted consistently (centered or justified to right) and ensure that existing formulas in "amount" columns calculate to amounts in "total" columns. Create formula for all "total" amounts to calculate and produce grand total at end of doc. The project involves adding new formulas ensuring that newly inserted data is added to "amount" colum that the numbers will automatically calculate and be added to the totals, similar to the setup at the beginning of the document. When in doubt please ask questions. This is a small project with a deadline of end of day to late evening Sunday, 01/26/25.
Key Tasks:
- Create a grand total at the end of the document.
- For the section starting with 'MONEY INTO ESTATE', devise a new formula that will automatically compute all subsections and provide a grand total at the end of this section.
The data in the 'FEES' and 'MONEY INTO ESTATE' sections are a mix of text and numbers. While no special financial calculations like taxes or interest need to be considered, error-checking for data input is crucial and needs to be incorporated into the formulas. Format doc so that all columns align with consistency and that line spaces are consistent (close up (delete) any extra line spaces). Final doc should be overal professional in look and formulas.
Ideal candidates for this project should be well-versed in Excel, with experience in creating complex formulas and formatting documents for ease of use. Attention to detail and ability to implement error-checking mechanisms are essential.
Key Tasks:
- Create a grand total at the end of the document.
- For the section starting with 'MONEY INTO ESTATE', devise a new formula that will automatically compute all subsections and provide a grand total at the end of this section.
The data in the 'FEES' and 'MONEY INTO ESTATE' sections are a mix of text and numbers. While no special financial calculations like taxes or interest need to be considered, error-checking for data input is crucial and needs to be incorporated into the formulas. Format doc so that all columns align with consistency and that line spaces are consistent (close up (delete) any extra line spaces). Final doc should be overal professional in look and formulas.
Ideal candidates for this project should be well-versed in Excel, with experience in creating complex formulas and formatting documents for ease of use. Attention to detail and ability to implement error-checking mechanisms are essential.