Macros de Excel Jobs

I have between three and five Excel sheets filled with text-only entries that need a straightforward cleanup: every duplicate row must go. No reformatting, no case-standardisation—just accurate deduplication while preserving the original column structure and any unique records exactly as they are. Please work directly in Excel (XLSX) or Google Sheets if you prefer, but be sure the final delivery arrives as XLSX files, one per sheet, with a brief note summarising how many duplicates were found and removed from each.

I have a series of company Cash Flow Statements spanning multiple periods and I need a clear, professional trend analysis completed in Excel. Your task is to organise the data, build the necessary formulas, and present the underlying trends so I can quickly spot shifts in operating, investing, and financing activities. I’m happy for you to use any Excel features that make the findings easy to read—pivot tables, dynamic charts, conditional formatting, or dashboards—so long as the final workbook is clean, well-documented, and ready for decision-making. Please focus your application on your experience performing similar cash-flow or broader financial trend analyses in Excel. I’m particularly interested in hearing how you have transformed raw statements into actionabl...

I’m holding 125 detailed 2024 bills, each already in Excel. What I need is a tidy, analysis-ready workbook rather than a pile of mismatched sheets. Here’s the flow I have in mind. First, standardise column headers and data formats so every bill follows one structure. Then assign two layers of organisation: a broad “bill type” category and, within that, clear tags for the exact Date, Amount, and Vendor/Issuer. Where data is missing or inconsistent, flag it visibly so I can verify later. Once everything is categorised, build a master summary sheet that pulls the key figures at a glance—totals by type, high-value items, and any other insights you think would speed month-end checks. A dashboard, pivot table, or slicer setup is welcome if it keeps the file li...

I have a series of documents that need to be turned into clean, well-structured Excel workbooks. The work starts with straightforward typing and transcription—moving the raw information from handwritten notes and PDFs into rows and columns. Once everything is in place, I also want the sheets organized, the right formulas inserted for quick calculations, and a light layer of analysis added so I can spot trends instantly. You’ll be working only in Excel spreadsheets, so deep familiarity with its data entry shortcuts, formula building, and basic visualization tools (think PivotTables, charts, conditional formatting) is critical. Accuracy is more important than speed, but I’m looking for someone who can deliver both. Deliverables I expect: • A fully populated Excel fil...

I have an Excel workbook containing sales data that I need to plug straight into my reporting dashboards, but the file is full of formatting inconsistencies. Your job is to go through every sheet and standardise two things: • Dates – everything must follow a single, clearly documented format across the entire file (e.g. YYYY-MM-DD). • Currency values – all monetary figures need to display as the same currency symbol, use consistent thousand-separator rules, and carry two decimal places. There are no duplicate-removal or missing-value exercises this time; the sole focus is on making the file presentation-ready. I’ll supply the spreadsheet and my preferred final styles. Once you’re done I want the cleaned .xlsx plus a short changelog so I can see exactly...

I have a growing list of customer information that now lives in several scattered files. I need it consolidated into a single, well-structured Excel workbook that is easy to update and filter when new records come in. The job centres on two data sets: contact information (names, emails, phone numbers, addresses) and each customer’s purchase history (order dates, items, quantities, amounts). Once everything is merged, I’d like clear column headings, consistent formats, basic data-validation rules, and a few summary views—simple pivot tables or filtered views are plenty—to give me quick insights without extra clicks. Please show me examples of past work where you cleaned or organised similar customer data in Excel so I can see your approach to structure and clarity....

I have all of my raw sales data stored in Excel workbooks and I want a single, interactive dashboard that instantly tells me how the business is performing. The dashboard must focus on three core metrics and update automatically whenever I drop new data into the same folder or worksheet: • Total sales volume • Sales by region (with an easy way to switch between regions) • Sales growth over time You are free to use PivotTables, Power Query, slicers, dynamic charts, or any Excel-native feature that keeps everything contained in one file—no external add-ins, please. Clean layout, clear labelling, and colour-coded visuals are important because this will be shared with non-technical colleagues. Deliverables • A finished .xlsx file with the dashboard on a ded...

