Excel vbscông việc

I am seeking a freelance Excel expert to assist me with a project that involves intermediate-level use of Excel formulas and functions. The ideal candidate would be able to automate the process fully.

I require competent services for data transcription. This project involves the transcription of data from a total of 265 JPEG images into an excel spreadsheet. Example Jpeg attached. The Details: - The JPEG images contain a combination of both text and numbers. - An integral part of this project is that the data from each image should be transcribed into a separate tab on the Excel spreadsheet. Key Qualities: - Proficiency in data transcription from images (JPEG) is essential. - Advanced skill level in Excel data management. - A keen eye for detail to ensure text and numbers are accurately transcribed. Thus, if you possess a high attention to detail and proven proficiency in this kind of work, I invite you to make your bid.

I am looking for an experienced freelancer to create a comprehensive hiring tracker on Excel. The tracker should be linked with PowerPoint and automatically update the slides. Additionally, I need a detailed dashboard that displays the following data points about the hiring status: - Number of applicants - Stages of the hiring process - Open vs filled positions Furthermore, I would like the dashboard to include some extra information, specifically: - Source of applicants - Diversity statistics The ideal candidate for this job should have a strong background in Excel, PowerPoint, and data visualization. Experience in creating automated systems and dashboards for recruitment or HR purposes will be highly appreciated.

This text file is too large for my pc to handle. You will open this text file, and then save it into 10 excel files and send the excel files to me. The data needs to all be in the correct format. Find the file here: (this is public data) Click 'Real Property Data' Then open the real_acct file. This is the file I need divided up and sent to me at 10 excel files. So each file will contain about 10% of the big file. All data needs to be captured. You will send me a test file with 100 rows of data to see if it is correct. Your bid is your bid. Do not bid and then ask me 'what my budget is?' Read the requirements and follow them. type 'sunshine' in your bid.

I need a designer who can format documentation for my company. It's crucial that the documentation is in line with our corporate standards. Requirements: - The documentation will be supplied in Word or Excel and will need to be formatted in Canva to corporate standards (see examples) - The final files will be provided as both the original Canva working file and a print ready PDF. - The primary audience for this documentation is our employees, so it needs to be clear and easily understandable for them. The ideal candidate will have: - Proficient document layout skills. - A high level of written English. - The ability to proofread supplied documents for any errors, and check their own work before submission. - Experience in creating process documentation. - Understanding of co...

excel optimization problems using premade excel model involving costs/profits/promotion. Answers using excel solver. There are 2 parts. I have already completed. Now, I need to complete another. I need it within 2 hours. It's not too big work.

Mi ...academia de Microsoft Excel online dirigida a profesionistas en el área contable / financiera / administrativa alrededor de distintos países de habla hispana. Actualmente estoy buscando probadores o "testers" los cuales tendrán acceso completo a los diferentes cursos de la academia y luego de consumir los mismos, a través de una revisión multipuntos, brinden no solo una reseña y calificación sincera del mismo, sino que también brinden un reporte de mejoras y acciones a efectuar para que pueda mejorar el nivel del mismo. La persona(s) interesadas en ser probadores no necesitan un nivel alto de conocimiento de la herramienta, ni tampoco deben tener alto conocimiento financiero y contable ya que los cursos dispo...

I have a set of .rdf files that contain data which I need to have extracted and organized into an Excel spreadsheet. - Extract data from .rdf files. - Ensure the data is accurately transposed into the Excel spreadsheet. No further data manipulation is required, just a neat and efficient organization of the data in the Excel file. Prior experience working with .rdf files would be an advantage.

I'm on the hunt for a diligent and adaptative Junior Admin for remote work based in the UK. This is a females-only position. Responsibilities: - Handling incoming phone calls and emails. - Performing data entry tasks and keeping all information organized. - Scheduling appointments as required. Requirements: - High proficiency in Microsoft Office (Word, Excel, PowerPoint) and Google Suite (Gmail, Google Docs, Google Sheets). - Exceptional verbal and written communication skills. - High degree of organization and attention to detail. - Willingness and ability to work under a flexible schedule that varies each day. The successful candidate must have a proactive approach, able to learn quickly, and cope well under the flexibility of working hours. Previous admin experience is a...

