Excel sheet formula jobs

I'm seeking a data entry professional for personal use. The role requires dedication of 1-2 hours daily, ideally someone with speed and precision. Skills and Experience: - Proficiency in MS Excel - Fast typing skills Your primary task will be to assist me in personal data entry tasks, which I expect to be completed in a proficient and timely manner. Only those with the necessary skills and experience should apply. Thanks.

...proficient Excel workbook developer who can design a system from scratch for me. The primary purpose of this workbook is to keep daily track of business transactions with great accuracy. The following features are crucial for the workbook: - Functionality to track daily transactions. - Automated monthly report generation to precisely sum up the data of a month. - The monthly report should include particulars such as expense tracking, revenue tracking, profit calculations as well as an end of the month balance sheet, tracking of sales, and out payments. In the Sales and Out Payments Tracking section, it is vital to monitor the quantity sold, payment received, and payment date. A closing sheet is also something I'm interested in. The ideal candidate would b...

I'm seeking a data analyst who can effetively convert a database from zip format to Excel. Requirements: - Proficient with handling both textual and numerical data - Expert in consolidating database tables into one Excel sheet - Strong understanding of applying specific formatting conditions Skills and Experience: - Proficient in Excel and database management - Experience working with .zip files - Exceptional attention to detail and organizational skills - Proven experience with similar tasks in the past The successful candidate should be able to maintain the integrity of the original data while fulfilling my custom formatting requirements.

I'm seeking a skilled data miner to extract and deliver usernames from 88k followers of a specific Twitter account. This scraping must be GDPR compliant, aligning with my IOC licence. This means you need to delete after excel is made... Even though I only need the usernames, the information should be housed in an Excel spreadsheet. Your expertise in data scraping, particularly from social media platforms, and a solid understanding of compliance requirements, will be crucial to completing this task.

you will be tasked to analyze the company current financial situation using dcf analysis and valuation and then write a small report.

I require a proficient data entry freelancer for a high-priority project. Your task involves generating a comprehensive CSV list, including specific details...to complete the entry Specifically, the CSV list should include: - Names - Phone Numbers - Emails - Websites Timelines and Delivery: I am on a tight schedule and need delivery ASAP. Professionals who can assure prompt delivery will be preferred. Required Skills: - Keen attention to detail - Proficiency in Data Entry - Experience in navigating search engines, specifically Google - Strong Excel/CSV handling skills - Ability to work under pressure and meet tight deadlines Please ensure you can accommodate these requirements before making a bid. Your understanding and quick action are appreciated. 1000 entries per week...

I'm seeking an experienced social media manager who can expertly utilize Facebook and Instagram to enhance my brand's engagement with young adults and parents. The ideal candidate will: - Excel at using Facebook and Instagram to drive engagement - Understand social media strategies tailored to young adults and parents - Have a proven track record for successfully generating leads through social media campaigns In this role, you will be expected to: - Plan and implement effective social media strategies - Monitor and analyze performance data to enhance our lead generation - Create engaging content that speaks to our target audience and encourages lead generation. This is an excellent opportunity to contribute to digital marketing efforts that directly support our ...

I am looking for an experienced professional who is proficient in data collection. The task involves collecting both individual and company contacts, particularly their roles within their given organizations and their email addresses. Ideal Skills: - Effective Internet research - High attention to detail - Data entry - Experience with Microsoft Excel or similar Responsibilities would include: - Comprehensively searching for over 500 individual and company contacts - Gathering important data including email addresses and roles within organizations - Compiling this information in an organized and accessible format I look forward to working with someone who can provide prompt, accurate results.

I need assistance with data entry into an Excel spreadsheet that is yet to be created. The data to be entered includes both numerical and text information. Key responsibilities will include: - Creating a user-friendly and intuitive Excel spreadsheet for my needs. - Entering both numerical and text data into the spreadsheet. Ideal candidate would have skills and experience in: - Excel spreadsheet creation - Data entry, specifically dealing with both numerical and text data - Attention to detail - Meeting project deadlines Please provide examples of past projects similar to this one.

