Macros de Excel Jobs

Tengo un cronograma de cursos CAP para mi autoescuela que ahora mismo completo a mano módulo a módulo. Quiero convertirlo en una plantilla de Excel donde solo indique: • la fecha de inicio del curso • los horarios diarios (p. ej. lunes-viernes 18:00-22:00) y el archivo calcule de forma automática las fechas de inicio y fin de cada módulo. Trabajo solicitado 1. Crear o adaptar una hoja de cálculo en Excel (no Google Sheets ni Calc) con las fórmulas o, si hace falta, una macro/VBA sencilla que: – distribuya las horas lectivas respetando los horarios indicados; – genere de inmediato la columna “Inicio módulo” y “Fin módulo” para todo el temario. 2. Dejar todo parametrizable par...

I have a set of printed documents that must be keyed into an Excel spreadsheet exactly as shown on the page. Everything will be entered manually—no OCR or automated scraping—so attention to detail is critical. You will receive high-resolution scans of the pages along with a template Excel file that already contains the required headers. Simply fill each column row-by-row, matching numbers, names, dates, and any special characters exactly as they appear in the originals. Deliverable • Completed Excel workbook with all records transcribed and internally checked for consistency (totals should match the printed source where applicable). Acceptance criteria • 100 % of the pages entered. • Error rate under 0.2 % (I will spot-check random samples). &bul...

I have several raw workbooks that mix financial, sales and customer figures, and I need them transformed into reliable, presentation-ready outputs. The first step is a thorough data clean-up: removing duplicates, repairing missing or partial entries, and giving every column consistent, professional formatting. Once the data is solid, I want dynamic pivot tables and charts that highlight the key trends I’ll be discussing with stakeholders. Finally, I need a clear profit-and-loss statement prepared from the cleaned data that I can drop straight into a report. Deliverables: • A cleaned, fully formatted Excel sheet (no duplicates, no blank anomalies) • Interactive pivot tables and matching pivot charts for quick drill-downs • A profit-and-loss statement pulling fr...

Potrzebuję kogoś kto odnajdzie wszystkie id porduktów z przypisane do danego produktu. Allegro prowadzi produktyzacje, do produktu są wystawiane oferty. Problem w tym, że w produktyzacji allegro często występuje ten sam produkt jaki kilka produktów na allegro. Np dla produktu: ID produktu allegro to: 1137e723-aadd-43d6-94be-87e9b3c4a495 Czyli Po przejsciu na powyższy link automatycznie wyświetla się najtańsza oferta. Ten sam produkt jest również pod: Czyli ID 455f3437-295c-47b0-b290-60a1aeee8b8e Dla tego samego produktu w allegro może być kilka ID. Zadanie polega na tym, że podam ID mojich produktów na allegro, pod które podczepiona jest moja oferta. Np. Mam około 800 takich linków z różnymi ID. Bedzie to plik excel. Zadani...

I need help transferring a collection of mixed data—some text, some numbers—into organised Excel spreadsheets. The finished workbook should be cleanly formatted, with each value placed in the correct column and all totals or calculations preserved exactly as they appear in the originals. Accuracy is my top priority, so I’ll be double-checking cell references, data types, and any formulas you include. Once you receive the files, please: • enter every record without omissions or typos • keep the layout consistent across all sheets • highlight any ambiguous or unreadable entries so I can clarify them quickly A neatly structured .xlsx file delivered on time will mark the job complete. Let me know your estimated turnaround and any questions you have before...

