Excel macro pivot table jobs

I have an existing excel document that I would like to adapt to help with quotations & orders. Key Features: - The adapted document should automatically generate quotations, order forms, and perform the necessary calculations. - The excel file should have fields for product name, quantity, price, and customer information. Additionally, it should accommodate the inclusion of photos, and sizing information (a template image will be provided for reference). Calculations & Formulas: - The document should perform total price calculations, as well as tax calculations. Ideal Skills & Experience: - Proficiency in Excel - Experience with automated document generation - Exceptional skills in creating complex formulas - Attention to detail to ensure the documen...

Important: Project must be completed within 10 hours or less I have designed the attached company fact sheet in Excel. I would like help converting this to a Microsoft Word template. I need it to be flexible so that all the text and information can be changed and amended as needed, and I can change the charts. I have also attached the logos to be used.

I am seeking a proficient VBA developer to help me create a set of macros in Excel. The purpose of these macros is to automate the process of generating multiple files from a base Excel file, specifically for the task of data analysis. Key Requirements: - The macros should be designed to create multiple Excel files from a single base file. The output files should maintain the formulas, formats, and templates of the original file. - The macro should be designed to run on a monthly basis. - The output files can have the same format with different data. The ideal candidate should have: - Proficiency in VBA and Excel - Experience in creating macros for data analysis - Ability to deliver a reliable, efficient, and well-commented solution. I need this to be ...

...years of technical business or functional analyst experience and demonstrated ability to see a project through from beginning to end including creation of business requirements and formal documentation during the solution development life cycle required  Strong emotional intelligence (EQ) and interpersonal skills required  Experience with workflow design required  Proficient in Microsoft Word, Excel, PowerPoint, Project, and Visio preferred Supervisory Responsibilities: None Travel:  Up to 20%, to include overnight stays, may include an annual software user conference Physical Requirements:  This role frequently communicates with others, must be able to exchange accurate information in these situations  This role routinely uses standard office equipment such as computers, p...

I'm seekin...experience in resolving issues related to the ADR6 table in SAP. The primary issue I am encountering is an ASSERT dump when attempting to update the table. Your task will be to resolve this and improve the overall functionality of the table. Key Responsibilities: - Identify the root cause of the ASSERT dump when updating the ADR6 table. - Resolve the issue to ensure successful and error-free updates. - Optimize the ADR6 table to improve system performance and ensure accurate communication mail ids. Ideal Candidate: - Proven experience working with the SAP ADR6 table. - Strong understanding of ABAP programming language. - Ability to troubleshoot and resolve complex technical issues in SAP. - Prior experience with ASSERT dump erro...

I'm currently on the lookout for an expert in Excel 2016, with a specialized focus on the creation of VBA. The end goal? Correct spelling mistakes across multiple worksheets in my data set. Given the language locale, proficiency in English (USA) is essential. In addition to this: - Strong attention to detail and accuracy skills are needed. - Proven experience of using Excel, especially dealing with multiple worksheets. - Experience in creating and executing VBAs effectively for similar problems. Do you believe that your expertise aligns with these requirements? If so, consider submitting a proposal.

I am looking for a software solution to extract exam questions and answers from PDF files and organize them into an Excel spreadsheet. The extracted data should be structured such that each question is listed in one column, its corresponding answers are listed in subsequent columns, and each row represents a single question and its answers. Project Requirements: PDF/Doc Parsing: The software should be able to parse PDF/Doc files containing exam questions and answers. Extracted data should include the question text and its associated answers. Data Organization: Questions should be listed in the first column of the Excel spreadsheet. Answers should be organized in subsequent columns, with each answer corresponding to the respective question. The number of columns for answers ...

I am looking for a competent designer who can create a visualization of the remodeling of my glamping's pool area. The visualization will be presented both in image format and as an animation or video. Key Requirements: - Upgrade the pool area: The primary focus of ...outdoor spaces, is highly desirable. - Designers who have worked on pool remodels or landscaping projects, particularly luxurious or resort-like designs, are encouraged to apply. - Any examples of work that incorporate LED lighting into a design is a plus. Please note that I am open to creative interpretations of the project brief - I am looking for a designer who can bring fresh ideas to the table while still adhering to the luxurious and resort-like design aesthetic. I will provide the images with the current...

