Visual Basic Jobs

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 an experienced analyst to turn my historical sales data into a forward-looking forecast entirely in Excel. Your task is to clean the raw figures, build an accurate predictive model, and present the results in a format that a non-technical stakeholder can understand at a glance. The dataset arrives as monthly CSV exports. After cleaning, I expect you to apply appropriate time-series or regression techniques available within Excel—think Data Analysis ToolPak, Power Query, Solver, or even VBA if it streamlines the workflow. Please document every transformation step so the model can be refreshed with new data later. Deliverables • A well-structured Excel workbook containing: – The cleaned data sheet – The predictive model with formulas fully visible &n...

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...

I need my raw spreadsheet transformed into a clean, searchable workbook. The file contains a mix of text and numerical fields; your job is to enter the data accurately, format it consistently, then apply smart sorting and filtering so I can find what I need in just a few clicks. No macros or financial modelling are required—simply solid data entry skills and a good command of Excel’s built-in sort and filter tools. Once finished, I should receive a single .xlsx file with: • All records entered and double-checked • Uniform formatting across every column and row • Filters already in place on the key columns I’ll specify I’ll send the source material plus a brief field guide the moment we kick off. If you enjoy keeping data neat, this is a quick, ...

I have several digital files that need to be brought together in a single, well-organized Excel workbook. Your task is to enter the data accurately, structure it into clear tables, and then build insightful line charts that highlight the most important trends in the dataset. Here’s what I need from you: • A tidy Excel workbook containing all imported data arranged in logical tables. • A set of line charts—one for each key dataset—linked to those tables so that updates flow automatically. • Brief summary tables beneath each chart, showing the figures that drive the visuals. Accuracy is critical, and the final file should be easy for me to maintain and update without breaking any references. If you’re comfortable handling digital source files and ...

Je souhaite produire une série de vidéos qui expliquent, étape par étape, comment fabriquer des produits cosmétiques et les commercialiser sous sa propre marque. Le format retenu est un montage vidéo avec voix off claire en français. Le tournage devra avoir lieu sur site – dans un laboratoire ou une petite unité de production – afin de montrer chaque phase réelle de fabrication. Ce que j’attends : • Captation HD sur place (idéalement multi-cam) couvrant pesées, mélange, contrôle qualité et conditionnement. • Montage rythmé avec titres, incrustations d’ingrédients et schémas récapitulatifs, durée finale 5-8 min par produit. ...

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...

My information is still being keyed in manually, so I need a simple data-feed or template set that lets me enter the data once and have it flow automatically into the right places inside Word documents and Excel workbooks. If VBA macros, linked tables, form fields, or any other Microsoft-friendly solution will shave time off the process, I am open to it. The end result should let me: • type or paste the mixed data in a single, easy-to-use input sheet or form • have Word reports and Excel sheets populate instantly and accurately • keep everything editable later without breaking the links Please build, test, and hand over the finished Word and Excel files (with clear notes on how to add or adjust fields) so I can start using them straight away.

At present the staff is getting the scheduled auto emails with the Excel Zip file attachment as scheduled report from ERP. The Zip files are downloaded on the desktop. Then the unzipped Excel data (Trial Balance) is manually pasted in the financial file on Google drive. The further linkage is already there in Google file & the financials are getting ready. We require a script / programme which will 1) read all the scheduled auto emails from ERP of the dedicated email id 2) rename the zip file based on the remark written on the auto email body by storing the same in My drive of the dedicated email id 3) unzip the Excel files & store in My drive of the dedicated email id 4) we have prepared the control panel which has info of which file data is to be pasted in which sheet of which ...

I have several Excel workbooks containing a blend of text and numeric fields that now need to be moved into a clean, well-structured master sheet. Your job is straightforward but detail-critical: copy the information exactly as it appears, keep all numbers in their proper formats, and double-check that no text strings are truncated or misplaced. You will receive the source files via a shared folder. Please return one consolidated Excel file, already de-duplicated and sorted by the column order I will provide once we start. Accuracy is the top priority; I will run spot checks against the originals before signing off. If you work comfortably in Microsoft Excel, understand basic data validation, and can turn this around promptly, I look forward to collaborating with you.

