You will get an Excel template for updating data fields between spreadsheets
Top Rated
Project details
Please message me with any questions ahead of making your purchase -- I am happy to clarify any requirements about this service.
I practiced data visualization and spreadsheet development for over 20 years in the pharmaceutical industry. Working in a fast-paced environment where data accuracy and validity were paramount to project success, I am aware of how important managing data is to your business.
I am pleased to offer an automation template for merging data updates in multiple files into a primary spreadsheet. This is not easily accomplished with default functions in Excel, requiring one to constantly enter formulas or manually transfer hundreds of rows of data. By automating this task, you can spend less time checking data fields and more time checking in with business partners.
The data template allows push-button access for selecting reference and change files. With a click, data entries across sheets are merged into the required fields of the primary sheets. The project is great for managing inventories, price updates, and observations from multiple sources.
I look forward to supporting your business workflow with this template project.
I practiced data visualization and spreadsheet development for over 20 years in the pharmaceutical industry. Working in a fast-paced environment where data accuracy and validity were paramount to project success, I am aware of how important managing data is to your business.
I am pleased to offer an automation template for merging data updates in multiple files into a primary spreadsheet. This is not easily accomplished with default functions in Excel, requiring one to constantly enter formulas or manually transfer hundreds of rows of data. By automating this task, you can spend less time checking data fields and more time checking in with business partners.
The data template allows push-button access for selecting reference and change files. With a click, data entries across sheets are merged into the required fields of the primary sheets. The project is great for managing inventories, price updates, and observations from multiple sources.
I look forward to supporting your business workflow with this template project.
Data Entry Type
Copy Paste, Document ConversionData Entry Tool
Microsoft Excel, Microsoft OfficeWhat's included
| Service Tiers |
Starter
$50
|
Standard
$90
|
Advanced
$160
|
|---|---|---|---|
| Delivery Time | 2 days | 3 days | 5 days |
Number of Revisions | 1 | 2 | 3 |
Number of Hours of Work | 3 | 6 | 12 |
Formatting & Clean Up | - | - | - |
Graph & Table Creation | - | - | - |
Optional add-ons
You can add these on the next page.
Additional Revision
+$15
Additional Hour of Work
+$15
Graph & Table Creation
(+ 1 Day)
+$60
Documentation Packet
(+ 1 Day)
+$30
10 reviews
(10)
(0)
(0)
(0)
(0)
SM
Simon M.
Jan 7, 2025
Mark works wonders and helped us organize an inventory of sixty projects for our team in excel, and even created some Visual Basic macros to automate creation of different spreadsheets. This will allowed us to automate the creation of different data tables and formats without having to manually update this each time we revise or add a project. Mark went above and beyond, met a tight turnaround and even creating a video tutorial to walk through the spreadsheet tool.
JP
Jennifer P.
May 22, 2025
Excel Specialist
Mark is very responsive and always helpful! I look forward to working with him again.
SM
Simon M.
Jan 7, 2025
You will get an Excel template for updating data fields between spreadsheets
Mark works wonders and helped us organize an inventory of sixty projects for our team in excel, and even created some Visual Basic macros to automate creation of different spreadsheets. This will allowed us to automate the creation of different data tables and formats without having to manually update this each time we revise or add a project. Mark went above and beyond, met a tight turnaround and even creating a video tutorial to walk through the spreadsheet tool.
DB
Drew B.
Sep 13, 2024
Quick data viz
Jumped on a rush job, couldn't have been better! Good work Mark!
EE
Eisaiah E.
Sep 4, 2024
Statistically significant test for product efficacy
Mark helped our startup think through a statistical test of our new product. He had to make a lot of strategic guesses to help us build a framework for performing a trial. Mark brought deep expertise from his work in pharma clinical trials. He helped us define a range of factors and outcomes. Overall, we learned a great deal from him and now have a solid foundation for the next stage of product testing.
VM
Vasudeva M.
Sep 4, 2024
mentoring support for statistical analysis
About Mark
Data Science Communicator and Visualizer in R, Python, and Excel
100%
Job Success
St. Louis, United States - 1:17 am local time
As a freelancer, I've developed strengths working with U.S. Census data sets and supporting projects in real estate, housing, and community outreach. I am always looking forward to doing analysis that improve neighborhood outcomes. Also, my background in chemistry and pharmaceuticals allows me to dive into technical details supporting many other fields.
My primary focus are tasks using R, Python, Excel, and Power Query. I am interested in statistical analysis, hypothesis testing, experimental design, SQL queries, and machine learning models. Further, my technical writing skills and analytical mindset have helped me to understand AI and ChatGPT integration into various business workflows including prompt architecture and data retrieval.
Having worked in fast-paced pharmaceutical development for small companies, I am accustomed to quickly learning business strategies and their impact across different functions. Further, technical writing projects helped me present complex processes to non-scientific audiences. This has given me a well-rounded approach to understanding a variety of regulatory, quality, and business-related concepts.
Clear problem statements drive successful projects, and I value collaboration and communication about project design. Let's talk about how we can convert your data into information and reach your key audiences!
Steps for completing your project
After purchasing the project, send requirements so Mark can start the project.
Delivery time starts when Mark receives requirements from you.
Mark works on your project following the steps below.
Revisions may occur after the delivery date.
Review Requirements and File Formats
Customer requirements and design requirements are checked to ensure compatibility with the design template. Both file format and content could impact the process. Clarifications on design should occur here or ahead of making the request.
Build Template Design
A custom template is standardized to meet the customer requirements for data import.