Access excel vba samplecông việc

I need help with an Excel sheet that will be used for data analysis, specifically sales distribution. The sheet will include a mix of sales data, customer information, and product inventory. Key tasks: - Organizing and inputting the provided data correctly - Creating a system for sorting and analyzing the data - Developing a system for tracking sales distribution effectively - Potentially applying necessary calculations and formulas to enhance the data analysis Ideal Skills: - Proficient in Excel, including data analysis and financial functions - Experience with sales data and distribution analysis - Strong attention to detail and organizational skills - Ability to create formulas and calculations - Familiarity with customer information and product inventory management Ple...

...fields into an Excel (.xls) file. The database consists of approximately 150,000 entries. Each record includes data such as name, business name, contact information, date of foundation, etc. Ideal Skills: - Strong experience in Web Scraping - Proficiency in transferring data into .xls format - Attention to detail to ensure all available fields are captured Purpose and Deliverable: - The objective of this project is to use this information for data analysis. - The final output will be an Excel (.xls) formatted file containing each scraped database entry. Operation Specifics: - You would be required to locate and scrape the database by Zip codes. - A full export of all accessible information per entry is needed. Your expertise in internet research, data mining, and...

I am seeking a talented deve...promoting my business. Key Features: - Bulk Phone Number Verification: The tool should be able to check multiple phone numbers at once. It should separate the active numbers from the inactive ones. - Whatssap Compatibility: The tool needs to connect with Whatssap API to confirm the activity of the numbers. Delivery: - Data Export: I require the verified numbers to be exported to an Excel spreadsheet for easy access and use or .txt file Skills & Experience: - Proven experience in API integration, specifically with Whatssap. - Strong programming and software development skills. - Experience in building phone number verification tools will be a plus. Please provide examples of similar projects you have worked on previously. Looking forwa...

I'm seeking a meticulous freelancer who can assist in a data analysis project. This involves video analysis to capture specific information for my recognized need. Having a keen ...corresponding video sequence. This will aid in contextualizing the data and providing robust analysis. Additional video data required: - Time of vehicle appearance - Vehicle plate numbers The final information extracted should be conveniently organised in an Excel format. Experience using data entry tools like Excel is mandatory. Note: We use Unifiy Protect. So we would give you an Access as console user. Worklfow we want to use : check video on console put the plate(we have ai, put have to recheck by an human) and date to an excel save the video stream on google drive d...

...Shortest Path First (OSPF) for routing protocols. Your role will involve: - Designing and implementing complex network models - Configuring OSPF as the routing protocol - Assigning IP addresses across all devices - Installing and setting up firewalls to protect the network - Configuring VLANs to segment network traffic - Ensuring successful ping across all devices - Setting up VPN for secure remote access Solid knowledge and experience with OSPF and Cisco Packet Tracer are must-haves. Your expertise should ensure seamless communication within the network, as well as robust and scalable network security. Please note, the expectation is to implement complex network security measures, so candidates with experience at this level are preferred. AND ALSO I REQUIRE A SCREEN RECORDING ...

I'm looking for a freelancer with excellent attention to detail and proficiency in Microsoft Excel and Word. As part of this project, you will be required to manually enter data from Excel files into a Word document. Key Requirements: - Strong Microsoft Excel and Word skills - Proven experience in accurate, manual data entry - Ability to work with robust data sets Deliverables: A Word document with the data accurately entered from the provided Excel files. Your ability to deliver clean, accurately transcribed data is essential for the success of this job. Attention to detail is paramount. I look forward to working with detailed and skilled freelancers.

...modern looking school management system. Key Responsibilities: - Given the nature of the project, an aptitude for clean and contemporary web design is crucial. - Deliver complete website code and database. - Although it wasn't specified in the project outline, it is important to cater for possibly multiple user roles. This could include Administrator, Teacher, Parent etc., each with differing access rights and features. - Despite not having mentioned specific system features, suggested must-have features include student attendance tracking, gradebook management, and a system for parental communication. Ideal Skills: - HTML, CSS, JS expertise - User-centric design experience - Detail-oriented - Experience with database design and management - Experience developing mult...

