Visual Basic Jobs

I need a clean, branded Excel file that lets me build product-only quotations quickly while still looking fully professional to my clients. The sheet has to show, at minimum, columns for Product Name, Product Description, Quantity and Unit Price, with automatic line totals, subtotal, tax and grand total calculations. I sometimes attach images to help the client visualise an item, so please leave space or an optional column that can accept embedded pictures without breaking the layout. A few other things will make the file truly useful to me: my company header and contact block locked into place, space for the client’s details, auto-generated quotation number and date, clearly formatted terms & conditions at the bottom, and colour-coded cells so it’s obvious which fields I ...

Build a reusable, branded one-page ROI summary in Excel for a plate funding sales tool. The template must auto-calculate all outputs from a small set of input cells, be formatted with the client's logo and brand colours, and produce a clean customer-facing layout that a sales team can use per deal without any Excel knowledge.

I need an Excel expert to fix some issues in my spreadsheet. The project is urgent and I require it to be completed ASAP. Key Issues: - Difficulty with macros - Conditional statements in formulas not working correctly - Colour coding if employees aren't inducted on a particular project - Formulas page where employees have their site and project inductions displayed and easily edited by excel basic users - Fix convoluted formulas within the spreadsheet - If Employees are scheduled for a particular day they disappear from the list to avoid double ups. - Have a tiered system that references project first, site second and job third - Jobs Merge and center under their selected site and sites merge and center under their selected project so they can be all seem in the same area of th...

Build a reusable, branded one-page ROI summary in Excel for a plate funding sales tool. The template must auto-calculate all outputs from a small set of input cells, be formatted with the client's logo and brand colours, and produce a clean customer-facing layout that a sales team can use per deal without any Excel knowledge.

