How to use excel pivot tables to organize data jobs

I'm looking for an Excel expert who can help me create a file that meets specific conditions. Here's the situation: - I have an Excel sheet with 4 columns: address (A), city (B), state (C), and zip code (D). I want in column E to automatically display the word "IMAGE". However, this word should function as a trigger: when hovering over it, a photo corresponding to the location will pop up as a note. This needs to work for every cell in that column. - There is address list - I need this to be done in an automated way. Requirements: 1. I want to be able to understand the solution, so I need you to explain it to me via video call. 2. I have experience with Excel but have hit a roadblock, so a ...

...purpose of use, and lighting requirements should be specified. 2.⁠ ⁠Explanation of the Modeling Process and Modifications The modeling process using software such as Dialux should be explained. Any modifications made in the model compared to the real situation (e.g., replacing specific light sources with alternatives, adjustments based on ideal conditions) should be described. The reasons and methods behind these modifications should be clarified. 3.⁠ ⁠Scenarios and Parameters Different scenarios tested during the modeling process should be explained (e.g., varying light levels, different lamp types, daylight simulations). The lighting parameters used (such as light intensity, color temperature, glare control) should be specified. Acceptable minimum values, standards, and ...

I have an excel sheet consisting of about 5000 lines and about 15 columns. The data is a bit random and requires advanced logic to organize. Due to company restrictions, I can't share the excel sheet directly, but I can provide snapshots and detailed descriptions of the tasks and formulas required. Key Responsibilities: - Utilize advanced Excel formula logic to sort data into specific categories. - Implement conditional calculations, data aggregation, and advanced filtering as per the project needs. Ideal Skills and Experience: - Proficiency in advanced Excel is a must. - Prior experience in data sorting and organization. - Strong analytical skills to understand and apply the required logic...

Dear [Client's Name], I am excited to apply for this data entry project. With experience in handling various data types, including text and numerical information, I can ensure accurate and efficient entry from Excel, Word, and PDF files into designated platforms. I have a strong eye for detail, excellent typing speed, and proficiency in Microsoft Office tools, ensuring high-quality and error-free data processing. My commitment to accuracy and efficiency makes me confident in delivering results that meet your expectations. I look forward to the opportunity to assist you. Let’s discuss how I can contribute to your project. Best regards, Wan Zakwan Fitri

I'm looking for someone to help me create a line chart in a spreadsheet to display comparable equipment data. This chart will need to compare more than 3 sets of data. Ideal Skills: - Proficiency in spreadsheet software (Excel, Google Sheets) - Experience in data visualization - Strong analytical skills - Attention to detail Please provide examples of similar work you have done in the past.

I have a set of last year's ticket sale data that needs to be entered into Excel. - Data Entry: The tickets are currently in Excel 10, and I need someone to accurately input all relevant data. - Excel Skills: Proficiency in Excel 10 is crucial, as the data will be entered into this software. - No Analysis Required: At this stage, I do not require any data analysis or reports generated from the entered data. However, a keen eye for detail will be beneficial to ensure accurate data entry.

I'm looking for a professional data entry expert to help me input mixed data from various digital files. Key Responsibilities: - Accurately enter mixed data (text and numerical) from various digital sources into designated platforms. - The data source will primarily consist of digital files such as Excel, Word, and PDF. - Ensure all data is entered correctly and efficiently. Ideal Skills and Experience: - Proven experience in data entry, particularly with mixed data types. - Proficiency in handling and navigating through Excel, Word, and PDF files. - Attention to detail and ability to maintain accuracy under pressure. - Excellent typing speed and computer skills.

Job Description: We are seeking an experienced Microsoft Excel specialist to develop a dynamic and automated spreadsheet to monitor the status of a loan contract. The spreadsheet should efficiently track loan payments, calculate interest, and provide a structured yearly overview of the loan’s status, including the available credit line. The final solution must be compatible with both Microsoft Excel for Windows and Microsoft Excel for Mac. Project Requirements: Input Data: Loan start and end date Interest rate (%) Maximum loan amount (credit limit) Loan payment records (date and amount) Core Calculations: Interest calculation for each loan payment Cumulative interest tracking Available credit line (credit limit minus utilized loan amount) Ye...

I need immediate help from an Excel expert to identify why my total on one financial sheet doesn't align with the revenue summary on another sheet. The task needs to be completed within 15 minutes. Ideal Skills: - Proficient in Excel - Quick analytical skills - Able to deliver under time pressure

I need a proficient Excel expert who can create a comprehensive profit and loss sheet for my agricultural business. Key Requirements: - The spreadsheet should be able to track profits and losses on an individual job basis. - The design of the sheet should be intuitive and user-friendly, with clear delineation of different sections. Ideal Skills: - Proficiency in Excel and data analysis. - Experience in creating financial tracking tools. - Understanding of the agriculture industry. Please provide a portfolio of similar projects you've completed, as well as any relevant industry experience.

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) Moo.10, Sukhumvit, Sukhumvit Rd, Samrong Nua, Mueng, Samut Prakan 10270, Thailand • Has a camera or phone/tabl...

