Visual Basic Jobs

Saya ingin vlog saya terlihat lebih hidup. Materi rekamannya sudah siap; yang saya perlukan adalah sentuhan visual agar penonton betah menonton sampai akhir. Tugas utama: • Sisipkan efek visual yang halus namun menarik. • Gunakan transisi kreatif di titik-titik perpindahan klip. • Tambahkan animasi teks untuk judul, call-out, atau highlight informasi penting. Hasil akhir harus berupa: 1. Video final siap unggah (MP4, 1080p). 2. File proyek asli (Premiere Pro, Final Cut, atau DaVinci Resolve—gunakan yang paling Anda kuasai). Pastikan tempo transisi tidak mengganggu alur cerita, warna tetap natural, dan animasi teks mudah terbaca di perangkat mobile. Saya terbuka pada saran gaya visual asal tetap konsisten dengan nuansa vlog kasual.

I have an existing workbook that needs a set of well-structured, reusable formulas so I can run quick calculations without relying on manual edits. At this stage I’m still finalising the exact datasets and worksheet layout, so your formulas should be written in a way that can easily be adapted to either a single sheet or a multi-sheet setup. The data itself may range from pure numbers to mixed alphanumeric values, so the logic must account for different data types and avoid errors when a cell contains unexpected content. Nested functions, dynamic named ranges, array formulas (or their Office 365 equivalents), and clear in-cell documentation are all welcome if they keep the workbook lean and easy to audit. Once the formulas are in place I’ll test them against several sampl...

I have a collection of digital files—mainly PDFs and existing spreadsheets—that contain a mix of text passages and numerical values. I need every piece of that information transferred accurately into a single, well-structured Excel workbook. Here’s what matters most to me: • Speed without sacrificing accuracy: a strong typing pace and a careful eye for detail. • Consistent formatting: headings, numbers, and text must be placed in clearly labeled columns so formulas and filters will work straight away. • Clean hand-off: the final deliverable is the Excel file, error-checked and ready for immediate use—no loose notes or partial uploads. I will share the source files as soon as we start so you can dive right in. Let me know how quickly you can tur...

I have three distinct text-file datasets—customer information, financial records, and survey responses—that all need to be brought into a clean, analysis-ready format. The job is twofold: first, accurately key or import every record into a structured spreadsheet or database layout; second, perform a full hygiene pass to remove duplicates, correct any formatting inconsistencies, and fill in the missing fields I will flag for you. You will receive a folder of raw .txt files plus a short field dictionary that shows the expected column names, data types, and any reference lists you can use for validation. Once the data is in shape, return it as Excel workbooks (or CSV if you prefer) that match the field order in the template I’ll provide so I can import straight into our CRM...

I need an Excel template that makes it quick and fool-proof to log our revenue. The sheet will only capture sales amounts, and every entry has to be automatically tagged by product or service so I can slice totals instantly. Core requirements • Simple, protected entry form for daily sales amounts • Drop-down list (or similar) that forces the user to choose the correct product/service category on each line • Behind-the-scenes table structure that keeps raw data clean for future pivot-table or Power Query use • A summary tab that rolls up total revenue per product/service and refreshes with one click I’m happy with native Excel functions—no external add-ins needed—as long as the workbook stays compatible with Microsoft 365.

I’m putting together a three-sheet Excel workbook to help me stay on top of my money and I’d like a specialist to build it cleanly so everything updates automatically. Sheet 1 – Income & Expenditure I want a straightforward table with separate columns for income and expenses. As I add rows, running totals and a net-balance field should refresh instantly. Simple drop-downs for date and category would be a bonus, but clarity and ease of data entry come first. Sheet 2 – Statistics Here I only need bar charts that pull from the first sheet and redraw themselves as new figures appear. At a glance I should be able to compare monthly totals and see trends. Sheet 3 – Budgeting (50/30/20) This sheet should apply the classic 50 % Needs, 30 % Wants, 20 % Sav...

I need to replace a handful of repetitive steps in both Excel and Word with clean, reliable VBA macros. In Excel the routine involves importing raw CSV files, re-formatting them, and generating summary pivot tables. In Word I’d like a macro that pulls those finished tables into a report template, updates reference fields, and exports the final document as PDF—all triggered by one or two buttons. If you’re comfortable writing and debugging VBA in both applications, this job should be straightforward. Please build the code in a way that is easy for me to maintain: use clear variable names, add short inline comments, and keep everything in one macro-enabled workbook (.xlsm) and one macro-enabled document (.docm). Acceptance criteria • Excel macro processes a sample ...