I need an assistive hand in a data extraction task that requires sharp focus and meticulous attention to detail. The task involves: - Extracting email addresses from an Excel spreadsheet - Maintaining accuracy and precision during the data entry process, ensuring no data is missed or inaccurately entered Proficiency in Microsoft Excel is a must for this task. Previous experience in data extraction or data entry is highly desirable. You should be adept at handling large volumes of data, have a keen eye for detail, and are able to keep track of your progress systematically. Let me know your capacity per day/week as this can be an ongoing project. Please dont negotiate on the price beyond the Bid provided

For my company, I need an expert with extensive experience in data consolidation and import to QuickBooks. - The project involves the migration of the company's financial data for the years 2022 and 2023 which is stored in Excel spreadsheets currently. - The data needs to be consolidated into a single file before importing into a new Quickbooks instance. As an ideal candidate, you should have: - Experience with Quickbooks data import - Excellent understanding of data consolidation - Proficiency with Excel spreadsheets - A keen eye for detail and the ability to maintain the integrity of financial data during the import process.

...the accuracy of the (choosen) model in predicting if a respondent will subscribe to the term deposit (No vs Yes) offered by the bank. Use all the knowledge that you have gained in class on KNN-classification to address this problem. You are free to choose (i) which independent variable(s) to use, (ii) whether you want to estimate the classification model using the entire sample observations, or splitting the full sample into training and testing sets, and (iii) the optimal k-neighbor value. But you must be prepared to justify your decision. For example, if you choose the optimal k-neighbor value = 3, then discuss the rationale behind it....

...keeping users up-to-date on contract status. - Reporting & Analytics: Sophisticated tools for generating detailed contract reports and analytics. - Payments Tracking: Ability to track payments stemming from each contract. - Supplier Account Statement: Functionality to maintain and access supplier account statements. - Editing Contracts with Variables: Flexibility to modify contracts with various variables. The software is to be used by a team of 1-10 people, making it important to have multiple levels of access controls. Ideal freelancers should have experience in programming and software development, with specific skills in building contract or document management systems. A strong understanding of data security is also recommended for the storage feature. This proj...

I need a large quantity of sticker designs, 1 new design every week. They are designs for collectible toys, you can look at the folder for samples: SAMPLE GRAPHICS. The designs have to be high quality like the samples provided. Here is the file folder with the DESIGN SHAPE AND SIZE, many SAMPLE GRAPHICS, and the 6 CAR COLORS. I will need the RAW Photoshop file. Successful winner of this bid will have a contract to produce 1 new design every week. You can view all the files here:

I'm in need of an experienced Excel professional to help me build a secure data management system. This system will be used to handle both financial and customer information. Key Requirements: - **Data Security**: A robust system that ensures the privacy and integrity of the financial and customer data. - **User Management**: The system should be designed for 1-10 users, allowing them to access and input data securely. - **User Experience**: While the users are expected to have advanced Excel skills, the system should be designed with clear interfaces and user-friendly features. Ideal Candidate: - Proven experience in designing secure data management systems in Excel - Proficiency in VBA and Excel's advanced features - Strong understanding of...

I am looking for someone who can effectively install a simple server on Ubuntu and configure Wireguard / WG admin panel along with pihole. Your tasks will be; - Configuration of a fully accessible Wireguard WG admin panel - Setting up pihole on the server About 10/20 mins work depends Full access will be given Those who have prior experience in Linux server installation, Ubuntu system management and Wireguard configuration are highly desirable. An understanding of pihole configuration will be a plus. Complete details will be shared once I identify the right professional.

I'm seeking a Wordpress expert to help me create a custom shortcode that can add products to the WooCommerce cart and then redirect to a specific page. Key Requirements: - The shortcode needs to perform both functions: adding products to the cart and redirecting to a designated URL including having GET...cart functions. What I believe is happening at the moment is, the shortcode logic is executing but AFTER the page has loaded which results in the add to cart logic failing. For your reference, the shortcode is called "prs_change_registration_transact_sc". The code is attached for your reference. I can provide access to a staging website if need be, but a professional WordPress and WooCommerce programmer should be able to see the issue immediately and help me fix ...

