Excel Jobs

I need an Excel expert to filter data based on exact matches across multiple columns from two files. Requirements: - Use exact match criteria - Copy matched data to a new sheet - Identify matches using multiple columns Ideal Skills: - Proficient in Excel - Experience with data filtering and manipulation - Attention to detail

I’m launching a straightforward data-entry assignment and will keep everything crystal clear from day one. You’ll be working solely in Excel—the only tool you need—so please be comfortable with formulas, basic formatting, and quick keyboard shortcuts. To remove guesswork, I’ll share a sample data-entry template that shows the exact columns, data types, and formatting rules I expect. Alongside that, you’ll receive brief internal-process notes outlining our file-naming convention and common validation checks. As soon as you complete the first sheet, send it back; I’ll review the accuracy, leave comments, and confirm any tweaks so the rest of the workload flows smoothly. The ultimate deliverable is a clean, fully populated Excel file that matches my...

I have a PDF that shows one clear, consistent table on every page, and I need each of those tables transferred into an Excel workbook so it mirrors the original layout exactly. Fonts, column order, merged cells—everything should look just like the PDF once it lands in Excel. Where you can add value is by baking in light data checks while you copy the content across. Simple validations for date and numeric fields (e.g., ensuring dates are valid Excel dates, numbers stay numeric) will be enough—no formulas, no pivot tables. Deliverables • A single .xlsx file with each PDF page’s table placed on its own worksheet, formatted identically to the source • Basic cell validation applied to date and numeric columns • A quick note describing any issues you enc...

I need a simple table template created for store employees using a picture I will provide. The final output should be in a Word document format. Ideal skills and experience: - Proficiency in Microsoft Word - Attention to detail - Ability to accurately replicate designs from images

I’m working on a personal R-and-D archive and need a reliable hand to gather large batches of films and clips that may include 18+ content. The files are accessible online through the “Right-Click Enable” Opera extension, so you’ll need to know how to capture the direct links or stream sources with that tool (or any method that achieves the same result without quality loss). Scope • Download 200–300 titles for each language folder: Korean, Japanese, English, and International (French, etc.). • Deliver every file in MP4—no other formats. • Upload each batch into its matching Google Drive (or equivalent cloud) folder that I’ll share with you. Keep original filenames when possible and maintain a clean folder structure. Key point...

I have a collection of text-based PDFs that need to be re-typed accurately into a digital format—no automated conversion, I want everything entered manually to ensure fidelity. Every page contains plain text only (no tables or images), and the finished file should reproduce the wording, paragraph breaks, and any basic styling exactly as shown. You’ll receive the PDFs as soon as we start; simply return the completed text in either Word or a clean .txt file, whichever you find quicker. Accuracy is my top priority, so before marking the job complete I’ll run a quick spot-check across several pages. If everything matches, we’re done; if not, I’ll send back notes so you can correct anything missed. I’m ready to get this moving right away and will respon...

I have a set of Excel workbooks that track multiple operational KPIs and now I need them transformed into an interactive Power BI dashboard focused on operational efficiency. The data model should be built directly from those Excel files—no other data sources are involved—so please be comfortable with Power Query for cleaning and shaping, as well as DAX for the final measures. The dashboard needs to highlight trends and bottlenecks through a combination of bar, line, and pie charts. I’m looking for a clean layout that lets managers drill down from a high-level efficiency score to department-level details in just a few clicks. Slicers for date ranges and departments are essential, and tooltips should surface any supporting metrics without crowding the page. Acceptance cr...

I have a web-based “fault finder” that guides users by letting them click through a series of images—for example: house ➜ bathroom ➜ shower ➜ problem questions. I need this entire decision tree captured in a clear, well-structured Excel file and supported by a fresh set of original, minimalist icons. Here’s what I’m after: • Workflow mapping – Document every branch from the 29 top-level items all the way down to the final question set. – Use a logical, readable layout in Excel so the hierarchy is obvious at a glance (one row per node with parent/child references works well). • Icon creation – Design a minimalist icon for each selectable item in the flow. No AI or stock tracing; all artwork must be your own. &nda...