I'm looking for a talented developer who can create a script that can extract diverse data from multiple web pages and compile it into an Excel spreadsheet. Requirements: - Extraction of text content, images, and tables from various web pages - Script should be able to handle multiple web pages efficiently Ideal Skills and Experience: - Proficient in web scraping and data extraction - Strong experience with scripting and automation - Prior experience with extracting images and tables from web pages - Proficiency in Excel for data compilation - Ability to create a script that can run automatically on a weekly basis.

All in German!! I require an experienced data collector who can provide me a comprehensive Excel spreadsheet with 200 targets for cold calls. The subjects of interest are all freelance and independent salespersons based in Germany. The information about the targets should include: - Name - Contact Information (Phone number, Email) - Location - Website - Social Media account (LinkedIn) - Company Address - Company Name These professionals should represent the following types of companies: - Marketing Agencies - E-Commerce Companies - Recruiting There are no specific requirements regarding the years of professional experience. Any level of experience is acceptable as long as they fall under the freelance and independent salesperson category, based in Germany, and are associated wi...

I need a talented freelancer to design an Excel-based Tambola ticket generator with my specific requirements. This will enable me to generate a variety of tickets efficiently and effectively. Feature Requirements: • The ability to generate tickets with random numbers. • Numbers must be evenly distributed across each ticket. Skills & Experience: Ideal candidates will have: • Proven experience in Excel and VBA (Visual Basic for Applications). • Knowledge of number generation and distribution algorithms. • Attention to detail. • Ability to work within specified requirements. • Problem-solving skills, as unforeseen computing problems may arise. • Advanced knowledge in spreadsheet software to ensure the generator functions smoothly. ...

I'm looking for a skilled expert in excel Pivot tables. To help me create an excel master sales file where i can get my stores to fill a template and email it over to me and i could put that template in a folder and that would auto feed my master sales dashboard. - Analyzing product sales by category, and store sales from the EPOS data. - Identifying the sales trends per week/month/qtr - Focusing on the product sales data, specifically looking at the highest revenue-generating items. Ideal skills and experience for this job would include: - Proficiency in Excel and pivot tables, as the analysis will involve working with a large dataset. - Previous experience with EPOS data analysis would be highly beneficial. - Strong analytical skills and the ability to draw m...

More details: What specific tasks do you want to automate in Excel? Data entry, Data cleaning and formatting, Data analysis How many Excel files do you need to automate? 1-5 What is the approximate size of each Excel file? Less than 1MB

Am nevoie de transcrierea unor date de pe anumite documente intr-un fisier excel. Este vorba de doar 4 campuri (data, pret, serie, numar identificare) iar toate documentele au exact acelasi format. Documentele sunt in format fizic in Cluj-Napoca, Romania.

...title, I'm facing a problem with some Microsoft Excel files that have become corrupted and can no longer be opened. Key Requirements: - Expertise in recovery and repair of corrupted Microsoft Excel files - Proven background in data recovery projects - Possesses a good understanding of Microsoft Excel file structures and data - Ability to perform tasks without causing further data loss Here's a short overview of the issue: - The corrupted files were all made in Excel and I'm currently unable to open them Due to the nature of this work, discretion and confidentiality are critical. If you have the right skills and can handle this kind of sensitive project, let's talk. Your mission, should you choose to accept it, is to take these corru...

We have 2 excel files. Where file nr 1 is having new article numbers for pricelist. File nr 2 has some of the same articles but not the new take the new prices on file 1 and update that same articles with new prices in file nr 2. And also transfer the articles that is not in file 2. This is express job and needd to be done today.

I am in need of a highly skilled and experienced freelancer who can help me implement a new component in Aspen Plus simulation software. The specific component to be implemented is a thermodynamic property package. I have chosen the NRTL RK package. Key Requirements: - Expertise in Aspen Plus simulation software - Profic...package and equations - Strong understanding of component property This project is focused on the Co2 capture process. The successful implementation of the EEPMA is crucial in achieving the desired outcome. The ideal freelancer for this project would have a background in chemical engineering, process optimization, or environmental studies. the graphs and data have already been transferred to Excel and uploaded ina addition to the original paper and should be im...

