Problems data cleansing excel jobs

Excel to Invoice Automation System My project involves leveraging Power BI, excel, and macros to automate the invoicing process. I am specifically looking to reduce the manual work that comes with data transfer. Requirements: - Develop a system to automatically generate and track invoices from excel spreadsheets - Implement a robust and error-free data transfer process - The final product should be able to streamline the entire invoicing process Ideal skills and experience: - Deep experience with Power BI, excel and macros - Understanding of finance and invoicing processes - Proven track record in creating automated systems - Strong problem-solving skills, attention to detail. In conclusion, I need someone capable of merging my existing softwar...

...am in need of a proficient VBA and Excel Macros expert to develop a simple, yet efficient invoice/billing application. Key Features: - Generation of invoices from input data. - Tracking and calculation facility for totals. - Maintaining a robust database for customers and invoices generated. Interface Requirements: - The GUI should be straightforward and user-friendly, allowing quick input, management, and retrieval of information. Data Handling: - The application should exploit Excel capabilities for the storage and manipulation of all the data, including customer and invoice records. Ideal Skills & Experience: - VBA and Excel Macros expertise. - Experience in creating user-friendly GUIs in Excel. - Able to develop robust ...

...management. Therefore, we're seeking an expert in Excel to build us an inclusive inventory management template. The template should possess the following specialized features: - Product Categorization: A way of classifying each product for straightforward identification and reference. - Stock Tracking: The prime functionality we're seeking. Notably, it should track items by product name. This will ensure precision in monitoring our inventory and prevent replication or confusion. - Comprehensive SKU Tracking: It should encase a complete and precise representation of our stock movements. Specifically, it should include incoming stock, outgoing stock, and current stock levels. An ideal candidate for this job should have extensive experience in Excel, particularl...

I'm looking for a seasoned SEO expert to help me increase traffic to my website, specifically catering to local customers. The project's primary focus will be on enhancing the on-page and off-page SEO elements. Looking for a candidate who can identify the current seo problems and logically explain the conditions for better seo. Key Responsibilities: - Improve content optimization: Develop strategies to enhance the website's on-page SEO, ensuring the content is both SEO-friendly and relevant to the local audience.

I'm in need of a freelancer who is skilled in designing both process and workflow flowcharts via Microsoft Visio, as well as project management checklist forms in Excel. The checklist should be of an intermediate level complexity, incorporating features such as drop-downs and validation. Prior experience in constructing Visio flowcharts and Excel forms is imperative to understand the project's need thoroughly. Proficiency in Excel functionalities would make tackling this task comparatively easier.

I am seeking a skilled programming expert, proficient in either Rub...querying capabilities. The primary task involves intelligently executing aggregations and nested queries in ElasticSearch, extracting data, in JSON format, and then transposing it into Excel or CSV format. I'm open to whichever format you are more comfortable with, so long as it is either of the two mentioned. In addition to this, having familiarity with job automation via GitHub is critical for this project role. This background should include understanding how to automate and schedule tasks to regularly extract, convert, and save this data. Ideal Skills: - Proficiency in Ruby or Python - Intermediate level ElasticSearch querying - Experience with JSON to Excel/CSV conversion - Famili...

Entering data into an Excel sheet is the primary task for this project. Unfortunately, I cannot specify the volume of data that needs entering as I skipped this information. However, please rest assured that there is no immediate rush, so you can complete the project at a pace that suits you. Ideal skills and experience for this job would include: - Proficiency in Excel data entry - High attention to detail - Excellent typing speed and accuracy - Relevant experience in data entry jobs If your profile matches these criteria, I'd be delighted for you to submit a bid. Looking forward to potentially working with you.

...looking for a skilled data entry professional who can assist me with inputting data. The exact details of the task are yet to be determined, but the ideal candidate should be comfortable handling various types of data and proficient in working with different formats. Your responsibilities will include, but are not limited to: - Efficiently and accurately entering data into the required format - Ensuring that the data is correctly categorized and organized - Checking for errors and handling them appropriately Ideal Skills and Experience: - Proven experience in data entry - Proficiency with Microsoft Excel and other relevant software - Strong attention to detail and accuracy - Excellent time management and organizational skills P...

