Excel macro neededprá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í.
Pro našeho významného klienta hledáme člověka, který se bude věnovat jeho Facebookovému profilu v Rumunsku. Co od tebe očekáváme: správa rumunského profilu, překládání postů z CZ -> RO, vymýšlení dvou postů pro Ruminsko měsíčně. Pozice je skvělá příležitost pro studenty! :)
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
I'm looking for a skilled professional who can set up and optimize Google Merchant Shopping Ads for my e-commerce website, Maxko.nl. I'm aiming to enhance my sales through this platform. Key Responsibilities: - Setting up Google Merchant Shopping Ads for - Conducting research on competitive keywords - Optimizing these ads to maximize ROI - Regularly monitoring and tweaking the campaigns for finer performance - Implementing conversion tracking to assess the effectiveness of the ads The ideal candidate should have: - A proven track record of setting up and managing Google Merchant Shopping Ads - Extensive experience in e-commerce and online marketing - Familiarity with 's e-commerce platform - Strong analytical and problem-solving skills - Demonstrable evidence of improvin...
I'm looking for a talented 3D mockup designer to help me create realistic visualizations. Your experience and creative input will be key to this process.
I'm looking to have a business-style logo designed for my tax business. The primary color I'd like to see integrated is green. Key Requirements: - Incorporate green as the primary color - Design a business-style logo - Include elements that symbolize trust and professionalism
I'm looking for an Excel expert to create a mark sheet for me. This mark sheet will be used to record student test scores and will automatically assign grades based on a custom scale I've provided. The sheet should have: - A column for Student Name - A column for Test Score - A column for Grade (to be calculated based on the score and the custom scale) The grade allocation should be as follows: - Score of 1: Grade E - Score of 2: Grade D - Score of 3: Grade C - Score of 4: Grade B - Score of 5: Grade A I do not require any additional calculations to be performed beyond the grade allocation based on the score. Ideal Skills: - Proficiency in Excel - Experience in creating automated grading systems - Background in academic assessment would be a plus Please let m...
I'm seeking a proficient Excel expert to create an interactive mark sheet specifically designed for student use. Key Features: - Implementation of essential calculation formulas: This will include automated calculations for grades, averages, and other relevant metrics. Delivery: - The final sheet is expected to be shared through a link to an online version that can be edited. This will ensure easy access for students and real-time updates as needed. Ideal Candidate: - Proficient in Excel and experienced in creating interactive and user-friendly sheets. - Knowledgeable about education-related metrics and formulas. - Ability to deliver a reliable online version for easy access and editing. Please note that the primary users of this mark sheet will be students,...
...manage MIS excel sheets pertaining to data analysis, sales forecasting, and expense tracking on a daily basis. Key tasks: - Establishing excel sheets to analyze a broad range of data - Constructing a sales forecasting model within the excel sheets - Regular tracking and management of expenses via the excel sheets Data sources would primarily be spreadsheets and databases. These excel sheets will require daily updates, enabling close monitoring of key metrics. Ideal skills: - Proficient in Microsoft Excel - Exemplary skills in data analysis and modeling - Good understanding of databases and how to extract data from them Experience in handling and managing sales and expense data is crucial for this project. The freelancer should be able ...
I need an Excel VBA expert to automate the generation and visualization of customer data reports. This task requires the building of a dashboard to simplify the report generation process. Key Tasks and Skills Required: - Strong understanding of Excel VBA for automation tasks. - Experience in building dashboards for report generation. - Skills in visualizing customer data within Excel. Outcome and Project Scope: - Develop an automated process for report generation. - Ensure the dashboard is user-friendly and visually appealing. - The final output should provide easily digestible customer data insights.
As a business owner, I am in search of a freelance translator who specializes in interpreting academic documents pertaining to science. Key Responsibilities: - Transfer scientific jargon in academic work into clear, concise, and easy-to-understand language for business application. Skills and Experience Preferred: - A substantial background or keen interest in the scientific field. - Proven record of translating academic documents. - Exceptional comprehension of scientific terminologies and concepts. - A knack for turning industry-specific language into simplified, understandable content. Ultimately, I am searching for someone who can bridge the gap between academic science and business practicality. Your success in this role will be measured by the quality and accuracy of your trans...
I'm searching for an expert in WooCommerce product entry to handle several tasks. Each week, between 10 to 20 products will need entry, and the tasks include: - Copying and pasting text - Uploading images - Filling out various fields For each product, you'll be required to enter: - Product name and description - Product images - Three additional fields The extra fields include numerical information relating to the product's age, number of players and playing time. Please note the website is in French so a working understanding would be beneficial but not necessary. You'll be quoting your price per 100 entries with payment on a monthly basis. It's crucial you're meticulous, organised and experienced with WooCommerce. Looking forward to your bids!
...enthusiastic business, we're seeking a talented freelancer who can design an effective Power BI Dashboard to integrate various data sources including Excel spreadsheets, CSV files, and SQL databases. The ideal freelancer would: - Have extensive experience with Power BI and DAX language integration. - Demonstrate an excellent grasp of designing dashboards that report on KPIs. - Be well-versed with creating DAX calculations in the Power BI environment. We require the dashboard to focus on specific metrics, therefore, a strong understanding of reporting on KPIs using DAX language is a must. Additional Skills: - Proficient in Microsoft Excel and SQL databases. - Understanding of data integration and reporting. - High attention to detail. We're excited to colla...
Hi, I need some active freelancers to help me to complete my project on the required information will be given.A test will be taken to accomplish the is the local Listing agent n are most welcome. Thanks
I'm in search of a skilled designer who can express their creativity in designing a cigarette package. -With complete creative freedom, we'll love to see your interpretation of a design that combines modern, vintage, and minimalistic styles. -The primary colors to use in the design are, red, black, gold, and white. Feel free to creatively incorporate them, as you deem fit. -A crucial design element to include is a flame symbol. This could be literally or metaphorically represented. Ideal skills and experiences include: - Prior packaging design - Interpretation of design briefs - Working with specified color palettes Aim to impress by showing us what unique blend you can bring to a cigarette package.
I'm in need of a thorough and reliable freelancer who can assist me with typing 1-5 columns of text-based data into an Excel sheet. Data will be provided in a digital format, like PDF or Word. Key Requirements: - Proficiency in Excel: You should be well-versed in using Excel, particularly in data entry tasks. - Accuracy: Attention to detail is crucial as any errors could affect the quality and integrity of the data. - Typing Speed: A fast and accurate typist will be highly preferred to get the task done efficiently. - Reliability: I'm looking for someone who can commit to delivering the work on time, as per the agreed-upon schedule. Please note that this project will be an ongoing one, with the possibility of more work if this initial task is completed succ...
In search of a competent Excel specialist adept in Microsoft Access for multiple automation tasks. I need assistance with: - Macros Development: The main tasks include automation and creating tools. The proficient use of macros in daily operations is essential. - Report Generation: Specifically, the generation of technical proposal reports. Alongside this, the candidate should also be capable of automating the formula calculation process. Familiarity with financial, sales, and project status reports is an added advantage. - Tool Building: The capacity to build tools and other operations geared towards improving efficiency is crucial. Ideal skills include deep understanding of Excel functionalities, proficiency in Microsoft Access, extensive experience in automation via macr...
I'm in need of a professional who can assist me in conducting a hybrid crowdfunding campaign. The project entails a mix of both rewards-based and donation-based crowdfunding. The campaign targets both the general public and businesses, hence, the successful candidate should be well-versed in managing campaigns that appeal to these groups. Key responsibilities and requirements for this project include: - Experience in managing successful rewards-based and donation-based crowdfunding campaigns. - Proficiency in targeting and engaging the general public and businesses. - A clear understanding and demonstrated ability of integrating both rewards and donation strategies into a single campaign. - Proven track record in cause marketing, ensuring that both business and charitable aspects ar...
I need an Excel expert to build a tool that can automatically validate and correct any incorrect country codes in the file. Requirements: - Replace incorrect country codes: The tool should replace the incorrect country codes with the correct ones. - Predefined list: The correct country codes should be determined based on a predefined list. - Daily updates: The tool should be able to handle daily updates. Ideal Skills and Experience: - Advanced Excel skills: You should have a deep understanding of Excel functions and VBA programming. - Data validation: Experience with data validation and manipulation in Excel. - Attention to detail: It's crucial that the tool is accurate in identifying and correcting country codes. - Timely updates: Experience in creati...
I'm looking for professional organizers to work with our company with a range of projects across home, office, and estate sale support. Key Tasks: - Home Decluttering: This will involve sorting through items, eliminating clutter, and organizing belongings in a way that's functional and aesthetically pleasing. - Office Filing System Setup: I need assistance in setting up a coherent and efficient filing system in my office. The right candidate should be able to help streamline the process and make it easy to maintain. - Assistance with Moves: I also need help with packing and unpacking during moves. This includes ensuring that items are packed securely, labeled properly, and unpacked efficiently in the new location. I'm looking for someone with experience in: - Home organiza...
I'm in the midst of expanding my software testing skills and keen on polishing my understanding of Software Testing. My main areas of ambiguity involve Test automation, Manual testing techniques, and Bug tracking and reporting. I have a preference for live video sessions as a means of instruction. It would be invaluable to virtually discuss & iron out the doubts in real-time with an expert. i dont mind via chat as well. An important aspect of my self-growth is getting hands-on experience in writing test scenarios and test cases for UI. I have experience with API testing but no so much with UI manual test case creation and writing case tests. My work is around automation. i see the test steps and execute them via automation. But i am weak in manual testing of UI and writing them...
...manage MIS excel sheets pertaining to data analysis, sales forecasting, and expense tracking on a daily basis. Key tasks: - Establishing excel sheets to analyze a broad range of data - Constructing a sales forecasting model within the excel sheets - Regular tracking and management of expenses via the excel sheets Data sources would primarily be spreadsheets and databases. These excel sheets will require daily updates, enabling close monitoring of key metrics. Ideal skills: - Proficient in Microsoft Excel - Exemplary skills in data analysis and modeling - Good understanding of databases and how to extract data from them Experience in handling and managing sales and expense data is crucial for this project. The freelancer should be able ...
We're on the search for a dedicated Customer Support Specialist for a part-time (4 hours/day) position to enhance our customer satisfaction. Key Responsibilities: - Handle communication via emails, live chat, and social media. - Efficiently answer client inquiries. - Resolve customer complaints in a professional and timely manner. - Share accurate product information. - Amend product orders and customer accounts in Shopify as required. Ideal candidate should have prior experience in customer service. Excellent problem-solving skills, knowledge about our product line, and a can-do attitude are essential. Training will be provided to ensure familiarity with our product and company policies.
I'm looking for a skilled graphic designer to create a vintage-style logo for my new online platform, 'Nexux Zone'. The main color should be green. Key Requirements: - Design: The logo should have a vintage aesthetic, with a green color palette. It should be suitable for online applications, particularly websites and social media. - Skills: I need someone with a proven track record in graphic design and logo creation. Previous experience with vintage styles is a big plus. - Communication: Clear communication on design ideas and the ability to incorporate feedback is crucial. A good understanding of my vision for the logo is important. Please provide examples of your previous work, especially if it includes vintage designs. I'm excited to see your creativity and profes...
I need an expert who knows WooCommerce and Wordpress who can speed up an existing site and make sure all the plugins are working properly. I'll explain more in PM.
Writer needed for article about plunge pools in luxury homes Posted 1 hour ago U.S. located freelancers only We are looking for an experienced writer who is well versed in luxury homes and pools. This piece is concerned with plunge pools for luxury homes. It should cover the reasons that a plunge pool might be preferable over a full-sized pool (space saving, aesthetics etc.); what a plunge pool offers to the resident (cooling off, hydrotherapy, relaxation etc.); and the types of plunge pools that are available to luxury home owners. The writer should research and report on the aspects of plunge pools that would best fit a magazine for a high-end home buyer. This article will be published in a nationwide (US) print publication with a luxury real estate focus. The writer should be...
I am in need of an expert architect to oversee a new construction project for a modern residential building. Key Responsibilities: - Designing a modern residential structure that aligns with the provided blueprints and specifications - Incorporating innovative and contemporary architectural techniques in line with modern design trends - Ensuring that the construction project adheres to all necessary building codes and regulations Ideal Candidate: - Proven experience in designing and overseeing new construction projects - Proficiency in modern architectural design - Strong knowledge of building codes and regulations - Excellent communication skills to effectively collaborate with contractors and other stakeholders Please provide a portfolio showcasing your previous residential projects, ...
I need an expert to migrate my products from an Excel file to my WooCommerce store. Key Requirements: - Migrate products from an Excel file to WooCommerce - Use attributes to define variations within a single product - Update existing product descriptions during the migration Ideal Skills and Experience: - Strong experience with WooCommerce and product migration - Proficiency in handling product variations using attributes - Attention to detail for updating and modifying product descriptions - Excellent knowledge of data import/export and product management on WooCommerce. - Ability to ensure a smooth and error-free migration process.
I require a detailed and accurate excel typist with a strong background in financial data analysis specifically in calculating profit margins. This person should: - Have strong excel typing skills for efficient data entry - Be knowledgeable in financial data analysis - Be able to interpret and analyze profit margins effectively - Have logical data organization skills to improve the overall workflow This role is essential for understanding and monitoring the profit margins of my business. Accurate analysis will aid in making strategic business decisions. Your expertise in handling financial data is highly valuable for this role.
I am looking for an advertising expert based in India to help me with my cross-platform advertising strategy. Key Requirements: - Experience with Facebook, Google AdWords, and Instagram advertising. - Proven success in driving brand awareness. - Sound understanding of the professional audience, particularly in the age group of 25-40. Your tasks will include: - Crafting a comprehensive advertising campaign that spans across Facebook, Google AdWords, and Instagram. - Focusing on strategies that are effective in increasing brand awareness. - Tailoring the content to appeal to professionals in the 25-40 age bracket. I would like to see your previous work in similar projects and hear your ideas on how we can maximize the impact of this campaign.
My Android app isn't displaying AdMob ads despite using the latest SDK and ensuring compliance with AdMob policies. Key Points: - The app is built for Android, and I am using the latest version of the AdMob SDK. - I have also checked my AdMob account, and there are no policy violations or restrictions. I need a skilled developer to troubleshoot and fix the issue. You should have experience in AdMob integration, be familiar with the latest SDK features, and be able to identify and resolve any potential obstacles that might be preventing the ads from appearing. Your task will be to identify the root cause, and provide a fix that ensures the ads are correctly displayed in the app. Please provide a brief overview of your relevant experience when applying.
I have a significant amount of text that needs to be typed into Excel quickly. The data is in a simple text format, no complex formatting required. Key requirements: - Proficient in Excel and typing - Attention to detail - Ability to work under tight deadlines The data is straightforward text and requires no specific formatting or analysis. The ideal freelancer will be skilled in data entry and be able to commit to a quick turnaround time.
I'm in need of a talented developer who can help me convert my Figma design to a responsive HTML website. The project is on a tight timeline, so I need someone who can start immediately and deliver high-quality results promptly. Requirements: - Proficiency in HTML and CSS - Experience with Figma to HTML conversion - Ability to create a website that is fully compatible with both Chrome and Firefox As the conversion requires an urgent delivery, I'm looking for someone who can commit to timely communication and updates on the project's progress. Please include samples of your previous Figma to HTML work in your proposal.
As a client with emphasis on quality, I need the support of an experienced Python programmer who can take charge of the frontend aspect of my web development project. At the core of this project are the following requirements: - Full proficiency in Python as the main programming language for the task - Demonstrated experience in frontend web development using Python - Familiarity with the best practices in Python programming - Capacity to effectively communicate, provide regular updates and accept feedback The missing response for the third question won't be an issue — I am more interested in a Python programmer who can bring their own unique ideas and solutions. You are encouraged to showcase your creative problem-solving skills. Apply if you have the necessary skills and ...
I'm working on a film or TV production and in need of an experienced 3D artist who can help me with 3D modeling, Visual Effects (VFX), and Computer-Generated Imagery (CGI), all with a focus on creating a realistic visual theme. Key Requirements: - Proficient in 3D modeling, VFX, and CGI - Experience working with a realistic visual style - Previous work on film or TV productions is highly preferred Looking for someone who can bring creativity, technical skills, and flexibility to the table, while delivering high-quality and realistic CGI work. If you've got the right skillset and experience, I'd love to hear from you.
I am seeking an Excel expert who can meticulously enter extensive amounts of text, numeric, and alphanumeric data into my spreadsheet. The task involves entering names, contact details, sales information, and inventory data. The size of the task is quite substantial, with up to 1,048,576 rows and 16,384 columns involved. The role requires a keen eye for detail, accuracy, and dedication. If you are efficient in Excel and possess experience with handling large data sets, your skills will be highly valuable for this project.
I'm in need of a talented jewelry designer to help bring my vision to life; I run a shop that specializes in modern jewelry. Your primary responsibilities will be to conceptualize and design earrings, necklaces, and bracelets with a contemporary and sleek aesthetic. In particular, the ideal candidate should: - Specialize in modern jewelry design. - Be proficient with 3D modeling software and ideally have experience with 3D printing. - Have a proven track record of designing and creating high-quality, stylish jewelry pieces. - Be able to interpret my vision for modern jewelry and turn it into tangible and sellable products. This project is well suited for a designer who is creative, detail-oriented, and passionate about modern jewelry trends. A portfolio showcasing your modern jewe...
long term , full time flask developer needed to build ecommerce backend you should start right away should have proficiency in flask, jquery, ajax and mongodb budget INR 100 per hour, need to work for another 15 to 20 days
I am in search of a footwear designer with a specialized focus in casual shoes and sneakers, specifically in luxury style. The primary materials intended for use are leather, suede, and synthetic. Key skills needed: - Experience in designing luxury sneakers - Familiarity in working with multiple materials especially leather, suede and synthetic - Ability to translate concepts and ideas into tangible designs Please include previous work samples if any in your proposal. Looking forward to working with creative and skilled individuals who can bring my footwear vision to reality.
I'm looking for an expert in Excel data entry to assist me with a project. The job primarily involves: - Text data entry: Entering textual information into Excel. Accuracy is crucial, as even minor errors can greatly affect the output. - Data categorization: Organizing the entered data into different categories within the sheet. The ability to understand and sort data effectively is key. - Basic data visualization: I'd like the data to be presented visually. The freelancer should be able to create and include simple charts or graphs to represent the categorized data effectively. Ideal Skills: - Proficiency in Excel: A deep understanding of Excel and its functions is essential. - Data Entry: Previous experience in data entry is highly preferred. - Data...
I'm in need of a talented individual who can handle my social media management needs, as well as work on content creation on a weekly basis. Key Responsibilities: - Primarily manage Facebook and Instagram accounts, as well as LinkedIn to a lesser extent. - Create engaging and relevant content for these platforms weekly. Ideal Skills: - Demonstrated experience with social media management and content creation. - Strong understanding of audience engagement and brand promotion on social platforms. - Excellent written and visual communication skills. - Familiarity with scheduling tools is a plus. If you have a track record of effective community management and are a content creation wizard, I'd love to hear from you.