Answer the question at the top of your bid. What is 0.2 + 0.1 in JS ? We are a company that sells mobile accessories online that currently runs our website with Prestashop but now decided to build a new website with Magento. We have thorough knowledge in building websites and have so far created a new website and installed the theme Hyvä and set up some sample product to work with. We now want help to create some new features. - We want to have a droplist with all the variants of The Configurable Product but still keep the original texts and links for the Simple Product. The Configurable Products is hidden and we only want to show each Simple Product separately, but inside the Simple Product there should be a droplist with all variants. When you select a variant, we want yo...

Our website is: [Enter URL] We will provide the following information as needed: - Facebook Business Manager access - Facebook Pixel and Product Catalog assets - Website administrative access including tag managers & online platforms

I am not able to access my cPanel, my website, all emails also down. I need to get it up and running as soon as possible. If you are able to help, please let me know for this small project

Hi, I need a rendering website 1-3 pages max. sample. Please use good quality images and website should be fully secure.

I'm looking for a skilled software developer to create a comprehensive control system for my greenhouse environment. Key Functionalities: - Temperature, humidity, light, fan, CO2, and irrigation control - VPD, nutrient dosing, and pH control User Interface: - I'm interested in a web-based interface for easy access and usage Additional Requirement: - Remote monitoring and control capabilities are a must. Ideal Skills: - Experience in developing similar systems - Proficiency in web-based software development - Knowledge of greenhouse environmental requirements Please provide your relevant experience and how you plan to address the functionalities I've outlined.

I am in immediate need of a professional with proven experience in writing legal Partnership Agreements. Specifically: - Proficiency in drafting Partnership Agreements is crucial. - The agreement must excel in providing measures for protecting sensitive information. - Understanding of confidentiality and data protection is mandatory. I am expecting work that is thorough, legally sound and protects my interests optimally. It is not about just getting it done but getting it done right. Previous experience with such documentation is a solid advantage. Kindly share your portfolio when applying. Accuracy, attention to detail, and understanding complex legal terminology are the skills that I am looking for. NB: Experience with sensitive information protection will be a bonus.

I have excel file where I want to clean. Merge columns and make it simple. You have to be able to fix it within 30 min not more

I am in search of a cybersecurity professional who can...in the area of Network Security and Zero Trust Network Access. Your responsibilities will entail: - Securing my network against any potential threats and vulnerabilities - Implementing an effective Zero Trust Network Access system The ideal freelancer for this project would have: - Strong experience and expertise in network security and Zero Trust Network Access - Understanding of cybersecurity best practices - Demonstrable experience in protecting sensitive information and preventing cyber threats. Please note, familiarity and experience with any specific cybersecurity framework (NIST, ISO 27001, or CIS) is not necessary for this project. Your primary task will be to safeguard the network and implement Ze...

We have a large internal-use-only business automation site, that our staff uses 24/7. We have some 70 pages. The design of them is very simple and we want to improve it. We need to unify the design of the pages and make them more visually appealing and also easier to use and clearer for our staff. This job is NOT to design the entire site, it's just to review what we have and send us a sample of how you could help us redesign. We will pay for 2 or 3 hours of work here, from several selected vendors, and then choose the one that we like to finish the job.

I'm in need of a creative and efficient Web Designer who can implement a user-friendly, Web-based app and a reservation focused website. Key functionalities to be integrated include: - Push Notifications: Active alerts to keep users engaged. - In-app Purchases: Safe and secure transactional processes within the app. - User Accounts/Profile Creation: Personal user space for convenient access and interaction. Candidates should ideally be experienced with reservation systems, e-commerce applications, and creating user-driven interfaces. Proven excellence in Web-based app development is a must. Familiarity with contemporary design styles and layout trends is highly appreciated. The right candidate will have a practical understanding of UX/UI design principles and be able to cre...

... The information required includes details on the CEO, senior management, and email addresses. The data should be compiled into a spreadsheet, such as Excel or Google Sheets, with separate columns for each piece of information. Key Responsibilities: - Researching and collecting information on the CEO, senior management, and email addresses of around 80 councils. - Ensuring the accuracy and relevancy of the data collected. - Organizing the data neatly into a spreadsheet, in a format suitable for subsequent upload to a CRM tool like Pipedrive. Ideal Skills and Experience: - Experience in data research and entry. - Proficiency in using Excel or Google Sheets. - Familiarity with CRM tools, particularly Pipedrive, is a plus. - Attention to detail and the ability to maintain d...