I need a proficient expert in Excel to type numeric data and carry out basic arithmetic calculations. The scope of the project includes: - Data entry of numeric information into an Excel sheet. - Applying basic arithmetic operations to the input data. The ideal candidate should have: - Proficient skills in Excel, specifically with numerical data entry and calculations. - A keen eye for detail ensuring accuracy in calculations. - An excellent understanding of basic arithmetic operations.

I need a detail-oriented and focused individual who excels in manual data entry to convert data from my physical documents into a spreadsheet. Requirements include: - Transferring data from paper formats into a computer system - Strong typing speed and accuracy - Experience with MS Excel or similar spreadsheet software - Ability to maintain confidentiality when handling sensitive information. Accuracy is absolutely critical for this project, so keen attention to detail is a must. Previous experience with similar projects will be highly regarded.

I'm looking for a skilled Java developer who is well-versed in Java 8 features. I need someone to help me understand and implement the various aspects of Java 8, including but not limited to: - Lambda expressions - Streams - Default methods - Date and Time API While the specific tasks or problems related to Java 8 that I need help with weren't provided in this form, you should be comfortable with teaching and guiding me through potential challenges in these Java 8 features. Your goal is to help me gain a deep understanding of these functionalities and how to apply them in practical scenarios. Ideal skills and experience for this job include: - Strong proficiency in Java, specifically in Java 8 features - Prior experience with teaching or mentoring Java concepts - Excell...

I have code for login trading accound and fetch token data. I need to update code to my system. I need to collect live data from the web and candle stick,Mins Intervals are in Dropdown box, I can choose any minutes interval, I need you to collect Last 5 candle data from the Excel in the web and other details for each token, I will give token name in the excel, It will automatically display the rows of data. If i chanage time interval it will display those data only. I need an intelligent programmer, who can see future problems and solve them clever and independently. Note: I dont know about coding, If you install the code and run successfully at my system thereafter I will hire you and release the payment. If you agree this term you...

I need a proficient freelancer to extract and simplify excel data encompassing text, numeric, and date and time data from a significantly sized data file (approximately 5000 rows). The simplified output should be in the form of an Excel file. Ideal Skills and Experience: * Proven experience in data extraction and simplification. * Proficiency in Excel. * Excellent attention to detail. * Ability to work with large datasets. Responsibilities: * Carefully extract specific data segments. * Accurately simplify data for ease of understanding. * Convert the processed data back into an Excel file. * Ensure absolute accuracy throughout the process.

I need a skilled professional who can create some form of wizard (general office365 tools) that lets me enter personal and cv/resume types of data and then turns it into a word based cv using layout that I will provide. The word cv template must be amendable by me. The output is to remain a word document. I need it to be something that will work when my computer is offline not connected to internet I have attached a first cut of the word document template and it is the hello highlighted pieces that represent the inputs and show how/where tables need to be populated. the intent is to enter data and have a consistent cv created for all members

I'm in need of someone to assist me with typing text data into an Excel sheet. The data will be provided in a digital format (PDF, Word, etc.). Key requirements: - Accurate and fast typing skills - Proficiency in Excel for proper data entry - Familiarity with using specific fonts and sizes for consistent formatting - Experience with data sorting and filtering in Excel Your attention to detail and ability to follow formatting guidelines is crucial. The ideal candidate will be organized, efficient, and able to deliver high-quality work within the agreed timeframe.

I'm in need of someone to assist me with typing text data into an Excel sheet. The data will be provided in a digital format (PDF, Word, etc.). Key requirements: - Accurate and fast typing skills - Proficiency in Excel for proper data entry - Familiarity with using specific fonts and sizes for consistent formatting - Experience with data sorting and filtering in Excel Your attention to detail and ability to follow formatting guidelines is crucial. The ideal candidate will be organized, efficient, and able to deliver high-quality work within the agreed timeframe.

