Excel Jobs

I need a professional to clean my text data. The primary goal is to standardize the formatting of the data. - Your main task will be to format the text data in a consistent and uniform way, ensuring that all the text data is correctly and uniformly structured. - You should be proficient in text data cleaning with experience in standardizing the formatting of textual content. - The data is currently stored in plain text files, so experience working with this type of data storage is necessary.

I'm looking for an google sheets / excel guru who can construct an advanced drop-down lookup system for my entire sheet. This system should include multiple variables that will inform the price from the database. Currently looking up values manually in a series of tables, tables may need reformatting to allow for efficient searching Key skills and experience: - Proficient in MS Excel Advanced Functions - Experience with both numerical and text data - Knowledge of creating drop-down lookups for entire sheets The final product should streamline our decision-making process by providing agile, accurate prices based on the selected variables. Your comprehensive understanding and application of numerical and text data within an Excel environment will be key to the success of this projec...

I'm looking for an expert to develop a Bollinger Band Contraction Screener for Nifty 500 stocks. The screener should: - Analyze daily data from the last year. - Prioritize contraction/expansion patterns in Bollinger Band. Ideal candidate would be someone with relevant experience in financial market analysis tools, specifically in Bollinger Band analysis.

I need a dependable freelancer to help me perform a quick 30-minute task involving text data entry. The data to be entered is sourced from a particular website and should be neatly entered into a Word document. Key Responsibilities: - Scour through specified website for necessary text data. - Concisely input data into a Word document. Ideal Skills and Experience: - Attention to detail is paramount. - Fast typing speed. - Familiarity with data entry from websites. - Proficient in Word document formatting. Looking forward to reliable and timely applicants.

Please start your proposal by saying "hello MBA student" I am looking for a skilled data scraper who can efficiently extract specific data from a football website (). and one more for average age of squad. Extraction will need to go CSV Key Tasks: - Extracting 'Average Age of Squad' information - Extracting 'Net Spend' data Ideal Skills: - Proficiency in data scraping - Understanding of football statistics - Experience with similar projects or websites is a plus I trust your expertise to advise if additional information is needed for successful execution. Experience and accurate, meticulous work is what this project calls for.

I am seeking a talented professional to assist me with my accounting work using TALLY ERP 9. The tasks will include data entry, bank reconciliation, and financial statement preparation. Key Responsibilities: - Data entry for up to 50 transactions per month - Bank reconciliation - Financial statement preparation The ideal candidate will have prior experience with TALLY ERP 9 and data entry. Additionally, understanding of accounting principles and GST will be highly beneficial. Accuracy, efficiency, and a strong attention to detail are crucial for success in this role.

I require a VBA Developer well-versed in automating repetitive tasks in Microsoft Excel. Your primary task is to automate my existing work functions to increase efficiency. Key Responsibilities: * Understand the current Excel operations and identify scope for improvement. * Develop VBA codes to automate basic standard operations. * Test the robustness and accuracy of the automation. * Combining 2 files into 1 pdf. 1st file is pdf and 2nd is excel(with selected sheets, and selected columns within sheets) Desired Skills & Experience: * Proficient in VBA, specifically for Microsoft Excel. * Experience in automating repetitive tasks. * Sharp problem-solving and debugging skills.

I am seeking a talented professional to assist me with my accounting work using TALLY ERP 9. The tasks will include data entry, bank reconciliation, and financial statement preparation. Key Responsibilities: - Data entry for up to 50 transactions per month - Bank reconciliation - Financial statement preparation The ideal candidate will have prior experience with TALLY ERP 9 and data entry. Additionally, understanding of accounting principles and GST will be highly beneficial. Accuracy, efficiency, and a strong attention to detail are crucial for success in this role.

Seeking a proficient Excel VBA developer to aid in the centralization and automation of tasks in Excel 2010. Project requirements include: - Expertise in Excel latest version - Strong understanding of EXCEL VBA for automation purposes. Please note, specific tasks and functions to be automated in VBA have yet to be defined. Flexibility and broad knowledge in different Excel functions will be considered an asset.

