Excel VBA Jobs

I’m running a crypto-options toolkit that couples Excel with Python through xlwings on Windows. It connects to Deribit and Bybit, prices BTC and ETH options, and rolls those numbers into P/L and risk reports. The volatility-surface interpolator is fine, but the pricing engine and the downstream risk calculations are now throwing errors, which breaks the entire reporting chain. I’ll share the workbook, the Python modules and a short technical document that maps the whole flow. I need you to trace the faults, refactor where necessary, and get everything—pricing, greeks, P/L and risk metrics—working smoothly again. The existing API calls to Laevitas and Deribit do not need any changes, so concentrate on the internal logic and the Excel-Python hand-off. Please save yo...

Operations Data in my last company Collaborate with business stakeholders to gather functional requirements and translate them into scalable BI reporting solutions. • Designed and implemented robust data integration workflows by consolidating data from Excel, SharePoint, Salesforce, and SQL Server into a centralized reporting model. • Performed comprehensive data profiling, cleansing, transformation, and modeling using Power Query (M) to deliver high-quality, analysis-ready datasets. • Designed and developed dynamic dashboards using custom visuals, hierarchical drill-down structures, geo-maps, and drill-through features to enhance analytical depth and improve strategic business decisions. • Proficient in advanced DAX (YTD, QTD, MTD, YoY, MoM), performance optimization ...

I have a set of Excel workbooks that track our daily sales. Each file is already organized by date, and I need a reliable specialist to enter a backlog of new transactions into the correct worksheets. You will receive the raw figures in a simple CSV export; your task is to copy-paste or import those numbers into the existing date-based tables, double-checking that totals, formulas, and basic formatting stay intact. Accuracy is more important than speed, but I still need a quick turnaround so the reports remain current. If you are comfortable working with Excel filters, data validation, and a few lookup formulas to catch entry mistakes, you will be a great fit. Deliverable: the updated Excel files returned with every new sale properly recorded under the right date column and a brief note ...

I will share a single-sheet Excel file that tracks all of our department KPIs. Before it can become a reliable decision-making tool, it needs a thorough tune-up and a polished, professional dashboard. First, the raw data requires attention: tidy up the layout, remove any inconsistencies, and make sure every column is clearly labeled so managers and team members can filter or add information without breaking anything. A few key formulas are throwing errors, so they must be corrected or rebuilt to calculate totals, averages, and year-to-date metrics accurately. I also have fresh data that must be appended and incorporated into every calculation and chart automatically. Once the backbone is solid, I want the numbers to speak visually. Build a dashboard on a separate sheet that pulls live fr...

I have several raw datasets that need to be processed with great attention to accuracy and consistency. Your job will be to take the files I provide, run them through a repeatable workflow—cleaning, validating, re-formatting where necessary—and return a final version that is analysis-ready. We are seeking a methodical and detail-oriented professional to handle client and vendor data processing. In this role, you will be responsible for accurately completing sales and expenses worksheets by progressing through a strict procedural workflow. You will evaluate and verify suppliers and customers, generate realistic invoice records, and execute rigorous quality checks before final submission. Key Responsibilities:Review and classify financial transaction records within spreadsheet...

My residential property budget spreadsheet needs a thorough refresh so that the operational-expense and maintenance-cost lines reflect my most recent figures and calculate year-to-date totals correctly. I’ll send you the existing Excel template; the layout and most formulas are already in place, but several cells and look-ups are broken after the latest rate changes. Your job is to plug in the new numbers I provide, audit the linked formulas for accuracy, and hand back a clean workbook that auto-updates summaries and charts without errors. Use native Excel functions only—no external add-ins—so the file stays fully portable for my team. Deliverable: • Updated .xlsx file with corrected formulas, populated operational-expense and maintenance-cost data, and a quick...

I’m working with an Excel worksheet that has grown messy over time and now contains unwanted, exact duplicates. I need a careful clean-up focused on three key columns—Name, Email, and Phone number—so the finished file is accurate, tidy, and easy to maintain. Here’s what I’m after: • Scan the spreadsheet for rows where any of those three columns are an exact match to another row. • Remove or merge the duplicates (we can decide together which approach is safest for my use case). • Return the cleansed workbook plus a short log or second sheet that lists what you removed or changed, so I have a full audit trail. You’re welcome to use your preferred Excel tools—Power Query, formulas, VBA, or a mix—as long as the final deli...

I’m looking for a detail-oriented freelancer to consolidate my sales records into one clean, reliable file. The information you’ll work with is mixed—numeric figures already sitting in several Excel sheets and text-based details that need to be pulled from online databases. Here’s how the flow should work: you’ll open the existing spreadsheets, verify each number, then match or append the related product and customer notes you locate online. Accuracy is critical; every figure must line up with its descriptive fields, and any discrepancies should be flagged for my review before final submission. Deliverables • A single, fully populated Excel workbook containing all numeric and text fields, free of duplicates and obvious errors • A brief chan...

