Excel automatic data entry formula jobs

...positive workplace culture. Key Responsibilities: - Data Entry: Accurately inputting information into our systems. - Scheduling: Coordinating calendars and scheduling meetings. - Document Preparation: Assisting in preparing various documents. - Admin Tasks: General office management duties. - HR Tasks: Primarily focused on assisting with employee documentation. I require someone who is equally adept in handling administrative and human resources tasks. Your ability to manage multiple responsibilities, prioritize effectively and meet deadlines without compromising on quality will be key to your success in this role. Ideal Skills and Experience: - Proven experience in administrative support and human resources. - Exceptional data entry skills. - Proficien...

I need someone to extract data from my invoices and enter it into Microsoft Excel and then into both a desktop and a cloud-based application. Key Tasks: - Extract data from invoices - Paste data into Excel - Enter data into a desktop app and a cloud app Ideal Candidate: - Familiarity with data extraction and Microsoft Excel - Experience with both desktop and cloud-based applications - Attention to detail to ensure data is entered accurately

I'm in need of a trading strategy to be implemented on the TradingView platform using Pine Script. The strategy should be based on breakout techniques and specifically utilise the Central Pivot Range (CPR) indicator. Key requirements: - Develop a comprehensive strategy that includes Entry points, Targets, and Stop Loss (SL). - Incorporate a Dynamic Trailing Stop (TS) within the strategy. - The strategy should be designed for a single timeframe, as I do not require multi-timeframe analysis. - The milestone for payment will be created only after the strategy is fully ready and tested. Ideal Skills: - Proficiency in Pine Script. - Experience with TradingView platform. - Strong understanding of breakout strategies and CPR indicator. - Ability to incorporate dynamic elements into...

...freelancer to generate organic installs for our Chrome extension AskMeOffers. ✅ Link: ? Steps for users: Visit the link above. Click Add to Chrome and confirm. Start saving with automatic coupon application! ?️ Endorsed by MrBeast – trusted by millions! Looking for creative strategies to drive organic traffic and installs. Apply now! Steps for users: Visit the link above. Click Add to Chrome and confirm. Start saving with automatic coupon application! ?️ Endorsed by MrBeast – trusted by millions! Looking for creative strategies to drive organic traffic and installs. Apply now! Key Responsibilities: - Utilize diverse channels such as social media, blogging and content marketing, and influencer partnerships

I'm in need of a meticulous freelancer to assist with manual data entry of my purchases. Key tasks include: - Extracting relevant data from my online transaction reports. - Manually entering this data into a specified format. The data to be entered primarily comes from PDF files of my invoices. Ideal skills and experience: - Proficient in manual data entry. - Comfortable working with PDF files. - Attention to detail is a must to ensure accuracy.

I'm looking for a skilled Excel expert who can transform my investment portfolio data into a user-friendly, dynamic spreadsheet. Key Requirements: 1. Create a comprehensive, dynamic Excel table capturing all of the client's investment positions. 2. Organize information into dedicated columns for each data point (e.g., ISIN, Name, Price, etc.) 3. Utilize advanced graphic design skills to present the data in an intuitive and visually appealing manner. The aim is to create a UX-friendly information table suitable for individual investors. 4. Include a dedicated column with links to Yahoo Finance or Investing.com. Each link should correspond to the historical chart data of each investment position. Ideal Skills: - Proficient in Microsoft ...

I need immediate assistance in resolving some issues in Power BI. Main issues: - Dates not displaying in correct order in a chart. - Need help with displaying employee hierarchy data in an organizational chart. Data Source: - Current data source for my Power BI report is an Excel file. Ideal skills and experience: - Proficiency in Power BI is a must. - Experience with Excel as a data source. - Ability to create and troubleshoot organizational charts. - Strong problem-solving skills for date sorting issues.

I'm looking for a professional who can proficiently analyze data using Excel, specifically looking at descriptive statistics. In addition, I need assistance with managing and strategizing my social media ad campaigns. Ideal candidates should have: - Strong expertise in Excel, particularly in data analysis - Experience in working with descriptive statistics - Proven track record in managing social media ad campaigns - Skills in creating compelling ad content - Ability to interpret data and adjust campaigns accordingly Please provide examples of your previous work related to this project.