I'm seeking a skilled financial modelling salesperson to help me find clients based out of US/UK/Europe who are looking for candidates who can create advanced financial models with the aim of improving their financial forecasting, investment analysis, and risk assessment. Your responsibilities will include: A) Finding clients who are looking to outsource their financial modelling work. B) coordinating and setting up meeting with prospect who are interested in the above work. Ideal candidates will possess a strong background in financial modelling, exceptional communication skills, and a proven track record in sales. Experience with company financial statements, market research data, and historical sales data is a huge plus.

I am looking for someone skilled in data sorting and collection, specifically within enterprise mailbox systems. The main responsibility will involve the collection of emails filtered according to specific criteria and their subsequent organization. Key tasks: - Collection of email data from enterprise mailbox - Sorting obtained emails using three criteria: date, sender and specific keywords in the subject Ideal Organization: - Emails should be organized exclusively by the sender for easy access. Ideal Skills: - Data collection and organization - Detailed understanding of enterprise mailbox structures - Competency in refining searches This task requires accuracy and an eye for detail, as the correct sorting and collection of these emails is critical for the smooth operation of our...

I need help to sanitize my online database to eliminate duplicate entries. My primary data source is an online database which has become cluttered with repetitive information. This hampers the overall efficiency and creates error in my outputs. I urgently require a skilled data entry expert with a strong competency in data cleaning, in particular, the elimination of duplicate entries. Your role will involve systematically reviewing the database, identifying duplicates and then removing or merging this data. Familiarity with online databases and previous experience in data cleaning is a necessity for this task.

I require precise and efficient data entry services for text-based data that will be entered into reports. The ideal candidate will have: - Proven experience in data entry work. - Familiarity with entering data into document formats. - Great attention to detail, ensuring accuracy of input data. - Ability to work with large volumes of text data. - Familiarity with report formats and terminologies. Please note that accurate and timely completion of this project is of high priority. Your previous experience in data entry for report creation would be greatly beneficial.

I require a professional to list FMCG products on an e-commerce website. The information to be included in each listing includes product descriptions, product images, pricing details, best before dates, and supplier information. Freelancers with previous experience handling FMCG product listings or familiarity with e-commerce platforms are highly preferred. Duties include: - Accurately inputting all required product information - Sourcing and uploading clear product images - Implementing detailed descriptions of each product - Integrating pricing specifics - Including best before dates and supplier details Accuracy and attention to detail are essential for this task.

I'm seeking a Power BI specialist who can create simple, yet effective, reports and dashboards using a few select data sources. The main aim is to analyse data, identify trends and generate insights that will be crucial in decision-making. You, as an expert, will: - Create simple Power BI reports and dashboards. - Utilise charts and graphs effectively within these report to present data in an impactful and easy-to-understand way. Your experience with Power BI, data analysis, report generation, and visualisation techniques will be pivotal to this project's success. Familiarity with chart and graphs based data representation will be a plus.

I am in immediate search of a medical billing specialist with an eye for detail. You will carry out specific tasks such as: -Patient Data Entry from Digital Form Registration [HTML] in medical records online platform. Furthermore, the project largely involves data entry tasks; inputting patient information and procedure codes. As such, you must be proficient with: - Medical billing software () - Electronic health record (EHR) system Familiarity with these software tools are considered a special asset. If you have the necessary skills and hands-on experience, please don't hesitate, bid now!

I need someone with specialized skills in password recovery to restore a forgotten password for an Microsoft Excel worksheet. This task requires a professional password hacker. I require one spreadsheet opened and password recovered and removed. Skills and Experience required: • Proficiency in programming languages, particularly those relevant to password recovery. • Expertise in methods of password recovery for Microsoft Excel worksheet xlsx files. • Strong ethics - the information on this spreadsheet must stay confidential. • Can deliver results within 7 days. • Will pay on successful confirmed completion only.

I require a proficient Excel expert with strong skills in data analysis and organization. The primary tasks you will handle include: - Analyzing business-related data - Organizing the analyzed data in an easy-to-understand format The purpose of these tasks is to help streamline business reporting processes. You must be adept at dissecting large volumes of data and summarizing key points to help inform business decisions. The final deliverable should be a standard Excel file that details the organized and analysed data. Relevant skills needed include data analysis, Excel proficiency, and a keen understanding of business data interpretation.

" DM fiscal policy is set to tighten markedly this year ” Check IMF and world bank websites, or other sites, to see if you could replicate the data below, using excel/ time-series to rebuild the chart from below