I am in search of a proficient data entry specialist based in LATAM who can help me with various data management tasks... and interpreting data. - Data Cleaning: Your role will also involve cleaning data sets to ensure they are free from errors and inconsistencies. - Data Verification: You will need to cross-verify data to guarantee accuracy and reliability. Preferred Tools: - Proficiency in Microsoft Excel, Google Sheets, and CSV file format is preferred. Ideal Candidate: - Prior experience in data entry, processing, and cleaning. - Familiarity with data verification methods and tools. - Proficiency in Microsoft Excel, Google Sheets and CSV file format. - Attention to detail and accuracy in data management. Please note that the estimated amount of data to be processed...

I'm looking for a skilled professional who can create more than 10 bar charts for a PowerPoint presentation. Requirements: - Proficiency in Microsoft Excel - Experience in visualizing survey results - Strong understanding of chart design principles The charts will need to visually represent survey data in a way that's engaging and easy to understand. Your role will be crucial in transforming raw data into meaningful insights. Please include relevant experience in your bid, and share any similar projects you’ve worked on in the past.

We are academic researchers interested studying visit patterns to Museums, Aquariums, and Zoos, in the United States. We are seeking assistance in collecting reported visit counts for the year 2019 from 500 museums, 100 zoos, and 100 aquariums across the United States. We will send you an excel spreadsheet with the name and state of each location we would like visits counts for. Note that these ~700 locations have been pre-selected. Task: - Search the internet for reported visits to each location in 2019 - If you can find the number of visits, please enter that number in the "visits" column AND paste the link to the website / source from which you obtained that number in the "link" column - If you cannot find an official reported figure for 2019 after som...

I'm focusing on selling electric therapy tables, with the primary audience being physical therapy clinics. I aim to highlight comfortability, adjustability, and durability as the key features of these products. Required Skills and Experience: - Experience in marketing therapy tables - Understanding of therapy clinics' needs - Ability to effectively highlight product features Job Scope: - Develop targeted sales strategies - Highlight the tables' comfortability, adjustability, and durability - Generate interest among physical therapy clinics

I am in need of a freelancer who can swiftly handle two data entry projects. The tasks involved include: 1. Updating Gas Station Addresses: - The spreadsheet requires updating existing address data for about 80 gas stations based in Jamaica. - I have a specific format that I require this in, which I will share...creation of a comprehensive list of car makes and models, supplemented with brief, succinct descriptions of each car. - I have a list in word document, there may be some duplicates and there could also be more that I have not considered The successful freelancer need not have to be a subject matter expert, but should be able to undertake data entry tasks with accuracy and speed. Experience with Excel data manipulation and a keen eye for detail are ideal for...

I need help with a moderately complex data cleaning project. My spreadsheet data has missing elements that need addressing. What this entails: - Locating and dealing with missing data in the spreadsheets - Proposing solutions to prevent future missing data The perfect candidate would proficient in Excel or similar spreadsheet software, and have a keen eye for detail. Past experience with data cleaning would be advantageous.

I'm seeking a skilled individual to automate a series of tasks on Microsoft Excel, Sharepoint, Microsoft Teams and Email, using Pulover Macro and AHK where needed. Requirements include: - Automating a series of tasks in Microsoft Excel. This includes data manipulation, data analysis and reporting. The process is already mapped out and can be shared with you. - Using Pulover Macro and AHK, as well as VBA to facilitate the automation process. - Ensuring the automation process involves uploading files to Sharepoint, sending messages on Teams, and emails. The key deliverable for you is not just the completion of the automation process, but a clear and concise explanation of each step once the task is finished. This will be crucial for future troubleshooting ...

Add cake into the table images proffesionally.

We are looking for a highly skilled Technical Support Specialist to join our team remotely. As a Technical Support Specialist, you will be responsible for providing excellent customer service and technical assistance to our clients. Your main duties will include troubleshooting hardware and software issues, managing device configurations, and providing account support. To excel in this role, you should have a strong technical background, excellent problem-solving skills, and the ability to communicate effectively with customers. Skills required: - Technical troubleshooting - Device management - Account support - Customer service - Communication skills

