Excel txt columns jobs

I'm experiencing various difficulties with my Excel spreadsheet. The problems include formula malfunctions, formatting inaccuracies, and missing or corrupted data. The spreadsheet was created using Microsoft 365 apps for business version 2402. I need someone with advanced understanding of this Excel version to resolve these issues. Key Issues to Address: - Correct misbehaving formulas - Fix formatting inconsistencies - Recover or reconstruct missing/corrupted data Excel functions that need to be recalibrated include VLOOKUP or HLOOKUP where I'm currently receiving 'value not available' errors. Ideal freelancers for this task will have proven experience in advanced Excel troubleshooting, including work with VLOOKUP and HLOOKUP function...

I require a detailed-oriented individual with expertise in data entry to create a comprehensive master file. The task: - Extracting specific fields from provided data sources, namely Excel files and PDF documents. Some files to large drop into upload. - The data to be extracted is unstructured and includes product codes, descriptions, pricing, Wels ratings, and EAN numbers. Ideal Candidate: - Experience with data entry from various sources into a singular master file. - Great attention to detail in order to accurately capture all necessary information. - Familiarity working with Excel and PDF data extraction. - Understanding product related data (codes, descriptions, pricing, Wels ratings, EAN numbers) can be an added advantage. Your ability to accurately translate ...

...seeking an Excel expert who can skillfully handle formulas and functions. Besides, a crucial part of this task requires dealing with intricate aspects of data visualization to provide me with the best outcomes. Key responsibilities: - Applying complex formulas and functions to optimize the usage of my existing data. - Utilizing your expertise to provide complex formatting for data visualization. Ideal Skills: - Expertise in Excel with a solid understanding of formulas and functions. - Solid experience in handling intricate data visualization in Excel. Experience Required: - Proven experience in utilizing pivot tables for data visualization in Excel. Please apply only if you are confident in your ability to deliver these requirements. This task will ...

I need a data analyst to thoroughly assess my sales data. The information is stored in Excel and needs to be analyzed urgently to determine key metrics that will enable me to make informed decisions with regards to our vending machines. The most critical details to extract include: - Product sales: Identifying which items sell more than others - Most popular products: Discovering the specific products customers prefer - Sales volume: Understanding our overall sales output The ideal freelancer should be proficient in Excel and data analysis. Previous experience working with sales data would also be advantageous. Time is of essence for this project and would require immediate prioritization.

...requirement for an Excel expert who can modify and add functionalities to my existing macro file. Key Requirements: - You must have a strong understanding of Excel 2016 or higher and its macro functionalities, ideally with previous experience in modification and functionality creation of macros. - Tasks will involve modifying current macro functions and developing new functionalities in line with my requirements. Detailed requirements will be shared with the chosen freelancer. - Time is of the essence in this project. Hence, please bid only if you could commit and deliver the project as soon as possible. If you tick all these boxes, I look forward to hearing from you. Your immediate availability and prompt action are highly appreciated. Let’s get started with enh...

Please Sign Up or Login to see details.

...project essentially revolves around data entry into an Excel spreadsheet. ***A list of 275 companies will be provided in an excel spreadsheet and the freelancer needs to find the website and refer to the websites of the companies one-by-one and add their email addresses, name of manager, phone number of the company and the manager. *** The responsibilities primarily involve: - Efficiently entering textual data provided by me into the designated Excel sheet. - Maintaining an organized and understandable layout for the entered information. - Ensuring accuracy in all entered data, with minimal to no errors. Candidates should have a solid background in administrative work, specifically with data entry tasks. Proficiency in the use of Excel is a must. The idea...

I'm in need of an adept freelancer who will create an Excel sheet using the logical formulas provided in a PDF file. Here are the key qualifications for this project: - Skilled in translating formulas provided in PDF format into Excel. - Expert in building and debugging logical formulas in Excel. - Experience in applying Excel's capabilities for efficient use of formulas is highly preferred. While the specific pay rates for this project were not mentioned, it's crucial for the freelancer to provide their reasonable rate. Your bid should include your proposed hourly rate, the estimated time needed to complete the task, and any additional costs.