I need help with data entry into spreadsheets. Key Responsibilities: - Efficiently and accurately transfer data into spreadsheet format Ideal Skills: - Proficient in spreadsheet software - Experience with data entry The project involves basic data entry tasks. The data is mainly in digital format. Your primary responsibility will be to ensure all data is accurately entered into the spreadsheet.

I'm seeking a computer science tutor to guide me through QuickBooks and Excel. - Topics include QuickBooks, Excel, data structures, algorithms and programming languages. - Primarily need help with data entry and organization in QuickBooks and Excel. - Additionally, assistance with Formulas and Functions in Excel is required. Ideal candidate should have: - Proficiency in QuickBooks, Excel and knowledge of data structures and algorithms. - Strong background in programming languages. - Experience in tutoring or teaching will be a plus. Please note that the volume of entries or rows of data is minimal, less than 100. Looking forward to your proposals!

I'm in need of a freelancer who can turn a scanned PDF into a Word document for me, maintaining the layout and images. Additionally, I require the addition of a table of contents to the Word document. Ideal Skills: - Proficiency in typing and data entry - Experience or knowledge in OCR software - Understanding of Microsoft Word and its features for document formatting - A keen eye for detail and accuracy in text and layout conversion - Ability to create a table of contents in Word This project requires a high level of accuracy as the Word document should be an exact replica of the scanned PDF. The final Word document should be fully editable and of high quality.

I'm seeking an experienced PowerApps developer to assist in creating a system for daily information management. - Data Formatting: The information will consist mainly of text fields, numeric data, images or multimedia, and a predefined set of choices. - User Interface: The system should offer a user-friendly interface for data entry and management. - Data Storage: The daily information should be saved to a centralized excel or table, allowing all authorized users to access the data at any time. The ideal candidate for this project would have prior experience in PowerApps development, particularly in creating systems for data management and user input. Experience with integrating PowerApps with Excel or other databases would be highly valuable.

I have a document in PDF or Word format that needs to be entered into a provided template. Key Points: - The task involves entering text data from provided digital documents into a specific template. - The data is purely text, no numbers or special characters are involved. - Attention to detail is crucial to ensure accurate data entry. Ideal Skills: - Proficiency in English, as the content is in English. - Strong data entry skills, with a good typing speed and a high level of accuracy. - Experience with textual data entry and following templates is a plus. Please bid if you are confident in your data entry skills and can commit to delivering the project accurately and promptly.

Urgently seeking a proficient Microsoft Excel user to help input a mix of numeric and text data into a CSV file. Your skills and experience should encompass: - Mastery of Microsoft Excel - Wide-ranging background in data input - Solid understanding of CSV files - Ability to work quickly and accurately The project is immediate and time-sensitive. Appreciate your prompt attention and swift action. Looking forward to your bids.

I'm in need of a professional who can create a straightforward database with a user-friendly GUI for Windows. Key Requirements: - The database should be able to store and retrieve data efficiently. - It should feature a GUI for easy interaction. Ideal Skills and Experience: - Proficiency in Windows database development. - Prior experience in designing user-friendly GUIs. - Strong knowledge of data storage and retrieval techniques. Please let me know about your relevant experience and a rough estimate of the time and cost required for this project. Thank you.

A reliable database migration specialist (with previous email campaign setup skills) with their own computer and internet to work from home. You will be working with the Microsoft SQL server, experience is preferred but not essential to be an expert. Anyone with generic database experience (with different databases) can also apply. Skills already acquired from previously doing this work: - Understand database schema - understand database structures - create database tables based on bespoke requirements (training included) - Working with relatively large sets of data - has exporting skills into SQL - Excel and VBA, - Has experience in different querying languages - Proficient in Microsoft SQL Server Management Studio - Familiarity with Windows OS - Experience in handling multiple dat...

I am seeking a proficient data collector who will assist me in acquiring vital information necessary for our sales and marketing campaigns. You'll be tasked with compiling a reliable list of emails and phone numbers for technology directors in K-12 school districts that I will specify. The ideal freelancer for this project: - Has a solid background in data-mining - Understands US K-12 Education System - Is meticulous and accurate The required data should include: - Technology Director's name - Their emails - Their contact numbers Accuracy and timeliness are critical for this project. Please only commit if you are confident you can deliver with great efficiency. This is a great opportunity for you to display your ability to garner high-value contacts and contribute to the...

