Excel Jobs

I’m in need of an experienced Excel software engineer who specializes in automation. The project revolves around automating data entry tasks in Excel. We are an accounting firm and I am looking to automate my compliance practices. Tasks include 1) rolling forward previous year excel work papers 2) taking information from. Client data sheets (excel) and importing into new excel workpaper workbook 3) data analytics based on metrics 4) hyperlink to source data Ideal candidates should have: - Proven experience with Excel macro programming and automation - Ability to work with numeric and legal data - Strong attention to detail to ensure data accuracy This will be a valuable addition to our workflow. Looking forward to your proposals.

I'm looking for a data sourcing and CRM expert to help me build a targeted lead list for prospecting. The ideal candidate will have experience in: • Identifying relevant data sources for lead generation based on an Ideal Customer Profile (ICP). • Sourcing high-quality contact information (emails, phone numbers) for 100-200 potential customers. • Data cleansing and validation to ensure accuracy. • Uploading the cleaned data into HubSpot CRM. Project Goals The goal of this project is to establish a foundation for targeted email marketing campaigns. This will be achieved by: • Creating a targeted lead list based on my ICP. • Uploading the lead list into HubSpot for easy campaign management. Your Responsibilities • Collaborate with me to define my Ideal ...

I need a Google Sheets expert to help me put together an extensive and detailed cricket schedule for the upcoming English summer season. Tasks Include: - Including International, Domestic, and Club tournaments and teams in the schedule - Organizing fixtures based on the date Additional Details: - Each fixture should have comprehensive information about the venue - Match timings should be included - Broadcast details for each match should be provided Ideal Skills: - Proficiency in Google Sheets - Knowledge of cricket and its various tournaments - Attention to detail to ensure that all necessary information is included - Time management skills to complete the project in a timely manner more details--- ### Task Description: Google Sheets Data Entry Expert for Cricket Schedule **Objective...

I need an Excel expert to create a comprehensive spreadsheet to track and calculate project costs, revenues, expenses, and profits. Specific calculations required include sum, average, percentage. The Excel sheet should track the following: - Project cost - Project revenue - Project expenses - Percentage of account receivable - Percentage of account paid - How the client paid after tax - Description for the costs - Percentage of the costs - Percentage of the profit before tax - Percentage of account receivable before tax - Date of payment The data presentation in the spreadsheet should be in the form of tables and graphs. Experience with financial data analysis and management is vital. Understanding of cost and profit calculations, as well as capability to implement advanced Excel fun...

I have an existing Excel macro that is predominantly used for handling formatting tasks within the Excel file. However, I need an expert who can assess and modify it to ensure compatibility with Excel for Mac 2019 or later. Key Requirements: - The existing macro primarily deals with formatting tasks within the Excel file. - The data in the Excel file is stored in both text and numerical formats. - The main change required is to update the formulas in the macro to ensure it functions smoothly on Excel for Mac 2019 or later. The ideal freelancer for this job would have prior experience with: - Excel macros and VBA - Formatting tasks in Excel - Updating or creating cross-platform Excel macros This project requires a meticulous attention to detail, as the compatibility adjustments are cru...

I'm in need of a skilled professional who can provide me with HD screenshots of successful stock trades made on the Robinhood platform. I will need at least 50 screenshots in total. The screenshots must include the following key details: - Trade date and time - Profit margins - Stock symbols and volume This project requires a meticulous and detail-oriented individual who is capable of accurately capturing and presenting the specified information. Experience with stock trading or familiarity with the Robinhood platform would be advantageous, but not mandatory. Thank you in advance for your help.

I am seeking a skilled data miner to initially extract at least 1,000 company names, telephone numbers, and emails of translation agencies in the United States. We will provide the names of the cities, and the data miner will be responsible for searching local translation agencies on Google that meet these requirements. The database is to be created on a Google Spreadsheet. Based on this information, please tell us how many entries you can complete per hour and your best rate per hour.

