Excel Μακροεντολές Jobs

Need Excel + Power Query Expert for Inventory Dashboard (Pen Drive Based System) Project Overview: I run a manufacturing business and maintain stock in multiple Excel files (7–10 files), each for different categories like motors, inverters, pumps, etc. These files are stored in a folder on a pen drive. I need a simple, reliable system to view consolidated stock in one place without manually opening multiple files. Constraints (VERY IMPORTANT): * All files will remain on a pen drive (no cloud solutions like OneDrive or Google Drive) * Folder path will remain fixed (example: E:Stock_Files) * I will only open ONE master Excel file (no need to open individual files) * System must work offline * Must be simple to use (non-technical staff) Requirements: 1. Use Power Query (“Fr...

I need our simple logistics data-entry workbook turned into a smarter, mostly hands-off tool. Right now staff key information into a single base sheet, then we spend extra time copying, filtering and re-formatting that same data before it can be e-mailed to clients. I want to keep the base sheet as the only place anyone touches the raw figures, but have the rest happen automatically: • Guided data input – drop-downs, look-ups or forms that prevent typos and ensure each required field is filled. • One-click data output – macros or Power Query that transform the base data into clean, customer-ready sheets (PDF or XLSX) and save them to a specified folder, ready to attach to an e-mail. Because all finished files go out as e-mail attachments, the generated sheets mu...

I need a comprehensive financial report spreadsheet created in Microsoft Excel. The spreadsheet will need to handle mixed data types, including numbers, text, and descriptions. There already is a financial model, but it needs to be optimised and also be able to be changed into different currencies. There then need to be a consilidation option needed as well. Key Requirements: - Create a detailed financial report - Use Microsoft Excel - Handle mixed data types - Ensure data accuracy and integrity Ideal Skills and Experience: - Proficiency in Microsoft Excel - Experience with financial reporting - Attention to detail and accuracy - Ability to manage mixed data types Please provide samples of previous financial reports created in Excel.

I need a single Excel workbook that can serve as an issue register for roughly twenty ongoing projects. Each project will sit on its own sheet, and every sheet must let me log: • the date an issue is booked • its target closure date and actual closure date • a status field with the options Open, In Progress, or Resolved • the name of the resource responsible for that issue Across the whole file I want a compact dashboard, shown as summary tables, that rolls everything up in real time. At a glance I should see: • total issues booked • total issues still open • total issues closed / resolved A simple date-range filter is essential so I can instantly list all deliverables that remain open (or moved to Resolved) between any two dates I choos...

I need a single Excel workbook that lets me monitor four different products from the moment they come into stock until they reach my customers each week. The file must show, at a glance, how many units I still have on hand, how many went out this week, and the exact date each order was placed. The only way I want to add customer orders is through a clean, user-friendly form—no typing directly into tables. When I open the form, I should be able to pick the product, enter the quantity requested, choose or type the customer name, and hit submit. As soon as I do that, the workbook should automatically: • deduct the quantity from the correct product’s stock balance • stamp today’s date (or the date I select) as the order date • log the transaction so w...

I have two nearly identical Excel workbooks—each with approximately 300 rows and columns A through AE—that need to be merged into a single, clean master sheet, which is already established. The goal is to streamline our data management by ensuring every record is transferred accurately and all duplicates are eliminated using an automated duplicate-checking tool, rather than manual review. The finished file must reach me by Wednesday, 16 April 2026, midday AET.

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 have a collection of PDF documents whose tables and text need to be transferred accurately into an Excel sheet. At the same time, I also need a set of subtitle files translated from English into clear, natural-sounding French. Here’s what I’m aiming for: • Data from each PDF copied precisely into the matching columns of my provided Excel template, with no omissions or typos. • SRT or VTT subtitle files translated line-by-line, keeping timestamps intact and respecting character limits so the on-screen text reads smoothly in French. • Consistent terminology across both tasks; any unclear phrases flagged for confirmation rather than guessed. I will supply: – The source PDFs – The Excel layout showing required columns – The original Engl...

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

我正在同时推进两项内容，需要一位熟悉办公软件与视频编辑的伙伴协助完成： 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...

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 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 CSV and native Excel files that need to be merged into one clean, well-structured workbook. The source material already sits in digital form, so no manual transcription from scans is required—just careful extraction and organization of the mixed data (both numbers and text). Here’s what I need from you: • Import each CSV/Excel source, preserving every value exactly as it appears. • Standardize column headers and align the datasets into a single master sheet (or a set of logically separated tabs if that proves clearer). • Run quick checks—basic formulas, filters, or conditional formatting—so obvious discrepancies or mis-typed entries surface immediately. • Deliver the final .xlsx file plus a brief note summarizing an...

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

I have the numbers but need them organized into a clear, reliable annual budgeting model in Excel. The file should let me input or update assumptions quickly while flowing those changes through to projected revenues, expenses, and ending cash balances for the full year. Key things I am looking for: • Solid financial-modeling technique—clean, auditable formulas and no circular references. • Logical structure with separate input, calculation, and output sections so anyone can follow the trail. • Summary dashboards and simple charts that highlight the key variances at a glance. • Straightforward cell naming and consistent formatting. Good written English is important because I will be asking questions and may need brief documentation explaining how each sec...

I need a sharp-turnaround assist for my upcoming Business Analytics laboratory exam that is entirely Excel-based. The exam will require me to build the underlying formulas that drive the analysis and then translate the results into a clear line graph, so I want a ready-to-use workbook that I can study and replicate during the test. Here is what I must walk away with: • A single Excel file containing the clean, well-labeled data range. • All core formulas and functions already in place—no array tricks or VBA, just efficient native functions that can be retyped quickly under exam conditions. • A professional-looking line graph that dynamically updates when any value in the data table changes. I will share a sample data set the examiners provided; please use it so I can...

I need an existing PDF invoice template converted into an Excel format for Mac. Requirements: - Must include: - Company logo - Table of items and prices - Payment terms and conditions - Formatting must match the PDF exactly - Automatic calculations are required Ideal skills and experience: - Proficiency in Excel on Mac - Experience with PDF to Excel conversions - Attention to detail to match formatting accurately - Familiarity with setting up automatic calculations in Excel

I need a sharp-turnaround assist for my upcoming Business Analytics laboratory exam that is entirely Excel-based. The exam will require me to build the underlying formulas that drive the analysis and then translate the results into a clear line graph, so I want a ready-to-use workbook that I can study and replicate during the test. Here is what I must walk away with: • A single Excel file containing the clean, well-labeled data range. • All core formulas and functions already in place—no array tricks or VBA, just efficient native functions that can be retyped quickly under exam conditions. • A professional-looking line graph that dynamically updates when any value in the data table changes. I will share a sample data set the examiners provided; please use it so I...

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.

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 an existing PDF invoice template converted into an Excel format for Mac. Requirements: - Must include: - Company logo - Table of items and prices - Payment terms and conditions - Formatting must match the PDF exactly - Automatic calculations are required Ideal skills and experience: - Proficiency in Excel on Mac - Experience with PDF to Excel conversions - Attention to detail to match formatting accurately - Familiarity with setting up automatic calculations in Excel

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

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

I need an automated order book organized by product type. The data should include: - Product details - Order status It should be adaptable to a 4-inch printer in a compact list format. Ideal skills and experience: - Experience with automation tools - Ability to design printer-friendly layouts - Familiarity with order management systems Looking for a clean, efficient solution.