Excel jobs

Data Compilation on Excel I am looking for a freelancer who can compile a large data set of customer data on Excel. The ideal candidate should have the following skills and experience: - Proficiency in Excel and data entry - Strong attention to detail and organizational skills - Ability to organize data by customer type - Experience working with large data sets (more than 500 entries) The project involves compiling customer data on Excel, organizing it by customer type. The data set is expected to be more than 500 entries. The freelancer will need to accurately enter the data and ensure it is correctly organized.

I am looking for a skilled freelancer to help me with coding a large Excel sheet. The specific functions and calculations are simple (averages, rank, sum) however there are numerous steps and involves a large data set. I have a specific layout in mind. However, given the large data set, it may be better to run the calculations in Python or the like. Data Complexity: - The data that will be inputted into the Excel sheet is of moderate complexity, including dates and formulas.

Excercises on finance and excel

...have more than 10,000 data's of potential clients who have approached us in the past for taking our consulting service. presently, we are maintaining the data on excel sheets. We want to move it to CRM. c) We want to save data in CRM software category wise. Example if suppose 1000 potential clients approached us for our service and out of the same, 200 were looking for Accounting service, 200 were looking for ITR filing, 200 were looking for GST filing service, 200 were looking for Funding service and balance 200 for some other service, in such case, we should be able to save data in such a manner that we can export a list in excel sheet for 5 different types of clients who has approached us for 5 different services. d) Also, the CRM data can be categorised as Cold ...

Excel Expert needed for advanced data analysis task with a A DAY. 1 have one worksheet with 320 rows and 14 columns. I just need this sorted in a particular order using sum ifs and any other excel fomulas. So its easy to present to a meeting. Skills and Experience: - Advanced proficiency in Excel - Strong knowledge and experience in data analysis - Ability to create complex formulas and perform advanced calculations - Familiarity with data visualization techniques - Attention to detail and accuracy in data analysis - Ability to work within tight deadlines

I am looking for a freelancer to webscrape data and build a user interface for a Decision Support System. Key Requirements: - Webscraping data fro...programming language - use Natural language processing to clean the text - Displaying the scraped data in the user interface - take user inputs to validate the cleaned textual information - present the summarized data Ideal Skills and Experience: - Proficiency in webscraping techniques and tools - Strong knowledge of Python for developing user interfaces - Familiarity with data formats such as Excel/CSV, MySQL/Other Databases, and JSON/XML - Experience in designing and implementing user-friendly interfaces If you have the skills and experience required for this project, please submit your proposal with relevant examples of your prev...

Copying data from excel to sage

...freelancer who can help me convert a large Excel file (more than 5MB) into an Access database. Presently the file is used as an invoicing system to generate invoices and save information. This is it's primary function. There is additional recording with each invoice showing manufacturing details. Requirements: - The data should be updated in both Excel and Access after conversion. - I need the Access database to have reporting and analysis features. -The file has a few macros which are used to generate PDF invoices and save them to a folder. -I want to ensure I can see the information and use filters in the same way as I can in excel - so we don't need a special form to display the data. Ideal skills and experience: - Strong knowledge and experience ...

Scenario : I have a requirement to produce a spreadsheet which will have sheets for SUBSCRIBERS CURRENTLY ON THE NEWSLETTER, NEW ORDERS DETAILS, UNSUBSCRIBERS UNSUBSCRIBERS needs to be removed from the NEW ORDERS DETAI...needs to be removed from the NEW ORDERS DETAILS sheet and produce a new sheet created ADD TO LIST SUBSCRIBERS CURRENTLY ON THE THE NEWSLETTER need to be removed from the ADD TO LIST sheet to leave unique users who have not previously unsubscribed. I will be using this spreadsheet weekly so it needs to be easy for me to update with NEW ORDERS DETAILS and then process. This will be achievable with Excel and macro's/VB I believe. I can supply sample data to suitably qualified freelancers to produce a demo. Any suggestions to make this easier will be certainl...

