Basic data entry knowledge pdf jobs

...On: - Carbohydrates: Explore and explain their effect on human body's molecular structure. - Proteins: Investigate their impacts, focusing on molecular processes. - Lipids: Analyze and detail how they influence the human body on the molecular level. Depth of Analysis: - The project requires an intermediate level understanding of the molecular aspects of these macromolecules, meaning neither too basic nor overly complicated. Sources Preference: - The research should be backed by credible sources mainly including: 1. Journal articles 2. Online databases Ideal Candidate: - Familiarity with biochemistry or related fields - Experience in academic writing and research - Ability to explain complex scientific concepts in a digestible manner. Documented in text and re...

I'm in need of a WordPress expert who can create and maintain simple yet effective blogs for me. These blogs are essentially a tool to promote my products and services d...informative, and ultimately persuasive for readers to convert into customers. - SEO: The blogs must be search engine optimized. Even if you're not an SEO expert, you should have a good understanding of what makes content rank well on Google and other search engines. The ideal freelancer for this job would have a mix of the following skills and experiences: - WordPress development and maintenance - Basic understanding of SEO principles If you believe you have the skills and time to take on this project, please bid and let me know how you intend to approach the task. Please include any relevant experie...

I am looking for an expert in copy typing who can accurately reproduce my English-language documents using the original materials that I will provide. The ideal freelancer for this task should not only have extensive experience in data entry and copy typing but also possess a keen eye for details to ensure the accuracy and fidelity of the reproduced documents. Exceptional skills in English language typing are a must for this job. Prepare to demonstrate past relevant projects.

I need an automation program that can handle my textual data entry and processing tasks.

I'm looking for a skilled PowerPoint designer who can create a visually appealing presentation based on a PDF paper summary for a topic (Why people use VPN). The main goal of this project is to present key findings, provide visual summaries, and enhance understanding through a minimalist and visual approach. - The presentation should include 10-20 slides - Each slide should be designed in a minimalist style with a strong emphasis on visual content - Design should be focused on delivering key findings and summaries in a clear and concise manner To take on this project successfully, you should have a strong background and experience in: - PowerPoint presentation design - Infographics and chart creation - Understanding of visual communication and information design Please in...

I require a skilled Java programmer to assist me with debugging a beginner-level program. Key aspects of the project: - Debugging: The main focus of this project is to help me fix basic syntax errors and runtime errors that I am encountering in my Java program. - Goal: The primary goal of this collaboration is to ensure that all identified bugs are fixed in the program. Ideal Freelancer: - Proficient in Java: The ideal candidate should have a strong understanding of Java programming, particularly when it comes to debugging and handling errors. - Patient and Detail-Oriented: As this is a beginner-level task, I am looking for someone who is patient and detail-oriented, to help me navigate through the debugging process.

