What is pivot table in ms excel jobs

...ranking) (Only shows items registered for that month, in registration order) History screen link sharing function: This link is valid for only one week Only the corresponding screen can be viewed Approximately 300-400 new businesses expected to be registered each month: Development needed to accommodate the expected volume of registrations Development to prevent IP bans Detailed feature description: Member Login Sign-up Permission assignment Individual inquiry Immediate rank crawling Tracking target management Individual input Bulk Excel upload & download Keyword-based crawling On/Off Deletion Background crawling of tracking targets Naver Place keyword (1 daily query) Rank change history Generate a shareable URL (reset every week) Display in a popup from...

Dear Candidate, As described in the title, this task requires that you reasearch medical centres (also called general practice medical centres, family physician clinics, clinics) and find out who the owners of these clinics are are using internet research. You will have to be fluid with excel, online reasearch tools. This is a posting for a long-term VA who can perform various forms of online research and other tasks. Personal attributes required: 1. Speed and efficiency in online research. 2. Attention to detail and complete accuracy in all tasks. 3. Punctuality and ability to meet deadlines. 4. Ability to read/follow instructions carefully with attention to detail. Successful candidates will be required to complete two test works before the projec...

I am looking for a developer with a focus on backend operations and experience with C#, MSSQL, and WordPress eCommerce integrations. The primary task is deduct stock in azure ms sql stock table when order placed in wordpress e commerce create comand for performa invoice when order placed in e commerce Key Skills Required: - Strong experience with MSSQL and WordPress - Expertise in inventory management system integrations - Understands the intricacies of WordPress eCommerce platforms budget $70

I am seeking a digital marketing professional who can help me enhance my brand visibility, ramp up web traffic, and generate leads via Facebook and Instagram. I need someone who has a knack for curating targeted... * Create engaging, relevant content, and optimize it for each platform. * Monitor campaigns, analyze key metrics, and adjust strategy as needed. - Required Skills and Experience: * Extensive experience in social media management, specifically with Facebook and Instagram. * Proficiency in performance marketing and lead generation. * Demonstrated experience managing campaigns targeting the 18-44 age demographic. Your expertise in these areas will be crucial to achieving our marketing objectives. I can't wait to see the innovative strategi...

I am in need of an experienced digital marketing specialist to assist with managing my social media and content marketing activities. This job will also involve aspects of performance marketing. - Responsibilities: -- Managing our social media profiles, primarily on Facebook and Instagram -- Crafting engaging content for our target audience -- Running performance marketing campaigns - The ideal candidate should have: -- Proven experience in social media management and content marketing -- A solid understanding of performance marketing -- Ability to implement strategies to increase brand awareness and generate leads I anticipate working with someone who not only executes these tasks effectively but also brings fresh insights and a proactive approach to the table...

Looking for someone to go to a few sites and make me an excel sheet with all the listings on the site . Must speak fluent English

I am looking for a professional freelancer who can convert a PDF file into an Excel spreadsheet, while maintaining the images within the PDF. The Excel file should comprise of data tables with corresponding headings. Key Requirements: - Convert PDF to Excel format - Preserve images from PDF - Create data tables with headers in Excel Ideal Skills: - Proficiency in data entry and Excel - Familiarity with image integration in Excel - Attention to detail for ensuring accurate data structuring

I am in need of a proficient Personal Assistant to work remotely with me as I manage a fundraiser for a specific cause. The ideal candidate would be able to handle various key tasks in relation to the fundraiser and overall CEO support. Tasks: - Typing Admin documents: The PA should assist in typing a range of documents related to the fundraiser. This will include letters, reports, and agendas. Proficiency in MS Office suite is expected for this task. - Setting Appointments: The PA should be able to manage my calendar effectively, setting appointments which could be related to the fundraiser or general business activities. - Handling Emails: The PA should be able to effectively manage incoming emails, filtering out important ones and responding t...

I'm in need of a meticulous professional to clean a mixed set of data contained in an Excel file. I am specifically struggling with duplicate values and missing entries. To effectively accomplish this: - You should possess excellent skills in data analysis and data management. - Previous experience with Excel-based data cleaning is preferable. - Profound knowledge of dealing with duplicate entries and filling in missing data is required. - A keen eye for detail and ability to spot and correct errors is essential. In summary, my ideal candidate would be someone with significant experience in data cleaning, particularly with mixed data in Excel files. It would be a bonus if you've previ...

