Visual Basic Jobs

I have two related workbooks. Sheet 1 is my working file; Sheet 2 holds the customer information I need to reference. Both sheets share a unique reference code, and I want a single, reliable formula—ideally built with HLOOKUP—to pull the customer data into the correct columns of Sheet 1 every time the reference appears. Here’s how I’d like to tackle it: • We jump on a quick 30- to 45-minute call with screen-share. • You review the current structure, insert the lookup formula where it belongs, and test it on a few rows. • You leave me with a short note explaining how the formula works so I can extend or tweak it later. I prefer HLOOKUP because the customer fields run across columns, but I’m open to VLOOKUP or INDEX/MATCH if you think they&...

I need someone who can sit with me this afternoon and again tomorrow afternoon in Daman or Vapi and help knock out a very simple Excel task. The file contains mixed data that just has to be copied and pasted into the right spots, then given a quick tidy-up. After a five-minute walkthrough I’ll provide, your job is to: • enter the records exactly where shown, • use basic formatting only—mainly data sorting, filtering, and a couple of straightforward formulas to keep totals correct. No macros, no complex analytics—just clean, accurate entry and a neatly organised sheet by the end of each half-day. Bring a solid grasp of Excel shortcuts, show up on-site for both sessions, and we’re good to go.

I need someone who can sit with me this afternoon and again tomorrow afternoon in Daman or Vapi and help knock out a very simple Excel task. The file contains mixed data that just has to be copied and pasted into the right spots, then given a quick tidy-up. After a five-minute walkthrough I’ll provide, your job is to: • enter the records exactly where shown, • use basic formatting only—mainly data sorting, filtering, and a couple of straightforward formulas to keep totals correct. No macros, no complex analytics—just clean, accurate entry and a neatly organised sheet by the end of each half-day. Bring a solid grasp of Excel shortcuts, show up on-site for both sessions, and we’re good to go.

I have an Excel workbook packed with productivity figures that needs to tell its story clearly in an upcoming presentation. My audience is non-technical, so visuals must be intuitive: clean tables with strategic highlights rather than complex charts. Here’s what I need: • A set of formatted tables that surface the key productivity metrics—think conditional-formatted cells, sparklines, or color-coded variances—so trends and outliers pop at a glance. • An easy-to-follow layout: summary at the top, detailed breakdowns below, each section clearly labeled for quick navigation when I’m presenting. • Light automation where it helps (simple formulas, named ranges, perhaps a few slicers) so I can refresh the data without re-doing the design. Accept...

I have a PDF of well over 50 pages that blends narrative text with numerous embedded tables. I need every page reproduced in Microsoft Excel so the spreadsheet looks and reads exactly like the source—same column order, fonts as close as possible, spacing, and page breaks. Deliverables • One Excel workbook with a separate sheet for each original PDF page (or another clear structure that still preserves page order) • All text, table data, and simple graphics positioned to match the PDF layout identically • No loss of characters, line wraps, or merged-cell problems Acceptance criteria When I place the PDF and the Excel file side by side, nothing should be missing or displaced; scrolling through either should feel like the same document in a different format....

I have a sales performance sheet. I want an experienced person who is specialized in advanced Excel formulas and who can automate the sheet. The sheet is already automated. Some of the formulas are not working, and I want to add some more stuff into it, so I need someone who can actually do the stuff.

Hi there! Fixed budget & Looking for resonable canditade allowed! I need to streamline a recurring data-analysis routine that currently takes me hours of manual work each week. The raw data arrives in several worksheets and, from there, I want one clean, automated flow that: • pulls the latest dumps into a master sheet • applies dynamic formulas and functions to flag key metrics, spot variances, and summarise totals automatically • refreshes itself with a single click so I can hand the file to colleagues with zero additional steps Formulas and functions sit at the core of this job. If you decide that a few pivot tables or quick charts would clarify the insights, I’m open to that, but the heavy lifting must happen through well-structured formulas that are easy to...