I'm in need of an expert who can assist with entering text data into an Excel spreadsheet. Key Responsibilities: - The primary task is to accurately input text data into the designated cells of an Excel file. Ideal Skills and Experience: - Proficiency in Excel, especially in handling text data. - Attention to detail and accuracy in data entry. - Previous experience in similar projects will be an added advantage. Looking forward to your bids. My typing speed is 55wpm

I need a proficient freelancer to extract and simplify excel data encompassing text, numeric, and date and time data from a significantly sized data file (approximately 5000 rows). The simplified output should be in the form of an Excel file. Ideal Skills and Experience: * Proven experience in data extraction and simplification. * Proficiency in Excel. * Excellent attention to detail. * Ability to work with large datasets. Responsibilities: * Carefully extract specific data segments. * Accurately simplify data for ease of understanding. * Convert the processed data back into an Excel file. * Ensure absolute accuracy throughout the process.

I am currently in need of an Excel and data entry expert with strong understanding in copyright matters. Key Deliverables: • Efficient handling of data entry tasks with fast typing speed. • Strong proficiency in Excel functions and formulas. • Undertaking copyright research and analysis. Ideal freelancer for this role should have: • Proven experience in Excel and Data entry. • A strong grasp of copyright laws will be a plus. Please include in your application evidence of your speed and proficiency in data handling, and any relevant experience you've had in dealing with copyright issues. Your past experience related to these tasks will be greatly considered during the selection process.

I'm looking for an expert with a keen attention to detail to manually extract particular data from a web page twice per day. The task involves gathering a 2x30 simple chart from the site. This chart consists of two columns - one representing the date and time, and the second representing a series of numbers. Once this data is extracted, it will need to be organized into an Excel spreadsheet and promptly emailed to me following each extraction. Skills and Experience: - Proficiency in data collection and entry - Familiarity with Excel spreadsheets - Exceptional attention to detail - Ability to work without supervision - Punctuality to ensure data sets are sent promptly after extraction. The success of this project relies greatly on accura...

Project Title: Customizable Excel-Based Mark Book System for English Learning Area Tracking This reads like a lot, but I am only trying to be clear. It's just a mark book. Project Overview I need a skilled Excel developer to create a solution that helps schools track student progress against specific English Achievement Standards across year levels of the Australian Curriculum. The goal is to pinpoint areas needing improvement, empowering schools to target resources effectively. Is it Speaking and Listening, Reading and Viewing, or Writing and Creating? If so what particular Aspect (sentence? Key Requirements Foundation: Excel workbooks to accommodate multiple teachers and classes. Structure: Year Levels (tabbed sheets) with each year's Achievement...

Seeking a Python wizard to generate line and scatter plots from simple numerical data housed in Excel files. Your expertise in Python and experience with data visualization is key to succeeding in this role. Please, in your application: - Highlight your experience in Python plotting - Specify similar projects you've completed Going above and beyond to deliver an error-free, clean and professional visualization will be appreciated. Trust me, I value quality. Let's get started!

As I'm launching a new business, I need your expertise in developing VBA scripts and macros in Excel to help me automate several repetitive tasks. I am looking for an expert in MS Excel to develop a special MS Excel Macro which can be integrated to MS Excel environment, in order to generate an output file. This tool will allow us to transform a specific Input file into another Output file. • Input: catalog_product_option-YYYY-MM-DD • Output: The 2 files are attached, with a color mapping to recognize the columns in scope. In summary, we need to be capable to issue an export file in a specific format (see attached picture “”): • Specific Orders of the column (Green) • Suppress the duplicated values for some line items, o...

...new configs to ensure the IoT devices and CCTV systems function correctly - Add functionalities to the website that include real-time monitoring of the devices, controlling and managing the devices remotely, and enabling data analytics and reporting. - Localize the existing backend and frontend design and contents as required to make the application as a template - Required to work with my other DevOps freelancer on my pc via anydesk Ideal Skills: - Experience with IoT Deployments: A solid understanding of IoT systems, including connectivity, device compatibility, and data security. - Proficiency in IP CCTV Systems: Knowledge of IP CCTV systems, their deployment, and integration with other systems. - Real-Time Monitoring Expertise: Ability to set up systems for real-time ...

