Hi,
I have good expertise in Excel VBA, macros and Automation.
- Have done some complex logic and solutions with Excel including the Wiring design for Canadian company where it will find the optimum wire based on dimensions of room, Resistance, Volt and amps.
- Also reporting based on the criteria entered in a neat PDF format.
- All these can be done with Button clicks.
Pl. ping me to discuss further.
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...