I need help transferring my inventory records—specifically product names and their current quantities—into an Excel workbook. I already have a clean template laid out; your task is to populate it accurately, double-checking spellings, units, and any duplicate item names so the file is ready for immediate use in our system. You will receive the raw data in a text file and a copy of the template. Simply complete every required column, save the workbook, and return it. Experience with Excel functions such as data validation or conditional formatting is welcome, but not mandatory—the key requirement is precise, error-free entry. Deliverable: the filled Excel sheet, fully matching my template, delivered in XLSX format.

I have several business-critical Excel spreadsheets that I want transformed into clear, interactive dashboards inside Power BI. The job starts with connecting those workbooks, cleaning and modelling the tables so they refresh smoothly, and then designing visuals that let any stakeholder spot trends, outliers and KPIs at a glance. You’ll have freedom over DAX measures and layout as long as the end result meets these acceptance points: • One unified data model that auto-updates when the source files are replaced in the same folder • At least three slicer-driven report pages combining charts, tables and cards for quick drill-downs • Clear colour styling and titles so non-technical users understand every visual without extra guidance • A short hand-off note exp...

I have an existing Excel workbook that I use as a lightweight database, and I’m looking for dependable support to keep it clean and current. The job is straightforward data entry: you’ll be copying mixed text-and-numeric records from source documents into the appropriate worksheets, following the column structure that is already in place. Consistency is critical; every field must follow the exact formatting rules I provide so lookups and pivot tables continue to work seamlessly. You do not need to build formulas or perform analysis this time; the focus is on precise, timely data entry. Experience with Excel features such as data validation, freeze panes, and basic filtering will make the process smoother, but the main requirement is an eye for detail and the discipline to doub...

I have a PDF of well over 50 pages that blends narrative text with numerous embedded tables. I need every page reproduced in Microsoft Excel so the spreadsheet looks and reads exactly like the source—same column order, fonts as close as possible, spacing, and page breaks. Deliverables • One Excel workbook with a separate sheet for each original PDF page (or another clear structure that still preserves page order) • All text, table data, and simple graphics positioned to match the PDF layout identically • No loss of characters, line wraps, or merged-cell problems Acceptance criteria When I place the PDF and the Excel file side by side, nothing should be missing or displaced; scrolling through either should feel like the same document in a different format....

I have several existing spreadsheets that contain a blend of text and numerical fields. They now need to be brought together into a single, well-structured Excel workbook. Your task is to copy the data across, preserve every character and figure exactly as written, and apply consistent formatting so the finished file is easy to filter, sort, and run formulas on. Accuracy is essential—please double-check that text strings stay intact, numbers keep their original decimal places, and column headings remain uniform throughout. Where you spot obvious typos or irregular spacing, correct them as you go so the final sheet is clean. Deliverable: • One polished Excel file that merges all source sheets, with data validated and neatly formatted. If you’re comfortable moving mixed d...

I’m looking for a creative video editor who can turn raw clips into eye-catching social media content. The focus is short-form edits for Instagram Reels, YouTube Shorts, and TikTok, each optimised for its native aspect ratio and style. What you’ll work on • Edit 15–60-second videos that feel organic to each platform • Add dynamic captions, colour grading, basic sound clean-up, and royalty-free music or trending audio • Incorporate subtle motion graphics or transitions that keep viewers engaged without overpowering the message • Deliver platform-specific exports (vertical 9:16 for Reels/TikTok, 1:1 or 9:16 for Shorts) What I’ll provide • Raw footage or stock clips, brand colours and fonts • A shot list or rough storyboard...

I have an Excel workbook in which numeric entries are a mess—some are real numbers, others are text strings littered with stray symbols, and quite a few mix commas and periods as decimal separators. I need every monetary figure, in every column that contains numeric data, converted so it behaves as a true number and displays in a single, consistent currency style: the $ symbol with two decimal places. Your task is to hunt through the file, detect any value that should be treated as money, automatically recognise whether the comma or the point is acting as the decimal marker, correct it, and then apply the chosen format. Dates, percentages, text, formulas, and the workbook’s structure must stay exactly as they are; after the cleanup nothing should break or recalculate incorrect...

