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!
Na podstawie 139,219 opinii klienci oceniają nas na Visual Basic Developers 4.9 na 5 gwiazdek.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!
Na podstawie 139,219 opinii klienci oceniają nas na Visual Basic Developers 4.9 na 5 gwiazdek.I have an automated Excel-based rostering workbook that has been running in production for a while, but a few critical pieces now need attention. The core of the job is to refine the calculation logic. Some totals are coming out wrong, a couple of edge-case rules were never coded, and overall processing speed has slipped as the file has grown. I would like the existing formulas/VBA adjusted so every shift, allowance and overtime rule reconciles accurately, a set of new business rules is added, and execution time is brought back to an instant feel. Alongside that, I need the import/export module expanded. At present it handles only a basic CSV; I want to introduce two additional formats (one XLSX template we use with payroll and a JSON summary we send to Power BI). Clean, reliable parsi...
Every day I need our accommodation paperwork to flow smoothly from first email through to final signed PDF. Here’s what the process currently looks like and what I want you to take over and streamline. First, the daily shuffle: whatever is in today’s “move-in” folder should be transferred to the “move-out” folder, and vice-versa, so the file structure always reflects our live status. Second, new arrivals: an email hits my inbox with flight or ticket details. I already have an email-parsing tool connected, so you’ll open that feed, pull the guest’s name, arrival date, and any special notes, then drop that data straight into our room-allocation Excel template. From there you’ll assign the most suitable room, making sure capacity rules a...
A spreadsheet with detailed instructions is attached, and I need the entire assignment completed exactly as outlined there. The work involves three core pieces: • Data entry – copy the raw values into the correct sheets and ranges without altering formatting. • Formulas and calculations – build dynamic formulas (SUMIFS, VLOOKUP/XLOOKUP, pivot tables if specified) so every total, percentage, or lookup updates automatically when source data changes. • Creating charts – generate the charts requested in the file, styling them to match any colour or layout cues already present. Please keep every worksheet structure intact, add only the cells or tabs the assignment explicitly calls for, and double-check that all formulas return the same answers shown in the...
Saya membutuhkan bantuan di bidang administrasi, khususnya dokumentasi, untuk menyusun laporan keuangan yang rapi, akurat, dan mudah dipahami. Ruang lingkup pekerjaan meliputi: • Mengumpulkan dan memverifikasi data transaksi dari berbagai sumber internal. • Menyusun laporan laba rugi, neraca, dan arus kas dalam format spreadsheet yang konsisten. • Menambahkan penjelasan singkat (notes) atas pos-pos penting agar laporan dapat langsung dipresentasikan ke manajemen. • Membuat template standar agar tim dapat memperbarui laporan di periode berikutnya tanpa memulai dari nol. Saya mengutamakan ketelitian, kerahasiaan data, dan kecepatan penyelesaian. Jika Anda terbiasa menggunakan Excel atau Google Sheets serta memahami prinsip dasar akuntansi, berikan contoh laporan s...
I have a collection of PDF reports that contain only numerical tables and I need every column transferred into Excel with absolute accuracy. The task is straightforward data extraction—no calculations or interpretation—just a faithful, one-to-one move of all table columns into a clean .xlsx file. Each table in the PDFs must appear on its own sheet, keep the same column order, and preserve any header names exactly as shown. The numbers cannot be rounded or reformatted; they must remain identical to the source so cross-checking totals against the original files comes out perfect. Deliverables • A single, well-organized Excel workbook with each PDF table on a separate tab • Spot checks completed so the final figures reconcile perfectly with the PDFs • A br...
I have a live Google Sheet that serves as my online database and it’s packed with pure numbers—sales figures, performance metrics, and a few calculated fields. I need every one of those values re-entered into the designated columns of a fresh template while keeping the exact order, formatting, and decimal precision intact. You’ll work directly in Google Sheets (or download to Excel if that speeds you up) and follow my short naming convention for tabs and ranges. Consistency matters more than speed: a single misplaced digit throws off automated reports downstream, so double-checking is expected. Deliverables • A fully populated template sheet matching my column layout • A brief verification log that highlights any ambiguous entries you flagged and how th...
I have a sales dataset in Google Sheets that I’d like turned into clear, insightful pivot tables. Your job is to set up each pivot so I can quickly slice totals, averages, and counts by product, region, and date without touching the raw sheet. Please build the pivots directly in my shared Google Sheet, label each tab logically, and add a short note beside every table explaining the filters and row/column logic you used. Once done, I should be able to refresh the data or add new rows and have the pivots update with a single click. If you’ve created dynamic pivot views in Google Sheets before and are comfortable working with sales-oriented metrics, this should be a quick engagement.
I have several Excel workbooks that contain raw income-statement figures. Before I can run any meaningful analysis, the data needs a careful pass of cleansing—removing duplicates, fixing inconsistent formats, standardising account names—and then re-entered into a tidy, well-structured sheet that aligns with my chart-of-accounts layout. Here is what I expect: • Every line item in each workbook reviewed and corrected for spelling, date and numeric formatting. • Uniform column order (period, account code, account name, amount, notes). • One consolidated, error-free master sheet delivered back in .xlsx format. I will provide the existing Excel files and a brief style guide for headers and acceptable account names. No OCR or PDF conversion is required; everythin...
I want a clean, intuitive spreadsheet that lets me keep track of every book I’ve finished. The main goal is simple: organise the books I’ve read so I can quickly see what’s in my personal library and find titles again later. Here is the core information I want to capture for each entry: title, author, a flexible “tags” field (so I can label genres or themes), space for personal notes, the cover image, and a direct link to where the book can be read or purchased. A well-structured header row and sensible column widths will make data entry painless. Formulas aren’t a big focus; basic counts or summaries you feel are useful are fine, but nothing complex is required. What matters most is tidy formatting, easy sorting and filtering (especially by tags or au...
I need the tables locked inside several PDFs transferred into a clean, well-structured Excel workbook. The source tables include merged cells, so a simple copy-paste will not preserve the layout; every field must be placed in the correct row and column manually or with a reliable extraction workflow. High accuracy is essential: totals, character spacing, and any special symbols must match the original documents exactly, with no dropped or shifted data. Deliverables • One Excel file (XLSX) replicating each table’s structure and content in separate sheets or a clearly labeled format that makes sense for quick analysis. • Consistent column widths and headings so I can filter and run formulas immediately after delivery. • A brief note describing any ambiguity y...
I have an Excel spreadsheet filled with traveler details. Your task is to take that file, follow the step-by-step method I’ll demonstrate inside the Travel Line mobile app, and create a unique customer ID for every traveler. The workflow is straightforward once you see it in the app: • import or copy each row’s data, • apply the in-app ID-generation steps exactly as I show, • note each finished ID back into the Excel file. Accuracy and consistency are critical—every ID must be accepted by the app with no duplicates or spelling errors. When the list is complete, return the updated spreadsheet and a quick confirmation report summarizing how many records were processed and any issues you encountered. Remote screen–share training takes about t...
I have a collection of PDF files containing mixed text and numeric information that must be transferred into structured Excel workbooks so the data can be fed straight into my downstream processing routines. Your focus will be on accuracy and faithful layout replication rather than analysis or reporting. For each PDF you will: • Extract every field and line item, preserving spelling, punctuation, and numerical precision (no rounding). • Organise the content into clearly labelled columns and, where relevant, separate sheets to mirror logical sections of the source document. • Keep number formats (dates, currency, percentages) native to Excel so formulas recognise them instantly. • Flag any illegible or ambiguous entries in a dedicated “Issues” sheet....
I’m rebuilding a detailed Profit & Loss report and need another set of expert eyes to push it across the finish line. The file already holds base data, but the core logic and visual story still have gaps. Here’s where you come in: • Design and refine advanced formulas—nested logic, array functions, dynamic ranges—so every line on the P&L updates automatically when new transactions drop in. • Translate the numbers into clear, presentation-ready charts and graphs that management can grasp at a glance. I’ll give you the current workbook, data sources, and the specific reporting rhythm we follow. Your job is to deliver a clean, fully linked spreadsheet (Excel or Google Sheets—whichever you prefer) with: 1. Robust error-proof for...
I need an automated system to manage trading quotes and update an Excel file every minute. Essential requirements: - Fetch and record trading quotes - Update Excel every minute Ideal skills and experience: - Proficiency in Excel - Experience with trading data - Familiarity with automation tools or scripts
I need a sharp Excel specialist who can jump straight into my raw data, clean it up, and turn it into useful information. Day-to-day work will begin with straightforward data entry, then move quickly into advanced territory: building pivot tables that slice the figures the way I need, writing or tweaking VBA macros to automate repetitive steps, and crafting complex formulas so the sheets stay dynamic even as the numbers change. Once the groundwork is solid, I’ll also ask for clear, standard charts that can be dropped into monthly reports without further editing. Nothing flashy—just accurate visual summaries that decision-makers can read at a glance. A bonus (and the reason “Tally Prime” sits in the title): most of these datasets originate from our Tally Prime ...
I have several PDFs that combine both numbers and text. I simply need every piece of that mixed data entered accurately into an Excel workbook laid out in a clean, standard table—one row per record, one column per field, no fancy templates or custom formatting. You will receive the source PDFs as soon as we start. From there, your job is to extract every value, label, and note exactly as written, place them in the sheet, and run a quick self-check to be sure totals, dates, and spellings match the originals. When you reply, focus on the similar PDF-to-Excel work you have completed before and how you keep accuracy high at speed. If you have a favorite tool or script that helps automate error checking, feel free to mention it; otherwise, solid manual entry skills are fine. I will revi...
I need a Macro script to automate the process of comparing two Excel spreadsheets and generating a CSV file. The script will also dump this CSV into our ERP system (EPICOR) using the DMT tool. Requirements: - Compare the two spreadsheets cell-by-cell. - Highlight mismatches. - Include all columns in the resulting CSV file. Ideal Skills and Experience: - Proficiency in PowerShell - Experience with Excel and CSV manipulation - Familiarity with EPICOR and DMT tool (Plus) - Attention to detail and accuracy
I need a full-source-code recreation of the classic Visual Basic 6 development environment, internally referred to as “Visual Basic 7.” My main goal is to open and run existing VB6 projects with zero functional loss, while adding modern support for .png images in both the Image and PictureBox controls. Core requirements • Replicate all standard VB6 user-interface components, complete with property windows, toolbox, code editor, and form designer. • Preserve the original event-driven programming model so legacy code behaves exactly as it does in VB6. • Ensure ActiveX controls register and load seamlessly. • Add built-in .png file selection and rendering for Image and PictureBox controls (no external converters—the controls must handle tra...
I have three separate customer data reports that I download regularly. I need an offline solution—Excel-based is preferred, but I’m open to any lightweight desktop approach—that can pull the data from those three files, combine and clean it automatically, and then present the final results back in Excel across multiple worksheets. Core needs • A simple way for me to point the tool to the three source reports (file picker, drop zone, or even just pasting paths). • Behind-the-scenes logic that matches customer records, removes duplicates, and reconciles any field name differences. • Output to an .xlsx file with clearly labelled multiple sheets (e.g., Combined_Data, Exceptions, and any other logical splits you suggest). • Everything must run full...
I need a professional, enterprise-level Tableau project that simulates a real-world K-12 school district analytics solution rather than a basic dashboard. The project should solve actual business problems faced by district leadership, such as identifying at-risk students, monitoring attendance, evaluating academic performance, measuring MTSS intervention effectiveness, analyzing behavior trends, and tracking equity across student groups. It should include a realistic dataset (15,000–25,000 records), a well-designed star schema data model, SQL scripts for data extraction and transformation (using joins, CTEs, window functions, aggregations, and data validation), and six interactive Tableau dashboards: Executive Overview, Attendance Analytics, Academic Performance, MTSS Analytics, Eq...
I need someone to automate tasks in a Microsoft Excel spreadsheet that handles financial data. Key Tasks: - Automate data entry, analysis, or report generation (to be specified) - Ensure accuracy and efficiency Ideal Skills: - Proficiency in Excel, including VBA and macros - Experience with financial data - Attention to detail Please provide examples of similar work done.
I need a purpose-built piece of account-management software centred on Financial Management. The core must cover everyday tasks—Invoicing & Billing, Expense Tracking, and Financial Reporting—while also letting me pull a Monthly EMI list for any chosen date-to-date window. Seamless integration with my existing accounting software is essential; a clean API connection or reliable CSV/XML import-export will work as long as data stays perfectly in sync. Key deliverables • Fully-functioning web or desktop application (your recommendation) • Modules for invoicing/billing, expense tracking, financial reports, and the custom EMI date-range report • Accounting-software integration with automated data exchange • Role-based access, searchable ledgers, PD...
I’m organising a hands-on Microsoft Excel programme for a small group of absolute beginners (no more than five participants). The aim is to move them from opening a blank spreadsheet to feeling comfortable with the essentials that drive everyday office work. The sessions must walk them through: • Basic formulas and functions (SUM, AVERAGE, simple IF statements, etc.) • Creating clear charts and graphs that effectively illustrate the data they produce • Data organisation and formatting so their sheets look professional and remain easy to update Because the group is small, I’d like the training to be highly interactive—screen sharing, practice files, quick exercises, and live Q&A rather than long lectures. Please supply a concise session outline...
Quero reconstruir o ambiente do Visual Basic 6, porém em Open source para que eu e outros possam incluir novas funcionalidades que não existiam na versão original. O foco não é tanto mudar a interface ou perseguir ganhos extremos de desempenho, mas sim disponibilizar recursos adicionais, por exemplo, imagens em PNG — com controles antigos/ mais atuais, suporte a APIs recentes do Windows e uma área de trabalho que facilite extensões futuras. Escopo que imagino: • Clonar as funções essenciais do VB6 (editor, compilador e depurador) mantendo a experiência familiar. • Acrescentar os novos recursos que definirmos juntos, garantindo total compatibilidade com Windows. • Entregar um executável i...
I’m organising a hands-on Microsoft Excel programme for a small group of absolute beginners (no more than five participants). The aim is to move them from opening a blank spreadsheet to feeling comfortable with the essentials that drive everyday office work. The sessions must walk them through: • Basic formulas and functions (SUM, AVERAGE, simple IF statements, etc.) • Creating clear charts and graphs that effectively illustrate the data they produce • Data organisation and formatting so their sheets look professional and remain easy to update Because the group is small, I’d like the training to be highly interactive—screen sharing, practice files, quick exercises, and live Q&A rather than long lectures. Please supply a concise session outline...
I’m looking for help turning a messy Excel workbook into a model-ready dataset and then driving a small machine-learning workflow directly from Excel. The immediate focus is data cleaning and transformation: removing duplicates, fixing inconsistent formats, handling missing values, and reshaping tables so every column is analytically sound. Once the data is tidy, I’d like you to set up a lightweight machine learning model—classification or regression—using whichever approach fits best inside the Excel environment (Power Query + Power Pivot, the new Python in Excel feature, or an external script triggered from VBA). Key deliverables • A fully cleaned, well-structured Excel file with transformation steps saved (Power Query or documented VBA). • An opera...
I need an Excel expert to teach me and prepare some project planning spreadsheets. Key Tasks: - Data entry and formatting - Creating formulas and functions - Generating reports and charts Ideal Skills & Experience: - Proficiency in Excel - Experience with project planning spreadsheets - Ability to teach effectively Looking for someone who can start ASAP.
I need an Excel spreadsheet to automate the payment process for approximately 30 teachers in accordance with NC State's legislative yearly pay increase. Requirements: - Automatic pay calculations based on legislative rules - Individual teacher profiles, including personal details Ideal skills and experience: - Proficiency in Excel, especially with formulas and automation - Experience in creating professional, user-friendly spreadsheets - Attention to detail to ensure accuracy in pay calculations I have all necessary information ready for integration.
I have a collection of records that combine text descriptions with corresponding numeric values, and I need them transferred—keystroke by keystroke—into the spreadsheet template I will supply. This is strictly manual data entry; no scripts, OCR, or bulk-import tools should be used, as I want human oversight on every line for accuracy. Here is what the task involves: • Open the source files I provide (they come in standard document formats). • Type each text field and its associated number into the correct column of my Excel or Google Sheet, following the header labels exactly. • Double-check totals, spelling, and number formats before marking the row complete. I will share clear field-by-field instructions and a small sample set so you can confirm your un...
I operate a poultry farm and I need a clear, easy-to-update model that shows exactly where I stand financially. The tool should pull together all major cost drivers—feed, labour and veterinary expenses—then balance them against the revenue I earn from eggs, meat and any by-products. I’d like the calculations built in Excel or Google Sheets with transparent formulas so I can change input values (flock size, feed price, mortality, market price, etc.) and instantly see updated profit or loss figures. A clean dashboard summarising total income, total expenses and net margin will help me make faster, data-driven decisions. Because timing is critical, I need the first workable version as soon as possible, ideally within a few days, with a brief walkthrough so I understand...
I’m taking our agency paperless, and the first piece I need in place is a digital shift log sheet. All of the fields and headings are already mapped out; what I don’t have is a clean, intuitive form that my team can open and start using without extra training. I’m flexible on where this lives. Google Sheets sounds convenient, but I’m open to Microsoft Excel or even a lightweight web form if that would give us better usability—feel free to suggest what you believe will work best for quick data entry and easy record-keeping. The finished sheet should guide users with drop-downs or protected cells where appropriate, capture dates and times automatically, and look good on both desktop and mobile screens. Once you’ve built it, a short “how-to” o...
I’m organising a hands-on Microsoft Excel programme for a small group of absolute beginners (no more than five participants). The aim is to move them from opening a blank spreadsheet to feeling comfortable with the essentials that drive everyday office work. The sessions must walk them through: • Basic formulas and functions (SUM, AVERAGE, simple IF statements, etc.) • Creating clear charts and graphs that effectively illustrate the data they produce • Data organisation and formatting so their sheets look professional and remain easy to update Because the group is small, I’d like the training to be highly interactive—screen sharing, practice files, quick exercises, and live Q&A rather than long lectures. Please supply a concise session outline...
I want a Microsoft Access relational database that lets my service team log every piece of client hardware the moment it arrives, follow it through each repair step, and close the loop when it ships back out—all without spreadsheets or paper forms. Core workflow • Intake: a simple form captures serial number, model, client name, date-in, and automatically assigns a job ID. • Live status tracking: technicians update the record as the unit moves through diagnosis, parts ordering, repair, testing, and dispatch, so anyone can see its current location and status in real time. • History at a glance: each asset’s full maintenance history should be retained and viewable from a single screen. • Daily summary report: at the click of a button I need an automat...
The Visual Basic program I currently run straight from a USB stick needs to move to the cloud without changing how it behaves. My goal is simple: open the same interface and get the same results, only now over the internet instead of from a pen drive. Preferred environment is a Linux server. I’m open to whichever method makes most sense there—Wine, a lightweight Windows VM, containerisation, or even a web-friendly wrapper—as long as the end-user experience stays identical. Database handling is the one grey area: the app might be using flat files or an old Access database. I’ll need advice on whether we keep that structure, migrate to MySQL/MariaDB, or adopt another engine that plays nicely under Linux. What I’d like from you: • A proposed approach that...
I need a streamlined workbook that keeps my retail product inventory accurate without constant manual intervention. All stock data will arrive from another system—typically a CSV or Excel export from our POS—so the file must let me import that feed, refresh totals at the click of a button, and immediately show what is selling and what needs re-ordering. Core deliverables • Track stock levels in real time once the latest import is processed • Generate clear sales reports (daily, weekly, monthly views with sortable pivots and charts) • Alert me when any SKU hits or drops below my chosen reorder point—ideally with conditional-formatting highlights plus an optional pop-up or email trigger I am comfortable working in Excel or Google Sheets; choose whiche...
I’m looking to push my existing Excel workflows far beyond basic formulas by pairing Microsoft 365 Copilot and ChatGPT. The goal is to design a set of practical, reusable solutions that let me ask natural-language questions, have the AI build or improve formulas, generate summaries, automate repetitive steps, and surface insights on demand—without forcing me to learn complex VBA from scratch. Here’s how I picture the engagement: you’ll review a few representative workbooks, identify where AI assistance will save the most time, then configure Copilot prompts, ChatGPT scripts or integrations, and any supporting Power Query or simple VBA snippets needed to make everything flow. Clear, inline comments and a brief, step-by-step guide should accompany the final files s...
I need a streamlined workbook that keeps my retail product inventory accurate without constant manual intervention. All stock data will arrive from another system—typically a CSV or Excel export from our POS—so the file must let me import that feed, refresh totals at the click of a button, and immediately show what is selling and what needs re-ordering. Core deliverables • Track stock levels in real time once the latest import is processed • Generate clear sales reports (daily, weekly, monthly views with sortable pivots and charts) • Alert me when any SKU hits or drops below my chosen reorder point—ideally with conditional-formatting highlights plus an optional pop-up or email trigger I am comfortable working in Excel or Google Sheets; choose whiche...
advance excel usin copilot and chatgpt
You will take the raw daily vouchers, invoices, and bank statements I supply and enter them directly into Tally, keeping every ledger updated in real time. After the entries are complete, I need the bank statement for each period reconciled against the Tally cash-book so that any variances are flagged, explained, and corrected the same day. All supporting data lives in Excel. Use VLOOKUP to pull matching references from multiple sheets and keep a clean master file that mirrors what sits in Tally. Accuracy comes first, but I also work to tight reporting deadlines, so speed matters as well. Deliverables • Tally file with all transactions posted and error-free • Reconciled bank statement showing zero open items (or a clearly annotated list of exceptions) • Excel workboo...
I want to take my existing workbooks to the next level by combining Excel’s new Copilot capabilities with ChatGPT prompts. The goal is to streamline complex analysis, speed-up formula creation, and add conversational querying directly inside Excel. Here’s what I need: • A step-by-step setup of Copilot in Microsoft 365, including any add-ins or connectors required to surface GPT-powered suggestions inside my worksheets. • Practical examples that show how natural-language prompts can translate into formulas, dynamic arrays, conditional logic, and quick data exploration. • Demonstrations of how ChatGPT can be called from within Excel—either through native functions, Power Query, or lightweight VBA—so I can ask questions about my data and receive s...
Saya membutuhkan seorang admin yang terampil di Microsoft Excel untuk menyusun laporan keuangan rutin perusahaan saya. Fokus utama pekerjaan ini adalah: • Mengumpulkan data transaksi yang saya kirimkan (mutasi bank, faktur, dan bukti pengeluaran). • Merapikan data ke dalam template Excel, lengkap dengan kategori akun, tanggal, dan penjelasan singkat. • Menghasilkan ringkasan keuangan bulanan—neraca sederhana, laporan laba-rugi, serta grafik tren dasar. • Memastikan setiap angka selaras dengan dokumen sumber dan mudah ditelusuri kembali. Saya sudah memiliki sebagian format, tetapi saya terbuka jika Anda ingin mengoptimalkannya dengan rumus, pivot table, atau visualisasi agar laporan lebih informatif. Semua file akhir harus diserahkan dalam format .xlsx ...
I’m looking to push my Excel workflows far beyond basic formulas by bringing Microsoft 365 Copilot and ChatGPT into the mix. The goal is to transform everyday spreadsheets into smart, self-updating models that surface insights on demand and remove as much manual work as possible. Here’s what I have in mind: • Use Copilot and ChatGPT prompts to generate advanced formulas, build dynamic ranges, and troubleshoot errors in real time. • Let Copilot summarise trends, exceptions, and outliers directly inside the workbook so I can act without exporting data elsewhere. • Automate repetitive clean-up steps—merging sheets, reformatting imports, refreshing connections—without relying on long VBA scripts unless absolutely necessary. • Leave me with c...
I use a custom spreadsheet to track how a series of trades compound over time, and I’d like it taken to the next level. The immediate priorities are two-fold: • New formulas for profit and loss projections – I need clean, reliable calculations that show projected equity curves, percentage returns, and cumulative gains based on variable position sizes and target/stop parameters. • Improvements to what is already there – the layout should feel more intuitive, and, above all, the figures must reconcile perfectly with the raw trade data I input. A sharper interface (clear labels, colour-coded highlights, sensible protections) plus stronger data validation rules will help eliminate the small accuracy issues I occasionally spot. If you are comfortable with advanc...
I need help moving a blend of text and numerical fields from a few online databases into one well-structured Excel workbook. You’ll be working directly inside my shared Excel file, adding each record row by row, double-checking that the numbers copy over exactly and that text values keep their original spelling, punctuation and capitalization. I’ll provide: • Login credentials to the source databases • A template workbook with column headings and data-validation rules Your task: • Copy every field from the database screens into the matching Excel columns • Follow the simple formatting notes included on the first sheet • Flag any inconsistencies, duplicates or unreadable characters so I can review them quickly Accuracy is more important than...
Title: Need an Excel Expert to Build an Automated Business Management Dashboard Description: I am looking for an experienced Microsoft Excel freelancer to create a professional and fully automated Excel workbook for my freelancing business. The workbook should include income tracking, expense tracking, client records, pending payments, monthly reports, and a professional dashboard with formulas that update automatically whenever I enter new data. I will share all the required details after awarding the project. Important: My fixed budget is $10. Please read this before placing your bid. Only bid if you are comfortable working within this budget. Thank you!
I have a dataset in Excel that I need turned into clear insights. Your role will be to clean and organize the raw data, run any necessary analyses, then present the results through professional-looking charts, graphs, and at least one interactive dashboard built directly in Excel. Please structure the workbook so the visualizations update automatically when new records are added, and label everything clearly so a non-technical stakeholder can follow the story. I’m open to the techniques you prefer—Power Query, Power Pivot, or standard formulas—as long as the final file stays within Excel and remains lightweight. Deliverables • Charts and graphs illustrating the key metrics • A dashboard page summarizing trends and outliers • The underlying, well...
I need help with an Excel sheet. This includes embedding standard office icons and formatting two calendars (monthly and yearly). Requirements: - Embed standard office icons in specific cells with data - Format two calendars (monthly and yearly) in the sheet Ideal Skills: - Proficient in Excel - Experience with icon embedding and calendar formatting - Attention to detail
I have a dataset in Excel that I need turned into clear insights. Your role will be to clean and organize the raw data, run any necessary analyses, then present the results through professional-looking charts, graphs, and at least one interactive dashboard built directly in Excel. Please structure the workbook so the visualizations update automatically when new records are added, and label everything clearly so a non-technical stakeholder can follow the story. I’m open to the techniques you prefer—Power Query, Power Pivot, or standard formulas—as long as the final file stays within Excel and remains lightweight. Deliverables • Charts and graphs illustrating the key metrics • A dashboard page summarizing trends and outliers • The underlying, well...
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.