I am looking for a skilled developer to create a Report Generator App which exposed as a Web app (or runs as CLI). The app will be responsible for generating reports which relies on Excel sheets as data source, and PowerPoint template and ultimately generates a PPT or PDF. An preferably packed as a docker image. Skills and experience required for this job include: - Proficiency in web development languages such as HTML, CSS, and JavaScript, Java or .NET, Web Services. - Experience in building web applications and working with excels and PPT - Familiarity with report generation frameworks to read and write to Excels/PowerPoint embedded tables and charts. - Experience with dockers and docket images. - Attention to detail and the ability to create visually appealing and user-friendly ...

We have some sort of Excel-based shadow-bookkeeping that was once created storing data of revenues and money that has been withdrawn from the partners. The Excel exists and will be shared and it works OK but we need this to be transferred into a much more flexible system (some sort of MIS) that will allow us to analyze much more in detail, e.g. how much revenues have been created by the respective partners, how much have been withdrawn, how much have been allocated to the company based on the amount the respective partners have created revenues etc.

...organization Scope of Work: - The scraper should be able to scrape all job posts from Glassdoor, without any specific filters for job categories or keywords. - The web scraping should occur on a daily basis, ensuring that the latest job posts are captured. Deliverables: - A script or software that can scrape job posts from Glassdoor on a daily basis and save the data in a structured format (e.g., CSV or Excel). Ideal Skills and Experience: - Strong knowledge and expertise in web scraping techniques and tools - Proficiency in programming languages such as Python, Java, or Ruby - Experience working with APIs and handling large data sets - Familiarity with job board websites and their structures - Attention to detail and ability to handle complex data extraction tasks If you hav...

I am looking for a freelancer who can assist me with data entry from digital documents into an Excel spreadsheet. The project involves a medium-sized volume of data, with between 100 and 500 entries. Skills and experience required: - Proficiency in data entry and accuracy in transferring information from digital documents to Excel spreadsheet - Familiarity with Excel functions and formulas for efficient data entry and organization - Attention to detail to ensure accurate and error-free data entry - Good time management skills to complete the project within the specified timeframe

I am looking for someone to convert a historical PDF file into an Excel file. The PDF file is in a scanned image format and contains 3 pages. I would like the data from the PDF to be organized into separate columns in the Excel/CSV file. I need that the work should be done in python and I need the code for transparency, in case of error. Skills and Experience: - Experience in converting scanned image PDF files into Excel files - Experience in OCR - Proficiency in data organization and formatting in Excel - Proficiency in Python - Attention to detail to ensure accurate data extraction and column separation

I am looking for a Python programmer who can help me with data analysis. Specifically, I have specific methods in mind that I would like to be applied to a small data set in CSV or Excel format. Skills and Experience: - Strong knowledge and experience in Python programming - Proficiency in data analysis techniques and methods - Familiarity with working with small data sets in CSV or Excel format

I am looking for a freelancer who can help me consolidate both numbers and text data into one line in a specific format. The data structure is simple and straightforward. Skills and experience required: - Expertise in Microsoft Excel - Proficiency in data consolidation techniques - Attention to detail - Ability to work with both numbers and text data - Familiarity with creating and formatting data in a specific format Need within the next hour

...contest for The MAG Dental Academy! We're looking for a creative and talented designer to create a logo that represents our dental academy's brand identity. About The MAG Dental Academy: The MAG Dental Academy is a premier institution dedicated to providing top-notch dental education and training. Our mission is to empower aspiring dental professionals with the knowledge and skills they need to excel in their careers. Design Guidelines: We are looking for a logo that embodies the following elements: Professionalism: The logo should convey a sense of professionalism and expertise. Dental Theme: Incorporate dental-related elements such as teeth, toothbrushes, dental instruments, or related imagery. Modern and Timeless: The design should be modern yet timeless, making ...

