How to create an excel spreadsheet with formulasงาน

...want users to be able to input a large list of company names and receive an output in a downloadable Excel sheet. Although I initially explored utilizing an [API from ](), I encountered difficulties with downloading data or obtaining an API key, possibly due to issues with their website. but was able to find [this csv file on kaggle]() containing information of companies from 1857-2020. My initial approach is to use appwrite for backend and react for frontend. populate the appwrite db with information from the csv file. then build the react frontend. however I can't help but wonder that there must be an easier way to do this. How would you

I would like to receive a price quote for making phone calls according to the following details: Territory: Scandinavia Number of records: 400 The purpose of the conversation: to find out if the company still exists and why they stopped buying Background: We are a company that sells aluminum frames for the sign industry to sign manufacturers in the world, including Scandinavia Zone]. These records are of companies that have purchased from us in the past for some amount. From 20 euros to hundreds of thousands of euros, and they stopped a year or more ago. The purpose of the conversation is to check whether the company still exists, whether it is still in the field and why they stopped purchasing. We have prepared a dedicated link for filling in th...

I would like to receive a price quote for making phone calls according to the following details: Territory: Netherlands Number of records: 58 The purpose of the conversation: to find out if the company still exists and why they stopped buying Background: We are a company that sells aluminum frames for the sign industry to sign manufacturers in the world, including Netherlands. These records are of companies that have purchased from us in the past for some amount. From 20 euros to hundreds of thousands of euros, and they stopped a year or more ago. The purpose of the conversation is to check whether the company still exists, whether it is still in the field and why they stopped purchasing. We have prepared a dedicated link for filling in the resu...

I am in need of a skilled data entry operator to assist with the transfer of input of text data. Your main task is to take text data from an online database and accurately enter it into an Excel spreadsheet. Requirements: - Ability to accurately enter text data - Proficient in Excel - Experience sourcing data from online databases - Diligent and detail-oriented to ensure no errors are made during data transfer - Strong English language skills to ensure effective communication The ideal freelancer for this project is someone with proven data entry experience, excellent Excel skills, and vast familiarity with online databases. Being a detail-oriented person with great concentration s...

...Deadline: 1 Day Project Budget: $50 Project Type: PHP (8.2 and above) Server Type: Linux Ubuntu Project Overview: We have an existing PHP script that calls the OpenAI API & outputs the response in decoded JSON format. We want to add Replicate API () to the script so we have the option of using the Replicate API instead of the OpenAI API. A user should be able to specify which API the script should use via a line in the code. So... - Currently: Script uses OpenAI API - New Version: Script uses both OpenAI API & Replicate API The output format from Replicate API must match the OpenAI API response, as the output is used in an existing Web App. New API Documentation: 5* FEEDBACK WILL

...multiple Excel slicers into one for our data analysis needs. The requirement is, I want to use same Slicer for multiple data. Detailed description is as follows: I have a accounting sheet. Where in one separate sheet I have captured Incomes along with the date and amount and other sheet I have put Expenses along with Date and amount. Now in summary sheet I am using Income pivot table, where I am using Slicer on Date (Merged for Months and Years). I want the same slicer to be used for Expense pivots as well. The ideal freelancer for this job should be proficient in: - Excel - Slicers and PivotTables - User experience design - Data analysis techniques Your input and expertise in this project can help streamline our data manipulation process...

...looking for an Excel and VBA expert to help streamline my workflow and boost productivity. You'll be responsible for: - Automating repetitive tasks: I need you to develop efficient scripts that will handle routine operations in the spreadsheets, eliminating the need for manual intervention and enhancing the overall efficiency. - Crafting custom functions: The custom functions I require are complex and involve external data sources. Your role will involve creating these functions effectively, ensuring they are accurate and function seamlessly within the Excel environment. The ideal candidate will have extensive experience in Excel, VBA, and creating complex custom functions. Solid understanding of data analysis and automation is crucial f...

Only two site links need to be implemented identically: = One-time check of Naver Place ranking = Daily check of Naver Place ranking for keywords and registered businesses Use the following credentials for testing: ID: qmfh123 PW: qmfh123! You'll understand better by trying it yourself. After implementing the two links above identically, additional features should be added: When registering for Naver Place ranking check, users can register up to three keywords: For example: "강남맛집, 압구정맛집, 서울맛집" (Keywords) - "강남로코컴플렉스" (Business name) For example: "강남맛집(강남로코컴플렉스) 11위, 압구정맛집(강남로코컴플렉스) 6위, 서울맛집(강남로코컴플렉스) 30위" Member functions - Permission separation into Master, Manager, and Team Leader: Master

