How to use excel pivot tables to organize data jobs

Clean home page: slider, attractive promotions, well-organised categories, no duplication. Footer with appropriate links, no words in English. Clean product and category pages (advanced filters, appropriate images). Optimised shopping basket and payment. Mass import of products via Excel file. ATUM confirmed for stock management. Delivery methods configured (zones and extensions). Site ready to inspire confidence and sell.

I'm looking for a highly skilled tutor in Excel and KoboToolBox to teach me data collection/visualization/evaluation. Excel: - Help me improve my data analysis skills - Explain complex concepts in an easy-to-understand manner, provide practical examples, and guide me through various data analysis tasks KoboToolBox: - Creating surveys - Teach me how to collect, visualize, and evaluate data Ideal Candidate: - Strong background in data analysis, proficient in Excel, and highly experienced in using KoboToolBox for data collection. - Excellent teaching skills, patience, and the ability to adapt to my learning pace.

I'm looking to implement a day trading strategy using an automated trading setup in Excel with the Shoonya Finvasia broker. This setup will focus on trading options. Key Requirements: - The system must be capable of automated order execution. This is crucial as it will allow for timely responses to market movements. - The system should have a backtesting feature to test trading strategies on historical data. Ideal Skills and Experience: - Proficiency in Excel and experience with creating trading systems within it. - Familiarity with day trading strategies, specifically in options trading. - Understanding of automated order execution systems and their integration within Excel. - Prior experience with the Shoonya Finvasia broker would b...

I'm in need of an Excel Macro specialist who can assist in extracting tables from multiple PDF files into Excel. Budget - 20 Max Key Requirements: - Expertise in Excel Macro development - Experience in data extraction from PDF files, particularly tables - Ability to deliver a quick turnaround Ideal Skills: - Proficient in Excel and Excel Macro - Skilled in handling and processing PDF files - Fast and reliable with a strong attention to detail. Please note, the task involves multiple PDF files, so the ability to handle bulk data and automate the process efficiently is crucial. I look forward to your bid and your proposed timeline for completion.

...inspire and educate people how to change and transform their lives. As an international teacher, I have taught in Australia, New Zealand, Peru, and Mexico and have assisted hundreds of people to find inner peace through yoga, meditation, & counselling. As a Coach and Therapist, I have pioneered a wholistic approach that assists people to transform their lives, using Yoga Therapy and Somatic Psychotherapy. This work has been recognised for assisting and affecting positive change in hundreds of people particularly those who suffer from anxiety and depression disorders. As am Empath & Intuitive I also communicate with animals and nature and teach people how to connect with the magic of life in this you want to create profound c...

I'm currently using a Selenium driver via Excel VBA to scrape a website, but I'm running into some issues that I need help fixing. The project involves a scrollable table where the link element needs to come into view before data can be extracted. Key Problems: - Extracting data from the table consistently fails. - Many elements are not found when trying to scroll the table into view. Methods Tried: - I have attempted using Execute JavaScript to scroll the table into view. I am happy to share my current code and provide access to the website so that you can see the problem first hand. I am looking for a freelancer who has experience with Selenium and Excel VBA and can help me fix this quickly.

I'm currently using a Selenium driver via Excel VBA to scrape a website, but I'm running into some issues that I need help fixing. The project involves a scrollable table where the link element needs to come into view before data can be extracted. Key Problems: - Extracting data from the table consistently fails. - Many elements are not found when trying to scroll the table into view. Methods Tried: - I have attempted using Execute JavaScript to scroll the table into view. I am happy to share my current code and provide access to the website so that you can see the problem first hand. I am looking for a freelancer who has experience with Selenium and Excel VBA and can help me fix this quickly.

I'm seeking to secure funding of $500k to purchase a transportable mixed-use facility. This facility will primarily serve both current and ex-Defense personnel. Key Features: - Mixed-Use: The facility will function as both accommodation and a toilet facility. - Disability Accessible: The facility must cater to wheelchair accessibility needs. Ideal Skills and Experience: - Experience with disability-compliant design and construction - Knowledge of transportable facilities - Previous work related to Defense personnel or military projects - Fundraising or grant writing experience. Proposals from those with relevant experience will be prioritized.

