Certified Microsoft Excel, Google Sheets & Salesforce Specialist

I specialize in converting spreadsheets into streamlined, automated systems using VBA programming and my extensive background in finance and operations. With over a decade of consulting experience, I design efficient processes to automate daily tasks for clients ranging from students to large corporations.

Credentials & Experience

• Certified Specialist in Microsoft Excel and Google Sheets Programming
• Certified Salesforce.com Administrator
• Over a decade of consulting experience with substantial datasets
• Background in finance, operations, and business processes
• Highly responsive and committed to accuracy and deadlines
• All work is guaranteed and handled with complete confidentiality

Services Offered

Microsoft Excel | Google Sheets

• Dashboards, Scorecards, and Customized Templates
• Pivot Tables, Dynamic Charts, and Advanced Formulas (Vlookup, SumIfs)
• Data Validation, Conditional Formatting, and Dynamic Drop-down Lists
• VBA Programming: User Forms, Message Boxes, and Custom Buttons
• Web Scraping (Python), Mail Merge, and PDF Outputs
• Google Suite Automation (Sheets, Forms, Google Scripts)

Salesforce.com

• Salesforce Instance Setup (Essentials, Professional, Enterprise)
• Customization of Page Layouts, Fields, and Picklist Values
• Advanced Automation using Workflow and Process Builder
• Custom Reports, Dashboards, and List Views
• Data Import, Cleanup, Migration, and Salesforce Training

Other Areas of Expertise

• Logo Design, Restaurant Menus, and Flyers
• QR Code Creation for Websites and Menus
• Support for Student Projects and Online Courses (DeVry, Pearson, myitlab)
• Kenexa Prove It Test Exam Preparation

Contact Information

Call or email Pete at 847-461-9062 to arrange a complimentary, no-obligation consultation.