Excel Jobs

I need an Excel 365 PowerQuery script that can fetch daily market data and handle potential data source interruptions or changes. I will be providing a URL that contains the market data, and you'll need to replicate the Google Sheets function =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). This function provides real-time data from the specified URL. Please note that the data is structured using HTML tags. Key requirements: - The PowerQuery should be able to be refreshed with the google sheet. - It needs to include robust error handling. If the data source is unavailable or the structure changes, the PowerQuery should not break but continue to function, ideally providing a notification that an error occurred. Ideal sk...

As your client, I'm looking for an Excel VBA expert who can make my daily processes more efficient by creating an automated reporting solution for me. Key Tasks: - Design and implementation of a VBA macro in Excel to automate the generation of cost summary reports. - The automated reports should be populated by data from four different worksheets, namely Worksheet 1, Worksheet 2, Worksheet 3, and Worksheet 4. Ideal Skills and Experience: - Excel VBA Programming - Experience with automated reporting - Understanding of data manipulation in Excel. -Possible migration of Cost Summary data to Word contract. In your proposal, please share samples of previous automated reporting projects done with Excel VBA. Commitment to delivering high quality and defect-free output is imperative. Lo...

I'm seeking an expert to merge and de-dupe around 700 account / contact records to enable us to obtain a clear deduped prospecting list to be uploaded into a CRM like HubSpot. The records will need to be deduped using a specific criteria to ensure that all unique information is kept for each account. The list is currently in Excel/CSV file format. Each contact record encapsulates around 10 key fields: Customer type and association, Store Name, Contact Name, Email, Phone, Mobile, Email, Address, Job Title and notes. Ideal Skills and Experience: - Proficiency in Excel and other spreadsheet tools - Experience with data cleansing and deduplication - Attention to detail and accuracy - Experience with handling sensitive data securely Tasks Involved: - Merging duplicate contacts (based on...

Create a form in google Sheets following the pre-determined options. The results of the answers must be recorded in a second tab

I am looking for a freelancer with expertise in PowerBi and Excel. The task will revolve around creating a one-time report/dashboard on PowerBi sourced from a single Excel spreadsheet. The ideal candidate should have: - Previous experience with PowerBi and Excel - Proven track record of data analysis - Attention to detail Please note that the Excel file won't be changing over time, so there is no requirement for the PowerBi report/dashboard to be updated. Content Description: I have statistics from every UFC fight and want basic visualizations made (I have a rubric)

I need a proficient typist who can assist in the copy typing of documents from scanned PDFs. No specialized knowledge is required, but the ability to work efficiently and with great attention to detail is crucial. Responsibilities: - Accurately copying content from scanned PDF files. - Use basic text formatting in the typed document. The ideal candidate should have: - Experience in copy typing. - Familiarity with basic text formatting. - Proficiency in English language. - Keen attention to detail. Your contribution to this project by providing error-free, neatly formatted documents will be highly appreciated. Please ensure to submit your completed work on time.

I need a power BI expert with deep knowledge of DAX query to help me retrieve specific metrics about product inventory. Key Requirements: -Retrieve product ID, Quantity and Location -Gather specific production data including the production number. Ideal skills: -Proficient in DAX query language -Comprehensive experience with Power Bi -Excellent attention to detail -Previous experience in inventory data management will be a plus. What to do: I need to get a query in DAX (Power Bi) that gives me the same result as what I show in the excel file ( table ( column in yellow)). The excel file was obtained from the attached SQL query () The two screenshots show the power bi tables. I need to get a new column in power bi that shows me the results like in the yellow column in Excel.

The primary aim of this project is environmental conservation. I require assistance in defining precise marine boundaries around submerged reefs using Shape files (SHP). This boundary creation align to guidelines of international environmental conservation bodies including UN, Pacific Regional Environment Programme or Convention on Biological Diversity in terms of marine boundaries. The boundaries are already present on raster paper charts for navigation but we need digital boundaries made with accurate coordinates. Ideal freelancers should have: Primary: - Proficient skills in working with Shape files (SHP) - Apps such as QGIS or ARCGIS. Secondary (optional): - Understanding of the maritime environment and submerged reefs - Experience or familiarity with international environmental ...

