Search data several excel files jobs

I need an Excel tool that can sort data by category and provide users with an interactive experience. I'm looking for an experienced Excel developer who can create a user-friendly, yet advanced, Excel tool. The tool should have the following features: - **Filtering**: The tool should allow users to filter data by category. This is a crucial aspect of the tool's functionality, as the data will be organized by this field. - **Interactive Buttons**: I would like the tool to have buttons that allow users to sort data. When a button is clicked, the data should rearrange itself based on the selected category. For example, when a user clicks on the button related to 'Category A', all data entries related to ...

From 2.5 lakh records, need to find the duplicate data and make different sheets with unique data. Example: In a sheet of alphabets, that have multiple A’s, B’s, C’s. Now I need separate them and make a sheet with all A’s, separate sheet with all B’s, another sheet with all C’s.

...a few tasks and then disappear. No place holders, please! I need someone who is serious and can do the work, if you are not an expert dont waste my time please! MAX BUDGET $5 an hour, we can work direct if that is better for you after, a team would be great this way i can make sure i always can get someone to work. If you bid more than this, I know you didn't read this. The current sites have several issues going on which is due to breaks with theme/plugins and php versions. Note this is an hourly job for fixes as needed, not full time, about 10-20 hours per week depending on the amount of work that needs to be worked on. Must use a visual time tracker which i use is Apployee which takes screenshots so i can see work being done. All actual billing can be done through here....

I'm looking for a professional who can help with Excel work, primarily focusing on formula creation and formatting tables. Key Requirements: - I need assistance in creating formulas that can automate calculations and processes in Excel. - I'm looking for a clean and simple format for my tables, in line with a minimalist style. Ideal Freelancer: - Proficient in Excel, with a deep understanding of formula creation. - Experienced in table formatting and design, with a flair for minimalism. - Able to deliver high-quality, error-free work in a timely manner.

...detailed financial reports and dashboards, primarily based on data from Excel spreadsheets. Key Responsibilities: - Develop compelling, visually appealing reports and dashboards that are easy to interpret and navigate. - Tailor the reports and dashboards specifically to financial analysis, ensuring they provide the insights necessary for informed decision-making. Ideal Candidate: - Proven experience creating financial analysis reports and dashboards in Power BI. - Proficiency in integrating data from Excel spreadsheets. - Strong attention to detail and the ability to translate complex financial information into clear, concise visual elements. This project requires a high level of expertise in Power BI, financial analysis, and data visualization. ...

I'm in search of a talented illustrator skilled in pencil art who can bring my Pokémon team to life in a unique, realistic style. Key requirements: - Expertise in figure drawing is a must, as the project will involve detailed illustration of fantasy characters. - Familiarity with Pokémon character design would be a significant plus. - You will be working with traditional pencil and paper, delivering the final physical product. - An eye for realism in your drawing style is essential. Ultimately, I want to see my Pokémon team arise from the canvas in an impactful and detailed manner that blends the fun of fantasy with a touch of realism. If you're a skilled draftsman with a passion for bringing imaginary creatures to life, I'd love to see your po...

I'm looking for a skilled developer to create a search engine that emulates the functionality of Google

I'm in search of a versatile freelancer with skills in Word, Excel, programming, and graphic design. Your expertise in these areas will help me in different domains. Your main tasks will include: - Formatting documents in Word, ensuring a professional and consistent layout. - Creating Excel spreadsheets and conducting data analysis. Proficiency in Excel will be crucial to help me interpret and visualize data effectively. - Developing software or web applications. I am working with Java/Spring/JavaFX and am open to creative development ideas and solutions. - Designing logos and visuals. Your ability to create engaging and unique visuals will be a big asset to my projects. I am currently using Word 2010 and will be working with Java/Spring/Ja...

I need a skilled Wordpress developer to help me with minor cosmetic changes on several websites. Your tasks will include: - Implementing minor cosmetic changes to the theme. This may include color alterations, font changes, or minor layout adjustments. - Ensuring that the changes are consistent across all sites. I need someone with a keen eye for design, as well as excellent knowledge of Wordpress themes and customization. Experience working on multiple sites is highly desirable.

