Data excel spreadsheet set organizationJobs

I'm in need of an Excel formula expert to help me with a specific task. I need a formula that will COUNT cells based on the following criteria: - I need to COUNT the number of cells in a range that are greater than -250 - The count should be done for the last 50 cells (ongoing) Your task will be to help me create a formula that dynamically counts the number of cells based on the above criteria. I need this formula to be able to adjust as new values are added to the range. The ideal Freelancer for this project should have: - Extensive experience with Excel functions and formulas - Strong understanding of dynamic range referencing in Excel - Excellent communication skills to explain the logic behind the formula in layman's terms Please include any relevant...

I'm seeking a highly skilled programmer proficient in Excel macros and ODBC data connections to automate critical processes in my business. Specifically, your tasks will involve: - Automating order tracking, inventory management, and vendor communication processes. - Connecting to Excel files, SQL databases, and CSV files using ODBC. - Developing an automated procurement system capable of: - Generating purchase requisitions, - Aiding in vendor selection and negotiation, - Creating and tracking purchase orders. Proficiency in utilizing Excel macros is a must, and experience with ODBC data connections and related platforms is highly desirable. Knowledge of procurement systems and order logistics would be beneficial. Successful completion of th...

One excel file with macro as per requirement

...expert in Microsoft Excel to build an efficient spreadsheet to monitor potential lost revenue due to late service deliveries. The ideal candidate would possess a strong background in creating financial models and understanding of revenue tracking. Key Requirements: - Proficient in Microsoft Excel, with emphasis on creating advanced, clear, and highly-functional spreadsheets. - Experience in financial modelling and understanding of revenue tracking. - Ability to automate the process as much as possible to minimize manual tracking. Objective: - Create an intuitive and efficient Excel spreadsheet to replace the current manual method of tracking potential lost revenue due to late service. Skills Needed: - Microsoft Excel - Financial modellin...

...application based on this platform. Key Features: - Internal Business Process Application - Data Management: The app needs a strong data management feature, allowing for efficient organization and retrieval of information. - Workflow Automation: Automatically streamline tasks and workflows to increase efficiency. - Customization Options: Enable customization to cater to various needs within our internal team. Design: The UI should have a clean and professional look, facilitating easy navigation and enhancing user friendliness. Audience: - The app is intended primarily for use by our internal staff only Ideal Skills: - Previous experience in Zoho Deluge based application development. - Proven track record in data management, workflow automation, and user...

I'm seeking a professional to diligently run through LinkedIn, identifying and documenting HR higher-u...Identifying: I'm targeting senior-level personnel only. Expertise in navigating LinkedIn search and understanding corporate hierarchies will be a plus point. 2. Documenting: I'd like the findings to be presented in a tabular form within an Excel document. Critical data points to be captured include the Company Name, individual's LinkedIn Profile link, and their Role. Your background in HR and corporate structures would be critical in understanding the perfect fit for my requirements. Strong organizational skills, meticulous attention to detail, and proficiency in Excel would be highly appreciated. Overall, a good grasp of LinkedIn-based researc...

To help manage my work efficiently, I am in need of a proficient virtual assistant. Using Google Sheets, your initial task entails creating a spreadsheet listing festivals held in Louisiana and Mississippi. This sheet should include: - Festival names - Festival locations - Festival dates Apart from spreadsheet creation, I'll also require assistance with customer service tasks. This role best fits someone that is skilled in utilizing Google Sheets and who possesses excellent customer service skills. Prior experience in a similar role is a bonus, but not a must.

I'm looking for a skilled freelancer to help me create a pivot table in Microsoft Excel that will be used to find pricing quicker Key Requirements: - The pivot table must be created in Microsoft Excel. - The purpose of the pivot table is to find pricing easier The data sources which the pivot table will be using are confidential, and will be shared with the selected freelancer.

