Excel vba projects for practice jobs

I require an experienced VBA programmer to write a script for my Office 365 Excel workbook. The task is to automate the printing process of a specific worksheet based on a cell value in the 'Component Index' worksheet. Key Requirements: - The 'Component Index' worksheet contains the cell value that determines the number of pages to print. - The script should allow for changing the name of the workbook without interrupting the print process. - The automation should seamlessly integrate with Excel's regular print button. The ideal candidate for this project should be proficient in VBA programming and have extensive experience with Excel 2019 and Office 365. Knowledge of Excel's print processes and handling of ...

Hi, I’m Nirajan Neupane, a skilled professional specializing in cybersecurity and computer-related technologies. With a strong foundation in IT and a passion for problem-solving, I also excel in freelance writing, delivering high-quality, well-researched, and engaging content on technical and non-technical topics. Skills and Expertise Cybersecurity and system protection. Writing and content creation for technical topics. IT-related problem-solving and consultation. Research and documentation on advanced computer technologies. Why Work With Me? I bring a blend of technical expertise and creative writing skills to every project. I ensure clear communication, timely delivery, and meticulous attention to detail. My goal is to help clients achieve success wi...

I'm looking for an expert in Microsoft Excel to help me create a visually appealing and functional spreadsheet for tracking PM maintenance checks and notes. The ideal candidate should have a strong background in: - Advanced Excel features: You will need to use conditional formatting and create drop-down menus. - Visual design: The spreadsheet should be easy to read and visually engaging. - Understanding of maintenance schedules: The spreadsheet will be organized by maintenance type, so an understanding of this field would be beneficial. Please, include in your proposal examples of similar projects you've done in the past.

I need to connect my website ( ) buttons and data capture to a MySQL database on Hostinger. I'm hoping to integrate 1 to 2 of my websites into this system. The key data points to capture include: - User contact detai...integrate 1 to 2 of my websites into this system. The key data points to capture include: - User contact details - Paypal Donations - Other Forms of Donation - Petitions Additionally, I need a simple way to export this data. Primarily, I would need to send it off as an Excel file. Ideal Skills for this Job: - Proficiency in MySQL - Experience with Hostinger - Web development skills - Ability to set up data capture from website interactions - Excel data manipulation skills Please provide examples of similar projects you've wo...

I need an Excel expert to analyze my sales data and generate visualizations. The ideal candidate should be proficient in Excel, with a strong understanding of data analysis and visualization techniques. Key Requirements: - Analyze sales data to determine profits - Create a variety of visualizations including bar charts, pie charts, and line graphs Experience in data analysis and Excel is necessary for this project. I hope to gain a clear understanding of my profits and any related patterns through this analysis.

I'm in need of a highly skilled Excel professional to create a customized spreadsheet for managing our stainless steel kitchen items. This spreadsheet should not only track our inventory, but also automatically calculate prices based on various factors. Key Features: - Automatic pricing calculations per meter for each item, as well as for single items. - An easy-to-use inventory tracking system. - A system for manual data input as our inventory grows. - Accommodation for fixed amount price adjustments reflecting market fluctuations. - Versatility to handle different pricing for different units of measurement, specifically meters. Ideal Skills and Experience: - Proven expertise in creating intricate, user-friendly Excel spreadsh...

I'm looking for a skilled Excel expert to create a bespoke spreadsheet for our stainless steel custom kitchen items. Key Requirements: - The spreadsheet should automatically calculate prices per meter per item as well as for single items. - It should have an inventory management system. - There should be capabilities for price adjustments reflecting market fluctuations. - I need to manually input the data for each item over time. - The spreadsheet should accommodate different pricing for different units of measurement. Ideal Skills and Experience: - Extensive experience with creating complex Excel spreadsheets. - Strong understanding of inventory management systems. - Previous work with pricing calculations based on varying u...

I need a qualified and licensed Solicitor in Northern Ireland to assist with transferring a plot of land from parents to my daughter and son-in-law. - This is a property law matter. - The plot of land is currently owned outright. - I am not in need of assistance with buying/selling property, lease agreements or property disputes. Ideal candidate should have: - Licensed to practice in Northern Ireland. - Extensive experience in property law. - Proven track record in handling property transfer matters. - Excellent communication skills to explain legal jargon in simple terms. Full details below - We meet via Teams or Zoom You examine the following documentation – 1. Land Registry Form – completed, signed and witnessed 2. Land Registry Search dated 19th October **** 3....

