How to normalize data in excelроботи
Створити таблицю Excel та внести в неї данні з касових чеків. Розбити по періодам та групам.
Потрібно написати модуль (скрипт) для оновлення цін в інтернет магазині. Періодично висилають нові прайси, з яких потрібно підтягувати нові ціни. Вибірку робити по артикулу товару. На сайті поле артикула містить також назву фірми (для прикладу Nowodvorski 65441), а у прайсі просто 65441. Прайси приходять у Excel. Інтернет магазин створений на базі CMS Drupal 7.
Ввод информации в базу, возможно Excel либо другой редактор, могу работать непосредственно с онлайн информацией
Вносити дані до таблиці Excel. Це э дуже непогана робота яку можна виконувати дуже швидко, а головне чітко і без помилок.
I am looking for an experienced Data Analyst who can focus on identifying patterns and making data-driven decisions. I have several types of data to analyze. I require an expert who is versatile and adaptable, capable of handling different types of data sets. I have yet to determine the specific data types to be analyzed. Skills and Experience Required: - Extensive experience in data analysis - Familiarity with various data types - Ability to make data-driven decisions - Expertise in spotting patterns in data sets - Versatility in handling different data sets
I'm seeking a proficient Excel user to oversee daily updates to my inventory data. This includes adding new products, updating stock levels, and modifying product details. The inventory data should be updated every day without fail. Responsibilities: - Daily addition of new products - Regular changes in stock levels - Daily modifications of product details Ideal Skills: - Proficiency with Excel - Attention to detail - Inventory management experience - Fast and efficient data entry skills - Ability to work daily without supervision This role demands diligence and speed, but also precision. If your skills align with these requirements, I would love to hear your plan of action for managing this task. Experi...
I am in urgent need of a professional well versed with Excel Operations to help typify a vast array of data into an Excel sheet. The data includes: - Text - Dates - Numbers A key part of this project involves adhering to specific formatting requirements, which include: - The application of currency formatting - Utilizing bold or italic text when necessary - Highlighting certain cells This is a time-sensitive project that requires immediate attention, therefore the ideal candidate should be able to commence work ASAP. Your experience with Excel, data entry, and attention to detail will be highly beneficial in executing this project.
...for a freelancer who can download pictures from an excel list that will be provided (see 2 attachments). Following are the specific project requirements: We need those pictures in 2 separate folders (f.e. zip or rar file), one for each excel list. All pictures must be saved with Superaction excel file Pictures must be saved with their code. f.e. (code is in column A). If in Column F there are more than 1 pictures, then save 2nd, 3rd etc. pictures like: , adiddv0318_4.jpg... Always in Column F (URL's for download), pictures without _a, _b... are the main picture (therefore must be saved like ). Pictures with _a, b.. etc. must be save as 2nd, 3rd ... (, ). If in Column F there is no picture without _a, then use the
I require a professional with proficiency in Data Entry and Excel. Your task will be to type data that includes text, numbers, and dates into an Excel sheet that has more than 500 rows and columns. It's crucial for the selected freelancer to have acute attention to detail, to maintain the accuracy of the data. Experience in dealing with sizable Excel projects will be favored. Ideal Skills: - Proficiency in Excel - Fast and accurate typing skills - Experience in handling large data sets - Strong attention to detail - Good understanding of different data types such as text, numbers, and dates.
I am seeking a professional freelancer to assist with typing data from a PDF file into an Excel spreadsheet. The ideal candidate for this job should have: - Strong typing and data entry skills - Previous experience with PDF and Excel - Attention to detail as the data contains textual information - Ability to deliver work in a timely manner. Your primary task involves converting the textual information contained in the PDF into editable text format while ensuring data accuracy. To succeed in this job, familiarity with Microsoft Excel is a must as the typed data should be well-structured in an Excel spreadsheet.
I need an Excel sheet created that includes dates only. Ideal Skills and Experience: - Proficient in Excel - Skilled in data entry - Attention to detail - Familiarity with date formatting - Ability to follow instructions accurately
Будь ласка, зареєструйтесь або увійдіть в систему для перегляду деталей.
...seeking a seasoned Excel macro expert with an efficient approach to task automation specifically for performing calculations. Key Requirements: - Expert-developed Excel macros that automate repetitive tasks, making my workload more manageable. - The macros created should focus on performing calculations, thus, speed and precision are of the essence. - Due to the nature of the project, potential contractors must understand Excel inside out, especially on how to configure and troubleshoot macros. No specific type of calculation was specified, therefore experience with a wide range of calculations from basic arithmetic to complex equations is integral. Your problem-solving skill will be a plus point as the ability to und...
I have a one-time project that involves converting a PDF file with tables into an Excel spreadsheet. The main purpose of this conversion is to extract specific information from the tables. Key Requirements: - Convert a PDF file containing tables into an Excel spreadsheet - Extract specific information from the tables Ideal Skills and Experience: - Proficiency in Python - Experience with PDF to Excel conversion - Ability to extract information from tables If you have the skills and experience I'm looking for, please submit your proposal.
I am looking for a professional with expertise in data entry and PDF conversion to perform an error-free conversion of my text-based PDFs into a spreadsheet format. Accuracy is essential in this task. Ideal Skills: • Proficiency in data entry • Experience with converting PDFs to excel or similar formats • Meticulous attention to detail ensuring 100% accuracy Responsibilities: • Convert text-based data from PDFs to spreadsheets error-free • Maintain record consistency, structure, and format during conversion • Verify the converted data for accuracy The successful candidate will have ample experience with data entry and PDF conversion, boasting a track record of impec...
I am in need of an individual to assist in extracting email addresses of all child care centers and compiling them into an Excel spreadsheet. Key project details: - Purpose: The extracted email addresses will be used as part of a contact database. - Usage: The contact database will primarily be used to offer services or products to these child care centers. Ideal skills and experience: - Proficient in data extraction and Excel spreadsheet handling. - Ethical data practices - the extraction must be legal and compliant with GDPR and any other relevant regulations. - Previous experience in email extraction or database creation would be a definite plus. This project will require a keen attention to detail ...
I need a freelancer to scrape text data from a PDF and output it into separate cells by paragraph in an Excel document. Key Requirements: - Extract and convert text data from a PDF into a structured Excel file. - Each paragraph should be in a separate cell in the Excel sheet. Ideal Skills and Experience: - Proficiency in PDF scraping and Excel data entry. - Attention to detail to ensure accurate data transfer. - Understanding of text formatting to ensure the data is organized accordingly in the Excel sheet.
I'm in need of a top-notch data entry freelancer who can accurately input data into Microsoft Excel. Working primarily with text and numeric data, the project simply requires a keen eye for detail, a high level of accuracy, and exceptional Excel skills. It's crucial to note that there will be minimal data cleansing involved - the data should just be entered as it is. This job will suit someone who: * Has proven experience in data entry * Is proficient in using Microsoft Excel * Office365 online documents editing * Can ensure accuracy with minimal supervision * Extreme organised * Perfect English written and spoken.
I need assistance with EXCEL- Working with Multiple Worksheets and Workbooks The task is quite urgent, so I need someone who can start right away and complete the project in a timely manner.
I need assistance transferring data between Excel sheets Key requirements: - Data transfer: I'm unsure if this needs to be a manual or automatic process. I'm open to suggestions that will make the process efficient and error-free. - Randomising 'Task Types': This column needs to be randomized each time data is transferred. The 'Task Types' should be selected from a specific range of values. Ideal skills for this job: - Proficiency in Excel )
I need an Excel expert to review and make suggestions for how they would improve a register workbook which I have already created for tracking Quality System Document and Record Control. The register is a template which my quality systems consulting customers use to track procedures, policies, and work instructions, as well as active and archived records. I expect the expert to have a strong understanding of Excel, formulas, functions, and design of excel workbooks so that they look professionally made and are also easy to use (and perhaps also customise if required). The final product should look professional and offer an effortless way to track quality system document controls as well as support the managers and users of the ...
...with data from an Excel sheet. Key Requirements: - The application should be accessible online and be compatible with major browsers. - It should provide an interface where I can upload an Excel sheet with the necessary data. - The application must be able to recognize specific tags in a template and replace them with corresponding data from the Excel sheet. - should work with PDF , Word document - Document / Arrangement Formatting MUST be maintained - Able to export into doc or pdf Experience and Skills Required: - Proficiency in web development, particularly in creating online applications. - Strong experience in working with Excel files and data extraction. - Knowledge of automation te...
...Senior Web Designer to join our team on a freelance basis, with a potential pathway to full-time employment. Ideal candidates will have extensive experience in designing scalable, high-traffic websites and a portfolio that demonstrates their capability in crafting complex, user-friendly designs. Key Requirements: Proven experience in designing sophisticated websites at a senior level. Expert knowledge of UX/UI principles, responsive design, and current web technologies. Ability to collaborate closely with our development team to ensure seamless implementation of designs. Strong communication skills and a proven track record of meeting deadlines. This role is suited for individuals who excel in a dynamic, fast-paced setting...
I am seeking an experienced photo editor who can help elevate my personal photos. The ta...experienced photo editor who can help elevate my personal photos. The tasks required include: - Basic retouching to improve overall image quality. - Background removal to highlight the photo's main subject matter. - Lighting adjustment to amplify the mood of the image. Knowledge of JPEG format is necessary as all images come in this format. Ideal candidates will have a keen eye for detail and the ability to enhance images in a tasteful manner. A sensitivity to personal photography and an understanding of image composition will also be highly regarded. The aim here is to ensure every image conveys the story beautifully. If this soun...
I'm in need of a professional's help to create static line graphs in Microsoft Excel for scientific data presentations. Ideal Skills and Experience: - Proficiency in using Microsoft Excel to create line graphs - Experience with scientific data visualization - Understanding of best practices in graph creation Additional notes: - The data for the graphs will be provided to you - The graphs are expected to be clear, accurate and visually appealing - Familiarity with scientific terminology is a plus, but not strictly required.
I'm looking for a talented professional who can create a substantial number of quality backlinks for my website. Key Requirements: - The primary aim is to improve website visibility. The backlinks should therefore support this goal directly. - You're encouraged to get creative and leverage your expertise to deliver the best results possible. Ideal Skills & Experience: - Proven experience in creating backlinks - Understanding of SEO best practices - Strong communication skills - Ability to work within a limited budget The type of websites the backlinks should come from is not specified, so you have the flexibility to make choices based on your expertise and experience. Your work will be highly appreciated and you can expect awes...
Seeking a skilled and experienced Data Analyst to sift through unspecified data sources. As the data type, desired insights, and current storage system have not been specified, I am looking for someone highly flexible and adept at handling all types of data, formats, and analysis needs. Ideal Skills and Experience: * Proficiency with Excel, database, BigQuery, JSON, and CSV file formats * Experience working with sales data, financial data, and customer data * Ability to identify sales trends, perform customer segmentation, and analyze profitability Please note that the specifics will be provided upon project commencement. We look forward to hearing from data analysts who can adapt to different ...
...working with an existing Excel spreadsheet that contains date data. I need help with sorting and filtering these dates. PROBLEM: I have different data set (mm/dd/yyyy and dd/mm/yyyy) in the same column exchanging every 100rows or so...data set is about 70000rows I dont want a solution I want you to teach me how to resolve this because this is something ill do for some time now and i need to know how i can do it by myself. Key Requirements: - Sorting and filtering the dates in the spreadsheet effectively. - Ensuring the sorted and filtered data can be used for additional calculations within the same spreadsheet. Ideal Skills and Experience: - Advanced proficiency in Excel, with a strong ...
I'm seeking a skilled freelancer to assist me with basic data analysis in Excel. Ideal Skills and Experience: - Proficiency in Excel - Experience with basic formulas and functions - Strong attention to detail - Good communication skills
I am aiming to incorporate and enhance my Parent Company's policy and processes on IT asset management, with particular focus on the documentation process and IT Asset Management Workflow diagram (From registering the asset to retiring the asset). Key deliverables: 1. Provide a document that lists all relevant terminology for IT Asset Management, including formal definitions and simplified definitions. These definitions must be aligned to Parent Company's terminology. 2. Provide a diagram that explains the desired lifecycle of IT Asset Management and how Cybersecurity, ICT Operations, Data office and Business Unit fit into this flow via clear RACI. This must aligned to Parent Company's lifecycle descriptions. 3. Complete an exce...
I am looking for a proactive and detail-oriente...for a proactive and detail-oriented lead generation assistant to help me with data research and email outreach/follow-up. The main focus will be on the B2B sector. Key Responsibilities: - Conducting thorough data research to find relevant contacts and organizations in the B2B sector - Managing email outreach and follow-up with these leads Ideal Skills and Experience: - Proficiency in data research and collection to identify potential leads - Experience in email outreach and follow-up to engage and nurture leads - A good understanding of the B2B industry and its dynamics - Ability to deliver leads in an Excel/CSV format If you have a track record ...
My company and I are looking for an experienced freelancer to develop an Excel tool for Electrical energy savings. The tool should be able to calculate energy savings, graphically represent data, and compare different scenarios all according to the formulas and calculations I will provide. We prefer to communicate technical details via telephonic discussion. The freelancer should have experience creating similar tools and should present a proposal for development.
croatian text below (please translate it in your language if necessary) Mi trazimo freelancer-a koji ce definirati i izvesti tendera u Europi za igradnju jedne kuce sa tri stana i 3 PGM u Hrvatskoj - Grad Zagreb. Sudjelovanje pri raspisu natječaja i ugovaranju radova uključuje: - Priprema natječajne dokumentacije (nacrta i troškovnika) - Ispitivanje i vrednovanje ponuda te izrada usporedbe cijena prema pojedinačnim poslovima - Sudjelovanje u pregovorima s ponuđačima i izrada prijedloga za ugovaranje - Sudjelovanje pri odabiru izvođača Format predaje: Dokumentacija u excel i pdf formatu
To create a canvas powerapps screens similar to the Excel provided to Florian.
I need a skilled Power BI developer to support me with key aspects of my project. Your tasks will include: - Data modeling and visualization - Creating insightful dashboards - Generating detailed reports You'll need to connect and work with data from Excel spreadsheets and SQL databases. So, competency and experience with these data sources is crucial for this project. I'm looking for an intermediate Power BI developer. You should have a solid understanding of Power BI functionalities and the ability to translate data into clear visual insights.
As one aiming to maximize my productivity, I'm in need of a proficient data entry professional who can assist in data transcription, processing, and validation. This task revolves around: - Handling a medium scale data volume, approximately between 100-1000 records. - Processing data I have currently stored in an Excel Spreadsheet. Freelancers with the following skills are ideal for this job: - Expertise in Excel and data entry practices. - Experience in data validation. - Strong attention to detail. Your primary responsibility would be to ensure the accuracy and usefulness of my data efficiently. Your proficiency and speed are key to the success of t...
My project revolves around the conversion and enhancement of specific JPEG images. The enhancements needed pertain to retouching, color correction, background removal in addition to change of format. Ideally, I require someone skilled in photo editing and proficient in using Excel, to transcribe these reformatted images into an Excel document. I would like my JPEGs converted into the Excel , if you have a keen eye for detail and the necessary expertise, I would love to hear from you.
Looking for a Python & Active Directory Expert to create a script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, group policy etc. and export to a MS Excel File. More information attached.
I need assistance with data cleaning, data analysis, and pivot table creation in Excel. Project specifics: * Work with a large dataset containing more than 1000 rows * Data type: Mixed (both numerical and text) Ideal freelancer skill set: * Proficiency in Excel data management and analysis * Proven experience with pivot tables * Strong understanding of data cleaning processes * Attention to detail and maintaining accuracy Great results in this complex project will open up opportunities for longer-term work in our data management and analysis team. Are you the Excel expert I'm looking for?
Hello, I'm in need of a developer capable of creating a tool to store data in bulk and automatically remove duplicates each time new data is added to the existing database. Storage of large datasets: The tool should allow for storing a large quantity of data. Duplicate removal: It should be possible to remove duplicates in the Excel files to maintain a clean and organized database. In addition to these features, it would also be necessary to be able to edit data in the tool and export the changes made to an Excel file. Furthermore, an archiving feature would be desirable, allowing for downloading of the used data for future reference. I would ...
I'm seeking a proficient AI researcher. The main focus is to research all the AI tools and suggest best tools for the following activities, 1. PPT, Excel & word document creation 2. Prompt engineering for Chatgpt & similar 3. Project management : Auto schedule creation, task tracking, followups, resource management, report generation, auto reply for emails, risk management 4. Sentiment analysis of text 5. Engineering document creation : System Requirements, SW Requirements, Architecture creation, software detailed design, software coding, Test case creation. 6. Images, Animation creations Your primary task will be to understand different AI tools, create a list of all the AI tools, its corresponding usage for both free & paid tools. The industry targ...
We are in search of a meticulous researcher adept at data compilation within Excel sheets. Your primary task will involve sourcing, researching, and organizing data for a designated list of company names provided. The role entails gathering contact details and accurately inputting them into the provided spreadsheet under relevant column headings such as email, phone number, address, country, buyer name, buyer Linkedin profile link and buyer contact number. The scope of the project requires data collection for a minimum of 1000 companies, predominantly from the United States, along with other specified countries. Upon data entry, you will be responsible for sorting and categorizing companies based on size (large, medium, small), while ensuring the ...
I'm seeking a proficient PowerBI expert who can create a simple dashboard with 2 tables and 6 card. Data is in excel and requirements will be shared in a doc file with all details. Needs to be build today.
...Google Excel expert to assist me in refining and optimizing my current Excel tables for business purposes. Key Requirements: - **Formatting**: I need assistance in improving the aesthetic appeal and readability of my tables. This includes changes to font style and size, cell borders, and background color. - **Formulas**: The expert should be proficient in implementing essential formulas such as Sum, Average, and Count. They will play a crucial part in calculating and managing data effectively. - **Data Validation**: I need guidance on implementing data validation processes to ensure the accuracy and consistency of my data entries. Ideal Skills and Experience: - Proven experience in worki...
I have image form i want to make the form in excel to print it directly
mình đang tìm dịch vụ support cho tự động hoá đọc dữ liệu ở Excel dùng VBA. bạn nào có thể giúp thì sẽ nói chuyện trực tiếp để giải thích thêm
...looking for someone to develop a stock prediction program specifically targeted at the Saudi market. Key Requirements: - Programming Language: You can use any language you're comfortable with, whether it's Python, Java, C++, or another language or excel sheet. - Technical Requirements: The program should be highly accurate, providing predictions with an accuracy rate of over 90%. - Data Sources: The program should utilize a range of data sources to inform its predictions. These should include historical stock data for the Saudi market and any other relevant information that you can source. Be creative with your data sources and demonstrate a strong understanding of the market. Ideal Skills and Experience: - Strong background ...
I am searching for a dynamic Sales Executive well-versed in technology, specifically software solutions, to drive sales in the business sector. Key Responsibilities: - Building and maintaining relationships with business clients - Presenting and selling software solutions ( web designing and social media marketing and management ) Ideal Profile: - Experience in B2B sales, particularly in technology - Understanding and passion for software solutions - Excellent communication, presentation and negotiation skills. This is a commission-based role offering the opportunity to excel within the tech industry while working closely with businesses. Comession is based on deals you will it is going to be between 8% - 20% on every successf...
I have an urgent project requiring the conversion of 1121 rows x 5 columns of data from an Excel spreadsheet into a Word document. The data must be formatted according to a pre-defined template (which I will provide). Key Requirements: Confidentiality: A non-disclosure agreement (NDA) will be signed to protect the sensitive nature of the data. Experience: Must have demonstrable experience with data formatting and conversion between Excel and Word. Speed: This project has a strict 24-hour deadline. Accuracy: Meticulous attention to detail is essential. Additional Details: I will provide the Excel file, Word template, and specific formatting instructions. Please share examples of similar projects you have completed s...