I'm in need of an experienced freelancer who can efficiently scrape sales leads from LinkedIn and Crunchbase. I want to target specific job titles within various industries, focusing primarily on the technology sector. Target Job Titles: - CEO/Founder - Technology head - Instrumentation head - Quality head - Digitization manager - Methods and process excellence The primary focus of this project is on gathering phone numbers of these targeted users. However, the deliverable should also include a CSV or Excel file with validated data points such as names, job titles, company details, and contact information. Along with this, a brief report detailing the scraping methods used would be appreciated. Your proposal should include your budget and an estimated timeline...

I'm seeking an Excel expert proficient in creating complex formulas. The task involves working with financial data. The project is a test for a Financial Planning and Analysis (FP&A) profile, consisting of three questions. The formulas need to generate accurate financial projections.

I'm looking for an Excel specialist who can help me compare three files containing inventory data. Specifically, I need to identify quantity discrepancies and item mismatches. Key Responsibilities: - Compare data across three Excel files - Identify quantity discrepancies and item mismatches - Create a separate summary sheet highlighting these differences Ideal Skills: - Proficiency in Excel with extensive experience in data analysis - Detail-oriented with a knack for spotting discrepancies - Ability to organize data in a clear and concise manner

I need an Excel expert to design a spreadsheet for me that includes various charts and graphs for data visualization. The project specifically requires the creation of bar charts and pie charts. Ideal Skills: - Proficiency in Microsoft Excel - Experience in designing custom Excel spreadsheets - Ability to create clear, effective data visualizations Please note, the main purpose of the Excel file has not been defined yet, hence flexibility and adaptability will be key in this project.

I'm looking for an expert in data extraction and cold outreach to help my merchant export company. Key Responsibilities: - Extract data of purchase managers from the United States, United Kingdom, and Australia. - The data should include their Name, Email address, and Phone number. - Organize the extracted data into a CSV file. Ideal Skills: - Proficiency in data extraction and analysis. - Experience in B2B cold outreach, specifically targeting purchase managers. - Familiarity with export-import industry is a plus. - Excellent attention to detail and data accuracy. Your role will be pivotal in helping me initiate email campaigns and WhatsApp bulk messages to potential business partners.

...users will be able to download their ID cards from their dashboard. The admin panel should allow administrators to monitor user sign-ups, view user data, and manage memberships. Requirements: 1. User Registration and Membership Form: User Registration: Users should be able to register on the platform via email or social login (optional). After successful registration, they should be directed to a membership form. Membership Form: The form will include fields such as: Full Name Email Phone Number Address (optional) Date of Birth Profile Picture Upload Other relevant membership fields as per business requirements. After submitting the form, the user will receive a confirmation message or email. 2. User Dashboard: Once the user submits the form, they wi...

I'm looking for a skilled Excel Macro specialist to automate the importing of data from PDF files into my Excel spreadsheet. Fixed Pay - $20 Key Responsibilities: - Create an Excel Macro to automate data entry from PDF files into Excel. Ideal Skills and Experience: - Proven experience with Excel Macros. - Proficiency in data manipulation and automation. - Familiarity with importing data from PDF files. - Excellent problem-solving skills.

I'm seeking a proficient developer to create an AI agent for me. The agent's primary function will be to locate fitness-related businesses in multiple specific regions. The collected data will need to be organized into an Excel table, including details such as: - Name and website of the business - Location and contact details - Person name and job title An example of the task would be finding all personal trainers in Redcliffe, Australia, Postcode 4020. Ideal Skills and Experience: - AI and machine learning development - Data mining and web scraping - Proficient in Excel and data organization - Understanding of fitness industry would be a plus

I'm looking for someone to help me create a financial model in Excel focused on budgeting. The primary task will be filling in the blanks with the appropriate formulas. Ideal Skills: - Proficient in Excel - Experience in financial modeling - Knowledgeable in budgeting processes Please ensure your proposal highlights relevant experience and skills.

I need assistance with matching two lists of brand and company names. The data is in Excel format. - The first list has 4 columns and the second list has 1 column. - The type of matching required is 'fuzzy match'. Ideal skills for this project include proficiency in Excel, experience with data analysis, and knowledge of fuzzy matching techniques. The work needs to be completed by Friday morning India time .