Web Development Project: Advanced Level I am looking for a skilled web developer who can help me with an advanced level web development project. Specific Functionalities: - The website should have specific functionalities in mind, which I will provide in detail upon hiring. Ideal Skills and Experience: - Strong experience in web development, particularly in advanced level projects. - Proficiency in programming languages such as HTML, CSS, JavaScript, and PHP. - Experience in working with databases and integrating them into websites. - Knowledge of responsive design principles and mobile optimization. - Ability to create dynamic and interactive web pages. - Experience in using frameworks such as React, Angular, or Vue.js. - Familiarity with version control systems such as Git. If yo...

I am looking for an experienced freelancer to create an Excel form for me. The purpose of the form is for calculation and analysis. Key Requirements: - Intermediate level of complexity for the calculation and analysis tasks - Ability to create a rough idea format for the Excel form Ideal Skills and Experience: - Proficiency in Excel and advanced knowledge of formulas and functions - Experience in creating custom Excel forms for calculation and analysis purposes - Strong attention to detail and ability to accurately organize and present data If you have the necessary skills and experience, please submit your proposal along with examples of similar projects you have completed.

Tutor Needed for High School Math Students - More than Twice a Week We are seeking a highly qualified and experienced tutor to join our tuition center, specifically to teach high school math. Subjects: - The primary focus will be on math, covering topics such as algebra, geometry, calculus, and statistics. Grade ...concepts and engage with students. - Proven ability to adapt teaching methods to cater to students' individual learning styles. - Previous experience in tutoring high school students, preferably in a group setting. - Patience, dedication, and a genuine passion for helping students succeed. If you are an experienced math tutor who is passionate about teaching and helping high school students excel in math, we would love to hear from you. Please provide your...

I am looking for a freelancer who can apply basic arithmetic and statistical formulas to 4-7 Excel formats. I have specific formulas in mind that I would like to be implemented. I am open to suggestions for any additional formulas that could improve the functionality of the formats. Skills and Experience: - Proficiency in Excel and knowledge of basic arithmetic and statistical formulas - Ability to understand and implement specific formulas provided by the client - Strong problem-solving skills to suggest additional formulas for data manipulation and conditional formatting - Attention to detail to accurately apply formulas to multiple Excel formats

Project Title: Microsoft Office Assistance Specific Tasks: - Excel: The client needs help with tasks in Microsoft Excel. Data Analysis and Organization: - The client requires assistance with data analysis, as well as data entry and organization. Proficiency Level: - The client's proficiency level in Microsoft Office was not specified. Ideal Skills and Experience: - Proficiency in Microsoft Excel is a must. - Experience in data analysis and organization is desired. - Familiarity with other Microsoft Office programs such as Word and PowerPoint is a plus.

I am looking for an Excel expert who can help me with creating formulas and functions. Specific tasks include: - Creating complex formulas and functions to automate calculations - Developing custom functions for advanced data analysis I have a specific Excel file that I need assistance with. The deadline for this project is within a week. Ideal Skills and Experience: - Proficiency in Excel and advanced knowledge of formulas and functions - Experience in data analysis and manipulation - Strong attention to detail and accuracy in data entry If you are an Excel expert with the required skills and can work within the given deadline, please bid on this project.

Hi I wanted to copy some words and sentences sequentially and then paste them sequentially, I entered Word and copied the name Muhammad Abdullah Majid Then I entered Excel and copied Yasser Salem Muhammad Then I went to another place and started copying and copying Issa Muhammad Jamal I wanted to paste them consecutively, as follows: Muhammad Abdullah Majid Yasser Salem Mohammed Issa Muhammad Jamal It is possible to copy the first name in one place and the second in another place, and so on, meaning the pasting process is sequential. thanks