I am seeking a skilled individual to assist in managing my project. The role will be part-time, which will be two to three times weekly and comprises approximately 5 to 6 hours each day. The role's responsibilities will include: - Data entry tasks: To ensure accurate and efficient information flow. - Project adm...Correspondence: Monitor and manage emails, ensuring effective and timely communications. - Assisting with Scheduling: Help in setting up meetings and managing the project calendar. The candidate should have experience in project administration, data entry, and general office tasks. Excellent organization and communication skills are needed. Proficiency in Microsoft Office suite especially MS Excel is preferred. Detail-oriented and can work independently with minim...

...Microsoft Excel expert to assist in automating two excel worksheets. The goal of this form of automation is to facilitate the calculation of my workers' money balance. The task primarily involves setting up formulas to perform subtraction given that data is well categorized across different worksheets. While the task doesn't require highly advanced functions, it necessitates a good understanding of Excel's simple mathematical operations. Key responsibilities for this project include: * Creating formulas for automating subtraction between two worksheets * Adhering to the set arrangement of the data to maintain order * Ensuring accuracy in the customization of formulas according to the set data fields The ideal candidate should possess: * Solid experience ...

I am looking forward to having a personalized Excel-based attendance and salary system created. This project is for personal use, and I have a specific layout in mind that I'd like to implement. Key Requirements: - The system is to accurately track daily attendance and overtime with a user-friendly interface that allows for easy data input. - In addition, the system will calculate salaries based on the daily attendance and overtime records. It's crucial that it's accurate and efficient to avoid mistakes in pay calculations. - The layout should be simple but effective, making it easy to understand the data presented. Ideal freelancer for this project: - Excellent skills in Excel (including formulas, pivot tables, and spreadsheet management) to ensure the pro...

I'm in need of a proficient freelancer who can develop Excel sales dashboard updating on a daily basis. The chosen freelancer needs to be capable of tracking: - Total sales - Sales by region - New customers acquisition - Returning customers - Daily, weekly, monthly, and yearly sales - Sales comparison to the previous year - Top 10 accounts by turnover _what visual charts as well for sales Apart from this, I would like the dashboard to be configured to compare current sales data for the day, week, month, and year-to-date with the corresponding periods from the last year. Ideal Skills: - Excel skills - Experience in a similar project - Understanding of sales metrics - Strong communications skills High accuracy and attention to detail are paramount in this j...

...I require an Excel expert who can create a dynamic salary and attendance sheet for my employees. This sheet should have a feature for tracking employee attendance, and calculating individual salaries based on their hourly rate. Here are the key functions I would like the sheet to perform: 1. Track Employee Attendance: - The ability to record dates and the corresponding employee names. 2. Salary Calculation: - I would like this to be done based on the hourly rate of each individual. 3. Calculate Overtime: - The system should also have an option for calculating overtime. The ideal candidate for this project should have strong Excel skills, outstanding attention to detail, and a clear understanding of payroll calculation methods. Prior experience in developing ...

I'm looking for someone who can fix some simple issues with some ai generated code. It's a simple page which allows a user to quickly select items from a series of boxes. This data is then populated in an exportable Excel spreadsheet. Fix's - the code doesn't currently work properly I want a properly laid out spreadsheet, coloured and easy to read. See code attached.

Hi Lan, I'm keen to get you to do some more company research as discussed. I will need you to do about 8 hours worth of research work for me. I will send you through an excel spreadsheet with the research terms and criteria I am looking for and ask you to populate the appropriate field.

I would need excel table to calculate DDP cost from China. The cost per container and shipments port are variables and it will be changing for example: I would need to calculate transportation costs from Ningbo to for Sur Mer, other time is it is different port. So probably ports has to be in another excel sheet so I can update the transportation routes and costs, same for currency.

I'm in need of a proficient financial expert to assist with the execution of financial reporting and the preparation of financial statements. With your profound skills and background in financial analysis, you ...accurately depict our financial standing. - Financial statement preparation: Creating reliable and succinct financial statements that reflect our financial position will be an integral part of your job. Skills & Tools: - Excel Proficiency: I prefer the use of Excel in executing the above tasks, hence an advanced understanding of Excel is necessary for making complex computations and data analysis. Please note that it's not compulsory to have knowledge of my business industry as it wasn't defined. This job is purely about your superior com...