Project Name: Build a Microsoft Teams Search Bot ## 1. Project Overview I want to create a simple chatbot for my company's Microsoft Teams. When a staff member types an IP address or a Computer Name (Hostname) into the chat, the bot should automatically look it up in an Excel spreadsheet and reply with the details of that asset (like who owns it or its location). To keep our company data safe, I will not give the developer access to my system, and I do not want to import pre-made files. Instead, the developer will guide me over a live video call (like Zoom or Teams) while I share my screen, showing me exactly where to click on my laptop to build the bot myself. ## 2. Tools We Will Use We will use standard Microsoft tools that are already built into our company account: * Microsoft T...

I have several spreadsheets that need to be built out, cleaned up, and kept current in Microsoft Excel. The core of the job is straightforward data entry and basic spreadsheet management—copy-pasting data from source documents, organising it into the right columns, applying simple formulas where needed, and double-checking for accuracy before saving each file. You will work exclusively in Excel; no Google Sheets or other tools are required. If you have a solid eye for detail and can follow clear naming conventions, you’ll find this task smooth and repetitive—in a good way. Deliverables • Fully populated Excel workbooks provided back to me in the same file format • Zero placeholder cells or formatting errors • A short completion note outlining an...

I have several spreadsheets that need to be built out, cleaned up, and kept current in Microsoft Excel. The core of the job is straightforward data entry and basic spreadsheet management—copy-pasting data from source documents, organising it into the right columns, applying simple formulas where needed, and double-checking for accuracy before saving each file. You will work exclusively in Excel; no Google Sheets or other tools are required. If you have a solid eye for detail and can follow clear naming conventions, you’ll find this task smooth and repetitive—in a good way. Deliverables • Fully populated Excel workbooks provided back to me in the same file format • Zero placeholder cells or formatting errors • A short completion note outlining an...

I need an end-to-end Tableau dashboard that puts sales performance front and center. The data set is ready; what I’m missing is the polished, interactive layer that lets managers explore results on their own. Here is what matters most to me: • Key metrics: Total sales and Sales by product must be clearly surfaced, with room to add growth rate later if we decide it’s useful. • Visuals: Combine Bar, Line, and Pie charts so users can switch perspectives without leaving the workbook. • Interactivity: Filters by region, product category, and time period, plus hover tooltips and drill-downs that reveal underlying tables. • Storytelling: A concise KPI banner that highlights highs and lows at a glance before users dive deeper. Deliverables • A package...

I need an experienced Excel accountant who can jump in right away and structure a clean, accurate and complete assessment of the financial statements in the excel task. for my upcoming financial reporting. All figures are provided. I want the final workbook to: • flow automatically from clearly labeled input tabs to the finished solutions tab, • use formulas as much as possible (no hard-coded subtotals) so I can update figures later, and • include a brief checksum or cross-check of nevessary Formatting should match standard UK GAAP headings—Assets, Liabilities, Equity—so the file is presentation-ready for management. I’m on a tight deadline and need the completed, error-free workbook delivered ASAP, ideally within the next 24 hours. If you’re co...

i need a desktop tool which converts scanned pdfs to excel with atleast 99% accuracy. its urgent need.

I have a set of Excel workbooks that need a smarter layer of automation. Your job is to weave in solid, intermediate-level formulas—VLOOKUP, nested IF statements, and similar functions—to turn raw data into information I can slice and present quickly. Alongside the formulas, I need reliable data sorting and filtering controls as well as conditional formatting rules that instantly flag exceptions and trends. The focus is on clear, maintainable solutions; no VBA or complex array formulas are necessary. Deliverables: • Updated .xlsx file(s) with all new formulas, sorting/filtering views, and conditional formats in place • A concise in-sheet note or README explaining the logic so I can update it later I’ll share the current workbook as soon as we start and will...