I have a batch of customer records that I need transferred accurately into an Excel workbook. Each record contains just a handful of fields—no more than five per customer—so the task is simple but demands perfect attention to detail. I’ll provide all source files and a template with the exact column headings (e.g., Name, Email, Phone, etc.). Key points • Roughly 1-5 data points for every customer • Data must be typed, not copied via OCR, to avoid hidden errors • Final file should arrive as a clean .xlsx, free of duplicates and formatted for easy filtering and sorting Deliverable • Completed Excel sheet containing every customer entry exactly as provided, spot-checked for accuracy. That’s it—straightforward, quick, and ready...

I have one (possibly two) Excel workbooks where many of the text cells contain multiple consecutive spaces inside the strings—think “New York” or “Invoice Number”. I do NOT need you to touch leading or trailing blanks; the goal is strictly to collapse everything inside the text so that any run of spaces becomes a single space. You may tackle this with a quick VBA routine, Power Query, an advanced Find-Replace sequence, or whichever method you prefer, as long as the result is accurate and repeatable. When you send the file back, every internal gap must be reduced to exactly one space, with all other content left untouched. Please return: • The cleaned workbook(s). • A brief note (or embedded macro) that shows the steps or code you used so I c...

I have a set of PDFs and Word documents that contain a mix of text and numerical information. I need every piece of that content transferred into a neatly structured Excel workbook. Because no template exists yet, the very first step is to design an intuitive column layout that captures all fields logically and leaves room for any slight variations you may notice while combing through the files. Accuracy is everything here. Typos, transposed digits, or skipped rows will cause downstream reporting problems, so each entry must match the source exactly. Once the structure is in place, populate the sheet, double-checking totals and text entries for consistency. Feel free to lean on Excel’s data validation and simple formulas if they help keep quality high; what matters most is that the ...

I have a batch of text-based information that needs to be transferred accurately into a clean, well-structured Excel workbook. The job is straightforward data entry—no calculations or formulas—just precise transcription and sensible column alignment so the sheet is easy to read and ready for future analysis. Here is what I need from you: • Enter all supplied text data into the appropriate Excel columns and rows. • Tidy the layout as you go—consistent fonts, header rows styled for clarity, and no blank lines or stray characters. • Double-check spelling and spacing so everything looks polished before you hand it back. When you deliver, I expect a single Excel file that mirrors my source documents perfectly and is formatted to a professional standard.

I have an Excel workbook that’s become messy over time and now needs a thorough text-format refresh. I need every cell that holds text to read consistently—no random capitalization, no stray spaces, no columns that shift out of alignment when the file is filtered or sorted. Here’s what I expect from you: • Open the file, review each worksheet, and correct all visible formatting inconsistencies. • Apply the appropriate Excel functions or Power Query steps to remove extra spaces, standardize capitalization (sentence, proper, upper, or lower case as the content demands), and ensure column alignment without altering the underlying data. • Return a polished version of the workbook along with a quick summary of the key transformations you applied so I can...

I have a spreadsheet that needs to be populated with mixed text-and-number data. Accuracy is essential, but so is presentation—I already have a layout in mind and want the finished sheet to follow that structure precisely (column widths, date and currency formats, consistent fonts, conditional colour bands, etc.). Your task is to take the raw information I send, key it into Excel, and apply the specified formatting as you go so that the file is immediately client-ready. If simple formulas or data-validation rules help keep everything clean, feel free to add them; otherwise, straight data entry with the agreed-upon styling is all that’s required. Deliverable • One Excel workbook fully filled and formatted exactly to the reference sample I provide, with no stray charac...

I need an Excel workbook set up for straightforward data analysis. The core of the job is to structure my raw data clearly, apply the right formulas where useful, and summarise everything with well-designed pivot tables so I can slice the information fast without extra clicks. Once I send the dataset, configure the sheet so new rows dropped into the source table automatically flow through to the pivots. Clean headings, consistent data types, and no hard-coding in the calculations are essential. Deliverables • Final .xlsx file with fully functional pivot tables linked to a neatly formatted source table • Brief in-sheet notes explaining any key formulas or settings If you prefer using Power Query or a light VBA macro to keep the refresh seamless, feel free to suggest it&mdas...

I'm seeking an Excel expert to help me create comprehensive reports. Key Requirements: - Proficiency in Excel, especially in report generation. - Experience with financial, sales, or inventory reports. - Skills in charts, pivot tables, and conditional formatting. Ideal Skills and Experience: - Advanced Excel knowledge - Experience with data visualization - Strong analytical skills - Attention to detail and accuracy Please provide samples of previous work and relevant experience.

