Profile image of mjl78
@mjl78
Member since June, 2009
0 Đề xuất

mjl78

Trực tuyến Ngoại tuyến
Strong background in Manufacturing as a degreed Industrial Engineer. Developed a strong skill and expertise with computers and am a super user of Excel and Powerpoint. I know visual basic and can write macros. Additional expertise with MS Access Very strong with financial analysis, spreadsheet design, formal presentation, graphs, etc. I can create or customize simple to complex spreadsheets and am highly proficient and innovative with data manipulations, data summaries, reformatting of data, and creating graphs.I possess very strong analytical, problem solving and business skills and experience. Provide high quality products in a very timely manner 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 a. Use visual basic to write macros as needed b. Data is automatically linked to other worksheets where applicable 5. Automate Data Inputting using other Excel or CSV files a. Make use of OPEN FILENAME macro to access data to input b. Make use of drop downs, checkboxes, etc. 6. Providing complex data manipulations / data summaries / dashboards & metrics 7. Use advanced formulas (SUMIFS, COUNTIFS,SUMPRODUCT), Defined Names, Dynamic Data Range updates using OFFSET, automated emailing 8. Pivot Tables 9. Creating templates, automated input sheets, and data transfers as needed 10. Creating professional presentations / training materials / process flow charts
$15 USD/giờ
3 đánh giá
1.9
  • 100%Các công việc hoàn thành
  • 100%Đúng ngân sách
  • 100%Đúng giờ
  • N/ATỉ lệ thuê lại

Portfolio

Các đánh giá gần đây

  • image of jkk Microsoft EXCEL expert to create a template $30.00 USD

    “It is generally claimed that experience provides the best result. It is completely true when I had the project going with Marty. He had the desired output before we could complete the discussion on the inputs...all that was required was minor changes. I am delighted to have Marty working on this project. Great work indeed. And good to interact with him as well.”

  • image of ThatsImpact Need template of legal contract or agreement for Data Entry $30.00 USD

    “in three words... FAST! INTELLIGENT! TRUSTWORTHY! Surely, I will hire him again. Thank you.”

  • image of NicolaLee888 Need an Excel Whizz: needs presentation improvement $30.00 USD

    “Marty really is an Excel whizz and that's exactly what I advertised for! So pleased with the result never seen work this immaculate and precise. Excellent communicator and kept to timings, great attention to detail! Will definately be recommending this provider to others (already have today ;-) ).”

Giáo dục

B.E.I.E

1968 - 1972 (4 years)

Các Chứng Nhận

  • Đã kết nối với Facebook
  • Freelancer Ưa Thích
  • Đã Xác Thực Thanh Toán
  • Đã Xác Thực Điện Thoại
  • Đã Xác Thực Danh Tính
  • Đã Xác Thực Email

Các kỹ năng hàng đầu của tôi

Xem các Freelancer tương tự