Excel vba work sheet jobs
I'm in need of a professional to help populate my BIGIN CRM with contact information from an Excel file. The task will involve: - Transferring data from Columns A, B, C of my Excel file to BIGIN CRM. - Achieving appropriate data segregation based on geographic location within the CRM. This task will require a keen attention to detail and strong experience in and BIGIN CRM and integrate emails to Outlook. A solid understanding and experience in data segregation & bIGIN PLATFORM is also key for successful delivery of this project. The aim is to streamline my contacts for easier management. Your keen knowledge of geography and ability to dissect contact data is highly needed.
I'm looking for an Excel expert to help me create a comprehensive tool that will serve as a project scheduler, lead manager, and accounts system. Specifically, I'd like the tool to have the following features: - **Project Scheduler** - Task tracking: I need to be able to input tasks and track their progress. - Gantt chart: Visualization of tasks and their timelines. - Resource allocation: The ability to allocate resources to tasks and track their usage. - **Lead Manager** - Lead tracking: The tool should allow me to input and track leads. - Contact management: I need to be able to store and manage lead contact information. - Sales pipeline: Visualization of the sales pipeline, including lead progression and conversion rates. - **Accounts Management** - Ex...
I'm seeking a proficient data handler with deep knowledge in Google Sheets, for management of my product sales data on a daily basis. In terms of the actual information required, the sales quantity, sales revenue, and product pricing data are crucial. Please ensure that you're able to accurately u...crucial. Please ensure that you're able to accurately update these specifics daily in a well-organized manner. Ideal Skills: - Data manipulation and organization - Proficiency in Google Sheets - Attention to details - Ability to deliver timely updates Your responsibilities will include but not limited to: - Tracking and updating product sales data regularly - Daily reporting of data in the Google Sheet - Management and organization of data Who can achieve these tasks ...
I'm looking for a skilled professional who can create more than 10 bar charts for a PowerPoint presentation. Requirements: - Proficiency in Microsoft Excel - Experience in visualizing survey results - Strong understanding of chart design principles The charts will need to visually represent survey data in a way that's engaging and easy to understand. Your role will be crucial in transforming raw data into meaningful insights. Please include relevant experience in your bid, and share any similar projects you’ve worked on in the past.
I have a PDF document that needs a fresh, minimalist redesign. The purpose of the single page document is to clearly show our easel users the different "T-Bar Arm Configurations" for attaching different size and shapes of canvas to our rotating easels. We refer to it as a "cheat sheet". Key Responsibilities: - Redesigning an existing document to have a professional, clean look - Ensuring the document remains instructional and easy to follow - Change over logo from "artristic studio" to "artristic rotating easels" (see attached) - Update minor text changes - Refer to our website and social pages @artristiceasel for design inspiration - Providing the final design in PDF format Ideal Skills and Experience: - Graphic design with experience in c...
...application. This tool will structure reports from user inputs and is required to be fully compatible with Microsoft Excel. Therefore, proficiency in Excel-integrated application development is essential. Key Tasks and Specifications include: - Designing and coding a desktop application for report generation - Ensuring the application can accurately convert user input data into structured reports - Implementing compatibility with Microsoft Excel for the accessible and seamless transfer of data The ideal freelancer for this project has a strong background in software development, particularly with creating desktop applications and working with Excel. Experience with coding Excel-integrated apps and understanding of user-friendly UX design would set yo...
I'm in need of an Excel Expert to create a functional and visually cohesive form for my company. The form should have various action buttons and cell locking features to ensure data integrity. Key Features Required: - Action Buttons: The form needs to have a 'Submit' button for data submission and a 'Clear' button for form reset. - Time Store Function: This unique feature should automatically calculate time spent on the form, store time values in a specific cell, and generate a report of time spent. Its implementation should be seamless and user-friendly. - Cell Locking: Certain cells in the form must be locked to prevent accidental changes. This is crucial for the form's operational integrity. Design Requirements: - The form should be designed using...
I'm in need of a website that is secure and provides my clients with the ability to register and login. The key features of the site should be: - User registration - User login - User profile creation My clients should also be able to access an Excel file on our Onedrive cloud and extract pricing information from there. Finally, they should be able to submit their orders directly to us via email. This includes order details such as description, price, and delivery instructions. Additionally, clients should be able to attach relevant files to their orders. The ideal candidate for this project would have vast experience in secure website development, Microsoft Onedrive integration, and email integration. Familiarity with order processing systems would also be a key advantage.
Hi Zubair Ali S., I noticed your profile and would like to offer you my project. We can discuss any details over chat.
...tasks primarily centered around Excel and Word. - Excel: The emphasis will be on crafting sophisticated formulas and performing financial projections. I need someone with an understanding of finance and the ability to manipulate data in Excel. A depth of knowledge in Excel formulas, calculations, and data analysis is crucial. - Word & PDF: Apart from Excel work, there is a need for expert formatting and layout design skills in Word, as well as converting Word documents to PDF format. Finally, I am seeking someone who can apply a professional design to a CV. The style I want to embody is professional, and therefore a good understanding of professional layout design and typography will be beneficial. Ideal candidates should have profic...
I'm in need of an expert in Excel for data entry and cleaning. The tasks involve handling text-based, numeric, and date & time data. Key Responsibilities: - Perform accurate data entry - Cleanse and format the data as needed Ideal Skills and Experience: - Proficiency in MS Excel - Proven experience with data entry and data cleaning - Attention to detail - Ability to work with various data types, including text-based, numeric, and date & time data
I am in urgent need of a meticulous freelancer to assist with data entry and the organization of several Excel spreadsheets. Your primary task will involve entering data from various not-specified sources into Excel, as well as categorizing and structuring this data in a logical and efficient manner. Desirable Skills & Experience Required: - Mastery of Excel functions and formatting features - Strong attention to detail and accuracy - Proven experience in data entry - Ability to work with limited supervision - Data analysis and detection of irregularities is considered a plus. The task doesn't necessarily require prior relevant experience but being familiar with Excel and data structuring principles would be advantageous. Due to the nature...
I need assistance transferring my handwritten notes into a digital spreadsheet. Ideal skills and experience include: - Proficiency in data entry - Ability to decipher handwritten text - Expertise in spreadsheet software, such as Excel or Google Sheets
As an advanced Excel user, I'm looking for a professional who can help me with two specific aspects of my project: performing advanced data analysis and creating macros to automate repetitive tasks. Key Requirements: - Data Analysis: You should be well-versed in data visualization, statistical analysis, and data cleaning and manipulation. Your ability to extract insights from complex data sets and present them clearly is crucial. - Macro Development: You will be responsible for automating repetitive tasks in Excel, including generating reports, automating data entry, and creating efficient formula calculations. Your macros should be user-friendly and easy to maintain. Ideal Skills: - Proficiency in Excel, including advanced functions and VBA programming ...
I'm seeking a Python developer who's proficient in web scraping to help me extract data from social media platforms. Key Responsibilities: ...help me extract data from social media platforms. Key Responsibilities: - Develop and implement a Python script for web scraping data from social media channels. Deliverable: - The scraped data should be compiled and delivered in an Excel spreadsheet for further analysis. Ideal Candidate: - Proficient in Python with a strong background in web scraping techniques. - Prior experience in scraping data from social media platforms will be a big plus. - Ability to deliver the end results in an organized, neat and easily accessible format, such as an Excel spreadsheet. Please reach out if you think you're the right f...
I have a requirement for someone adept at data entry and proficiency in working with PDF documents and Excel. My project involves converting a PDF document into Excel format. Key Details: - Source Document: The source document is a PDF which needs to be copied verbatim into Excel. - Structure: The data should be displayed in the Excel document exactly as it appears in the PDF format. No need to segregate into different columns based on the type of data. - Special Handling: There are no specific requirements for handling or formatting any particular data in the PDF document. Ideal Skills: - Experience in data entry and manipulation - Proficiency in Microsoft Excel - Ability to work accurately with PDF documents If you have these key skill...
I'm in need of a comprehensive contact list for Queensland-based mine sites. I'd like the list to include: - Company name and contact details - Mine site location and address - Contact person and title I'm looking for a high volume of entries, so ideally more than 50 mine sites should be included. The final deliverable should be an Excel spreadsheet. Ideal freelancers for this project should be experienced in data mining and collection. You should be thorough and detail-oriented to ensure all information is accurate. Knowledge of Queensland's mining industry would be a plus.
I have a requirement for someone adept at data entry and proficiency in working with PDF documents and Excel. My project involves converting a PDF document into Excel format. Key Details: - Source Document: The source document is a PDF which needs to be copied verbatim into Excel. - Structure: The data should be displayed in the Excel document exactly as it appears in the PDF format. No need to segregate into different columns based on the type of data. - Special Handling: There are no specific requirements for handling or formatting any particular data in the PDF document. Ideal Skills: - Experience in data entry and manipulation - Proficiency in Microsoft Excel - Ability to work accurately with PDF documents If you have these key skill...
I'm looking for an experienced Excel professional to help me set up a SUMIFS formula in an Excel spreadsheet with the following requirements: - The SUMIFS function needs to work with numeric matching criteria. - The source for the data is an Excel spreadsheet. - The most crucial aspect for this project is that the SUMIFS formula needs to be dynamic. It should update automatically as new data is added to the spreadsheet. Ideally, you should have: - Proven experience working with Excel SUMIFS functions, especially with numeric matching criteria. - The ability to create dynamic formulas that update with changes in the source data. - Strong attention to detail to ensure the formula is implemented correctly and efficiently. If you're confident in ...
I'm in need of a talented animator who can create an engaging 2D animated clip that explains the mechanism of molecules in hair. This clip will be used for marketing purposes and should be aimed primarily at adults. Ideal skills and experience for this project include: - Proficiency in 2D animation and motion graphics - Understanding of molecular concepts (particularly in relation to hair) would be advantageous, but not essential
I'm on the hunt for a...skilled Data Analyst who will work closely with our customer data, primarily formatted in Excel/CSV. The primary goal of this analysis is to identify trends and patterns that could aid our business processes. Key Responsibilities: - Deep analysis of customer data to identify patterns and trends - Create visually engaging and understandable reports Ideal Skills and Experience: - Proven track record as a Data Analyst - Comprehensive understanding of data analysis methodologies - Superior skills in Excel/CSV data processing - Ability to present complex information in an engaging and understandable manner. Your contribution will hugely impact our business decisions. I look forward to viewing your proposals. Please include samples of your...
Project Overview: The project involves reconciling sales data with weekly remittances over a span of 2.5 years in Excel. This requires merging multiple remittance files into one cohesive dataset, and then cross-referencing the sales data with the remittance data using a unique identifier (e.g., order number). The goal is to ensure that each sale corresponds to an accurate payout in the remittance, identifying any discrepancies or missing payments. Project Tasks: Data Collection: Gather all sales data and remittance files spanning 2.5 years. Ensure each dataset includes a unique identifier (e.g., order number) for matching. Data Merging: Consolidate all remittance files into one master remittance dataset. Arrange the data in a structured format for ease of analysis. Data Reconcil...
I'm seeking a driven sales assistant well-versed in multitasking. Your main responsibilities will include cold calling, lead generation and sales follow-up. My business resides within the marketing industry. Having knowledge of different marketing channels like social media, email marketing, consulting, content production, and digital assets is preferred. To excel in this role, here's what you need: - A strong background in sales particularly cold calling and lead generation. - Good understanding of multiple marketing channels. - Excellent follow-up skills to ensure effective sales conversions. Apply if you're ready to help drive growth in an active marketing environment.
...completion and enhancement of a CSV file for upload to Square. This extensive project requires three core competencies: meticulous data extraction from our website, proficient data entry into an Excel form, and the creation of engaging service descriptions using AI tools. The ultimate goal is to craft a CSV file that not only meets but exceeds the requirements for Square's platform, ensuring a seamless upload process. Key Responsibilities: Data Extraction and Accuracy: Initiate the project by extracting data from specific sections of our website. This data must be accurately transcribed into an Excel form, adhering closely to the required fields. Attention to detail is paramount to ensure that the information captured is both precise and aligned with our needs. Cont...
I need an experienced financial...include detailed financial projections based on the provided assumptions. - Operating model and capital structure: You will need to build a comprehensive operating model, and structure the capital in line with the LBO requirements. - Sensitivity and scenario analysis: I expect you to provide a detailed sensitivity and scenario analysis that is easy to interpret. - I have a CIM and a template excel sheet that you can use to create the model. I have other instructions as well in which I will provide after you bid. Time is of the essence, and I need this completed within 24 hours. Please only bid if you are confident in your ability to deliver accurate results in this very tight timeframe. This needs to be done in 24 hours or less, it cannot be...
...and accurately entering it into a spreadsheet. The data is not overly complex and primarily consists of straightforward text entries. - Skill with Spreadsheets: Proficiency in using spreadsheet software like Excel or Google Sheets is essential. The ability to accurately organize and input data into these platforms is crucial. - Attention to Detail: Precision is paramount. I need someone who can enter the data with great accuracy, ensuring that each entry is correct and in the right place. - Efficiency: While accuracy is key, speed is a factor too. I'm looking for someone who can work efficiently without compromising on the quality of the data entry. Experience: Previous experience with similar data entry tasks, particularly with text data and spreadsheets, is high...
I want to create Basic Vector Logo , A letter Head , And a Membership form FORM is in excel or PDF
...and accurately entering it into a spreadsheet. The data is not overly complex and primarily consists of straightforward text entries. - Skill with Spreadsheets: Proficiency in using spreadsheet software like Excel or Google Sheets is essential. The ability to accurately organize and input data into these platforms is crucial. - Attention to Detail: Precision is paramount. I need someone who can enter the data with great accuracy, ensuring that each entry is correct and in the right place. - Efficiency: While accuracy is key, speed is a factor too. I'm looking for someone who can work efficiently without compromising on the quality of the data entry. Experience: Previous experience with similar data entry tasks, particularly with text data and spreadsheets, is high...
About us: BA Marine is 3 years old company with a track record of USD 15 Million value of transaction of 60 vessels in GCC during the past 3 years and operated by the owner alone that generate 60 existing clients and 400 prospective clients. We are looking for bilingual speakers: Arabic and English for social media/ LinkedIn outreach. Your tasks include: -Screening existing Facebook and Instagram users by sending DMs using your accounts to check if they are interested in a certain boat by providing our boats database. -Approaching users on LinkedIn targeting C-Level, Doctors, Engineers etc who are based on Arabian Gulf seafront cities. -Inviting users on public groups or any other boat lovers communities to join our FB page or to follow us on Instagram. -Nurturing clients who inquir...
I'm seeking a data aggregator for a unique AI training project. Key Tasks: - Gathering text content from official website/source of the particular product/entity. - Focusing specifically on product descriptions, specifications, price and other attributes. Ideal Skills: - Basic searching skills - Able to follow given format of data collection - MS Excel or Google Sheets This project requires precision, and the information gathered will contribute to an AI's learning process. Accuracy in aggregation is, therefore, key.
I need help from an Excel specialist who can help me identify who has opened a shared Excel document that is located on Onedrive. I am trying to see when an employee accessed it last. - You'll need to create a solution that can track and log users who access the file. - The document is accessed by 2-5 people. - It would be beneficial if you could also provide a report or dashboard that can show this access data in a clear and concise manner. Please provide examples of similar work you've done in the past, and any relevant experience that you have.
Important: Project must be completed within 10 hours or less I have designed the attached company fact sheet in Excel. I would like help converting this to a Microsoft Word template. I need it to be flexible so that all the text and information can be changed and amended as needed, and I can change the charts. I have also attached the logos to be used.
I have an existing excel document that I would like to adapt to help with quotations & orders. Key Features: - The adapted document should automatically generate quotations, order forms, and perform the necessary calculations. - The excel file should have fields for product name, quantity, price, and customer information. Additionally, it should accommodate the inclusion of photos, and sizing information (a template image will be provided for reference). Calculations & Formulas: - The document should perform total price calculations, as well as tax calculations. Ideal Skills & Experience: - Proficiency in Excel - Experience with automated document generation - Exceptional skills in creating complex formulas - Attention to detail to ensure the documen...
Important: Project must be completed within 10 hours or less I have designed the attached company fact sheet in Excel. I would like help converting this to a Microsoft Word template. I need it to be flexible so that all the text and information can be changed and amended as needed, and I can change the charts. I have also attached the logos to be used.
I require an experienced Laravel developer to handle both frontend and backend development tasks for an upcoming project. Key Responsibilities/Task: - Backend Development: As I've not detailed the desired functionality for this at the moment, having experience in diverse backend tasks will be beneficial. - Frontend Development: Your focus will be on creating a responsive design and providing an interactive user interface. Ideal Skills: - Extensive experience with Laravel - Proven track record in frontend and backend development - Strong knowledge and experience with responsive design practices - The ability to create interactive user interfaces This project has a level of urgency attached to it, so I am looking for a dedicated professional who can hit the ground running.
I am seeking a proficient VBA developer to help me create a set of macros in Excel. The purpose of these macros is to automate the process of generating multiple files from a base Excel file, specifically for the task of data analysis. Key Requirements: - The macros should be designed to create multiple Excel files from a single base file. The output files should maintain the formulas, formats, and templates of the original file. - The macro should be designed to run on a monthly basis. - The output files can have the same format with different data. The ideal candidate should have: - Proficiency in VBA and Excel - Experience in creating macros for data analysis - Ability to deliver a reliable, efficient, and well-commented solution. I need this...
I'm currently on the lookout for an expert in Excel 2016, with a specialized focus on the creation of VBA. The end goal? Correct spelling mistakes across multiple worksheets in my data set. Given the language locale, proficiency in English (USA) is essential. In addition to this: - Strong attention to detail and accuracy skills are needed. - Proven experience of using Excel, especially dealing with multiple worksheets. - Experience in creating and executing VBAs effectively for similar problems. Do you believe that your expertise aligns with these requirements? If so, consider submitting a proposal.
I am looking for a software solution to extract exam questions and answers from PDF files and organize them into an Excel spreadsheet. The extracted data should be structured such that each question is listed in one column, its corresponding answers are listed in subsequent columns, and each row represents a single question and its answers. Project Requirements: PDF/Doc Parsing: The software should be able to parse PDF/Doc files containing exam questions and answers. Extracted data should include the question text and its associated answers. Data Organization: Questions should be listed in the first column of the Excel spreadsheet. Answers should be organized in subsequent columns, with each answer corresponding to the respective question. The number of columns for answers ...
I'm looking for a freelancer who can help me with the first stage of my data warehousing project, only 1st stage so it doesn't require a lot of effort. If your work is good, we can continue the rest of the stages! Key Requirements: - Data Integration: The main task is to bring in public datasets and integrate them into the data warehouse. - Reporting & Visualization: The data warehouse primarily serves as a hub for reporting and data visualization using Microsoft Power BI. Ideal Skills and Experience: - Proficient in data integration and ETL processes. - Experience with public datasets. - Advanced knowledge of Microsoft Power BI. - Solid understanding of the business needs behind data warehousing. What exactly I will need you to deliver in the 1st stage: -EXPECTATIO...
I am in search of a proficient data entry specialist based in LATAM who can help me with various data management tasks... and interpreting data. - Data Cleaning: Your role will also involve cleaning data sets to ensure they are free from errors and inconsistencies. - Data Verification: You will need to cross-verify data to guarantee accuracy and reliability. Preferred Tools: - Proficiency in Microsoft Excel, Google Sheets, and CSV file format is preferred. Ideal Candidate: - Prior experience in data entry, processing, and cleaning. - Familiarity with data verification methods and tools. - Proficiency in Microsoft Excel, Google Sheets and CSV file format. - Attention to detail and accuracy in data management. Please note that the estimated amount of data to be processed...
I am looking for an Asterisk/SIP expert to help me configure a SIP trunk. Specific tasks include: - Configuring the SIP trunk on my Asterisk server - Assisting with troubleshooting any issues that arise during the setup process Requirements: - Expertise in Asterisk and SIP configuration - Experience with setting up SIP trunks - Familiarity with troubleshooting Asterisk setups Additional information: - I already have a SIP provider - Ongoing maintenance assistance will be required after the SIP trunk has been configured.
I'm looking for a skilled professional who can create more than 10 bar charts for a PowerPoint presentation. Requirements: - Proficiency in Microsoft Excel - Experience in visualizing survey results - Strong understanding of chart design principles The charts will need to visually represent survey data in a way that's engaging and easy to understand. Your role will be crucial in transforming raw data into meaningful insights. Please include relevant experience in your bid, and share any similar projects you’ve worked on in the past.
I am in need of a freelancer who can swiftly handle two data entry projects. The tasks involved include: 1. Updating Gas Station Addresses: - The spreadsheet requires updating existing address data for about 80 gas stations based in Jamaica. - I have a specific format that I require this in, which I will share...creation of a comprehensive list of car makes and models, supplemented with brief, succinct descriptions of each car. - I have a list in word document, there may be some duplicates and there could also be more that I have not considered The successful freelancer need not have to be a subject matter expert, but should be able to undertake data entry tasks with accuracy and speed. Experience with Excel data manipulation and a keen eye for detail are ideal for...
I need help with a moderately complex data cleaning project. My spreadsheet data has missing elements that need addressing. What this entails: - Locating and dealing with missing data in the spreadsheets - Proposing solutions to prevent future missing data The perfect candidate would proficient in Excel or similar spreadsheet software, and have a keen eye for detail. Past experience with data cleaning would be advantageous.
I'm seeking a skilled individual to automate a series of tasks on Microsoft Excel, Sharepoint, Microsoft Teams and Email, using Pulover Macro and AHK where needed. Requirements include: - Automating a series of tasks in Microsoft Excel. This includes data manipulation, data analysis and reporting. The process is already mapped out and can be shared with you. - Using Pulover Macro and AHK, as well as VBA to facilitate the automation process. - Ensuring the automation process involves uploading files to Sharepoint, sending messages on Teams, and emails. The key deliverable for you is not just the completion of the automation process, but a clear and concise explanation of each step once the task is finished. This will be crucial for future troubleshooting and ind...
I have a list of contacts in an excel file, and I need someone to find their email addresses. - The main task will be to locate and verify the email addresses of these contacts. It is crucial that the emails provided are accurate. - The purpose of this exercise is for personalized outreach to these individuals and not for mass email marketing or research purposes. The ideal freelancer for this job is someone with excellent research skills, an ability to meticulously verify information, and experience in email marketing or personalized outreach. A high level of proficiency with Excel is also required. Files: There are lots of entries that need to be completed. you will need to add the email address of
We are looking for a highly skilled Technical Support Specialist to join our team remotely. As a Technical Support Specialist, you will be responsible for providing excellent customer service and technical assistance to our clients. Your main duties will include troubleshooting hardware and software issues, managing device configurations, and providing account support. To excel in this role, you should have a strong technical background, excellent problem-solving skills, and the ability to communicate effectively with customers. Skills required: - Technical troubleshooting - Device management - Account support - Customer service - Communication skills
I need an Excel sheet that can help me analyze customer information for trends and patterns. This will involve: - Basic Formulas and Functions: The data room should have basic formulas and functions that allow for the easy manipulation and analysis of customer data. - Data Room Design: The sheet should be designed to be user-friendly and intuitive, making it easy for me to analyze the data without getting lost in the spreadsheet. - Data Analysis: The main goal of this project is to analyze the customer data for trends. So, the ideal freelancer will have experience with data analysis and the ability to create custom formulas to uncover patterns. - Attention to Detail: Accuracy is key in this project. I need someone who is meticulous and can ensure that all the data ...