I'm in need of a proficient Excel specialist who can help create a solution for selecting rows to display in Excel with a total at the bottom. Requirements: - Proficiency in Excel and experience with creating VBA or macros - Ability to display both numerical and text data - Ensure compatibility with Windows Operating System Please note, this task calls for a clean, simple solution. Your proposal should detail your previous work with similar Excel functions.

...communication, presenting complex ideas in a concise and engaging manner. Your task is to critically evaluate the infographic you chose based on various criteria including the importance of the topic, focus, flow, organization, scope, content, quality of visual and written material, and inclusion of references. Instructions: Select an infographic from a reputable source on a topic related to pollution problems. Carefully examine the infographic, paying attention to the following aspects: Importance of the Topic: Is the topic timely, significant and relevant? Does it address a current issue or provide valuable insights? Focus: Is the infographic focused on a specific message or idea? In what ways does it effectively communicate the main point? Flow and Organization: Evaluate the ...

I'm currently experiencing a problem with my Linux-based server - NGINX refuses to restart due to issues with the configuration file that I edited directly in the main file. I ne...the configuration file that I edited directly in the main file. I need a savvy Linux and NGINX expert to help diagnose and rectify this issue, ensuring that my server can restart successfully. Skills and Experience Needed: - Proficiency with Linux OS - Expertise in troubleshooting NGINX - Experience with configuration file management - Ability to effectively diagnose and fix server problems in a timely manner. Your task will be to identify the errors in the configuration file, correct them, and provide a brief explanation of what went wrong so that I can avoid similar issues in the future.

I am having several issues with my Wordpress websit, Elementor-based website hosted on Hostinger. The problems include slow loading time, high page size, and slow server response time, which I believe are primarily due to the presence of high-quality images, integrated videos, and complex web animations on my site. However, I'm unsure if these are the only elements causing the issue. The current loading time of the website is more than 4 seconds, significantly slower than ideal. I am seeking a freelancer who can work on these issues and enhance the performance to make my website load faster. The ideal candidate should have proven experience in: - Wordpress - Elementor - Web Optimization - Understanding of high-quality images and video optimization - Knowledge of reducing pag...

I'm in need of a data handling professional. Gig is $36 Max. I have a large excel file that houses data from multiple sources but the columns are misaligned. I want it to be organized to Name, email, city, state, phone number, additional info columns. Your task will be to: - Correctly align the columns - Merge any duplicate records Ideal freelancer would have: - A strong background in Excel - Experience in data cleaning - Proven track record of handling large datasets - A keen eye for detail to spot and fix misalignments

Looking for an experienced Excel professional who can help debug my university project. I'm currently grappling with project-related issues and need rapid assistance. Expectations include: - Rectifying the project - Delicate understanding of Excel debugging - Fast turnaround time - as soon as possible Ideal candidate should have prior experience with Excel debugging, problem-solving ability, and methodology to correct projects. Knowledge about appropriate data structures will be appreciated. Being a student's project, confidentiality will be highly appreciated.

I'm looking for a s...developer to combine around 1000 XLSX files into a single one. I need this new file to contain all the data from the original files. The Excel files have a structure where each file contains data for a different entity. The end goal is to have all this data centralized into a single document for easier management and analysis. The successful freelancer for this project should have: - Proficiency in Python, particularly in working with Excel files. - Experience in data manipulation and consolidation. - Strong attention to detail to ensure that all data is accurately captured and combined without loss. Please provide examples of your previous work in Python, particularly relating to data consolidation if p...