I have a PDF file with over 50 pages of data in mixed formats - text, numbers, and tables. The task is to accurately transfer this data into an Excel spreadsheet in a tabular format. Key requirements: - Data entry from a PDF file into an Excel spreadsheet - The data is of moderate complexity, so a good understanding of Excel is needed - The output should be a well-organized and clean Excel spreadsheet Ideal skills for this job: - Proficiency in data entry and working with large data sets - Advanced Excel skills, including the ability to work with mixed data formats - Attention to detail and accuracy to ensure the data is correctly captured - Experience with PDF to Excel data conversions would be a plus Please note that while the task is to transfer data, there is no requirement for dat...

--- ### Job Title: Excel Sheet Creation for Job Tracking and Payment Calculation **Description:** I need a custom Excel sheet to help me track jobs completed by my installers, including details about each job, such as dates, customer information, and payments. The sheet should be able to automatically calculate the total number of jobs done and the total payment owed to each installer. **Requirements:** 1. **Job Tracking:** - Columns for the date each job was completed. - Columns for the job details including customer address and account number. - Columns for the installer assigned to the job. 2. **Payment Calculation:** - Ability to input the payment rate per job. - Automatic calculation of the total number of jobs completed by each installer. - Automatic calculation...

I am looking for an expert who can assess and modify an existing Excel macro for compatibility with Excel for Mac 2019 or later. The current macro mainly handles formatting tasks within the Excel file. Key Requirements: - Assess the current macro's compatibility with macOS - Modify the macro to ensure compatibility with Excel for Mac 2019 or later I don't have a strict deadline for this project, so you can work on it at your own pace. However, I am looking for someone who can get this done efficiently and effectively. Feel free to ask any questions for more information. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge of macOS compatibility issues with Excel macros.

I'm in need of a knowledgeable expert to help manage my bookkeeping using FreshBooks. Your tasks will primarily involve: - Maintaining financial records and handling all business transactions - Ensuring accuracy and maintaining systematic order Ideal candidates should be well-versed with FreshBooks and have profound experience in accurate bookkeeping. A strong comprehension of financial statements and the ability to organize large amounts of data are also critical. Previous accounting experience would be a bonus. Prompt, reliable, and detail-oriented professionals are preferred.

I'm looking to integrate Open AI capabilities with Google Sheets to create an AI assistant that can provide our customer real time inventory information when asked. Key Project Details: - The main task of the AI assistant will be to provide real-time inventory information from Google Sheet that contains our inventory data. Ideal Skills: - Solid experience with Google Sheets API - Proven track record of integrating AI tools with external data sources - Understanding of real-time data processing and automation - Familiarity with predictive inventory management would be a plus I'm looking for a freelancer who can bring both technical expertise and creative problem-solving skills to this project.

As a new hotel owner, I need an Excel spreadsheet capable of calculating the optimum number of staff I need based on the number of available rooms, which in my case is 438 rooms. My current hotel staffing level is in its initial stages. The spreadsheet should effectively track staff allocation costs and other related expenses to assist in budgeting. The key tasks it will need to perform include: - Calculating the optimum number of staff - Staff allocation - Expense tracking The ideal freelancer will have experience in human resources, budgeting and have advanced Excel skills. They should understand how staffing impacts hotel operations and costs, with a keen understanding of allocation of resources. Their experience should also include creating Excel spreadsheets for companies in their...

I need a skilled data entry professional to help me with a project. I have a large volume of text-based data that I need input from physical documents. The task involves organizing this data in a document. Key Responsibilities: - Transcribing text-based data from physical documents accurately - Ensuring the data is organized as required in the document Ideal Skills and Experience: - Proven experience in data entry - Strong attention to detail - Proficiency in handling text-based data - Familiarity with transcribing from physical documents - Ability to maintain confidentiality of sensitive information The successful candidate will be reliable, efficient, and able to deliver accurate work within the agreed timeframe.