I’m looking to turn a scattered set of rollout spreadsheets into one clear, interactive dashboard that lets me see exactly where every site sits in the life-cycle—from initial installation all the way to On-Air. I have no fixed preference on the platform, so feel free to build in either Excel (Power Query/Pivot, slicers, VBA if needed) or Power BI; choose whichever will let you structure the data model cleanly and keep future updates simple. Core view I need • Progress by site and phase: Installation → Integration → Testing → On Air, with automatic percentage-complete calculations. • At-a-glance flags for any milestones slipping behind their target dates. • Filters by region, vendor, tech (2G/3G/4G/5G) and project manager. Nice-to-have layers If ...

I have a designated Windows folder that keeps filling up with new PDF reports. Every table or other structured block of data inside those PDFs must land in an Excel workbook automatically, without me pressing a button. Here is the core workflow I need built: • The moment a PDF is dropped into (or removed from) the monitored folder, the solution scans it, pulls every table or structured dataset, and appends the results to an ever-growing database area in Excel. No data should be overwritten. • Each row (or logical record) must include the source-file name and timestamp so I can trace anything back to its original PDF. • The Excel layout itself—columns, headers, any calculated fields, summaries, or pivot tables—will be finalised together once the extraction log...

I have a batch of customer information that needs to be transferred into a single, well-organised Excel workbook. The dataset contains three elements for every record: contact details (name, phone, email, address), a concise purchase history, and any feedback the customer has provided. Accuracy and consistent formatting are critical because the file will feed directly into our CRM once complete. You’ll receive the raw material in mixed formats—mostly CSV exports and a few PDF sales reports—and the current column layout I use. The job is straightforward data entry, but I expect duplicate checking, basic data validation, and clear separation of the three information types so they can be filtered or pivoted later. Deliverables: • Completed Excel file with all customer...

I’m streamlining several internal projects in Google Sheets and want a tech-savvy hand to bring them together. The core file needs clean data entry workflows, well-structured tables, custom formulas that cut down on manual math, plus clear summaries and charts that anyone on my team can read at a glance. My main goal is to take the repetitive typing out of the process. I’d like an OpenAI-powered script—or any sensible approach you suggest that still leverages the OpenAI API—to recognize incoming text, classify or transform it, and drop it into the right cells automatically. Once that foundation is solid, the sheet should run its own calculations and refresh the visuals without extra clicks. Deliverables • A Google Sheet template (or connected workbook) with...

The goal is to develop a robust Windows Forms application in VB.NET that streamlines barcode scanning, label printing, and production traceability across our automobile manufacturing lines. Core workflow • Operators will scan components through handheld barcode readers connected over both serial and TCP. Every scan must be validated against a local SQLite database in real time, blocking duplicates instantly and raising an audible/visual alert. • Once validated, the system will trigger ZPL commands to a networked Zebra printer, producing both QR Code and Code128 labels according to predefined templates. • All transactions feed a production-tracking module that updates three key dashboards: real-time production metrics, workstation-based tracking, and shift performance ...

I need the text content from a set of web pages placed into a clean, well-structured Excel workbook. I will share the list of URLs; your job is to visit each page, capture the required text precisely, and enter it into the spreadsheet following the column layout I provide (e.g., headline, author, body, date). Accuracy matters more than speed—spelling, punctuation, and line breaks must match the source, and no extra formatting should be introduced. When a page contains multiple text blocks, keep the original order so the material remains easy to trace back. Deliverables: • One Excel file (.xlsx) containing all extracted text, fully populated and ready for review. I’ll be available for questions as you work and will check progress periodically, so please save earl...

I have several Excel workbooks that contain a blend of text and numeric fields, and I need every row copied into a single master sheet with 100 % accuracy. Everything you’ll work with is already in digital form, so the task is pure data entry and validation—no scanning or transcription from print. You will receive: • All source spreadsheets • A destination template that shows the required column order and cell formats What I need from you: • Transfer each record exactly as it appears, following the provided column map • Maintain number formatting (decimals, dates, currency) and preserve text capitalisation • Spot-check totals or obvious anomalies and flag anything that looks out of place When you finish, I should be able to open the master shee...