I'm looking for an experienced VBA coder who can focus on two main tasks. 1. **Fixing Existing Issues:** - My current VBA code has issues with execution errors and incorrect results. I need solutions to these two problems. 2. **Adding Modifications:** - I'm looking for someone who can add additional features to my existing VBA code. - Good user experience is important too so improvements on the user interface would be very beneficial. Ideal candidates will have an excellent understanding of VBA syntax, debugging, and error handling. Experience with user interface design is also appreciated. The aim here is to produce accurate calculations, formatted data or reports swiftly and easily.

We don't want our employees to see the phone numbers of customers on whatsapp and chat with them. We just want to restrict whatsapp usage to making calls only without visibility of the numbers. So best is that if the GUI of WhatsApp Desktop is not visible and we access it using another app. Either from browser or another windows app. Alternative is that we do this with android app

I'm in need of a skilled design professional to refine and elevate an existing design using Squarespace. Specific improvements I'm looking for include: - looking to take an existing design created from templates in squarespace - changing the navigation to put the design behind members only access (100 members max) - no SEO required - limited number of pages - a simple information site collecting pdfs and documents for download by members - inital site created by a complete novice without required skills to complete - estimate initial 6 hours work I want to ensure the end result speaks to the unique identity of the project, providing user-friendly navigation and robust functionality. To apply for this project, freelancers should be able to demonstrate: - E...

Don't show the whatsapp app or atleast hide the numbers and don't allow users to access chats. Only allow whatsapp calls with no number visibility and settings change. The goal is to allow users to make whatsapp calls only to the saved contacts only. So can you modify whatsapp or run in hidden mode to use it using another app.

As a client seeking to create a detailed and useful content on business report writing, I am in need of a diligent freelancer who can create business report writing sample blogs. While I haven't specified particular topics or a target audience, the successful freelancer must have a versatile writing skill that can cater to a broad range of readers, whether they be students, professionals, or business owners. Key Responsibilities: - Generate blog posts that serve as concrete examples of outstanding business report writing. - Craft content that educates readers on different elements of business reports, potentially covering topics such as report structure, data analysis, and presentation techniques. - Showcase your prowess in report writing, demonstrating a high level of know...

...required 1. Admin 2. Customer 3. Vendor 4. Random user Few more requirement as below 1. Dashboard for admin 2. Reports for admin and vendor 15 nos 3rd party integrations 1. SMS/whatsapp 2. Email 3. Calling service like Uber 4. Payment gateway Features in modules 1. Admin * Login. Option to create new ids * Dashboard * Setting up price for the product. * Tax module * User Access Module * To create new users for admin * To create new vendor users * Reports * Delivery status of product * Qr generator * QR printer * Handling of failed transactions * Auto mailer to admin user of the performance and to customer for promotions 2. Customer 1. Otp based login and signup 2. Change password 3. Profile ma...

Hello, I am in need of a developer capable of creating an Excel tool (.xls format) for efficient management of large amounts of data. The tool should have the following features: Storage of large datasets: The tool should enable storing a large quantity of data. Duplication removal: It should be possible to remove duplicates in Excel files to maintain a clean and organized database. Standardization of French numbers: All French phone numbers in the files need to be modified and put into the correct format, such as +33780000000. Editing and export: Users should be able to edit data in the Excel file and export the changes made. Archiving: Once the data is used, it should be possible to upload it to an archive for future reference. I would greatly appreciate it if you co...

I am looking for a skilled freelancer who can deploy the Nextcloud app on Azure-joined devices. The devices are operating on Windows 10 and macOS. The project involves deploying both versions of Nextcloud - as a WEB application and as a Native Desktop application. Here are the key points: - Deploying the Nextcloud app through Intune as a Win32 app. - Incorporating conditional access to the app via Multi-Factor Authentication (MFA). - so this also means if I disable a user, then the desktop app will ask them to sign in again or will not work Ideal Candidate: - Proficiency in Azure and Intune for app deployment. - Knowledge in configuring MFA. - Experience in working with Windows 10 and macOS. - Understanding of both Native Desktop and Web application deployment. I expect users to ...