...of an experienced Excel developer proficient in creating dynamic dashboards. My project will involve the creation of a dynamic, user-friendly Excel dashboard that maximizes the usability of my data. Here's what I'm looking for: Key Features: - Dynamic charts that adjust based on different variables - Automated data refresh from linked Excel spreadsheets Excel Spreadsheet Structure: Although I'm familiar with Excel, I don't have a specific structure for the dashboard in mind. I would be counting on your expertise to guide the creation of an effective, well-structured and user-friendly interface. Ideally, you should have: - Extensive experience with Excel dashboard creation - Proficiency in creating dynamic charts within ...

Please Sign Up or Login to see details.

I need a skilled Excel macro developer to create a macro that adjusts hyperlinks disrupted by One Drive. - The existing issue: - The hyperlinks in my Excel document lead to the incorrect destinations. - The ideal solution: - After running the macro, links should direct to specific webpages or files that I provide. Having a background with similar hyperlink issues, as well as knowledge of One Drive and Excel macros, is crucial for this task. Please note the urgency of this project, it requires immediate attention.

I need a tailored Excel-based AR tracking system with specific features centered around tracking by invoice. The system should: - Enable the tracking of accounts receivable. - Include a detailed view of each invoice, highlighting key data such as the invoice amount and due date. The freelancer who takes on this project needs proficiency in Excel, with an in-depth understanding of invoice tracking and accounts receivable. Previous experience in creating similar systems will be a distinct advantage.

I am in need of a freelancer with proficient skills in online data entry. The work we have in mind involves using Microsoft Excel Online as an entry software. Key Responsibilities: - Perform Online Data entry using cloud-based software - Use Microsoft Excel Online as the preferred software - Ensure accuracy of all data input Ideal Candidate: - Should have exceptional knowledge of Microsoft Excel Online - Prior experience with online data entry - Good attention to detail - Must possess excellent typing speed - High commitment to meet deadlines To successfully carry out this project, a high level of accuracy and speed will be required. Hence, having prior experience doing similar tasks can be an added advantage. This role may lead to more assignments if excel...

I need an extensive research conducted, seeking for job postings of Chief Revenue Officer(CRO) or SVP of Sales, SVP of Business Development for software companies located remot...of job boards like LinkedIn, Glassdoor or Indeed. No specific companies are targeted, revealing broad perspective is the key. IDEAL SKILLS: - Excellent Web Research capabilities - Strong understanding of job searching - Proficient in Data Entry and interpretation - Experience in HR, specifically in software industry. REQUIREMENTS: - All job links should be current and active - Submission in Excel format detailing the Company Name, Job Link and Location. - Confidential and respectful handling of the project. This task is perfect for someone knowledgeable about job market trends and has proficiency in web...

leads AI USA venture capital companies find AI venture capital companies in the USA. as more companies as possible , at least 1800 companies data save in csv file with ALL needed columns : One record in each cell one line/row per company do not forget phone numbers Specifically, I require : 0 company name and foundation date 1 company website 2 company address 3 at least for 3 leaders: name , email and linkedin, direct phone number . One record in each cell 4 HR: name , email and linkedin, direct phone number . One record in each cell some ideas to start

I'm seeking a proficient individual to transfer data from physical documents into an Excel spreadsheet. The data consists predominantly of names and addresses alongside survey responses and results. Organizational skills, attention to detail, and familiarity with Excel are key. The ideal candidate should have: - Proven experience in data entry and knowledge of Microsoft Excel. - The ability to maintain accuracy, even when dealing with large volumes of data. - Excellent organizational skills to manage and categorize this data in a logical and accessible manner. If you have relevant experience and are ready to start immediately, please apply.

I am looking for a data entry specialist with a knack for numbers and attention to detail. You'll be entrusted with entering numeric data in Excel without a specific format or template provided. Your required skills and experience: - Excel proficiency - Fast and accurate data entry - Experience with numerical data The data inputted will be used for generating reports, so an understanding of report generation would be beneficial. Accuracy and precision are paramount to ensure the correctness of the reports. Let's get those numbers crunching!