I'm looking for a skilled developer to transform my MS Excel files into a functional web application. Key Requirements: - The web application should be focused on data entry and form submission. - It should be compatible with desktop only. Ideal Skills: - Proficient in web application development. - Experience with data entry and form submission interfaces. - Understanding of desktop compatibility requirements.

I'm looking for a freelancer who can download numerical data from a specific website and organize it in an Excel spreadsheet. The data is updated daily every 3 min, so this will be a regular task. Requirements: - Download and organize all available numerical data columns from the website into Excel. - This task needs to be done daily in sync with the website's updates. Ideal Skills: - Proficiency in Excel and web data extraction. - Attention to detail and ability to follow daily schedules.

...come to a complete stop (idle state), ensuring new and unique screens are captured after each spin. Avoid taking screenshots while reels are in motion or incomplete states. Image Organization: Label all screenshots accurately with identification details such as video ID and channel name. Save and organize screenshots into a structured folder system for easy retrieval. Adherence to Guidelines: Follow established procedures to maintain consistency across screenshots for multiple machine types. Ensure that all reel symbols, graphics, and screen details are clear and fully visible in the captured images. File Management: Review each screenshot to ensure quality, clarity, and accuracy. Organize images into designated folders based on video ID or s...

I'm looking for a professional Excel macro developer who can help me create a macro that extracts specific information from one Excel file and organizes it into another new Excel file. Key Requirements: - The Macro should be able to extract specific information from Sample A and make it into an organized Excel file exactly like Sample B. - NOTE: Sample A will have Comments on what specific information will be extracted and become Sample B. Hover over them to view the comments - NOTE 2: If some of the information in Sample A is Blank, then leave them blank for Sample B Ideal Skills: - Proficient in Excel, especially in creating and implementing macros. - Experience with data organization and manipulation in Excel. - Stro...

The objective of this project is to produce an instructional video utilizing Kali Linux to transmit an observer file to a WhatsApp number. This endeavor is intended solely for educational purposes. The following requirements must be met: 1. Kali Linux must be accessed via Oracle Virtual Machine. 2. The video should detail the process of creating the file in formats such as PDF, JPG, Excel, Word, or even video or audio files. 3. The file must be recognized as safe by WhatsApp and Android security measures. 4. The file should enable the sender to view the gallery photos and camera of the WhatsApp Android device. 5. The file must not contain any malicious algorithms. To receive payment, you must demonstrate that you have successfully complete...

Please Sign Up or Login to see details.

I'm looking for a data vendor who can provide a list of homeowners in Los Angeles, California, who have expressed interest in home improvement within the last two weeks. The list should include: - Name and contact details - Property details - Type of home improvement needed - List phone numbers for quick contact. Please deliver the list in an Excel spreadsheet. Ideal candidates for this project should have experience in data collection and analysis. They should be able to provide accurate, up-to-date information in a timely manner. Knowledge of the home improvement sector would be a plus.

I'm looking for a skilled Power BI professional who can create multiple operational reports. The data primarily comes from Excel spreadsheets and will be processed through Power BI. Your proficiency in Excel is crucial. Key Responsibilities: - Create operational reports in Power BI - Utilize Excel spreadsheets and Power BI as primary data sources Preferred Skills: - Mastery in Excel - Expertise in Power BI - Experience in creating operational reports Ideal Candidate: - Able to create visualizations such as bar charts and graphs, pie charts and doughnut charts, and heatmaps.

I'm seeking a proficient SQL developer with extensive experience in Sage X3 ERP. The task is to craft a query that compiles an Inventory Valuation by Date across multiple warehouses. The valuation method is FIFO. Key Requirements: - Expert in SQL with a focus on writing complex queries within Sage X3. - Deep understanding of Sage X3's data structure, particularly inventory and valuation data. - Ability to retrieve accurate inventory valuation details broken down by date. - Skill in referencing the correct tables and fields, and applying all necessary joins and conditions. The query should accurately reflect FIFO inventory valuation across multiple locations. Experience with this ERP system is crucial for success in this role.

