Microsoft Excel and Visual Basic Expert

Highly trained and experienced with computer consulting in the area of Microsoft Excel
and Visual Basic (writing macros) and PowerPoint

• Creating simple to complex spreadsheets / data manipulation / automation
• Visual basic programming
• Creating pivot tables, summary data using SUMIFS & COUNTIFS, creating ad hoc reports and dashboards
• Create robust Templates / Input sheets that are reusable
  1. Can write macro to automatically add input data to a central DB on another worksheet
  2. Can create summary reports / key metrics from this DB

• Highly proficient with conditional formatting, use of drop downs, check-boxes, etc.
• Eliminate redundant data entry, linking data across multiple worksheets, doing lookups
• Process flow diagrams, flowcharting
• Professional presentations
  
  Thirty plus years in: Manufacturing as an Industrial / Process Engineer. Broad experience in
  
  
  
  1. Manufacturing (domestic and international),
  2. Supply Chain Management, Planning, and Procurement, and Warehousing functions.
  3. Know many Service Functions
  4. Business Planning, Financial / Business Case Analysis, Process Improvements.
  5. Ability to lead highly visibl projects, establish rapport and credibility with diverse groups, with an
     eye toward bottom line results.
  
  
  AREAS OF EXPERTISE:
  
  - Microsoft Excel Consulting - Workflow and Process Improvements - Mergers & Acquisitions - Project Management – Internet Research - Financial Analysis - Lean Manufacturing -Professional Presentations
  
  
  
  WORK EXPERIENCEMJL Consulting 2006- Present
  
  President and Owner
  
  Provide computer consulting support in the areas of Microsoft Excel and PowerPoint. We assist in creating simple to complex spreadsheets and / or making existing spreadsheets more robust or more automated. Trained in visual basic and can write macros as required.
  
  Skill sets:
  
  
  1. Creating/ developing informational databases
     
     
  2. Create ad-hoc reports as required from existing excel data, files
     
     
  3. Creating/ developing spreadsheets (simple to complex)
     
     
  4. Customizing existing spreadsheets to be more robust, automated, and less labor intense
     
     
     1. Use visual basic to write macros as needed
        
        
     [/*]
  5. Providing complex data manipulations / data summaries / dashboards & metrics
     
     
  6. Creating templates, automated input sheets, and data transfers as needed
     
     
  7. Creating professional presentations / training materials / process flow charts
     
     
  8. Make use of drop downs and checkboxes where applicable
     
     
     1. Create dropdowns that automatically update data range and make new additions
        automatically appear on the drop down
        
        
     [/*]
  9. Can create pivot tables or other summary tools such as advanced formulas like
     SUMIFS, COUNTIFS, etc
     
  
  Business Expertise:
  
  
  • Manufacturing / Supply Chain / Logistic and Warehousing / Procurement
  • Real Estate…residential and commercial
  • Service Organizations
  • Mergers and Acquisitions
  We also assist in creating professional presentations using PowerPoint.