Excel Macros Jobs

I need a tidy, well-formatted Microsoft Excel workbook built with up to five separate sheets, each populated with text records that I will supply—every record includes a person or company name and a full mailing address. Your job is simple but must be flawless: transfer the information exactly as shown in the source documents, keep the spelling and line breaks intact, and place each field in its proper column so the file is instantly searchable and ready for mail-merge use. To keep things consistent, I will send you a template that shows the column headers I need (Name, Street, City, State/Province, ZIP/Postal Code, Country). Please stick to that layout, avoid merged cells, and apply the same basic formatting on every sheet. Deliverable: • One Excel (.xlsx) file containing 1...

Sales & Profitability Dashboard — Project Description Overview An interactive Excel-based dashboard that consolidates raw sales transaction data into real-time KPIs, breakdowns, and visualizations for tracking revenue, cost, and profitability performance across regions, product categories, time periods, and sales reps. Objective To give sales and finance stakeholders a single, self-updating view of business performance — eliminating manual pivot-table building and enabling faster, data-driven decisions on where revenue and margin are strongest or weakest. Key Features Live transaction table — a structured Excel Table capturing Date, Region, Category, Product, Sales Rep, Units Sold, Unit Price, and Unit Cost, with Revenue, COGS, Gross Profit, and Margin % calculate...

I'm looking for a skilled Excel developer to create a comprehensive property calculator for residential properties. The calculator should handle the following calculations: - Mortgage payments - Rental income - ROI (Return on Investment) Additionally, it should incorporate essential financial variables: - Property taxes - Insurance costs - Maintenance costs Ideal skills and experience: - Advanced proficiency in Excel - Experience with financial modeling - Knowledge of real estate calculations - Attention to detail and accuracy Please provide samples of similar work done.

I need a fast-turnaround conversion of a large batch of entries written in English, Hindi, and Gujarati into a single, well-organised Excel workbook. Every record must be placed under the correct category— I’ll supply the category list— and each category heading should appear once, centred in bold at the top of its section. No additional colours, merged cells, or fancy layouts are needed; clarity and accuracy are all that matter. The data includes both written contacts and visiting cards, which will need to be reviewed to extract details like Name, Company, Location, and Contact Information. Acceptance criteria for the file: • All supplied entries transcribed exactly as written, preserving language-specific characters. • Every item sorted into its correct ca...

I have several spreadsheets that need to be built out, cleaned up, and kept current in Microsoft Excel. The core of the job is straightforward data entry and basic spreadsheet management—copy-pasting data from source documents, organising it into the right columns, applying simple formulas where needed, and double-checking for accuracy before saving each file. You will work exclusively in Excel; no Google Sheets or other tools are required. If you have a solid eye for detail and can follow clear naming conventions, you’ll find this task smooth and repetitive—in a good way. Deliverables • Fully populated Excel workbooks provided back to me in the same file format • Zero placeholder cells or formatting errors • A short completion note outlining an...

I have several spreadsheets that need to be built out, cleaned up, and kept current in Microsoft Excel. The core of the job is straightforward data entry and basic spreadsheet management—copy-pasting data from source documents, organising it into the right columns, applying simple formulas where needed, and double-checking for accuracy before saving each file. You will work exclusively in Excel; no Google Sheets or other tools are required. If you have a solid eye for detail and can follow clear naming conventions, you’ll find this task smooth and repetitive—in a good way. Deliverables • Fully populated Excel workbooks provided back to me in the same file format • Zero placeholder cells or formatting errors • A short completion note outlining an...

I’m working with a single .xlsx file that holds all of my raw sales transactions and I need it turned into an insightful workbook in just three days. The core of the job is to build robust pivot tables that summarise performance by product, by month, and—importantly—by region, with the spotlight on India. Because I don’t have any existing templates, you’re free to design the layout, colour scheme, and overall flow of the dashboard from scratch. The visuals should rely primarily on bar charts so that trends and comparisons are instantly clear. Please add slicer or timeline filters so I can toggle months, products, and regions without touching the underlying data. I also need a concise monthly summary sheet that pulls key KPIs straight from the pivots. Deliver...

I need an Excel-based quotation template for my aluminium windows and doors manufacturing business. The template should include: - Itemized product list - Pricing breakdown - Terms and conditions - Glass details - Fabrication cost - Installation cost Ideal skills and experience: - Proficiency in Excel - Experience with quotation templates - Understanding of manufacturing and installation cost breakdowns

I run a medium-sized enterprise and need ongoing help keeping our accounts payable and receivable accurate and up to date. At the moment every transaction lives in a set of linked Microsoft Excel workbooks, so you must be comfortable working in Excel and able to maintain formulas, pivot tables, and basic macros as you record new invoices, payments, and customer receipts. Scope of work • Record and code supplier bills and customer invoices. • Track due dates, flag overdue items, and apply payments. • Reconcile the A/P and A/R balances against bank statements to catch discrepancies quickly. • Provide a concise weekly summary of outstanding payables, receivables, and any issues that need my attention. Acceptance criteria • All entries are double-checked for da...

