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!
Από 131,709 αξιολογήσεις, οι πελάτες αξιολογούν τους Visual Basic Developers με 4.9 από 5 αστέρια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!
Από 131,709 αξιολογήσεις, οι πελάτες αξιολογούν τους Visual Basic Developers με 4.9 από 5 αστέριαI need a set of interactive dashboards built in Microsoft Excel that will let my team monitor projects at a glance. The focus is squarely on project management, so the workbook must pull together: • Task completion status • Team performance metrics • Resource allocation These dashboards will be used day-to-day by team members rather than executives, which means the layout has to be intuitive, fast to update, and locked against accidental formula changes. I picture slicers, dynamic charts, conditional formatting, perhaps a progress-bar style visual for tasks—whatever gives an immediate sense of where we stand without asking anyone to hunt for numbers. Source data will come from the worksheets we already maintain; your job is to cleanly connect them, automate re...
I need an Excel sheet to automate my 7 touch quote system. The goal is to minimize my manual work. Requirements: - Auto-send emails and texts for follow-ups - Track follow-up schedule for different contacts - Easy copy-paste functionality for messages Ideal Skills: - Proficiency in Excel - Experience with automation tools - Strong organizational skills Need this done ASAP.
I need an Excel template to input and analyze visitor management data. The goal is to automate data generation for insights. Requirements: - Create an organized, user-friendly Excel template. - Implement formulas or macros for data analysis. - Ensure accuracy and reliability. - Provide a brief user guide. Ideal Skills: - Proficiency in Excel (formulas, macros). - Experience in data management and analysis. - Attention to detail and accuracy. Need this done ASAP.
Hi there! I need a seasoned VBA developer to turn financial spreadsheets into clear, ready-to-share. Will share more details only selected candidate.I look forward to streamlining our reporting workflow together. Thanks
I need a single Google Sheets file that can comfortably store and manage mixed data—numbers, text, dates, anything I throw at it. Day-to-day, some records will be keyed in by hand, while others should flow in automatically from an external source, so the sheet must accommodate both entry styles without breaking formulas or formatting. Here is what I have in mind: • Core layout: a clean, well-structured master sheet with intuitive columns, filters, and basic data-validation rules to keep entries consistent. • Automated import: an Apps Script or built-in connector that can pull new rows from a designated source (API, CSV in Drive, or another sheet—whichever is simplest) on a schedule I can tweak. • Manual entry support: protected formulas, drop-down lists, an...
I need a spreadsheet to track product sales. Requirements: - Track amount of sale compared to cost - Visual representations (charts, graphs, or tables) are optional Ideal Skills and Experience: - Proficiency in spreadsheet software (Excel, Google Sheets) - Experience in creating sales tracking sheets - Ability to create visual data representations
I need assistance to fine-tune an Excel document that is heavily VBA-coded and has query connections. The goal is to improve the user interface and ensure the robustness of the code. Key Requirements: - Improve ease of navigation - Enhance code integrity - Allow end users to easily modify and change Ideal Skills and Experience: - Proficiency in Excel and VBA - Experience in optimizing complex Excel workbooks - Strong understanding of user interface design within Excel - Ability to create intuitive navigation and modify existing code for user adaptability Looking for someone with a keen eye for design and solid coding skills to make this document more user-friendly and efficient.
I need assistance to fine-tune an Excel document that is heavily VBA-coded and has query connections. The goal is to improve the user interface and ensure the robustness of the code. Key Requirements: - Improve ease of navigation - Enhance code integrity - Allow end users to easily modify and change Ideal Skills and Experience: - Proficiency in Excel and VBA - Experience in optimizing complex Excel workbooks - Strong understanding of user interface design within Excel - Ability to create intuitive navigation and modify existing code for user adaptability Looking for someone with a keen eye for design and solid coding skills to make this document more user-friendly and efficient.
1. Project Overview The goal is to develop a robust, high-precision clinical database system (preferably using MS Access with VBA) to automate the ordering process for Oncology Chemotherapy protocols. The system will bridge the gap between diagnosis and drug administration by automating clinical calculations, tracking patient treatment history, and enforcing safety dosage limits. 2. Key Modules & Features A. Admin Dashboard (Protocol Management) Database Management: Ability to Add, Edit, or Delete Diagnoses and their associated Protocols. Protocol Structure: Each protocol must be divided into three sections: Pre-medications (Supportive care). Chemotherapy Agents (Cytotoxic drugs). Post-medications (Take-home or recovery drugs). Safety Limit Settings: Per Cycle Cap: Set a max...
We are seeking a skilled freelancer to create a comprehensive KPI tracking template tailored to our organization’s needs. The template should enable effective monitoring of key performance indicators across various departments. The ideal candidate will have experience in building Excel or Google Sheets templates, ensuring user-friendly design and functionality. A solid understanding of KPIs in business contexts is essential. Please provide examples of previous work in this area.
I required PAIRS TRADING in NSE stock market including OPTIONS Trading to be adopted, Who is having a knowledge in stock market and DATA analysis must, a person should have premium version of CLAUDE and GITHUB. Manual coding it takes too much time having AI and coding will be better option for us. If you are in the track, please give the bid otherwise avoid.
Experto en excel, sustituir unos datos de un excel por otros que facilitare
I'm looking for an expert in Microsoft Power Automate to help automate workflows specifically for data entry operations. Key tasks include: - Automating form submissions - Streamlining spreadsheet management Ideal skills and experience: - Proficiency in Microsoft Power Automate - Experience with form automation and spreadsheet integration - Strong problem-solving skills - Attention to detail and reliability Looking forward to your bids!
I need an expert in Excel to create a macro that automates the process of extracting data from one file, validating it, and importing it into another file for upload. The solution should ensure accuracy during validation and streamline the workflow. Ideal skills include advanced Excel expertise, VBA programming, and experience with data validation processes.
I need an Excel sheet to automate my 7 touch quote system. The goal is to minimize my manual work. Requirements: - Auto-send emails and texts for follow-ups - Track follow-up schedule for different contacts - Easy copy-paste functionality for messages Ideal Skills: - Proficiency in Excel - Experience with automation tools - Strong organizational skills Need this done ASAP.
Tutor for AutoCAD LT PI&D CSV import/Export to update labels I’m looking for hands-on guidance to build a clean, repeatable CSV workflow inside AutoCAD LT (for my P&ID drawings). The objective is two-fold: update the labels already in place and generate entirely new ones—specifically part numbers, component descriptions and connection details—directly from a spreadsheet. What I need from you • A live tutoring session (or a short series) where you share screen and show, step by step, how to structure the drawing data so that a CSV can push changes back in, as well as pull fresh data out. • Advice on the best automation route available to LT—scripts, Sheet Set Manager, Data Links, or any third-party utility that sidesteps LT’s lack of...
I have a workbook with salary information for 100 employees that needs to be reshaped so it drops straight into our destination software without further tweaks. To make that happen I will send you a sample file that illustrates the final structure, then share an additional note that spells out the exact column names we must use. Here is what has to change: • Column headers need to be renamed • Data must be sorted in a different order to mirror the import sequence • Certain fields have to be added or removed so the sheet lines up perfectly with the target template Once those adjustments are complete I just need the finished Excel file back, ready for import and free of validation errors.
I need an expert in Excel to create a macro that automates the process of extracting data from one file, validating it, and importing it into another file for upload. The solution should ensure accuracy during validation and streamline the workflow. Ideal skills include advanced Excel expertise, VBA programming, and experience with data validation processes.
Tengo una aplicación de cálculo de presupuestos desarrollada íntegramente en Microsoft Access y quiero llevarla al siguiente nivel. Necesito: • Nuevas funcionalidades – Informes claros y totalmente personalizables. – Campos matemáticos adicionales que indiquen a qué área o partida pertenecen. • Automatización de tareas repetitivas – Generación automática de reportes para reducir tiempo y errores. • Mantenimiento y calidad – Corrección de los fallos que van apareciendo durante el uso diario. – Código VBA limpio y comentado para facilitar futuras ampliaciones. Cómo trabajo Comparto todas las aclaraciones mediante breves vídeos explicativos (ejemplo: ) y ...
I have several PDFs filled with tables that blend text labels and numeric values, and I need every line lifted into a single, well-structured Excel workbook. The job is more than a straight copy-paste: the rows and columns must line up exactly as they do in the source, mixed data should keep its original formatting (numbers recognised as numbers, text as text), and any unwanted page headers, footers, or blank rows must be stripped out so the sheet is immediately usable for analysis. Speed matters—my timeline is ASAP—so I’m looking for someone who already has a reliable workflow with conversion tools such as Adobe Acrobat, Able2Extract, or Power Query, and can move quickly from extraction to cleanup without sacrificing accuracy. Once complete, I’ll review the file t...
Saya membutuhkan bantuan untuk mengolah data penjualan yang saat ini masih mentah. Semua file tersedia dalam format spreadsheet sederhana dan ingin saya kelola sepenuhnya lewat handphone, jadi hasil akhir juga harus mudah diakses dan dipantau dari perangkat seluler. Ruang lingkup pekerjaan: • Membersihkan dan memvalidasi data penjualan agar bebas duplikasi dan kesalahan pengetikan. • Menyusun data ke dalam sheet terstruktur dengan kolom jelas (tanggal, produk, jumlah, harga, total). • Membuat ringkasan penjualan harian dan mingguan menggunakan rumus sederhana sehingga grafik bawaan spreadsheet bisa langsung menampilkan tren. • Memberi penanda (highlight atau filter) pada transaksi yang tampak tidak wajar untuk saya cek lebih lanjut. Saya menghargai alur ke...
I have several Excel spreadsheets that contain a mix of text and numerical fields. They need a thorough pass of data cleaning and validation so the information is consistent, accurate, and ready for downstream analysis. The job centres on: • Removing duplicate or irrelevant rows • Correcting formatting issues (dates, decimals, text case) • Flagging and resolving inconsistent or out-of-range values • Verifying that key fields match predefined validation rules Please return a fully cleaned workbook along with a brief summary of the issues you found and the actions you took. Consistent use of Excel’s built-in tools, formulas, or Power Query is fine—whatever you normally deploy for reliable results—as long as the final file is error-free and easy...
I have a steady stream of records that need to be keyed in every day for the next four weeks. The workload is consistent rather than overwhelming, so what matters most is accuracy, reliability, and the ability to keep to a simple daily schedule. You will receive the source files each morning, and I’ll expect the completed spreadsheet back by the end of the same day so I can run my checks overnight. For quality control I’ll be spot-checking at least 5 % of the rows; anything above a 1 % error rate will have to be corrected before the next batch goes out, so solid attention to detail is essential. I’m flexible on the platform—Excel, Google Sheets, or another tool you prefer—as long as the final file is compatible with standard .xlsx or .csv formats. Please...
I’m gathering quotations from roughly a dozen food-service suppliers and need a clean, reliable Excel file that lets me and you plug each quote in and instantly see where we can save money. Structure I have in mind • One master workbook with a dedicated tab for every supplier (expect 10–12). • A dynamic summary tab that automatically identifies the best supplier overall for every line item, taking into account weight and pack-size differences. possible colour coded • Built-in calculations for total costs per supplier, potential savings against a current baseline, and any weight/pack-size conversions so we’re always comparing like with like. Presentation requirements • On the final tab I want a clear “best supplier overall” view, p...
I have a stack of printed forms that now need to live in a clean, well-structured Excel spreadsheet. Every field on each form must be keyed in manually—no OCR or automated scraping—so close attention to spelling, numbers, and formatting is critical. The sheet you return should mirror the form layout: each column clearly labeled, each row representing a single form, with no merged cells or hidden formulas. I’ll review the file against the originals, so accuracy must be spot-on and any illegible items flagged for clarification rather than guessed. If you’re comfortable working quietly and methodically with Microsoft Excel and can keep the source paperwork confidential, this will be a straightforward job. Let me know your expected turnaround time and how you ensure...
I have several Excel spreadsheets that contain a mix of text and numerical fields. They need a thorough pass of data cleaning and validation so the information is consistent, accurate, and ready for downstream analysis. The job centres on: • Removing duplicate or irrelevant rows • Correcting formatting issues (dates, decimals, text case) • Flagging and resolving inconsistent or out-of-range values • Verifying that key fields match predefined validation rules Please return a fully cleaned workbook along with a brief summary of the issues you found and the actions you took. Consistent use of Excel’s built-in tools, formulas, or Power Query is fine—whatever you normally deploy for reliable results—as long as the final file is error-free and easy...
I need my existing workbook to do more of the thinking for me. Right now each process is logged manually, but the column that should show who is responsible is blank. Your task is to insert the right data-analysis formulas so that, as soon as a process code or other key detail is entered, Excel automatically returns the correct “responsible” name. You may lean on lookup combinations, conditional logic, or any other native functions that keep the file fast and easy to edit; lightweight VBA is acceptable only if a purely formula-based route proves impossible. The sheet layout should remain intact—no moving columns or renaming headers. Deliverables • Working formulas (or compact VBA) that populate the “Responsibility” field for every current and future r...
I have a set of existing spreadsheets filled with plain text records that now need to live in clean, well-structured CSV files. Your task is to pull every row from those sheets, check that the headings stay consistent, and export the results as UTF-8 CSV without introducing any hidden characters or broken line breaks. The spreadsheets are already organised, so no deep data cleansing is required—just tidy up obvious spacing issues, preserve punctuation, and make sure every cell ends up in the correct column position in the final CSV. I will share the sheets in either Google Sheets or Excel; work in whichever environment you prefer as long as the finished deliverable is a set of ready-to-import CSV files. Deliverables • One CSV per source sheet, correctly named and enc...
I need a clean, reusable Excel workbook that lets me do two things from the same file. First, track daily attendance in a simple table that shows each employee’s name, check-in time, check-out time, and total hours worked. Second, have those attendance figures feed seamlessly into a salary-slip sheet so I can generate individual payslips at month-end without re-entering data. A formula-driven solution is my priority, but I’m open to lightweight VBA if it keeps everything one-click simple. The layout must stay fully editable, as different teams may add or hide columns later. Please deliver: • A master attendance sheet with automatic date handling and clear data-validation for time entry • Dynamic formulas (or macro) that calculate total hours per person per day and...
I have a stack of Excel homework that is almost entirely data-entry focused and spans well over ten individual worksheets. Every sheet is already formatted; I simply need the correct figures transferred from source PDFs into the proper cells without breaking any of the existing formulas. Accuracy comes first. I will spot-check random rows, so typos or mis-aligned entries will be sent back for revision. Because there are more than ten sheets, I’d like someone who has proven experience handling large, repetitive data loads while maintaining consistency. Deliverables • All homework sheets returned in the original workbook structure, fully populated and saved in .xlsx format • A quick message summarising any anomalies you noticed (e.g., missing source values) If you have...
I need a fully automated Excel bill for my trading business. The Excel sheet should be capable of generating invoices automatically. The invoices need to include: - Customer information - Product details - Payment terms Ideal skills and experience: - Advanced Excel skills - Experience in creating automated Excel templates - Attention to detail - Prior experience in invoicing for retail or trading businesses Please provide samples of similar work done.
I need a seamless link between Xero’s API and an Excel workbook that automatically pulls the standard financial reports—Profit & Loss, Balance Sheet, Cash Flow and any other off-the-shelf statements—directly into Excel every day. No custom fields are required; the default columns Xero provides are perfect. The workflow should: • Authenticate securely with Xero’s API. • Drop each report into its own tab in a refreshable .xlsx file. • Allow a quick manual refresh in Excel (Power Query, VBA, Office Scripts, Python, or comparable approach is fine) in case I want an on-demand update. • Be simple to maintain if Xero tokens expire or if I need to adjust the date range. Deliverables: 1. Fully working connection script or add-in. 2. An E...
I have a set of existing spreadsheets filled with plain text records that now need to live in clean, well-structured CSV files. Your task is to pull every row from those sheets, check that the headings stay consistent, and export the results as UTF-8 CSV without introducing any hidden characters or broken line breaks. The spreadsheets are already organised, so no deep data cleansing is required—just tidy up obvious spacing issues, preserve punctuation, and make sure every cell ends up in the correct column position in the final CSV. I will share the sheets in either Google Sheets or Excel; work in whichever environment you prefer as long as the finished deliverable is a set of ready-to-import CSV files. Deliverables • One CSV per source sheet, correctly named and enc...
I’m looking for an experienced Power BI developer to build a financial dashboard that provides clear visibility into performance, with a strong focus on budget vs actual analysis and KPI tracking. All underlying data will be provided in Excel format. The goal is to transform this data into a clean, interactive, and management-ready dashboard that supports decision-making. Scope of Work • Review and structure the provided Excel data • Build a robust data model within Power BI • Create DAX measures for key financial metrics • Develop an interactive dashboard with filters and drill-down capability Key Metrics to Include • Revenue, Costs, and Net Profit • Budget vs Actual (with variance analysis) • Monthly and Year-to-Date (MTD/YTD) performa...
We need an Excel VBA quotation system (offline) for a windows & doors company. The system must include: A protected Admin Pricing Sheet where only admin can control all prices (designs, materials, colors, glass, screens, key lock, installation rates, delivery rate). A Customer Database where users can add customers, but cannot edit or delete them without admin approval. Customers must be searchable and auto-filled into quotations. A Quotation system where: - Quotation number is automatic - Date is automatic - Expiry date is +15 days - User selects customer, adds salesperson name and remarks Each quotation must support multiple line items. Each line includes: Design, Material, Color, Glass, optional Screen, optional Key Lock, Width, Height, Quantity. The system must automatically...
I have a set of raw transactional records sitting in several CSV files. I need them imported into Power BI, cleaned, and reshaped into a star-style model. The core relationships I must see are Customer → Orders and Region → Revenue; anything else you add for best practice is welcome provided it remains documented. Once the model is in place, create DAX measures for: • Total revenue • Number of orders • Distinct customers • Return rate With those measures, build visuals that show: • Revenue distribution by region • Seasonal revenue patterns (month and quarter) • Any revenue-concentration risk—e.g., regions or customers that contribute a disproportionate share • Key performance trends over time I will consider the job c...
I keep a master list of text in Excel and need the same strings to appear in set bookmarks inside a lengthy Word document. Manually updating each spot is getting out of hand, so I want to automate the round-trip. The core job is to write reliable VBA/macros that will: • Pull text data from specific Excel cells. • Match each cell to its corresponding Word bookmark. • Push the new text into Word at the click of a button (or Workbook_Open/Document_Open event). • Offer a simple “refresh” command so I can rerun the sync whenever the spreadsheet changes. • Handle errors gracefully (missing bookmark, blank cell, Word not open, etc.). Nice-to-have: If a bookmark’s text is edited directly in Word, a reverse sync back to Excel would be a bonus. ...
I need a freelancer who can convert 144 DTA files into Excel files, with each DTA file being converted into a single sheet in an Excel file. Key Project Details: - Each DTA file should be converted into a single sheet in an Excel file. - There is no need for any data cleaning or processing during the conversion. The task is strictly to convert the files. - The converted Excel files should use the original file names. Ideal Skills: - Proficiency in data conversion and Excel. - Familiarity with DTA file format is a plus. - Attention to detail to ensure accurate file naming and conversion.
I have a collection of Word documents that hold nothing but numbers—mostly tables of sales figures, inventory counts, and a few one-column lists. I need every single value lifted out of those digital files and placed accurately into a clean, well-structured Excel workbook. The job is straightforward but detail-sensitive: • Open each Word document and extract the numbers exactly as they appear. • Paste or type them into the matching rows and columns of the Excel template I will provide. • Keep original number formatting (decimals, commas, negatives) intact. • Double-check totals with simple SUM formulas so we can spot any discrepancies instantly. When you are done, I expect one Excel file that mirrors the order of the source documents, plus a brief note of any ir...
Project Title: Firebase Web App Foundation + Dashboard Shell (Google Ecosystem, Modular and Scalable) Project Description: I am building a web-based trucking operations platform. This contract is ONLY for the first foundation section of the project, not the full system. The goal of this first job is to create a clean, professional, modular foundation that can support future modules later. I want the project to start in the Google ecosystem for speed, low cost, and ease of launch. However, the code must be structured cleanly enough to support future scaling, refactoring, or migration into a larger architecture if needed. This is a small foundation contract only. I am NOT hiring yet for the full platform. Preferred Stack: - Firebase Authentication - Firestore - Firebase Storage - Fireb...
My Excel workbook already contains a VBA macro that opens a PDF, extracts targetted numeric value from certain columns, aggregates them, and drops the results straight into specific cells. Functionally it works, yet it generates errors when it comes accross different number formats. I need a fast, tidy rewrite (or smart port) that does the same three core steps—read, parse & aggregate, write—within roughly three hours of coding time. You can choose the approach that lets you move fastest: streamline the existing VBA, replace it entirely with a Python routine built around pdfplumber, or create a hybrid where Python performs the heavy lifting and VBA simply updates the sheet. I’m comfortable with any of those paths as long as the final workbook remains a one-click solu...
I have a single Excel spreadsheet that I need turned into a PDF. Basic visual structure—column widths, row breaks, and simple font sizing—should look the same, but I’m not worried about exact color matching or advanced styling. Please send back a clean, ready-to-share PDF file that opens without warnings on standard viewers (Adobe Acrobat, browser preview, etc.). One quick pass is all that’s required; as soon as the page layout matches the worksheet and everything is legible, we’re done.
I need an end-to-end n8n workflow that pulls data from two main sources—uploaded CSV/Excel files and live Google Spreadsheet tabs—then lets me ask for a custom report, have AI compose the narrative, export the result to a fresh .xlsx file, and add whatever chart the request calls for (bar, line, pie, or any other common type). Here is how I picture it working: • Data intake: watcher or manual trigger accepts a spreadsheet or points to a specific Google Sheet range, cleans and validates the dataset. • AI step: a prompt-driven node (OpenAI, GPT-4, or similar) summarises insights and structures the text for the report according to the question I write in plain English. • Report assembly: tables, headings, and the chosen chart are combined, then saved as a mult...
I’m looking for a clean, reusable sales-invoice template built entirely in Microsoft Excel. The finished workbook must let me enter customer details, list product descriptions, and spell out payment terms without breaking the layout. For the product section I’d like full flexibility—sometimes a single line per item is enough, other times I need multiple descriptive lines or even a category breakdown. Please structure the sheet so any of those views can be shown or hidden easily. Automatic line totals, subtotal, tax, and grand-total formulas should already be in place, and all cells where I’ll type data clearly marked. A spot for my company logo and address would be helpful too. Deliverable: • One unlocked .xlsx file ready to use and modify later. If you&rsq...
PROJECT: Excel-Based Quotation System with Admin Control (MODA Windows & Doors) We need to develop a quotation system using Microsoft Excel (offline), with structured pricing logic, admin-controlled pricing tables, and manual PDF export. The system must be easy for sales users to operate while maintaining full control of pricing by the admin. 1. USER ROLES & ACCESS CONTROL There are two types of users: Admin Has full access to all sheets, including Pricing List and Customer Database. Can edit all pricing, unlock protected areas, and manage the system. User (Sales) Has access only to: - Customer List (restricted editing) - Quotation Sheet (data entry only) User cannot: - Access or modify Pricing List - Change formulas or pricing logic - Delete or edit customers without admin...
I'm looking for an Excel spreadsheet that will help me manage customer data effectively. The spreadsheet should include features for timeliness tracking and to-do lists. Key Requirements: - Establish timeliness needs for various tasks - To-do lists generated from a fixed data set of customer information - Organized layout for easy data entry and analysis Ideal Skills and Experience: - Proficiency in Microsoft Excel - Experience in creating customized spreadsheets for data management - Strong organizational skills
When I export my .xlsx workbook to PDF, what should be a single-page printout gets split across two pages. In Excel’s print preview everything fits neatly on one sheet, so I know the layout is correct inside the file; the problem appears only at the PDF stage. The sheet contains a mix of text labels and numerical data, no external links or macros. I need someone who can dive into the page-setup settings, scaling, margins, printer drivers or any other culprit and deliver a PDF that mirrors the one-page view I already see inside Excel. Ideally you’ll explain the tweak so I can apply it to future sheets too. Deliverable: • Updated workbook (or documented steps) that consistently exports to a single-page PDF matching Excel’s print preview.
I have a set of raw financial figures that still need a bit of tidying before they can reveal their story. Once the data is properly formatted in Excel, I need clear, well-labeled outputs for these descriptive measures: mean, median, plus the full spread of quartiles and percentiles. Please structure the workbook so that the cleaning steps (date or currency standardisation, removal of blanks, etc.) are transparent, then create the calculation area—whether that is with built-in functions, dynamic arrays or PivotTables is up to you, as long as the results update automatically when new records are dropped in. Deliverables: • A single Excel file containing: – A “Raw_Data_Clean” sheet with all prep formulas in place – A “Stats_Summary&rdquo...
I have a batch of files containing both text and numerical values that need to be transferred into a clean, well-organized Excel worksheet. There are no special templates, validation rules, or conditional formats to worry about—just straightforward, high-accuracy entry into the default spreadsheet layout. You’ll receive the raw data in the format that is easiest for you to process (PDF, Word, or scanned images if preferred), and I’d like the finished work returned as an .xlsx file. My priority is absolute accuracy and a quick turnaround, so please work carefully, double-check for typos or transposed numbers, and keep the sheet tidy. If questions arise while you’re keying in the information, let me know right away so we can keep the workflow smooth. Looking forward...
I have several Excel spreadsheets filled with statistical entries recorded on different dates. I need the date columns repaired and standardised first, then a reliable way to compare each entry across the sheets so perfect matches surface immediately. Once the data is aligned, A small dashboard or set of charts inside the workbook is perfect; I want to see the movement at a glance. Everything must stay in .xlsx format. Use familiar Excel tools—formulas, conditional formatting, PivotTables, maybe Power Query if it speeds up the cleaning—so I can inspect or tweak them later. Deliverables: • Cleaned and consistently formatted spreadsheets • Automated comparison logic for the date-based entries • Standard deviation results for each metric • Tren...
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.