Process Management Excel Dashboard - I am looking for an Excel expert to create a process management dashboard that will track specific metrics such as sales, inventory, and customer satisfaction. - The dashboard should provide data visualization through charts and graphs, with the option to include tables if necessary. - As an Excel expert, you should have experience in creating visually appealing and easy-to-understand dashboards that effectively communicate key metrics. - The dashboard should be updated on a regular basis, but the frequency of updates is yet to be determined. - This project requires a strong attention to detail, as accuracy in data representation is crucial for making informed business decisions. - The ideal freelancer should have a strong understa...

I am looking for a freelancer to assist with monthly data entry tasks for my bookkeeping needs. The ideal candidate should have experience in entering sales and expenses into Excel. Tasks to be performed include: - Entering sales and expenses data into Excel - Updating inventory records - Organizing receipts The anticipated workload is 50-100 entries per month. Accuracy and attention to detail are essential for this role. Preferred software for bookkeeping is Excel. Experience with QuickBooks or other software is also a plus.

I need an Excel application for manual expense input and automatic financial result generation. The app should provide overall company results and results for each workplace. Keyboard input for expenses and income, with automatic generation of other reports. I can share the current app we're using and a sketch of what I want. Expenses are per workplace, with common expenses distributed based on the number of employees at each location. Design is crucial, aiming for a corporate style.

I am looking for a freelancer coder who can help build a code to compare two files, one structured and the other unstructured. The structured file is in Excel format, while the unstructured file is in Audio format. Specifically, I need to compare the name and value between the two files. Ideal Skills and Experience: - Proficiency in Excel and image file analysis - Strong attention to detail to accurately compare the name and value - Experience in data comparison and analysis - proficiency in python scripts If you have the necessary skills and experience, please submit your proposal.

Excel programming, solving simultaneous functions

I am looking for a Power BI expert to help me with my project. Here are the details: Data Sources: - I have Excel spreadsheets that contain the relevant data for analysis. Analysis: - I need descriptive analysis to be performed on the data. Visual Presentation: - I would like the results to be presented using charts. Ideal Skills and Experience: - Proficiency in Power BI and data analysis. - Experience with Excel spreadsheets and data visualization. - Strong understanding of descriptive analysis techniques. - Ability to create visually appealing charts for presenting the analysis results. If you have the required skills and experience, please reach out to me with your portfolio and a brief description of your relevant experience.

I am looking for a freelancer who can help me with a web scraping project focused on job posts from LinkedIn. The ideal candidate for this job should have experience...scraping project focused on job posts from LinkedIn. The ideal candidate for this job should have experience with web scraping and data extraction. Requirements: - Scrape job posts from LinkedIn - Extract the job description from each post - Format the scraped data into an Excel spreadsheet Skills and Experience: - Proficiency in web scraping tools and techniques - Familiarity with LinkedIn's website structure - Strong attention to detail to ensure accurate data extraction - Experience with data formatting and manipulation in Excel If you have the necessary skills and experience, please submit your prop...

I am looking for a freelancer to scrape 18k URLs and extract specific data, which in this case is contact information. The data should be formatted in Excel format. Data points - Phone - Whatsapp - Email Skills and Experience: - Proficiency in web scraping techniques - Experience in extracting contact information from websites - Strong attention to detail to ensure accurate data extraction - Familiarity with Excel to format the extracted data into the required format

Hello talented designers! I am in need of a skilled graphic designer to assist in converting an ...not adhering to the guidelines or timeline will be rejected. Your Role: Convert the provided AI image into an Adobe Illustrator template suitable for factory printing. Creatively interpret and incorporate the FIXI Guys and RTS logos into the design. Provide multiple design options with 3D renderings. Adhere to the specified timeline and guidelines. This is a great opportunity for designers who excel in product packaging and have a keen eye for detail. If you are ready to take on this challenge, please submit your proposal along with your portfolio showcasing similar work. MAKE SURE TO Incorporate a the BARCODE (One for each product) Looking forward to your creative and timely su...