I need help transferring and cleaning a set of mixed data that is already sitting in several Microsoft Excel workbooks. The job is straightforward: open the existing spreadsheets, copy-or-move the text and numerical fields into a new, consolidated Excel file I will provide, and make sure each column aligns with the schema I’ll share at kickoff. You may have to adjust a few formats—dates, currency, and text case—so the final sheet is consistent and import-ready for a later process on my side. You’ll be working only in Microsoft Excel, so please be comfortable with common functions like VLOOKUP/XLOOKUP, text-to-columns, conditional formatting, and basic data validation. If you prefer macros or Power Query to speed things up, that’s fine as long as the end resul...

I have a project schedule that now needs to be presented as a clean, professional Gantt chart. Every task must appear in proper chronological order, and the predecessor / successor relationships should be shown through indented task lists rather than connecting arrows or colour blocks. Core requirements • Convert my existing task list into a Gantt chart. • Display task dependencies through indentation. • Highlight any timing conflicts you spot while building the chart. Please deliver the Gantt in an editable file (native software file) plus a PDF snapshot for quick sharing. If you normally work in Microsoft Project, Excel, Smartsheet, or another dedicated tool, that’s fine—just let me know which format you’ll use so I can open and update it late...

I have an existing spreadsheet that’s starting to get unwieldy, and I need it brought under control. All the information is already entered; what’s missing is a clear, reliable way to view it by category. Here’s what I’d like done: • Clean up any obvious formatting issues so the sheet looks consistent. • Create simple, reusable filters that let me isolate each category instantly. • Sort the entire data set so every row falls into its proper category grouping (A-to-Z within each group is fine). • Flag duplicates or blank fields that could cause reporting errors. • Hand back the file in both Excel and Google Sheets formats so I can work in whichever tool I’m using that day. I’ll provide the raw spreadsheet as soon a...

An existing Excel workbook is starting to slow down reporting because the raw data was compiled from multiple sources. The file now needs a proper clean-up and a consistent structure so I can use formulas, pivot tables, and dashboards without fighting errors. Here’s the scope in plain terms: the entire sheet must be reviewed, obvious problems removed, and every column normalised to the same format. That includes spotting anything that stops sorting, filtering, or lookup functions from working smoothly—mis-typed values, stray spaces, mis-aligned dates, hidden characters, or anything else you notice while you work. If a lightweight VBA routine or Power Query step will save time, feel free to use it; the final file just has to open in standard Excel without external dependencie...

I keep all of my customer information in one Excel file that is starting to sprawl across several worksheets. What I want is a single-entry workflow: I type a customer’s name or code once and the file instantly pulls the relevant details from the various sheets, then produces a clean, printable quotation (and, later, an invoice version) with no extra copy-and-paste steps. The solution can be built with VBA, Power Query, dynamic arrays—whatever is most robust—but it has to meet three essentials: • Pull linked customer data from multiple sheets in the same workbook. • Populate a quotation template automatically, ready for PDF or direct print. • Leave me with a user-friendly front end so anyone on the team can generate quotations without touching the underlyi...

I have a collection of records that need to be keyed into Excel manually. The information is a mix of text and numbers, so the workbook has to be arranged in a way that keeps labels clear while still allowing basic calculations or filtering. I do not yet have a working template, only a rough idea of how the finished sheet should look. Your first task will be to shape an easy-to-use layout—column headings, consistent data types, light formatting, and, where it makes sense, simple formulas or data-validation to prevent errors. Once the structure is approved, you’ll enter all of the supplied data with careful attention to spelling, number accuracy, and overall consistency. Deliverables • A reusable Excel template (.xlsx) reflecting the agreed layout • The template ...

I have a set of raw figures that I need entered accurately into a master Excel workbook and, just as importantly, I want the file to do the heavy lifting for me once the numbers are in place. This means building solid formulas—SUM, SUMIF/S, XLOOKUP, IF statements, running balances, variance percentages—so the totals and subtotals update automatically every time I add new rows. Accuracy is critical because these tallies feed straight into management reports. If you spot a cleaner way to structure the sheet or streamline calculations, I’m open to your suggestions as long as everything remains transparent and easy for me to maintain. Deliverables • A clean .xlsx workbook populated with my supplied data • All requested formulas working and tested with sample v...