LINE WORKS is a popular business communication tool, mainly in Japan. You dont need to it or know Japanese to help me get an access token though. I urgently need someone who can provide me with a LINE WORKS access token for my backend. The process is cumbersome and involves several times of sending data in specific formats back and forth, but it should be easy for someone familiar with the process. I will give you the specific IDs needed before you start. The instructions on the LINEWORKS dev page are only in Japanese, so you need a translation tool. Here is the link> Key Requirements: • Expertise in Lineworks API • Proficiency in Python • Ability to deliver within a tight deadline

I'm in need of a Pivot table in Excel to analyze my sales data. This will help me track and understand key metrics like units sold and profit margins. Key Project Details: - Data: Primarily sales data - Metrics: Primarily interested in tracking units sold and profit margins - Organization: The data should be organized by product and region Ideal Skills & Experience: - Advanced Excel proficiency, particularly with Pivot Tables - Strong analytical skills for identifying key metrics - Experience working with sales data is a plus - Ability to understand and visualize data in a meaningful way.

I need a freelancer to help convert my scanned PDF document into Excel format. The Excel should have the same layout as the original document in the PDF: - Expert in scanned document conversion to Excel is required as the document isn't text-based. - Advanced knowledge in layout replication is necessary because the converted Excel file needs to have the same structure as the original PDF. - Since the PDF contains unknown special data types, ability to deal with potential complexities (like images, graphs, complex tables) would be a plus. The ideal freelancer for this project should have a proven track record in PDF to Excel conversions and dealing with scanned documents. Bonus points for experience with complex data types.

I am in need of a proficient freelancer with expertise in data cleaning and data analytics to handle an upcoming project involving Excel. Specifically, the tasks will involve: - Removing duplicate entries, - Correcting inaccuracies in data as needed, - Formatting data to enhance its visual interpretation. The next part of the project involves data analysis, where the focus is on: - Creating data visualizations, particularly concerning the sales trends in our dataset. A background in Excel-based data correction and visualization is essential. Ideally, you've had previous exposure to sales data and are capable of understanding and predicting trends. Your bid should reflect your ability to accurately complete these tasks in a timely fashion.

We are seeking an experienced penetration tester to join our team. As a penetration tester, you will be responsible for identifying and exploiting vulnerabilities in our systems to ensure they are secure. Your main tasks will include conducting vulnerability assessments, performing penetration testing, and providing recommendations for remediation. To excel in this role, you should have a strong understanding of various testing methodologies, possess analytical skills to interpret test results, and be familiar with a wide range of penetration testing tools and techniques. Skills required: - Penetration testing - Vulnerability assessment - Ethical hacking - Knowledge of network protocols - Familiarity with security frameworks - Strong problem-solving skills This is a medium-sized ...

In this crucial project, we aim to significantly improve the cybersecurity of data stored on the Google Cloud Platform (GCP), using cutting-edge artificial intelligence methods. Our main goals are as follows: - Use Machine Learning and Deep Learning to detect and mitigate any potential cyber threats before they occur. - Utilize AI to predict and intercept Unauthorized Access, Data Breaches, and Malware Attacks, thereby bolstering our defense mechanisms. The ideal candidate will be proficient in AI, specifically Machine Learning and Deep Learning, and have extensive knowledge of cybersecurity on clouds. Experience with GCP would be a valuable advantage. It's essential for the chosen freelancer to be adept at translating complex AI algorithms into practical cybersecurity soluti...

I need a C# .NET app that can access real-time stock data. The ideal candidate should have experience with Alpaca API and Blazor Tailwind CSS. I already have 2 small skeleton projects to start with, using Highcharts in Blazor. Key Features: - Accessing real-time stock data from Yahoo Finance, and trade information from Alpaca - Supporting basic trading functionalities including Buy/Sell orders, Portfolio management, and Price alerts - Displaying Highcharts Please include some examples of similar projects you've worked on, and how you would approach the integration of the specified features in your bid.

...particularly keen on making sure it's not leaked or shared. Key elements of the project: - The course content should be accessible only on limited pre-defined devices. I want to prevent unauthorized sharing or downloads. This could involve IP or MAC address restrictions, or other secure protocols that you would recommend. - Password protection should be implemented to ensure only paying customers can access the content. - I am also looking to incorporate discussion forums into the course. This interactive element is crucial for fostering a community around the course material and enhancing the learning experience for my customers. Ideal skills and experience: - Proven experience in web development with a focus on e-commerce and secure content delivery. - Familiarity with ...