...research. You will have to be fluid with excel, online reasearch tools. This is a posting for a long-term VA who can perform various forms of online research and other tasks. Personal attributes required: 1. Speed and efficiency in online research. 2. Attention to detail and complete accuracy in all tasks. 3. Punctuality and ability to meet deadlines. 4. Ability to read/follow instructions carefully with attention to detail. Successful candidates will be required to complete two test works before the project is awarded. 1. Watching instructional video which explains the task. 2. Completing an 11 question quiz based on the video instructions. 3. Completing a small sample test on 5 medical centres to demonst...

Looking for someone to go to a few sites and make me an excel sheet with all the listings on the site . Must speak fluent English

I'm in need of a meticulous professional to clean a mixed set of data contained in an Excel file. I am specifically struggling with duplicate values and missing entries. To effectively accomplish this: - You should possess excellent skills in data analysis and data management. - Previous experience with Excel-based data cleaning is preferable. - Profound knowledge of dealing with duplicate entries and filling in missing data is required. - A keen eye for detail and ability to spot and correct errors is essential. In summary, my ideal candidate would be someone with significant experience in data cleaning, particularly with mixed data in Excel files. It would be a bonus if you've previously r...

I need an adept data entry freelancer to skillfully convert text data from various online sources into an organized Excel spreadsheet. You'll reap the benefits of this project if you're detail-orientated, familiar with navigating online sources, and proficient in Excel. - The project involves researching, collecting and collating text data from specific online sources - The final deliverable needs to be an Excel spreadsheet, with data arranged legibly - Demonstrable experience in data entry jobs would be ideal - A keen eye for detail is paramount as exactness is key for this data entry task - You should be comfortable working with Excel and have proficiency in using all its feature...

I need a proficient excel expert to help me with a data entry project. The data involves simply names, emails, and phone numbers. It will be a table with 100-500 entries, so proficiency in data entry and Excel is crucial. Key Requirements: - Accurate Data Entry: The job is primarily about accurately transferring names, emails, and phone numbers from a document to an Excel sheet. - Excel Proficiency: Knowledge of Excel functions is a plus, though not specifically required. You should be comfortable working with a table of this size.

I'm in need of comprehensive and detailed Australian databases. Specifically: - Medical databases, with a key focus on medical specialties. Medical databases should preferably contain reliable and relevant information about the different branches of medical specialties across Australia. - Business databases, encompassing detailed company profiles inclusive of industry category, phone, fax, email, physical address, etc. I'd appreciate getting more data, as in-depth as possible. The databases should be pre-existing or scraped and must be provided in Excel format, or .BAK for MSSQL server. Professionals equipped in big data collection, scrapping, and data analysis would be the most suited for this project. Knowledge about Australian medical and business sectors woul...

โปรดลงทะเบียน หรือเข้าสู่ระบบ เพื่อดูรายละเอียด

I need a freelancer to assist with accurate and efficient data entry into Microsoft Excel. The data is in digital format and involves numeric values. Key Requirements: - Enter numeric data into Microsoft Excel from provided digital sources - Ensure data is accurately transcribed - Maintain confidentiality of the data Ideal Freelancer: - Proficient in Microsoft Excel - Strong attention to detail - Previous experience in data entry, preferably with numeric data - Ability to maintain data integrity and confidentiality. Note: Please ensure you have a copy of Microsoft Excel for this job.

I am in need of a professional who can help provide insights into a dataset using Excel's pivot charts, tables, and dashboard. The area of the data is unspecified as of now, but a strong candidate would be adaptable and skilled across domains. Key responsibilities will include: ...Excel's pivot charts, tables, and dashboard. The area of the data is unspecified as of now, but a strong candidate would be adaptable and skilled across domains. Key responsibilities will include: - Data Visualization - Creating Pivot Charts - Building Tables - Preparing a Dashboard Note: This project is basic-level work and my budget is 10 not more than that I already checked price comparisons with different freelancing platforms. if anyone works in that price range only the person make bids ...

...details## I have an existing Online Stamp Inventory for Postal Stamp Collectors in my site. It is made in CakePHP. I need to add some features to it and repair current feature. I want to add Export feature, improve search feature and add the feature of uploading images/document, repair Year field, URl field, make the current captcha and email verification system better. Further, I need to add Subscription feature. Free Users can add limited number of entries whereas Paid Subscribers can get full features. See the site: This is very easy Project. Just making Form fields and report generating. Lowest bidder will win this project. You don't need to develop any new website or web design. Just a basic look will do. I need to deploy i...

