About This Service

Certified Specialist in Microsoft Excel and Google Sheets Programming | Certified Salesforce.com Administrator

I specialize in converting spreadsheets into streamlined, automated systems. My core skill lies in VBA, a robust programming language integrated into all Office products, which is used for database communication. Leveraging this technology alongside my extensive background in finance, operations, and business processes, I can develop nearly any form of automated tool or business intelligence system within Microsoft Excel or Google Sheets.

With over a decade of consulting experience, I work with substantial datasets to design and implement more efficient processes that automate and simplify your daily tasks. I welcome projects of any scale, assisting everyone from students and individual entrepreneurs to small business owners and large corporations.

I value honesty and reliability above all. I am highly responsive to client communications and committed to completing all work accurately and on schedule. Please call or email me to arrange a complimentary, no-obligation consultation to explore how I can assist you.

Contact Information

Pete | 847.461.9062

Microsoft Excel | Google Sheets

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

Salesforce.com

• Salesforce Instance Setup: Essentials, Professional, Enterprise
• Customization of Page Layouts for Accounts, Opportunities, Contacts, Tasks, and Home Pages
• Non-Standard Customizations: Adding New Fields and Modifying Picklist Values
• Building Advanced Automation Using Workflow and Process Builder
• Creating List Views and Building Customized Reports and Dashboards
• Data Import for Accounts, Contacts, and Other Objects; Data Loader
• Salesforce Training, Data Cleanup, and Migration

Other Areas of Expertise

• Logo Design, Restaurant Menus, and Flyers
• QR Codes for Business Websites, Google Forms, Surveys, and Restaurant Menus
• Student Projects, Homework Assignments, and Online Excel Courses
• Support for DeVry, Blackboard, ilab, myitlab, and Pearson platforms
• Kenexa Prove It Test Exams (Excel, Word, Outlook, Access – versions 2010, 2013, 2016, 2019)

All work is guaranteed and handled with complete confidentiality.

Keywords: Microsoft, Excel, Word, Outlook, VBA, Graph, Charts, Freelancer, Macro, Analysis, Query, Spreadsheet, Database, Tool, Table, DeVry, Homework, assessment, ilab, myitlab, pearson, prove it, proveit, excel 2007, excel 2010, excel 2013, excel 2016, Dashboard, template, logo design, formulas, vba, macro, automate, streamline, reporting, salesforce.com, sfdc, developer, programmer, excel guru, google docs, google forms, google sheets, apps script, access, database, sql, python, webscrape, data tables, logo design, business intelligence, automation, template, sales, finance, marketing