Find Jobs
Hire Freelancers

Advanced Pivot Table Customization

min $50 USD / hour

Closed
Posted 14 days ago

min $50 USD / hour

I am looking for a pivot table expert who can bring advanced features to my data analysis tool. - Calculated Fields: The core requirement is to create calculated fields, specifically subtraction, using the same data (but of different periods, for example, I have a data table that lists sales for multiple periods, if I pivot on 2 different years, how can I create a calculated field that subtract one year from the other, when the field is the same) that is presented in the pivot table. - Functionality: The table should have all the typical functionalities of advanced pivot tables, such as filtering data, calculating totals and subtotals, and grouping data. I'm looking to have this project completed as soon as possible. Experience in pivot table customization and advanced Excel functionalities is a must.
Project ID: 38020896

About the project

36 proposals
Remote project
Active 11 days ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
36 freelancers are bidding on average $64 USD/hour for this job
User Avatar
As a highly experienced and top-rated freelancer with over 18 years of expertise in Web and APP Development, I'm well-versed in handling complex data analysis projects like yours. My proficiency in PHP and Software Architecture will be pivotal in this project, as these are the core qualities required for advanced Excel functionalities and pivot table customization. In addition to this, I have worked extensively on WooCommerce where we integrated it with Google Merchant through Json. This showcases my ability to work with different platforms and technologies, providing a holistic approach towards your project requirements. Having successfully completed numerous tasks before deadline and within budget, I ensure not just speed but utmost accuracy when it comes to executing tasks. Customers' satisfaction is my priority and I'm proud of the 712+ satisfied clients that have applauded my diligence and attention-to-detail, as well as my ability to blend new features seamlessly with pre-existing modifications. Effective communication is another asset that I bring onboard. As mentioned in my positive reviews, you can expect frequent updates about the progress of your project along with a friendly and professional channel for discussion. Your trust is valuable to me, and as a demonstration of that, I am ready to take up your project immediately and complete it to the best of my abilities well within your desired time frame. Let's get started!
$50 USD in 40 days
4.9 (582 reviews)
8.9
8.9
User Avatar
Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion. Thank you Sandeep
$50 USD in 40 days
4.9 (712 reviews)
8.7
8.7
User Avatar
Dear Daniel L.,   We carefully studied the description of your project and we can confirm that we understand your needs and are also interested in your project. Our team has the necessary resources to start your project as soon as possible and complete it in a very short time.   We are 25 years in this business and our technical specialists have strong experience in PHP, Visual Basic, Data Processing, Excel, Software Architecture and other technologies relevant to your project.   Please, review our profile https://www.freelancer.com/u/tangramua where you can find detailed information about our company, our portfolio, and the client's recent reviews.   Please contact us via Freelancer Chat to discuss your project in details or let's appoint time for Zoom meeting to meet and discuss your project in details.    Best regards, Sales department Tangram Canada Inc.   
$50 USD in 5 days
4.7 (225 reviews)
8.7
8.7
User Avatar
Hello, I am an Excel expert and I would like to help you with your pivot tables. Please check my profile and contact me to discuss further details. Regards.
$50 USD in 10 days
5.0 (517 reviews)
8.1
8.1
User Avatar
As a seasoned pivot table wizard, my team and I are fully equipped to handle even the most complex data analysis tasks. With skills honed in PHP, Data Processing, and Software Architecture over the past several years, we have developed not just proficiency but also a creative approach to finding solutions that go beyond the traditional functionalities of pivot tables. Our ability to utilize calculated fields to subtract data from different periods - similar to your case - is just one of the many ways we can add remarkable value to your data analysis tool. One thing we deeply value here at our company is client satisfaction. This forms a core part of our work ethos, evident from our 100% recommendation rate and consistent repeat business. We embrace project development with careful planning, ensuring the delivery of high-quality work in line with our client's specific needs and within agreed upon timelines. Regarding pivot tables specifically, rest assured we are well-versed in advanced Excel functionalities, including filtering data, computing totals and subtotals, and grouping data to give you maximum functionality. Quite simply, if you need seamless customization that stretches the limits of spreadsheets for your pivot tables, we've got you covered. Let's get started on transforming your data analysis tool today!
$50 USD in 40 days
4.9 (26 reviews)
7.1
7.1
User Avatar
Hi There Nice to know your requirement. I have delivered more than Two Hundred Excel Automation Projects in the past five years. Can discuss and work with you to get this task done. Thank you. Durai
$50 USD in 40 days
5.0 (199 reviews)
7.1
7.1
User Avatar
Hello, good time Hope you are doing well I'm expert in MATLAB/Simulink, Python, HTML5, CSS3, Java, JavaScript and C/C#/C++ programming and by strong mathematical and statistical background, have good flexibility for solve your project. I have many experience practical and theoretical in implementation different algorithms (such as: state estimation and Kalman filter, design controller, analysis closed loop stability, signal and systems, signal processing, heuristic optimization, fuzzy logic, neural network and machine/deep learning fields). Evidence of this claim exist in the portfolio. I have read your project description and I can help you (without any plagiarism). Please send me the details of your project. Thanks for attention 100% Jobs Completed, 100% On Budget, 100% On Time ⭐⭐⭐⭐⭐ 5-star reviews
$50 USD in 40 days
5.0 (9 reviews)
6.5
6.5
User Avatar
Hi! I have read your details, and it seems like you're looking for a freelancer for "Advanced Pivot Table Customization". Well, I have 9+ years of experience in Full-Stack development and have expertise in Tool Customization. Regarding your project, I would like to ask a few questions for better clarification: 1- Can you please explain more about the nature of your project and business? 2- Will there be any third-party integrations required? 3- Are there any security requirements or authentications that need to be considered? 4- Can you please share the complete workflow of the calculation functionality? 5- Is there any preferable tech stack required? If you can respond to the questions over the chat, that'll help me fully understand the scope of work. I am happy to have a follow-up call based on your availability and time zone. Thank you.
$50 USD in 40 days
5.0 (7 reviews)
6.5
6.5
User Avatar
Hi, Are you in search of a highly skilled Microsoft Excel expert proficient in automated solutions encompassing Excel VBA, Excel formulas, Excel macros, functions, Excel dashboards, and Pivot tables? Look no further, as you have arrived at the right place! At EXO Automations, I offer a comprehensive range of solutions tailored to meet your needs: Excel Automation through Excel VBA and Excel Formula Interactive and Dynamic Excel Dashboard MS Excel User forms, Charts & Graphs Automatic Invoicing, Sales Orders, Payroll using Excel vba Data Analysis and Web Scraping Custom Excel Spreadsheets/Templates Complex Excel formula Google Sheets Expert (Google Spreadsheets) and much more
$50 USD in 40 days
4.8 (34 reviews)
6.3
6.3
User Avatar
Hey there! Picture this: your project, but even better. I've got skills that'll make your ideas sing and your goals soar. Let's chat and make some awesomeness happen together. Trust me, it's gonna be epic!
$50 USD in 7 days
5.0 (36 reviews)
6.2
6.2
User Avatar
Hello. I am an experienced data analysis developer having more than 8 years of experience in pivot table customization and advanced Excel functionalities. I am confident that I can help you enhance your data analysis tool with advanced pivot table features. To clarify the requirements, I kindly request the following information: 1. Can you provide a sample dataset for the pivot table? 2. Do you have any specific requirements for the user interface of the pivot table? 3. Are there any other specific calculations or functionalities you need besides subtraction? Let's have a quick chat session so we can discuss the project thoroughly. I look forward to connecting with you on this project.
$50 USD in 40 days
5.0 (19 reviews)
5.8
5.8
User Avatar
Hi, I can help you in building and customizing Pivot table tool. I have a clear understanding of your core needs for the data analysis tool: Calculated Fields: I can implement calculated fields that perform subtractions on data from different periods within the pivot table. This will allow users to easily compare sales figures across years or any other relevant timeframes. Advanced Pivot Table Functionality: The tool will provide all the functionalities expected in an advanced pivot table, including: Filtering Data: Users will be able to filter data based on specific criteria to focus on relevant subsets. Calculating Totals and Subtotals: The tool will automatically calculate grand totals, subtotals for rows and columns, and other essential summaries. Grouping Data: Users will have the option to group data by different categories for further analysis. Lets get into chat for further discussions. I am online right now. Thanks Pankaj
$50 USD in 40 days
5.0 (8 reviews)
5.0
5.0
User Avatar
Hi there, I am writing to express my keen interest in bringing advanced features to your data analysis tool, particularly in pivot table customization. With extensive experience in PHP, Visual Basic, and Excel, I am well-equipped to fulfill your requirements for calculated fields and advanced functionalities. I am committed to delivering high-quality results promptly and am eager to discuss how I can contribute to the success of your project. Best regards, Martin
$50 USD in 40 days
4.9 (9 reviews)
4.7
4.7
User Avatar
Hello, I hope this message finds you well. I am writing to express my keen interest in the opportunity to collaborate with you on your project. With a wealth of experience in constructing dashboards and analytical systems, particularly with extensive datasets, I am confident in my ability to deliver results that align closely with your requirements. Having thoroughly grasped the scope of your project and your envisioned outcomes, I am committed to providing a solution that meets and exceeds your expectations. Your satisfaction with the final deliverables is paramount, and I am dedicated to ensuring that our discussions inform every aspect of my work. In order to proceed effectively, I kindly request detailed information regarding the specific dataset you intend to pivot. Having access to sample data will greatly facilitate our collaboration and enable me to tailor my approach accordingly. I am genuinely excited about the prospect of working together and contributing to the success of your project. Thank you for considering my candidacy. I eagerly await the opportunity to discuss further details and embark on this journey with you. Warm regards, Bachana
$50 USD in 40 days
5.0 (2 reviews)
4.7
4.7
User Avatar
Greetings! I read and understood your need for pivot table advanced skilled support,. I have over 15 years of MS Excel Experience. I am specialized in Excel Reports Automation, and presenting multi source files in consolidated and migrated report as per your requirement However, my commitment does not end when the project is finished. I strongly believe in providing exceptional after-service support to my clients, ensuring their continued support for any data-related queries. Your success is my top priority, and I am committed to being a reliable partner throughout our cooperation. I can Do: - Any required Excel Formulas. - MS Excel Spreadsheets cleaning and Formatting. - MS Excel Spreadsheets Conditional Formatting. - MS Excel Spreadsheets Standardizing . - Excel Reports Automation. - Presenting (Pivot Table, Pivot Charts or spreadsheet Tables) for multi source files in consolidated and migrated report as per your requirement - Power BI charts and reports. Please don't hesitate to accept my offer and feel free to visit my Portfolio for some related previous projects samples. Regards, Emad @EmadOwaida's profile on Freelancer https://www.freelancer.com/u/EmadOwaida?frm=EmadOwaida&sb=t
$50 USD in 40 days
5.0 (1 review)
3.5
3.5
User Avatar
Hello Daniel, I understand that you are seeking a pivot table expert to enhance your data analysis tool by incorporating advanced features such as calculated fields and typical pivot table functionalities. With my expertise in PHP and experience in pivot table customization and advanced Excel functionalities, I am confident in delivering the desired results for your project. I plan to achieve this by implementing custom PHP scripts to generate the calculated fields and ensure seamless integration with the existing data structure. Effective communication will be maintained throughout the project to ensure that your requirements are met accurately and efficiently. I look forward to the opportunity to collaborate on this project and bring your vision to life. Best regards, Itahand Naizir
$500 USD in 7 days
5.0 (1 review)
3.0
3.0
User Avatar
With over 7 years of experience as an Excel specialist, I have a proven track record in pivot table customization and advanced Excel functionalities, making me an ideal fit for your project. My expertise in designing and engineering complex formulas is particularly fitting for your need to create calculated fields while ensuring the data is from different periods. I can confidently handle filtering, totaling, subtotalling, data grouping and more to provide you with a robust and user-friendly solution. One of my strengths lies in streamlining workflows through automation with VBA and Power Query. By leveraging these tools intelligently for your project, I can enhance its efficiency and effectiveness. My priority is always to make your life easier by offering comprehensive, accurate and timely solutions. Lastly, as a graduate of the University of Colombo with a degree in Industrial Statistics and Mathematical Finance, I bring a solid understanding of the underlying logic behind your data needs. Trust me with your project and let's transform your pivot tables into powerful analytical tools.
$50 USD in 40 days
5.0 (2 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Cincinnati, United States
0.0
0
Member since Apr 22, 2024

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.