Fuzzy match macro 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.
...dokonale ovládali jeden z těchto jazyků. We want you! Are you outgoing, love connecting with others, and have the ability to captivate potential customers with your enthusiasm? Are you reliable, goal-oriented, and do you speak the national language perfektly? Do you have a driver license, are flexible in time and have some experience with promotion, sales or marketing? If so, you are the perfect match for this position! We are a young, innovative start-up company from Germany and will soon rank among the leading providers in the market for smoking accessories. You will showcasing our freshest products with the goal to gain new customers and partners. Send us your curriculume vitae and a recent photo, introduce yourself in a short video application and tell us why you are ...
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í.
Hello, I need to design a logo for my new emerging brand, including an inverse variant. The name of the company is: "Evenťačka" It is about a single female person / group of independent professionals and artists that are producing tailored made highly creative events. It is not an emerging event agency producing "event products" My company is looking for a 100% match and understanding with the client that is percieved as a co-creator of the event. The main focus of the brand is to reduce waste from events and to use and work gently with materials and props. "Eventačka" offers 3 services: - Tailor made events for business partners, employees, or the public. (Family, Kids or sports day, Corporate events, Employee parties, Christmas parties, Opening e...
Pro účel vyúčtování potřebuje naše firma macro, které bude kontrolovat platby a jejich zdroje. Macro by také mělo identifikovat transakce, které buď nejsou spojené s žádným prodejem, nebo jsou nějakým jiným způsobem problematické. V příloze je vzor zdrojových souborů: report z našeho systému, výpis transakcí z paypalu, výpis transakcí z bankovního účtu. V případě zájmu/ dotazů mne neváhejte kontaktovat. Strobl
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
...update a directory of funding opportunities. User Authentication and Profile Setup: Developing secure login/logout capabilities and user profile management. AI Chatbot Development: Integrating OpenAI’s ChatGPT API to create an interactive chatbot that conducts a business background quiz and uses responses to tailor funding recommendations. Opportunity Matching System: Implementing algorithms to match users with funding opportunities based on quiz results and profile data. Subscription and Payment Processing: Integrating Stripe for handling subscriptions and payments, including setting up different access levels and monitoring usage. Testing and Quality Assurance: Ensuring all features operate seamlessly and meet user expectations. Documentation and User Support: Creat...
I have a large Excel sheet that needs to be typed in, and then analyzed for trends using a variety of statistical analysis techniques. Key Requirements: - Data Entry: The project involves a substantial amount of data that needs to be accurately typed into Excel. This part of the project requires a detail-oriented and precise freelancer. - Trend Analysis: Once the data entry is complete, I need you to analyze the data for trends. This requires a good level of understanding and experience in trend analysis. - Statistical Analysis: The project also involves performing a range of statistical analysis on the data, including: * Descriptive Statistics: This will involve summarizing the main aspects of the data set, such as mean, median, mode, standard deviation etc. * Hypo...
...developer to provide a ready-made webtrader platform for Forex CFD Trading integration into my website. It should cater to an efficient and user-friendly trading experience. Key features must include: - Real-time market data - Charting and technical analysis tools - One-click trading In addition, the platform needs to be integrated with payment gateways and have a customizable user interface to match my website's aesthetic. Whoever takes on this project should possess a deep understanding of Forex trading software and web integration techniques. The ability to make third-party integrations is crucial. While 24/7 support and maintenance isn't necessary right now, please outline your availability and turnaround times for potential future issues. If you have prior exper...
...is looking candidates for Senior Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 200 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical knowledge of VBAs, Mac...
I need an assistant to help me with checking for formatting errors in my text files. I tend to be meticulous about how my text appears and am looking for someone who can match my attention to detail. Here's how the workflow will go: - I'll provide you with a link to upload the text files that need checking. - You'll carefully go through each document, specifically focusing on finding and correcting any formatting errors, ensuring that they are consistent and adhere to my standards. Once you've completed the review, I would like you to: - Compile a separate report of the errors you have found. This will help me quickly implement corrections. Ideal Skills: - Excellent attention to detail - Proficiency in understanding and correcting formatting errors - Good comm...
...developer to provide a ready-made webtrader platform for Forex CFD Trading integration into my website. It should cater to an efficient and user-friendly trading experience. Key features must include: - Real-time market data - Charting and technical analysis tools - One-click trading In addition, the platform needs to be integrated with payment gateways and have a customizable user interface to match my website's aesthetic. Whoever takes on this project should possess a deep understanding of Forex trading software and web integration techniques. The ability to make third-party integrations is crucial. While 24/7 support and maintenance isn't necessary right now, please outline your availability and turnaround times for potential future issues. If you have prior exper...
I'm looking for a talented recruiter who's capable of identifying and hiring any-level in any industry. Key Responsibilities: - Identify and approach potential cand...capable of identifying and hiring any-level in any industry. Key Responsibilities: - Identify and approach potential candidates. - Screen candidates through interviews and background checks. - Match candidates with the right job opportunities. - Coordinate with hiring managers to understand job requirements. Ideal Candidate: - Proven experience in recruiting mid-level professionals across diverse industries. - Strong networking and communication skills. - Familiarity with applicant tracking systems. - Adept at evaluating candidate skills and experience. - Able to understand job requirements and match...
I need a detail-oriented professional to help with my bookkeeping and prepare financial statements using Excel. Key Responsibilities: - Regularly update my Excel spreadsheets with day-to-day transactions - Prepare monthly financial statements for my business Ideal Skills & Experience: - Strong Excel skills, including advanced functions and formulas - Experience in bookkeeping and financial statement preparation - Attention to detail and a good understanding of accounting principles Please note: - The role is likely to require around 10 hours of work per month - I may consider transitioning to a more robust accounting software in the future, so experience with QuickBooks or Xero would be a plus.
I'm looking for a skilled analyst to examine and arrange a substantial set of numerical data using Excel. The primary purpose of this project is to facilitate thorough data analysis. However, the data's arrangement or layout has yet to be defined, and I'm open to suggestions from the freelancer on how best to structure the data for optimal analysis. Ideal Skillset: - Strong background in data analysis and numerical data - Proficient in Excel, including its advanced functions - Ability to suggest and implement data arrangement strategies in Excel This project will require strict attention to detail and excellent organizational skills. So, if this project is up your alley, don't hesitate to bid.
I need assistance in a data entry project. The task involves inputting numerical and textual data from digital documents into an Excel sheet. Skills and Experience: - Proficient in Excel - Must have accurate and fast typing skills - Prior experience in data entry jobs This job requires the utmost precision and accuracy, as the entered data will be used for important business processes. A keen eye for detail and a high degree of data accuracy are important for this role. The successful candidate should have the ability to read, understand, and input data efficiently.
Seeking a skilled programmer adept in WordPress for custom coding work and form layout adjustments. Requires proficiency in backend management, specifically relating to data capture, viewing, and exporting in Excel format. A highlight of the project entails the customization of our existing WordPress theme and the integration of new, unspecified features. Lack of detailed request emphasizes the need for a freelancer capable of intuitive problem solving. Primary tasks include: - WordPress custom coding - PDF form adjustments - Data capture and export to Excel Ideal candidate should have knowledge and experience in custom coding, WordPress navigation, and form data handling. Exceptional problem-solving skills are highly appreciated. Undefined project elements call for a creat...
I'm urgently requiring a resourceful developer to create a tailor-made HR dashboard for our company. T...understanding of HR-related metrics. Key Features: - The dashboard should prominently feature recruitment metrics and performance evaluations. Recruitment Metrics Include: - Time-to-hire - Cost-per-hire Performance Evaluations Indicators: - Retention rate The dashboard should present these metrics in a clear, accessible format, preferably utilizing visually-pleasing graphs and charts. To excel at this project, the developer should have significant experience working on similar projects, a keen eye for design, and a knack for turning complex data into easy-to-understand visuals. A truly comprehensive understanding of HR metrics and how to effectively display them will b...
I have an Excel sheet full of text data that I need typed up. The data is currently in a PDF file, so you'll have to extract it from there. Once the data is in the Excel sheet, it needs to be organized into tables. Key Requirements: - Data entry of text from a PDF into Excel - Organizing text data into tables in Excel Ideal Skills: - Proficiency in Excel - Fast and accurate typing - Attention to detail - Experience with data formatting in Excel Looking for someone who can complete this task in a timely and error-free manner.
I'm looking for a freelancer with expertise in data entry to assist with tasks in Excel. Tasks: - You'll be working to enter data into an Excel sheet. Nature of Data: - The data to be entered will be a mixture of numerical and textual. Size of Project: - You'll be handling an Excel sheet containing between 100-500 rows and columns. Required Skills: - Proficient in Microsoft Excel - Fast typing skills with a strong attention to detail. - Strong numerical and textual data entry skills.
Hi Ashish, this is for the tasks I emailed about.
I'm looking for a detail-oriented freelancer to help me with an Excel data entry project. The task primarily involves typing text from scanned documents into my Excel sheet. **Key Requirements:** - Accurate typing of text from scanned documents into Excel - Organizing the data into tables and lists **Skills Needed:** - Proficient in Microsoft Excel - Attention to detail to ensure accuracy - Experience in data entry, ideally with scanned documents - Ability to organize data into tables and lists The ideal candidate should be comfortable working with scanned documents, have a knack for accuracy and attention to detail in typing, and be able to organize the data effectively into tables and lists in Excel.
I'm in need of an expert who can develop a risk assessment model for Cmbs SASB. The main g...of this project is to identify and analyze risks associated with my investments. Key Project Details: - The primary focus will be creating a risk model for Cmbs SASB. - I will provide third-party analytics data which you will need to integrate into the model. - The development and implementation of this model will be done using Excel. Ideal Candidate: - Prior experience in financial risk assessment, ideally involving Cmbs SASB. - Proficiency in Excel is a must, as this will be the main tool for developing the model. Please provide any relevant past work or experience that you think aligns well with this project. We can discuss further details and expectations once...
I'm in need of a skilled professional to assist with my video project, which is centered around the creation of promotional content. Key Tasks Include: - Video Editing: You'll be responsible for polishing and enhancing the raw video footage. This includes tasks like trimming, adding transitions, and ensuring a high-quality final product. - Script Writing: Crafting engaging, ...content creation, with a focus on video editing and script writing. - Possess excellent communication skills and attention to detail. - Be able to work efficiently to meet deadlines. - Understand the nuances of creating promotional content that drives action and conversions. If you have a portfolio of similar projects you've worked on, I'd love to see it. Looking forward to finding the perfect ...
I have a project which involves transferring text data from PDF documents into an Excel sheet. The data is purely text-based and will need to be accurately inputted. The ideal freelancer for this project would: - Have experience with Excel data entries, especially involving text - Be proficient in working with PDF documents - Have previous experience in data import from different formats Your job will largely involve: - Importing data from PDF files into Excel accurately - Ensuring correct data input without losing any details - Maintaining the original structure and formatting wherever necessary Please ensure the completion of this project in a timely and precise manner.
I'm searching for a detail-oriented freelancer with extensive experience working with Excel. - This task involves typing text data into an Excel spreadsheet. - The data entered will be a mixture of both structured and random entries. Thus, a keen eye for detail and the ability to maintain organization amidst complexity is key. - As a crucial aspect of this project, I require error checking to ensure the highest quality of work. The ideal candidate should have experience and knowledge in Excel data validation. - For successful completion of this project, accuracy and attention to detail are paramount. Candidates with previous background in similar tasks will be highly regarded.
I'm looking for an expert who can streamline our payment matching process by integrating Xero with our Procurement system. Key Requirements: - **Manual Matching Override Capability**: The ability to manually match transactions is crucial as it allows us to handle exceptions and discrepancies effectively. Current Discrepancy Handling: - Discrepancies between the systems are currently addressed via manual review and adjustment. The integration should help minimize these instances and make the process more efficient. Ideal Skills and Experience: - Experience in integrating Xero with Procurement systems is a plus. - A good understanding of financial processes and payment matching. - Ability to develop a system that allows for manual override matching. - Proven track record...
As part of my wedding preparations, I am in need of a skilled audio editor to help with the trimming of 1 to 5 songs. The main task would be to cut out certain sections of the songs for better flow and to match the timing for my wedding ceremony. Key Responsibilities: - Trim 1-5 songs by cutting out specific sections - Maintain good audio quality and consistency throughout the edit Ideal Skills and Experience: - Proven experience in audio editing, particularly in song trimming - Familiarity with tools such as Audacity, Adobe Audition, or similar - Excellent attention to detail and a good ear for music - Previous experience in working on wedding-related projects would be a plus Note that the project will be considered successful if the edited songs maintain a high quality and are ...
I require a meticulous individual who is adept at data entry into Excel, with precision and accuracy being top priorities. - The task involves entering various types of data, including numeric, text, and alphanumeric, ensuring it is correctly and appropriately categorized. - The Excel sheet will consist of two columns which will require careful management for data uniformity and consistency. - The entered data should be organized based on the input order, therefore, attention to chronological details is paramount. The successful bidder should have proficient data entry skills and a keen eye for detail for successful completion of this project. Prior experience in similar projects would be an advantage.
I am in need of a skilled developer who can build a customized matchmaking database for my internal use. The database will primarily focus on matching investors to investment opportunities. Key Features: - Storing Match Preferences: The database should be able to store various match preferences including minimum/maximum investment, minimum/maximum funding amount, geographical preference, and the type of funding. - User Authentication: As this database will be for internal use only, the user authentication should be secure and limited to specific staff members. No external user authentication is required. - Search Criteria: The database should have search functionality based on the geographic location. Ideal Skills: - Proficiency in database management and developme...
Please read the attached instruction sheet along with below details before you bid Kindly bid if you are experienced in image editing...set in pixel -900 X 700+s...image or website link, The same shall be shared to you as per the required data. Any visible imperfections need to be painstakingly cleared off. Each picture will have to be improved in terms of lighting and contrast to make it more visually appealing. 2) the Size of the image should be 900 X 700 (Sample attached for your reference) 3) No Duplicates images should be created even if the brochure /excel or images (provided twice by us)has got duplicates 4) If the images are not clear as per the 900 X 700... YOU shall consider the image from the website. we will share you the link for your understanding if you require the a...
I need your expertise to touch up a senior picture and create a nature-themed background. - For the photo, I need you to: - Remove any blemishes or imperfections. - Adjust the brightness and contrast to...to touch up a senior picture and create a nature-themed background. - For the photo, I need you to: - Remove any blemishes or imperfections. - Adjust the brightness and contrast to enhance the overall appeal. - Change the current background to something more suitable for a senior portrait. - The nature-themed background you'll create should: - Be vibrant and eye-catching. - Ideally match the outfit the senior is wearing. Your skills in Photoshop and background design are crucial for this project. Experience in portrait editing and a good eye for color will al...
I am searching for a proficient and attentive freelancer to assist with data entry tasks, specifically within Microsoft Excel. The role will require the successful candidate to be highly tech-savvy, with a strong background in Excel and an eye for detail. Key Responsibilities: - Handle diverse data entry tasks within Microsoft Excel - Ensure accuracy and consistency throughout the Excel spreadsheets - Offer quick turnaround times for tasks, while maintaining quality Ideal Skills: - Excellent knowledge and proficiency in Microsoft Excel - Previous experience in data entry roles - Strong attention to detail and accuracy - Ability to work quickly and efficiently under minimal supervision.
Copy and paste content into figma template and build out pages for a new website. Change colours and font to match colours in branding Template: 8 Pages - Landing Page - Services Overview - 5 Service Pages - Contact Us Page
I'm looking for an experienced and creative graphic designer to create a front cover, spine, and back cover for my non-fiction book targeted towards...non-fiction book targeted towards business owners with an entrepreneurship theme. Deliverables - Front, Back & Spine Design - 3D Mockup - Print Ready PDF, - 3 Design Concepts - Source File Key Aspects: - Meaningful and visually appealing design that conveys entrepreneurship - Should have a professional and businesslike feel to attract the correct audience - The spine and back cover design should match the aesthetic of the front cover Preferred Skills: - Previous experience in book cover design, specifically non-fiction - Understanding of what attracts business owners - Ability to convey the theme of entrepreneurship thro...
Make my business card looks better I'm seeking a skilled graphic designer to revamp my existing business card design with a modern touch. I'm open to color suggestions and would appreciate your creativity to enhance the overall look and feel of the card. Key Requirements: - Enhance the design of my current business card with a modern style - Propose suitable color schemes that match the modern theme - Incorporate any essential information such as my name, title, contact information and/or social media handles in a visually appealing manner. Ideal Skills and Experience: - Proven experience in graphic design, particularly with business card designs - A strong portfolio demonstrating modern design styles - Excellent creativity and ability to propose color schemes and layo...
...details into a spreadsheet. Responsibilities: -Conduct basic research to locate contact information for 25 specified agencies. -Validate that email addresses are current and active. -Accurately enter all data into a provided spreadsheet format. Requirements: -Experience in data collection and validation. -Proficiency in basic research and use of spreadsheets (e.g., Google Sheets or Microsoft Excel). -Ability to deliver accurate results within a set timeframe. -Project Length: Short-term, estimated completion within one week. ( MAX 80 AUD as a test round, if the work is good, Larger jobs will come) Application Instructions: Please message me with the keyword "VSL" at the beginning of your application to confirm that you have fully read and understood the job desc...
I need an Excel 365 PowerQuery or VBA script that can fetch daily market data and handle potential data source interruptions or changes. Google Shhets example =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). <Where C31 = Cell containing the Stock eg GB00B8XYYQ86, LU1033663649 or GB00B0CNH163 I need an identical function in MS365 Excel - either with PowerQuery OR VBA (preferable) Ideal skills: - Proficiency in Excel 365 and PowerQuery and VBA - Experience in web scraping and handling dynamic data sources. I am after a fixed quote for this project.
...of the organization. * Submit proposals to grant coordinators for approval. * Respond to internal and external queries on drafted and submitted proposals. * Maintain positive relationships with fund providers and other stakeholders. * Maintain records and submit reports related to grant opportunities. * Researches and identifies new Canadian Government small Business grant funding prospects to match our businesses priorities; * Generates high-quality proposals, narratives, applications and supporting documents and the requirements and guidelines of the funding agencies; * Generates revenues for GC programs through timely submission of well-researched, well written and well-documented grant proposals. * Maintains primary responsibility for grant schedules and tracking grants; * Se...
I'm seeking a professional able to create a custom CRM system in Excel for my business. Key requirements: - Sales Tracking: I need a system that allows me to monitor sales performance and forecast future sales. - Task Management: The CRM should have a task management feature to help me organize and prioritize my daily activities. Additional details: - The system will be used by a small team of 1-10 users, so it needs to be user-friendly and easy to navigate. - No integration with other software or platforms is needed at this time, so the focus will be solely on creating a robust, efficient Excel-based CRM. Ideal skills and experience for this job would include: - Proficiency in Excel, with a clear understanding of how to create complex formulas and visual repre...
The database is on the National Environmental Agency's website, and it includes all of the applications submitted for environmental permits. Here is a link to the database: Please go over all of the records, and filter ones that match all criteria: 1. EIA Screening Application/Statement or EIA Scoping Application/Statement and 2. The application is for an activity in the sea Start a new spreadsheet, and for every such record, meeting the above criteria, add a row to the spreadsheet including: date of the record, screening/scoping, title of the application (translated to English), a url linking to the application on the NEA website. In addition, download the screening/scoping report document, translate it to English with Google translate
I am currently seeking a virtual assistant to help me with my job hunting in the technology sector. The role of the virtual assistant will primarily involve: - Job application submissions: The ideal candidate should be proficient in submitting job applications online, particularly for senior-level positions in the technology industry. This includes customizing cover letters to match job descriptions and ensuring that all required documents are submitted. Sharable resources: - resume - guide doc. Salary: $25 per week Responsibilities: - open job board platform accounts with my profile - apply for 200 proper jobs matching my profile every weekday - record them in the google sheet. Requirements: - fluent English is a must - prior experience working on similar stuff - software engin...
...scraping and data collation. The project will involve scraping blog articles in HTML format and compiling desired information into an Excel file. Key Project Requirements: * The extraction will be from specified URLs, using their individual patterns for efficient and accurate scraping. * For each blog article, I need the title, the full text, and the publish date extracted. * This scraped data must be properly arranged in an Excel file for easy analysis. * List of articles is here: Ideal Candidate Expertise: * Proven experience in web scraping is a must, preferably with full understanding of HTML structures. * Proficiency in Excel and data organization. * Attention to detail to ensure accuracy of the scraped data. * An understanding of URL patterns would be adva...