Each day I need at least seventy job applications filed for me on Indeed, Glassdoor, and Monster. I supply the account, the tracking software, and a clear, step-by-step workflow. During a live training session I’ll walk you through the entire process; whenever the procedure changes, I’ll run another session so you’re always up to date. You don’t need prior experience—just solid English, a careful eye for detail, and the reliability to hit the monthly target without reminders. Accuracy matters: every application must follow the template exactly and be logged in the software so I can check progress at a glance. Compensation starts at $100–$150 per month and can grow as you prove consistency and loyalty. Deliverables (checked monthly) • Minimum 70...

I have several large Excel files that need to be converted into a single, analysis-ready dataset. The job centres on three things: cleaning the raw sheets, validating every record, and transforming the structure so it slots neatly into the next stage of my workflow. Here’s what has to happen: • Map each column from the source workbooks to the target structure I’ll share, flagging any mismatches early. • Build concise formulas (or Power Query steps, if they fit better) that standardise formats, handle errors, and automate repetitive fixes. • Run thorough validation checks so the final tables are free of obvious errors and the data can be trusted the moment it arrives in Power BI and similar tools. The final hand-off will be a polished Excel file (or clearly ...

I have a PDF that shows one clear, consistent table on every page, and I need each of those tables transferred into an Excel workbook so it mirrors the original layout exactly. Fonts, column order, merged cells—everything should look just like the PDF once it lands in Excel. Where you can add value is by baking in light data checks while you copy the content across. Simple validations for date and numeric fields (e.g., ensuring dates are valid Excel dates, numbers stay numeric) will be enough—no formulas, no pivot tables. Deliverables • A single .xlsx file with each PDF page’s table placed on its own worksheet, formatted identically to the source • Basic cell validation applied to date and numeric columns • A quick note describing any issues you enc...

Saya ingin mendelegasikan beberapa pekerjaan rutin agar alur kerja harian saya lebih efisien. Fokus proyek ini adalah Pengerjaan Tugas berulang—aktivitas yang mengikuti prosedur tetap, tidak bersifat kreatif, dan membutuhkan ketelitian serta konsistensi. Ruang lingkup • Tugas bersifat Pekerjaan rutinitas: contoh umum meliputi entri data sederhana, pengelompokan file, pembaruan spreadsheet, atau langkah prosedural sejenis. Daftar persisnya saya sediakan setelah kontrak dimulai. • Instruksi sudah tersedia dalam bentuk panduan tertulis dan video pendek; Anda tinggal mengikuti langkahnya. • Frekuensi: harian atau mingguan, tergantung volume. Harapan saya – Akurasi tinggi; kesalahan kecil pun cepat dikoreksi. – Komunikasi responsif melalui chat ata...

The questionnaire wording and flow are finished; now I need someone who lives and breathes Qualtrics to turn that draft into a fully functioning study and push it live on Prolific. Your job starts once I hand over the survey document and ends when the first participants are able to enter through a Prolific link and I can pull clean data straight into Excel. Here’s what I specifically need you to take care of: • Build the survey in my Qualtrics account, matching the exact wording, section order, and page breaks I provide. • Polish the visual layout so it is clear and mobile-friendly—fonts, spacing, progress bar, everything that makes the experience smooth. • Implement any required logic (screeners, randomisation, display / skip patterns) so each respondent s...

I have a PDF that shows one clear, consistent table on every page, and I need each of those tables transferred into an Excel workbook so it mirrors the original layout exactly. Fonts, column order, merged cells—everything should look just like the PDF once it lands in Excel. Where you can add value is by baking in light data checks while you copy the content across. Simple validations for date and numeric fields (e.g., ensuring dates are valid Excel dates, numbers stay numeric) will be enough—no formulas, no pivot tables. Deliverables • A single .xlsx file with each PDF page’s table placed on its own worksheet, formatted identically to the source • Basic cell validation applied to date and numeric columns • A quick note describing any issues you enc...

I’ll hand you a full set of architectural PDFs—often twenty pages or more—covering walls, floors, electrical plans and the like. Your task is to extract every measurable note (lengths, heights, areas, finishes, paint colours, coverings, etc.) and compile them into a clean, well-structured spreadsheet that lets me see totals per floor and, within each floor, per category (walls, floors, electricity, …). The finished file must come in two identical versions: an .xlsx I can keep offline and a live Google Sheet my team can review online. Each should feature clear headings, automatic subtotals and a summary page that rolls everything up. I usually spend a couple of days per project doing this myself, so accuracy and speed are equally important. If you rely on tools li...

I need an itemised quantity take-off for a residential tower of 20 storeys plus ground (G+20). The built-up area is roughly 150,000 sq ft and the scope spans the entire building—every apartment, lobby, core, and service area. Materials to be quantified: concrete, reinforcement steel, shuttering/formwork, blockwork and internal plaster. Please include footing to roof, shafts, balconies, external works tied to the structure, and all ancillary concrete elements such as ramps and parapets. The final deliverable must be a clean, well-structured Excel workbook ready for pricing. Break it down by floor and trade, show the take-off calculations (lengths, areas, volumes), reference drawing numbers in each line, and round quantities only at the summary level. Accuracy is critical: use cen...

I’m looking for a detail-oriented researcher who can locate reliable information, verify each source, and present the findings in a clean, easy-to-use file. We’ll start by agreeing on the exact topics and data points I need; from there you’ll map out the best online and offline sources, compile the numbers or facts, and cross-check for accuracy before delivery. Feel free to recommend the final format—Excel, PDF, or Word—so long as the data remain searchable and clearly organised. Please include live links or citations for every figure you capture and flag any gaps you encounter early so we can resolve them together. Deliverables • A structured dataset covering all agreed-upon fields • A concise summary of key insights or anomalies Accept...

I need a Python script that can check and identify which brands are currently offering free gifts with purchase. What the Script Should Do: The script should search each brand on Amazon.in. For each brand, check its product listings and detect if Amazon is offering any free gift with any product from that brand. Output must be an Excel file with: Brand name Gift available: Yes/No

I’m managing a series of customer-education projects and need help transforming course and training data into a persuasive case for why one audience segment—and the course tailored to them—deserves priority. Here’s what I’ll hand over: survey and questionnaire results, plus the relevant pulls from our LMS. I need you to apply solid quantitative, descriptive, comparative, and thematic techniques to surface the story hidden in those numbers and comments (this has been started). Once the insights are clear, I’d like succinct external research on that audience stitched in to strengthen the argument. Deliverables must arrive in two files: • a Google Sheet that houses the cleaned data, formulas, pivot tables, and any quick-hit visualisations you cre...

I need an Excel-based dashboard, powered by clear, maintainable macros, to turn raw operational data into an at-a-glance performance story. The workbook should pull in the data I provide, refresh with a single button, and present the results in a clean, board-ready layout that highlights three core KPI groups: • Efficiency metrics • Productivity metrics • Quality metrics Beyond the tables and charts, I want thoughtful touches—conditional formatting that calls out exceptions, slicers or dropdowns to filter by date and department, and an overall design that feels modern rather than cluttered. All formulas and VBA code must be unlocked and well-commented so I can tweak them later. Deliverables • A macro-enabled Excel file (.xlsm) with dynamic visuals fo...

I have a PDF that shows one clear, consistent table on every page, and I need each of those tables transferred into an Excel workbook so it mirrors the original layout exactly. Fonts, column order, merged cells—everything should look just like the PDF once it lands in Excel. Where you can add value is by baking in light data checks while you copy the content across. Simple validations for date and numeric fields (e.g., ensuring dates are valid Excel dates, numbers stay numeric) will be enough—no formulas, no pivot tables. Deliverables • A single .xlsx file with each PDF page’s table placed on its own worksheet, formatted identically to the source • Basic cell validation applied to date and numeric columns • A quick note describing any issues you enc...

Lead Generation & Data Research I’m looking for a reliable freelancer to research and collect accurate contact details for a list of assigned organisations, then enter the data into the correct Google Sheets. Data to Collect (per lead): Organisation name Contact name(s) Job role/title Direct email address (no generic emails) Phone number Full address City/region Website URL Requirements: Strong online research skills Accurate, verified data only Clean and consistent data entry into Google Sheets No guesses or placeholders To Apply: Share your relevant experience, similar work samples, and estimated timeframe.

I run an education M&A firm in Singapore (). I already have two datasets: 1) Childcare centres 2) A partial database of tuition, enrichment and special-needs/therapy centres I am now looking for a freelancer to: ✅ Enrich and clean both datasets ✅ Add PEIs and EduTrust-certified schools into Dataset2 ✅ Combine everything into a single Master Prospecting List (Google Sheets) This is a data intelligence project, not basic data entry. DATASET 1 – CHILDCARE (Exists) You will: - Add on missing centres based on online sources/childcare directories - Clean duplicates - Standardise naming and addresses - Recheck data for accuracy Identify: - Brand vs single-centre - Multi-outlet groups Tag each centre with: - Business Type - Size Tier - Premium Indicator - Profit Potential - Pri...