I'm seeking a proficient data analyst to help with an upcoming project, primarily focusing on data cleansing, visualization and statistical analysis. ...visualizations to convey complex data in a simple format. - Interpreting data through statistical analysis to extract valuable insights and trends. The ideal candidate needs to be skilled and experienced with Excel, as it's the primary tool we'll be using for these tasks. A deep understanding of data cleansing procedures, visualization techniques and statistical analysis methods is critical. Demonstrated experience in handling a variety of datasets concurrently will be highly regarded. This project offers an opportunity to work with a wide spectrum of data and refine your skills within Excel and data analys...

I am looking for a freelancer with expertise in Excel to type and arrange data precisely as provided. Specifically, here's what you would need to do: - Type text data onto an excel sheet - The data should be inputted in lists - The data should be arranged exactly as provided, not in any specific order Ideal applicants for this task have precision and attention to detail. Mastery of Microsoft Excel is also required to ensure accuracy in typing and data hold. If you take pride in meticulous work, I'd be thrilled to have you on this project.

I need your help to add the names of LLC owners to an Excel spreadsheet. The purpose of this is purely for identification purposes. The names should be sourced from public records and the final file format should be .xls. Ideal Skills & Experience: - Proficiency in Excel and data entry - Understanding of and experience with public records - Attention to detail in accurately transcribing names - Prior experience in legal or administrative data handling is a plus

I want a Power Automate workspace delivered that will ingest multiple images, convert the area specified on the image to columns in Excel. Sample files can be provided

For an upcoming task, I need a detail-oriented worker to parse data from around 400-450 resumes in PDF format into an Excel file. My task requires you to: - Extract specific information from each resume, specifically: contact information, work experience, educational background, and date of birth. - Accurately enter the data into a given Excel template, ensuring no data loss or misplacement. The ideally suited freelancer for this job should have: - Extensive experience with data entry and PDF manipulation - A meticulous eye for detail - A solid understanding of resume contents and structure If you possess these skills, and the task fits your abilities, please demonstrate in your application your relevant experience in similar roles. I look forward to receiving your bids!

I'm seeking a proficient and detail-oriented freelancer to execute a critical cleanup process on my Excel spreadsheet encompassing 1000 lines of data. This role requires the incumbent to perform the following tasks: - Sorting and filtering Name, Date, Number, Price, and Uber data fields - Identifying and executing operations on specific calculations – particularly focusing on sums The ideal freelancer should possess outstanding Excel literacy and a keen attention to detail. Proficiency in data management with an ability to identify trends, anomalies or data discrepancies is also crucial. Prior experience with similar tasks will give candidates a competitive edge.

Formula Excel max min

I require the creation of an employee database focusing on fresh graduates with 2-3 years of experience in the Technology and Finance sectors. The database needs to be structured and delivered in an Excel spreadsheet format. It should contain the following information for each candidate: - Name - Education qualifications - Work experience details - Phone number The ideal freelancer for this project should demonstrate strong data entry skills and have a firm grasp of Microsoft Excel. A background in recruiting, HR or a related field, and knowledge about the Technology and Finance industries would be beneficial. Efficiency, meticulous attention to detail and respect for confidential information are also critical for this project. Prior experience in developing such databases ...