I'm seeking a proficient individual to help with a data entry project. I have about 40 URLs, from which I need to extract the product names, prices, and descriptions. The goal is to collate this information in a pre-defined Excel template. Key Aspects: - Extract product names, prices and descriptions from 40 URLs. - Populate an Excel file with the gathered data.

I'm seeking a skilled individual with a strong command of Microsoft Excel and Word. The tasks at hand are primarily data entry, table creation in Excel and development of an instruction manual in Word. Key Responsibilities: - Efficiently perform data entry tasks in Excel. - Create tables in Excel to visually present the data. - Develop an instruction manual in Word. Ideal skills for this project include: - Advanced proficiency in Microsoft Excel, with a strong expertise in data entry and structuring information. - Proficiency in creating tables, and potentially pivot tables. - Strong experience in creating documents in Word, preferably instructional or informative content. - Attention to detail, as accurate data ...

I'm in need of an Excel calendar for 2024 - 2025 that will be used for tracking school days off and special events. The calendar should feature the following: - Ability to add and modify events - Monthly view - Color-coded categories - Dates should be highlighted with background color Ideal skills: - Proficiency in Excel, including knowledge of advanced functions - Experience in creating and customizing calendars - Design proficiency to ensure aesthetic and functional layout Look at the Sample

I'm currently in need of a professional who can produce a corporate video for my company. The video will primarily focus on showcasing our company culture and values, aiming to be inspirational in tone. Key Requirements: - The video needs to be uplifting and motivating, reflecting the core values of our organization. - Interviews with our clinicians and clients will be the main content of the video, so the ability to interact well with people and bring out their stories is crucial. - Creative input in terms of video editing, background music, and other visual elements is highly valued. Skills and Experience: - Proven experience in video production, especially in the realm of corporate videos. - Adept at conducting and filming interviews in a professional manner. - Ability t...

I'm in need of a virtual assistant to help with a variety of tasks, specifically: data entry, email management, and conducting research. Ideal Skills and Experience: - Proficient in Google Docs and Sheets - Experience in managing email inbox - Can attend video calls and meeting to write MOM with clients I'm looking for someone who can commit to more than 20 hours per week. The ideal candidate should have a basic understanding of Excel or Google Sheets. Your job will be to document data, answer emails effectively, and conduct research on various topics. I am looking for someone who is timely, organized, and detail-oriented. Please reach out if you think you are a good fit for this role.

In this project, I'm needing assistance to extract text data from printed documents and entering it into Google Sheets. This task involves meticulous attention to detail to ensure the accuracy of the data entered. The project requires a freelancer with strong data entry skills and the following qualifications: - Proficient in Google Sheets and Microsoft Excel - Excellent typing speed - Previous experience with data extraction - Ability to work with printed documents - Good at data categorization and organization - Proven track record of accuracy - Strong attention to detail If you have these skills, please bid for this project. Thanks in advance for your time and effort.

I have a calculator form that needs some updates made. It allows the user to input measurements for an industrial hose to find out settings for crimping. Current form is here: Need to add an option for the user to calculate with Hose Wall Thickness OR Hose ID & OD. Here is a prototype showing how this will work: measurements for an industrial hose to find out settings for crimping. Current form is here: Need to add an option for the user to calculate with Hose Wall Thickness OR Hose ID & OD. Here is a prototype showing how this will work: New page (needs some jQuery updates): Also have Excel with new formula

One excel file with macro as per the customer requirement

I am seeking an experienced freelancer who is proficient in data mining tasks in Excel. the analysis must done in excel by installing the data mining tools in excel The ideal applicant should be capable of installing and executing data mining tools in Excel. Unfortunately, I cannot specify what data mining tasks will be performed, nor the type of data provided for the analysis as these details are not available just yet. However, in order to be eligible for consideration, please include: - Detailed project proposal showcasing your approach to data mining tasks. Feel free to inquire if you need any more details. A strong understanding of data mining in Excel is essential for this task. Looking forwar...

