Excel Data Entry & Management -- 2
$250-750 USD
Posted 1 minute ago
•
Ends in 6 days
$250-750 USD
Paid on delivery
I have several Excel workbooks that hold my financial and accounting records, but months of ad-hoc edits have left them cluttered and unreliable. I need you to turn this into a clean, trustworthy data source I can analyse with confidence. The core of the job is to identify and remove every duplicate or incomplete line, standardise all names, dates, and address fields to a single clear format, then sort, filter, and group the information into well-defined columns. Along the way, please correct any broken formulas or obvious formatting errors you encounter so the file is ready for future dashboards and reporting. I will provide the current spreadsheets and let you know the conventions I want followed for dates, currency, and naming. Once the file is returned, I should be able to run simple pivots or charts without hitting errors, and a quick scan should show consistent formatting throughout.
Project ID: 40820499
About the project
6 proposals
Open for bidding
Remote project
Active 4 secs ago
Place your bid
Bid amount Email addressBenefits of bidding on Freelancer
Set your budget and timeframe
It's free to sign up and bid on jobs
6 freelancers are bidding on average $293 USD for this job


HELLO, "Excel Data Entry & Management" - unreliable financial workbooks need clean, consistent data that can be trusted for reporting. I'll review each workbook, identify duplicates and incomplete records, standardise names, dates and addresses, then organise the data into consistent columns and correct broken formulas and formatting issues. I'll preserve the original files and flag ambiguous records rather than deleting potentially valid financial information. The final workbooks will be structured for reliable filtering, pivot tables and charts. Do you want questionable or incomplete entries flagged in a separate sheet before any records are removed? I appreciate your consideration and look forward to working with you. THANKS


Hello, I can clean your financial and accounting Excel workbooks by removing duplicates, standardising date and currency fields, and fixing broken formulas so pivot tables and charts run without errors. I will work through each workbook to align naming conventions, fill or flag incomplete rows, and structure columns consistently, so the files are ready for dashboards once returned to you. You can see my profile here: https://www.freelancer.com/u/wasimameen What date format and currency convention do you want applied across the workbooks? Wasim Ameen


Each Excel workbook is cleaned in a copy. Every removed duplicate or incomplete line is logged on a separate sheet, so nothing disappears unseen. The 375 USD covers the workbooks you described: removing duplicates, putting names, dates and addresses into one format, grouping the data into clear columns, and fixing formulas. The first milestone is 75 USD for one workbook cleaned to your conventions, plus its removal log. It passes when a pivot and a chart run on it without errors and the formatting looks consistent on a quick scan. The remaining 300 USD covers the other workbooks in later milestones, after you accept that checkpoint. Two rounds of revisions are included. Formulas are fixed and kept as formulas rather than pasted as values, so future dashboards still recalculate. To start, please send the current spreadsheets and your conventions for dates, currency and naming. Price: 375 USD fixed · Timeline: 8 working days from access/brief Konrad


Months of ad-hoc edits have left your accounting workbooks with duplicates, gaps and broken formulas, so you can't rely on the numbers. I would first make a copy of every file and list what is wrong in each: duplicate or incomplete rows, mixed date and currency formats, inconsistent names and addresses, formulas that return errors. Then I clean the data in Excel, using Python with pandas for the bulk deduplication and standardisation, apply your conventions for dates, currency and naming, and fix or rebuild the broken formulas. You get the cleaned workbooks as one consistent table with clearly named columns, plus a short change log of what was removed or corrected, and I test that pivots and charts run without errors. I am based in Frankfurt, Germany, and have worked on cleaning and processing data since 2014 as a PhD researcher (30+ publications). Before you award the project, I can clean the first 20 rows of one sheet for free so you can check the result. How many workbooks are there, and roughly how many rows does the largest one have? Wahed


Cleaning up your financial workbooks would start with a row-level audit: duplicates, incomplete lines, broken formulas and mixed formats get logged, so you can see exactly what changes before anything is deleted. I would load each workbook with Python (pandas and openpyxl), check for exact and near duplicates such as the same entry with different spacing or capitalisation, and flag rows that are missing key fields. Then I would apply your conventions for names, dates, currency and addresses. Dates stored as text in mixed formats like 03/04 versus 4-Mar get converted to real Excel dates, or pivots will break. Broken references and #REF! formulas are fixed in Excel directly. Roughly how many workbooks and rows are involved? You would get one workbook cleaned first, with a change log and a test pivot, to check before I do the rest.


hi, i can clean and organize your financial and accounting excel workbooks into accurate, reliable files ready for analysis ✓ identify duplicates and incomplete records, keeping a backup before cleanup ✓ standardize names, dates, addresses and currency formats ✓ organize data into consistent columns with proper sorting and filtering ✓ fix broken formulas and formatting errors ✓ validate the cleaned data so pivot tables and charts work correctly ✓ deliver organized excel files ready for future reporting i can start immediately and complete the cleanup with careful accuracy checks
内容来自 Freelancer News,版权归原作者所有。
阅读原文 ↗