I have a Word document that requires a few tasks to make it more professional and accessible. - **Photo Conversion**: The photos within the document need to be converted into both tab...an intermediate level of detail. This means that the translation should accurately capture the content and tone of the original document. - **Formatting**: The document should be formatted in a standard business format. This means that the layout, fonts, and styles should be consistent and professional throughout the document. I am looking for a freelancer who has: - Proficiency in Word and Excel - Translation experience, preferable with a business background - Strong attention to detail - Excellent communication skills Please provide a quote and an estimated time for completing this project. ...

I'm in need of an efficient, digital solution to streamline our insurance quoting processes as our current method is manual. Key Features: - Quote Comparison: An element that allows for easy comparison of different quotes for the customer's selected coverage. Access: I am open to ideas for the program's accessibility. It could be a web-based platform, a desktop application, or even an Excel program. The primary goal is to transition from manual quoting to a more efficient, digital process. Ideal Freelancer: - Experience: A strong background in insurance software development and a proven track record in creating similar programs. - Innovative: Capable of suggesting and implementing creative solutions for an optimal quoting experience. - Detail-Oriented: Attentive ...

Hi Milan S., I noticed your profile and would like to offer you my project. We can discuss any details over chat.

I have a very simple web page that has a scrollable table with data. I can't copy and paste the data as a whole into excel, it's requiring that I copy each entry one by one. I'm looking for someone that can help design a simple program to automatically save all data as a csv file. Thanks

I need a data entry operator proficient with spreadsheet data entry. The work involves keying in data from scanned PDF documents into a spreadsheet. Key Requirements: - Proficiency in spreadsheet data entry - Comfortable working with PDF documents Ideal Skills: - Experience in data entry - Proficiency in spreadsheet software, particularly Excel The scanned documents will be provided to you in PDF format. I will provide clear guidelines on formatting and data entry requirements. The accuracy and efficiency in data entry is crucial for this job.

...should be a dedicated section for setting and monitoring financial goals, which can help in achieving short and long-term financial aspirations. Colorful Design: The design must be visually appealing and colorful, utilizing a palette that is both engaging and suitable for easy viewing and differentiation of categories. **Deliverables:** A fully functional digital template in editable format (e.g., Excel, Google Sheets). A user guide or instructions on how to use and customize the template. Initial design mockups followed by final design files. **Preferences:** Experience in creating financial templates or tools. Strong portfolio featuring clean, modern designs, especially those that effectively use color. Understanding of user interface design for ease of use in digital format...

I'm looking for help speeding up the load time of my WordPress website, which currently takes between 3-5 seconds to load. The most critical area to focus on is the home page....up the load time of my WordPress website, which currently takes between 3-5 seconds to load. The most critical area to focus on is the home page. I'm unsure which elements or features are causing the delay, so part of this project would be diagnosing that potential issue. Ideal candidates would be experienced in WordPress, website optimization, and able to perform diagnostic tests to identify problems. An understanding of how to make a website still look engaging while operating faster is also necessary. I need performance score in Green for mobile and desktop both on

Need an Excel VBA expert to do automate a workflow of flagging the date of the first non-zero value in a row. I'm looking for a freelancer with the following skills: - Proficient in VBA programming. - Previous experience in developing Excel automation scripts. - Able to deliver the project as soon as possible.

...layer are they using. You don't need to memorize message formats etc. No programming questions will be given on the exam. >> Transport Layer - Chapter 3 from the textbook: - Please look at basic functionality of UDP and TCP, - shown in fields of their headers, basic segment structure and connection establishment. Which one is fair, which one has congestion control? >>Network layer: Data plane: Chapter 4 - Overview of the network layer - 4.1. (all subsections within this section) - What is inside of router - 4.2 with 4.2.1 - The Internet Protocol IP: IPv4, Addressing, IPv6 and more - 4.3 - Generalized forwarding and SDN Section 4.4 - Middleboxes: Section 4.5 >> Network layer: control plane: Chapter 5 - Introducti...