I have a batch of JioMart skincare sales that needs to be entered into a clean, searchable spreadsheet. The work is strictly sales-record entry: each transaction’s customer name must be captured accurately and every row should be sorted and grouped by customer name when the file is delivered. Raw source files are already exported from the JioMart dashboard; you can work in Excel or Google Sheets—whichever lets you deliver a neatly formatted, filter-ready document with zero typos. Deliverable: a completed sheet containing all provided sales transactions, alphabetically organized by customer name and ready for immediate reporting.

I have an Excel workbook that needs to do more than hold raw numbers. Using IF, SUMIF (and similar) formulas, I want the file to: • filter my data on the fly, • run conditional calculations that adapt as new rows appear, and • roll everything up into clear, criteria-based summaries. Once that logic is solid, I also need a one-click way to export the relevant sheets—or a defined print range—straight to PDF. The export should preserve whatever structure the formulas create, so the numbers shown in the PDF always mirror the latest workbook state. If charts or additional tables are required to make the report clearer, please build those into the flow; I’d like the option to toggle them on or off without touching the underlying code. Deliverables: ...

I have several spreadsheets of raw sales transactions pulled from different systems. Before the numbers feed our dashboards, I need one consolidated file whose figures I can trust. Your job is pure data cleaning and validation—no manual re-keying—focused entirely on verifying the accuracy of the sales data already in place. Here is what I need from you: • Examine every column (dates, order IDs, SKU codes, quantities, prices, tax, totals) and confirm each record is internally consistent. • Recalculate extended prices and grand totals with formulas to catch calculation errors or missed tax. • Cross-check SKU codes against the master product list I will supply; flag any that don’t match. • Identify and clearly mark blank or suspicious values tha...

I have an existing workbook that needs two upgrades: solid IF / SUMIF logic and a clean, automated export to PDF. The current sheets already hold the raw data, but totals, flags, and conditional results are still being calculated manually. I’d like you to: • Replace the manual steps with reliable IF and SUMIF formulas so the correct figures appear instantly, even when rows are added or data is shuffled. • Set up a one-click (or short-cut) PDF export that captures only the intended print area, keeps my page setup intact, and produces a professionally formatted document every time. Feel free to use native Excel tools, VBA, or another lightweight approach as long as it works on Office 365 for Windows without additional add-ins. Deliver the updated workbook plus a brief set...

I will give you a set of source PDFs containing mixed text and numerical information. Your task is to accurately transfer every record into a single, well-structured Excel workbook and then clean the dataset so it is ready for seamless import into my Tally / SAP environment. The cleanup I need is very specific: • Removing duplicates • Correcting formatting issues (dates, currency, decimals, etc.) • Standardizing text for consistent naming and casing Everything must balance exactly with the original documents, so please double-check totals, headers, and any calculated fields before you hand over the file. Once the spreadsheet is complete and verified, simply return the finished Excel workbook; no additional reports or summaries are required. If you have solid experi...

I have a batch of more than ten Excel workbooks that must be turned into polished, press-ready PDFs. Before you generate each file, I need three specific customisations applied: • Formatting changes – adjust column widths, fonts, margins and page breaks so every page sits neatly on standard A4/Letter. • Adding headers/footers – insert my logo on the left, the file name centred and the date on the right, mirrored on every page of the export. • Including charts/graphs – keep all embedded charts exactly where they belong and ensure they render sharply in the final PDF. If you can automate the process with a reusable VBA macro, Power Query routine, or a reliable Python script (openpyxl, pandas, reportlab, etc.), that would be ideal; I want to be able to r...

I have a raw spreadsheet that needs to be tidied up and then pushed a step further into simple predictive work. I only need four well-chosen Excel formulas that will: • clean the data first—removing blanks, standardising text and isolating usable rows, • feed a lightweight predictive-model setup so I can forecast future values from the cleaned series. Please give me: 1. The exact four formulas, written so they drop straight into Excel without extra add-ins. 2. A brief line under each explaining what it does and why you chose it. 3. A small demo sheet (can be dummy data) showing the formulas in action, with the forecasted values clearly visible. Keep the approach native to Excel—functions such as FILTER, UNIQUE, TEXTSPLIT, LET, XLOOKUP, FORECAST or whatever c...