I require a professional data entry freelancer to help me with a PDF data extraction task. The project involves extracting and organizing information from a series of PDF files. The data to be extracted varies and includes both text data and numerical data, in addition to images or diagrams. The ideal freelancer for this project should be experienced in data entry and be comfortable working with PDF files. Key requirements for the project include: - Extracting text and numerical data from PDF files - Organizing the extracted data in an easily accessible format - Ensuring accurate extraction of information - Handling images or diagrams within the PDF files The extracted information will be used for further analysis and will significantly contribute to a larger project. Accuracy, speed, a...

I'm in need of a talented financial analyst to create a robust underwriting model for a multi-family property. Key Requirements: - Develop a comprehensive underwriting model for a multi-family property that will assist in calculating the internal rate of return (IRR) and equity multiple. - This model should also include waterfall projections that cover profit splits, with and without preferred returns. Additionally, I require a clear, user-friendly format that is easy to understand for someone without an extensive financial background. The ideal candidate for this project should have a strong background in finance, specifically in multi-family real estate. In summary, the main deliverables for this project are: - Underwriting model for a multi-family property - Multiply Water...

I'm in need of an experienced data entry specialist who can assist in uploading 850 products onto my online store. You will be provided with the necessary product information (description, price, specifications) in the format of Excel/CSV files. Your tasks will include: - Accurate data input of all relevant product details - Verification and correction of any existing data entries - Ensuring all listings are in sync with their corresponding inventory Ideal Skills: - Experience in data entry, particularly e-commerce product listing is preferred - Proficiency in Excel - Attention to detail and accuracy are extremely essential - Fast typing speed with a keen eye for details. Please only bid if you have relevant experience, and can start work promptly.

I'm looking for a financial expert skilled in Tally ERP9 to help with specific bookkeeping tasks. This includes bank reconciliation for 1-5 accounts on a monthly basis, as well as the generation of financial statements. Key Responsibilities: - Reconciliation of 1-5 accounts monthly using Tally ERP9 - Generation of monthly financial statements The ideal candidate should: - Be proficient in Tally ERP9 - Have prior experience in bank reconciliation - Possess a strong understanding of financial reporting I need someone who is detail-oriented, has excellent organizational skills, and can provide accurate financial records in a timely manner. Prior experience with similar tasks is a definite plus.

I'm looking for an experienced freelancer who can create an Excel calculator for historical cryptocurrency prices from Binance and Luno. The calculator should also include fiat exchange rates for major currencies such as ZAR/USD bank sell rates Key Requirements: - Retrieve historical price data from Binance and Luno - Incorporate USD, and ZAR exchange rates - Organize the data and create user-friendly interface - Ensure accuracy and reliability of the calculator - Prioritizing the preservation of data privacy Ideal Skills: - Proficiency in Excel and data manipulation - Familiarity with cryptocurrency exchange APIs - Knowledge of major fiat currency exchange rates - Strong analytical and problem-solving abilities Please include your relevant experience in your application. Thank you...

I'm in need of a skilled online data entry professional for a project involving the extraction of data from various websites and organizing it into a database. Key Responsibilities: - Conducting online data entry tasks from multiple websites. - Ensuring the accuracy and completeness of the data. - Organizing the entered data into database entries. Ideal Skills and Experience: - Proven experience in online data entry. - Proficiency in web browsing and data extraction. - Strong attention to detail and accuracy. - Experience with organizing data into database entries would be considered a plus. Please only apply if you have a strong track record in online data entry and can guarantee the quality of the work.

I would like to see the result statistic in %. Important, when i refresh the excel i always want to see the last 5, last 10 and last 15 results.

I need a talented typist to help with a large-scale project. The task at hand involves typing numerous reports. These reports are not overly complex and do not require any advanced formatting or design work. Instead, basic formatting is all that is needed to give them a professional look. Key requirements: - Large volume of typing work - Typing and basic formatting of reports Ideal skills and experience include: - Proficiency in typing and formatting - Capability to handle a high volume of work - Attention to detail for accuracy - Experience with report typing is a plus