I need an Excel sheet that can help me analyze customer information for trends and patterns. This will involve: - Basic Formulas and Functions: The data room should have basic formulas and functions that allow for the easy manipulation and analysis of customer data. - Data Room Design: The sheet should be designed to be user-friendly and intuitive, making it easy for me to analyze the data without getting lost in the spreadsheet. - Data Analysis: The main goal of this project is to analyze the customer data for trends. So, the ideal freelancer will have experience with data analysis and the ability to create custom formulas to uncover patterns. - Attention to Detail: Accuracy is key in this project. I need someone who is meticulous and can ensure that all the data is entered cor...

...Spring Boot 3.1.11, JDK 17 or 21, MySQL Usecase: 1. As a super admin I would be able to onboard a new tenant(example: school). Whenever superAdmin does that then new new database can be created dynamically in mysql. And the user_details, product, services tables need to be created. 2. There should be a table "tenant_master" which should have information of all tenant databases. like hostname, port, username, password, connection_string, tenant_name, status. One entry should come to this table when we are onboarding a tenant. 2. Need to configure the Spring Security with JWT authentication. 3. I can be able to login as school admin and JWT token need to generated accordingly. 4. When I request endpoints by sending the JWT token, system should connect to the ...

I am looking for a skilled Alteryx expert who can take on a project involving data blending from complex Excel spreadsheets. The project specifically involves: - Utilizing Alteryx for blending data from multiple sheets in Excel - Handling complex data structures within the Excel spreadsheets, including nested tables and formulas. Ideal candidates will have: - Proven experience with Alteryx, particularly in handling data blending tasks - Strong understanding of complex data structures, like those found in nested tables and formulas in Excel This project requires a high level of attention to detail and proficiency in data manipulation, so please only apply if you have the necessary expertise.

I am looking for an expert in electrical design to assist me with a project I have. The scope and areas of expertise are quite broad and I'm open to input from professionals in the field. The ideal candidate should have experience in: - Circuit design - Power distribution - Control systems The end goal of this project is to maximize the efficiency of the el...improving energy efficiency, upgrading existing systems, or designing new systems from scratch. I'm looking for someone who is detail-oriented, has excellent problem-solving skills, and a good understanding of electrical engineering principles. The ability to work independently and communicate effectively is also key. If you have experience with similar projects and can bring innovative ideas to the table, I'...

I'm in the services industry and looking for someone to help me utilize Google My Business without verification to attract more customers. - I need help from a specialist who can navigate the platform and maximize its potential without the need for verification. - Experience in this area or with other alternative methods of using Goog...to help me utilize Google My Business without verification to attract more customers. - I need help from a specialist who can navigate the platform and maximize its potential without the need for verification. - Experience in this area or with other alternative methods of using Google My Business would be a significant advantage. - I'm open to any suggestions or ideas that you can bring to the table to improve my online visibility and att...

I need a form created on my WordPress website that can be filled out from the front-end by users. This form should then display the submitted values in a table. Key Requirements: - Create a form with standard fields like Name, Email, Message, and Phone Number. - Ensure the form is user-friendly, accessible, and responsive. - Develop a backend that can handle the form submissions and display the values in a table. - The table should be dynamic, updating in real-time as new submissions are made. Ideal Skills: - Proficient in WordPress, including custom post types and advanced custom fields. - Experience with front-end development and user interface design. - Knowledge of back-end development, particularly in handling form submissions and data storage. - Familiarity wi...

I'm in need of a savvy professional who appreciates the finer details of Major League Baseball (MLB). You'll be tasked with compiling a comprehensive sprea...should cover designated players and/or teams - the specifics of which I'll supply once you're on board. 3. Additional Factors: In keeping with the finer details, the spreadsheet should also cover the Date of Game, Team A vs Team B data, analysis on which pitcher is better, and predictions on which team will win. The ideal candidate will have a strong background in data manipulation, particularly in Excel or similar tools. But more than just your average data enthusiast, I'm specifically looking for someone with a deep understanding of baseball. If you can hit a home run with MLB stats and predictions, ...

I need a freelancer proficient with both Excel and Photoshop for two primary tasks. Excel Work: - Conduct data analysis and create visualizations, leveraging skills in updating and organizing data Photoshop Work: - Provide graphic design and photo editing services Ideal candidate should have solid experience in both platforms and a keen eye for details. Understanding my needs in data management and visual design will be a key success factor.