I have a live spreadsheet that has to be cleaned, have smart logic added, and be ready to share today. The job breaks down into three fast-moving parts: 1. Data organisation – tidy the existing rows, ensure consistent headers, remove blank or duplicate lines, and generally get the file into a solid table structure that works well in Excel 365. 2. IF and SUMIF formulas – build the conditional logic I’ll specify (e.g. flagging records that meet multiple criteria and rolling subtotals by category). Every formula must calculate correctly across the full data set. 3. Exports – once the numbers check out, create two outputs: • a flat .csv file that carries all final values (no broken references) • a clean, print-ready PDF report of the same data, sized to...

I have a customer database in a single Excel workbook that needs a thorough scrub. The file currently contains duplicate rows, inconsistent name capitalisation, mixed-format emails, city names with spelling variations, and several date columns that appear in multiple formats. Here is the refinement I’m after: • Remove every duplicate record while keeping the first valid instance. • Standardise all personal fields—names in proper case, emails in lowercase, city names consistently spelled. • Reformat every date to DD/MM/YYYY so reporting tools read them correctly. • Apply uniform cell formatting (text, number, date) across the sheet. • Leave any legitimately missing value blank; do not introduce placeholders or delete rows that could still ho...

I have a collection of PDFs from which I need only the paragraph text pulled out and neatly placed into an Excel sheet so I can run further data analysis on it. No tables, headers, or footers are required—just the core narrative content exactly as it appears in the documents. You may use whatever reliable PDF-parsing or OCR tools you prefer, as long as the final workbook keeps one row per paragraph and preserves any obvious paragraph breaks. Please clean out page numbers or stray artefacts that often sneak in during conversion, and keep character encoding intact so analytics formulas work without surprises. Deliverable: one well-structured Excel file containing the extracted paragraphs, ready for immediate analysis.

I need a streamlined budgeting model built in Excel that relies on Power Query for all data loading and transformation. The model focuses exclusively on revenue, and more specifically on sales revenue, because that is the driver of every other decision we make. Here is what I want to achieve: • Import raw sales data straight from our current CSV export (or an ODBC connection if you think that is cleaner). • Use Power Query to clean, structure, and append each new file automatically, so I can refresh the model with a single click. • Feed the transformed data into clearly labeled tables that roll up monthly, quarterly, and annual revenue figures, giving me an at-a-glance view of how the numbers compare against budget targets. • Build dynamic dashboards and char...

I need two things handled in the same engagement. First, my existing workbook needs reliable SUM, AVERAGE and a few straightforward (and nested) IF formulas placed in the correct columns so monthly roll-ups calculate automatically. Second, I have several reports locked away in PDF format that must be converted into clean, fully editable Excel sheets—tables aligned, numbers preserved as numbers, and no text scrambling. Feel free to work with whichever tools you trust most—Power Query, Adobe Acrobat, or a dedicated converter is fine—as long as the end result is accurate and easy for me to maintain. I’m flexible on timing, so take the space you need to get the details right. Deliverables: • Updated .xlsx file with all requested formulas in place and functi...

We are converting a mature, commercially deployed Excel-based financial/audit automation application from VBA to Python. The Excel workbook front-end and custom ribbon stay; all processing logic moves to a Python engine running behind Excel. THE SYSTEM: • ~56,000 lines of VBA across a main workbook and add-ins, developed • Modules include: data import and mapping wizards, journal/adjustment engines, configurable settings panels, analytical calculations, multi-step report generation wizards, sampling tools, and a cash flow statement engine • Full installed environment, source code, and user documentation will be provided under NDA SCOPE OF WORK: 1. PLANNING PHASE: Analyze the VBA codebase and produce a technical planning document — module inventory, proposed Python ar...

I run a daily-meal (tiffin) service and today every order arrives by phone or WhatsApp, then gets typed into an Excel sheet where a VBA macro creates end-of-month invoices. As the volume grows, calls are missed, a few meals go unrecorded, and irregular customers sometimes slip past our payment checklist. I’m ready to replace this patchwork with a single, automated system that works everywhere my customers are. Here’s what I need built: • A customer-facing experience that works both as a lightweight web link and as an installable mobile app. From either interface a customer should be able to see the daily or weekly menu, select quantity or subscription type, and place the order in a couple of taps. • UPI integration for instant payment at checkout, with the transac...