Hello, I have a WordPress store (ecommerce), I am interested in generating an automatic price calculation according to parameters that I will indicate to you I have a certain price list for each category, this means that all the products in the same category have the same price according to the variations (my website works according to the variations and not necessarily according to the quantity, which means that the customer chooses the quantity through a variation, and not through the cart to which he adds the product several times ) I want to have an automatic price calculation between products that are in the same category, example: There are currently 2 products in the boutique strains category called Black Widow and Caviar Gold If I choose a 5G variant for both produc...

I need someone to help with typing text from business-related PDFs into a system. The PDFs primarily contain text documents and there's no special formatting to retain. The main goal of this task is for data entry into a system. Ideal Skills: - Fast and accurate typing skills - Attention to detail - Experience in data entry Please note, the PDFs do not contain any special formatting or elements that need to be retained.

I need a freelancer to scrape 30,000 records of contact information from a provided URL within 48 hours. The information will specifically consist of names, email addresses, phone numbers, and mailing addresses. The final output should be in an Excel format. Ideal skills and experience for the job include: - Proficiency in web scraping - Experience with Excel - Attention to detail - Ability to meet tight deadlines

I am looking for a skilled and efficient data entry operator to assist me with manual data entry tasks. Requirements: - Proficient in manual data entry - Experienced with MySQL databases - High speed and accuracy in data handling Tasks will primarily involve: - Inputting data into MySQL databases - Ensuring the data is entered correctly and efficiently

...professional to set up a two-node Oracle 19c RAC database on Oracle VirtualBox 7.14 for a test environment. Key Requirements: - Host System: Windows 11 powered by Intel i5 12th Gen with 64 GB RAM - Install Oracle Linux Server 8.8 on both cluster nodes, assigning 12 GB RAM to each - Configuration of ASM with specified disk groups: - OCR: 3 GB - DATA: 30 GB - RECO 20 GB - Installation of Oracle 19c Grid software - DNS setup can be ignored - Use of Automatic Storage Management (ASM) for disk groups I have the Oracle Linux Server 8.8 ISO ready, and no special network settings are needed for the cluster nodes. The ideal freelancer for this project should have extensive experience with Oracle databases, VirtualBox, and Linux systems. Please be prepared to demonstrate ...

Hi. It’s supposed to generate teams based on data from several sheets, but it’s not working as I need. Additionally, I would like to have a button to update the data for each game week. I’m attaching the code so you can review it and help me out if possible. Thanks in advance!

I'm looking for a dedicated data entry professional. The job involves: - Handling mixed content data from digital files - Ensuring a typing accuracy of at least 90% The source of the data will predominantly be from a portal, so familiarity with web-based platforms is a plus. Experience with data entry is essential, and a keen eye for detail will be highly valued.

I'm seeking a professional who can automate user registration and forum posting on my Xenforo forum through or similar platforms. Tasks: - Automate user registrations on my Xenforo forum. - Enable automatic posting of text posts using predefined templates. Ideal Skills: - Expertise in Xenforo forum software. - Proficiency with automation tools like Make.com. - Strong understanding of user registration systems. - Ability to work with predefined posting templates.

I'm looking for an Excel sheet that generates newspaper bills for approximately 150 houses on a weekly basis. This should include the delivery charge and provide a total for each week, as well as a 4-week total, excluding holidays or days when the paper isn't delivered. Key Requirements: - The bill should include the house number and address, total number of papers delivered, and the week's total cost including the delivery charge. - I need to manually enter non-delivery days. - The final summary of the total weekly and 4-week costs should be displayed in the same Excel sheet. Ideal Skills & Experience: - Proficiency in Microsoft Excel, particularly in creating complex sheets with formulas and functions. - Previous experience in creating billing or...

