
Open
Posted
•
Ends in 4 days
I have an existing workbook that needs two upgrades: solid IF / SUMIF logic and a clean, automated export to PDF. The current sheets already hold the raw data, but totals, flags, and conditional results are still being calculated manually. I’d like you to: • Replace the manual steps with reliable IF and SUMIF formulas so the correct figures appear instantly, even when rows are added or data is shuffled. • Set up a one-click (or short-cut) PDF export that captures only the intended print area, keeps my page setup intact, and produces a professionally formatted document every time. Feel free to use native Excel tools, VBA, or another lightweight approach as long as it works on Office 365 for Windows without additional add-ins. Deliver the updated workbook plus a brief set of notes or a quick loom/video showing where you placed the formulas and how to trigger the PDF. I’m ready to start as soon as I find the right fit and will be available to answer questions or share a sample file right away.
Project ID: 40747677
13 proposals
Open for bidding
Remote project
Active 1 day ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
13 freelancers are bidding on average ₹194 INR/hour for this job

EXCEL WORKBOOK UPGRADES Dear Client, ABOUT ME: I am John K., an experienced academic writer and statistician with a 4.9 rating from 173 reviews on Freelancer. I specialize in data analysis and have successfully completed over 1000 projects, delivering impactful research and publications. ? - UNDERSTANDING OF THE PROJECT REQUIREMENTS: I recognize your need for automation in Excel to replace manual calculations and streamline PDF exports. I will ensure accurate formulas are implemented correctly. - HOW I WILL DELIVER: Utilizing native Excel tools and VBA, I will create reliable IF and SUMIF logic for instant updates, alongside a one-click PDF export feature for professional documentation. ?️ - WHAT I WILL DELIVER: You will receive an updated workbook with automated calculations and a brief guide or video demonstrating the new functionalities, ensuring clarity and usability. Your project aligns perfectly with my expertise, and I am committed to providing a solution that meets your needs effectively. Kind regards, John K.
₹100 INR in 40 days
4.5
4.5

★★★ TOP 1% IN FREE LANCER WORLD ★★★ ★★★ 20+ Year Experience in IBD being CMD★★★ ★★★ 200+ Country Satisfied Clientele ★★★ ★Linkedin★ ★Data Entry★ ★Business Plans★★★ ★★★ Operational Strategic planner Customer Support 24*7★★★ ★★★Excel/Word Operation★★★ ★★★Chat Support★★★ ★★★Calling Support★★★ ★★★Business Plans / Marketing Strategy ★★★ * Digital Marketing★★★ ★★★Social Media Marketing ★★★ ★★★Internet Marketing ★★★ ★★★Any type of Data Projects★★★ ★★★★★★ Regards, ★★★CMD★★★ ★★★PVSYS GROUP (INDIA)★★★ ★★★IF YOU THINK THEN I CAN★★★
₹100 INR in 40 days
3.5
3.5

Hello! I can upgrade your existing Excel workbook with reliable IF and SUMIF formulas that automatically adjust as rows are added or data is rearranged. I will configure a professional one-click PDF export using native Excel tools or lightweight VBA, preserving the correct print area, page setup, and formatting. The completed workbook will be fully compatible with Microsoft 365 for Windows and thoroughly tested for accuracy and ease of use. I will also provide clear notes or a short instructional video explaining the formulas and PDF export process.
₹250 INR in 20 days
3.2
3.2

The primary goal is to automate manual calculations in your workbook using reliable IF/SUMIF logic and to set up a consistent one-click PDF export feature for Office 365 on Windows. I will structure the formulas to ensure calculations remain accurate even if rows are added or reordered, and configure the PDF export to maintain the existing page setup and defined print area. My Approach: I will first audit the workbook structure and existing manual logic, then implement robust IF/SUMIF formulas and validate edge cases. Next, I will set up a one-click or shortcut-based PDF export using lightweight VBA, ensuring that the print area, orientation, margins, scaling, and formatting are preserved. Finally, I will test the workbook and provide concise notes along with usage instructions. 1. Should the PDF export cover a specific sheet or multiple sheets? 2. Must the existing formulas and formatting be fully preserved? 3. Should the PDF filename and location be generated automatically? I will deliver a tested, user-friendly, and maintainable workbook that effectively eliminates manual effort in daily use.
₹250 INR in 40 days
2.1
2.1

I reviewed the sample workbook and the current structure is straightforward, so I can complete the requested Excel logic and PDF automation cleanly without overcomplicating the file. I can add the required IF/SUMIF logic so the results update reliably as rows are added or changed, and I’ll keep the formulas transparent so you can adjust them later. I can also configure the worksheet for clean printing and add a one-click VBA PDF export that uses the intended print area and preserves the page setup. I’ll test the formulas with changed and added rows, verify the PDF output, and include a short note showing where the formulas are located and how to run the export. I can complete this within 1 day.
₹100 INR in 3 days
0.3
0.3