I need a streamlined Excel workbook, built around Power Query, that projects our revenue based solely on the market analysis reports we receive each week. The idea is to load those reports, transform and cleanse them through repeatable Power Query steps, and funnel the result into a clear forecasting model—charts, pivot tables, and any DAX-driven measures you feel improve readability are welcome, but keep everything inside Excel so my team can follow the logic. The workflow should let me drop a fresh report into a folder every Monday, hit refresh, and immediately see updated projections for the coming months. No manual copy-pasting; all connections and calculations need to refresh automatically. Deliverables • An unlocked .xlsx file containing the Power Query routines, for...

I have a data-heavy workbook that relies on several IF statements to drive the analysis, but a few of them are getting unwieldy and returning inconsistent results. I’d like a fresh set of eyes to review my current logic, streamline it where possible, and make sure each formula scales as new rows are added. The job is purely formula-focused—no VBA or macro work—so deep knowledge of Excel’s logical functions is essential. Deliverables • Corrected or rebuilt IF formulas for the specified sheets • Brief in-cell or separate notes explaining how each formula works • Confirmation that results update accurately when I append additional data Once the revised workbook passes a quick spot-check on my end, the task is complete.

I have a clean database export that contains strictly numerical fields—no text, no mixed formats. The task is to take this export and enter the numbers into the destination file I will provide, preserving the exact order, decimal precision, and any leading zeros that appear in the source. You will receive: • the original database export file (CSV) • a target spreadsheet template with the required column structure Accuracy is critical. A quick spot-check will be run on random rows, and anything under 99.8 % accuracy will need revisiting. I will also review cell formatting to ensure numbers are not inadvertently converted to dates or text. When you apply, focus on your experience handling large sets of numerical data—mention any projects where you maintained high...

I’ve put together several product-information workbooks in Excel and now need two things finished. First, add or refine the conditional formulas—mainly IF and SUMIF—so totals, flags, and subtotals update automatically no matter how many products I append. The logic has to stay transparent so I can tweak thresholds later, and every reference must stay within the sheet (no hard-coded ranges that break when data grows). Once the calculations are solid, convert each completed worksheet to a clean, print-ready PDF. I’d like the PDFs to keep the same column order, hide gridlines, fit to A4, and stay under a reasonable file size for email sharing. Deliverables: • Updated Excel files with working IF/SUMIF logic • One matching PDF for each finished sheet S...

I’m looking for focused, one-on-one help in Excel so I can turn raw management data into clear, executive-ready visuals. My priority is data analysis in the form of data visualization, and I want to concentrate specifically on Conditional Formatting and Sparklines. I already know the basics of spreadsheets; what I need are practical techniques that let me highlight trends, embed tiny in-cell charts, and package everything into a monthly report that prints—or exports to PDF—without surprises. Please work with the real files I’ll share, walk me through best-practice layouts, and show me how to keep everything dynamic so the visuals update automatically as new numbers arrive. Deliverables • Live screen-share coaching sessions scheduled over the next two week...

I have a set of scanned copies of paper documents that contain both text and numerical fields. I need every character—words, figures, dates, codes—typed with absolute accuracy into a digital format of my choosing (most likely an Excel sheet or Google Sheet, though I’m open to your suggestion if you have a more efficient workflow). Because the material is mixed data coming from images, close attention to detail is essential. Mis-keyed digits or misspelled names will break downstream reports, so double-checking your own work before handing it back is vital. A familiarity with basic data-cleaning functions such as text-to-columns, simple formulas, or validation rules will help you spot issues quickly, but the main task is straightforward typing and verification. Delivera...

I have a collection of customer records that currently live partly in PDF documents and partly in a rough Excel file. I want everything consolidated into a single, tidy workbook and equipped with the right formulas so I can slice the numbers instantly. Step one is pulling the information out of the PDFs and arranging it in clean, tabular form inside Excel—no manual copy-and-paste errors, and every column properly typed. Once the data sits where it belongs, I need the following logic added: • SUM and AVERAGE calculations for key spend, balance and contact counts • IF statements tied to conditional formatting that immediately highlight missing fields, overdue payments or duplicate entries • VLOOKUP and HLOOKUP where look-ups make sense, and XLOOKUP for the longe...

I’m working on an Excel workbook that stores and organises large volumes of GST- and TDS-related figures. The structure is solid—data validation, filters, sorting and some conditional formatting are already in place—but the heart of the file, the formulas and functions, now need a careful audit and refinement to keep the data flow error-free as the sheet grows. Here’s what I need from you: • Go through every existing SUM, IF, nested IF, VLOOKUP and XLOOKUP I’ve built, check for hidden inconsistencies and remove any redundant calculations. • Optimise each formula so look-ups are fast and ranges stay dynamic even when new rows are added. • Confirm that all totals reconcile across summary tabs and the GST & TDS sections. • Return a ...

