Excel VBA / PPT Client Analytics project
- or -
Post a project like this$$
- Posted:
- Proposals: 6
- Remote
- #1252806
- Expired
PPH #1 Service Provider in Development & IT : Wordpress|Magento|React Native|Mobile App Development|Angular|Node.js
Mohali
Microsoft Office (Excel / Word / PowerPoint/One Note/Publisher/Visio), VBA, and SQL Reports developer
Lewisville
1283427507971214404133113913453091358589
Description
Experience Level: Intermediate
Industry: Business
Description of excel work: Hello!
I hope you are well.
I have a project that consists of three parts:
1. I have built a VBA code that performs a: copy, paste, format and save as. I would like this to be optimized.
*File available
2. I have datasets for PRODUCT TYPE, INDUSTRY and SALESPERSON. I need the dataset to be setup as a CUBE to be sliced and diced in different ways (SLICER functionality). I need to know how to add more columns to this cube as well.
*Concept
3. After completing (2) and building out PIVOT tables that I want reported, I want to link (2) from above in Excel to a Powerpoint file. SO whenever (2) is updated with new data, the PPT deck is automatically updated as well. For example, if I copy and paste a Pivot table, Chart or table set and then update the data in Excel - there should be some functionality where the Pivot table, Chart or table set in PPT update automatically while keeping the formats.
*Concept
- I am looking for optimized, clean code with good notes - Open to suggestions for better techniques etc.
Thank you very much
Rafi
Design and target audience: Executive Management
Extra notes:
Description of excel work: Hello!
I hope you are well.
I have a project that consists of three parts:
1. I have built a VBA code that performs a: copy, paste, format and save as. I would like this to be optimized.
*File available
2. I have datasets for PRODUCT TYPE, INDUSTRY and SALESPERSON. I need the dataset to be setup as a CUBE to be sliced and diced in different ways (SLICER functionality). I need to know how to add more columns to this cube as well.
*Concept
3. After completing (2) and building out PIVOT tables that I want reported, I want to link (2) from above in Excel to a Powerpoint file. SO whenever (2) is updated with new data, the PPT deck is automatically updated as well. For example, if I copy and paste a Pivot table, Chart or table set and then update the data in Excel - there should be some functionality where the Pivot table, Chart or table set in PPT update automatically while keeping the formats.
*Concept
- I am looking for optimized, clean code with good notes - Open to suggestions for better techniques etc.
Thank you very much
Rafi
Design and target audience: Executive Management
Extra notes:
Rafi B.
0% (0)Projects Completed
-
Freelancers worked with
-
Projects awarded
0%
Last project
5 May 2024
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies