Excel vba create pivot table in existing sheet jobs

I'm seeking an Excel expert to provide a comprehensive training session for my team of 11-20 individuals. We're at a beginner level and need someone capable of teaching us the basics and showing us how to optimally utilize data analysis and reporting features. - The training should cover: - Basic Excel functions and formulas - Data analysis - Reporting techniques The perfect fit for this project would be someone with an extensive background in Excel, ideally as a trainer or educator. Experience with teaching groups is a must, and the ability to break down complex topics into digestible, understandable parts is essential. Our goal is to increase our productivity and data handling capabilities through this training, so if you have a trac...

I'm looking for an Excel expert who can create an automated template for a financial renewal analysis dashboard. The dashboard should include basic descriptive statistics functions such as mean, median, mode, standard deviation, correlation, and regression. Key Requirements: - The dashboard needs to focus on the renewal status of our products/services. - It should be able to track the renewal status by product/service type. - The dashboard should be able to automatically update renewal statuses. Ideal Skills and Experience: - Proficiency in Excel and its advanced functions. - Experience in creating automated dashboards. - Understanding of financial data analysis, particularly in the context of renewals. - Strong communication skills to under...

I'm in need of an intermediate level automated meeting minutes solution on Excel 2016. This project requires expertise in Excel and VBA and knowledge of data categorization. Key requirements include: - **Template Generation**: The tool should be able to generate a meeting minutes template automatically. - **Categorization**: Information in the meeting minutes should be categorized by attendee. Date Task owners Points discussed New Ideas generation' related System Process People Technology others Ideal skill set for this project includes: - Proficiency in Excel, particularly Excel 2016 - Experience in VBA/Macros for Excel - Previous work with data categorization and template generation Looki...

Location: Trinity, North Carolina, 90% on-site (see info in the requirements section) Job Type: Freelance/Part-Time - Possibility for long-term assignments Employment Type: Contract – Project oriented This project is ideal for students and entry-level professionals. Involves assisting with product photography and videography for my new online store opening. If you have a knack for capturing stunning, unique images and are ready to bring your creative flair to my product range, I want to hear from you! Responsibilities: • Assist in setting up photography scenes with limited props, a trip(s) to purchase necessary items will likely be involved. • Provide guidance on lighting techniques, photography methods, and tips to capture the best images ...

I urgently require a freelancer to create a logistics management system for my business. The system must address the issues I'm currently facing with tracking shipments and managing inventory. Key Points: - The system should be able to efficiently track shipments and provide real-time updates. This is crucial to improve our customer service and overall business operations. - The inventory management module should be effective and user-friendly. As a business with 18 warehouses, we need to ensure all stock levels are accurately and efficiently maintained across all locations. Skills and Experience: - Proficiency in logistics software development - Strong understanding of inventory management systems - Prior experience with large warehouse networks - Ability to deliver a...

I'm seeking a creative and experienced designer to create a modern and minimalist logo design for my brand. The logo will be used across various platforms such as sign board, projects board, websites, social media, business cards, flyers, and merchandise like t-shirts and mugs, socialmedia. Key requirements: - Design a modern and minimalist logo that reflects my brand identity - Ensure the logo is versatile enough to look great across digital and physical applications - indicate the business of Engineering consultancy and architecture design with using tool of engineering such caliper - Deliver in a format that is easily adaptable for different platforms The logo should be content name in english and arabic - Need to be first world in the name " ONY...

...primarily are text-based and I'd love to find a professional who can assist in formatting them in a polished, consistent manner using Word 2016 Professional Plus on my Windows machine. The following aspects need to be considered: - Header and Footer Customization: Ensure that these are set up correctly and consistently across all pages. - Automatic Table of Contents Generation: Establish a dynamic table of contents that updates as the document changes. - General Formatting in Word 2016: This includes a review of the overall layout, font selections, spacing, and any other formatting needs to make the documents look professional. The ideal candidate would have: - Proficiency in Word 2016 specifically - Experience in text document fo...

you will need to be Expert in PHP understanding existing PHP Code along with knowledge of MySql and JS to handle a small game that will post results to a table in the data base then show on a leaderboard style page. $40 Job

