Create Advanced Excel Spreadsheet, Excel Reports With Macros
Hi - I am a highly experienced Excel specialist that has been working with Microsoft Excel in all facets of my academic and working careers.
I develop advanced excel spreadsheets with functionalities such as:
- Buttons
- Macros
- Automated Reporting
- Error Handling for the VBA Macros
- Pivot Tables/Power Pivot
- Advance Formulas to avoid Macros when possible
- Database integration
- Template Creation
My experience and knowledge are from the daily hands-on use and development of Excel and from quite literally creating and enhancing HUNDREDS of spreadsheets throughout my working life.
This GIG will include:
1.Update its efficiency with mathematics functions, text reference, data lookup between different sheets or different Excel Files
2.Select list, buttons, fields for menu,forms,etc
3.Pivot tables
4.Data cleaning (duplicate, empty spaces, standardization, etc)
5.Easier workflow with the implementation of macros for common tasks
6.Design a new Excel worksheet from scratch according to your needs (no matter the topic)
7.Charts and summaries.