มาโครใน Excel Jobs

I need an execl spreadsheet wizard that can combine multiple independent estimates of multiple types of contracts ( with multiple years and the job description with amounts of people) into one large spreadsheet spread out over a ten year with a summary page. To handle multiple contract types, headcounts, job descriptions, and a ten-year timeline without creating an unmanageable mess, we must separate your data into three distinct layers: Data Inputs, the Calculation Engine, and the Executive is the blueprint for your master spreadsheet. 1. The Core Architecture[Input Sheets] ---------> [Master Calculation Sheet] ---------> [Dashboard / Summary] - Contract Type A - Combines all inputs - 10-Year Financial Chart - Contract Type B - Standardizes timeline...

Potrzebuję kogoś kto odnajdzie wszystkie id porduktów z przypisane do danego produktu. Allegro prowadzi produktyzacje, do produktu są wystawiane oferty. Problem w tym, że w produktyzacji allegro często występuje ten sam produkt jaki kilka produktów na allegro. Np dla produktu: ID produktu allegro to: 1137e723-aadd-43d6-94be-87e9b3c4a495 Czyli Po przejsciu na powyższy link automatycznie wyświetla się najtańsza oferta. Ten sam produkt jest również pod: Czyli ID 455f3437-295c-47b0-b290-60a1aeee8b8e Dla tego samego produktu w allegro może być kilka ID. Zadanie polega na tym, że podam ID mojich produktów na allegro, pod które podczepiona jest moja oferta. Np. Mam około 800 takich linków z różnymi ID. Bedzie to plik excel. Zadani...

I need an Advanced Excel specialist to turn raw campaign data into an interactive retention dashboard that spotlights performance metrics—specifically conversion rates. My files already contain the necessary transactional and engagement logs; what I’m missing is a clean, automated way to track how each cohort converts over time and to surface insights I can act on immediately. Here’s what the finished work should let me do: • Open one workbook and, through slicers or drop-downs, filter by channel, segment, or date range to see real-time conversion performance. • Compare current conversion rates against historical benchmarks, with clear visual cues when a metric slips or surpasses target. • Drill down from a summary view to individual campaign detail...

I’m putting together a three-hour Excel workshop for an Information Technology team of roughly 15–20 people and I need a complete training package that hits both basic and intermediate skills. The focus is on practical ability, so every concept has to be reinforced with hands-on activities. Content scope • Core formulas and functions we rely on every day • Efficient data analysis using pivot tables and related tools Session assets • A clear, well-structured PowerPoint deck that can carry the whole three-hour class • Live demo files and datasets my team can manipulate during each exercise • Step-by-step facilitator notes so the flow is easy to follow and timing stays on target Digital handbook I also want a concise, searchable PDF/OneN...

I have prepared a design brief (see the ZIP) that shows the look and feel I want: one page for entering a register of referral relationships and their milestone activities, and a second page that turns those entries into a clean, professional-looking dashboard. The workbook needs only straightforward formulas—nothing heavy on macros—but it must calculate totals and status summaries automatically so the overview always reflects the latest input. You will build: • Sheet 1 – a clearly laid-out input form where users can type or paste each referral partner, the date of each milestone, and any notes I have specified in the mock-ups. Data validation and drop-downs should guide users so entries stay consistent. • Sheet 2 – an interactive dashboard that pulls f...

instruction to be applied in excel sheet

I need to move roughly 500 – 1,000 rows of mixed text and numerical data out of several PDF reports and into an Excel file that follows a template I will supply (fixed columns, headers, number formats, etc.). Accuracy is absolutely critical—there is zero tolerance for typos, misplaced decimals, or shifted rows—so every entry must be double-checked before you send the final workbook back to me. You will work only with PDF files, and the information is confidential, so please handle all documents responsibly and agree to delete them once the job is closed. Turnaround time is 3–5 days from the moment I share the files. To succeed you’ll need to be comfortable with: • Sorting large tables quickly • Applying consistent formatting across columns an...

