I have very good expertise in Excel including macros for automizing and VBA scripting.
I can build the logical to highlight by color or symbol when certain criteria is met.
Went through your PDF and the Excel.
Used different formulas, lookups in Excel to bring up the computation required.
Please see the reviews for the Excel work I have done.
My skills:
• I have good skills in Excel automation and used 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.
• With summary data plotting graphs, bringing pivot tables etc.
• MS Access - Expert in designing table, user input forms and also reporting from data.
• Excel to MS access data porting and conversion and designing new system for use.