I need an automation script to process my Qualys CSV export. The script should: - Add calculated fields: MTTR, Age, Severity Name, Month Detected, Month Fixed - Format the sheet - Refresh my pivot tables The ideal candidate should have experience with data manipulation, CSV handling, and pivot tables, and be proficient in scripting languages suitable for automation (like Python or PowerShell).

I am looking for Quality Alibaba add poster

I’m looking to hire a detail-oriented Data Entry Specialist to assist with extracting and organizing data from Huobi platform. You’ll record the data accurately into Excel spreadsheets following a structured format that will be provided. No prior experience is required — full training will be provided. The only requirement is that you’re comfortable working with Excel and can follow clear instructions carefully. Responsibilities: Extract and compile data from HTX Enter data accurately into provided Excel templates Maintain data confidentiality at all times Communicate daily progress updates to the client Requirements: Basic knowledge of Microsoft Excel (must know how to enter and organize data) Reliable internet connection and attention to detail Commitme...

I need a detail-oriented lead hunter who can scrape fresh, accurate B2B data and hand me a clean file I can use right away. The focus is on companies that are actively hiring, regardless of industry, so you are free to pull from technology, healthcare, finance, or any other sector as long as the business fits that hiring criterion. Here’s what matters to me most: each record must include a working business email and a direct phone number. I’ll also need the company name so I can immediately recognise who the contact belongs to. Beyond that, feel free to enrich the list with any other fields you capture during your scrape—just keep those two core data points complete and verified. Please source the data legally, verify it to reduce bounce rates, and deliver everything in...

