Macrocomenzi Excel Jobs

Tôi đang tìm một chuyên gia Excel có thể hướng dẫn tôi sử dụng phần mềm thành thạo cho công việc văn phòng hằng ngày. Những gì tôi mong đợi: • Giải thích rõ ràng các hàm và công thức cơ bản đến nâng cao (SUM, IF, VLOOKUP, PivotTable…). • Tư vấn cách định dạng bảng tính, quản lý dữ liệu và trình bày báo cáo chuyên nghiệp. • Cung cấp file ví dụ, bài tập thực hành và đáp án để tôi tự luyện sau mỗi buổi. • Hỗ trợ qua Zoom hoặc Google Meet, có thể chia sẻ màn hình, ghi lại phiên học để tôi xem...

I have a locally stored Excel workbook that contains a financial-data Pivot Table. My goal is to move away from the static worksheet and make the figures available inside Power BI so I can build live dashboards and share them company-wide. Here’s what I need from you: • Take the existing Pivot Table and restructure the underlying data model so it works cleanly in Power BI—preferably in a star schema where possible. • Preserve every measure, calculated field, and filter currently used in the Excel view, translating them to DAX if required. • Deliver a Power BI file (.pbix) that automatically refreshes from the updated Excel source, along with concise documentation outlining the data-refresh steps. Acceptance will be based on side-by-side comparisons confirm...

Excel Developer Needed – Offline Compliance Tracking Workbook Seeking an experienced Excel developer to build a professional offline tracking workbook with a clean user interface and automated reporting features. Workbook Structure The workbook should open to a branded home screen containing: - Company logo - Welcome/home page - Navigation buttons/menu Additional sections/tabs should include: - Dashboard view with totals, summaries, and tracking metrics - Data entry section for managing records - Editable and reusable entries - Dropdown selections from maintained reference lists - Automated calculations and reporting Technical Requirements - Offline/local file storage - Clean and user-friendly design - VBA/macros for automation and navigation - Admin-manageable reference list...

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 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 have several Excel and Google Sheets that together exceed 5,000 rows. The files already contain mixed-quality information and new rows are still arriving, so I need help both entering the incoming data and bringing every column in the existing sheets to a consistent, reliable format. What the job involves • Enter each new record exactly as supplied, keeping existing column order. • Standardise all date, currency, percentage and phone-number fields so every row follows one clear format. • Flag anything clearly inconsistent rather than guessing at a value. You will work directly inside the original Excel workbooks or the shared Google Sheets, whichever is easier for you, but the final delivery must preserve both versions. Basic formulas, filters and conditional forma...

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...