I have several very large spreadsheets that need to be audited, cleaned, and uniformly formatted. The job revolves around identifying and fixing discrepancies quickly while keeping every entry accurate. You’ll be diving into thousands of rows, using VLOOKUP, XLOOKUP, and any other advanced functions you find useful to reconcile records, highlight mismatches, and verify totals. I care a lot about proper formatting—leading zeros must stay intact, text-to-number issues have to be resolved, and custom field structures need to remain consistent from sheet to sheet. Throughout the process I expect frequent spot-checks to confirm that formulas are returning the correct values and that no data has been lost or overwritten. Deliverables: • One consolidated, fully audited work...

I have a single Excel/CSV master file that captures every employee movement in the organisation, and I need a dynamic Power BI dashboard built around it. The goal is simple: the moment I replace or append the source file, every visual should refresh without any extra work from me. What the report must show: • Total headcount • Employee attrition rate • New-hire and exit counts I want users to slice these numbers region-wise, department-wise, and role-wise through interactive filters. Clear trend lines, month-over-month comparisons, and a clean summary card layout are preferred so executives can grasp churn patterns at a glance. Deliverables 1. A PBIX file containing a tidy data model, DAX measures for the metrics above, and well-labelled visuals. 2. Automated refresh se...

I need an experienced Siemens SIMATIC PCS 7 / WinCC engineer to build a read-only connector from an existing PCS 7 DCS system to an existing Excel MIS workbook. The plant already uses PCS 7/WinCC and the Excel workbook already contains formulas and a management dashboard. The goal is to automatically extract selected DCS values and populate only the approved Excel input cells without modifying plant-control logic. The freelancer should first review the actual PCS 7 setup and recommend the safest supported method, such as Siemens-generated Excel/CSV export, OPC UA/OPC DA, OpenPCS 7, Process Historian, WinCC archives, or another approved read-only interface. Scope includes: identify the correct PCS 7/WinCC data-access method; map approximately 50–100 required tags/parameters to Exc...

I have a collection of Microsoft Word documents and I need every standalone paragraph lifted out and placed into an Excel workbook, with each paragraph occupying its own row. No tables, images, or contact blocks—just the plain text paragraphs exactly as they appear in the source files. You may use any reliable method you prefer (manual copy-paste, VBA, Power Query, or a small Python script with python-docx and openpyxl) so long as the final result is clean and accurately mirrors the original wording, punctuation, and line breaks. Deliverables • One .xlsx file per Word batch, each row containing a single paragraph in sequence • Source-to-row mapping retained (either by file name in a separate column or a clear index) • Completed file returned error-free and read...

I have a collection of PDF files that contain structured tables I need moved into a clean, well-formatted Excel workbook so I can run data analysis right away. Your task is a straight conversion—no deduping, reformatting of dates, or other transformations—just an accurate, cell-by-cell transfer. Key points to keep in mind • Every table, every row: nothing can be skipped. • Three columns are critical and must be clearly preserved in the sheet: Dates, Values, and Text descriptions. Feel free to flag them with a subtle background colour or bold header so they stand out the moment I open the file. • Sheet layout should mirror the PDFs, making it easy for pivoting and charting later. Deliverable An .xlsx file (or multiple sheets if that keeps things tidy) ...

The project centres on my raw sales data, delivered to you in a mix of CSV files and Excel spreadsheets. I need the full analytical pipeline built and documented so that anyone in my team can reproduce it. First, consolidate every source in Excel and use Power Query to remove duplicates, fix date and currency formats, and create calculated columns that will later support trend analysis, sales-performance comparisons and customer segmentation. Keep the transformation steps clearly named and ordered so that refreshing future files is one click. Next, publish the cleaned table to Power BI and design an interactive, professional-looking dashboard. Key visuals should highlight monthly and quarterly trends, compare performance across product lines or regions, and let the user dive into custome...