I have a set of lender-issued spreadsheets that are already laid out with every row and column the bank expects to see. What I need now is for those sheets to be filled with my company’s actual numbers so the loan package is ready for submission. The data you will work with covers two core areas—how the requested loan will be spent and how our own match funding supports the same plan for job growth and vehicle-fleet expansion. I will supply you with our internal cost reports, quotes, and hiring projections; your task is to translate those figures into the correct cells, double-check the totals and formulas, and leave clear notes wherever an assumption or allocation is made. Accuracy is critical because these sheets must tie back exactly to the narrative we submitted in the p...

I have about 100 stock-decrease journal entries to record in MYOB every month. Each adjustment represents product that has left the warehouse because a sale was completed, so the quantity on hand must be reduced accordingly. I have hand written entries of stock for each job in notebooks of which I will send scanned copies. Each entry is in an abbreviated version. A document explaining the abbreviations will be supplied. A journal ID can be documented on the o entry I will supply the product abbreviation, the quantity used, the date the sale was finalised, and the relevant job number. Your task is to enter this information in MYOB as an Inventory Journal so that the on-hand count and cost of goods sold are updated accurately. Accuracy is non-negotiable—items, dates, and job numbers...

I'm looking for an Excel expert to automate report generation, specifically financial reports. Key Requirements: - Develop an Excel program to automate the generation of financial reports. - Streamline and simplify the reporting process to save time and reduce manual errors. Ideal Skills: - Proficiency in Excel, including advanced formulas and macros. - Experience in automating tasks within Excel. - Strong background in financial reporting and analysis. Please provide examples of similar work done and estimated time for completion.

