Visual Basic Jobs

I run compliance for a busy haulage company and need a single Excel workbook that keeps me ahead of every statutory obligation. The sheet must revolve around our WEEKLY TARGETS: when each licence, CPC refresher, driver medical or maintenance inspection is due, what percentage of the fleet is still outstanding, and whether we are on-track for the week. Here’s what I picture: the moment any target slips inside its warning window the cell turns amber; miss the deadline and it flips to red. At the same time an automatic email should leave Outlook so the relevant manager is warned without me lifting a finger. Formulas must update themselves from simple data entry (dates, counts, kilometres, etc.), calculate the remaining days and the KPI percentages, and feed a quick-view dashboard so I ...

I need a custom options screener that will quickly surface the best trade opportunities across both call and put contracts. The primary goal is simple: filter live market data so I can spot setups worth acting on, without wading through every strike and expiration by hand. Here is what I have in mind: • Pull current option chains for my chosen tickers (US equities to start). • Apply configurable filters—strike proximity, days-to-expiration, volume/open-interest thresholds, implied volatility, or any other smart metric you suggest—to highlight trades with an attractive risk-reward profile. • Present the shortlisted trades in an intuitive table or dashboard, sortable by key statistics and linked back to the underlying chart. I am flexible on the tech stack; P...

A set of blank online application forms need to be completed quickly and with perfect accuracy. I will supply all of the source information in an easy-to-read spreadsheet along with clear field-by-field instructions. Your responsibility is simply to copy the data and submit each form, double-checking every entry before you hit “send.” Accuracy matters more than speed, yet I still need a prompt turnaround, so plan to keep me updated on progress at agreed checkpoints. Screenshots or a brief completion log for each batch will be enough to confirm submission. Deliverables • All application forms submitted online and confirmed as accepted • A completion log (spreadsheet or PDF) showing date and time of each submission and any notes on issues encountered Experience...

I need a detailed spreadsheet to track employee training. The spreadsheet should handle the following: - Training Completion Status - As detailed in the email I will send - Automatic date renewal and frequency Ideal Skills: - Proficiency in spreadsheet software (Excel, Google Sheets) - Experience in creating automated tracking systems - Attention to detail and accuracy am also interested in a quote please for our training matrix for employees. What we do with this is we add in the training, there is a rag rating and a frequency set at the top which I needs changing to that it goes red when its expired, orange within 3 months and green until that point regardless of the frequency set, leave the frequency as this is an important part, we also want an option of NFA and N/A for people wh...

I need purpose-built Excel files that handle two day-to-day bookkeeping areas—Accounts Payable/Receivable and Payroll management—and then roll everything up into clean, ready-to-share financial reports. Here is what I want to walk away with: • A dynamic AP/AR workbook that lets me record invoices, tag payments, and instantly show outstanding balances. • A payroll tracker that calculates gross-to-net, accrues benefits, and updates year-to-date figures automatically. • A consolidated reporting sheet (or dashboard) that pulls data from both workbooks and produces the standard financial statements I rely on. I work almost exclusively in Excel, so strong command of formulas, pivot tables, lookups, and—where it speeds things up—macros or Power Q...

I need purpose-built Excel files that handle two day-to-day bookkeeping areas—Accounts Payable/Receivable and Payroll management—and then roll everything up into clean, ready-to-share financial reports. Here is what I want to walk away with: • A dynamic AP/AR workbook that lets me record invoices, tag payments, and instantly show outstanding balances. • A payroll tracker that calculates gross-to-net, accrues benefits, and updates year-to-date figures automatically. • A consolidated reporting sheet (or dashboard) that pulls data from both workbooks and produces the standard financial statements I rely on. I work almost exclusively in Excel, so strong command of formulas, pivot tables, lookups, and—where it speeds things up—macros or Power Q...