I have a set of Excel workbooks that need a smarter layer of automation. Your job is to weave in solid, intermediate-level formulas—VLOOKUP, nested IF statements, and similar functions—to turn raw data into information I can slice and present quickly. Alongside the formulas, I need reliable data sorting and filtering controls as well as conditional formatting rules that instantly flag exceptions and trends. The focus is on clear, maintainable solutions; no VBA or complex array formulas are necessary. Deliverables: • Updated .xlsx file(s) with all new formulas, sorting/filtering views, and conditional formats in place • A concise in-sheet note or README explaining the logic so I can update it later I’ll share the current workbook as soon as we start and will...

I have several very large spreadsheets that need to be audited, cleaned, and uniformly formatted. The job revolves around identifying and fixing discrepancies quickly while keeping every entry accurate. You’ll be diving into thousands of rows, using VLOOKUP, XLOOKUP, and any other advanced functions you find useful to reconcile records, highlight mismatches, and verify totals. I care a lot about proper formatting—leading zeros must stay intact, text-to-number issues have to be resolved, and custom field structures need to remain consistent from sheet to sheet. Throughout the process I expect frequent spot-checks to confirm that formulas are returning the correct values and that no data has been lost or overwritten. Deliverables: • One consolidated, fully audited work...

I need an Excel-based auto quotation maker that generates both product and service quotations. Requirements: - Generate quotations in Excel format. - Include: - Client details - Itemized list with prices - Payment terms Ideal Skills and Experience: - Proficient in Excel - Experience in designing automated quotation systems - Attention to detail and accuracy

I’d like my current Excel rota transformed into a clean, automated workbook that practically manages itself. Right now dates are out of order and shifts run together; I need everything sorted chronologically with each shift clearly separated so I can scan the week in seconds. The file must keep one critical data point—employee names—at its core, because every formula will rely on that. As soon as I enter a start and end time I want the sheet to calculate the shift length and each employee’s running monthly total automatically. If two people accidentally overlap or a shift doubles up, conditional formatting should light it up straight away. Presentation matters too. Please apply a single, professional font across the workbook; beyond that I’m not fussy about ...

I’m working with an Excel rota that has become unwieldy and hard to trust. I need you to reorganise it so every working day appears in chronological order, start- and finish-time columns calculate shift length automatically, and monthly hour totals are ready at a glance. Please separate the data by shifts (not by clients or locations) so each type of shift is simple to scan and edit. Because I frequently adjust start or finish times, all totals must update instantly through robust formulas, not manual entry. A key requirement is highlighting any scheduling conflicts; the moment two shifts clash I want clear conditional-formatting alerts so I can spot and fix issues right away. While you’re streamlining the layout, keep the original information intact—just tidy th...

I have between one and five CSV files containing purely text fields that I want moved into a single, well-structured Excel workbook. While the move itself is straightforward, I also need basic cleaning carried out along the way—think trimming leading/trailing spaces, normalising simple text inconsistencies, removing blank rows, and ensuring each column retains a consistent header. Once the import and tidy-up are finished, please deliver the final .xlsx file with the cleaned data sitting on clearly named worksheet tabs (one tab per source file is fine). I would also appreciate a short note describing any issues you spotted and the steps you took to correct them so I have a quick audit trail for future reference. If you work comfortably with Excel formulas, Power Query, or similar to...

I have between one and five CSV files containing purely text fields that I want moved into a single, well-structured Excel workbook. While the move itself is straightforward, I also need basic cleaning carried out along the way—think trimming leading/trailing spaces, normalising simple text inconsistencies, removing blank rows, and ensuring each column retains a consistent header. Once the import and tidy-up are finished, please deliver the final .xlsx file with the cleaned data sitting on clearly named worksheet tabs (one tab per source file is fine). I would also appreciate a short note describing any issues you spotted and the steps you took to correct them so I have a quick audit trail for future reference. If you work comfortably with Excel formulas, Power Query, or similar to...

I have an automated Excel-based rostering workbook that has been running in production for a while, but a few critical pieces now need attention. The core of the job is to refine the calculation logic. Some totals are coming out wrong, a couple of edge-case rules were never coded, and overall processing speed has slipped as the file has grown. I would like the existing formulas/VBA adjusted so every shift, allowance and overtime rule reconciles accurately, a set of new business rules is added, and execution time is brought back to an instant feel. Alongside that, I need the import/export module expanded. At present it handles only a basic CSV; I want to introduce two additional formats (one XLSX template we use with payroll and a JSON summary we send to Power BI). Clean, reliable parsi...

