Hi,
I have good expertise in Excel and Outlook automation.
- Based on the Flat list, corresponding data for the employee can be extracted
- Calculations done
- Email template formed and the Data file corresponding to the employee can be triggered to the employee.
This could be automatic process initated from Excel itself.
Have done similar Outlook automations and triggering of emails for the select list of employees.
My Skills:
- Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs.
- Extensively the macros/VBA to automate:
- Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells
- Data camparision using formulas, lookups and bringing up summaries.,
- Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them.
- With summary data plotting graphs, bringing pivot tables
- Pl. review my portfolio on projects done - https://www.freelancer.com/u/satishtl
Sample HighComplex Projects using Macros: (via Freelancer)
- Complex Data anlaysis and graphing, UK
- Heating Wire Design, Canada,
- University Scoring, US -
-Roster and Wage calculations , Australia
- System Login/Logout - Greece
- Wood cutting Automation - Peru...