Visual Basic Jobs

I need an experienced VB developer to add a robust report-generation module to my existing application. The core requirement is the ability to build reports whose layout can change at runtime—groupings, columns, charts, and even page orientation must adapt to user selections rather than following a fixed template. You will work with the current VB codebase, hook into my SQL Server data layer, then expose a clean way for end-users to design, save, and export their own reports (PDF and Excel are the primary targets). Crystal Reports or ActiveReports experience is a plus, though I am open to whatever reporting engine you feel gives the greatest flexibility in Visual Basic. Acceptance criteria • Users can choose any data fields and instantly preview the resulting report. &...

I have a backlog of both accounts receivable and accounts payable that must be keyed into Tally and mirrored in Excel for reporting purposes. Source documents are already scanned and organized, so most of the work is straightforward data entry and careful copy-paste, followed by a quick self-check to be sure every invoice, payment, credit note, and adjustment is represented in both systems. You can work with the column layout I already use, or propose a cleaner template if you feel it will speed things up—I’m flexible on that point as long as the final Excel sheet matches the Tally ledgers line for line. Because accuracy matters more than speed here, I will verify the first small batch before you proceed with the rest. Once we’re happy with the approach, you can take th...

I need an Excel sheet converted into both MS Forms and HTML Form. The completed form should be downloadable in MS Excel format and integrate with Power BI. Requirements: - Form Types: MS Forms and HTML Form - Fields: Text inputs, Dropdown menus, Checkboxes, Automated scoring - Functionalities: - Data validation - Conditional logic - File uploads - Automated score calculator Ideal Skills: - Proficiency in MS Forms, HTML Forms, and Power BI - Strong experience with Excel, data validation, and conditional logic - Ability to implement automated scoring systems

I have an Excel file that’s meant to build a self-populating work roster, but the dashboard sheet is no longer talking to the roster grid. The Generate Roster button sits there looking pretty, yet nothing happens. What it should be doing is cycling through my predefined staffing rules—roles, shift lengths, maximum hours—and auto-filling the grid instantly. The core of the job is to trace where the VBA (or assigned macros) break down, restore the link between the dashboard inputs and the roster sheet, and make sure the Generate Roster button actually produces a complete schedule every time. Once fixed, I need clean, well-commented code so I can tweak the rules later without breaking everything again. Deliverables: • Working Generate Roster button that auto-fil...

I have several Excel spreadsheets that need to be brought up-to-date and reorganised so the information is clear, searchable and ready for analysis. The work is straightforward—but precision is essential. You will take raw data I provide, enter it accurately into the correct columns, apply consistent formatting, and keep everything neatly structured. Because the sheets feed into other reports I run, even a small error can cascade, so I value careful double-checking before each file is returned. If you spot obvious inconsistencies, feel free to flag them; I’ll confirm whether to correct or keep as-is. Turnaround matters, so once we agree on a hand-off schedule I expect the files back on or before the deadline each time. Experience with Microsoft Excel’s basic functio...

I need mixed text-and-numeric information transferred into a clean, well-structured Microsoft Excel file. Because no template exists yet, the first step is to design a workbook layout that groups the data logically, uses appropriate data types, and includes basic validation to minimize entry errors. The structure should include features like dropdown menus, data validation rules, basic formulas where appropriate, and clear formatting for ease of use. Once the format is approved by me through a submitted sample layout or brief guidelines, enter all supplied records, double-checking for typos, misplaced decimals, and inconsistent labels to achieve utmost accuracy. Key deliverables: • Custom Excel template with clear headings, data-validation rules, dropdown lists, and basic formulas a...

I have a backlog of both accounts receivable and accounts payable that must be keyed into Tally and mirrored in Excel for reporting purposes. Source documents are already scanned and organized, so most of the work is straightforward data entry and careful copy-paste, followed by a quick self-check to be sure every invoice, payment, credit note, and adjustment is represented in both systems. You can work with the column layout I already use, or propose a cleaner template if you feel it will speed things up—I’m flexible on that point as long as the final Excel sheet matches the Tally ledgers line for line. Because accuracy matters more than speed here, I will verify the first small batch before you proceed with the rest. Once we’re happy with the approach, you can take th...

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

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

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

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

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

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

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

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

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.

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

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

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

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

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