I have a sizeable spreadsheet that needs a thorough clean-up in Microsoft Excel. The raw file contains duplicates, inconsistent formats, stray blanks and a few obvious typos. I’m looking for someone who can methodically work through the sheet—using whatever mix of formulas, Power Query, or manual checks you prefer—to deliver a polished, analysis-ready workbook. Accuracy is more important than speed, so the timeline is flexible. When you respond, please highlight your experience handling similar Excel data-cleaning jobs; examples of past successes will help me gauge fit. Final deliverable: the cleaned Excel file plus a short note summarising the main issues you found and the fixes you applied.

I have a collection of digital files that hold nothing but raw lists of names and addresses. I need every single entry moved into a clean Microsoft Excel workbook with absolute accuracy—no spelling slips, transposed numbers, or missing fields. The layout I’m after is straightforward: each component of the address (first name, last name, street, city, state, postcode, and country when supplied) goes into its own column so I can filter and sort later without hassle. I will provide all source files in their current digital format along with a brief field guide that shows how each line should map to the spreadsheet. When you return the finished .xlsx file I’ll spot-check it against the originals, so consistent formatting and 100 % data fidelity are essential. If you use sho...

I’m putting together a three-hour Excel workshop for an Information Technology team of roughly 15–20 people and I need a complete training package that hits both basic and intermediate skills. The focus is on practical ability, so every concept has to be reinforced with hands-on activities. Content scope • Core formulas and functions we rely on every day • Efficient data analysis using pivot tables and related tools Session assets • A clear, well-structured PowerPoint deck that can carry the whole three-hour class • Live demo files and datasets my team can manipulate during each exercise • Step-by-step facilitator notes so the flow is easy to follow and timing stays on target Digital handbook I also want a concise, searchable PDF/OneN...

I have a collection of digital files that hold nothing but raw lists of names and addresses. I need every single entry moved into a clean Microsoft Excel workbook with absolute accuracy—no spelling slips, transposed numbers, or missing fields. The layout I’m after is straightforward: each component of the address (first name, last name, street, city, state, postcode, and country when supplied) goes into its own column so I can filter and sort later without hassle. I will provide all source files in their current digital format along with a brief field guide that shows how each line should map to the spreadsheet. When you return the finished .xlsx file I’ll spot-check it against the originals, so consistent formatting and 100 % data fidelity are essential. If you use sho...

I have a set of raw sales figures and I need an Excel-based dashboard that surfaces only one KPI—revenue. Charts are not necessary; a clear, dynamic layout that lets me filter, sort, and instantly see total and segmented revenue is what matters. The file should open on a summary page that automatically refreshes from the underlying data table, highlights key numbers with conditional formatting, and offers simple slicers or drop-downs for date ranges and product groups. Everything must run on native Excel features (Power Query or Power Pivot are fine) so I can maintain it without add-ins. Deliverable: a single .xlsx file with all formulas, queries, and named ranges unlocked and cleanly documented so I can follow the logic.

I’m organising an on-site workshop for a group that already works confidently in Excel and wants to take their skills to the next level. The participants handle complex spreadsheets daily, so the content must dive straight into expert territory—no time spent on the basics. Core topics we need covered • Macros & VBA: writing, editing, and debugging code that automates repetitive tasks. • PivotTables & PivotCharts: building multi-layered summaries and interactive dashboards. • Data Analysis & Visualisation: advanced formulas, scenario analysis, and clear graphical storytelling that supports decision-making. What I’m after – A trainer who can run engaging, hands-on sessions at our premises (exact location and dates to be agreed). ...

My VBA-driven workbook suddenly throws an error on Windows 11 with Office 2019. I need someone who can jump in right away, locate the glitch, and patch it within the next couple of hours. I will send the workbook and a brief note on the steps that trigger the failure. Once you reproduce the problem, please clean up the code, make it robust for this environment, and send the corrected file back along with a short summary of what you changed and why. Deliverables • Repaired Excel file with fully functioning macro • One-paragraph changelog outlining the fix If you are confident with VBA in Office 2019 and can start immediately, this should be an easy win for you and a quick resolution for me.

