Excel Jobs

Je cherche quelqu’un capable de mener une recherche en ligne ciblée sur un sujet technologique. Objectif Je veux obtenir un aperçu clair, à jour et sourcé du thème que je préciserai dès le démarrage (par exemple : dernières innovations IA, tendances matériel, ou adoption 5G). Ce que j’attends • Une synthèse concise (1-2 pages) exposant les points clés, chiffres marquants et évolutions récentes. • Un tableau des sources : au minimum 8 liens fiables (articles spécialisés, rapports d’entreprises, blogs d’experts) avec date, titre et résumé rapide. • Un court paragraphe conclusif mettant en évidence les opportu...

Apply every evening at 8 PM French time on 5 different websites for work-study offers in the relevant field, every day for 2 hours, with a goal of 40 to 50 applications per day, for 2 months. and report on excel

I’m sitting on a raw list of roughly 130,000 email addresses that currently triggers both soft and hard bounces. My sole objective is to raise overall deliverability, so every single address must be checked for full deliverability issues—syntax, domain validity, mailbox existence, role/disposable addresses, possible spam traps—rather than simply stripping obvious hard bounces. Here’s what I need from you: • Run a comprehensive verification sweep using a trusted solution such as NeverBounce, ZeroBounce, MillionVerifier, or an equivalent SMTP-ping setup that never sends an actual message. • Return two clearly labeled CSVs: one “Valid & Safe” file ready for import, and one “Invalid / Risky” file that lists each rejected addre...

Tengo un libro de Excel que llega cada semana con datos crudos y desordenados. Quiero transformar ese archivo en un proceso totalmente automático: que se limpie, se organice y acabe generando un informe listo para enviar, sin que yo tenga que tocar fórmulas ni copiar-pegar nada. La prioridad es la automatización. Imagino que una combinación de VBA, macros o Power Query resolverá la limpieza y el formateo; después, el sistema debe armar el reporte con los indicadores clave que definamos juntos. El resultado final debe quedar en una hoja de presentación (o PDF) con diseño claro y actualizado con un solo clic. Entregables concretos: • Script o macro que importe el archivo fuente, depure los datos y los normalice. • Plantill...

I need assistance formatting my undergraduate dissertation in Microsoft Word. I currently have a base template but require support ideally live on microsoft teams to assist with editing of word formats, bringing subsections of chapter drafts into the main template etc. - Headings and subheadings - Table of contents - List of Tables and Figures - linking of appendices to intext citations - References and citations - General editing The formatting should adhere to the Harvard style guide and University of Cumbria Guidance which i can provide copies of. Ideal skills and experience: - High Proficiency in Microsoft Word - Proficiency in Excel for basic tables and charts. - Experience with academic formatting, specifically Harvard style - Attention to detail and ability to follow guidelines a...

I have a steady flow of printed and handwritten material that needs to be re-typed with absolute accuracy, then kept neatly organized in Word or Excel. Most sheets only require basic structure—clear headings and the occasional bullet list—so nothing too complex, but consistency is vital. Alongside the typing, I sometimes need short written pieces: concise reports or summaries that pull key points from the data you just entered. Think of it as transforming raw notes into a clean narrative a colleague can skim in minutes. Turnaround matters to me. If we agree on a deadline, I expect the finished Word documents, tidy Excel files, and—in the moments they’re needed—those brief summaries to land in my inbox on schedule. Basic familiarity with Word, Excel, Google D...

I have a spreadsheet containing 200 universities that might have career-services sites accepting external employer listings. I need you to go through the list, post my three vacancies on their websites, or, if you don't find a job portal, send them an email asking if they have one or if they could post our jobs somewhere. Here is what I will hand over: • University list • The full job descriptions, company overview, logo • Contact details and job parameters (duration, pay range, application link, etc.) that must be entered exactly as provided What I need from you: • Create employer accounts where necessary, then submit the roles on each sit • Capture a confirmation link or screenshot for every successful listing and record it back in my spreadsheet so I can ...