Translator (Egyptian Arabic to English) – Technical & Programming Files Overview We are seeking a skilled translator with expertise in translating technical and programming-related content from Egyptian Arabic to English. The role involves accurately translating programming files, code comments, documentation, and other technical content while ensuring clarity, consistency, and proper technical terminology. The ideal candidate should have a strong understanding of both software development concepts and linguistic accuracy. Key Responsibilities Technical Translation: Translate programming files, code comments, documentation, and technical guides from Egyptian Arabic to English. Ensure translations maintain technical accuracy without altering the code’...

I need assistance to convert a PDF file into an editable Word document. The primary purpose of this conversion is to enable me to edit the text freely. The ideal freelancer for this project will have: - Strong attention to detail to ensure all formatting from the PDF is preserved in the Word document. This includes fonts, colours, spacing, etc. - Proficiency in Microsoft Word to handle potentially complex formatting. Please note, while the document does not contain any specific elements that need special attention, a general familiarity with handling tables, headers and footers, bullet points and lists will be beneficial.

...solution, as they all have purchase invoices to organize. The aim is to help them save time, optimize their accounting and better structure their financial documents. Core business: Invoice centralization EcoBill offers an online platform where companies can easily store, organize and retrieve their invoices. Key features - Centralized invoice storage - Easy import via file or photo - Organization and tracking for improved accounting management - Fast, structured access to facilitate financial management Automation technology is being developed to improve invoice processing, including automatic document recognition (OCR) and other tools to facilitate invoice import and classification. EcoBill also offers a loyalty option that enabl...

Convert 30 pages handwriting in Excel. Convert 30 pages handwriting in Excel. Convert 30 pages handwriting in Excel. Convert 30 pages handwriting in Excel.

...freelancer to design and implement a predictive maintenance system using big data analytics. The system should collect real-time sensor data (temperature, vibration, lubrication levels) and apply machine learning models to predict equipment failures. The goal is to optimize maintenance schedules, minimize downtime, and improve operational efficiency. Requirements: ✅ Data collection from real or synthetic datasets (Kaggle, HuggingFace, or generated data). ✅ Big Data technologies (Hadoop, Apache Spark) for real-time processing. ✅ Machine Learning models (e.g., Scikit-learn, TensorFlow) for failure prediction. ✅ Dashboard for visualization (e.g., Streamlit, Grafana). ✅ Clean and well-documented code (preferably in Python). Deliverab...

I have a spreadsheet that requires some help with data formatting, particularly with date and time entries. I need someone who can fix the incorrect date/time entries so that the spreadsheet is accurate and usable. Ideal skills for the job include: - Proficiency in Excel or similar spreadsheet software - Strong attention to detail - Experience with data formatting and troubleshooting

I'm looking for someone to help me organize my Gmail account. The primary goal is to categorize my emails into folders. Ideal skills and experience for the job: - Proficient in using Gmail - Experience with email management - Excellent organizational skills - Strong attention to detail

I'm seeking ... will need to be in French and include 5-7 pages of Excel sheets, featuring repetitive content. Key Aspects of the Project: - The most critical element of the presentation will be highlighting the company's growth potential. - The Excel sheets will be provided, so there will be no need for complex data analysis, but attention to detail and ability to present the data clearly will be essential. - Strong French language skills are a must, as is experience with financial presentations. Ideal Skills and Experience: - Proficiency in French, particularly in a business context - Experience creating financial presentations, especially for institutional investors - Ability to highlight key aspects of a business in ...