I'm seeking an expert in Excel and VBA who can work on an an existing financial model. The primary tasks will involve optimizing formulas, macros, and implementing data validation. I am looking for an hourly regular working engagement where the person will sit with me from time to time online and solve for things one at a time. I cant share workbooks as I have some IP related restrictions so person will have to work on my system, remotely. For Faridabad, Haryana based freelancers, we can do it in physical mode too. Key areas of focus will be: - Refining Formulas and Calculations. - Improving Data Organization and Management - Managing , improving the existing VBAs

I am in need of an excellently crafted web form that can carry out addition calculations. The main purpose of this form is to accurately calculate the cost of chosen services. My business involves a multitude of services, and I need an within-the-business platform that allows for easy calculation based on user preference. Here are some specifics: - Carousel selection of services: your form should allow selection of various services provided by my business. - Calculation logic: Addition is the primary calculation required. The system should be able to add up the costs of selected services. - Data entry: Your form would need to support product selection-based data entries. - User interface: the form should be easy to navigate, with clear instructions for inputting service choices. Ideal C...

I am seeking researchers in Melbourne, Australia to conduct market research for a retail audit. The ideal candidate should have good communication skills. You will have to own an android mobile device to be eligible for this project. You will visit 5 supermarkets in the city of Melbourne, Australia and the payment for this project is €170. Woolworths - South Morang Woolworths - Croydon Coles - Ringwood Coles - Ivanhoe Coles - Dandenong Plaza Project in a Nutshell Products do not need to be bought, its an instore audit. Shelf photos required. Product photos Production codes Specific requirements for the project include: - Conducting a retail audits in Melbourne, Australia - Collecting data on android device using our company app Skills and experience needed for this project:...

I'm seeking a proficient Excel expert who can assist me with enhancing my current study time tracker. I need the following features to be incorporated: - Auto-calculation of total study hours: I'd like for this to be automatically summed up based on the inputs provided. - Auto-calculation of average study hours per day: This should also be done automatically, providing me with a clear view of my daily commitment. - Study hours per subject: I require a part of the spreadsheet to allocate study hours to specific topics that I am learning. The spreadsheet will be utilized for tracking my study progress across different subjects. It should allow for easy input of study hours and materials covered. I will provide the current version of the spreadsheet to the chosen freelancer, an...

I have an Excel spreadsheet containing a list of data, from which I need specific email addresses extracted and organized. Key requirements: - Extract email addresses: You'll need to go through the spreadsheet and locate email addresses contained within the data. - Excel Organization: The extracted email addresses should be neatly and accurately organized in the Excel spreadsheet. Each email should be placed in a separate cell. Ideal Skills: - Proficient in Excel: Ability to efficiently navigate and manipulate data in Excel. - Data mining and extraction: Skilled in identifying and extracting specific data from larger datasets. - Attention to detail: Accurate organization of email addresses is crucial. - Time management: Ability to work efficiently and meet deadlines. Please let me ...

I have a requirement to develop a bespoke Microsoft Excel spreadsheet to calculate sales commissions. Let me share the specifics: - The variables: I want this spreadsheet to take into account the Sales Volume, the Profit, and the Commission Percentage while computing sales commissions. - Calculation specifics: Commission should be determined according to a custom formula that considers the Commission Percentage. - Data input: The spreadsheet should be easy to use, allowing me to manually input the data for calculation. The ideal freelancer for this project would be someone well-acquainted with the mechanics of Microsoft Excel and its formulas. Relevant experience in the field of sales calculations would be an asset. I am trusting that this tool will enhance efficient determination of c...

I have a substantial Excel spreadsheet that requires competent attention. I'm on the lookout for someone who's proficient in: - Data entry - Data cleaning Your role will primarily involve entering various types of data that's currently on an Excel spreadsheet. Despite the data being available, it's in a raw unclean format that needs some cleaning. The ideal freelancer is someone who's used to working with Excel and recognizing inconsistencies, errors, and redundancies. Additionally, anyone versed in: - Proficient in Excel usage - Strong attention to detail - Experience in data cleaning - Strong data entry skills would be extremely helpful in achieving the goals of this project.