I have three extensive Excel files—each packed with multiple worksheets—that currently hold all of our internal financial reports. I need these merged into a single, well-structured database that can automatically pull the latest data, tabulate it against our budget lines, and generate clear, executive-level dashboards focused on performance assessment. The scope is large (about 120 hours) and hands-on collaboration is essential. I will work closely with you to map every worksheet, define the budgeting logic, and agree on the look and feel of the summary views. Advanced Excel skills—think Power Query, PivotTables, dynamic array formulas, and VBA for tighter automation—will be required to keep maintenance simple after hand-over. Key deliverables: • A mast...

A spreadsheet with detailed instructions is attached, and I need the entire assignment completed exactly as outlined there. The work involves three core pieces: • Data entry – copy the raw values into the correct sheets and ranges without altering formatting. • Formulas and calculations – build dynamic formulas (SUMIFS, VLOOKUP/XLOOKUP, pivot tables if specified) so every total, percentage, or lookup updates automatically when source data changes. • Creating charts – generate the charts requested in the file, styling them to match any colour or layout cues already present. Please keep every worksheet structure intact, add only the cells or tabs the assignment explicitly calls for, and double-check that all formulas return the same answers shown in the...

I have a 50-page PDF that contains plain text only. I need every bit of that text transferred into a single-column Excel sheet. Each new logical section in the source should begin on a new row, and the first row for every section must use bold formatting so the headers stand out at a glance. Accuracy is critical; the Excel file has to mirror the PDF’s wording character-for-character—no omissions, no added spaces, and no spelling changes. I will spot-check for consistency before signing off. Deliverable: one .xlsx file completed to the above standard and ready for immediate use.

I have a 50-page PDF that contains plain text only. I need every bit of that text transferred into a single-column Excel sheet. Each new logical section in the source should begin on a new row, and the first row for every section must use bold formatting so the headers stand out at a glance. Accuracy is critical; the Excel file has to mirror the PDF’s wording character-for-character—no omissions, no added spaces, and no spelling changes. I will spot-check for consistency before signing off. Deliverable: one .xlsx file completed to the above standard and ready for immediate use.

I have several digital Excel spreadsheets that contain blocks of text which need to be transferred accurately into our master file. Your job is to open each spreadsheet, copy or re-type the text into the corresponding fields I will provide, and double-check that every character matches the original. Please keep the existing spelling, punctuation, and line breaks exactly as they appear. Any obvious typos should be flagged in a separate note rather than corrected on the fly—content fidelity is more important than editing. Deliverables • A consolidated master file with all text correctly placed • A brief log noting any unreadable cells or issues you encounter Acceptance criteria • 100 % of rows present in the final file • No mismatched or truncated t...

I have a batch of PDFs where all the information I need sits neatly inside tables. Every cell in those tables contains text only—no numbers, formulas, or special characters. Your task is to copy that text into an Excel workbook, keeping each table’s row-and-column order intact but using simplified, clean formatting rather than trying to mirror the PDF’s exact look. Essential points • Source content: text-only tables in PDF files • Target file: a single .xlsx workbook (one sheet per PDF, unless a different layout proves clearer) • Formatting: standard font, consistent column widths, no borders or shading beyond Excel’s defaults Please double-check that every table entry is captured and appears in the correct cell. Spelling must match the origin...

أحتاج إلى مُدخِل بيانات يتفرغ للعمل خلال الفترة المسائية (بعد الساعة 6 م بتوقيت الرياض تقريبًا) لإدخال أرقام في قاعدة بيانات وجداول Excel. المطلوب البدء فورًا، لذلك سأتواصل سريعًا مع من يثبت قدرته على إنجاز العمل بدقة وسرعة. طبيعة المهام سأرسل لك ملفات رقمية أو صور فواتير تتضمّن أرقامًا مختلفة (مبالغ، أكواد، تواريخ). المطلوب نقلها إلى جدول منسّق مع التحقّق من صحة كل خانة قبل الحفظ. أستخدم Google Sheets و Microsoft Excel، وأتوقّع منك الإلمام بالاختصارات والأساليب التي تسرّع الإدخال دون المساس بالدقة. التسليم والالتزام - أحدث نسخة من الجدول نهاية كل مناوبة مساءً - نسبة خطأ لا تتجاوز 0.1٪ بعد مراجعة عيّنة عشوائية - حفظ نسخة احتياطية على Google Drive قبل إغلاق اليوم اذكر في عرضك معدل السرعة لديك (عدد الخانات في الدقيقة) وأي خبرة سابقة في التعامل مع بيانات رقمية حساسة مثل الحسابات أو المخزو...

