Hi,
I am a CPA and ACA with 10 years’ experience in the accounting and finance field. In my professional career, I’ve performed many accounting and financial tasks in excel to get the required output like budgeting, forecasting, financial modeling, financial projection, Sales Forecast, financial analysis, Profitability analysis, Liquidity analysis, Valuation analysis, breakeven analysis, preparation of financial statements, profit and loss statement, cash flow statement, review and reconciliation of accounts, bank reconciliation, various reports and summaries etc.
I'm well-versed in Excel formulas like (SUMIF, OFFSET, COUNT, VLOOKUP, GETPIVOTDATA), Pivot tables, Excel tables, Data validation, Auto-shapes, Named ranges, Conditional Formatting, Charts, Excel dashboard widgets, Macros, VBA, etc. I have built various types of dashboards like project dashboard, financial dashboard, marketing dashboard, and more for my clients in the past. I can even build an excel dashboard template for your use where, in the future, you can just add values and the rest will all be automated.
With this vast experience in excel, I believe I can help you with this. Looking forward to hearing back from you and complete the task as per your requirements. Please note that this is just a tentative offer as the actual price can only be given after analysis of the workload.