Macros do Excel Jobs

My courier has issued a comprehensive rate card and I need those numbers turned into a live Excel matrix that my e-commerce platform can read without further tweaks. The finished sheet must calculate charges by matching two factors—weight of the package and the destination zone—and return the correct variable-by-weight price every time. I will supply: • the original courier rate card • an Excel template that already shows the required row / column layout What I expect back: • the completed matrix with formulas or look-ups inserted, fully tested across all weight breaks and zones • a short note explaining any hidden helper tables or named ranges you create, so I can maintain it later Accuracy is critical; the numbers in the final matrix must mirror...

I need an Excel sheet to record users for applications access review. The data should be organized in a pivot table for detailed analysis. This project involves an Applications Access Review, starting with two applications containing sensitive information. The goal is to clean up user access by gathering a list of users from each department in the company. These users will be reviewed, categorized, and unnecessary access will be eliminated. You need to record the following information: - User ID and names - Access levels and permissions - Last access date - Department - Inactive user And any other information that you recommend Ideal skills and experience: - Proficiency in Excel, especially with pivot tables - Experience in data organization and management - Attention to detail

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

I have several Excel workbooks that need a straightforward tidy-up. All the source material is already digital, so there’s no scanning involved—just working directly in the spreadsheets I provide. Your job is to reorganize the information, apply consistent formatting, and generally make each sheet clear, readable, and ready for immediate use or reporting. Key deliverable • A single, well-organized Excel file for each original workbook, with clean headings, uniform cell styles, and properly structured tables (no stray blanks or merged-cell surprises). If you have a good eye for detail, solid Excel skills, and can turn this around efficiently, I’d like to hear how quickly you can start and your estimated completion time.

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

I have several Excel workbooks that need a straightforward tidy-up. All the source material is already digital, so there’s no scanning involved—just working directly in the spreadsheets I provide. Your job is to reorganize the information, apply consistent formatting, and generally make each sheet clear, readable, and ready for immediate use or reporting. Key deliverable • A single, well-organized Excel file for each original workbook, with clean headings, uniform cell styles, and properly structured tables (no stray blanks or merged-cell surprises). If you have a good eye for detail, solid Excel skills, and can turn this around efficiently, I’d like to hear how quickly you can start and your estimated completion time.

Saya berencana memulai karier sebagai freelancer di bidang desain grafis dan membutuhkan pendampingan praktis dari orang yang sudah berpengalaman. Latar belakang saya kuat di Excel dan Word, tetapi belum terbiasa dengan tool desain standar industri seperti Adobe Photoshop, Adobe Illustrator, atau CorelDRAW. Apa yang saya perlukan: • Penjelasan langkah-demi-langkah untuk memetakan layanan desain grafis yang paling cocok bagi saya. • Sesi bimbingan online singkat (chat atau video) yang membantu saya mengenal dasar penggunaan Photoshop, Illustrator, maupun alternatif lain yang Anda rekomendasikan. • Contoh proyek latihan—misalnya logo, konten media sosial, atau brosur—beserta umpan balik agar saya punya portofolio awal. • Saran praktis tentang cara menen...

I need an expert in Microsoft Excel to assist with advanced formulas and calculations. The ideal candidate will have: - Proficiency in array formulas and nested functions - Experience with complex conditional calculations (e.g., IF statements) - Strong problem-solving skills to tackle intricate Excel challenges Please provide examples of previous work and relevant qualifications.

I need to automate my export business processes currently managed in Microsoft Excel. I'm looking for a solution that can streamline and automate the following tasks: - Data Entry: Reduce manual input and errors. - Generating Reports: Create automated, real-time reports. - Tracking Shipments: Automate and simplify shipment tracking. Ideal skills and experience: - Expertise in Excel automation and integration. - Experience with export business processes. - Ability to develop custom solutions or workflows. Looking for someone who can deliver an efficient, user-friendly automation flow.