...Sales and Marketing Data **Description:** We are seeking an experienced Power BI developer to create a comprehensive report for our sales and marketing data. The ideal candidate should have a strong background in data visualization and analysis, with a proven track record of delivering high-quality Power BI reports. **Project Requirements:** 1. **Data Integration:** - Integrate sales and marketing data from various sources (e.g., CRM, ERP, Excel files). - Ensure data accuracy and consistency. 2. **Report Design:** - Create visually appealing and interactive dashboards. - Include key metrics such as sales performance, marketing campaign effectiveness, customer segmentation, and ROI analysis. - Design reports that are easy...

I'm seeking a skilled Android & iOS developer to create an event registration app with the following features: ...with session details (title, speakers, time, location). -Add sessions to a personal calendar or create a custom agenda. - Real-time updates to agenda (push notifications for changes). 3. Lead Scanner: QR code scanning for exchanging contact information between users (attendees, exhibitors, and organizers). Store scanned leads in a dedicated section. Export leads to Excel or other formats. The app should have a manual form entry system for event registration. The ideal candidate for this project should have a strong background in iOS development, experience with integrating payment gateways and implementing push notifications, and a knack for creating u...

I'm in need of a professional who can extract data from a corporate website and compile it into an Excel spreadsheet. Key Requirements: - Extract data from a corporate site. - Data includes: Shopping Centre Name, Street Address, Suburb, State, and Post Code. - Focus on all store locations in New South Wales (NSW). - Use web scraping techniques for data extraction. Ideal Skills: - Proficiency in web scraping. - Experience with data extraction from corporate sites. - Excel spreadsheet management skills. - Familiarity with New South Wales geography is a plus.

I need a proficient Excel expert to help me with a VLOOKUP task involving my inventory data. Specific task: - The VLOOKUP function needs to match exact quantities within my inventory. Ideal Skills: - Advanced proficiency in Excel, particularly in using VLOOKUP. - Prior experience in inventory management is a plus.

...delivering a detailed database of 7,000 US companies. Each company profile must encompass key details like the company name, and its associated emails (e.g CEO email, Owner email, Founder email etc.) along with the website. Key Requirements: 1. All data must be current and verified for precision. 2. Data must be sourced from credible platforms to ensure uniqueness, eliminating any duplication. 3. Final data should be presented in an orderly Excel or Google Sheets format. 4. Timely delivery within 7 days from the project start date. 5. Proficient use of data scraping and verification tools and platforms. Please ensure to read the project description carefully before bidding. If you're not in agreement with the budget or are unable to fulfill the ...

I'm in need of a data entry expert who can help input both text and images onto my website. - Text: The text data will be sourced from various online platforms. Your ability to discern, extract, and input relevant information accurately is key. - Images: The images will also be sourced online. Familiarity with stock image websites and an eye for appropriate visuals will be beneficial. Skills and experience that would be ideal for this project include: - Proficiency in data entry and web navigation - Experience with sourcing and selecting relevant online content - Familiarity with stock image websites - Attention to detail - Ability to work independently and efficiently

I'm in need of a freelancer who can assist with various tasks for my oil palm industry company. The highest priority task is data entry, specifically manual data entry from documents. - Data Entry: The data will need to be manually entered from inventory and stock lists. This will require a keen eye for detail and the ability to work accurately and efficiently. - Business Logo: I also need assistance in creating a professional and eye-catching logo for my business. - Accounting: Finally, I need help with basic accounting tasks. Ideal skills for this job include: - Proficiency in manual data entry - Basic understanding of accounting principles - Creative skills for logo design - Attention to detail - Ability to work effic...

I'm looking for an expert in financial modelling to create a comprehensive Excel model for my new business. The model will be used primarily for an investor presentation, so it needs to be robust and compelling. Key Requirements: - Inclusion of all essential financial statements: Income statement, Balance sheet, and Cash flow statement. - Projections covering a period of 5 years. Ideal Skills: - Expertise in financial modelling and Excel. - Experience with investor-focused financial presentations. - Ability to create clear and precise financial statements.

