Excel VBA Jobs

I need reliable support maintaining and improving my inventory records in Excel. The work is fully online and centres on three recurring tasks: • Data entry – updating stock counts, SKUs and supplier details as new information arrives. • Data analysis – spotting discrepancies, slow-moving items and reorder points so I can react quickly. • Creating financial reports – turning the raw inventory data into clear monthly summaries of stock value, cost of goods sold and projected spend. I already have a partially built workbook that tracks most items, but formulas, pivot tables and basic Power Query connections still need attention. Your first milestone will be to review this file, streamline the structure and propose any additional fields that will help au...

I need a compact Excel workbook that helps me spot and explain sales trends at a glance. The main goal is to analyse current and past performance rather than produce long-range forecasts. You will have two data sources to work with: detailed customer-demographic fields and our marketing-spend figures for the same periods. There is no historical sales file yet, so the model must extract insight from these two tables alone. I would like you to keep everything in native Excel, leaning on SUMIFS, LOOKUPs and well-designed PivotTables instead of more advanced statistics. Clear, reusable formulas are important because the sheet will be updated monthly by non-technical staff. Deliverables • One Excel file containing: – Cleaned and well-structured raw-data tabs for the demograph...

I have a batch of digital files in PDF format that must be transcribed into an Excel spreadsheet and then brought to life with the right formulas and calculations. Accuracy on the raw data is essential—I need every figure transferred exactly as it appears in the PDFs—so double-checking before you move on to the next step is part of the job. Once the numbers are in place, set up the formulas that will automate the totals, subtotals, and any percentage or variance calculations the sheet requires. Think standard arithmetic, SUM, AVERAGE, and a few conditionals such as IF or SUMIF; nothing overly complex, just enough to make the file self-updating for future entries. The finished workbook should be clean, clearly labeled, and ready for me to reuse. Deliverables: • One Excel ...

I need my existing Excel time sheet for Monday to Sunday updated. Requirements: - Modernized layout and design - Increased space for typing on each line Ideal skills and experience: - Proficiency in Excel - Experience with Excel design and layout improvements Looking for clean, user-friendly, and functional designs.

I need a reliable pair of eyes on a batch of Microsoft Word documents and several Excel workbooks. The Word files mainly require a consistency pass so everything reads smoothly and follows the same style; I’ll share the exact focus and house-style guide once we’re underway. The heavier lift is on the Excel side. I want the data properly organised and cleaned, redundant or inconsistent entries fixed, and formulas checked or rebuilt so totals, look-ups, and any linked sheets calculate correctly every time. When that’s solid, the workbooks should be reformatted into a clear, presentation-ready layout that makes key numbers pop without breaking the underlying logic. Deliverables • Updated Word documents returned in their original folder structure (DOCX) • Clea...

I have an Excel workbook where every supporting tab holds numerical figures laid out in clearly defined columns. The Master sheet is meant to roll those numbers up, but its current formulas are incomplete and sometimes miss new entries. Your task is to rebuild the Master sheet logic so that, whenever I type or paste fresh numbers in any of the subsidiary tabs, the corresponding totals appear instantly and accurately on the Master sheet. All calculations are straightforward sums—no averages or counts—yet they must remain dynamic enough to keep working if extra rows are added later or if a new sheet follows the same column structure. Using robust techniques such as structured Tables, 3-D or INDIRECT references, or any smarter approach you prefer is fine as long as the end resu...

I have an existing workbook that needs a cleaner, more intuitive front end. I want a slim navigation bar running across the top (or down the side—whichever best fits the layout) that lets me jump to any sheet in a single click while also giving me built-in filter controls so I can slice the visible data without hunting through menus. On the main dashboard I’d like a concise KPI layer: top-level numbers, simple traffic-light indicators, and space for a short explanatory note beside each metric. These figures will pull automatically from the underlying sheets, so the setup has to stay fully dynamic as new rows are added. Because different stakeholders review the file, the dashboard needs customizable views: think show/hide toggles, drop-down selectors, or similar mechanisms tha...

PROFESSIONAL SUMMARY Detail-oriented and systems-focused Data Specialist specializing in end-to-end data pipelines for remote business environments. Proven expertise in taking raw, fragmented business datasets and transforming them into structured, automated, and visually striking Power BI dashboards and Excel models. Expert in data cleansing, relational data modeling, and advanced business intelligence analytics (DAX, Power Query, XLOOKUP, and Pivot Tables) aimed at helping remote teams optimize operations, increase sales performance, and make data-driven decisions. TECHNICAL SKILLS MATRIX Data Analysis & BI: Power BI Desktop, Power BI Service, Power Pivot, Data Modeling (Star Schema), DAX (Data Analysis Expressions) Measures. Advanced Spreadsheet Engineering: Microsoft Excel, Googl...