I need to turn an existing inventory spreadsheet into a decision-making cockpit where all calculations and simulations run automatically in the background. The idea is simple: Excel keeps the familiar visual layer while a GPT-powered backend handles the heavy lifting. What I want automated • Inventory-specific calculations, with a focus on stock-level prediction and order-fulfilment optimisation. • Simulation logic that can test different demand, lead-time, and safety-stock scenarios on-the-fly. How I imagine the build A clean Power Query pipeline pulls and shapes the data. Modern macros—Office Scripts, TypeScript, or VBA—then pass the prepared data to the OpenAI API. GPT analyses patterns, returns recommended reorder points and fulfilment actions, and the r...

I have a raw data set in an Excel workbook and I want to take full advantage of Microsoft 365’s Copilot features to turn that information into clear, publication-ready line graphs. Here is what I need from you: • Guide Copilot (or create the prompts/scripts yourself) so that the data is cleaned, labelled, and structured correctly for time-series visualization. • Build dynamic line charts that automatically refresh when new rows are added. • Apply straightforward, branded formatting—legible axes, titles, legends, and colour choices that print well in both colour and grayscale. • Leave concise in-sheet notes so I can tweak the visuals or rerun Copilot on updated data without breaking anything. Acceptance criteria • Workbook opens without ...

I want a concise yet actionable strategic plan that zeroes in on operational efficiency—specifically, process optimization within our supply-chain network. My main goals are to shorten lead times, eliminate redundancy between suppliers and warehouses, and set measurable KPIs that let my team track improvements quarter-by-quarter. To get there, the plan should: • Audit the current end-to-end flow (procurement, inbound logistics, inventory handling, outbound logistics). • Identify bottlenecks and quantify their cost or time impact. • Propose data-driven process changes—lean methods, automation opportunities, or routing tweaks—ranked by ROI and implementation complexity. • Lay out a phased timeline that pairs each initiative with owners, milestones...

I have an existing invoice in PDF form that needs a full refresh. I will send you the original Excel spreadsheet that was used to generate the PDF, so you can work directly from the source data. Here is what I need done: • Text corrections – a handful of product descriptions and billing details have changed. • Price recalculations – totals, subtotals, VAT, and any linked formulas must be updated so the figures are accurate throughout. • Layout adjustments – small alignment issues crept in during export; spacing, column widths, and logo placement should look clean and professional in the final PDF. Once the edits are complete in Excel, export a crisp, flattened PDF that matches the updated spreadsheet exactly. Deliverables 1. Updated Excel file with c...

Saya sedang mencari bantuan profesional untuk menata kembali semua kewajiban saya agar pembayaran berjalan lancar sekaligus menurunkan beban bunga. Fokusnya adalah manajemen pembayaran hutang sehari-hari dan proses restrukturisasi yang secara spesifik menargetkan pengurangan suku bunga. Gambaran situasi – Beberapa pinjaman aktif dengan tingkat bunga berbeda – Arus kas bulanan masih cukup, tetapi jadwal pembayaran tercecer – Prioritas utama saya adalah menurunkan bunga dan memastikan setiap cicilan terbayar tepat waktu tanpa denda Apa yang saya butuhkan dari Anda • Memetakan seluruh saldo, bunga, serta tanggal jatuh tempo • Menyusun skema pembayaran terpadu yang realistis dan sesuai arus kas saya • Bernegosiasi dengan kreditur untuk memperoleh ...

