Visual Basic Jobs

मेरे पास एक शॉर्ट फ़िल्म की रॉ फुटेज तैयार है, मुझे इसे आकर्षक और सिनेमाई अंदाज़ में एडिट करवाना है। मुख्य रूप से मैं निम्न फ़ीचर्स शामिल करना चाहता हूँ: • Background music   • Text overlays (टाइटल व क्रेडिट्स सहित) • Smooth transitions हर सीक्वेंस के बीच मैं अपेक्षा करता हूँ कि एडिटर कलर करेक्शन, बेसिक साउंड मिक्सिंग और अंतिम एक्सपोर्ट (Full HD MP4) तक पूरी प्रक्रिया सँभाले। मैं आपको: – सभी रॉ क्लिप्स – म्यूज़िक ट्रैक्स और लोगो फाइलें – एक बेसिक एडिट स्क्रिप्ट/शॉट लिस्ट प्रदान करूँगा। मुझे आपसे: – फाइनल कट (rendered) – एडिटिंग प्रोजेक्ट फ़ाइल (Premiere Pro या आपकी प्रयुक्त सॉफ़्टवेयर फ़ाइल) – छोटे बदलावों के लिए सीमित रिविज़न की आवश्यकता होगी। यदि आपका पोर्टफोलियो शॉर्ट फ़िल्मों या यूट्यूब स्टाइल कहानिय...

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 am starting a multi-stage automation project and the very first milestone is to take the daily flood of Outlook messages off my plate. Here’s what I need right now: every new email that lands in my main Outlook inbox must be read automatically, identified as either a “request for quote” or “other enquiry”, stored neatly in an Excel file, and answered with a short receipt confirmation. In practical terms this means: • Outlook is the mailbox you will connect to. • The sorting logic must recognise “requests for quotes” as the top priority; everything else falls into a second bucket labelled “other enquiries”. • Each recognised enquiry adds (at minimum) Name, Email, Phone, Company, Subject, and Date into separate Exc...

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 ...

The goal is to turn raw accounting exports into a clear Management Information System inside Microsoft Excel. The workbook must display financial data only, with live views on Revenue & Expenses, Profit Margins, and Cash Flow. I will supply the source files (CSV and XLSX). Your job is to design the data model, automate the refresh, and present the numbers through clean charts, pivot tables, slicers, and conditional formatting so that anyone on the team can spot trends in seconds. Power Query or VBA is welcome if they simplify the workflow, but the final file has to stay fully portable in standard desktop Excel. Deliverables • One .xlsx file containing the dashboard and underlying data model • Simple “Data Refresh” button or documented refresh steps &bull...

I need a simple yet reliable Google Sheets setup for logging my daily income and expenses. The sheet must live online so I can update it from any device, and it has to perform automatic calculations without me touching a calculator. Core objectives • A clean, intuitive table where I enter the date, description, category, and the amount (positive for income, negative for expense). • Formulas that instantly tally daily totals, maintain a running balance, and roll up weekly and monthly summaries. • Separate summary view that shows total income, total expenses, and net balance at a glance. • Protection on formula cells so accidental edits don’t break the math. • Easy sharing permissions so I can add collaborators later. Acceptance will be based on the...

I’m looking for a clean, easy-to-use spreadsheet that lets me log dozens of orders across several vendors in one place. It must automatically add up quantities and costs as I enter line items, offer a dropdown menu so I can pick the vendor instead of typing it each time, and change colour or style the moment an order shifts from “Pending” to “Shipped”, “Back-ordered”, or any other status we define together. I don’t need a standalone app—Excel or Google Sheets is perfect as long as the file is ready to go the moment I open it. The layout should be flexible enough for future columns, yet locked where formulas live so nobody breaks them by accident. If you can include a quick instructions tab and a bit of sample data so I can see everythi...

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 have a collection of text-based records that need to be typed accurately into an Excel spreadsheet. Everything will be provided in clearly labelled source documents; your role is to enter each line exactly as written, keep the column order I supply, and run a quick spell-check before saving. I’m concentrating on manual data entry because I want a human eye on every detail rather than an automated import. Consistency in spacing, capitalization, and basic formatting is important, but no complex formulas or analysis are required—just clean, error-free text in the right cells. When the file is complete, return the finished workbook plus a brief note confirming the number of rows you entered and any obvious issues you spotted along the way. That’s all there is to it, and i...