I need a single Excel workbook that lets me broadcast personalised WhatsApp Business messages straight from the sheet. Core flow is simple: • I drop or paste a contact list into a dedicated sheet (structure: phone number, name, any merge fields you feel are useful). • I type one master message that can pull those merge fields so every recipient gets a tailored text. For this first release we will stick to text-only messages; later on I may ask you to extend it to images or documents, so please keep the code modular. • When I hit “Send”, your VBA (or Office Script) routine should call the official WhatsApp Business API, handle authentication, queue the messages and confirm each send. Stability is key. The workbook must trap API errors, surface clear status m...

Excel Automation for Billing & Financial Projections We are looking for an experienced Excel automation freelancer to develop a smart and user-friendly Excel-based system for billing, financial projections, and reporting dashboards. Scope of Work: Create dynamic financial projection models Develop automated calculations and summaries. Design dashboards and MIS reports. Use advanced Excel formulas, Pivot Tables, Power Query, and VBA/macros wherever required. Ensure the file is easy to use and scalable for future requirements. Key Requirements: Strong expertise in Microsoft Excel automation Experience in financial modeling, billing systems, and projections Knowledge of VBA/macros preferred Ability to create clean, professional, and efficient templates Deliverables: Fully functional a...

I need a set of tightly linked Excel workbooks that take sales leads from first contact through close, flag every key project milestone along the way, and—with a single click—spin out clean performance reports for management. Scope of work • Build advanced automation with VBA macros. Think push-button forms that add or update records, automatic time-stamps, self-refreshing pivot tables, and dynamic charts that redraw as data changes. • Three core functions are mandatory: tracking sales leads, monitoring project milestones, and generating performance reports. All dashboards, summary views, and print-ready reports should update without manual intervention. • No direct tie-in to Salesforce, HubSpot, or Zoho CRM is needed right now, so the files must remain fu...