I have a need for a meticulous freelancer with solid web research and data entry skills. The project involves researching company details and the necessary data should be accurately entered into an Excel sheet. Key Responsibilities: - Detailed online research to gather specific company data. - Accurate data entry of information into Excel, adhering to specific guidelines. Ideal Candidate Skills: - Strong web research ability. - Very accurate data entry skills. - High proficiency in Excel. - Able to meet deadlines. - Excellent attention to details.

I'm in need of a skilled freelancer with proficient online research and data entry skills. Responsibilities: - Conduct online research to collect necessary data - Expertise in entering numerical data precisely - Compile, verify accuracy and organize the information into a Excel spreadsheet Desired skills/experience: - Attention to detail - Experience in data entry - Excellent knowledge of MS Excel - Strong ability in online researching

I'm in need of a skilled professional to create a No-Code app on the Adilo platform or any other. It shall has three interface. 1. User Interface 2. Management Interface 3. Service Provider Interface App Idea: Chat based profile matching for Carpenters to work on hourly basis. User Interface Step 01 Signup Form with Phone, Email, Address Step 02 A chat box would open up with basic questions as; • Date for Booking • Time Period for Booking Step 03; Within the chat box the next question would be regarding the work profile Users can text to match profiles. Example: I want Bamboo Artisans Step 04: The Chat box will show all profiles for Bamboo Artisans as in the Directory or excel file Excel would be as simple as Skill Set, Pr...

...of both the Presidential and Local elections in real-time. Key Requirements: - I need the dashboard to be able to pull data from reliable sources(officials in polling station in an excel form) and refresh the data in real-time. This will facilitate the display of accurate and up-to-date results. - The design of the dashboard should be clean,animated,interactive, intuitive and easy to understand for users. It needs to be able to show data for both elections simultaneously with the help of a switcher between the two pages. - The dashboard should be mobile responsive, so that it can be viewed on various devices with ease. - The security of the data is paramount, so it's important that the dashboard is developed with necessary security measures in...

I am in need of a skilled Facebook Ads Expert to assist me in maximizing the impact of my advertising campaign. - Target Audience: My campaign needs to reach both men and women. I require an Expert who can create tailored ads that resonate with a diverse audience and convert them into potential customers. - Specific Goals: My primary aim is to boost sales of my Health & Beauty products through this campaign. The Expert should be able to understand the nuances of this industry and create ads that are not only engaging but also persuasive. - Expertise: Previous experience in running successful Facebook campaigns is a must. Knowledge of the Health & Beauty sector would be an added advantage. Your role would be pivotal in helping me achieve t...

I'm in need of an Expert Excel programmer to help design a user-friendly Excel sheet focusing on stock and ledger management. Specifically, I'm interested in: - Incorporating Automatic Calculations: The ideal candidate should be able to create a system that automates complex calculations based on data inputs. - Dropdown menus: The sheet should offer an easy interface with dropdown menu options for hassle-free data inputs and editing. - Linking Stock and Sales: The sheet should be designed in such a way where the inventory updates automatically from sales data. So, a keen understanding of Excel's data integration and interconnection capabilities is necessary. - Essential Data Fields: My Excel sheet ...

I just need a list of employees from Linkedin Recruiter.. I will get in a google-meet or zoom meet with you, and I give instructions. _We need to find the list of 'Open to Work' People from a particular Company in India. The reason for doing that is, We want to look for employees, who are considering Job switch from this company. _we will together log into your Linkedin Recruiter account _We will look for 'open to work' candidates _we will export the list (around 313 people) in CSV or Excel or PDF format. _If exporting the list is costly, in that case, I will simply take screenshots of the List (of candidates), and will later convert that into excel sheet. **The Task will take maximum of 10-15 minute time. Regards, ...

I have a project that involves the entry of data from Excel into a new system. The data entries are in Excel format, and I estimate the total number of entries required to be between 100-500. The task will involve a mix of text and numeric data. Ideal Skills: - Proficiency in Excel - Strong attention to detail - Efficient, accurate data entry - Previous experience with data entry projects of similar scale This is a straightforward task that requires someone who can work accurately and efficiently. Meeting the estimated entry count and maintaining data quality are key.