I have a list of 50000 urls, I would like to scape the pages to see if they contain references to scripts - I will provide a list of the urls and the scripts. Deliverable should be an excel with the 50000 urls and whether they contain the link for each script. Looking for fast turnaround

Title: Automated Data Retrieval from Websites Using CRM and CID Numbers Description: We are looking for an experienced developer to automate the process of retrieving data from specific websites using CRM and CID numbers. The goal is to develop a script or tool that will: Look up Doctor's Specialization: Use CRM numbers to search on the website: CFM Doctors Search Extract doctor's information including their specialization. Look up Disease Descriptions: Use CID numbers to search on the website: MedicinaNet CID10 Search Extract the disease description. Deliverables: ( ) A script or tool that can take a list of CRM and CID numbers as input. Automate the search process on the specified websites. Extract

...Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 300 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical knowledge of VBAs, Macro, MS Office skills to drive automation o...

Hello, I need convert a PDF invoice to Excel to import to our invoices software

I'm looking for an experienced Power BI developer to create bespoke reports and dashboards, which will be integrated into Microsoft Teams. Tasks: - Handling data from Excel spreadsheets and converting it into insightful reports and dashboards. Skills and Experience: - Strong command of Power BI for report and dashboard creation. - Proven experience with Excel spreadsheets. - Good knowledge of integrating Power BI into Microsoft Teams. The goal is to make complex data easy to understand, facilitating better decision-making within our team. Your work will directly impact our day-to-day operations and strategies.

...a specialized WordPress developer with experience in Excel operations and data showcasing. Key tasks: - Create a WordPress page that extracts numeric and text data from an Excel sheet. - Implement highlights and color-coded information on the webpage for better readability and understanding. - The data on the Excel sheet will be updated on a monthly basis, hence the website should be able to fetch the data automatically upon any modifications. Ideal skills: - Proficiency in WordPress and Excel integration - Experience in creating visually appealing data showcases or infographics - Strong understanding of data extraction and display technologies The aim is to have a user-friendly webpage that accurately repres...

I'm in search of an Excel expert who can assist me with complex tasks in Excel. Specifically, help is needed in two key areas: - Formulas & Functions: While basic arithmetic operations are simple for me, I need assistance with text and date functions. - VBA Macros: I'm looking for someone who can develop advanced user forms and interfaces. This requires a high level of VBA expertise. The ideal candidate would have a strong background in Excel, with a focus on formulas, functions, and VBA. Previous experience working on advanced macros and a deep understanding of text and date functions will be a huge plus. The ability to communicate effectively and understand my specific needs is essential.

I'm in search of a versatile freelancer with skills in Word, Excel, programming, and graphic design. Your expertise in these areas will help me in different domains. Your main tasks will include: - Formatting documents in Word, ensuring a professional and consistent layout. - Creating Excel spreadsheets and conducting data analysis. Proficiency in Excel will be crucial to help me interpret and visualize data effectively. - Developing software or web applications. I am working with Java/Spring/JavaFX and am open to creative development ideas and solutions. - Designing logos and visuals. Your ability to create engaging and unique visuals will be a big asset to my projects. I am currently using Word 2010 and will be working with Java/Spring/Ja...

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

I'm looking for someone who can design a sophisticated budget template for me in Excel. This template should: - Track both income and expenses - Project weekly outcomes - Compare actual amounts to budgeted amounts - Include more than 20 budget categories - Incorporate graphs and charts for visual representation. Skills necessary for this project will include advanced Excel knowledge and experience with financial modeling. The ideal candidate will have previously worked with complex budget templates and be comfortable creating a user-friendly interface. You should know how to devise a system that simplifies input and keeps data organized and easy to understand. Your ability to turn raw numbers into straightforward graphs and charts will be particularly valuable...

I'm after an expert in SEO, particularly white hat and local SEO, to help optimise my clients online visibility, especially towards local SEO The goal is to improve my clients local search ranking, increase organic traffic, and enhance visibility of my clients websites. The tasks include: - GMB Optimization - Improving local search ranking - Enhancing website visibility The ideal freelancer for this job should have extensive experience and proven successes in these areas. Please include examples of past work in your bid, showing how you have improved local search ranking, increased organic traffic, and enhanced website visibility for previous clients. This project is specifically targeted at reaching local customers, so a solid understanding and experience of ...