I have a collection of PDFs that contain structured tables and accompanying charts. I need every table lifted from those files and placed into an Excel workbook so it mirrors the original layout—row order, column widths, merged cells, borders, basic colours, and any percentage or currency formats must remain intact. Charts do not have to be rebuilt in Excel; only the numerical data that feeds them is required. Source files are standard, non-scanned PDFs, so the job should be straightforward for someone comfortable with Adobe Acrobat, Power Query or other reliable PDF-to-Excel tools. I am interested in accuracy above all else; totals, subtotals, and calculated fields must match the original documents. Deliverables • One Excel file per PDF, or a single consolidated workbook wi...

I have a clean data set of monthly sales that needs to come to life inside Excel. The goal is a single, interactive dashboard that instantly tells me three things: how much revenue we generated each month, how many units we moved, and what our profit margins looked like. I picture a layout where dynamic charts and graphs present the trends at a glance, supported by neatly formatted tables for quick detail checks. Slicers or other interactive filters should let me drill down by product line, region, or any other field you think is useful, all without breaking the flow of the visuals. What I need from you: • An Excel workbook containing the fully-built dashboard on a dedicated tab • All formulas, pivot tables, and named ranges clearly organized so I can tweak or expand th...

I have a collection of inventory records that must be transferred into a clean, well-structured Excel workbook. For every item I only need two fields captured: its name and a clear description. Once the list is complete, please build straightforward bar charts that visually summarise the data—think “at-a-glance” views of how many items sit in each category or any other sensible grouping you spot. Here is what I expect: • One Excel file with a neatly formatted table containing the item name and description for every inventory record I provide. • At least one bar chart (more if it adds value) using that table as its source, laid out on a separate worksheet for easy printing or export. • No macros or external add-ins—native Excel functions only&mda...

I have a CSV file filled with financial data—every row is numbers, dates, and account labels that need to be reviewed in Excel rather than a flat text grid. I simply need the contents moved into an .xlsx workbook with each field correctly recognised as a number, date, or text so formulas, filters, and pivot tables will work without extra cleanup on my side. Key deliverable: • One Excel workbook (.xlsx) containing the full financial dataset, column-for-column and row-for-row, with no data loss or type mismatches. Please keep the sheet names and column headers exactly as they appear in the source file, and double-check that any leading zeros, negative signs, or decimal places remain intact. If you notice obvious delimiter or encoding issues during import, go ahead and correct th...

My priority is a spotless, well-structured data sheet delivered quickly and without a single typo or formatting slip. The raw information will reach you exactly as I have it—some of it already digital, some still in mixed formats—and I’m open to whichever workspace you prefer, whether that is Excel, Google Sheets, or a clean CSV build. Accuracy and clarity come first. Every entry must be double-checked, consistent, and logically arranged so that anyone on my team can sort, filter, and pull insights at a glance. If duplicates, blank cells, or odd characters appear, remove or flag them; if field names clash, standardize them; and if numeric columns carry stray text, separate and correct them before final hand-off. Deliverables • A single, fully cleaned and orga...

I have a single CSV exported from a survey platform that captures only demographic information—age brackets, gender codes, location IDs and similar numeric fields. Right now column order is inconsistent, a few headers are missing, line breaks sometimes split records, and the file triggers import warnings in Excel. What I need is simple but precise: • Inspect every row, repair or remove malformed entries, and guarantee each record has the full set of demographic fields. • Add clear, human-readable column headers (I’ll supply the exact wording once we start). • Normalise delimiters, keep leading zeros intact, and ensure all numeric columns remain numbers when the file is opened in Excel. • Return the finished dataset as a clean CSV that opens instantly...

I have a PDF filled with financial-data tables that I need converted into fully editable formats—Word for documentation and Excel for analysis. Accuracy is crucial: every figure, column, and row must match the source exactly, and the original borders and shading that help readers follow the numbers need to appear the same way in the new files. You may use any reliable tool—Adobe Acrobat, Able2Extract, or a custom script—as long as the end result opens cleanly in Microsoft 365 without broken cell alignment or lost formatting. I am expecting two deliverables: • a Word document that mirrors the PDF layout and preserves all table styling, and • an Excel workbook with each table on its own sheet, ready for formulas and pivot-table work. Before final hand-off, s...