I am seeking assistance with the update of a spreadsheet to reflect current year assets and...current year assets and liabilities under ASC 842, the Right of Use. The spreadsheet is complete for 2022, and I need it updated for 2023. To succeed in this project, you should be: - Familiar with ASC 842, Right of Use. - Proficient with Excel, especially in data organization. - Detail-oriented and accurate about financial data. Your mission will be to: - Update the current year (2023) assets and liabilities. - Specifically, the asset values need to be updated. Your expertise in accounting standards, precision with numbers, and proficiency in Advanced Excel would come in extremely handy. Show me your previous work relating to ASC 842, Right of Use, to boost your chances of sele...

HR freelancer We are looking for an HR expert to help us locate and recruit talents as per requirement of the project This is a part time, work from home opportunity for candidates looking for a challenging and vibrant career and to grow in the reputed networks in Europe. Eligibility 1. Strong communication skills 2. Ability to travel within Schengen area 3. Soft skills in online research, excel, presentations 4. Quick grasping and learning abilities 5. Confident with go-getter attitude

I am in need of an expert in the data entry field who will assist me in converting my PDF document into Excel format. Essentially, your responsibility shall be to conduct the following tasks: - Convert a PDF file into an excel worksheet - Organize the transferred data by categorizing business structural information. The ideal candidate will have prior experience in data entry and conversion, including knowledge of both PDF and Excel platforms. High attention to detail and a solid understanding of business structural data are crucial for effective sorting of information by category in the Excel sheet. Your previous experience in handling business structural data will be highly beneficial for this job. Punctuality as well as delivering accurate and quality wor...

...someone proficient in extracting data from tables within JPEG images and digitizing this data into Excel. I have more than 20 images that need this service. The tables are moderately complex, with several columns and rows. The project requires: - Advanced skill in data extraction and digitization - Proficiency in data entry into Excel - Experience with reading JPEG images is a plus - High level of detail and precision Your role will involve, but not be limited to: - Reading and understanding the data in the JPEG images - Extracting this data accurately - Organizing and entering this data in Excel I would appreciate a timely completion of this task, with each table accurately represented in Excel. It's critical that all the details in the tabl...

Giving my e-commerce operations a boost is the motive and for achieving this I am currently on the hunt for a proficient API Integra...platforms of focus are Meesho, Amazon and Flipkart. As the ideal candidate for this project, you will need to provide me with: - Seamless product synchronization - Efficient order management - Proficient inventory management This trifecta of tasks will be executed whilst prioritizing compatibility with our maximum possible existing systems, making the transition as smooth as possible. To excel in this gig, you'll be a master Javascript coder, with proven experience of API integration in e-commerce contexts. Understanding the intricacies of Meesho, Amazon and Flipkart APIs will be crucial. If you can hit the ground running on day one, I wan...

I need some help with Excel typing. The job involves typing and formatting a text based content. Here's what you will need to do: - Type text data into an Excel sheet. - This text is strictly client details. - Please ensure all the text cells are bold in formatting. Ideal freelancers would be extremely comfortable with Excel, detail-oriented, and capable of following instructions for formatting. Prior experience with data entry, particularly text and client information, would be beneficial.

I am in need of someone with a firm grasp on Excel, especially with formatting and typing text data. Project requirements will be: - Typing text data into Excel. - Applying bold or italic formatting to the text data. - Specifically, the formatting should be focused on the header section of the sheet. Ideal candidates should be detail-oriented, have extensive experience with Excel data entry and formatting. Familiarity with the application of bold or italic settings to headers is a must. Accuracy and consistency are key to this project.

I need a 2000 word report written using formula provided below, can choose any formula from the options given, I need an excel sheet made as part of the report and inserted. It also needs to be referenced Harvard style. There are very clear instructions so if they can be followed that’ll be great. Thanks

I need a 2000 word report written using formula provided below, can choose any formula from the options given, I need an excel sheet made as part of the report and inserted. It also needs to be referenced Harvard style. There are very clear instructions so if they can be followed that’ll be great. Thanks

