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
- Can write macro to automatically add input data to a central DB on another worksheet
- 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
- Manufacturing (domestic and international),
- Supply Chain Management, Planning, and Procurement, and Warehousing functions.
- Know many Service Functions
- Business Planning, Financial / Business Case Analysis, Process Improvements.
- 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:
- Creating/ developing informational databases
- Create ad-hoc reports as required from existing excel data, files
- Creating/ developing spreadsheets (simple to complex)
- Customizing existing spreadsheets to be more robust, automated, and less labor intense
- Use visual basic to write macros as needed
[/*] - Providing complex data manipulations / data summaries / dashboards & metrics
- Creating templates, automated input sheets, and data transfers as needed
- Creating professional presentations / training materials / process flow charts
- Make use of drop downs and checkboxes where applicable
- Create dropdowns that automatically update data range and make new additions
automatically appear on the drop down
[/*] - 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.