I’d like my current Excel rota transformed into a clean, automated workbook that practically manages itself. Right now dates are out of order and shifts run together; I need everything sorted chronologically with each shift clearly separated so I can scan the week in seconds. The file must keep one critical data point—employee names—at its core, because every formula will rely on that. As soon as I enter a start and end time I want the sheet to calculate the shift length and each employee’s running monthly total automatically. If two people accidentally overlap or a shift doubles up, conditional formatting should light it up straight away. Presentation matters too. Please apply a single, professional font across the workbook; beyond that I’m not fussy about ...

I’m working with an Excel rota that has become unwieldy and hard to trust. I need you to reorganise it so every working day appears in chronological order, start- and finish-time columns calculate shift length automatically, and monthly hour totals are ready at a glance. Please separate the data by shifts (not by clients or locations) so each type of shift is simple to scan and edit. Because I frequently adjust start or finish times, all totals must update instantly through robust formulas, not manual entry. A key requirement is highlighting any scheduling conflicts; the moment two shifts clash I want clear conditional-formatting alerts so I can spot and fix issues right away. While you’re streamlining the layout, keep the original information intact—just tidy th...

I need all the text and numerical information that currently lives in several Excel and Word files transferred into one clean, consolidated Excel workbook. The end file should: • Keep the original values exactly as written—no rounding, spelling tweaks, or re-formatting that changes meaning. • Place each record in its own row, with clear column headers I can filter or pivot. • Use consistent data types (numbers stored as numbers, dates as dates, and so on). I will supply the source files, along with a short field-mapping guide so you know which column each piece of data belongs in. Please double-check totals and spellings, flag any ambiguous entries, and leave a comment where something seems off. Accuracy and neat formatting are more important to me than speed, ...

I need experienced help verifying a volume of customer data that has already been keyed into our system. The task is strictly data entry–focused, but rather than entering new records you’ll be confirming the accuracy and completeness of existing ones. You’ll cross-check each field against the original source documents we provide, flag discrepancies, correct obvious errors, and leave clear notes wherever something can’t be resolved. Everything lives in a shared Google Sheet that connects to our CRM, so solid spreadsheet skills and care with formulas, filters, and simple look-ups will speed your work. Confidentiality is crucial because the file contains names, contact details, and purchase histories. Deliverables • A fully verified sheet with corrected or ann...

I have a collection of PDF files that need to be converted into a single, well-structured Excel workbook. Some of these PDFs contain selectable text you can copy directly, while others are scanned images that will require reliable OCR before the content can be placed in the spreadsheet. I will supply an Excel template with pre-defined columns and formatting guidelines; your task is to populate it faithfully, preserving line breaks and text order exactly as they appear in the source. I expect clean, error-free entries, so please use tools you trust—Adobe Acrobat, ABBYY FineReader, or any OCR software that delivers high accuracy—then proof the result before saving. If any characters remain unclear after OCR, create a brief comment log noting the page number and context. Deliver...

A batch of digital files (e.g., PDFs) contains plain text that must be transferred, line by line, into a structured Excel workbook. The task is entirely text-based—no numbers or calculations—so accuracy in spelling, punctuation, and spacing is essential. I will supply the PDFs and a template spreadsheet with the required column headers. Your job is to read each PDF, capture the relevant text exactly as it appears, and place it in the corresponding cells. If a PDF page includes headers, footers, or incidental content, leave those out unless I flag them as needed. Deliverables: • Completed Excel file populated with the extracted text • A brief note highlighting any unreadable characters or ambiguous passages Before starting, confirm you can open standard PDFs and w...

I have a collection of PDF files filled with text-based content. The information I need copied is confined to the Introduction and Summary sections of each document, and the text in those sections appears only as flowing paragraphs—no tables or bullet points. Your task is straightforward: open each PDF, isolate every word from the specified two sections, and enter the material accurately into an Excel workbook I’ll provide. Each PDF should occupy its own row, with separate columns for the Introduction and for the Summary so I can filter and sort later. Accuracy is critical: line breaks do not matter, but every sentence and keyword must be captured exactly as written, without omissions, additions, or spelling changes. If a file is unreadable or the required sections are missin...