STAGE 1 - DESK RESEARCH to identify up to 20 European E-Commerce brands of sportswear, leisure wear, baby wear as per the customised criteria that we will agree upon together. ...leisure wear, baby wear as per the customised criteria that we will agree upon together. DELIVERABLE: a list of up to 20 prospective customer e-commerce brands in Europe matching your set criteria including their contact details, short profile, key buyers (if they are available in the public domain), sources and other information of interest, preferably via a shared google sheet, otherwise via an Excel file. DELIVERY TIME: 30th December to remain on the safe side considering the Christmas Holidays The final cost has been converted from Euro 520 to USD 565 as per today's currency exchange calculate...

I am looking for a skilled editor to assist with editing and reformatting of word and excel files. In the main: 1: I require a business logo to be changed. 2: References from 1 company name to another company name changed. 3: In some cases the date of the document to be changed. 4: In some cases a title of a position to be changed. Specific Requirements: - Ensuring that the document is properly formatted and visually appealing Ideal Skills and Experience: - Experience in editing word documents - Strong attention to detail and ability to spot and correct errors in grammar, spelling, and punctuation - Proficiency in document formatting and design Please note that in most cases the document consists of 1-5 pages. The attached file is typical of the types of documents th...

Hi. I am writing a grant application for a SA State Government Tourism Development Grant of $450,000 to assist in the building of two luxury accommodation units. A first draft of the grant application has been developed (copy attached). It now needs to edited, formatted and improved. The inclusion of some graphics etc is required. Other files such as excel financial statements, letters of support etc will need to be incorporated into one file for lodgement. I require a draft to be completed by Saturday 10 December with final lodgement due on 15 December.

I am looking for a freelancer who can create an Excel dashboard for me. The dashboard should have the following features and functionalities: - Excel Functions, including VLOOKUP, HLOOKUP, and INDEX - The primary purpose of the dashboard is to model and simulate business scenarios - The dashboard should include more than 5 worksheets or tabs Ideal skills and experience for this project would include proficiency in Excel functions, experience with creating complex Excel dashboards, and knowledge of modeling and simulation techniques.

I am looking for a freelancer who can scrape author email addresses from 20 computational chemistry journals. The desired output format for the scraped email addresses is Excel. The scraped data will require partial cleaning and formatting. This project has an urgent deadline of less than a week. Ideal skills and experience for this job include: - Proficiency in web scraping and data extraction techniques - Experience working with computational chemistry journals - Strong attention to detail for data cleaning and formatting - Ability to deliver high-quality work within tight deadlines

Create an excel worksheet which has 4 tabs (one per website). Each tab is to have 4 columns to be filled in with data from the website it correlates to. All tabs will share the same columns. Columns (data) required: Firm Name, Phone Number, Email address and URL. Data to be collected from the following sites (tabs): - - - - 973 total entries. Require this to be done post-haste.

... Testimonials (receive reviews in the form of text, image, or video, to be able to edit, approve, disapprove etc) E. Advertising Banner in Header of Website F. Advertisement Section for Sponsor (User will be able to change the text from the Admin Panel) G. New Advertisement section for sponsors (User will be able to change the Photo and text from the Admin Panel) H. User will be able to export excel sheet of Number of classes a teacher taught in the given date range (Start - End) I. Copy all selected emails to a clipboard for bulk email purposes. 4. I will provide these details A. Hosting Login and password B. Content, Images, and Video 5. What I need from you? A. Quotation (alongwith scheduled payment plan) B. Time schedule (module wise) C. Any question? Please ask. 6. What c...

...are not lit, and the thermometer is at $0. Whenever someone makes a donation, we will manually input the data in an Excel file that has a cell showing Total Amount Raised and a cell showing Total of Candles Lit (see attached Excel file sample). Example scenario - someone donates $100 then we will input $100 in the Excel file. The Excel file will show a Total Amount Raised at $100 and will show the Total of Candles Lit at 1. Then the webpage will show an animation that 1 of the candles will light up and then have an animation showing the thermometer will start to move from $0 to $100. And if another person donates say $1500 then we will input $1500 in the Excel file. The Excel file will now show a Total Amount Raised at $1600 and will show the T...