I'm...Grocery Items Database suitable for an online app and website. The database needs to be in Excel format, and must include: - UPC, Bar code - Product Name - Product description - Unit - MRP - Multiple high resolution images The database should cover all branded standard grocery items across the following categories: 1. Fruits 2. Vegetables 3. Grocery & Staples 4. Breakfast & Dairy 5. Biscuits & Snacks 6. Beverages 7. Personal Care 8. Home Care Ideal Skills: - Database Management - Data Entry - Research Please note: - The data should be free from copyright restrictions and not sourced directly from Google. - I will need an initial sample to assess the quality of the information and images. - Data needs to be structured in a cat...

I need an Excel file containing my bank transactions converted into a QFX file, which can be imported into Quicken. Ideal Skills and Experience: - Strong proficiency in Excel - Experience with file conversion to QFX - Familiarity with Quicken software - Attention to detail to ensure all transactions are accurately converted.

I have an Excel file that contains crucial customer information. I need it organized correctly to facilitate better understanding and accessibility. Requirements: - Primary focus on organizing Names and Contact Details. - Each contact's item should be in its own column: Name, Email, Street, City, State, Post Code, and Country. Ideal Skills and Experience: - Proficiency in Excel - Experience in data organization - Attention to detail

I'm in need of a comprehensive operating and financial model in Excel for a new venture. The model should encompass an operations section, a financing component (balancing both Debt and Equity), and generating complete Profit & Loss and Balance Sheet outputs. Key Requirements: - Detailed representation of production costs, sales volume, employee expenses, and capital costs in the operations section. - Consideration of daily hire rates, income from asset disposal, build period expenses, and utilisation metrics. - The financing section should adequately reflect a mixture of Debt and Equity. - Major sensitivities to be clearly presented within the model. Ideal Skills and Experience: - Proficiency in Excel with a strong background in financial modelling. - Previous ex...

I need an Excel dashboard created to track H2S material limits. The primary data source will be Excel Spreadsheets. The dashboard should allow me to monitor: - Material Suggestions I would like the data to be visualized using Pivot charts. Attached file has some created dashboard but they do not provide accurate data. Need to modify it and make more accurate. Ideal skills for this job include Excel proficiency, data visualization, and experience with dashboard creation.

I'm in need of an Excel expert who can help me build a comprehensive workbook to capture end of shift data from multiple locations. Key categories to include: - Delays OS&D - Scanning/PLS Cube Outs - Equipment Issues - Driver Issues - Safety Crucial categories for reporting: - Delays OS&D Specifics for managing Delays OS&D: - I need to be able to list specific delays Ideal skills and experience: - Proficient in Excel - Data management experience - Ability to create user-friendly and efficient workbooks.

I'm seeking help with ICDL programming, specifically focusing on Excel, Word, and PowerPoint. Ideal Skills: - Proficient in Excel, Word, and PowerPoint. - Experienced in teaching or tutoring ICDL content. - Able to prepare for certification assessments. Key Tasks: - Assist with understanding and practical application of ICDL concepts. - Provide targeted help with Formulas and Functions in Excel. - Support with general use of Word and PowerPoint. - Prepare for certification.

...project and need assistance with Microsoft Excel and PowerPoint. Microsoft Excel: - Data Entry & Formatting: I have a lot of data that needs to be entered and formatted correctly in Excel. - Creating Formulas & Functions: I need someone who is skilled in Excel to create appropriate formulas and functions to manage my data. - Data Analysis & Visualization: The project will require some data analysis and I would appreciate help visualizing the data using Excel tools. Microsoft PowerPoint: - Creating a Presentation: I need a PowerPoint presentation to accompany this project, so experience in creating engaging and clear presentations is a must. Ideal candidates should have: - Advanced skills i...

I need assistance with an Excel spreadsheet. The task involves adjusting column D to ensure all wrapped text is readable. - Number of Rows: The column contains between 100 and 500 rows. - Software: The file is in Microsoft Excel. - Specifics: Only column D needs to be adjusted, not the entire spreadsheet. Ideal skills for this project include proficiency in Microsoft Excel, attention to detail, and experience with data manipulation and formatting in spreadsheets.