I have an existing electrical riser where each apartment is fed with 6 AWG conductors. Every unit falls in the 500–700 sq ft range and is outfitted with the usual kitchen package—range, refrigerator, dishwasher, microwave—as well as Central heating and cooling systems. Before I commit to new tenant improvements, I need a professional load study that tells me two things: • the largest breaker size that can safely be installed at the electric room and servicing the apartment panel given the 6 AWG feeder, and • the realistic maximum panel demand, factoring in the appliances listed above plus general lighting and receptacle loads for a space of this size, and • analysis of what breaker size could be installed if the feeder wires were 4 AWG Please base y...

I have a steady flow of first-time home buyers who have already expressed interest in a mortgage; what I need now is a skilled telecaller who can take them from “interested” to “application submitted.” Your main focus will be closing the sale during the call, not just warming the lead. During each conversation you’ll confirm the prospect’s basic eligibility criteria for our loan products, explain how our process works, and guide them to complete the application while you’re still on the line. When necessary, you’ll schedule follow-ups to collect any missing information, but the aim is to finish the call with a committed borrower. Key deliverables • Daily call log with outcome notes and next-step status • Completed application ...

I need a comprehensive Excel tracker for real estate development that aligns the targets and statuses of multiple departments. This tool will help maintain control and ensure the smooth flow of activities. Essential Departments to Track: - Projects and Sales - Purchase and Finance - HR and Administration Data Visualization Requirements: - Tables with conditional formatting - Interactive dashboards Ideal Skills and Experience: - Proficiency in Microsoft Excel - Experience in creating complex trackers - Strong data visualization skills - Background in real estate or project management is a plus The final product should be user-friendly and provide clear insights into departmental performance against timelines and targets.

Hello, I'm looking for a Data entry specialist which can: - analyse invoices and receipts issued in different countries of the European Union - knows to identify the specific tax rates for each country - divides the data of the invoices and receipts for each country in different excel sheets (extracting specific data) - put in order all invoices and receipts in country dedicated folders - reports to me the progress of work This is an ongoing project during several months.

Project: E-Vikas Portal Member Registration Automation Project Overview Need a software automation system for E-Vikas Member Registration Portal Portal Link: The system should automatically submit member registration forms in bulk using Excel data Core Requirements Portal Automation Automate member registration form submission Automatically fill all required form fields Submit form and move to next entry Process 200–500 entries per minute depending on server response Login Automation Handle OTP-based login Handle CAPTCHA verification Maintain active session during bulk submission Avoid repeated login for each entry Excel Upload System Software must accept Excel (.xlsx / .csv) file Read rows from Excel Automatically map Excel columns to portal fields Validate data b...

I have several automation workflows already running in UiPath that now need to live entirely inside Microsoft Power Automate—both Desktop and Cloud flows. Your task is to look at each existing process, document the logic, rebuild it in Power Automate, and make sure it runs just as fast (or faster) while integrating cleanly with Excel, Outlook, SharePoint, and the broader Microsoft 365 stack. You should be comfortable translating UiPath activities into the native Power Automate equivalents, setting up robust error handling, and stress-testing every path so I can rely on consistent, unattended execution. Strong debugging habits are essential; I expect clear logging and graceful recovery whenever an exception occurs. Deliverables • A rebuilt Power Automate solution for every UiPa...

Data entry/e-commerce buying must be well paced and reliable must have good/reliable electricity and fast internet

I’m working with a sizable dataset that contains both numbers and text, and I need every record entered faithfully into a Google Sheet. Before anything goes in, each numerical field has to be checked against the specific upper- and lower-bound ranges I’ll provide; if a value falls outside that range, simply flag it in a separate “Issues” column instead of altering it. The flow is straightforward: validate, enter, double-check. You may rely on Google Sheets’ built-in data-validation rules, filters, or even quick formulas to speed up the range checks, but accuracy always overrides speed. Because the sheet mixes text columns and numeric columns, please beware of mis-aligned cells, accidental truncations, or copied formatting that could skew the data type. Del...