The goal of this project is to improve warehouse and logistics operations through accurate data management, shipment tracking, inventory control, and process optimization. The freelancer will deliver: - Custom Excel templates for daily operations, inventory management, shipment tracking, and MIS reporting. - Automated dashboards and reports using Excel formulas, Pivot Tables, and charts. - Process optimization suggestions to enhance productivity and reduce delays. - A tracking system for order status, rider performance, and inventory accuracy. - Data analysis support to identify operational issues and improve workflow efficiency. - Easy-to-use formats for daily use by warehouse and logistics teams.

I run a micro-business in Ireland and need the last trading year laid out as a clean, well-structured Excel file. All transactions are already in digital form—PDF invoices, bank CSVs, and card statements—but nothing lives in Excel yet. Your job is to import those records, categorise every line, reconcile totals, and produce both an income-and-expense view and a concise balance sheet that fits Irish micro-entity requirements (very close to UK rules). I don’t have a fixed template in mind, so feel free to suggest or build one that keeps things clear and easy for me to maintain next year. Automation with simple formulas or pivot tables is welcome as long as everything remains transparent. Deliverables • Excel workbook with separate sheets for the raw ledger, summarise...

I have a working Excel VBA macro that end-users should be able to run, but I don’t want them to see or tinker with the underlying code. I’d like you to implement password protection on the VBA project so that: • The code window stays hidden unless the correct password is entered. • Users can still execute the macro without needing that password. • Both viewing and editing the code are blocked. Compatibility needs to span any common desktop build—Excel 2016, 2019, and Microsoft 365—so please use methods that work across those versions with no add-ins required on the client’s side. Deliverables I expect: 1. The secured workbook (or a stripped-down sample if you can’t touch my production file) with the password protection in place. 2. ...

I’m looking to turn a scattered set of rollout spreadsheets into one clear, interactive dashboard that lets me see exactly where every site sits in the life-cycle—from initial installation all the way to On-Air. I have no fixed preference on the platform, so feel free to build in either Excel (Power Query/Pivot, slicers, VBA if needed) or Power BI; choose whichever will let you structure the data model cleanly and keep future updates simple. Core view I need • Progress by site and phase: Installation → Integration → Testing → On Air, with automatic percentage-complete calculations. • At-a-glance flags for any milestones slipping behind their target dates. • Filters by region, vendor, tech (2G/3G/4G/5G) and project manager. Nice-to-have layers If ...

I have a designated Windows folder that keeps filling up with new PDF reports. Every table or other structured block of data inside those PDFs must land in an Excel workbook automatically, without me pressing a button. Here is the core workflow I need built: • The moment a PDF is dropped into (or removed from) the monitored folder, the solution scans it, pulls every table or structured dataset, and appends the results to an ever-growing database area in Excel. No data should be overwritten. • Each row (or logical record) must include the source-file name and timestamp so I can trace anything back to its original PDF. • The Excel layout itself—columns, headers, any calculated fields, summaries, or pivot tables—will be finalised together once the extraction log...

I have 6-10 PDF files, each containing a mix of tables and charts, and I need every figure transferred accurately into Microsoft Excel. There’s no predefined template you have to follow; a clear, logically-structured worksheet is all that’s required. Accuracy is paramount—numbers, headings, and any text labels from the PDFs must match the source exactly. If a chart’s underlying data isn’t explicitly visible, you’ll need to recreate it in tabular form so the spreadsheet can be used for further analysis. Please let me know how quickly you can begin, the method you prefer for extracting table data (manual entry, Adobe Acrobat, OCR tools, etc.), and any checkpoints you suggest to verify accuracy before final delivery. I’m ready to get started rig...

I’m ready to hand the repetitive parts of my operation over to AI and I need someone who already speaks Openclaw fluently. The goal is to link every moving piece—customer service, inventory, and sales—so they run without me hovering over them. Customer service first: I want an AI-driven help desk that can answer FAQs in real time, process straightforward orders on its own, and automatically drop new contacts into a messaging sequence that nurtures, qualifies, and converts them. Think of it as a chatbot that sells as well as it supports. For inventory, the critical piece is intelligent reorder alerts. The system should watch stock levels, predict when we’ll run low, and fire off a timely prompt—email, Slack, SMS, whatever integration Openclaw handles best&mda...