I need a data entry specialist to handle mixed data from online databases. Tasks include: - Data extraction and input - Data cleaning and verification - Data organization and categorization Ideal skills and experience: - Experience with online databases - Strong attention to detail - Proficiency in data entry tools and software

I run A.B. InfoTech Solutions and I’m ready to reward a driven marketer who can secure fresh data-entry work for us. The sweet spot is small businesses that need their day-to-day information quickly digitised and organised, so your outreach should focus there. Right now we see the most traction in: • Retail • Healthcare Pitch our full-cycle data-entry service, stay in touch with each prospect until they sign, then hand the project to my operations team. Every contract you land earns you a straight percentage of the total value—no ceiling, no fixed salary, just pure commission that scales with the size of each project. You’ll thrive if you already understand B2B outreach or freelance marketplace hunting, communicate clearly, and like setting your own targe...

I have diverse operational data that needs to be transformed into clear, interactive dashboards and printable reports inside Power BI. You will connect to the sources I provide—these might range from SQL tables and Excel workbooks to a few cloud-based APIs—then shape and model the information so it refreshes reliably. The finished work should let end-users filter by date, product, and region, drill from summary visuals into row-level detail, and export key pages to PDF for management reviews. All visual and DAX choices must remain fully editable in the .pbix file so I can extend the solution later. Deliverables • Clean, well-structured .pbix file with an optimized data model and at least three interactive dashboard pages • A short walkthrough video or document ex...

Power BI Expert Needed to Build Complete E-Commerce Analytics Dashboard We are seeking a Power BI expert to design and implement a comprehensive e-commerce analytics dashboard. The ideal candidate should have a strong background in data visualization and e-commerce metrics. You will be responsible for translating complex data into insightful visual reports that help drive business decisions. Job Title: Power BI Expert Needed to Build Complete E-Commerce Analytics Dashboard Budget: (Flexible based on expertise) Timeline: 2-3 days Work Type: Remote – Screen-share support preferred Data Sensitivity: Must follow confidentiality / NDA We need an experienced Power BI developer to build a professional, dynamic, refreshable e-commerce analytics dashboard. The dashboard must update automat...

I have fresh lead lists of Central-Time home-service businesses ready to be dialed, a tested script that converts, and a streamlined CRM workflow already in place. What I need is a confident voice on the phone who can follow the script, qualify each prospect in real time, and lock in calendar appointments with business owners who show genuine interest. You’ll step straight into a proven system: I upload the leads, you make the calls, and once a booked client closes, your performance payout is released immediately. Consistent callers are able to generate strong monthly earnings based purely on results. Since I provide the data, script, and full back-end support, your focus stays on smooth conversation, objection handling, and confirming meeting times. Requirements are straightforwar...

Please contact with me only developer that have experience about humanoid voice bot. IF LLM, please tell me about scraping.

I have three standalone financial models that already work well on their own, but I need them merged into one Excel-based workbook that instantly rolls everything up and shows the impact of a worst-case, neutral, or best-case outlook. All logic embedded in the original files has to survive the migration, so the first step will be for you to study each sheet, trace the formulas, and confirm that results match the originals before anything is combined. Structure • One master workbook in Excel • Three clearly labelled scenario tabs (Worst, Neutral, Best). Switching tabs should refresh every linked schedule so that the summary outputs always reflect the selected case. • A clean, locked-down consolidation dashboard that summarises P&L, cash flow, and KPIs at a glance. ...

I need someone to jump straight into my eBay Seller Hub and put together new listings using the template I’ve already built. All the product details have to be entered—titles and descriptions, images with specs, plus item condition and the right category selection. You’ll receive: • the template file (CSV and a quick reference PDF) • a folder of product photos • source sheets with the specs, sizes, and condition notes What I expect back is a completed upload-ready file and any resized images you’ve pre-named to match the SKUs. Accuracy on spelling, character limits, and category codes is key; if a field isn’t in the template, flag it rather than guessing. If you’re comfortable working in Seller Hub bulk tools or Turbo Lister...