A CALL WILL BE REQUIRED TO GO OVER THE JOB IN DETAIL BEFORE AWARDING NO IFS NO BUTS I need someone with good data collection skills. I need some data put into a spreadsheet it will have 3 columns SHOP NAME, POSTCODE, TELEPHONE NUMBER i will provide links and you have to send me the full sheet back with all the details you may have to search the web to get the phone number the most important info is the TELEPHONE NUMBER and it must be correct any mistakes and you will NOT be paid. this is ongoing work for the right candidate

.../ Sourcing Agent for Cable Assembly materials (wire, connectors, etc.), Electronic Components for PCBAs, and Sheet Metal for our customers requirements. This is a key Purchasing and Quoting position reporting to our Operations Manager. This position supports key strategic OEM customers that require an experienced and organized professional for their ongoing needs for quotes, order management and supplier management to ensure OTD. Responsibilities: Manage materials, supplier quoting, placing Purchase Orders, and following up with Suppliers to ensure OTD. Essential Duties and Responsibilities: - Quoting new opportunities for Cable Assemblies, Electronic Components, and Metals (sheet metal and machined parts) - Purchasing of materials for orders. Following up with Supplier...

I need a professional to perform qualitative coding on four interview transcripts using thematic analysis. The interview materials are text transcripts and need to be thoroughly a...thematic analysis. The interview materials are text transcripts and need to be thoroughly analyzed for key themes and patterns. Requirements: - Ability to analyze using thematic analysis - Experience in qualitative research - Proficiency in or NVivo software Your job will be to identify and code prevalent themes, using your expertise in thematic analysis. Instead of a Word document, Excel spreadsheet, or PDF, I need the final coded data in either or NVivo format. Accuracy and depth are key elements for this project, and a strong track record in qualitative research will be highly beneficial.

A CALL WILL BE REQUIRED TO GO OVER THE JOB IN DETAIL BEFORE AWARDING NO IFS NO BUTS I need someone with good data collection skills. I need some data put into a spreadsheet it will have 3 columns SHOP NAME, POSTCODE, TELEPHONE NUMBER i will provide links and you have to send me the full sheet back with all the details you may have to search the web to get the phone number the most important info is the TELEPHONE NUMBER and it must be correct any mistakes and you will NOT be paid. this is ongoing work for the right candidate

For an upcoming project, I am in need of a dedicated freelancer who can do more than just word processing. I have a word table, its aim is organization of data, and I need it converted into an Excel table with the same structure. A keen understanding of data organization would be crucial to this task. Ideal Skills and Experience: •Excellent knowledge of Microsoft Word and Excel •Proven ability to convert Word documents into Excel files •Detailed understanding of tables and their formatting in both Word and Excel •Strong data organization skills.

I need a freelancer well-versed in internet research and Google Sheets who can collect as many contacts as possible from different divisions of hockey teams. I have a website where many of these things are available I just need someone to grab them and build out a Google sheet. These include their names, email addresses, job titles, and phone numbers. Key Tasks: - Internet research to locate hockey team contacts - Building a comprehensive Google sheet These contacts will be used for marketing outreach, so accuracy and precision are essential. The more contacts you can gather, the better. Ideal Skills: - Experience with Internet Research - Proficiency in Google Sheets - Attention to detail - Experience in Data Entry

Looking to develop an Excel spreadsheet that will streamline tracking of Profits & Losses (P&L), sales, and payments. This obligation demands: - Create excel forms for each client/sale that will encompass information related to change orders, tracking of revenues, tracking of expenses by vendors and liabilities, and profit/loss analysis broken down for each client - Calculations: The spreadsheet must include key formulas such as gross profit margin, profit margin per customer, and payment reconciliation. Ideal candidate should possess advanced Excel skills with a robust understanding of finance and sales metrics. Previous experience in such tasks will be advantageous.

I need someone with good data collection skills. I need some data put into a spreadsheet it will have 3 columns SHOP NAME, POSTCODE, TELEPHONE NUMBER i will provide links and you have to send me the full sheet back with all the details you may have to search the web to get the phone number the most important info is the TELEPHONE NUMBER and it must be correct any mistakes and you will NOT be paid. this is ongoing work for the right candidate

I require a proficient professional to calculate the thermal power in my study of hot air flow. Key Tasks: - Determine the applicable formula/method for thermal power calculation. I do not have a preferred approach, so I need your expertise on this one. - Calculate the available thermal power using the provided air flow rate, measured in cubic meters per hour. Ideal Skills & Experience: - Strong understanding of thermodynamics - Experience in thermal power calculations - Excellent research skills.