I urgently need to extract the emails from Excel and place each one in a separate cell. In the image, you have an example of what I want.

...list of the services offered by the agency, including • in-home care • personal care • companionship • meal preparation • medication management, etc. Each service should have its own dedicated page with descriptions. 3. About Us: Information about the homecare agency, including its history, mission, and values. 4. Client Portal: If applicable, a secure client portal where clients can log in to access important information, schedule appointments, communicate with caregivers, etc. 5. Testimonials: Real testimonials from satisfied clients or their families can build trust and credibility for your homecare agency. Consider including photos and/or videos if possible. 6. Contact Information: Clear contact information, including phone number, email address, an...

...acre farmers. The site should serve as a detailed resource, highlighting key aspects of our work and organization. Key Features: -A professional look and feel `-Wordpress based - A comprehensive "About Us" page to outline our mission, goals, and team. - A clear display of our contact information on every page. - Easliy updated by ourselves with graphics based on data collected and stored in MS Excel -Potential for client login The perfect candidate for this job would be an individual with a keen eye for modern web design, experience building informational websites, and ideally some knowledge in Australian agriculture. Good communication skills are necessary, as you'll be expected to collaborate with our team closely. A successful end result would result in a u...

I'm looking for an Excel expert to help me clean up a dataset. I have a large dataset that contains both text and numeric data that needs to be cleaned up. The specific issues I'm facing are: - Text Data: There's a need to find and remove any duplicated values, missing values, and correct any formatting issues. - Numeric Data: The numeric data in the dataset has inconsistent decimal places and a few outliers that need to be identified and adjusted. Ideal skills for this project include: - Proficiency in Excel, particularly in data cleaning and data analysis. - Experience in handling both text and numeric data. - Strong attention to detail to identify and rectify issues within the dataset. Please, only apply if you have experience with similar tasks and ca...

...authentication, access to user profile data, and the ability to publish to the user's timeline, pages and groups. You need to create the app with these permissions and get the approval so that we can integrate the functionality in your website. for facebook permission needed: public_profile pages_show_list pages_manage_engagement pages_manage_posts pages_read_engagement pages_read_user_engagement Your app user must be able to perform the CREATE_CONTENT, MANAGE, and MODERATE tasks on the Page in the API requests. Key Responsibilities: - Assist in the development of a social networking app on Facebook - Provide guidance and support on ensuring the app meets Facebook's guidelines - Ensure the app is equipped with necessary security measures - Implement user authentic...

I need a seasoned web developer specialising in building educational platforms. The aim of this project is constructing a web app for a tutoring platform tailored for school student...platform will mainly focus on All subjects Ideal freelancer would: - Have previous experience creating educational apps - Be capable of integrating a chat system (e.g. GPT tech) - Understand the unique needs of a school-age audience - Have knowledge or interest in Maths and Sciences sectors By implementing these features in an easy-to-navigate interface, we'll ensure that students can both have access to tutoring resources and effectively communicate within the platform. Your role will be instrumental in nurturing our young learners' skills, and in making education less stressful and more...

I'm in need of a skilled typist for a data entry project. The task involves entering data into an Excel spreadsheet. Requirements: - Excellent typing speed and accuracy. - Previous experience with data entry. - Proficiency in Excel. - Ability to follow instructions precisely. Ideal Candidate: - Proven track record in data entry tasks. - Strong attention to detail. - Reliable and able to meet deadlines. - Good communication skills. If you have the right skills and experience for the job, I look forward to receiving your bid.

I'm searching for a seasoned mobile app designer and developer. This project involves creating a fitness/yoga membership app for both iOS and Android platforms. Key Functionalities: - Online Training Sessions: Users should be able to access, participate, and save fitness training videos. - Diet Planning: The app should include features for creating and monitoring meal plans, incorporating nutritional information, and tracking calorie consumption. - Progress Tracking: The app should allow users to track their fitness progress, log their workouts, and monitor their diet. Ideal Skills and Experience: - Proficiency in iOS and Android app development - Experience with multimedia content integration for online training - Previous work on fitness, health or wellness apps would ...