How to use excel pivot tables to organize datamunkák

About the Role I’m looking for a highly experienced, proactive Virtual Assistant to support me across multiple areas, including podcast management, event coordination, strategic research, and personal assistance. The ideal candidate is a self-starter who thinks critically, spots gaps, and leads tasks from start to finish with minimal oversight. Strong organizational skills, excellent written English, and independent problem-solving are essential. Since you will interact with high-net-worth individuals, investors, and senior stakeholders, professional communication, reliability, and discretion are crucial. ________________________________________ Key Responsibilities ? Podcast & Content Management • Manage guest bookings (scheduling, follow-ups, collecting mater...

Freelancer Task: Azure MS SQL Database & Data Pipeline Setup Project Scope The freelancer will deploy a cloud-based Microsoft Azure SQL Database, set up an automated data pipeline for Excel uploads, and provide a management interface for querying the data. Requirements 1. Azure SQL Database Setup Deploy an Azure SQL Database (PaaS) instance. Create three tables using data from provided Excel sheets. Define appropriate data types, constraints, and indexing for optimised performance. Provide SQL scripts for table creation and initial data import. 2. Azure Virtual Machine (VM) for Management Provision an Azure Virtual Machine (Windows-based) to serve as a management server. Install and configure Microsoft SQL Server M...

I need a professional to gather and train a dataset of 5000 crime scene objects for me. The focus is primarily on weapons, but the dataset should include a wide variety of items such as: - Guns - Knives - Explosives - Footprints - Bloodstains - Cars - Bicycles - Victims - Motorcycles - Mobile phones - Watches - Laptops - Shoes - Beds - Tables - Chairs - Bottles - Books - TVs - Cups - Spoons It's important that all these items are included in the dataset. The ideal freelancer for this project would have experience in data collection and training for object detection, particularly in the context of crime scene investigation.

I have a Python backend and a React frontend. I need someone to combine both and make my website work. The integrated website should be able to: - Display data using tables and lists - Handle form submissions I also have some existing APIs that need to be integrated into the website. Ideal Skills: - Proficient in Python and React - Experience with API integration - Ability to create simple data visualizations using tables and lists Please note this is currently an unpaid project. I can offer a maximum of 200INR for this task, but am willing to pay more in the future for the right person. If you're interested in helping me, please feel free to reach out.

...someone to analyze my bank statement, which spans 36 months. The statement is in PDF format and is 5-6 pages long, one side only. You will need to itemize each month's interest charged, calculate total interest and penal charges, and the amount credited to the principal. Key Requirements: - Prepare a detailed table with the interest calculations and charges. - Identify and note any changes in interest, specifically the shift from 6.60% to 9.1%. - You will need to focus on all months in the statement for this analysis. - Highlight any unusual charges or discrepancies in the statement. Ideal Skills and Experience: - Proficiency in data analysis and finance. - Experience with PDF data extraction and analysis. - Ability to prep...

visual studio code aplicacion con fiori element, efectuando la llamada de servicios odata 4.0 o 2.0(estan creados ambos). el odata trae datos de una tabla de sap de 5 columnas , 2 de las columnas necesitan ayuda de busqueda y hay que generar 3 botones . 1 boton 1 grabar datos 2 boton 2 agregar linea 3 boton cargar excel Lo creado se debe ingresar A sap para estar disponible a usar en fiori Se debe realizar en dos dias.

I have a Word document containing names, emails, numbers, specialties, subspecialties, states, and cities. I need this data entered into an Excel spreadsheet with separate sheets for each category. Key requirements: - Proficient in Excel and data entry - Attention to detail to ensure data is accurately transferred - Ability to organize data into separate sheets by category

...in supply chain contexts, to assist with an assignment. The project will involve using Excel Solver to tackle various complex problems related to inventory management and demand forecasting. Key Objectives: - Apply linear programming and integer linear programming models to optimize and simulate supply chain scenarios. - The primary goals are to minimize costs, maximize efficiency, and optimize resource allocation. Constraints: - The model must account for various budget, capacity, and time constraints. Ideal Skills: - Proficiency in Excel Solver and mathematical modelling. - Strong understanding of supply chain management, particularly in inventory management and demand forecasting. - Expertise in linear programming and integer line...

I'm seeking a skilled mobile app developer to create a Free Fire tournament conducting app. This application should be compatible with both iOS and Android platforms. Key features of the app: - Organize and manage Free Fire tournaments seamlessly. - User-friendly interface for easy navigation. - Real-time updates and notifications for participants. - Robust backend to handle multiple tournaments simultaneously. - Add a payment gateway to earn money through conducting tournaments Ideal Skills and Experience: - Proficient in mobile app development for both iOS and Android. - Prior experience in developing gaming or tournament apps is a plus. - Strong understanding of user-friendly design principles. - Ability to create a reliable and efficient backen...

...UI/UX designer with a strong background in data visualization to create a welcome screen/dashboard for my application. Key Responsibilities: - Design a welcome screen/dashboard that primarily serves the purpose of data visualization. - Incorporate charts and graphs as well as tables into the design. We have the live platform setup with the data we need, but would like fresh eyes to create a new layout and design elements that we can deploy throughout the application. Tiles, buttons, other elements are needed. Current desktop and mobile view is attached, we’d like the main sections to display as charts, but then open/drill down in page with the list view details. We have a full in house development team in house building this, ...

I am in need of an advanced Excel developer to create a sophisticated spreadsheet for budgeting purposes. The spreadsheet should have the following features: - Revenue forecast - Budget variance analysis - Deal profitability and margin assessment - Expense tracking: Monitor and categorize all expenses with ease. - Break-even analysis: Calculate the break-even point for budgeting purposes. The spreadsheet will primarily handle manual data entry. The ideal freelancer for this project should have extensive experience in developing complex Excel spreadsheets, particularly for budgeting. They should also be adept at creating user-friendly interfaces for manual data input. Knowledge of financial modeling and data analysis will be a plus.

I'm seeking urgent help with two practice exercises relating to effective RSI calculations for steel stud walls and thermal gradient & dewpoint plotting. - Areas of Focus: The project specifically involves both effective RSI calculations for steel stud walls and thermal gradient & dewpoint plotting. - Data: I have some initial data and calculations prepared, but it's only partial. - Explanation: I require both steps and final results to be explained to me. Ideal Skills and Experience: - Proficient in Excel and familiar with 2023 National Building Code, Alberta Canada Edition. - Experience in dealing with thermal and structural calculations. - Ability to explain complex concepts in a simple, understandable way. - Hands-...

Hallo, ich suche einen fähigen Excelprogramier mit kenntnissen in der Lohnsteuer. Als Anlage habe ich den akutellen Ablaufplan zur berechnung der Lohnsteuer beigefügt. Mein bisheriger Nettogehaltsrechner muss auf den neuen Ablaufplan angepasst werden. Dieser Rechner wird dann Bestandteil eines Rechners für die betriebliche Altersvorsorge. Viele Grüße Holger Konermann

...in need of a diligent professional to assist with entering and managing inventory data in our computer systems. This role requires a keen eye for detail and the ability to handle various data tasks efficiently. Key Responsibilities: - Inputting inventory data into spreadsheets and databases. - Identifying and rectifying any errors in the data. - Organizing and updating records on a daily basis. - Ensuring all information is handled with the utmost confidentiality. Skills Needed: - Proficient typing speed and accuracy. - Basic understanding of Microsoft Excel and Google Sheets. - Exceptional attention to detail. - Self-sufficient and able to work independently. Qualifications: - A high school diploma or equivalent is requi...

I'm looking for a freelancer who can independently manage and accurately transfer information from various sources into an Excel spreadsheet. The specific sources will include paper documents, spreadsheets, and online forms. The ideal candidate should have experience with data entry, attention to detail, and proficiency in Excel. Key Skills Required: - Data entry - Excel proficiency - Attention to detail

... Home Page (Page Builder): A dynamic landing page customizable via a page builder, featuring multiple banners with slides, sub-banners with links, new arrivals section, product categories display, flash deals, and a brand logo slider. Search: A robust search function allowing users to find partners, categories, and products using keywords. Search results are displayed with navigation, filtering options (item, category, type), alphabetized listing, and detailed product pages. Add to Wishlist: Allows users to save favorite products for later purchase. Content Screens: Informational pages including About Us, Terms & Conditions, Disclaimer, Privacy Policy, Payment Options, Social Media Links, Careers, FAQs, Shipping and Refund Policy, and Free and Easy Refund de...

I have an Excel with 5 soccer leagues and I would like the games and the position in the classification of each team to be updated every day. It would be to associate Excel with the Internet and refresh the sheet with a button. My budget is 15 euros.

I need assistance with data entry, specifically handling numerical data sourced from online databases. The specific format for the entered data will be confirmed later but it is likely to be an Excel spreadsheet or a CSV file. Ideal Skills: - Proficiency in data entry - Experience with numerical data - Familiarity with online databases - Attention to detail - Ability to work efficiently and accurately

...freelancer skilled in MS Excel for manual data input and preliminary data cleaning. Key Responsibilities: - Manual data input: Accurately transcribing data into Excel spreadsheets. - Data Cleaning: Primarily focused on removing duplicates from the dataset. Ideal Skills: - Proficiency in MS Excel - Strong attention to detail - Experience with data entry and data cleaning tasks The dataset is expected to have up to 1,000 rows. The project should be completed within a week. Please ensure data formatting to meet specified standards. Please follow common data formatting practices for clarity and consistency. No additional data cleaning tasks are required other than remov...

I’m seeking a LinkedIn specialist to assist with: Data Research: Identify ideal prospects using criteria like profile, industry, and location. Proficiency in LinkedIn Sales Navigator and other tools is required. Profile Evaluation: Analyze prospects to assess fit, interest, and potential need. Strong knowledge of Sales Navigator is essential. Data Filtering: Sort and refine data based on relevance and priority using Sales Navigator and other tools. Data Organization: Organize prospect data into structured formats (e.g., spreadsheets) while ensuring accuracy and consistency. Personalized Messaging: Craft and send tailored connection requests and messages to drive engagement. Expertise in Sales Navi...

...looking for an expert who can integrate AI logic into Excel to automate complex calculations and enhance my Excel sheet's capabilities. The project primarily revolves around automating tasks with the help of AI. Key Requirements: - Expertise in Excel and AI - Proficiency in automating complex calculations - Experience in integrating AI logic into Excel - Experience in integrating machine learning models into Excel - Experience in creating custom functions in Excel - Familiarity with optimization algorithms and their implementation in Excel - Proficiency in scripting or programming languages such as Python or VBA In addition to the automation, I would also like the AI to assist in optimizing certain functions ...

I'm in need of a spreadsheet that can effectively track employee tasks. The spreadsheet should include the fol...spreadsheet should include the following details for each task: - Assigned Employee: It should be clear who is responsible for each task. - Name of Task: A column for the name of the task. - Notes: A space for any relevant notes about the task. - Ongoing: A column to indicate whether the task is ongoing. - Link to SharePoint: A space for a link to the relevant SharePoint page. The ideal freelancer for this project should be proficient in Excel and have experience creating spreadsheets for task tracking. They should also be able to create a user-friendly, intuitive layout. The spreadsheet should also be repeated for 2026 etc at the bottom...

I'm looking for someone to help with a data entry task. The data will need to be entered into an Excel spreadsheet.

I need an expert in MySQL for data analysis. The primary focus is descriptive analysis using data from CSV/Excel files. Key Responsibilities: - Analyze data from provided CSV/Excel files using MySQL. - Conduct descriptive and predictive data analysis to extract insights. Ideal Skills: - Proficiency in SQL. - Strong background in data analysis, particularly descriptive analysis. - Experience working with data from CSV/Excel files.

...designer who can convert an existing Excel line graph into a more visually appealing format using a specific colour template. Additionally, I need another graph, which is currently an image, to be redrawn and converted into the same colour scheme. Both graphs need to be delivered as new images compatible for inclusion in a Canva document, with a transparent background mask Key Requirements: - Convert an Excel line graph and an existing image of a graph into a format (note I have roughly done this so just needs to be redrawn properly using consistent line weights etc) - Implement a specific colour template using multiple Hex codes that will be provided - Make both graphs the same width/height (ie: same size) - Deliver final images in JPEG format (g...

I need detailed working drawings for a full office cabin's furniture. The designs should be in a modern style and encompass: - Desks and chairs - Storage units and shelves - Meeting tables and seats Ideal candidates will have a background in interior design and furniture engineering, with a portfolio showcasing modern office designs. Experience in creating detailed, precise working drawings is crucial. A keen understanding of modern aesthetic and functional requirements of office furniture will be highly advantageous.

I'm looking for ...looking for a social media expert to manage my overseas education consultancy's Instagram account. Your task will be to create engaging posts that align with my brand guide and focus on the following types of content: - Educational Posts: Share valuable insights about overseas education, study tips, scholarships, etc. - Student Success Stories: Showcase the achievements of students who have benefited from our consultancy. - Live Q&A Sessions: Organize and host interactive sessions to engage our audience and address their queries. Ideal candidates should have: - Proven experience in managing Instagram accounts, preferably in the education sector. - Skills in content creation, social media strategy, and community engagement. - Ab...

I'm looking for an Excel Power Query expert who can assist me loop functionality needed asap . - Proficient in Excel and Power Query - Experienced in data transformation tasks - Ability to create calculated columns Please include your relevant experience in your bid.

I'm looking for an expert in AWS and data processing to create an automated system for generating and sending extensive Excel reports based on credit card transactions data stored in an S3 datalake. Key Requirements: - Extract and process data using AWS Lambda - Generate 40 comprehensive reports on a weekly basis - Implement extensive data transformations and aggregations into the reports Ideal Skills: - Proficiency in AWS, particularly S3 and Lambda - Strong experience in data processing and transformation - Excellent skills in Excel - Prior experience in generating automated reports

I need a freelancer to redraw my existing company logo to enhance its quality and make it suitable for professional use. The final deliverables should be in both vector and raster formats. Ideal Skills: - Graphic Design - Logo Design - Vector Graphics - Raster Graphics Requirements: - Redesign of the existing logo - Delivery in both vector and raster formats

I'm looking for a skilled VBA expert to assist with Excel automation. Key Responsibilities: - Automate data entry processes - Implement custom data validation rules Ideal Candidate: - Proficient in Excel and VBA - Experienced with creating and implementing custom validation rules - Able to deliver efficient, streamlined automation solutions

Doing a database search for the selected databases and sending an excel sheet containing the search results

Game Concept Description Title: City Builder Simulation Game Overview: We are looking for a scriptwriter to create an engaging narrative for a city-building simulation game where players can interact with various characters and design their own city environments. The game will focus on immersive storytelling, character development, and dynamic interactions that enhance the overall gameplay experience. Key Features: City Building Mechanics: Players will construct and manage their own city, making decisions about zoning, resource allocation, and infrastructure development. Include challenges such as natural disasters, economic fluctuations, and community needs. Character Design and Development: Create diverse characters with unique backgrounds, personalities, and roles within the c...

? About the Project We are building an AI-powered Voice & Text Bot to automate cold outreach, lead qualification, and follow-ups via calls and SMS. The system will use Claude 3.5 for AI conversation handling, Twilio & Bandwidth for VoIP & SMS, LiveKit for real-time AI voice streaming, and a web dashboard for analytics, lead tracking, and performance monitoring. ? AI Voice & SMS Bot System ? Tech Stack ✅ Claude 3.5 – AI text generation & objection handling ✅ Twilio & Bandwidth – SMS & VoIP for AI-powered calls & text automation ✅ LiveKit – AI voice streaming for real-time conversations ✅ Deepgram STT – Speech-to-text (STT) for AI-powered transcriptions ✅ Deepgram TTS – AI-generated voice for outbound calls ✅...

...storage and data management needs. The software should be compatible with both Android and Windows, and the primary purpose of this service is for backup and restoration of my files. Key Requirements: - Cloud Storage: The main function of the software will be to backup and restore my files securely. - Automatic Backups: The software should come with a feature that allows for automatic backups at set intervals. - Data Management: I have an Excel sheet filled with data that I want to manage through this app or software. The data should be converted and organized into a database that I can easily navigate and manipulate. Ideal Skills and Experience: - Proficiency in software development for both Android and Windows. - Experience with crea...

...Research Assistant (Unpaid Internship)** **Duration:** 3-6 months **Location:** Remote (Web-Based Operations) **Reporting to:** AI Development Team **Responsibilities:** - Assist in developing AI algorithms for physiotherapy applications. - Conduct research on machine learning models, motion tracking, and posture correction techniques. - Analyze patient data to improve AI-driven recommendations (with data privacy compliance). - Collaborate with developers to test AI models and suggest improvements. **Requirements:** - Pursuing/completed Bachelor’s in Computer Science, Data Science, or related fields. - Basic knowledge of Python, AI/ML concepts, and data analysis tools. - Strong problem-solving skills with a...

...calories , exercise, weight etc 2) Booking tickets and cancellation 3) Arranging parties etc. I would like to start with Tracking nutrition. In this task, Myself and Wife will share audio notes of the food we took , screenshot of exercise app , etc and this needs to be tracked on an excel sheet ( along with calorie input etc) on a daily basis. We can keep sharing this on a whatsapp group and at the end of a day (or every 2-3 days) the excel sheet needs to be updated. I will share a sample excel sheet we use for calorie tracking , calorie value will be there for the usual foods we take in that sheet. For new ones you need to use websites like nutritionix or apps like healthifyme to get the information. For Body weig...

