Excel automatic data entry formulaεργασίες

I'm in need of an Excel expert who can help automate some of my book-keeping tasks. The main focus will be on reconciling accounts. Your responsibilities: - Utilise experience with excel formulas and macros to refresh existing reconciliation process for the book-keeping and management reporting of a small UK charity. - Ensuring accuracy and efficiency in the automation. Ideal skills and experience: - Proficiency in Excel, particularly in using formulas and creating macros. - Background in book-keeping and accounting. - Experience in automating tasks in Excel.

lets do a trail at 1000 INR for two restaurant listing

...Telegram's API with Excel. The goal is to download real-time data regarding Bitcoin trades from a specific channel, focusing primarily on market analysis. Key Requirements: - Set up a system to download market analysis related to Bitcoin trades in real-time from Telegram. - Ensure the data is properly formatted and easily readable in Excel. - Implement error handling and data validation to ensure the integrity of the downloaded data. Ideal Skills and Experience: - Extensive experience with Excel, including knowledge of advanced functions and data manipulation techniques. - Proven track record of working with Telegram's API. - Strong programming skills, particularly in languages commonly used for API integratio...

Tagline: "Professional Logo for Tube Fittings, Valves, and Accessories" Project Description: We are seeking a talented logo designer to create a professional and eye-catching logo for our website, Excel Flow Control. Our company specializes in providing high-quality tube fittings, valves, and accessories for various industries. The logo should reflect our expertise and commitment to excellence in the flow control solutions industry. Key Requirements: Brand Name: Excel Flow Control Industry: Industrial and Engineering – Tube fittings, valves, and accessories Design Style: Modern, sleek, and professional with a hint of industrial elements to reflect our niche. Color Scheme: Preferably shades of blue, gray, or metallic tones, but we are open to creati...

I need assistance with cleaning data from several digital Excel files. Key Responsibilities: - Review and clean data in Excel spreadsheets - Ensure data integrity and accuracy Ideal Candidate: - Proficient in Excel - Has experience with data cleaning - Detail-oriented and able to spot errors in data

I'm in need of a market research expert who can help identify potential delegates for an upcoming national trade show. The primary...Skills and Experience: - Market research - Making a Database of potential delegates - Ability to search social media platforms, websites, online databases and online B2B marketplaces - Delegate sourcing to build up a database of potential delegates with contact details in excel as per approved fields - Fields required, First Name, Last Name, Email, Phone Number, Company Name, Fields related to addresses - All the data should be verified Payment shall be made on the basis of each verified data of each contact person Data has to be collected from India and from the specific industry only. Please ensure to provide previous e...

I'm looking for a detail-oriented professional to assist with data entry operations. The primary focus of this task will be entering text data sourced from digital files. Ideal Skills: - Proficient in data entry with a focus on text data - Excellent attention to detail - Familiarity with handling and processing digital files - Time management skills to meet deadlines

I need assistance with manual data entry into an SQL database. The project involves working with database entries, so experience with SQL and data handling is essential. Ideal Skills: - Proficient in SQL - Manual data entry experience - Attention to detail - Data handling skills - Able to work independently and meet deadlines

I'm in need of a comprehensive Excel workbook that can assist in managing and scheduling both staff and volunteers. The workbook should be capable of: - Scheduling staff and tracking days off - Computing hours and calculating salaries Additionally, the workbook should enable viewing the schedule in Gantt charts. Ideal candidates for this project should have a strong background in Excel, particularly in creating complex workbooks with various functions. Experience in HR or volunteer management is a plus. Please note, I will be providing the data necessary for hours computation and salary calculation.

I'm seeking an Excel expert to help me manage and visualize performance grades. The project involves: - Creating tables to breakdown grades according to different units and ranks - Interlinking multiple Excel sheets for live updates - Utilizing formulas and functions for these live updates Ideal Skills: - Advanced Excel skills, particularly with formulas and functions - Experience in data visualization - Ability to interlink Excel sheets I'm looking for someone who can transform this data into a comprehensive and interactive overview of performance grades.

I need a freelancer who can help me extract and label data from a collection of past exam papers. The final product will be a 126 page Excel spreadsheet. The data needs to be organized in the following format: - exam_year_month - exam_id - question_id - scenario_text - question_text - total_marks - answers Ideal skills and experience: - Proficient in Excel - Attention to detail - Experience with data extraction and labeling

I'm in need of an efficient and detail-oriented freelancer to assist with data entry. This project involves both typing from documents and entering data into a database. The data is a mix of textual and numerical information. Ideal Skills: - Proficient typing skills - Experience with data entry - Familiarity with both textual and numerical data - Able to maintain a high level of accuracy and attention to detail

