Vba excel project jobs
I'm in need of an individual expert in Excel who can perform some simple calculations on my attached spreadsheet. The details of the task are shown in the spreadsheet, it won't take an expert too long to finish.
Hello, I am looking for a talented and affordable video editor to assist with editing 2 hours of content. This is a continuous project, and I am seeking someone who can deliver high-quality work on an ongoing basis. Key Requirements: Proficiency in video editing software and techniques. Ability to understand and edit Kannada language content is highly preferred. Strong attention to detail and ability to deliver polished final products. Good communication skills and responsiveness. Ability to work within deadlines and provide timely updates. Project Details: The initial project involves editing 2 hours of video content. The content will be provided in segments, and the editor will be responsible for stitching them together, adding transitions, effects, and ensuring ...
I require expert assistance in analyzing financial transaction data using Excel. The project's primary goal is quantitative data analysis. Through this project, I aim to draw valuable inferences and insights. Key responsibilities: • Analyzing large datasets related to financial transactions • Applying advanced Excel formulas and functions to dissect data Ideal Candidate: • Proven experience in data analysis, specifically within financial sectors • Proficiency in Excel for data management and analysis • An excellent understanding of quantitative data analysis methods.
I need an expert in Excel to build a robust calculator capable of handling complex mathematical equations and statistical analyses. This tool should be designed to deal with less than 100 distinct variables or data points. Key Requirements: - Excel proficiency with in-depth knowledge of mathematical and statistical functions. - Prior experience in building sophisticated Excel calculators. - Ability to create a tool that imports data from external sources automatically. The ideal candidate would have a strong statistics background and be capable of understanding the mathematical formulas I'll provide. The automation of data importing is crucial as it will streamline the usability of this calculator. The project is to calculate drivers pay and fuel cons...
You need to collect local business details out of Facebook groups and put them in an excel file. Data fields are: Source (posting url) Kind of business (like “painter” for instance) Name of business Contact Person Name (optional) Phone if available Email if available Phone is preferred but if not possible then email is ok. Please make your offer for 100 data rows aka 100 businesses and mention the word Australia at the beginning of your application so I know you have been reading the instructions. We will provide the local Facebook groups where the businesses post. Some of them you need to join first, others are open.
We currently run an online magazine for the transport and construction industry in Austria (). I plan to move to the Philippines in June this year and am planning a similar project there: Domestic News A regional online magazine was to be created and reproduced in a franchise. Each franchisee will fill the contents themselves. The website appears under a subdomain, for example www.domestic-news/manila I need: - An easy-to-use CMS with login for every franchisee o Customer data (company, name, address, email, web, telephone) o Customer data – export to Excel o Rubrics prepared according to template - Deactivation of categories without content - Expansion of categories by franchisees - Frontend design is already sketched (in the appendix) - All images in 3:2 format
Need an expert to clean up my textual data currently stored in an excel spreadsheet. This includes: - Fixing the formatting issues present in the dataset - Removing any blank cells to create a more organized and streamlined data view Please note that while the project does not require any specific end format for the text data, I'm looking for someone with a keen eye for detail who can make suggestions to improve the data readability and utility. Success in this project would involve achieving a tighter, cleaner dataset, hence your experience and familiarity with Excel and data cleaning techniques will be crucial.
...intelligence project requires creating a comprehensive database of all the flooring manufacturers across the USA and Canada. I specifically need information about companies producing hardwood, laminate, and vinyl flooring. Key tasks include but are not limited to: - Identifying and profiling flooring manufacturers in the given categories irrespective of their company size. - Generating leads by identifying marketing contacts in each company, complete with their contact information. - Companies can be of any size, from large corporations, medium-sized businesses to smaller local operations. Ideal Skills: - Exceptional research skills - Experience in lead generation and data mining - Familiarity with the flooring industry, specifically hardwood, laminate, and vinyl - Pr...
I am looking for an expert in Excel especially well-versed in the Norwegian language to assist me in data entry and creating database leads for marketing purposes. The focus is on signage companies in Norway. The ideal candidate should be proficient: - In Excel data entry and organization - Skilled in designing and managing databases - Must have an understanding and fluency in Norwegian language. -this project requires phone calls and web searching The main task will revolve around generating leads through database creation for targeted marketing campaigns (Signage companies in Norway). This project requires a good grasp of lead generation strategies in addition to the aforementioned skills. Please place your bid keeping in mind all the requirements stated.
Objective: To set up and configure Microsoft Office applications for a small business in New Delhi, India, to modernize operations and enhance productivity. Key Requirements: Primary MS Office Applications: Excel: For managing data, performing calculations, and creating reports. Outlook: For email communication, scheduling, and task management. SharePoint: For document management and collaboration among team members. Installation Scope: The MS Office suite will be installed on 1-5 devices to accommodate the needs of the small business. User Proficiency: The users of the MS Office suite are beginners. Therefore, the setup will include basic configuration and user-friendly customization to ensure ease of use.
I have an Excel document that needs to be updated by reading data from a TXT file. The process must be automated via a script, filling in blank cells, distributed across all the sheets in the document. Key requirements include: 1. The ability to read and accurately interpret all fields from the TXT file. 2. Updated data should be posted to all sheets within the excel document, in the required cells. 3. In the case of data discrepancies within the TXT file, enable an automated resolution by defaulting to a specific value. Leveraging your expertise in data extraction, manipulation, and Excel automation will be instrumental for this project. Ideally, you are proficient in scripts suitable for handling such tasks, debatably the likes of Python or VBA, c...
More details: What type of data do you need to type into the Excel sheet? Numbers How many columns and rows are there in the Excel sheet? 10-20 Would you like me to create any specific formulas or functions within the Excel sheet? Summation formulas, Average formulas, Lookup and reference formulas
I'm searching for an experienced Excel Macros Specialist to help me edit my document. Quick easy job. Won't take more than 10 minute.
I'm looking for an experienced freelancer who can create a dynamic and detailed Excel spreadsheet to break down the scenes of a screenplay, identifying specific elements of each scene (e.g Location, Characters). **Requirements:** - The ability to input details including Location, Time, Characters involved, and whether the scene is interior (INT) or exterior (EXT). - The spreadsheet should be structured to allow sorting options. This function is crucial for organizing the scenes in various orders, such as Chronological, by Scene Number, or other categories as needed. **Ideal Skills and Experience:** - Basic Proficiency in Microsoft Excel or similar spreadsheet software - Previous experience in creating spreadsheets for screenplay analysis or similar projects would...
I'm looking for an experienced freelancer who can create a dynamic and detailed Excel spreadsheet to break down the scenes of a screenplay, identifying specific elements of each scene (e.g Location, Characters). **Requirements:** - The ability to input details including Location, Time, Characters involved, and whether the scene is interior (INT) or exterior (EXT). - The spreadsheet should be structured to allow sorting options. This function is crucial for organizing the scenes in various orders, such as Chronological, by Scene Number, or other categories as needed. **Ideal Skills and Experience:** - Basic Proficiency in Microsoft Excel or similar spreadsheet software - Previous experience in creating spreadsheets for screenplay analysis or similar projects would...
I'm...digital transformation project. This will involve various data sources such as sales, marketing, and financial data. Key Responsibilities: - Integrating KPI performance from diverse data sources into the dashboard. - Tracking specific indicators like project progress, performance indictor and department performance. - Including project progress and performance indicators from other departments viz. Operations and Customer service. Ideal Skills and Experience: - Proven experience in KPI dashboard creation and data integration. - Strong analytical skills to track vital performance indicators effectively. - Proficiency in Business Intelligence and Analytical tools for data processing. - Familiarity with project progress tracking and departmental perf...
...problem-solving skills, effective communication abilities, exceptional attention to detail, and the ability to work cordially with a diverse group of people. - Usage of vivid colors to enhance audience attention. Preferred colors include Red, Pink, Black, Purple, and White. - Creative use of fonts for improved readability and uniqueness. Please empathize that I am skilled in Microsoft Office, Excel, Word, Teams Outlook, SQL, Voya, and ADP Ideal candidate: The ideal candidate for this job would have a great eye for design, experience in creating engaging PowerPoint presentations, and an understanding of how to present personal and professional attributes in a visually appealing manner. Fluency in English is a must. This is not just about translating skills into bullet points ...
I need a skilled editor to take on the task of content editing for my range of videos. This includes, but is not limited to, vlogs, promotional videos, and educational videos. Ideal Skills for the role:...limited to, vlogs, promotional videos, and educational videos. Ideal Skills for the role: - Proficient in video editing software - Prior experience in editing different types of video content - Adaptable and creative in the editing process - Attention to detail and sensitivity to the purpose of each video This project will require a versatile content editor with a knack for molding video footage into engaging narratives tailored for various video formats. Apply if you excel in understanding the subtleties of video content and are able to enhance them through your e...
...spreadsheet below 3 times now and 3 times a week after that. I will pay (escrow and release) your $5 FL fee as soon as I hire you. Then I will pay $10 for each spreadsheet that you fill in. Attachments: JPEG: Snapshot_5 is one JPEG from the zip file attachments. Excel Spreadsheet: Time Speed Bottom Left - 1 zip files: Snapshots Part 1 and Part 2 contain 516 JPEGs. WHAT NEEDS TO BE DONE: Look at JPEG Snapshot_5. There are 3 numbers: Time: 3000 Speed: 1.5 Bottom Left: 70 (Ignore the number 000 at the bottom right.) Look at the Excel Spreadsheet and the zip file Snapshots Part 1. Two of the rows are filled in with the numbers on the first two jpegs in the zip file. Your job is to fill in all rows of the spreadsheet using the 2 zip files of jpegs. (There is also an extra...
I am looking for a script to automatically add 7 days to a date in a table. The date format is dd/mm/yyyy and the date is located in the column "Not done late +35D". The result should be a new column with the date + 7 days, called "Not done late +42D". Specifications: The script must work on Microsoft Word. The script must be easy to use and does not require any programming knowledge. The script must be compatible with recent versions of Word (2013 and above).
...on using Outlook, Microsoft Edge, Excel, Signal and snipping tool. I'm an ESP Monitoring Engineer. Most of work is analyzing the performance ESP (Electrical Submersible Pumps) oil wells by viewing the trends of their running parameters (Current, Pump intake pressure, pump discharge pressure, Motor temperature, etc.) using specific surveillance websites. First, I receive an email notification that a certain ESP well has an event. This event can be a shutdown, restart, or even higher motor temperature than usual among many other notifications. Each email has a link that redirects me to a certain surveillance website where I will view the ESP well trends and perform root cause analysis of the event at hand. I record the event of interest in my personal log Excel...
I have a google sheet where we put 3 paragraphs of data into 1 cell. I have included an image showing the "reasoning" columns (D-J) which...concatenation. Then a final check to verify that the original = QA check. This is to verify no data was lost. Here is a read only link to the sheet: https://docs.google.com/spreadsheets/d/1TiyKKNjrEHeCrNySmmiD9xWQXTjd1OAh-8fUluSLRR0/edit#gid=420694380 rows 4-509 need to be done. Only work with the new fields, do not edit the original data This needs to be done with formulas, not manually. For an excel/google sheet expert this should be a 1 hour job. To show you have read this posting and have attention to detail, put your favor color as the absolute first word in your bid in ALL CAPS. If you don't do this, your bid wi...
I have 2 unfinished Access/VBA projects. I need assistance to finish the projects. My estimation is 3 working days. Max budget : 100$ Please note that I m also a freelancer. Thanks for you bid
I am seeking a qualified ...categorized and formatted into an excel sheet. Key Aspects Include: - Development of OCR model utilizing English language only - OCR model application should be primarily on handwritten letters - Exportation of interpreted data into a structured excel sheet Skills and Experience Required: - Substantial knowledge and hands-on experience in OCR technology - Proficiency in English handwriting interpretation - Understanding of Excel and data categorization - Experience with a diverse age demographic is a plus - Previous work with handwriting recognition technology will be highly valued Using OCR or AI is fine, i just want the best model. Need the ability to upload to the model on a basic test website and see results returned on that website ...
We want to automatically update a "Master Stock excel file by either uploading an "Additional" Stock file or by subtracting a "Subtract" stock file. This inventory system would ideally: - use the item code/ID in the additional or subtract files as the key and match or lookup the corresponding ID on the Master file and update the stock by adding or subtracting (depending on the file). - Any items that cannot be uploaded or matched need to be highlighted to the user so they know the item did not upload or update correctly. - We want to be able to repeat this process many times buy adding and subtracting files while automatically updating the master file. - We then want to be able to download the latest Master Stock File whenever needed. Important: It needs t...
I am in need of a customized Microsoft Excel spreadsheet for tracking employee departures. This tool is vital to manage efficiently and effectively the following data: - Employee Full Names - Departure Dates and Times - Bag Pull Information - Airline Information - Flight Information - Room Numbers The employee names should be formatted with both their first and last names for clarity and precision. As well as their guest names. Experience with creating functional and easy-to-navigate spreadsheets is key. Familiarity with airline industry operations or similar would be a great asset. Proficiency in Microsoft Excel is, of course, essential. I look forward to receiving your bids for developing this crucial tool for my operation.
I'm experiencing an issue with my VBA code not running as expected on my Mac with Office 365 version of Excel. I am also receiving error messages when attempting to run the code. I'm in need of a freelancer with a strong background in: - VBA Programming - Excel - Debugging - MacOS, specifically the Office 365 version of Excel Your task will be to inspect my code, identify the issue causing it to malfunction, provide fixes, and guide me through the process to avoid such problems in the future. Your debugging skills will be paramount and your ability to communicate clearly is desired. I expect prompt resolution of this issue, without any loss of original functionality. Please ensure you have the specified skills before making a bid.
Data Entry Project - Microsoft Excel Skills and Experience: - Proficiency in Microsoft Excel - Attention to detail and accuracy in data entry - Ability to meet deadlines Description: I am looking for a freelancer to assist me with a data entry project using Microsoft Excel. The task involves entering data into Excel spreadsheets accurately and efficiently. The ideal candidate should have experience in data entry and be familiar with using Microsoft Excel. Key requirements for the job: - Proficiency in Microsoft Excel - Attention to detail and accuracy in data entry - Ability to meet the deadline of completing the task within a week If you have experience in data entry and are proficient in Microsoft Excel, please submit yo...
I will inflict on you about a thousand pictures of cookie cutters I produce, and an excell file where you will have to replace the existing name with the name that describes it and you will also have to divide them into categories.
scraping 80k of data using python and export it into excel file
I am seeking a data entry professional with strong keyboarding skills and attention to detail. The task involves entering both textual and numerical data into a spreadsheet. The project will entail managing 100-500 records. I need information from webiste to be copied to excel sheet Ideal skills/Experiences: - Proficiency in Microsoft Excel or other spreadsheet software - Strong data entry skills with emphasis on accuracy - Experience dealing with large amounts of data - Must be efficient and organised. Kindly bid if you have proven experience in similar projects and can deliver this task within the given timeline. Accuracy is absolutely critical in this role. Your work will directly impact data-driven decisions and enhance operations.
I need someone to convert 20 PDF files into Excel spreadsheet format. See attached of ONE pdf file (to give you an idea) that needs to be converted to Excel. Secondly, once converted to Excel format, I need a slightly new design (colour scheme and presentation) to the existing design found in the PDF files. If you could create several sample designs of how to represent the data in the PDF files in a different way (style?) in Excel? See attached 1 x sample PDF file to convert I also need the FAQ PDF and the "Quick Start Guide" PDF converted to word documents.
...Potential to earn significantly with dedication, achieving 3-5+ sales per week. • Remote role with flexibility to work from anywhere. • Supportive team committed to your success and growth. How to Apply: If you're ready to contribute to our business success, apply with your resume, cover letter. Highlight your sales and digital marketing experience, especially with Google Ads, and your ability to excel in a remote work environment in your cover letter....
I would like to receive a price quote for checking customers acco...results of the conversation. I am attaching the excel file with the records, the script of the conversation. (I translated it into Dutch on Google, it must apparently be proofread) The conversation must not be mechanical, the script is only for illustration. I have prepared several questions and answers in case it comes up in the conversation. For the purpose of the conversation, you work at Vista System Netherlands. Some of the records include several people in the same company, it is enough for us if you talk to only one of them. I am attaching several files with instructions and questions for the project, it is important to go through them before starting the project! Thank You.
I am in need of an Excel expert to meticulously comb through my data and correct errors. The main task involves handling a phone numbers list riddled with duplicates. Key Responsibilities: * Identify duplicate entries in the phone numbers list. * Cleanse and correct information accordingly. Ideal Abilities: * Excellent Excel skills * Ability to spot errors quickly * Prior experience in data cleaning and error correction * Attention to detail is critical This job requires a keen eye and precision. Apply today if you have the necessary skills.
I am seeking a reliable individual with experience in data entry, particularly with entering text data, to assist with my project. Prior work with similar tasks is key, so please be sure to highlight any relevant experience in your proposal. Specific job requirements include: - Enter text data accurately - Must have past work demonstrating proficiency in data entry - Final format of data must be in an Excel spreadsheet The ideal freelancer for this task will have: - Strong attention to detail for accurate data entry - Demonstrated experience with Excel - Proven track record of punctuality in past projects
...freelancer with intermediate Excel skills to accurately and efficiently perform data entry from online resources. - Task: Your main job will be to gather data from specified online resources and input this into Excel. Accuracy is key in this role. - Skills: Your Excel skills should be at an intermediate level. You should be able to use Excel functions efficiently, handle large datasets, and have good attention to detail for data accuracy. - Experience: Previous data entry experience will be highly beneficial, especially if you have performed data entry from online resources. Having familiarity with a variety of online platforms is also advantageous. This project requires diligence, accuracy, and efficiency. The right freelancer will be proficie...
I'm looking for a professional who can efficiently input a variety of data types into an Excel spreadsheet. The data will be both text and numeric, along with dates. Key Project Details: - The spreadsheet will contain less than 100 columns and rows. - Data will be sourced from online resources. - Please ensure accurate data entry and review all entries for completeness and consistency before delivery. Ideal Skills: - Proficient in Excel - Attention to detail - Strong research ability and adept at sourcing information online - Accurate data entry skills
I'm looking for a profess...professional with broad experience in AutoCAD 2D drafting and Excel data entry. AutoCAD Drafting: - You will be working on mechanical design projects. - Your primary role will be to convert manual drafts into 2D AutoCAD drafts. - Meticulous attention to detail in replicating these designs in AutoCAD is crucial. Excel Data Entry: - Additionally, your role will also include meticulous data entry tasks in Excel. IDEAL SKILLS AND EXPERIENCE: - Proficient in AutoCAD 2D drafting with an emphasis on mechanical design. - Experienced in data entry in Excel. - Attention to detail is a must. - Experience in mechanical engineering design will be a plus. I look forward to working with someone who can meet these requirements and help m...
I'm seeking a proficient professional with excellent data management skills. The project involves: - Data entry with primarily text data. - Utilizing Microsoft Excel for this data population task. - Reformatting the entered data into a well-organized database. Ideal Skills: - Proficiency in Microsoft Excel - Experience with data entry involving text-based data. - Familiarity with database design and management - Attention to detail - Strong organizational skills This project emphasizes accurateness and adherence to detail, hence the perfect candidate would be someone highly meticulous with a proven track record in similar projects.
Job Description: We are seeking an experienced and dynamic Excel Data Management Coach to provide live coaching to our team. The ideal candidate should be proficient in all aspects of Excel, from basic functionality to advanced data management, and be capable of delivering engaging and informative sessions in Malay. Our goal is to significantly enhance our team's Excel skills for improved data management and analysis within our projects. Responsibilities: - Conduct live coaching sessions in Malay for a group of employees at times agreed upon with the team. - Provide a comprehensive syllabus or course outline that covers all aspects of Excel data management, -from introductory concepts to advanced techniques. - Ensure the course material is engaging, up-to-...
I'm seeking an expert in VBA coding, financial dashboard design, and crafting Power BI presentations. This project's focus is to: 1. Develop VBA coding 2. Design interactive and dynamic financial dashboards 3. Create an engaging Power BI presentation The ultimate goal of the dashboard and presentation is to: • Thoroughly analyze financial data • Visualize the company's financial performance in a compelling manner • Present clear and concise financial insights The types of financial data that will be included in the dashboard and presentation encompass: • Revenue • Expenses • Profit/Loss • Cash flow • Budget Ideal candidates possess in-depth experience with VBA, financial dashboards, Power BI, and prove...
I'm looking for an experienced freelancer who can create a dynamic and detailed Excel spreadsheet to break down the scenes of a screenplay, identifying specific elements of each scene (e.g Location, Characters). **Requirements:** - The ability to input details including Location, Time, Characters involved, and whether the scene is interior (INT) or exterior (EXT). - The spreadsheet should be structured to allow sorting options. This function is crucial for organizing the scenes in various orders, such as Chronological, by Scene Number, or other categories as needed. **Ideal Skills and Experience:** - Basic Proficiency in Microsoft Excel or similar spreadsheet software - Previous experience in creating spreadsheets for screenplay analysis or similar projects would...
I need 24 hours of your expertise in internet research to pinpoint distributors in the USA for Pergolas & outdoor furniture, the core products I aim to feature on my website. Finding these distributors is challenging, and your ability to uncover them would be invaluable. Upon identification, please add them to the provided Excel list, noting the number of brands they represent. Be aware that access to some sites might require a 'dealer login'. This task is an initial step towards a regular monthly assignment focused on supplier sourcing. Initially, my goal is to identify 1-2 very good distributors to kickstart the process. I would ask you to research 24 hours in 3 milestones, and each 2 days send me an excell with an update of about 8 hours of work. It could be that ...
I need a freelancer who excels in Excel to carry out some basic data entry tasks of 7 columns in 75 rows. I attach the excel sheet. Please note that you will get the information from the first page of the reports attached here. The pdf file name is the project id identifier. Note: appraisal_complete is basically closing date appraisal. You don't have to add any additional information apart from the ones I asked for in the excel. In essence, you will be entering numeric and date data, with formatting required for the date data. This task is simple, therefore no complex formulae or data validation will be needed. Ideal skills and experience: - Proficiency in Excel - Attention to detail - Experience in data entry This should be a straightforward ...
I'm in need of an expert who can effectively use Interactive Brokers Excel API for streaming real-time options data. I need only 2 types of data 1 stocks last price 2 open interest of every option price
I'm in search of a professional to create an easy-to-use Excel inventory management system. This project focuses purely on the management of raw materials. Key Features needed: - Automated data entry and reporting/analytics will be key features of this system. - Capability to continually track stock levels. Preferred Skills and Experience: - Fluent in Excel - Experience in creating inventory management systems - Excellent UI/UX Design skills - Experience in data analysis and reporting - Familiarity with raw materials management will be a plus. This tool should improve our inventory management and provide clear analytics on our stock. Experts only, please.
I'm seeking an experienced corporate and real estate paralegal who can assist with several operational tasks, predominantly involving: -Drafting of various legal documents, -Conducting comprehensive legal research, and -Assisting with contract negotiations. My business operates in the corporate and real estate legal fields. The individual I'm lookin...experience in corporate and real estate law sectors - Expertise in drafting a wide range of legal documents - Proficient in contract negotiation - Strong research skills - Broad understanding of business legalities. The right candidate will play a crucial role in my company, providing regular and diligent paralegal support to ensure smooth operations. If you have the experience and knowledge to excel in this role, I enc...
I'm seeking a professional with proficiency in Excel to interpret and visualize my company's sales data. The project involves transforming our monthly sales figures into an intuitive, easy-to-understand line graph. Key requirements include: - Ability to translate complex data into a clear, meaningful line graph. - Using the graph to indicate the highest and lowest sales periods, effectively allowing for product comparisons. - Proven experience with Excel is necessary, particularly graph creation and data visualization. The ideal candidate should have a solid background in data analysis and preferably in sales data interpretation. This project requires accuracy, attention to detail, and ability to deliver within tight deadlines. Graphing details ar...
