Macros de Excel Jobs

Estoy buscando un experto en Excel para el desarrollo (o adquisición) de una Plantilla de Funnel de Ventas Profesional. El objetivo es centralizar la gestión comercial en una herramienta robusta, intuitiva y visualmente atractiva que permita monitorear el ciclo de vida de los prospectos. Estructura Requerida (4 Módulos) Configuración Personalizable: Definición de etapas del embudo, tasas de conversión objetivo y validación de datos. Registro de Prospectos: Base de datos centralizada con campos para contacto, origen, etapa actual, valor de oportunidad y probabilidad. Visualización de Progreso: Pipeline activo con formatos condicionales para detectar cuellos de botella y estancamientos. Dashboard de Rendimiento: Panel visual con KPIs cl...

I need someone who can sit with me this afternoon and again tomorrow afternoon in Daman or Vapi and help knock out a very simple Excel task. The file contains mixed data that just has to be copied and pasted into the right spots, then given a quick tidy-up. After a five-minute walkthrough I’ll provide, your job is to: • enter the records exactly where shown, • use basic formatting only—mainly data sorting, filtering, and a couple of straightforward formulas to keep totals correct. No macros, no complex analytics—just clean, accurate entry and a neatly organised sheet by the end of each half-day. Bring a solid grasp of Excel shortcuts, show up on-site for both sessions, and we’re good to go.

I need someone who can sit with me this afternoon and again tomorrow afternoon in Daman or Vapi and help knock out a very simple Excel task. The file contains mixed data that just has to be copied and pasted into the right spots, then given a quick tidy-up. After a five-minute walkthrough I’ll provide, your job is to: • enter the records exactly where shown, • use basic formatting only—mainly data sorting, filtering, and a couple of straightforward formulas to keep totals correct. No macros, no complex analytics—just clean, accurate entry and a neatly organised sheet by the end of each half-day. Bring a solid grasp of Excel shortcuts, show up on-site for both sessions, and we’re good to go.

I have a series of Excel documents that contain only text—no numbers or formulas—pulled together from earlier reports. Your job is to take that text exactly as it appears and enter it into the data capture template I’ll share once we start. Accuracy matters more than speed; the wording, spacing, and capitalization must match the source files so downstream searches work correctly. You will receive: • A folder of Excel files, each clearly named. • A simple web-based form with fields that mirror the column headers in those spreadsheets. Your deliverable: • The online form fully populated for every row in every file, with no typos or omissions. I will run a spot-check before sign-off. If you’re comfortable working line-by-line in Excel and have a goo...

I have an Excel workbook packed with productivity figures that needs to tell its story clearly in an upcoming presentation. My audience is non-technical, so visuals must be intuitive: clean tables with strategic highlights rather than complex charts. Here’s what I need: • A set of formatted tables that surface the key productivity metrics—think conditional-formatted cells, sparklines, or color-coded variances—so trends and outliers pop at a glance. • An easy-to-follow layout: summary at the top, detailed breakdowns below, each section clearly labeled for quick navigation when I’m presenting. • Light automation where it helps (simple formulas, named ranges, perhaps a few slicers) so I can refresh the data without re-doing the design. Accept...

Je dispose d’un fichier Excel déjà doté de macros (VBA) destiné à générer des comparateurs de fournisseurs détaillés. Plusieurs points bloquants sont apparus et je souhaite les résoudre tout en améliorant l’esthétique globale. Objectifs principaux • Corriger les erreurs d’automatisation qui empêchent l’affichage du logo lorsque je sélectionne un fournisseur. • Re-designer l’interface pour obtenir un rendu propre, cohérent et clairement professionnel (pas de style trop coloré, je vise quelque chose d’élégant et moderne). • Réparer la fonction d’export PDF : aujourd’hui l’extraction plan...

I have a sales performance sheet. I want an experienced person who is specialized in advanced Excel formulas and who can automate the sheet. The sheet is already automated. Some of the formulas are not working, and I want to add some more stuff into it, so I need someone who can actually do the stuff.

Complete Excel-Based Business Record Management System I need a complete Excel-based business management system to maintain all daily business records in a professional and organized way. The file should be user-friendly, automated, and easy to manage. The system should include the following modules: 1. Customer Ledger Customer Name Contact Number City Opening Balance Debit / Credit Entries Outstanding Balance Customer Transaction History 2. Supplier Ledger Supplier Name Purchase Records Payment Records Remaining Payable Amount Supplier History 3. Stock / Inventory Management Item Name SKU Code Stock In / Stock Out Current Available Stock Purchase Price Sale Price Low Stock Alert 4. Expense Management Daily Expenses Expense Categories Cash Expenses Monthly Expense Summary 5. Bank & C...