Your IF/SUMIF logic and one-click PDF export are exactly the parts I’d focus on. I’d replace the manual calculations with reliable formulas, preserve the existing print area and page setup, and use an Office 365-friendly button or shortcut for the PDF export. I can deliver a first pass within 1 day and include short notes showing where everything is. Would you prefer the PDF export on a button or a keyboard shortcut?
₹100 INR in 40 days
0.0
0.0

I bring over 7 years of professional experience, including hands-on work as a Quality Analyst at HCL. This means accuracy, attention to detail, and catching errors before they become problems isn't just a skill I claim — it was my actual job. For your data entry, cleanup work and excel work, I'll apply that same QA mindset: placing records in the correct columns, categorizing them properly, removing duplicates, and cross-checking spelling, figures, and formatting before I consider anything "done." I don't just enter data — I verify it, the way I was trained to review high-volume work for compliance and accuracy. I'm comfortable working independently in Excel/Google Sheets/Word and can start right away. I am new to Freelancer and Freelancing work, hence don't have any projects to show for, I did similar tasks previously in my job but not on Freelancer. I would be very grateful if you can give me my first project. I can start away right now.
₹200 INR in 20 days
0.0
0.0

Hi, I've read your project description and it's something I can help with. I'm Willem, a developer who builds websites, dashboards, and business tools, and I can start right away. I specialize in Excel automation and can efficiently create the IF and SUMIF logic you need, ensuring that your calculations update automatically with data changes. Additionally, I will implement a streamlined PDF export that maintains your formatting and captures the correct print area with just one click. To give you an accurate price and timeline, could you tell me what the most important result is for you, and whether you have a deadline? Worst case, we have a quick chat and you walk away with a free consultation on your project. Regards, Willem
₹200 INR in 7 days
0.0
0.0

I recently worked with a client looking to streamline their Excel processes, similar to your project. We helped them automate calculations and improve their reporting efficiency significantly. I can enhance your workbook by implementing reliable IF and SUMIF formulas, ensuring your totals and flags update automatically. Additionally, I’ll create a simple one-click PDF export that maintains your page setup and delivers a polished document every time. With 75+ 5-star reviews on similar projects, I rank in the top 1% among 75 million users. I’d love to discuss your vision further and start right away. Regards, HGNadia
₹200 INR in 7 days
0.0
0.0

Hi, I can update your existing Excel workbook with the required IF/SUMIF logic and add a simple PDF export button while keeping the correct print layout. I’ll review your sample file first, implement the automation, and test everything in Office 365 on Windows. Please send the sample workbook and the expected calculation rules. I can start immediately.
₹150 INR in 12 days
0.0
0.0

I can replace the manual IF/SUMIF steps with maintainable formulas and set up a reliable PDF export that respects the intended print area and page setup in Excel 365 for Windows. If you share a redacted sample workbook through Freelancer, I can first demonstrate one representative formula and one PDF-page layout as a private screenshot-level preview. This small fit check is free; the completed workbook, working export control and editable implementation are delivered after the agreed platform milestone is funded. My approach is to first inspect the current worksheet structure and expected examples, then implement the conditional formulas using clear ranges or Excel Tables so new rows are included; add test cases for blanks, text-number mismatches and reordered rows; configure the print area, margins, headers and page breaks; and use a lightweight VBA button only if macros are acceptable—otherwise I will keep the export native to Excel. I will return the updated workbook plus concise written operating notes. Before starting, please share the number of worksheets, one example of each expected result, and whether macro-enabled files are permitted. I estimate 2–4 hours at INR 400/hour after reviewing the sample and will confirm the upper limit before work begins.
₹400 INR in 4 days
0.0
0.0

Hi! Both upgrades are small, clear jobs and I can turn them around in 2 days. Here's what you'll get: - IF and SUMIF formulas that replace the manual totals and flags, built to keep working when rows are added or re-sorted - A one-click button that exports only your print area to PDF, with your page setup untouched - Works on Office 365 for Windows with no add-ins - Short notes showing where each formula sits and how to run the export Send me the sample file and I'll confirm the exact hours before I start, so there are no surprises. One question: should the PDF save to a fixed folder, or ask you where to save each time? Brandon
₹220 INR in 2 days
0.0
0.0

Kunnapatt, India
Member since Jul 2, 2026
₹600-1500 INR
£10-15 GBP / hour
$750-1500 USD
$30-250 USD
€100-500 EUR
$15-25 USD / hour
$10-16 USD / hour
$10-30 USD
₹750-1250 INR / hour
₹600-800 INR
$250-750 AUD
$28-92 USD / hour
₹750-1250 INR / hour
₹1500-12500 INR
€12-18 EUR / hour
₹750-1250 INR / hour
₹12500-37500 INR
$25-30 USD / hour
$20-100 USD / hour
$250-750 USD