I’m developing a 3D scene where money-themed motifs wrap around a series of architectural pillars, and carefully placed back-lighting gives the structure real depth. I already have the core concept sketched; what I need now is a skilled 3D artist who can turn that vision into a clean, production-ready model with textures and lighting that feel tangible on screen. You’re free to work in Blender, Maya, 3ds Max, or a comparable tool—just keep the final files exchange-friendly. Realistic scale, accurate UVs, and a lighting rig that makes the relief of the notes pop against the columns are essential. Subtle details like engraved edges on the currency and soft falloff from the lights will sell the effect, so a good eye for material setup (PBR workflows preferred) is important....

I run a packaged-water and cold-drink distribution service in Sitapur and I’m ready to move the entire record-keeping process into a single, reliable workbook in Excel or Google Sheets. What I need built is a clear, easy-to-use file that: • lets me enter each day’s deliveries in seconds, • automatically updates the stock of 20-liter bottles in circulation and on hand, and • rolls everything into accurate, customer-specific monthly bills I can print or export. I already know the headings I want—date, route, customer name, quantity, bottle returns, payment status—but the formulas, look-ups, and structured tables that tie it all together are where I need your expertise. A lightweight dashboard or pivot chart that highlights low stock and outstandi...

I already have a fully-built Power BI report that pulls our Balance Sheet and Profit & Loss, but some numbers are off. I’ve traced the issues to data discrepancies in the Assets and Liabilities sections of the Balance Sheet and similar discrepancies flowing through to the P&L. Here’s what I need from you: • Open the existing .pbix, trace the data sources, queries, and measures, and identify why the Assets and Liabilities figures are wrong. • Apply the same rigorous check to the P&L so every figure aligns with our source ledger. • Once everything reconciles, deliver a clean, version-controlled .pbix file with all discrepancies fixed and clearly documented. I work in a standard Microsoft stack (SQL Server + Excel feeds), so familiarity with Pow...

I need help transferring a set of mixed text and numerical records into a clean, well-structured Excel spreadsheet. Everything will be keyed in manually—no file imports or automated scripts—so attention to detail and fast, accurate typing are essential. Scope of work: • Enter each record exactly as provided, preserving capitalization, punctuation, and numeric precision. • Follow my column order and any cell-formatting notes I supply. • Double-check for typos, missing fields, and consistent data types. • Deliver the finished .xlsx file plus a brief summary of any issues or ambiguities you encountered. I’ll share the source documents and a template as soon as we start. If you’re comfortable with Excel functions like basic validation and con...

I need a custom quality-control form that my team can open on an Android tablet, fill in quickly, and have every entry land neatly in a standard Excel table. The form must accept free-text notes, numeric measurements, and checkbox or multiple-choice selections without forcing the user to jump between screens. it also needs to include an image associated code and generate automatic numbers and SKU numbers. A clean, minimalistic interface is essential so inspectors can focus on the job rather than the software. Arabic Speaking is Highly Encouraged as the form is in Arabic Please build the form so the collected data flows straight into a regular .xlsx sheet (one row per inspection), ready for downstream analysis and reporting in Excel. If you propose a no-code or low-code app builder, an Ex...

I have an existing Excel workbook that needs to be populated with numerical data only. The structure of the sheet is already set up; what is missing are the actual figures. Accuracy is critical because the file feeds directly into my internal reports, so any typos or misplaced decimals will create downstream issues. You will receive: • The blank workbook with clearly labeled columns and any notes on acceptable value ranges. • Source documents containing the numbers to be entered. What I need back: • The same workbook returned, fully completed, double-checked for errors, and saved in .xlsx format. • A brief note highlighting any anomalies you spotted while entering the data (e.g., unreadable figures, missing values). Time is of the essence—I’d like the fin...