Project Title Complete Excel-Based Business Record Management System Project Description I need a complete Excel-based business management system to maintain all daily business records in a professional and organized way. The file should be user-friendly, automated, and easy to manage. The system should include the following modules: 1. Customer Ledger Customer Name Contact Number City Opening Balance Debit / Credit Entries Outstanding Balance Customer Transaction History 2. Supplier Ledger Supplier Name Purchase Records Payment Records Remaining Payable Amount Supplier History 3. Stock / Inventory Management Item Name SKU Code Stock In / Stock Out Current Available Stock Purchase Price Sale Price Low Stock Alert 4. Expense Management Daily Expenses Expense Categories Cash Expenses Mo...

My phone book currently lives in a single .xlsx file and holds about 200,000 records. I need that sheet cleaned and standardised in two key ways: 1. Every duplicate number—regardless of whether it carries the +91 prefix or not—must be identified and removed so each contact appears only once. 2. Phone numbers must carry a consistent format for the Indian market. That means adding or stripping “+91” wherever required so each final entry follows one clear rule (I’m happy to agree on the exact rule with you before you start so we’re on the same page). The end result I’m after is a fresh Excel workbook with: • Zero duplicate rows • Uniformly formatted mobile numbers • No broken formulas, blank rows or stray characters If you ...

I have several existing spreadsheets that contain a blend of text and numerical fields. They now need to be brought together into a single, well-structured Excel workbook. Your task is to copy the data across, preserve every character and figure exactly as written, and apply consistent formatting so the finished file is easy to filter, sort, and run formulas on. Accuracy is essential—please double-check that text strings stay intact, numbers keep their original decimal places, and column headings remain uniform throughout. Where you spot obvious typos or irregular spacing, correct them as you go so the final sheet is clean. Deliverable: • One polished Excel file that merges all source sheets, with data validated and neatly formatted. If you’re comfortable moving mixed d...

I have an Excel workbook in which numeric entries are a mess—some are real numbers, others are text strings littered with stray symbols, and quite a few mix commas and periods as decimal separators. I need every monetary figure, in every column that contains numeric data, converted so it behaves as a true number and displays in a single, consistent currency style: the $ symbol with two decimal places. Your task is to hunt through the file, detect any value that should be treated as money, automatically recognise whether the comma or the point is acting as the decimal marker, correct it, and then apply the chosen format. Dates, percentages, text, formulas, and the workbook’s structure must stay exactly as they are; after the cleanup nothing should break or recalculate incorrect...

I have a folder containing 909 image files that all need to appear inside a single Excel workbook. Each photo should sit in its own row, neatly sized so the sheet remains readable. In the next column I’d like the original file name copied exactly, so I can trace any image back to its source folder without confusion. All photos are ready to go; no editing or re-naming is required on your side—just bring them straight into Excel and line them up. When you finish, I will open the workbook on both Windows and macOS, so please embed the pictures (don’t link) and keep the file under the usual Excel size limits. Acceptance check: • 909 rows populated, one embedded image per row • Adjacent column shows the correct file name for every photo • Images are visibl...

I have several Excel workbooks that contain a blend of text and numeric fields, and I need every row copied into a single master sheet with 100 % accuracy. Everything you’ll work with is already in digital form, so the task is pure data entry and validation—no scanning or transcription from print. You will receive: • All source spreadsheets • A destination template that shows the required column order and cell formats What I need from you: • Transfer each record exactly as it appears, following the provided column map • Maintain number formatting (decimals, dates, currency) and preserve text capitalisation • Spot-check totals or obvious anomalies and flag anything that looks out of place When you finish, I should be able to open the master shee...

I need an Excel sheet to record users for applications access review. The data should be organized in a pivot table for detailed analysis. This project involves an Applications Access Review, starting with two applications containing sensitive information. The goal is to clean up user access by gathering a list of users from each department in the company. These users will be reviewed, categorized, and unnecessary access will be eliminated. You need to record the following information: - User ID and names - Access levels and permissions - Last access date - Department - Inactive user And any other information that you recommend Ideal skills and experience: - Proficiency in Excel, especially with pivot tables - Experience in data organization and management - Attention to detail

I run a micro-business in Ireland and need the last trading year laid out as a clean, well-structured Excel file. All transactions are already in digital form—PDF invoices, bank CSVs, and card statements—but nothing lives in Excel yet. Your job is to import those records, categorise every line, reconcile totals, and produce both an income-and-expense view and a concise balance sheet that fits Irish micro-entity requirements (very close to UK rules). I don’t have a fixed template in mind, so feel free to suggest or build one that keeps things clear and easy for me to maintain next year. Automation with simple formulas or pivot tables is welcome as long as everything remains transparent. Deliverables • Excel workbook with separate sheets for the raw ledger, summarise...

