Excel VBA Jobs

Înregistrează-te sau Conectează-te pentru a vedea detaliile.

Develop an Advanced Excel-Based Construction Cost Estimation System You are an experienced Civil Quantity Surveyor, Construction Cost Estimator, Structural Engineer, BOQ Specialist, and Advanced Excel Automation Expert with deep expertise in residential construction costing. Objective Develop a comprehensive, automated Construction Cost Estimation System in Microsoft Excel that can accurately estimate the complete construction cost of residential projects based on user inputs. The system should function as an intelligent estimator that minimizes manual calculations and generates detailed quotations, BOQs, material and labour requirements, and cost breakdowns. Functional Requirements 1. Project Information Collection The estimator should begin by collecting all the essential project details...

I need an Excel spreadsheet fully replicated in Google Sheets. Requirements: - Transfer of all formulas and calculations - Complex functions: VLOOKUP/HLOOKUP, IF/AND/OR, and array formulas - Application of data validation rules and conditional formatting Ideal Skills and Experience: - Proficiency in both Excel and Google Sheets - Experience with complex formulas and data validation - Attention to detail to ensure accuracy in migration

I have a live workbook that already holds well over 10,000 rows and it desperately needs a meticulous touch. Every duplicate has to disappear, all stray date and currency formats must be normalised, and the whole sheet needs to be sorted so the information is logically grouped and easy to filter. On top of that, a batch of source documents in PDF must be converted into Excel and folded into the same structure without breaking alignment or introducing extra white-space characters. Accuracy and 100 % confidentiality are non-negotiable because the file contains customer information. Deliverables • A single, organised Excel file with every duplicate removed, formats standardised, and data professionally sorted. • All supplied PDFs transcribed into matching Excel columns and ...

Rebuilding an unwieldy quoting tool into a clean, modular system is a highly effective way to eliminate errors and speed up your workflow. Keeping reference data separate from your main calculation engine ensures that updating yearly rates won’t break your active client templates. Here is the blueprint for your new, streamlined Excel quotation system. System Architecture To ensure reliability, all four workbooks must be saved in the same local folder or cloud directory. Excel resolves relative paths automatically for files in the same folder, preventing broken links. 1. Primary Workbook: This is the only file your team will open daily. It handles inputs and generates the client-facing quote. • Sheet 1: Cover & Inputs • Fields: Client Name, Project Title, Date...

Înregistrează-te sau Conectează-te pentru a vedea detaliile.

I want to turn a plain-looking workbook into a polished fintech experience, completely inside Excel. The end result should feel like commercial software rather than a template, with clean navigation, protective formatting and responsive formulas/VBA so users never see the “spreadsheet guts.” Design tone I gravitate toward a classic aesthetic—elegant typography, restrained colour palette, clear hierarchy—so every sheet and chart needs to reflect that timeless look. Phase-one focus We will begin with the Income Tracker. I need an input interface that feels form-based, instantly categorises income streams, and rolls the data into dynamic views (daily, weekly, monthly). Slicers or a custom ribbon button for quick period changes are welcome if they keep the expe...

I need a clean, ready-to-use Excel file that lets me organise mobile numbers for my business contacts. I will be recording each contact’s name, company, designation, primary mobile number and a few optional fields such as email, city and short notes. The sheet must be simple for day-to-day data entry yet professional enough to filter, sort or search quickly when the list grows. Practical touches like data-validation on the mobile column (to ensure only 10-digit numbers), drop-downs for city or category, and conditional formatting for duplicates will help a lot. I’d also like a summary tab that instantly shows the total number of contacts and highlights any missing key details. Deliverable: one Excel workbook (.xlsx) that opens without macros on Microsoft 365, already formatte...

Based on everything we’ve worked through, you’re not just building a dashboard—you’re building a workforce planning platform. A freelancer will do much better if they understand the business problem first. ⸻ Workforce Planning & Labor Intelligence Dashboard Project Overview I am creating an Excel-based workforce planning and labor intelligence tool for a large distribution center. The goal is to replace manual staffing decisions with a centralized, data-driven system that helps leaders make faster and more accurate labor decisions. The dashboard will combine information from multiple Excel sheets into one interactive workbook that automatically calculates staffing health, labor gaps, attendance, and workforce recommendations. This tool is designed for thre...