I'm looking for a professional writer to draft a comprehensive, easy-to-follow guide on how to "l7as tizi" for personal use. The final output must be a text-only document. Key requirements include: - Comprehensive: The guide should cover all aspects of "l7as tizi" that are crucial for a beginner to know. - Easy-to-Follow: It should be written in a clear, concise, and engaging manner. Avoid using technical jargon or overly complex language. - Personal Use: The guide is intended for my personal use, so it should be tailored to suit my needs and knowledge level. Ideal skills and experience for this project include: - Proven experience in technical writing or creating how-to guides. - Excellent written co...

Necesitamos una hoja de excel donde podamos introducir datos y sea dinamica, os enseñaria un ejemplo de algo que ya tenemos hecho Solo Hispanohablantes por favor, sino es muy complicado el entendimiento

O trabalho consiste em digitar 140 páginas de extratos que estão em PDF para uma planilha do Excel, conforme modelo (os extratos a serem digitados e o modelo de planilha estão nos anexos deste projeto)

...Sales Specialist with a mid-level experience in enhancing our Service Sales. (5 Sales Specialist needed). Key Requirements: - Fluency in English and Spanish - Mid-level experience in sales. Ideal Skills and Experience: - Proven track record in service sales - Strong communication and negotiation skills - Bilingual proficiency in English and Spanish - Ability to excel in a fast-paced environment. The Sales Specialist will focus on sales effectiveness through phone calls. The primary target market is the Telecom/Home service. The ideal candidate should have a solid understanding of this market and be able to communicate effectively in both English and Spanish. Training on our Services and related will be given. We offer excellent Commissions. Join our team...

I am looking for a freelancer who is proficient in data entry and familiar with Excel to assist in the digitization of a 276-page vintage parts manual. Your task would be to: - Accurately copy the information from pdf to Excel. This includes part numbers, the description of parts, and all other columns present in the original tables in the document. - Organize the spreadsheet such that each section of the document is represented by a separate worksheet. No specific data validation rules or cell formatting are required, but the data must be accurate and searchable in Excel. This job requires someone with a keen eye for detail and a good understanding of Microsoft Excel. Prior experience in similar data entry tasks woul...

I am looking for Individual to Create a static website for my cloud based pathology lab management software. i have every thing domain, Hosting, Stock Photos and graphics are Provided by us. your job is : 1. Create a code for a Responsive multipage website using PHP, HTML, CSS (4 page Home, About software, About us, contact ) 2. Create editable header, footer and menu for easy editing. 3.. Content writing and arrange the things together. 4. SEO Key word (to Prove your skill in SEO) we have this awesome trample too if you're good on edit

...designer who can create a minimalist, illustrative Instagram graphic for my latest blog post titled "How to Get Your Business Phone Registered to Avoid Spam Labels". Key Requirements: - Minimalistic Design: The graphic should be clean, simple, and in line with a minimalistic aesthetic. - Illustrative Style: I'm looking for an illustration rather than a photographic or typographic design. - Business/Communication Elements: Incorporating telephone or mobile icons into the design is a must. The design should subtly communicate the main theme of the blog post without being overly busy or cluttered. The winner will be asked to provide a Canva template, so please design your samples in Canva. Here's the blog post:

...Simple Product Attributes to create them I am looking for an experienced Magento developer to create a configurable product programmatically using existing simple product attributes. The ideal candidate will have expertise in both front-end and back-end development of magento 2. Scope of Work: - this work is NOT to convert simple products to confirguable products - Create all configurable products for a product catalog of over 150,000 simple prodcuts in Magento 2 using existing simple products so make a configurable product made from the simple products - Programmatically generate the configurable products from the data in the simple products - Ensure that the configurable product is functional and displays correctly on the fron...