I need a professional to convert the information in the attached document into an organized, well-formatted Excel sheet. The project will require you to: - Copy all the text content of the document into corresponding cells in the Excel sheet. - Transcribe all tables and charts in the document accurately into the Excel. - Maintain the original formatting of the data in the document. The Excel document should: - Include all columns and rows from the original document. - Not require any additional formulas or functions.

I am in need of a comprehensive Excel sheet that does calculation. Data entry is not too complex; it includes dates, dropdowns and formulas. Requirements: - Design an Excel sheet that calculates basic arithmetic operations, performs statistical analysis, and handles financial calculations. - The form should be user-friendly and able to accommodate the moderate complexity of data entry. - I need an expert who can create a clear and concise interface for the user, making data entry and subsequent calculations easy and efficient. It would be great if the freelancer has experience with: - Excel design for calculation purposes - Data entry form design - Experience in basic arithmetic operations, statistical analysis, and financial calculations...

Please Sign Up or Login to see details.

I'm in need of a fast professional who can develop a website for me similar to the one linked, and then provide me with the necessary files so I can host it myself. Should be simple website, no wordpress or similar. I will provide you with further details later I will provide you graphics but you would also need some grapic skills to make them look cool. Key Requirements: - Create a website similar to - Provide the files for hosting upon completion - Eye for aesthetics and design Please let me know your expected time frame for completing such a task, and your prior experience in creating similar websites.

Let's do it. let's do it. let's do it

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

I'm in need of an Excel expert to enhance my files. The tasks include: - Removing duplicate rows - Fixing formatting issues - Merging two sheets into one Additionally, I would like to incorporate a corporate branding style in the file, utilizing appropriate colors and logos. Ideal Freelancer: - Proficient in Excel with experience in data cleaning - Skilled in formatting and merging multiple sheets - Familiar with incorporating corporate branding within Excel

I'm looking for an efficient data entry professional to input a variety of data into Excel for me. The required data includes: - Text data - Numeric data - Date and time data The main purpose of this data entry is to facilitate data analysis and the creation of reports. There are approximately 100-500 data entries in total. Ideal Skills: - Proficient in Microsoft Excel - Excellent attention to detail - Strong analytical skills - Previous experience with large volumes of data input

I need a detail-oriented and efficient freelancer to assist me with a data entry project. The specifics are as follows: - The project requires entering a combination of numeric and text data. - The goal is to have the data organized in a clear and coherent manner. The format of the data is likely to be in spreadsheets, although it may vary. Proficiency in Excel and Google Sheets will be essential for this task. Previous experience in data entry with formulas will be considered a plus. The ideal candidate will be able to deliver high-quality work in a timely manner.

I'm in need of a skilled developer to create a text-based GPT (Generative Pre-trained Transformer) specifically for analyzing excel outputs and give answer according to user pre-defined questions.

...for a talented and experienced SEO copywriter to join our team. This role requires a deep understanding of SEO best practices, excellent writing skills, and the ability to produce engaging, informative, and high-quality content. Responsibilities: Write and edit blog articles that are informative, engaging, and optimized for search engines. Conduct keyword research to identify high-potential keywords and topics. Optimize existing blog articles to improve their search engine rankings. Develop content strategies to increase organic traffic and improve user engagement. Collaborate with the marketing team to ensure content aligns with overall brand strategy and goals. Stay up-to-date with the latest SEO trends, tools, and best practices. Requirements: Proven experience as ...

...desarrollo y marketing para implementar las mejoras. - Collaborate with our development and marketing team to implement improvements. Requisitos / Requirements: - Experiencia comprobada en auditoría de sitios web. - Proven experience in website auditing. - Conocimiento profundo de herramientas como Google Analytics, Google Search Console, Ahrefs, SEMrush, Moz, GTmetrix, Lighthouse, entre otras. - In-depth knowledge of tools such as Google Analytics, Google Search Console, Ahrefs, SEMrush, Moz, GTmetrix, Lighthouse, among others. - Certificaciones en SEO y otras áreas relevantes son una ventaja. - Certifications in SEO and other relevant areas are a plus. - Excelentes habilidades de comunicación y capacidad para explicar conceptos técn...