I'm seeking an experienced professional to design a compressed air piping layout for an industrial facility. The primary application of the compressed air will be for machinery operations. Key Requirements: - Design and layout of compressed air piping - Use of steel as the primary material for the piping - Consideration for industrial machinery operations in the design Ideal Skills: - Proficiency in industrial piping design - Extensive experience with steel piping - Knowledge of compressed air systems for machinery Please provide examples of similar projects you've completed, as well as your approach to ensuring efficient and safe design.

More details: Is this project for business or personal use? For an existing business What information should successful freelancers include in their application? Detailed project proposals How soon do you need your project completed? ASAP The target market for this project is tech companies. Targeting the global market for sales campaigns. The main goal is closed sales.

I am a data analyst in need of assistance with creating a sales report in MS Excel. Ideal skills for this project: - Expertise in MS Excel - Strong data analysis skills - Experience in sales report creation Looking forward to your bids.

...professional data analyst with exceptional statistical expertise and experience in creating clear and informative data visualizations. The project involves analyzing pre and post data for two groups (Group A: ages 18 to 65 and Group B) and their various outcome measures. Key tasks include: - Conducting statistical analysis for all outcome measures across both groups. - Creating pre-post data graphs. - Preparing statistical tables and visualizations of these analyses. - Producing histograms or graphs depicting normality. - Calculating effect sizes. The ideal freelancer for this project would be highly proficient in statistical software and data visualization tools, with a proven track record of similar projects. Clear and concise comm...

Vlog Editing & Video Editor Description Are you looking to transform raw footage into compelling, high-quality vlogs that captivate and grow your audience? We’re searching for (or offering) a skilled Video Editor who specializes in vlog editing and is adept at creating attention-grabbing thumbnails. The ideal candidate stays on top of the latest editing trends, YouTube best practices, and storytelling techniques, ensuring each video engages viewers from start to finish. Key Responsibilities Video Editing & Storytelling Review and assemble raw footage into a cohesive story that highlights the best moments. Perform color correction, audio mixing, and seamless transitions to maintain professional consistency. Incorporate motion graphics, titles, and lower-...

...professional data analyst with exceptional statistical expertise and experience in creating clear and informative data visualizations. The project involves analyzing pre and post data for two groups (Group A: ages 18 to 65 and Group B) and their various outcome measures. Key tasks include: - Conducting statistical analysis for all outcome measures across both groups. - Creating pre-post data graphs. - Preparing statistical tables and visualizations of these analyses. - Producing histograms or graphs depicting normality. - Calculating effect sizes. The ideal freelancer for this project would be highly proficient in statistical software and data visualization tools, with a proven track record of similar projects. Clear and concise comm...

I need a freelancer to fully set up two websites using a paid WordPress template that I will provide. The freelancer must handle everything from design setup, image selection, keyword research, and SEO content writing (100% AI-proof and unique). Scope of Work: Website Setup & Customization – Install and set up the provided WP template, organize pages, and ensure a professional layout. Image Selection & Optimization – Find high-quality images, Logo design, edit if needed, and optimize them for web performance . Keyword Research – Identify high-ranking, low-competition keywords for SEO. Content Writing (100% Unique & AI-Proof) – Write engaging, SEO-optimized content that passes AI detection and plagiarism checks. On-Page SEO – Optimize...

...for a developer to create a cross-platform mobile application (iOS and Android) similar to Uber, BlinkIt, or Urban Company. The app will primarily be focused on service booking and scheduling. Key Features: - The app should support two main user roles: Customers and Service Providers. - An intuitive interface for both user types is crucial, allowing customers to easily book services and service providers to manage their availabilities and bookings. - An administrative backend to oversee operations and manage users will also be necessary. - Payment Integration: Enable secure in-app payments via credit card, debit card, and popular payment gateways like PayPal and Stripe. - Geo-Location Services: Integrate location tracking to find nearby servic...