I need a proficient Excel specialist to develop a spreadsheet that will calculate gross pay based on clock in and clock out times. Some work-shifts will start on one calendar day and not clock out until the next calendar day (example- clock in May 1 at 3:30pm - clock out May 2 at 12:30am). It should also factor in specific overtime rules for the workplace, including: - Weekly overtime after 40 hours. -All hours on any given workday shall be paid at the straight time rate of pay unless forty (40) hours have already been worked at straight time. No matter the length of route: example- a driver's bid/scheduled route may be 10.8 hours, as long as the employee does not work any additional hours other than those bid/scheduled, they will be compensated at straight time rate of pay unless for...

I'm looking for a personal assistant to help with various online tasks, primarily data entry, research, and email management. Key Responsibilities: - Data Entry: This involves copying and pasting data, as well as cleaning and organizing it. Furthermore, I need assistance with data analysis and reporting. The ideal candidate should be comfortable with working in spreadsheets, and have a good eye for detail. - Research: The research tasks will include market research, competitor analysis, and product research. You should be able to gather and synthesize data from various sources to help me make informed decisions. A background in a related field is a plus. Skills: - Proficient in using spreadsheets - Strong attention to detail - Excellent research skills - Ability to work independ...

I'm in need of a meticulous professional to clean a mixed set of data contained in an Excel file. I am specifically struggling with duplicate values and missing entries. To effectively accomplish this: - You should possess excellent skills in data analysis and data management. - Previous experience with Excel-based data cleaning is preferable. - Profound knowledge of dealing with duplicate entries and filling in missing data is required. - A keen eye for detail and ability to spot and correct errors is essential. In summary, my ideal candidate would be someone with significant experience in data cleaning, particularly with mixed data in Excel files. It would be a bonus if you've previously resolved issues related to duplication and missing entries in datasets.

I have a set of handwritten notes with relevant numeric data that I need entering into an online database. The task involves transcribing the numerical information with a high degree of accuracy. Key Requirements: - Enter numeric data from handwritten notes into an online database - Ensure high accuracy in data entry - Abide by project deadlines - Maintain confidentiality of data Skills Required: - Proficiency in data entry - Attention to detail - Experience with online databases - Fast and efficient work ethic - Ability to maintain data confidentiality

I am in need of a detail-oriented individual to help with a data entry project. This involves manually entering alphabets into an Excel spreadsheet to create a comprehensive database. For this task, you should have: - Excellent attention to detail, as the entered alphabets should be strictly in lowercase. - Proficiency in Excel, as the data will be used to compile an Excel spreadsheet database. - Ability to work diligently on a potentially repetitive task. Your primary responsibility will be to manually input the alphabets into the spreadsheet with absolute accuracy. As it's vital that each data entry is correct, having strong attention to detail is paramount for this job. Experience in data entry and Excel is a must.

I have an Excel file that is corrupted and won't open. The latest version has over 5000 columns which I need retrieved. I have a previous version of the Excel file with over 4500 columns. The Excel file was last saved on a USB and I am using Excel 2016. I do have a backup copy of the corrupted file. Key Tasks: - Recover the latest version of the Excel file with over 5000 columns. - Integrate the data from the previous version (4500 columns) into the latest version. - Ensure all data is intact and functional. Skills and Experience: - Expertise in data recovery and Excel. - Proficiency in Excel 2016. - Attention to detail and thoroughness to ensure that all 5000+ columns of data are successfully retrieved and integrated. Please bid with a specific plan on how you will tackle this iss...

I'm urgently seeking someone with expertise in Microsoft Word and PowerPoint. As the core tasks involve: - Formatting documents: Revamping and structuring multiple existing ones with professional formatting. - Creating templates: Building clean, easy-to-navigate custom Word and PowerPoint templates for future use. - Designing presentations: Enhancing PowerPoint presentations with engaging design. Ideal professionals would be quick responders, experienced in advanced functionalities of Microsoft Office, and possess creative design skills to make presentations visually engaging. As the project needs to be completed ASAP, please apply only if you can commit to a fast-paced timeline.