...organized Excel spreadsheet. You'll reap the benefits of this project if you're detail-orientated, familiar with navigating online sources, and proficient in Excel. - The project involves researching, collecting and collating text data from specific online sources - The final deliverable needs to be an Excel spreadsheet, with data arranged legibly - Demonstrable experience in data entry jobs would be ideal - A keen eye for detail is paramount as exactness is key for this data entry task - You should be comfortable working with Excel and have proficiency in using all its features. The testimonials of your past clients and your portfolio of similar projects will enhance your chances of selection. This project req...

...have sketched a table design, and now need assistance to bring it to life through Fusion360. Key tasks for you will include: - 3D Modeling: I'll need you to take my sketches, which are partially available from different perspectives, and use them to create a 3D model with a medium level of detail. - Rendering: After the 3D model is completed, I'll require rendering services to provide a realistic visualization of the table design. - Assembly: The last phase of the project will be the assembly, where you will put together the individual components of the table in Fusion360. Ideally, you should have extensive experience with Fusion360, particularly in 3D modeling, rendering, and assembly. Being able to work from partial sketches ...

I'm in need of a WordPress expert to assist with a complete overhaul and custom design of my theme. In addition to this, the project also includes the implementation of advanced features such as e-commerce capabilities and membership registration and management. Key Requirements: - Expertise in WordPress theme customization - Proven track record in complete overhaul and custom design - Experience with e-commerce integration and management - Implementation of membership registration and management functionalities Your role in this project will be crucial to the success of my website, so I’m looking for an experienced professional who can not only deliver on the technical side of things, but also bring creative ideas and suggestions to the ...

I'm in need of an animator who can bring life to 20 cartoon illustrations. The style I'm looking for is motion graphics, rather than traditional 2D or 3D animation. The animations will serve an educational purpose, so it's crucial that the freelancer can maintain a balance between engaging visuals and clear, informative content. These animations are not aimed at children or teenagers, but at an adult audience. Key responsibilities include: - Transforming static illustrations into dynamic, informative animations - Ensuring the animations cater to an adult audience's learning needs I'm looking for an animator with: - Strong experience in motion graphics animation - A portfolio that demonstrates their skills in creating educational con...

I need a proficient excel expert to help me with a data entry project. The data involves simply names, emails, and phone numbers. It will be a table with 100-500 entries, so proficiency in data entry and Excel is crucial. Key Requirements: - Accurate Data Entry: The job is primarily about accurately transferring names, emails, and phone numbers from a document to an Excel sheet. - Excel Proficiency: Knowledge of Excel functions is a plus, though not specifically required. You should be comfortable working with a table of this size.

I'm in need of comprehensive and detailed Australian databases. Specifically: - Medical databases, with a key focus on medical specialties. Medical databases should preferably contain reliable and relevant information about the different branches of medical specialties across Australia. - Business databases, encompassing detailed company profiles inclusive of industry category, phone, fax, email, physical address, etc. I'd appreciate getting more data, as in-depth as possible. The databases should be pre-existing or scraped and must be provided in Excel format, or .BAK for MSSQL server. Professionals equipped in big data collection, scrapping, and data analysis would be the most suited for this project. Knowledge about Australian medical and ...

I need a freelancer to assist with accurate and efficient data entry into Microsoft Excel. The data is in digital format and involves numeric values. Key Requirements: - Enter numeric data into Microsoft Excel from provided digital sources - Ensure data is accurately transcribed - Maintain confidentiality of the data Ideal Freelancer: - Proficient in Microsoft Excel - Strong attention to detail - Previous experience in data entry, preferably with numeric data - Ability to maintain data integrity and confidentiality. Note: Please ensure you have a copy of Microsoft Excel for this job.

I am in need of a professional who can help provide insights into a dataset using Excel's pivot charts, tables, and dashboard. The area of the data is unspecified as of now, but a strong candidate would be adaptable and skilled across domains. Key responsibilities will include: - Data Visualization - Creating Pivot Charts - Building Tables - Preparing a Dashboard Note: This project is basic-level work and my budget is 10 not more than that I already checked price comparisons with different freelancing platforms. if anyone works in that price range only the person make bids does not waste time.