I need an Excel macro developed for my employee training tracking workbook. I want to have a feature that sends email notifications to both the new hire and their manager based on the completion date of each training module. Key Requirements: - Email Trigger: The macro should send emails based on the completion date of each training module, not just the hire date. - Email Recipients: The email notifications should be sent to both the new hire and their manager. - Email Content: The email should include the name and email of the new hire, along with a list of overdue training modules. Ideal Skills and Experience: - Proficient in VBA and Excel: You should have a strong background in developing macros and automating processes within Excel. - Familiarity with Employee T...

I'm needing a seasoned professional to aid with various integral aspects of my organization's Hum...all formalities are completed and they're effectively integrated into their teams. - Performance Evaluations: Must be capable of conducting fair and thorough assessments of employee performance, ensuring that all evaluations are both accurate and constructive. Given that we are an organization composed of 50-100 employees, experience handling HR needs of similar scale is most appreciated. To excel in this project, considerable knowledge and experience in recruitment, employee onboarding, and performance evaluations is paramount. Practical understanding of recruitment through diverse channels such as conventional job portals, social media, and recruitment agencies is a...

I'm looking for an experienced Shopify developer Collaborate with UI and SEO team Improve the website’s performance Add icons and sections Add new pages to the website Implement any code Solve language and translation problems

I need a skilled data analyst to work on a large dataset in Excel. Key Responsibilities: - Sorting and filtering data: The dataset contains over 10,000 rows, so the analyst must be adept at handling large data sets. - Creating pivot tables: Organizing data is a key step in our data cleaning process. - Performing Statistical Analysis: Appropriate statistical analysis will be crucial for accurate data cleaning and preparation. Ideal Skillset: - Proficiency in Excel: The freelancer must have extensive experience working with advanced Excel features and handling large datasets. - Data Analysis Skills: The individual should be well-versed in data analysis techniques, including statistical analysis and data pr...

I'm in urgent need of a skilled Excel expert to unmerge text cells in my spreadsheet. Here's what I need: - Unmerge text cells - Format the data as requested - Complete the task ASAP The ideal freelancer for this job should have: - Proven experience in Excel - Strong attention to detail - Ability to work quickly and efficiently Please submit your proposal if you can get this done right away.

Hi Ahmed I can pay you here for that work on the 2 small excel projects

I am in need of an Excel form that will track data and facilitate scheduling. This will primarily be used by our administrative staff, so ease of use and clarity are paramount. Key Requirements: - The form will need to provide a user-friendly interface for entering data. This should be intuitive and easy for administrative staff to use without any advanced knowledge of Excel. - The form should also be capable of performing calculations based on the data input. These calculations are central to the purpose of the sheet, so they must be accurate and reliable. - Data should be stored across multiple tabs for organizational purposes. This will help ensure that the data remains clear and easy to access as the form is used over time. Ideal Skill...

...unspecified bugs/errors. The details of the issues are as follows: - Unspecific database connection issues - Pages are not loading as they should - Certain functionalities are not properly working The exact pages or functionalities affected are not clearly pinpointed yet. It's a task that requires you to have an in-depth understanding of Codeigniter, and the ability to quickly identify and resolve problems within the project. Key Skills and Experience: - Strong experience with PHP and Codeigniter framework - Advanced troubleshooting and debugging skills - Proficient in SQL and server/database connections - Ability to detect and fix broken code rapidly Kindly note, this work is time-sensitive and needs to be completed ASAP. Please bid if you are immediately available ...

...converted into an Excel table. The layout is moderately complex. Here are some additional details: - **Task**: The primary purpose of this conversion is data entry. As such, the Excel table must be an accurate representation of the information in the PDF. - **Layout**: The PDF contains multiple columns of text which need to be correctly mapped to the appropriate cells in the Excel spreadsheet. - **Verification**: After the conversion, manual review and correction are required to ensure that the data has been accurately transcribed. Ideal skills and competencies for this project include: - **Strong attention to detail**: Given the manual verification needed, an eye for detail is crucial. - **Excel proficiency**: A good understanding of Exce...

I need someone to make a calculator program for my TI-84 plus that can solve any form or variation or any version of the following problems that attached to the project so that I can plug in that type of problem and output and answer in the correct form make the program low storage! I need the program made ASAP