Excel Automation: create pivot charts from 7 sheets
Job Id: 1523563: Excel Sheet update and adding a chart A group of hotels in Moncton, New Brunswick, Canada maintains revenue data in 7 Excel sheets for about 400 companies for each month starting from 2017. Its Executive Joey Duplessis needed monthly/yearly totals of each company but she could not create the visuals. She hired me for summary and visual presentation of data by company/by month-year. The totaling from 7 sheets with 400 companies in each sheet was really tough. I created Excel macro program for this purpose. One click creates summary of all companies all months by year and create pivot table and pivot chart. Also another macro adds new company or new year with formula and formatting accurately. This reduced 100% manual task and made her life easy.
About Me
I've been programming since 2005 and freelancing since 2015 at other marketplaces. I've done more than 500 jobs in the following areas. Expertise: -------------- 01. MS Excel: Automation through VBA programming 02. MS Access Database Development 03. MS SQL Server Programming 04. Migration from Excel to Access or Access to SQL Server and User Interface 05. MS Word Automation, Mail Merge 06. MS Outlook Customization, Automation Education: ------------- Graduation: B. A. (Honours) in English Literature and Post Graduation: M. A. in English Literature Employment History: -------------------------- Formerly: Senior Executive Officer, Sonali Bank Limited Bangladesh (up to 2017) At present: Full-time freelance programmer If you award me a job, I assure you that you will consider me again for your next work because I provide quality solutions at a reasonable cost.
$10 USD/hr
NEW FREELANCER!