I need my date-tracking sheet polished today. Every date must follow a single style—spell out the month, then the year (for example, “January 2024”). While you work through the column, please realign any off-center cells and apply one uniform font family, size, and style so the whole sheet looks consistent. No duplicate removal or error checking is required; this is purely a formatting pass. Once the file comes back with tidy alignment, consistent fonts, and the new date format across the board, the job is done. I’ll send the spreadsheet as soon as you accept and will be available for quick feedback so we can wrap this up before the day ends.

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

I use Tally Prime / Tally ERP for day-to-day bookkeeping and need experienced hands to keep everything up-to-date and fully reconciled. The workload centres on three core areas: • Voucher and ledger upkeep – enter every sale, purchase, payment, receipt and journal accurately each day so all ledgers stay current. • GST compliance – post GST invoices, then prepare the basic GST reports I need for filing (GSTR-1, GSTR-3B, mismatch checks). • Bank reconciliation – match bank statements with Tally, investigate variances and close each period with zero unreconciled items. Alongside Tally work, I often export data to Microsoft Excel for deeper analysis. You will create and maintain spreadsheets that include clean data entry sheets, smart formulas and automat...

My current bookkeeping is scattered and I want everything organised in one Excel file that lets me record every income and expense once and then shows me clear, ready-to-print financial reports automatically. Scope of work • Build a clean data-entry sheet dedicated to Income and Expenses, with columns such as date, category, description and amount. • Create the behind-the-scenes formulas that roll those entries into running totals, monthly and yearly summaries, and an overall balance. • Add a separate “Reports” tab that pulls the data into at least a profit-and-loss style summary plus any other insightful views you think would help me monitor cash flow quickly. Dynamic tables, slicers or simple charts are welcome if they keep the file easy to use. •...

I want to turn a workbook that currently relies on manual typing into a push-button process. The flow is simple in theory—data comes from people keying numbers or text straight into Excel—yet it’s time-consuming and error-prone. Here’s what I need: when a user opens the file, they should be guided through an organised form or other intuitive interface that writes their input to the correct sheets, performs validation, and stamps a time-and-user log automatically. As soon as the new records land, Excel should run the built-in statistical routines I specify (mean, standard deviation, t-tests, simple regressions and similar core stats) and update all summary tables, charts and printable reports without further clicks. I’m comfortable if you lean on VBA, mac...

I need an Excel price sheet recreated for printing. Requirements: - Include product names and prices - Simple table format - Company logo and contact information - Create separate retail and wholesale versions Ideal Skills: - Proficiency in Excel - Experience with creating printable price sheets - Attention to detail and good design sense for simple, professional layouts

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

I’m looking for a patient instructor who can walk me through two key areas that I use every day but still don’t feel fully confident about: Excel and general email management. On the Excel side, my goal is to become comfortable with basic formulas and functions (SUM, AVERAGE, IF, etc.) and then quickly move into creating clear, compelling charts or graphs for small reports. I don’t need advanced automation or pivot tables right now—just practical, hands-on skills I can apply immediately in my job. For email, I’d like to streamline the way I organize my inbox and folders, create rules or filters, and generally adopt best practices so important messages never slip through the cracks. Here’s how I picture the collaboration: • Short, focused sessions...

I need an Excel expert to improve my existing business workbook. The sheet already contains customer details, revenue, expenses, profit, and aggregator information. I want to add a professional dashboard with monthly and yearly comparisons, partner-wise analysis, charts, graphs, KPIs, and other visual reports to help me track business performance. The final workbook should be automated, user-friendly, and easy to update with new data.

