Excel macro data comparison jobs
I'm seeking assistance with Power BI for the creation of reporting dashboards. Key requirements: - Connecting to Excel sheets as the primary data source. - Crafting interactive dashboards featuring charts and graphs. Ideal candidates should have: - Proficiency in Power BI. - Experience with Excel data connections. - Skills in designing interactive visualizations.
We are looking for a developer who can create a model using the Amazon API. We will provide access to the API. Below are the ...our Shopify store. Checking each listing one by one for price and stock updates is a tedious and time-consuming task. Task Description: We will provide a list of ASINs in an Excel file. Your task is to use the Amazon API to fetch the following data for each ASIN: Current Price Stock Status (in-stock or out-of-stock) This data should be updated daily. Example Scenario: On January 1, 2025, 1,000 listings are uploaded to our Shopify store with a price of $99 and stock of 10 units each. By January 2, 2025, the price for some products changes to $109, and stock drops to 5 units. Using the Amazon API, we need the updated data reflecting the...
I'm looking for an RPA developer with extensive experience ...developer with extensive experience in Microsoft Power Automate Desktop or UIPath. The primary goal is to automate repetitive tasks that involve data entry and file/document management. The automation should specifically interact with Excel and our own in-house ERP system. Key Responsibilities: - Implementing RPA solutions using Microsoft Power Automate Desktop - Automating data entry and file/document management tasks - Ensuring smooth interaction with Excel and our in-house ERP Ideal Skills and Experience: - Proficiency in Microsoft Power Automate Desktop - Prior experience with automating data entry and file management tasks - Familiarity with Excel and ERP systems - Strong und...
Hi. It’s supposed to generate teams based on data from several sheets, but it’s not working as I need. Additionally, I would like to have a button to update the data for each game week. I’m attaching the code so you can review it and help me out if possible. Thanks in advance!
I'm looking for an RPA developer with extensive experience in ...an RPA developer with extensive experience in Microsoft Power Automate Desktop. The primary goal is to automate repetitive tasks that involve data entry and file/document management. The automation should specifically interact with Excel and our own in-house ERP system. Key Responsibilities: - Implementing RPA solutions using Microsoft Power Automate Desktop - Automating data entry and file/document management tasks - Ensuring smooth interaction with Excel and our in-house ERP Ideal Skills and Experience: - Proficiency in Microsoft Power Automate Desktop - Prior experience with automating data entry and file management tasks - Familiarity with Excel and ERP systems - Strong und...
I'm looking for an engaging and interactive website where users can take multiple-choice mock tests. The site should also provide a comparison of each user's score against their peers. Key Features: - User-friendly, interactive platform for taking mock tests - Multiple-choice questions as the sole test format - Score analysis that compares applicants' performance Ideal Skillset: - Experience in designing engaging, interactive web platforms - Proficiency in developing online testing systems - Skill in creating comparative score analysis features
...have a comprehensive Excel file containing purchase and sale details that needs thorough analysis and a dashboard built in a corporate visual style. Key Requirements: - Dashboard: It should display stock quantity, total amount, and total quantity, broken down by brand, type, and color. - Stock Analysis: I need to see overall stock quantities by brand, type, and color, as well as date-wise tracking to see if a specific product is sold from a purchase date using FIFO method. - Purchase Details: Total quantity and amount of purchases should be calculated, alongside a slicer to view specific combinations of brand, type, and color. A macro to add new entries is also required. - Sale Insights: Total quantity and amount of sales, with a slicer for specific combinations, a ma...
I'm looking for an expert in Excel to assist me with creating a file for recording inventory data and summarizing financial data on a daily basis. Your tasks will include: - Setting up an Excel file to track inventory data - Creating a basic daily summary of financial data within the file Ideal candidates will have excellent Excel skills, experience in inventory management and financial data analysis, and a keen attention to detail.
Write a heading in your bid: Your location & if civil engineer then yes /if not then no for eg. " Lucknow, yes/No" Note: please read the project details before bid . I will only ...only consider the profile with heading only. I need Lucknow candidate for this project. And if you are a civil engineer then type yes otherwise no. I'm looking for a civil engineer based in Lucknow to assist with a data entry project. The ideal candidate will have experience in construction and be able to understand the context of the data. Key Responsibilities: - Data entry from PDF files into Excel spreadsheets - Ensuring accuracy and attention to detail Skills and Experience: - Based in Lucknow - Civil engineer - Familiarity with construction project data...
I'm looking for an Excel expert to create a financial data sheet for budget tracking. The sheet will need to: - Support budget tracking - Include automatic calculations Ideally, you have prior experience in creating similar sheets and can provide examples of your work. Your understanding of financial data and budget tracking will be crucial to the success of this project. Please ensure you have the necessary skills to create a comprehensive, user-friendly Excel sheet.
I'm looking for an Excel expert to create a file that will record my financial transactions, specifically sales and purchases. The file should also include automated calculations to help me keep track of these transactions easily. Ideal skills and experience for the job: - Proficiency in Microsoft Excel - Experience with creating financial tracking spreadsheets - Ability to implement automated calculations within Excel - Attention to detail - Good understanding of financial transactions
I need assistance in extracting data from PDF documents and entering it into an Excel spreadsheet. Data to be extracted: - Invoice Number - Date - $ Amount Looking forward to your bids!
I'm in need of an Excel expert who can help create a file suited for data analysis. Key Requirements: - The file should incorporate advanced Excel features, specifically Pivot tables. - The data to be inputted into this file will be manually sourced and entered. Ideal Skills and Experience: - Proficiency in Microsoft Excel, especially with creating and managing Pivot tables. - Previous experience in data analysis. - Attention to detail for manual data entry.
I'm looking to set up a straightforward cloud flow with Microsoft Power Automate. This flow should be triggered whenever any changes occur in a specific Excel file stored in SharePoint. Key Features: - Activation of a pre-written desktop flow upon detecting any alterations in the Excel file. - No additional tasks or notifications required post desktop flow execution. - The sole trigger for this cloud flow is any sort of modification to the Excel file. Requirements: - Proficiency in Microsoft Power Automate is essential. - Experience with SharePoint and Excel is highly desirable. - Skills in setting up simple, effective automation flows. Please note, this project does not require any error handling or notifications in case of flow failures.
I'm seeking an experienced professional to manage and enhance our Kaufland account over the next three months. If you excel in this role, there's potential for continued employment. Your primary responsibility will be to increase sales through targeted marketing campaigns on Kaufland, as well as optimizing our product listings for maximum visibility and appeal. Previous experience with Kaufland is a must, and a proven track record of driving sales on the platform will be a significant advantage. Our marketing strategy will be focused on Kaufland-specific ads. Therefore, familiarity with the platform's advertising systems and strategies is crucial. Your ability to create compelling ad content and strategically position our products within the marketplace will be key ...
Gather web browsing statistics. • Total views for all product pages. • Breakdown of views per product. • Total clicks on products from various campaigns or internal links. • Details on how users landed on AC product pages. • Key user information. • Number of products added to the cart (orders placed or abandoned cart). • Products ad...web browsing statistics. • Total views for all product pages. • Breakdown of views per product. • Total clicks on products from various campaigns or internal links. • Details on how users landed on AC product pages. • Key user information. • Number of products added to the cart (orders placed or abandoned cart). • Products added to wishlists. • Average time spent on AC product pages by...
I'm looking for someone who can help with data entry into an Excel document. The data is mixed, containing both text and numbers. As for formatting, I’m not entirely sure what’s needed at this point, so some flexibility and judgement will be appreciated. Ideal skills and experience: - Proficient in Microsoft Excel - Experience in data entry - Ability to handle mixed data - Flexible and able to make judgements on formatting - Attention to detail
...to be replaced by this application. - An application capable of managing a fleet of new and/or used vehicles (Cars, Motorcycles, Other Vehicles), detailing every minute characteristic of the vehicles. - Every detail of the vehicle is stored in order to have a detailed record even years later. - General vehicle data and accessories - Purchase data: supplier, invoice payable, cost, depreciation and vehicle stock in our fleet - Sales data with details of minimum price to be realised, final price, deposit, as well as invoices for the sale and transfer of ownership costs. These can also be automatically created with a single click. - Printout of sales contracts, order proposal, declaration of liability, for...
I'm seeking a meticulous data entry expert who can assist in manually entering data from my scanned documents into an Excel spreadsheet. Ideal Skills: - Proficient in data entry - Excellent attention to detail - Familiarity with Excel Experience Required: - Previous experience with manual data entry from scanned documents is a plus - Proven track record of maintaining data accuracy
...create a modern and interactive real estate app, similar to Zillow, but tailored for the Iraqi market. This project involves: - CRM Integration: Essential for managing customer relationships and tracking interactions. - Comprehensive Market Analysis Tools: The site should offer real-time data updates, historical property trends, and comparative market analysis. - User Interface: The site must feature interactive maps and listings, user-friendly navigation, quick search functionality and property comparison tool. Key components of the project include: - Implementing 3D real estate tours. - Utilizing MLS technology for the first time in Iraq. - Incorporating a translation tool, light change tool, and a robust search engine. - Ensuring excellent device emulation, SEO optim...
Top Skills, Strengths, and Experience: I excel in digital marketing and sales, with a proven ability to craft effective strategies that drive results. My expertise includes social media marketing, SEO, lead generation, and conversion optimization. I have strong analytical skills, enabling me to identify growth opportunities and deliver data-driven solutions. My communication and relationship-building skills are a key strength, helping me connect with clients and foster long-term partnerships. Services Offered: Digital Marketing Strategy Development: Crafting tailored campaigns to meet business goals. SEO and Content Marketing: Improving online visibility and engaging target audiences with high-quality content. Social Media Management: Creating, scheduling, and analyzing c...
...Performance Indicators (KPIs), which are outlined in a provided PDF. Initially, the data source will be from Excel. Language: Arabic then English Key Details: - Primary Users: The dashboard is intended for Executives, so it should be intuitive and visually appealing. - Visualizations: The dashboard should include a variety of visualizations, specifically Bar charts, Line graphs, and Pie charts. - KPIs: The KPIs to be tracked have already been defined and can be found in the PDF document. Ideal Skills: - Extensive experience with Power BI/Tableau - Ability to create executive-level dashboards - Proficiency in Excel - Knowledge of data visualization best practices - Experience interpreting and visualizing business data Your bid should reflect your ex...
I need an experienced Excel expert to correct errors on my existing timesheet salary calculator. Skills and experience required: Strong proficiency in Excel, experience in financial modelling, and familiarity with creating interactive and automated Excel sheets.
I'm looking for someone to edit my inventory data in Excel. The task involves moving data from one file to a new one with a different layout. The new layout requires: - Reordering columns - Adding new fields - Combining data from multiple sheets There are specific formatting requirements for the new layout, which includes the use of certain cell colors and font styles. Ideal candidates for this project should have: - Extensive experience with Excel - Strong attention to detail - Ability to follow specific formatting guidelines - Experience working with inventory data.
...skilled data scraper to extract information from the Costco mobile app. The task involves multiple locations and specific product IDs. here is the app: I have attached the locations, productids for which data needs to be scraped. I have also attached the sample data for fields which we need. Key Requirements: - Scrape data from the Costco mobile app for various locations and product IDs. - Gather a pre-defined list of information for each product (to be shared in an Excel file). - Output the data in a CSV file. Initially, I need the data for one location. If the first batch is successful, I will require the code used for the scraping as well. Ideal Skills: - Proficient in data scraping and using tools for web and app dat...
I'm seeking an experienced Amazon FBA Stock Manager to estima...include: - Forecasting sales for current products - Managing seasonal inventory trends - Coordinating with logistics partners - Analyzing sales data The ideal candidate should have: - Strong analytical skills - Excellent understanding of Amazon's marketplace dynamics - Experience in managing stock levels to maximize in-stock rates for both new and existing products - Ability to maintain a healthy Inventory Performance Index (IPI). Prompt communication is key, especially when informing the team about stock in China that needs to be liquidated. Skills in market demand forecasts, competitor analysis and supplier lead times are crucial. Proficiency in Excel is a must, and familiarity forecasting tools w...
I'm seeking an experienced Amazon FBA Stock Manager to estima...include: - Forecasting sales for current products - Managing seasonal inventory trends - Coordinating with logistics partners - Analyzing sales data The ideal candidate should have: - Strong analytical skills - Excellent understanding of Amazon's marketplace dynamics - Experience in managing stock levels to maximize in-stock rates for both new and existing products - Ability to maintain a healthy Inventory Performance Index (IPI). Prompt communication is key, especially when informing the team about stock in China that needs to be liquidated. Skills in market demand forecasts, competitor analysis and supplier lead times are crucial. Proficiency in Excel is a must, and familiarity forecasting tools w...
...delivering a detailed database of 7,000 US companies. Each company profile must encompass key details like the company name, and its associated emails (e.g CEO email, Owner email, Founder email etc.) along with the website. Key Requirements: 1. All data must be current and verified for precision. 2. Data must be sourced from credible platforms to ensure uniqueness, eliminating any duplication. 3. Final data should be presented in an orderly Excel or Google Sheets format. 4. Timely delivery within 7 days from the project start date. 5. Proficient use of data scraping and verification tools and platforms. Please ensure to read the project description carefully before bidding. If you're not in agreement with the budget or are unable to fulfill the ...
...delivering a detailed database of 7,000 US companies. Each company profile must encompass key details like the company name, and its associated emails (e.g CEO email, Owner email, Founder email etc.) along with the website. Key Requirements: 1. All data must be current and verified for precision. 2. Data must be sourced from credible platforms to ensure uniqueness, eliminating any duplication. 3. Final data should be presented in an orderly Excel or Google Sheets format. 4. Timely delivery within 7 days from the project start date. 5. Proficient use of data scraping and verification tools and platforms. Please ensure to read the project description carefully before bidding. If you're not in agreement with the budget or are unable to fulfill the ...
...restrictions: - Visibility of Microsoft Word and Excel icons on all local users' desktops. - Display of a specific, read-only folder on the C drive on all local users' desktops. The folder is a custom one, please reach out for specifics. The technician must have Windows 11 23H2 to ensure effective troubleshooting. Microsoft's Office 2021 should be included in the XML. Ideal skills and experience for this project include: - Proficiency in creating assigned access XML files for Windows 11 - Familiarity with Microsoft Configuration Designer - Access to Windows 11 23H2 and Office 2021 for effective troubleshooting - Ability to follow specific, detailed requirements attached is the xml file i am working with, i need someone that can edit it in order for word,ex...
I'm in need of a professional who can assist in creating top-notch Amazon A+ content for my product listings. This content should include enhanced product descriptions, comparison charts, and high-quality images. Key Components: - Crafting engaging and informative enhanced product descriptions - Designing clear and appealing comparison charts - Sourcing or creating high-quality images that meet Amazon's standards I will provide all necessary branding guidelines and requirements, so attention to detail and adherence to brand consistency are crucial. Ideal candidates should have a strong background in e-commerce content creation, particularly for Amazon, and be able to demonstrate previous successful projects of a similar nature. Experience with graphic design and ...
**Project Description: I am seeking a skilled freelancer to transform an existing employee schedule from a basic Excel format into a modern, visually appealing design. The goal is to enhance the user interface and overall aesthetics, making it intuitive and easy to navigate for both management and staff. The redesigned schedule should incorporate interactive elements and be adaptable to various devices, ensuring accessibility and usability. The ideal candidate will have experience in UI/UX design and a strong understanding of creating visually engaging digital tools.
I need a professional-grade Excel template with dropdown lists to help track visa statuses for employees. The template should have the following fields: - NAME/LAST NAME - PROFILE (Dropdown: RADS or OPS) - CONTRACT TYPE (Dropdown: FT or PT) - VISA PROCESS CALL (Dropdown: yes, not yet) - DATE (blank) - VISA (Dropdown: requested, lodged, granted, renewed) - FAMILY (Dropdown: yes, no) - VISA EXPIRES (blank) - PASSPORT NO (blank) - PASSPORT EXPIRES (blank) - RELOCATION (Dropdown: initial consultation, 5 days package, in progress) - FLIGHT (Dropdown: initial consultation, booked) - IT (Dropdown: requested, not yet) - CONTRACT (Dropdown: signed, approved, amended, in progress) - REPORTING COUNTRY (Dropdown: SCAN, UK, NA) - COUNTRY (Dropdown: AUS,NZ) - OFFICE LOCATION (Dropdown: Noosa, Sy...
...expert in data research who can help me investigate customer data. The primary focus will be on gathering staff contact information for 250 companies. I want the entire staff contact list with email and phone. This is the list of the 250 companies with their website links. Example of the staff list for first company CRMLS The ideal freelancer for this project should have: - Proven experience in market research, particularly customer data. - Strong analytical skills to interpret complex data sets. - Proficiency in Excel to organize and present the data. The final deliverable should be in the form of detailed Excel spreadsheets that clearly present the researched customer data. Provide
...designed for an upcoming presentation. The poster should creatively and visually engage the audience while clearly highlighting our research findings. Key specifications include: - Emphasis on our research findings - A creative and visually engaging style - Incorporation of charts and graphs, illustrations and icons, as well as photographs and images Ideal skills for the job are: - Graphic design - Data visualization - Experience with research poster design A portfolio showcasing previous engaging research posters will be highly regarded. presentation: Title Speak with Ease: Building Confidence in End-of-Life Communication for First-Year Paramedics Authors: [Your Names] Background Context: Importance of effective end-of-life communication for paramedics. Problem Statement: M...
I need a new WooCommerce template created, based on my design. The main goal of this new template is to effectively showcase product details, in the same design as blog posts use - while showcasing also a datafeedr comparison set accordingly. Key Requirements: - Ability to follow a specific design to create the template. - Knowledge of WooCommerce and PHP. - Understanding of best practices for detailing product information. Please note, this template will not require any related products or upsell recommendations. Therefore, the focus will solely be on presenting individual product details in an engaging and clear manner.
I need a PowerBI dashboard to monitor project performance. The dashboard should track progress against milestones and budget vs actual costs. The data sources include Excel spreadsheets and various Cloud services. Ideal skills and experience for this job include: - Proficiency in PowerBI - Experience in project performance tracking - Skills in connecting PowerBI to Excel and Cloud services - Expert in data visualization and interpretation -Understanding of budgeting terms - developing a dashboard that can be updated by end user
...engaging and interactive cricket betting website. The site should be equipped with crucial features like live betting, odds comparison, and user accounts. Key Requirements: - Development of a moderate level of user interaction. This includes creating user profiles and tracking activities. - A strong focus on real-time updates and seamless live betting experiences. - An intuitive odds comparison feature that enhances user engagement and competitiveness. Ideal Skills: - Proven experience in developing sports betting websites. - Expertise in creating interactive user profiles and tracking systems. - Strong understanding of live betting mechanics and odds comparison. Your bid should include examples of similar projects you've completed. Looking forward to wo...
I'm looking for a skilled developer to build an app delivering professional services (task management/organisation). This app should be av...that information will then need to be collated and presented to other users. Key Features: - Task management capabilities - User-friendly interface - Notifications - Capacity to involve multiple users - Users will input preferences and information will be provided/priorities will be amended based on those preferences - On the 'backend', I want it to create something like an excel spreadsheet, so data can be gleaned and used - Cross-platform compatibility Ideal Skills: - Proficiency in iOS and Android app development - Experience in building apps - Strong UI/UX design skills Please provide examples o...
I'm in need of a freelancer who can help me draft an audit report for a small city. The ideal freelancer for this project should be a seasoned report writer with extensive experience with Microsoft word and excel.
...professional to extract data from 500-700 high-quality photographed pages containing handwritten text. The primary task is to accurately digitize the information into a structured format. The key fields to extract and verify are: Full Name Email Address Phone Number Permission for Commercial Communications (marked as "Yes" or "No"). Consent for Image Rights Usage (indicated by an "X" or no mark). Additionally, if the process allows automation or is otherwise feasible, we would like to capture the following optional fields: Last Name Country Language City Instagram Handle Date of Birth Correlation with Photo File Number The Name, Email, and Phone Number fields are critical and must be thoroughly checked to ensure zero errors. Requ...
...support, customized control panel per user. Modern Interface: Clean, user-friendly and mobile-friendly interface. Per Message Charge: A system of charging per message sent. Users are charged according to the campaign type and sending volume. 2. WhatsApp Marketing Tools Bulk Message Sending: Sending messages to multiple people with a single click. Uploading Contacts: Uploading numbers in bulk via Excel/CSV file. Message Scheduling: Automatic sending of messages at a specific date and time. Multimedia Messages: Sending messages that support images, videos, documents and other media files. 3. Chatbot Features Auto Responder: Automatic sending of predefined responses to incoming messages. Smart Chatbot: Customizable message flows based on user behavior. Keyword Detection: Sending m...
E-commerce Product Optimization Overview: Our website's navigation is hindered by an overwhelming number of products and outdated categories, making it difficult for customers to find and compare items. We are seekin...appear in multiple child categories across different parent categories, creating inconsistency and redundancy. Ideal Solution: Logical, Function-Based Categorization: Products are grouped by primary function, enabling intuitive exploration, discovery, and comparison. Streamlined child categories under each parent category to eliminate redundancy. Products are assigned to the most relevant single category, avoiding cross-category duplication. Next Steps Enhanced product titles and descriptions based on logical categories Skill Sets: Excel chat-GPT Fami...
I'm in need of a skilled web scraper capable of extracting data from a webpage with 5,500 products. These products do not have variants, which should simplify the task. Data to be scraped: - Product name - Product Part Number - Product description (The product descriptions aren't formatted the same way for each product. They are inconsistent but similar.) The final deliverable should be an Excel/CSV file containing all the scraped data, sorted by product name. Ideal skills for this project include: - Proficient in web scraping - Proficient with AI - Experienced in data organization and Excel/CSV Please, only bid if you can deliver quality work in a timely manner. Thank you!
I require a professional who can convert my PDF files into editable Excel and Word formats while preserving the original formatting. The ideal freelancer for this job would have excellent attention to detail and experience with data conversion. After the conversion, I may need some additional services such as adjusting the layout and design or proofreading and editing text, so flexibility and a good command of English would be an asset.
...compile your own leads (no lead list provided) using tools like Google, Google Maps, or YellowPages. -Cold Calling: Initiate outbound calls to potential prospects, using both English and Spanish confidently. -Appointment Setting: Use our provided script (with the freedom to adapt your approach for better results) to schedule appointments with business owners. -Data Entry: Record all leads and appointments in our provided Excel templates. -Quality Assurance: Each appointment will be evaluated for validity before payment is released. Requirements: -Bilingual Fluency: Must be able to speak and write English and Spanish proficiently. -Equipment: You must provide your own computer, headset, and reliable internet connection. -Phone Software: We will provide phone/VOIP sof...
I'm in need of a Power BI dashboard that pulls from an Excel sheet to monitor regulatory compliance deadlines for various applications. The dashboard should showcase key information, such as application deadlines, compliance status, and the departments responsible for each application. Key Requirements: - Proficiency in Power BI and Excel is a must - Experience in creating dashboards for compliance tracking is preferred - Ability to ensure the dashboard can be updated on a weekly basis, in line with the Excel sheet Ideal Skills: - Power BI - Excel - Compliance Tracking - Data Visualization - Dashboard Creation
...freelance data entry to complete 2024 financial budget project in a short time. Data accuracy is essential. Define the scope of the job: Describe in detail the type of data that needs to be entered, the file format, and the amount of data that needs to be processed. * Define the skills required: In addition to basic data entry skills, you can include additional skills such as using Excel formulas or knowledge of accounting software. * Define the completion time: Provide a realistic completion time estimate. * Define the budget: Indicate the budget range you have prepared. Data Entry Freelancer Required for 2024 Financial Budget Project We are looking for a meticulous and efficient data entry freelancer to help us enter 2024 fi...
I've got an Excel dataset of 3500 parts that needs to be linked with their corresponding part drawings in the parts manual, which are all available as digitized PDF files. Ideal skills for the job include: - Proficiency in Excel - Attention to detail for accurate linking - Familiarity with handling and interpreting part drawings from PDF files The goal is to create a comprehensive and user-friendly reference that connects each part to its corresponding drawing.