Necesito un desarrollador de macros experto en VBA para PowerPoint. La macro debe generar explicaciones paso a paso desde una presentación de PowerPoint. Requisitos: - Estructura de explicación: Por diapositiva - Contenido: Texto descriptivo y texto matemático Habilidades y experiencia ideales: - Dominio de VBA y PowerPoint - Experiencia en la creación de macros automatizadas - Atención al detalle y capacidad para seguir instrucciones Adjunto 4 archivos de PowerPoint. Dos de ellos tienen el ENUNCIADO y los otros 2 el PASO A PASO que deseo obtener. Lo que envío es solo una muestra. El trabajo sería mucho más amplio. Uno de los requisitos ineludibles es que de una diapositiva a la siguiente "no se mueva" nada. Solo aparece ...

PROFESSIONAL SUMMARY Detail-oriented and systems-focused Data Specialist specializing in end-to-end data pipelines for remote business environments. Proven expertise in taking raw, fragmented business datasets and transforming them into structured, automated, and visually striking Power BI dashboards and Excel models. Expert in data cleansing, relational data modeling, and advanced business intelligence analytics (DAX, Power Query, XLOOKUP, and Pivot Tables) aimed at helping remote teams optimize operations, increase sales performance, and make data-driven decisions. TECHNICAL SKILLS MATRIX Data Analysis & BI: Power BI Desktop, Power BI Service, Power Pivot, Data Modeling (Star Schema), DAX (Data Analysis Expressions) Measures. Advanced Spreadsheet Engineering: Microsoft Excel, Googl...

I have a master template in Excel and a list of spare-part codes that need to be turned into clean, uniform “standardization” forms. For every item you will: • Work directly in the Excel template I provide, completing the fields for part name, concise description, technical specifications and the correct material group. • Source a clear product image—even a medium-grade web image is fine—primarily from manufacturer websites or reputable online marketplaces. • Use the companion Excel lookup sheet I send you to confirm and assign the most accurate material-group code. I will share a few fully filled examples so you can mirror layout, wording style and level of detail. The workload is largely copy-and-paste once the right information is located, bu...

My financial-report templates rely on several nested IF, AND and OR formulas that should pull figures from other sheets in the same workbook, yet the numbers stay frozen when the source data changes. I need someone who can open the file, trace the internal links, correct any reference errors or circular logic, and make sure every total and subtotal refreshes instantly after data entry. You will be working only inside this one workbook—no external files or databases—so the focus is on sheet-to-sheet connections, range naming, and any settings (calculation mode, table expansion, etc.) that might block recalculation. Once the logic is solid I would like the templates cleaned up: remove any redundant helper columns, lock the finished formulas, and confirm the output matches a shor...

I need a freelancer to verify and update a spreadsheet of company contacts. The task involves checking if companies still exist and if the contacts are still valid. If a contact is no longer valid, please replace them with someone of a similar title. Requirements: - Utilize online search and validation for verification. - Preferred sources: Company website, LinkedIn, Industry directories. Ideal Skills & Experience: - Proficiency in using LinkedIn and industry directories. - Attention to detail. - Experience with online research and data validation. - Familiarity with spreadsheets for updating information.

I have a picture of an existing network layout that I need redrawn cleanly in Microsoft Visio. The final diagram must clearly show the servers and computers, routers and switches, plus the firewalls and other security devices exactly as they appear in the image, keeping their relative positions and connections intact. Please replicate the iconography with standard Visio stencils (or equivalent custom shapes where needed) so the diagram is editable later. I’ll supply the source photo in high resolution; you return a fully editable .vsdx file, logically grouped and neatly labelled. Deliverables: • Editable Visio (.vsdx) file reflecting the picture That’s all I need—accuracy, clarity, and tidy layer organisation so future tweaks are simple.

I want to replace a string of repetitive, error-prone steps in my workbook with a clean, well-documented VBA macro. The end result should run at the click of a button or a keyboard shortcut, carry out every step automatically, and leave the sheet ready for review without any manual fixes. Deliverables • The Excel file containing your fully commented VBA code • A short note (or Loom/video) explaining how to install, edit, and trigger the macro in Excel 2016, 2019, and Office 365 • Clear documentation of any external references or libraries you use Acceptance criteria • Macro executes from a single action with no run-time errors • Code is logically structured and easy for me to tweak later • Operation remains consistent across all three Excel v...

I need assistance to get my Excel macro working for report generation tasks related to rates. Requirements: - The macro is already created but currently non-functional. - It should automate the generation of reports based on specified criteria. Ideal Skills and Experience: - Proficiency in Excel and VBA (Visual Basic for Applications). - Experience in creating and troubleshooting Excel macros. - Strong understanding of report generation processes in Excel. Please provide a brief overview of your experience with similar projects.

Silakan Daftar atau Login tuntuk melihat rincian.