Need Freelancer for development of excel spreadsheet tool for financial projections, scenario analysis and presentation materials for same. Spreadsheet function is to calculate cash position and standard EBIT/EBITDA information from 2023 to 2040 (pre-revenue through profitability) for a (renewable energy) technology development and licensing company: not manufacturer, not a software developer, nor SAS provider. The basic financial structure includes simple operating cost structure, project-based revenues, non-operating income, minimal capex and equity infusion. Project Revenue Types are: • License payments based on milestones related to tangible progress for design, construction and commissioning of commercial and annual annuities (royalties) based o...

I need assistance exporting quotes from an Excel price list into a Word document. The quotes should be organized by product category. The exported quotes should include the following details: - Product name and price - Vendor information - Quote expiration date Ideal skills for the job include: - Proficiency in Excel and Word - Attention to detail - Organizational skills

Please Sign Up or Login to see details.

I'm looking for an Excel expert to create a variable tracking Excel file for me. I will be inputting a list of 1000 or more 3-digit numbers (ranging from 1-5) like 123, 231, 542, etc. Key Requirements: - Track the movement of each digit (whether it's +1,2,3, or 4 or -1,2,3,4, and also 0 when the number remains the same in the next sequence). - Provide a tally of movements for each digit in each position. For example, digit 1 in position 1 moved +1 75 times into the next sequence, +2 100 times, and so on. - Allow me to constantly update the list of 1000 numbers. - I will be copying and pasting the numbers into the file. Outputs/Reports Needed: - A summary table that presents the movements in a clear and comprehensible manner. - Please use...

I'm looking for a freelancer who can design a modern style personal blog for me. The blog should incorporate the following key features: - A Newsletter subscription: I'd like my readers to be able to subscribe to a newsletter. - Advanced search functionality: Enable readers to search for specific content within the blog. - Responsive design layout: Ensure the blog is fully responsive and looks good on all devices. - Featured posts section: Highlight key or popular blog posts prominently on the homepage. - Categories and tags: Organize blog posts by categories and tags for easier navigation. - Dedicated 'About Me' page: Provide a separate page that gives readers information about the blog author. The designer should have a strong port...

I'm seeking a detailed contact list of roofing, restoration, and mitigation companies located in California & Florida. The list should be compiled into an Excel sheet and include: Construction Companies: 1. Mitigation 2. Restoration 3. Reconstruction 4. Roofing 5. Water, Fire, Hail Damage. - Company name and address - Phone number and email - Key contact person's name and role - Specific roles such as Owner, Sales Managers, and HR Ideal skill set for the job includes proficiency in data collection and Excel, and ideally, some experience or understanding of the insurance roofing and restoration industry.

Please Sign Up or Login to see details.

I need help analyzing a list of companies in Excel and identifying duplicates based on specific criteria. Your task will also involve assigning MTAuIDs to these companies according to a set of rules. Key Requirements: - Identify duplicate companies based on their Business Name - Assign different MTAuIDs to Joint Ventures - Assign the same MTAuID to DBAs, CEOs/Presidents, Trade Name companies, AKA companies, and divisions The list of companies includes additional key attributes such as Address, Email, Website, Phone numbers, and Type of Business. Please provide a description of your approach and the code you will use to solve this problem. Ideal candidates should have experience with data analysis, coding, and understanding of busi...

...of the Invention: This invention relates to software solutions designed for mobile devices, specifically targeting productivity enhancement. The system integrates task management, time tracking, collaborative tools, and AI-powered analytics to optimize user workflows and improve task execution efficiency. Background of the Invention: With the growing dependence on mobile devices, professionals and individuals increasingly rely on mobile applications to manage their daily tasks. However, existing solutions often lack comprehensive integration of task scheduling, collaboration, and performance insights. Users typically switch between multiple applications, leading to inefficiencies, data fragmentation, and reduced productivity. This invention seeks t...

I'm looking for a freelancer to assist with a copy paste and data entry project. The data is mixed - both numeric and textual - and is currently stored in various online sources. Ideal Skills: - Proficiency in Excel - Experience with Tally ERP software - Strong attention to detail - Ability to work with mixed data types - Prior experience with online data sourcing The final output needs to be in an Excel spreadsheet. Please ensure you can access and work with online data sources before bidding.