I have an Excel file laid out in a straightforward table and I need fresh rows entered accurately from source material I will provide. No formulas or links are involved—just clean, consistent data entry that respects the existing headings and cell formats so the sheet remains ready for downstream use. At the same time, I have a companion PDF that requires a round of corrections. The exact mix of text edits, layout touch-ups, or image swaps will be shared once you’re onboard; the goal is a polished, print-ready document that matches the updated spreadsheet content. Deliverables • Updated Excel workbook with all new data correctly placed • Final, corrected PDF returned in the same page order and resolution as the original Send back both files error-free and nam...

I have between 50 and 100 documents that contain a mix of text and numeric values. I will supply these files, and I need every piece of information transferred into a single, well-structured Excel workbook. Your job is to: • copy the data from the documents into Excel, • clean and format each column so everything is consistently typed, capitalised and aligned, • insert basic formulas where totals or averages are required, and • rearrange rows or columns whenever it improves clarity. Accuracy is critical—every figure must match the source, and the sheet should be free of duplicates, blank rows and stray characters. The final workbook should be ready for analysis the moment I receive it. Please let me know your best price and how quickly you can turn th...

I receive a raw Excel export straight from our database and need it turned into a clean, analysis-ready workbook. Every record is already there, but column widths, dates, numbers and text fields arrive in mixed formats, making the file hard to read or filter. The main requirement is to clean up the Excel conditional formatting, remove any incorrect or unnecessary formatting, and make the formatting consistent and organized. The freelancer can use the existing Excel file as the reference. Your task is to bring order to the chaos: • Verify the download imported correctly—no cut-off text, misaligned columns or hidden characters. • Apply smart conditional formatting rules that instantly flag duplicates, outliers or empty cells and add subtle banding for readability. &bull...

I have a financial report drafted in Microsoft Excel that needs a careful editorial pass. Your task is to review every worksheet for numerical accuracy, consistent formatting, clear labeling, and correct formulas, then polish the wording so the final document reads professionally and is ready for stakeholder review. I’m looking for a mid-level editor with solid accounting knowledge and strong command of Microsoft Excel features such as conditional formatting, pivot tables, and data validation. If you’re comfortable checking totals, tracing formulas, and tightening explanatory notes, you’ll fit right in. When you apply, focus on relevant experience—tell me about similar financial reports or spreadsheets you have edited and the impact your changes made. No lengthy p...

I have between two and five Excel workbooks that must be publication-ready for our upcoming reports. Before I can plug them into the dashboards, each sheet needs a precise clean-up: • Remove every duplicate entry while keeping the first accurate record. • Detect, fill, or clearly flag missing values so no blank cells slip into the final figures. • Standardise formatting—dates, currency, percentages, text casing, column names, and number precision—so each file follows the same structure. I’ll provide the original files plus a short data dictionary. Please return: 1. A cleaned version of every workbook, keeping original file names with “_clean” appended. 2. A concise change log (Excel sheet or CSV) that notes what was removed, filled, or ...

Project Overview: Interactive Coffee Sales Analysis & Dashboard (Excel) In this project, I transformed raw sales data into an interactive, insight-driven Excel Dashboard to analyze retail coffee shop performance and optimize business decision-making. Key Steps & Methodology: Data Structuring & Cleaning (Transactions Sheet): Processed detailed transaction records containing transaction ID, timestamp, store location, product categories, quantities sold, unit prices, and product specifics. Data Aggregation & Analysis (Analysis & Pivot Table Sheets): Built dynamic Pivot Tables to summarize high-level Key Performance Indicators (KPIs), including: Total Orders & Quantities Sold Total Revenue & Total Costs Net Profit & Profit Margins (%) Segmented metrics b...