I require an expert in MS Access and Visual Basic programming to design a user-friendly form input interface for my project. - This interface should be intuitive and be capable of capturing and effectively managing predominantly text data. - Familiarity with database systems and strong understanding of user interface design principles will be extremely advantageous. - I'm looking for someone who can deliver quality work promptly. Demonstrative past experience in similar tasks will be highly advantageous.

I am looking for a freelancer to assist with cleaning and analyzing a small dataset in Microsoft Excel. Key Responsibilities: - Data Cleaning: The dataset includes multiple columns and rows that need to be checked for inconsistencies, errors, and duplicates. - Data Analysis: After cleaning, I need the freelancer to perform basic data analysis to extract meaningful insights from the dataset. Ideal Skills: - Proficiency in Microsoft Excel and experience with data cleaning and analysis. - Attention to detail to ensure the dataset is thoroughly cleaned. - Basic data analysis skills to interpret the dataset and present the findings in a clear manner. Please note that the project does not require any specific tools or methods for analysis, but any experience with Pivot Tables, Statistical F...

I'm in need of a professional who can consistently extract data from a specific website on a daily basis. Key Requirements: - Data Extraction: Extracting various forms of data from a website. - Ongoing basis: This is not a one-time job. I'm looking for long-term cooperation, with the extraction ideally happening on a daily schedule. Ideal Skills and Experience: - Web Scraping: Proficiency in web scraping tools and techniques is a must. - Automation: Experience with automating the extraction process to make it efficient. - Consistency: Ability to maintain a daily extraction schedule accurately is crucial. Please include in your bid how you plan to approach this sort of ongoing data extraction.

fichier sur Excel reproduire le même identique sur Excel avec calcul automatique

Hello, I need complet the Amazon categories catalogue excel in french

I've compiled a comprehensive global leads database with 8 million entries. The database includes a variety of details such as name, email, contact number, website, profession, and even Instagram username. - **Purpose**: This database is specifically designed for sales leads generation. It's meant to help businesses and organizations reach out to potential customers and grow their sales. - **Categorization**: The leads are not just categorized by one specific filter. Instead, they're a mix of different categories from various industries, countries, and professions. This eclectic mix provides a wide range of opportunities for potential buyers. - **Delivery Method**: I'm looking to sell this database through a CSV file, online access to the database, and a Google Driv...

I have a small dataset of less than 1,000 rows that requires both data cleaning and formatting. Additionally, I need assistance with data analysis and visualization. This is a one-time project, and I am looking for a skilled individual to handle this for me. Ideal Skills and Experience for this project: - Proficiency in Excel is a must. - Experience with data cleaning and formatting. - Ability to perform data analysis and create visualizations. - Attention to detail and an eye for accuracy.

I have an Excel file with a macro that I need to be updated for compatibility with Excel for Mac 2019 or later. The current macro's compatibility with macOS is unknown to me, and I need an expert to assess and modify the code as needed. Key Requirements: - Update the existing macro for compatibility with Excel for Mac 2019 or later. - Ensure the modified macro functions correctly on a MacBook Pro 2018 intel OS Ventura. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge of macOS compatibility issues with Excel macros.

I'm in need of a proficient typist to convert the text from printed documents into digital form. The project primarily requires: - Entering text data: The task mainly involves converting the text from printed documents into digital format. The ideal candidate should have: - Excellent typing skills: As the core of the job is typing, a high level of accuracy and speed is required. - Attention to detail: It’s critical to ensure the data is entered correctly and without errors. - Experience in data entry: A background in similar projects or data management is preferred. Looking forward to your bids.

I have a batch of handwritten notes that I need to be converted into digital text. Key Requirements: - The project is primarily data entry. You will be given physical copies of these notes, and your task will be to accurately transcribe them. - Attention to detail is crucial, as the notes may be difficult to read and require care to ensure that the content is correctly interpreted and entered. - This is a time-sensitive project, so meeting the deadline is essential. Ideal Skills: - Proficient in typing and data entry, ideally with experience in transcribing handwritten notes. - Attention to detail is paramount. - Time management and ability to meet deadlines.