I need an Excel workbook that converts raw revenue and expense figures into polished, ready-to-share financial reports. The focus is purely on creating reports, not broader analysis or heavy automation, but I still want smart use of formulas, PivotTables, and dynamic charts so the layout updates itself as new data is pasted in. My source files arrive monthly in CSV format. Once the data is dropped into a “Raw Data” sheet, the workbook should instantly populate: • A clean revenue-versus-expense summary • Month-over-month variance visuals (line or column chart) • A printable report page formatted for A4, with my logo placeholder at the top Key points for acceptance: • All calculations must recalculate without manual refresh beyond standard Excel recalc (no e...

I’m looking for a detail-oriented accounting professional who can take full ownership of two core areas: Data entry and bookkeeping, and Invoice preparation and accounts management. All of my records live in MS Excel, so you’ll need to be comfortable working inside formulas, pivot tables, and well-structured worksheets rather than a cloud platform like QuickBooks or Xero. Here’s what I’m expecting week to week: • Enter every transaction promptly so the ledgers stay current and tidy. • Keep my invoices flowing—prepare, send, log payments, and flag anything overdue. • Maintain clear ageing summaries so I can see receivables and payables at a glance. Accuracy is critical, but so is timeliness; I rely on these files to make cash-flow decisions...

I need a clean, easy-to-use Excel workbook that lets our pantry volunteers log each client’s visit and, at a glance, see how often people are coming, which ZIP or area codes we are serving most, and a running count of the demographics we report to our partners. Core data to capture • Client name or household ID • Area/ZIP code • Visit date (each time they come) – the sheet should automatically tally total visits per client • Demographic check-boxes: Adults, Children, Seniors, Veterans, Disabled What will make the file helpful 1. A front-end “Visits” sheet where staff enter one row per visit. 2. A hidden or protected look-up table that turns those rows into a summarized “Dashboard” showing: – Total househol...

I'm seeking an Excel macro developer to create a macro for Excel 2016 or later. The primary task will involve data sorting and filtering. Key Requirements: - Expertise in Excel macro development - Proficiency in Excel 2016 or later - Experience with data sorting and filtering operations Ideal Skills: - Strong knowledge of VBA (Visual Basic for Applications) - Previous experience in automating Excel tasks - Attention to detail and problem-solving skills Please provide examples of similar work done. Looking forward to your proposals!

I’m setting up a clear, easy-to-maintain Excel file dedicated to inventory management. The sheet needs to hold three core data blocks—product names and descriptions, current stock levels, and supplier information—while staying simple enough for me to update manually. Here’s what I have in mind: a clean dashboard-style front page that shows total SKUs, low-stock alerts, and quick filters, backed by structured tables where I can add or edit items without breaking formulas. Built-in data-validation lists, conditional-formatting warnings, and a few helpful pivot-table summaries will keep everything organised and instantly readable. Deliverable • An unlocked .xlsx template with the layouts, formulas, and formatting fully tested. • Brief instructions insid...

Нужен опытный специалист для индивидуальных занятий по Excel. Мой уровень — начальный, поэтому ценю понятные объяснения и терпение. Хочу разбирать реальные задачи и получать практическую помощь именно по формулам, функциям и приёмам анализа данных (сводные таблицы, фильтры, условное форматирование и похожие инструменты). Планирую проводить онлайн-сессии 1–2 раза в неделю. Удобнее всего обсуждать расписание и задавать короткие вопросы через [Removed by Freelancer.com]. Первую встречу готов посвятить обзору моих задач и согласованию дальнейшего плана. Жду откликов от репетиторов, которые: • умеют обучать с нуля и приводить практические примеры; • имеют подтверждённый опыт работы с формулами и анализом данных; • могут гибко подстраиваться под формат «помощь ...

I need an Excel workbook that converts raw revenue and expense figures into polished, ready-to-share financial reports. The focus is purely on creating reports, not broader analysis or heavy automation, but I still want smart use of formulas, PivotTables, and dynamic charts so the layout updates itself as new data is pasted in. My source files arrive monthly in CSV format. Once the data is dropped into a “Raw Data” sheet, the workbook should instantly populate: • A clean revenue-versus-expense summary • Month-over-month variance visuals (line or column chart) • A printable report page formatted for A4, with my logo placeholder at the top Key points for acceptance: • All calculations must recalculate without manual refresh beyond standard Excel recalc (no e...

I need a clean, user-friendly Excel workbook built specifically for payroll management. The core requirement is an interface where I can type in each employee’s hours worked and instantly see accurate pay figures. Everything will be keyed in manually, so error-proof data-entry fields, drop-downs, and clear validation messages are essential. Structure & Functionality • A master employee sheet holding names, IDs, pay rates, and status (active/inactive). • A timesheet where I enter daily or weekly hours; the sheet should automatically total regular and overtime hours. • A payroll summary that pulls those hours, multiplies by the stored pay rates, and shows subtotals such as regular pay, overtime pay, and a grand total for the pay period. • Built-in formu...

I need a 30-day habit-tracking workbook created completely from scratch in Microsoft Excel. The file must carry a classic, simple aesthetic—clean grids, restrained colours, no distracting graphics—yet still feel polished enough for resale under my own brand, so please avoid all third-party or premade templates. Core logic and layout • Month selector (drop-down) that instantly updates all date labels. • Daily tracking for productivity habits with either tick-boxes or a Yes/No drop-down in every cell. • Automatic percentage calculation of days completed. • Circular progress chart that refreshes in real time. • Streak counter that recognises uninterrupted runs. • At-a-glance dashboard summarising the month’s totals and longest strea...

I need help with my VBA macros in Excel. They work fine when the Excel file is in its original folder, but they fail when I move the file to a different folder or another computer. Requirements: - Fix macros that are executed through a custom ribbon button. - Ensure macros work regardless of file location. - Determine if relative or absolute paths are needed and implement accordingly. Ideal skills and experience: - Expertise in VBA and Excel. - Experience with custom ribbons in Excel. - Ability to troubleshoot and fix path-related issues. Please provide a solution that ensures the macros work seamlessly after moving the file.

I need help with my VBA macros in Excel. They work fine when the Excel file is in its original folder, but they fail when I move the file to a different folder or another computer. Requirements: - Fix macros that are executed through a custom ribbon button. - Ensure macros work regardless of file location. - Determine if relative or absolute paths are needed and implement accordingly. Ideal skills and experience: - Expertise in VBA and Excel. - Experience with custom ribbons in Excel. - Ability to troubleshoot and fix path-related issues. Please provide a solution that ensures the macros work seamlessly after moving the file.

I have a collection of text-based information that needs to be gathered from specific online sources and transferred accurately into an Excel spreadsheet. The task is straightforward: locate the required text on the sites I will provide, copy it without altering any wording, and paste it into the corresponding columns of the sheet I share with you. Consistency matters more than speed. Every row in Excel must be free of typos, follow the header structure I supply, and retain all punctuation and line breaks exactly as they appear online. I will give you a short set of instructions and a sample row so you can mirror the format from the start. Deliverable: a fully populated Excel file, double-checked for completeness and perfect text fidelity.

I need an execl spreadsheet wizard that can combine multiple independent estimates of multiple types of contracts ( with multiple years and the job description with amounts of people) into one large spreadsheet spread out over a ten year with a summary page. To handle multiple contract types, headcounts, job descriptions, and a ten-year timeline without creating an unmanageable mess, we must separate your data into three distinct layers: Data Inputs, the Calculation Engine, and the Executive is the blueprint for your master spreadsheet. 1. The Core Architecture[Input Sheets] ---------> [Master Calculation Sheet] ---------> [Dashboard / Summary] - Contract Type A - Combines all inputs - 10-Year Financial Chart - Contract Type B - Standardizes timeline...

I need an Advanced Excel specialist to turn raw campaign data into an interactive retention dashboard that spotlights performance metrics—specifically conversion rates. My files already contain the necessary transactional and engagement logs; what I’m missing is a clean, automated way to track how each cohort converts over time and to surface insights I can act on immediately. Here’s what the finished work should let me do: • Open one workbook and, through slicers or drop-downs, filter by channel, segment, or date range to see real-time conversion performance. • Compare current conversion rates against historical benchmarks, with clear visual cues when a metric slips or surpasses target. • Drill down from a summary view to individual campaign detail...

I’m putting together a three-hour Excel workshop for an Information Technology team of roughly 15–20 people and I need a complete training package that hits both basic and intermediate skills. The focus is on practical ability, so every concept has to be reinforced with hands-on activities. Content scope • Core formulas and functions we rely on every day • Efficient data analysis using pivot tables and related tools Session assets • A clear, well-structured PowerPoint deck that can carry the whole three-hour class • Live demo files and datasets my team can manipulate during each exercise • Step-by-step facilitator notes so the flow is easy to follow and timing stays on target Digital handbook I also want a concise, searchable PDF/OneN...