The ultimate guide to hiring a web developer in 2021
If you want to stay competitive in 2021, you need a high quality website. Learn how to hire the best possible web developer for your business fast.
Visual Basic is a general-purpose programming language designed to develop graphical user interface (GUI) applications. Visual Basic programming is used to build a wide range of applications and run platforms on the Microsoft Windows operating system. Visual Basic can be used to create almost any application you imagine, from inventory systems to customized games. It is a powerful programming language with many features like the ability to use the libraries, classes and objects available in .Net languages, such as C# and J#. A Visual Basic Developer is an experienced professional who is able to develop applications using this Microsoft’s programming language.
Here's some projects that our expert Visual Basic Developer made real:
Visual Basic Developers are capable of creating various software purposes, actions and activities. With their advanced coding knowledge and experience, they can make an application or program easily accessible and very useful in a short period of time. Their communication skills also help them work closely with you throughout the entire project.
All these makes freelancers with expertise in Visual basic extremely useful in developing various computer programs. They are responsible for designing interfaces, writing codes, testing programs and fixing errors when needed. By hiring one of our expert Visual Basic Developers on Freelancer.com, you can trust that your project will be delivered on time and with great quality. Put your project in front of qualified professionals now and get started! Make your ideal project come to life with us!
De 135,948 opiniones, los clientes califican nuestro Visual Basic Developers 4.9 de un total de 5 estrellas.Visual Basic is a general-purpose programming language designed to develop graphical user interface (GUI) applications. Visual Basic programming is used to build a wide range of applications and run platforms on the Microsoft Windows operating system. Visual Basic can be used to create almost any application you imagine, from inventory systems to customized games. It is a powerful programming language with many features like the ability to use the libraries, classes and objects available in .Net languages, such as C# and J#. A Visual Basic Developer is an experienced professional who is able to develop applications using this Microsoft’s programming language.
Here's some projects that our expert Visual Basic Developer made real:
Visual Basic Developers are capable of creating various software purposes, actions and activities. With their advanced coding knowledge and experience, they can make an application or program easily accessible and very useful in a short period of time. Their communication skills also help them work closely with you throughout the entire project.
All these makes freelancers with expertise in Visual basic extremely useful in developing various computer programs. They are responsible for designing interfaces, writing codes, testing programs and fixing errors when needed. By hiring one of our expert Visual Basic Developers on Freelancer.com, you can trust that your project will be delivered on time and with great quality. Put your project in front of qualified professionals now and get started! Make your ideal project come to life with us!
De 135,948 opiniones, los clientes califican nuestro Visual Basic Developers 4.9 de un total de 5 estrellas.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 need someone to key a batch of financial figures—revenues, expenses, and a few tax percentages—into an existing Excel sheet. This is a straight-forward data entry task; all formulas are already in place, so nothing needs to be built or modified on your end. Accuracy is critical because the numbers drive automated reports. You will receive scanned statements and a small CSV export. Simply place each value in the correct cell and make sure the running totals produced by the embedded formulas match the source documents. Basic currency or percentage formatting would be appreciated if you can apply it as you go, but the main objective is to have every figure entered flawlessly. The finished deliverable is the updated .xlsx file returned to me within 24 hours, saved under a n...
I have an excel sheet I need three years of assumptions based on the information I provide. And I need a script written on why those assumptions we're made.
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 building a scheduler for the department courses, given Instructor preference form, student-course counts, courses-pre-requisities, to produce a final schedule with the instructor names assinged to courses (some with labs) with timings. I also want it to allow edits and show conflicts of time if any plus ability to add Rules (eg. CS101 cannot be assigned 8-9am. ) attached is an example of the Instructor form (Course preference) and student form (Student Course selection) and two examples of a final schedule.
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.
Saya ingin menyatukan foto-foto lama, beberapa rekaman video, dan sedikit pesan teks menjadi satu video kenangan yang sederhana dan langsung. Fokusnya bukan efek rumit, melainkan alur yang rapi, transisi halus, dan musik latar yang pas agar momen terasa hangat namun tetap natural. Ruang lingkup pekerjaan: • Susun urutan foto dan klip sesuai kronologi atau cerita pendek yang saya berikan. • Tambahkan caption atau pesan teks singkat di beberapa bagian. • Pilih musik bebas hak cipta yang lembut; saya akan review sebelum finalisasi. • Koreksi warna ringan untuk menyamakan tone antar klip dan foto. • Durasi akhir sekitar 3–5 menit, resolusi Full HD. Saya akan menyediakan semua materi mentah lewat folder cloud. Silakan kirim contoh pekerjaan serupa ...
I want to clean up and speed up the way we handle vendor and customer invoices. Right now the flow touches SAP FI, MM and SD as well as a set of Microsoft Excel workbooks that staff use for preliminary checks. The immediate priorities are: • Accurate data entry and verification at each step, so master data, PO numbers, tax codes and payment terms always match. • Eliminating as many repetitive keystrokes as possible—whether that means SAP scripting, BAPIs, Fiori apps, VBA macros in Excel, or an RPA bot that can move between both platforms seamlessly. You’ll start by mapping the current steps, highlight where errors or double-entry happen, then build and test the automation or validation logic. A concise hand-over guide and annotated code/scripts are part of the...
I have several Excel/CSV sheets that contain both text and numerical fields. Your task is to key this mixed data into the destination I will provide, keeping every value exactly as it appears in the source files. Speed is welcome but accuracy is essential—spelling, punctuation, and number formatting must match the originals. You will receive the Excel/CSV files, my template, and brief written notes that clarify any column-to-column mapping. Once you finish, return the completed file (or direct database update, if you prefer to work that way) along with a quick summary of any anomalies you spotted so I can double-check them. If you are comfortable working directly in Excel or via a simple import script, great; otherwise manual entry is fine as long as the end result is error-free.
Saya memiliki kumpulan data penjualan dan memerlukan analisis statistik lengkap langsung di Excel. Saya ingin: • Perhitungan statistik deskriptif: rata-rata, median, standar deviasi, dan ukuran sebaran lain yang relevan. • Uji atau pemodelan sederhana (misalnya korelasi, regresi linier) untuk melihat hubungan variabel kunci. • Ringkasan temuan dalam tabel pivot serta grafik yang mudah dipahami manajemen. • Catatan langkah-langkah (atau macro/VBA jika diperlukan) agar proses bisa saya ulang di masa depan. File sumber akan saya berikan dalam format .xlsx. Kerjakan sepenuhnya di Microsoft Excel; tidak perlu software eksternal. Hasil akhir yang saya harapkan adalah: satu file Excel berisi lembar data bersih, lembar analisis, visualisasi, dan ringkasan insight, plus ...
I have an Excel workbook with several sheets of live inventory information that must be migrated into our SAP environment. The file tracks daily progress reporting for each SKU across multiple warehouses, so the solution needs to carry that data across without loss or distortion. What I need: • A repeatable conversion routine—LSMW, BAPI script, or another SAP-approved method—that reads every sheet, maps each column correctly, and uploads the records into the appropriate SAP tables. • Validation checks to confirm row counts and key figures (especially the daily progress metrics) match pre- and post-load. • A concise how-to document so my team can rerun the process whenever new inventory files arrive. Acceptance criteria will be a successful test import...
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.
Por favor, regístrate o inicia sesión para ver los detalles.
I’m organising several months of financial records and want them entered quickly and flawlessly into my spreadsheet-based database (Excel). All source documents are scanned and neatly labelled; I simply need each transaction transcribed into the correct columns, totals double-checked, and any discrepancies flagged. The work is pure database entry in Excel—no other platforms are involved. You’ll be pulling figures such as dates, voucher numbers, ledger heads, debit/credit amounts and GST breakdowns, then validating every line against the supporting document. Familiarity with basic accounting terminology or tools like Tally will make the process smoother, but the key requirement is uncompromising accuracy and a steady typing rhythm. Deliverables • A fully populated...
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 a rigorous value-based pricing framework and an accompanying ROI model for the Herdwatch Enterprise Platform. Because the platform is rooted in agriculture, the model has to speak the language of farm managers and ag-tech procurement teams, proving in clear numbers how much time our software saves them each week and what that is worth in monetary terms. Here is what I expect: • Pricing framework: a structure I can reuse to set customer-specific licence fees that scale with measured time savings. The framework should show how to move from raw usage or operational data to € value created and finally to the price point, allowing a simple “plug-in” of each prospect’s metrics. • ROI calculator: built in Excel, with clean formulas, inputs clearly sep...
I'm looking for a PowerBI expert to create an interactive and insightful report page using data from Excel spreadsheets. The visuals should help in analyzing spend data and can be filtered and sliced by Matter, Region, Department, and Paid Date (with options to filter by quarter and year). Requirements: - Visuals should include, but not limited to: Bar charts, Pie charts, Line graphs, etc., depending on what best displays the data. - Key metrics to be included: Total Spend, Total Spend per Quarter, Total Spend by Year, Spend by Department - The report should be user-friendly and allow for easy data exploration Ideal Skills and Experience: - Proficiency in PowerBI and Excel - Strong data visualization skills - Experience with spend analysis reports - Ability to create interactive fil...
My current CSV contains value misalignment and inconsistent date formatting that are breaking downstream reports. I need someone who can open the file, identify every row where a cell has slipped into the wrong column, and realign the data so each field sits in its correct place. While you are in there, please standardise all date fields to a single, clean format (ISO-style yyyy-mm-dd is fine) and remove any delimiter or line-break quirks that could trip up future imports. You may use whatever parsing or spreadsheet tools you prefer, as long as the final deliverable is a single, well-structured CSV that opens flawlessly and preserves every record exactly once. Before handing it back, spot-check totals or unique IDs so we both know nothing was lost or duplicated. Deliverable: • Clean...
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 need a well-structured Excel workbook that lets me drop in raw customer data and instantly see meaningful insights. The core objective is data analysis focused specifically on customer behaviour, so the file should make trend analysis and segmentation analysis both quick and intuitive. Here is what I have in mind: • A clean, instruction tab where I can paste or import new customer records (CSV friendly). • Automated tables, formulas, or Power Query steps that transform that raw feed into an analysis-ready data model. • Pivot tables, charts, or a compact dashboard that highlights purchase trends over time and breaks the customer base into clear segments I can act on. • Everything unlocked and documented so I can tweak filters, date ranges, or add new fields la...
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...
We are converting a mature, commercially deployed Excel-based financial/audit automation application from VBA to Python. The Excel workbook front-end and custom ribbon stay; all processing logic moves to a Python engine running behind Excel. THE SYSTEM: • ~56,000 lines of VBA across a main workbook and add-ins, developed and patched over 15+ years • Modules include: data import and mapping wizards, journal/adjustment engines, configurable settings panels, analytical calculations, multi-step report generation wizards, sampling tools, and a cash flow statement engine • Full installed environment, source code, and user documentation will be provided under NDA SCOPE OF WORK: 1. PLANNING PHASE: Analyze the VBA codebase and produce a technical planning document — module inv...
I have prepared a design brief (see the ZIP) that shows the look and feel I want: one page for entering a register of referral relationships and their milestone activities, and a second page that turns those entries into a clean, professional-looking dashboard. The workbook needs only straightforward formulas—nothing heavy on macros—but it must calculate totals and status summaries automatically so the overview always reflects the latest input. You will build: • Sheet 1 – a clearly laid-out input form where users can type or paste each referral partner, the date of each milestone, and any notes I have specified in the mock-ups. Data validation and drop-downs should guide users so entries stay consistent. • Sheet 2 – an interactive dashboard that pulls f...
instruction to be applied in excel sheet
Call Center Performance Dashboard in Microsoft Excel Created a professional Microsoft Excel dashboard to monitor call center performance. The workbook includes Break Efficiency Tracking Agent Efficiency Analysis Overall Performance Report Excel formulas and calculations Clean and organized data Performance monitoring and reporting Skills Used: Microsoft Excel, Formulas, Data Analysis, Reporting, Dashboard, Conditional Formatting
I have a sizeable spreadsheet that needs a thorough clean-up in Microsoft Excel. The raw file contains duplicates, inconsistent formats, stray blanks and a few obvious typos. I’m looking for someone who can methodically work through the sheet—using whatever mix of formulas, Power Query, or manual checks you prefer—to deliver a polished, analysis-ready workbook. Accuracy is more important than speed, so the timeline is flexible. When you respond, please highlight your experience handling similar Excel data-cleaning jobs; examples of past successes will help me gauge fit. Final deliverable: the cleaned Excel file plus a short note summarising the main issues you found and the fixes you applied.
I have a collection of digital files that hold nothing but raw lists of names and addresses. I need every single entry moved into a clean Microsoft Excel workbook with absolute accuracy—no spelling slips, transposed numbers, or missing fields. The layout I’m after is straightforward: each component of the address (first name, last name, street, city, state, postcode, and country when supplied) goes into its own column so I can filter and sort later without hassle. I will provide all source files in their current digital format along with a brief field guide that shows how each line should map to the spreadsheet. When you return the finished .xlsx file I’ll spot-check it against the originals, so consistent formatting and 100 % data fidelity are essential. If you use sho...
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...
I have a collection of digital files that hold nothing but raw lists of names and addresses. I need every single entry moved into a clean Microsoft Excel workbook with absolute accuracy—no spelling slips, transposed numbers, or missing fields. The layout I’m after is straightforward: each component of the address (first name, last name, street, city, state, postcode, and country when supplied) goes into its own column so I can filter and sort later without hassle. I will provide all source files in their current digital format along with a brief field guide that shows how each line should map to the spreadsheet. When you return the finished .xlsx file I’ll spot-check it against the originals, so consistent formatting and 100 % data fidelity are essential. If you use sho...
I have a set of Excel workbooks that I consult daily and I’m ready to turn them into a single, interactive Power BI dashboard for my own use. I’ll supply the spreadsheets; you will connect, clean and model the data directly in Power BI, then design a sleek report with custom visuals—not just the default bar or pie charts. What matters most is clarity, speed and flexibility: I need to spot trends at a glance, drill down when something looks off, and update the dashboard easily whenever I drop a new file into the folder. If DAX measures or Power Query transformations are required, go ahead and build them in; just keep the logic readable so I can maintain it later. Deliverables • A .pbix file linked to my Excel sources, fully refreshable • All custom visu...
I want to clean up and speed up the way we handle vendor and customer invoices. Right now the flow touches SAP FI, MM and SD as well as a set of Microsoft Excel workbooks that staff use for preliminary checks. The immediate priorities are: • Accurate data entry and verification at each step, so master data, PO numbers, tax codes and payment terms always match. • Eliminating as many repetitive keystrokes as possible—whether that means SAP scripting, BAPIs, Fiori apps, VBA macros in Excel, or an RPA bot that can move between both platforms seamlessly. You’ll start by mapping the current steps, highlight where errors or double-entry happen, then build and test the automation or validation logic. A concise hand-over guide and annotated code/scripts are part of the...
I have a set of raw sales figures and I need an Excel-based dashboard that surfaces only one KPI—revenue. Charts are not necessary; a clear, dynamic layout that lets me filter, sort, and instantly see total and segmented revenue is what matters. The file should open on a summary page that automatically refreshes from the underlying data table, highlights key numbers with conditional formatting, and offers simple slicers or drop-downs for date ranges and product groups. Everything must run on native Excel features (Power Query or Power Pivot are fine) so I can maintain it without add-ins. Deliverable: a single .xlsx file with all formulas, queries, and named ranges unlocked and cleanly documented so I can follow the logic.
I need help transferring numerical data that currently lives in a company database into clean, well-structured Excel spreadsheets. The task is straightforward: open the records I will grant you access to, verify each figure against the on-screen source, then enter it accurately into the matching Excel fields I provide. Consistency is crucial, so a quick eye for spotting outliers or missing values will be appreciated. I will supply clear field-by-field guidelines and a small sample sheet so you can see the desired formatting before you begin. A short check-in after the first batch will confirm we’re aligned, then you can proceed with the remaining rows. If you have solid experience with data entry, understand basic database navigation, and are comfortable working in Excel, this ...
I’m organising an on-site workshop for a group that already works confidently in Excel and wants to take their skills to the next level. The participants handle complex spreadsheets daily, so the content must dive straight into expert territory—no time spent on the basics. Core topics we need covered • Macros & VBA: writing, editing, and debugging code that automates repetitive tasks. • PivotTables & PivotCharts: building multi-layered summaries and interactive dashboards. • Data Analysis & Visualisation: advanced formulas, scenario analysis, and clear graphical storytelling that supports decision-making. What I’m after – A trainer who can run engaging, hands-on sessions at our premises (exact location and dates to be agreed). ...
Saya sedang menyiapkan sebuah kampanye dan membutuhkan bantuan Anda untuk merancang satu poster bergaya minimalis. Fokusnya adalah kesederhanaan yang elegan namun tetap kuat menyampaikan pesan. Lingkup pekerjaan • Konsep visual: saya memberi arahan tema dan teks utama; Anda mengembangkan ide layout dan tipografi yang clean. • Desain final: versi siap cetak (A3, CMYK, 300 dpi) serta versi digital untuk media sosial. • File sumber: Adobe Illustrator atau Photoshop beserta font dan aset pendukung. • Revisi: hingga dua kali penyesuaian ringan jika diperlukan agar hasil benar-benar sesuai harapan. Yang saya cari • Portofolio desain grafis, khususnya contoh poster minimalis. • Ketelitian tinggi, kreativitas, dan komunikasi responsif sepanjang proses. &bu...
My VBA-driven workbook suddenly throws an error on Windows 11 with Office 2019. I need someone who can jump in right away, locate the glitch, and patch it within the next couple of hours. I will send the workbook and a brief note on the steps that trigger the failure. Once you reproduce the problem, please clean up the code, make it robust for this environment, and send the corrected file back along with a short summary of what you changed and why. Deliverables • Repaired Excel file with fully functioning macro • One-paragraph changelog outlining the fix If you are confident with VBA in Office 2019 and can start immediately, this should be an easy win for you and a quick resolution for me.
I need a freelancer to convert a dozen Word and Excel forms into auto-fill formats. These forms are currently used for written reports and invoicing. Requirements: - Convert Word/Excel forms to an auto-fill format. - Maintain the integrity of text input fields, checkboxes, multiple choice fields, and dropdown menus. Ideal Skills and Experience: - Proficiency in Word, Excel, and form automation tools. - Attention to detail to ensure accurate field mapping.
Por favor, regístrate o inicia sesión para ver los detalles.
I’m looking for an Excel-based solution that lets me maintain a fully linked set of financial statements without touching a calculator. The workbook should open to a clean, user-friendly dashboard where I can enter raw transaction data (or paste it in) and instantly see an updated Balance Sheet as well as an Income Statement, Cash-Flow Statement, and Statement of Changes in Equity. Core deliverables • Balance Sheet • Income Statement • Cash-Flow Statement • Equity Statement Key features to build in • Automated calculations that flow through every schedule and roll forward ending balances automatically. • Clear, presentation-ready graphs and charts that refresh with each data update so trends are visible at a glance. • Solid data-va...
I need an interactive Power BI dashboard that pulls its data directly from a set of Excel workbooks I will supply. The core of the job is to connect to those sheets, model the data cleanly, and design compelling visuals that let me slice and drill down without having to touch the underlying files. You are free to suggest the most meaningful charts and KPIs once you see the data, but the refresh must remain one-click simple: whenever I replace the source Excel files, the dashboard should update automatically. If you think an additional source—such as a SQL database or an online service—would improve insights later on, please note it in your proposal; for now everything needs to function with Excel alone. Deliverables: • A fully-functional .pbix file linked to my Excel da...
I’m looking for an Excel-based solution that lets me maintain a fully linked set of financial statements without touching a calculator. The workbook should open to a clean, user-friendly dashboard where I can enter raw transaction data (or paste it in) and instantly see an updated Balance Sheet as well as an Income Statement, Cash-Flow Statement, and Statement of Changes in Equity. Core deliverables • Balance Sheet • Income Statement • Cash-Flow Statement • Equity Statement Key features to build in • Automated calculations that flow through every schedule and roll forward ending balances automatically. • Clear, presentation-ready graphs and charts that refresh with each data update so trends are visible at a glance. • Solid data-va...
I need an Excel spreadsheet fully replicated in Google Sheets. Requirements: - Transfer of all formulas and calculations - Complex functions: VLOOKUP/HLOOKUP, IF/AND/OR, and array formulas - Application of data validation rules and conditional formatting Ideal Skills and Experience: - Proficiency in both Excel and Google Sheets - Experience with complex formulas and data validation - Attention to detail to ensure accuracy in migration
Saya membutuhkan bantuan untuk membuat sebuah tabel yang rapi dan siap pakai untuk keperluan analisis data. Fokus utamanya adalah: • Data yang diolah: Data penjualan dan data pelanggan. • Kolom inti yang harus ada: Tanggal dan Jumlah. Saya ingin hasil akhirnya berupa file spreadsheet (Excel atau Google Sheets) dengan struktur yang mudah difilter, diurutkan, dan kalau perlu langsung dipakai untuk membuat pivot table atau grafik sederhana. Mohon sertakan pengaturan format tanggal yang konsisten dan rumus dasar (misalnya total, rata-rata, atau pertumbuhan sederhana) agar analisis awal bisa langsung dijalankan. Silakan lengkapi dengan kolom bantu lain jika menurut Anda dapat meningkatkan kualitas analisis, tetapi pastikan dua kolom inti di atas tetap menjadi prioritas.
I need a single Excel workbook tailored for our mechanical department that can automatically turn raw operational data into clear summary reports. The main purpose is to generate three report types—Monthly Performance, Maintenance Schedule, and Inventory—without extra manual manipulation, because the engineers who will use it have limited time to tinker with formulas. Here’s what I have in mind: • One input sheet where engineers can paste or import daily data. • Backend formulas, pivot tables, or VBA (your call) that clean, sort, and calculate the required metrics. • Three dedicated report tabs—Performance, Maintenance, Inventory—that update instantly once new data is entered. Acceptance criteria • All calculations refresh with a single ...
I’m looking for an Excel-based solution that lets me maintain a fully linked set of financial statements without touching a calculator. The workbook should open to a clean, user-friendly dashboard where I can enter raw transaction data (or paste it in) and instantly see an updated Balance Sheet as well as an Income Statement, Cash-Flow Statement, and Statement of Changes in Equity. Core deliverables • Balance Sheet • Income Statement • Cash-Flow Statement • Equity Statement Key features to build in • Automated calculations that flow through every schedule and roll forward ending balances automatically. • Clear, presentation-ready graphs and charts that refresh with each data update so trends are visible at a glance. • Solid data-va...
You will be working directly in Microsoft Excel to transfer mixed data—both numbers and text—into pre-made sheets that I will share at the start of the project. The layout is already set, so you won’t need to create categories or redesign the workbook; your focus is pure data entry with accuracy front and centre. Every line you enter must pass two quality gates: first, a quick spell-check to catch typos in text fields, and second, a numeric review to be sure figures match the source documents exactly. Feel free to use Excel’s built-in spell checker, simple validation formulas, or any other technique you prefer as long as the final file is error-free. I’ll supply the source material in PDF and Word format, along with a short guide on naming conventions for th...
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...
If you want to stay competitive in 2021, you need a high quality website. Learn how to hire the best possible web developer for your business fast.
Learn how to find and work with a top-rated Google Chrome Developer for your project today!
Learn how to find and work with a skilled Geolocation Developer for your project. Tips and tricks to ensure successful collaboration.