I am in need of a Tableau expert to develop a project that visualizes our employee hierarchy and access levels. The project should include the following: 1. A "Top Office" table that encompasses all ...everything beneath them; supervisors and managers can see their respective employees; and employees can only see their immediate boss. 3. Access control settings that allow for 'Editable for specific roles'. This means that only designated individuals can edit certain parts of the project. Data for this project will be sourced from Excel spreadsheets. It is critical that the freelancer has profound experience with Tableau and is able to create a comprehensive and clear visualization. Familiarity with Excel and understanding of hierarchical structure...

...Freight Management Excel Dashboard Dear I hope this message finds you well. I am looking for an advanced Excel solution for our freight forwarding operations. Below are the specific requirements: 1. Data Entry Form: A user-friendly dashboard to enter shipment details, such as: Arrival and departure times. HBL and CFS manifest details. Railing status, delivery order status. BL (Telex/Original) status. Each shipment should create a unique job number automatically. 2. Centralized Database: All data should be stored in a master Excel sheet, capturing all shipment details. 3. Search and Filter Functionality: Ability to search by job number, BL number, or other fields. Upon searching, display all related details for the specific shi...

Our online school is looking for qualified teachers to teach English, Math, and Science to our Chinese students. ( Students' ages between 3 to 16 years old ) Key Requirements: - Subject-specific degree in English, Math, or Science - Passionate about teaching entry-level students - Willingness to cooperate with our school - Previous experience with Asian students is a plus Ideal Skills: - Strong communication skills in English - Understanding of teaching at entry-level - Ability to make learning engaging and enjoyable

I'm seeking an Excel expert who can help me automate a project progress report using macros. The report will track task completion status. Ideal Skills and Experience: - Extensive knowledge and experience with Excel - Proficient in creating and implementing automation and macros - Previous experience with project tracking and reporting - Excellent attention to detail

As an experienced AI developer, your role in our team will be pivotal in creating a state-of-the-art text-to-video app for the Apple Store. This innovative application will focus on automatic video generation powered by advanced AI technology, specifically Natural Language Processing (NLP). Key Responsibilities: - Develop an app that generates videos automatically from text inputs. - Incorporate moderate levels of user interaction, where users can input some preferences. - Deliver an app that embodies creativity, innovation, and technical excellence. Ideal Skills and Experience: - Proven track record in AI development and app creation. - Expertise in Natural Language Processing. - Experience in developing user-friendly, interactive applications. - Passion for AI and inn...

I need a freelancer who can help me extract and label data from a collection of past exam papers. The final product will be a 126 page Excel spreadsheet. The data needs to be organized in the following format: - exam_year_month - exam_id - question_id - scenario_text - question_text - total_marks - answers Ideal skills and experience: - Proficient in Excel - Attention to detail - Experience with data extraction and labeling

...designated email address if any PC goes offline. Scalable design to handle up to 100+ PCs as the network grows. Server Functionality: Collects status reports from the monitoring software. Serves data to the web-based interface. Scalability and Reliability: Designed to handle up to 100+ PCs and possibly more in the future. Ensure reliability and minimal downtime. Security: Encrypted communication between the PCs and the server. Secure web interface with protection against unauthorized access. Deliverables: Fully functional PC monitoring application. Web-based interface for monitoring the statuses. Automatic email notification system for offline PCs. Complete installation and deployment instructions. Documentation for future scalability and maintenance. Additional Inform...

... Email Creatives: - Creating engaging visuals and layouts for email campaigns. - Ensuring designs align with brand identity and resonate with our target audience. E-commerce Listings: - Assisting in creating and updating product listings with optimized visuals. - Ensuring images and descriptions are consistent across platforms (e.g., WooCommerce, eBay, and Google Shopping). Requirements: To excel in this role, you’ll need: - Proficiency in Photoshop or similar design tools. - A strong portfolio showcasing creative design skills, particularly in e-commerce or digital marketing. - Familiarity with social media ad design best practices (especially Facebook/Instagram). - Experience with e-commerce platforms (WooCommerce, eBay) is a plus. - Excellent attention to detail and t...

I'm seeking a freelancer with robust XLS and data analysis skills who can help me create a PPT presentation based on customer feedback analysis. Key Tasks: - Analyze customer feedback data to identify trends in customer satisfaction. - Pinpoint the most common complaints from the feedback. - Extract suggestions for improvement from the customer feedback. - Create a compelling and clear presentation from the analysis. Ideal Skills: - Proficient in Excel for data analysis. - Experienced in creating presentations in PowerPoint. - Strong analytical skills to interpret customer feedback data. - Ability to present data in a clear and engaging manner.

I'm in need of a skilled developer to scrape phone numbers from www.yellowpages.com.au. The data should be categorized into Plumbers, Electricians, HVAC companies, Roofers, and other trades. Key Requirements: - Delivering the data in an Excel spreadsheet - Including the Company name and Website URL along with the phone numbers - Formatting the phone numbers in International format for easy dialing Ideal Skills: - Proficient in web scraping and data collection - Experienced in using Excel for data organization - Knowledgeable in categorizing trade-related companies

I am in need of an experienced Excel specialist who can create a financial modeling matrix for me. The matrix should be capable of performing ROI calculations and Net Present Value (NPV) calculations. Ideal skills and experience for the job: - Proficiency in Excel, particularly in creating complex models - Experience in financial modeling - Ability to incorporate specific financial formulas into the matrix - Understanding of ROI and NPV calculations. I WILL PAY $30 TO FULLY COMPLETE MY MATRIX AFTER YOU SUCCEED THE FIRST STAGE PLUS A BONUS WHEN I GET PERSONAL GUARANTEE PLUS UNLIMITED REVISIONS

...Implemented). ◦ Logout functionality (Already Implemented). 2. Tournament Management: ◦ Search for tournaments using filters. ◦ Create tournaments (if KYC verified and with sufficient account balance). ◦ Join tournaments (if sufficient balance exists). ◦ View past tournaments they participated in. ◦ Confirm readiness before tournament start or wait for automatic start at a predefined time. 3. Monetary Transactions: ◦ Deposit real money via payment gateway. ◦ Withdraw funds with a 30-day security grace period for added funds/winnings. ◦ KYC verification and bank account linkage to PAN/AADHAR for withdrawals. 4. Invitations: ◦ Invite other players via platform-generated URLs. ◦ Share...