I need a meticulous pair of eyes—and hands—to bring together data from more than ten Excel sheets into one master workbook I will provide. Each source sheet carries a mix of plain text and live formulas, so every entry must be pasted or re-typed exactly as it appears, without disturbing any existing calculations. The template you’ll receive shows the precise column order. Simply populate it, keep all spacing, spelling, and capitalization intact, then run a full sweep for duplicates: flag them clearly, confirm counts with me, and remove any I approve for deletion. Nothing should be lost or unintentionally altered; a single stray character compromises our internal search results. When the import is complete, send me: • The updated master workbook, formulas functionin...

I have a live workbook that already holds well over 10,000 rows and it desperately needs a meticulous touch. Every duplicate has to disappear, all stray date and currency formats must be normalised, and the whole sheet needs to be sorted so the information is logically grouped and easy to filter. On top of that, a batch of source documents in PDF must be converted into Excel and folded into the same structure without breaking alignment or introducing extra white-space characters. Accuracy and 100 % confidentiality are non-negotiable because the file contains customer information. Deliverables • A single, organised Excel file with every duplicate removed, formats standardised, and data professionally sorted. • All supplied PDFs transcribed into matching Excel columns and ...

I need a single Excel workbook tailored for our mechanical department that can automatically turn raw operational data into clear summary reports. The main purpose is to generate three report types—Monthly Performance, Maintenance Schedule, and Inventory—without extra manual manipulation, because the engineers who will use it have limited time to tinker with formulas. Here’s what I have in mind: • One ​input sheet where engineers can paste or import daily data. • Backend formulas, pivot tables, or VBA (your call) that clean, sort, and calculate the required metrics. • Three dedicated report tabs—Performance, Maintenance, Inventory—that update instantly once new data is entered. Acceptance criteria • All calculations refresh with a single ...

Rebuilding an unwieldy quoting tool into a clean, modular system is a highly effective way to eliminate errors and speed up your workflow. Keeping reference data separate from your main calculation engine ensures that updating yearly rates won’t break your active client templates. Here is the blueprint for your new, streamlined Excel quotation system. System Architecture To ensure reliability, all four workbooks must be saved in the same local folder or cloud directory. Excel resolves relative paths automatically for files in the same folder, preventing broken links. 1. Primary Workbook: This is the only file your team will open daily. It handles inputs and generates the client-facing quote. • Sheet 1: Cover & Inputs • Fields: Client Name, Project Title, Date...

โปรดลงทะเบียน หรือเข้าสู่ระบบ เพื่อดูรายละเอียด

I want to turn a plain-looking workbook into a polished fintech experience, completely inside Excel. The end result should feel like commercial software rather than a template, with clean navigation, protective formatting and responsive formulas/VBA so users never see the “spreadsheet guts.” Design tone I gravitate toward a classic aesthetic—elegant typography, restrained colour palette, clear hierarchy—so every sheet and chart needs to reflect that timeless look. Phase-one focus We will begin with the Income Tracker. I need an input interface that feels form-based, instantly categorises income streams, and rolls the data into dynamic views (daily, weekly, monthly). Slicers or a custom ribbon button for quick period changes are welcome if they keep the expe...

I need a meticulous pair of eyes—and hands—to bring together data from more than ten Excel sheets into one master workbook I will provide. Each source sheet carries a mix of plain text and live formulas, so every entry must be pasted or re-typed exactly as it appears, without disturbing any existing calculations. The template you’ll receive shows the precise column order. Simply populate it, keep all spacing, spelling, and capitalization intact, then run a full sweep for duplicates: flag them clearly, confirm counts with me, and remove any I approve for deletion. Nothing should be lost or unintentionally altered; a single stray character compromises our internal search results. When the import is complete, send me: • The updated master workbook, formulas functionin...

I need a clean, ready-to-use Excel file that lets me organise mobile numbers for my business contacts. I will be recording each contact’s name, company, designation, primary mobile number and a few optional fields such as email, city and short notes. The sheet must be simple for day-to-day data entry yet professional enough to filter, sort or search quickly when the list grows. Practical touches like data-validation on the mobile column (to ensure only 10-digit numbers), drop-downs for city or category, and conditional formatting for duplicates will help a lot. I’d also like a summary tab that instantly shows the total number of contacts and highlights any missing key details. Deliverable: one Excel workbook (.xlsx) that opens without macros on Microsoft 365, already formatte...