I need you to complete the attached Excel file **“APF – Organisation Data Sheet FY 2026–27”** for organisation. Your responsibility is to complete the entire workbook accurately and make it **submission-ready**. Please do not just enter whatever information is readily available—review the instructions in the workbook, identify the information/documents required, collect the missing details from the organisation's records, and complete all applicable sections. ### Scope of Work Please review and complete the following tabs: 1. **Org Profile & Documents** * Verify and complete the organisation profile. * Complete all required organisation details. * Review the complete list of required documents. * Mark whether each document has been up...

I have several Excel workbooks that contain customer records and I’ve noticed the same phone numbers appearing more than once. Your task is straightforward: scan every sheet, spot rows that share an identical phone number, and give me back a version of each file where those duplicates are either eliminated or clearly flagged on a separate tab—whichever you find cleaner to implement. I do not need help with missing values or formatting issues right now; the focus is solely on duplicate detection. Excel-native solutions such as advanced filters, Power Query, or a short VBA routine are all acceptable, as long as the final files open without macros blocked warnings and every surviving record is unique by phone number. Please provide the cleaned Excel files plus a brief summary of...

Project overview • Need an Excel-based system for a small vehicle finance office (4‑wheelers and 3‑wheelers). • Objective: move from handwritten registers to a single Excel workbook that tracks all agreements, instalments and reminders with minimal manual work.[freelancer +3] --- Core requirements • Create a Master “Agreement” sheet (one row per agreement) with: • Hirer details (name, address, mobile). • Guarantor details (name, mobile). • Vehicle details (type, make, model, year, regn no, engine no, chassis no). • Finance details (loan/finance amount, total amount to recover, number of instalments, instalment amount, first due date, frequency). • Create an Installments / Dump sheet (one row per instalment) that can be auto‑generated from...

My main Excel workbook refuses to load correctly. The moment I try to open it, Excel throws the warning: “Excel cannot open the file because the file format or file extension is not valid.” If I continue, the file does open, yet every sheet is visibly corrupted—numbers, formulas and formatting are all unreadable. The goal is simple: restore this file so it opens in modern Microsoft 365 without errors and displays its original data, formulas, charts and pivots intact. You may rely on any recovery approach—built-in repair, VBA, third-party tools, hex or binary editing, even temporary conversion through LibreOffice—as long as the outcome meets the criteria below. Acceptance criteria • A clean .xlsx that opens with zero error prompts • Origina...

I have several digital files—mostly PDFs and Word documents—that contain a mix of numbers and text. I need everything transferred accurately into Excel and organised as clean, structured tables. Each table must have clear, consistent headers so the sheet is ready for sorting, filtering, and further analysis the moment you hand it back. Please keep cell formatting tidy, use native Excel tables (so the headers stay locked in place), and double-check that every numeric figure and text entry matches the source. Deliverables: • One Excel workbook with separate, well-named sheets for each source file • All data entered in official Excel table format, with headers applied • Quick rundown of any data you could not decipher or confirm If you’re comfortable w...

I have a set of raw information that must be transferred into a neatly organised Excel spreadsheet. Your role is purely data entry: copy the figures, text, and any other details I supply and position them in the exact columns and rows I specify, applying consistent formatting along the way. Accuracy is the priority. I will spot-check the finished file, so every value should match the original source without typos, skipped lines, or misplaced decimals. Basic Excel tools such as Find & Replace, Data Validation, and simple formulas are welcome if they help keep the sheet tidy and error-free. Deliverables • One fully populated, well-formatted Excel workbook • All required fields completed and aligned with my heading structure • Turnaround time: 7 days from project star...