I am seeking a detail-oriented freelancer with demonstrable experience in data collection to gather texts, images, numbers, and tables from a particular website. My instructions, which will include 1 to 5 photographs, will guide you in pr...numbers, and tables from a particular website. My instructions, which will include 1 to 5 photographs, will guide you in precisely what data I need to be gathered. The freelancer will be expected to: * Carefully collect the specified data from the website * Ensure all text, images, numbers, and table-based data are meticulously compiled * Consolidate all the collected data into a neat Excel spreadsheet Your experience in data collection should be highlighted in your application. Experience in using Excel for data organization ...

I'm exploring the idea for an Android app and am seeking an experienced app developer to help shape the concept. The direction is currently open-ended, though the categories of interest ar...are E-Commerce, Social Networking and Productivity. While specifics of user authentication and design preferences are yet to be determined, I'm seeking someone who can think innovatively and work flexibly. Ideal skills and experience include: - An ability to think creatively and suggest ideas. - Experience in E-commerce, Social Networking, and Productivity app development. - Flexibility to pivot and adapt as the concept evolves. - Excellent communication skills - we'll need to have regular, open discussions. If you’re comfortable working within an undefined project scop...

Please Sign Up or Login to see details.

hello everyone we have a CRM which allows us to manage our customers, a CRM entirely coded by us in html php and javascript. we have started to integrate a function which allows us to insert customers into our CRM using an excel file, but I don't have the time to finish that. It must be ready before the end of the day, today! mandatory deadline. if we are satisfied we will entrust you with many other missions on this brand new CRM

T...the Filters on top of the page are reactive (You can see that by clicking for example on "UV-Lack, glänzend" in the Filter Section. As a reaction to your click some options in the Filter section vanish). This IS needed. As it is the most difficult part of the job please state in your bid that you understood this part. Bids that do not mention this will be ignored. - Currently the site generates a table with rows. You will have to generate a list of "Cards", like on the sample page Attached you can find the Vue-files for the new layout and the javascript-dumps (compiled and uncompiled) of our old site. In these is the functionality already alive, but obviously it'll still be hard work to get it to function. Deliverables: - Vue files that demonstrat...

I am in need of an individual with skills to assist with the migration of data from FS5 and .IDX files. My project involves: - files in FS5 or .IDXfiles that need to be migrated into a usable, readable CSV format that can be edited a - Handling text data specifically, and ensuring its integrity is maintained throughout the conversion. Potential freelancers need to have: - Knowledge of FS5 /.idx files. - Strong knowledge and understanding of text data management. - Excellent problem-solving aptitude, as the difficulty level can vary across files. I look forward to a thorough demonstration of your ability.

Apply VBA code in new Excel file

I have a project that requires an experienced developer to assist in the building of an open-source B2B e-commerce platform. Given the open-ended nature of the project, any developer considering this job should ideally bring a wide array of programming skills to the table, including but not limited to Python, Java, and JavaScript. Key Functionalities Needed: - User authentication system - Product listing and search abilities - Shopping cart functionality The platform also requires different integrations to optimize the user experience: - Payment gateway integration - Integration with various shipping carriers - CRM integration I want a professional with previous experience in e-commerce platforms and a deep understanding of B2B systems. Continued collaboration is a potential if t...

The data pipeline type we want is Appsflyer (app) / GA4 (web) data -> GCP -> Big Query. I will briefly s...settings, etc. required) 2. AppsFlyer a. All data supported by AppsFlyer & Data Locker must be linked b. Both raw data and aggregate data must be linked (all data provided by AppsFlyer, including SKAN) 3. GA 4 a. GA 4 is contracted and also includes GA 360 integration b. Both raw data and aggregate data must be linked (including SKAN) 4. Common to AppsFlyer & GA 4 a. Must be linked to a table to be searchable in Big Query b. All periods of saved data must be linked (requires retroactive loading of past data) 5. Common features a. If a problem occurs with data integration, you must be notified by email or Slack message. b. The data linking cy...