As a business owner, I need a data entry operator who is proficient and experienced with Excel formulas. This is fairly urgent, and I am looking to make a quick hire for this role. The complexity of the task at hand includes: - Data entry with calculations - interpretations are not necessary - The project needs to be completed as soon as possible The ideal candidate for this job would possess: - Speed and accuracy for data entry tasks - Strong proficiency with Excel - A deep understanding of Excel formulas - The ability to work under tight deadlines I look forward to seeing your bids and working with you. Thanks!

I need a knowledgeable and experienced pivotchart expert in Excel, who can assist in creating a line chart to visualize my customer data. This chart should effectively illustrate the purchasing behavior of my customers over time. A deep understanding of customer trending and Excel pivotchart is essential. Key Requirements: - Expertise in Excel pivotchart (specifically line charts) - Ability to analyze and visual customer data - Experience in monitoring customer purchasing trends - Quick and efficient work pace - Attention to detail and accuracy - Excellent data visualization skills This role requires strong organizational and analytical skills. Previous experience in similar tasks is highly valued. I look forward to seeing your bids.

...edit yourself or use help of , we will provide access. 5. Responding to user engagement The objective is to grow the social channels, increase engagement and drive more traffic to our website. Crafting engaging and relevant content tailored to each platform is super important. Automating tasks would be a big advantage although not necessary. You will need to keep track of posts in a spreadsheet that will include: time of post, length of content (text/video), number of views, likes, comments, shares after 1 day. We are open for more ideas! If you BREATH social media, this job is for you! You will be paid weekly milestones. In your proposal please include a weekly price for your work. Thanks and good luck!...

I'm looking to revamp my current website. It's an informational site with less than 10 pages, but I feel it needs a serious upgrade in terms of content organization, readability, and visual appeal. Key Requirements: - Improve Content Organization: I need a freelancer who can restructure the content of my site, making it easier to navigate and understand. This may involve creating new sections, reordering existing information, and possibly removing or condensing redundant content. - Enhance Readability: The current site is not as easy to read as I'd like it to be. The chosen candidate should be able to optimize the typography, layout, and overall design to improve the site's readability. - Revamp Visual Design: Aesthetically, the site needs a fresh look. T...

We are an IT consultant organization based in Spain. We are looking for help in the following project. Project description available in Spanish below. Project Description:We are seeking a freelance IT consultant to assist with the implementation of Peer-to-Peer (P2P) distribution solutions within our Microsoft SCCM environment. The project involves setting up either BranchCache with OSD Toolkit or Peer Cache to optimize the distribution of Windows 11 images across our network. The primary goal is to reduce network congestion and improve distribution speed while ensuring minimal disruption to our existing SCCM infrastructure. The consultant will collaborate closely with our internal IT team to define objectives, configure the P2P solutions, conduct a proof of concept (POC), and prov...

I'm in need of a virtual assistant to help with a variety of tasks. One of the primary responsibilities will be finding jobs leads across all industries.l for our cleaning business. Key Responsibilities: - Researching and identi...Responsibilities: - Researching and identifying job leads in all industries - a possible ongoing role for answering emails and messages as well as scheduling appointments. Your primary focus will be on searching for potential job opportunities across various sectors. You should have a keen eye for detail and a thorough understanding of the current job market. This role requires someone with excellent organization skills and a proactive attitude towards task management. Previous experience in lead generation and virtual assistance would be a signifi...

I'm in search of a project coordinator with a background in team coordination and excel. The selected individual will be primarily responsible for planning and organizing a one time project, it will be plotting out some meetings and planninh some deadlines in excel. I'd like to ask them questions while they plan it out if possible! Key Requirements: - Strong Experience in Project Management: This is the most critical requirement. Experience in managing technology-related projects is highly preferred. - Strong Organizational and Time Management Skills: Ability to organize tasks efficiently and manage deadlines effectively. - Excellent Communication and Interpersonal Skills: Ability to communicate effectively with team members, stakeholders, and clients.