I have an existing Excel workbook that needs a thorough clean-up and a touch of professional polish. Your job is to: • remove any stray characters or spacing issues, • apply a single, consistent font style across every sheet, • set up the formulas and functions that will automate all current manual calculations (SUM, VLOOKUP/XLOOKUP, IF statements, or whatever is most efficient for the data on hand). When you return the file, every cell should calculate correctly without error messages, and the entire workbook should look cohesive at a glance. Please tell me about projects where you have performed similar Excel data cleaning or formula-building work. A quick note on the challenges you solved and the tools or functions you relied on will help me pick the right fit.

I have several digital files—mostly PDFs and Word documents—that contain a mix of numbers and text. I need everything transferred accurately into Excel and organised as clean, structured tables. Each table must have clear, consistent headers so the sheet is ready for sorting, filtering, and further analysis the moment you hand it back. Please keep cell formatting tidy, use native Excel tables (so the headers stay locked in place), and double-check that every numeric figure and text entry matches the source. Deliverables: • One Excel workbook with separate, well-named sheets for each source file • All data entered in official Excel table format, with headers applied • Quick rundown of any data you could not decipher or confirm If you’re comfortable w...

I have several raw data files that need to be transferred into a single, well-organised Excel workbook. Your first step will be to enter the information accurately, align the columns to a consistent structure, and label every header clearly so future updates are straightforward. Once the data is in place, I’d like the sheet to look clean and professional. That means readable fonts, sensible column widths, and colour or conditional cues wherever they make the numbers easier to scan. If you see opportunities to introduce simple formulas, named ranges, or validation rules that prevent typing errors, feel free to suggest them—I’m interested in anything that keeps the file tidy and reduces manual rework. Deliverables • A fully populated, logically structured Excel workb...

I have several Excel workbooks that hold our recent revenue figures, and they now need to be keyed into the company’s budgeting platform. Every row must be transferred exactly as it appears, with dates, account codes and memo fields kept intact so the totals reconcile perfectly on my side. You will receive: • Clean, well-labeled Excel files containing all revenue data. • Field-by-field instructions for the target entry screens plus a sample completed record. Deliverables: • All revenue lines entered in the platform, preserving original formatting and descriptions. • A completion log noting any anomalies you spot (duplicate entries, missing periods, unusual values). • Final confirmation that platform totals match the source spreadsheet totals. Acceptanc...

I keep a growing list of clients and need every record kept accurate and tidy in a single Excel workbook. You will manually browse the specified website, copy each client’s number along with all available contact information, and paste that data into the matching columns of the sheet I provide. Accuracy is more important than speed because this is strictly a manual data-entry task—no scraping tools or APIs this time. I will supply the site link, the template Excel file, and a short set of naming conventions so everything stays uniform. As new names appear online, you will add them; if any entry changes, you will update it rather than duplicating. Deliverables • Updated Excel workbook containing every client number and complete contact details, checked for duplicates ...

I will supply a series of text documents that contain raw information we need organised and lightly manipulated. The task is entirely manual—no scraping tools or automated scripts—so accuracy and careful attention to detail are essential. Your job is to read each file, enter every data point into the correct columns of a master Excel spreadsheet, and carry out straightforward clean-ups such as standardising dates, fixing obvious typos, and trimming extra spaces. Deliverables: • A single, well-structured Excel workbook containing all records from the provided text files • Consistent formatting across columns (dates, numbers, text case) • A brief log noting any ambiguities or source issues you encountered I’ll provide the documents in batches and will...

I need all of my current figures ­– income and expenses, individual departmental budgets, and several project-level budgets – transferred into a single, well-organised Excel workbook. The source data is already collected; what’s missing is a clean, accurate entry and a structure that makes analysis easy. I’m undecided on the exact template, so I’d like you to weigh in. If an existing industry-standard layout suits the data, great; if a custom sheet with dynamic formulas, drop-downs and clear categorisation would work better, let’s build that instead. Either way, totals must reconcile, categories need to be intuitive, and the file should be ready for monthly updates without breaking any links or formulas. Deliverables: • An Excel file contain...