I have an Excel spreadsheet filled with traveler details. Your task is to take that file, follow the step-by-step method I’ll demonstrate inside the Travel Line mobile app, and create a unique customer ID for every traveler. The workflow is straightforward once you see it in the app: • import or copy each row’s data, • apply the in-app ID-generation steps exactly as I show, • note each finished ID back into the Excel file. Accuracy and consistency are critical—every ID must be accepted by the app with no duplicates or spelling errors. When the list is complete, return the updated spreadsheet and a quick confirmation report summarizing how many records were processed and any issues you encountered. Remote screen–share training takes about t...

I have an Excel file containing a list of brake pad part numbers. I need a skilled automotive parts researcher to identify all vehicle applications that match each brake pad part number. The Excel file includes a worksheet named “Example” that shows exactly how the results must be entered and formatted. Please follow the same structure without changing the original columns or file layout. There are also 17 brake pad numbers that use internal part numbers and may not be identifiable by number alone. I will provide a ZIP file containing full drawings and dimensions for these brake pads to help identify their correct vehicle applications. Required work: - Research every brake pad part number in the Excel file. - Identify all compatible vehicles, including make, model, model yea...

I have a 50-page PDF that contains plain text only. I need every bit of that text transferred into a single-column Excel sheet. Each new logical section in the source should begin on a new row, and the first row for every section must use bold formatting so the headers stand out at a glance. Accuracy is critical; the Excel file has to mirror the PDF’s wording character-for-character—no omissions, no added spaces, and no spelling changes. I will spot-check for consistency before signing off. Deliverable: one .xlsx file completed to the above standard and ready for immediate use.

I have an Excel file containing a list of brake pad part numbers. I need a skilled automotive parts researcher to identify all vehicle applications that match each brake pad part number. The Excel file includes a worksheet named “Example” that shows exactly how the results must be entered and formatted. Please follow the same structure without changing the original columns or file layout. There are also 17 brake pad numbers that use internal part numbers and may not be identifiable by number alone. I will provide a ZIP file containing full drawings and dimensions for these brake pads to help identify their correct vehicle applications. Required work: - Research every brake pad part number in the Excel file. - Identify all compatible vehicles, including make, model, model yea...

Tôi cần bạn hỗ trợ nhập dữ liệu đơn giản bằng Excel, hoàn toàn làm từ xa nên rất phù hợp cho học sinh hoặc bất kỳ ai đang tìm việc linh hoạt tại nhà. Công việc chỉ xoay quanh lĩnh vực nhập liệu; tôi không yêu cầu dịch thuật hay thiết kế đồ họa, vì vậy bạn chỉ cần tập trung vào bảng tính. Bạn sẽ nhận file nguồn (văn bản, hình ảnh rõ ràng, link web…) và chuyển nội dung sang workbook Excel do tôi cung cấp sẵn mẫu. Miễn là bạn đã quen thao tác cơ bản trong Excel – điền ô, định dạng, dùng công thức SUM, COUNT, v.v. – là đủ. Kinh nghiệm nhập liệu trước đây không bắt buộc; tôi sẽ hư...

Necesito apoyo recurrente en una cuenta de Mercadolibre Empresarial para mantener al día la información de productos mediante archivos CSV/Excel. Requisitos: - VIVIR EN BOGOTA O TENER DISPONIBILIDAD PARA LA CREACION DE ACCESOS INICIALMENTE Y ALGUNA REUNION EN CASO DE REQUERIRSE. - TENER LA DISPONIBILIDAD Y AUTORIZAR DATOS PERSONALES PARA LA CREACION DE LOS ACCESOS COMO RECONOCIMIENTO FACIAL Y ESCANEO DE DOCUMENTO DE IDENTIDAD. - CUMPLIR REALIZANDO LA TAREA CORRESPONDIENTE CADA SEMANA. Tu principal responsabilidad será descargar las bases de datos actuales de la plataforma, actualizarlas localmente y volver a cargarlas sin errores. En concreto: • Importación/Exportación de datos desde mercadolibre a google drive • Control de integridad: ve...

Saya mencari bantuan untuk “Editing dan Microsoft Office Excel,” dengan fokus utama pada “Data input dan pemrosesan.” Tugas inti: • Memasukkan data mentah ke dalam lembar kerja yang sudah saya siapkan. • Memeriksa, membersihkan, dan memvalidasi setiap entri agar bebas kesalahan. • Menambahkan rumus, fungsi, atau pivot table sederhana untuk otomatisasi perhitungan dan ringkasan data. Hasil yang saya butuhkan adalah file Excel yang rapi, terstruktur, dan langsung siap dipakai untuk laporan lebih lanjut. Apabila Anda juga mampu menata format atau menyisipkan grafik dasar, silakan sebutkan; itu bonus bagi saya. Sertakan contoh proyek sejenis dan estimasi waktu pengerjaan. Saya ingin memulai secepatnya—terima kasih!