I need an experienced data entry specialist to oversee more than 500 entries consisting of text, numbers, and images into a spreadsheet. Key Responsibilities: • Accurate entry of mixed data into a spreadsheet • Compliance with established data entry standards and guidelines Required Skills: • Proven data entry work experience • Proficiency in Microsoft Excel • Attention to detail • Continual learning and development in relation to data entry techniques and tools. You should have demonstrated ability to manage a large volume of data, and have an eye for detail to ensure high accuracy and quality of data.

...with a substantial amount of data analysis on Excel. My project revolves around: - Statistical Analysis The freelancer needed for this task should be proficient in Excel, adequate enough to perform detailed statistical analysis. This may include the use of functions for regression, correlation, histograms, and the like. Key responsibilities would include: 1. Understanding the data from excel sheets 2. Process and analyze the data using statistical analysis 3. Summarize and visualize the outcomes The ideal candidate should have: - A strong background in data analysis - Proficiency in Excel and statistical software - Excellent attention to detail - Good understanding of statistics and able to expertly use statistical functions within Excel Someo...

I need a specialist to create a Discord bot featuring custom commands specifically for user management. The bot must have the capability of executing channel updates. The preferred freelancer should ideally possess: 1. Excellent proficiency in programming Discord bots. 2. Prior experience with custom command creation. 3. Knowledge in implementing channel updates. I added a bri...specialist to create a Discord bot featuring custom commands specifically for user management. The bot must have the capability of executing channel updates. The preferred freelancer should ideally possess: 1. Excellent proficiency in programming Discord bots. 2. Prior experience with custom command creation. 3. Knowledge in implementing channel updates. I added a brief summary of the workflow in the txt...

We are seeking to develop a standalone app to assist health professionals in selecting effective treatment protocols for diseases. Our current MVP, built on GPT Teams, uses a guide (uploaded as a PDF) to answer queries. We aim to evolve this into an app where queries can be made and answered verbally, leveraging our proprietary dataset stored in a PostgreSQL database and supplemented with Excel spreadsheets for static content. Key requirements include: Voice-Activated Queries and Responses: Enable health professionals to input queries by voice and receive spoken answers. Dynamic Data Integration: Incorporate and regularly update treatment recommendations and static content from our database and spreadsheets. Customizable Interaction: Define the manner in which the AI present...

Overview of the Task: The original test sheets contain many data sets each with 49 numbers. Each data set is a column. Each of the data sets/columns has 7 out of 49 numbers selected as Process numbers. These are given in bold red. Now, the last column, the rightmost column, is the target data set for prediction. All other columns are data sets to be used for training the model. The project's ultimate objective is to predict the 7 process numbers of that last column/data set using Machine Learning models. We are using as many as 5 different types of ML models to predict these 7 pattern numbers from the target data set which is the last column of each test sheet. During this process of prediction, we have come across certain observations. We had to solve those observ...

Hi, I need a Power Automate expert to help with exporting values from an existing SharePoint column and then re-importing those values into a new, empty column within the same SharePoint library. Looking for someone who can do this smoothly and without data loss. Please share your experience and rate, and let me know when you can start.

I am in need of a proficient Python programmer with strong skills in data entry automation. - The preferred candidate will handle Excel files and bookkeeping software. - The tasks being automated include Data Input, Data Sorting, and Error Checking. - A strong understanding of Excel file manipulation in Python is critical. - Experience in error-checking algorithms and data sorting techniques is a major plus. - Candidates should be detail-oriented and able to test and debug the program thoroughly to ensure its accuracy and efficiency. If you have these skills and can provide references of similar automation jobs done before, this might be the project for you. Looking forward to seeing your bids!

I am searching for a proficient Excel expert who can assist remotely in creating and modifying spreadsheets dovetailing with my jewellery business. Preferably, candidates should have some understanding of the jewellery industry, but what's more important is your ability to handle these specific tasks: - Data Entry: Enter data accurately and efficiently. Familiarity with the type of data typically associated with a jewellery business, notably inventory data, is desired. - Formatting and Organizing Data: Develop a system to organize the data in an effective and practical way. Choosing a customized format to cater to my specific needs is imperative. Establishing clear, user-friendly layouts are equally important to enable straightforward maintenance on my side. - Creating Form...

