Over the last 5 years, I have developed a wide range of automated Microsoft Excel, Word, PDF, PowerPoint and Web Scraping projects to save my clients time and money on their everyday repetitive tasks. My skills are not limited only with-in Excel, Word, PDF and PowerPoint, but I can code programs to communicate between these applications. For example if you require data from your Excel file to populate fields in a Word or PDF file at a click of a button.
Read More »
My areas of expertise include:
- Excel Automation
May 28, 2015|Software Application|Private|Completed
May 20, 2015|Data Entry|Private|Completed
May 19, 2015|Data Engineering|Private|Completed
May 12, 2015|Virtual Assistant|Private|Completed
With years of experience using Microsoft Products I can develop VBA programs to automate any task using Microsoft Excel, Word, PowerPoint and PDF. And create programs that allow communication between these applications.
- Creation of User Forms that allow users to input data into Text Fields, Combo Boxes, List Boxes, Option Buttons, etc. The inputted data is then used to create tables, pivot tables, graphs, charts, export to other files, etc.
- Creation of visually appealing Templates / Dynamic Dashboards to give your company a professional look. Examples include Invoices, Sales Tracking Progress Reports, Company Budget, Event Flyers, Calenders, etc
- Creation of clean, neat and organized Pivot Tables / Chart / Graphs to help display your data.
- As a web scraper I have the skills to write a program that scrapes websites and displays the information in Excel according to my clients needs. Every scraping job requires a unique code to extract the data properly.
With a great understanding of Excel, Word, PowerPoint and PDFs I can complete any of your macro and data entry tasks as well.
If you'd like to see some of my work, my portfolio showcases some projects that I have previously completed.
Read More »