I'm experiencing various issues with approximately 5 short Microsoft Power Automate flows. I am attempting to create and fill a WORD template by completing a form in Microsoft Lists....am attempting to create and fill a WORD template by completing a form in Microsoft Lists. The form must then be changed to a PDF and emailed. I am presently using a Plumsail action but would like to get rid of it. One of the flows is the same as previously stated but fills an Excel template instead. Key Requirements: - Troubleshoot and fix various issues with the flows - Ensure accurate and efficient file processing Ideal Skills and Experience: - Expertise in Microsoft Power Automate - Proficient in handling PDF, Excel, and Word files - Strong problem-solving skills to identify and recti...

We are looking for an experienced data entry specialist familiar with Blesta, a billing and client management platform, to help us set up our new service offerings. Using our newly designed website and pricing matrix as a reference, you will be responsible for inputting all the features, packages, and pricing details into our Blesta system. Requirements: Experience with Blesta: You must have hands-on experience with configuring and managing services, packages, configurable options, and pricing in Blesta. Strong attention to detail: Accuracy is essential to ensure all data is correctly entered and functional within Blesta. Data entry skills: Ability to efficiently input, organize, and validate data. Good communication skills: You’ll need to ...

...solution must be built using Power Apps, Power Automate, and Power BI, leveraging Dataverse as the central data repository. Key functionalities include: Tenant management and lease tracking. Maintenance scheduling and task tracking. Automatic billing, payment reception, and reconciliation by property. Supplier management, including invoice tracking and payment processing by property. Investor reporting and financial oversight with interactive Power BI dashboards. The ideal candidate will have expertise in building solutions on the Power Platform, with a strong understanding of Dataverse for data modeling and integration. Experience in automation workflows, financial processes, and data visualization is essential. This project aims to streamline operations, e...

...Surcharge, Damages, Cancellation Fee Mileage: Allowance, Actual Mileage, Excess Mileage Charge Payment: Deposit, Payment Amount, Card Fee Outputs: Total Cost, Refund/Outstanding Amount Step 2: Excel Layout Design an Excel sheet with the following structure: Description Input Formula/Explanation Check-Out Date 01/10/2025 User input Check-In Date 01/25/2025 User input Rental Duration (Days) =B3-B2 Rental Type Daily/Weekly/Monthly/3-Month Dropdown using Data Validation Daily Rate $50 User input Weekly Rate $300 User input Monthly Rate $1,000 User input 3-Month Rate $2,800 User input Rental Cost Formula depends on rental type (see Step 3 below) Fuel Surcharge $30 User input Damages $100 User input (if applicable) Mileage Allowance (miles) 500 User input...

I need a professional with strong Excel skills to help me analyze sales data using pivot tables in a spreadsheet. The primary aim is to gain insights into sales trends over time. Ideal Skills: - Advanced Excel and Pivot Table expertise - Data analysis experience - Ability to uncover trends and insights from data