T...the Filters on top of the page are reactive (You can see that by clicking for example on "UV-Lack, glänzend" in the Filter Section. As a reaction to your click some options in the Filter section vanish). This IS needed. As it is the most difficult part of the job please state in your bid that you understood this part. Bids that do not mention this will be ignored. - Currently the site generates a table with rows. You will have to generate a list of "Cards", like on the sample page Attached you can find the Vue-files for the new layout and the javascript-dumps (compiled and uncompiled) of our old site. In these is the functionality already alive, but obviously it'll still be hard work to get it to function. Deliverables: - Vue files that demonstrat...

...experienced C++ programmer to debug, improve, and develop new features for my existing system related to hardware interface programming specifically for a Camera SDK technexion. I require assistance with: 1. Debugging Current Code: Thorough inspection of our current system to identify and rectify any existing issues in the code. 2. New Feature Development: Bringing creativity and C++ expertise to the table to develop fresh, efficient features for hardware interface programming. 3. Performance Boost: Optimizing the system to raise overall performance, response times and operational efficiency. Your ability to understand the complex layers of an embedded system is very important. You'll be interfacing with a Camera SDK technexion, so I expect you to showcase your experience...

As a vendor, I have three excel sheets containing product numbers and corresponding data. Both sheets are error-free and completely filled in, but the second sheet has its entries in a mixed order. I need a freelancer who is adept in working with Excel to match the data in the sheets based on product I.D number using the product numbers and or product name (TRS Direct Sheet) to match the size dimensions in the other sheets as highlighted via colored columns (must match colors) Sheet format cannot be moved or changed or altered in the cells already published on the 2 sheets as listed only the DATA MASTA it effects the upload process. area highlight pink no information or changes to be made or added please scroll through to observe existing pink cells. Here's a detailed b...

I need a seasoned data visualization expert who can thoughtfully organize and present my survey information via a tabular form. The purpose is mainly the presentation of findings gathered from a survey ...selected professional must be proficient in sorting out these types of data to guarantee comprehensive findings. The requirements for this project are: - Ability to interpret and visualize data of differing types - Experience in creating readable, effective tables for presenting survey results - Strong attention to detail. Your task will be to translate the raw data into an easy-to-understand table format that can effectively communicate the survey's findings. A report that can guide the audience to understand the details and the correlations of the provided input is hi...

I'm in need of an adept hydraulic or fluids engineer to create a PVC pipe gold trap tailored specifically for high water flow. Key components for this project would be: - Efficiency: The design should excel in gold particle collection, regardless of particle size - from less than 0.5mm to 2mm. - Adaptability: The trap will be utilized in a sandy soil environment. - Durability: The trap should possess a high erosion resistance to exceed in everyday wear and tear in mining operations. Your expertise in fluid mechanics, material selection and applying scientific principles to practical application would make you an excellent fit for the task. An understanding of the gold mining process would be a plus but isn't necessary. I'm looking forward to discussing your ideas an...

I'm in need of an experienced app developer who can create a cross-platform application. The app should primarily provide a data prediction feature similar to 'Probo app' or 'MPL Opinio'. The functionality of the data prediction feature needs to be a combination of predictive text input, machine learning algorithms, and real-time data...the data prediction is based on predictive text input, machine learning algorithms, and real-time data analysis Desirable Skills: - Proficiency in both iOS and Android app development - Strong background in data prediction and analysis - Previous experience with predictive text input and machine learning algorithms. This project requires someone who can bring creativity and innovation to the table, while ensuring a user-fri...