I have a working Excel VBA macro that end-users should be able to run, but I don’t want them to see or tinker with the underlying code. I’d like you to implement password protection on the VBA project so that: • The code window stays hidden unless the correct password is entered. • Users can still execute the macro without needing that password. • Both viewing and editing the code are blocked. Compatibility needs to span any common desktop build—Excel 2016, 2019, and Microsoft 365—so please use methods that work across those versions with no add-ins required on the client’s side. Deliverables I expect: 1. The secured workbook (or a stripped-down sample if you can’t touch my production file) with the password protection in place. 2. ...

Tôi đang tìm một chuyên gia Excel có thể hướng dẫn tôi sử dụng phần mềm thành thạo cho công việc văn phòng hằng ngày. Những gì tôi mong đợi: • Giải thích rõ ràng các hàm và công thức cơ bản đến nâng cao (SUM, IF, VLOOKUP, PivotTable…). • Tư vấn cách định dạng bảng tính, quản lý dữ liệu và trình bày báo cáo chuyên nghiệp. • Cung cấp file ví dụ, bài tập thực hành và đáp án để tôi tự luyện sau mỗi buổi. • Hỗ trợ qua Zoom hoặc Google Meet, có thể chia sẻ màn hình, ghi lại phiên học để tôi xem...

I have a locally stored Excel workbook that contains a financial-data Pivot Table. My goal is to move away from the static worksheet and make the figures available inside Power BI so I can build live dashboards and share them company-wide. Here’s what I need from you: • Take the existing Pivot Table and restructure the underlying data model so it works cleanly in Power BI—preferably in a star schema where possible. • Preserve every measure, calculated field, and filter currently used in the Excel view, translating them to DAX if required. • Deliver a Power BI file (.pbix) that automatically refreshes from the updated Excel source, along with concise documentation outlining the data-refresh steps. Acceptance will be based on side-by-side comparisons confirm...

My courier has issued a comprehensive rate card and I need those numbers turned into a live Excel matrix that my e-commerce platform can read without further tweaks. The finished sheet must calculate charges by matching two factors—weight of the package and the destination zone—and return the correct variable-by-weight price every time. I will supply: • the original courier rate card • an Excel template that already shows the required row / column layout What I expect back: • the completed matrix with formulas or look-ups inserted, fully tested across all weight breaks and zones • a short note explaining any hidden helper tables or named ranges you create, so I can maintain it later Accuracy is critical; the numbers in the final matrix must mirror...

I have a raw Excel workbook that must be cleaned, structured, and fully analysed today. The priority is to extract clear insights—think pivot-table summaries, meaningful charts, and concise findings—so I can make immediate decisions from the data. Because timing is critical, I will only consider freelancers who can demonstrate solid, hands-on experience performing data analysis in Microsoft Excel (formulas, Power Query, PivotTables, and basic VBA are all welcome if they speed things up). Deliverables (today): • The updated Excel file with all cleaning steps, formulas, and analysis embedded • A separate summary sheet (or brief PDF) highlighting key metrics and any notable trends If you can commit to turning this around within a few hours and have the expertise t...

I have several Excel workbooks that need a straightforward tidy-up. All the source material is already digital, so there’s no scanning involved—just working directly in the spreadsheets I provide. Your job is to reorganize the information, apply consistent formatting, and generally make each sheet clear, readable, and ready for immediate use or reporting. Key deliverable • A single, well-organized Excel file for each original workbook, with clean headings, uniform cell styles, and properly structured tables (no stray blanks or merged-cell surprises). If you have a good eye for detail, solid Excel skills, and can turn this around efficiently, I’d like to hear how quickly you can start and your estimated completion time.

I have several Excel and Google Sheets that together exceed 5,000 rows. The files already contain mixed-quality information and new rows are still arriving, so I need help both entering the incoming data and bringing every column in the existing sheets to a consistent, reliable format. What the job involves • Enter each new record exactly as supplied, keeping existing column order. • Standardise all date, currency, percentage and phone-number fields so every row follows one clear format. • Flag anything clearly inconsistent rather than guessing at a value. You will work directly inside the original Excel workbooks or the shared Google Sheets, whichever is easier for you, but the final delivery must preserve both versions. Basic formulas, filters and conditional forma...

I need an Excel sheet to manage and track inventory data. The sheet should allow users to manually input data and should be able to track stock levels, generate reports, and automate calculations. Key Requirements: - Track stock levels - Generate reports - Automate calculations Ideal Skills: - Proficiency in Excel - Experience with data entry sheets - Strong understanding of inventory management