I have a batch of completed forms saved as PDFs and I need every field transferred accurately into an Excel workbook. The PDFs all follow the same basic layout, so once the first document is mapped the rest should flow with a repeatable process. Feel free to use Adobe Acrobat scripting, Power Query, Python (tabula-py, pdfplumber, camelot) or any other dependable extraction method—speed is welcome, but accuracy is non-negotiable. Deliverables: • A clean .xlsx file containing one fully-populated table where each form becomes a separate row and every captured field is arranged consistently across columns. • The original script or macro (if you automate the task) so I can rerun it on future batches. Acceptance criteria: • 100 % of the visible data in the PDFs must appe...

I have a sizeable collection of records that live in a few online databases, and I need every text field, number, and code transferred quickly and accurately into a single spreadsheet template I will provide. Because the source contains both narrative text and numerical figures, close attention to formatting is essential—dates must stay in the same style, currency values must keep two-decimal precision, and free-text notes must remain exactly as written. The process is straightforward: log in to each database with the credentials I supply, copy the required fields row by row, and paste them into the matching columns of my Google Sheet (or Excel, if you prefer). I will be monitoring progress in real time, so please be comfortable updating a live document and flagging any anomalies as...

I have a backlog of mixed text-and-number information that must be transferred into a spreadsheet for long-term record keeping. I need you to design a clear, easy-to-navigate layout from scratch in either Excel or Google Sheets (whichever you prefer) and then enter every piece of data with perfect accuracy. Deliverables: • A custom spreadsheet template ready for ongoing use • All supplied records entered, double-checked, and neatly formatted • File delivered in both Excel and Google Sheets formats, with no loss of structure or formulas Accuracy is the priority, so familiarity with basic validation tools, simple formulas, and keyboard shortcuts will help you work quickly without sacrificing quality. Once complete, I should be able to sort, filter, and locate any e...

Looking for an Excel Expert/Tutor – PivotTables & Case Analysis Hi everyone, I’m looking for an experienced Excel expert/tutor who can teach me how to build management reports using an existing case-level Excel report. I have a Q3 OM case dataset containing fields such as Case Number, Territory, Case Opened Date/Time, Case Closed Date/Time, Case Age No Weekend, and Domestic/International classification. I need help learning how to create the following reports: 1. Q3 Case Count Report Total Q3 case count Domestic vs. International case count Case count by Territory Group/merge territory divisions such as ALLA 2026-M and ALLA 2026-S where required Correct Grand Totals 2. Average TAT Report Identify closed cases Calculate the number of closed cases Calculate average TAT for cl...

I have a collection of raw text files that need to be transferred into a clean, well-structured spreadsheet. I want every record entered accurately and grouped by category so the sheet becomes an easy-to-filter reference for my team. Scope of work: • Review each text file and extract all required fields. • Enter the information into a master spreadsheet, assigning each row to the correct category column. • Double-check for consistency, eliminate duplicates, and flag anything unclear. The spreadsheet should be delivered in Excel or Google Sheets format, ready for immediate use. Familiarity with data-cleanup functions such as VLOOKUP, conditional formatting, and basic pivot tables will be helpful for quick validation, though not mandatory. If you are detail-oriented a...

I’m looking for ongoing help recording our store’s inventory adjustments at the close of each business day. On an average day I need between 1 – 50 individual SKU updates entered quickly and error-free into our tracking system so that the next morning’s reports reflect the correct on-hand counts. You’ll receive the raw counts in a simple file each evening—usually Excel or CSV, though I can accommodate whatever format keeps you fastest and most accurate. Your task is to transfer those numbers into our cloud-based dashboard, double-check that totals balance against yesterday’s ending stock, and flag any negative or unrealistic deltas you see. Consistency matters more than speed; I need the updates completed no later than 10 p.m. EST each night so o...

I need help moving a large volume of text-based information into an Excel spreadsheet. All the source material will be provided; your task is purely data entry—no analysis, formatting, or calculations are required beyond keeping the columns tidy and consistent. Accuracy matters more than speed, but a fast, error-free typist will finish this smoothly. Deliverable: a completed Excel workbook with every piece of text placed in its correct cell, free of typos and duplication. I will spot-check the file for consistency before signing off. If you are comfortable working in Microsoft Excel and can maintain focus over repetitive tasks, this project should be straightforward.