CREATE A SEAMLESS INFINITE ZOOM CINEMATIC VIDEO IN VERTICAL 9:16 FORMAT. IMPORTANT CUSTOMIZATION: Before generating the video, use the following customizable variables. The user can change ONLY these variables according to their desired concept: [MAIN OBJECT / SUBJECT] = The main thing where the video starts. Examples: an eye, pencil, smartphone, watch, flower, car, book, coin, laptop, camera, building, painting, bottle, planet, or any other object. [ZOOM DETAIL] = A tiny visible detail inside or on the main object that the camera can zoom into. Examples: reflection, hole, texture, screen, lens, button, pattern, writing, crack, window, opening, surface detail, microscopic particle, or any visually interesting element. [SCENE THEME] = The overall visual theme of the worlds revealed duri...

I need a single, well-organised system that keeps every reinsurance policy I handle in one place, tells me instantly which market fits each risk, reminds me before anything falls due, and produces clear reports for management. Core workflow • Policy tracking: an easy data-entry form (policy number, cedant, premium, sum insured, occupancies, dates, notes) that saves into a searchable table. • Market insights: the moment I fill in premium, sum insured or occupancies, the tool should suggest the appropriate market automatically. • Reminder emails: automatic Outlook-ready messages for renewals, premium receipts or any custom date I define, with editable templates pulled straight from the record. • Reports: quick buttons to create production, renewal pipeline and ou...

I have a series of online databases that contain text-only records I need captured into a single Excel workbook. Your task is straightforward: pull each text entry, place it in the appropriate columns of the sheet I provide, and keep everything chronologically sorted so the final file reads from the earliest date to the most recent. Accuracy is critical. I rely on this spreadsheet for daily reporting, so every entry must match the source word-for-word, free of stray formatting, and dated correctly. Once all records are in place, a quick check with Excel’s sort feature should confirm the date order before delivery. Deliverables • Completed .xlsx file with every record from the assigned databases, sorted by date • A brief log noting any broken links or unreadable entrie...

I need a straightforward yet reliable task-tracking air table that lets me see, at a glance, where every assignment stands. The sheet must be designed specifically for task tracking (not full project management or a sales pipeline) and include the following built-in capabilities: • Due dates so I can sort and filter upcoming deadlines • Priority levels to flag what needs attention first • Progress tracking to show what’s in progress, blocked, or done I’m open to Google Sheets or Excel—whichever you feel will let you build these features quickly and keep maintenance simple. When you send your bid, please attach or link to a few examples of similar tracking sheets you’ve built in the past. Seeing your past work will help me gauge both layout cl...

I need every record from an online database—well over 200 pages in total—transferred into a clean, consistently formatted spreadsheet. The source is entirely online, so you will be copying or manually keying the information directly from the database interface into Excel (or Google Sheets if you prefer) without losing a single character or number. Accuracy is the priority: names, addresses, numerical values, dates and any free-text notes must match the original entries exactly. Please keep the column order I provide, flag any illegible or missing fields, and maintain the same spelling, punctuation and capitalisation you see in the source. Deliverable: a single .xlsx file ready for import into our internal system, accompanied by a short log of issues or clarifications. If...

I need help bringing an existing financial spreadsheet fully up to date. All raw figures are ready, but I’m short on time to transfer everything accurately. Your task is to enter the new financial data into the correct rows and columns, double-check totals against the source figures, adjust or insert formulas where needed, and leave clear notes for any anomalies you spot. The file is in Excel, so please be comfortable with basic functions such as SUM, IF and simple percentage calculations; no complex macro work is required. Once finished, I’d like the workbook returned error-free, neatly formatted, and ready for internal reporting.

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 have a batch of information that was originally keyed in from printed forms, but the digital file now needs a thorough refresh. Your job is to work directly in Excel, spotting and fixing any inconsistencies, removing duplicates, standardising dates and text fields, and making sure every record lines up with the source details on the forms. By the end I want a single, well-structured workbook that is ready for analysis—with clear tabs, tidy formatting, and zero errors. If you are comfortable auditing datasets, using functions like VLOOKUP/XLOOKUP, conditional formatting, and basic pivot tables for quick validation, this task should be straightforward. Please let me know how quickly you can turn around the cleaned file and any relevant experience you have with data quality proj...

I have several months of bank and credit-card statements in CSV/PDF format and I need every line item tagged to its correct merchant so I can finally see where the money is really going. Your task is pure transaction categorization—no forecasting, no fraud checks—just clean, accurate labeling that lets me track expenses at a glance. Here’s what I will pass over: the raw statements plus a small starter list of common vendors I already recognize. From there I’m expecting you to standardize merchant names, handle duplicates or misspellings, and return a file I can sort or pivot instantly. Excel, Google Sheets, Python, or any other tool you prefer is fine as long as the final output is a spreadsheet I can open without extra software. Deliverables • A fully cate...

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 ...