I’m consolidating a mixed set of text and numerical records into an Excel-based database. Your task is to take the source documents I provide and enter every field into my pre-formatted spreadsheet template, keeping both the layout and data types intact. The files include names, descriptions, IDs, quantities, and prices, so close attention to text accuracy and proper numeric formatting is essential. I’ll share a short walkthrough video, the template (.xlsx), and a list of validation rules with dropdowns and conditional formatting already in place. Deliverable • A fully populated Excel file that mirrors the template, free of typos, empty rows, or formatting drift. Acceptance criteria • 100 % of source rows transferred. • No numeric field stored as text. ...

I’m consolidating a mixed set of text and numerical records into an Excel-based database. Your task is to take the source documents I provide and enter every field into my pre-formatted spreadsheet template, keeping both the layout and data types intact. The files include names, descriptions, IDs, quantities, and prices, so close attention to text accuracy and proper numeric formatting is essential. I’ll share a short walkthrough video, the template (.xlsx), and a list of validation rules with dropdowns and conditional formatting already in place. Deliverable • A fully populated Excel file that mirrors the template, free of typos, empty rows, or formatting drift. Acceptance criteria • 100 % of source rows transferred. • No numeric field stored as text. ...

I’m consolidating a mixed set of text and numerical records into an Excel-based database. Your task is to take the source documents I provide and enter every field into my pre-formatted spreadsheet template, keeping both the layout and data types intact. The files include names, descriptions, IDs, quantities, and prices, so close attention to text accuracy and proper numeric formatting is essential. I’ll share a short walkthrough video, the template (.xlsx), and a list of validation rules with dropdowns and conditional formatting already in place. Deliverable • A fully populated Excel file that mirrors the template, free of typos, empty rows, or formatting drift. Acceptance criteria • 100 % of source rows transferred. • No numeric field stored as text. ...

I need help correcting formula errors in a complex Excel spreadsheet. Requirements: - Fix formula errors in specific sections - Ensure data integrity and accuracy Ideal Skills: - Advanced Excel proficiency - Strong problem-solving skills - Attention to detail Experience with complex spreadsheets is a plus.

I have several Excel spreadsheets holding strings of information—names, addresses, reference notes, short descriptions—that all need to be brought into one clean, consistent master sheet. Every entry must be copied exactly as written, checked for stray spaces or line-break issues, and parked in the correct column of the template I will share at kickoff. The job is entirely text-based; no numeric formulas or image conversions are involved. Source files are already in .xlsx format, so you can work directly inside Excel without any import steps. Simply follow the field order I supply, keep capitalization exactly as shown, and flag any illegible or duplicate items in a separate tab so we can review them later. Deliverable: • A final Excel workbook containing all supplied rec...

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

I am looking for an Excel specialist to develop a professional executive dashboard based on an existing and structured Excel database. The dashboard must closely follow the attached reference image, maintaining the same visual style, layout, KPI cards, charts, and indicators. The workbook already contains the database, formulas, and part of the structure. The scope of work is to build the dashboard, configure Pivot Tables, Slicers, Timeline, and dynamic charts, delivering a modern, clean, and fully functional dashboard for executive presentations. Proven experience with professional Excel dashboards is highly desirable. If you have prior examples of Excel dashboards—especially around HR or performance management—feel free to include a screenshot or brief description when you re...

I'm looking for an Excel expert to help with financial calculations, specifically for creating and fixing formulas on an expense report for a small company. Key requirements: - Proficiency in Excel, especially in financial formulas - Experience in creating and fixing complex formulas - Ability to organize and analyze financial data Ideal skills and experience: - Background in finance or accounting - Strong problem-solving skills - Attention to detail and accuracy Your expertise will help streamline our expense reporting process.

I’m consolidating a mixed set of text and numerical records into an Excel-based database. Your task is to take the source documents I provide and enter every field into my pre-formatted spreadsheet template, keeping both the layout and data types intact. The files include names, descriptions, IDs, quantities, and prices, so close attention to text accuracy and proper numeric formatting is essential. I’ll share a short walkthrough video, the template (.xlsx), and a list of validation rules with dropdowns and conditional formatting already in place. Deliverable • A fully populated Excel file that mirrors the template, free of typos, empty rows, or formatting drift. Acceptance criteria • 100 % of source rows transferred. • No numeric field stored as text. ...