...in the folder “for translation” and the translated texts will be in the folder “translated”. The deadline for the texts in the folder will be longer (5 days max.) as they will relate to our upcoming campaigns. For the short texts, there will be an Excel table in Google Drive. There we`ll put texts for buttons, short sentences, ads, etc. The deadline for the texts within the Excel table is 24 hours. There will be about 10 lines maximum daily. If we have very urgent texts we can negotiate a higher price. You`ll have to check every day a table in Google Drive in which we`ll place short texts for translation. We need 100% commitment for this project and a serious translator who will be able to translate every day from Monday to...

As your client, I'm looking for a specialist having a proficient knowledge of Microsoft Excel to achieve a simple data manipulation project. The task involves predictive analysis of data, heavily leveraging date and time functions. Key Responsibilities: - Manipulating data using simple Excel functions. - Predictive analysis using Excel based on the manipulated data. Ideal Candidate: - Sufficient proficiency in Microsoft Excel, with specialised expertise in date and time functions. - Strong attention to detail and accuracy in data entry and analysis. - Superior skills in organising and ability to handle increasing complexity when required.

I'm seeking for an expert in Excel VBA with strong debugging and troubleshooting skills along with the ability to optimize the performance of existing macros. The key responsibilities would be: - Debugging and troubleshooting my created Excel VBA Macros - Enhancing the efficiency and performance of these Macros - Inclusion of new features as required - And finally be able to explain the code for each module. What I'd really value is a clear and concise explanation of what each module does, and this requirement would be fulfilled best by providing detailed comments in the code. This project is perfect for anyone with a deep understanding of Excel VBA, Macro functionality, and a passion for clear and enlightening code documentation.

I'm in need of a proficient developer capable of integrating an API that reflects financial statistics onto a visual dashboard. Key components of this task include: - Integration of an API that conveys financial figures. - Representation of Investment performance stats in a table format. - Visualization of portfolio return via a line chart along with portfolio assets and diversification. Experience and skills ideal for this task are: - API integration knowledge - Experience in financial data representation - Advanced proficiency in creating visual dashboards A ready-made template will be used so as not to have to develop the visual part.

I'm in need of an expert who can proficiently convert a 12-page Excel document into an editable PDF while maintaining its original layout. Key requirements: - Preserve the current layout of the Excel document in the converted PDF. - Ensure the PDF is editable not a read-only. - Important: There are links and media embedded in the Excel document that must remain functional in the PDF. Ideal skills to have: - Strong experience with Excel and PDF conversions. - Attention to details especially concerning layout preservation and media functionality. - Excellent communication skills to address any clarifications promptly. This project requires specific expertise, and the exact replication of the Excel layout is critical. If you feel suited for this ...

I'm seeking a SQL and snowflake expert. I have a small table in snowflake, for which I need a view to be created. The view will have some failed from the table and then some calculated fields based on the original table.  Needs to be done asap. Will share the table data and columns of the table in and excel sheet and the desired results as well for your reference.

Dear Freelancer, I have a little task for a video editing professional that is done very fast. Right now I have 37 short clips that need to be converted from 16:9 format to YouTube shorts format (9:16, 1920x1080px) In these videos you can see interview clips of two people sitting at a table. There are a total of three camera perspectives: - Presenter - Interview guest - Both at one table This task is about adapting the scenes by recutting the image in which both people can be seen at the table so that - the person speaking is always shown and - the reaction of the interviewee is briefly shown in the case of special reactions The overall result is that these interview sequences should be prepared for YouTube Shorts/TikTok in a high quality, in which the co...

It is necessary finish a project managemet application made in laravel. The change are: - make some change regard the flow, the links, the design, the ecommerce and report; - It is necessary experience in query, report charts, pivot builder and Business intelligence to change the reports that must have good design, many filter and cross. the charts must have drill down. Please answer only if have experiences in project management software and pivot-query-busienss intellegence. And show my the url of similar job made.

I need a freelancer to revamp the tables and figures in my Word document. The current visuals need a professional overhaul, without losing the data integrity. Key project details are: - **Recreation Scope:** I prefer the tables and figures to be redesigned with a corporate and professional theme. The goal is to enhance the visual appeal while maintaining the substance and clarity of the data. - **Technical Expertise:** The ideal candidate should be well-versed with Word functions and capable of creating visually appealing yet professional graphics. - **Communication:** Clear communication is key. I expect regular updates and the opportunity to provide feedback throughout the revision process. Ideal skills for the job include proficiency with Microsoft Word and a strong understanding of...

...and graphics, making it both informative and visually appealing. - The textual element should prioritize the use of a clean, modern, and legible sans serif font. - For the icon, I'm open to abstract shapes. The design should introduce a captivating degree of intrigue, sparking interest and conversation. The ideal freelancer for this job would bring the following skills and experience to the table: - Proven experience in text-icon logo design - Strong versatility in handling a variety of font styles, particularly sans serif - An innovative outlook towards abstract design and visual symbolism A portfolio demonstrating previous work in icon and text-based logo designs will be highly valued. Please share pertinent work samples in your bid. Your creativity and willingness t...