I need a professional who can convert my scanned PDF bank statement into an Excel. I have been trying to do it via a python script and while I can extract the text the data is not being pasted into the correct columns. My script is not accounting for the fact not all columns are populated. The primary purpose for this conversion is data extraction for analysis. The data should be organized in the Excel file by column from the statement. Specifically, I need the following columns from the bank statement to be included: Date, details, Debit €, Credit €, Balance €. Ideal Skills: - Proficient in data extraction and analysis - Experienced in Excel script creation - Detail-oriented to ensure accurate data conversion

I need a freelancer to enhance my spreadsheet by adding two new text columns, C and D. Using the first tab, PLCMON, as a template, these columns should be labeled 'Pass/Fail' and 'Comment' respectively. Key Requir...spreadsheet by adding two new text columns, C and D. Using the first tab, PLCMON, as a template, these columns should be labeled 'Pass/Fail' and 'Comment' respectively. Key Requirements: - Insert the new columns into the spreadsheet - Populate column C with 'Pass' or 'Fail' - Place the text 'Comment' at the top of column D - Utilize the first tab, PLCMON, as a reference for data placement Ideal Skills: - Proficient in Excel or equivalent spreadsheet software - Strong attention to detail - Abi...

I have approximately 3000 rows of data spread across three Excel 365 sheets. I need someone to extract, link, and manage this data for me. The final deliverable will be a detailed report in Excel. This report should include: - Data summaries - Trends and patterns - Comparative analysis There's no need for complex formulas, but the ability to identify and highlight these aspects of the data will be crucial. Your expertise in data management and proficiency in Excel will be key to the success of this project.

I'm looking for an Excel expert who can create a pivot table for me. The main purpose is reporting on customer data. Specifically, I want to gain insights into expenses per category. Ideal Skills: - Proficient in Excel, particularly in using Pivot Tables - Experience in data analysis and reporting - Ability to interpret and present data in a clear and concise manner Please bid if you can assist with this task.

I am looking to have a excel spread sheet created for my small buisness, I already have my branded business logo so I would also like that to be featured on the spreadsheet, I am looking for a basic 1)Profit & loss spreadsheet 2) General Ledger Spreadsheet 3) Balance sheet. I have P&L Templet along with a General Ledger Templet I can provide for reference if needed. the spreadsheets I have will need a few adjustments but are pretty basic. I am also open to some templates you provided for reference if you have any Thank You

I am looking to update my CRM database with a couple simple excel tasks in a macro. See tabs in excel sheet as I download these when needed, and upload the new DataBase values when needed. • Household Id is unique to a household • Id is unique to a person. • You can have many people in a household 1st Task: I would like to update “Manual Household Last Note” in the Last Note Report Excel Tab to the most recent date from any of the people inside a household associated with their Household Id. Place in same date format. – Purpose: this will show me recent activity of anyone in the house when I run my report from my CRM. I would like to make this in an excel macro that I can use again in a few months. Report which ones were ch...

I need someone to create printable labels from an excel sheet. The labels will be used for products and should include the following details: - Product details - Expiration date - Ingredients list - Price - Others These labels need to be designed to fit on letter size (8.5 x 11 inches) sheets. Ideal skills for this project include proficiency in Excel and label design software, attention to detail, and experience with product label design.

I need a skilled VBA programmer to help me add a macro to my existing Excel file. The macro needs to automate some of my repetitive tasks, specifically: - Data entry: I want to streamline the process of inputting data into the spreadsheet to save time and reduce errors. - Data analysis: I need assistance with automating some basic analysis to derive insights from the data. The data for these tasks will primarily come from user input within Excel. Ideal skills and experience for this job include: - Proficient in VBA programming with a strong portfolio of Excel automation projects. - Excellent understanding of data manipulation and analysis within Excel. - Ability to work with user-generated input and create a seamless autom...

Basically I have this single 1 .doc File. In this file, there are 2 "words/sentences" that need to be changed. They appear in the document maybe just 3-4 times.... 1. - one is a code for a product, like ABC1234 2. - one is the description of this products like "Cat Epithelium" ... I already have an Excel file with all the 750 different variants... Can somebody help me out here? THanks

Exciting Opportunity for a Social Media & Digital Marketing Specialist! Are you passionate about social media, digital marketing, and community engagement? Dishefs is looking for a dynamic individual to join our team and drive our online presence to new heights. If you're creative, proactive, and ready to make an impact, this is the perfect role for you! Key Responsibilities: 1) Social Media Engagement: Create and customize Facebook, Instagram, and LinkedIn posts based on our event calendar. Post at least 5-6 times a week, focusing on kitchen rentals and restaurant marketing. Actively participate in relevant groups, interact with members, and grow our organic following by 7-10% monthly. Experiment with new strategies and creative ideas to enhance engagement...

