- Have good expertise in Excel programing and macros.
- Based on the logged appointments containing the Date, Employee, Job#, address details and the outcome of the appointment
On button clicks the the totals on the
Number of appointments
Data missing
Listing the data based on multiple search criteria
can be displayed.
.
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