Seocheckout

Microsoft Excel and Visual Basic Expert for $30

Level 1
Attention: The owner of this service has not logged into Seocheckout for more than 30 days. It is highly recommend that you contact them before ordering this service. Last Login: 2661 days ago

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.


Tags

Highquality Expert Fast

0.0

0 reviews

Rating breakdown


Other services by MJLexcelexpert

$30 - In stock