...create a custom piece of artwork in celebration of our 59th anniversary. Key Responsibilities: - Create a unique, high-quality digital illustration suitable for printing - Incorporate the essence of long-lasting relationships, love, and celebrations into the artwork - Adapt to any specific themes or concepts I might have in mind Ideal Skills & Experience: - Proven experience in digital illustration - Strong understanding of design principles and techniques - Ability to create original, captivating concepts - Experience in creating artwork for special occasions or anniversaries is a plus. Please note that while I have not specified a particular style, I am open to suggestions and looking for a professional who can bring their creativity and expe...

Problem Statement Create a ms projects (Preferably 2019 version)that creates a future project on creation of an artisanal organic jam production (strawberry flavored) : 1. With at least 32 tasks; 2. The project has to have codependencies between tasks; 3. The project has to have fixed costs and variable costs, as well resource allocation. In addition, the project needs a 500 word write up on the execution of the project. I want to emphasize that ms projects has to be used for the assignment A 500 word write up about the project

I am looki...for a freelancer who is proficient in data entry and familiar with Excel to assist in the digitization of a 276-page vintage parts manual. Your task would be to: - Accurately copy the information from pdf to Excel. This includes part numbers, the description of parts, and all other columns present in the original tables in the document. - Organize the spreadsheet such that each section of the document is represented by a separate worksheet. No specific data validation rules or cell formatting are required, but the data must be accurate and searchable in Excel. This job requires someone with a keen eye for detail and a good understanding of Microsoft Excel. Prior experience in similar data en...

...specialist to design 3 MS Project templates customized for managing the commissioning and start-up phase of a construction project for 3 different busniess units. This template should specifically assist in tracking the projects schedule via Gantt, and it needs to visually show resource (30) availability in a nice full sheet calendar view, resource utilization. Then I would like to see all 3 of these project templates feed into a power BI report that looks at all 3 project templates and lets us see the whole business picture. Ideal candidate would possess strong skills in project management, specifically with MS Project, HR resource management, and have extensive knowledge of construction processes and labor management. Power BI skills are also a mus...

I'm in need of a Python developer with a focus on machine learning and AI. Your primary task will be to design and implement machine learning algorithms for our project. I'm looking for someone who can bring both technical skill and creative problem-solving to the table. Ideal Skills and Experience: - Strong Python programming skills - Proven experience in machine learning and AI - Previous project experience in this area I'm open to discussing the project, solving problems, and communicating progress. Looking forward to working with you.