I need assistance with data entry. I have printed documents containing text data that I need to be accurately transcribed into a spreadsheet. Key Requirements: - The data is text-based and will require accurate transcription. - The data will be provided in printed documents. - The output format required is a spreadsheet. Ideal Freelancer: - Proficient in data entry with high attention to detail. - Experienced in working with printed documents. - Skilled in using spreadsheet software. Your role will be crucial in ensuring the accurate and efficient transfer of the information from these printed documents to a digital spreadsheet. The ability to maintain precision in transcription is key.

Seeking assistance to streamline my medical billing tasks, specifically in insurance claims processing and payment posting. With an in-depth understanding of Excel spreadsheets and electronic medical billing software, your expertise will be used to enhance efficiency. The complexity of the project is increased as working with more than 10 healthcare providers. Key Attributes: - Proficient in insurance claims processing - Experienced in payment posting - Competence in the use of Excel spreadsheets and electronic medical billing software - Background in working with numerous healthcare providers While the task will be challenging, your contribution will be pivotal in improving our system. Looking forward to your applications.

For my growing customer base of 10-50 clients, I need a competent Excel specialist to design a complex, customer-friendly workbook. - The workbook will need to track and organize three main types of data: Contact Information, Order History, and Communication Log, for each customer separately. - I'm currently unsure whether calculations or formulas will be necessary for any automated tasks within the workbook. This is something that can be explored as the project progresses. The perfect freelancer for this job would have solid experience in Excel, especially in creating complex workbooks. They'd also be able to advise on the use of calculations and formulas. Attention to detail is paramount, as is a commitment to creating a user-friendly layout.

I'm in need of an experienced data entry specialist who can accurately transfer information from images into a PDF document. Key Requirements: - Data Entry: The main task involves typing documents from images. - Document Formatting: The deliverable should be a PDF file. Your Skills: - Proficiency in data entry. - Strong attention to detail and accuracy. - Experience with converting files to PDFs. Looking forward to working together.

I'm seeking an Excel expert to create a user-friendly data entry workbook. The job is straightforward and requires the following: - **Data Entry:** The workbook should mostly focus on simple data, like names and dates. I am not looking for any intricate calculations, formulas, or pivot tables. The main focus is on creating an Excel workbook that streamlines the process of entering simple data in a structured and efficient way. Experience in creating user-friendly UX within Excel is a plus. No integration with external systems or services is needed - this is a standalone project. I look forward to collaborating with an experienced professional who can deliver an effective, easy-to-use data entry solution within Excel.

I have a project that involves meticulously retyping a Torah text. This is a comprehensive project that includes approximately 1900 pages of text, with specific footnotes that need to be included. Ideal Skills and Experience: - Excellent attention to detail and accuracy - Proficient in typing and formatting text - Familiarity with religious texts and terms is a plus, though not mandatory The project is urgent and needs to be completed as soon as possible.

I am in need of expert help to scrape text data from specified websites. After the data has been collected, the next step is to clean the data, ensuring that it is in the appropriate format for use. The final output should be managed and stored in a Database Management System. The ideal freelancer for this project should have: - Proven experience in web scraping, specifically text data from websites - Advanced skills in data cleaning to ensure the data is usable and well-structured - Capabilities to manage and store the cleaned data into a Database Management System Please provide any relevant examples of previous work in web scraping and data cleaning and provide details about how you plan to carry out this project.

I require a freelancer who is savvy with setting up social media and Gmail accounts. Create 50 Google email (gmail) accounts with the names in a provided excel spreadsheet. I have not attached it here, I will provide it when the project starts, as I don’t want to make them public to others then the person that will create the accounts. It is real accounts for real people that do not use gmail today, and that do not have a social presence. In the spreadsheet there is also information about the backup email to be used for PW resetting etc. Create 50 Facebook and Instagram accounts matching the google accounts. Ad profile pictures. Ad 20 to 30 random pictures to each account. Follow 30 to 50 people for each account. Make the profiles otherwise private. Make half of the accounts fol...