We need an excel fully automated document for the insurance industry that can carry out the following system functions: 1) Excel to receive a word presentation from admin staff for 1 products called Rural Combined which will will contain a lot of data e.g. policyholder details, risk information e.g. names, dates of birth, property information, (risk addresses, sums insured), claims. 2) the risk information is extrapolated from the word (presumably into a CSV file and automatically driven into an excel rating calculator where it will undergo a number of functions to calculate a premium based on a set underwriting criteria where there will be rates built into the system The document will then produce a premium. 3) The information can then be mer...

...page stile, the payment of service, so creation of account, login and payment. It must have a form plugin to do questionnaire. At th eend of the questionnaire the AI must show a report baed on answers. The web must have a form plugin jotform) The job to do: make the landing pages with information of service, add the buy page of service using table price and direct ckeckout (you can use woocommerce); add jotform; integrate the questionnaire of jotform and the answer with AI to create the authomatic report. The questions of jotform and the answer of jotform must be saved inside my mysql database. So it is necessary use a plugin to create the tables and save the answer add a plugin or code to comunicate with an AI the plugin (wpauto...

I'm seeking a dedicated personal assistant/accountant for my engineering company. This role involves a blend of administrative and financial responsibi...financial records and bookkeeping - Processing invoices and payments - Preparing and submitting expense reports Essential Skills: - Proficiency in accounting software, particularly QuickBooks and Excel - Excellent organizational skills - Strong communication abilities -Familiar with google drive/sheets/earth Experience in the engineering sector would be a plus, but not necessary. What is crucial is your ability to handle the finances of a growing company with precision and professionalism. Role is for one big data entry project to start along with 1-2 hours a day of on-going to start but can lead...

...Telegram community builder and automation expert to create a tiered competition-based chat group for OnlyFans chatters. This project involves setting up a structured Telegram group with multiple tiers, automated verification, tournament systems, engagement bots, and security measures to prevent poaching. The goal is to create a self-sustaining ecosystem where top-performing chatters compete in daily, weekly, and monthly challenges, with high-performing individuals being recruited into our OnlyFans agency. This is a one-time project with the possibility of ongoing work if needed for maintenance, optimizations, or expansions. Scope of Work: 1. Telegram Group Creation & Structure Setup Set up a public Telegram group using Topics to organize differe...

...an expert to help me manage my sales team. This role will involve tracking performance, training and development, as well as incentive planning. I currently use software tools to monitor the team's performance, but I need someone who can help me interpret the data and make strategic decisions to improve our sales outcomes. Key Responsibilities: - Monitor and analyze sales team performance - Design and implement effective training programs - Develop and oversee incentive plans to motivate the team - Set clear and achievable performance metrics for the sales team - Conduct regular team meetings to discuss progress and address concerns - Develop and implement sales strategies to boost revenue growth - Create and manage a peer m...

...need of a data entry expert who can assist me in compiling and entering mixed data sourced from online databases into a database. Ideal Skills and Experience: - Proficient in data entry with a focus on mixed data (both numeric and textual) - Experience working with online databases - Familiarity with database software and tools - Detail-oriented with a strong focus on accuracy - Able to manage time effectively to meet deadlines - Experience in querying databases using SQL or other querying languages - Strong skills in data cleaning and preparation - Expert proficiency in Microsoft Excel or Google Sheets for data manipulation Your role will involve: - Sourcing mixed data from various online databases - Accurately ent...

I'm seeking an Excel expert who can help me create a spreadsheet for analyzing viewing and analysing our machine assets and what stage of 'hire' they are on. Should have the ab ability to pick an asset and see the next 6-12 months, or pick a month, set of month, have one view of all assets etc Key Tasks: - Design a user-friendly Excel spreadsheet tailored for viewing and analyzing - Focus on tracking the 'Asset Hire Status'. The ideal freelancer should have: - Extensive experience with Excel, particularly in designing spreadsheets for data analysis. - Strong understanding of operational metrics. - Ability to create a spreadsheet that can track specific metrics effectively.

1. Data Entry - Accuracy and Efficiency: I specialize in entering large volumes of data quickly while maintaining a high level of accuracy. My methodical approach ensures that all data is correctly inputted and organized. - Data Cleansing: I can enhance the quality of your data by identifying and correcting errors, ensuring consistency and reliability in your datasets. 2. Excel Proficiency - Advanced Excel Skills: I possess extensive knowledge of Microsoft Excel, including advanced functions, pivot tables, and data visualization techniques. This allows me to not only input data but also analyze and present it effectively. - Macros and Automation: I can streamline data processes through automa...

Hi, I'm looking to convert CMM to an application with the following features ordered by necessity with the top 3 being the most important for now. Need help with some other coding items but wanted to get this project in motion and can fine tune the code as we go Main coding issue - having Airbnb, VRBO and all travel site bookings to feed automatically. The guest who booked yesterday was from Airbnb and we then have to manually add to CMM to track all data and calendars on our backend for direct bookings and other sites mixed together into one calendar. I need all bookings to auto sync to the system / owner / calendar / automation immediately upon booking confirmation. WEBSITE TO APP FEATURES: Tr...

I'm looking for a professional with a technical background to create a PowerPoint presentation with 50 slides from a book with 78 Pages that you need to summarize well. The primary purpose of this presentation is for educational and training purposes. Key Responsibilities: - Summarizing key concepts and definitions from the book into the slides - Designing the slides with appropriate shapes, transitions, and movements to engage the audience Ideal Skills and Experience: - Proficient in Microsoft PowerPoint - Technical background with experience in shape design - Ability to create visually appealing slides with charts, graphs, images and illustrations, and tables - Prior experience in creating educational/training PowerPoint presentations

I need the content of my PDF book converted into Amazon Kindle (MOBI) and ePub formats. The book contains tables and images, which will require special attention during the conversion process. Additionally, the table of contents needs to be interactive in the final eBook formats. Ideal Skills and Experience: - Proven experience with eBook formatting and conversion - Familiarity with Amazon Kindle and ePub standards - Ability to handle complex formatting, including tables and images - Experience creating interactive elements in eBooks - Attention to detail and commitment to quality

...Translators, and Data Entry Experts Description: I am seeking freelancers with expertise in the following areas: Content Writing: Articles, blogs, and creative story writing. Typing and Copywriting: Fast and accurate typing skills for various projects. Translation: Professional translation services for documents and content. Medical Writing: Assistance with healthcare-related content and research. Data Entry: Accurate and efficient data management. Diet & Public Health Research: Creating reports and articles related to diet and health. PowerPoint Presentations: Creating professional and engaging presentations. Excel Work: Data analysis, charts, and spreadsheet management. Requirements: Strong attention to detail. Relevant...