Excel Template Update for Financial Data
Budget: $250 – $750 USD
I am seeking an experienced Excel expert to update or develop an Excel template that allows me to seamlessly copy and paste data from a .csv file into one tab, which will then automatically update monthly company data on various other tabs. The template involves formulas, pivot tables, graphs, and financials.
Key Requirements:
- Resolve issues with columns from the .csv not matching the template.
- Ensure correct currency formatting for South Africa in the Excel template.
- Integrate monthly income and expenses data pulled from Xero.
- Provide guidance on whether specific automation or macros are needed.
- Ensure the template is user-friendly for someone with limited Excel expertise.
Ideal Skills and Experience:
- Strong proficiency in Excel, including formulas, pivot tables, and graphs.
- Experience with financial data management and reporting.
- Familiarity with currency formatting and data integration from .csv files.
- Ability to provide clear instructions and support for template use.
I have examples of the current Excel template and .csv file, and I can explain the desired outcome. Your expertise will help streamline our financial data management process.
Key Requirements:
- Resolve issues with columns from the .csv not matching the template.
- Ensure correct currency formatting for South Africa in the Excel template.
- Integrate monthly income and expenses data pulled from Xero.
- Provide guidance on whether specific automation or macros are needed.
- Ensure the template is user-friendly for someone with limited Excel expertise.
Ideal Skills and Experience:
- Strong proficiency in Excel, including formulas, pivot tables, and graphs.
- Experience with financial data management and reporting.
- Familiarity with currency formatting and data integration from .csv files.
- Ability to provide clear instructions and support for template use.
I have examples of the current Excel template and .csv file, and I can explain the desired outcome. Your expertise will help streamline our financial data management process.