I am looking to develop a professional Excel-based system to manage and track daily, weekly, and monthly tasks across multiple departments within our company. Departments include: - Human Resources - Finance - Logistics - Projects - Administration The system should be user-friendly and designed to support management-level monitoring and decision-making. Key Requirements: 1. Main Dashboard: - Total number of tasks - Completed tasks - Delayed tasks - Tasks in progress - Task distribution by department - Completion rate per department 2. Central Task Input Sheet: Should include the following fields: - Department name - Task title - Short description - Assigned person - Start date - End date - Priority (High / Medium / Low) - Status (Not Started / In Progress / Completed / Delayed / On Ho...

I am looking for a highly skilled Excel expert to design and develop a comprehensive, user-friendly task management and performance tracking system in Microsoft Excel. The solution should allow efficient allocation, tracking, and reporting of staff tasks across departments, with both daily and monthly visibility. Key Requirements: 1. Task Allocation & Tracking Monthly view of all tasks assigned to each staff member Daily task tracking with progress updates Task allocation based on hourly workloads Track: Department Employee name Task description Standard task completion time Number of tasks assigned Tasks completed per day Pending task list 2. Performance Monitoring Automatic calculation of task completion percentage (daily & monthly) KPI tracking for each employee and department M...

I want a streamlined Excel workbook that lets me keep my entire book collection—both printed copies and e-books—in one place. The file should open to a clean dashboard where I can quickly add a new title, see totals by format, and search or filter by any field I decide to include. Core requirements • Separate tables (or a single master table with a clear Format column) so I can distinguish physical books from digital ones without maintaining two different files. • Built-in search & filter tools—standard Excel filters are fine, but a slicer-driven summary or a small VBA search box would be even better. • At-a-glance metrics: total count, counts by format, and a quick view of what I’ve loaned out (I’ll define the exact fields with you...

我正在同时推进两项内容，需要一位熟悉办公软件与视频编辑的伙伴协助完成： 1. Excel表格 • 根据我提供的原始数据，建立结构化工作表 • 使用常用函数（如VLOOKUP、SUMIF、透视表等）整理与汇总 • 套用清晰的格式与颜色标注，方便后期查阅与打印 2. 教学视频剪辑 • 原片长度约 10–15 分钟，需删减空白、卡顿与多余段落 • 加入片头片尾、淡入淡出转场和背景音乐（我可提供素材，也可接受你推荐的免版税音乐） • 配置简洁字幕与关键步骤提示，最终导出 1080p MP4 请在申请中侧重分享你在 Excel 自动化或视频剪辑（Premiere、Final Cut、DaVinci Resolve 等）的相关经验，最好能附上一两个成品链接或截图，便于我快速评估成效。 交付时间、具体工作流程和任何疑问都欢迎在沟通中进一步确认。期待与你合作！

I need help getting my Excel macros to work. They don't run at all, and I haven't changed my Excel version or disabled macros. Ideal skills and experience: - Expertise in Excel and VBA - Experience troubleshooting Excel macros - Ability to work on older Excel versions

I have a collection of Excel sheets filled with raw numbers that need to be brought up to date, checked for accuracy, and turned into something I can actually use for decision-making. Your first task is straightforward numeric data entry: complete any missing figures and confirm existing totals with simple cross-checks so everything balances. Once the numbers are rock-solid, I’d like you to move straight into data analysis inside the same workbook—think pivot tables, descriptive statistics, and clear charts that highlight key trends. Please keep all work native to Excel (Office 365 or compatible) and avoid external add-ins so the file remains easy for me to open and audit. Deliverables: • Updated workbook with verified numeric entries • Separate analysis sheet c...

I have a batch of information that blends narrative text with numerical figures, and I need it captured precisely in a well-structured Excel workbook. Accuracy takes priority, especially where numbers and text sit side by side in the same rows. You will receive the source files as soon as we start; the exact layout for the spreadsheet—column headers, data types for each field, and any simple validation rules—will be shared up front so you can follow it without guesswork. Deliverable: • A fully populated .xlsx file that mirrors the layout I provide, with all mixed data types correctly entered and formatted. I’ll review the file for consistency, spot-check random rows, and sign off once everything matches the source material. Let me know if you have question...

Build a reusable, branded one-page ROI summary in Excel for a plate funding sales tool. The template must auto-calculate all outputs from a small set of input cells, be formatted with the client's logo and brand colours, and produce a clean customer-facing layout that a sales team can use per deal without any Excel knowledge.

Each month I have a small, repeatable task that takes about half an hour: entering and checking mixed text-and-numeric data that arrives in a spreadsheet. The flow is always the same, so once you understand the routine it should feel quick and predictable. Accuracy matters more than speed, and I need the file returned on the agreed date every month without exception. Because the dataset is drawn directly from spreadsheets, you’ll simply open the source sheet, copy or key the mixed fields into the target file, make sure everything lines up exactly, then save and send it back. That’s it—no complex formulas, no macros, just careful data handling. I’m only able to work with U.S.-based freelancers for this role. If you have reliable month-to-month availability and a ...

Détails du projet Descriptif de la mission : Création d'un Tableau de Bord de Gestion Financière sur Excel Objectif : Concevoir un fichier Excel automatisé, professionnel et visuellement attrayant pour le suivi des recettes et des dépenses, avec mise à jour en temps réel des soldes et des graphiques. 1. Structure du fichier : Le document doit comporter au minimum trois onglets distincts : Configuration : Pour lister les catégories de revenus et de dépenses (ex: Salaire, Ventes, Loyer, Fournitures, etc.). Saisie des données : Un tableau propre pour enregistrer chaque transaction (Date, Description, Catégorie, Type [Recette/Dépense], Montant). Tableau de bord (Dashboard) : Une page de synthèse v...

I need an advanced Excel expert to assist with a independent capstone project. The project requires proficiency in: - VBA, Macros, Formulas, and Functions - Data Visualization, specifically Bar Graphs - Creating Custom Functions Ideal skills and experience would include: - Advanced knowledge of Excel and its functions - Experience in automating tasks using VBA and Macros - Strong data visualization skills, particularly with bar graphs - Ability to create custom functions to meet specific project needs Please provide examples of similar work done.

I have a collection of raw information that needs to be turned into clean, well-structured data. Your task is to take what I provide, enter it accurately, check for consistency, and present it in a clearly formatted file we agree on before you start—whether that ends up being Excel, CSV, or Word. Attention to detail and solid keyboard speed matter more to me than fancy tools, but if you prefer working with spreadsheets, text-processing macros, or simple scripts to accelerate the workflow, feel free to use them. What I really care about is a final file that is error-free, neatly organised, and easy for me to sort or filter later. Send a brief note describing the approach you’d take to keep the data clean from the first keystroke through final delivery, along with a realistic t...

I have a collection of raw information that needs to be turned into clean, well-structured data. Your task is to take what I provide, enter it accurately, check for consistency, and present it in a clearly formatted file we agree on before you start—whether that ends up being Excel, CSV, or Word. Attention to detail and solid keyboard speed matter more to me than fancy tools, but if you prefer working with spreadsheets, text-processing macros, or simple scripts to accelerate the workflow, feel free to use them. What I really care about is a final file that is error-free, neatly organised, and easy for me to sort or filter later. Send a brief note describing the approach you’d take to keep the data clean from the first keystroke through final delivery, along with a realistic t...

I have several Excel spreadsheets containing raw customer information that now need to be turned into a single, reliable data set. Your task is to go through the files, eliminate duplicates, fix obvious entry errors, standardise formats (names, phone numbers, email addresses, dates), and flag anything that looks inconsistent or suspicious. I will provide the spreadsheets plus a short style guide so you know exactly how each field should look when it is “clean”. You’re free to use any solid Excel-based method—formulas, Power Query, VBA, even third-party tools—so long as the end result meets the guidelines and can be inspected easily inside Excel. Deliverables • A cleaned master worksheet with all customer records consolidated and validated • A con...

I have a collection of raw information that needs to be turned into clean, well-structured data. Your task is to take what I provide, enter it accurately, check for consistency, and present it in a clearly formatted file we agree on before you start—whether that ends up being Excel, CSV, or Word. Attention to detail and solid keyboard speed matter more to me than fancy tools, but if you prefer working with spreadsheets, text-processing macros, or simple scripts to accelerate the workflow, feel free to use them. What I really care about is a final file that is error-free, neatly organised, and easy for me to sort or filter later. Send a brief note describing the approach you’d take to keep the data clean from the first keystroke through final delivery, along with a realistic t...

I have an existing Excel file that lists product quotations, but its layout is messy and makes quick pricing reviews difficult. I need it turned into a clear, professional template—with tidy column headers, consistent currency and percentage formatting, built-in totals, and space for my logo and client details—all by tomorrow. You will receive the current workbook plus a short style guide. Please keep every price and SKU exactly as they are while improving readability and adding any formulas needed for automatic subtotals, taxes, and grand totals. When finished, send back the polished .xlsx and a ready-to-print PDF version. Acceptance criteria • No data loss or price changes • Formulas work when I add new rows • Headings, fonts, and cell styles match the ...

I have a set of purely numeric records that must be transferred into Microsoft Excel with absolute accuracy. Because I don’t have an existing template, you’ll create a clear, well-structured workbook from scratch, choosing columns, headings, and basic formulas so the figures are easy to read and verify. All data provided will be numbers only, so speed keys such as flash-fill, data validation, or simple SUM/AVERAGE formulas are welcome if they help maintain consistency without over-engineering the file. What matters most is error-free entry and a logical layout. Timing: an initial draft is expected within the next 2–3 days; the final, polished version must be delivered within a month at the latest. Deliverables • One Excel (.xlsx) workbook containing every numeri...

I'm looking for an expert to build a custom spreadsheet template to track, document, calculate, and analyze financial data. Requirements: - Handle complex financial data - Advanced calculations using custom formulas - Incorporate advanced functions like macros or pivot tables Ideal Skills and Experience: - Proficiency in spreadsheet software (e.g., Excel, Google Sheets) - Experience with advanced formulas, macros, and pivot tables - Strong background in financial data analysis

Summary Build Executive-Level Gantt Chart in PowerPoint from Dependency Tracker (with Cascade Impacts) Description I am looking for an experienced PowerPoint / data visualization specialist to convert an Excel-based dependency tracker into a **high-quality executive Gantt chart presentation**. The output must be **clean, visually compelling, and suitable for senior leadership (SteerCo level)**. What I Will Provide * Excel dependency tracker (fully populated) * Includes: * Dependency IDs and names * Upstream and downstream programs * Required dates * RAG status (Red / Amber / Green) * Impact levels * Cascade impact descriptions (cause → effect chains) * Impact category (Release, Program, Client, Financial) * Critical flag * Impacted milestone What You Need to D...

I already have a working NetSuite ↔ ShipStation connector that pushes standard order data without issue. The remaining gap is five customer-level notes that I keep in NetSuite—“Custom 1, 2, 3”, “Internal Note”, and “Note From Buyer.” I need these text fields to travel with every order and land in equivalent custom fields inside ShipStation. The job is straightforward: extend the existing SuiteScript / RESTlet logic (or whatever method you prefer) so those three NetSuite fields are picked up, passed through the ShipStation API, and show up on the order record there. No extra validation or special formatting is required; plain text is fine as long as the content matches exactly. Please update the code, deploy it to my sandbox first, run a samp...

I’ve built our social-media content calendar in Excel and now need a clear, scroll-friendly timeline inside the same file. The goal is to glance at the sheet and instantly see which posts are scheduled, which channel or format they belong to, and how they line up across the coming days. Here is what I need you to deliver: • Insert an in-sheet timeline (think lightweight Gantt) that automatically pulls from the existing rows. • Display two data points on every bar: the scheduled post date and its content type (e.g., Reel, Story, Blog-link). • Keep it dynamic—when we add or shift a row, the visual updates without extra steps. The workbook is already structured; you can add helper columns, named ranges, or PivotCharts if that speeds things up, but please a...

Create a dynamic Excel workbook tailored for the South African market, using SI units (m, kN, MPa), to design and analyse reinforced concrete T-beams. Scope: Reinforced concrete T-beam design and analysis (including shear stress, bending, reinforcement requirements, etc.) Compliance with relevant South African design standards (e.g. SANS codes / Eurocode where applicable) Workbook requirements: Fully linked formulas across structured sheets Clear separation of inputs, assumptions, and calculated outputs Detailed design tables for reinforcement (flexural and shear), section properties, and load effects Automated calculations with minimal manual input Embedded tables and charts for visualisation and validation User-friendly layout with clear labels and guidance Additional requirement: ...

I use Saral Accounts in a medium-sized enterprise and need the system organised so that every day’s sales and expense transactions are entered quickly and end up in the right ledgers without extra spreadsheet work. Once the data is flowing correctly I also want a reliable set of monthly reports generated straight from the software: the standard Profit & Loss plus a Balance Sheet, Cash-Flow Statement, Sales Summary and an additional “renovation” report that pulls together costs we tag to that heading. To keep this project focused, here is what I expect from you: • Configure or refine the daily-entry screens so staff can post both sales and expenses with minimal clicks. • Set up any required ledgers, item masters or tags in Saral Accounts to feed the repor...

I have 10–15 short-term rental listings already laid out in Canva that just need a quick content check—spelling, alignment, overall polish—before I share them with guests. After that light review, pull everything into a single Excel workbook. Here’s what I’m after for each listing: the listing title, the live Canva design link, and an embedded preview of the design right inside the worksheet (using Excel’s picture/object insert so I can scroll and see each design at a glance). If the original photos are handy, feel free to park them in a sub-folder and note their path in the sheet; keeping the main file streamlined is the priority. Final deliverable: one tidy Excel file covering all 10–15 listings, with every design embedded and linked, ready for...

Necesito que diseñes y construyas una base de datos que me permita generar reportes de costos claros y rápidos. El foco está en tres componentes clave: • Costos fijos • Costos variables • Costos de producción Quiero que, con un par de clics, pueda descargar estos informes directamente en Excel con el formato listo para presentar. La solución debe: – Incluir un modelo de datos bien estructurado, fácil de mantener y de escalar. – Permitir la carga y actualización periódica de la información (idealmente mediante plantillas o importación masiva). – Automatizar la generación de reportes de costos en Excel, con filtros por periodo y centro de costos. – Venir acom...

The objective of this project is to develop an automated system that can extract the Annual Filing Status of companies from the MCA website () through the path MCA Services → FO Services → Check Annual Filing Status (V3). The system should accept either the Company Name or CIN (Corporate Identification Number) as input and automatically search and select the relevant company from the results. Once the company page is accessed, the tool should capture year-wise filing details, specifically for forms AOC-4 (or AOC-4 XBRL), MGT-7, and ADT-1. The extracted data must be structured in a predefined format showing the company name and financial year-wise filing status, and should be exportable into Excel or CSV format. The solution should support both single and bulk company processing, ...

I have a set of records labelled “Data emtry” that must be transferred into a clean, well-structured Excel spreadsheet. You will receive the raw files and a template workbook with predefined columns; your task is simply to key every value into the correct cell, maintaining the original text and numbers exactly as shown. Accuracy is critical, so please double-check each entry before saving. When you finish, return the completed .xlsx file and keep the source material confidential. Let me know your estimated turnaround time and any clarifying questions you may have so we can get started right away.

All of the raw figures for our project are already sitting in a single Excel workbook; what I need now is a polished report that turns those numbers into a clear, management-ready dashboard focused on overall project status. The analysis itself is straightforward—primarily status-tracking with the usual descriptive break-downs—so the real value will come from designing crisp visuals, dynamic summaries, and any drill-downs that help senior management grasp progress at a glance. Because the data set is complete, you can dive straight into building formulas, pivot tables, charts, or even connect the file to Power BI if that speeds up interactivity. Deliverables • A live, refreshable dashboard (within Excel or a linked BI layer) showing key status KPIs, trends, and var...

I need a clear, practical walk-through of Excel that focuses first on feeling at home with the Tabs—how to locate key commands quickly and move between the different groups inside each tab. Once that foundation is solid, I want to practise routine data entry so I can drop text, numbers, and date values into the right cells without slowing down. The last piece is basic but essential formatting: switching fonts, shading or colouring cells for emphasis, and adding crisp borders so my sheets look tidy and professional. Please guide me step by step, share best-practice shortcuts as we go, and make sure I can repeat every action confidently on my own by the end of the session.

I need a solution to automate the generation of financial reports using data from Excel spreadsheets. Requirements: - Automate report generation process - Utilize Excel spreadsheets as data source Ideal Skills: - Expertise in Excel and automation tools - Experience with financial report generation - Familiarity with integrating Excel with automation software

I need a small utility that pulls customer sales and payment-receipt data out of Tally, drops it neatly into Excel, reconciles each invoice against what has been paid, and then reminds the customer when something is coming due. In the Excel file I must see: • Customer name and contact information • Exact sales and payment amounts already recorded in Tally • The original invoice date alongside the payment due date As soon as the sheet opens it should refresh from Tally (ODBC/XML is fine), calculate outstanding balances, flag anything overdue, and fire a WhatsApp reminder directly from Excel. A quick “Send All” button that loops through the due items is ideal, but individual sends must also be possible. I am happy with a lightweight VBA or Power Query appro...

ENTERPRISE MASTER EXCEL ARCHITECTURE File Name DATA MODEL (STAR SCHEMA IN EXCEL) You will maintain one Fact table + multiple Dimension tables + Analytics layer. DIM_PART │ DIM_CUSTOMER ─ FACT_TRANSACTIONS ─ DIM_SUPPLIER │ DIM_DATE │ PRICE_HISTORY │ DASHBOARD / PIVOTS 1. FACT_TRANSACTIONS (CORE ENGINE) Every row = 1 part line (quote/invoice/PO) Field Description Transaction ID Unique (auto) Date Key Link to DIM_DATE Part Code Link to DIM_PART Customer ID Link to DIM_CUSTOMER Doc Type Quote / PO / Invoice Doc No QT / INV / PO Qty Quantity USD Price Unit price INR Value Total Currency USD / INR Source File QT reference Remarks Notes This is your single source of truth 2. DIM_PAR...

My Excel workbooks suffer from frequent duplicate records, inconsistent formatting, and other invalid values spread across multiple sheets. I need a specialist who can systematically scan every column and row, eliminate duplicates, apply consistent number/date/text formats in line with my basic house-style rules, and flag or correct any entries that fall outside logical ranges. The datasets are large, so I expect you to lean on efficient methods—Power Query, VBA macros, or advanced formula workflows—rather than manual spot-fixing. Once complete, the file should open without errors, pass a quick filter test for duplicates, and display uniform cell styles throughout. Deliverables: • A fully cleansed, consistently formatted Excel workbook. • A brief change log summar...

I need a solution to automate the generation of financial reports using data from Excel spreadsheets. Requirements: - Automate report generation process - Utilize Excel spreadsheets as data source Ideal Skills: - Expertise in Excel and automation tools - Experience with financial report generation - Familiarity with integrating Excel with automation software

Please complete the following problems from Chapter 8 as listed below: Chapter 8 (Use Excel, ignore other software POM): Problem 3 (just run a regression analysis using the data analysis tool, then you can answer) Problem 5 (age is the independent variable, maintenance is the dependent variable). Please ignore least squares; just run a regression analysis using the data analysis tool. Problem 7 Problem 9 Please show all your calculations (not only answers). More help file in Excel Please show all your calculations (not only answers). Highlight answer please The Excel file below has data for your problems (go to the question chapter tab, copy and paste to your own Excel sheet or Word document). Do not solve in the given Excel sheet. Data from Excel for homework, The Excel file...

I need a seasoned strategist to sit with me—virtually—and help sharpen my company’s operational efficiency. During our consultation we will map the current workflow, spot bottlenecks, and outline practical, low-friction improvements I can put in place right away. I’m comfortable sharing metrics, process maps, and any back-office data you need to make the session effective. The engagement is deliberately lean: a focused call of about an hour, followed by a brief written summary (bullet points are fine) highlighting quick wins, longer-term recommendations, and any relevant benchmarks or tools you suggest. Think of it as donating your expertise; I will reciprocate with a donation for the time you invest. If you thrive on turning tangled ops into smooth, efficient sys...

I’m refreshing my personal website and need a single, punchy headline that instantly signals credibility while still sounding approachable and down-to-earth. The line will sit at the very top of my home page, so it has to balance professional polish with a conversational vibe—think “expert next-door” rather than stiff corporate jargon. What I’m after: • One standout headline written in a relaxed, confident tone. • Two alternate versions so I can test which resonates best. • Each option should come with a one-sentence rationale that explains the angle you took. I’ll share a short bio and a few career highlights once we start; you’ll weave the strongest themes into the wording. Keep it tight (ideally under 12 words), free of buzz...

I need a complete, working business suite that covers Accounting, Sales, Inventory, Invoicing and Personnel Payroll. You may deliver it as one integrated application or as clearly linked modules, provided every part runs reliably on its own and shares data smoothly. Accepted languages are Python, C or Visual Basic .NET—choose whichever you already master. What matters most is that you hand over the full, well-commented source code, a sample database, and clear build/run instructions so I can compile or execute everything on a Windows machine without extra troubleshooting. Typical flows should work out of the box: inventory updates after a purchase, receivables after a sale, payroll entries posting to the ledger, plus standard reports such as trial balance, income statement, stock...

I have a raw banking list that I need reshaped into a clean, reliable Excel workbook that lets me see every deposit and withdrawal at a glance. The primary goal is simple: organize those transactions by date so I can quickly filter, sort, and review activity month-to-month. You’ll start with the file I provide (CSV or PDF export—whichever you prefer to import) and build a worksheet that includes clear column headers, consistent formatting, and a running balance. Logical features such as date-based filtering, basic conditional formatting for quick visual checks, and an easy-to-update table structure are exactly what I’m after. If you enjoy adding a quick pivot or summary sheet for totals by month, that would be a bonus, but the core requirement is a straightforward, no-fr...

Excel VBA was working properly until last month. But currently not working. I am looking for a VBA developer. I think 30mins or 1 hour is enough to resolve.

My Excel workbooks suffer from frequent duplicate records, inconsistent formatting, and other invalid values spread across multiple sheets. I need a specialist who can systematically scan every column and row, eliminate duplicates, apply consistent number/date/text formats in line with my basic house-style rules, and flag or correct any entries that fall outside logical ranges. The datasets are large, so I expect you to lean on efficient methods—Power Query, VBA macros, or advanced formula workflows—rather than manual spot-fixing. Once complete, the file should open without errors, pass a quick filter test for duplicates, and display uniform cell styles throughout. Deliverables: • A fully cleansed, consistently formatted Excel workbook. • A brief change log summar...

Overview The objective is to build a private, high-security Wealth Management System in Microsoft Excel that leverages AI (LLM APIs) to provide strategic financial oversight. The tool will transition from a manual ledger into a "Strategic Advisor" capable of micro/macro-analysis, tax optimization, and inheritance planning. Structure & User Interface (The Workbook) The system must be organized into the following synchronized layers: • Sheet 1: Definition & Legacy Profile – User financial profile, risk appetite, specific objectives, and Inheritance/Succession parameters (beneficiaries, tax jurisdictions, and asset protection goals). • Sheet 2: DB Transactions – A structured, relational database ledger for manual entry (Date, Amount, Currency, Category...

I need a specialist who can build robust, reusable Excel 365 formulas for an existing workbook. The work centres on creating truly advanced logic rather than simple cell references. In practical terms, every formula you write must: • include reliable error handling so any #N/A, #DIV/0! or similar issues are gracefully managed • use nested functions where they provide the cleanest, fastest solution • trigger conditional formatting rules that instantly flag results requiring attention I will supply a sample file with annotated targets and a brief “business-rules” document describing what each output should show. Your job is to translate those rules into efficient formulas, test them in Excel 365, and return the updated file together with a short explanation...

I have a collection of Excel (.xlsx) files containing text-only records that need to be copied, verified, and placed into a new master spreadsheet I will provide. The job is straightforward yet demands close attention to spelling, spacing, and column alignment—no numerical fields, formulas, or calculations are involved. You will receive the source workbooks via a shared drive link. Your tasks are to: • Open each sheet, copy the text exactly as written, • Paste it into the matching columns of the template I supply, and • Double-check for any accidental truncation or hidden characters before saving. A quick turnaround with zero introduced errors is my priority. When you return the completed master file, I will spot-check several rows; if everything matches the ori...

I have several Excel workbooks that track our stock supply quantities. Unfortunately, the running balances have drifted and I keep running into inconsistent data. I need a data-savvy professional to dig into the spreadsheets, locate every mismatch, and return a clean, fully reconciled file. Here is what I’m after: • Work directly in the existing .xlsx files—no data extraction needed. • Clean and standardise the key columns (item code, in-qty, out-qty, balance, unit cost, payment status). • Identify and flag each row, SKU, or date range where the quantity on hand does not reconcile with the recorded movements. • Produce a short findings report that highlights the size and cause of each discrepancy, backed by pivot tables or charts so the results are ...

I have a batch of raw sales numbers that need to be transformed into a clean, analysis-ready Excel file and a concise PowerPoint deck. In Excel, I want robust formulas and functions that automate all key calculations—totals, variances, growth rates, anything that helps me slice the data by product, region, or period without manual work. If you see an opportunity where a quick pivot table or a simple chart would clarify the story, feel free to propose it, but the priority is rock-solid formulas that won’t break when new rows are added. Once the spreadsheet is in place, I’ll need a companion presentation that walks stakeholders through the insights. Keep the design professional and on-brand: consistent colour palette, clear typography, and layouts that let the numbers...