Excel makrók Jobs

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 someone long term to help me and be compensated weekly for filling out 100 contact forms a day and completing to perfection one excel document a day or filling out 200 contact forms a day . All forms require before and after screenshots and initial pay is $5 a week with a $1 a week raise per week until $35 a week is achieved in compensation, must meet all goals, and may take either Saturday or Sunday day off weekly

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.

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 run a hydroponic service company and the bank has asked for a fresh Credit Monitoring Arrangement (CMA) projection. I need a complete one-year model that stands up to lender scrutiny and clearly tells the story of our cash needs and growth path. The work revolves around three core statements—income statement, balance sheet, and cash-flow statement—built month-by-month, tied together, and driven by transparent assumptions. Please build everything in a clean, well-annotated Excel workbook so I can trace every input. Deliverables • Excel file with linked Income Statement, Balance Sheet, and Cash-Flow tabs covering 12 months • Separate assumptions tab showing revenue drivers, cost structure, funding terms, and cap-ex for the hydroponic operations • A brief ...

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 run a chartered-accountancy practice in Basti, Uttar Pradesh and am looking for an ADCA-qualified article assistant who can stay with the firm for up to three years. Your core responsibility will be documentation preparation, specifically drafting and finalising complete sets of financial statements for our clients. On a typical assignment you will pull data from Tally ERP or Excel workbooks, prepare balance sheets, income statements and cash-flow notes, plug supporting schedules into the ICAI-prescribed formats, and export clean, audit-ready PDFs. While client interaction and in-depth analysis remain in-house, I rely on you for speed, accuracy and strict confidentiality. Key tools in daily use include Tally ERP, advanced Excel (pivot tables, lookups, macros), Word and basic GST/MCA po...

I need a clear, investor-focused KPI dashboard built in Excel that lets me monitor the health of a property portfolio at a glance. The workbook should automatically pull or accept monthly figures, then present each metric side-by-side in both clean tables and intuitive charts so investors can drill down or get a quick snapshot during meetings. Core KPIs to visualise • Occupancy rate • Rental income • Maintenance costs • Planned-preventive maintenance (PPM) status • Lease expiry timeline • New lease count • Tenant satisfaction score • Budget vs. actual spend • Cost variance • Utility cost trends • Average rent per sqm What I expect – One Excel file with an easy “Data” sheet for raw inputs and se...

I need text copied from several digital Excel sheets into one clean, consolidated workbook. Every cell must match the source exactly, including capitalization, spacing, and line breaks. What you’ll do: • Open each supplied Excel file. • Transfer all text data into the designated master sheet, keeping original column order. • Run a quick spell-check and flag any gaps or unclear entries for my review. Deliverable: a single Excel file containing the fully merged and verified text dataset. Please let me know how soon you can start and your typical turnaround time for similar projects. Accuracy and attention to detail are essential; if you’re comfortable with Excel functions, filters, and basic data validation, this will be a straightforward task.