Excel automatic data entry formula Jobs

I'm seeking assistance to upload 29 products from an Excel list to my online store. You can refer to the sample products already uploaded on the site. Ring Atelier Chicago, a fine jewelry business, is seeking a detail-oriented Website Product Entry Specialist to upload 29 bracelet products to our Shopify website. The products are detailed in an Excel file, and you’ll refer to existing product pages for format and style consistency. **Responsibilities**: - Accurately upload 29 bracelet products to the [Bracelets Collection]() of our Shopify website. - Input product details (e.g., title, description, price, weight, and specifications) as provided in the Excel file. - Ensure product pages match the style and format of existing products like

I'm in need of a skilled Excel VBA developer to create a macro that transfers numerical data from one Excel workbook to a second one on a daily basis. The macro should be designed to bring over all data from the source workbook. In addition, I would appreciate written instructions on how to recreate the macro in the event of a break. This project requires a clear understanding of Excel, VBA programming, and the ability to write clear and concise instructional material. Must speak good english as best we do a zoom / teams meet to review workbooks.

Bitte melde dich an oder Loge dich ein um Details zu sehen.

Description: We are seeking an experienced Financial Modeling Consultant with in-depth knowledge of affordable housing developmen...layering. Familiarity with compliance and reporting requirements for state and federal programs. Exceptional analytical and problem-solving skills. Excellent communication skills and ability to explain financial concepts clearly. Preferred Qualifications: Experience working with LIHTC, HUD, or other Florida-specific housing programs. Background in real estate finance or development. Proficiency in Excel and financial modeling tools. Deliverables: A refined or new underwriting model for affordable housing projects. A detailed report outlining recommendations and insights for financial decision-making. Ongoing support for financial strategy discussions ...

I'm a sales training consultant seeking an entry-level sales assistant whose primary task will be to prospect and set appointments for me. I am open to appointments from any industry, be it Technology, Healthcare, Finance, or beyond. Key Responsibilities: - Utilize social media platforms for prospecting - Set appointments with potential clients Ideal Skills: - Proficiency in social media - Basic understanding of sales principles - Good communication skills - Eagerness to learn and grow in the sales field Experience: - Entry-level candidates preferred - Prior experience in sales or appointment setting is a plus but not necessary. Your role will be crucial in helping me expand my reach and grow my business. If you're a motivated individual with a passion for sal...

I have a data sheet ready for a Monte Carlo Simulation assignment. An Excel expert is needed to input the formulas into the sheet and complete the assignment. A formula sheet and instructions will be provided. Key Requirements: - Intermediate level complexity for the Monte Carlo Simulation - Use of Random Sampling technique - Results presentation in both tables and charts Ideal Skills/Experience: - Proficient in Excel - Experience with Monte Carlo Simulations - Able to present data in a clear and concise manner

I need help with a data entry project. The task involves extracting numerical data from PDF documents and inputting it into a specified format. Ideal Skills: - Proficient in data entry with a keen eye for detail - Strong numerical skills - Comfortable working with PDF documents - Experience in data entry from PDFs is a plus - Familiarity with maintaining accuracy and speed in data processing This project is all about handling numerical data from various sources. It's crucial that the freelancer is able to maintain a high level of precision and speed while ensuring the data is accurately entered.