I'm looking for a seasoned Excel expert to create a set of macros that can automate my data extraction process. Here's what I need: - Automate data extraction: The primary purpose of these macros is to enable automated data extraction from local files. The data in question is stock market data. The ideal candidate for this project would have: - Proficiency in Excel: You should have a strong grasp of Excel, particularly in designing and implementing macros. - Experience in data extraction: You should have a track record of successfully automating data extraction processes. Looking forward to hearing from you.

I am looking for an expert in Excel to design a dynamic spreadsheet for project tracking. This spreadsheet will focus on monitoring task progress and deadlines. Key Features: - Daily updates: I will be updating task progress and deadlines daily, and so I need the spreadsheet to be user-friendly and efficient. - Task highlighting: If a task is falling behind schedule, I need it to automatically become highlighted in red. This will help me prioritize tasks and ensure no deadlines are missed. - This will need to show throughput for every phase and also provide an average through in volume. Skills and Experience: - Proficient in Excel - Experience in creating dynamic spreadsheets - Understanding of project management principles. I look forward to working with a detail-oriented, reliable ...

As the client, I require the services of a skilled copy typist who can accurately duplicate a PDF document. The original document contains tables, so a certain level of precision and attention to detail will be necessary. Your tasks: - Copy typing a PDF document - Transcribing tables as text - Ensuring 100% accuracy The ideal freelancer for this job has previous experience with copy typing and transcription, and is familiar with working with PDF documents and tables. A strong understanding of English and high attention to detail is imperative.

I'm in need of a proficient typer to execute a medium volume job, of between 100 and 500 pages. Here are the details: - You have to retype handwritten notes into a Microsoft Word document format. Accuracy and attention to detail are paramount, as the formatting needs to adhere strictly to the layout of Microsoft Word. - Although the task does not come with a tight deadline, efficiency in completing the job would be highly appreciated. - Experience in a similar role would be an advantage, as the typer needs to have stellar knowledge in document formatting and editing in Microsoft Word. This project does not require rush execution, therefore making it a perfect opportunity for those balancing multiple projects or those new to freelancing aiming to prove their abilities.

I am seeking a professional who has experience in setting up Fresh Sales and integrating it seamlessly with Insightly. My specific requirements include building a customized sales pipeline, managing contacts and leads effectively, and generating comprehensive reports. Key Tasks: - Customized Sales Pipeline: I need the freelancer to design a sales pipeline that aligns with our unique business practices and sales processes. The pipeline should be intuitive and easy to navigate. - Contact and Lead Management: The professional should ensure seamless migration of data from Insightly to Fresh Sales. They must create an organized system for managing contacts and leads, including appropriate tagging and categorization. - Report Generation: I require the freelancer to set up automated report gene...

I need a skilled professional familiar with MS Office for a word processing task, specifically focusing on personal letters. Key responsibilities include: - Processing the content for personal letters. - Ensuring correct grammar, punctuations, and overall coherence. - Working within the style and tone provided for these letters. Ideal applicant would have: - Excellent word processing skills. - A meticulous eye for detail. - Prior experience in drafting and editing personal letters. This project requires the precision and personal touch of an experienced Office specialist who understands the intricacies of personal correspondence.

I'm looking for an experienced inventory associate to help me manage my retail inventory. The system needs to focus on stock level tracking and product categorization, as we have less than 100 products in our inventory. Key Responsibilities: - Develop an efficient inventory management system - Ensure real-time and accurate stock level tracking - Organize products effectively through categorization Ideal Skills: - Proficiency in inventory management software - Strong understanding of stock control methods - Experience in product categorization - Attention to detail and accuracy is crucial, considering the relatively small number of products The project is crucial to our business operations, so I'm looking for someone who can deliver a system that's reliable and user-friend...

We're looking for multiple competent native English editors to help us improve English language usage in a big batch of Excel-related tutorials. Starting with a paid trial. Please bid $20.