I'm looking for a skilled data scraper who can extract all available information from a specific e-commerce website. This includes, but is not limited to, product details, customer reviews, and pricing information. I need all available information. Please consider that there are also product variants. Work needs to be done today! The ideal candidate should: - Have a strong background in data scraping - Be proficient in using data extraction tools - Have experience dealing with e-commerce websites. The scraped data should be delivered in an Excel format. Please note, this is a one-time project, I do not require ongoing data scraping. If you read everything, please write "DATA" in your message.

I'm looking for a skilled developer to create a web-based stock market application enriched with AI capabilities. The app should allow users to query data from several database tables using Natural Language Processing (NLP). I prefer the use of Open AI or any other affordable and reliable alternative. Key Features: - User-friendly UI for both regular users and admin - Admin panel with options for query monitoring, usage tracking, limit settings, etc. - Basic user authentication system with email and password The application will need to integrate with various Stock Market APIs. Ideal Skills: - Proficiency in web application development - Experience with AI and NLP - UI/UX design skills - Knowledge of Stock Market and AI api - Backend devel...

...first book, which I plan to publish independently. The book will focus on how ma nagers can effectively handle difficult personalities in the workplace. The working title is Mastering Workplace Dynamics: How to Lead and Manage the Most Difficult People. I’m seeking an experienced book writer who can help me bring this vision to life. The writer will work with me to develop the manuscript, refine the structure, and ensure the content resonates with the target audience. Scope and Word Count: Word Count: Approximately 50,000 - 75,000 words The book will be divided into chapters, each focusing on a different difficult personality type found in work environments. Target Audience: This book is intended for managers, team leaders, a...

I need a skilled data analyst and visualization expert to create an interactive dashboard to track and analyze my online sales data. The dashboard should connect to a variety of data sources, primarily my sales database. Key Responsibilities: - Use complex parameters to drill down in the worksheet and customize using filters and slicers. - Create connections, join new tables, and perform calculations to manipulate data and enable user-driven parameters for visualizations. - Use different types of customized visualizations (bar chart, pie chart, donut chart, clustered bar chart, scatter chart, line chart, area chart, map, slicer, etc.) The primary purpose of this dashboard is to track sales performa...

I need a skilled video creator to plan, shoot, and edit 30 engaging Instagram reels each month. The primary goal of these reels is to enhance brand awareness. Key Responsibilities: - Collaborate with our team to conceptualize, plan, and execute 8-10 engaging content pieces per week. - Stay updated with the latest video editing trends and tools to enhance content quality. - Maintain and organize video files for easy access and future use. Ideal Skills: Proficiency in video recording and editing, with a strong portfolio showcasing past work. Must own an iPhone for video recording and editing. Creative eye for detail, storytelling, and visual aesthetics. Strong time management skills to meet tight deadlines. Ability to work both indep...

...Coursera, and other platforms. post content on various platforms like medium substack vocal media ✅ Handle call-to-action campaigns, SEO, and social media promotions. ✅ Research and implement growth strategies to expand online reach. ✅ Assist in executing new ideas, business strategies, and brand promotions. 2️⃣ Marketing Personnel (Part-time) ✅ Flood the web with the company's banners, posters, and videos. ✅ Handle mass content distribution across multiple platforms. ✅ Assist in basic marketing tasks & repetitive work. ? Flexible work schedule, long-term opportunity for the right person. ? Apply with your experience in digital marketing and content execution. Please ensure to track social media engagement as a key performance indicator. We are looking...

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 seeking assistance in extracting numerical data from individual stock pages on a website and storing it in an Excel file in a specific format for multiple stocks. This needs to be done monthly. - Data Points: The data points to be extracted include various metrics like annual sales, operating profit margin (OPM), net profit, and others. - Excel Formatting: The extracted data needs to be stored in a particular format in Excel. Ideal Skills: - Proficiency in Excel - Experience with web data extraction - Attention to detail to ensure data is accurately captured and formatted. Please note, I need this to be set up for monthly updates.

I am looking for a data operator to assist with a complex data entry project. The ideal candidate should have experience in data entry from digital files, specifically using Microsoft Excel. The work involves significant formatting and clean-up of the data. Skills and experience required: - Proficiency in Microsoft Excel - Strong attention to detail - Ability to handle complex data entry tasks - Experience in formatting and cleaning up data If you are meticulous, experienced in data entry, and proficient in Microsoft Excel, please apply for this project.

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.