I'm in need of an Excel guru to take on my project that entails budgeting and expense tracking. The gravity of this project leans on the advanced, as the utilization of pivot tables, VLOOKUP, and macros would be crucial. Completing this project demands a strong understanding and practical experience of: - Microsoft Excel - Advanced Excel functions (pivot tables, VLOOKUP, macros) - Finance and accounting (budgeting & expense tracking) If you think you've got what it takes to navigate through the complex labyrinth of numbers in this Excel project, then show me what you've got. Your detailed knowledge of finance and Excel will be put to good use. Looking forward to working with you!

Hi Akriti, I hope all is well with you. Recently you created a googlesheets dashboard for me. As I have used the sheet over the last several days, Ive realized that there are some things not working. Would you mind doing a quick look for me & let me know what the issue is, how it can be avoided and how I should continue to add data going forward? I also have one additional thing Id like to add. I can add more details in a separate message because I about about to exceed the character limit.

Please Sign Up or Login to see details.

I'm seeking an expert in Excel who can create a formula suitable for analyzing my account transaction data. The specific task at hand involves automating the summing of transactions. The ideal candidate will have: - Proficiency in Excel and data analysis - Proven ability to create complex Excel formulas or VGA macros - Attention to detail I need a formula which will bring up the last value from worksheet "Transactions" column O (looking for multiple dates which are the same), and putting it into D7. In addition, the result needs to change based on the date being greater or equal to worksheet "Account Balance" D3 and less than or equal to worksheet "Account Balance" D4. So, using the attached spreadsheet, the result ...

I am in search of a highly skilled Power BI analyst to dissect my sales data currently in Excel Spreadsheet format, .csv file and share the dashboard. The ideal candidate will have a strong background in sales analysis with the ability to generate insightful reports that can inform strategic business decisions. Key Responsibilities; - Analyze large amounts of raw data to find patterns and use them to optimize our performance. - Build and maintain reports, dashboards, and metrics to monitor the sales performance. Requirements; - Proven experience in data analysis and data modelling in Power BI. - Strong proficiency and working knowledge with Excel Spreadsheets. - High level analytical skills, attention to detail, and ability to make data-driven decisions is critically impor...

I'm in need of a knowledgeable financial expert to conduct a comprehensive review on my Balance Sheet and Income Statement within a month's time. Key tasks and attributes include: - Analyzing and interpreting each account in the Balance Sheet and Income Statement. - Providing a detailed report including potential areas of improvement. Ideal candidate: - Has demonstrated experience in financial analysis. - Has a current licence to sign in Ontario - Can meet strict deadlines. - Preferably Ontario-based, or comfortable working with province-specific financial regulations.

I need a proficient Excel expert to automate data entry, calculation, and formula tasks on my spreadsheet. Your role will be to ensure seamless integration of: - Text - Numbers - Dates The spreadsheet handles daily data input, so it requires daily updates. Mastery in Excel is required, and a keen eye for accuracy is important due to the frequency of the updates. The task would be greatly suitable for those who have versatile skills in spreadsheet management and data automation. Your ability to streamline these tasks will be key in this project. The All tabs with a status column will need to feed into the Actions tab, which can be relabeled into a Actions (Master) tab. The purpose is to have a general overview of the actions required throughout the spreadsheet. I am ...

I need a professional who is skilled in cold calling and lead generation, with a target of finding new custome...clientele. The primary target for the cold calls will be Freight Carrier Services. The aim is to provide them with an extraordinary transport solution while expanding our customer base. The cold caller will need to gather key information during the calls, including: - Company name and contact information - Shipping volume and frequency - Specific transportation needs and requirements To excel in this role, the ideal candidate should have excellent communication skills, a proven track record in cold calling, and a solid understanding of the freight carrier services industry. Their initiative, ability to build relationships, and knack for securing new business will b...

I'm in need of someone skilled in web development, particularly for static websites. The main objective is to create a transport roster site where employees can fill out their details and...concept, design, and functionality all need to be crisp, clean, and user-friendly. - Incorporating a form for employees to input their details. This should include validation checks to ensure that all information submitted is accurate and complete. - Upon submission, the form should be converted into an Excel Spreadsheet and sent to a specified email automatically. I'm seeking someone with experience in form handling, validation checks, and automated email sending. Familiarity with Excel document automation will be a plus. Your expertise to meet those demands will ensure t...