I need a skilled Excel professional to create a comprehensive spreadsheet for financial tracking. - Data Type: The primary focus will be on financial data, so the spreadsheet must expertly handle these calculations and entries. - Data Organization: The data should be organized by project. This includes clear separation of financial data under different project heads, ensuring a clean and easily navigable interface. - Functionality: I am looking for an Excel expert to incorporate some key features to help make the data easier to understand, like conditional formatting. Ideal Skills: - Proficient in Excel, particularly in managing financial data - Experience in creating user-friendly and logically structured spreadsheets - Understanding of conditional formatting and other data visualizatio...

I have less than 10 documents that need to be typed for online publication. The purpose of this typing task is for data entry. Ideal skills: - Proficient in typing, with strong accuracy and speed - Attention to detail to ensure no errors in the data entry - Familiar with online publication process - Good command of English The successful candidate needs to be able to transcribe the content in a timely manner so that it can be quickly published online.

I'm urgently seeking a skilled individual with experience in data entry. The main tasks include completing online form filling and helping me decipher an image. Key Responsibilities: - Online Form Filling: The job involves handling online form completions. The forms are fairly straightforward and shouldn't be overly complex. - Image Deciphering: You'll be required to assist me with interpreting an image. The complexity level is not specified, but it's anticipated to be moderate and should be manageable for an experienced professional. Key Requirements: - Proficiency in data entry, particularly in the domain of online form filling. - Strong attention to detail is crucial, as the correctness of the entries is paramount. - Experience with deciphering images could be an a...

I need a freelancer to help me convert a set of PDF files into editable files. The purpose of this project is to create these files so that they can be entered into a database for storage and management. Requirements: - Data entry skills: You should be proficient in data entry as the information from the PDFs will need to be accurately transferred into an editable format. - Attention to detail: Precision is key here. The data should be entered without errors. - Basic understanding of databases: While you won't be required to manage the database, a basic understanding of how they work will be beneficial for the project. The format of the final data is yet to be determined, so your input on this matter would be valuable. Feel free to suggest the most suitable format for this task.

I have a small project that requires the entry of structured text data. The project will involve: Ideal candidate would have a strong attention to detail, excellent organizational skills, and a background in data entry. Experience with structured data formats is a plus. This should be a fairly quick task, but accuracy is key. I will share you more details in via chat box. Thanks

I am looking for an expert in Excel to help me with a relatively straightforward task. I have data that needs to be reorganized in a new Excel sheet. Key Tasks: - Organize the data by date. - Add a summation formula to the sheet. This project is perfect for someone who is meticulous in data handling, proficient in Excel, and can ensure accuracy and attention to detail.

I'm looking for a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuously in real-time. Any updates made to the Excel file should be reflected in my phpMyAdmin database instantly. Skills and Experience: - Proficient in Excel and phpMyAdmin - Experience in data syncing and database management - Familiarity with real-time data syncing No specific data validation or transformation is needed during the import process. The goal is to ensure that any changes made in the Excel file are accurately reflected in the existing database.

I'm seeking a data entry specialist with a knack for precision to type data from PDFs into an online database. Key Requirements: - As a data entry specialist, you will be responsible for the accurate and timely entry of data from PDFs into our online database. - The data format should match the original PDFs, with no specific validation rules needed. - The ideal candidate will be detail-oriented, with a proven track record of data entry. If you're someone who enjoys working with data and has an eye for detail, this could be an ideal project for you.

I'm in need of a Virtual Admin Assistant to help me manage my daily work. Our dailly working time is : 10 - 7pm. We are in retail industry, dealing with bathroom & kitchen products. I need freelancers who are based in Malaysia and based in City if Kuala Lumpur and Town of Cheras Key Responsibilities: - Data Entry & Report Writing: You would be handling data entry tasks & writing report and (you only need to direct report to me so simple communication) - Task Management: Utilizing software such as Trello, or Microsoft Excel to keep track of tasks and deadlines. Ideal Skills and Experience: - Experience as a virtual assistant or in administrative roles is a huge plus. -Experience in wiritng report will be added advantage - Proficiency with task management t...

