Excel Formula for Real Estate Expenses

Job ID: 38109084

Budget: $15 – $25 AUD

I have a real estate development company, and I'm looking for a dedicated Excel expert to help me streamline my expense tracking process.

Key Requirements:
- I already have a template set up and in one of the tabs I have a CSV statement import. Your primary task will be to create a formula that can automatically pull data from a statement import into the relevant property tab.
- The data should be ordered by date to ensure clarity and easy reference.
- I have created a macro to change the debit figures to negative amounts in the spreadsheet.
- I am open to changes/ideas on if it requires a different setup.

Ideal Skills and Experience:
- Advanced Excel skills are a must. You need to be comfortable working with complex formulas to manipulate data.
- Experience with real estate or property development would be a plus, but not essential.

Please provide examples of previous work that demonstrate your skills with Excel and, if possible, any experience you have with property development.