I'm in need of a skilled data entry professional to assist with entering numerical data from our databases. The primary purpose of this project is for record keeping. Ideal Skills: - Proficiency in data entry - Familiarity with handling numerical data - Experience with database management - Attention to detail - Good organizational skills Your task will primarily involve: - Accessing our databases - Accurately entering numerical data - Ensuring all records are kept updated and organized

I'm seeking a proficient Jotform programmer to create an event registration form. The form needs to include: - Payment integration - Customizable fields - Automatic email confirmations Freelancers should highlight relevant past work, particularly projects involving Jotform and event registration. Experience with Jotform's payment integration and setting up automatic email confirmations is essential. Please include any examples of your past work that you believe may be relevant.

...to assist with text creation. Daily Targets: Successfully post a minimum of 160 links across the internet each day. Important: Only links that remain live and online will count toward your daily target. Links that are removed, deleted, or flagged will not be considered. Tracking and Reporting: Maintain a well-organized record of all links posted. Submit proof of work at the end of each day in Excel format, listing all successfully posted links. Work Schedule: Days: Monday to Friday Hours: 8 hours per day Skills & Requirements: Attention to Detail: Accurately track posted links and ensure they stay live. Efficiency: Achieve the daily target of 160 live links consistently. Online Familiarity: Ability to navigate various websites, forums, directories, and communities. Writin...

Found the Selected Data from One Excel file on the Other File. Both files are provided for reference. "Scores" sheet, find the same song on the

I’m seeking a talented artist who loves Pokemon, logos, and fun colors. Freelancer musts: -No Canva -Must provide rights to th...copyright, but I do love the angle and design of this. (See Image Named "Example Logo") Here are the gem styles I’d like to replicate in our own color scheme. (See Image Named "Gem Shapes") I’m thinking these are the colors I’d like to use. (See Image Named "Colors") Prismatic is the keyword, and all auto responses will be automatically deleted. Asking to work off of Freelancer will be an automatic block. AI art submissions will be reported. If you have a love for fun colors and playful design, I would love to see your work! See the doc for more information:

I'm in need of an Excel template builder who can create a template for weekly reports concerning employee shift schedules. The primary focus of these reports will be on scheduling management. Key Requirements: - Build an Excel template that can track employee shift schedules on a weekly basis. - The template should be user-friendly and easy to update with new data. Ideal Skills: - Proficiency in Excel and its advanced features (like pivot tables, VLOOKUP, etc.) - Experience in designing Excel templates. - Understanding of scheduling management. I am looking for someone who can complete this task efficiently and accurately, allowing for smooth tracking of employee shifts.

We are seeking a versatile Data Analyst to support multiple companies across different industries. The ideal candidate will excel in transforming raw data into actionable insights using various visualization tools and will be adept at managing and querying databases.

I need a freelancer to convert a 3-page PDF document into an Excel file. The Excel layout should mirror the PDF exactly. The PDF contains primarily text and numbers. Key Requirements: - Convert data from the PDF into Excel, maintaining the original layout. - Utilize your judgement to handle any ambiguities or potential errors in the PDF. Ideal skills for this job include: - Proficiency in Excel - Attention to detail - Ability to make educated guesses when faced with uncertainties in the source material.

...have an Excel file with multiple tabs, each representing a month of the year. Within each tab, my products are listed in one column, and the days of the month are represented in rows. The cells that intersect contain a number representing the quantity of products sold on the corresponding day. I need a new dynamic tab created that has at least two columns: one for products that have sold at least one unit, and another for the total number of items sold. Products that have no sales on a given day should not be displayed. This new tab should be dynamic, allowing me to see which products have sold on a given day. There should be a day selector that filters the products accordingly. Specific Requirements: - The new tab should be formatted as a simple table - The project is in E...

I'm in need of an Excel wizard to create a Monthly Sales MIS Report for me. This report needs to focus exclusively on sales data and perform a trend analysis. Key Responsibilities: - Collect and analyse sales data on a monthly basis. - Identify and illustrate trends in the sales data. Ideal Skills and Experience: - Proficiency in Excel, including the use of advanced functions and features. - Previous experience in creating MIS reports. - Strong analytical skills with a focus on trend analysis. - Excellent attention to detail.

I'm in need of a competent office clerk who can assist with data entry and handle some odd jobs around the office. The prime responsibilities will include: - Data Entry: Accurately inputting and managing data in our systems. - Maintenance Tasks: Assisting with basic upkeep of the office. Skills and experience ideal for this role would include: - Proficiency in data entry. - Strong organizational skills for office maintenance tasks. - Ability to handle odd jobs with a positive attitude. Please note this is not a customer service or scheduling role, but a hands-on position requiring a proactive and diligent individual.