...create a script or class that generates PDF/A-1a compliant files from the text stored in my database. The content of the PDF will primarily be text, with some logos and icons as images, as well as tables and bullet lists. Key Features: - The PDFs will generally include an index, with each entry linked to specific content via internal links. - The content is text, tables, lists, images (path to local images) to take from a database. - The images are and must be stored in folder on the server. - Proper data structure with titles, tags, labels, internal links, etc., to meet PDF/A-1a standards. - Validation of the generated PDFs for PDF/A-1a compliance. - Ability to append an existing PDF/A-1a document at the end. Additionally, I would like to know if it's possible al...

I'm looking for an Excel expert to help me with a task related to tracking revenue. The primary focus will be on creating projections based on available market growth data. Key Responsibilities: - Analyze market growth data to create revenue projections - Use advanced Excel skills to apply necessary equations and techniques Ideal Skills: - Proficient in Excel, particularly with financial equations - Experience in revenue tracking and forecasting - Strong analytical skills to interpret market data

I need assistance with extracting text data from 7 PDF files into a spreadsheet. The data from each PDF will go into a specific, pre-existing worksheet within the spreadsheet. - Type of Data: The extraction will only pertain to text data. - Structure: The text data in the PDFs is well-organized with clear sections, making the extraction process straightforward. Ideal skills for this task include: - Proficient in data entry and spreadsheet management - Excellent attention to detail - Familiarity with PDF data extraction I have attached a sample PDF document and Spreadsheet with the first section of data already extracted from the PDF into the relevant worksheet. I have also created a video demonstrating what is required: :v:...

I'm looking for an Excel expert to help me create a comprehensive inventory management spreadsheet for my business. Key Requirements: - Inclusion of all our supplier's items that we sell - Categorization of items by product type The ideal freelancer for this project should have extensive experience with Excel and inventory management systems. They should be able to create a user-friendly, efficient, and organized spreadsheet that meets these requirements.

I'm seeking a software developer to create a Windows-compatible solution for managing estimates, sales/purchase orders, and invoices for our dealer network. Key Requirements: - Create a user-friendly interface for managing estimates, sales orders, purchase orders, and invoices. - Design the software with a primary focus on generating estimates. - Incorporate customizable templates for the estimates, ensuring they can be tailored to specific needs. - Ensure compatibility with the Windows operating system. The ideal candidate will have: - Extensive experience in software development, particularly for Windows. - Proven skills in designing user-friendly interfaces. - Prior experience in developing software for managing sales and purchase orders, and invoices. - Ability to create customi...

I require an experienced professional to manage a team handling refund calls for my Walmart store. We've bee...and oversee the distribution of payments. - Track and report call outcomes: It’s also important to monitor and report the results of the calls. Ideal Skills and Experience: - Good communication skills: Employees must be able to communicate effectively with customers. - Experience in customer service: Prior experience handling customer calls is a plus. - Proficiency in data entry: Employees should be comfortable with entering data accurately and efficiently. I will provide all necessary phone numbers and cover call costs. Each call takes between 3 to 8 minutes. If 100 employees handle 10 calls daily, that’s $1,200 USD. I’ll pay $1.2 USD...

ISP1 (Primary or principal) - Connected to ether1. ISP2 (Backup) - Connected to ether5 The failover must switch to ISP2 only if ISP1 loses actual internet access, not only if the gateway is unreachable, because could the Gateway answer but without internet access. For example, Pings to 8.8.8.8 should be forced through ISP1 to confirm real internet loss. Once ISP1 is restored, the system should automatically switch back to ISP1. It's important to make sure the ISP1 has real internet connection for example Pings to 8.8.8.8.

I'm in need of a dynamic and creative Online Assistant to support me with a variety of essential tasks on a daily basis. Key Responsibilities: - Email management: Organizing and responding to emails - Data entry: Inputting and maintaining data - Scheduling and calendar management: Keeping track of appointments and deadlines Required Skills and Experience: - Proficiency in Microsoft Office Suite - Prior experience in a similar role is preferred - Strong organizational skills - Excellent communication skills Please note, tasks will need to be completed on a daily basis.