I need a freelancer to upload less than 50 clothing and accessory products to my Flipkart store. Requirements: - Experience with uploading products on Flipkart - Attention to detail for accurate product uploading - Good understanding of the clothing and accessories market - Ability to meet deadlines I will provide the product descriptions, photos and other necessary details. Your responsibility will be to ensure that these details are correctly inputted and the products are presented in an attractive and professional manner on the platform. I could do this work myself but I don't have time, so I want to do this work to a freelancer. It's a very small job and I can't pay more than 500 INR

i have a list of 11,000 car part numbers. need to find the image from each one, if you type the part number in google you'll find the image for that part.

I'm seeking a proficient data analyst with strong statistical analysis capabilities. Your main responsibilities will be: - Data Cleaning & Preparation: This includes cleansing the data from any incomplete records, duplicates or errors. - Statistical Analysis: You'll need to conduct a thorough statistical analysis of the data, utilizing regression analysis specifically. The project will involve various types of data including numerical, categorical, and textual data. Since we'll be working in a professional environment, knowledge and proficiency in MS Office is a must. This includes Excel, PowerPoint, and Word. Ideal candidates should be well-versed in data analysis and have a strong statistical background. Proficiency in using MS Office is also a key requirement....

Before you bid, please check our "Client profile" on Freelancer.com We are an established employer. Quick and correct work will earn you positive feedback and timely payment. ************************************************************************************************** Project description : I need a PowerPoint presentation modified into 350 copies Step 1: Open the PowerPoint file named "Adelya Expansion - Australia and New Zealand" Step 2: Open the Excel sheet named "Companies in whose name the file is to be saved " Step 3: Note that in the Excel sheet, the second name after Adelya is Tecmark Step 4: SAVE the Powerpoint file as "Tecmark Expansion - Australia and New Zealand" Step 5: Replace in Powerpoint (Keyboard command is Alt-E-E), the n...

I need a skilled professional to manually upload 1000 products from our online eBay store to our Magento 2 website. Requirements: - The products will include information such as title number, description, images, sku number, and prices. - You need to ensure that the listings are accurately and completely transferred from eBay to Magento 2. - There's no need to optimize images for web before uploading. Simply uploading as is will suffice. - Please use the existing product descriptions. Ideal Skills and Experience: - Proficiency in using Magento 2, including product management. - Experience in data entry and manual product uploads. - Attention to detail to ensure that all product information is accurately transferred. - Ability to follow instructions carefully and respect the existin...

I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.

I am in need of a virtual assistant to support me with various tasks. The ideal candidate should be tech-savvy and proficient in general virtual assisting responsibilities.

I'm looking for a professional email marketing agency that can manage an email campaign for me. Essential skills/experience required: - Proficiency with email service like mailchimp or similar - Previous experience in email marketing, particularly in promoting products - Ability to send follow-up email Key deliverables: - Sending out 350 emails using our email id - Creating and sending follow-up emails - Providing a detailed report on the campaign's performance Please note, I have a template for the emails already. I also have the database of the people to send out in excel format - company name, email, first name and last name - so it should be easy

I'm looking for a proficient professional who can effectively scrape leads from LinkedIn, Facebook, and Instagram and all over the internet Key responsibilities: * Extracting Email leads, Phone number leads, and Social media leads. * Collecting specific data - Name, Job title, Company, and Location, email and phone numbers Ideal freelancers for this project should have: * Extensive experience in data scraping, especially on the platforms mentioned above. * Proficiency in data mining techniques and possessing advanced analytical skills. * Understanding of ethical data scraping practices. * Strong attention to detail - ensuring all data is accurate and up-to-date. * Proven track record of delivering quality leads in a short timeframe. Get in touch if you're up for the task. I ...