Makra Excel Jobs

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

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

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

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

I'm seeking an Excel expert to create a spreadsheet that organizes pricing for my materials on ServiceM8. This is for calculating the cost of goods sold as a Level 2 electrician. Requirements: - Organize pricing for raw materials, finished products, and service supplies. - Include elements for COGS calculation: Material costs and Labor costs. - Automatic calculations/formulas mixed with some manual entry. Ideal Skills & Experience: - Proficiency in Excel, especially in creating spreadsheets with automatic calculations. - Experience with ServiceM8 software. - Strong organizational skills to manage multiple pricing elements.

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

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

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

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

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

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

Proszę, Zarejestruj się lub Zaloguj, żeby zobaczyć szczegóły.

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

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

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

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

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

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

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

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

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

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

I’m looking for a patient instructor who can walk me through two key areas that I use every day but still don’t feel fully confident about: Excel and general email management. On the Excel side, my goal is to become comfortable with basic formulas and functions (SUM, AVERAGE, IF, etc.) and then quickly move into creating clear, compelling charts or graphs for small reports. I don’t need advanced automation or pivot tables right now—just practical, hands-on skills I can apply immediately in my job. For email, I’d like to streamline the way I organize my inbox and folders, create rules or filters, and generally adopt best practices so important messages never slip through the cracks. Here’s how I picture the collaboration: • Short, focused sessions...

I need an Excel expert to improve my existing business workbook. The sheet already contains customer details, revenue, expenses, profit, and aggregator information. I want to add a professional dashboard with monthly and yearly comparisons, partner-wise analysis, charts, graphs, KPIs, and other visual reports to help me track business performance. The final workbook should be automated, user-friendly, and easy to update with new data.

Title: Need an Excel Expert to Build an Automated Business Management Dashboard Description: I am looking for an experienced Microsoft Excel freelancer to create a professional and fully automated Excel workbook for my freelancing business. The workbook should include income tracking, expense tracking, client records, pending payments, monthly reports, and a professional dashboard with formulas that update automatically whenever I enter new data. I will share all the required details after awarding the project. Important: My fixed budget is $10. Please read this before placing your bid. Only bid if you are comfortable working within this budget. Thank you!

I’m consolidating a mixed set of text and numerical records into an Excel-based database. Your task is to take the source documents I provide and enter every field into my pre-formatted spreadsheet template, keeping both the layout and data types intact. The files include names, descriptions, IDs, quantities, and prices, so close attention to text accuracy and proper numeric formatting is essential. I’ll share a short walkthrough video, the template (.xlsx), and a list of validation rules with dropdowns and conditional formatting already in place. Deliverable • A fully populated Excel file that mirrors the template, free of typos, empty rows, or formatting drift. Acceptance criteria • 100 % of source rows transferred. • No numeric field stored as text. ...

I’m consolidating a mixed set of text and numerical records into an Excel-based database. Your task is to take the source documents I provide and enter every field into my pre-formatted spreadsheet template, keeping both the layout and data types intact. The files include names, descriptions, IDs, quantities, and prices, so close attention to text accuracy and proper numeric formatting is essential. I’ll share a short walkthrough video, the template (.xlsx), and a list of validation rules with dropdowns and conditional formatting already in place. Deliverable • A fully populated Excel file that mirrors the template, free of typos, empty rows, or formatting drift. Acceptance criteria • 100 % of source rows transferred. • No numeric field stored as text. ...

I’m consolidating a mixed set of text and numerical records into an Excel-based database. Your task is to take the source documents I provide and enter every field into my pre-formatted spreadsheet template, keeping both the layout and data types intact. The files include names, descriptions, IDs, quantities, and prices, so close attention to text accuracy and proper numeric formatting is essential. I’ll share a short walkthrough video, the template (.xlsx), and a list of validation rules with dropdowns and conditional formatting already in place. Deliverable • A fully populated Excel file that mirrors the template, free of typos, empty rows, or formatting drift. Acceptance criteria • 100 % of source rows transferred. • No numeric field stored as text. ...

I need help correcting formula errors in a complex Excel spreadsheet. Requirements: - Fix formula errors in specific sections - Ensure data integrity and accuracy Ideal Skills: - Advanced Excel proficiency - Strong problem-solving skills - Attention to detail Experience with complex spreadsheets is a plus.

I have several Excel spreadsheets holding strings of information—names, addresses, reference notes, short descriptions—that all need to be brought into one clean, consistent master sheet. Every entry must be copied exactly as written, checked for stray spaces or line-break issues, and parked in the correct column of the template I will share at kickoff. The job is entirely text-based; no numeric formulas or image conversions are involved. Source files are already in .xlsx format, so you can work directly inside Excel without any import steps. Simply follow the field order I supply, keep capitalization exactly as shown, and flag any illegible or duplicate items in a separate tab so we can review them later. Deliverable: • A final Excel workbook containing all supplied rec...

I'm looking for an Excel expert to help with financial calculations, specifically for creating and fixing formulas on an expense report for a small company. Key requirements: - Proficiency in Excel, especially in financial formulas - Experience in creating and fixing complex formulas - Ability to organize and analyze financial data Ideal skills and experience: - Background in finance or accounting - Strong problem-solving skills - Attention to detail and accuracy Your expertise will help streamline our expense reporting process.

I’m consolidating a mixed set of text and numerical records into an Excel-based database. Your task is to take the source documents I provide and enter every field into my pre-formatted spreadsheet template, keeping both the layout and data types intact. The files include names, descriptions, IDs, quantities, and prices, so close attention to text accuracy and proper numeric formatting is essential. I’ll share a short walkthrough video, the template (.xlsx), and a list of validation rules with dropdowns and conditional formatting already in place. Deliverable • A fully populated Excel file that mirrors the template, free of typos, empty rows, or formatting drift. Acceptance criteria • 100 % of source rows transferred. • No numeric field stored as text. ...

I need assistance in converting Excel vb script that generate contract in docs using macro into Python scripts. The project involves: - Converting mathematical and text manipulation formulas - Working with Vb scripts that pull data from Excel - Generating Word contracts using the data Ideal skills and experience: - Proficiency in Python - Strong understanding of Excel formulas - Experience with data manipulation and automation tasks - Familiarity with generating Word documents through Python Please provide examples of similar work done.