Looking for an expert who can import data from 1-10 Excel files into Google Earth. Key tasks: - Convert location data from Excel into a format readable by Google Earth (preferred Google Eath Pro Tours for Commercial Real Estate Properties - Ensure perfect alignment of data with the geographical locations - Grouping and categorizing the locations as per the content of each column within the Excel files Ideal candidate: - Proven experience with data visualization tools, particularly Google Earth and Google Earth Pro tours for Commercial Real Estate Properties -- High proficiency in handling Excel files and data - Understanding of Geographical Information Systems would be a bonus.

...seeking a social media marketing professional with a proven track record in boosting brand visibility, driving web traffic, and generating leads. The main focus will be on Facebook, Instagram, and Twitter platforms, with the goal of targeting business professionals. Key Project Details: - The main objectives of this campaign are to increase brand awareness, drive traffic to our website, and ultimately convert this traffic to leads or sales. - The primary target audience we are aiming to reach with this campaign are business professionals. Understanding the demographics and behaviors of this group will be crucial in crafting effective content and engagement strategies for the campaign. - While I do have specific goals in mind, I'm also open to hearing your sugg...

I have a MySQL database that needs exporting. All user data, product data, and transaction data are required to be exported. Key Tasks: - Export all MySQL user data - Export all MySQL product data - Export all MySQL transaction data The final export should be in Excel format. This is not a job for beginners. You should have prior extensive experience with large database exports and MySQL. It would be a big plus if you're familiar with handling sensitive user and transaction data. As the project involves substantial data, confidentiality and data security are non-negotiable. Please include samples of similar database exporting projects you've completed.

I am in need of an Excel spreadsheet expert to create an Excel template using a PDF sample. Without being specific about the details, the ideal candidate should have excellent skills in extracting data from PDFs and well-versed in designing Excel templates. Here's what I'm looking for: Mactacquickshipsellsheet pdf converted into an excel sheet example of what I would like as template.

I'm in need of a Python expert who can meticulously extract text and tables from PDFs for data analysis. The requirements are as follows: - Develop a Python solution in form of a Jupyter Notebook - Preferable use of the libraries PyPDF2, Tabula, PDFMiner, PyMuPDF, and PDFPlumber for extraction Required Skills and Experience: - Proficient in Python - Familiarity with Jupyter Notebook - Experience with PyPDF2, Tabula, PDFMiner, PyMuPDF, and PDFPlumber - Data extraction and analysis expertise. Your commitments would include understanding the architecture of the PDFs, and the most effective library for extraction in each case. The ultimate goal is to create a Python script that eases the data extraction process for subsequent analysis. Whoever ca...

Database Tool Development I. Introduction 1. Purpose: The DRP Talent Solutions team currently manages an internal workforce partner database developed in-house and updated internally. This resource, currently in an Excel spreadsheet format, is used to assist employers in navigating our regional workforce programs and partners. To enhance its utility in responding promptly to RFIs (Request for Information), we aim to reinforce this database tool. Our objectives include implementing organizational features with multiple tags for efficient categorization and establishing a user-friendly update and maintenance system that does not require consultant engagement. 2. Objectives: i. Objective 1: Enhance Database Organization 1. Introduce multiple tags f...

...I need the Dymo printer to work seamlessly with my Access 2013 database. The goal is to automatically print stock labels based on query results. This means you'll need to set up the system to take the query output and send it to the printer for label creation. - **Printing Specifics**: The labels I need printed are stock labels. The process should be automated, so the labels are generated and printed without manual intervention. The labels will be printed based on the results of a query in Access and some limited entry from the operator with such things as qty of labels and which of 2 labels (it's the DYMO LabelWriter 450 Turbo) with slightly different fields. - **Skillset**: You should be proficient in MS Access and have experience working with D...

I'm in need of an Excel expert to help me with intermediate-level spreadsheet formatting. The tasks include moving data from sheet to another sheet Ideal Skills and Experience: - Proficiency in Excel

...seek to include are invitations, table settings, and venue decorations. Key Points: - Neutral Colors: The color scheme is neutral, in line with a traditional Persian aesthetic. - Persian Inspiration: I'm looking for a designer who can take elements of Iran's rich cultural heritage and incorporate them into the wedding's design. - Invitations: The designer will create a beautiful, culturally inspired invitation set that sets the tone for the theme. - Table Settings: The design should extend to the table settings, ensuring that the guests are immersed in the theme throughout the event. - Venue Decorations: Finally, the designer will help transform the wedding venue with decorations that evoke the Persian atmosphere I'm aimin...

...seek to include are invitations, table settings, and venue decorations. Key Points: - Neutral Colors: The color scheme is neutral, in line with a traditional Persian aesthetic. - Persian Inspiration: I'm looking for a designer who can take elements of Iran's rich cultural heritage and incorporate them into the wedding's design. - Invitations: The designer will create a beautiful, culturally inspired invitation set that sets the tone for the theme. - Table Settings: The design should extend to the table settings, ensuring that the guests are immersed in the theme throughout the event. - Venue Decorations: Finally, the designer will help transform the wedding venue with decorations that evoke the Persian atmosphere I'm aimin...

I am looking for a freelancer to assist me with a data entry project. The task involves typing data from handwritten documents into a digital format. The data must be formatted in a specific way, so attention to detail is important. Skills and Experience: - Proficient typing skills and accuracy - Experience with data entry and handling handwritten documents - Familiarity with formatting data according to specific guidelines - Ability to work efficiently and meet deadlines The project includes 1-10 pages or documents that need to be entered. If you are interested in this project, please provide examples of previous data entry work and explain your experience with formatting data.

