Excel Macros Jobs

I’m looking for help building an Excel-based staff overtime dashboard. I’ve already started the structure and data, but I need someone to develop and connect everything properly. Here’s what I have so far: An Excel workbook I use for managing staff overtime, with two main sheets: Page 1 – Overtime records, with reference number generation (already working) Page 2 – Source data for each staff member What I need your help with: Build out a **Dashboard** that includes: Filters to select specific staff and time ranges Summary KPIs (e.g. total hours worked, overtime % of contract, double shifts flagged, etc.) A drill-down table to display overtime entries by staff and date A highlight or flag when overtime exceeds 30% of contractual hours A Filter to...

My work responsibilities are expanding, and Excel is at the heart of nearly every new task that lands on my desk. I want to move from merely competent to genuinely advanced, so the focus is on practical, job-ready techniques rather than academic theory. Expect to guide me through topics like nested formulas, dynamic arrays, data analysis with Pivot Tables or Power Query, and light-weight VBA automation where it will save time. We will meet online, share screens, and tackle anonymised files pulled straight from my day-to-day workload. After each session I need a concise cheat-sheet and an annotated version of the workbook so I can practise and reference later. Deliverables • Live, hands-on training sessions (recorded for replay) • Example workbooks showcasing each concep...

We are seeking an experienced Excel professional to design and build a finance dashboard that provides clear, actionable insight into our business performance. The dashboard will primarily visualise a range of data, with a strong emphasis on monthly trends and decision-ready reporting for senior management. Scope and Purpose: • The primary income source to be visualised is business revenue. • The dashboard should clearly show monthly income and expense trends, with the ability to identify movements, patterns, and variances over time. • Senior management has reviewed and approved the proposal and costing and has requested additional data views to be incorporated. Data Sources: The dashboard will draw from three systems: • MYOB – financial data (income and expens...

I have a single workbook that holds our current inventory data. I need that data reorganised into two clearly labelled sheets, each grouped by stock level. Alongside the split, each sheet must show the average stock for its level so I can spot over- or under-stocked items at a glance. You’ll be working inside Excel only. Please rely on native features—formulas, pivot tables or Power Query, whichever you prefer—so the result stays fully editable. Data validation rules already in the file must remain intact. Deliverables • Sheet 1 – items at or below the reorder threshold, plus a line (or cell) displaying the average stock for this low-level group. • Sheet 2 – items above that threshold, again with the average stock figure. • The updated w...

I have between 500 – 1,000 records that need to be copied or typed into a clean, well-structured table in Microsoft Excel. Accuracy tops the priority list: every cell must match the source exactly, follow consistent formatting, and pass a quick logic check before delivery. Speed matters too. I’m ready to hand you the source material today and would like the completed file back without delays, so only take the project if you can begin right away and keep communication open while you work. Deliverables • A single .xlsx file containing one clearly labeled worksheet with the full table of 500–1,000 rows, headings properly formatted. • All required fields populated, no stray spaces, duplicates, or mismatched data types. • Final file returned by the d...

I have between 500 – 1,000 records that need to be copied or typed into a clean, well-structured table in Microsoft Excel. Accuracy tops the priority list: every cell must match the source exactly, follow consistent formatting, and pass a quick logic check before delivery. Speed matters too. I’m ready to hand you the source material today and would like the completed file back without delays, so only take the project if you can begin right away and keep communication open while you work. Deliverables • A single .xlsx file containing one clearly labeled worksheet with the full table of 500–1,000 rows, headings properly formatted. • All required fields populated, no stray spaces, duplicates, or mismatched data types. • Final file returned by the d...

I have a spreadsheet holding well over 100,000 mixed-type records—text fields, numeric columns, a few calculated cells—and it needs to be brought to a usable state. Right now the file is a single Excel workbook; no separate databases or flat files are involved. Two things must happen: • Data entry – several columns are still blank or contain placeholder codes that need to be filled from a secondary sheet I will supply. • Data cleaning – duplicates removed, inconsistent text normalised, numeric outliers flagged, and all formulas verified so totals match source balances. The finished workbook should open quickly, pass a spot-check for accuracy, and be free of hidden errors (broken links, stray formats, unused styles). Feel free to use Power Query, VBA, ...

My work responsibilities are expanding, and Excel is at the heart of nearly every new task that lands on my desk. I want to move from merely competent to genuinely advanced, so the focus is on practical, job-ready techniques rather than academic theory. Expect to guide me through topics like nested formulas, dynamic arrays, data analysis with Pivot Tables or Power Query, and light-weight VBA automation where it will save time. We will meet online, share screens, and tackle anonymised files pulled straight from my day-to-day workload. After each session I need a concise cheat-sheet and an annotated version of the workbook so I can practise and reference later. Deliverables • Live, hands-on training sessions (recorded for replay) • Example workbooks showcasing each concep...

I’m building a simple yet reliable system to log and analyze my trades, and I want the entire workflow contained in a single Excel file. The sheet has to let me enter trades in both the stock and crypto markets, capturing three fields only: the trade date, the ticker or symbol, and the profit or loss for that position. From there, the file should automatically calculate my running totals, my average profit or loss per trade, and the amount that I can gained or loss, and the percentage return so I can see how efficiently I’m trading over time. Please structure the workbook so data entry is friction-free—clean column headings, drop-down validation for asset type if helpful, and clearly separated summary metrics. All formulas need to be transparent and easy to audit; no hid...

I’m building a simple yet reliable system to log and analyze my trades, and I want the entire workflow contained in a single Excel file. The sheet has to let me enter trades in both the stock and crypto markets, capturing three fields only: the trade date, the ticker or symbol, and the profit or loss for that position. From there, the file should automatically calculate my running totals, my average profit or loss per trade, and the amount that I can gained or loss, and the percentage return so I can see how efficiently I’m trading over time. Please structure the workbook so data entry is friction-free—clean column headings, drop-down validation for asset type if helpful, and clearly separated summary metrics. All formulas need to be transparent and easy to audit; no hid...

I need an Excel-based automation that turns our raw company KPI data into clear, refreshable reports. The workbook should import or paste monthly updates, process them automatically, and present production-efficiency metrics in a dashboard that managers can print or export to PDF in one click. Here’s the flow I have in mind: • Raw data sheet where I can drop each month’s figures. • Behind-the-scenes formulas / Power Query / VBA (whatever you find most efficient) that clean, aggregate, and store the numbers. • A dynamic report tab with charts, conditional-format tables, and traffic-light indicators showing how production efficiency is trending month-over-month. Please keep the file self-contained—no external add-ins—so anyone with standard Exce...

I need a concise SAP GUI scripting routine, driven from Excel VBA, that opens ME9L, loops through a pre-populated list of purchasing documents and prints each one to PDF automatically. Every file must be saved in a local folder as ; if the same name is produced again the macro should append an incremental sequence number so nothing is overwritten. Environment details you will be working with: SAP GUI 770 on Windows and the latest desktop build of Microsoft Excel. I already have a small proof-of-concept script that logs in and reaches ME9L, so you can extend rather than start from scratch. The finished workbook should let me paste a list of document numbers, click a single button, and watch the PDFs land in the target directory with the defined naming rule. Please share at least one previ...

I have a workbook with four to five related sheets and need a set of advanced formulas that will pull, process, and summarise data exactly where I need it. Some of these formulas must reach across the sheets—for instance, a lookup drawing values from a master sheet—while others can remain self-contained within their own tab. You’ll start with the file as it stands today, review my current structure, then build or refine formulas so that: • cross-references update instantly when source data changes, • stand-alone calculations stay protected from accidental overwrites, and • every function remains clear enough that I can maintain it later without hunting through nested syntax. I expect the final deliverable to be the updated workbook plus a brief,...

I need an Excel expert for data analysis. Your task will involve using advanced formulas and functions to help me analyze data efficiently. Key Requirements: - Create and optimize complex formulas for data analysis. - Automate data analysis tasks to save time. - Provide insights and summaries from the data. Ideal Skills: - Proficiency in Excel, especially in data analysis. - Experience with a variety of Excel functions. - Strong analytical skills and attention to detail. Looking forward to your bids!

I need an experienced Excel VBA developer to automate repetitive tasks. Ideal skills and experience: - Proficient in Excel and VBA - Experience in task automation - Ability to create and manage user forms - Knowledge of integrating VBA with other applications, especially Outlook and Access Please provide examples of previous work.

I’ve built an Excel 365 workbook that tracks three health, safety and environmental metrics—TRIR, LTIFR and MCFR—but the totals are still being tallied manually. I need you to insert the correct arithmetic formulas so each of those columns automatically produces an accurate running Sum every time new data is entered. The sheet is already laid out; what’s missing is the logic behind it. Please: • Add reliable SUM formulas to each of the three metric columns, making sure they keep working even when rows are inserted, deleted or filtered. • Test the file to confirm that totals update instantly for new entries. • Keep cell referencing clear and, if you see a cleaner way to structure the ranges (tables, named ranges, structured references), feel free...

I have a large batch of product photos—well over two hundred—that need clear, consistent file names. All of the images relate to items we sell, and I don’t yet have a fixed naming rule. I’d like you to look at the range of products, suggest two or three practical naming-convention options (e.g. SKU-based, descriptive, or hybrid), agree on the best one with me, then rename every image accordingly. Once the files carry the new names, I also need an Excel sheet completed. Each row should include at minimum: the new filename, the product title, a short description, and any SKU or reference code that appears on the packaging. I will supply the raw photos plus any existing data we have so you can cross-check details. The job is finished when I receive: • A fo...

I need a clean, reliable Excel workbook that lets me track up to five production lines hour-by-hour. On one sheet I’ll manually enter, each hour, the line number, Units Produced, Downtime occurrences or minutes, Quality issues, and the SKU we’re running. The file must instantly calculate each line’s current units-per-hour and its attainment versus the hourly target I’ll set. A separate dashboard should present the numbers clearly: • Large numeric displays that show each line’s live UPH, its attainment percentage, and a room-wide total. • Simple bar or line charts so supervisors can see how performance is trending through the shift. • Conditional formatting that flips to green when a line is on or above pace and red when it falls behind (I&rsquo...

Title: Excel Executive Dashboards, Ratios & Decision Analytics (General Insurance) Description I already have an Excel financial model with: Trial balance Mapped Profit & Loss, Balance Sheet, and Cash Flow Budget and prior-year data I am looking for an Excel expert to build dynamic executive dashboards and analytics that automatically update every time the financial figures change. This is not a one-off report, but a repeatable decision-making tool for management and board review. Scope Board-ready Excel dashboards One-page Financial Indicators & Highlights summary KPI tiles with Red / Amber / Green indicators Insurance and financial ratios (to be created by developer) Early warning indicators and trend deterioration flags Profitability influencers (revenue, clai...

I'm looking for an Excel expert to assist with a one-time data entry job. You'll create PPM checklists and DDC point schedules for a BMS project. Requirements: - Proficiency in Excel, especially in data entry - Knowledge of BMS/DDC is preferred but not mandatory - Ability to work quickly and accurately I have a reference document to guide you. Ideal Skills & Experience: - Advanced Excel skills - Attention to detail - Experience with BMS/DDC systems

I need a streamlined Excel-based system that treats our service inventory the same way retailers track stock—only my “items” are scheduled maintenance jobs. Your task is to build and keep up a spreadsheet that shows, at a glance, every upcoming and completed maintenance task across the company. Here’s what matters most to me: • Each row represents a single maintenance task, clearly stamped with its status (pending, in-progress, done). • Filters and pivot-style summaries let me slice the data by location, equipment type, or technician without extra clicks. • Color-coded alerts highlight anything overdue or scheduled within the next seven days. I am already comfortable importing raw data from our service portal, so the workbook must accept eas...

I’ve got a set of tables sitting in one Excel workbook that need to be moved into a different Excel file. It’s a straightforward copy-and-paste job, but I need every cell, formula, and format to arrive in the destination sheet exactly as it appears now—no broken references, merged-cell mishaps, or lost conditional formatting. I’ll send you the source workbook along with a blank destination file that already has the target sheet names in place. Your task is to copy each table into its corresponding sheet, confirm that the row and column dimensions match, and save the finished file back to me. Deliverable: • Completed destination Excel workbook with all tables accurately transferred and fully functional. I’m ready to hand over the files as soon as you&rs...

I’ve got a set of tables sitting in one Excel workbook that need to be moved into a different Excel file. It’s a straightforward copy-and-paste job, but I need every cell, formula, and format to arrive in the destination sheet exactly as it appears now—no broken references, merged-cell mishaps, or lost conditional formatting. I’ll send you the source workbook along with a blank destination file that already has the target sheet names in place. Your task is to copy each table into its corresponding sheet, confirm that the row and column dimensions match, and save the finished file back to me. Deliverable: • Completed destination Excel workbook with all tables accurately transferred and fully functional. I’m ready to hand over the files as soon as you&rs...

I have an Excel template waiting to be filled with a combination of text and numerical fields. All source materials will be supplied the moment we start, and I’ll include clear column headings alongside a brief example row so you know exactly where each value goes. What I need from you is straightforward: transcribe the mixed data accurately, keep the cell formats intact, and double-check totals or calculated columns to ensure nothing slips through. A short progress update part-way through will help us spot any issues early. Deliverables: • Fully populated Excel workbook • Quick note highlighting any unreadable items or ambiguities you encounter If you’re comfortable navigating Excel’s basic functions (simple formulas, data validation, autofill) and...

I have a multi-section Microsoft Word (.docx) file that has drifted out of sequence over time. The task is simple: place every section in strict chronological order without touching the text itself. No content editing, no proofreading—just reorganizing. Deliverables • The original document, saved as .docx, with all headings and sub-headings arranged chronologically • An updated table of contents (if present) reflecting the new order • All existing formatting, comments, and tracked changes preserved exactly as they are Once you’re done, send back the reordered file and let me know if you ran into anything that needs my attention. Quick turnaround is appreciated; just share your timeframe when you place your bid.

We are looking for a skilled freelancer to enhance the formulas in our spreadsheet summary tab. The goal is to ensure that our summary calculations remain accurate and robust, even when changes occur in the other sheets. The ideal candidate will have experience with Excel or Google Sheets and a strong understanding of formula creation and troubleshooting. If you have a knack for making formulas resilient and effective, we'd love to hear from you!

I have several large, mainly numerical datasets that first need meticulous data entry and thorough cleaning. Once everything is error-free and consistently structured, I want the data organised so that I can run quick analyses and share concise insights with my team. Your first job will be to standardise all incoming rows and columns, weed out duplicates or obvious inaccuracies, and make sure every figure is in its correct place. After that, you’ll apply essential SUM formulas so totals reconcile across the entire file. If this stage goes smoothly, we can expand into more advanced logic such as IF statements, VLOOKUP/XLOOKUP, and automated dashboards, but the immediate focus is clean, accurate data. When the sheets are tidy, I’ll need you to use native Excel tools—sorti...

I’m looking for someone who can take over the day-to-day numbers in my Fortnox environment and keep everything compliant with Swedish rules. The work is not a one-off; I need an ongoing partner who is comfortable handling the full cycle—daily bookkeeping, periodic tax preparation (moms, arbetsgivar­deklarationer, etc.) and the monthly/annual financial reports that go to Bolagsverket and Skatteverket. You should already know your way around Fortnox workflows, integrations and export routines. If you also use Capego or similar tools that’s a plus, but my current stack is Fortnox only, so proven experience there is essential. Key deliverables • Up-to-date books in Fortnox, reconciled each month • Timely preparation and submission of VAT, employer and inco...

We are looking to hire an experienced Excel VBA freelancer to automate PDF form filling directly from Excel data. Mandatory Requirement No third-party software, no Python, no RPA, no Power Automate Only Excel VBA (using native VBA + Adobe Acrobat Object Library, if required) Project Scope Read data from Excel sheets Automatically populate PDF forms using VBA Support bulk PDF generation Handle text fields, checkboxes, and dropdowns in PDFs Maintain proper formatting and field mapping One-click execution from Excel (button or macro) Technical Skills Required Strong hands-on experience with Excel VBA Experience with: Adobe Acrobat PDF form fields via VBA PDF field mapping and automation Ability to write clean, well-commented VBA code Deliverables Fully working Excel VBA macro...

I’m streamlining a series of files that live mostly as documents, yet the heavy lifting happens inside Microsoft Excel. I need an expert who can dive straight into my existing workbooks and build, refine, or replace formulas and functions so the sheets calculate everything accurately and automatically. What this involves • Reviewing the current layout and any sample data I provide • Designing clear, maintainable formulas—think look-ups, nested IFs, conditional sums, date math, or whatever logic the job calls for • Testing to be sure every cell returns the right result and scales as the data grows • Adding brief in-sheet comments so I (and anyone else who opens the file) can understand the logic at a glance I’ll send over the Excel files as ...

I run a small fleet and keep all my figures in individual Excel workbooks, but I now need a central dashboard that makes those numbers meaningful at a glance. Here’s what the finished file must let me do: • See key KPIs—starting with Revenue per Car front-and-center, followed by weekly Expenses per Car, road fares, overall revenue, total expenses and resulting profit. • Drill down to Revenue per Driver and weekly mileage for every vehicle. • Spot upcoming major expenses the moment they appear. Maintenance tracking is just as important. I want an area that: • Highlights parts that are frequently replaced across the fleet. • Calculates the next service date automatically (assume each car averages 200 km/day and needs servicing every 5 00...

I need help keying in a backlog of sales-transaction records into my master spreadsheet. All raw figures are already collected in Excel/Google Sheets, but they still have to be copied into the main sheet, double-checked, and cleaned up so reporting formulas work without errors. Accuracy is critical. Each row should be verified against the source totals, date formats must stay consistent (DD/MM/YYYY), and duplicate invoice numbers have to be flagged before they slip through. Feel free to set up data-validation rules, drop-down lists, or conditional formatting—whatever streamlines the process while keeping mistakes out. Deliverables • A completed spreadsheet with every transaction entered, validated, and clearly formatted. • A short log that notes any anomalies you foun...

I need help keying in a backlog of sales-transaction records into my master spreadsheet. All raw figures are already collected in Excel/Google Sheets, but they still have to be copied into the main sheet, double-checked, and cleaned up so reporting formulas work without errors. Accuracy is critical. Each row should be verified against the source totals, date formats must stay consistent (DD/MM/YYYY), and duplicate invoice numbers have to be flagged before they slip through. Feel free to set up data-validation rules, drop-down lists, or conditional formatting—whatever streamlines the process while keeping mistakes out. Deliverables • A completed spreadsheet with every transaction entered, validated, and clearly formatted. • A short log that notes any anomalies you foun...

I have several files containing both numerical and text entries that need to be moved into a single, well-structured Excel workbook. Before anything is copied across, the information has to be cleaned—duplicates removed, inaccuracies corrected, and formats standardized—so that the final sheet is ready for analysis straight away. Once cleaned, I expect the data to be laid out logically, with clear headers, consistent row and column alignment, and simple formulas added where they help verify totals or highlight anomalies. Accuracy is my top priority, so I’m looking for someone who double-checks their work as they go and keeps me updated on progress. Deliverables • A polished Excel file (or multiple sheets if that suits the data) containing all imported records ...

I will provide an Excel file with raw records that need to be re-entered into a clean, separate sheet. Every row must be placed in chronological order so the final document reads smoothly by date. While the content itself is straightforward, the finished sheet has to look polished—use clear headings, uniform column widths, and any light styling that makes the data visually appealing without compromising readability. Here is how we’ll work together: • I send the source workbook as soon as we kick off. • You re-key each entry, double-checking all figures and text for absolute accuracy. • The data is sorted strictly by date before delivery. • Final hand-off is an Excel or Google Sheets file, ready for immediate use. Timeframe is tight: I need the compl...

I have an existing Excel template that tracks our online store’s customers, but the section on purchase history is still blank. I need you to populate that sheet with accurate “Items Purchased” data for each customer. You will receive raw exports from our e-commerce platform along with a simple mapping guide that shows which columns in the export correspond to the template. The task is straightforward: extract the list of items each customer bought and paste it, cleanly formatted, into the correct column of my workbook. Please keep every entry consistent—product names exactly as they appear in the export, no extra spaces, and one customer per row. I rely on this file for forecasting, so data integrity is critical. Double-check for duplicates, align any mismatc...

I need a clean, reliable Excel workbook that lets me track up to five production lines hour-by-hour. On one sheet I’ll manually enter, each hour, the line number, Units Produced, Downtime occurrences or minutes, Quality issues, and the SKU we’re running. The file must instantly calculate each line’s current units-per-hour and its attainment versus the hourly target I’ll set. A separate dashboard should present the numbers clearly: • Large numeric displays that show each line’s live UPH, its attainment percentage, and a room-wide total. • Simple bar or line charts so supervisors can see how performance is trending through the shift. • Conditional formatting that flips to green when a line is on or above pace and red when it falls behind (I&rsquo...

I need to overhaul several workbooks that currently depend on VLOOKUP / HLOOKUP to pull information across multiple sheets. The formulas have grown messy and slow, so your first task is to audit what I have, rebuild the lookup logic, and make sure everything recalculates cleanly. You are free to suggest smarter alternatives—INDEX-MATCH, XLOOKUP, even Power Query—as long as the files stay compatible with Office 2016. Once the lookups are solid, return the updated workbook along with a short note or dedicated sheet that explains the key formulas so I can maintain them myself. Deliverables • Cleaned-up workbook with efficient lookup formulas • One-page explanation of how the new formulas work Acceptance criteria • No #N/A errors on my test set • ...

I need an Excel workbook to track student data, specifically grades, and help monitor weekly goals. I have a very basic table with information that I'm looking to track. Requirements: - Dashboard for quick-glance information - Track Grades: Weekly goal tracking - Categories: Weekly goals (homework completion, participation, improvement points) - User-friendly interface Ideal Skills: - Excel proficiency - Experience with data visualization - Attention to detail - Ability to create dashboards Looking forward to your bids!

I’m looking to roll out a single Excel workbook—driven entirely by VBA—that will let my warehouse team record every kilogram of finished product that enters or leaves our godown. Each transaction must be captured against party, purchase order, batch, and current process stage, then stored in one normalized table so we never touch raw data again. Key flow • A clean user-form (no sheet scrolling) for data entry, validating quantities and dates before they hit the table. • Automatic posting of in- and out-movements, with running balances calculated product-wise in the background. • A daily summary report that refreshes with one click (or on open), showing the running balance for every product. Non-technical staff should be able to read it without hunting ...

My current Excel workbook prices both residential and commercial remodels, yet it’s clunky, fragile, and time-consuming to update. I need it transformed into a clean, intuitive tool that anyone on my crew can open, fill in project details, and instantly receive reliable numbers—no guesswork, no broken formulas. Here’s what I want improved • Design and layout: clearer tabs, color-coded input cells, and an at-a-glance summary tab. • Formulas and calculations: modern, error-proof math that automatically pulls Material, Labor, and Overhead rates into each estimate. • Data entry process: structured tables, drop-downs, and data validation so inputs stay consistent. Key new functionality • Automated pricing buckets for material, labor, and overhead, selecta...

I need an Excel file to optimize my finished goods inventory. The tool should help me track stock levels and demand forecasts, and include out of stock alerts. I also need to file to break demand from a national level into a dc level and clearly have a tab on the file to type in what is producing and spit out the split where product should be shipped to each dc Key Requirements: - Track stock levels and demand forecasts. - Out of stock alerts/notifications. - User-friendly interface Ideal Skills and Experience: - Advanced Excel proficiency - Experience with inventory management - Ability to create automated alerts in Excel

I’m working on a personal project that requires a large volume of information to be entered into Excel quickly and with absolute accuracy. The spreadsheet must be clean, consistently formatted, and free of errors; if simple formulas or data-validation rules help maintain integrity, feel free to add them. Because I need this finished ASAP, only bid if you can start right away and keep communication prompt. When you apply, please link or attach past work that demonstrates your data-entry skills in Microsoft Excel or Google Sheets—seeing real examples is the quickest way for me to judge fit. Deliverable: the completed, error-free Excel file in the same structure I provide, ready for my personal use. I look forward to working with someone who shares my focus on speed and quality.

I have an investment-analysis workbook built around 4–6 tightly linked worksheets and the Morningstar Excel Add-In. Right now, every time I add a new product on the control sheet I have to touch each tab manually. I want that to stop. The moment a ticker or fund name is entered on the main sheet, every dependent tab should fill itself out automatically according to the logic already driving the file (all calculations lean on the existing Morningstar data feed). What matters most to me is clean automation: formulas and, where appropriate, VBA that are easy to audit, keep the file light, and never break when the data set grows. If you have a proven track record building sophisticated, highly performant Excel models—and you’re comfortable working with the Morningstar plug-i...

I want a single Excel file that lets me compare different investments across several interconnected sheets. The core data points are daily share performance and current asset allocation; both should refresh automatically from an external source such as Excel’s built-in Stocks data type, Power Query, or another reliable feed you recommend. Here is what I need the finished workbook to do: • Sheet-level formulas that pull live prices and allocation figures into a central dashboard without manual copy-paste. • Consistent references so that when I add or rename a holding on one sheet the change flows everywhere else. • Clear, protected input areas for anything that cannot be automated. Acceptance criteria: the workbook opens without connection errors, updates pr...

I will provide an Excel file with raw records that need to be re-entered into a clean, separate sheet. Every row must be placed in chronological order so the final document reads smoothly by date. While the content itself is straightforward, the finished sheet has to look polished—use clear headings, uniform column widths, and any light styling that makes the data visually appealing without compromising readability. Here is how we’ll work together: • I send the source workbook as soon as we kick off. • You re-key each entry, double-checking all figures and text for absolute accuracy. • The data is sorted strictly by date before delivery. • Final hand-off is an Excel or Google Sheets file, ready for immediate use. Timeframe is tight: I need the compl...

I have several Excel workbooks packed with numerical records that need to be fully prepared for downstream analysis. The raw files currently contain inconsistencies, stray entries, and formatting issues that must be resolved without altering the underlying structure or formulas. Here is exactly what I need: • Data cleaning – remove duplicates, fix obvious entry errors, and flag any out-of-range values. • Data formatting – apply consistent number formats, align decimal precision, and standardise date or currency columns where they appear. • Data verification – cross-check row and column totals, ensure all formulas recalculate correctly after cleaning, and produce a brief summary of any anomalies you find.

I have several files containing both numerical and text entries that need to be moved into a single, well-structured Excel workbook. Before anything is copied across, the information has to be cleaned—duplicates removed, inaccuracies corrected, and formats standardized—so that the final sheet is ready for analysis straight away. Once cleaned, I expect the data to be laid out logically, with clear headers, consistent row and column alignment, and simple formulas added where they help verify totals or highlight anomalies. Accuracy is my top priority, so I’m looking for someone who double-checks their work as they go and keeps me updated on progress. Deliverables • A polished Excel file (or multiple sheets if that suits the data) containing all imported records ...

I’m working with a set of raw spreadsheets and need them processed into a clean, analysis-ready format. All source files will arrive as Excel workbooks; please keep everything in the same environment—no outside conversions that might break formulas or formatting. What I expect you to do: • Review each sheet for inconsistencies, missing values, and duplicates • Standardize column formats (dates, numbers, text casing) • Apply any straightforward transformations or look-ups needed so the data is relationally consistent • Return a single, polished workbook plus a short changelog describing the main steps you took Accuracy is critical; I’ll verify by spot-checking rows and formulas. If you see a potential issue or better approach while processing, f...

My one–page Excel sheet relies on a handful of basic SUM and AVERAGE formulas. I need a fresh set of eyes to make sure every calculation is accurate, references stay consistent even when rows are added, and no accidental hard-coded numbers have slipped in. Once the check-up is done, add a new column that simply sums a specific range and shows its grand total in the last row. Format it so the total updates automatically as new data appears. Deliverables: • Corrected or confirmed formulas across the sheet • Newly inserted column with a dynamic SUM and a clearly styled total at the bottom • Quick note (in-sheet or separate) describing any fixes you made If you can jump in, tidy things up, and hand it back error-free, that’s all I need.