How to remove unwanted data in excelpráce

pasar informacion a excel. pasar informacion a excel

Pro pracovní projekt potřebuji zajistit webscrapping jedné webové stránky (nejlépe pomocí Octoparse) vytvoření dvou relačních databází (malé datové sety, jedny jako výsledek webscrappingu, druhé dvě Excel tabulky) pomocí SQL, včetně jednoduché prediktivní analýzy, a grafické zobrazení dashboardu v Power BI. Dat je málo, tedy věřím, že pro zkušeného datového analytika je to práce max. na pár hodin, mně to však velmi pomůže.

On my multistore: I have linked 7 multistores. TASK1: -On , I want to remove two types of material options from the dropdown list: "Transparent sticker (only for white wall)” “White sticker (for colorfull wall)" TASK 2: Add to the Material “Restick, white sticker” —> “Restick, white sticker (can be used several times)” Here is the translation of "(can be used several times)” in all languages: SK: (možno použiť viackrát) CZ: (ize použít několikrát) DE: (kann mehrmals verwendet werden) FR: (réutilisable plusieurs fois) PL: (może być używany wielokrotnie) These changes should appear permanently on all website (, , , , , , )

Par hodin prace s kontingencnimi tabulkami ve dvou souborech Excel.

Jedná se o vytvoření ekonomických posouzení investic do realit. Po vzájemné dohodě dojde k zadání základních parametrů a informací, které je zapotřebí posoudit pomocí ekonomických ukazatelů jako jsou IRR, CASH FLOW, YIELD, ROI, ROE. K tento činnosti je nutné perfektně ovládat Excel a mít vzdělání ekonomického zaměření ideálně se zaměřením na realitní trh a investice na tomto trhu.

Krátkodobá a dlouhodobá půjčovna elektromobilů: - Datábáze vozidel (současná evidence v excelu) - Databáze zákazníků (CRM) - Automatizované vytváření dokumentace: smluv, předávacích protokolů, fakturace, pojistných smluv a jejich následné zálohování. Současně používáme Excel a Word. Cíl je mít centrální přehled a systematičtější postup. Ideálně i jako cloudové řešení.

datae

datae

mise en forme

Dobrý den, potřebuji naprogramovat makro dle zadání v Excel příloze. Chtěl bych to rozložit na 2 části. 1: dle zadání v excelu 2: později po domluvě dodělat výstup na tiskárnu etiket

Napraviti Excel VBA program

I wait funky

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

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

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

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

I have a photograph that has a large, very noticeable scratch running across important details, such as faces or text...a photograph that has a large, very noticeable scratch running across important details, such as faces or text. I need an expert to remove this scratch and restore the image to its original state. Key Requirements: - Extensive experience in photo editing, particularly in the restoration of damaged images - Proficiency in using tools like Adobe Photoshop or similar software to repair scratches or blemishes - Ability to maintain the integrity of the image and not distort important details while removing the scratch - Understanding of the importance of delivering high-quality work within a reasonable timeframe Please ...

Active Directory Expert to create a Python script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, AD RMS (Rights management Services) group policy GPO etc. and export to a MS Excel File. More information attached.

...and purchase our products. Signup . The order processed should print on the certain computer linked to the website. It should be supported by Strong Backend database . Key Features: - I need a custom-built website, not a WordPress or Shopify site. - The CMS should have robust product management tools, allowing me to add, remove, or update items under different categories. - Content editing is essential. I need to be able to update the content of the site regularly. - The CMS should also include user account management. This will allow registered customers to have accounts on the site with their own profiles, order history, etc. - Additionally, I need the ability to send promotion messages to registered customers. This will be a ...

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

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

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

We are an Ecommerce company dealing with variety products and we are looking for a Social Media Ads Manager to join our team. The tasks includes but not limited to: Creating the ads on different Social Media Platforms Create reports in Excel, and Google Sheets on a daily and monthly basis Turning off the ads which are not delivering the acceptable ROI Creating a new ad for the stopped campain The Ads Manager must be solely free for this project and not committed to any other task, job or study work hours: 6 days a week, 10 hours a day The agent must be fluent in both Arabic and English Must also have good communications skills Can work on Excel Have sufficient experience in Social Media Ads and Digital Marketing

...website is currently infected with malware and I need an expert to remove it. Following this, I would like to enhance the security of my website. Key details include: - Malware Removal: The primary task involves thorough cleaning and removal of malware from the site. This is crucial to restore the website's functionality and protect users' data. - Security Enhancement: I'm looking to implement regular security scans to prevent any future malware infections. This will ensure that my website remains secure and malware-free in the long term. Ideal Skills and Experience: - Experience in cleaning malware from WordPress websites. - Proficient in WordPress security and firewall installation. - Ability to...

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

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

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

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