I need support handling a steady flow of numerical information that currently sits in various raw files. Your main focus will be: • Entering the numbers into clearly structured Microsoft Excel spreadsheets, following my column layout and file-naming conventions. • Cleaning and organizing the data as you go—removing duplicates, standardizing number formats, fixing obvious inconsistencies, and flagging anything that looks questionable. Accuracy is critical; totals must reconcile and every record must line up with its source. I will provide the raw files, the target template, and brief written guidelines. Regular check-ins over chat or email keep us on schedule, and I expect the first batch turned around within two days of receipt. If we work well together, there will ...

I’m putting together a showcase-worthy sales workbook for my Data Entry & Excel portfolio and need an expert touch. The dataset is retail-focused and will be a mix of records I supply and additional, realistic entries you create to round it out. Everything must live in a single Excel file and look clean, consistent, and professional. Here’s what I’m after: • A well-structured table that holds customer and product details, quantities, unit prices, order dates, payment status, and a calculated line total. • Thorough data cleaning and formatting so every field is validated, dates align to one format, and currency values carry two decimals. • Built-in formulas (SUMIFS, COUNTIFS, IF, XLOOKUP or similar) for automatic totals. • Sorting and filter...

I have a sizeable set of financial data that needs to be turned into a clean, well-structured workbook ready for immediate reporting or deeper analysis. Here is what I need done: • Data cleaning: remove every duplicate entry and correct any inconsistent formats so dates, currency, and percentages all display uniformly. • Logical organisation: sort and filter the data into an intuitive layout that anyone on my team can follow at a glance. • Formula layer: build a solid framework of Sum, Average, IF statements, plus VLOOKUP and HLOOKUP so common comparisons and roll-ups are automatic. • Final polish: apply clear headings, freeze panes, and light conditional formatting so key figures stand out without clutter. The finished file should open with no warnings, pass ba...

I have a set of PDFs whose contents—straightforward text and numbers—are already laid out in neat, highly structured tables. All I need is for that information to live in an Excel workbook, arranged in simple, standard columns and rows so I can sort, filter, and run quick calculations without fighting with formatting. Speed is welcome, but accuracy is critical. Every value must match the source exactly, including any decimal places or units shown in the files. Typos, misplaced rows, or skipped entries will break the downstream reports that depend on this sheet. Deliverable: • One clean .xlsx file containing every record from the PDFs, with each original column preserved in the same order across all pages. I’m open to whatever method you prefer—manual entry, ...

I have an automated Excel-based rostering workbook that has been running in production for a while, but a few critical pieces now need attention. The core of the job is to refine the calculation logic. Some totals are coming out wrong, a couple of edge-case rules were never coded, and overall processing speed has slipped as the file has grown. I would like the existing formulas/VBA adjusted so every shift, allowance and overtime rule reconciles accurately, a set of new business rules is added, and execution time is brought back to an instant feel. Alongside that, I need the import/export module expanded. At present it handles only a basic CSV; I want to introduce two additional formats (one XLSX template we use with payroll and a JSON summary we send to Power BI). Clean, reliable parsi...

I have an existing VBA routine in my workbook that pulls end-of-day natural-gas quotes from an online source and drops them straight into a dedicated sheet. Lately the data is coming in, but the columns arrive out of order—prices, volumes, and dates no longer line up, so charts and formulas break. The connection itself still completes and I am not seeing any run-time errors; the only problem is this misaligned-column formatting issue. I need you to trace where the shift happens, correct the parsing or write a cleaner import routine, and leave the data neatly aligned exactly as the sheet expects. You’ll have remote access to a sample workbook plus the small chunk of VBA (about 60 lines) that handles the web request and paste operation. Please return a fixed version or, if ...

