Data cleansing steps excelроботи
Створити таблицю Excel та внести в неї данні з касових чеків. Розбити по періодам та групам.
Потрібно написати модуль (скрипт) для оновлення цін в інтернет магазині. Періодично висилають нові прайси, з яких потрібно підтягувати нові ціни. Вибірку робити по артикулу товару. На сайті поле артикула містить також назву фірми (для прикладу Nowodvorski 65441), а у прайсі просто 65441. Прайси приходять у Excel. Інтернет магазин створений на базі CMS Drupal 7.
Ввод информации в базу, возможно Excel либо другой редактор, могу работать непосредственно с онлайн информацией
Вносити дані до таблиці Excel. Це э дуже непогана робота яку можна виконувати дуже швидко, а головне чітко і без помилок.
...to work with me to achieve great rankings. If I say something needs tweaked a bit, I expect the team to listen to my desires as long as those desires will reach the end goal. While working on the main keywords, I expect additional keyword phrases to be used in Chat GDP blog and wiki articles that would benefit the website. That way not all backlinks will be from the list of 20. We can use our excel sheet from previous projects for this. I should see a drastic increase in DA and PA of the website. Post the phrase #seoGuru so I know you read and understand and agree to these terms. Post the sentence in your bid: "I understand and agree to the terms and conditions set forth in the project description. I agree that not following instructions will be grounds for termination a...
...provide the update in excel (actual start, actual finish, actual cost), the monthly activities that needed to be updated (actual date & Cost) around 100 activities every month. Please note sometimes I need to provide you comments on the schedule update, so you need to fix the comments. I need you to update the start/finish date and insert the actual cost monthly (once every month). Plus, prepare small narrative report including some P6 PdF. I have the P6 layouts I will share with you. I have the report and layout built in already and I will share it with you. Finally, send me XER file, and Narrative report every month. It is very important you respond and communicate quickly. I can share sample I did last month as an example to show you, and you follow the same steps...
Access Points setup. Provision (x3 Test Devices) for now using the Software Management Tool. License/Registration only. Possible SSID, Security Settings, Guest/Staff SSIDs and other Wireless parameters if we need anything. The main thing is get them configured locally with the most basic setup and a Client Connection before we proceed to next steps on more devices. Omada Controller and Licenses available to manage the devices. Please only get in touch if you've set these up before. Unfortunately, I don't have enough time to start interviewing people. If you're confident enough then please get in touch. Immediate start.
I am in need of an Excel relational database. The database should have the functionality to enter values automatically from an attached worksheet. The entry of these values will be based on specific criteria, more specifically, column values. Required Skills and Experience: - Strong knowledge and proficiency in Excel - Experience in database creation, management, and optimization - Understanding of data entry and data analysis - Proven experience in creating reporting capabilities within Excel. Using the "Reference data" tab, when the value in Column B is entered in the "Example worksheet" the corresponding values should automatically populate - Tariff code, Duty rate, CPF.
LOOK AT THE FIL...arguing that information and understanding can be a powerful tool against discrimination. Your proposal will demonstrate: - Deep understanding of the problem: the struggles parolees face when trying to secure housing - Clear plan of action: how community awareness programs can alleviate this issue - Benefits: how reducing discrimination could lead to a more inclusive and supportive society To excel in this project, you should have: - Exceptional skills in persuasive writing - Knowledge of recent legislature related to housing and parolees - An understanding of discrimination in housing applications - Experience in generating community-based solutions or policies Let's build a case to uplift this marginalized group, charting a path to fair and inclusive hou...
I'm in need of an Excel expert who can help me create a sophisticated formula for data analysis. The data I'm working with is moderately complex, involving multiple variables. It's all housed in Excel spreadsheets. Ideal Skills and Experience: - Proficiency in Excel, with a focus on complex data analysis - Experience in creating advanced formulas for data manipulation - Strong understanding of data structures in Excel and how to work with multiple variables - Previous projects involving statistical analysis would be an advantage I'm looking for someone who can not only create this formula, but also explain its function and how to adjust it for future data sets. Please provide examples of similar ...
I'm in need of a Java developer to create a standalone application for a small school. The application will be used to manage student records, various school resources, and facilitate communication with parents. Key Features: - Student Records: The application should be able to manage and track student progress through interactive line charts. - School Resources: The app should also ...Java development, previous experience in creating similar applications, and are confident in managing school resources and building a parent communication portal, feel free to bid on this project. I would need a preliminary discussion to assess the possible architecture/technologies. The initial bid if for the first module (main page, students list, DB, add/edit/delete students, load student data...
I need an intricate Excel model to calculate a cumulative threshold commission scheme, tailored to three varying levels of seniority: Junior, Mid-level, and Senior. The model needs to be exceptionally flexible and versatile to allow for easy manipulation and scenario planning. Key Requirements: - Create a multi-level commission scheme: The model should have different commission percentages for each level of seniority. - Cumulative Threshold Calculation: Incorporate a mechanism to calculate cumulative thresholds. - Revenue Generation Calculation: Develop an accurate formula that calculates the revenue generated. - Flexibility in Threshold Percentage: Ensure that the threshold percentage can be flexed. - Cash Retained in the Business: The final model should account for cash retained...
I am in need of an expert in Adobe InDesign Plugin customization. The exact version of the Adobe InDesign I am using will be revealed once we initiate the project. Primarily, I am expecting the following services: - Specific steps and instructions to customize my Adobe InDesign plugin to match my personal requirements. - Potential enhancements and added features to the plugin based on your wealth of experience in this sphere. Although I have skipped detailing specific functionalities or improvements I desire, once we start the project I will provide all necessary specifics. There is no strict timeline for project completion. I am more concerned with achieving the perfect result than rushing the process. However, a proposed schedule would still be appreciated. Ideal candidate...
I need an expert in Excel spreadsheet and dashboard creation to help me with a project related to the management of properties. The project involves the following tasks: - Data analysis - Formulas and calculations - Data visualization The data to be used in this project will mainly revolve around a situation room containing property under management status and updates. Specifically, the dashboard should track and monitor the following key metrics: - Rent collection and payout status - Tenant and business complaints - Contacts details - Contracts status - Property profits - Property location - Owner notes - Comments If possible to have it as geolocation kml as a copy I'm looking for someone with strong experience in creating dashboards and spreadsh...
...web application developer with expertise in using Python for backend development, JavaScript and HTML for frontend. Key Components: - Backend programming using Python - Frontend programming implemented with JavaScript and HTML Key Functionalities: - Database Integration: The software developer should be able to create a seamless link to an existing database and enable secure data exchanges. there is already excel .xlsx file in the folder - API Integration: The project includes integration of specific APIs to provide essential functionality for the Web Application. Purpose of the Project: - The main goal for this project is to develop a functional web application and host it either on a server or GitHub. The application isn’t static and employs IT-technical featu...
I have the attached images , I need it to be in excel form.
Bonjour, j'aurai besoin de récupérer la liste exhaustive des garages automobiles référencés sur un site internet () qui permet de géolocaliser des garages via code postal / ville. Les info à recueillir sont : nom du garage / adresse complète avec champs Adresse / Code Postal et Ville séparés ; autres champs : SIR...sur un site internet () qui permet de géolocaliser des garages via code postal / ville. Les info à recueillir sont : nom du garage / adresse complète avec champs Adresse / Code Postal et Ville séparés ; autres champs : SIRET / adresse e-mail / téléphone / réseau. En option les coordonnées GPS si disponibles. La restitution devra idéalem...
I am in need of a proficient data entry operator, for a smaller task of less than 100 entries. The data will be provided to you in the form of scanned documents and you will be required to interpret and enter this data accurately into an Excel worksheet. - You should have experience with data entry from scanned documents into Excel and attention to detail is of utmost importance here. - Understanding of Excel basics is also required for successful execution of the task. - The format of data delivery will be an Excel worksheet. Proficiency in English and a strong attention to detail would be ideal attributes for this task.
We are looking for a remote operations expert and virtual assistant to join our team. Your primary tasks will revolve around posting job openings and managing LinkedIn messages. Key Responsibilities: - Post job openings on LinkedIn on a daily basis. - Manage LinkedIn connections and messages efficiently. Ideal Candidate Skills: - Strong research and communication skills...managing LinkedIn messages. Key Responsibilities: - Post job openings on LinkedIn on a daily basis. - Manage LinkedIn connections and messages efficiently. Ideal Candidate Skills: - Strong research and communication skills. - Self-motivated and able to work well independently. This task if good for those who are starting out as freelancers. We encourage you all to apply as we will provide all the steps needed ...
I'm in need of a skilled Excel professional to assist with data analysis tasks. The primary focus will be on trend analysis and results should be presented in the form of detailed reports. Key requirements include: - Proficient in data analysis using Excel - Experience with creating reports - Attention to detail - Ability to communicate complex data in a clear and concise manner Please only apply if you have experience in trend analysis and report generation using Excel.
As a sysadmin developer, I'm in need of an asterisk specialist to build a Docker Compose script or a bash script for an interactive vocal server. This project is multifaceted, carrying out outbound calls and saving responses in a database. Key responsibilities are: * Creation of an Interactive voice response (IVR) system. * Outbound calling function connected with my API for automated sched...scheduling of phone calls. * MySQL database integration to securely store the recorded responses. For this assignment, it would be ideal if you have proficiency in using Asterisk, Docker Compose, API integration along with comprehensive database management skills It would be a cherry on top if you have prior experience constructing interactive vocal servers. Let's connect to discuss th...
I am in immediate need of an Excel specialist who is well-versed in formula troubleshooting and fixing. There are 4 formulas that require attention; unfortunately, I am unable to enumerate them as I skipped that information. However, here's what I can provide: - Detailed description of how each formula should function - Expectations for the fixes I'm looking for individuals who are confident they can rectify the issues and can offer neoteric solutions. This project requires more than just experience, a resourceful approach to problem-solving is necessary. The application must include: - Detailed project proposal The proposal should provide clear insight into your troubleshooting steps, planned adjustments, and method of testing the new formulas. Time effic...
I am looking for a freelancer to assist me with a typing project. The project involves typing more than 100 pages of PDF documents. Requirements: - Proficient in typing and attention to detail - Ability to follow instructions and work independently - Experience with typing PDF documents is preferred but not required Specifics: - The documents do not require any specific formatting and can be typed in any standard format. - The freelancer has the freedom to choose the most suitable formatting for the documents. Skills and Experience: - Excellent typing speed and accuracy - Strong attention to detail - Ability to work independently and meet deadlines Please provide a sample of your previous typing work. Thank you for your interest in this project!
I need a professional who can help me solve some critical SEO issues that my website is facing with Google indexing. Key Responsibilities: - Identify and resolve crawl errors that are preventing my site f...results. - Analyze the root cause of these issues and provide a solution that will ensure my website is effectively indexed on Google. Ideal Candidate: - Proven experience in resolving SEO issues, particularly with Google. - Familiarity with Google Search Console and other SEO tools. - Strong problem-solving skills and attention to detail. - Excellent communication to explain the issues and required steps clearly to me. The website has been experiencing these issues for the past 1-3 months. I'm looking for someone who can start on this project immediately and provide a qu...
I am seeking a developer to create an Excel-based order placement tool for TradeStation, utilizing EasyLanguage. This tool will be designed to execute trades based on alerts from a specific indicator and strategy. Key functionalities should include support for OCO (One Cancels the Other), OSO (One Sends Other), and Basket orders. This is a fixed-price project. Payments will be released upon successful completion of predefined milestones. Please contact me if you're interested in this opportunity.
I'm looking for a skilled developer who can create a web application that can read data from multiple sources like Excel files, XML files, and APIs, and then match, aggregate, and save this data to a database. Requirements: - The web app should be able to read data from Excel files, XML files, and APIs. - The application should have the capability to match and aggregate data from these different sources based on specific fields, data types, and unique identifiers. - The end goal of the data matching and aggregation is to save the data into a database. Ideal candidate should: - Have experience in developing web applications that work with various data sources - Be proficient in database management and data a...
I'm seeking a proficient Excel VBA coder to create a system that automates data entry from Excel files. The task involves: - Creating a VBA function that can input data automatically into my current system. - Implementing a data sorting feature as part of the data entry process to ensure that all data is easily read and interpreted. The ideal freelancer should have the following skills and experience: - Proficiency in Excel VBA - Experience with automated data entry - A solid understanding of data sorting techniques. This project requires precision and attention to detail. It should not only meet the needs listed above but also enhance data accuracy and save time.
...key asset in question is a CE-marked machine learning application. Our primary objective is to showcase to stakeholders the existence of a comprehensive IP strategy. Nonetheless, we must navigate certain restrictions such as the inability to patent algorithms in the UK, a point that has been extensively discussed in previous IP consultations. It's worth noting that the client has already taken steps to trademark their logo, and their processes are carefully guarded trade secrets. The main challenge we face is that many investors are eager to examine the inner workings of the machine learning solutions. In this regard, the inclusion of an IP strategy in the document can provide the necessary assurance and confidence to all interested parties. Moreover, by outlining the str...
I'm searching for a proficient developer to create a trading bot that operates on the Dhan platform. This bot must be integrated with Excel. Key Features: - It should have the functionality to automate trades based on calculations of quantities on a predefined Stop Loss (SL). - Its operation will involve using fixed quantities for all trades, regardless of SL level. Ideal Skills: - Experience in bot creation. - Knowledgeable about the Dhan trading platform and Microsoft Excel. - Strong understanding of trading algorithms and risk management. Your bid will be more competitive if you have previously done similar projects and can show a portfolio or examples of your work.
I am seeking an experienced data entry specialist to assist me with both digital and manual input into Microsoft Excel. The ideal freelancer will provide assistance with data extraction, cleaning, and verification to ensure accuracy and consistency of the data. Skills and experience required: - Proficient in digital and manual data entry - Expert in Microsoft Excel - Experience in data extraction, cleaning, and verification - Strong attention to detail - Ability to handle large amounts of data. The primary objective of this project is to manage and organize data efficiently. I'm expecting a high level of precision on the data entered. The candidate should be able to demonstrate experience in handling both digital...
...an oil & gas upstream company seeking a skilled developer to create a comprehensive library of automation tools. These tools will be designed to handle a wide range of tasks from data analysis to report generation and workflow management. The goal is to fully automate these processes to boost our operational & technical efficiency. project SOW: 1- build excel sheet list of company support of oil & gas upstream automation processes. first from UAE local company than find global company (list include: company name & type of tools service & description service tools & contact (website) 2- check the attachment excel, you will find the overall job & activity in oil company & type of tools need & find more activity + tools support. 3-...
Job: Change field names in vb source code according to Excel table (from/to)
...containing a mix of numerical and textual data, meant for meeting diary maintenance. The task involves meticulous conversion of this document into a tabular format. Key requirements: - Proficiency in handling PDF documents and excel tables. - Understanding of the data categorization to create efficient tables. - Excellent attention to detail to ensure the accurate alignment of numerical and textual data as per the PDF. - Ability to deliver the project within a decided timeline. Ideal candidate: - Has experience converting PDFs to Excel or similar table formats. - Can handle mixed data (numerical and textual). - Excellent organizational skills for data arrangement. - Background in data management preferred but not mandatory. ...
Challenging opportunity for a skilled Excel Specialist. The details of the tasks are undefined due to insufficient information from the client. Candidate must be proficient in: - Data organization - Formula creation - Data analysis The size of the dataset is unknown and could range from small to large. You are expected to be able to handle any data size comfortably. While the type of analysis isn't specified, you should be skilled in: - Statistical analysis - Trend analysis - Financial analysis In summary, I need an Excel maestro who can confidently navigate any project, no matter how ambiguous. Your expertise, flexibility and adaptability will be essential for this project's success.
Challenging opportunity for a skilled Excel Specialist. The details of the tasks are undefined due to insufficient information from the client. Candidate must be proficient in: - Data organization - Formula creation - Data analysis The size of the dataset is unknown and could range from small to large. You are expected to be able to handle any data size comfortably. While the type of analysis isn't specified, you should be skilled in: - Statistical analysis - Trend analysis - Financial analysis In summary, I need an Excel maestro who can confidently navigate any project, no matter how ambiguous. Your expertise, flexibility and adaptability will be essential for this project's success.
Need someone who can create a complete video course for teaching excel from beginner level to expert level. Videos can be short as 2 minutes each to 8 minutes maximum. Need high quality videos showing right from how to open an excel sheet on a computer to on how to write real tome formulas.
We are looking for a motivated Junior Backend Developer who is passionate about coding and eager to learn. In this role, you will have the opportunity to work on exciting projects, collaborate with a talented team of developers, and gain valuable experience in backend development. If you have a strong foundation in programming and...development concepts and principles. Proficiency in at least one backend programming language (e.g., Python, JavaScript) and related frameworks. Familiarity with database management systems (e.g., SQL, NoSQL) and ORM libraries. Good problem-solving skills and attention to detail. Ability to work effectively in a team environment and communicate technical concepts clearly. How to Apply: Follow the Steps given at trinc(dot)in/jobs/1 Thanks, and Regards ...
I am looking for a proficient Excel expert who is highly experienced in financial data analysis. You will primarily be tasked with conducting comprehensive revenue and expense analysis. The ensuing breakdown of financial information will allow us to understand and evaluate our company's financial health. Ideal Skills and Experience: - Deep understanding of Excel, particularly in data analysis - Expertise in Financial analysis, specifically revenue and expense analysis is a must - Excellent in applying Excel for financial forecasting - Capacity to design efficient spreadsheets that emphasizes readability and ease of use - Fluency in formulating functions to automate data computations.
As a budding R&B/hip-hop artist, I'm looking for an experienced individual to guide me through the next steps of my music career. I've officially released close to 50 songs, but they haven't gained the traction I was hoping for. In particular, I need help with: - **Social Media Promotion**: I'm active on Instagram, Facebook, and TikTok, posting daily. However, I believe there is still untapped potential in promoting my music on these platforms. I'm looking for strategies to increase my engagement, reach a wider audience, and eventually go viral. - **Artist Branding**: I understand the importance of having a unique and consistent brand as an artist, but I'm struggling to define mine. I need guidance on how to create a strong personal brand that res...
As a business owner, I need a proficient and efficient freelancer who can manage my company's financial data in Excel format. Key responsibilities: - Accurately entering, managing, and updating Income and Expense statements daily. - Ensuring data is correct, up-to-date, and accessible. Ideal skills: - Proficiency with Microsoft Excel - Strong attention to detail - Experience with financial data management Please note, this role requires daily work and a consistent, reliable, and professional approach. Experience in financial data entry is preferred but not mandatory.
I'm seeking an experienced an...Optimization: I expect you to identify and integrate effectively targeted keywords, improving the chances of reaching the desired audience. - Content Optimization: Your job will also be to optimize site content to ensure top-notch quality and SEO efficiency. As part of this project's application, I am specifically interested in receiving detailed project proposals. Please outline your strategic steps and intended actions that demonstrate how you plan to drive our goal of significantly increasing organic traffic. Ideal applicants will have proven experience with successful on-page SEO campaigns and an understanding of SEO best practices. Be ready to troubleshoot SEO issues and augment our website's SEO content. Looking forward to our ...
We are looking for a remote operations expert and virtual assistant to join our team. Your primary tasks will revolve around posting job openings and managing LinkedIn messages. Key Responsibilities: - Post job openings on LinkedIn on a daily basis. - Manage LinkedIn connections and messages efficiently. Ideal Candidate Skills: - Strong research and communication skills...managing LinkedIn messages. Key Responsibilities: - Post job openings on LinkedIn on a daily basis. - Manage LinkedIn connections and messages efficiently. Ideal Candidate Skills: - Strong research and communication skills. - Self-motivated and able to work well independently. This task if good for those who are starting out as freelancers. We encourage you all to apply as we will provide all the steps needed ...
I'm seeking an experienced Excel VBA expert to help me automate some basic, repetitive data entry and formatting tasks. Key Requirements: - Automate basic data entry and formatting tasks in Excel - Develop VBA script to ensure automation runs smoothly Ideal Skills and Experience: - Proven experience in developing VBA scripts for Excel - Strong understanding of Excel functions and data formatting - Ability to create automation systems that run seamlessly without user interaction Please note, no user interaction is required for this project. The VBA program should be designed to run automatically once set up. This task is relatively simple but needs to be executed precisely and efficiently. Looking forward to working with a professi...
I'm seeking an expert in Excel and VBA who can work on an an existing financial model. The primary tasks will involve optimizing formulas, macros, and implementing data validation. I am looking for an hourly regular working engagement where the person will sit with me from time to time online and solve for things one at a time. I cant share workbooks as I have some IP related restrictions so person will have to work on my system, remotely. For Faridabad, Haryana based freelancers, we can do it in physical mode too. Key areas of focus will be: - Refining Formulas and Calculations. - Improving Data Organization and Management - Managing , improving the existing VBAs
I'm need of an expert in Excel, particularly with a strength in creating complex calculation systems, for the task of data keeping. Key Tasks: - Understand and implement a data structure for holding financial data - Build a system for complex calculations within the excel sheet Qualities Needed: - Proficiency in Excel - Experience dealing with financial data - Ability to design and incorporate complex formulas for calculations - Analytical thinking The Excel sheet will specifically monitor and report Budget versus Actuals, so experience in handling these aspects are an added advantage. The goal is to have a seamless, reliable system for my financial data.
I'm in need of a skilled professional who can diligently carry out a large volume of data entry involving text, numbers, and images. The data is to be accurately entered into an Excel spreadsheet. Ideal Skills: - Proficiency in Excel - Accuracy in data entry - Ability to handle large volumes of data - Familiarity with processing text, numeric, and image data The right freelancer should have substantial experience handling this type of project and able to demonstrate precision and attention to detail.
I'm seeking an experienced Brawl Stars coach who can help me elevate my gameplay to the next level. Having played on both Android and iOS platforms, I've developed a decent understanding of the game but I want to push my skills further to become a formidable competitor. **What I'm Looking For:** - **Expertise in Brawl Stars:** Someone who has a track record of high achievement in the game and can provide proof of their skills. - **Coaching Ability:** Not just a great player, but someone who can teach. You should be able to analyze my gameplay and offer actionable advice. - **Focus Areas:** Since I'm looking to generally improve my gameplay, having a broad understanding of key strategies, character usage, and gameplay mechanics is essential. **Expected Outcomes:** - ...
...LinkedIn advertising, backed by strong skills in tracking technologies and data analytics to optimize campaign performance. Immediate Goal: Boost inbound calls and bookings via targeted, technologically advanced advertising campaigns. Ensure these campaigns resonate with our target audience to drive immediate action and long-term engagement. Key Responsibilities: Advanced Google Ads Management: Strategy and Setup: Provide a detailed description of your approach to structuring our Google Ads account. Explain how you will develop campaigns, ad groups, and keyword strategies. Include your methodology for leveraging Google's latest features like responsive search ads, AI-driven bidding strategies, and real-time data for adjustments. Innovative Features Usage: Detail...
...LinkedIn advertising, backed by strong skills in tracking technologies and data analytics to optimize campaign performance. Immediate Goal: Boost inbound calls and bookings via targeted, technologically advanced advertising campaigns. Ensure these campaigns resonate with our target audience to drive immediate action and long-term engagement. Key Responsibilities: Advanced Google Ads Management: Strategy and Setup: Provide a detailed description of your approach to structuring our Google Ads account. Explain how you will develop campaigns, ad groups, and keyword strategies. Include your methodology for leveraging Google's latest features like responsive search ads, AI-driven bidding strategies, and real-time data for adjustments. Innovative Features Usage: Detail...