I have a ready-made Excel template and need all records typed accurately into the four columns—NAMA, NIK, NO KK, and ALAMAT. The structure is locked, so you will not add or reorder any fields. For NIK and NO KK, I follow national standards: each value must contain the exact number of digits (I will confirm the length guide with you before you begin), no spaces or separators, and every entry has to pass a simple checksum I run at the end. If a source record is incomplete or fails the length rule, you will flag it in a note column that already exists in the file. Because the sheet is already laid out, your task is purely data entry plus a quick self-check for those basic formatting rules. When you return the file I will run an automated validation; the job is considered finished once...

I need a Microsoft Access document to track important data, specifically to import from Excel files. Key requirements: - Ability to import data from Excel (XLS/XLSX) files - User-friendly interface for data tracking - Secure and organized data storage Ideal Skills and Experience: - Proficiency in Microsoft Access - Experience with data import from Excel - Strong database design skills - Attention to detail and data accuracy Please provide samples of previous Access projects if available.

I need an interactive Excel dashboard that lets me analyse three core KPIs—sales performance, customer satisfaction and employee productivity—in a single, easy-to-read view. The workbook should focus on data analysis rather than static reporting, so everything has to update automatically when new data is pasted into the model. My preferred visual format is clear, well-labelled charts (bar, line or combo where appropriate). Tables can sit behind the scenes for calculations, but the front end must stay chart-centric and visually balanced. Slicers or drop-downs for date ranges, regions or product lines will help me drill into the numbers quickly, so please add them where you think they add value. Deliverables • One Excel (.xlsx) file containing:  – Dynami...

I’m looking for a clean, well-commented Visual Basic solution that lets me pick any drive letter or folder on my machine and back it up to a mapped local network drive. The tool must be easy to configure yet reliable enough to safeguard both documents and critical system files. Core behaviour • User selects the source (drive or individual folder) and the destination network share. • The program can schedule automatic runs—daily, weekly, or at a custom interval—without my needing to keep the window open. • Before writing to the network share, selected files are compressed. • Once the job finishes, an email notification summarises success or failure. Please code everything in pure Visual Basic; I’ll open the project in the standard VB envir...

Make a professional banking app in Microsoft access format. Currency preferably in (K) Zambian kwacha It should be able to collect customer, account, and transaction details e.g. bank statements, loan details.

I need help getting a group of text-heavy article and blog pages properly into Google’s index. At the moment Search Console reports three specific problems: • “Crawled – currently not indexed” is the most common flag. • A handful of URLs sit in “Page with redirect.” • Several alternates show “Alternate page with proper canonical tag,” yet they have never been processed. Although I already run standard SEO plugins, the issue clearly goes deeper than basic on-page optimisation. I am looking for a precise technical fix that: 1. Identifies why Google can crawl but refuses to index these posts. 2. Corrects any redirect chains or loops so the “Page with redirect” status clears. 3. Verifies and, if necessary, rewrites c...

I need a self-contained Windows application that lets me issue professional invoices while keeping an eye on stock levels in real time. The inventory module must offer straightforward stock tracking—add and edit items, register incoming deliveries or outgoing sales, and flag low-level alerts automatically. On the invoicing side, customizable templates are essential. I want to drop in my logo, choose colors and fonts, decide which columns show, and save multiple designs for different client types. Every time I finalize an invoice, the corresponding stock should adjust automatically, and I should be able to export the document to PDF. Basic reports that show sales totals, current inventory valuation, and low-stock items will help me validate everything at month-end. Deliverables ...

I need a reliable spreadsheet workflow that lives comfortably in both Excel and Google Sheets. The core of the job is to take data that arrives via an API, drop it cleanly into the sheets, and make sure every row is immediately useful. Here’s what I want to achieve: • Seamless data entry from the API to predefined tables, with proper type handling so numbers, dates, and text all land in the right format. • Robust formulas and functions that calculate key metrics the moment new data appears—think dynamic lookups, conditional logic, and any custom calculations the dataset demands. • Built-in analysis tools such as summaries, pivot-style views, and clear visual cues that let me spot trends fast. I’m in no rush, so we can iterate until everything is...