I am looking for a freelancer who can assist me with an edit of the Excel Simple Loan Calculator and Amoritzation template. The edit will be that the payment amount needs to be able to be whatever I enter, a varied amount and still calculate the correct principle/interest and balance etc... All other items are fine I just need to be able to change the amount received for payment. Ideal Skills and Experience: - Strong understanding of loan amortization principles - Proficiency in spreadsheet software (e.g. Excel) - Ability to accurately calculate and present loan amortization schedules - Attention to detail to ensure accurate data entry and calculations.

I have reduced the cost for this project for the fees are in an excel spreadsheet,. You can alignn them and then copy and past onto the project template

I am looking for a freelancer who can convert a small (less than 5MB) scanned PDF file into an Excel file. The Excel file does not need to maintain the same formatting as the PDF. Skills and Experience: - Previous experience in converting scanned documents to Excel - Proficiency in data entry and extraction - Attention to detail to ensure accurate conversion _ The need to provide written Instruction on How to Convert a similar File on my Own I have attached a sample file...

...assist me with converting some PDF file into an Excel spreadsheet. The total pages of the PDF files are approximately 250 pages in size. The data in the PDF file may or may not be organized in a structured manner, so I need the freelancer to check and ensure that the data is properly organized before converting it into Excel. Furthermore, I require the data to be formatted in a specific way in Excel. I have a specific format that I would like the freelancer to follow. I have attached a sample pdf file. I need the date wise conversion rates (for export) from this type notices in a single spreadsheet. So need the date, currency name and conversion rate (for export) in a single excel sheet. Ideal Skills and Experience: - Expertise in PDF to Excel da...

I am seeking a skilled Python developer with experience in healthcare revenue cycle management (RCM) to create scripts for converting HL7 837 files to Excel. The ideal candidate should have knowledge of the healthcare industry and be familiar with the 837 file format. Requirements: - Experience with Python programming - Familiarity with HL7 837 file format - Ability to extract specific columns or data elements from the 837 file - Knowledge of Excel file formats and the ability to create either a single worksheet or multiple worksheets based on client requirements

I am looking for a freelancer who can create an excel catalog using a provided PDF file for ecommerce use. The purpose of the catalog is to showcase products. Requirements: - Experience in creating excel catalogs for ecommerce - Proficiency in working with PDF files and converting them into excel format - Ability to organize and present product information in a visually appealing manner - Attention to detail to ensure accurate and complete product listings Specifics: - I will provide the format or template for the excel catalog - The catalog will include more than 100 products If you have experience in creating excel catalogs and are skilled in working with PDF files, please submit your proposal.

I am looking for a freelancer who can provide me with a CSV/Excel file containing 500 emails of contacts at Compass Real Estate in the Northeast region of the United States. Requirements: - The file should have 3 columns: company name, contact email, and company website. - Any role within the company is acceptable, so there are no specific job title requirements. - The preferred format for the file is a standard CSV. Skills and Experience: - Proficiency in data entry and data scraping. - Familiarity with Compass Real Estate and their website () is preferred. - Attention to detail to ensure accurate and complete information is included in the file. Please provide a sample of your previous work or demonstrate your ability to complete this project successfully.

I am looking for a freelancer to assist with a data entry project involving a combination of numeric and text data. Applicant will have to browse the web to get the data and copy paste. The data entry must be done according to a specific format that I will provide. The project requires entering more than 500 rows of data. ~60 hours Skills and experience needed: - Proficiency in Microsoft Excel - Skill to browse internet and copy paste - Accurate and efficient data entry skills - Attention to detail to ensure data is entered correctly and in the right format

File recovery and macro to fix file open & close issues