Need an extremely competent financial modeler in Excel who is capable of working with a lot of date math in formulas. You need to work on a working model template. NOTE: Do not apply if you are not genuinely capable of working with complex models. I am looking for help because I'm busy, not because I'm not capable! I make huge financial model templates on topics people don't model. I made a model on "ESOP" (Ownership structures for startups). ISSUE A client input dates in a way I didn't test and I realized I built in circular references I wasn't aware of. TASK Remove circular references (Need to change logic a bit to do it, which is not simple) Ideally break test to see how I messed up date math when dates are simila...

I am in need of a robust and efficient inventory management system made in Excel. This project requires: - Tracking of product quantities and managing stock levels to ensure seamless operation - Cataloguing of each product's relevant information including its name, SKU/Part number, quantity, batch number and expiry date - Methods of updating system quantities should be manual entry and bar code scanning. Knowledge in these methods is required. Ideal candidates should have extensive experience in Excel and inventory management system creation, preferably with a sound understanding of retail or related sectors. They should also be adept at implementing bar code scanning into Excel systems. Sharp attention to detail and ability to opti...

Hello, We are looking for a Creative Designer to reproduce 3 kit of editable resume (CV) + cover letter templates. It’s to say 3 resume and 3 cover letter in Word and Mac Pages. We will give you 3 design to copy and just add small adaptation, because these creations/designs will be used for business purposes (resume website). • Each resume must be accompanied by a cover letter with the same style than the CV • Each resume and cover letter must be designed and delivered: o in 2 differents format (Word (.docx) and Mac Pages (Mac OS), o in A4 o in 4 colors Variations (we will give you the 4 colors variations). • For each resume create a variation of 1-page and another variation of 2-pages • Then we will need for each kit of &ldquo...

I'm seeking a skilled web developer to UPLIFT an eCommerce store via SQUARESPACE for selling physical products. This store will sell customizable jewelry. The website is already created but we need to: 1. Update the style/colour/formatting and design of the front end. I am not happy with my colour schemes and font choice. Please help me improve the design. 2. Optimise my website for mobile 3. Improve functionality, spacing, and formatting using code. There is ~25 design and functionality changes that need to be changed e.g. Add pop up at checkout for ring size guide. Logo, media, text etc will all be provided.

...looking for an Excel expert able to implement drop downs and inter sheet connections to manage my business ledger and stock updates on a weekly basis. Here are the project specifications: * There are currently less than 5 Excel sheets that need to be interconnected. * The primary intent of this interconnection is the cross-referencing of information. * The exchange of data to be implemented includes Inventory data, Financial data, and Sales data. The ideal candidate should possess advanced Excel skills, including knowledge and experience in cross-referencing various types of data across multiple sheets. Familiarity with business inventory, financials, and sales data is highly desirable. Please ensure your bid reflects your ability to fulfill the...

Title: Sales Representative Specializing in the Meat Industry in UAE Location: Remote, UAE Job Type: Freelance with a potential for full-time engagement Description: We are seeking an experienced Sales Representative with expertise in the Meat Industry, specifically within the UAE market. Your role will involve intensive market research and lead generation, focusing on the importation and distribution of chilled lamb from Australia, Kenya, and South Africa. Responsibilities: Conduct thorough market research to identify and analyze the prices and competitors within the UAE meat market. Identify and reach out to at least 40 potential suppliers, including wholesalers and importers, to obtain competitive quotes on chilled lamb varieties. Essential data points include:...

I am in need of an experienced freelancer who can assist with various types of data entry tasks. This primarily involves: - Transcribing data from handwritten documents - Entering data from digital documents - Inputting data from spreadsheets The volume of data to be entered is moderate, falling between 100 - 1000 records. The preferred software for this project is Excel, therefore, proficiency and solid experience in using this application is necessary. Attention to detail and accuracy will be essential for this position. Understanding how to use spreadsheets effectively, and a proven track record in data entry are important skills that a suitable freelancer should possess.

...looking for a skilled character designer to create a unique and engaging cartoonish character. This character will be the official mascot for my brand, focusing on a child-centric appeal. Key Points: - Character Design: I need a character that is memorable, unique and fits the cartoonish style. - Brand Representation: This mascot will represent my brand, so it should be child-friendly. - Experience: A portfolio showcasing character designs, especially mascot designs, aimed at children is highly preferred. Skills: - Proficiency in character design - Prior experience in creating brand mascots - Understanding of appealing to children through design - Strong creativity and imagination I'm looking for a freelancer who can bring their own creativity to the tabl...

In my pursuit to propel the recognition of my brand to new heights, I'm seeking an innovative and experienced advertising expert. Objective: - The core aim of this project is to bolster the brand's recognition among working professionals aged between 25 and 50. Target Audience: - The focal point of our advertising will be working professionals aged 25-50, assuring that our brand resonates with them and aligns with their preferences. Medium: - We will majorly utilize online platforms for our campaign, including but not limited to social media channels and various websites relevant to our target demographic. Ideal skills for this role: - Strong understanding of brand positioning and strategy - Proven experience in digital marketing, specifically with a focus on s...

Table cover

I'm in need of a well-rounded property manager. The exact nature of the properties being managed hasn't been stated, as well as tenant management responsibilities. Ideal Skills and Experience: • Property Management (Residential/Commercial) • Tenant Management Please Note: The amount of properties to be managed will be clarified later, but your experience managing different scales from small to large will be of interest. Submit your bid indicating your experience level and what you bring to the table.

I require an expert in Excel to build a comprehensive tracking file. This task involves: - Establishing a data entry form to easily input inventory and project progress details. Knowledge of creating user-friendly interfaces within Excel is beneficial. - Implementing automated calculations to streamline the data analysis process. Strong mathematical and analytical skills are essential. - Creating a graphical representation of data to facilitate understanding. Experience in data visualization is a must. The spreadsheet will track fewer than 10 types of inventory data and project progress data. Your familiarity with inventory management processes and project tracking would be highly valuable. This assignment calls for you to use Excel's capabilities optima...

I am looking to streamline my excel data entry process. Needs centralized on the automation of numerical data entry in my Excel spreadsheets. Key requirements: - Automate simple data entry into few columns. - Experience with Excel data entry automation required. - Should have good knowledge of Excel functionalities and automations. - Ability to handle numerical data efficiently. Experience in handling simple data entry (few columns) and automating the same would be ideal for this job. Reach out if you need more information and looking forward to your expert assistance in this process improvement.

I am seeking a proficient specialist in Excel 2010, with extensive experience in the creation of VBA Macros, designing data entry sheets, automating tasks, and generating reports. Key responsibilities include: - Design and develop efficient VBA Macros - Design accessible and streamlined data entry sheets - Automate various Excel tasks for increased productivity - Generate comprehensive and insightful reports Ideally, you have advanced knowledge of Excel and VBA Macro programming, demonstrating a proven track record in dealing with complex Excel projects. A strong understanding of spreadsheet automation and report generation is fundamental to execute this project successfully.

Hi Nida, I have another small job that I would love your help with. It is just a matter of adding and styling a small table in the word template that you previously created for me. I will send you an example of the styling we want and the table content.

I'm in search of a meticulous data entry specialist to assist with my Excel-related work. Key responsibilities: - Data entry: The work pertains to entering simple, text-based data into Excel sheets. - Data sourcing: This role requires you to source the data before entry. Ideal skills for this project: - Proficiency in Excel: A strong grasp of Excel functions and formulas is a must. - Data entry experience: Previous experience with data entry, especially in Excel, is preferred. - Research skills: A knack for sourcing data efficiently and accurately.

...synchronized customer table accessible via both web and mobile applications, and developing and integrating APIs. We also need to enable the functionality to preview and download existing quotes via the web and mobile applications. Additionally, assisting the client in installing the latest version on their local host to facilitate their participation in the testing process. Project 2: Software Enhancement and Bug Resolution Our second project is a comprehensive web-based software developed using HTML, Bootstrap, PHP, Laravel, and MySQL. We are not aiming to completely redesign the system but to improve upon the initial version, which encountered several bugs post-launch. We have initiated the development of a new version, currently 40% complete, that restru...

Seeking an experienced QA tester based in Thailand to perform functionality testing on our cross-platform mobile app. This is final testing before launch and URGENT as we launch ASAP. You will perform tests following the test cases provided by us. Having a solid understanding in app functionality testing is crucial. I am only accepting bids from professionals who can work in daylight hours and are based in Thailand. Please share any relevant experience and success in similar projects. We seek to hire TODAY, May 3, 2024 if possible and seek to start you as soon as possible (today if possible). Essential Skills & Requirements: - Cross-platform mobile app testing (Android, iOS) - Excellent understanding of functionality testing - Capacity ...

Typical Functions: Data Architecture: Leverage your 5+ years of experience in designing and optimizing database solutions. You’ll work closely with stakeholders to create a robust data architecture that seamlessly integrates various data sources. Programming Languages: Demonstrate proficiency in Java and C#. Your code is not just functional but elegant. Team Leadership: As a seasoned engineer, you’ll mentor junior team members, foster collaboration, and drive technical excellence. Cloud Solutions: Familiarity with Azure or AWS is essential. You’ll architect, deploy, and manage cloud-based solutions. Data Import Strategy: Devise a robust strategy for importing data efficiently, ensuring data quality, and maintaining performance. Collaboration: Work cl...

I have two PDF files that contain about 150 records each that I need entered into a single spreadsheet. I do not require any specific categorization, but rather a direct, one-to-one transfer of the information from the PDFs into the spreadsheet. The data fields needed are names, addresses, emails phone number etc Ideal Skills: - P...have two PDF files that contain about 150 records each that I need entered into a single spreadsheet. I do not require any specific categorization, but rather a direct, one-to-one transfer of the information from the PDFs into the spreadsheet. The data fields needed are names, addresses, emails phone number etc Ideal Skills: - Proficiency in data entry - Experience with working on PDFs - Attention to detail - Familiarity with spreadsheet software (such...

Please Sign Up or Login to see details.

I need a proficient Excel user to create a workbook for my multiservice business. What I Require: - The ability to record both cash, check and card income, as well as expenditure for each. This tool needs to be able to accommodate and separate these different transactions for easy access and clarity. Desired Features: - It should automatically calculate the daily and monthly income for each category. - Must also offer a daily and monthly balance for cash flow. Skills & Experience: - Strong Excel skills are a necessity. - Ideally, the freelancer should have experience with creating business financial sheets. Timeline: - I'd like this project completed as soon as possible. Urgency is key.

I need a freelancer to convert a PDF file into a Word document while preserving its basic text formatting. Additionally, I would like the freelancer to create a table of contents in the Word document. The ideal candidate should be proficient in: - PDF to Word conversion - Basic text formatting in Word - Creating tables of contents in Word It is important that the freelancer maintains the integrity of the document's formatting during the conversion process.

I'm seeking a talented graphic designer to create a vector image of a perfume bottle. The design needs to be vintage-themed, capturing the essence of the original image.. The final design must also incorporate the brand name. The ideal freelancer will have: - Proficiency in vector image creation - Expertise in design Attention to detail is crucial for this project, in order to maintain the accuracy and beauty of the original design while adding the necessary branding elements. This graphic will be used on product packaging, so quality and impact are vital. The file is required in an AI file and layered PSD file. I need two versions, one like a line drawing version and the other a more of a block version with some details. I have attached examples.

I'm seeking a talented graphic designer to create a vector image of a perfume bottle. The design needs to be vintage-themed, capturing the essence of the original image.. The final design must also incorporate the brand name. The ideal freelancer will have: - Proficiency in vector image creation - Expertise in design Attention to detail is crucial for this project, in order to maintain the accuracy and beauty of the original design while adding the necessary branding elements. This graphic will be used on product packaging, so quality and impact are vital. The file is required in an AI file and layered PSD file.

We are launching an exciting contest to create a distinctive and memorable logo for our health and wellness brand, Zenith Wellness. We invite talented freelancers to submit their original designs to help us capture the essence of our brand, which offers a comprehensive suite of wellness services. Requirements: 1. Color Scheme: Your design must incorporate our brand colors: - Primary Color: #FF4242 - Secondary Color: #ACC6E5 2. Originality: All submissions must be 100% original and unique. AI-generated designs or those copied from other brands will be rejected. We are looking for creative and innovative concepts that reflect our brand's ethos and services. 3. Inspiration: I have attached some inspirations for the logo, as well as the logo of our biggest competitor, Res...

I'm in need of a freelancer who can assist me with the styling and formatting of an Excel spreadsheet. Your task will primarily involve applying cell style formatting. Specifically, I'm requiring assistance with: - Implementing cell style formatting. Please note that while the exact type of cell styles are not defined yet, I will be able to provide more details and guidance once the project begins. Ideal skills for this job would include: - Proficiency in Microsoft Excel - Previous experience with complex Excel formatting - Ability to work independently and on deadline Please, in your bid, include examples of any similar jobs you've completed.

I'm looking for an Azure professional who can help me set up an Azure cloud solution to host my Excel data. The project involves: - Hosting Excel Data: I will provide you with an Excel file, which I would like hosted on Microsoft Azure. The data in this file will not be updated frequently, just once for now. - Web Application: I would like the Excel data to be accessed through a web application. This means you will need to set up a simple, user-friendly interface for viewing and possibly manipulating the data. Ideal Skills: - Experience with Microsoft Azure, particularly in hosting data. - Proficiency in setting up web applications. Please get in touch if you have the right expertise, and we can discuss the project further.

I am seeking a detail-oriented freelancer to input text and numerical data into 3 small Excel spreadsheets, containing 1 column each. 2 spreadsheets for emails, one called Minnesota, one called Midwest. 1 spreadsheet of inventory numbers. See attached. Only emails are needed. Inventory is on yellow paper Ideal Skills: - Proficient in Excel - Attention to detail - Knowledge of data organization and management Highlight the entries that you are not sure of, or the handwriting is to difficult to read. English fluency in a must.

The task centers around leveraging Py...and machine learning skills to perform data analysis. The data to be analyzed are contained in an Excel sheet, specifically focusing on customer data. The ideal freelancer for this task should exhibit the following: - Strong proficiency in Python programming. - Solid experience with machine learning. - Familiarity with data analysis, particularly descriptive analysis. - Ability to accurately interpret customer data. The task requires a reading of the Excel sheet and performing data analysis based on the customer data contained within. The chosen Python and machine learning expert will focus on descriptive analysis techniques to extract meaningful insights. Your insights should guide our strategies in...

I'm in need of an experienced PowerShell script writer, specifically for Power BI associated data management tasks. As part of the project, code will be required to execute the following tasks: - Data extraction from Excel files, CSV files, and SQL databases - Transformation of data, including extraction and update of parameter values from Data Models in each Workspace Ideally, the freelancer would carry a strong understanding and hands-on experience with PowerShell scripting, Power BI, data transformation techniques, and working with database source files like Excel, CSV, and SQL formats.

Hello, I have 6 simple contact web forms that I would like recorded into a single matrix. The goal is to see the field alignment and comparison between the form data.

I want you create similar logo , to the attached one . More modern and clean Design: Combine the runes Fehu and Sowilo in a stylized lighthouse design. could be designed so that the structure itself takes the shape of the Fehu rune, while the light of the lhouse represents the Sowilo rune. • Colors: Use blue and gray tones for the lighthouse to symbolize professionalism and trust, with a bold yellow or gold for the light, radiating warmth and success. • Font: Choose a modern, clear font for the company name, placed below or beside the company

...looking for a capable .NET developer to create a WebAPI using the Visual Studio template "WebApi Net core (Minimal api)". It needs to have Authentication and Authorization in place, using the X-API-Key. Key Requirements: - Authentication and Authorization: You need to enable X-API-Key based authentication and authorization for this WebAPI. - Data Model: The WebAPI will manage a simple 'City' table, performing basic CRUD operations. Expectations: - The X-API-Key should be hardcoded in the application. - The WebAPI should be developed using .NET 8.0 and the Visual Studio template "WebApi Net core (Minimal api)". - Data access should be implemented using EFCore. - Authorization should be handled through middleware. Ideal Skil...