I need assistance with a data entry task. The project involves transcribing text from printed hardcopies into a text file. Ideal Skills: - Fast and accurate typing skills - Attention to detail - Proficiency in creating and editing text files - Prior experience in data entry from printed materials Please ensure your proposal reflects your relevant experience and skills. Thank you.

...expert to update my Excel dashboard. This dashboard is currently used for reporting the daily status of equipment. The update should streamline the process, making it faster and more convenient. Key Tasks: - Revamp the Excel dashboard to improve its efficiency - Incorporate equipment status and availability as primary data points - Ensure the new setup accommodates future needs - Due to much formula, the sheet is slow to navigate Currently, I manually input the status and availability of equipment into the dashboard. The updated dashboard should ideally reduce the manual workload and make the reporting process more efficient. Skills and Experience Required: - Proficiency in Excel, with a strong understanding of dashboard creation and management - E...

I'm looking for a designer to customize an elevation we already have to look like the customer's drawing. The current design needs to incorporate cedar-stained double entry doors (4-lites) with sidelights, white horizontal lap siding body with a grey fieldstone base (3'), and it needs consistency with the windows and doors (4-lites with matching pane sizes). I also need it to show asphalt shingles with metal decorative awnings. Ideal skills and experience: - Proficient in design software (AutoCAD, SketchUp, etc.) - Strong understanding of farmhouse aesthetic - Experience with lap siding and stonework - Creative with incorporating unique design elements - Able to produce high-quality, detailed design plans.

...tool. I have a bunch of other bigger projects which I'm looking for a dev for and this lotto project will potentially lead to regular work in an exciting, leading edge of blockchain development. I am looking for a long term-relationship with a quality dev to build amazing things. Key features of the application will include: - No user signup, the user only enters their chosen name for their entry to the lotto when sending their ticket purchase: The app will lock all of the users' ticket amounts into a smart contract with time lock and paid out at a specific time every week to a randomly chosen address. - Lottery ticket purchase: The app should facilitate easy and secure purchase of lottery tickets. - Prize payout management: This feature should ensure that the priz...

I need an expert in Excel VBA to breathe new life into my project. The enhancements will involve: - **Data processing and automation**: Improving the efficiency and speed of data handling processes. - **User interface enhancements**: Making the project more user-friendly with better forms, buttons, and navigation. - **Integration with external systems**: Ensuring seamless connectivity with other platforms and systems. The user interface improvements will focus on: - **Forms and input fields**: Streamlining data entry and enhancing usability. - **Buttons and navigation**: Simplifying the user journey through the project. - **Report layouts and visuals**: Upgrading the presentation of data for better comprehension. Visually, the reports will need...

I am looking for a Hindi-speaking individual to visit our warehouse in Port Klang, Malaysia. The purpose of this visit is to teach a small group of our Indian staff (1-5 members) basic computer skills. Skills to be taught include: - Using a web browser - Using Google Sheets - Using Microsoft Excel The level of proficiency we aim for is basic. Your role will be crucial in helping our staff become more computer literate and improving their productivity. Ideal candidates will have: - Proficiency in Hindi and Malay - Strong knowledge of basic computer skills - Experience in teaching or training - Patience and good communication skills

1) Collect data, examine it, and identify any duplicates or outliers, ensuring its completeness and accuracy. 2) Create a table and organize the data in a clear and easy-to-understand format. 3) Provide statistical analysis using mean, median, mode, variance, standard deviation, and other relevant metrics. 4) Present charts that illustrate the relationships between variables 5) Present charts that help predict future trends, identify gaps, and improve performance and operational efficiency.

...complete this questionnaire sheet this weekend, so may I request your professional English writing expertise. Fill out the attached sheet to provide input for this comedy writing material based on rationality in everyday life. I welcome you to read the following first, then check out the sheet, place a bid. It would be kind of you to provide the answers using quality English grammar in the attached Excel spreadsheet within 2 days. Allow me to observe your progress after the first hour so I can provide early feedback on your answers. Get into the spirit of comedy writing, consider all the witticisms and wordsmith techniques, and provide your best answer to each of the questions (70+). Look for inspiration online around jokes, puns, irony, repartee, sarcasm, memes, idioms, brainy-...