I'm seeking an experienced VBA developer to create an Excel macro. The primary goal is to automate reporting tasks to save time and reduce manual effort. Key Requirements: - Develop a VBA macro to automate repetitive reporting tasks. - Ensure the macro is user-friendly and well-documented. - Provide support for any troubleshooting post-deployment. Ideal Skills and Experience: - Proficiency in Excel and VBA. - Strong experience in automating tasks, particularly in reporting. - Problem-solving skills and attention to detail. Please provide examples of past work and relevant experience in your application.

I have a backlog of both accounts receivable and accounts payable that must be keyed into Tally and mirrored in Excel for reporting purposes. Source documents are already scanned and organized, so most of the work is straightforward data entry and careful copy-paste, followed by a quick self-check to be sure every invoice, payment, credit note, and adjustment is represented in both systems. You can work with the column layout I already use, or propose a cleaner template if you feel it will speed things up—I’m flexible on that point as long as the final Excel sheet matches the Tally ledgers line for line. Because accuracy matters more than speed here, I will verify the first small batch before you proceed with the rest. Once we’re happy with the approach, you can take th...

I’m looking for a mentor-consultant who can help me blend two worlds that normally sit apart: solid financial-accounting practice and persuasive mobile-phone sales. My immediate priority is to deepen my grasp of financial accounting—closing entries, reporting logic, ratio interpretation, and the everyday Excel workflow that underpins them—while, in parallel, mastering product-level knowledge of smartphones so I can explain specs and value propositions with genuine authority. Here’s how I picture the engagement: • Build a concise learning roadmap that alternates between financial-accounting concepts and mobile-device product briefings, so the two skill sets reinforce one another instead of competing for time. • Provide live or recorded walkthroughs o...

I have a batch of customer information locked away in several PDF files that needs to be brought into a clean, well-structured Excel workbook. Your job is to extract every required field, place it in the correct columns, format it consistently, and double-check the results so that the sheet is error-free. Source material • Native and scanned PDFs containing names, addresses, contact details, account numbers and a few date fields. • Some documents include multiple records per page, others just one. What I need from you 1. Convert the PDFs to Excel, making sure each customer record sits on its own row. 2. Standardise text (capitalisation, date formats, phone number structure, no trailing spaces). 3. Run quick validations—spot duplicate records, flag missing mandat...

# Advanced Excel Study Planner & Performance Dashboard (RRB PO, SBI PO, SSC) ## Project Overview I need a professional, full-featured study-planning workspace built entirely in Microsoft Excel (Excel 2016+ compatible) for competitive exam preparation, specifically RRB PO, SBI PO, IBPS PO, SSC CGL, SSC CHSL, and similar aptitude-based examinations. The workbook should function as a complete planning, tracking, and performance-management system, allowing me to create fully customizable study schedules (daily, weekly, monthly, or hour-based), monitor progress automatically, analyze mock-test performance, and identify weak areas through interactive dashboards. The final deliverable should be clean, professional, optimized for performance, and suitable for long-term use without requirin...

I have a backlog of both accounts receivable and accounts payable that must be keyed into Tally and mirrored in Excel for reporting purposes. Source documents are already scanned and organized, so most of the work is straightforward data entry and careful copy-paste, followed by a quick self-check to be sure every invoice, payment, credit note, and adjustment is represented in both systems. You can work with the column layout I already use, or propose a cleaner template if you feel it will speed things up—I’m flexible on that point as long as the final Excel sheet matches the Tally ledgers line for line. Because accuracy matters more than speed here, I will verify the first small batch before you proceed with the rest. Once we’re happy with the approach, you can take th...

I have a collection of text-based records that must be transferred accurately into Excel and then processed with a short Python routine. Everything will be keyed in manually—no web scraping or database pulls—so precision and an eye for detail are critical. The spreadsheet should come back tidy, well-formatted, and ready for basic filtering or pivoting. Once the sheet is complete, I’d like a lightweight Python script (pandas / openpyxl are fine) that reads the file, performs simple cleaning steps I’ll specify, and exports an updated version. If any numeric fields appear along the way, just include them exactly as the client supplies; no additional analysis is required. Deliverables • Finished Excel workbook with all text data correctly entered • P...

I have a collection of text-based records that must be transferred accurately into Excel and then processed with a short Python routine. Everything will be keyed in manually—no web scraping or database pulls—so precision and an eye for detail are critical. The spreadsheet should come back tidy, well-formatted, and ready for basic filtering or pivoting. Once the sheet is complete, I’d like a lightweight Python script (pandas / openpyxl are fine) that reads the file, performs simple cleaning steps I’ll specify, and exports an updated version. If any numeric fields appear along the way, just include them exactly as the client supplies; no additional analysis is required. Deliverables • Finished Excel workbook with all text data correctly entered • P...