...experienced PowerApps developer to create a PowerApp that mirrors my Excel Online spreadsheet. This project involves: - Replicating the first three tabs of the spreadsheet (SLS Input, jSKU input, PB input) within the PowerApp. - Ensuring all functionalities of the embedded macros in the Excel are integrated into the PowerApp. - Implementing the ability to add/edit rows in separate SharePoint Lists. This project is the first phase of a larger initiative. If the initial project is successful, there will be further opportunities for development into dashboards and automation using PowerBI and Power Automate. Ideal skills for this project include: - Extensive experience with PowerApps and SharePoint. - Proficient understanding of Excel Online and its e...

I'm seeking a data analyst with a strong background in operational metrics and excel spreadsheets. The primary goal of this project is to analyze our operational data with the intent of improving our presentations. Key Areas of Focus: - Data analysis: You will be tasked with scrutinizing our operational metrics to identify potential areas for enhancement. - Performance improvement: The aim is not just to collect data, but to derive actionable insights that can lead to tangible improvements in our production process.

**Please post your correct bid account. We are seeking a highly motivated and creative Virtual Assistant to join our team. The ideal candidate will excel in managing social media content, creating engaging campaigns, and overseeing ad accounts with a special focus on the supplement industry. If you have experience in driving results for supplement stores or related niches, we want to hear from you! Responsibilities:Plan, create, and manage engaging content across multiple social media platforms (Instagram, Facebook, TikTok, etc.).Develop creative strategies to boost engagement, reach, and brand and optimize ad accounts (Google Ads, Facebook Ads, etc.) to maximize trends in social media and apply them to create innovative , analyze, and report on

I need someone to organize my tax receipts into an Excel sheet. Group them by month Jan 2024, Feb 2024, etc....into food, gas, etc. So each month Ill know what i spent total on gas, food, vehicle repairs, office supplies etc in that month. If there is something you dont know then put it in a mics section for that month. Should take less than 2 hours easily.

I require an Excel-based scorecard for my small team. This scorecard should track both year-to-date and monthly performance, with priority weights differing for each team member. - Team Size: There are only 4 members in the team. - Priorities: There are 5 priorities, with the weight for each specified in Tab 3. - Visualization: All data should be presented in a table layout. The scorecard should specifically include metrics on productivity. As such, an ideal candidate for this project would be someone with robust experience in Excel, data visualization and performance tracking. Thank you for your assistance.

...high-quality products. My previous experiences have provided me with deep-rooted understanding and practice in troubleshooting and problem-solving within pressing deadlines. Over the years, I've developed an instinct for creating intuitive user interfaces while ensuring that the backend is robust and secure. On this project, my goal will be to refine your existing design, seamlessly integrate APIs, and enable dynamic content rendering. My proficiency with HTML5, CSS3, JavaScript, and Sass will allow me to not only meet these requirements but to bring fresh ideas and insights to elevate your website's functionality and aesthetic appeal. Moreover, I'm well-versed in using Context API which can prove beneficial for the collaboration at hand. With my ...

...(New, Used, and Repair Service options) Project Scope: Extract product details from provided sources (websites, PDFs, or spreadsheets). Organize data into a structured format for easy import into our database (e.g., Excel or CSV). Ensure accuracy and completeness of all extracted information. Requirements: Proven experience in data extraction and handling. Proficiency in tools like Python, Excel, or other scraping software. Attention to detail to ensure error-free data entry. Ability to manage large datasets efficiently. Deliverables: Completed dataset with part numbers, manufacturer names, and pricing details for all conditions (new, used, and repair). Documentation of the extraction process (optional but preferred). Additional Information: If famili...

...its online platforms, and skills in creating interactive and user-friendly interfaces. Key Features: - Integration with major chess websites: Open source website - A platform that pulls puzzles from user's own game history, or any user name inputted. - Allows users to save puzzles to return to later - Mimics platform to provide a similar and comfortable experience - Practice tactics from your own games or from other notable users such as Magnus Carlsen or Eric Rosen - Allow users to donate, a portion of which goes to and the rest to maintain and improve the website Skills and Experience Required: - Proficient in web development. - Familiarity with chess and its online platforms. - Experience in creating interactive websites. - Good understanding of user-friendly

I'm looking for a Windows-based standalone PHP web app that scans QR codes and compares them with an Excel file containing employee attendance data. The app should visually indicate whether an employee is scheduled to work with a popup alert. Key Requirements: - Well-documented source code The app should display a popup alert for each matching entry. - For non-matching entries, it should display an error message. Ideal skills and experience: - Proficiency in web app development, particularly for Windows. - Experience with QR code scanning integration. - Ability to work with Excel file data. - Skills in creating user-friendly interfaces with visual alerts.