Need to extract data from website: , into an Excel file. Specifically name, discipline (medical practitioner, midwife, nurse, OT, physio, psychologist, podiatrist), location (incl suburb and postcode), initial registration date, registration expiry. There would be at least 100,000 rows of data. Only barrier, is this data is not able to be 'searched' efficiently. Individual names can be looked up. Or disciplines with a select number of names demonstrated...but I can't find a way to show ALL clinicians at once. Looking for a solution which can reliably pull all the names from the database.

I'm looking for a reliable and experienced data entry specialist who can assist me with entering data from images. The images will be directly uploaded to a website, and I need the data to be transcribed into various formats like Excel sheets, Word documents, and for copywriting purposes. Ideal Skills and Experience: - Prior experience with data entry from images - Proficiency in Excel and Word - Copywriting experience is a plus The primary goal of the project is to create a comprehensive database in various formats, so the ability to accurately transcribe and organize data is crucial. The chosen freelancer should have keen attention to detail and a high level of accuracy.

I need an expert to set up an automation system in Google Sheets for specific data from the NSE India website. Key Requirements: - Data Source: The data source will be '' - Data to be Integrated: Only the column titled '%CHNG IN OI' should be extracted. - Update Frequency: The automation should update the Google Sheets column once every day. - Data Display Format: The data in the Google Sheets should be displayed in percentage values. - Historical Data: No historical data tracking is required. The focus is solely on current updates from the source website. Ideal Skills: - Proficiency in Google Sheets and automation tools. - Experience with web scraping and data extraction. - Knowledge of data presentation and formatting in Google Sheets. - Ability to create a seamles...

I'm seeking a proficient Telecaller to focus on generating leads for two key segments within my Event Management company: Corporate Events and Conferences. KEY RESPONSIBILITIES: - Establish productive communication with potential clients. - Convert conversations into promising leads. - Record conversational details into our database. REQUIRED SKILLS AND EXPERIENCE: - Exceptional persuasive communication skills. - Proven experience in lead generation. - Familiarity with the corporate events and conferences sector. - A resilient attitude to handle potential rejections and keep going. This role demands someone ready to excel in a fast-paced environment while showcasing dedication, autonomy and agility. Your ultimate aim will be to assist in the company's expansion through the su...

I require a freelancer to extract and consolidate numeric data from existing databases. The data should be transformed and presented in a workable database file format. Key responsibilities include: - Extracting data from various data sources - Ensuring data integrity and quality - Transforming the data into a database file format Ideal Skills and Experience: - Proficiency in database management and data extraction - Strong understanding of data transformation - Attention to detail and precision - Ability to ensure data quality and integrity - Prior experience working with numeric data is a plus.

I have a task for those skilled in data entry, particularly with respect to copy-pasting job. The work is to be done in Google Sheets, so excellent proficiency in Google Sheets is vital. The volume of data is less than 100 rows and columns total. Therefore, I'm also expecting a high level of accuracy and attention to detail. If you've been involved in similar projects previously, that'll be an added advantage, but it's not a must. Key Skills/Experience: - Excellent copy-pasting abilities - Proficiency in Google Sheets - High attention to detail - Previous experience in similar projects is a plus

I am looking for an experienced Power BI expert to create a project dashboard for me. This dashboard will be the central hub for monitoring the progress and success of our projects. Key Requirements: - Connect the dashboard to Microsoft Power BI. - Visualize data related to our projects, including but not limited to sales, finance, and marketing. - Include all key metrics and KPIs, such as revenue, customer acquisition cost, and conversion rate. The ideal candidate should have: - Proven experience in developing Power BI dashboards. - A solid understanding of project management principles. - Excellent data visualization and analytic skills. - A proactive attitude and great communication skills. This is a critical tool for our project management team, and we are looking for someone who c...

In search of a competent Excel specialist adept in Microsoft Access for multiple automation tasks. I need assistance with: - Macros Development: The main tasks include automation and creating tools. The proficient use of macros in daily operations is essential. - Report Generation: Specifically, the generation of technical proposal reports. Alongside this, the candidate should also be capable of automating the formula calculation process. Familiarity with financial, sales, and project status reports is an added advantage. - Tool Building: The capacity to build tools and other operations geared towards improving efficiency is crucial. Ideal skills include deep understanding of Excel functionalities, proficiency in Microsoft Access, extensive experience in automation via macros, and strong...