I'm looking for someone to complete a task with Canva. Producing eBooks. I've already created template and cover for several ebooks, it takes me too much time to move the text from the word document so that’s the job. Ideal Skills and Experience: - Proficiency with Canva - Experience in ebook design - Strong attention to detail This task is straightforward and would suit someone who has experience working on similar projects. Images show the details and example. Looking forward to hearing from you. Jake

I'm looking for a dedicated virtual assistant to assist me with simple data entry tasks. The data will be provided in handwritten notes. Ideal Skills and Experience: - Proficiency in data entry - Ability to handle simple copy-pasting tasks - Experience with handwritten notes data entry is a plus - Attention to detail and accuracy - Excellent time management skills - Familiarity with tools like Excel or Google Sheets for organizing the data Please note that while the tasks are straightforward, attention to detail is crucial. I'm looking for someone who can deliver accurate and timely results.

I have a substantial Excel table and I am in need of a skilled data analyst to help with correlation analysis between Column 1 to 9 of my dataset, which contains more than 4200 rows and 9 columns. Need the source file of xls with formula too Key Responsibilities: - Perform accurate correlation analysis on specified columns - Generate line graphs to visualize the correlation Ideal Skills and Experience: - Proficiency in Excel and correlation analysis - Solid understanding and experience with line graph creation - Excellent problem-solving abilities - High attention to detail I'm looking for accurate and efficient work so I can understand the relationship between my data points and act accordingly. Your experience could be the key to enhancing my project. ...

What we have -------------------------- 1: Excel or CSV file. containing addresses to post letters 2: Letter Quality ( Paper weight, Sizes, Cost per letter etc configuration in JSON array) What we need -------------------- - Standalone PHP Script where we will be able to select an item from provided JSON. - Through DHL API we will validate the provided addresses(in the form of exel or csv) if each individual address is valid - or we should be able to select the areas of over choice over google map is shown in the provided video - this funcationaly is also provided over DHL api I think. and there demographic filters can also be applied which are provided be DHL api also shown in the video Please apply only if you the the required experience. these links may help

...documents and photos into simple data in Excel format (language is not in English workable when one can use translate and understand the few terms that are there). The ideal candidate will have the following skills and experience: - Proficient with MS office - Expert in handling MS Excel - Ability to follow a specific Excel template provided - Attention to detail to ensure accurate data entry ***The task is very simple and just requires attention to detail. I need mainly 4 Data Rows: 1. Date 2. Payor/Payee 3. Amount 4. Short Description of Transaction (if given in the doc) Please message me to talk about the project and the realistic bid price per Job. Your responsibility would be to ensure that the scanned files and photos are a...

I'm looking for a skilled AI Developer to program module that speaks with AI (Gemini or GPT) as batch analysis of Excel files. Key Responsibilities: - Conducting pattern recognition and insights in the data Ideal Skills: - Strong AI development experience - Proficiency in Excel and data analysis - Ability to automate analysis processes

I'm seeking an experienced sports statistician who specializes in data analysis. We would like to find someone based in the US who has some knowledge ideally of the NFL. Our primary aim is to understand the overall performance of different teams and when they peak (early, mid-, late season, etc.) Key Responsibilities: - Examine several seasons of football, basketball, and baseball statistics (to be decided) - Provide team performance analysis - Generate report highlighting key findings Required Skills and Experience: - Understanding of sports statistics, specifically American football, baseball and basketball - Proficient in statistical analysis tools - Previous experience in sports-data analysis preferred

...dealers, can post their cars on our classified section for a fee. Classified Browsing for Buyers: Buyers can browse our classified section to purchase cars. What We Need: General Promotion: We need to promote our website and its services to the residents of Abu Dhabi. Specific Campaigns: We need to create special TikTok ads for specific cars listed in our classified section. This might involve several cars with dedicated campaigns. Future Plans: We plan to develop a bot that will automate the promotion of specific cars based on the criteria and campaigns you help us build. We hope to establish a long-term relationship where you will continue managing and adjusting our website campaigns and ad automations over time. Requirements: Proven experience in managing TikTok ad campaign...