I have a raw Excel workbook that must be cleaned, structured, and fully analysed today. The priority is to extract clear insights—think pivot-table summaries, meaningful charts, and concise findings—so I can make immediate decisions from the data. Because timing is critical, I will only consider freelancers who can demonstrate solid, hands-on experience performing data analysis in Microsoft Excel (formulas, Power Query, PivotTables, and basic VBA are all welcome if they speed things up). Deliverables (today): • The updated Excel file with all cleaning steps, formulas, and analysis embedded • A separate summary sheet (or brief PDF) highlighting key metrics and any notable trends If you can commit to turning this around within a few hours and have the expertise t...

I’m looking to have a small Windows-desktop application built that lets our team manage fuel usage and billing in one place. The idea is simple: • I drag-and-drop three files into the program—our monthly fuel statement, each branch’s litres sheet (tracked by litres only) and the Cars+ export that shows what we’ve billed. • The app matches the data, flags any litres we haven’t charged for, and stores everything so I can drill down by branch. • When I pick a branch from a dropdown, I want to see a clear on-screen report and be able to click “Export” to save that branch’s report as a PDF for follow-up. Required file formats are Excel & PDF, so the import routine needs to parse both reliably. The finished build should run...

I have several Excel and Google Sheets that together exceed 5,000 rows. The files already contain mixed-quality information and new rows are still arriving, so I need help both entering the incoming data and bringing every column in the existing sheets to a consistent, reliable format. What the job involves • Enter each new record exactly as supplied, keeping existing column order. • Standardise all date, currency, percentage and phone-number fields so every row follows one clear format. • Flag anything clearly inconsistent rather than guessing at a value. You will work directly inside the original Excel workbooks or the shared Google Sheets, whichever is easier for you, but the final delivery must preserve both versions. Basic formulas, filters and conditional forma...

I need an Excel sheet to manage and track inventory data. The sheet should allow users to manually input data and should be able to track stock levels, generate reports, and automate calculations. Key Requirements: - Track stock levels - Generate reports - Automate calculations Ideal Skills: - Proficiency in Excel - Experience with data entry sheets - Strong understanding of inventory management

I’m putting together a complete “training-of-trainers” package that lets any competent facilitator with basic knowledge of Excel, run a 15-20-hour Excel program for working professionals, then extend it with 4-5 hours of advanced material. Your job is to design the curriculum, create the session assets, and supply realistic, hands-on exercises that fill a three to four-hour classroom block for 4-6 days. Foundation module The opening section must ground learners in Basic Excel formulas and functions, Data entry and formatting, and an Introduction to charts and graphs—essentially everything in Excel that a working professional will need before moving forward. Intermediate module Next, I want strong coverage of Advanced formulas and functions, Data analysis and p...

I have an existing Power BI dashboard that already houses the raw data and category-level visuals. What I now need is a concise Balance-Sheet (BS) Overview page built directly inside that same PBIX file. The new view should pull the relevant category information already present in the model and present a clean, interactive summary that decision-makers can grasp at a glance. Preferred format The overview must live natively in Power BI—please do not export it to PDF, Excel, or PowerPoint. Instead, add a dedicated report page (or revise an unused one) and keep all calculations in DAX so totals stay dynamic when filters are applied. Scope of work • Identify the tables and fields that represent the balance-sheet categories. • Create measures for key BS lines (e.g., asset...

I’m building a clean, well-structured Excel database of our customer information and need a reliable remote partner to key everything in accurately. All raw data—PDFs, handwritten notes, and the occasional CSV export—will be shared through Google Drive. Your task is simply to transfer each record into my pre-formatted spreadsheet, keep the columns consistent, and flag any duplicates you notice. Because the sheet already contains formulas and data-validation rules, familiarity with Excel and spreadsheets is important. Nothing more advanced than copy-paste, basic sorting, and an occasional VLOOKUP check is required. We’ll communicate in basic English (or Hindi if you prefer) via chat for clarifications, so a headset or phone line isn’t necessary; this is strict...

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