...am looking for an expert in Doorbird system to help maximize the efficiency of my home unit, focusing specifically on: Access control: - Enable the system to control multiple doors and garage openers - Allow to lock/unlock remotely - Add a keypad entry system for a streamlined user experience. Automation: - Automize processes where possible for ease of use Ideal Skills: - Extensive knowledge in Doorbird systems - Experience in automating security systems - Expertise in integrating varying access control systems, particularly with keypad entry systems and magnetic locks Your will help me document the current setup, explore technologies and products to purchase, make a plan incl. wire diagrams. Proven experience with home automation (doorbird a1018, doorbird &lrm...

(ON SUNDAY EVERYTHING SHOULD BE DONE THAT IS THE CONDITION) I need a skilled frontend developer to create basic HTML/CSS pages. You will need to integrate these frontend pages with a Python backend. The project involves adding JavaScript for client-side validation and implementing AJAX page transitions. After pressing the 'save' button on one of the pages, the page should transition to the next. The data inputted should be sent to the Python backend for processing. Key Requirements: - Proficient in HTML, CSS, and JavaScript - Experience with client-side validation and AJAX - Prior work experience that showcases your frontend development skills - Proficiency in Python is a must for the backend implementation Please provide me with your relevant past work when you a...

...CPanel management, database administration (PHP), FTP, firewalls. WordPress Maintenance: Plugin updates, theme management, basic frontend/backend operations. Security Focus: WordPress hardening, malware/infection remediation, firewall configuration, virus scanning, intrusion prevention. SEO: Basic on-site/off-site optimization, Google Search Console, Google Analytics, Google Webmaster Tools, Google ReCaptcha, cookie consent implementation. The Ideal Candidate: Demonstrated WordPress administration expertise Strong security background with experience in infection cleanup. Proven ability to manage multiple websites simultaneously. Knowledge of SEO best practices. Excellent problem-solving and communication skills. Important: Our clie...

I'm currently looking for a React developer with knowledge in the use for FiveM, I'm just looking for a single developer, not companies or teams. I need the developer to do the frontend and call the events as the are called in the FiveM Game.

I need an expert to create Power BI slides for data analysis. - The primary objective is to assist me in analyzing the data from excel spreadsheets efficiently. - The slides are intended for basic data analysis. Therefore, the level of interactivity required is basic, encompassing features like tool tips and basic filters. Ideal candidates should have: - Proficiency in Power BI for data analysis. - Proven experience working with Excel spreadsheets. - The ability to create easy-to-understand visuals. - Good communication skills to understand the requirements and deliver the project urgently.

I have an ongoing project that involves the entry of text data from online sources directly into our website. Key Project Details: - Type of Data: Primarily text-based information - Data Source: Online sources - Organizational Structure: Directly input into our website Ideal Skills and Experience: - Proficiency in data entry - Experience with text-based data - Ability to navigate and use online sources - Attention to detail - Website data entry experience is a plus Please bid with your relevant experience and expected rates.

I need a data entry freelancer who can help me transfer 100 emails onto my website. - I'll provide you with the source of the data in PDF format. - You'll need to accurately copy and paste the emails onto the designated sections on the website. - The data should be organized in a way that's user-friendly for visitors. Ideal skills for this job include: - Proficiency in data entry, particularly copying and pasting. - Attention to detail to ensure the emails are transferred correctly. - Familiarity with website data entry would be a plus, but not mandatory.

...organizational skills to assist in a product sourcing and data entry project. This task involves purchasing Orangina soft drink from at least two different stores, entering specific product data on our platform, labeling the purchased items clearly, and preparing for their shipment to Ireland. **Task Overview:** - **Purchase Orangina:** Secure 29 bottles of Orangina from a minimum of two distinct retail locations. Preference for varying shops to compare regional stock variances. - **Data Entry:** Log into our online platform to input two critical pieces of information for each product: the best before date and the store from where it was purchased. - **Labeling:** Each of the 29 bottles must be labeled in a manner that correlates with the entered d...

...organizational skills to assist in a product sourcing and data entry project. This task involves purchasing Orangina soft drink from at least two different stores, entering specific product data on our platform, labeling the purchased items clearly, and preparing for their shipment to Ireland. **Task Overview:** - **Purchase Orangina:** Secure 4 bottles of Orangina from a minimum of two distinct retail locations. Preference for varying shops to compare regional stock variances. - **Data Entry:** Log into our online platform to input two critical pieces of information for each product: the best before date and the store from where it was purchased. - **Labeling:** Each of the 4 bottles must be labeled in a manner that correlates with the entered dat...

I have a simple C/C++ program that needs debugging on an urgent basis. I need someone who's an expert in C and C++ and can quickly identify and fix any errors in the code. Ideal candidate should: - Be proficient in C and C++ - Have a good understanding of basic functions and structures in C/C++ - Be able to quickly debug and fix errors -Syntax and Analysis Parsing - Have good communication skills and be able to work under tight deadlines The project is simple in terms of function and structure, so it should be quick work for the right person.

I'm in need of someone skilled in PDF file structures who can determine if a particular PDF has undergone editing, and to identify the edited segments. To help successfully complete this task, you should: - Have in-depth experience navigating the structure of PDF files. - Capably discern changes or alterations made to a PDF. - Provide a report indicating any modifications, where they occurred. When applying, please exclusively focus on detailing your experience with manipulating PDF file structures. Past projects involving this will be highly advantageous. Ideally, you will have worked on similar projects, where the goal was to detect alterations in the document. Looking forward to a seamless collaboration.

I need a skilled 3D artist with experience in Lumion or Enscape or any other software to enhance the renders of a pre-existing school structure I've already modeled. Its a academic project Key Points: - The school structure is already modeled, but requires expert touch to elevate the realism of the renders. - I have set the desired views and added basic materials. Your task will be to add the finishing touches, including lighting and human models for scale and context. - The desired output is semi-realistic renders. So, you should have a keen eye for detail and an understanding of how to achieve this level of realism within Lumion. - These renders will be used primarily for presentations, hence they need to be engaging and professional. Ideal Skills & Experience: - P...

In quick expansion of our consumer base, I am seeking an Italian native speaker to provide customer support primarily through phone calls. The ideal candidate will have basic knowledge of sales to facilitate successful interactions with our customers. Key Responsibilities: - Answering product-related queries via phone calls - Utilizing effective sales techniques to ensure customer satisfaction - Necessitate top-tier communication skills Essential Skills: - Native level Italian - Proven sales skills - Exceptional problem-solving capabilities - High-quality communication skills I invite those who fit the bill of a proactive problem solver with sales expertise and a passion for providing excellent customer support to consider this opportunity.

...clustering in Orange data mining software with the aim to segment and profile the churners in Customer Churn file. By applying the k-Means clustering you need to explore how many types of churners exist and what characterizes those types. More specifically, this assignment consists of two tasks:  Task a (Segmentation): Establish how many types of churners there are and the size of those types. This involves dividing the churners into segments.  Task b (Profiling): Profile and appropriately name the identified types of churners based on the values of their shared characteristics, i.e. variables. Your submission ought to include: 1. Orange workflow1 containing the k-Means clustering analysis of segments and profiles. 2. Summary file (max. 600 words; in PDF format) present...

PLEASE TAKE TIME AND READ CAREFULLY DO NOT SUMBIT ENTRY BEFORE READING YOU WILL BE REJECTED IF BELOW GUIDELINES ARE NOT FOLLOWED 1. **Design Concept:** Create a circular logo incorporating the letters "W" and "S" in an elegant font. 2. **Color Scheme:** Use gray as the primary color, beige/nude as the secondary color, and add a touch of gold metallic. 3. **Composition:** Ensure the logo is visually balanced and appealing within the circular shape. 4. **Tagline:** Consider a tagline like "Elevating Luxury Living" or "Creating Opulent Spaces."

I'm in need of an ex...that need to be handled were not decided upon, proficient data organization skills are essential as we may need to restructure large data sets. The ideal freelancer for this job should: - Have expert skills and proficiency in Excel and Access. Knowledge of other data organization tools will be considered a plus. - Showcase notable experience, specifically in dealing with large data sets and complex spreadsheets. - Since the specific tasks to perform were not mentioned, a flexible approach and ability to adapt with regard to potential data analysis and data entry tasks will be greatly appreciated. With your application, please include detailed description of your experience, particularly projects dealing ...

Hi, So i am here looking for some active participants to work on this task of listing. A test will be taken for the task. It's a one time task and won’t tale much of time. All the required information will be provided. Kindly make sure to ask everything to make things clear and the pay will ne given according to the task. Newbies are preferred. Please Note This Job not for India Pakistan and Bangladesh Thanks

...freelancer to design an HTML form for my website. This form must have: - Text fields for basic information collection - Dropdown menus for selection options - Capture creation The form should be designed with user-friendly, visually appealing elements. Your role will also include: - Implementing validation requirements for all input fields. This will ensure that the user completes all the required fields in the correct format. - Integrating an email script that will automatically send a reply to the submitter. This is an essential feature for my project. Ideal Skills and Experience: - Proficiency in HTML and CSS for form design - Experience in creating and implementing form validation - Knowledge of backend scripting languages for email automation - Understanding of u...

I am looking for a professional developer to create a comprehensive real estate website using React. As the client has not specified a particular function, it is anticipated that the website will provide common...creating intuitive, user-friendly design What to Include in your Application: - Samples of past work, especially of previous real estate websites you've created - Description of your experience with React and with real estate website development - A detailed proposal for the project, addressing all functionalities and anticipated challenges - Any suggestions for adding value to the project beyond the basic requirements I am excited about the possibility of collaborating with individuals who bring passion, expertise, and creativity to the table. Let's build somet...

I'm in need of a skilled video editor for my latest project. The primary goal is to ensure that the video is engaging and professional. Key requirements for this project are: - Basic editing (FCPX) to trim and arrange the footage in a coherent manner. - Quick turnaround: the project should be completed within a month. -Basic Color Grading We are a photography studio that does behind the scenes and highlight videos of our clients (women’s beauty, maternity, and newborns/children). I need an expert in Final Cut to be able to create captivating 4k videos (2-3 minutes in length and possibly vertical reels 1080x1920 of their sessions (all raw footage provided) we shoot with Sony A7s3 / s-cinetone color profile.

I need a React developer for immediate collaboration. The primary focus will be on frontend development, with special emphasis on creating a basic user interface, involving simple forms and buttons. Skills Required: - Proven experience in React, with a strong portfolio of work in frontend development. - Ability to work quickly and efficiently, meeting an immediate project deadline. - Familiarity with integrating APIs into a project. The ideal candidate will have: - Strong communication skills as this is an immediate requirement. - Prior experience working on simple UI/UX design. - A keen eye for detail and the ability to follow design specifications accurately. Please include examples of your work with your proposal.

...3D tour to enhance the user experience. User Experience for Lead Generation: - Contact Form Submission: Users should be able to submit inquiries through a contact form. - Direct Email or Call Option: Provide means for users to directly contact us via email or phone. - Schedule a Visit or Appointment Feature: Allow users to schedule visits or appointments. - Button for Download PDF Brochure: Include a downloadable PDF brochure about the project. Skills and Experience: - Proficiency in website development, particularly for real estate. - Experience in implementing interactive floor plans and 3D tour. - Strong understanding of lead generation and user experience. - Capability to integrate Google Maps and other multimedia elements. - Familiarity with creating user-friendly c...

I'm in need of a proficient typist for creative writing projects, specifically in the narrative genre. Key Responsibilities: - Transcribing creative content into digital format - Typing up documents with attention to detail and accuracy Ideal Skills and Experience: - Proven experience with transcribing or data entry - Excellent typing speed and accuracy - A passion for narrative creative writing Looking to hire someone who can take on a variety of creative writing materials and provide accurate and efficient typing services.

I am looking for a graphic designer to create a bold and colorful YouTube thumbnail for a podcast. The thumbnail should include a catchy phrase related to the main theme of the podcast, which is real estate and business. Skills and experience required for this project: Graphic design expertise, with a strong understanding of color theory and composition Ability to create eye...the guest, Dom Franco Instagram for a picture of them:   Here is a URL to the google drive with some of the raw video/audio files for context or ideas OR to get portraits of the hosts or guests: Maybe add the text to the thumbnail: House Hacking Military Style First good entry we will award

...meal plans: Including a diet that can assist with weight loss. Meal plans should be practical and easy to follow. - Nutritional counseling: Providing insights on healthy eating, lifestyle changes in support of weight loss goals. This might include tips on portion control, food choices, etc. - Delivery: You should be able to deliver the meal plans and conduct counseling sessions in written formats (PDF, Word, etc.). -Basically I am allergic to citrus fruits and apple so it would be better if don’t include those things in the diet plan. Ideal candidates should have: - Proven experience in developing meal plans for weight loss - A background in nutritional counseling - Ability to work with individuals seeking weight loss - Excellent communication skills Please indicate your...

I'm looking for a freelancer to develop a company profile for my business, with a primary focus on . The profile should be in PDF format and written in English. "Rqeem Valuation & Consulting is a certified entity by TAQEEM for providing business as well as machinery & equipment valuations for different purposes such as M&A transactions, internal decision making, litigation, and financial reporting. As a member of the Saudi Authority for Accredited Valuers (Taqeem), our enduring leadership, collaboration, and focus on anticipating what the future looks like for our clients has positioned us as a trusted partner in the industry." Key Requirements: - The company profile should be compelling, engaging, and concise, tailored to attract potential customers and ...

I'm looking for a skilled trading view indicator developer to create an indicator based on fair value gaps. The indicator will need to include alerts triggered by specific conditions. Details will be discussed later. Should have complete knowledge on trading view. Multiple timeframes will be used including the seconds timeframes. Key Requirements: Indicator: The focus of this project is to develop a robust trend-following indicator for trading purposes based on Fair value gaps. Details will be shared in detail. Basic knowledge about fair value gaps required. Platform: The indicator should be specifically designed for the trading view to work on all platform. Alert System: The indicator will need to include an alert system that can be triggered by specific con...

I need a skilled freelancer to extract table data from a PDF file. The extracted data will be used for analysis in a Microsoft Excel spreadsheet. Key Requirements: - Extract tables from a PDF - Ensure data quality and integrity - Deliver the data in a Microsoft Excel format Ideal Skills: - Proficiency in PDF data extraction - Strong understanding of table structures - Experience in working with Microsoft Excel - Attention to detail and accuracy is crucial look attached PDF and EXCEL then Bid, start Bid writing PDF and sample attached. So I know you look my file

...managing multiple tasks efficiently and possesses a keen eye for detail. Your main responsibilities will include: The budget is 100 USD a month. ( 6 hours a day, 6 days a week ) - Managing my emails with the utmost discretion and organization. - Scheduling appointments, ensuring I never miss an important date. - Conducting data entry tasks with accuracy. - Performing internet surveys to gather valuable information for projects. - Preparing ad-hoc reports based on collected data and research. Required Skills and Experience: - Proficiency in Microsoft Office Suite, especially in Excel, Word, and PowerPoint. - Familiarity with accounting software. Although not the main focus, this skill will probably be essential for financial tasks. - Exceptional organizational s...

Please Sign Up or Login to see details.

I need an Excel expert to help me with my spreadsheet. My spreadsheet has some formula errors that need to be fixed. The spreadsheet is not very complex; it mainly contains simple formulas and calculations. Ideal skills for this job: - Strong understanding of Excel formulas - Experience in fixing formula errors - Attention to detail After the fixes, I plan to use the spreadsheet for daily operations. I need help to fix the column titled "Total Shifts" and the row titled "TOTAL" - Both of these are not calculating the correct numbers when a selection is made from the dropdown lists in the table. I also want a report creating which will tell me how many of each shift type in that week the employee has done i.e if they have done 3 DayA shifts, 1 HfdayA shift and 2 midd...

...experienced developer specifically skilled in Backtrader and Interactive Brokers integration to create an intricate trading strategy. Key components of this strategy include: - Incorporation of risk management tools to safeguard investments - Multiple time frame analysis for comprehensive market overview - Utilization of Exponential Moving Average (EMA) in decision making I require the strategy's entry and exit criteria to be based on: - Moving average crossovers to identify potential market opportunities - Identification of support and resistance levels to pinpoint price boundaries - Breakout strategy implementation to exploit significant price moves I am open to discussing other elements that you think might be beneficial to the strategy, your in-depth understanding...

Mail server is getting attacked, I need to create a windows service constantly checking a .txt log file for preset keywords like "Failed SMTP login" or "Relay attempt" to auto block IP's. This service should auto add/delete a new entry to a existing "inbound windows firewall rule" with the hacker's IP for a specific period of time. A good example or a similar concept could be found here: Some of the settings that I need to control: – Duration to ban ip address (min) – Number of failed login attempts before ban – Whitelist of comma separated ip addresses to never ban – Blacklist of comma separated ip addresses to always ban – Custom keywords, XPath and Regex to parse logs for failed login attempts &nda...

I'm urgently looking for a professional who can create a customizable resume builder for me. It needs to be a simple and effective tool that allows users to easily input their information and then customize whi...sections - Ability to choose responsibilities to add for each employer from a list of responsibilities that can be added to. - The following sections are to be included: (1) Name/Contact information (2) Summary (3) Professional Experience (4) Technical Skills (5) Professional Designations (6) Education (7) Certifications. Export formats: - PDF - Word Not sure what format this would best be suited for. Could use Excel, Access, Word (as long as can select the data ie check box or something similar), or AI. The project is on a tight deadline, so I would apprecia...

I'm in the final stages of creating a 3D muscular anatomy video using Blender, but I need an expert to help me with the animation refinement and finalizing the video. Some key points: - The 3D video is almost complete, so you will be required to finish the last touches. - The animation refinement needs to focus on basic movements and functionality. This project requires someone with a keen eye for detail, a solid background in 3D animation, specifically with Blender, and a good understanding of human anatomy. Experience with similar projects or a background in medical animation would be a plus. I need someone who can understand the requirements of this project and bring it to completion with a high level of professionalism in the animation refinement. A passion for anatom...

I'm thrilled to be pursuing an exciting opportunity as a Sales Executive at Tidsol. As a novice in the sales industry, my focus has been in the tech products area. This targeted specialization could offer a perfect fit for Tidsol's objectives. The ideal candidate will exhibit a keen interest, a foundational experience in sales, and strong knowledge of selling tech products.

I'm in need of a skilled typist who can help me convert my PDF documents into editable text. The primary language of the documents is English. Requirements: - Type all the content in the PDFs accurately into a Word or Google Docs file. - Ensuring that there are no typographical or grammatical errors. - No specific formatting is needed, just plain text. Ideal Skills: - Proficiency in English language. - Fast typing speed with high accuracy. - Experience in PDF to Word/Google Docs conversion.

I'm in need of a skilled Virtual Assistant. The ideal candidate must be able to handle a variety of tasks such as: - Email management: Organizing and responding to emails in a timely and professional manner. - Scheduling appointments: Setting up and managing my schedule, ensuring I am kept on track. - Research and data entry: Undertake necessary research and input data accurately. Furthermore, proficiency in tools such as email, phone calls, and instant messaging is required for efficient communication. I am seeking someone who is available on a flexible as-needed basis. Previous experience in a similar role would be an advantage. Looking forward to your proposals!

...format the proposal in a modern and professional manner. Key Points: - The design of the Business Proposal should be modern. - It should include high-quality images that I have ready to provide. - The final output of this project should be in a digital format such as a PDF. Ideal Skills and Experience: - Proficiency in InDesign or similar design software. - Experience in creating visually appealing Business Proposals. - Strong eye for modern design and layout. - Ability to work with high-quality images. - Knowledge of digital document creation and formatting. Your task will be to take the existing content and images and create a visually appealing, modern Business Proposal that will impress potential clients and partners. Compliance with the information p...

My firm is in need of a reliable virtual assistant to support us with administrative tasks, data entry and customer support. Work will be done from home, anywhere in the world, between 8AM - 4PM EST. Key responsibilities: - Conducting a variety of administrative tasks - Ensuring accurate and timely data entry - Providing top-notch customer support Skills Required: - Intermediate proficiency in G Suite - Strong administrative skills - Effective customer dealing capabilities

...will provide the original artwork for the 3D boxes to the successful coder. The "cable(s)" or "connector(s)" should be designed in such a way, with a transparent background if necessary, that they can be "dropped into" a new marketing design project, alongside any combination of 3D boxes. *** All of the specific details and requirements of this project are carefully documented in the attached .PDF file. *** There is a keyword buried in the attachment that we mention clearly. Your bid proposal needs to include this keyword to demonstrate that you have taken the time to read the attached document carefully. Proposals that do not include the keyword are likely NOT to be considered because it shows a lack of interest in the details. IMPORTANT: We a...

My WordPress website is redirecting to unknown sites and showing signs of injected Javascript. I've experienced this issue despite keeping my WordPress and plugins up to date. Key Requirements: - Identify the malware and its entry point - Remove all malware and traces of injected Javascript - Restore website to its original, clean state - Provide recommendations to prevent future attacks I have full access to my website's hosting environment. Ideal candidates should have proven experience in malware removal for WordPress sites and possess a strong understanding of web security best practices. Please share your approach and experience in your bid.

I need an experienced content writer who has expertise in the areas of Artificial Intelligence, Cloud Computing, and Cybersecurity. You should be able to write engaging content for two main segments: business professionals who want to stay informed about these technologies, and beginners in tech who need easy-to-understand, entry-level guidance. - Frequency: Weekly articles - Audience: Business Professionals & Beginners in Tech - Topics: Artificial Intelligence, Cloud Computing, Cybersecurity The ideal candidate will have excellent writing skills, a deep understanding of these tech areas, and an ability to make complex ideas accessible for all levels of tech skills. You should also have a keen understanding of the specific needs and interests of business professionals and tech...

...me with data analysis, formulas, and data visualization. The project involves working with a dataset of medium size, specifically, between 1,000 - 10,000 rows. Key requirements for this role include: - Strong understanding of data analysis: The ideal candidate should have a proven track record of analyzing data, preferably in a business context. - Proficient in formulas and calculations: You should be very comfortable with advanced Excel formulas and calculations. - Data visualization skills: The ability to present data in an easily understandable and visually appealing way is crucial for this project. Specific functionalities and tools that need to be utilized include: - Pivot Tables: You will be required to create and manipulate pivot table...