I am seeking an experienced SharePoint developer to create a new SharePoint site and list for my team. This list should encompass both team member contact information and task assignments. Organisation of the list should be by both task category and project phase, for easy navigation and maximum efficiency. The significant aspect of this project is n...list 2. Inclusion of team member contact information and task assignments in the SharePoint list 3. Organizing the list by task category and project phase 4. Configuring Power Automate flow for the list Ideal freelancers should demonstrate: * Proficiency in SharePoint and SharePoint Online * Previous experience with Power Automate * Strong understanding of list organization and prioritization * Attention to detail and accuracy in ...

*UPDATED* I'm looking for an imaginative and creative designer to generate a unique logo for our organization. The name is Commercial Academy Ambassador Program. Please refer to the attached logos. Please emphasize the shield image in your design. Please make sure you include all these words in your logo: Commercial Academy Ambassador Program. Our organization is prominently situated within the commercial real estate industry, connecting clients with high-value property solutions. Ideal Skills Include: - Proficiency in modern logo design - Experience in the real estate industry or related fields - Ability to deliver work in vector files Color Scheme & Fonts: Please refer to the attached branding guideline. Incorporate the colors and fonts that you think bes...

I need a proficient Excel expert to adapt my advanced financial models to reflect our current business strategies. The project involves: - Adapting advanced financial models: The existing models are highly complex, with intricate formulas and extensive use of macros. The ideal candidate should be comfortable working with such complexity. - Business strategy alignment: The primary goal is to ensure that these models accurately mirror our updated business strategies. This may involve tweaking existing formulas, adding new ones, and making the models more responsive to changing market conditions. Ideal Skills: - Advanced Excel Proficiency: A deep understanding of advanced Excel functionalities, including complex formulas, pivot tables, and macros is critical. - Financia...

I need a real estate development pro forma converted from a PDF to a functional excel file. One document is 18 pages and the other is 17 pages.

i want 3-5 minutes (both timeframe) candle data into excel sheet. data like date, time, open, high, close, volume of each candle. (check image for refrence) data should be updating in realtime, no delay, next candle data in new row. add instruction, so that i can edit code my self and chsnge stock symbol to get data for desired stock. easy to use and record all day data, even if i open excel at the day end or reopen thw whole day data should be recorded.

Cher Freelancer, Je suis à la recherche d'une personne femme/homme s'exprimant parfaitement en français dans le but de pouvoir appeler des casinos français d'une liste excel avec les numéros de téléphone. Votre mission sera la suivante : - Appeler chaque casino - Obtenir les informations demandées dans le fichier excel - Mettre à jour le fichier - Rappeler les casinos qui n'ont pas pu vous répondre au 1er appel - Répéter l'opération mensuellement ou à convenir Les appels peuvent être effectués en semaine comme en week-end. Cependant, ceux-ci devront être fait le soir dès 20h30. Je recherche une personne avec collaboration sur le long...

Looking for some simple finance-based calculations on a car-budget, some simple ratios and charts, by using MS-Excel. Also need a 650-words write up in 2 to 3 days

...comprehensive wedding website and app that will serve as a one-stop solution for all my wedding-related needs. Key Features: - RSVP Management: The app should be able to track and manage RSVPs from all invitees. - Wedding Countdown: A countdown feature to the wedding date. - Photo Gallery: A place to store and showcase the couple's photos and memories. - Guest Management: The app should have two excel sheets, one for the bride's guests and one for the groom's guests. - Dietary Preferences: A feature to collect and manage dietary preferences of guests. - Seating Charts: Ability to create and manage seating arrangements. - Communication: Integration with WhatsApp to create a community for confirmed guests. - Create an app for it so can log in via website or app. I...

I work for a security company. We needed a spreadsheet to track security units and track what they're doing. I have the code almost perfect, but it's buggy enough that it's hard to use. There's quite a bit of backend code and intermittent problems with it. I need someone who is great at project code to look at it, troubleshoot it and make it more user friendly.

