Excel VBA Jobs

I'm looking for an expert in Excel to create a detailed compensation analysis The model should help in compensation benchmarking analysis . Key requirements: - ability to add multiple surveys into the file and the ability to weight the different surveys different based off position. Built out for at least 3 survey sources - columns for 25th, 50th, and 75th percentiles for base pay, total cash, and long term incentives. Should also include bonus target as a %Ike and bonus actual as a $ value - Detailed compensation insights Ideal skills and experience: - Advanced Excel proficiency - Experience in modeling - Attention to detail - ability to

I need my monthly electricity bills transferred into a clean, well-structured Excel workbook. For every statement I receive, I want one row that captures columns of data: the billing date, usage in kWh, total cost, current read, previous read current usage and any remaining credits that appear on the bill. Edit: I have approx 100 previous bills I would like added to the spreadsheet. Please set up the file so I can keep adding future bills myself—simple data-validated entry boxes or a protected template sheet would be appreciated. A running year-to-date summary that auto-totals usage and spend would be a useful bonus, though not mandatory. Deliverables • Excel file (.xlsx) with the template sheet and at least one sample entry filled in • Clear instructions (a short note...

I have a multi-sheet Excel project that starts with a plain text file and ends with dynamic dashboards. I need you to take the raw content, import it, and turn it into a fully structured, well-formatted workbook that is ready for executive review. Here is the flow I follow every month and want automated or documented so anyone can repeat it: • Open the starter workbook, rename it to the current reporting period, and save it to the network location I will supply. • Import the supplied text file then convert it into a properly sized Excel table. • Apply my preset formatting rules—this includes conditional formatting for key metrics, custom number formats for currency and percentages, plus the cell styles and theme colors that match our brand guidelines. • Du...

I have a multi-sheet Excel project that starts with a plain text file and ends with dynamic dashboards. I need you to take the raw content, import it, and turn it into a fully structured, well-formatted workbook that is ready for executive review. Here is the flow I follow every month and want automated or documented so anyone can repeat it: • Open the starter workbook, rename it to the current reporting period, and save it to the network location I will supply. • Import the supplied text file then convert it into a properly sized Excel table. • Apply my preset formatting rules—this includes conditional formatting for key metrics, custom number formats for currency and percentages, plus the cell styles and theme colors that match our brand guidelines. • Du...

I need a single Excel workbook that lets me see every project at a glance while still giving each project manager a personalised view. The opening tab will act as a master register containing all projects. From that master list, data should flow automatically into individual tabs—one tab per PM—so they only see the projects assigned to them. For every project I have to capture: • assigned project manager • employees on the job • core project details (name, client, start & end dates, status, and any notes) The current spreadsheet and additional details will be provided upon hire. Drop-downs, conditional formatting, simple formulas or Power Query should keep everything synchronised; use VBA only if it truly simplifies the workflow. The file should...

I run an interpreting and translation agency and I want a polished invoice template that works seamlessly in both Microsoft Excel and Google Sheets. Once complete, I should be able to copy-paste raw data straight from our CRM (sample tabs provided) and have the invoice populate instantly without touching any formulas. Key functions I need baked in: • Auto-formatting so the file always prints cleanly in landscape, no matter how many service lines we add. • Dynamic column handling—if I insert extra columns the header must stay intact, and I can hide or show selected columns with a single click. • A dedicated import zone that matches the CRM export fields, ensuring data drops into the correct spots every time. Design requirements: • Custom template styling ...

I need an Excel automation solution to streamline the summarization and reporting of demand data. Requirements: - Automate data summarization and reporting tasks - Use of tables for summary reports Ideal Skills and Experience: - Proficiency in Excel, especially in automation tools like VBA - Experience in data analysis and reporting - Ability to create structured and well-organized tables Looking for a freelancer who can deliver efficient and reliable automation.

I have a raw CSV that needs to become a streamlined analysis workbook. The goal is to bring the data into Excel, shape it into a named table, and layer on the tools I use most—Advanced Filters, Conditional Formatting, and PivotTables—so I can slice, summarise, and visualise the information quickly. Here’s the flow I want to see inside the final file: • Import the CSV and convert it to a properly sized, named table. • Build an Advanced Filter (criteria on a separate sheet) so I can isolate records by multiple fields. • Apply a multi-level sort to any filtered view to keep results in logical order. • Add conditional formatting that highlights key exceptions or trends; rules should be easy for me to adjust later. • Demonstrate converting th...

I need a single Microsoft Excel workbook that already contains a full, properly scaled map of the United States—every state, every county. Inside that file I want to be able to: • Fill or change the color of any county so I can instantly show where each customer is located as we add new business. • Add, remove, or recolor states automatically when several counties inside them are selected. • Place one clearly visible annotation that identifies our main office; I should be able to move or rename that label myself. My source data will arrive as standard .xls or .xlsx spreadsheets, so the map has to accept county names or FIPS codes from those sheets and update the colors with as little manual work as possible (a macro, Power Query, or any Excel-native method you ...

I have a collection of Notepad files that contain mixed data—snippets of text, numbers, and the occasional alphanumeric code. Your task is to transfer every line into a clean Excel workbook, observing a few house-style rules that I will cover during a brief onboarding call. The spreadsheet will need custom cell formatting rather than a simple copy-paste: dates must read correctly, numerical strings should remain as numbers (not text), and certain text segments need a light wrap so nothing is hidden from view. I’ll supply clear written guidelines with screenshots, but no pre-built template; you’ll build the sheet from scratch based on those instructions. Accuracy is everything here. I’ll run random spot-checks once the first set is complete, and any inconsisten...

In one column I have repeating state codes—WA, WA, SA, SA, ACT, ACT, WA, WA—and I simply need an automatic way to display each code once. The duplicates should disappear (no highlighting, no counting) and the tidy, de-duplicated list must appear in a new column right beside the source data. A neighbouring column already holds the running total of uniques (currently 3 for WA, SA, ACT), so your solution only has to focus on extracting the distinct values themselves. Please provide a single formula (or a compact, copy-ready combination of formulas) that I can drop into the worksheet without restructuring anything else. It should work regardless of future changes in the original column’s length. If different Excel versions require slightly different syntax, include each v...

Bitte melde dich an oder Loge dich ein um Details zu sehen.

Very straightforward task. Create an Excel table based on the draft I'll provide. Need to add simple filters to some columns and separate columns into different sections, which could be expanded or collapsed upon clicking on them. It's important that if collapsed the title of the section is still visible so I can understand which section is hidden and I should be able to expand it once I click on the title of the "hidden" section.

I have a set of raw financial records that must be entered into Excel and arranged strictly by date. I will forward the source files (PDF statements and the occasional CSV download); every transaction line needs to be keyed in, totals verified, and the final sheet sorted chronologically from the oldest entry to the most recent. I’ll also provide a concise style guide covering number formats, header rows, cell styles, and a colour code that highlights income versus expense. Please follow those custom formatting instructions so the workbook is client-ready the moment it lands back in my inbox. Because these files contain confidential account figures, I need someone who treats data security as non-negotiable and is willing to delete local copies once the project closes. A quick turnar...

Looking for an experienced freelancer to build a formula-based Excel (.xlsx) tool that generates EDIG@S EDIFACT NOMINT messages for gas nominations. Requirements • Generate NOMINT messages (single & multi-point) • Correct EDIG@S segments: UNH, BGM, DTM, NAD, SEQ, LOC, QTY, RFF (opt), UNT • Automatic and correct UNT segment count • Excel formulas only for all EDIG@S logic (no VBA for message generation) • Optional VBA only to export the generated text to a .edi file • Clean input/output separation, ops-friendly Nice to have • Read-only viewing of CONTRL / APERAK • Simple ALLOC generation (daily only) Deliverables • Excel file + brief instructions • Sample NOMINT output MUST HAVE SKILLS • Hands-on EDIFACT / EDIG@S expe...

We are hiring an experienced professional to build Excel-based strategy and planning tools. These tools will be used for business planning, analysis, and decision-making. What You Will Develop You will build Excel tools and frameworks, such as: Planning and evaluation tools Scoring and comparison models Tracking and analysis templates Structured decision-support frameworks

We are hiring an experienced Excel financial modeling expert to develop a set of advanced financial Excel models for internal business use. The work requires strong financial logic, accuracy, and professional Excel structuring. This is not data entry or basic Excel work. Only apply if you have built serious financial models before. What You Will Develop You will build multiple Excel financial models, such as: Integrated financial models (Profit & Loss, Balance Sheet, Cash Flow) Budgeting and forecasting models Cash flow and runway models Unit economics models (LTV, CAC, break-even) Valuation and scenario analysis models Each model will be a complete, stand-alone Excel file. Deliverables (Per Model) Excel file (.xlsx) 5–10 structured worksheets Clear input and output sections...

I need an Excel dashboard to visualize operational data, specifically focusing on procurement across different companies. The dashboard will be used for data visualization purposes. The data set is already created, along with some ref pivot tables for IDEA. just need Help with the visualization of the content along with a few addons based on requirements. The data set talks through the Procurement plans from different global regions for the next 3 Financial years with some key metrics needed to be captured for easy user/team viewing of the plan and progress Requirements: - Ability to create visually aesthetic, interactive and user-friendly Excel dashboards - Expertise in data visualization techniques - Experience with operational data analysis - Ideal Skills and Experience: - Strong a...

I have an Excel sheet that already contains options prices, futures prices and strike prices laid out in raw tables. I need a second workbook (or a re-structured copy of the same one) that automatically recognises the at-the-money (ATM) strike, computes the corresponding straddle value, and shows the ratio of that straddle to the current futures price. The file should refresh these three metrics instantly whenever I paste new daily data. The layout I have in mind is simple: source data on one tab, clean summary on another. Formulas are fine; a small VBA routine or Power Query step is welcome if it keeps the workbook fast and eliminates manual intervention. Deliverables • A working .xlsx file with clearly labelled input and output areas • Built-in calculations for:  1...

I have a single CSV file that holds all my contact data—name, email, and phone number—and I need it converted into a clean, ready-to-use Excel workbook. The records should appear alphabetically by name, with no extra columns beyond those three essentials. Please apply simple, professional touches such as bold header rows so everything is instantly readable when I open the file in Microsoft Excel. The final deliverable is a .xlsx file that faithfully reproduces every contact from the original CSV while respecting the order and basic formatting notes above.

I need a clean, fool-proof Excel workbook that lets me roster my team by simply typing each person’s start and finish times for every shift. As soon as I enter those times, the sheet must calculate the exact hours worked that day and keep a running total for the week, all without any extra clicks or macros. What has to be captured • Start time and end time for every shift • Hours worked, calculated automatically • A live weekly total for each team member Core requirements • Manual time entry—plain cells where I can type or paste times. • Formulas only (no VBA), compatible with Office 365 and standard desktop Excel. • Clear, protected formula areas so no one overwrites the logic by mistake. • Straightforward layout I can duplica...

I need help to efficiently pair PO numbers with accounts in Excel. Currently, I do this manually using Excel functions, and I'm looking for a more effective solution. Key Tasks: - Analyze current manual process - Develop a streamlined method, potentially using Excel functions, VBA, or other tools Ideal Skills: - Proficiency in Excel, including advanced functions and VBA - Experience in process optimization - Attention to detail and problem-solving skills Looking for a solution that saves time and reduces manual effort.

I'm looking for an Excel calendar template designed specifically for daily scheduling and planning. The template should be user-friendly and customizable, allowing me to efficiently manage my daily tasks and activities. Requirements: - Daily format covering 365 days - Customizable fields for task descriptions, time slots, and priority levels - Clean, organized, and visually appealing layout - Ability to easily add, modify, and track tasks Ideal Skills and Experience: - Proficiency in Microsoft Excel - Experience in creating customizable templates - Strong design skills for a professional appearance - Attention to detail and user experience Please include samples of previous Excel templates you've created.

I have two Excel report sheets and need help merging and comparing data between them. The final output should be a clean, automated dashboard that presents the results clearly.

I have a contacts worksheet in Google Sheet for Mac that often contains more than one row with the same email address. What I need is a lightweight macro I can trigger from a button or shortcut that will: • scan the sheet, • find every email that appears more than once, and • highlight each duplicated entry in red—nothing is to be deleted automatically. The highlight-only approach lets me decide, on a case-by-case basis, which full contact row to keep and which to remove. Aside from the red fill on duplicates, the script must leave every other part of the workbook untouched. Please deliver a ready-to-use VBA module (or an entire macro-enabled workbook if you prefer) that works smoothly in current Mac Google Sheets, along with a short set of installation and usag...

I need three clean, easy-to-reuse templates built in Excel: • A hiring sheet that already has columns for candidate details and position, space to log each interview’s schedule and feedback, and a final section where we record the hiring decision plus any offer details. • A weekly time sheet with rows for employee working hours, break times and any overtime captured automatically. Simple formulas that total the regular and OT hours are a must. • A productivity-hours tracker for my teachers so I can see, at a glance, how many hours each one spends on class time, prep, grading or other tasks; totals should roll up per teacher and per week. * petty cash sheet - incoming money and expenditure items and showing balance as on date * attendane sheet, where i can automati...

I’m looking to have a single, well-structured Excel workbook that lets me stay on top of my raw-materials inventory at a glance. The sheet needs to record every item, its current stock level. Inlcuding stock entry and exit at a complex level. Here’s what I expect from the finished file: • A clean input area where I can add, edit, or deactivate materials without breaking formulas • Automatic stock-on-hand calculations and clear visual cues for low or out-of-stock items • Location fields that accept only valid entries (drop-downs or similar data-validation) so mistakes are minimized • A summary view that aggregates totals and lets me filter or sort by material type, location, or status I’m comfortable updating raw data; what I need is the underlying st...

My workbook already contains a sizable VBA routine that keeps our day-to-day data flowing, yet it now throws occasional errors, runs slower than it should, and is missing a few purpose-built functions that would save even more time. I need the codebase tuned rather than rebuilt: squash the bugs, streamline the logic so it executes faster, and insert several new user-defined functions that handle repetitive steps I still perform manually. You will receive the current file with full source code and a short list of the extra tasks these new functions must cover. Please keep the structure familiar, add clear comments, and avoid breaking existing naming conventions so future tweaks remain simple. Deliverables • Clean, fully tested VBA module(s) with all errors resolved • Perform...

I’m looking to have a single, well-structured Excel workbook that lets me stay on top of my raw-materials inventory at a glance. The sheet needs to record every item, its current stock level. Inlcuding stock entry and exit at a complex level. Here’s what I expect from the finished file: • A clean input area where I can add, edit, or deactivate materials without breaking formulas • Automatic stock-on-hand calculations and clear visual cues for low or out-of-stock items • Location fields that accept only valid entries (drop-downs or similar data-validation) so mistakes are minimized • A summary view that aggregates totals and lets me filter or sort by material type, location, or status I’m comfortable updating raw data; what I need is the underlying st...

I have 50 pages of information locked in PDF documents that I now need clearly entered into a single Excel workbook. Nothing fancy—just clean, error-free data that mirrors what you see on each page. Accuracy matters more than speed; a small typo in one cell could throw off the entire file, so I need someone who is comfortable double-checking their own work and flagging anything that looks ambiguous. Once you receive the PDFs, please extract every data point and lay it out row-by-row in Excel so I can sort, filter, and run formulas later. If a page has obvious column structure, keep that structure intact. If it’s a paragraph or form, split the content logically across columns (I can clarify edge cases as they come up). No special template is required—the standard grid is ...

Project Title: Daily Data Entry for Diesel and Cash Reports in Excel Project Description: I am looking for a freelancer fluent in Arabic to assist with daily data entry tasks using ready-made Excel templates. The work involves: - Diesel Report: Extracting data from images shared on a WhatsApp group, including equipment codes and the number of liters. - Cash Report: Recording details such as the cash holder, purpose, and amount based on provided invoices. Key Requirements: - Proficiency in Arabic. - Experience with Excel and accurate data entry. - Availability to work approximately one hour per day, six days a week. What will make this run smoothly • Native-level Arabic reading and typing • Solid Excel skills (formulas are built in; accuracy in data entry is critical) &bu...

I’m looking to have a single, well-structured Excel workbook that lets me stay on top of my raw-materials inventory at a glance. The sheet needs to record every item, its current stock level. Inlcuding stock entry and exit at a complex level. Here’s what I expect from the finished file: • A clean input area where I can add, edit, or deactivate materials without breaking formulas • Automatic stock-on-hand calculations and clear visual cues for low or out-of-stock items • Location fields that accept only valid entries (drop-downs or similar data-validation) so mistakes are minimized • A summary view that aggregates totals and lets me filter or sort by material type, location, or status I’m comfortable updating raw data; what I need is the underlying st...

I need a simple, reliable VBA macro that scans an Excel workbook and replaces specific words only—no pattern matching or regex, just straight one-to-one swaps. The list of target words and their replacements will already be laid out for you across multiple columns in a dedicated sheet; the macro should read directly from that sheet, loop through the rest of the workbook, and make the substitutions wherever they occur. Key points you should build in: • Action: word-for-word replacement (this is a data-processing task, not data entry or extraction). • Source list: multiple columns on a single sheet; assume column A holds the words to find and column B the words to insert. • Scope: apply changes to every cell in every sheet unless I later flag specific sheets to ex...

Several hundred rows of records are currently trapped in a mix of PDF documents and image files. I need every line transferred into a clean, well-structured Excel workbook within the next 2–3 days. Here is what the job entails: • Transcribe all data from the supplied PDFs and images into a single Excel file, keeping every field in its correct column. • Remove any duplicate rows, fix alignment or date/number inconsistencies, and delete entries that are clearly incomplete. • Apply quick, readable formatting—bold headers for every column and light color-coding to highlight key sections or totals—so the sheet is immediately understandable. • Insert basic formulas where relevant: SUM ranges for totals, IF statements for simple checks, and VLOOKUPs t...

I have a set of raw survey responses that must be brought into a single, well-structured Excel workbook ready for descriptive statistical analysis. The job starts with straightforward data entry—copying and pasting figures from several source files—then moves on to tidy formatting, consistent cell styles, and the creation of clear headers so every column can be understood at a glance. Once the data is clean, I need you to build the formulas that will drive the analysis: means, medians, modes, standard deviations, response counts, and percentage breakdowns across key demographic columns. A summary sheet should pull these measures together automatically, updating whenever new data is added. Deliverables • Master worksheet containing the cleaned survey data, free of blanks,...

I need a lightweight Excel-based “project program” that I can open, understand and tweak without outside help. Everything—from the way data is entered to the formulas that calculate results—has to stay clear, unlocked, and easy to adjust. Here’s the feel I’m after: I type project details in one place, watch totals or status indicators update instantly, and know I can add rows or columns later without breaking anything. Macros, pivot tables or flashy charts are fine only if they remain transparent; the priority is simplicity and self-sufficiency. What I’d like back from you is an .xlsx file with: • A clean data-entry sheet • Built-in calculations clearly labeled or commented • A concise note or inline comments pointing out whe...

I’m building a streamlined payroll workbook in Excel that handles everything in one place—from manual attendance entry right through to the final net-pay figure. The file must automatically calculate basic salary, overtime, incentives, standard and optional deductions (PF, ESI, TDS), then roll these up into clear per-employee and month-end summaries. Key expectations • Robust formulas or VBA (your call) that protect against common data-entry errors and flag them instantly. • A clean, intuitive attendance tab designed for manual input; once entries are made, every other sheet should update without further touch-points. • Consolidated reports that let me see totals, breakdowns and variances at a glance. Deliverables 1. Finished Excel workbook with all...

Project Overview We are building an Excel-based automation and reporting system to track execution progress and speed across two parallel workflows: Listing optimization: - PPC advertising pipeline - The system must show status, velocity, bottlenecks, and readiness on ASIN and Cluster level, both internally and client-facing. This is a system-level automation project, not a simple dashboard. What the System Must Do: At any time, the reporting must clearly answer: - Where do we stand overall? - Which clusters are blocked or slow? - How fast is execution moving? - Is Listing or PPC the bottleneck? - How has progress changed vs yesterday / last week / last month? Core Scope (High-Level): - Derive execution statuses from raw Excel data - Track daily historical snapshots (append-only) - Cal...

Monthly sales figures from several CSV exports have to be transformed into clear, actionable insights in Excel. The core of this Excel-based project is data analysis, not general spreadsheet creation or macro automation, so the focus stays on cleaning raw sales data, structuring it, and presenting digestible results. Scope of work • Import and consolidate all source files into a single, well-organized workbook. • Remove duplicates, handle missing values, and standardize date and currency formats. • Build dynamic pivot tables, slicers, and charts that let me filter by product line, region, and time period. • Generate a concise dashboard highlighting total revenue, average order value, month-over-month growth, and top-performing SKUs. • Provide a short writt...

Monthly sales figures from several CSV exports have to be transformed into clear, actionable insights in Excel. The core of this Excel-based project is data analysis, not general spreadsheet creation or macro automation, so the focus stays on cleaning raw sales data, structuring it, and presenting digestible results. Scope of work • Import and consolidate all source files into a single, well-organized workbook. • Remove duplicates, handle missing values, and standardize date and currency formats. • Build dynamic pivot tables, slicers, and charts that let me filter by product line, region, and time period. • Generate a concise dashboard highlighting total revenue, average order value, month-over-month growth, and top-performing SKUs. • Provide a short writt...

I keep my monthly figures in a local Excel workbook and now need a clear, interactive dashboard that focuses on one core KPI—cash flow. I can handle basic formulas, but I’d like your expert walk-through on structuring the data model, choosing the right visuals, and automating refreshes when I drop in an updated file. No API or database connections are involved; every source stays on my machine. Here’s how I picture our collaboration: • A short call or screen-share where you review my current sheet, outline a clean data layout, and map out the cash-flow metrics. • Hands-on build of the dashboard inside Excel using PivotTables (or Power Pivot if you feel it adds value), slicers, conditional formatting, and clear charting. • Simple refresh logic so when ...

Excel Macro Conversion & Redesign (Windows → Mac / Excel or Numbers) I am looking for an experienced Excel expert to adapt an existing Excel file with macros, originally built on Windows, so it can be used seamlessly on Mac or alternatively converted to Apple Numbers, while preserving full functionality. Scope of work: • Adapt or rewrite Excel VBA macros so they work perfectly on Mac Excel, or provide a reliable solution using Apple Numbers • Ensure all formulas, calculations, and automated processes work exactly as intended • Optimize performance and stability across platforms • Redesign the layout to make the document more modern, visually appealing, and user-friendly • Maintain and properly integrate existing images, charts, and formatting Proje...

I have a set of raw survey responses that must be brought into a single, well-structured Excel workbook ready for descriptive statistical analysis. The job starts with straightforward data entry—copying and pasting figures from several source files—then moves on to tidy formatting, consistent cell styles, and the creation of clear headers so every column can be understood at a glance. Once the data is clean, I need you to build the formulas that will drive the analysis: means, medians, modes, standard deviations, response counts, and percentage breakdowns across key demographic columns. A summary sheet should pull these measures together automatically, updating whenever new data is added. Deliverables • Master worksheet containing the cleaned survey data, free of blanks,...

I need three clean, easy-to-reuse templates built in Excel: • A hiring sheet that already has columns for candidate details and position, space to log each interview’s schedule and feedback, and a final section where we record the hiring decision plus any offer details. • A weekly time sheet with rows for employee working hours, break times and any overtime captured automatically. Simple formulas that total the regular and OT hours are a must. • A productivity-hours tracker for my teachers so I can see, at a glance, how many hours each one spends on class time, prep, grading or other tasks; totals should roll up per teacher and per week. * petty cash sheet - incoming money and expenditure items and showing balance as on date * attendane sheet, where i can automati...

Project Title: Daily Data Entry for Diesel and Cash Reports in Excel Project Description: I am looking for a freelancer fluent in Arabic to assist with daily data entry tasks using ready-made Excel templates. The work involves: - Diesel Report: Extracting data from images shared on a WhatsApp group, including equipment codes and the number of liters. - Cash Report: Recording details such as the cash holder, purpose, and amount based on provided invoices. Key Requirements: - Proficiency in Arabic. - Experience with Excel and accurate data entry. - Availability to work approximately one hour per day, six days a week. What will make this run smoothly • Native-level Arabic reading and typing • Solid Excel skills (formulas are built in; accuracy in data entry is critical) &bu...

I have a steady stream of digital files—mostly PDFs and Word documents—containing a mix of numbers and text that need to be transferred into structured Excel workbooks. Your job is straightforward but detail-oriented: copy-type the information exactly as it appears, double-check for accuracy, and make each sheet easy to read by adjusting cell sizes and fonts where necessary. You’ll work remotely and at your own pace, yet I do need each assigned batch turned around promptly so that the larger project keeps moving. I’ll share clear file naming conventions and a simple template to keep everything consistent. The completed Excel files must come back error-free, neatly formatted, and ready for immediate use. If you’re comfortable juggling both numeric and text ...

I need a streamlined way to record every inward and outward movement of stock so that my running balance is always accurate. The only details I want captured are the product name and its quantity; anything more slows my team down. My preference is to work in MS Excel because everyone here already uses it daily, yet the final sheet must be formatted so it can feed data into our existing custom billing software that issues GST invoices and e-way bills for wholesale orders. A clean CSV export or a lightweight macro that pushes the figures across will do the job—whichever you feel is the quickest to maintain. Deliverables • A ready-to-use Excel workbook with clearly separated inward, outward, and live-stock sheets, plus built-in checks that flag negative or mismatched quanti...

I have an Excel workbook that needs to turn whatever I type into structured, print-ready Reports. The idea is simple: I enter data on one sheet and, through well-planned formulas (and any clever use of named ranges or dynamic print areas you think is best), the file instantly reshapes that information into a polished layout that is ready to hit Ctrl-P without further tweaks. Content focus The Reports are meant to hold Documentations, yet I want enough flexibility so that later I can extend them to other sections such as Sales data, Employee performance or Inventory levels if needed. Please keep the formulas and any conditional formatting readable because I will maintain the file after your hand-off. What I expect as deliverables • A single .xlsx template with all formulas, page ...

I’m starting a new project and looking for support on building a structured Excel model and a short PowerPoint deck. Raw data will be provided. I’ll need help mainly with setting up formulas, XLOOKUPs (when required), and applying specific criteria that will be shared. An example of how the Excel model should look will be provided, but please note that the example is high-level, while this project will require a less detailed with 5 countries only. In addition, a 5-page PowerPoint presentation is required. A sample structure will be shared to guide the layout and flow. Both the Excel model and PowerPoint should follow the provided examples closely. I’m happy to share samples and discuss the scope further before starting. Once agreed, the project will kick off immediate...

I’m starting a new project and looking for support on building a structured Excel model and a short PowerPoint deck. Raw data will be provided. I’ll need help mainly with setting up formulas, XLOOKUPs (when required), and applying specific criteria that will be shared. An example of how the Excel model should look will be provided, but please note that the example is high-level, while this project will require a less detailed and granular model. In addition, a 5-page PowerPoint presentation is required. A sample structure will be shared to guide the layout and flow. Both the Excel model and PowerPoint should follow the provided examples closely. I’m happy to share samples and discuss the scope further before starting. Once agreed, the project will kick off immediately ...