I'm looking for a freelancer who can assist me with my sales data. The tasks primarily involve data entry, data cleaning, and data analysis. The dataset is relatively small, with less than 1,000 rows. Ideal skills for this project: - Proficient in Microsoft Excel - Experience in data entry - Strong data cleaning skills - Capable of performing data analysis Please bid if you have the required skills and experience. Thank you!

...and day-to-day court work efficiently. It should include tools for case management, client management, reminders, legal resources, and financial tracking. Additionally, the app should include ad services for revenue generation. Key Requirements: 1. Features 1. Case Management o Ability to add, view, and edit case details (case name, number, client, court, and stage). o Upload and manage case-related documents. o Track case status (e.g., pending, ongoing, resolved). 2. Client Management o Maintain client profiles with full contact details and case associations. o Categorize clients (current, past, or prospective). 3. Reminders and Notifications o Set reminders for court hearings, filing dates, and meetings. o Push notifications for upcoming deadlines. 4. Expen...

Everything that was discussed will be carried out based on the documents sent.

...can manage various referral links for business loans, home loans, investments, credit cards, insurance, savings and current accounts. The app should be user-friendly for my potential clients, with features to apply for loans, track application status, and receive future EMI reminders. Key Features Include: - Daily progress reports sent to my email every 24 hours. Reports should include: number of new leads generated, customer information, potential revenue and revenue from successful sales, and customer ratings for ease of using app and willingness to refer app to others. - Strict adherence to KYC and AML guidelines with a focus on customer data safety. - A secure login system based on PAN/GST Number and Aadhaar OTP verification. - Simple interface for...

I have a set of flowcharts and process diagrams in Excel that I need converted into Visio. The complexity of these charts is moderate, with multiple steps and branches. Key Requirements: - Proficient in Microsoft Excel and Visio - Experience with converting flowcharts and process diagrams - Familiarity with standard Visio templates - Able to accurately represent moderate complexity flowcharts Please ensure that the flowcharts are converted using a standard Visio template. I can provide this template if needed. The ideal freelancer for this project will have a keen eye for detail and a strong understanding of flowchart and process diagram conventions.

I'm looking for an expert in Excel to assist me with creating Excel-based solutions.

I need a VBA script in Excel that will help me to import data into Word. The main purpose of this script will be to merge data from Excel into a Word document. Key Features: - The Word template will include text data, tables and spreadsheets, as well as charts and graphs. - The imported data will need to be formatted with custom styles, not just standard formatting. Ideal Skills and Experience: - Proficient in VBA programming. - Strong understanding of Excel and Word integration. - Experience with creating custom styles in Word. - Able to work with diverse types of data.

I'm looking for a personal assistant to help me manage my day-to-day tasks as a small business owner. While familiarity with my industry is not a strict requirement, a basic understanding would be beneficial. daily routine - ask everyone on which project-task they spend their time, update budget for project and timesheet (for hourly engineers) weekly routine - check timesheets for hourly project, and invoices - check progress for fixed-price engineers, update project budget and schedule, report update in a minute of meeting - Review the internal project folders and check if they are aligned with quality standards (the order is in the right subfolder, requirements, technical documentation) - update this list of routine and on-demand routine Supp...

I need assistance in renaming a set of JPG image files based on an Excel spreadsheet. Key Details: - The current naming of the image files is arbitrary, with names consisting of random numbers and letters. - I have a specific Excel spreadsheet that outlines the desired new names for these files. The ideal freelancer for this project should have: - Experience in file management and renaming tasks - Proficiency in using Excel - Attention to detail to ensure every file is renamed accurately.

I need 12 pages of mixed data (text and numbers) from a handwritten document entered into a specific A3 Excel template. Time is of the essence, as I need this completed within the next 2 hours. Requirements: - Proficient in data entry, particularly with mixed data. - Ability to accurately follow a template and specific formatting requirements. - Experience with Excel, particularly A3 layouts. Please note, I will provide the A3 Excel template that needs to be used. The data needs to be entered into specific columns and rows.

I'm looking to build a typing website that helps users practice their Hindi and English typing skills. The site will support various typing modes including timed, free typing, and competitive typing. Key Requirements: - The site should have a simple and clean user interface. - It should support both Hindi and English typing. - It should include features for timed typing, free typing and competitive typing. Ideal Skills: - Experience in web development, particularly in creating interactive and user-friendly websites. - Proficiency in Hindi and English. - Understanding of typing mechanics and user training methodologies.