I'm looking for a skilled photo editor to help me eliminate the glasses from a high-resolution photo. The main aim of this task is to enhance the overall appearance of the image. Key Requirements: - The photo is of high resolution and detail. It will require a professional with experience in handling photos of similar quality. - The primary task is the removal of the glasses, and this should be done with precision and attention to detail. - I'd also like the freelancer to provide skin retouching. This will involve making minor adjustments to smooth skin tone and remove blemishes. - Additionally, I need assistance with background editing. The background should be edited to ensure it complements the main subject, without bei...

necesito un Software punto de venta con estas caracteristicas Especificaciones • Software de escritorio • Base de datos mariadb • Control de Licencias de manera remota con servidor • Demo de presentación • Grabado de videos de su desarrollo paso a paso Menú principal • En forma de pestañas • iconos e...teléfono 6. Correo 7. Sitio web 8. País 9. Departamento 10. Ciudad 11. Creador de moneda 12. Logo foto 13. Facturas tamaño carta y recibo 14. Creación de formas de pago 15. Creador de impuesto porcentaje de uso RESPALDO DE BASE DE DATOS 1. Respaldo de base de datos manual 2. Respaldo de base de datos al cerrar programa Configuración 1. Subida y bajada de productos de forma masiva con tablas de ...

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

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

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

...can create a database in Excel/Access for Invoices Log (tracking for already processed invoices) with the following features. 1- A list of all invoices (Master List) with the field names I will provide. 2- A list of all Contracts with the field names I will provide. 3- A list of all Purchase Orders. 4- A list of Approvers who is approving the invoices. 5- A list of Accounts. 5- All of these list should be linked with each other. The database should have a main page, with link to the above mentioned list pages plus Add Invoice, Search Invoice, Search Approver, Search Contract, Search PO, Search Account and Reports pages. For Add New Invoice page, I should be able to add an invoice details in it, and if it's related to a contract or purcha...

I want to build custom chromium browser bundled with my webapp. We dont want to use any framework like electrom due to business decisions. Below are the requirements: 1. Bundle webapp with custom chromium build. When the browser is opened then the webapp should be opened by default 2. Remove chromium tabs and url bar. these are not needed since we always open our webapp

...that needs to be changed = Model-car-photo1-8bit.jpg. The edits I need are as follows, and I attached images that describe the edits i need. Recover Dress Highlight Details but keep the skin exposure bright. (). Fix models arm marks and tan line. (). Remove Bright Reelections on car hood and window. (). Remove the large crack in the concrete ground. (). Make the car lights look like they are on. (). Edit the license plate so it says THT GIRL. Make it look real. () After those edits are done, please make the subject stand out from the background.. Maybe darken the car and background, to put more emphasis

I need a PDF expert to complete some text editing tasks for me. The project involves adding and removing text from a PDF document. I will provide the text to be added, and the specific text to be removed. Ideal Skills and Experience: - Proficient in PDF editing software - Attention to detail to ensure correct text is added and removed - Ability to follow specific instructions - Strong communication skills for clarifying any doubts - Previous experience with similar tasks is a plus

I’m in need of an experienced Excel software engineer who specializes in automation. The project revolves around automating data entry tasks in Excel. We are an accounting firm and I am looking to automate my compliance practices. Tasks include 1) rolling forward previous year excel work papers 2) taking information from. Client data sheets (excel) and importing into new excel workpaper workbook 3) data analytics based on metrics 4) hyperlink to source data Ideal candidates should have: - Proven experience with Excel macro programming and automation - Ability to work with numeric and legal data - Strong attention to detail to ensure data ac...

...need an Excel expert to create a comprehensive spreadsheet to track and calculate project costs, revenues, expenses, and profits. Specific calculations required include sum, average, percentage. The Excel sheet should track the following: - Project cost - Project revenue - Project expenses - Percentage of account receivable - Percentage of account paid - How the client paid after tax - Description for the costs - Percentage of the costs - Percentage of the profit before tax - Percentage of account receivable before tax - Date of payment The data presentation in the spreadsheet should be in the form of tables and graphs. Experience with financial data analysis and management is vital. Understanding of cost and profit cal...

Hello there, I'm in need of some assistance with an old PDF file. I'm experiencing issues with stains and blurriness that compromise the quality of the file. The task I need to be done involves: - Removing the stains and enhancing the overall clarity of the PDF. - The correction work will involve handling a mix of both text and images. Ideal freelancers for the job will have ample experience in handling and editing PDF files. Proficiency in using advanced PDF editing tools will be highly beneficial for this task. I value attention to detail in ensuring that the document's quality remains high and no content is lost or altered during the correction process. Looking forward to seeing your proposals.