Right now, colleagues type a mix of numbers and text straight into our Excel template every time we receive a new submission. I want that manual step gone. The goal is a simple, bullet-proof automation—ideally a VBA macro, Power Automate flow, or an add-in—that takes incoming mixed data and drops each field into the correct cell or table row without human involvement. It must preserve all existing formulas and formatting in the workbook and work on current Microsoft 365 versions. Deliverables • A working automated solution (VBA file, flow, or equivalent) • Clear setup notes so I can deploy it on other machines • A quick demo file or screen-record showing it in action I’ll test by running the tool on sample data and confirming every value lands ...

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’m looking for someone who can take the source documents I send each day—receipts, invoices and bank statements—and record every income and expense line into my existing Excel (.xlsx) workbook. The file already has labeled tabs and basic formulas; your task is to key in the amounts, categories and notes, double-check totals and ensure each entry aligns with my chart of accounts. Because I rely on this spreadsheet for real-time cash-flow tracking, updates must be completed daily (including weekends). Accuracy and attention to detail are paramount, and you should already be comfortable with common Excel tools such as data validation, sorting/filtering and simple SUMIF or VLOOKUP checks to spot inconsistencies. At the end of each day I expect the workbook returned—o...

I have a collection of records that contain both text and numerical values. The job is straightforward: take the source material I’ll provide and key every field in exactly as it appears, checking that spelling, punctuation, and numbers are all correct and consistently formatted. I’ll supply clear column headings and a short set of validation rules so you always know where each piece of information belongs. Once the last record is entered, run a quick pass to flag any blanks or obvious mismatches and include that brief QC note with the final hand-off. You may work in Excel, CSV, or import-ready tables for a database; choose whichever environment you’re most efficient with and let me know up front so I can align my export. Accuracy is the top priority, but I also app...

Je souhaite centraliser et tenir à jour toutes les informations relatives à mes clients dans une feuille de calcul Excel ou Google Sheets. Votre mission : • Créer un fichier structuré avec des champs clairs (identité, coordonnées, historique d’achats, notes internes, etc.). • Importer ou saisir les données existantes, puis vérifier leur exactitude. • Mettre en place des filtres et une mise en forme simple pour faciliter la recherche et l’exploitation quotidienne. Je privilégie une approche propre et intuitive ; aucune automatisation avancée n’est exigée pour l’instant, mais la structure doit rester évolutive si je décide d’ajouter des graphiques...

I already have a fully-cleansed Excel workbook; each of its nine tabs contains the data plus mock-up charts that show exactly what I want. All that’s left is to bring this file into Looker Studio, connect it as the single data source, and reproduce those visuals inside a new interactive report. Please arrange the dashboard in a tabbed layout so every section mirrors its corresponding worksheet. No other sources are required, so you can focus on getting the charts (bar, line, pie, etc.) looking and calculating exactly like the samples. Apply the same colour palette, include the simple filters shown in the mock-ups, label each section clearly, and keep performance snappy. Deliverables • A Google Looker Studio report with nine labelled tabs that replicate the provided charts &b...

Voice Based Management System Background & Challenge: Have existing excel based activity tracker with macros to initiate emails to concerned person for assigning a task. This is limited to assigning a task via email and later manual update post follow-up with concerned executive is required. Advanced Requirement: Need to have a web-based portal with login access to Management as Executives for tracking activities across Projects including miscellaneous tasks. Task to be assigned & updated thru voice command by all users. Need to use AI tools to capture instructions, assign task, take inputs from Executives, update the activity, record & track the activity with interactive analytics. Requirement in brief: 1. The system can be web / mobile application based. 2. Need separate ...

I need a small utility or script that pulls our Sales data from a shared FileMaker Pro file and drops them straight into a pre-existing Excel workbook. The process has to run twice a day—once in the morning and againat 7pm—without anyone clicking a button. No data cleansing or re-formatting is required; I just want the exact export that FileMaker produces to appear in Excel, ready for further analysis. You’re free to choose the most reliable route—FileMaker Server schedules, an ODBC connection, a FileMaker script coupled with Power Automate, even a lightweight VBA or Python bridge—so long as it works unattended on Windows and can be quickly adjusted if the report layout changes. Deliverables: • A fully configured automation script or tool with clear, co...

