I'm looking for a part-time assistant to help with a simple data-entry task. The task involves reading data from a TradingView chart and transcribing it into an Excel spreadsheet. Key Details: - The task will take approximately 5-8 hours to complete and needs to be repeated every week. - You have the flexibility to choose the day and time of the week to perform the task. - An initial 1 hour training/demonstration via video call (either Skype or Signal) is required. - You should be able to understand spoken English, particularly my Australian accent. Please provide your hourly rate.
I'm looking for a way to calculate the totals in a specific cell within a bunch of worksheets all within the same Windows folder. Key Requirements: - The workbooks I want to sum from only contain one sheet each. - I want to specify the cell to sum by cell reference (like A1) Please let me know if you can help.
I need assistance with transferring data from a Word file to an Excel file. - Content: The Word file contains text only, with approximately 200 line items. - Task: Copy and paste each line item from the Word file including the headers into the D column of the excel file. - Text Wrapping: Ensure to wrap the text so that everything fits into Column D. - Starting Point: Begin placement at row 321 in the Excel file. - Formatting: Bold all headers in the Excel file, no other additional formatting is needed. Please ensure no line is missed in the transfer. Ideal skills for this project include proficiency in Excel and attention to detail. Previous experience with data entry is a plus.
I'm seeking a proficient Excel expert to update my spreadsheet. The task primarily involves working with existing formulas and performing statistical analyses. Key Responsibilities: - Update formulas in various tabs based on new data. - Conduct statistical analysis similar to what's already present in the spreadsheet. Ideal Candidate: - Strong proficiency in Excel, specifically with formulas and calculations. - Experience with statistical analysis. - Attention to detail to ensure all updates are accurate and consistent.
I'm looking for an Excel expert to help me match a specific value X in my data and list the adjacent values to the right. Key Details: - Data Format: The data is in an Excel sheet. - Scope: I need values from 12 columns to the right of the matched value X. -If selected supplier, then bring that selected supplier information to the final selected supplier area. - Output Format: The results should be placed in "Final Selected" range Ideal Skills: - Proficient in Excel and data manipulation. - Experience with matching and filtering data. - Ability to clearly communicate progress and results.
I am looking for an experienced Financial Analyst with advanced Excel skills to collaborate on my project. Specifically, I am interested in purchasing pre-built, high-quality financial models that are robust, user-friendly, and professional. These models should cater to the needs of accounting and finance professionals. Examples of the types of models I’m looking for include: Cash Flow Forecasts Budget Templates Budget vs Variance Analysis KPI Dashboards for Finance or Accounting Financial Analysis Models CAPEX Trackers Requirements: Models must be dynamic, well-structured, and easily customizable. Must include detailed formulas, assumptions, and visualizations (if applicable). Ideally suited for use by accountants, finance managers, and analysts. You must have the legal ri...
I have an Excel spreadsheet of companies and need someone to find their respective domains and add them to the spreadsheet. Requirements: - Find the domains of each company in the list - Add the domains to the existing Excel spreadsheet - Perform basic verification of the domains for accuracy Ideal Skills: - Proficient in Excel - Internet research skills - Basic understanding of domain verification processes - Attention to detail
...Professional Data Entry, Excel Management, and Photo Editing Services As a skilled Data Entry Operator with extensive experience in handling various types of data, I offer fast and accurate data entry services to ensure seamless management of your information. I specialize in organizing and inputting large volumes of data into spreadsheets, databases, and other systems. My ability to maintain consistency and accuracy is crucial for any project that requires timely completion. In addition to data entry, I provide expert Excel management services, specifically for handling protein data. Whether it's for scientific research, dietary tracking, or nutritional analysis, I can structure and organize protein-related information efficiently. I am proficient in using Excel...
i have two of my suppliers websites that i need product data scrubbed and put into an excel sheet. All the images need to be saved to a file with product code label.
...data being stored and retrieved from a database. Key Project Requirements: - User Roles: The site will have two levels of user access control: Admin and User roles. - Financial Tables Functionality: Users should be able to add, edit, and delete entries, filter and search data, and generate reports on financial tables. - Data Handling: The site will allow for manual upload of Excel files and exporting data to Excel for further analysis. The pages of the site will include: 1. Categories and Pricing: Displaying items, prices, buyers, sellers, and profit margins. 2. Account Assets and Expenses: Summarizing the account's assets and expenditures. 3. General Account Information: Showing overall account details. Ideal Skills and Experience: - Proficiency in PH...
...automatically receive reminders for the event via WhatsApp and email. • Automation tools like Power Automate or other free solutions should be used (NO paid 3rd party integrations allowed). 3. Backend Dashboard for Admin • The admin should: • Able to upload an Excel file containing a list of attendees to be added to the sign up database • Create and schedule to Trigger *Unlimited* bulk messages (email and WhatsApp) from the dashboard to remind/invite them to a Zoom session. • Functionality should include: • Bulk messaging from the Excel data. • Management and re-blasting scheduling options for reminders. Completed and running in the hosting server. Recourses : Website is using wordpress . Microsoft 365 suite , hosting ( hostgator - Cp...
...discrepancies or inefficiencies. Ensure compliance with financial policies, procedures, and accounting standards. Administrative Support: Maintain accurate and organized financial records and documentation. Assist with payroll processing and reporting. Liaise with external auditors, tax advisors, and financial institutions as needed. Qualifications: Bachelor’s degree in Accounting, Finance, or a related field (preferred). Proven experience as an accountant, bookkeeper, or in a similar financial role. Proficiency in accounting software (e.g., QuickBooks, Xero) and Microsoft Excel. Strong understanding of accounting principles, practices, and regulations. Excellent organizational, analytical, and problem-solving skills. High level of accuracy and attention to detail. ...
I'm looking for a professional who can create a comprehensive spreadsheet for my locksmith business, focusing on financial tracking. The primary purpose of this spreadsheet will be to monitor weekly pay, monthly expenses, and year-t...monthly expenses, and year-to-date totals. Key Requirements: - The spreadsheet should be user-friendly and able to provide rolling totals. - Depending on the final design, the spreadsheet may need to generate reports automatically, so a versatile approach is preferred. - It should be able to accommodate both manual input and potential future automation. Ideal Skills: - Proficiency in Microsoft Excel or Google Sheets. - Experience with financial tracking and report generation. - Previous work with small business or service industry spreadsheets w...
I'm in need of a skilled Excel professional for data analysis. I have a dataset ready for analysis. Please note that the specific type of analysis hasn't been predetermined, so flexibility and expertise in various types of data analysis will be beneficial. Ideal Skills and Experience: - Proficient in Excel - Strong data analysis skills - Experience with various types of data analysis - Able to deliver insightful interpretations of the data
...build a custom Excel sheet for tracking progress claims on construction projects. Key Features: - Automatic calculations: The sheet should be able to compute totals, subtotals, and other necessary financial figures without requiring manual input. - Customizable templates: The spreadsheet should be template-based, allowing for easy customization to suit different projects. Ideal Skills: - Proficiency in Excel with a strong understanding of its advanced features (formulas, pivot tables, macros etc.) - Experience in construction project financial tracking would be a significant advantage. - Ability to create user-friendly, customizable templates. - The data in the current pdf spreadsheet does not need to be fully replicated. - Sheet 1 - Progress Payment...
...Those are not correct. I will randomly pick some data and call them to verify the quality of your data collection. 5) No duplicate contact is allowed. Daily update is required. Finding the URL, writing script or using any other form of tools, platform, VPN, are your responsibilities. I will NOT provide anything. 6) Populate the Excel sheet, remove duplicate, clean it up with proper column formatting for easy readability purpose, post link to the populated Excel sheet. Do not send me junk or screen shot. I do not want to see email in phone column or vice versa. Email is the most important field. a) Milestone 1- Deliverable: 131,050 rows - - DFW-USA: From the 22 US Universities listed, collect 50 professors / Instructors and 1,000 students (BS, MS, and Ph.D...
...build a custom Excel sheet for tracking progress claims on construction projects. Key Features: - Automatic calculations: The sheet should be able to compute totals, subtotals, and other necessary financial figures without requiring manual input. - Customizable templates: The spreadsheet should be template-based, allowing for easy customization to suit different projects. Ideal Skills: - Proficiency in Excel with a strong understanding of its advanced features (formulas, pivot tables, macros etc.) - Experience in construction project financial tracking would be a significant advantage. - Ability to create user-friendly, customizable templates. - The data in the current pdf spreadsheet does not need to be fully replicated. - Sheet 1 - Progress Paymen...
...Those are not correct. I will randomly pick some data and call them to verify the quality of your data collection. 5) No duplicate contact is allowed. Daily update is required. Finding the URL, writing script or using any other form of tools, platform, VPN, are your responsibilities. I will NOT provide anything. 6) Populate the Excel sheet, remove duplicate, clean it up with proper column formatting for easy readability purpose, post link to the populated Excel sheet. Do not send me junk or screen shot. I do not want to see email in phone column or vice versa. Email is the most important field. a) Milestone 1- Deliverable: 131,050 rows - - DFW-USA: From the 22 US Universities listed, collect 50 professors / Instructors and 1,000 students (BS, MS, and Ph.D...
...of an Excel-Based Budgeting and Monitoring Tool for Construction Projects (WBS-Based) Description: We are seeking an experienced freelancer to create a budgeting and monitoring tool for construction projects, designed exclusively in Microsoft Excel. The tool must be based on a Work Breakdown Structure (WBS) and include task and activity management, rather than focusing solely on resources. Required Skills: • Expertise in project management (ideally with a PMP certification or equivalent). • Strong proficiency in Microsoft Excel, including advanced formulas, pivot tables, macros, and VBA. • Experience in developing Excel-based tools for complex projects. • Understanding of construction projects and their unique requirements. Expected...
I need to find and compile contact information for 382 Conveyancing Solicitors and 313 Probate Solicitors within 25 miles of MK45 1AH. Requirements: - Data scraping expertise - Excel proficiency for data organization Task Breakdown: 1. Gather a list of 382 Conveyancing Solicitors and 313 Probate Solicitors using data scraping techniques. 2. Compile their details (Name, Company Name, Company Address, Phone Number, Email) into a spreadsheet. The email should be sourced from their respective websites. 3. Categorize the solicitors' data based on their type - "Conveyancing", "Probate", or "Conveyancing/Probate" (for duplicates). 4. Organize the entire list by distance from the postcode MK45 1AH. Please note: - The ideal freelancer should have experie...
Support in Sage300 payroll for Sep and Dec-2024
Instructions: Duplicate this google Sheet: Go to the website and review the colors in the website theme, pick the top 3 colors. Look at the background colors as the first color, Button color as number 2 and another accent color or font color as number 3. Use Chrome extension to speed up the process: All colors must be readable with a White Background, Meaning, White or very light colors are not acceptable. If the Name, website columns the same or similar the colors can be the same If the colors are this, They are not correct, They were defaults: {#303954,#6993CD,#ECA542} Columns
I'm looking for an Excel expert to create a comprehensive Excel sheet for my team's workload analysis and look-ahead program. Key Functions: - Workload Distribution: The sheet should help in distributing tasks evenly among team members based on their capacity and skillset. - Progress Tracking: It should allow us to monitor the progress of each task and project. - Deadline Reminders: The sheet should have a mechanism for reminding us of upcoming deadlines. The sheet will be used exclusively by my team members, so it needs to be user-friendly and intuitive. No integration with other software or tools is required. Ideal Skills: - Advanced Excel skills - Experience in creating workload analysis tools - Understanding of project mana...
I need assistance uploading 40 variable products on my WordPress site. These products will have size variations. I will provide a Google Sheet with product details, image folders and images. Key Responsibilities: - Uploading products on WordPress - Setting up size variations for each product - Ensuring the correct images are uploaded to each product Ideal Candidate: - Proficiency in WordPress and WooCommerce - Experience with product uploads - Attention to detail to ensure all products are uploaded correctly.
I'm working on Excel export feature.
Automated Investment Management Tool for Rupeezy Broker (Phase 1: Buy/Sell Automation) Project Description: The objective of this project is to develop an Excel-based or standalone software solution integrating Rupeezy broker APIs. This Phase 1 focuses on automating basic Buy and Sell functionalities, along with real-time reporting, margin trading calculations, and investment tracking. Additionally, the tool will include a feature to automatically calculate target price adjustments based on user-defined profit percentages and margin costs, executing orders daily when conditions are met. Phase 1 Requirements: Core Features API Integration: Integrate Rupeezy broker APIs using: API Documentation GitHub Library Securely connect to the broker's platform for real-time data and o...
I'm seeking a meticulous data entry professional to help with organizing and validating customer data. The data is currently in Excel/CSV files and requires detailed validation for accuracy. Key Responsibilities: - Input, sort, and organize customer data with precision. - Perform detailed validation checks to ensure data accuracy. - Assist with data management and reporting as needed. Ideal Skills: - Exceptional attention to detail and accuracy. - Proficiency with Excel/CSV files. - Experience with data entry and quality control. - Strong administrative support skills. With over 24 years of experience in administrative roles, including expertise as a Steno-Typist, Personal Assistant, and Admin Manager, I am confident this project will be a success. I look forward to...
I'm seeking an expert in Microsoft Excel to create a dynamic and visually appealing sales analysis dashboard for my bicycle business. This tool will help in understanding various performance metrics, and ultimately, in making informed business decisions. Key Features: - Incorporation of specific metrics: Sales trends by month, Profitability by product, and Customer demographics. - Exclusive use of Pie charts for data visualization. - Implementation of advanced data analysis techniques: Forecasting future sales and Seasonal trend analysis. The ideal candidate will have extensive experience in data analysis and visualization using Excel, with a strong understanding of business metrics. Prior experience in creating interactive dashboards will be a significant advantage. P...
I am seeking a skilled data analyst with a strong background in prescriptive analysis, utilizing Excel spreadsheets and SQL databases. The primary focus of this project is to conduct a thorough examination of our data for market research purposes. Key Responsibilities: - Conduct prescriptive data analysis to aid in decision making - Utilize Excel and SQL for data manipulation and examination - Deliver insights that can influence our market strategy Ideal Skills: - Advanced Excel and SQL proficiency - Expertise in prescriptive data analysis - Experience in market research analysis Please include your relevant experience and examples of similar projects in your bid.
I'm seeking a detail-oriented professional to assist with entering customer data from Excel spreadsheets into our database system for my existing business. Key Responsibilities: - Accurately input customer data from Excel into our database system. - Maintain confidentiality and handle sensitive information responsibly. - Ensure data integrity and consistency throughout the process. Ideal Skills and Experience: - Proven experience in data entry, particularly with customer data. - Familiarity with Excel and database systems. - Excellent attention to detail and a commitment to accuracy. - Ability to maintain confidentiality and handle sensitive information responsibly.
I'm seeking a talented Figma designer to create interactive prototypes for a comprehensive Human Resource Management system. This project encompasses all facets of HR, including employee onboarding, performance management, and payroll processing. Deliverables: - Interactive prototypes designed in Figma Ideal Skills: - Proficient in Figma - Experience in designing HR management systems - Ability to create engaging, user-friendly interactive prototypes. Please provide examples of similar projects you've completed in your bid.
...Software. The software should focus on: - **Operation Management**: Ensuring smooth transport operations. - **Accounts Management**: Handling all financial aspects including income, expenses, and VAT details. - **Payroll Processing**: Efficient management of employee salaries and other compensations. - **Invoice Generation**: Automatic creation of invoices for services rendered. The ideal candidate for this project should have a strong background in software development with specific experience in creating transport management software. Understanding of accounts management, payroll processing, and invoice generation is essential. Prior experience in developing software for transport operations will be a significant advantage. Please, include in your proposal any simila...
I'm looking for a data-savvy freelancer to help me gather information on software and AI influencers. The primary task is to find their email addresses, primarily from their personal websites and exact number of subscribers on YouTube. Skills and Experience Needed: - Proficient in web research and data collection - Familiarity with YouTube and other social media platforms - Att...primary task is to find their email addresses, primarily from their personal websites and exact number of subscribers on YouTube. Skills and Experience Needed: - Proficient in web research and data collection - Familiarity with YouTube and other social media platforms - Attention to detail - Ability to present data in a clear and organized manner The data should be presented in a Spreadsheet (Excel/...
I need a proficient Android app developer to create a telecalling application. The app's main function will be for lead generation. Key Features: - Admin Panel: A separate web-based dashboard where I can upload contact details from an Excel sheet. - Click-to-Call Functionality: The app should display contact details for easy dialing. - API Integration: The app must utilize the Gsm (Phone SIM) for calling. - WhatsApp API: To send messages to end users directly from the app. - Feedback Mechanism: Incorporating a call disposition mechanism to capture conversation feedback through predefined options. - Tracking Features: The app should monitor total calls dialed, average talk time, and various call statuses (completed, missed, lead, callback, prospect, etc.) - Reporting: An...
...to the second stage (Chamber of Commerce websites) ** Here is exactly what you will do in this first stage, step-by-step: Stage #1: Municipality websites: a) You will scrape the website for every municipality (i.e. city) in Canada. I have a sheet that contains source websites for the ten provinces and three territories in Canada. Each source website contains links to the websites of municipalities in that province/territory. You will review those source websites and scrape all municipality websites from each source website. Here is the sheet with source websites for the ten provinces and three territories in Canada: b) Check the municipality websites for the top 50 municipalities (by
I'm in need of a person to create an Excel catalogue for my collection of 78 RPM discs. (had to re post as images and uploads did not come through on prior post) With 203 images to work from, the catalogue will need to encompass several key pieces of information which is available on the image of each disc including the artist, song title, record label, catalogue number, genre, unique identifiers, and any other relevant details observable from the images. The final catalogue will also need to include a condensed size version of each photo. - Artist - Song Title - Record Label (exact wording) - Catalogue Number (if applicable on disk) - Genre (basic classification e.g., Jazz, Blues) - Unique Identifiers (full transcriptions of labels) - Any other information found on each pho...
I'm looking for someone proficient in Microsoft Excel to assist with data entry. The data is mixed - both numeric and text. Key Responsibilities: - Accurately input mixed data into Excel - Perform basic data validation checks to ensure accuracy - Report any discrepancies in the data Ideal Skills: - Proficiency in Microsoft Excel - Attention to detail - Ability to perform basic data validation checks Experience with data entry and Excel is a must. I look forward to your bids.
I need an expert to help me through some excel questions for about an hour on a zoom call. My main goal for the call is: - Creating new formulas The ideal freelancer for this project should have: - Extensive experience with Excel, particularly with creating mathematical operations - Excellent communication skills for a seamless Zoom interaction - Patience and ability to explain complex concepts in a simple way
I'm seeking an experienced SQL developer to write a MySQL query for me. The task involves combining two data tables based on a specific column, with the aim of generating an output that includes SKU, Product Name, Sales Group, Category, Cost Price, and Sales Price. Key Requirements: - Combine the dat...with the aim of generating an output that includes SKU, Product Name, Sales Group, Category, Cost Price, and Sales Price. Key Requirements: - Combine the data based on the item_id column. - Filter the data based on the Sales Group. - Ensure the query is compatible with MyPHPAdmin. - The final output needs to be exportable to Excel. Ideal Skills and Experience: - Proficient in SQL and MySQL. - Prior experience with data integration tasks. - Familiar with MyPHPAdmin and Excel...
I'm looking for someone to manually collect email addresses from various programming sites. Skills & Experience: - Familiarity with programming sites like Stack Overflow, GitHub, and Reddit. - Experience in data collection and research. - Proficient in Excel, CSV and Text file formats. Please note, the specific programming sites and email types will be discussed further. I'm seeking assistance in collecting member emails from specific programming community websites I will provide. Your task will primarily focus on gathering emails of recent members from these sites. You have to manually go to user profile look, for his email if not there search email for same person from his linkedin profile or google or github or twitter etc etc profile. The ideal candidate for...
I'm seeking a skilled professional with deep expertise in dynamic programming and non-linear programming. The primary objective of this project is optimiza...non-linear programming. The primary objective of this project is optimization modeling, specifically targeted at leveraging dynamic programming techniques. Ideal Skills and Experience: - Advanced knowledge in dynamic programming - Advanced knowledge in operations research - Proficient in linear programming - Skilled in dynamic programming - Experienced in non-linear programming - Highly proficient in Excel for modeling and analysis Please note, the focus will be primarily on dynamic programming and non-linear programming. Your ability to apply these techniques to complex optimization problems will be key to the success o...
Location: Remote (UK-Based Only) About Us: We are a growing website design and development studio specialising in crafting tailored online solutions for SMEs and specialist businesses, including schools, estate agents, accountants, lawyers, and more. While we excel in technical expertise, we are seeking a dynamic and experienced sales partner to join as a co-founder to help us drive growth. The Opportunity: This is a unique chance to become a commission-based co-founder of a promising digital studio. You’ll take charge of sales and client acquisition, while we focus on delivering high-quality technical solutions. Together, we’ll scale the business and share in its success. What You’ll Do: - Develop and execute sales strategies targeting SMEs and specialist indu...
I need someone to help me with typing some text data from an Excel file. The data is a few pages worth of text. Ultimately, I need the typed data to be compiled into a plain text file. Ideal Skills: - Proficiency in Excel - Fast and accurate typing skills - Attention to detail - Experience with creating plain text files
...Include fields like Name, Subject Expertise, Experience, Contact Details, and Availability. o For Parents: Include fields like Student’s Name, Grade, Subject(s) Required, Location, and Budget. 2. Link Forms to Google Sheets: o Connect each Google Form to a dedicated Google Sheet to automatically log responses. o Example: Teacher Responses → Teachers Database Parent Requests → Parents Database ________________________________________ Step 3: CRM Setup 1. Use a no-code CRM tool like Airtable, Zoho CRM, or a custom Google Sheet-based CRM to: o Manage teacher and parent records. o Track ongoing and completed tuition assignments. o Store revenue-sharing details. 2. CRM Fields: o Teachers Database: Name, Subject, Experience, Contact, Availability, Status (Act...
