Excel keywordроботи
Необхідно розробити макрос з перетворенням 1 файлу excel "для обробки" у кілька файлів-шаблонів теж у excel. Суть заповнення всіх полів у цих шаблонах з даних файлу excel "для обробки" згідно з алгоритмом описаним у технічному завданні.
Створити таблицю Excel та внести в неї данні з касових чеків. Розбити по періодам та групам.
Потрібно написати модуль (скрипт) для оновлення цін в інтернет магазині. Періодично висилають нові прайси, з яких потрібно підтягувати нові ціни. Вибірку робити по артикулу товару. На сайті поле артикула містить також назву фірми (для прикладу Nowodvorski 65441), а у прайсі просто 65441. Прайси приходять у Excel. Інтернет магазин створений на базі CMS Drupal 7.
Ввод информации в базу, возможно Excel либо другой редактор, могу работать непосредственно с онлайн информацией
Вносити дані до таблиці Excel. Це э дуже непогана робота яку можна виконувати дуже швидко, а головне чітко і без помилок.
I'm looking for a skilled Excel expert to create a task management system tailored for team collaboration. The system needs to support a small team of 1-5 members. Key Features: - Task Assignment: The system should facilitate the distribution of tasks among team members. - Progress Tracking: There should be a way to monitor the progress of tasks and projects. - Shared Calendars: A component for a shared calendar is essential, allowing team members to stay informed about deadlines and important dates. Ideal Skills and Experience: - Proficiency in Excel, particularly in creating complex spreadsheets. - Experience in designing task management systems. - Understanding of team collaboration needs. other things required: calendar view deadlines short term , long term plan...
I've got 4 AI-generated blogs ready to go, complete with keywords. However, they need a human touch to enhance their SEO and make them more appealing to industry professionals. The ultimate goal is to improve keyword optimization without compromising the integrity of the content. I'm willing to pay 10 AUD for this task. Once completed, I need these blogs to be completely AI-free. Please let me know if you can help.
I'm in need of a comprehensive Excel file detailing the top 50 universities in the USA offering PhD programs in Quantum Computing with a focus on AI. The Excel should contain the following: - University name - Details of Professors 1 to 5 including: - Their department and position - LinkedIn profiles - Emails - History of past collaborations or projects in AI - Application deadlines for both Fall and Spring batches - Program specifics I would like this data to be organized in a single sheet with categorized columns for ease of use. Ideal skills for this project include experience in data collection, proficiency in Excel, and knowledge of the field of quantum computing and AI. Previous experience compiling similar data sets will be an added adva...
Details in attached text file, Please read Login part can be skipped if tough to implement ( will re-negotiate price accordingly ) Ideal candidates should: - Have extensive experience with Python and Excel - Ability to deliver a seamless automation process.
I am seeking an SEO expert to enhance the on-page elements of my website. The focus will be on optimizing content, meta tags and descriptions, and internal linking. Key Responsibilities: - Content Optimization: Improve the quality and relevance of the website's content to boost SEO ranking. - Meta Tags and Desc...specific list of keywords that I want to target. Your role will involve implementing these keywords into the on-page SEO elements, while ensuring the content remains natural and engaging. Ideal Skills and Experience: - Proven experience in On-page SEO - Proficiency in content optimization and SEO tools - Familiarity with meta tags and internal linking strategies - Ability to work with specific keyword lists - Strong understanding of SEO best practices and Google ra...
...50 municipalities (by population) to see if each website has a business directory. c) If a municipality website does have a business directory, scrape/download the business directory for businesses’ contact details. As an example, the City of Mississauga in the province of Ontario has an online directory that lists 14,481 businesses in Mississauga, and allows users to download the list as an Excel file (I have already downloaded info for all of these businesses): Note: some municipality websites don’t have business directories. That’s fine - I just want you to check the top 50 municipality websites and determine which ones do have business directories. So to summarize the
I'm looking for an experienced developer who can create a WordPress...tags. The plugin should also be capable of posting the content on my Telegram, Facebook, and Instagram accounts. Key functionalities of the plugin should include: - Monitoring and detecting new articles from various relevant websites (specific sites will be discussed). - Utilizing AI to rewrite these articles before sharing on my site and social media. - Categorizing articles into tags based on keyword matching. Ideal candidates for this project should have: - Proven experience in WordPress plugin development. - Extensive knowledge and experience working with AI. - Familiarity with social media APIs for content sharing. Please note, the specific websites for monitoring articles will be discussed in detail ...
...commenting thoughtfully on industry posts and participating in relevant groups. Build a strong network by connecting with AI thought leaders, business owners, and industry professionals. Use strategic hashtags to increase visibility and engagement. Save all content and engagement data in our OneDrive folder for tracking and reporting purposes. Track comments and interactions on LinkedIn posts using an Excel sheet. What We’re Looking For Proven experience managing and growing professional LinkedIn profiles or pages. Strong understanding of AI, technology trends, and personal branding. Exceptional content creation skills with a human, conversational tone. Ability to analyze and use LinkedIn insights to improve performance. Familiarity with tools like Canva and access to paid...
I am conducting an academic research project that involves handling quantitative data. I am looking for a skilled data entry professional who can assist me in organizing this data appropriately. Ideal Skills: - Proficient in data entry - Experience with handling quantitative data - Familiarity with academic research data requi...data - Familiarity with academic research data requirements Your task will primarily involve: - Entering quantitative data accurately and efficiently - Organizing the data into a format suitable for academic research Please note, the specific format of the data is yet to be determined, and may include: - Tabular format - Graphs and charts - Custom reports Data will primarily be sourced from Excel sheets and CSV files. Experience with these formats is ...
I'm seeking assistance with managing and organizing data in Excel spreadsheets. Ideal Skills and Experience: - Proficiency in Excel, particularly in handling data entry and organization tasks - Attention to detail to ensure accuracy in data handling - Prior experience in administrative tasks or data entry roles would be an advantage
I'm experiencing issues with my Excel code that's leading to incorrect results during data processing. The main task of this code is to help me process data efficiently and accurately. Key Requirements: - Identifying and correcting errors in my current Excel code - Ensuring the code produces correct results during data processing - Potentially improving the performance of the code Ideal bidders should have extensive experience with Excel coding, a keen eye for detail to spot errors and the ability to optimize code for better performance.
I'm looking for an Excel expert to create a sophisticated form for data input and validation. Key Requirements: - The form will primarily be used for entering and validating text and numbers. - It must include dropdown menus for selecting options at various points. Ideal Skills: - Extensive experience with Excel form programming. - Ability to create user-friendly and efficient data input systems.
I require assistance with manual data entry. The task involves transcribing text from printed documents into a digital format. Ideal Skills: - Exceptional attention to detail - Proficient in English - Fast and accurate typing skills - Previous experience in data entry from printed documents - Familiarity with basic computer applications (Word, Excel, etc) Please note that the data to be entered is purely text-based, and it is essential that the work is carried out with a high level of accuracy.
...and scripts). Ability to create integrations with other platforms using APIs or third-party tools (Zapier, ). Excellent attention to detail and ability to maintain data accuracy. Strong organizational and problem-solving skills. Ability to collaborate with team members and understand business data needs. Preferred Qualifications: Experience with other database platforms (Google Sheets, Excel, or similar). Basic understanding of scripting languages (JavaScript) for Airtable custom scripts. Familiarity with project management or CRM systems. Experience working with remote teams and cloud-based tools. Hours: This is a part-time, remote position (approximately 10-20 hours per week), with flexible working hours. Some availability for team meetings during business hours may be requir...
...our day-to-day operations. This is a long-term, part-time position with potential for growth. The ideal candidate will have experience handling a variety of administrative and office support tasks, from managing data and emails to providing excellent customer service. Key Responsibilities: Data Management: Organize, manage, and update records and databases (experience with tools like Airtable, Excel, or similar is preferred). Email Handling: Monitor and manage incoming emails, respond to general inquiries, and escalate urgent matters when necessary. Customer Service: Provide professional and timely customer service via email and occasionally over the phone. General Administrative Duties: Assist with scheduling, booking appointments, organizing files, and preparing documents. Co...
...our day-to-day operations. This is a long-term, part-time position with potential for growth. The ideal candidate will have experience handling a variety of administrative and office support tasks, from managing data and emails to providing excellent customer service. Key Responsibilities: Data Management: Organize, manage, and update records and databases (experience with tools like Airtable, Excel, or similar is preferred). Email Handling: Monitor and manage incoming emails, respond to general inquiries, and escalate urgent matters when necessary. Customer Service: Provide professional and timely customer service via email and occasionally over the phone. General Administrative Duties: Assist with scheduling, booking appointments, organizing files, and preparing documents. Co...
...search results: - Store name and address - Contact information - Website (if any) - Contact person's name (if available) The towns / cities names will be provided in an Excel sheet, and the freelancer will need to: Search for auto parts stores in each town via Google. Scrape the relevant data (store name, contact number, address, website). Compile and organize the scraped data into an Excel file. Requirements: Experience with web scraping and the use of tools like Selenium, BeautifulSoup, or Scrapy. Experience using Google Custom Search API or SerpApi to extract structured results from Google searches. Proficiency with Excel (to organize and output the data in a structured format). Ability to work with proxy services and Captcha solving if needed, to avoi...
As a building company, I need a comprehensive Excel spreadsheet for quoting purposes. The spreadsheet should cater to both commercial and residential buildings and should include all necessary aspects for quoting. Key Features: - Inclusive of all trades: plumbing, electrical, roofing, tiling, etc. - Incorporation of all structural purchases - Detailed breakdown of individual wages with hourly rates - Everything needed to quote on commercial and residential buildings in Australia - All Excel workings need to be in metric measurements - A single, unified template for all quotes Ideal Skills and Experience: - Proficiency in Excel - Understanding of building trades and associated costs - Familiarity with commercial and residential building processes in Australia - Expe...
Busco un profesional en Power BI para desarrollar un reporte visual e interactivo basado en un archivo Excel con varias hojas (denominadas "Lam") que ya contienen datos calculados. Requerimientos: Conectar y cargar el archivo Excel. Crear gráficos interactivos (barras, líneas, tablas) para mostrar acreditaciones, canjes, saldos y porcentajes de redención. Incluir filtros y segmentaciones para explorar datos por hoja, fechas o miembros. Diseñar un tablero visualmente atractivo y fácil de usar. Entregar el archivo Power BI (.pbix) listo para usar. Adjunto el archivo en excel y un ejemplo hecho en power bi
I’m looking for someone to help edit and enhance my WordPress webpages with a focus on creating human-written content that is unique, engaging, and targets the specific keywords already assigned to each page (e.g., Apartment Movers). The project includes: Editing or rewriting existing content to improve quality and ensure it aligns with the target keyword. Using widgets, graphics, and other design elements to enhance presentation and user experience. Optimising the page for SEO while maintaining a professional and visually appealing design. I’d like to start with 1–2 pages per week, but for now, please provide a quote for editing and optimising one page as an example. This is a long-term project with many pages, so consistent and high-quality work will lead to on...
I need assistance converting an Excel calculator into a calculator that I can embed in a Word document, so that when the word document is turned into a PDF the calculator still works and is editable by the user. This could be done using Python to create the calculator. I can see two scenarios to achieve this:- 1 The Word document will be regularly updated , so the calculator should be embedded in the word document. 2 The calculator could be embedded in a separate pdf and the word pdf and calculator pdf merged each time the word document is updated. Requirements: - Integrate an editable calculator into the PDF that performs basic arithmetic Ideal Skills: - Python - Ability to create interactive elements within a PDF - Attention to detail and ability to follow instructions accura...
I need a professional who can create an Excel report in a dashboard format tracking the performance of our management. The report should encompass: - KPIs (Key Performance Indicators) - Financial performance - Employee productivity Ideal candidates for this project should be proficient in Excel, with experience in dashboard creation and performance reporting. Strong analytical skills and understanding of management metrics will be a plus.
Excel sheet financial expert to monitor my income, expenses and investments with proper graphical visualization.
I'm looking for an SEO expert who can assist with both on-site and technical SEO aspects. My needs encompass structured data, schema markup, keyword research, strategy formation, competitor analysis, backlink acquisition, and more. Key Responsibilities: - Implement structured data and schema markup - Conduct keyword research and develop strategies - Analyze competitors and acquire backlinks - Help onboard new clients - Generate comprehensive reports Ideal Skills: - Proficient in both on-site and technical SEO - Excellent organizational skills - Strong reporting capabilities - Experience with client onboarding - Deep understanding of structured data and schema markup
...of the current inventory and overall stock value. Exportable reports (e.g., in Excel or PDF format) to facilitate performance monitoring and decision-making. Technical Requirements: Design the system to be flexible and capable of integrating with existing devices (such as RFID readers) while supporting future expansions. Ensure the system interface is user-friendly for non-technical users. Include an activity log to track and document any modifications made to the data. Additional Notes: The system is intended for managing the inventory of a retail store's warehouse and focuses on simplifying the stock management process. The system does not need to rely on a specific programming language or platform; using Excel files as a working platform is acceptable as long as t...
...of the current inventory and overall stock value. Exportable reports (e.g., in Excel or PDF format) to facilitate performance monitoring and decision-making. Technical Requirements: Design the system to be flexible and capable of integrating with existing devices (such as RFID readers) while supporting future expansions. Ensure the system interface is user-friendly for non-technical users. Include an activity log to track and document any modifications made to the data. Additional Notes: The system is intended for managing the inventory of a retail store's warehouse and focuses on simplifying the stock management process. The system does not need to rely on a specific programming language or platform; using Excel files as a working platform is acceptable as long as t...
I'm looking for a detail-oriented and resourceful individual to find high-quality products for our dropshipping store specializing in pet supplies (dog, cat, and small pets). The ideal candidate will search for trending, affordable, and reliable products on AliExpress, collect relevant product data, and organize it in an Excel spreadsheet for easy reference.
I'm in need of a dynamic excel sheet that will assist in managing the daily and weekly activities of our vehicles. This sheet should be able to track various aspects such as: - Maintenance schedules: Keep tabs on when each vehicle is due for maintenance. - Fuel usage: Monitor fuel consumption over time to identify any discrepancies or patterns. - Trip logs: Record details of each trip for future reference. The ideal freelancer for this project should be highly proficient in Excel and have experience in creating dynamic, interactive spreadsheets. They should also have an understanding of vehicle operations and be able to incorporate relevant features into the planner. Key features of this planner should include: - Automated scheduling: The sheet should be able to auto...
I'm looking for a professional to customize my recipe website using the Newspaper (TagDiv) theme. The primary goal is to boost user engagement through a clean, modern design and optimized site structure. Key Tasks: - Tailoring a visually appealing layout to recipe content....a clean, modern design and optimized site structure. Key Tasks: - Tailoring a visually appealing layout to recipe content. - Integrating high-performing SEO keywords to enhance visibility. - Ensuring fast loading speed and mobile responsiveness. - Structuring the site for optimal SEO and user interaction. Ideal Candidate: - Expertise in WordPress and TagDiv Newspaper theme. - Strong SEO and keyword research skills. - Ability to deliver a professional, modern design. - Experience with recipe or food con...
I require an Excel expert who can help me create complex data lookup and reference formulas. Specifically, I need assistance with VLOOKUP and HLOOKUP.
...one-off gig, but a long-term collaboration aimed at scaling the store. Key Responsibilities: - Develop fully functional niche eCommerce sites on OpenCart, alongside a comprehensive master site. - Initial upload of 100 products, inclusive of category creation and filter setup. - Quarterly addition of a minimum of 300 products, with a target of 10,000 by year-end. I will provide all product data in Excel format and URL to images. - Implement necessary APIs for automated order fulfillment. - Regular site maintenance, including yearly opencart CMS and theme upgrades. - Gradually incorporate SEO support and an affiliate marketing module, and collaborate with influencers over time. Ideal Candidate: - An individual (not an agency or company) - Proven expertise in OpenCart, with a port...
I'm seeking an SEO expert to enhance my blog's visibility on Google. The primary focus is on improving the search engine ranking of my website, , which is primarily a blog about flaxseeds. Key Requirements: - Proven experience in SEO, particularly for blog content - In-depth knowledge of Google's ranking algorithms - Ability to create and im...an SEO expert to enhance my blog's visibility on Google. The primary focus is on improving the search engine ranking of my website, , which is primarily a blog about flaxseeds. Key Requirements: - Proven experience in SEO, particularly for blog content - In-depth knowledge of Google's ranking algorithms - Ability to create and implement effective SEO strategies - Skills in keyword research and content optimization
I'm looking for someone to help me merge several files, including Excel, CSV, and one HTML table, into a single unified Excel file. The files contain various investor types and their information. Key Requirements: - Combine all information from the original files into the new table. - Prioritize the organization of the table by investor names. - Categorize the unified table by investor type. Ideal Skills and Experience: - Proficient in Excel with strong data handling skills. - Experience in data consolidation from various file types. - Ability to categorize and format data in a logical manner. Please note, I want all the information from the original files to be included in the new table. The final product should be an easy-to-navigate table that is organized ...
...to store, edit, view BOM. - Functionality to filter data based on all possible fields with multi level sorting. Allow full flexibility for user to filter and sort data based on multiple fields. - Report generator to generate all types of reports. User selects multiple fields and multiple sorting options to generate reports to track consumption and show inventory levels. - Import/export data to Excel format - Backup/restore database - Page to add/view/delete suppliers - Settings page to manage various options and create look up tables for various fields. - Data display must use pagination - Access & activity logging Your responsibilities will include: - Designing and implementing the web interface - Ensuring the system is robust and able to handle a large amount of data - Ma...
I'm seeking a dedicated professional to help take my Amazon electronics business to the next level. Key Responsibilities: - Optimizing product listings to enhance visibility and appeal. - Implementing effective SEO strategies to improve product rankings. - Writing compelling, keyword-rich product descriptions. Ideal Skills & Experience: - Proven track record in Amazon product listing optimization. - Strong SEO skills with a focus on ecommerce. - Excellent copywriting abilities, particularly for product descriptions. - Experience in the electronics sector is a plus. The perfect candidate will also be able to follow precise instructions and work well with my suppliers from around the globe. If you have experience in these areas and can help drive my business forward, I�...
I need a detail-oriented virtual assistant to help with data entry tasks. The primary responsibilities will include: - Inputting data from a specific website into spreadsheets. Ideal skills and experience: - Proficiency in using spreadsheets (Excel, Google Sheets) - Previous experience in data entry - Strong attention to detail - Ability to work independently and meet deadlines.
I need a professional who can assist me with posting apparel products on my Alibaba store. The primary focus will be on optimizing these listings for the North American market. Key Tasks: - Keyword Research: Find and implement the most effective keywords to enhance the visibility of the product listings. - Product Posting: Help in posting the selected apparel products on the store. Ideal Skills: - Experience with Alibaba platform - Proficient in SEO, specifically keyword research - Understanding of North American market trends in apparel - Knowledge on product posting procedures on e-commerce platforms. I am looking for someone who can not only help with the technical aspects of posting but also ensure that the listings are optimized for maximum reach and impact.
...experience. Login & Registration Validation: Implement mobile login with OTP and email confirmation. Streamline the registration process for a smoother user experience. Admin Invoice Correction: Resolve gaps in invoice details. Make the delivery address mandatory during order placement. Order Fulfillment Text: Change "Order Fulfill" text to "Dispatched" in the admin panel. Order Download Excel Sheet: Add fields like SKU, product name, contact details, coupon codes, and shipping address. Display transaction ID from the payment gateway in invoices. Order History: Enable date-wise order history in both admin and user panels. Email/Text Notifications: Set up email SMTP and text notifications for order updates. Review Module: Validate reviews to b...
...who can assist me primarily with creating engaging presentations in PowerPoint. Your role will also encompass data analysis in Excel and document formatting in Word. Key Responsibilities: - Crafting compelling PowerPoint presentations, inclusive of custom graphics and charts, animations and transitions, and overall template design and layout. - Conducting thorough data analysis in Excel. - Formatting documents in Word to a professional standard. Additionally, I require assistance in boosting my Instagram followers and likes organically, without risking a ban on the platform. Ideal Skills and Experience: - Proficient in Microsoft Office Suite (PowerPoint, Excel, Word). - Exceptional graphic design skills, particularly for creating PowerPoint presentations. - Exp...
As a freelance SEO Specialist for our SMMA agency, your primary focus will be on the E-commerce sector. Your main goal will be to increase our organic traffic. Key responsibilities: - Develop and implement effective on-page and off-page SEO st...strategies specifically tailored for E-commerce - Conduct thorough technical audits - Build high-quality backlinks - Optimize content (primarily product pages) to improve search engine rankings Ideal skills and experience: - Proficiency in SEO tools like Google Analytics, SEMrush, and Ahrefs - Proven track record in improving organic traffic Deliverables: - Comprehensive SEO audits - Regular keyword ranking reports - Demonstrable traffic improvements If you're passionate about SEO and have a knack for E-commerce, we'd lo...
...experience. Login & Registration Validation: Implement mobile login with OTP and email confirmation. Streamline the registration process for a smoother user experience. Admin Invoice Correction: Resolve gaps in invoice details. Make the delivery address mandatory during order placement. Order Fulfillment Text: Change "Order Fulfill" text to "Dispatched" in the admin panel. Order Download Excel Sheet: Add fields like SKU, product name, contact details, coupon codes, and shipping address. Display transaction ID from the payment gateway in invoices. Order History: Enable date-wise order history in both admin and user panels. Email/Text Notifications: Set up email SMTP and text notifications for order updates. Review Module: Validate reviews to b...
I'm looking for a proficient software developer to create a Desktop application for managing our company's incoming and outgoing documentation. This project aims to transition our current system, which relies heavily on MS Excel and VS Code, to a more streamlined and efficient software solution. Key Requirements: - The software should be a desktop application, specifically designed for Windows operating system. - It should incorporate functionalities for automated data entry, and reporting and analytics. - Ideally, the software will transform our current manual processes into a fully automated system, significantly improving our operational efficiency. Skills and Experience: - Proficiency in desktop application development, with a strong focus on Windows systems. - Exten...
I'm seeking a skilled ASP.NET developer to create a simple one-page application for report display. The design should be modern and minimalist. Key features of this project include: - **Report Grid**: The grid should include sortable columns, pagination, and search functionality. - **Export Functionality**: The application should support exporting reports in Excel and PDF formats. - **Design**: A clean, modern and minimalist design is crucial for this project. I will handle the ADO connection string and SQL command creation. Proficiency in ASP.NET and web form development is required. Experience with creating interactive report displays will be a significant advantage.
...Expertise in creating and managing Google Ads campaigns specifically for YouTube video promotion. 2. Ability to target the right audience to maximize views, engagement, and retention. 3. Proficiency in keyword research and implementing targeted ad strategies. 4. Experience with budget optimization to achieve cost-effective results. 5. Strong analytical skills to monitor and improve campaign performance. 6. Knowledge of YouTube analytics and audience behavior. Responsibilities: Set up and manage Google Ads campaigns for our YouTube videos. Conduct thorough audience and keyword research. Optimize ad placements to ensure high visibility and ROI. Monitor campaign performance and provide detailed reports. Suggest and implement strategies for improved video eng...
