Excel macro data cell jobs
...of an experienced Excel specialist to create a user-friendly contract tracking system. This system is required to have the following functions: • Automated alerts and notifications: The tracking system should automatically alert the user about important details and updates related to the contracts. • Report generation: It should have the capability to generate concise reports to provide clear and precise insights regarding the contracts. For creating and fine-tuning this system, the successful freelancer should possess: • Mastery with formulas and functions: A strong grasp and understanding of excel formulas and functions is essential to ensure the tasks are automated efficiently. • Display proficiency in pivot tables and data analysis: Effi...
I'm in need of a freelancer who can expertly design a payroll system in Excel, ensuring it has the capacity to print payslips. Any potential freelancer should ensure the system includes: - Employee information - Payroll calculations - Tax deductions Additionally, the following calculations need to be embedded into the system: - Gross salary calculation - Tax deductions calculation - Net salary calculation - Taxable Pay Year-To-Date (YTD) - Pay As You Earn (PAYE) Year-To-Date (YTD) Finally, the system should have the ability to accumulate leave days without affecting the salary. A template of the desired payslip will be provided later for reference. Skills and experience in Excel development, payroll system setup, and familiarity with tax calculation formulas are id...
...level 1 Use an excel file as a settings file, which file to open and for Sharepoint folder location (settings file) 2 Open three excel files which is specified in the 3 For each of the excel files go in excel to the tab Data> and click Refresh all. After that go to the specified tabs in the file for that file and right click on the pivot table to refresh the pivot table 4 Step #3 should be done per file, but the actions performed for the first file should be finished first before starting with the second and third file 5 Go to the specified Sharepoint link (in the settings file), and click on the in the specified excel file and select open in app. 6 Clear the in the specified rows for that relevant sheets and copy the data from t...
Looking for a large list of investors who have worked in or showed interest in various entertainment industries provide data in excel: name | company | industry | location | email address
I am currently seeking an experienced Excel and Visual Basic (VB) Automation Professional who is proficient in SAP Security. Key responsibilities will include: - Developing and automating report generation and analysis within the SAP Security module. - Automating workflows to enhance efficiency and accuracy. - Leveraging Excel and VB scripting skills to facilitate these automations within SAP. Additionally, localities in Pune are preferred due to the specifics of the project. The ideal candidate will demonstrate a strong understanding of SAP modules, particularly SAP Security, and be adept with Excel and VB scripting. Prior experience with SAP reporting and workflow automations will be highly beneficial for this project.
...calls, emails and potentially door knocking to attract potential clients. - Successfully communicating and promoting our services to elicit interest and convert into sales leads. Ideal Skills: - Experience in lead generation - Excellent communicator in both verbal and written form - Ability to use different lead generation channels effectively, such as calling and emailing - Data entry skills and proficiency in Excel - Cold calling and door knocking experience is a plus. I am looking for someone who understands the value of well-qualified leads and the impact it can have on a growing business, and I can't wait to start driving success together. Affiliate program provides for 12 months trailing 25% commission based on paid invoices net of any taxes and charges. Sam...
I'm seeking a skilled data entry specialist to assist in cleaning and formatting a substantial volume of data - more than 1000 entries. This crucial task will involve converting raw data into a more readable and user-friendly format in an Excel spreadsheet. Ideal Skills: - Proficiency in Microsoft Excel - Attention to detail and accuracy - Experience in data cleaning and formatting - Ability to handle large volumes of data Reliability, efficiency, and confidentiality are expected in handling this task. Prior experience in similar projects is highly desirable. Looking forward to your proposals.
As a Python specialist, your mission involves enhancing an existing Llama2 program to operate on Excel files within Google Colab. This project requires just a few hours of work, and a bit of the code is already completed. Key Tasks: - Implement Llama2 for data cleaning operations. Specifically, your role will include: - Applying given formulas to data - Sorting and filtering data according to set parameters Skills and Experience: - Proficient in Python programming language - Familiar with Llama2 - Experience working with Excel file manipulation in Google Colab is advantageous.
I am currently looking for an Excel expert to provide support with certain tasks. These include: • Data Analysis • Spreadsheet formatting • Creation and manipulation of formulas and functions Regarding the data analysis, I am open to suggestions on the best way to present the data. Whether that be through graphs, charts, pivot tables, or summary reports. Your task will be to work with just one spreadsheet that requires this assistance. Ideal Skills: • Expertise in Excel • Strong knowledge in data analysis, spreadsheet formatting and manipulating formulas and functions • Creativity in displaying data analysis Having a high-level understanding of Excel and the ability to display complex data i...
I'm seeking a brilliant Excel expert who can help with my moderately-sized project. The perfect candidate should possess: - Experience in data cleaning and formatting. My Excel dataset, consisting of between 1,000-10,000 rows, needs to be professionally cleaned and formatted, ensuring all data is structured immaculately. - Proficiency in data visualization and charting. With the cleaned and formatted data, I would need alluring, easy-to-understand charts and visualizations. An eye for aesthetics and layout would greatly benefit this deliverable. - Advanced statistical analysis and modeling skills - the final stage of the project would involve insightful statistical analysis and sophisticated modelling. A solid grasp of Excel's analysis f...
...sign-ins. Once signed in, they should be able to upload Excel files into the application, and the data should be automatically saved into our database will have one internal database table for customer sign-ups and another for the actual information from Excel files that they will upload into the database. The number of tables can vary, and you will decide the designing of databse tables as per the available data , backups, security, indexes . The design must be accurate and flexible, allowing for future scope expansion. Note - Only require experienced who have done similar work before. Please share your sample work as well. I am looking for a skilled developer to create a new web application that enables uploading of data into a database, by build...
...this desktop app is to import quiz content (questions and 3 possible answers each) from an Excel spreadsheet and transfer it to Powerpoint. Key Features: Excel to PowerPoint Integration: Seamless importation of quiz content (questions and three answers) from Excel to PowerPoint. Bulk Transfer Capability: Ability to bulk transfer quiz questions and answers at once. User-Friendly Interface: Simple and intuitive UI/UX that requires minimal technical expertise to navigate. Compatibility: Must be compatible with Microsoft Excel and PowerPoint 2016 or later, and Windows 10/11. Error Handling: The application should be able to identify and alert the user to any import errors or formatting issues in the Excel file. Project Requirements: Functionality: ...
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 HL...
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 advantag...
...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 ...
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...
...tasks. The 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 ...
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.
...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 administration support: To ensure everything runs smoothly and on time. - Creating Reports: Regular reporting to track progress. - Managing Email 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 indep...
...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...
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 ...
...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 job, as da...
...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.
We are searching a person that can work at the supermarket. The payment will be $12 for working hour (at least 75 scans in 1 hour). Only offer if you have at least 20 hours free in the week. This job involves going to a supermarket and taking photos of products (3 photos for each product). You'll only need a basic cell phone camera without editing photos. See attached sample photos. A list of product categories will be provided and there is no limit to the number of products to be shipped. If you are interested, leave a message and I will give you more information.
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 super...
I would like to add a cell from excel that display the draft amount in an email which changes for each line
...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 cha...
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 ...
I need an extensive research conducted, seeking for job postings of Chief Revenue Officer(CRO)...within USA or Midwest USA. The focus should be on direct company websites instead 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...
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 urgently require an experienced Yetiforce developer to tweak our Account module. The customization needed is the integration of a feature to take photos directly from a cell. This task requires immediate attention. • Module to Customize: Account - Integrate new cell photo-taking functionality Ideal Skills: - Proficiency in Yetiforce development - Experience in handling photo integrations on platforms - Ability to deliver under tight deadlines This immediate task will require a high level of expertise and professionalism. I would highly appreciate it if only experienced freelancers place bids.
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 c...
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 ...
I am looking for 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...
We need native Portuguese speakers from Brazil to help us with a recording project, and this data will be used to improve the accuracy of in-car speech recognition. You will need to record 110 simple sentences using a cell phone app. The sentencee may include car brand names. Please check the document in detail to learn how to read them before recording. Project Requirements 1: Native Brazil Portuguese speaker 2: Have a cell phone worth 200USD or more (purchase price more than 300USD) 3: Quiet recording environment and stable WIFI Payment 8USD Guideline: Test sentence: Hi Zeekr Ativar o controle climático Hi Zeekr 11 graus mais quente E aí Siri Defina a temperatura para 23 graus Siri Quero ouvir uma música rejeitar a ligação
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