I have a series of raw Excel spreadsheets that I use strictly for record keeping, but right now they are messy and hard to read. I need you to step in and turn them into a clean, well-structured workbook. You’ll receive the data already in .xlsx format, so your first task is to apply the usual housekeeping: remove duplicates, correct any obvious alignment or text issues, and make sure each column has an appropriate data type. From there, I want the sheets sorted and filtered logically so I can locate information quickly—basic formulas such as SUM, AVERAGE, COUNTIF, or simple look-ups are enough for my needs. Once the data is tidy, convert key ranges into properly named tables; this is important because I rely on structured references later. If you see a spot where a small, ...

I have an Excel workbook that contains several thousand rows of raw data. The core issue is inconsistent text formatting—capitalisation varies, extra spaces appear, and some entries include stray symbols that break downstream look-ups and reports. Your job is to correct those text fields so every cell follows the same, clearly documented pattern. What I will provide • The original .xlsx file • A short style guide that shows how each column should read (e.g., “Title Case with no trailing spaces”) What I expect back • The same workbook returned with all text fields cleaned and validated—no broken formulas, no hidden characters, no mismatched encodings • A brief change log or summary sheet explaining the main fixes you applied so I can a...

I have a set of CSV files that hold purely numerical fields, and I need every value placed into a clean Excel workbook with the formatting still recognised as numbers. No extra calculations or text parsing—just an accurate, reliable transfer. A reusable method is important. If a concise VBA macro, Power Query routine, or a short Python script using pandas / openpyxl can automate the process, include it along with concise guidance. The final file must open error-free in the latest desktop version of Excel and display each column as true numerical data, with headers preserved (or created from the first row where they are missing) and sensible column widths for quick review. Deliverables • Populated Excel workbook. • Transfer script or macro, fully commented. • A ...

I have a PDF document that must look and feel identical once it lives in Excel. Every column width, row height, font style, border, and color should mirror the source so that a quick side-by-side comparison shows no visual difference. I do not need formulas—this is purely about presentation—but I do need the file to remain editable afterward. Please bring in only those images that add meaning to the sheet and discard the decorative ones; if an image clarifies data or serves as a header or logo, keep it in the same position and scale. All pages and sections deserve the same level of care, so work through the PDF sequentially instead of prioritizing any single area. Deliverable: • One Excel workbook (.xlsx) that faithfully reproduces the entire PDF layout, with relevant ...

I have an Excel file containing more than 5000 customer records that need to be added to Viber. I don’t just want one large broadcast list—I need these contacts neatly segmented into multiple groups so future messaging remains targeted and manageable. Here’s what I’m after: • Cleanly import every entry from the Excel file into Viber without triggering number-block issues or spam flags. • Create and name the groups based on criteria we agree on (e.g., location, purchase history, or any other filters you recommend). • Provide a repeatable method—whether that’s a step-by-step guide, a small script, or automation using the Viber API/desktop tools—so I can run future imports on my own. • Verify that each group shows the correc...

I have a raw Excel workbook that needs a careful sweep before it can be used for reporting. The file holds a few thousand rows spread across several sheets and currently suffers from duplicate records, inconsistent date and number formats, scattered blank cells, and a patchwork of column names. Your job is to transform this messy source into a single, tidy .xlsx file that is ready for analysis. Standard Excel tools—filters, conditional formatting, VLOOKUP/XLOOKUP, PivotTables, data validation, and simple formulas—should be all you need; no macros or external add-ins are required. Deliverables • One consolidated, fully cleaned Excel workbook • A short “change log” sheet noting what you removed, merged, or reformatted • Optional: a brief note with...

I need a tidy, well-formatted Microsoft Excel workbook built with up to five separate sheets, each populated with text records that I will supply—every record includes a person or company name and a full mailing address. Your job is simple but must be flawless: transfer the information exactly as shown in the source documents, keep the spelling and line breaks intact, and place each field in its proper column so the file is instantly searchable and ready for mail-merge use. To keep things consistent, I will send you a template that shows the column headers I need (Name, Street, City, State/Province, ZIP/Postal Code, Country). Please stick to that layout, avoid merged cells, and apply the same basic formatting on every sheet. Deliverable: • One Excel (.xlsx) file containing 1...

Sales & Profitability Dashboard — Project Description Overview An interactive Excel-based dashboard that consolidates raw sales transaction data into real-time KPIs, breakdowns, and visualizations for tracking revenue, cost, and profitability performance across regions, product categories, time periods, and sales reps. Objective To give sales and finance stakeholders a single, self-updating view of business performance — eliminating manual pivot-table building and enabling faster, data-driven decisions on where revenue and margin are strongest or weakest. Key Features Live transaction table — a structured Excel Table capturing Date, Region, Category, Product, Sales Rep, Units Sold, Unit Price, and Unit Cost, with Revenue, COGS, Gross Profit, and Margin % calculate...