...techniques. • Planning and problem solving with product development, operations & business teams. • Product Organization/Startup experience is desirable. • Demonstrated experience facilitating meetings at multiple levels of an organization and an understanding of facilitation technique. • Intermediate working knowledge of Microsoft Office applications, including but not limited to Outlook, Word, and Excel. • Certified Scrum Master -CSM0 /Professional Scrum Master -PSM0 / SAFe Scrum Master Certification is mandatory. B.3 Knowhow on methodologies ▪ Agile-Scrum ▪ Agile-Kanban ▪ Agile-Scrumban ▪ CI-CD ▪ Large Scale Agile -LeSS0 ▪ Scaled Agile Framework -SAFe0 ▪ Product Management C.1 Expected deliverables ▪ Manage & facilitate Scrum events/ceremonies ...

I would like a script that allows me to enter a business website URL which then looks at the type of business and creates different marketing campaigns for each month for the next 12 months. The marketing campaigns will involve 10 emails to be generated and placed in individual txt files in a folder named with the month and year and name of the marketing campaign. For example, if there was a website for a dog photographer called , then the user would type that URL into a field and hit enter. The script would read the type of content on that website's home page and if there is a store, it would read the type of products and services for sale. Then the script would make 12 marketing campaigns for the current and next 11 months. For each month, the script would generate the market...

I am in need of a solution for creating dynamic export invoices in Excel. This solution would ideally allow for customer-specific details to be selected through the use of option buttons or dropdown menus. The following details should be incorporated into the invoice: - Customer Name - Customer address The ideal candidate for this project will possess a strong understanding of Excel and its functionalities. Experience in creating dynamic invoices is a major plus. This project has an urgent timeline and I am hoping to have it completed as soon as possible. If you have the skills and can work within the timeframe, I'd be excited to hear from you.

*Contains explanatory video* *Contains sample* Dear Freelancer(s), I have a list of 5.500 company names of mortga...directors within the company. Therefore we would like to match data by combining competitors that are located in exactly the same city in The Netherlands. This can be done by using data and coding skills. It is a relatively simple job to do. I have added a sample of mortgage advisors as an attachment and a video that explains what I am looking for. The matching of the data should take place in our Excel file marked green. I would like to work with the freelancer that succeeds this job. Please let me know if this job suits you by completing a sample. Video explanation:

I need assistance with entering less than 500 entries into a spreadsheet. The data is simple, requiring basic text entry with no additional research or verification necessary. The ideal freelancer for the job would be quick, reliable, and experienced with spreadsheet data entry. Details or instructions will be provided upon awarding the project. Efficiency...assistance with entering less than 500 entries into a spreadsheet. The data is simple, requiring basic text entry with no additional research or verification necessary. The ideal freelancer for the job would be quick, reliable, and experienced with spreadsheet data entry. Details or instructions will be provided upon awarding the project. Efficiency and accuracy are key in this job; familiarity with Excel or Google Sheets is an ...

I need an Excel expert to create a macro on my Excel 2016 sheet. The task involves automating a few features which are at an intermediate level of complexity. These include implementing logic and executing complex commands. - Task Information: The macro should help in automating data entry, formatting, and calculations on the sheet. - Skills and Experience Required: Ideal candidates should have proficiency in Excel 2016 and a profound understanding of macros at the intermediate level. They should be well-equipped with knowledge in creating macros that can perform logic-based actions and execute complex commands. Programming knowledge is a plus. Please provide examples of similar projects you've done in the past, especially handling similar task complexities. D...

I am looking for a professional freelancer who can provide a solution for automating the creation of weekly MIS reports using Excel. The selected candidate will have: - Expertise in Excel and data manipulation - A deep understanding of sales data - A proven track record in automating data reporting tasks Tasks will include: - Understanding my sales data structure and reporting needs - Designing and implementing a process to extract significant data - in this case, Revenue, from my Excel sheets - Setting up an automatic report generation mechanism This project will require a tool or macro that can generate these reports on a weekly basis, without fail. The tool or macro should be straightforward to use and should effectively sort and analyze the data to produce the ...