My UAE-based company is approaching its first corporate tax season and I want the return filed correctly the first time. All bookkeeping for the period is up to date in Excel and Zoho Books, but I need an experienced practitioner to take those trial balances, confirm the taxable profit calculation, complete the Federal Tax Authority (FTA) corporate tax return on the EmaraTax portal, and submit it on my behalf. Your scope is a one-time engagement focused on “Filing the Return.” If you can spot any VAT inconsistencies while working through the ledgers, that is a bonus, yet the primary deliverable remains the lodged corporate tax return together with: • the signed computation schedule, • the PDF acknowledgement issued by the FTA, and • a concise summary of ...

All of these Excel sheets must be completed using reasonable assumptions and a transparent, traceable rationale explaining how and why each figure was chosen, including the data sources used. Each calculation should be supported by clear explanations and justification for the inputs applied. Once the model is fully filled out, a 2–3 page written report must be prepared, as outlined below. The worksheets are interconnected—simply follow them and the instructions in them in sequence and enter the appropriate data with explanations. Most of the required information can be obtained directly from the Novo Nordisk A/S ADR 10-K filings. The company which is being focused on is of course Novo Nordisk A/S ADR. The Tasks in detail: 1. Template model with additional sheets 2. Optim...

I need help with descriptive statistics for my college-level statistics project. I have data sets ready for analysis. Key requirements: - Use Excel for analysis - Calculate mean, median, standard deviation, and variance Ideal skills: - Proficiency in Excel - Strong background in statistics - Experience with data analysis

I need a clean, automated Excel workbook that turns raw supplier price lists into clear, detailed pricing reports for my online store. The file should let me drop in the latest supplier spreadsheet (CSV or XLSX), map the fields once, and then refresh to show: • every product with its current supplier cost • my pre-set markup or margin formula applied • a ready-to-print/report tab that highlights price shifts since the previous update Please keep everything inside Excel—no external macros that require additional installs—using Power Query, pivot tables, or VBA only if it makes the refresh seamless. I maintain the worksheets weekly, so the process must be straightforward: import, click refresh, and export the finished report as PDF when needed. Deliverable: ...

I need a Python-based routine that can open batches of Excel workbooks and PDF reports, pull out both the text and numeric fields they contain, run the required data transformations, and drop everything into a single, tidy Excel file that’s ready for analysis. Here’s the flow I have in mind: • Source files: a mixed set of .xlsx and multi-page PDFs. • Extraction: every relevant text label, number, and date must be captured—no copy-paste shortcuts. • Transformation: reshape columns, standardise units and naming, and apply any other logic we agree on so the final sheet is analysis-ready. • Output: one well-structured .xlsx workbook (extra tabs are fine if it keeps things clear). • Logging: the script should create a simple log file that not...

I am seeking a sharp, detail-focused Data Analyst to help transform existing shopify product catalog into a well-structured, highly searchable system using a clean and consistent tagging strategy. You’ll work with our product data exports to: Enrich product information (titles, categories, types) Apply structured tags based on our naming conventions Deliver a Shopify-ready dataset for upload Ideal candidates have experience with Shopify or eCommerce data, strong spreadsheet/CSV skills, and an eye for consistency. Your work will power smart collections, filters, and merchandising logic — making it easier for customers to discover the right products. Apply with your experience and availability. Prefer if you’ve worked with Shopify catalogs before! Q: What is your fa...

We are looking for an experienced Material Estimator / Quantity Surveyor to prepare a detailed material take-off and BOQ for our Australian residential construction project. Responsibilities: • Prepare accurate material estimation (BOQ) • Quantity take-off using plans/drawings • Follow Australian construction standards • Provide output in Excel with clear breakdowns • Identify materials, quantities, units. Preferred Skills: • Experience in Australian building projects • Knowledge of Bluebeam / PlanSwift / Cubit / CostX • Strong understanding of construction drawings • Accuracy and attention to detail Deliverables: • Detailed BOQ in Excel • Material take-off for all trades (as per scope) • Clarifications if required