...Scope of work – Survey platform is an android based mobile application. Survey creation and management to take place on web. Survey Creation and Management: Should offer intuitive survey builder functionalities – Bulk Import of Choices: Streamline the creation of detailed surveys by allowing users to import extensive lists of options (SKU names, outlet names, brand, categories, etc.) directly from Excel or CSV files. Integrated Skip Logic and Branching: Utilize advanced conditional logic to guide respondents through customized paths based on their answers. This includes dynamically filtering choices for subsequent questions based on previous responses taking bulk imports into consideration. Question Types: • Invoice Scanning (employing third-party SDK, finaliz...

I'm seeking an experienced professional who is proficient in Arabic and English for a data entry project. You will be inputting simple data in Excel form, such as names and addresses. The data is currently stored in digital files. Required Skills: - Proficiency in Arabic and English languages - Experience in Excel data entry - Attention to detail Experience with similar data entry projects before would be ideal. The Task we have an excel sheet which has list of professors for a Kuwait University, and we have images of the updates professor list. We want you add in the table the missing people from the images. Attached the excel sheet and the images. What you will do is, open an image check which major it is, then apply major filter in the sheet,...

Need to search emails for number of records and arrange that in excel sheet.

I need a skilled professional to update my website's stock prices in real-time using excel. The project primarily involves: - Updating numerical data on my website - Ensuring accuracy and real-time updates - Using excel as the data source Ideal candidates will have: - Experience in data updating on websites - Proficiency in excel and data management - A good understanding of stock prices and real-time data management The goal of this project is to enhance the user experience on my website by providing accurate and real-time stock prices.

a single strategy via Excel so if you're interested then message me

More details: How would you like the PDF files to be named? This question was skipped Are there any specific formatting requirements for the PDF files? This question was skipped How soon do you need your project completed? This question was skipped

I have code for login trading accound and fetch token data. I need to update code I need to collect live data from the web and candle stick,Mins Intervals are in Dropdown box, I can choose any minutes interval, I need you to collect Last 5 candle data from the Excel in the web and other details for each token, I will give token name in the excel, It will automatically display the rows of data. If i chanage time interval it will display those data only. I need an intelligent programmer, who can see future problems and solve them clever and independently. Note: I dont know about coding, If you install the code and run successfully at my system thereafter I will hire you and release the payment. If you agree this term you will apply this task Budet is 600 INR and Good review,...

Address labels to be made Over 100 different addresses Font and layout should be all correct Addresses on excel spread sheet Label template will be provided and is on Microsoft word Labels made should not be duplicated

The project is an excel test. The attached file contains the test. It requires medium level skills. All the details are in the file More details: What specific calculations do you need to perform in Excel? Formulas to consider using - IF, VLOOKUP, SUMIF, SUMIFS, INDEX How familiar are you with using Excel formulas? Intermediate (comfortable with commonly used formulas) Which Excel features beyond basic formulas are you interested in incorporating? Pivot Tables, Conditional Formatting

I'm seeking a highly-skilled freelancer with a deep understanding of Excel for a data entry project. This is not your typical data entry job as it requires knowledge of complex formulas and data manipulation. Key Responsibilities: - Enter data from Excel spreadsheets - Create complex formulas within Excel - Use data manipulation techniques to ensure data integrity Ideal Candidate: - Advanced understanding and experience with Microsoft Excel - Proven experience with complex data entry - Attention to detail is paramount - Strong organizational skills - Ability to meet tight deadlines Join me in this challenging yet rewarding project and let's make a difference together.

I have code for login trading accound and fetch token data. I need to update more details incode I need to collect live data from the web and candle stick, Mins Intervals are in Dropdown box, I can choose any minutes interval, I need you to collect Last 5 candle data from the Excel in the web and other details for each token, I will give token name in the excel, It will automatically display the rows of data. If i chanage time interval it will display those data only. Automate the buy/sell Trade I need an intelligent programmer, who can see future problems and solve them clever and independently. Note: I dont know about coding, If you install the code and run successfully at my system thereafter I will hire you and release the payment. If you agree this term you will apply...

Hi, I have 6 excel optimization problems using premade excel model involving costs/profits/promotion. Answers using excel solver. Using an excel model to adjust subcontracting and demand. Note: Need it done within the next 20 hours.

6 excel optimization problems using premade excel model involving costs/profits/promotion. Answers using excel solver

This take is to take a list of URLS (as in the URLS spreadsheet attached) and create a Power Automate flow to extract the following from each URL: • Previous Close • Open • Bid • Ask • Day’s Range The output should be in a separate spreadsheet (‘output’). In the sample ‘output’ file attached, this shows the result for ‘MMM’. Other URLs will follow. I should be able to run the Power Automate workspace at any point to scan the URLS. The URLS may change (added or removed).

Hello I do sales for a tobacco company and I need to enter all my sales for January February March. I need three different Excel files. All it is is the name of the store the amount that I sold and the address.

...concreto necesitamos: • Automatizar la exportación de datos de facturas emitidas (y su estado, canal de entrada, consultor asignado) y gastos, y preparación de los mismos desde HOLDED. • Automatizar la exportación de datos (presupuestos lanzados y vendidos, potenciales clientes y comerciales asignados) y preparación de los mismos desde HUBSPOT. • Automatizar la cumplimentación Excel de RRHH mediante un Excel que nos pasa la gestoría cada mes, con todos los datos de las nóminas y costes laborables de cada trabajador. *****Importación e integración de todos datos y modelado de un cuadro de mando en Microsoft Power BI con las siguientes funcionalidades:  Facturación Mensual, anual,...

I'm seeking a freelancer with advanced Excel and Power Query proficiency to provide essential data extraction, transformation, cleaning, and combination services for an Excel Report. Qualified candidates must demonstrate: - Advanced understanding of Excel and Power Query - Experience in extracting data from diverse sources - Capability for cleaning and transforming data for optimal utility - Aptitude for combining data from various sheets effectively In your proposal, include details about your relevant experience. Your hands-on experience and proven record of similar projects will secure your success in this job.

As a busy professional, I'm on the lookout for an Excel pro who can assist in organizing my dataset of less than 1,000 rows. The data is moderately complex, with multiple columns of various types. The ideal freelancer will: - Have experience with Data Entry and Organization. This includes swiftly inputting data and structuring it for optimal accessibility and productivity. - Possess Data Analysis and Reporting Skills. I'm keen on meaningful insights from the data and require straightforward, compelling reports. - Excel proficiency is a must, with strong attention to detail, and ability to handle moderate complexity data. By bringing your advanced Excel management and analysis skills, you'll be delivering order to chaos, and helping drive more informed ...

...date, most recent, i dont want to have old people who dont work there anymore or invaild emails, i'll check for that Data Points to Include: Full Name of the HR contact or recruiter Their Position/Title within the company Gender (if available and relevant) Company Name Professional URL (e.g., LinkedIn profile) Contact Email Address Contact Phone Number (if available) Deliverable: A completed Excel or Google Sheets database that is well-organized and easy to navigate. Timeline: Please provide an estimated time of completion. I am looking forward to working with someone who has excellent research skills and a keen eye for detail. This project could potentially lead to further work if done successfully. When applying, please include examples of similar work you have comple...

See the attached File. Simple project here. If any of the words in column A, sheet 2 are in column D, Sheet 1, then delete the entire row (in Sheet 1) (Delete the entire row, not just the cell) No macros Likely conditional formatting, new rule is the best. This will be used on multiple files so it needs to be quickly applied. New words will be added to the list to filter for. The filter list can be added to each new file. No Macros Type :Sponge Bob" in your bid (to sort through the spammers) This should be a very low cost bid and delivered today.

I need an Excel expert who can craft 4 meaningful bar charts to visualize several health metrics. The foremost tasks required would include: - Visualizing perceived health data acquired from various sources namely, self-assessment questionnaires and participant interviews - Converting raw data of percentage changes in health into impactful insights using Excel It's pertinent that the freelancer has a good grasp of Excel and data visualization. A comprehensive understanding of health metrics would be appreciated, but not compulsory. Your role will aid in the better comprehension of health improvement or decline, ultimately guiding decision-making based on these observations.

I am looking for a skilled individual to create 4 bar charts in Excel for the purpose of showcasing percentage changes in perceived health over time. Key requirements: - Using perceived health data, generate 4 bar charts showing changes over time. Ideal Skills: - Proficiency in Excel - Understanding of data visualization - Ability to depict percentage changes in a clear and accessible manner. Please provide examples of your past work in your bid.

I need an Excel file created with text, numbers, and formulas. The data should be organized using rows and columns, across 6-10 tabs/sheets, and include pivot tables. Ideal skills and experience for this project include: - Advanced Excel knowledge - Experience in creating organized and visually appealing Excel files - Proficiency with pivot tables and formulas - Attention to detail and ability to follow specific instructions If you have experience with similar projects and can deliver a well-organized Excel file with the specified features, I'd like to hear from you.

...from an Excel file. The automation should be set up to run on Windows operating system using Power Automate. Requirements: - Automate creation of tasks and subtasks in Microsoft Planner from an Excel file - The automation should trigger based on a specific action, potentially a call, button, or script (vba button Prefered) - The system should be set up to run on Windows Ideal skills and experience include: - Proficiency in Power Automate - Prior experience integrating Microsoft Planner with Excel - Strong understanding of Windows OS and how to set up automation scripts to run on it - Experience creating and managing subtasks in project management software I am looking for someone who can create a reliable and efficient automation system that can seamlessly integr...