- Can get the leads from the campaign into Excel
Sender
To
Body
Names
from the Emails received, if it is Outlook then the automation can be done in Outlook mail itself.
- Have done similar extraction from Outlook.
- Outlook macros - - Samples - Extracting mail contents parsing and sending to different customers, getting the task and calendar events from Outlook to Excel- 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