We need an experienced data researcher with the following skills: 1) Experience in Internet Research 2) Good English skills 3) Knowledge of google sheets & excel 4) Attention to detail This is a long term project.

I am looking for assistance in automating the process of generating metrics to minimize human interaction and increase efficiency. My current approach involves the use of Excel Query, but I am open to exploring other Excel-based solutions if they offer better automation.

I am looking for assistance in automating the process of generating metrics to minimize human interaction and increase efficiency. My current approach involves the use of Excel Query, but I am open to exploring other Excel-based solutions if they offer better automation.

Looking for a freelancer experienced in Excel and VBA to develop a tool that automates the creation of Sorare teams based on data from three sheets: "Sorare Bot," "Classifications," and "GW." The tool should: Generate valid 5-player teams for competitions following specific rules (positions, exclusions, etc.). Organize teams into blocks categorized by competition. Create a list of unused players with exclusion reasons. Include a button to update the "GW" sheet whenever the other sheets are modified. Skills Required: Advanced Excel and VBA expertise. Data processing and automation. Attention to detail for applying prioritization and exclusion rules.

I'm looking for a professional to help extract specific healthcare data from a country of my choosing (I will provide in chat) and guide me through the process(coding part). The data of interest includes: - Doctor's Name - Registration Number - Practicing End Date - Specialty - Place of Practice - Address of Place of Practice -Contain 18480 Record The final output should be delivered in a CSV file. I will provide the specific sources or databases from which to extract this data, which may include government health sites, public health records and medical association databases. Ideal skills for this job include data extraction, data analysis, and proficiency in working with CSV files. Previous experience in extracting healthcare data would be a sign...

Project Overview We want to create a complete mechanical design for a mini tractor utilizing a 7 HP diesel engine. The project deliverables will include conceptual sketches, 3D CAD models, engineering drawings, bill of materials (BOM), and detailed instructions for fabrication. Key Objectives: Design a sturdy yet compact frame to house the 7 HP engine, transmission, and differential. Provide multiple forward gears, reverse gear, and PTO capabilities. Ensure maneuverability in small farmland or narrow pathways. Incorporate safety elements and easy maintenance features. Scope of Work & Deliverables Phase 1: Requirement Analysis & Conceptual Design Requirements Gathering Discuss and finalize key requirements: Overall dimensions, power transmission layout, PT...

...tailored software solution for my Chartered Accountants office. This software will primarily focus on reporting and analytics, while also automating various tasks. Key Features: - Master entry of Client including KYC, Inward-Outward Register, Task Assignment, Quotations, Appointment Letter, Acceptance Letter, Engagement Letter, Management Representation Letter, NOC of previous auditor, Staff KYC, Etc. - Robust reporting and analytics capabilities - Automation of email notifications, data entry, scheduling, and other statutory records Integration: - Seamless integration with Excel sheets for reporting and analytics Ideal Skills & Experience: - Proficient in software development with a focus on analytics - Experience with task automation software - Strong under...

Please Sign Up or Login to see details.

I'm in need of a proficient MS Excel professional who can assist me with complex formulas and functions, as well as creating charts and visuals. The primary goal of these tasks is to aid in financial modeling using sales data. Key Responsibilities: - Apply complex Excel formulas and functions for financial modeling. - Create detailed and informative charts and visuals based on sales data. Ideal Skills: - Advanced expertise in MS Excel. - Proficient in financial modeling and data interpretation. - Capable of creating professional charts and visuals.

...hadn't actually read what I posted. Guys, don't waste my time bidding for this project if you are not serious. The project is actually simpler than I described below. You really need Sendgrid email experience and you need to read what I have posted below. ***************** We're seeking a Sendgrid specialist to review and make small improvements to our existing email templates and settings. While we already have people in our team familiar with Sendgrid and have drafted over a dozen email templates, we're looking for someone with strong experience to help refine padding, spacing, font styles, and improve the overall readability of our emails. This includes fixing cramped areas like our footer and identifying any best-practice adjustments tha...

Generate Leads of driving Schools in USA Deliver in Excel Sheet

I need an Excel expert who can help me analyze our sales data and identify trends. The main objective is to leverage Excel formulas and tools for data analysis. I have a considerable amount of sales data that needs to be examined. The ideal candidate for this project should be proficient in Excel, with a strong background in data analysis. Experience with analyzing sales data specifically will be a plus. Key tasks will include: - Utilizing Excel's advanced features for data analysis - Identifying and interpreting trends within the sales data - Providing clear, concise insights based on the analysis Please bid if you can help me find trends in my sales data using Excel.