I'm looking for a talented Excel programmer to build an Excel tool tailored for my business' quotation procedures. Notably, this tool must provide these key functions: - Automatic Price Calculation - Customized Quotation Template Design I already have a specific design in mind for the quotation template and would require the freelancer to implement my design concept accurately. A potential candidate should have considerable Excel programming skills coupled with a solid understanding of quote creation processes. A sense of accuracy, creativity, and robust attention to detail would be beneficial for this task. Outputs should be precise and user-friendly, ultimately contributing to streamlining our current operations.

I'm looking for a talented Excel programmer to build an Excel tool tailored for my business' quotation procedures. Notably, this tool must provide these key functions: - Automatic Price Calculation - Customized Quotation Template Design I already have a specific design in mind for the quotation template and would require the freelancer to implement my design concept accurately. A potential candidate should have considerable Excel programming skills coupled with a solid understanding of quote creation processes. A sense of accuracy, creativity, and robust attention to detail would be beneficial for this task. Outputs should be precise and user-friendly, ultimately contributing to streamlining our current operations.

...designer who can create harmonious and compelling designs for various print materials - namely a table top display, table cover, brochure, flyer, and business card. Table Top Display: - Execute a design incorporating my company's logo and name, along with details about the products or services we offer. Please also include clear reference to our contact information. - The table cover should be sized for a 8-foot table. 2 Flyers: - These should be in line aesthetically with the design elements used in the table top display and table cover. The exact content details will be provided once you're selected for the project. Skills & Experience: - Proven experience in graphic design, particularly in...

I am looking for a developer with a focus on backend operations and experience with C#, MSSQL, and WordPress eCommerce integrations. The primary task is deduct stock in azure ms sql stock table when order placed in e commerce create comand for performa invoice when order placed in e commerce Key Skills Required: - Strong experience with MSSQL and WordPress - Expertise in inventory management system integrations - Understands the intricacies of WordPress eCommerce platforms budget $70

I'm looking for a skilled Excel expert who can help with adjusting product pricing, adding products, creating formulas, adding products etc via excel, .csv. This is a ongoing project. If you can upload .csv to wordpress is a big plus!! KEY REQUIREMENTS: - I specifically need assistance with spreadsheet automation. - The work required is at a basic level, focusing on formulas and functions. - Implement automation for the designated tasks. - Ensure that the automation is robust and well-documented. SKILLS & EXPERIENCE: - Proficiency in Excel is a must. - Experience in basic spreadsheet automation. - Strong understanding of formulas and functions. - Attention to detail and commitment to quality.

I'm looking to develop an Artificial Intelligence (AI) charges calculator for Excel. The core functionalities include: - Automatic calculation of fixed charges - User-friendly interface for effortless interaction and data management. - Reliable data input validation to ensure accuracy and consistency. - Calculate Profit based on fixed charges and earning from subscription The calculator will primarily handle financial data. Prospective freelancers should have a strong grip on Excel, data validation, and UI/UX design—along with financial acumen for effective calculator development. A successful execution ideally enhances efficiency and aids with precise financial management.

I'm in need of an experienced game designer to create a strategy game specifically for mobile devices. The game should be engaging and immersive, with a focus on local multiplayer features. Key requirements: - Experience in designing strategy games: I'm looking for someone with a strong portfolio in creating strategy games, preferably for mobile platforms. - Proficiency in local multiplayer integration: The game needs to support local multiplayer, allowing users to play against each other on the same device. - Understanding of mobile game design principles: The ideal candidate should be well-versed in the unique challenges and opportunities that come with designing for mobile devices. Please provide examples of previous projects that showcase ...

I'm in need of a meticulous and reliable freelancer to assist with online data entry tasks. You'll be required to input data into spreadsheets using platforms like Excel or Google Sheets. The data will be provided to you in digital formats, such as PDFs, Word documents, or scanned images. Key Requirements: - Proficiency in online data entry - Experience working with spreadsheets (Excel, Google Sheets) - Ability to maintain accuracy and attention to detail - Familiarity with handling data in digital formats Ideal Skills: - Previous experience with similar data entry projects - Proficiency in using Excel or Google Sheets - Background in spreadsheet management - Strong attention to detail and accuracy A successful c...