I need every record from a series of spreadsheets copied by hand into a new master sheet I’ll provide. The task is strictly manual data entry—no macros or scripts—because the source contains mixed information: text fields such as names and notes alongside numerical figures like prices and quantities. Accuracy is critical; what appears in the source spreadsheets must match the destination sheet exactly, including number formats and spelling. You will receive the original Excel workbooks plus a target template with clearly labelled columns. Deliverables • A fully populated target sheet with 100 % of the mixed text and numerical data transferred • A brief note highlighting any illegible or conflicting entries you encounter Acceptance criteria • Al...

I’m preparing a new personal-loan campaign that needs a steady flow of unqualified And quilified prospects from across the country. At this stage I don’t need the leads warmed up or pre-screened—I simply want fresh contact data that my in-house team can qualify and nurture. For every record you supply, I need: • Full name and primary contact details (phone and email) • Current employment information (employer name, position, time in role, income if available) • A credit-score figure or range Leads must originate within the United States and be generated ethically (TCPA/CAN-SPAM compliant; no purchased or scraped lists). I’m open to whichever channels you favour—paid social, Google Ads, content funnels, co-registration, or your own databa...

I need a detailed, line-item cost estimate covering all Mechanical, Electrical, Plumbing, and Civil trades for an upcoming project. You will work from the construction drawings and specifications I provide and produce a clear quantity take-off plus a priced Bill of Quantities in Excel. Please use whichever digital take-off tools you are most comfortable with—Bluebeam, PlanSwift, Revit, AutoCAD, or similar are all fine—as long as the final workbook shows measured quantities, unit rates, and subtotaled costs by discipline so I can drop it straight into my budgeting model. Deliverables • Complete Excel BOQ, separated into Mechanical, Electrical, Plumbing, and Civil tabs • PDF copy of marked-up drawings showing your measurement references • Short methodol...

I am preparing the second–year business plan for my aviation start-up and need a set of clear, fully referenced formatted in Word. You will receive last year’s figures (fleet details, operational spending, preliminary sales data, and marketing notes) to guide your assumptions; feel free to flag any gaps you spot so I can share the missing numbers promptly. The job revolves around six tables, each on its own page and built for easy copy-paste into a Word document: • Total operating costs: fleet lease/finance, parking, landing, and fuel, broken down by month and summed for the year. • Annual promotion & branding spend: itemised media channels, events, digital campaigns, aircraft livery, and contingency lines. • Full-year payroll: headcount, job titles, g...

I need a clean, minimalistic, single-column resume template that reliably scores 95 percent or higher in mainstream ATS scanners such as Greenhouse, Workday, Lever, and Taleo. The file must stay to one printed page and suit tech applicants in software, security, or engineering roles without relying on graphics, text boxes, or multi-column layouts that can confuse a parser. The template should flow in this exact order so machines and humans read it effortlessly: • Personal Details • Education • Skills Summary • Work Experience • Projects • Certificates Please format each heading with standard style tags, use system fonts (Calibri, Arial, or similar), and include bullet styles that an ATS can interpret. Subtle accent color on section titles is w...

I will give you six promotional exams in both DOCX and PDF. Your primary task is to turn them into one master exam of about 700 multiple-choice questions. The questions must be organised underneath the title of the resource document they originally came from, listed alphabetically so the reader can jump straight to a particular manual, policy, or chapter. Here is what you can expect from me • Source exams: mixed PDF and Word files • A working example that shows the layout I have started • A separate sheet that “best guesses” the resources for the one test that came without citations Key points to follow • Keep every question exactly as written—no re-wording or re-numbering other than the new sequential order. • Where a source is mi...

I already hold a raw-data workbook that lists each product, its department and the associated revenue, plus a separate sheet with customer details. What I need now is to turn those rows into insight while watching the entire process in real time. Here is what I want us to tackle together: • Spot revenue trends month-over-month and year-over-year. • Compare product sales by department so I can instantly see top and under-performers. • Layer in customer demographics to explain the “why” behind the numbers. We will meet on Zoom or Teams, share screen, and co-build both an Excel model (pivot tables, slicers and chart dashboards) and a Power BI report (clean data model, DAX measures, interactive visuals). I will be asking questions throughout, so please be c...