I am seeking an experienced virtual assistant to manage data entry tasks, focusing specifically on filling out online forms. Your role will be vital in collecting and organizing data from various survey polls. Requirements: - Strong attention to detail in order to ensure accuracy of data - Proven experience in managing online forms - Ability to work quickly and efficiently, providing data in a timely manner - Experience with survey polls is a bonus Responsibilities: - Input and organize data from survey polls via online forms - Check and correct data entries for accuracy - Recognize, correct, and report any issues concerning the data and the online forms No specific industry knowledge is needed, just keen attention to detail and a reliable work ethic. Though not a requirement, previous...

I am in need of an expert who can continuously build and manage MIS excel sheets pertaining to data analysis, sales forecasting, and expense tracking on a daily basis. Key tasks: - Establishing excel sheets to analyze a broad range of data - Constructing a sales forecasting model within the excel sheets - Regular tracking and management of expenses via the excel sheets Data sources would primarily be spreadsheets and databases. These excel sheets will require daily updates, enabling close monitoring of key metrics. Ideal skills: - Proficient in Microsoft Excel - Exemplary skills in data analysis and modeling - Good understanding of databases and how to extract data from them Experience in handling and managing sales and expense data is crucial for this project. The freelancer sho...

I'm in need of an expert equipped with Doc Clipper proficiency. I've got a collection of PDF files that require clipping. The skillset I'm seeking involves: - Extensive experience with Doc Clipper, specifically with clipping documents effectively. - Proven ability to handle PDF files in Doc Clipper. - Attention to detail to ensure no vital information is left out. Your task will solely focus on clipping PDF files. Apply if you can fulfil these needs with speed and efficiency.

I need an expert to migrate my products from an Excel file to my WooCommerce store. Key Requirements: - Migrate products from an Excel file to WooCommerce - Use attributes to define variations within a single product - Update existing product descriptions during the migration Ideal Skills and Experience: - Strong experience with WooCommerce and product migration - Proficiency in handling product variations using attributes - Attention to detail for updating and modifying product descriptions - Excellent knowledge of data import/export and product management on WooCommerce. - Ability to ensure a smooth and error-free migration process.

As an eCommerce business owner, I'm in need of a diligent freelancer who can take on the critical roles of Email Handling and Data Processing within our Shopify platform. - **Email Response Management**: This entails handling all incoming emails from customers. The goal is to ensure timely and accurate responses, maintaining high quality customer service standards. - **Data Entry and Organization**: You would be responsible for entering and organizing data within our Shopify platform. This would include product information, customer details, and other pertinent data. - **Customer Query Resolution**: Addressing customer queries in a professional, friendly and efficient manner is crucial. You would need to have good problem-solving skills. **Daily Volume**: The expected volume of em...

I need 1000 list from USA which will have email phone number address etc and it should be in excel file category bar.

As an eCommerce business owner, I'm in need of a diligent freelancer who can take on the critical roles of Email Handling and Data Processing within our Shopify platform. - **Email Response Management**: This entails handling all incoming emails from customers. The goal is to ensure timely and accurate responses, maintaining high quality customer service standards. - **Data Entry and Organization**: You would be responsible for entering and organizing data within our Shopify platform. This would include product information, customer details, and other pertinent data. - **Customer Query Resolution**: Addressing customer queries in a professional, friendly and efficient manner is crucial. You would need to have good problem-solving skills. **Daily Volume**: The expected volume of em...

I need a proficient data specialist to compile a comprehensive database of Romanian companies. - Compatibility: The database must be compatible with Windows and Mac platforms. - Specific Details: Every company's record in the database must contain the company's name, phone number, and email address. - Extent of Database: Aim for a sizable database that contains information about 100,000 companies. Ideal candidates will have experience in data mining and database management, and an understanding of Romanian market dynamics. Strong accuracy and attention to high-quality data is a must.