I'm in need of someone to assist with creating daily/weekly journal entries in our Zoho Books accounting software. Key Responsibilities: - Record a Journal for each business day that summarizs the payment transactions of the day (cash, credit card, bank transfer etc) Ideal Candidate: - Proficient in Zoho Books software. - Strong understanding of basic accounting principles. - Experience with creating journal entries. - Reliable and able to deliver entries on a weekly basis.

I'm looking for a skilled individual who can create a pivot dashboard for my business. This dashboard needs to be updated daily and needs to include comprehensive sales data, material costs, labour costs, and profit and loss. Ideal Skills: - Data management - Ability to create and maintain pivot dashboards - An in-depth understanding of business financials. The main users of this dashboard will be the Management Team. Therefore, it needs to be designed in a user-friendly manner and should meet the needs of a strategic managerial perspective. The ultimate goal is to help us make more informed and data-driven decisions. Your expertise in data handling and visualization is much needed for this project. If you've created similar dashboards in the past, we would love to hear ab...

I need a knowledgeable Excel VBA specialist, with a background in data manipulation and analysis, to create a custom macro for my spreadsheet. - The macro's primary function is to automate the creation of new rows based on certain numeric values, namely the ones found in columns E to L on a specific sheet in the workbook. - Upon row creation, data from columns A to D should be copied over to the corresponding new row on another sheet. - Additionally, the macro should automate the assignment of values in cells from L to Q based on the count of numbers in rows created. The assignment of values is to be done using a simple addition or subtraction formula. The ideal freelancer should have solid experience in creating advanced Excel VBA macros, and a strong understanding of Excel func...

I'm looking for an experienced MS Access developer to assist with my form development tasks. The ideal candidate is proficient in VBA (Visual Basic for Applications) coding and has the ability to design and implement forms based on my specifications. Key Responsibilities: - Designing and developing database structures based on my project requirements - Implementing VBA code for basic functionalities such as form submissions and data entry automation - Creating forms in MS Access based on a specific design I have in mind - Ensuring the database and forms meet quality standards and are user-friendly Ideal Skills and Experience: - Proven experience in database design and development using MS Access - Proficiency in VBA coding, particularly for basic functionalities - Previous experienc...

I'm in need of an Excel expert who can help me compile a detailed file for the merger of PVR and INOX. The document should contain two main sections: - Financial Data: - I require you to list the revenue, expenses, and profit/loss figures. These should be clearly presented in a way that allows easy comparison. - Merger Details: - You will also need to include specific merger details. This includes the merger date, the terms of the merger, and the name of the merged company. The ideal candidate for this project is an experienced Excel user, with a proven track record in data analysis and a keen eye for detail. You should be comfortable working with financial data and able to present complex information in a clear and insightful manner. Experience in mergers and acquisiti...

I'm in need of someone to send invoices to my clients via email. The invoices must contain the following details: - Client name and contact information. - An itemized list of products/services. - Payment terms and due dates. I don't have any specific format or template in mind, so you'll have the creative freedom to design the invoice layout as you wish. Ideal candidates for this job should be detail-oriented, have good communication skills, and be reliable in sending the invoices on time. Previous experience with invoicing or basic accounting would be a valuable asset.

**PLEASE SEE AND READ THE ATTACHED PDF WEB DEMO ACCOUNT A report is required with the following information: Report where it marks the maximum fuel level value (load) in this case it is 20,000 liters The report must have the condition to take the load point if it was kept at a high level for more than 10 minutes, it has not moved and the value did not change, let's say 5000,10000,15000,20000lts, it will mark it as load, when it is stopped for 10 minutes and begins to detect discharge movement of more than 2000 liters, it will take the last largest value as the discharge. • The report must be generated in the same place where they are currently generated (image 1). The PDF, HTML and XLS format is required, such as those for Fuel fillings and Fuel thefts. • What we want t...

I am interested in creating an Excel VBA macro that will allow me to import PDF invoices into line items and parse them. The objective of this project is to streamline the process of invoice data entry by automating the extraction of key information from incoming PDF invoices, namely Invoice number, Vendor name, Pricelist, and Detail. The successful freelancer for this project should have: - Demonstrated experience in creating VBA macros for Excel - A strong understanding of PDF parsing and data importation - Knowledge of accounting principles is a plus The imported data should ideally be formatted in Excel as: - Each PDF invoice should be translated into a single row - The extracted information should be available in separate columns for each piece of information.