A spreadsheet with detailed instructions is attached, and I need the entire assignment completed exactly as outlined there. The work involves three core pieces: • Data entry – copy the raw values into the correct sheets and ranges without altering formatting. • Formulas and calculations – build dynamic formulas (SUMIFS, VLOOKUP/XLOOKUP, pivot tables if specified) so every total, percentage, or lookup updates automatically when source data changes. • Creating charts – generate the charts requested in the file, styling them to match any colour or layout cues already present. Please keep every worksheet structure intact, add only the cells or tabs the assignment explicitly calls for, and double-check that all formulas return the same answers shown in the...

I have a collection of PDF reports that contain only numerical tables and I need every column transferred into Excel with absolute accuracy. The task is straightforward data extraction—no calculations or interpretation—just a faithful, one-to-one move of all table columns into a clean .xlsx file. Each table in the PDFs must appear on its own sheet, keep the same column order, and preserve any header names exactly as shown. The numbers cannot be rounded or reformatted; they must remain identical to the source so cross-checking totals against the original files comes out perfect. Deliverables • A single, well-organized Excel workbook with each PDF table on a separate tab • Spot checks completed so the final figures reconcile perfectly with the PDFs • A br...

I have a live Google Sheet that serves as my online database and it’s packed with pure numbers—sales figures, performance metrics, and a few calculated fields. I need every one of those values re-entered into the designated columns of a fresh template while keeping the exact order, formatting, and decimal precision intact. You’ll work directly in Google Sheets (or download to Excel if that speeds you up) and follow my short naming convention for tabs and ranges. Consistency matters more than speed: a single misplaced digit throws off automated reports downstream, so double-checking is expected. Deliverables • A fully populated template sheet matching my column layout
 • A brief verification log that highlights any ambiguous entries you flagged and how th...

I have a sales dataset in Google Sheets that I’d like turned into clear, insightful pivot tables. Your job is to set up each pivot so I can quickly slice totals, averages, and counts by product, region, and date without touching the raw sheet. Please build the pivots directly in my shared Google Sheet, label each tab logically, and add a short note beside every table explaining the filters and row/column logic you used. Once done, I should be able to refresh the data or add new rows and have the pivots update with a single click. If you’ve created dynamic pivot views in Google Sheets before and are comfortable working with sales-oriented metrics, this should be a quick engagement.

I have several Excel workbooks that contain raw income-statement figures. Before I can run any meaningful analysis, the data needs a careful pass of cleansing—removing duplicates, fixing inconsistent formats, standardising account names—and then re-entered into a tidy, well-structured sheet that aligns with my chart-of-accounts layout. Here is what I expect: • Every line item in each workbook reviewed and corrected for spelling, date and numeric formatting. • Uniform column order (period, account code, account name, amount, notes). • One consolidated, error-free master sheet delivered back in .xlsx format. I will provide the existing Excel files and a brief style guide for headers and acceptable account names. No OCR or PDF conversion is required; everythin...