...training for my small dataset. The dataset, currently in Excel format, contains relevant data on threat, vulnerabilities, existing controls, likelihood, and impact. In this project, you would be responsible for: - Cleaning the dataset to ensure accuracy and relevance - Normalizing the data for consistent, efficient analysis - Employing machine learning techniques to train on cleaned and normalized data - The input should be the Threat, Vulnerability, Existing control and the Model should predict the liklihood and Impact Ideal skills and experience for this project would involve: - Extensive experience with machine learning algorithms and processes - Strong attention to detail for effective data cleaning - Proficiency in handling Excel formatted datasets - F...

I'm in need of someone skilled in web development, particularly for static websites. The main objective is to create a transport roster site where employees can fill out their details and...concept, design, and functionality all need to be crisp, clean, and user-friendly. - Incorporating a form for employees to input their details. This should include validation checks to ensure that all information submitted is accurate and complete. - Upon submission, the form should be converted into an Excel Spreadsheet and sent to a specified email automatically. I'm seeking someone with experience in form handling, validation checks, and automated email sending. Familiarity with Excel document automation will be a plus. Your expertise to meet those demands will ensure t...

I'm in need of a talented individual with a strong financial and Excel background to prepare several financial reports templates for a debt crowdfunding company like he is the Finance Manager on this Company. These templates should be innovative, user-friendly, and highly effective. Key tasks include: 1. Cash Flow Forecast: Projecting the company's cash flow situation, indicating both incoming and outgoing cash. 2. Profit & Loss Statement: Detailing the company's financial performance over a specific period of time. 3. Risk Assessment Report: Identifying potential financial risks and constructing a plan to mitigate them. 4. Portfolio Performance Report: Assessing the performance of our portfolio, including yield, volatility, and return on investment. 5. In...

I'm in need of an experienced data entry specialist who can handle text, numbers, and images. I will provide the necessary data through Excel files, PDF documents, and handwritten notes. Understanding and accuracy are key as the volume of data to be entered is medium, ranging from 100 to 1000 entries. Ideal candidates should be detail-oriented, have proficiency in Excel, and have strong written English skills for interpreting my handwritten notes. Prior experience in data entry is highly valued.

I have a need for a tool capable of reading and transferring table information from websites into excel. Here are the specifics of what I'm looking for: - The tool must be compatible with both Google Chrome and Microsoft Edge web browsers. - I need to extract information specifically from static tables. - The tool must be capable of extracting text and numerical data from these tables. Freelancers bidding on this project ideally should have the following skills and experiences: - Proficiency in web scraping techniques and data extraction. - A deep understanding of web browser's behaviors, particularly Google Chrome and Microsoft Edge. - Extensive experience with Excel data management and manipulation. - A knack for creating user-friendly tools is a bonus. I e a ...

I need Email addresses to all beauty salons in Sweden & Norway. This shall be pasted into an excel in a row so it will be easy to copy paste into Outlook.

I have a project that entails transferring data from 64 screenshots (.jpg) of an Excel spreadsheet into an actual Excel worksheet. Across the 64 screenshots, there are 2,571 rows of data in total, with 5 columns of data on each screen shot (account, firstname, lastname, title, email). Accurate data conversion and attention to detail is essential.

I'm seeking someone experienced in entering data; specifically text, numbers, and dates, into an Excel sheet comprising less than 100 columns and rows. Not only will you input the data, but I'm also requiring a new template design that will make our data easier to decipher and interact with. Therefore, ideal candidates should possess: - Strong expertise in Excel - Proficiency in creating intuitive and efficient Excel templates - An eye for design to enhance data readability - Exceptional attention to detail to ensure accurate data entry.

I am looking for a skilled data entry specialist to handle a task that involves transferring text information from PDF files into an Excel Spreadsheet. - The ideal candidate should have experience in data entry, particularly dealing with text data and is familiar with PDF and Excel formats. - Accuracy and attention to detail are paramount as the entered information will be used for critical business decisions. - A fast turnaround time will also be appreciated but not at the expense of the quality of work. - If you've handled such tasks before, feel free to share the outcome and your experience. Your bid should also reflect a deep understanding of this project. This task provides an opportunity to showcase your data entry prowess while contributing to business inte...