I'm seeking an audio professional, preferably with experience in denoising audio files, specifically meeting recordings. The main issue at hand is the removal of consistent background noise of people talking. It's imperative that a careful approach is executed, as there are very frequent phrases or words that need to remain intact despite the background chatter. Skills and Experience: - Proficiency in audio editing software - Prior experience in denoising audio files - Familiarity with processing meeting recordings - Keen ear for differentiating important dialogues from unwanted noise. Your task is to clean up the audio file without losing substantial information. Please, apply and let's make our meeting discussions clear and co...

We are looking for freelancer for technological catalogues redesign and build in adobe indesign. Freelancer should be expert in adobe indesign, photoshop, ilustrator. We provide example project templates in adobe indesign, source data in pdf and excel. Based on source data our catalogue should be created and redesigned as template project. Project should be done in adobe indesign for printing and web

...with over 50 pages of data in mixed formats - text, numbers, and tables. The task is to accurately transfer this data into an Excel spreadsheet in a tabular format. Key requirements: - Data entry from a PDF file into an Excel spreadsheet - The data is of moderate complexity, so a good understanding of Excel is needed - The output should be a well-organized and clean Excel spreadsheet Ideal skills for this job: - Proficiency in data entry and working with large data sets - Advanced Excel skills, including the ability to work with mixed data formats - Attention to detail and accuracy to ensure the data is correctly captured - Experience with PDF ...

I'm looking to transform my game videos, which are currently in Full HD format, to weave a captivating story for my viewers. - The initial task involves trimming and removing any unwanted parts from less than 30 minutes of footage. - I want to bring the remaining video clips to life by adding special effects and animations to enhance the overall viewer engagement. - Additionally, adjusting audio levels is crucial to provide crystal clear sound and further enrich the gaming experience. Ideal strengths for this project would be technical proficiency in video editing software, a knack for storytelling through visual effects, and a solid understanding of audio engineering. If you have worked on gaming videos before, that wo...

--- ### Job Title: Excel Sheet Creation for Job Tracking and Payment Calculation **Description:** I need a custom Excel sheet to help me track jobs completed by my installers, including details about each job, such as dates, customer information, and payments. The sheet should be able to automatically calculate the total number of jobs done and the total payment owed to each installer. **Requirements:** 1. **Job Tracking:** - Columns for the date each job was completed. - Columns for the job details including customer address and account number. - Columns for the installer assigned to the job. 2. **Payment Calculation:** - Ability to input the payment rate per job. - Automatic calculation of the total number of jobs comple...

Just a quick bit of help needed in excel macro writing. See attached before and after showing a piece of the original data. and what i neeed the macro to achieve. WHAT IM ASKING If two adjacent cells in column b are equal, then add cells adjacent column c cells, put the result in the first column c cell and remove the duplicate row. AEE ATTACHED png. I need a tailored solution for a data manipulation task within Excel. Specifically, I am looking for an Excel macro that can accurately merge cells based on their adjacency. Essential skills and experience should include: - Expert knowledge of Excel and its macro functionality - Prior experience with data manipulation tasks such as merging cells - Und...

I am looking for an expert who can as...expert who can assess and modify an existing Excel macro for compatibility with Excel for Mac 2019 or later. The current macro mainly handles formatting tasks within the Excel file. Key Requirements: - Assess the current macro's compatibility with macOS - Modify the macro to ensure compatibility with Excel for Mac 2019 or later I don't have a strict deadline for this project, so you can work on it at your own pace. However, I am looking for someone who can get this done efficiently and effectively. Feel free to ask any questions for more information. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform...

I'm in need of a skilled Delphi developer who can quickly generate a program that can dive into the registry of a Windows machine and extract the names of all programs listed in the "Add/Remove Programs" section. Key Requirements: - The code should be written in Delphi. - It should effectively scan the registry. - Extracted program names should be displayed in a listbox. This is a simple task, but it's important that the code is efficient and free from bugs.

...developer to create a robust mobile application that offers real-time translation capabilities and includes an AI assistant with a focus on language understanding and real-time conversation support. Key Features: - Cross-Platform: The app should be developed for both iOS and Android, ensuring a wide user base. - Page Translation: Users should be able to translate live any page on their phone. - AI Assistant: The AI assistant should have the ability to provide information on various topics and should excel in language understanding, helping users with translation in real-time conversations with others. - Live Translation: The app should provide a smooth live translation experience for conversations. Ideal Skills: - Proficiency in Reac...

I'm looking for a graphic designer to enhance a wellness wheel chart. The chart is currently in PDF format, and I wish for it to be redesigned with a bright and vibrant color scheme. Key requirements include: - Updating the design elements, focusing on a new, vibrant color palette - Remove old text and logo and add new text - Ensure the chart remains clear, visually appealing and easy to read - Incorporate icons or symbols in a strategic way - No interactive elements are needed for this project Ideal candidates will have experience in graphic design, particularly in creating visually appealing and user-friendly charts. Experience in wellness or health-related design would be a plus. A good understanding of color the...