I want a clean, intuitive spreadsheet that lets me keep track of every book I’ve finished. The main goal is simple: organise the books I’ve read so I can quickly see what’s in my personal library and find titles again later. Here is the core information I want to capture for each entry: title, author, a flexible “tags” field (so I can label genres or themes), space for personal notes, the cover image, and a direct link to where the book can be read or purchased. A well-structured header row and sensible column widths will make data entry painless. Formulas aren’t a big focus; basic counts or summaries you feel are useful are fine, but nothing complex is required. What matters most is tidy formatting, easy sorting and filtering (especially by tags or au...

I need the tables locked inside several PDFs transferred into a clean, well-structured Excel workbook. The source tables include merged cells, so a simple copy-paste will not preserve the layout; every field must be placed in the correct row and column manually or with a reliable extraction workflow. High accuracy is essential: totals, character spacing, and any special symbols must match the original documents exactly, with no dropped or shifted data. Deliverables • One Excel file (XLSX) replicating each table’s structure and content in separate sheets or a clearly labeled format that makes sense for quick analysis. • Consistent column widths and headings so I can filter and run formulas immediately after delivery. • A brief note describing any ambiguity y...

I have an Excel spreadsheet filled with traveler details. Your task is to take that file, follow the step-by-step method I’ll demonstrate inside the Travel Line mobile app, and create a unique customer ID for every traveler. The workflow is straightforward once you see it in the app: • import or copy each row’s data, • apply the in-app ID-generation steps exactly as I show, • note each finished ID back into the Excel file. Accuracy and consistency are critical—every ID must be accepted by the app with no duplicates or spelling errors. When the list is complete, return the updated spreadsheet and a quick confirmation report summarizing how many records were processed and any issues you encountered. Remote screen–share training takes about t...

I have a collection of PDF files containing mixed text and numeric information that must be transferred into structured Excel workbooks so the data can be fed straight into my downstream processing routines. Your focus will be on accuracy and faithful layout replication rather than analysis or reporting. For each PDF you will: • Extract every field and line item, preserving spelling, punctuation, and numerical precision (no rounding). • Organise the content into clearly labelled columns and, where relevant, separate sheets to mirror logical sections of the source document. • Keep number formats (dates, currency, percentages) native to Excel so formulas recognise them instantly. • Flag any illegible or ambiguous entries in a dedicated “Issues” sheet....

Hello, I have a list of details, using those you need to collect a lot of data from a specific website. I will show you how to scrape the details like Name, Email, and Phone numbers, you just need to follow the pattern..

Not so much of a project, but a relatively simple task for an experienced Microsoft Word geek. I have two Microsoft files. v1 was created and saved after 5mins in April this year. Unfortunately, it does not contain some final drafting that was lost when I clicked the wrong button at the time. v2 of the document is a simple cut-n-paste of the original with corrected 2nd bullet (highlighted) My Ask/Request Update to the original v1 document with the 2nd bullet replaced with (v2 Bullet 2) without changing the original Properties. OR the v2 document (as is, no change to document content) but showing the original document properties (last modified & created) see attached Word file called Document Properties. The final Word document - whichever approach (above) is taken needs to have h...

Saya mencari seorang admin yang dapat saya percayai untuk menangani penjadwalan tugas harian menggunakan software manajemen tugas khusus (bukan Excel atau Google Sheets). Fokus Anda adalah memastikan setiap tugas tercatat rapi, memiliki tenggat jelas, dan ter-update tepat waktu. Ruang lingkup: • Membuat dan memelihara daftar tugas harian di aplikasi yang saya gunakan (detail akses akan saya berikan). • Menetapkan prioritas, tenggat, dan pengingat sesuai arahan saya setiap hari. • Memantau progres serta menandai tugas selesai atau memindahkannya bila ada perubahan prioritas. • Mengirim ringkasan status harian singkat melalui chat atau email di akhir hari kerja. Saya mengutamakan ketelitian, komunikasi cepat, dan sikap proaktif dalam menyarankan perbaikan alur ker...

Saya membutuhkan bantuan di bidang administrasi, khususnya dokumentasi, untuk menyusun laporan keuangan yang rapi, akurat, dan mudah dipahami. Ruang lingkup pekerjaan meliputi: • Mengumpulkan dan memverifikasi data transaksi dari berbagai sumber internal. • Menyusun laporan laba rugi, neraca, dan arus kas dalam format spreadsheet yang konsisten. • Menambahkan penjelasan singkat (notes) atas pos-pos penting agar laporan dapat langsung dipresentasikan ke manajemen. • Membuat template standar agar tim dapat memperbarui laporan di periode berikutnya tanpa memulai dari nol. Saya mengutamakan ketelitian, kerahasiaan data, dan kecepatan penyelesaian. Jika Anda terbiasa menggunakan Excel atau Google Sheets serta memahami prinsip dasar akuntansi, berikan contoh laporan s...