I’m a contractor who receives every work order as a text-based PDF. From each of these orders I have to issue three things on my own branded paperwork: a GST invoice, a completion certificate and a matching Excel summary sheet. I already have polished Word and Excel templates for all of them, so the visual layout is locked in. What I need is a small Windows-friendly .exe that lets me drop in a work-order PDF, automatically pulls out the key text (job number, client name, dates, amounts, GST, etc.) and shows the captured fields on screen. I’ll review or tweak anything that couldn’t be read and then hit “Generate”. The program should merge the confirmed data straight into my templates and instantly give me: • a finished DOCX invoice • a completed D...

My existing VB.NET project is behaving unpredictably: it sometimes crashes on startup and, even after it loads, other crashes appear at random. I need these bugs isolated and fixed so the application runs reliably every time it is launched and during normal use. You will receive the full Visual Studio solution and a short video showing the crashes in action. I have not added any custom logging yet, so incorporating meaningful exception handling or a lightweight logging mechanism is welcome if it helps trace the faults quickly. Deliverables • Corrected source code with clear comments on the changes • A brief summary explaining what caused each crash and how you resolved it • Simple reproducibility steps that confirm the issues no longer occur Please use standard VB...

hello, I need to create a solution in Excel that I would use to print school certificates... on the first Excel sheet I would enter general information about the school, teacher's name, number of students and class and by pressing the "generate" button it would open a new Excel sheet in which I would create a table overview of all subjects and calculate average grades... the data entered on the second sheet should be used on the third sheet to print the certificate. I would like to submit an outdated proposal of how it would look and how we used to use the certificate form on which the data should be printed More details: What kind of overview do you need on the second sheet? Grades and attendance What format do you prefer for the certificate on the third sheet? Custom te...

I have a series of projects that span Word, Excel, and PowerPoint, all requiring an advanced touch. In Word, I need complex documents cleaned up and formatted so headings update automatically, cross-references never break, and tables of contents look publication-ready. Expect to work with long manuscripts that already contain tracked changes and a variety of embedded objects. For Excel, the focus is data analysis and reporting. Raw CSV files must be transformed into dynamic dashboards: pivot tables connected to slicers, clear charts driven by named ranges, and formulas or Power Query steps that remain transparent for future updates. Attention to data integrity and reproducibility is essential; VBA or Office Scripts are welcome where they add real value. Finally, I want visually engaging...

Develop a VBA Macro Automation Script that can process and search through multiple folders and subfolders containing 100+ Excel files across different brands. The script should automatically read all Excel files from all specified directories and ensure that no file is skipped during processing. The objective is to compare the IMEI values from a target Excel file against the IMEI records available in all source files. For each matching IMEI, the script should: Search all Excel files within all folders and subfolders. Match the IMEI number with the target file. Verify that a valid Sell Out Date exists for the matched IMEI. If both conditions are satisfied (IMEI matched and Sell Out Date found), automatically populate the corresponding Sell Out Date and Purchase Price with GST in the desig...

I have several Excel sheets that hold both text and numbers and I need every record transferred, by hand, into a master template I will provide. Accuracy is critical—no copy-paste macros or automated scraping—just careful manual input so the final file mirrors the source exactly, including formatting such as date and currency styles. You’ll receive: • A folder of the original Excel workbooks • My blank master template and a short set of field-by-field notes Your task is simply to work through each sheet, key in the corresponding values, and double-check totals or formulas so nothing is lost in translation. When you return the completed template I will run a spot check; if everything aligns, the job is done. Familiarity with Excel’s basic func...

I have several Excel sheets that hold both text and numbers and I need every record transferred, by hand, into a master template I will provide. Accuracy is critical—no copy-paste macros or automated scraping—just careful manual input so the final file mirrors the source exactly, including formatting such as date and currency styles. You’ll receive: • A folder of the original Excel workbooks • My blank master template and a short set of field-by-field notes Your task is simply to work through each sheet, key in the corresponding values, and double-check totals or formulas so nothing is lost in translation. When you return the completed template I will run a spot check; if everything aligns, the job is done. Familiarity with Excel’s basic func...