I'm seeking an expert in Google Sheets who can create a formula for me. The formula needs to: - Add a margin to the product price, calculated as a percentage of the cost. - Include the credit card surcharge, which is a percentage of the total. - Calculate HST (Harmonized Sales Tax) for a final grand total. Ideal candidates should have a deep understanding of Google Sheets and experience with financial calculations. Please provide previous examples of similar projects you've completed. I've attached a screen shot of what I've created so far (which isn't much) I'm having trouble with material margin, credit card surcharge which won't be applicable every time and HST to give me a total of all 3 based off the subtotal price when appropriate q...

I need assistance with data entry focused on contact information sourced from websites, with the goal of aiding in business development. There are about 500 entries to be done. Key Requirements: - Proficient in Excel - Experience in data entry - Familiarity with sourcing and validating contact information from websites Tasks: - Collecting and entering contact information from various websites into an Excel spreadsheet - Ensuring the accuracy and relevance of the data collected Ideal Skills and Experience: - Prior experience in business development or lead generation would be beneficial - Attention to detail and ability to work independently - Strong organizational skills

...and exchanges while maintaining accuracy and efficiency. Meet or exceed sales targets and key performance indicators (KPIs). Product Knowledge: Stay up-to-date on company products, services, pricing, and promotions. Educate customers on product features, benefits, and usage to encourage purchasing decisions. Maintain knowledge of competitors’ offerings to provide better customer comparisons. Data Entry & Record Keeping: Accurately input customer information, transactions, and feedback into the company’s database. Track and document customer interactions and sales metrics. Collaboration: Work with team members, managers, and other departments to resolve customer issues and ensure smooth service. Provide feedback to the sales or product development teams b...

Hi there, We're looking for someone to help with administrative finance tasks such as creating quotations and invoices, checking / processing expenses, checking GST, updating payments and revenue tracking / data entry. - Tasks: Reconciling our accounts, preparing quotes and invoicing from templates, and assisting with our receivables and expenses administration. - Software: We primarily use Xero for our bookkeeping. We use Zoho for expenses which would be great, or familiarity with another expenses platform. Strong knowledge of Xero and Google sheets is a must. Zoho familiarity ideal, or other expenses platforms. Most important is attention to detail and ability to follow templates, processes and instructions. This is an ongoing role with hours required every week.

I'm in need of an Excel expert who can assist with a complex spreadsheet designed for data analysis. Key Responsibilities: - Help with analysing data using %tile rank - Potentially adding additional features to the spreadsheet Ideal Skills: - Proficient in Excel with a deep understanding of its functions and formulas - Experience in data analysis - Able to implement automation with macros, create visualizations with charts, and use conditional formatting if needed I am open to suggestions for additional features that could improve the functionality of the spreadsheet. Please provide a comprehensive proposal outlining how you would approach this project.

*TEST PROJECT DO NOT BID* *TEST PROJECT DO NOT BID* *TEST PROJECT DO NOT BID* I am currently hosting a design contest focused on creating a logo. Key requirements: - Extensive experience in logo design - A strong portfolio of modern and minimalist design - Ability to work under contest conditions Please note that this is a test contest, do not submit an entry. *TEST PROJECT DO NOT BID* *TEST PROJECT DO NOT BID* *TEST PROJECT DO NOT BID*

I need a freelancer to help with maintaining my Excel files. My datasets typically range from 1,000 to 10,000 rows. Ideal Skills: - Proficiency in Excel 365 - Data cleanup and organization - Troubleshooting formulas and functions - Macro creation and automation Experience with large datasets and Excel 365 is essential. Tasks may include data organization and cleanup. I look forward to your proposals.

I require a Microsoft Excel expert to assist with data analysis and visualization. The data is currently in an Excel spreadsheet and needs to be analyzed using descriptive statistics. Your tasks will primarily include: - Interpreting data and providing meaningful insights - Creating visual representations of the data Ideal skills and experience for the job include: - Proficiency in Microsoft Excel - Experience in data analysis and visualization - Strong understanding of descriptive statistics

We need someone to scrape website data and social media posts. Please download every Tiktok post from Return Home: @returnhomenor?lang=en We will need the videos, text description, hashtags, and all comments (and their associated data). In doing so, we ask that you create an Excel spreadsheet, a folder with video downloads, and a folder of Word documents that include the comments on each video. We provide a detailed description below. 1. Excel Spreadsheet: Please create an excel spreadsheet with the following columns. Column A: Label: “Video title” In this column, please provide the video title to match the title of the video download. For example, if you look at this TikTok video (@returnhomenor/video/7164090596796157230?lang=en), you woul...

I'm in need of a freelancer who can assist me with data entry of realtor information (name, company name, phone number, email, city) from multiple websites onto an excel sheet. This data needs to be formatted in a way that it can easily be imported into my CRM. Key Tasks: - Source realtor information from multiple websites - A combination of web scraping and manual data entry - Processing of more than 500 entries Ideal Skills & Experience: - Proficient in Excel - Experience with web scraping - Detail-oriented to ensure data accuracy - Able to work independently and efficiently

...analysed and inserted in a excel spread sheet. The emails to be analysed will come from our customers providing a list of available haulage collections/deliveries. The emails will be in a general inbox which will also contain non transport related emails and these should be ignored. The emails are all in different formats for each customer but all should contain collection location, collection date, delivery location and delivery date. Due to every email being in a different format I am looking for an intelligent solution that can analyse the email, decide if its offering us haulage collections, determine which customer its from, determine the collection site and date, determine the delivery site and date and then pass this information to a formated excel spreadsh...

We are seeking a skilled bookkeeper to assist with the conversion of our business bank and credit card statements from PDF format to Excel. This is essential for the preparation of our financial statements for tax filing purposes. There are around 290 statements, containing around 1000 pages. The ideal candidate should be detail-oriented and proficient in accounting software. Experience with financial reporting and knowledge of tax regulations will be needed. We are looking to have this done ASAP, preferably by the end of the day this week on Wednesday. If you have a strong background in bookkeeping and are comfortable working with various file formats, we would love to hear from you.

...MySQL database to store project and user data. - Enabling dynamic project entry by division (there are 16 divisions, each with unique input fields). - Creating an API to handle form submissions and display project metrics in real-time. - Ensuring the platform is scalable for future growth and additional features. - Collaborating closely with the front-end developer to ensure a seamless integration. The user authentication will be handled through a simple Email and password system. Therefore, experience in developing secure login systems is crucial. Ideal skills and experience include: - Proficiency in Flask (Python) and MySQL - Experience in designing and implementing secure user authentication systems - Ability to create APIs and handle dynamic data - Previous ...

...looking for an experienced automotive technician to complete the installation of my Compustar remote start kit in my 2011 Chevy Cruze. Important Details: I have already programmed the bypass module (iDatalink Blade-AL) myself, so this step is complete. The installation should include keyless entry and an alarm system setup. The kit is already purchased and ready for installation. Ideal Candidate: Proven experience with Compustar remote start systems installations. Skilled in integrating keyless entry and alarm systems. Strong understanding of automotive electrical systems and wiring. Detail-oriented to ensure the installation is safe, clean, and fully functional....

I need assistance with reformatting my spreadsheet to improve its layout and visual appeal. Additionally, I require help with performing some statistical analyses, specifically calculating means, medians, standard deviations, and variances. Ideal candidates should have: - Proficient skills in Excel or similar spreadsheet software - Experience with data formatting - Strong understanding of statistical functions and analysis

I'm looking for an experienced mobile app developer to create an app that measures nails for both hands and feet. The app should have the following features: - Automatic detection of nail size using camera-based detection technology - Measurement history tracking to allow users to keep track of their nail growth over time Ideal skills for this project include: - Proficiency in mobile app development - Experience with camera-based detection technology - Ability to integrate automatic detection features - Strong understanding of user interface design for ease of use Please provide examples of similar projects you have completed.

I'm looking for a web designer/SEO expert who can enhance my current pricing page. The main goal is to improve conversion rates by making the page modern, user-friendly, and SEO optimized for potential sellers of heavy construction equipment in Latin America. Our website works with both english ...Simplify and clearly display the pricing tiers and benefits. - Optimize the page for search engines. - Implement strategies to improve conversion rates. Ideal Skills: - Proficiency in web design/copy/SEO. - Experience with SEO. - Understanding of modern design principles. - Ability to create user-friendly interfaces. Please check the website: and submit your entry explaining the rationale behind it. If you need more information, let me know on your submission.

...Development of a data management application for didactic processes, based on a topic of your choice. The individual project consists of two modules (files): • A descriptive module (a word-processed document) • A calculation module (developed in a data processing application) The project should generally follow the structure below, tailored to the specifics of your specialization: 1. Formulation of the theme/topic, including the objectives/requirements proposed for the project. 2. Specification of the studied characteristic(s), data volume/sample size, etc. 3. Data collection (miniaturized), with sources indicated (e.g., yearbooks, surveys, questionnaires, or other sources). 4. Preliminary data processing, such as coding, systematizing, group...

...reports “Safety Culture” created to both a Word and also an Excel format. Word Format The export format contains all of the data which I have collated in my iPhone report into a lengthy and detailed report, complete with photographs illustrating each defect which I have identified and listing remedial work which I have deemed is necessary. What I require as far as Word is concerned is the following: A Macro, triggered on the click of a button, to ensure that the report is modified to suit the attached example of how I would like the report to look after triggering the Macro. All the remedial information (which is already mentioned within the report underneath each defect) is then grouped together at the end of the report (see raw data example) which ...

...Structure Main Account A (my account) → Secondary Account B (friend's account) Main Account C (friend's account) → Secondary Account D (my account) **Each main account could potentially have multiple secondary accounts as needed. How the System Should Work When a position is opened on the main account, it should be copied to the secondary account(s) quickly and precisely. Criteria to Follow Entry Price: Must be executed as a market order. Exit Price: Must be executed as a market order. Leverage: Use the same leverage on the secondary account(s). Position Mode: Isolated mode should be used. Take Profit: The take profit levels set on the main account should be mirrored on the secondary account(s). Must be executed as a market order. If the take profit is ...

Hi Talia I ended up having to take the bid down because it wouldn’t let me remove the attachment. After that it wouldn’t let me type into the chat! We can continue sorting this this way hopefully. I’ve paid USD10 as a down payment for the project to message you this way. If you can send me the revised project fee here (ie the one you mentioned factoring ...up having to take the bid down because it wouldn’t let me remove the attachment. After that it wouldn’t let me type into the chat! We can continue sorting this this way hopefully. I’ve paid USD10 as a down payment for the project to message you this way. If you can send me the revised project fee here (ie the one you mentioned factoring in that dad/I will send all the edits for the longer ...

...technical support for mobile app users. - Providing product/service information for new sales and closing them. - Scheduling appointments. Ideal Skills: - Excellent communication skills - in english and be very fluent in english. - Problem-solving skills - Experience in customer service and must be able to be super friendly with customers. - Familiarity with VoIP systems -Must be good with excel, words, docs. Please note that specific admin tasks have not yet been defined, and will be many different admin tasks. we are looking for someone who wants to work and can wear multiple hats at anytime, doing whatever tasks given them. we are looking for someone reliable and can work at any given schdeule moment.. no excuses and no exceptions. our work hours in USA is 8am...

...com/DaveHappyFunTran You can use a picture from social media or from the video podcast itself Here is a URL to the google drive with some of the raw video/audio files for context or ideas OR to get portraits of the hosts or guests:  Maybe add the text to the thumbnail: Empower Growth Through Teamwork  First good entry we will award...

...search feature allowing users to find tokens by contract address, symbol, or name. Token-specific pages will present comprehensive data such as name, symbol, description, real-time price, market cap, liquidity, historical price charts, and recent transaction feeds, with all data sourced from the Dexscreener API. The voting functionality will remain login-independent, ensuring accessibility for all users. To improve the submission process, we are enhancing the token submission form to include fields for comprehensive details like social media links and KYC verification status. Automated validation via APIs such as Dexscreener and CoinGecko will streamline data entry while integrating payment gateways for premium or sponsored submissions. Advertising features ...

Hi there - I'll help you create a database for your invetor's information in Excel workbook. Thanks for your work!

...Wiegand signal from our controller (a Windows-based server) to an access control system. The main function of this system will be to authorize entry. Key Requirements: - The system should support sending both 26-bit and 37-bit Wiegand formats (with and without facility code). - I need an API written in C# for sending data, which can be easily integrated into our existing application. - Expertise in identifying the necessary, readily available hardware in the USA to connect to our machine's W0/W1 connections. - Preferably, the hardware should be USB-based, compact and capable of supporting 1-8 Wiegand outputs from the machine. The machine will receive data, our application will do a look up and then send an ID over a Wiegand connection. Ideal Skills: - Prof...

...looking for a highly organized Data Assistant to help us make sense of our numbers and stay ahead of the game. Role Overview: We’re seeking someone detail-oriented and data-savvy to gather and analyze key performance metrics across our platforms. If you have a knack for spotting trends in analytics, SEO, and social media stats, this is the perfect role for you. Key Responsibilities: Collect and organize data from Google Analytics, SEO tools, social media platforms, and email marketing platforms. Track and report on KPIs, including website traffic, social engagement, and newsletter performance. Create easy-to-digest reports and visualizations for the team. Analyze trends and provide actionable insights to improve performance. Work closely with the team to opt...

I am seeking a Zoho CRM Report expert. The task involves building a Lead Status Report and a Deal Pipeline sheet, like an excel sheet, these sheets must be able to filter by seller, will be based on data from Zoho CRM data reports and will need to be AUTOMATICALLY updated daily (access to Zoho will be granted upon hiring). The Lead Status Report should include the concepts shown in the reference screenshots. The ideal candidate will have: - Proficiency in Excel and data visualization - Proven experience with Zoho CRM - Ability to set up automated reporting systems is A MUST - Strong attention to detail - Excellent communication skills to explain the data clearly.

Bitte melde dich an oder Loge dich ein um Details zu sehen.

I'm looking for a skilled freelancer to set up a Mac and create an automated daily report from stock broker accounts. This project involves: - Using Python to extract and analyze stock data - Integrating with the broker API (specific API to be determined) - Incorporating volatility indicators (to be specified) - Ensuring the final product can be easily imported into Excel The ideal candidate should be detail-oriented and accurate in data reporting. Proficiency in Python and Excel is essential, as is experience in financial data analysis. If you can deliver reliable reports, I would love to hear from you.

I need an expert in Artificial Intelligence, ChatGPT, Python, Machine Learning: can be expert in any of them The job is to collect data from the internet (NOT from one particular website, but from the worldwide web in general) and populate an Excel sheet that I provide The data is about businesses, and will be used on a business website

...standing out, you could receive direct requests for individual projects. Ongoing Work: We have multiple automations pending. If your first project is successful, we’d love to continue working together. Full Flexibility: Work on your own schedule. No endless meetings or unnecessary processes. ? Examples of Specific Automations Needed: Automated posting on social media using Google Sheets. Sending automatic reminders via WhatsApp and email from a web form. Automating periodic report delivery by email. ? Why Should You Apply? If you’re an expert wanting to gain recognition and make an impact with your knowledge. If you want to expand your portfolio with high-value tutorials. If you’re looking for new revenue streams and potential clients seeking personalized auto...

I have a matrix where it computes the sum over some zip codes and regions and a time filter and the values are correct but also I have a second sheet where I have a bar plot but you can select a month and a region using bookmark and the sum is not correct. There might be some something small or formula to fix IN the second sheet I created some measure and the issue might be there. To work in this task it is required to use any desk.

...types (e.g., assists, points, rebounds, threes), and updates Airtable with the results. This program will run locally on my computer and will be delivered as an executable file .exe for windows. Key Deliverables: - A working Python script or executable that: - Retrieves data from the Odds API (player name, prop category, odds, and line value). - Filters the data based on a specific odds threshold (-400 to -1200). - Checks Airtable to avoid duplicate records (player name, prop category, and line value). - Inserts the data into Airtable if the combination of player, prop, and line doesn't already exist. - Retrieves totals for the relevant prop category (e.g., assists, points, rebounds, threes) from Airtable. - Calculates hit percentages for the last 5, 10, 20, a...

I'm seeking a detail-oriented freelancer for data entry tasks. The project involves transcribing text from scanned images into a digital format. Tasks: - Transcribe text from PDF scanned images into a digital format. Ideal Skills and Experience: - Excellent typing skills - Attention to detail - Prior experience with data entry, particularly with transcribing text from scanned images - Proficiency in handling PDF files - Ability to maintain confidentiality and handle sensitive information with discretion.

I need a desktop application for Windows that can predict when a betting plane is going to crash. The app should automatically withdraw the money or make the plane go higher when it knows a crash is imminent. Betting sites Key Features: - Predictive algorithm to anticipate crashes - Automatic betting adjustments - Desktop application compatible with Windows - Dual interface: Graphical User Interface (GUI) and Command-Line Interface (CLI) Ideal Skills: - Proficient in desktop application development for Windows - Experienced in creating both GUI and CLI - Capable of implementing predictive algorithms - Understanding of betting systems and mechanics Please provide examples of relevant past projects in your bid.

I have suppliers I have user and password to log in then I get my special discounted prices. I want a scrpit to download detials whenever required of the all items in excel or CSV format like item code, item detials and description, item price, item stock with differnt color options mentioned.

Already i check the Attachments excel sheet and i agree client timeline and budget $15.

I'm seeking a proficient data analyst to match two financial datasets containing company information. - The first dataset has 1649 rows and the second has 14922 rows. - Each entry in the first dataset must be matched with its corresponding entry in the second dataset. - The first dataset contains detailed identifying information such as company name, ISIN, and Ticker, while the second dataset primarily includes ticker and company name. The primary goal is data matching for consolidation and analysis purposes. The ideal freelancer should have robust experience in data analysis and entry matching, with a keen eye for detail. - Prioritization for matching should focus on the company name. - Discrepancies between the datasets will need to be ...

Same as previous jobs, payment released after all corrections

...- Knowledge about different types of trading orders Ideal Skills: - Python programming - Trading experience - Interactive Brokers expertise - Order placement automation I am looking to hire a pythan trading expert, You need to automate trade in Shoonya Broker Account, Automate the buy sell order, It has lots requirment I have attached excel file to fetch and update data, and automate trade, I can choose any interval, It need to fech candle data, more detaiil i wll give if you can provide result with my budget, Not your Expectation If you accept my term apply this task: Budget:Rs 900 I will give good review, if you complete my budget, Dont expect more money, Money will paid after complete the job successfully, dont waste your time and bid If you have exp...

...border around the image for a clean and modern look. Mirrored Borders: Extends the artwork on the edges for a continuous wrap effect, ideal for canvas prints. Real-Time Preview A dynamic real-time preview feature must allow users to see exactly how their selected options (frame, passepartout, glass, size) must look before completing their order. Price Calculation The platform must include an automatic price calculator that updates the total price based on the user’s customization choices, including material, size, frame, and additional options. Artwork Description and Information Each artwork page must feature detailed descriptions about the artist, the artwork title, the year of creation, and the historical context. This must help users better understand the value and sign...

I'm seeking a diligent virtual assistant for product data encoding and entry. This is an hourly-paid position, with certain tasks being conducted via Remote Desktop. Key Responsibilities: - Accurately entering product details into spreadsheets Requirements: - Proficiency in Excel or similar spreadsheet software - Prior experience with data entry - Attention to detail - Ability to work via Remote Desktop