I need assistance in converting Excel vb script that generate contract in docs using macro into Python scripts. The project involves: - Converting mathematical and text manipulation formulas - Working with Vb scripts that pull data from Excel - Generating Word contracts using the data Ideal skills and experience: - Proficiency in Python - Strong understanding of Excel formulas - Experience with data manipulation and automation tasks - Familiarity with generating Word documents through Python Please provide examples of similar work done.

Saya membutuhkan bantuan untuk menangani pekerjaan data entry berbasis Excel. Fokus utamanya: • Memasukkan data dari berbagai sumber (file CSV, PDF, atau website internal) ke dalam template Excel yang sudah saya sediakan. • Membersihkan, menata ulang, dan mengelompokkan data agar formatnya konsisten, bebas duplikat, serta mudah difilter dan dianalisis. Saya akan menyerahkan file sumber, panduan penamaan kolom, dan contoh akhir yang diharapkan. Silakan gunakan fitur‐fitur Excel seperti sort, filter, text-to-columns, dan formula sederhana (VLOOKUP, IF, atau sejenisnya) bila diperlukan. Hasil akhir yang saya inginkan berupa satu berkas Excel siap pakai dengan sheet terstruktur rapi beserta catatan singkat tentang langkah pembersihan yang Anda lakukan. Prioritaskan akurasi dan k...

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

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

I have an Excel workbook called “VlookupPracticeExamples.xlsx.” The VLOOKUP formulas that are already in place appear to be returning the wrong values, even though they do not produce a #N/A message. I need someone to open the file, diagnose exactly why the lookups are pulling incorrect results, and then correct every affected formula so the returned values match the underlying data. Please keep your approach transparent: highlight any range issues, column-index mistakes, or lookup-type mismatches you uncover, and then replace or adjust the formulas accordingly. A short note inside the sheet (or a separate tab) explaining each fix will help me follow your logic later. To apply, send over a brief example of past work where you successfully traced and resolved VLOOKUP or simila...

I need a professional to assist with multiple financial and Excel tasks. Key Responsibilities: - Automated Reporting in Excel - Data Validation and Verification - Managing EPF, ESIC, and P Tax Returns - Handling TALLY, GST, and TDS Returns Ideal Skills: - Expertise in Excel, especially in automated reporting - Experience with EPF, ESIC, P Tax, TALLY, GST, and TDS - Strong attention to detail for data validation Please provide relevant experience in your bids.

I have a collection of printed documents that I need converted into clean, well-organized text inside an Excel spreadsheet. Each page contains straightforward text—no complex tables or mixed numerics—so the task is to read the printed material and key the wording exactly as shown into the designated columns I will provide. Accuracy is critical. I will supply high-resolution scans (PDF) along with a short guide that explains the column layout, required sheet names, and a few simple validation checks I use. Once you finish a batch, I’ll spot-check for typos and consistency in capitalization, spacing, and line breaks before approving the next batch. Deliverable: the completed Excel file with every page of text entered, saved in .xlsx format and ready for immediate use. If ...

Developed an interactive Logistics & Delivery Performance Dashboard in Excel using Power Query, Pivot Tables, Pivot Charts, KPI Cards, and Slicers. Analyzed 5,000+ e-commerce orders by performing data cleaning, handling missing values, creating custom metrics (Delivery in Days, Delivery Performance, and Total Logistics Cost), and generating business insights related to delivery efficiency, cancellations, logistics costs, and product demand.

I have a sizeable spreadsheet that needs a thorough clean-up in Microsoft Excel. The raw file contains duplicates, inconsistent formats, stray blanks and a few obvious typos. I’m looking for someone who can methodically work through the sheet—using whatever mix of formulas, Power Query, or manual checks you prefer—to deliver a polished, analysis-ready workbook. Accuracy is more important than speed, so the timeline is flexible. When you respond, please highlight your experience handling similar Excel data-cleaning jobs; examples of past successes will help me gauge fit. Final deliverable: the cleaned Excel file plus a short note summarising the main issues you found and the fixes you applied.