I have a set of operational-expense figures already captured in an Excel spreadsheet that now need to be transferred into my master budget-tracking file with complete accuracy. The task is straightforward: take each row from the source sheet, verify the numbers, and enter them into the appropriate cost centres and period columns in the destination workbook. Because these are purely operating costs, I need the chart-of-accounts coding kept intact so our month-end reporting flows without manual fixes. Consistency in date formats, currency symbols, and decimal precision is critical; a single misplaced digit throws the whole variance analysis off. You’ll receive: • The source Excel file with all original entries. • A blank copy of the budget template that mirrors our ac...

I have a spreadsheet that needs careful data entry and precise formatting. The source material combines text and numerical values; I will send everything in a single file so you can work directly in Microsoft Excel (or Google Sheets if you prefer). Here is what I expect: • Enter all records accurately, matching my source order. • Apply the custom font styles I specify to every text field—headings, labels, and any descriptive columns. • Format every numerical column in clean, consistent decimal format, so totals and averages display correctly without rounding surprises. When the job is done I should be able to open the workbook and immediately print or share it with no extra tweaks required. If something in the source file looks ambiguous, please flag it; da...

I have a PDF made up exclusively of neatly structured tables and I need every row and column moved into Excel with absolute fidelity. Because the table layout never changes from page to page, the job is straightforward in terms of mapping—but the resulting workbook must be more than a copy-and-paste. Key requirements • Each PDF table goes into its own worksheet, preserving original column order and headings. • Apply clear data-validation rules (e.g., drop-downs where the source file shows fixed choices, numeric limits for quantity fields, and date pickers for any date columns). • Match source formatting: header shading, bold totals, and any merged cells that exist in the PDF. • Final file must open error-free in the current versions of Excel for both Wi...

