Excel data manipulation macrosprá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.
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í.
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
...Mandatory Skillset:Seeking a skilled SSAS Developer to contribute to our team's success. Responsibilities include designing, developing, and maintaining SQL Server Analysis Services solutions for business intelligence and data analytics requirements. Tasks involve creating data models and developing multidimensional cubes. Key skills required: expertise in MS SQL Server Analysis Services (SSAS) Tabular and Multidimensional. Proficiency in TSQL for writing performant queries is essential. Experience with data visualization and reporting tools is highly valued. Additional knowledge of Excel and .Net development is advantageous. Strong problem-solving abilities, excellent communication skills, and a collaborative mindset are desired traits. Developer has t...
Looking for a freelancer with expertise in managing and manipulating numeric data sourced from Excel spreadsheets. The work involves: - Efficient management of extensive numeric data - Organizing the data effectively onto separate worksheets according to their specific types Ideal candidates are those with previous experience in data entry and strong proficiency in Excel. Your responsibility would not only be to perform accurate data entry, but also structure it logically and intuitively. It requires excellent attention to detail, precision, and the ability to understand data categories. We value those with a proactive approach who can offer insights into improved data organization. Solid experience in similar projects is pre...
We are looking for a detail-oriented professional to review a set of documents and extract and integrate the data into tables. The candidate must have excellent attention to detail and strong organizational skills. The task involves identifying relevant information, formatting and structuring the data into tables, and ensuring accuracy and consistency. The ideal candidate should have experience working with data entry and be proficient in using spreadsheet software such as Microsoft Excel or Google Sheets. Required skills: - Attention to detail - Organization - Data entry - Spreadsheet software
...diligent freelancer to collect a variety of data types, despite the specifics not being disclosed at this time, to further my projects in data analysis. The collected data will need to be formatted into a user-friendly spreadsheet which can be easily utilized for further usage. Key requirements and skills: - Proactive approach to understanding and gathering a broad range of data types - Experience with data analysis tools and strategies - Proficiency in spreadsheet software, particular Excel - Strong organizational and communication skills - Keen attention to detail when it comes to data gathering and analysis - Able to deliver the complete data in a spreadsheet format Your experience in data collection and analysis, with ...
...professional data entry specialist to input information from various sources into an Excel spreadsheet. This project involves a mid-range volume of entries, approximately between 1000 and 5000. Key requirements: - Skilled in data entry, particularly in an Excel environment. - Ability to maintain high accuracy and consistency throughout the project. - Previous experience in handling medium to large data volumes. - Understanding of basic statistical analysis for post-entry work. Once the data is entered, I require basic statistical analysis to be performed. This will involve simple calculations and organization of the data in a meaningful way. Ideal Skills: - Proficiency in Microsoft Excel - Attention to detail - Basic statistic...
I am in need of an experienced freelancer who can assist with various types of data entry tasks. This primarily involves: - Transcribing data from handwritten documents - Entering data from digital documents - Inputting data from spreadsheets The volume of data to be entered is moderate, falling between 100 - 1000 records. The preferred software for this project is Excel, therefore, proficiency and solid experience in using this application is necessary. Attention to detail and accuracy will be essential for this position. Understanding how to use spreadsheets effectively, and a proven track record in data entry are important skills that a suitable freelancer should possess.
I need a data scraping tool to pull business names and addresses from Google and Google Maps. - The tool should be able to extract this information in an organized and comprehensive manner, enabling me to create a database for further analysis. Ideal skills and experience for this job include: - Proficiency in web scraping tools and techniques. - Experience working with Google and Google Maps APIs. - Ability to organize and structure data effectively. - Data to be compiled in an excel spreadsheet - Prior knowledge of extracting business information from online sources is a plus. Looking forward to your proposals.
I'm urgently in need of a Python specialist to accomplish an assignment using Jupyter Notebook. The task involves reading and merging multiple Excel sheets, and subsequently creating visual representations for the collated data. Key requirements are: - Deep knowledge of Python for data analysis - Proficiency in creating Bar Charts, Scatter Plots, and Line Graphs. - Strong skills in Excel data manipulation. Required libraries/packages expertise: - Matplotlib - Seaborn - pandas Your responsibility will be to decode the problems presented, manipulate provided Excel data accordingly, and present the output in an understandable visual format. Previous experience in similar tasks will be highly regarded. Will show the work on zoo...
I require an expert in image manipulation who can skillfully change certain parts of a pre-existing red-colored image to display a polished aluminum finish/Silver instead. I would also like the image delivered with a transparent background. Key responsibilities: - Identify the specified parts that need color adjustment and maintain the quality of the rest of the image. - Modify the specified areas to render a convincing polished aluminum texture. Ideal Skills and Experience: - Proficiency in image editing software such as Adobe Photoshop or Gimp - Sound understanding of color theory and photo manipulation - Prior experience with metallic color rendering and texture work is a plus
I am seeking a seasoned Excel expert to manage a complex data entry project. Your focus will be the development and implementation of advanced macros to ensure efficient, effective data management. Key Responsibilities: - Executing Excel data entry tasks - Developing and applying advanced macros Preferred Skills & Experience: - Proficiency in Excel - In-depth understanding of advanced macro development - Proven experience in similar data management projects The ideal freelancer will be detail-oriented, possess strong problem-solving skills, and have a track record of improving efficiency and accuracy in data entry tasks via macro automation.
...in/content/mca/global/en/mca/fo-llp-services/) However, these don't allow bulk input. I want users to be able to input a large list of company names and receive an output in a downloadable Excel sheet. Although I initially explored utilizing an [API from ](), I encountered difficulties with downloading data or obtaining an API key, possibly due to issues with their website. but was able to find [this csv file on kaggle]() containing information of companies from 1857-2020. My initial approach is to use appwrite for backend and react for frontend. populate the appwrite db with information from the csv file. then build the
...the past for some amount. From 20 euros to hundreds of thousands of euros, and they stopped a year or more ago. The purpose of the conversation is to check whether the company still exists, whether it is still in the field and why they stopped purchasing. We have prepared a dedicated link for filling in the results of the conversation. I am attaching the excel file with the records, the script of the conversation. Translate it into the appropriate language for the country you will be speaking with) The conversation must not be mechanical, the script is only for illustration. I have prepared several questions and answers in case it comes up in the conversation. For the purpose of the conversation, you work at Vista System Norway. Some of the records include
I am in need of a skilled data entry operator to assist with the transfer of input of text data. Your main task is to take text data from an online database and accurately enter it into an Excel spreadsheet. Requirements: - Ability to accurately enter text data - Proficient in Excel - Experience sourcing data from online databases - Diligent and detail-oriented to ensure no errors are made during data transfer - Strong English language skills to ensure effective communication The ideal freelancer for this project is someone with proven data entry experience, excellent Excel skills, and vast familiarity with online databases. Being a detail-oriented person with great concentration skills will be a huge plus.
...UI, which has a settings dialog for the rules: - add/delete/update/display (CRUD) operations on rules - user can choose a regex pattern to detect specific phone numbers (from) - user can choose the destination(s) (a list of destinations) with whatsapp, telegram, sms, e-mail - implementation in this MS on the UI only for e-mail (but user can select all the named options) - user can choose to use macros like: - sender phone (smsSenderPhonenumber) - sender name (smsSenderDisplayName) - senders text (smsBody) - senders datetime (smsDatetime) MS3: help to publish on playstore and appstore MS4: implement the telegram integration (forwarding destination) MS5: implement the telegram integration (receiving telegram msgs and forward) MS6: implement sms sending (e.g. to forw...
...multiple Excel slicers into one for our data analysis needs. The requirement is, I want to use same Slicer for multiple data. Detailed description is as follows: I have a accounting sheet. Where in one separate sheet I have captured Incomes along with the date and amount and other sheet I have put Expenses along with Date and amount. Now in summary sheet I am using Income pivot table, where I am using Slicer on Date (Merged for Months and Years). I want the same slicer to be used for Expense pivots as well. The ideal freelancer for this job should be proficient in: - Excel - Slicers and PivotTables - User experience design - Data analysis techniques Your input and expertise in this project can help streamline our data manipulation ...
I'm looking for an Excel and VBA expert to help streamline my workflow and boost productivity. You'll be responsible for: - Automating repetitive tasks: I need you to develop efficient scripts that will handle routine operations in the spreadsheets, eliminating the need for manual intervention and enhancing the overall efficiency. - Crafting custom functions: The custom functions I require are complex and involve external data sources. Your role will involve creating these functions effectively, ensuring they are accurate and function seamlessly within the Excel environment. The ideal candidate will have extensive experience in Excel, VBA, and creating complex custom functions. Solid understanding of data analysis and automation is crucial fo...
...only one week Only the corresponding screen can be viewed Approximately 300-400 new businesses expected to be registered each month: Development needed to accommodate the expected volume of registrations Development to prevent IP bans Detailed feature description: Member Login Sign-up Permission assignment Individual inquiry Immediate rank crawling Tracking target management Individual input Bulk Excel upload & download Keyword-based crawling On/Off Deletion Background crawling of tracking targets Naver Place keyword (1 daily query) Rank change history Generate a shareable URL (reset every week) Display in a popup from step 3...
I need a skilled Phot...familiarity with Envato Elements to help me with a specific task. need add ons for this site - I'm looking for someone experienced in using Envato Elements and Photoshop presets/addons. - To be considered for the project, you must provide an example of your work. - The specific task will involve photoshop manipulation, focusing on the addition of addons presets to images on a page. Your role will be to enhance the images on the indicated site. I require an individual with excellent Photoshop skills, particularly in terms of applying presets and addons. Your work should improve the overall quality and aesthetics of the images. Show samples of your work No samples = no work
Dear Candidate, As described in the title, this task requires that you reasearch medical centres (also called general practice medical centres, family physician clinics, clinics) and find out who the owners of these clinics are are using internet research. You will have to be fluid with excel, online reasearch tools. This is a posting for a long-term VA who can perform various forms of online research and other tasks. Personal attributes required: 1. Speed and efficiency in online research. 2. Attention to detail and complete accuracy in all tasks. 3. Punctuality and ability to meet deadlines. 4. Ability to read/follow instructions carefully with attention to detail. Successful candidates will be required to complete two test works before the project is awarded. 1. Watching i...
Looking for someone to go to a few sites and make me an excel sheet with all the listings on the site . Must speak fluent English
I'm in need of a meticulous professional to clean a mixed set of data contained in an Excel file. I am specifically struggling with duplicate values and missing entries. To effectively accomplish this: - You should possess excellent skills in data analysis and data management. - Previous experience with Excel-based data cleaning is preferable. - Profound knowledge of dealing with duplicate entries and filling in missing data is required. - A keen eye for detail and ability to spot and correct errors is essential. In summary, my ideal candidate would be someone with significant experience in data cleaning, particularly with mixed data in Excel files. It would be a bonus if you've previously resolved issues...
I need an adept data entry freelancer to skillfully convert text data from various online sources into an organized Excel spreadsheet. You'll reap the benefits of this project if you're detail-orientated, familiar with navigating online sources, and proficient in Excel. - The project involves researching, collecting and collating text data from specific online sources - The final deliverable needs to be an Excel spreadsheet, with data arranged legibly - Demonstrable experience in data entry jobs would be ideal - A keen eye for detail is paramount as exactness is key for this data entry task - You should be comfortable working with Excel and have proficiency in using all its features. The testimonials of you...
I need a proficient excel expert to help me with a data entry project. The data involves simply names, emails, and phone numbers. It will be a table with 100-500 entries, so proficiency in data entry and Excel is crucial. Key Requirements: - Accurate Data Entry: The job is primarily about accurately transferring names, emails, and phone numbers from a document to an Excel sheet. - Excel Proficiency: Knowledge of Excel functions is a plus, though not specifically required. You should be comfortable working with a table of this size.
I'm in need of comprehensive and detailed Australian databases. Specifically: - Medical databases, with a key focus on medical specialties. Medical databases sh...databases should preferably contain reliable and relevant information about the different branches of medical specialties across Australia. - Business databases, encompassing detailed company profiles inclusive of industry category, phone, fax, email, physical address, etc. I'd appreciate getting more data, as in-depth as possible. The databases should be pre-existing or scraped and must be provided in Excel format, or .BAK for MSSQL server. Professionals equipped in big data collection, scrapping, and data analysis would be the most suited for this project. Knowledge about Australian medi...
I'm in need of a talented photo editor who can elevate my images to professional standards. You'll be performing enhancements, tailored to each photo's needs. Here's a snapshot of what I'll require you to do: - **Im...editor who can elevate my images to professional standards. You'll be performing enhancements, tailored to each photo's needs. Here's a snapshot of what I'll require you to do: - **Image Retouching**: Professional touch-ups to remove imperfections. Your skill set should include: - Proficiency in Adobe Photoshop or equivalent. - A keen eye for detail and aesthetics. - Creativity in image manipulation. - Previous experience with photo editing, particularly in a commercial or artistic context. Looking forward to your bi...
K zobrazení podrobností se zaregistrujte nebo přihlaste.
I need a freelancer to assist with accurate and efficient data entry into Microsoft Excel. The data is in digital format and involves numeric values. Key Requirements: - Enter numeric data into Microsoft Excel from provided digital sources - Ensure data is accurately transcribed - Maintain confidentiality of the data Ideal Freelancer: - Proficient in Microsoft Excel - Strong attention to detail - Previous experience in data entry, preferably with numeric data - Ability to maintain data integrity and confidentiality. Note: Please ensure you have a copy of Microsoft Excel for this job.
I am in need of a professional who can help provide insights into a dataset using Excel's pivot charts, tables, and dashboard. The area of the data is unspecified as of now, but a strong candidate would be adaptable and skilled across domains. Key responsibilities will include: - Data Visualization - Creating Pivot Charts - Building Tables - Preparing a Dashboard Note: This project is basic-level work and my budget is 10 not more than that I already checked price comparisons with different freelancing platforms. if anyone works in that price range only the person make bids does not waste time.
Necesitamos una hoja de excel donde podamos introducir datos y sea dinamica, os enseñaria un ejemplo de algo que ya tenemos hecho Solo Hispanohablantes por favor, sino es muy complicado el entendimiento
O trabalho consiste em digitar 140 páginas de extratos que estão em PDF para uma planilha do Excel, conforme modelo (os extratos a serem digitados e o modelo de planilha estão nos anexos deste projeto)
I am seeking a bilingual Sales Specialist with a mid-level experience in enhancing our Service Sales. (5 Sales Specialist needed). Key Requirements: - Fluency in English and Spanish - Mid-level experience in sales. Ideal Skills and Experience: - Proven track record in service sales - Strong communication and negotiation skills - Bilingual proficiency in English and Spanish - Ability to excel in a fast-paced environment. The Sales Specialist will focus on sales effectiveness through phone calls. The primary target market is the Telecom/Home service. The ideal candidate should have a solid understanding of this market and be able to communicate effectively in both English and Spanish. Training on our Services and related will be given. We offer excellent Commissions. Join our tea...
I am looking for a freelancer who is proficient in data entry and familiar with Excel to assist in the digitization of a 276-page vintage parts manual. Your task would be to: - Accurately copy the information from pdf to Excel. This includes part numbers, the description of parts, and all other columns present in the original tables in the document. - Organize the spreadsheet such that each section of the document is represented by a separate worksheet. No specific data validation rules or cell formatting are required, but the data must be accurate and searchable in Excel. This job requires someone with a keen eye for detail and a good understanding of Microsoft Excel. Prior experience in similar data entry tasks would be a signifi...
...to in a attempt to avoid responsibility and legal repercussions. It's essential that the freelancer I hire for this project is capable not only of conducting thorough research, but is also able to present their findings in a way that is both persuasive and thought-provoking. Like a rotting onion, every layer of this story will unveil a nasty new character trait and paint a chilling picture of manipulation and personal corruption. This is a complex story of and individual with a affinity for negatively effecting the lives of anybody who cross' with them. A twisted tale of an unchecked sociopath wreaking havoc on the community. It is my hope that the investigation will result in findings that can be presented to the Court of the Kings Bench, help countless employees, ve...
Looking for an expert who can import data from 1-10 Excel files into Google Earth. Key tasks: - Convert location data from Excel into a format readable by Google Earth (preferred Google Eath Pro Tours for Commercial Real Estate Properties - Ensure perfect alignment of data with the geographical locations - Grouping and categorizing the locations as per the content of each column within the Excel files Ideal candidate: - Proven experience with data visualization tools, particularly Google Earth and Google Earth Pro tours for Commercial Real Estate Properties -- High proficiency in handling Excel files and data - Understanding of Geographical Information Systems would be a bonus.
I have a MySQL database that needs exporting. All user data, product data, and transaction data are required to be exported. Key Tasks: - Export all MySQL user data - Export all MySQL product data - Export all MySQL transaction data The final export should be in Excel format. This is not a job for beginners. You should have prior extensive experience with large database exports and MySQL. It would be a big plus if you're familiar with handling sensitive user and transaction data. As the project involves substantial data, confidentiality and data security are non-negotiable. Please include samples of similar database exporting projects you've completed.
I am in need of an Excel spreadsheet expert to create an Excel template using a PDF sample. Without being specific about the details, the ideal candidate should have excellent skills in extracting data from PDFs and well-versed in designing Excel templates. Here's what I'm looking for: Mactacquickshipsellsheet pdf converted into an excel sheet example of what I would like as template.
Database Tool Development I. Introduction 1. Purpose: The DRP Talent Solutions team currently manages an internal workforce partner database developed in-house and updated internally. This resource, currently in an Excel spreadsheet format, is used to assist employers in navigating our regional workforce programs and partners. To enhance its utility in responding promptly to RFIs (Request for Information), we aim to reinforce this database tool. Our objectives include implementing organizational features with multiple tags for efficient categorization and establishing a user-friendly update and maintenance system that does not require consultant engagement. 2. Objectives: i. Objective 1: Enhance Database Organization 1. Introduce multiple tags for easier navigation and filtering ...
...experience in API integration and data handling to assist me with incorporating meter reading systems Tehama, Cereniti, and Inovonics into our existing system. This integration is referred to as MDM, or meter data module, with our software provider Utility Trackr. Key Project Requirements: - Extracting specific data: The project requires the extraction of meter readings, property information, and other necessary data from the aforementioned meter reading systems. Specifically, I need to extract Meter ID, Unit ID, and Date of read, Current Read. Dual transmitters require a unique ID. - Generating CSV or Text files: The extracted data should be organized and formatted into CSV or TXT files. Each property in the system should have its own file containin...
I'm in need of an Excel expert to help me with intermediate-level spreadsheet formatting. The tasks include moving data from sheet to another sheet Ideal Skills and Experience: - Proficiency in Excel
I am looking for a freelancer to assist me with a data entry project. The task involves typing data from handwritten documents into a digital format. The data must be formatted in a specific way, so attention to detail is important. Skills and Experience: - Proficient typing skills and accuracy - Experience with data entry and handling handwritten documents - Familiarity with formatting data according to specific guidelines - Ability to work efficiently and meet deadlines The project includes 1-10 pages or documents that need to be entered. If you are interested in this project, please provide examples of previous data entry work and explain your experience with formatting data.