I am preparing to move forward with a new set of industrial works and need an accurate, line-item quotation that covers everything-–materials, labour, and projected timelines. The facility already has partial schematics, so you will be working with some existing drawings while identifying the gaps that still need detailing before you finalise your numbers. The scope centres on an industrial environment rather than residential or commercial, so experience with higher-load distribution boards, cable sizing, MCCs, and relevant safety codes (NEC, IEC or equivalent) is essential. If a short site walk-through or video call is helpful to verify the current setup, just let me know and we can schedule it. Please include in your submission: • A clearly structured quotation (PDF or...

I run a small operation in the plastic toy industry and need a reliable extra set of hands to keep things moving smoothly. Your main focus will shift between supplier sourcing, price checking, data entry, and general online support—whatever is most urgent that day—so flexibility is key. Familiarity with plastics or toys helps, but strong research and spreadsheet skills matter even more. Typical tasks you might tackle: • Source vetted domestic or international suppliers and compile their contact details, MOQs, and lead-times. • Check current market prices for specific SKUs and prepare a comparison sheet that clearly flags the best options. • Enter product specs, inventory counts, or sales figures into my existing Google Sheets with 100 % accuracy. • Ha...

I’m looking for a detail-oriented bookkeeper who is completely at home in Tally. My immediate need is to get all bank accounts reconciled on a regular schedule and to generate clear, error-free account statements that I can rely on for decision-making and audits. Here’s what the work involves: • Importing and matching transactions in Tally until every statement line is accounted for. • Investigating and resolving any mismatches or suspense entries. • Producing monthly account statements in a format that can be shared directly with management and our auditors. Accuracy is everything here, so I expect clean reconciliations with no unreconciled balances left hanging and statements that tie back perfectly to the ledgers. If you’ve done this routinely in...

I will give you six promotional exams in both DOCX and PDF. Your primary task is to turn them into one master exam of about 700 multiple-choice questions. The questions must be organised underneath the title of the resource document they originally came from, listed alphabetically so the reader can jump straight to a particular manual, policy, or chapter. Here is what you can expect from me • Source exams: mixed PDF and Word files • A working example that shows the layout I have started • A separate sheet that “best guesses” the resources for the one test that came without citations Key points to follow • Keep every question exactly as written—no re-wording or re-numbering other than the new sequential order. • Where a source is mi...

I have the structural drawings for a new water-treatment plant and need an accurate quantity take-off for every RCC component that goes into it. The facility centres on a chemical-treatment line, with chlorine as the primary agent, so all tanks, reaction chambers, beams, columns and slabs tied to that process must be captured in the numbers. Please extract and tabulate: • Concrete volumes and formwork areas • Reinforcement weights with a concise bar-bending schedule • Any embedded items or starter bars that will affect pour sequences I am comfortable reviewing in Excel, but you may build the model in AutoCAD, Revit or any other software you prefer—just share the source file alongside the final BOQ. Quantities must align with IS codes and be broken down by p...

I have a small batch of sales data—fewer than 1,000 rows—that needs to be entered into Excel and formatted so the sheet is clear, logical, and ready for analysis. Each record must land in the correct column, with headings aligned and consistent styling applied throughout. Data-accuracy checks are essential: I’ll need you to validate numeric fields, flag anomalies, and ensure no duplicates slip through. Basic functions such as sort, filter, conditional formatting, and simple formulas will help keep everything tidy. Deliverables: • A fully populated Excel workbook with clean, labeled columns and rows • Built-in accuracy checks (e.g., data validation rules, error highlights) • A brief note summarizing any issues found and how they were resolved ...

I have a spreadsheet with well over 500 construction-related items that need tidying before they can go live on our site. Every row already contains a short description; what I need from you is a clean, customer-friendly product name, along with the correct Header, Category and Sub-Category taken from the official classification list I will supply. Here is the flow I follow and expect you to replicate: • Read the existing description, extract the key identifying features (material, size, application, etc.) and create a concise, grammatically correct product name in natural English. • Match the item to the closest fit in the provided category matrix, then populate the Header, Category and Sub-Category cells exactly as they appear in that list. • Double-check that every...

Administrative Assistant for the Accounts Department plays a vital role in supporting financial operations by managing administrative and accounting-related tasks. This position ensures accuracy, efficiency, and compliance in day-to-day financial processes while providing critical support to accountants and finance teams. Key Responsibilities Process invoices, receipts, and payments; assist with accounts payable and receivable. Perform data entry, reconcile accounts, and maintain accurate financial records. Assist with bank reconciliations, monthly reporting, and preparation of financial statements. Schedule meetings, manage calendars for finance managers, and coordinate travel arrangements. Handle office correspondence, sort and distribute mail, and manage office supplies. Prepare repo...

The project centers on a manually-entered sales spreadsheet that requires a full Excel-based analysis focused on monthly sales performance. I will supply the raw rows exactly as they come from our internal forms; they first need cleaning (duplicate checks, consistent date formatting, error spotting) before any insights can be trusted. Once the data is reliable, the workflow should move into sorting, filtering, and creating pivot tables that break revenue down by month, product line, and any other field that emerges as useful. Clear, professional charts—line, clustered column, or a pivot chart—must then visualise month-over-month results so trends and anomalies are unmistakable at a glance. Deliverables • Cleaned Excel file with all transformation steps traceable ...

I have an assignment made up of straightforward arithmetic and introductory algebra questions, and I need complete, correct solutions for each one. This is purely problem-solving work—no tutoring sessions or lesson plans—just clear, step-by-step answers I can follow and learn from later. Please deliver: • A neatly typed document (Word, Google Doc, or PDF) containing each question followed by its full working and final answer. • Brief notes where a particular rule or property is applied, so I can see the logic behind every step. Accuracy is critical, and the reasoning must be easy to trace. Once I review the solutions, I’ll confirm everything lines up with the assignment requirements before marking the job complete.

Tôi đang tìm một freelancer có thể hỗ trợ khâu bán hàng. Công việc bao gồm: • Lên danh sách và tiếp cận khách hàng tiềm năng bằng những kênh phù hợp (email, mạng xã hội, gọi điện). • Ghi chú, theo dõi và cập nhật tình trạng từng khách hàng trong file Excel hoặc CRM mà tôi cung cấp. • Báo cáo kết quả và đề xuất điều chỉnh mỗi tuần để tối ưu tỷ lệ chốt đơn. Bạn cần giao tiếp chuyên nghiệp, nắm căn bản về kỹ năng bán hàng và sử dụng thành thạo các công cụ văn phòng. Nếu bạn từng làm việc với CRM (ví dụ: HubSpot, Zoho), vui lò...

I need a Microsoft Power Automate cloud flow that reads my existing Excel file, checks each row for its due-date column, and automatically sends an email reminder to the address listed in that same row. The sheet sits in my Microsoft 365 environment (OneDrive/SharePoint), so the flow must use standard O365 connectors only—no premium licenses. Core expectations • The flow runs on a schedule I can easily adjust (hourly or daily). • Each email pulls dynamic values from the row (name, task, due date) and uses a template I can edit later. • Once an email is sent, the row should be marked so duplicates are avoided. A “Reminder Sent” flag or timestamp is fine. • Everything must be built and tested inside my tenant, with clear, step-by-step notes so I...

I am preparing to move forward with a new set of industrial works and need an accurate, line-item quotation that covers everything-–materials, labour, and projected timelines. The facility already has partial schematics, so you will be working with some existing drawings while identifying the gaps that still need detailing before you finalise your numbers. The scope centres on an industrial environment rather than residential or commercial, so experience with higher-load distribution boards, cable sizing, MCCs, and relevant safety codes (NEC, IEC or equivalent) is essential. If a short site walk-through or video call is helpful to verify the current setup, just let me know and we can schedule it. Please include in your submission: • A clearly structured quotation (PDF or...

Job Title Tally Developer / Tally Customization Specialist (Freelancers) Job Summary We are looking for an experienced Tally Developer who can customize Tally (ERP 9 / TallyPrime) and build solutions to import, export, and transform Tally data into client-demanded Excel templates. The role requires strong expertise in Tally Definition Language (TDL) and hands-on experience with data mapping, reporting, and automation. Key Responsibilities Customize Tally ERP 9 / TallyPrime using TDL based on business requirements Develop solutions to extract Tally data and export it into predefined/custom Excel templates Handle data mapping, transformation, and validation between Tally and Excel Create custom reports, vouchers, screens, and forms in Tally Implement import utilities for bringing Excel/CSV d...

Create a catering and decorating ERP excel speadsheet system structure which includes dashboard, total booking, upcoming events, monthly revenue, monthly expenses, net profit, vendor payments, staff salary, charts like revenue chart, expenses chart, event type chart, client database, event booking system, event calendar, menu database, event menu planner, raw material costing per programme menu or client, staff database with per day wise salary system, event decoration cost, decoration package, staff attendance, staff payroll, vendor database, vendor payment tracker, inventory, daybook, quotation generator, invoice generator, profit per event, reports, also add data validation dropdowns, xlookup, sumifs, countifs, conditional formatting, button for navigation, auto client from, auto invoic...

I need a reliable workflow that pulls Sales, Customer, and Inventory data from my Microsoft SQL Server into both Google Sheets and Excel on an automatic schedule. Once the feed is live, I want the data modeled and visualized in Google Data Studio so I can slice performance by product line, customer segment, and time period without manual intervention. The last piece is real-time, rule-based notifications that reach mobile devices—push or SMS—whenever metrics cross predefined thresholds (for example, daily sales drop below target, inventory hits a reorder point, or a new high-value customer signs up). Deliverables: • Scripted or no-code connector that syncs SQL Server to Google Sheets and an Excel workbook on OneDrive/SharePoint, running at set intervals. • A...

Quiero un archivo maestro en Excel que consolide mis ventas históricas por producto y por cliente. Cada mes recibiré varios archivos de mis distribuidores; sus hojas comparten la misma información clave, pero el formato puede variar ligeramente entre uno y otro. Lo que necesito exactamente: • Una estructura de base de datos dentro de Excel (tablas o Power Query) que me permita importar mensualmente esos archivos externos y actualizar los registros sin perder histórico. • Columnas estandarizadas para fecha, código-producto, descripción, cliente, unidades y valor de venta. • Un panel de análisis con gráficos de líneas que muestren la evolución mensual de ventas, filtrables tanto por producto como por c...

WE WILL HIRE YOU BID THAT IS ASSURED I have a small backlog of bank activity that must be typed directly into QuickBooks. The file is already set up; what is missing are 1–10 monthly statements, each averaging no more than twenty transactions. I will provide PDFs for each statement plus my current chart of accounts and any notes on how specific items should be coded. Your task is straightforward: enter every transaction exactly as it appears, assign the correct account, add payee details, and include clear memos where information is thin. Once a statement’s transactions are in, confirm the closing balance matches the PDF so I know the figures reconcile. Deliverables • Every transaction from all statements accurately entered and categorized in my QuickBooks company file...

Location: Must currently be in Guyana Job Description: We are looking for someone currently located in Guyana who has access to a television and can use the local national TV platform (NCN Guyana). The task involves verifying specific TV channels on the platform. This is a simple verification task. Detailed instructions will be provided after hiring. Task Overview: • Check the channel list on the TV platform • Confirm whether the specified channels is available • Record short video clips as proof Requirements: • Must currently live in Guyana • Have access to a TV that can receive the NCN Guyana platform • Able to follow instructions and submit files on time

Preference Mechanical or Electronics students from India only

Have you used Google sheets? Rate yourself from 1 to 10 Can you use lookup functions? Have u created traffic based reports? Want a VA to help me with reports and SEO related data entry tasks

I need a single Excel workbook that can build and police our small team’s roster for me. At its core the sheet must: • Calculate each employee’s daily and weekly hours automatically and highlight anyone who ends up rostered for more than seven straight days. • Apply additional rule-based conditional formatting so I can tweak thresholds later (for instance, total weekly hours). • Generate weekend coverage automatically—every Saturday and Sunday one person is placed on a full-time shift while another is booked for a half-day, rotating fairly through the team. • Resolve overlapping or double-booked shifts on its own rather than only flagging them; it should shuffle the clash to the nearest viable slot and note the change. • Remain scalable...

Job Title Project Intelligence Analyst – Mining (WA) & Construction (Australia) About the Role Blue Diamond Machinery is seeking a freelance Project Intelligence Analyst to identify and track upcoming mining and construction projects that may require temporary or remote power solutions. The objective of this role is to provide early project intelligence—identifying opportunities before procurement begins. Focus Areas • Mining projects: Western Australia (Pilbara, Goldfields, regional developments) • Construction projects: Australia-wide (major infrastructure, renewables, industrial construction) What You Will Do • Identify upcoming or active mining and construction projects • Map the contractors and EPC companies involved • Identify decisio...

I have a set of raw customer records that need to be organised into clean, well-structured Excel spreadsheets. For this phase I only require contact details—name, phone number, and email address—entered accurately and formatted consistently. The source material comes in mixed formats (scanned pages, PDFs, and a few loose text notes), so the job involves both careful transcription and sensible field formatting inside Excel. I will provide the files as soon as we start along with a column template that shows the exact order and heading names I want. Accuracy is critical; invalid phone numbers, misspelled names, or mis-placed emails will be rejected. If you spot obvious typos or duplicates in the source, flag them so I can confirm before you proceed. Deliverables: • One Exc...

I need an Excel file to track my stock investments. The file should be able to import data from CSV files. all need to be automated updation of from data pulling from website(free source) to putting systematically store and integrate that data in excel by date order and there after process with below ratios. I should be able compare past data outcomes with new one also Essential features include: - Key Ratios: Beta, Alpha, Sharpe Ratio, Portfolio Beta, Variance, Standard Deviation - Visualizations: Line Charts to display the data trends Ideal Skills and Experience: - Proficiency in Excel, especially in creating complex formulas and importing CSV data - Experience with financial metrics and investment tracking - Ability to create clear and informative line charts

I need focused validation applied to one of my Excel workbooks so every field only accepts the information it is meant to hold. The goal is to prevent bad entries at the source and flag anything that slips through before it causes downstream issues. You can expect to work directly inside an .xlsx file I will provide, create the necessary Data Validation rules—drop-downs, custom formulas, dependent lists, or any other built-in options—and return the sheet ready for everyday use. If it makes sense, feel free to suggest complementary touches like quick error-checking messages or gentle input restrictions for related columns, but the core deliverable must remain rock-solid validation. When you reply, please link to past work that shows you have already set up or audited validatio...

I need a small, browser-based calculator that lets my customers work out exactly how much aluminium they have in their basket and whether it meets our production thresholds before they call us. The interface should feel as familiar as a typical e-commerce quantity selector: pick a beam section, choose a length, type in a quantity and watch the results update instantly. Behind the scenes the script has to pull the density and surface-area data I will supply (already organised in a spreadsheet) and then: • add up total weight in kilograms • add up total powder-coating area in square metres • highlight when any single beam section hits 250 kg • highlight when any colour grouping hits 200 m² Customers will also be able to split the same physical items across d...

I have a raw set of customer records that must move from messy spreadsheets to a structured, analysis-ready format. The job starts in Excel—think Power Query, advanced formulas, or VBA for quick wins—then shifts to Python (Pandas, NumPy, openpyxl) so the process can run automatically whenever fresh data arrives. Here’s what I need from you: first, clean and normalise the fields (remove duplicates, unify date and address formats, fill or flag missing values). Next, reshape the information into tidy tables that feed our reporting model. Finally, package everything into a repeatable Python script that reads the latest file, runs the full transformation pipeline, and exports polished XLSX/CSV outputs along with a simple log of what changed. Deliverables • One fully d...