I am a certified public accountant currently working as a Senior Accountant of a retail and wholesale company doing financial reports and analysis and subject matter expert for 6 years. Previously worked as external financial auditor for two years. My skill set include:
1. High proficiency with advance excel formulas and functions/Macros/VBA programming and error handling
2. Preparation of Excel Dashboards using Pivot Table, Pivot Charts, Slicers and Shapes
3. Preparation of automated Excel templates and userforms with buttons, dropdown lists, text boxes, scroll bars, calendar, etc.
4. Data Entries, Data Processing, Data Clean-up, Data Validation and Conditional Formatting
5. Preparation of financial statements such as Balance Sheet, Profit or Loss, Cash Flows and Statement of Changes in Owner's Equity
6. Preparation financial models, forecasts and budget