I am seeking a proficient seller to promote my online mental health services specifically tailored for IT professionals. This unique offering allows sellers to earn commissions based on successful sales, ensuring a mutually beneficial partnership.

I am seeking an experienced Power BI expert who can assist with generating intermediate reports. This role involves: - Working with Excel datasets. - Developing seamless processes to generate user-friendly reports. - Troubleshooting any issues that may arise during report generation. The ideal freelancer should have: - Excellent understanding of Power BI. - Experience in report generation. - Adept knowledge in handling Excel datasets. - An analytical mindset with attention to detail. Proficiency in Excel and experience with intermediate report generation will be highly advantageous.

I own a blog and I'm looking for a skilled freelancer who can assist me in acquiring high authority backlinks that will help to increase organic traffic and improve my search engine rankings. Key Responsibilities: - The primary task will be to acquire high authority backlinks. These should be from reputable sources and relevant to the content on my blog. - Analysis of my current backlink profile and making necessary adjustments to improve SEO performance. - Consistent monitoring of the backlinks to ensure they are active and continuously contributing to my website's growth. Ideal Freelancer: - Proven experience in building high authority backlinks. - Familiarity with SEO practices and up-to-date knowledge on the latest algorithm changes. - Previous work with blogs is a p...

I'm looking for an experienced Excel expert to create a customized spreadsheet for my construction project. The primary usage of the sheet will be for material and labor cost estimation, and I need it to include visualizations in the form of charts for budget allocation. Key Tasks: - Set up the sheet with the right formulas and functions to ensure accurate calculations for material and labor costs. - Design the sheet to be user-friendly, yet professional in appearance. The ideal candidate should have: - Proficient knowledge and experience in using Excel for construction projects. - Prior experience in creating similar spreadsheets with formulas and visualizations. - An understanding of the construction industry and the specific needs of this field in terms of estima...

I have a complex Excel file with more than 10 worksheets that I need help with. The project involves three main tasks: data entry, formulas and calculations, and data analysis. Key Responsibilities: - Data Entry: - Ensure accurate entry of information across various tabs - Formulas and Calculations: - Implement necessary formulas and calculations to make sure that the data is accurately processed - Data Analysis: - Utilize Excel functions for data analysis Skills and Experience Required: - Proficient in Excel, including strong skills in data entry and formula creation - Experience in data analysis and visualization would be a plus - Attention to detail and accuracy are crucial as the data is sp...

Hi there! I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.

I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.

As a local contractor, I'm looking for a skilled and experienced Google Ads expert to help me generate leads within our city. My target audience is homeowners, and the main focus of this campaign is to generate high-quality leads. Key Requirements: - Proven experience in running successful Google Ads campaigns - Deep understanding of lead generation techniques - Prior experience working with local businesses - A clear understanding of the homeowner market The ideal freelancer would be able to set up, monitor and optimize the campaign to ensure a steady flow of leads. A keen eye for detail and a collaborative approach to work would be highly valued.

My website currently has an average performance in search engine rankings and I am primarily looking to enhance this on Google. I'm in need of a SEO expert who can identify and implement both On-page and Off-page techniques to improve my site's visibility and ranking. Key Requirements: - Experience in SEO: A proven track record of increasing search rankings for clients. - Google SEO Knowledge: A comprehensive understanding of Google's algorithms and best practices. - On-page & Off-page SEO Skills: Proficiency in both these areas, including content optimization, link building, and other relevant strategies. Your work will be critical in boosting our online presence and driving more organic traffic to our site.

I'm in search of an expert in MS Excel to help me with an advanced task involving formula creation. This project requires knowledge of macros and pivot tables. Your primary responsibilities will include: - Developing and implementing complex formulas in Excel - Ensuring the data is correct and displayed properly - Creating macros and pivot tables - Providing any insights that can help improve the overall process The ideal candidate should have: - Proven experience in advanced Excel tasks - In-depth understanding of macros and pivot tables - Ability to communicate effectively and provide clear progress updates - Attention to detail and accuracy in data analysis and formula creation