...freelancer to create a dynamic and interactive project management schedule dashboard using Power BI. Key Features: • Data Sources: The dashboard will incorporate data from my Excel spreadsheets and connect dynamically with Power BI. • Important Metrics: The dashboard should be capable of tracking Key Performance Indicators (KPIs) including Project Progress, Task Completion, and Resource Allocation. • Customization: I require both basic template customization and advanced data visualization customization for an enhanced user experience. Ideal Skills: • Power BI functionality expertise • Knowledge on integrating Excel with Power BI • Advanced data visualization abilities • Proficiency in template customization Experience in creating...

We are seeking a highly skilled and detail-oriented Virtual Assistant to support our team of Quantity Takeoff and Floor Covering Estimators. The successful candidate will have extensive experience in the construction industry and be proficient in estimating materials, labor, and other costs associated with...LVT, LVP, floor leveling and preparation, concrete leveling and polishing, and tile work • Proficient in reading construction designs or blueprints • Strong attention to detail and the ability to manage multiple projects simultaneously • Experience with construction estimating software such as Bluebeam, PlanSwift, or similar programs is a requirement • Proficiency in Microsoft Office, especially Excel and Word • Knowledge of flooring covering and subcont...

As a WordPress website owner, I am looking for a freelancer with skills and experience in WordPress, Elementor, and Google Sheets integration. The task involves linking my Elementor form with Google Sheets so that every submission made through the form is automatically transferred to my designated Google Sheet. Requirements • I have a Google account, hence experience with Google Sheets is necessary. • The attributes of my form that need to be linked to Sheets is unspecified at this moment, meaning the freelancer might be required to guide me in mapping out the necessary fields. • The task should be done ASAP. This makes proficiency in Google Apps Script and knowledge of APIs advantageous as it could quicken the process. Freelancers adept at debugging are preferred ...

...freelancer with experience in scanning documents, extracting relevant data, and converting it into Excel format. The type of documents will be disclosed to the selected freelancer - since the question about the document type was skipped. Key Responsibilities: - Scan the provided documents. - Convert scanned documents into Excel format. Important Skills: - Experience with scanning and converting documents into Excel format. - Able to follow specific formatting requirements to match the original document layout. Getting shortlisted: Freelancers keen on this project should have a proven track record of such conversions. I am interested in seeing your past experience with similar projects. Note: The Excel files should mirror the original documents' ...

I need an expert to convert a complex Excel spreadsheet into a form that is compatible with the wpDataTables plugin, or similar, to be used on a WordPress website. The document is heavy on formulas which must remain operational post-conversion. The purpose is to have this data visually displayed on the website in table format, which will not only make the data more presentable but improve accessibility as well. It will also need to have the ability to run reports directly from the website or plugin using the data entered into the build. The ideal freelancer for this job would possess: - Proven experience in working with Excel and WordPress. - Proficiency in working with wpDataTables or similar plugins. - Ability to ensure the translation of Excel formulas into the n...

...and perform timely maintenance of all listed resources, update plugins, monitor settings, etc. - Identify and prevent errors in settings and/or functionality of services in advance - Fix main menu on the website, add/remove buttons - Add/remove a block on an existing page. The page itself can be made using HTML or a designer (Wp-Backery or Elementor) - Set up contact form integration with Google Sheet, Kommo CRM, MailChimp, Gmail, etc. - Fix page displaying - Upload materials to the website, correct the page content, adapt the mobile/desktop version - Transfer a page from Wp-Bakery to Elementor or vice versa and so on. If you're easy, fast, and fun to figure out any unexpected technical tasks and challenges - you're the one we're looking for We are looking for an...

I am looking for an Excel and database expert who will assist me in creating sales reports. Your main task will involve: - Utilizing and massaging sales data to generate comprehensive reports. - Presenting these reports in the form of dynamic Pivot tables. The ideal freelancer for this job should have: - An extensive knowledge and experience in Excel, specifically with Pivot tables. - Proven track record of data analysis and report creation. - Ability to interpret and analyze sales data. If you are detail-oriented and results-driven with a knack for turning data into actionable insights, I would like to hear from you. Please include samples of the sales reports you have created in the past using Excel.