...a Windows (Linux would be considered) software application that takes input from an RFID tag, converts it to decimal, sends this decimal to a web API, and displays the returned result on the screen. The current output is HTML, but we can switch to JSON if necessary. The RFID tag readers are OmniKey 5022, with 13.56MHz ISO14443A tags. Currently, we have a simple web page setup with a clock, an entry box, and a submit button. We're using a third-party software to read the RFID cards, but it doesn't always work as intended due to startup sequence issues. This new application should: - Display the web API response on the screen - Not require any user authentication - Show error messages on screen for any issues, such as failed API calls or invalid RFID tags Ideal candid...

Chemical Engineer Needed for Creating Industrial Chemical Datasheets and Catalogs **Description:** We are looking for a freelance Chemical Engineer with expertise in industrial chemicals to create professional datasheets and cata...looking for a freelance Chemical Engineer with expertise in industrial chemicals to create professional datasheets and catalogs for our products. **Requirements:** - Research and compile technical specifications and industry applications. - Prepare datasheets and catalogs in editable formats (Word, Excel, and PDF). - Ensure the output is professional, accurate, and visually appealing. **Skills Required:** - Strong knowledge of industrial chemicals. - Proficiency in Microsoft Word, Excel, and PDF tools. - Excellent research an...

I'm in need of a professional who can create a web-based data entry tool for a MySQL database. This tool will handle mixed data types: text and numerical. The primary functions of the tool will be to facilitate data input and conduct validation checks. See attached file for specifics. Key Requirements: - Proficiency in MySQL database management - Experienced in web-based application development - Prior work on data entry and validation tools - Understanding of both text and numerical data processing Please include examples of similar projects you've completed in your proposal. Thank you.

I'm in immediate need of a Certified Public Accountant (CPA) with extensive experience in Quickbooks management, bookkeeping, auditing, journal entry, US tax filing, and balancing the books, specifically within the realm of trucking company accounting. The ideal candidate for this role should possess the following skills: - Strong experience working with Quickbooks software - Thorough understanding of US tax laws - A background in trucking company accounting - Exceptional attention to detail - Demonstrated ability to deliver timely and accurate financial reports The project is extremely time-sensitive, so I'm looking for a professional who can start right away and work efficiently to get the job done. If you meet these criteria and are available to start immediately, ple...

I'm looking for an Excel expert who can help me build a comprehensive report showing Actuals vs Budget vs FC vs PY. The report will primarily serve as a financial overview tool and needs to be updated daily. Key requirements include: - Proficient in Excel with advanced skills in data analysis and visualization. - Experience working with internal databases and external data feeds. - Ability to understand and interpret financial data. - Capability to create automated daily updates for the report. Please include examples of similar projects you've completed in your proposal.

I need to convert file format from Altium Designer format to EAGLE format the Altium files are for STM32F746G-DISCO PCB Design () PCB are 4 layers medium complexity with components THT and SMD both side and following dimensions The conversion should be reviewed manually (no automatic conversion) in all details and DRC applied and the final result on Fusion 360 (or Eagle) should be 100% error free including Gerber file generation and libraries

I'm seeking a meticulous freelancer for a data entry task. The job entails transferring data from a 300-page PDF file into an Excel spreadsheet. The data needs to be organized into clear columns such as First Name, Last Name, Address, City, ZIP Code, and Other relevant details. Requirements: - Exceptional accuracy and attention to detail. - Experience in data organization in a clean and structured format. - Timely delivery of the completed file. The data in the PDF file is text only and has a consistent layout. If you're interested, please provide your estimated time and cost for this task. Thank you!

I'm looking for an Excel expert to create a macro that will help in task automation. The specific tasks to be automated will be discussed later. Ideal Skills: - Proficiency in Microsoft Excel - Experience in developing macros for task automation - Excellent problem-solving skills - Ability to understand and analyze tasks for automation Please provide examples of similar projects you've completed in your proposal.

I have a collection of printed documents containing text data that need to be entered into a Word document. The ideal freelancer for this task should possess the following skills and experience: - Excellent typing skills with a high level of accuracy - Proficient in Microsoft Word - Prior experience in data entry - Attention to detail - Ability to maintain confidentiality and handle sensitive information with discretion.

I'm seeking an expert to help with my spreadsheet. The project involves formula adjustments and formatting changes, specifically applying conditional formatting. The ideal freelancer should be adept at adding new formulas and fixing existing ones.