I keep a growing set of records in Excel and I want to stop typing everything straight into cells. Instead, I need a small automation tool—built directly inside the workbook—that pops up a clean, user-friendly form, lets me key in each new record, and then stores the information in the correct table automatically. Core needs • Form-based data entry only; no direct cell editing. • Data are entered manually, so the form should guide the user with drop-downs, date pickers, and basic validation to prevent typos or blanks. • Once a record is submitted, the macro should place it in the next empty row of the master sheet and, if possible, time-stamp the entry. • A simple “Edit existing record” function would be a bonus but is not essential fo...

I need my date-tracking sheet polished today. Every date must follow a single style—spell out the month, then the year (for example, “January 2024”). While you work through the column, please realign any off-center cells and apply one uniform font family, size, and style so the whole sheet looks consistent. No duplicate removal or error checking is required; this is purely a formatting pass. Once the file comes back with tidy alignment, consistent fonts, and the new date format across the board, the job is done. I’ll send the spreadsheet as soon as you accept and will be available for quick feedback so we can wrap this up before the day ends.

I need a single, easy-to-use Excel workbook dedicated to data entry for customer information. The goal is to let anyone on my team open the file and start typing without worrying about layout or errors. Here’s what I’m after: • An input area (form or clearly marked table) that captures all the customer fields I’ll supply once we start. • Custom formatting throughout—title-case names, phone numbers masked as (000) 000-0000, emails forced to lowercase, dates shown as dd-mmm-yyyy, and any other rules we agree on. • Data-validation dropdowns for categorical fields such as region or customer status. • Conditional formatting that flags missing mandatory cells or obvious entry mistakes. • Protected formula or helper columns where usefu...

I use Tally Prime / Tally ERP for day-to-day bookkeeping and need experienced hands to keep everything up-to-date and fully reconciled. The workload centres on three core areas: • Voucher and ledger upkeep – enter every sale, purchase, payment, receipt and journal accurately each day so all ledgers stay current. • GST compliance – post GST invoices, then prepare the basic GST reports I need for filing (GSTR-1, GSTR-3B, mismatch checks). • Bank reconciliation – match bank statements with Tally, investigate variances and close each period with zero unreconciled items. Alongside Tally work, I often export data to Microsoft Excel for deeper analysis. You will create and maintain spreadsheets that include clean data entry sheets, smart formulas and automat...

My current bookkeeping is scattered and I want everything organised in one Excel file that lets me record every income and expense once and then shows me clear, ready-to-print financial reports automatically. Scope of work • Build a clean data-entry sheet dedicated to Income and Expenses, with columns such as date, category, description and amount. • Create the behind-the-scenes formulas that roll those entries into running totals, monthly and yearly summaries, and an overall balance. • Add a separate “Reports” tab that pulls the data into at least a profit-and-loss style summary plus any other insightful views you think would help me monitor cash flow quickly. Dynamic tables, slicers or simple charts are welcome if they keep the file easy to use. •...

I want to turn a workbook that currently relies on manual typing into a push-button process. The flow is simple in theory—data comes from people keying numbers or text straight into Excel—yet it’s time-consuming and error-prone. Here’s what I need: when a user opens the file, they should be guided through an organised form or other intuitive interface that writes their input to the correct sheets, performs validation, and stamps a time-and-user log automatically. As soon as the new records land, Excel should run the built-in statistical routines I specify (mean, standard deviation, t-tests, simple regressions and similar core stats) and update all summary tables, charts and printable reports without further clicks. I’m comfortable if you lean on VBA, mac...

I need an Excel price sheet recreated for printing. Requirements: - Include product names and prices - Simple table format - Company logo and contact information - Create separate retail and wholesale versions Ideal Skills: - Proficiency in Excel - Experience with creating printable price sheets - Attention to detail and good design sense for simple, professional layouts