Looking for an expert who can import data from 1-10 Excel files into Google Earth. Key tasks: - Convert location data from Excel into a format readable by Google Earth (preferred Google Eath Pro Tours for Commercial Real Estate Properties - Ensure perfect alignment of data with the geographical locations - Grouping and categorizing the locations as per the content of each column within the Excel files Ideal candidate: - Proven experience with data visualization tools, particularly Google Earth and Google Earth Pro tours for Commercial Real Estate Properties -- High proficiency in handling Excel files and data - Understanding of Geographical Information Systems would be a bonus.

I have a MySQL database that needs exporting. All user data, product data, and transaction data are required to be exported. Key Tasks: - Export all MySQL user data - Export all MySQL product data - Export all MySQL transaction data The final export should be in Excel format. This is not a job for beginners. You should have prior extensive experience with large database exports and MySQL. It would be a big plus if you're familiar with handling sensitive user and transaction data. As the project involves substantial data, confidentiality and data security are non-negotiable. Please include samples of similar database exporting projects you've completed.

I am in need of an Excel spreadsheet expert to create an Excel template using a PDF sample. Without being specific about the details, the ideal candidate should have excellent skills in extracting data from PDFs and well-versed in designing Excel templates. Here's what I'm looking for: Mactacquickshipsellsheet pdf converted into an excel sheet example of what I would like as template.

Comedy Artist team to create Comedy YouTube shorts for our channel Created videos will be our copyrighted content, your team cannot reuse the video anywhere. Also it needs to be fresh videos that have not been posted anywhere earlier.

...Solutions team currently manages an internal workforce partner database developed in-house and updated internally. This resource, currently in an Excel spreadsheet format, is used to assist employers in navigating our regional workforce programs and partners. To enhance its utility in responding promptly to RFIs (Request for Information), we aim to reinforce this database tool. Our objectives include implementing organizational features with multiple tags for efficient categorization and establishing a user-friendly update and maintenance system that does not require consultant engagement. 2. Objectives: i. Objective 1: Enhance Database Organization 1. Introduce multiple tags for easier navigation and filtering of informati...

I'm in need of an Excel expert to help me with intermediate-level spreadsheet formatting. The tasks include moving data from sheet to another sheet Ideal Skills and Experience: - Proficiency in Excel

Hi Izhan A., I noticed your profile and would like to offer you my project. We can discuss any details over chat.

I am looking for a freelancer to assist me with a data entry project. The task involves typing data from handwritten documents into a digital format. The data must be formatted in a specific way, so attention to detail is important. Skills and Experience: - Proficient typing skills and accuracy - Experience with data entry and handling handwritten documents - Familiarity with formatting data according to specific guidelines - Ability to work efficiently and meet deadlines The project includes 1-10 pages or documents that need to be entered. If you are interested in this project, please provide examples of previous data entry work and explain your experience with formatting data.

I'm looking for a talented Excel programmer to build an Excel tool tailored for my business' quotation procedures. Notably, this tool must provide these key functions: - Automatic Price Calculation - Customized Quotation Template Design I already have a specific design in mind for the quotation template and would require the freelancer to implement my design concept accurately. A potential candidate should have considerable Excel programming skills coupled with a solid understanding of quote creation processes. A sense of accuracy, creativity, and robust attention to detail would be beneficial for this task. Outputs should be precise and user-friendly, ultimately contributing to streamlining our current operations.

I'm looking for a talented Excel programmer to build an Excel tool tailored for my business' quotation procedures. Notably, this tool must provide these key functions: - Automatic Price Calculation - Customized Quotation Template Design I already have a specific design in mind for the quotation template and would require the freelancer to implement my design concept accurately. A potential candidate should have considerable Excel programming skills coupled with a solid understanding of quote creation processes. A sense of accuracy, creativity, and robust attention to detail would be beneficial for this task. Outputs should be precise and user-friendly, ultimately contributing to streamlining our current operations.

I'm looking for a skilled Excel expert who can help with adjusting product pricing, adding products, creating formulas, adding products etc via excel, .csv. This is a ongoing project. If you can upload .csv to wordpress is a big plus!! KEY REQUIREMENTS: - I specifically need assistance with spreadsheet automation. - The work required is at a basic level, focusing on formulas and functions. - Implement automation for the designated tasks. - Ensure that the automation is robust and well-documented. SKILLS & EXPERIENCE: - Proficiency in Excel is a must. - Experience in basic spreadsheet automation. - Strong understanding of formulas and functions. - Attention to detail and commitment to q...

I'm looking to develop an Artificial Intelligence (AI) charges calculator for Excel. The core functionalities include: - Automatic calculation of fixed charges - User-friendly interface for effortless interaction and data management. - Reliable data input validation to ensure accuracy and consistency. - Calculate Profit based on fixed charges and earning from subscription The calculator will primarily handle financial data. Prospective freelancers should have a strong grip on Excel, data validation, and UI/UX design—along with financial acumen for effective calculator development. A successful execution ideally enhances efficiency and aids with precise financial management.

...of homemade skincare, I need expert consultation. My brand is in its infancy and set to scale primarily on creams and lotions - all made with natural and organic ingredients. • Product Formulation: Looking for a professional with deep knowledge in formulating organic creams and lotions. You should have a wide scope of natural ingredients and their properties to help generate effective formulas. • Legal Requirements: Understanding the legalities of the skincare industry is equally vital. I need guidance on the regulations and compliances needed to run this business. Ideal candidates should have considerable experience in the skincare industry, especially in organic product formulation – familiarity with legal requiremen...

I'm in need of a meticulous and reliable freelancer to assist with online data entry tasks. You'll be required to input data into spreadsheets using platforms like Excel or Google Sheets. The data will be provided to you in digital formats, such as PDFs, Word documents, or scanned images. Key Requirements: - Proficiency in online data entry - Experience working with spreadsheets (Excel, Google Sheets) - Ability to maintain accuracy and attention to detail - Familiarity with handling data in digital formats Ideal Skills: - Previous experience with similar data entry projects - Proficiency in using Excel or Google Sheets - Background in spreadsheet management - Strong attention to d...

I am in search of a proficient data entry specialist to integrate data into my online Microsoft Access database. Key Responsibilities: - Entry of a large volume of data accurately and efficiently - Verify the integrity of data before entry into the database Ideal Skills and Experience: - Proficiency with Microsoft Access - High attention to detail, precision and excellent organizational abilities - Prior experience with large database data entry is a plus Please note, the spreadsheet format requirement was skipped and so any standard format is acceptable. Only apply if you are proficient, accurate, diligent, and can meet deadlines.

I would like a custom sales order created in Excel for about 50 different items. Key Requirements: - Each item's entry in the order should include item name, quantity, and description. - The items should be sorted by their ship date. - The system should incorporate a feature to apply a total discount on the order. Ideal Skills and Experience: - Advanced Excel Skills with the ability to create customized sales orders - Proven experience in developing financial/ordering spreadsheets - Excellent understanding of sales order process and discount mechanisms.

I'm seeking an experienced graphic designer with a knack for box / product designs. The project involves creating an illustration to promote my new course. I need you to create something almost identical to the illustration design attached, except: 1. Without the stripe notification/boxes in the back of it 2. Changing "Low ticket starter kit" to "The Newsletter Machine" and below it replace the start selling... part with "Turn your brand's email list into your #1 marketing channel in just a few hours" 3. Changing the left box copy to just say "The 4 Honeypot Emails ... so you never run out of ideas" 5. Changing the right box copy to just say "Our Copy ...

I'm looking for an experienced PostgreSQL professional capable of analyzing and generating reports from sales data. Key Responsibilities: -Analyzing sales data stored in PostgreSQL -Generating insightful reports based on analysis Ideal candidate should excel in PostgreSQL and possess strong data analysis skills. Previous experience with sales data is an advantage, however, specific functionalities required for the analysis have been left open-ended for your expertise to fill. Please outline in your proposal any relevant experience and your approach to this task.

If C4 and D4 have no entries, make E4 blank. If C4 and D4 have values, perform C4/D4 in E4.

I need an expert in data formatting to help me clean and organize a large Excel file. The file currently contains unformatted data that needs to be segmented into distinct columns. I need the data separated into the following categories: - First Name - Last Name - Company Name - Position The ideal candidate for this job should have: - Proficiency in working with large Excel files - Experience in data segregation and formatting - Attention to detail to ensure data accuracy - Ability to follow instructions and deliver in an Excel file format Given that there are more than 500 entries in the file, efficiency and accuracy are key. The final deliverable should be an Excel file with the formatte...

create a logo for my brand about toilt product such as towls and stuff, name of the company is " Wsmi " it means The first spring rain in arabic

I'm seeking an expert who can assist with developing a comprehensive data analysis and automation solution within SMART sheet and Excel. Key Responsibilities: - Develop custom dashboards for financial analysis within Excel. - Automate data management processes within both SMART sheet and Excel. - Integrate the dashboards into SMART sheet for seamless use. Ideal Skills & Experience: - Strong expertise in SMART sheet and Excel, including VBA. - Proven track record of developing dashboards for financial analysis. - Ability to automate data management processes. - Excellent communication skills. Please provide examples of similar projects you've completed.

I'm in need of a competent Biostatistician who can conduct expert data analysis of a set of medical records that I will provide. Key Responsibilities: - Thorough analysis of the provided medical data ...Biostatistician who can conduct expert data analysis of a set of medical records that I will provide. Key Responsibilities: - Thorough analysis of the provided medical data - Identification of key patterns or trends within the data - Bringing any significant findings to my attention Final Deliverable: - The analyzed data should be delivered in a spreadsheet with detailed statistical analysis. Ideal Skills & Experience: - A strong background in Biostatistics - Previous experience with analyzing medical records - Proficiency in Excel or simil...

I need to scrape specific information from a website for all search results with a particular key. The data should include Name, Address, Phone number, Email, Company name, and Job title. This data should be organized into an Excel file, with each category of information in separate columns. Ideal Skills: - Proficient in Excel VBA - Experience in web scraping - Understanding of VPN usage to access region restricted sites Please note that the website will only work with a USA VPN.