Excel control pivot tables jobs
I'm urgently in need of a Python specialist to accomplish an assignment using Jupyter Notebook. The task involves reading and merging multiple Excel sheets, and subsequently creating visual representations for the collated data. Key requirements are: - Deep knowledge of Python for data analysis - Proficiency in creating Bar Charts, Scatter Plots, and Line Graphs. - Strong skills in Excel data manipulation. Required libraries/packages expertise: - Matplotlib - Seaborn - pandas Your responsibility will be to decode the problems presented, manipulate provided Excel data accordingly, and present the output in an understandable visual format. Previous experience in similar tasks will be highly regarded. Will show the work on zoom and will connect and probably do ...
I am seeking a seasoned Excel expert to manage a complex data entry project. Your focus will be the development and implementation of advanced macros to ensure efficient, effective data management. Key Responsibilities: - Executing Excel data entry tasks - Developing and applying advanced macros Preferred Skills & Experience: - Proficiency in Excel - In-depth understanding of advanced macro development - Proven experience in similar data management projects The ideal freelancer will be detail-oriented, possess strong problem-solving skills, and have a track record of improving efficiency and accuracy in data entry tasks via macro automation.
... for example [India fillings search]() [quick company company search]() [MCA portal]() However, these don't allow bulk input. I want users to be able to input a large list of company names and receive an output in a downloadable Excel sheet. Although I initially explored utilizing an [API from ](), I encountered difficulties with downloading data or obtaining an API key, possibly due to issues with their website. but was able to find [this csv file on kaggle]() containing
...assist in developing metrics and calculations for the data. - Deliverables: The final output should be presented in a report format. Ideal skills for this project would include expertise in Python, data analysis, experience with text data, and the ability to create comprehensive reports. I want to write a python code for the following calculation of Code Synchronization adoption rate: I've 4 excel files, 2 Jira extracts and 2 solman extracts. 1 for Jira Support state(support user stories & bugs) and 1 for Solman Support state(Support CRs). Other would be same Jira & SolMan extract but for Project State. Project might have more items that Support which is normal. The idea of code retrofit is every change that Support team introduces i.e N item should have a corr...
...the past for some amount. From 20 euros to hundreds of thousands of euros, and they stopped a year or more ago. The purpose of the conversation is to check whether the company still exists, whether it is still in the field and why they stopped purchasing. We have prepared a dedicated link for filling in the results of the conversation. I am attaching the excel file with the records, the script of the conversation. Translate it into the appropriate language for the country you will be speaking with) The conversation must not be mechanical, the script is only for illustration. I have prepared several questions and answers in case it comes up in the conversation. For the purpose of the conversation, you work at Vista System Norway. Some of the records include
I am in need of a skilled data entry operator to assist with the transfer of input of text data. Your main task is to take text data from an online database and accurately enter it into an Excel spreadsheet. Requirements: - Ability to accurately enter text data - Proficient in Excel - Experience sourcing data from online databases - Diligent and detail-oriented to ensure no errors are made during data transfer - Strong English language skills to ensure effective communication The ideal freelancer for this project is someone with proven data entry experience, excellent Excel skills, and vast familiarity with online databases. Being a detail-oriented person with great concentration skills will be a huge plus.
...multiple Excel slicers into one for our data analysis needs. The requirement is, I want to use same Slicer for multiple data. Detailed description is as follows: I have a accounting sheet. Where in one separate sheet I have captured Incomes along with the date and amount and other sheet I have put Expenses along with Date and amount. Now in summary sheet I am using Income pivot table, where I am using Slicer on Date (Merged for Months and Years). I want the same slicer to be used for Expense pivots as well. The ideal freelancer for this job should be proficient in: - Excel - Slicers and PivotTables - User experience design - Data analysis techniques Your input and expertise in this project can help streamline our data manipulation process and enhance the over...
I'm looking for an Excel and VBA expert to help streamline my workflow and boost productivity. You'll be responsible for: - Automating repetitive tasks: I need you to develop efficient scripts that will handle routine operations in the spreadsheets, eliminating the need for manual intervention and enhancing the overall efficiency. - Crafting custom functions: The custom functions I require are complex and involve external data sources. Your role will involve creating these functions effectively, ensuring they are accurate and function seamlessly within the Excel environment. The ideal candidate will have extensive experience in Excel, VBA, and creating complex custom functions. Solid understanding of data analysis and automation is crucial for this role. Y...
...only one week Only the corresponding screen can be viewed Approximately 300-400 new businesses expected to be registered each month: Development needed to accommodate the expected volume of registrations Development to prevent IP bans Detailed feature description: Member Login Sign-up Permission assignment Individual inquiry Immediate rank crawling Tracking target management Individual input Bulk Excel upload & download Keyword-based crawling On/Off Deletion Background crawling of tracking targets Naver Place keyword (1 daily query) Rank change history Generate a shareable URL (reset every week) Display in a popup from step 3...
CRUD 2 tables only. Long term project.
Dear Candidate, As described in the title, this task requires that you reasearch medical centres (also called general practice medical centres, family physician clinics, clinics) and find out who the owners of these clinics are are using internet research. You will have to be fluid with excel, online reasearch tools. This is a posting for a long-term VA who can perform various forms of online research and other tasks. Personal attributes required: 1. Speed and efficiency in online research. 2. Attention to detail and complete accuracy in all tasks. 3. Punctuality and ability to meet deadlines. 4. Ability to read/follow instructions carefully with attention to detail. Successful candidates will be required to complete two test works before the project is awarded. 1. Watching i...
I'm looking for an Android app developer who can create a finance loan application with an integrated web backend. The app should be designed using the latest technolog...user processes including registration, login, and profile updates - Loan application management - Property/Stock verification agent management - An admin dashboard for admin actions Security Features: - Encryption of user data - Role-based access control Ideal Skills and Experience: - Proven experience in developing Android applications - Proficiency in the latest web technologies - Strong understanding of mobile app security - Previous experience in developing finance or loan applications will be a plus - Familiarity with role-based access control and encryption - Good understanding of UI/UX design f...
Looking for someone to go to a few sites and make me an excel sheet with all the listings on the site . Must speak fluent English
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 da...
I need an adept data entry freelancer to skillfully convert text data from various online sources into an organized Excel spreadsheet. You'll reap the benefits of this project if you're detail-orientated, familiar with navigating online sources, and proficient in Excel. - The project involves researching, collecting and collating text data from specific online sources - The final deliverable needs to be an Excel spreadsheet, with data arranged legibly - Demonstrable experience in data entry jobs would be ideal - A keen eye for detail is paramount as exactness is key for this data entry task - You should be comfortable working with Excel and have proficiency in using all its features. The testimonials of your past clients and your portfolio of simil...
...at predetermine interval - Error logging: The program should be able to log any errors or issues that occur during monitoring. - Control: The ported program should support control features like: - Adjustment of monitoring settings: The user should be able to modify the monitoring parameters. - Remote control of monitored devices: The program should allow for remote control over the devices being monitored. The ideal developer for this project should have: - Strong experience in programming with C#. - Expertise in porting applications between different operating systems. - Prior experience with implementing real-time monitoring, data visualization, and control functionalities. - XEY ! The software is to monitored controllers with 3analog inputs, 2...
...Java-based desktop application on an AWS cloud instance. - Implementing a multi-user access system. - Integrating a MySQL database component. - Developing a Python-based web interface for users to change settings. The ideal candidate should have: - Proficiency in Java, Python, and MySQL. - Prior experience with cloud hosting, particularly on AWS. - Knowledge of user access control systems, particularly Discretionary Access Control. - A good understanding of desktop-to-cloud migration. - Strong communication skills and attention to detail. We need a developer who can take a Java based desktop application and host it on a cloud instant of AWS. - must have multi user access - must have a database component - must have a web interface that can allow users to configure...
I need a proficient excel expert to help me with a data entry project. The data involves simply names, emails, and phone numbers. It will be a table with 100-500 entries, so proficiency in data entry and Excel is crucial. Key Requirements: - Accurate Data Entry: The job is primarily about accurately transferring names, emails, and phone numbers from a document to an Excel sheet. - Excel Proficiency: Knowledge of Excel functions is a plus, though not specifically required. You should be comfortable working with a table of this size.
... PH sensor EC sensor Water level sensor - Output : 2 x Peristaltic pumps 2 x 12v pumps AC Fan (PWM-controlled EC-motor) 220v water motor pump (using Solid State Relay) inputs/outputs will need to be set up and configured and based on the reading of the input sensors the Microcontroller will control the outputs. The successful freelancer will need to provide the following : Full electronic diagram. List of the parts needed other than the inputs sensors and the outputs. Programing code. Ideal skills for this project include, but are not limited to: - Proficiency in programming with the ESP32 platform - Experience in working with digital and ...
I'm experiencing performance issues within my IoT-based platform, mostly coming from slow query response times, excessive storage consumption, and challenges with insert operations after compression. I'm looking for an experienced Timescal... I'm looking for an experienced TimescaleDB expert to optimize this. - Optimize slow query response time - Reduce excessive storage consumption - Fix insert operations after compression The ideal freelancer for this project is someone who has extensive experience in TimescaleDB, particularly in query optimization and compression features. Unfortunately, I'm unable to provide the number of tables in the platform, but I need someone who is capable of handling extensive data and complex structures. If you've dealt with...
I'm in need of comprehensive and detailed Australian databases. Specifically: - Medical databases, with a key focus on medical specialties. Medical databases should prefe...should preferably contain reliable and relevant information about the different branches of medical specialties across Australia. - Business databases, encompassing detailed company profiles inclusive of industry category, phone, fax, email, physical address, etc. I'd appreciate getting more data, as in-depth as possible. The databases should be pre-existing or scraped and must be provided in Excel format, or .BAK for MSSQL server. Professionals equipped in big data collection, scrapping, and data analysis would be the most suited for this project. Knowledge about Australian medical and business sect...
...management experience or have been a top producing call center agent! The Rehasher Commissioned Sales Closer can be located in an office or remotely. -The position will require a script outline that allows for creativity. Training will be provided by the company. -Rehasher Commissioned Sales will have access to run financing for customers to get financing secured for the sales made. -Rehasher will control their schedule, but calls will be monitored to ensure both rehasher is making money, and the customers are being followed up with. -The pay will be weekly, rehasher will be paid on deals that were installed and paid during the period. -The position will require follow up with customers that have received recommendations from a technician with the sole purpose to close the sal...
I'm looking to integrate a Chromecast cast button into my website. This button will be specifically for video content. I need the button to be functional in casting video content to Chromecast devices. Key Requirements: - Implement a Chromecast casting button - The button should be specifically for video content - The button should not have control for playback, just for casting Ideal Freelancer: - Proficient in Chromecast SDK - Experience in video content integration - Excellent understanding of web technologies my website here
I need a freelancer to assist with accurate and efficient data entry into Microsoft Excel. The data is in digital format and involves numeric values. Key Requirements: - Enter numeric data into Microsoft Excel from provided digital sources - Ensure data is accurately transcribed - Maintain confidentiality of the data Ideal Freelancer: - Proficient in Microsoft Excel - Strong attention to detail - Previous experience in data entry, preferably with numeric data - Ability to maintain data integrity and confidentiality. Note: Please ensure you have a copy of Microsoft Excel for this job.
I am in need of a professional who can help provide insights into a dataset using Excel's pivot charts, tables, and dashboard. The area of the data is unspecified as of now, but a strong candidate would be adaptable and skilled across domains. Key responsibilities will include: - Data Visualization - Creating Pivot Charts - Building Tables - Preparing a Dashboard Note: This project is basic-level work and my budget is 10 not more than that I already checked price comparisons with different freelancing platforms. if anyone works in that price range only the person make bids does not waste time.
I'm currently seeking an Oracle SQL developer with exceptional proficiency in creating logics. This task requires: - Writing an SQL code for data extraction purposes. - The code needs to be written as quickly as possible, with a time frame of 1-2 hours. - The solution should deal with the joining of multiple tables and creating doing some further order by, group by codes Decent knowledge of Oracle and experience in handling similar tasks would be ideal for success in this project. Your ability to deliver accurately and timely will be greatly valued. The code should be written using simple statements. I am not sure how to set up a connection to our datapool though. I can show couple of other related codes that can help
I am looking for a freelancer who is proficient in data entry and familiar with Excel to assist in the digitization of a 276-page vintage parts manual. Your task would be to: - Accurately copy the information from pdf to Excel. This includes part numbers, the description of parts, and all other columns present in the original tables in the document. - Organize the spreadsheet such that each section of the document is represented by a separate worksheet. No specific data validation rules or cell formatting are required, but the data must be accurate and searchable in Excel. This job requires someone with a keen eye for detail and a good understanding of Microsoft Excel. Prior experience in similar data entry tasks would be a significant advantage. A sa...
I am in need of a skilled professional to develop software. We have all barcodes in EAN formats in excel (14-15 digits format) Everyday we sell products online. We would like to be able to find a certain barcode on a shelf as we have many EANS on the same shelf. We have bought a wireless handheld scanner. So we would like to be able to transfer those eans (EAN ) to use this wireless scanner to find a certain product on shelf. Or maybe not transfer but to export some batch of eans everyday in order to find them faster everyday ob the shelf.
Looking for an expert who can import data from 1-10 Excel files into Google Earth. Key tasks: - Convert location data from Excel into a format readable by Google Earth (preferred Google Eath Pro Tours for Commercial Real Estate Properties - Ensure perfect alignment of data with the geographical locations - Grouping and categorizing the locations as per the content of each column within the Excel files Ideal candidate: - Proven experience with data visualization tools, particularly Google Earth and Google Earth Pro tours for Commercial Real Estate Properties -- High proficiency in handling Excel files and data - Understanding of Geographical Information Systems would be a bonus.
I have a MySQL database that needs exporting. All user data, product data, and transaction data are required to be exported. Key Tasks: - Export all MySQL user data - Export all MySQL product data - Export all MySQL transaction data The final export should be in Excel format. This is not a job for beginners. You should have prior extensive experience with large database exports and MySQL. It would be a big plus if you're familiar with handling sensitive user and transaction data. As the project involves substantial data, confidentiality and data security are non-negotiable. Please include samples of similar database exporting projects you've completed.
I am in need of an Excel spreadsheet expert to create an Excel template using a PDF sample. Without being specific about the details, the ideal candidate should have excellent skills in extracting data from PDFs and well-versed in designing Excel templates. Here's what I'm looking for: Mactacquickshipsellsheet pdf converted into an excel sheet example of what I would like as template.
I'm in need of a Python expert who can meticulously extract text and tables from PDFs for data analysis. The requirements are as follows: - Develop a Python solution in form of a Jupyter Notebook - Preferable use of the libraries PyPDF2, Tabula, PDFMiner, PyMuPDF, and PDFPlumber for extraction Required Skills and Experience: - Proficient in Python - Familiarity with Jupyter Notebook - Experience with PyPDF2, Tabula, PDFMiner, PyMuPDF, and PDFPlumber - Data extraction and analysis expertise. Your commitments would include understanding the architecture of the PDFs, and the most effective library for extraction in each case. The ultimate goal is to create a Python script that eases the data extraction process for subsequent analysis. Whoever can most efficiently extract (...
...consumption implied by these project details), include the A.I object and face recognition features to be included for the sense. The 484 should display the video stream of the latest activated sense, which can be maximised to full screen. Within its original page should also be toggles for the 3 relays. The screen should also contain the ability to add up/down button pairs for the forward/reverse control of continuous rotation servos. Make it so speed and end-stops can be edited preferably by the user but at least clearly within the code. • if live audio along with video is not possible, the page should contain a playlist of 30 seconds of audio to be automatically recorded upon each sense awakening. Recording should continue until below threshold and recordings should be...
Database Tool Development I. Introduction 1. Purpose: The DRP Talent Solutions team currently manages an internal workforce partner database developed in-house and updated internally. This resource, currently in an Excel spreadsheet format, is used to assist employers in navigating our regional workforce programs and partners. To enhance its utility in responding promptly to RFIs (Request for Information), we aim to reinforce this database tool. Our objectives include implementing organizational features with multiple tags for efficient categorization and establishing a user-friendly update and maintenance system that does not require consultant engagement. 2. Objectives: i. Objective 1: Enhance Database Organization 1. Introduce multiple tags for easier navigation and filtering ...
I'm in need of an Excel expert to help me with intermediate-level spreadsheet formatting. The tasks include moving data from sheet to another sheet Ideal Skills and Experience: - Proficiency in Excel
**Project Ti...looking for freelancers with extensive experience in Flutter, particularly in designing user-friendly authentication systems, efficient work organisation features, user profile management functionalities, team management capabilities based on assigned role models, communication options such as email, chat, SMS, and WhatsApp integration, timestamp functions, summary features, and role-based access control. Familiarity with PHP is advantageous for the seamless migration of the existing tool. The successful candidate should prioritize clean, efficient design and implementation to ensure a smooth transition to the new platform while maintaining the tool's solid functionality. Feel free to reach out if you have any further questions or need additional details regardi...
Project Brief: In this project, will be developing an application to sense, share and control another application on a nearby node. The application can be mobile, web or desktop. The application is required to: 1. Sense a nearby node. When a node comes within the communication range and also when it moves out from this range. An indication should be there when a node is sensed or moved away. 2. Share some content. It can be some message, file, chat etc. 3. Control minimum one feature of the remote node e.g., volume, brightness, wallpaper etc. Project Requirements 1. The deadline for the project is: 10-May-2024. a. Report: It should include: ii. Name of the application iii. Application’s purpose iv. Explanation of its functionality from the perspective of ad hoc and se...
I am looking for a freelancer to assist me with a data entry project. The task involves typing data from handwritten documents into a digital format. The data must be formatted in a specific way, so attention to detail is important. Skills and Experience: - Proficient typing skills and accuracy - Experience with data entry and handling handwritten documents - Familiarity with formatting data according to specific guidelines - Ability to work efficiently and meet deadlines The project includes 1-10 pages or documents that need to be entered. If you are interested in this project, please provide examples of previous data entry work and explain your experience with formatting data.
I'm seeking a seasoned freelancer w...seeking a seasoned freelancer with substantial experience in ESP32 programming and Nextion Display configuration. Your primary task will be to develop a comforting touchscreen control system that's attention-grabbing and user-friendly. This project requires: - Design and implementation of a multi-level menu structure. The idea is simple: we want users to navigate easily through various menu options without experiencing any difficulties. - Wireless connectivity isn't required. Key Skills: - Exceptional understanding of ESP32 programming. - Proven expertise with Nextion Display setup. -SD Card Read. -PID Control Please ensure your proposal demonstrates your experience with these specific requirements. Looki...
I'm looking for a talented Excel programmer to build an Excel tool tailored for my business' quotation procedures. Notably, this tool must provide these key functions: - Automatic Price Calculation - Customized Quotation Template Design I already have a specific design in mind for the quotation template and would require the freelancer to implement my design concept accurately. A potential candidate should have considerable Excel programming skills coupled with a solid understanding of quote creation processes. A sense of accuracy, creativity, and robust attention to detail would be beneficial for this task. Outputs should be precise and user-friendly, ultimately contributing to streamlining our current operations.
I'm looking for a talented Excel programmer to build an Excel tool tailored for my business' quotation procedures. Notably, this tool must provide these key functions: - Automatic Price Calculation - Customized Quotation Template Design I already have a specific design in mind for the quotation template and would require the freelancer to implement my design concept accurately. A potential candidate should have considerable Excel programming skills coupled with a solid understanding of quote creation processes. A sense of accuracy, creativity, and robust attention to detail would be beneficial for this task. Outputs should be precise and user-friendly, ultimately contributing to streamlining our current operations.
Design of a sales page based on these requirements: One page sell sheet that matches the brand guidelines. Audience is men aged 27-50, General Contractors and remodelers Headline: Get Exclusive, High Quality Leads Paid Ads Management Highlight in whatever way you’d like: 1. You control the ad spend 2. Only $500 management fee* 3. Search, Display, & Video Ads *excludes ad cost Testimonial: Following the Pandemic our SEO, Blogs and Website were out of date and no longer ranking in Search. No one could find us! Small Business Marketing Solutions knew exactly how to target the problem. First they did all the keyword research needed to update our blogs and content. SMB also created awesome videos for our marketing and used their special formula to give us maximum visibi...
For Task 1, the project will focus on analyzing flight simulator data using MATLAB to compute metrics that quantify pilot control behaviors during different landing phases, contributing insights into enhancing fly-by-wire systems. In Task 4, MATLAB will be employed to simulate driver responses in automated vehicle scenarios, particularly modeling how drivers might react during rear-end collisions. This simulation will help in assessing the impact of various time gaps on collision avoidance, providing valuable data for improving automated vehicle design and safety protocols.
I'm looking for a skilled Excel expert who can help with adjusting product pricing, adding products, creating formulas, adding products etc via excel, .csv. This is a ongoing project. If you can upload .csv to wordpress is a big plus!! KEY REQUIREMENTS: - I specifically need assistance with spreadsheet automation. - The work required is at a basic level, focusing on formulas and functions. - Implement automation for the designated tasks. - Ensure that the automation is robust and well-documented. SKILLS & EXPERIENCE: - Proficiency in Excel is a must. - Experience in basic spreadsheet automation. - Strong understanding of formulas and functions. - Attention to detail and commitment to quality.
I'm looking to develop an Artificial Intelligence (AI) charges calculator for Excel. The core functionalities include: - Automatic calculation of fixed charges - User-friendly interface for effortless interaction and data management. - Reliable data input validation to ensure accuracy and consistency. - Calculate Profit based on fixed charges and earning from subscription The calculator will primarily handle financial data. Prospective freelancers should have a strong grip on Excel, data validation, and UI/UX design—along with financial acumen for effective calculator development. A successful execution ideally enhances efficiency and aids with precise financial management.
...with a data analysis project. The project includes a variety of tasks such as Index Development and Justification, Data Selection, data cleaning, Multivariate Analysis, Normalisation, Weighting and Aggregation, Link to Other Indicators, Visualisation of Results, and Version Control. Skills/experience required: - Proficiency in data analysis techniques - Experience with data cleaning and normalization - Strong knowledge of multivariate analysis - Ability to create visual representations of data - Experience in version control of analytical work The specific data you'll be working with is open to your choice. Your expertise in selecting, cleaning, and analyzing the data will play a key role in the successful completion of this project. Needed strong knowledge of pytho...
I'm in need of a meticulous and reliable freelancer to assist with online data entry tasks. You'll be required to input data into spreadsheets using platforms like Excel or Google Sheets. The data will be provided to you in digital formats, such as PDFs, Word documents, or scanned images. Key Requirements: - Proficiency in online data entry - Experience working with spreadsheets (Excel, Google Sheets) - Ability to maintain accuracy and attention to detail - Familiarity with handling data in digital formats Ideal Skills: - Previous experience with similar data entry projects - Proficiency in using Excel or Google Sheets - Background in spreadsheet management - Strong attention to detail and accuracy A successful candidate will be someone who can ensure da...
I would like a custom sales order created in Excel for about 50 different items. Key Requirements: - Each item's entry in the order should include item name, quantity, and description. - The items should be sorted by their ship date. - The system should incorporate a feature to apply a total discount on the order. Ideal Skills and Experience: - Advanced Excel Skills with the ability to create customized sales orders - Proven experience in developing financial/ordering spreadsheets - Excellent understanding of sales order process and discount mechanisms.
Ease and flexibility of use by the site administration. - A comprehensive control panel for dynamic content management. - Multiple authority levels (manager, editor, publisher, etc.). - An easy and integrated system for managing multimedia (images, video, etc.). - Flexible tools for publishers enabling review and scheduling. - Compatibility with C3W standards for cross-browser functionality. - Possibility of future development without impacting existing content. - An excellent, search engine-friendly system for periodic archiving of content (SEO). - Multilingual support (Arabic - English). - Design meeting standards for speed and ease of browsing. &nb...