I have a raw sales dataset that needs to go from messy spreadsheets to an insight-rich, client-ready dashboard. First, I want the data cleaned and structured in Excel—think advanced formulas, Pivot Tables, and error checks—so every field feeds smoothly into Power BI. Once the foundations are solid, the core of the job is building an interactive dashboard in Power BI. It must spotlight the metrics that matter most to me: sales by region, sales by product category, monthly sales trends, profit margins, year-over-year growth, and customer acquisition cost. I picture a mix of bar charts, pie charts, and line graphs, complemented by KPI cards for quick reference and slicers that let users filter results on the fly. Good communication is important; I need to understand not just...

I have a series of projects that span Word, Excel, and PowerPoint, all requiring an advanced touch. In Word, I need complex documents cleaned up and formatted so headings update automatically, cross-references never break, and tables of contents look publication-ready. Expect to work with long manuscripts that already contain tracked changes and a variety of embedded objects. For Excel, the focus is data analysis and reporting. Raw CSV files must be transformed into dynamic dashboards: pivot tables connected to slicers, clear charts driven by named ranges, and formulas or Power Query steps that remain transparent for future updates. Attention to data integrity and reproducibility is essential; VBA or Office Scripts are welcome where they add real value. Finally, I want visually engaging...

The workbook I rely on daily contains an existing VBA macro that should handle several automation steps for me, yet its current logic is off and the tasks don’t complete in the right order—or sometimes not at all. I need a developer who can step through the code, identify exactly where the flow breaks down, and rewrite those sections so the automation runs reliably every time the file is opened or the button is clicked. Here’s what I expect once the job is done: • The macro executes its full task sequence without manual intervention or unexpected stops. • Any loops, conditional branches, and object references are cleaned up so they’re easy to maintain. • I receive the updated workbook plus a brief changelog (commented in-line or a separate note...

I need a single Excel workbook that lets me enter raw sales data and instantly turns it into professional-looking bills. The sheet must pull every essential detail into the final print-ready invoice: • Customer information: name, full contact details, address, and account number • An itemised list of products or services with quantities, rates, and line totals • Clearly shown payment terms, plus auto-calculated subtotals, tax, discounts, and grand total Date handling is important—each invoice should grab the sale date, stamp a configurable due date, and feed those dates into a running tally so I can track what’s outstanding. A summary page that aggregates totals by day, week, and month will help me reconcile figures quickly. Please build the logic with s...

hello, I need to create a solution in Excel that I would use to print school certificates... on the first Excel sheet I would enter general information about the school, teacher's name, number of students and class and by pressing the "generate" button it would open a new Excel sheet in which I would create a table overview of all subjects and calculate average grades... the data entered on the second sheet should be used on the third sheet to print the certificate. I would like to submit an outdated proposal of how it would look and how we used to use the certificate form on which the data should be printed More details: What kind of overview do you need on the second sheet? Grades and attendance What format do you prefer for the certificate on the third sheet? Custom te...

I have several high-volume financial datasets that need a careful eye before they can be trusted for decision-making. Your first task will be to tidy up the raw files—spot and resolve inconsistencies, fill the inevitable gaps, and confirm every figure lines up across worksheets. Once the data is clean, I’ll lean on you to turn it into clear, executive-ready reports. Think dynamic Excel dashboards, concise tables, and visual summaries that highlight key performance metrics without drowning the reader in numbers. While the whole workflow—from organising and validating through to analysis—matters to me, the reporting stage is where I need the most help right now. If you have a knack for transforming rows of figures into insights people can actually use, you’ll b...

I have several high-volume financial datasets that need a careful eye before they can be trusted for decision-making. Your first task will be to tidy up the raw files—spot and resolve inconsistencies, fill the inevitable gaps, and confirm every figure lines up across worksheets. Once the data is clean, I’ll lean on you to turn it into clear, executive-ready reports. Think dynamic Excel dashboards, concise tables, and visual summaries that highlight key performance metrics without drowning the reader in numbers. While the whole workflow—from organising and validating through to analysis—matters to me, the reporting stage is where I need the most help right now. If you have a knack for transforming rows of figures into insights people can actually use, you’ll b...

I’m a contractor who receives every work order as a text-based PDF. From each of these orders I have to issue three things on my own branded paperwork: a GST invoice, a completion certificate and a matching Excel summary sheet. I already have polished Word and Excel templates for all of them, so the visual layout is locked in. What I need is a small Windows-friendly .exe that lets me drop in a work-order PDF, automatically pulls out the key text (job number, client name, dates, amounts, GST, etc.) and shows the captured fields on screen. I’ll review or tweak anything that couldn’t be read and then hit “Generate”. The program should merge the confirmed data straight into my templates and instantly give me: • a finished DOCX invoice • a completed D...

I’ll send you an updated Excel workbook that contains several sheets. Your job is simple but must be done precisely: • Ensure every sheet keeps the exact column order, data types, and overall look we used in week 21—no unexpected formatting changes. • If anything was added across sheets, merge all columns so the structure stays identical throughout the workbook. • Upload the finished file to the designated SharePoint folder, replacing the prior week’s version. • Confirm the dataset still refreshes in Power BI without errors (no deep modelling required, just a quick check). Because the source is spread over multiple sheets and the downstream report relies on consistent formatting, strong Excel skills—tables, Power Query, data validation&md...

A batch of raw information—numbers and text pulled from Word files, PDFs and online tables—has to be copied into one clean Excel workbook and then polished for consistency. The work centres on accurate copy-paste, deduplication and applying a uniform style across every column: text case, date and currency formats, cell alignment, conditional formatting where helpful, plus basic error checks so the sheet is ready for immediate import into our database. Successful completion means: • every source value transferred without loss or typo • columns correctly typed (no text masquerading as numbers, no stray spaces) • neat, readable layout with filters and freeze panes already set The data volume is moderate but mixed; speed matters, yet precision comes first. I ...

I need a reusable Power BI template (.pbit) that connects seamlessly to one or more Excel workbooks. The idea is that I can point the template at any new Excel file that follows the same column structure and have the visuals and measures update automatically. Scope of work • Deliverables – A polished .pbit template file – A short read-me (PDF or markdown) outlining required Excel structure and refresh steps I’m aiming for a solution that business users can adopt immediately, so usability and clean design matter as much as the underlying DAX. Let me know your experience with Power Query, DAX, and similar template projects, and include a brief outline of your proposed approach and timeline.

I need a complete workflow that starts with a clean, well-structured Excel Bill of Materials and ends with that same BOM living accurately inside our Siemens Teamcenter instance. Here is the flow I have in mind: • Build an Excel template that carries our company branding in the header and footer. All columns must follow the layout we already use internally, so I can hand the sheet to any engineer and have them recognise it instantly. • Populate the template with a representative “company BOM” so we can prove the import routine. • Import or map that sheet into Teamcenter, creating the BOM exactly as it appears in Excel—same hierarchy, item numbers, revisions, and descriptive fields. • Demonstrate the result in Teamcenter to confirm every part an...

I have several high-volume financial datasets that need a careful eye before they can be trusted for decision-making. Your first task will be to tidy up the raw files—spot and resolve inconsistencies, fill the inevitable gaps, and confirm every figure lines up across worksheets. Once the data is clean, I’ll lean on you to turn it into clear, executive-ready reports. Think dynamic Excel dashboards, concise tables, and visual summaries that highlight key performance metrics without drowning the reader in numbers. While the whole workflow—from organising and validating through to analysis—matters to me, the reporting stage is where I need the most help right now. If you have a knack for transforming rows of figures into insights people can actually use, you’ll b...

I need an Excel sheet with multiple tabs to manage student information for school districts. Each tab should be dedicated to a different district, and within each tab, I want sub-tabs for organizing student data. Requirements: - Each main tab represents a different school district - Sub-tabs within each district for organizing student data broke down by schools - Data to track: Personal details (name, dob school name school address ID # Need the sheet built Ideal Skills and Experience: - Proficiency in Excel, including advanced functions and tab management - Experience with data organization and management in spreadsheets - Attention to detail and accuracy in data entry Please provide samples of similar Excel projects.

I’m building a new budgeting framework and need a clear, reliable model that projects our sales revenue quarter by quarter. The core focus is a dynamic budgeting model—nothing fancy on valuation or long-range strategy—just an accurate, easy-to-update tool that shows how revenue is likely to unfold through each quarter. Here’s what I’m looking for: • A clean, well-structured spreadsheet in Excel or Google Sheets, built with transparent formulas that any analyst can follow. • Dedicated input tabs for key drivers (price, volume, channel mix, seasonality). • Automatic quarterly roll-ups that flow into an income-style summary and visual dashboards. • Simple scenario toggles so I can test best, base, and downside cases without breaking the...

I need assistance in building complex data models using Power Query, Power Pivot, and VBA. The data will be sourced from multiple CSV files. Key Requirements: - Integrate and transform data from multiple CSV files - Build complex, efficient data models - Review and optimize existing VBA scripts - Provide an initial consultation to review the current workbook, explain and demonstrate encountered issues, and discuss recommendations before implementation Ideal Skills and Experience: - Proficiency in Power Query, Power Pivot, and VBA - Experience with CSV data manipulation - Strong data modeling skills

I need one of my existing Excel workbooks cleaned up so it’s clear, consistent, and presentation-ready. This involves applying a cohesive layout, organizing columns and rows logically, and setting up styles that make the data easy to read at a glance. If you see opportunities for conditional formatting, data-validation drop-downs, or smarter formulas that improve accuracy, feel free to suggest and implement them—I’m open to best-practice improvements. The final file should open without any warnings, print neatly on standard paper sizes, and be fully compatible with the latest desktop and Microsoft 365 versions of Excel. Once the finished workbook looks polished and functions smoothly, please walk me through the key changes so I can maintain it going forward.

I have a backlog of financial records that need to be brought into a logical, easy-to-navigate structure. The job is strictly data categorization: no data scraping or entry from paper forms—everything is already in digital tables. What I need: • Sort and tag each record so that I can quickly filter transactions by purchase history. • Apply the same purchase-history logic to a small related set of customer data to keep both datasets aligned. • Return clean, well-formatted spreadsheets (Excel or Google Sheets) with clear headings and consistent category labels. Accuracy and attention to detail are crucial; any misfiled entry could throw off downstream reporting. If you are comfortable working with large rows of financial data, know your way around pivot tables and simp...

I need a reliable pair of hands to keep my customer information up-to-date on a rolling basis. Every week I will send you fresh Excel spreadsheets that contain new sign-ups, profile changes, and the occasional duplicate record. Your job is to: • Review each sheet for accuracy, spotting and fixing obvious typos or formatting issues. • Enter the clean data into our cloud CRM (it’s a simple web form; I’ll provide login and a short video walkthrough). • Flag incomplete or suspicious entries in a separate tab so I can follow up with the customer directly. Turnaround is two business days after each upload, and consistency is more important to me than speed bursts—I want the information to look the same month after month. Familiarity with Excel functions s...

I’m a contractor who receives every work order as a text-based PDF. From each of these orders I have to issue three things on my own branded paperwork: a GST invoice, a completion certificate and a matching Excel summary sheet. I already have polished Word and Excel templates for all of them, so the visual layout is locked in. What I need is a small Windows-friendly .exe that lets me drop in a work-order PDF, automatically pulls out the key text (job number, client name, dates, amounts, GST, etc.) and shows the captured fields on screen. I’ll review or tweak anything that couldn’t be read and then hit “Generate”. The program should merge the confirmed data straight into my templates and instantly give me: • a finished DOCX invoice • a completed D...

I have created a simple FileMaker database that functions as a CRM. The goal is to send personalized emails using pre-defined templates (with placeholders like [LastName], [JobTitle], etc.) to my contacts via Gmail's SMTP server. Here's the problem: When sending emails, the email body and subject aren't displaying correctly. I need help: - Fixing these issues so the subject and body display properly. - Creating or fine-tuning a system where I can select email templates easily, populate them with contact details, and send them smoothly to my recipients. - Providing an example template with fields and an HTML-formatted email for demonstration. Only experienced professionals in FileMaker and email template setup should reach out.

I have several spreadsheets that are ready for a final pass of data validation. The sole focus is accuracy and consistency across every row and column—no scraping or fresh data entry is required. You will receive the original Excel files along with a short set of business-logic rules. Please work through each sheet, use the validation tools you prefer (Excel filters, conditional formatting, VLOOKUP/XLOOKUP, Google Sheets equivalents, etc.), correct any straightforward errors, and flag anything unclear so I can make the final call. Deliverables • The same spreadsheets returned, fully validated and saved in their original format • A concise log or extra tab listing all changes made plus any questions that still need my review Acceptance criteria • 100 % of f...

I have a batch of raw financial figures that needs to be transferred accurately into a clean, well-structured Excel workbook. The task is strictly spreadsheet entry—no online forms or database tools involved—so you should be comfortable working with Excel’s formatting, formulas for basic checks, and data validation features to minimise errors. The source material is ready to go and I’d like the finished file back as soon as possible. Speed matters, but accuracy is even more important: totals must reconcile, columns must align with my template, and there should be zero typos in account numbers or currency values. Deliverables: • Completed Excel file following my template • Quick note summarising any discrepancies you spotted and corrected If you can st...

I have a spreadsheet containing records for roughly 500 clients and I want to turn it into a set of clear, visually engaging dashboards. Before we jump into design, the data will need a light cleanse and the right filters so that every chart responds instantly. Visual style – The core of the build should rely on Charts and graphs for quick comparisons, complemented by Interactive maps so I can see how results vary by location at a glance. Primary insight – I’m focused on Customer demographics, with Income Level as the key slice. Other demographic details are available, but income-based breakdowns must be front and centre in every view. Preferred approach You are free to work in Tableau, Power BI, Looker Studio or another modern BI tool, as long as the final dashb...

I need an Excel date sheet to generate reports on employee performance metrics, specifically tracking material costs. Requirements: - Generate reports on employee performance - Track specific metrics, including material costs Ideal Skills and Experience: - Expertise in Excel, especially in creating dynamic reports - Strong analytical skills to ensure accurate data representation - Experience in handling employee performance data

I rely on several Excel files every day and am wasting too much time repeating the same clicks. I need five straightforward VBA macros that will remove that manual effort: • A VLOOKUP-style routine that pulls matching data from a reference sheet or workbook without breaking when new rows are added. • A file-consolidation macro that opens every workbook in a chosen folder, copies the required ranges, and stacks them neatly on a master sheet. • A data-validation checker that highlights blanks, improper dates, or values outside set limits and produces a quick summary of the issues. • Two additional “quality-of-life” helpers of the same level of complexity (for example quick formatting or a clean-up of duplicates) so that the final count is five macros in...

Hello, I have a list of details, using those you need to collect a lot of data from a specific website. I will show you how to scrape the details like Name, Email, and Phone numbers, you just need to follow the pattern..

Not so much of a project, but a relatively simple task for an experienced Microsoft Word geek. I have two Microsoft files. v1 was created and saved after 5mins in April this year. Unfortunately, it does not contain some final drafting that was lost when I clicked the wrong button at the time. v2 of the document is a simple cut-n-paste of the original with corrected 2nd bullet (highlighted) My Ask/Request Update to the original v1 document with the 2nd bullet replaced with (v2 Bullet 2) without changing the original Properties. OR the v2 document (as is, no change to document content) but showing the original document properties (last modified & created) see attached Word file called Document Properties. The final Word document - whichever approach (above) is taken needs to have h...

Saya membutuhkan bantuan untuk menyusun model anggaran dari kumpulan data keuangan perusahaan kami menggunakan Microsoft Excel. Fokus utamanya adalah: • Membersihkan dan merapikan data transaksi yang sudah ada. • Mengelompokkan pos pemasukan dan pengeluaran secara logis. • Membangun template anggaran tahunan/bulanan berikut ringkasan varians. • Menambahkan grafik sederhana guna memvisualisasikan proporsi biaya dan tren saldo. • Memberi penjelasan singkat di tiap sheet agar tim akuntansi kami mudah memutakhirkan angka di kemudian hari. Data mentah akan saya kirim dalam format .xlsx; semua pengolahan wajib tetap di Excel (tanpa VBA atau makro, cukup rumus dan pivot table bila diperlukan). Hasil akhir yang saya harapkan adalah file Excel siap pakai beserta c...

Procuro um profissional com experiência avançada em Microsoft Excel (ou Excel com VBA/Power Query/Power Pivot) para desenvolver um sistema de gestão de stock personalizado. O objetivo é criar uma solução simples e eficiente que permita: Registo de entrada de mercadorias no stock. Cadastro de novos produtos com referência, descrição, quantidade e outras informações relevantes. Registo de vendas, com baixa automática do stock sempre que uma venda for efetuada. Controlo em tempo real das quantidades disponíveis. Alertas de stock baixo (opcional). Registo de encomendas/reservas de clientes. Histórico de clientes e respetivas encomendas. Campo para registar a data de chegada da encomenda. Campo par...

Saya ingin seluruh proses pembuatan laporan kinerja di tim kami berjalan otomatis langsung dari file-file Excel yang sudah ada. Saat ini data performa di-update harian, lalu kami masih menyusun grafik, pivot, dan rangkuman KPI secara manual—memakan waktu dan rawan salah. Ruang lingkup yang saya butuhkan: • Merancang template Excel yang menarik sekaligus efisien, siap menerima input harian tanpa perlu copy-paste. • Membuat macro / VBA atau Power Query yang secara otomatis: – menarik data baru, – membersihkan dan memvalidasi input, – memperbarui tabel pivot dan grafik kinerja, – menghasilkan sheet ringkasan KPI mingguan dan bulanan. • Menyertakan tombol atau shortcut sederhana agar staf non-teknis cukup klik sekali untuk memperb...

Tengo una aplicación de cálculo de presupuestos desarrollada íntegramente en Microsoft Access y quiero llevarla y necesito lo siguiente: • Nuevos campos necesito añadir unos 10/20 campos mas, algunos condicionales, de importes y descripciones _ Añadir campo de referencia en listado _ añadir resultado de formula en campo para que se calcule automaticamte • Mantenimiento y calidad – Corrección de los fallos que van apareciendo durante el uso diario. (error 400, 275, 25) – Código VBA limpio y comentado para facilitar futuras ampliaciones. · Poder buscar cliente desde ficha cliente · Poder añadir lineas al presupuesto que no esten codificadas pero que se queden almacenadas Cómo trabaj...

Saya ingin membuat sistem akuntansi keuangan sederhana di Microsoft Excel dan membutuhkan bimbingan langsung dari Anda. Fokusnya hanya pada pencatatan data—membuat sheet transaksi, jurnal, buku besar, serta laporan dasar seperti neraca saldo tanpa analisis mendalam. Apa yang saya harapkan: • Template spreadsheet siap pakai dengan struktur tabel yang rapi. • Panduan langkah-demi-langkah (video singkat atau dokumen) tentang cara memasukkan dan memposting transaksi. • Penjelasan fungsi-fungsi Excel yang relevan (mis. SUMIF, VLOOKUP, pivot table dasar) agar saya dapat memperbarui data sendiri di kemudian hari. • Sesi tanya jawab singkat untuk memastikan saya memahami alur kerjanya. Tidak diperlukan integrasi software lain—semua dikerjakan di Excel. Jika ...

## Objetivo del Proyecto Desarrollé un sistema de análisis y control de inventario utilizando Microsoft Excel, enfocado en la identificación de desvíos operativos, control de stock y generación de indicadores de gestión para la toma de decisiones estratégicas. ## Herramientas Utilizadas * Microsoft Excel Avanzado * Tablas Dinámicas * BuscarX (XLOOKUP) * Funciones de búsqueda y referencia * Fórmulas condicionales * Segmentación de datos * Gráficos dinámicos * Dashboard de indicadores * Estadística descriptiva ## Desarrollo A partir de una base de datos de más de 6.000 unidades auditadas y más de 1.200 líneas de registros, realicé la consolidación y depura...