I have an excel SS that I need some quick formula help with. No VBA please. Table with expenses, then another table dividing up. I need the expense categories divided over months as per quantaty of time it is used. Explained in the SS attached. I need this done ASAP. Your responsibilities: - Understand the project financials and structure the Excel to match - Create a Gantt style tallies that captures my project expenses effectively Skills and Experience: - Solid expertise in advanced Excel functions - Experience in financial tracking, preferably in project management - Ability to work fast and deliver quickly Note: I didn't specify the expense categories so it should be customizable to accommodate any kind of expense. However, quick del...
I'm looking for an individual proficient in data entry, email management, online research, and making phone calls. Your daily tasks will primarily involve: - Performing data entry tasks using Microsoft Excel - Managing email communications effectively and promptly - Conducting online research as required - Making certain phone calls when necessary -Schedule is 9am-3pm CST (Monday-Friday) In addition, experience with project management software 'Click Up' will be highly favored. A strong work ethic, attention to detail, and excellent communication skills are fundamental for this role. The selected candidate will be expected to perform these tasks on a daily basis. Your ability to meet deadlines and work independently will contribute significantly...
I need a excel data sheet typist frequent in basic as well as skillful skills. There's no error in the formats and also professionally done with great effort.
Hey! I have experties on statistical analysis.
We are looking for a freelancer to scrape product information from Website and organize it in an Excel spreadsheet. Key Requirements: - The script should extract all text content and images displayed on the homepage need be add to excel file
...constantly updated depending on the configuration. 6. After completing the configuration, no order should be created in the system, but an offer should be created automatically as an Excel file, which is not sent to the customer, but to the office sales department, which checks the offer and can see which parts have been added, so that prices are added and finally sent to the customer. A second Excel file must also be created for production so that they know which parts are required for construction. 7. Synchronise article and customer master data between Majesty and Odoo. Majesty can only export the data using an Excel file and has no API. 8. Design customisation so that configurations that have already been made are collapsed, so that the page remain...
IA-calculated Excel Sheet Want to design an auto-calculated editable quotation, Purchase order, Invoice, and company letterhead in Excel and log-register quotation price and list in excel details as below All the Reports , Log, Purchase Order Quotation has to be Printed in PDF Sample Attached Customization is required as per our requirement The Provided Sample Sheets all Need to Be Combined in One Sheet Excel ERP Template Sales Pipeline Excel Template Excel Quotation Generator with Database Commercial Invoice Generator Excel Template Contractor Invoice Excel Template Vender List, Client List , Purchase order , Quotation & Invoice Log Excel Purchase Order Generator and Tracker Employee Attendance Tracker and Payroll Exce...
I'm looking for a freelancer to create an Excel dashboard that will be linked to a Microsoft PowerApp. The dashboard will be used for monitoring various data points. Key Details: - The dashboard will need to be dynamic and allow for updates directly from a database. - The successful freelancer will need to demonstrate experience in creating similar solutions in the past and provide a detailed project proposal for this task. The ideal candidate will have: - Proficiency in Excel, particularly in the creation of dynamic dashboards. - Experience with database connectivity and management. - Previous work examples that showcase their ability to create effective and user-friendly solutions. - Strong communication skills and a proactive approach to project...
I have a medium-sized Excel dataset that needs to be cleaned and analyzed. The tasks include formatting cells, filtering, and sorting data. Moreover, I'm looking for a professional who can conduct statistical analysis on this dataset. Key tasks: - Formatting cells: This involves making sure that the data is presented in a readable and visually appealing format. - Filtering and sorting: The freelancer should be able to organize the data in a way that makes it easy to understand and analyze. - Statistical analysis: The dataset needs to be analyzed statistically. This means that the freelancer should be proficient in statistical tools and techniques. Ideal candidate: - Proficient in Excel: The freelancer should have excellent skills in using Excel...
In need of a detailed-oriented freelancer for an alphanumeric data entry project using information sourced through online research. Key Responsibilities: - Source relevant information using online research methodologies - Accurately input alphanumeric data into a system - Ensure the final data is properly structured and error-free The final data should be delivered in an Excel spreadsheet format. Ideal Skills: - Experience with online research tools - Proficient in Excel - Fast typing skills - High attention to detail - Previous experience in alphanumeric data entry roles. The success of the project will be measured by the accuracy of inputted data. Proven examples of prior work in a similar data entr...
I am in need of a sharp and detail-oriented freelancer to assist me in a unique data entry task. Your primary responsibility will be to find pictures that correspond to specific words, and organize them in an Excel database. This project is crucial for the development of a comprehensive picture-based database. Key Responsibilities: - Search for images that match specific words - Organize the found images in an Excel database Ideal Skills and Experience: - Proficiency in using Excel for data entry - Strong attention to detail - Ability to efficiently find and match images - Prior experience working with picture databases would be a plus Please ensure that the images you find are high quality and in either JPG or SVG fo...
...for our construction project. This dashboard should pull data from Excel spreadsheets and provide valuable insights into our construction progress. Key Requirements: - Integrating Excel Spreadsheets: The primary data source for this project will be Excel spreadsheets. Your ability to connect and visualize data from this source is vital. - Construction Progress Monitoring: The dashboard's main focus should be on monitoring our construction progress. This includes: - Project Timeline: Displaying where we stand in terms of project timeline against the planned schedule. - Budget Utilization: Visualizing how the budget is being utilized in real-time. - Resource Allocation: Demonstrating how resources are being...
I'm looking for a professional freelancer to convert a 300-line PDF bank statement into an Excel report for reporting purposes. The specific bank statement details that need to be included are Date and Description as well as Debit and Credit amounts. Key Requirements: - Extract date and description details from the bank statement - Extract Debit and Credit amounts from the bank statement - Must have a clear understanding of date formatting in Excel Ideal Skills/Experience: - Must have extensive experience in data entry and Excel - Should have a good understanding of banking terms - Attention to detail is critical - Previous experience in bank statement conversion will be advantageous.
We are looking to collect the current prices for 5 specific procedures from lo...clinics. We need a call center to call 200 dental clinics from a list that we have already created to inquire about pricing. You will be calling as if you are an interested patient inquiring about getting the procedure. You will then fill out the 5 procedure costs on the excel sheet. We are hoping to hire a call center that speaks English with minimal accent. We have a general script. Each phone call should not last more than a few minutes. You need to have more multiple people on your team as we would like this project done very quickly. You also must be able to call from a US based phone number and have it show up on the caller ID. Start immediately. Pay is $250. Do not bid higher, as we wi...
I'm looking for someone proficient in Excel to assist with data entry and basic data analysis. Requirements: - The task involves entering numerical data into an Excel sheet. - The data is for both analysis and record-keeping, so accuracy is crucial. - I also need some basic Excel functions applied to the data, particularly summation and averages. Skills & Experience: - Proficient in Excel with experience in data entry - Knowledge of basic Excel functions (sums, averages) - Attention to detail for accurate record-keeping - Some experience with data analysis would be a plus Looking forward to your bids. Thank you.
...handle both copywriting and Excel data analysis tasks. For this project, the copywriting will need to be informative in nature. Aim it towards industry professionals, with the intent of providing detailed information in an engaging, digestible format, not advertising or branding. Excel expertise should include, but not be limited to, proficient data analysis capabilities to make sense of complex datasets. Ideal skills for the job: - Proven experience in copywriting, specifically informative writing. - Strong knowledge of Excel, particularly in the field of data analysis. - Ability to communicate complex information in an understandable manner to industry professionals. - Excellent attention to detail. - Proactive and able to work within ...
I'm seeking an individual proficient in Excel, with significant experience specifically in entering statistical data. The task revolves around efficiently and accurately typing numbers into an Excel sheet, which will then be processed for statistical analysis. Key Responsibilities: - Accurately input numerical data into Excel - Familiarity with statistical data is advantageous - Format inserted numbers as percentages Ideally, the individual will have stellar attention to detail, the ability to work under tight deadlines, and a strong grasp of handling statistical data. Prior experience in a similar role will definitely give you an edge.
I'm looking for a professional who can assist me with organizing financial data in an Excel sheet. This organized data will be used for reporting purposes. Key Responsibilities: - Inputting and arranging financial data - Ensuring accuracy and consistency of data - Creating a well-structured Excel sheet for reporting Ideal Skills and Experience: - Proficiency in Excel and data entry - Attention to detail and accuracy - Understanding of financial data - Experience with creating reports from data The successful freelancer will need to have a keen eye for detail, as the accuracy and correctness of the data is crucial for its utilization in our reporting.
...of an Excel database creation expert to help me establish a system to store and manage customer information. The project is time-sensitive, so I need someone who can get on it ASAP. Key Responsibilities: - Building an Excel database for customer information, possibly by using Chat GPT for data population - Ensuring the database is well-structured and easy to navigate for future reference - Implementing any necessary formulas or functions that can enhance the utility of the database - Ensuring the project is completed in a timely manner, as I need it done ASAP Ideal Skills: - Proficiency in Excel, with experience in database creation and management - Knowledge of using Chat GPT for data entry is a plus - Ability to structure data...
...of an Excel database creation expert to help me establish a system to store and manage customer information. The project is time-sensitive, so I need someone who can get on it ASAP. Key Responsibilities: - Building an Excel database for customer information, possibly by using Chat GPT for data population - Ensuring the database is well-structured and easy to navigate for future reference - Implementing any necessary formulas or functions that can enhance the utility of the database - Ensuring the project is completed in a timely manner, as I need it done ASAP Ideal Skills: - Proficiency in Excel, with experience in database creation and management - Knowledge of using Chat GPT for data entry is a plus - Ability to structure data...
...handle both copywriting and Excel data analysis tasks. For this project, the copywriting will need to be informative in nature. Aim it towards industry professionals, with the intent of providing detailed information in an engaging, digestible format, not advertising or branding. Excel expertise should include, but not be limited to, proficient data analysis capabilities to make sense of complex datasets. Ideal skills for the job: - Proven experience in copywriting, specifically informative writing. - Strong knowledge of Excel, particularly in the field of data analysis. - Ability to communicate complex information in an understandable manner to industry professionals. - Excellent attention to detail. - Proactive and able to work within ...
...meticulous assistance with several data entry tasks. This is a three-pronged job involving: 1. Entering Contact Information: You will input a myriad of contact details into an Excel spreadsheet. Accuracy is paramount. 2. Updating Databases: You'll be responsible for ensuring that all existing data is up-to-date. If a discrepancy is noticed, you will correct it. 3. Transcribing Documents: Transcription services are required. You need to accurately transcribe information from diverse documents. In addition to the aforementioned tasks, this job involves email verification for all entries; without exception. Needless to say, your keen attention to detail would be required to spot and correct any errors. The ideal candidate would have past experience with Exce...
...monthly targets of 150 salons signed and 3,000 app downloads to qualify for performance bonuses. Provide real-time geolocation updates during field movements. Candidate Requirements: Minimum 2 years of experience in B2B sales, preferably within the beauty, wellness, or tech industries. Strong understanding of sales strategies and customer relationship management. Proficient in Excel and capable of managing basic sales data analysis. Exceptional communication and interpersonal skills. Ability to commit to BookBook's unique brand and sales approaches. Must be organized, self-motivated, and capable of working under pressure to meet sales targets. Compensation and Incentives: Monthly salary of £2,000 after taxes. Promising £4,000 compensation following a succe...
...record includes creating and designing courses that resonate with diverse audiences, driving engagement and delivering tangible results. ⏰ **Timing Mastery**: You understand the importance of pacing and timing in course delivery. You'll orchestrate the flow of content to keep participants engaged and motivated every step of the way. ✍️ **Copywriting Skills**: Beyond just instructional design, you excel in crafting compelling copy that speaks to our target audience. Your words will inspire action and drive enrollment. ? **Quality Assurance**: Attention to detail is your middle name. You'll conduct thorough testing of the course materials to ensure seamless functionality and a superior learning experience. But that's not all! In addition to course creation, you&#...
Estoy buscando un asistente virtual y administrativo para realizar las siguientes actividades operativas en un negocio: Revisar y agregar datos en documentos de Excel. Elaborar reportes en Excel. Gestionar la agenda de proyectos. Revisar y agregar tareas de proyectos en el calendario. Redactar minutas y resúmenes de juntas. Establecer prioridades de actividades. Registrar datos generales como facturas, órdenes y proveedores en el sistema ERP. Crear manuales de procedimientos en Word. Herramientas de manejo: Excel a nivel avanzado. Loop o Notion. Conocimiento de los procesos de un ERP. OneDrive (administración y manejo de archivos). OneNote y Word.
I need a freelancer with a deep understanding of Excel ,data management and social media to extract info from profile list that we have . As the project involves organizing approximately 20,000 rows of data, proficiency in handling large datasets will get you far in this task. Key Project Details: - Data Type: The data primarily comprises email addresses and phone numbers. - Links in Profile - Other profiles in the profile - Formatting: The data files contain labels, so you'll need to distinguish this information keenly. Ideal Skills: - Proficient in Excel - Expertise in data management - Data Scraper
I need an expert with strong Excel skills to create two simple line graphs. Though I didn't provide specifics, these will be used to illustrate financial data, so experience in creating graphs for financial analysis would be ideal. Fast turnaround is critical. I will share 2 images of sample graphs. You need to put same data but have to create it line graph and in excel. I need this now. If you can't do now then please dont waste my time.
I require a professional who can develop a detailed sales forecasting report leveraging Power BI. The project needs to be done within one day. Key Requirements: - Utilize data from Excel spreadsheets for the forecasting. - The sales forecast should be detailed, breaking down sales by product/service. - The forecasting model should be based on regression analysis. Ideal Skills: - Proficiency in Power BI. - Strong experience in Excel data analysis. - Proven track record in regression analysis for sales forecasting. - Ability to work under tight deadlines.
I am in need of a Visual Basics code in Excel that specifically focuses on equipment check-in and check-out functionality, while also automatically creating a record for each transaction. Key Features: - Equipment Check-in and Check-out: The primary purpose of the program is to allow users to easily check equipment in and out. - Automatic Inventory Status Update: The program should update the inventory status automatically, ensuring that the availability of each item is always up to date. Additional Features: - Daily Reports: The program should generate daily check-in and check-out reports - this would be beneficial for managing equipment usage and tracking. - Statistics: The program should also provide statistics on equipment usage. This could help in determining patterns of usag...
Transferring data from a jpg file to an excel table. With online access via google
I'm looking for a Power BI expert to help me set up a robust sales forecasting system. Responsibilities: - Integrate my Excel spreadsheets into Power BI Desktop - Design visually appealing and intuitive dashboards that clearly display sales forecasts - Utilize Power BI's capabilities to predict sales trends Ideal Skills: - Proficiency in Power BI Desktop - Expertise in Excel spreadsheet integration - Proven track record in sales forecasting - Strong communication skills to understand my business and its sales forecasting needs This project requires someone who can not only set up the technical aspects but also has a deep understanding of sales forecasting.
I have a set of less than 10 excel spreadsheets that I use for various purposes. I'm looking for a talented professional who can re-work these sheets eliminating redundancy. Key objectives: - The primary goal of this rework is to automate repetitive tasks. I'm looking for someone who can introduce VBA scripts and macros to help me achieve this. - The spreadsheets are both independent and share common data. It will be important to create a system that can handle both types of sheets. Ideal skills: - Proficiency in Excel, VBA, and Macro programming is a must - Experience with data manipulation and automation - Ability to understand and work with a mix of independent and shared data I'm open to discussing the project requirements in...
...am seeking a proficient web data scraper to extract specific information from a prominent South African property portal and organize it in an Excel spreadsheet. Key Project Requirements: - Extracting and organizing the following data: property information (e.g., price, location) and size. - No need for continual updates, just a one-time extraction. Filtering Criteria: - The data to be scraped should be from a particular property portal and should extract information like : property type (industrial/retail/office), size, address, price. Ideal Skills: - Proficiency in web scraping techniques and tools. - Strong experience with Excel and organizing large sets of data. - Familiarity with the South African property market would be a plus....
...Requirements: - Research: This project demands high-quality research skills. You will need to locate and verify the schools that meet our criteria. - Mapping: Proficiency in using online mapping tools is essential. - Data Management: The final report should be in Excel format. Experience handling and analyzing data in Excel is a must. - Need to confirm they have sports facilities - Data needed is Name of school - distance to tube - address - Phone number off the school site There is a list of 151 schools already on the list these will be provided and can not be used. The budget is $25 to start but if it goes well will become full-time for 4 to 12 weeks. We have other areas outside London coming up as well. The final output should be a com...
convert gramms per second to litres per m thermodynamics fluid in excel calcualtor pv=nrt
I have a number of JPEG images with text which I need to be transcribed into an Excel spreadsheet. The task should take around 2 - 3 hours to complete. Key Requirements: - Convert text from JPEG images to an Excel spreadsheet - Organize the data into categories as requested - Implement numeric data validation checks for accuracy Ideal Skills: - Proficient in data entry and data management - Familiarity with Excel and its functionalities - Strong attention to detail and accuracy - Experience in implementing data validation checks Please ensure that before submitting, you are confident in your ability to deliver an error-free and well-organized Excel spreadsheet.
I have a PDF catalogue that I need converted into an Excel spreadsheet. The PDF contains a mix of text and images which are crucial for the data. Key requirements: - Extract the data from the PDF and input into an Excel sheet. - Embed the images within the corresponding cells in the Excel file.
I require an accurate and efficient individual to input a combination of numeric and text data into a spreadsheet. This will involve less than 1000 entries. The primary task will be to input shipment data from Bills of Lading (BOLs) into an Excel file (.xlsx). The data must be organized based on specific categories found in the BOLs. Therefore, attention to detail and a keen eye for categorization is crucial. NOTE: BOL's shipped to the same location (multiple BOL's) must be added together on the same line. EXAMPLE: 1/1/2024 (5 Pallets) To Store #2595 2/1/2024 (4 Pallets) To Store #2595 NOTE: There are two types of BOL's a. Multiple Stop BOL"s. These will have 4-5 store location drops / entries to be made. b. Si...
Expert in MS excel for automation of sheets
Am nevoie de extragerea unor anumite date dintr-un fisier pdf si exportul intr-un excel. Daca urc un pdf intr-un folder trebuie extrase anumite date si importate in excel, daca apare ualt pdf, va fi extras la fel, daca modific un pdf existent date trebuie sa se modifice in excel
I'm looking for a skilled freelancer to help me customize my Excel alerts with WAV files. - I have the specific sounds in mind for each type of alert, but I need someone who can skillfully integrate these into Excel's alert system. - You should have experience in both Excel and sound file manipulation, in order to create a seamless and professional system. - Please provide examples of past work to showcase your compatibility with this project.
...an Excel file that I'd like to convert to a Google sheet. I need the Google sheet to keep all the formulas that are present in the Excel file. Key Requirements: - The Google sheet should have all the formulas intact from the original Excel file. - Include Data validation rules to ensure the data entered is accurate and meets certain criteria. - Implement Conditional formatting to visually highlight important information. - Custom scripts or functions to automate certain tasks and enhance the sheet's functionality. - Preserve font styles and retain cell borders from the original Excel file. - Maintain the column widths as in the original Excel file. Skills and Experience: - Proficiency in Excel and Google Sheets, includ...
I'm in urgent need of a talented designer who can create high-quality animated images and GIFs for my project. This is a long-term position, so I'm seeking someone who can deliver consistent, top-notch work. Key Requirements: - Proficient in designing and producing 2D and 3D animations. - Capable of creating engaging and effective GIFs. - Able to deliver high-quality work on a tight deadline. - Previous experience creating animated content. Please include your past work in your application. The selected freelancer could have the opportunity to work with me in the future.
I'm looking for a professional who can help me develop a comprehensive Excel workbook for RFQ analysis and purchasing. The primary goal of this tool is to streamline our purchasing process. Key Responsibilities: - Develop an Excel spreadsheet for RFQ analysis and purchasing. - Implement basic formulas and functions to automate data analysis. - Ensure the tool is user-friendly and easy to navigate. Ideal Skills and Experience: - Proficiency in Excel and advanced knowledge of its functions. - Experience in developing purchasing and analysis tools. - Ability to streamline processes through automation. This is an exciting opportunity for someone with a keen eye for detail and a strong understanding of purchasing processes. Looking forward to your proposals...
I'm looking for a diligent researcher who can compile a list of tire processors across different US states and organize the information in an Excel spreadsheet. Key Responsibilities: - Conducting online research to identify tire processors in each state. - Collating specific information (company name, contact person, phone number) for each processor. - Inputting the data into an Excel spreadsheet with consistent formatting. The ideal candidate should have: - Proficiency in web research and data entry. - Excellent attention to detail. - Strong Excel skills, with knowledge of maintaining consistent formatting. - Prior experience in conducting similar research would be an added advantage. The final list should be organized by state, with each entry c...
I'm looking for an expert in data analysis to assist with a project in Excel. The data provided is well-structured and needs extensive examination to extract meaningful insights. Ideal Candidate Skills: - Proficient in Excel and its data analysis tools - Strong analytical abilities - Excellent understanding of data organization Deliverables: - Clear analysis of the structured data - Relevant insights extracted from the data - Detailed reporting on the findings This project is particularly suited to those with a keen eye for data and the ability to utilize Excel's functionalities efficiently. Thanks!
I am looking for a dedicated and detail-oriented data entry operator to assist with a large volume of data entry tasks. Key Responsibilities: - Typing, copying and pasting, data validation - Handling a large volume of entries Ideal Skills and Experience: - Proven experience in data entry - Expertise in handling large datasets - Proficiency with text documents (Word, PDF) and spreadsheets (Excel, Google Sheets) - Attention to detail and accuracy - Time management skills to handle large volumes of data
I need an Excel spreadsheet that allows me to input a starting point's latitude and longitude, a heading (in degrees), and a distance (in kilometers), and then calculates the new latitude and longitude based on a rhumb line calculation. This tool will be primarily used for navigation purposes. Key Features: - Input fields for starting latitude, starting longitude, heading, and distance (all in kilometers) - Calculation of a new latitude and longitude based on the input - Utilization of the Rhumb line formula for the calculation Ideal Skills: - Advanced Excel proficiency - Understanding of geographical coordinate systems and navigation - Experience with mathematical calculations in Excel - Prior experience in developing navigation tools would be a plus This p...
I'm looking for a freelancer to help with the data entry of a combination of text and numerical data into an Excel sheet. The data will be provided in digital text files. Key Requirements: - Proficiency in Excel and data entry - Attention to detail - Ability to accurately enter both text and numerical data Experience in similar projects will be an added advantage. Please include any relevant samples or references in your bid.