...integration between Excel and Outlook. The primary feature of this integration should be automatic updating Excel whenever new contacts are added to Outlook. In addition, a bulk auto-reply feature is desired. ---------------- Please read the attached proposal file carefully. Besides, before establishing a milestone, we are possible to continue to revise and update this proposal along with its specifications within the discussion threads. Prior to accepting the milestones, please ensure to review all the most updated proposal details and specifications. Let’s confirm we have the same proposal with the same modification time before accepting milestones. ---------- Key Tasks: - Develop an integration system between Excel and Outlook. - Auto-add new Outl...

...exponential matrix of M How do I calculate e^M using a Taylor column for the function e^X when the formula is as you know it is sigma from i to a certain n (which I need to find) of M^i/i! Now how do I know which term I need to calculate the matrix in order to reach the precision of an exponential matrix? Thanks to the Lagrange form of the remainder, I will check what the remainder is that comes out if I calculated only one term. If it is greater than epsilon, it means that I did not reach the accuracy I wanted and I need to calculate another term in the Taylor column, and so I go on and on until my error is smaller than epsilon. The calculation of the Lagrange form of the remainder also has a formula and it is: || Rn(x) || =( (e^||x||) *(||x||^n+1) )/ (n+1)! So we need t...

I require assistance with Excel data entry tasks, specifically related to transposing information from PDFs into Excel. The job will involve meticulous attention to detail to ensure accuracy of entered data. Key responsibilities include: - Inputting data from PDF files into Excel spreadsheets Ideal candidates should have: - Advanced experience and understanding of Excel - Proven data entry skills - Detail-oriented approach with ability to quickly identify and correct errors - Familiarity with PDF files In this role, you'll be instrumental in ensuring the seamless transfer of critical data from PDF to Excel, playing a key role in our overall data management efforts.

...media post designer. I need someone who can not only design well but also can write engaging content. - Design for multiple platforms: The designs will not be platform-specific, so I need a designer who is comfortable creating posts for various social media platforms. - Handle all aspects of creation: From content to design, you have to handle everything. We will provide you access to our Google sheet where you have to write a platform, website name, caption, and hashtags and upload the post image there. - Be flexible in style: Since I haven't decided on a specific style, I'd like a designer who can easily adapt between minimalist, bold and vibrant, or elegant and professional styles, or even something entirely different. Ideal skills would include familiarity with al...

In need of a highly proficient data entry and web scraping professional to assist with an extensi...professional to assist with an extensive project. The job involves obtaining specific contact information from a variety of links provided in an Excel file. Ideal Skills and Experience: - Familiarity with web scraping, data extraction and decoding - Proficient in using Excel and handling complex data sets - Attention to detail, to ensure accuracy of the extracted information - Prior experience in extracting contact information from varied sources is desirable Specific Task: - Go through the Excel file to access the respective website links - Extract key contact info from every link - Accurately compile all the extracted contact details back into an organized Excel...

I'm in need of someone with excellent spreadsheet skills and attention-to-detail for ...need of someone with excellent spreadsheet skills and attention-to-detail for this data entry project. The task involves extracting data from provided PDF files and accurately entering it into a spreadsheet. Tasks include: - Reading and understanding data from PDF documents - Entering the data into an Excel spreadsheet with precision and efficiency - Reviewing data for deficiencies or errors The ideal freelancer for this task will have: - Proven data entry experience - Proficiency in MS Excel - Attention to detail - Ability to interpret complex information - Excellent time management skills to meet the deadline within a month Please ensure you have these qualifications before pla...

As the client of this project, I need an experienced freelancer to translate a complex PDF into an Excel file. The PDF contains mixed data, both text and numbers, and it's crucial that the formatting in the original PDF file is retained in the Excel document. Key Responsibilities: - Accurate conversion of mixed data from PDF to Excel, maintaining the original format. - Ensuring the data remains intact during conversion. Key Skills and Experience: - Expertise in handling large Excel spreadsheets. - Proficiency in using data conversion tools. - Attention to detail to ensure data accuracy and consistency. - Experienced in data entry jobs with familiarity in both PDF and Excel formats. This project requires precision and a high level of detail, h...