I have a raw sales dataset that needs to be transformed into a polished, decision-ready Excel workbook. The job covers three core stages. 1. Data cleaning • Removing duplicates • Handling missing values • Correcting formatting issues 2. Data organisation After the clean-up, I need the information logically sorted and structured so filters, PivotTables, and formulas work seamlessly. 3. Visual insight Please build a set of bar charts, pie charts, and line graphs that look great on a PowerPoint slide and instantly convey the key trends. Use clear labelling, consistent colour palettes, and ensure the visuals update automatically if the data changes. Deliverable One .xlsx file containing the cleaned sales data on a dedicated sheet, an organised an...

I have a collection of records that contain both numbers and text and I need every line accurately transcribed into a single, well-structured Excel workbook. The information comes in various formats, so attention to detail is essential—you will often switch between numeric fields (such as quantities or ID codes) and descriptive text. All cells must be entered exactly as they appear, without altering spelling, punctuation, or numeric formatting. When a line includes multiple items, use separate columns that I will label for you before we begin. I will provide the raw files as soon as you are on board and will be available to answer any clarifying questions as you work. Deliverable • A clean .xlsx file with every record entered, double-checked for consistency (no blank row...

I need an organised freelancer to populate an Excel workbook with a batch of text records and apply my custom formatting rules as you go. This is strictly a data-entry task—no analysis or formulas required—yet accuracy is critical because every cell must follow the style I provide (headings in Title Case, specific column widths, wrapped text, and colour-coded status flags already embedded in the template). You will receive: • A blank template (.xlsx) that already contains the conditional-formatting rules. • A folder of raw text files to copy from. Your job is simply to: 1. transfer each text snippet to its correct column; 2. confirm the formatting renders exactly as in the sample row; 3. return the completed workbook for a quick spot-check. I’m ha...

I have a well-structured online database that I now need transferred into an Excel workbook. The records contain both numbers and text—think product IDs, prices, names, and short descriptions—so careful handling of mixed data types is important. Here’s what I’m expecting: • You’ll log into the database I provide and copy each record into the matching columns of my master spreadsheet. • Basic accuracy checks are a must: confirm totals, spot obvious typos, and flag any duplicate or missing entries you encounter. • Keep the file neatly formatted (dates as dates, currency as currency, text wrapped where necessary) so I can run pivots and filters without rework. The task is straightforward data entry, but precision matters. Let me know yo...

I have a set of digital PDFs containing between 100 – 500 customer contact records. Your task is to read each file and transfer every name, phone number, email address, and any listed company details into a single, well-structured Excel worksheet. Accuracy matters more than speed: spellings must follow the source exactly, phone numbers keep their original format, and every row in the sheet should represent one customer. Please work in Microsoft Excel (current version is fine) and keep the layout consistent across all entries. Deliverables • .xlsx workbook with all contacts neatly organised • Basic clean-up: remove duplicate rows and flag anything unreadable in a notes column I can review a small sample first so we’re sure the format is right before you move...

I update my product-sales workbook every evening, but the volume has grown past what I can comfortably handle alone. I’m looking for someone who can take over the daily Excel entry of all product sales that come through each day. The workflow is completely manual at the moment: I’ll send you the raw figures in a simple text or photo format, and you’ll record them in my existing Excel template. For every single sale you will capture the following: • Product name and quantity • Date and time of sale • Customer details Accuracy is more important than speed, yet I still need the file returned the same day so I can reconcile inventory and produce a quick report. If you already have solid Excel habits—data validation, consistent formatting, basic f...

I have a text-only PDF that needs to be transcribed into an Excel workbook. Every sentence from the original document should appear in its own row, keeping exactly the same formatting—bold, italic, underline, superscript, everything—so that the spreadsheet mirrors the visual emphasis of the source. Accuracy is critical: punctuation, line breaks inside sentences, and special characters must be identical to what you see in the PDF. Since the content is pure text, no table reconstruction or image handling is required; it is strictly a matter of lifting the sentences and placing them cleanly into Excel while preserving their styling. Deliverable • One .xlsx file with each sentence in a separate row, formatted precisely as in the PDF. I will run a side-by-side comparis...

I update my product-sales workbook every evening, but the volume has grown past what I can comfortably handle alone. I’m looking for someone who can take over the daily Excel entry of all product sales that come through each day. The workflow is completely manual at the moment: I’ll send you the raw figures in a simple text or photo format, and you’ll record them in my existing Excel template. For every single sale you will capture the following: • Product name and quantity • Date and time of sale • Customer details Accuracy is more important than speed, yet I still need the file returned the same day so I can reconcile inventory and produce a quick report. If you already have solid Excel habits—data validation, consistent formatting, basic f...

I have approximately 45 Excel files containing data from our old clients. I am looking for an experienced freelancer who can carefully review these files and make the required changes and updates as instructed. The work may include editing existing data, updating information, correcting entries, formatting, and making other necessary modifications while maintaining the original structure and accuracy of each Excel file. Requirements: Experience with Microsoft Excel and data management Ability to work with multiple Excel files Accurate and careful data entry/editing Maintain the existing formatting and structure where required Follow instructions precisely Keep all client data confidential Complete the work within the agreed deadline More detailed instructions and the required changes w...

I have several months of raw automotive service records that need to be transformed into reliable, presentation-ready workbooks. My immediate priority is accurate data entry and rigorous cleaning—specifically removing duplicates, correcting any formatting inconsistencies, and validating every key field for accuracy. Once the data set is trustworthy, I’ll also be moving on to the usual next steps of insightful formulas, Pivot Tables, and dashboards, so an eye for analysis will be valuable, even if the first milestone centres on cleanup. If you have worked with dealership or workshop data before, you’ll recognise the quirks these files can contain and the importance of precision when labour hours, parts numbers, and costs are involved. Experience with warranty claims or br...

The task is straightforward: take the content of a single PDF document—no more than ten pages—and convert it into a clean, well-structured Excel workbook. I will be using the spreadsheet purely for record-keeping, so accuracy matters more than speed. Every figure, label, and note that appears in the PDF must end up in the correct row and column, ready for easy lookup later. You are free to rely on Adobe Acrobat, OCR utilities, or any other tool that ensures faithful extraction, but the finished file must open flawlessly in modern versions of Microsoft Excel. Deliverables • One .xlsx file that mirrors the source data without omissions or transcription errors • Consistent column headers and cell formatting suitable for long-term archiving Before final hand-of...

I have a batch of mixed text-and-number records pulled from several online databases that must be transferred into a clean, well-structured Excel or Google Sheet. The job is straightforward but detail-oriented: copy each data point into the correct column, keep the formatting consistent, organise the rows logically, and run a basic duplicate check so the final file is error-free. You’ll work with data in CSV, PDF, Excel, or other common file formats that I will provide. Turnaround matters to me, so I’m looking for someone who can move quickly without sacrificing precision. Familiarity with Excel functions—especially sort, filter and conditional formatting—or the comparable features in Google Sheets will help you spot and resolve issues fast. If you notice obvious a...

I have an existing Excel workbook that currently relies on manual submissions. All the figures we need already live in a SQL Server database; they simply have to appear in the correct cells of the form and then trigger the usual calculations and formatting the sheet already performs. Here is what I need from you: connect Excel to SQL Server, pull the required numeric fields, map them to the form’s input range, and set the process to refresh on demand (button or scheduled refresh—whichever is cleaner). The workbook must stay fully functional for colleagues who are not technical, so the solution should run with a single click and require no additional installs beyond standard Office components. VBA, Power Query, or a lightweight Add-in are all acceptable, provided they are rel...

I have an Excel workbook that tracks every order moving through my shop. Each business day I will send you the raw updates, and I need those figures keyed straight into the correct rows and columns of that file so the status dashboard always shows the latest information. The sheet structure is locked in, formulas are already set, and I’ll share both the file and a short loom video that walks through the exact cells you’ll touch. Turnaround is same-day: once you receive the update, enter the data, double-check for obvious mistakes, save, and send the file back (or sync it to the shared folder) before close of business. Acceptance criteria • All new or changed values entered in the designated cells of the Excel workbook provided • No accidental edits to protected ...

I have a collection of Excel workbooks packed with numerical data that need a careful second look. The figures feed directly into monthly reports, so even small inaccuracies throw everything off. Your sole focus will be correcting errors—things like misplaced decimals, transposed digits, or totals that don’t reconcile with the underlying rows. Duplicates and formatting quirks can stay untouched for now; accuracy comes first. You’ll receive the original files plus a brief note on the most common slip-ups I’ve spotted. I’d like the revised worksheets returned along with a short log of every change you make so I can review the adjustments easily. When you respond, show me a sample of past work that proves you’ve hunted down and fixed numerical mistakes be...

We are expanding my operations team and need a full-time data entry clerk who can work remotely with very little hand-holding. Day to day you’ll be inside our customer account database keying in, verifying, and updating financial data that feeds directly into our reporting dashboards. Accuracy is critical; a single typo can throw off the month-end numbers, so I need someone who naturally double-checks their own work and spots inconsistencies quickly. Microsoft Excel will be your primary tool—everything from basic formatting to VLOOKUPs and pivot tables for cross-checks. If you already have at least two years of dedicated data entry experience and feel comfortable juggling multiple spreadsheets while meeting daily deadlines, you’ll fit right in. Beyond routine entry, I&r...

I have a set of Excel spreadsheets that contain only text fields needing orderly transfer into our central database. Every cell must be copied exactly as shown, preserving line breaks, punctuation, and any special characters. The files are already well-structured, so accuracy and speed are my priorities rather than complex formatting or formula work. You’ll receive the spreadsheets through a shared drive, and I’d like the completed dataset returned as a single, clean CSV file. A quick turnaround and zero‐error output will be the key markers of success.

I have a list of online sources that contain both narrative text and numeric figures, and I need every one of those details captured in a single, well-structured Excel workbook. The job begins with careful data entry: copy each text field, metric, date, or code exactly as it appears on the web page and paste (or import) it into the template I will provide. Because the information is mixed data—words and numbers side by side—consistent formatting, proper column alignment, and vigilant error-checking are essential. Once the raw information is entered, the spreadsheet has to become an analysis tool. Please set up the formulas that calculate totals, averages, and any other basic statistics we agree on, then create clear charts or graphs that visualise the key results. Think of it ...

I keep my sales records in a Microsoft Excel workbook and need someone reliable to add the day’s sales amount to the correct tab every evening. The file is already set up with clear date rows; you’ll simply open the spreadsheet, locate today’s row, type in the total sales figure I provide, and save the file back to our shared folder. Accuracy matters more than speed, but the update must be completed the same day you receive the number so my dashboards stay current. A quick double-check before saving is all it usually takes to prevent slip-ups. If you know your way around basic Excel functions—filters, sum checks, and the like—you’ll have no trouble. Deliverable • Updated Excel sheet reflecting each calendar day’s sales amount, saved by...

I need a tidy, idiot-proof Google Sheets setup that lets me record every sale we make at our events and immediately see how that affects current stock levels. All data will be entered by one person, so there’s no requirement for multi-user permissions or automated feeds—just a clear, well-structured place for manual inputs that keeps the numbers accurate. Here’s how I picture it working: • A single “Sales Log” tab with data-validation drop-downs for product names, event dates, and payment types, plus protected formulas that calculate quantity sold, total value, and running stock on hand. • A master “Inventory” tab that holds opening stock figures; the Sales Log should reference this in real time so I can spot shortages as soon as the ...

I need a robust yet easy-to-maintain Excel workbook (Office 365) that holds my full annual budget, then pulls in Simplifi monthly actuals via the CSV files the app exports. Once the file is dropped in, I want the sheet to refresh and immediately show me how my Income and Expenses are tracking against plan, both month-by-month and year-to-date. You can take advantage of Office 365 tools such as Power Query, dynamic arrays, PivotTables, slicers, or whatever you feel delivers the cleanest solution, as long as I’m left with a single file I can use without any extra add-ins. Deliverables: • An unlocked Excel workbook with: – a clear input area for my annual budget figures – a simple “Import CSV” or “Refresh” action that loads the Simplifi...

I need help standardising the text in an Excel workbook. Several columns are filled with names, product titles, and location fields that now appear in random mixtures of upper- and lower-case letters. Every entry should read in proper Title Case—first letter of each word capitalised and the rest in lower-case. The job is straightforward but must be done with precision. A quick PROPER() formula works for most cells, yet I also expect you to catch exceptions such as “USA”, “eBay”, or common abbreviations that shouldn’t be converted blindly. You are free to rely on formulas, Power Query, or a small VBA macro; just make sure the method is repeatable so I can apply it to future files. Deliverables • My original spreadsheet returned with every relevan...

I have a growing set of Excel workbooks that must be transferred into a MySQL database on a repeating schedule. The workflow I need is straightforward: read each new or updated workbook, validate the data, then load it into the correct tables without duplicates or broken references. Because these files arrive on a timetable, the import script or utility should run automatically— for example via cron, Windows Task Scheduler, or any scheduling feature you prefer—so there is no manual trigger required once everything is in place. Robust error logging is important; if a row fails validation, I want a clear report so it can be corrected before the next run. Deliverables • A script, small application, or stored procedure that connects to MySQL, parses the Excel files, and ...