I have one master text column in an Excel workbook that feeds about twenty-five different language versions spread through the same file. Right now, every language cell is filled by hand, so whenever I adjust the English source text I have to hunt through each translated column and update it manually. What I need is a clean way for any text change I make in that master column to cascade automatically to all of the other language columns. Whether you solve it with formulas, named ranges, Power Query, or a quick VBA macro is up to you—the only requirement is that the result works reliably in the current workbook structure and is easy for me to maintain. Please deliver: • The updated workbook with the automation in place • A brief note (or short Loom video if you prefe...

How to Use in Excel: Create New Workbook: Open a blank Excel workbook. Rename Sheets: Double-click on “Sheet1”, “Sheet2”, “Sheet3”, “Sheet4” at the bottom and rename them to “Instructions”, “Summary”, “Labor Detail”, and “Non-Labor & ODC Detail” respectively. Copy and Paste: For each sheet, copy the entire table (including column headers) from above and paste it starting in cell A1 of the corresponding Excel sheet. Adjust Formulas: Excel should automatically adjust the SUM ranges if you add/remove rows within the defined sections (e.g., adding a new role under “Project Management”). However, always double-check, especially if you add sections outside the initial rows. Fill in Yo...

I’m wrapping up my semester and must submit an Excel assignment built around sales data. The professor expects multiple linked worksheets that work together, with VLOOKUP as the key formula connecting them. I will share the exact prompts, column headings, and any sample numbers right after we start, but here’s the core of what I need: • A clean, realistic sales dataset split across two-or-more sheets—think Orders, Products, or Regions—so VLOOKUP can pull details from one sheet to another. • Correct, error-free VLOOKUP formulas that return the right values no matter how the underlying data changes. • Thoughtful formatting: clear headings, consistent number formats, and basic conditional formatting where it improves readability. • No macros ...

I have several Excel workbooks that need to be brought into shape from the comfort of your own workspace. The job is entirely data-entry focused, but it goes a step beyond simple typing. After you enter the raw figures, I need each sheet formatted neatly—consistent fonts, borders, cell styles, and quick conditional-formatting where it makes sense. Once everything looks clean, you will add basic formulas and functions so the totals, averages, and other simple calculations update automatically. Nothing extremely advanced is required; SUM, AVERAGE, simple IF statements, and similar built-in functions will cover almost everything. Deliverables: • Completed workbooks with every record accurately entered • Clear, professional formatting applied across all sheets • Fo...

I need an Excel expert to create a financial data sheet with automated calculations. Requirements include: - Input financial data like budget forecasting and expense tracking - Automated calculations for budget forecasting and expense tracking - Ability to pull specific values from Sheet 1 to Sheet 2 based on chosen cells Ideal Skills and Experience: - Advanced Excel proficiency - Experience with automated calculations and data manipulation - Attention to detail and accuracy Looking for someone who can deliver a professional and functional Excel sheet tailored to my needs.

My dataset mixes text fields—such as product descriptions and notes—with numerical figures like prices and quantities. I need an Excel file that brings all this information together in a clean, easy-to-use layout. Because no template exists yet, the first step is to design one that fits the data flow and is scalable for future records. Key task: apply cell merging and splitting so headers, sub-categories, and totals line up neatly. Once the structure is in place, paste a short sample of my mixed data into the sheet to show that everything aligns correctly. If you spot ways to improve readability—say, light conditional formatting or basic data-validation prompts—feel free to weave them in as long as they don’t slow down entry. Deliverables: • A reusabl...

My dataset mixes text fields—such as product descriptions and notes—with numerical figures like prices and quantities. I need an Excel file that brings all this information together in a clean, easy-to-use layout. Because no template exists yet, the first step is to design one that fits the data flow and is scalable for future records. Key task: apply cell merging and splitting so headers, sub-categories, and totals line up neatly. Once the structure is in place, paste a short sample of my mixed data into the sheet to show that everything aligns correctly. If you spot ways to improve readability—say, light conditional formatting or basic data-validation prompts—feel free to weave them in as long as they don’t slow down entry. Deliverables: • A reusabl...

I have roughly 100 pages of images and PDFs that contain tables and charts which need to be keyed accurately into a single Excel workbook within five days. Accuracy is paramount, but layout matters just as much. Here is exactly what I’m after: • Every table transferred verbatim, preserving numeric precision and text strings. • Specific column widths and alignments replicated so the sheet mirrors the original layout. • Conditional formatting applied to highlight key values exactly as shown in the source. • Custom headers and footers placed on each worksheet to match the originals. A clean, well-structured file is the end goal—no extra blank rows, no merged-cell surprises. If you prefer OCR to speed things up, that’s fine, but the final sheet...

Canva Sheet to Editable Excel I have an Excel file that was originally put together in Canva and then exported in a non-standard Excel format. It opens, but a lot of the cells are locked in place and I can’t comfortably add new rows, columns, or formulas. What I need is a clean, fully editable .xlsx version that keeps the existing layout yet behaves like a normal desktop Excel workbook. Every cell should be editable, all merged-cell issues removed, and I should be able to insert additional data anywhere without breaking the structure. Feel free to streamline the file behind the scenes—unhide or re-create any hidden sheets Canva may have added—so it functions smoothly in Microsoft Excel for Windows and Mac. Deliverable: one polished .xlsx file ready for day-to-day use,...

I want an Excel workbook that connects to the (public access) and continuously pulls the Nifty 50 option-chain data I specify: the at-the-money strike, plus five strikes out-of-the-money and five strikes in-the-money. For each of those eleven strikes the sheet must capture three fields—Open Interest, Change in Open Interest, and Volume Strike Price—and refresh them automatically every three minutes. Inside the file I need a time-stamped line graph that updates in real time, plotting the same three metrics so I can watch how they evolve through the session without touching the sheet. A single click to start or stop the refresh loop is fine; otherwise the process should run silently in the background. Please build with whichever approach inside Excel you prefer—VBA, Powe...