The site was created on WordPress * Set up link personalization so that by clicking on a link sent from the site, the page opens only to the user to whom it was sent. If clicking on the link will enter the login information of another user, in this case it should not proceed. Configure the correct redirect to the necessary sites * insert a link to a document for download on one of the site pages (this document has already been generated and there is a download link on another page of the site) * Add generation of an invoice for using the site in pdf form (the form will be provided) with saving on the pages in the admin panel and on the user page. * Edit the account pages created in the admin panel, add a filter by user, month, account status and account number (these fields have...

...vending project. This one-time task involves analyzing various metrics, such as conversion rates, visitor traffic, and other relevant data to forecast the profitability and feasibility of the project. Responsibilities: - Create a financial model based on the specific requirements of the vending project - Analyze conversion rates, visitor traffic, and other key metrics to predict profit margins - Utilize advanced spreadsheet techniques to organize and present data effectively - Provide recommendations and insights based on the financial analysis Requirements: - Proven experience with financial modeling, preferably in the vending industry - Proficiency in Excel, Google Sheets, or other financial modeling software - Strong analytical and problem-solving skills...

We're looking for multiple competent native English editors to help us improve English language usage in a big batch of Excel-related tutorials. Starting with a paid trial. Please bid $20.

I'm seeking an HRMS solution that delivers the following functionalities for my business, which currently employs between 50-100 workers: - Employee attendance tracking - Leave management - Payroll processing In addition to these fu...will have experience developing HR Management Systems, understanding of payroll systems, and excellent knowledge in varying report generation. Knowledge of regional labor laws and standards would be a major plus. The overall goal is to have a system that offers a comprehensive snapshot of our HR activities. Leaving room for future modifications is a must, based on the evolving needs of the organization. Your bid should reflect a full understanding of these requirements. Simplicity, accuracy, and efficiency are the core considerations for the s...

I'm in need of a master in Excel. Your task will include: - Inputting both textual and numerical data into Excel. - The data to be entered is categorized, meaning that you'll need to pay close attention to how and where the data is entered. Ideal candidates have extensive experience with Excel and a sharp eye for detail. Familiarity with categorized data entry is a plus. Please apply if you think you've got these skills.

We're looking for multiple competent native English editors to help us improve English language usage in a big batch of Excel-related tutorials. Starting with a paid trial. Please bid $20.

I'm seeking an experienced professional who can help me verify specific documents from the European Sleep Research Society in Germany. - The task involves collecting and validating particular documents from this organization. - You should have detailed knowledge of the procedures and requirements for document verification, ideally from the European Sleep Research Society or similar organizations. The purpose of these verifications will be disclosed to the successful applicant. Please share your past experiences in document verification, especially in a similar context. Looking forward to your proposals.

I'm in need of a diligent data entry operator with experience in handling numeric data. The source of the data to be entered is handwritten documents, which require a high level of attention to detail. The final data will then need to be organized in a database format. Key skills and experience required: - Proficiency in numeric data entry - Experience working with handwritten documents - Attention to detail - Experience with database organization The goal of this project is to have all the numeric data from various handwritten documents accurately transcribed and organized in a database.

I want to improve the search function of a webshop. I want to do this by adding extra data to the products (in the form of tags). I have a list of 11,000 product names in Dutch. These product names consist of a piece of proper name, noun and then sometimes some content information. For example: Orange Cleaner degreaser 5L c We are looking for a quick way to see the noun plural in the column next to it. Also, one or more synonyms in the column(s) next to it would be nice. Example: degreasers (=plural) I understand this can be done with a Python script that performs these tasks. This script uses the Natural Language Toolkit (NLTK) library to identify multiples and synonyms. This script assumes you have a list of product names and want to find the plurals and synonyms for each of t...

I am in need of an Excel expert who can assist me with data analysis. The level of complexity I am aiming for is basic sorting and filtering. Crucially, I would like the data analysis to be interactive for users. Key Requirements: - Data analysis in Excel - Proficiency in creating drop-down menus for sorting/filtering - Experience with basic Excel functions and formulas Ideal Skills: - Strong understanding of Excel and its data analysis functions - Ability to create intuitive and user-friendly interfaces with drop-down menus - Excellent communication skills to help with user instructions This project requires someone who can provide a clean, well-structured, and user-friendly Excel file.

Seeking sales enthusiasts ready to make money from the comfort of their homes selling physical products on a full e-commerce platform. Whether you are new to the field or have seasoned experience, join our team to help us broaden our company's online sales. While no experience is required, those with a background or interest in sales could excel in this role, as you will be responsible for maintaining a broad product knowledge of our inventory. Requirements and responsibilities: - Sell a variety of physical products online - Display strong communication skills - Maintain product knowledge - Be reliable and committed Being tech-savvy, having prior experience with eCommerce platforms, or proven sales experience are all a plus but not mandatory. Novices are also welcome to ap...

I'm looking for a skilled trainer to deliver a comprehensive Excel training targeted towards beginners. The training will cater to a larger group of participants, around 15-20 individuals. Key Learning Objectives: - Understanding of Excel formulas and functions - Mastery of data analysis and manipulation The ideal candidate for this project would have a strong command of the above topics, with a proven track record in delivering effective training to large groups. Experience in breaking down complex concepts for beginners is essential. Practical demonstrations and hands-on activities should be incorporated to ensure the understanding and application of the learnt skills. Please, when making a bid, provide a brief outline of how you plan to structure the cours...

I used my cpanel webmail at my hosting company easily on my Gmail account for years, and it stopped working on Sunday. The email still works on roundcube mail on my control panel. It's supposed to be easy to set up either Outlook or Gmail, but I can't do it. Is this expensive?

I need a skilled python developer to create a JSON to Excel converter. Key Requirements: - You'll be working with Flat JSON data - How to handle missing data is up to you - Mapping of JSON fields to Excel columns is flexible Ideal Skills: - Proficient in Python - Experience with JSON parsing - Excel manipulation skills I'm open to suggestions on the best way to map the data, so please include your ideas in your bid. Let me know if you have any questions.

Hi, The task is to scrape a pdf that is downloaded on website. Steps: 1. Go to website 2. Enter code in search and click search. (We provide list code) 3. On the results page Click on pdf document and open or download it 4. Extract 14 pieces of data from the PDF and export into excel sheet. There are about 150.000. Some codes do not have any data then skip. I have attached a word document with pictures and flow for you to review. Thanks!

I need a financial expert to help me with a range of tasks on ...budgeting, and tax preparation. - Specific tasks include: - Creating a detailed breakdown of financial plans and budgets - Ensuring high accuracy in financial planning and budgeting I expect the ideal candidate to be comfortable working with Excel/Spreadsheet, as this is the tool we'll be using to integrate the financial plan and budget. Ideal Skills: - Proficiency in financial planning, budgeting and tax preparation - Proven experience in creating detailed financial breakdowns - Advanced understanding and experience with Excel/Spreadsheet - Excellent analytical and problem-solving skills This project requires someone who pays extreme attention to detail, is comfortable with numbers,...

...should be designed to cater to the needs of both tournament organizers and participants. - Tournament organizers should be able to: - Set up tournament brackets and schedules - Manage player registration and check-ins - Communicate with participants - Update scores and results in real-time - Participants should be able to: - Find and join tournaments - Check tournament schedules and brackets - Receive notifications and reminders - Communicate with other players The ideal freelancer for this project should: - Have a strong background in Android app development - Be familiar with the MOBA gaming genre - Have experience in creating tournament organization features - Be able to design an intuitive and user-friendly interface - Have excellent communication skills, as...