I have a significant amount of text that needs to be typed into Excel quickly. The data is in a simple text format, no complex formatting required. Key requirements: - Proficient in Excel and typing - Attention to detail - Ability to work under tight deadlines The data is straightforward text and requires no specific formatting or analysis. The ideal freelancer will be skilled in data entry and be able to commit to a quick turnaround time.

I am seeking an Excel expert who can meticulously enter extensive amounts of text, numeric, and alphanumeric data into my spreadsheet. The task involves entering names, contact details, sales information, and inventory data. The size of the task is quite substantial, with up to 1,048,576 rows and 16,384 columns involved. The role requires a keen eye for detail, accuracy, and dedication. If you are efficient in Excel and possess experience with handling large data sets, your skills will be highly valuable for this project.

I need a reliable freelancer to assist with data input. Here's a breakdown of the project: - **Task:** Your primary job will be to input data from online forms into either Microsoft Excel or Google Sheets. - **Experience Required:** It is necessary for you to have prior experience with both of these tools. This will ensure you're able to work efficiently and accurately. - **Attention to Detail:** Given the nature of the task, it's crucial that you have excellent attention to detail. Even the smallest mistake can have significant implications. If you have the experience and skills mentioned above, I would love to hear from you.

I am in need of a proficient data entry specialist to help translate text data from PDF digital files to a more accessible format. This project requires a meticulous individual with keen attention to detail, who is capable of handling and processing large amounts of text data accurately and efficiently. The responsibilities for this job include: - Transferring text data from PDF files - Ensuring data is entered accurately, without errors - Organizing high volumes of digital documents Ideal skills and experience for the job: - Proven experience in data entry, particularly with PDF text - Exceptional attention to detail - Proficient in common data software - Excellent organization skills - Ability to handle multiple tasks simultaneously.

I require a skilled data entry professional to type data from various online sources into a structured format. This information will be used for subsequent data analysis. Key responsibilities: - Accurately type data from online sources Ideal Skills: - Proficient in typing - Attention to detail - Ability to maintain data integrity This position would be ideal for someone with a keen eye for detail and strong typing skills.

I am experiencing a problematic error with my Excel sheet. An error message keeps popping up and the sheet becomes protected every time I enter a price. Ideally, instead of locking the entire sheet, only specific columns should be locked when a password is triggered by clicking a button. Key issues: - Error message arising upon entering a price - Automatic sheet protection following action Work Required: - Identify and fix the error triggering the message pop-up - Adjust VBA codes to lock specific columns upon password entry: - Columns A to L - Columns Y, Z to AK - Columns CW to DH - Columns DO to DS - Columns DT, DV, DX, DZ, EB, ED For this task, I need a freelancer proficient in VBA and Excel, specifically with experience with sheet protection issues. A thorough understand...

I am searching for a detail-oriented data entry operator to help with a monthly task of making small text changes to a series of PDF data booklets. The ideal candidate should have: - Previous experience with data entry - Proficiency in PDF editing tools - Strong attention to detail.

Firstly, I want to know if what I am asking can actually be created in Excel 365 and used in Excel 365 Online. Please dont reply to this post without replying that it can or can't be done. If not, an alternative solution would be greatly appreciated. I need help creating an excel spreadsheet to track student progress in a course using 5 different options that also includes the date the option was selected. I can create the drop down list with the submission options, and apply color rules but I can not work out how to make the cell below change to the same color as the option selected and the date it was selected appear in the same cell. I need to include the date the option was selected selected and because you can't have two formulas in conditional formatting. I thought mak...

More details: What type of data do you need to type into the Excel sheet? Text What is the source of the data that will be typed into the Excel sheet? PDF documents Will the data need any kind of formatting or should it be entered as is in the source document? Enter as is

I need a comprehensive and efficient transportation per student cost model developed as soon as possible. Key Components: -Finding out per student cost -Finding out per bus cost Data Points: - I will provide you with the information that can help calculate the key components stated above. Ideal Skills and Experience: - Proficiency in cost analysis and financial modeling - Experience in transportation logistics and efficiency - Ability to work quickly and accurately, delivering within a tight timeline.