I have a sizeable Excel spreadsheet filled with mixed text and numeric fields that now needs a thorough clean-up before it can be analysed with confidence. The work involves removing duplicates, correcting obvious entry errors, standardising formats (dates, currencies, phone numbers), and applying clear filters so the file can be sliced and queried without glitches. Once everything is tidy I’d also like a brief sanity-check analysis—pivot tables or simple summaries are fine—so we can confirm the dataset’s integrity. Deliverables • A fully cleaned, consistently formatted .xlsx file with working filters • A short change log or note that flags the main issues you fixed and any assumptions you made • A quick analytical snapshot (pivot tables or sim...

I need an Excel workbook that lets my team enter sales figures through a user-friendly form and, with one click, posts each record into a master sheet. The whole point is to make data collection painless and consistent so I can move straight into analysing sales performance later. Data validation is non-negotiable. The form must stop typos and out-of-range numbers, force date entries to the current financial year, and offer drop-downs for product SKUs and sales reps. Whether you prefer VBA, Office Scripts, or Power Automate is up to you—as long as the solution runs inside Microsoft 365 on both desktop and (ideally) the web. Deliverables • Excel workbook with built-in form and automated submission • All validation rules implemented and tested against sample sales data ...

I have an existing Excel-based form that needs to run itself instead of relying on manual copy-and-paste. The form captures three kinds of input—free-text notes, numeric values (including dates or currency), and predefined multiple-choice selections—and all of them must be validated the moment a user types or picks an option. Once a user presses “Submit”, I want the sheet to carry out three things automatically: 1. Check every field against built-in validation rules (no missing mandatory items, correct number formats, valid choices). 2. Auto-populate any look-ups or calculated fields so the person filling the form never sees #N/A or has to open another tab. 3. Push a clean, single-row record straight into an external database table (SQL Server is preferred, ...

I need my backlog of mixed text and numeric information consolidated into a single, tidy Excel workbook for ongoing record keeping. All data must live in a structured table—each row a record, each column clearly labelled—with filters and freeze panes enabled so I can quickly search, sort and update. Here’s the work at hand: • Import or copy the source files I’ll supply, standardising dates, currencies and other numeric fields. • Apply a clean table style and header hierarchy, then auto-size columns. • Build drop-down lists for key categorical fields and add light data-validation rules to prevent entry errors. • De-duplicate, spot-check against the originals and confirm that subtotals match. Deliverable: • One .xlsx file, fully format...

I manage a growing rent roll and handle lease renewals outside of PropertyMe, relying instead on a series of linked Excel spreadsheets. What I need is a detail-minded virtual assistant who can step in and keep those sheets current, ensuring every lease agreement is updated promptly and every upcoming expiration is flagged before it becomes urgent. Your core focus will be twofold: first, update lease agreements as soon as new terms are approved; second, monitor the expiration tracker so I receive a concise daily report highlighting leases that are approaching renewal. Because everything feeds into the same workbook, accuracy in data entry and version control is critical. You’ll have secure access to the existing files in OneDrive along with a brief walkthrough video of my workflow s...

I track all of my transactions in a single Excel workbook and need those figures transferred every day into a clean, well-organised register. Each entry must be sorted into clear income and expense columns and then tagged under one of my three standing categories: • Salary • Investments • Savings For every daily batch you receive, please: – enter each line exactly as it appears, preserving dates, amounts, and any notes – assign the correct category so I can filter totals instantly – double-check your work for typing or placement errors before saving Deliverables are simply the updated file returned to me by the end of each day, ready for the next morning’s review. Consistency and accuracy matter more than speed, but I still expect a re...

I have multiple Excel workbooks that hold our organisation’s budget reports and I need every line of that financial data re-entered with perfect accuracy. Your task is to take each source sheet, capture every figure and description exactly as it appears, and place it into a single, clean master file that I will supply. Because these are budget reports, totals must reconcile once your entry is complete; I will be cross-checking formulas, so attention to detail is critical. No formatting surprises—I want consistent column order, date formats, and currency symbols throughout. Deliverable acceptance will be based on: • 100 % of rows present with no transcription errors • Column headings and cell formats matching the template I provide • Final file returne...

I have multiple Excel workbooks that hold our organisation’s budget reports and I need every line of that financial data re-entered with perfect accuracy. Your task is to take each source sheet, capture every figure and description exactly as it appears, and place it into a single, clean master file that I will supply. Because these are budget reports, totals must reconcile once your entry is complete; I will be cross-checking formulas, so attention to detail is critical. No formatting surprises—I want consistent column order, date formats, and currency symbols throughout. Deliverable acceptance will be based on: • 100 % of rows present with no transcription errors • Column headings and cell formats matching the template I provide • Final file returne...

I have several Excel sheets that track investment-return figures and I need every line copied into a clean, consolidated master file. All source material is already typed, so you will not be deciphering handwriting—just transferring figures with perfect accuracy. Your job is straightforward: • Open each provided workbook. • Verify totals and date formats match the original. • Enter the data into the template I supply, keeping column order and decimal precision intact. I will spot-check random rows against the originals; any mismatch beyond 0.1 % will be sent back for correction. The finished spreadsheet should be ready for pivot-table analysis with no blank cells, formula errors, or stray characters.

I need an Excel specialist to transform a raw data workbook into a polished, refresh-ready report. The core of the task is wiring together several data sheets with VLOOKUP and HLOOKUP, then driving a clear summary through Pivot Tables. Whether the final view ends up looking like a sales, financial, or inventory snapshot, the goal is the same: a concise report I can regenerate each time I paste in new data. What I will give you: • A multi-tab .xlsx file containing the source data. • A rough sketch of the information the finished report should display. What I expect back: • Clean, well-labeled VLOOKUP and HLOOKUP formulas that pull the right fields every time. • One or more Pivot Tables structured so the summary sheet instantly updates on refresh. • A short, plain-...

I’ll provide my current data-entry sheet along with batches of mixed information—text strings, numbers, and date/time values—that must be keyed in accurately and then rigorously checked. Your job is to populate every field, apply sensible validation rules (duplicate checks, format constraints, basic range logic), and hand back a clean workbook that’s ready for downstream analysis. The workbook should open with no warnings, columns must retain their intended data types, and any discrepancies you find should be flagged on a separate tab with a brief note. When you return the file I will spot-check several records, so accuracy has to be 100 %. If this first round goes smoothly there’s more data waiting in the queue, so a quick turnaround and clear communication ...

SSC/RRB/Agniveer Recent PYQ Papers (2025 & 2026) Needed in Excel with Explanations – English & Hindi I need a freelancer to compile **recent Previous Year Question (PYQ) papers** of various government exams into Excel format (soft copy), with detailed explanations for each MCQ. **Exams required:** - SSC MTS - SSC CHSL - SSC GD Constable - SSC CGL - SSC CPO - RRB (Railway) - Agniveer (Army/Navy/Air Force) - Other Central Government exams **Year range:** 2025 and 2026 papers only (most recent) **Requirements:** - Extract papers from **official PDF question papers** released by respective boards, OR from a **good/reputed publication's PYQ book**, shift-wise (since exams like MTS run in multiple shifts per day) - Please mention which **source/reference** you will use fo...

I receive a fresh Excel workbook every week containing the latest investment-returns figures for multiple portfolios, and I need those numbers keyed into our master tracking file with absolute accuracy. Here’s what the job involves: • Open the weekly Excel sheets I supply and enter each data point into the corresponding tabs of my master spreadsheet. • Double-check totals, percentages and date alignment so the values match the source file exactly—no rounding errors or skipped rows. • Save and return the updated master file to me by the agreed weekly cutoff, ready for further analysis. You may use any Excel-friendly workflow that keeps the file structure intact—macros, Power Query, or plain data entry are all fine as long as the final sheet mirrors the sou...

I need assistance with two Excel files located on SharePoint. One file needs to be readied, and the other needs to be updated based on key columns. Requirements: - Read and prepare one Excel file. - Update 'Amount' column in the second Excel file based on matching 'WBS' key column. - Both files contain financial data. Ideal Skills and Experience: - Proficiency in Excel, especially with handling financial data. - Experience working with SharePoint. - Attention to detail and accuracy in data handling. - Ability to complete tasks efficiently and within the budget.

I have an Excel workbook that lists individual investment transactions. I need every transaction date and the corresponding amount keyed accurately into our internal tracking system (a simple web form I will provide access to once we start). The descriptions column is already in place, so you can ignore that—your focus is strictly on dates and amounts. Accuracy is more important than speed: totals must reconcile with the Excel sheet, and the date format must follow the exact DD-MM-YYYY structure used in the file. After completion, I’ll run a cross-check against the spreadsheet; entries must match 100% for the project to be accepted. Deliverable • All transaction dates and amounts entered and saved in the system, verified against the source Excel sheet. If you have sol...

I need my current catalogue and separate pricing sheet merged into a single Excel workbook that clearly lists every hand tool, power tool, and abrasive I sell. Each product line must include an active hyperlink—either to its dedicated web page or to the exact page in the PDF catalogue—so customers can jump straight to full specs in one click. Please structure the file so it is easy to filter or sort by SKU, description, and price, and keep the design clean enough for immediate client distribution. Because I’m working against the clock, I’d like the finished, error-free file delivered as soon as possible, along with any source formulas or macros you use so I can update prices myself later.

I need an Excel workbook to track key performance indicators (KPIs) related to financial performance and operational efficiency. The workbook should include: Financial Performance KPIs: - Revenue - Profit Margins Operational Efficiency KPIs: - Production Rates Ideal Skills and Experience: - Proficiency in Excel, including advanced functions and data visualization tools - Experience in financial analysis and KPI development - Ability to create user-friendly, automated dashboards for real-time tracking Please provide samples of similar work done.