I'm seeking a data entry expert to assist with entering menu information. Specifics about the menu type, the data format, and the manner in which it will be provided are yet to be determined, but the need is immediate. Ideal Skills and Experience: - Proficient in data entry - Excellent attention to detail - Able to work under time pressure - Familiarity with common data entry software (Excel, Word, etc.)

I'm looking for an experienced data scraper who can gather information from various social media platforms. Ideal Skills: - Proficient in web scraping techniques - Familiarity with social media platforms - Excel data management skills The scraped data needs to be compiled in an Excel format. The specifics of the data to be scraped will be discussed in further detail with the chosen freelancer. Please include relevant experience in your proposal.

I'm encountering a problem with a MySQL query that joins multiple tables. The query is returning incorrect data, and I need a skilled developer to help identify the issue and debug the query.

Please Sign Up or Login to see details.

As a Site Verifier, you will verify a company’s existence through visual data by conducting a site visit to ensure that we provide reliable and accurate information to our client. JOB DESCRIPTION: • Conduct basic verification with the subject company’s authorized representative, such as line of business, key executives' names, etc. • Take pictures of the subject company and its vicinity per Confirmis’ standard operating guidelines. • Provide observation about the company to gauge activeness, e.g., staff working at the premise, loading/unloading of goods, etc. REQUIREMENTS: • Must be living in (or nearby) VILLAGE, PAOODONCHAI MUANG, CHIANG RAI, 57000, THAILAND • Has a camera or phone/tablet of quality with a camer...

I'm looking for a skilled data parser who can extract product information from a specified website and organize it into an Excel spreadsheet. The data that needs to be extracted includes product descriptions. Ideal candidates for this project should: - Have experience with web scraping and data parsing - Be proficient in Excel - Have an eye for detail to ensure all data is correctly captured and organized.

We are seeking a detail-oriented report reviewer to evaluate and provide constructive feedback on our research documents. The ideal candidate will have a strong background in analytical writing and be able to identify inconsistencies, errors, and areas for improvement. This role requires excellent communication skills and the ability to meet deadlines while maintaining high standards of quality. Responsibilities: • Review and validate prospect reports, ensuring that the information is concise, relevant, and aligned with business context. •Analyze and verify the accuracy of figures, statistics, and trends included in the reports. •Assess the reliability of the sources used and, when necessary, conduct additional research to corroborate data...

I need my Excel worksheet polished for print. The project involves enhancing the current layout of the worksheet, specifically to optimize it for printing. Key Requirements: - Adjusting the page layout and margins to ensure the worksheet is print-friendly. - Creating a green color scheme that is suitable for printing. Ideal candidate should have: - Proficient Excel skills especially in layout enhancement. - Experience in creating print-friendly documents.

I'm looking for a detailed Excel spreadsheet that covers the top 20 social media accounts for every sports team across the NBA, AFL (Australian rules football), NFL, MLB, IPL and international cricket. The accounts should span Twitter, Instagram, TikTok, and news outlets. Specific Requirements: - Top 20 Twitter accounts - Top 20 Instagram accounts - Top 20 TikTok accounts - Top 20 news outlet accounts - top 20 journalists covering the team - top 20 player accounts Each entry should include: - Account name - Profile link - Number of followers - Engagement metrics - Average post frequency: The average number of posts per day or week. Ideal Skills: - Proficiency in Excel - Familiarity with social media platforms - Ability to gather and analyze engagement met...

... At Area Ten we're looking for an Account manager to join our growing global SEO technology and service business headquartered out of Australia. This role will be focused on servicing North American clients and operate during Central Time. The focus of this role will be to assist clients with SEO but more importantly implementing the world's first and only programmatic SEO platform which already generates 60 million visitors a month across our clients on autopilot. Please view this explainer video for details We're after someone who lives and breathes Account Management and at a broader level digital marketing, who is passionate about delivering great results and service to clients. You will be working as part of a team of highly

Hey, im working on a c++ gameserver and i reworked all my files to protocol buffer All my systems worked fine. Now i just get an crash, i was able to identificate it but i dont know how to solve. Im looking for someone which have the needed tasks in c++ and well known in protocol buffers to solve it. Aswell i have an old copy with reference to take a look over if need. Im glad if anyone can help me.

Troubleshoot excel xlookup formula