I would like a custom sales order created in Excel for about 50 different items. Key Requirements: - Each item's entry in the order should include item name, quantity, and description. - The items should be sorted by their ship date. - The system should incorporate a feature to apply a total discount on the order. Ideal Skills and Experience: - Advanced Excel Skills with the ability to create customized sales orders - Proven experience in developing financial/ordering spreadsheets - Excellent understanding of sales order process and discount mechanisms.

About us: BA Marine is 3 years old company with a track record of USD 15 Million value of transaction of 60 vessels in GCC during the past 3 years and operated by the owner alone that generate 60 existing clients and 400 prospective clients. We are looking for bilingual speakers: Arabic and English for social media/ LinkedIn outreach. Your tasks include: -Screening existing Facebook and Instagram users by sending DMs using your accounts to check if they are interested in a certain boat by providing our boats database. -Approaching users on LinkedIn targeting C-Level, Doctors, Engineers etc who are based on Arabian Gulf seafront cities. -Inviting users on public groups or any other boat lovers communities to join our FB page or to follow us on Instagram. -Nurturi...

I'm looking for an experienced PostgreSQL professional capable of analyzing and generating reports from sales data. Key Responsibilities: -Analyzing sales data stored in PostgreSQL -Generating insightful reports based on analysis Ideal candidate should excel in PostgreSQL and possess strong data analysis skills. Previous experience with sales data is an advantage, however, specific functionalities required for the analysis have been left open-ended for your expertise to fill. Please outline in your proposal any relevant experience and your approach to this task.

I'm seeking an experienced developer to create a web application. The purpose of this application is to extract table data from PDF documents and translate it into various chart formats, specifically bar graphs, pie charts, and line diagrams. I also need the application to be capable of handling data pivoting. Ideal candidates would have strong skills in data extraction techniques, chart creation, and web application development. Understanding of data manipulation and presentation is also a must.

If C4 and D4 have no entries, make E4 blank. If C4 and D4 have values, perform C4/D4 in E4.

I'm in need of an Arab Frontend Developer who is a master of and GSAP. The task on the table is to work on an interactive website that features animations along with 3D modeling and visualization. Key Requirements: - Proficiency in GSAP and - Experience in building interactive websites - Skilled in 3D modeling and visualization - Fluent in English and Arabic The primary goal of the project isn't specified, but given the need for intricacy in animations and 3D modeling, your creative input is highly valuable. The UI design hasn't been decided yet, leaving an opportunity for your artistic influence. Ideal Skills: - GSAP and expertise - Exceptional skills in 3D modeling - Creativity in in...

...need an expert in data formatting to help me clean and organize a large Excel file. The file currently contains unformatted data that needs to be segmented into distinct columns. I need the data separated into the following categories: - First Name - Last Name - Company Name - Position The ideal candidate for this job should have: - Proficiency in working with large Excel files - Experience in data segregation and formatting - Attention to detail to ensure data accuracy - Ability to follow instructions and deliver in an Excel file format Given that there are more than 500 entries in the file, efficiency and accuracy are key. The final deliverable should be an Excel file with the formatted data ready for use. If you have...

My aging Drupal 6 website is overdue for a technological upgrade to Drupal 10, without losing its current custom modules. I also envision minor design updates on the aesthetics, but not an entire makeover. The site only has ONE custom module that is a form which requires porting over to the new drupal 10 site. The form updates a db table, but that table will remain the same and the same existing queries can be used. The theme can the default one. There is no real themeing requirment -**Compatibility Upgrade**: I desire my website to be on par with modern technologies and be ensured of its smooth operation. -**Design Updates**: A few enhancements to the website's look are needed, making it simple yet appealing. -**Intact Features**: I heavily re...

I'm seeking an expert who can assist with developing a comprehensive data analysis and automation solution within SMART sheet and Excel. Key Responsibilities: - Develop custom dashboards for financial analysis within Excel. - Automate data management processes within both SMART sheet and Excel. - Integrate the dashboards into SMART sheet for seamless use. Ideal Skills & Experience: - Strong expertise in SMART sheet and Excel, including VBA. - Proven track record of developing dashboards for financial analysis. - Ability to automate data management processes. - Excellent communication skills. Please provide examples of similar projects you've completed.