Create pivot table dynamically excel jobs

As someone struggling with certain aspects of Excel 2016, I need an experienced VBA Developer who can assist in creating custom Excel functions and rectifying existing Excel errors. Key duties will include: - Macros programming to automate repetitive tasks - Troubleshooting and fixing inaccuracies in the current Excel functions, if any Despite my lack of specificity about the exact functions or errors, I expect the developer to have a strong understanding of Excel functions in general and to use this knowledge to identify any issues that may exist. Ideal candidates should: - Have significant experience in VBA development - Have a solid understanding of custom Excel functions - Be proficient in troubleshooting & error handling in Excel...

I need a 2D construction drawing of an iron and recycled plastic lumber picnic table, ideally sized at 7' long. The primary purpose of this table is for public park or space furniture. We have been provided the exact details to follow by the owner. We do not have access to the CAD drawing therefore it has to be created from scratch. Drawing to be formated as 36" long x 24" high (Arch D) The font style used should be arial and all caps. A new title box will be required. see provided example in template. Key Features: - Wheelchair Accessibility: The table should be designed to accommodate wheelchair users, ensuring they can easily access and use the table. Skills and Experience: - Experience with 2D drafting and designing furniture is essen...

I am in need of a highly skilled developer who is well-versed in Pine Script Skills and Experience: - Proficient in Pine Script development for TradingView. - Strong understanding of various Pivot calculation methods - Prior experience in developing custom trading indicators is highly preferred. - Good understanding of trading and technical analysis concepts. Please ensure that you have the relevant experience and a comprehensive understanding of the project requirements before bidding.

I am looking for a professional who can help me create static QR codes that will be used on my product packaging. The primary purpose of these QR codes is to direct customers to a specific website URL that is related to the product. The content of the QR code will not change over time, as it is intended to be static. Ideal Skills and Experience: - Proficiency in creating and managing static QR codes. - Experience in linking QR codes to specific website URLs. Please note that the information to be contained within the QR codes will be provided by me. I am looking for someone who can bring technical expertise to the table, ensuring that the QR codes are functional and readily scannable.

I need to have an excel sheet to track expenses made on each items coming under 'purchases for office construction works', stationery for office, project software tool like project management tools, hosting service plans etc also for nterior decoration, expense on inaugration and also i need to list expected cost for future purchases

I am currently in need of a proficient Excel expert capable of aiding me in data analysis for my investment data portfolio. The Ideal Candidate Should: - Have in-depth knowledge and experience in Excel, particularly in handling and managing large amounts of data with efficiency. - Be familiar with investment-related data and understand trends to aid in analysis. - Be able to demonstrate past work on similar projects, ideally in the investment sector. Project Scope: - The task involves in-depth data analysis of my investment portfolio which encompasses various types of data. - The freelancer will need to interpret and analyze the data using advanced Excel formulas and techniques. The successful freelancer should include their past work in their application. An unde...

I require an expert in Python and Excel to assist with data analysis and manipulation tasks. The central focus will be: - Data Reshaping: You'll be transferring data from daily received *.xls files to a timeseries database. Tee database must be updated regularly, every day when one or more new datasets are available. - Data Cleaning: This involves improving the quality of data in our Excel files. Inaccuracies are often a result of missing data, which you'll need to identify and rectify. Key skills and experience needed: - Proficient in using Python with Excel for data analysis and manipulation. - Expertise in data cleaning, particularly in identifying and addressing missing data, double occurences, inconsistent datas - Experience in reshaping data i...

I'm looking for a VBA programmer to help me with creating custom functions and macros for data analysis in Excel. Key Tasks: - Creating Macros: The project involves developing macros that can automate repetitive tasks and facilitate data analysis. - Building Custom Functions: I need custom functions to aid in data cleaning and manipulation, as well as report generation. Ideal Skills: - Proven experience in VBA programming, especially in Excel. - Strong background in automating tasks and data analysis. - Ability to develop custom functions for data cleaning and report generation. Output: - The generated reports should be in an Excel spreadsheet format, as well as a PDF document. Please provide samples of your previous VBA work, specifically any projects rel...

...Word. The successful freelancer will excel in the following areas: - Expertise in formatting documents in Microsoft Word, particularly in the context of books. - Knowledgeable in setting up appropriate page layouts that will represent my content in a visually pleasing and easy to navigate manner. - The ability to create stylistically consistent and engaging chapter headings. - A keen eye for selecting and applying font styles that enhance readability and match the tone of my book. Past experience in similar book formatting projects would be considered an asset. This project consists of: -Assuring uniform layout of pages -Insert rectangle shapes behind certain areas of text -Making sure the numbering is consistent -Using Styles for headings -Adjusting Table of Con...

I'm in need of a skilled video editor to create engaging Facebook ads out of raw footage that we provide. Each ad should be approximately 15-30 seconds long and should have a fast-paced, energetic style social media reels style. Key Responsibilities: - Edit raw video materials into 15-30 second Facebook ads - Ensure the ad has a fast-paced, energetic style - Incorporate a voice-over into the video, captions... -creativity Ideal Skills and Experience: - Proven experience in video editing for social media platforms - Proficient in creating videos with a fast-paced, energetic style - Ability to include a voice-over in the video, captions, animations... - Creative mindset and strong attention to detail If you are a video editor with a keen eye for creating high-energy, engaging ...

I'm looking for a skilled MS Excel professional who can work on a multi-sheet file that requires data analysis, formula application, and design enhancements. Key Requirements: - Data Analysis: The primary aspect of this project is to analyze the existing data. - Formulas and Functions: Implementing formulas and functions to drive accurate calculations and insights. - Formatting and Design: Enhancing the visual appeal of the sheets, ensuring they are user-friendly and professional. The file contains 2-5 sheets, and I anticipate that the work will involve a mix of data analysis, formula implementation, and design adjustments. Since I've opted to complete the project, I'm open to any additional suggestions you might have to enhance the overall functionality of the she...

In order to effectively drive my ongoing project, I'm in need of someone skilled at gathering specific data and preparing it into a highly organized spreadsheet. The data needed include: - Name - Email - Job/Business - Phone number(Whats app) of (NRI) Non Resident Indians in UAE The ideal ca...specific data and preparing it into a highly organized spreadsheet. The data needed include: - Name - Email - Job/Business - Phone number(Whats app) of (NRI) Non Resident Indians in UAE The ideal candidate for this task should demonstrate: - Proficiency in data collection, and data management. - High level of accuracy and attention to detail. - Proven experience in sourcing data and utilizing Excel or similar spreadsheet software. Looking forward to advancing my project with ...

I need someone to transcribe the content of the picture to a excel as the same way. I have 100 picutures like this one. How much for this job?

My Excel file is very heavy and unorganized. I want it to get cleaned and effecient

I’m looking for a freelancer proficient in Excel who can create a dynamic tool for my restaurant business that helps in managing my food costs and menu pricing calculations. Key responsibilities include: 1. Cost Analysis: Crafting a spreadsheet that can factor-in: - Food cost percentage - Gross profit margin - Break-even analysis 2. Menu Pricing: The spreadsheet should provide calculations on: - Menu item profitability - Menu item pricing based on the desired profit margin Ideal candidates are detailed-oriented and have substantial knowledge in cost analysis and pricing strategy in the restaurant industry. Excel expertise including functions and formulas is paramount. Past experience in successfully building such tools will be a definitive plus...

We are seeking a software developer to create a solution that, through a form, allows the configuration of API usage parameters, such as headers and HTTP method (GET or POST), and the selection of data to send as filters, such as by name, identification number, or both, similar to the functionality of Postman for configuring requests on endpoints. This form should enable the creation of multiple API configurations for consumption. The initial response must be mapped with a list of preset fields and then generate a new response with the mapped information to standardize the response from all external sources to be configured. The results will be displayed independently in each API connector created in a table viewer as it comes from the source to perform mapping within the d...

We're on the lookout for skilled animators adept at infusing life into our milkbag persona through captivating and witty Instagram Reels and animated content. Our ideal candidate possesses a solid grasp of animation principles and consis...of content we're aiming for. We aspire to achieve a similar level of ingenuity and amusement in our milkbag character Instagram Reels. How to Apply: If you're passionate about animation and possess a talent for crafting entertaining Instagram Reels and understand cryptocurrencies and trading we're eager to hear from you! Please include your portfolio and a brief statement outlining why you'd excel in this role in your application. Additionally, feel free to share any relevant experience or ideas on bringing our milkbag c...

I need a simplistic, one-page website linked to a database. This page will have limited content, including a logo and a 'check authenticity' button. The database will be provided in an Excel sheet format, and must be integrated seamlessly into the page. Key Requirements: - Develop a one-page website - Integrate an Excel database for product authentication - Provide a clean, simplistic design Ideal Skills and Experience: - Experience in web development, particularly one-page websites - Proficiency in database integration, specifically Excel - Ability to create clean and minimalist designs - Strong understanding of web security and authentication processes

We are seeking a software developer to create a solution that, through a form, allows the configuration of API usage parameters, such as headers and HTTP method (GET or POST), and the selection of data to send as filters, such as by name, identification number, or both, similar to the functionality of Postman for configuring requests on endpoints. This form should enable the creation of multiple API configurations for consumption. The initial response must be mapped with a list of preset fields and then generate a new response with the mapped information to standardize the response from all external sources to be configured. The results will be displayed independently in each API connector created in a table viewer as it comes from the source to perform mapping within the d...

I am working on a travel memoir; a blend of non-fiction with a twist of fiction. In need of an enticing book cover for Amazon KDP, aiming to entice readers at first glance. Key project requirements are: - Creating a...in the travel or memoir genres. - A good understanding of Amazon KDP's book cover guidelines. This job requires a creative mind, as it will entail striking the balance between my personal vision and your professional expertise. I look forward to collaborating with a designer who can help bring the identity of my book to life with a memorable and compelling cover, not using AI! I can supply a Table of Contents to give an idea of how the book is written, as well as a few photographs that could be incorporated into the design if you see fit. I look forward to he...

I'm seeking an expert in data analysis to help with profiling and analyzing our financial data. The ideal professional will have the following experience and skills: - Proficient in financial data analysis - Able to generate comprehensive analytical reports - Experienced in Excel for data presentation

I'm looking for a skilled WordPress & App developer to create a dynamic web application and corresponding iOS/Android apps. The project is aimed at developing an Events and Staff Management application. The main features of the application will include: - Event Scheduling: The application should allow for the smooth scheduling of events. - Staff Scheduling: The application should facilitate in allocating staff to the scheduled events. - Attendance Tracking: The app should track the attendance of staff and participants at events. - Embed Video Call Platform: I'd like the application to have the ability to embed a video call platform for virtual events, such as Zoom. - Access Pass Creation: The app should be capable of creating unique 'Access Passes' for users...

I'm searching for a skilled Virtual Assistant (VA) to manage a small inventory of less than 100 entries. Your responsibilities will include: - Data entry: Accurately inputting necessary information into our system. - Spreadsheet management: Expertly organizing and managing our inventory data in Excel. - Reporting: Creating clear, concise, and actionable reports based on the inventory data. To execute these tasks proficiently, you should be well-versed in the SUMIF and Pivot Tables functions in Excel. Prior experience in managing small to medium-sized inventories will prove beneficial. Your ability to pay attention to detail, demonstrate excellent problem-solving skills, and deliver results in a timely manner will be important for success in this role.

summarize in a specific table in Excel

Simple editing task to enhanced an existing image

Hi Ravi Ranjan K.,I have a task of import of purchase excel to tally prime for now .

I'm looking for a professional mobile app developer who can create a robust e-commerce application similar to Fashion Nova. The app is intended to be developed for both iOS and Android platforms, with an additional web app component. Key Features: - User Registration and Login - Product Browsing and Search - Shopping Cart and Checkout - Vendor Page - Order Tracking - Admin Panel - Dynamic Backend Analytics - Personalization - In-App Chat for Customer Service I am not looking for specific design or branding requirements at this stage. I'm particularly interested in your experience with e-commerce app development, as well as any unique features or functionalities you can suggest to enhance the user experience. Please provide any relevant examples from your portfolio.

Project details €25.00 - 300.00 EUR. I am looking for an experienced developer to create a bot (on the telegram platform) capable of instantly buying and selling Solana tokens on Raydium, Jupiter DEX. You will need to develop a bot that will perform transactions fully automatically, without the need for manual approval. Key features: Telegram platform Seamless integration with Raydium. Orca. Jupiter. Phantom wallet import Instant execution of buy/sell orders (swap in less than 1 second) Copytrading Full automation of operations. The ideal candidate should have: Experience in programming trading bots. Excellent knowledge of Solana and its DEX platforms (Serum Dex). High level of accuracy and attention to real-time changes. More details will be provided upon receipt of the as...

I'm in need of an expert in Excel for data entry and cleaning. The tasks involve handling text-based, numeric, and date & time data. Key Responsibilities: - Perform accurate data entry - Cleanse and format the data as needed Ideal Skills and Experience: - Proficiency in MS Excel - Proven experience with data entry and data cleaning - Attention to detail - Ability to work with various data types, including text-based, numeric, and date & time data

I am currently using ZOHO Books and am looking to migrate to Odoo Accounting. I need an Excel expert to help with the migration process. Key Tasks: - Migrate complete set of invoices and bills from ZOHO Books to Odoo Accounting. - Transfer all customer and vendor details accurately to Odoo. - Ensure that financial reports are maintained and migrated correctly. Ideal Candidate: - Proficient in both ZOHO Books and Odoo Accounting software. - Excellent experience in data migration and Excel. - Familiar with maintaining and handling large databases. - Detail oriented, ensuring data integrity throughout the process. This is a large scale project as my current ZOHO Books database exceeds 1000 records. I need someone who can efficiently and effectively handle the migration proc...

Answer the attached question correctly, and briefly explain. using principles of subnetting. I'm looking for an expert in networking who can provide correct answer and clear and concise explanation of the attached question. Answer the attached questions, the provide table of the subnets Accepted file format Excel or Word

Create ui for rice disease detection model in flask

I'm in need of a professional to write concise yet comprehensive reports. Details regarding the purpose and type of reports were not specified. Ideally, the freelancer should be adept in creating performance analysis, expense tracking, project updates, financial, sales, and progress reports as all these may be requested. T...were not specified. Ideally, the freelancer should be adept in creating performance analysis, expense tracking, project updates, financial, sales, and progress reports as all these may be requested. The frequency of generating these reports is also yet to be confirmed, so preparedness to deliver on a daily, weekly, or monthly basis is essential. Superior skills in data analysis, proficiency in excel or other relevant software and report writing is a must fo...

I am seeking a skilled freelancer with proficiency in Excel, especially in performing statistical analysis using frequency distribution and creating informative visualizations. To get specific, the scope of work involves: - Converting my Excel sheet data into meaningful insights via statistical analysis - there is 12 workbook, represent date palm trees five varites. - each tree has branches which is recorded in the cell. -some trees did not produce - need a colorfull charts that represent branches . IF BRANCH IS 0 MAY BE WE COLOR RED. IF ONE WE GIVE OTHER COLOR, IF 10 MAY BE GREEN. - NEED TO HAVE THE SUM OF BRANCHES TOTAL NUMBER IN EACH WORK BOOK - BRANCHES MAY PRODUCE 4 KILO OR 5 KILO: NEED TO HAVE A FORMULA THAT I CAN CHANGE AND KNOW THE TOTAL PRODUCTION OF EACH WORKBOOK...

...seeking a Python developer who can automate certain calculations in my existing Excel files. The calculations that are currently done manually in Excel need to be automated. This means the Python script you develop will need to accurately and efficiently perform these calculations every time it runs. As for the frequency, the system should run calculations on demand. This way, I can trigger it whenever I need the numbers updated. The calculations are based on the data currently stored in my Excel files. So the script will need to read this data, perform the necessary calculations and update the files with the new results. The ideal candidate should have: - Proficiency in Python - Experience in working with Excel files - Understanding of automation proc...

I need assistance with entering inventory data into Quickbooks Desktop from an Excel file. - I'm looking for a professional who has experience with Quickbooks Desktop. - The job involves bulk data entry, focusing specifically on inventory. - You will be provided with an Excel file containing the inventory data. - Attention to detail is crucial to ensure accurate and efficient data entry. Ideal skills: - Proficiency with Quickbooks Desktop - Experience with data entry, particularly inventory - Attention to detail and accuracy in data entry - Familiarity with Excel files and their import into Quickbooks

We need experienced IOS APP developer to create a program that will assist in our medical project. The project Each student will receive a piece of paper with small colored litmus squares on top. Student will drip chemicals onto each square and observe the color change on the litmus squares. The 'NEW' color of each litmus square must match against a "Legend/Color Chart provided". Student will take a picture of the colored squares with their phone camera and upload it onto the APP/program. The APP/program will need to find the closest color match from the Legend, and display the final result. Requirement The app does not have to look pretty. Something basic will do. The APP must be able to accurately identify the ‘New’ color against the Legend...

I'm in need of a web scraping wizard who can help me extract text data and profiles from Twitter website. Key Requirements: - The ability to scrape text data and profile information efficiently and accurately. - Experience in ...Requirements: - The ability to scrape text data and profile information efficiently and accurately. - Experience in web scraping, with a strong portfolio showcasing past work in similar projects. - The time for scraping a post and profile must be less 3 seconds without using Twitter API. The final deliverable should be in a format that's easy for me to analyze, but I'm flexible on whether it's a CSV file, Excel spreadsheet or a database format. Please describe your past work examples with your application. Write "Blue" on th...

I am in need of a content creator who will create five copyright-free YouTube videos for my channel. The videos will be focused on observable tales and dodgy stories, a topic that young adults, my target audience, can appreciate. - Video Content: The videos will revolve around a variety of "dodgy tales". Succinct storytelling skills are paramount. The ability to craft engaging, compelling narratives will be highly appreciated. - Video Length: Each video must be around 4 - 5 minutes. Please note that creating content that fits within this time limit but still successfully delivers the intended story is crucial. - Target Audience: The videos will be tailor-made for young adults. Knowledge and understanding of this demographic’s preferences will be beneficial. - Skills...

I'm looking for proficient freelancers who can effectively input both text and numerical data into Excel from physical documents. The task does not require any formulas or calculations, but attention to detail is crucial to ensure the accuracy of data. Key tasks include: - Manual entry of text and numbers from physical documents into Excel - Ensuring accurate data entry and quality checks Ideal freelancers should: - Have experience in data entry tasks, particularly with Excel - Be detail-oriented to ensure accuracy - Have strong organizational and time management skills.

I require the expertise of a part-time remote accountant who can commit to less than 20 hours a week. The core tasks involve: - Bookkeeping: Systematically recording and organising my financial transactions. - Payroll: Managing payroll functions to ensure that employees are paid in a timely...can commit to less than 20 hours a week. The core tasks involve: - Bookkeeping: Systematically recording and organising my financial transactions. - Payroll: Managing payroll functions to ensure that employees are paid in a timely and accurate manner. - Financial analysis: Monitoring, identifying and interpreting financial trends. The ideal candidate should have a good command of QuickBooks and Excel spreadsheets. Familiarity with these tools is crucial for performing tasks efficiently and a...

I'm looking for an expert in Excel who can help me with applying conditional formatting and creating complex formulas that involve multiple conditions. Please watch this video for what i need Key Requirements: - Applying Conditional Formatting: The Excel file will require conditional formatting to visually represent data based on specific criteria. - Creating Complex Formulas: The project includes creating formulas that are not limited to basic arithmetic, and instead, involve multiple conditions. Ideal Skills and Experience: - Proven expertise in Excel: The ideal candidate should have a strong background in working with Excel and creating complex formulas. - Understanding of Conditional

...recognizing the number, it needs to check if that number is included in the PadresTable, in the Numero column. 3) If the phone number belongs to that column, I want it to go to the HijosTable and associate all children associated with the parent. Then, the bot should ask the parent with which child they want to schedule a tutoring session from the previously associated ones. If the number is not in the table, show a message indicating it doesn't belong to this school. 4) Once the parent selects the child they want to schedule a tutoring session for, I want to give them the option to schedule with the desired teacher. The selected child will be associated with the teachers they have through the ProfesoresHijosTable, and I want to give them the option to choose the teacher the...

I'm looking for assistance with online data entry to Excel. The task is not overly complex but will involve working with reference numbers and ensuring accurate data entry and cross-referencing. Full training will be given and I will explain all. Budget is hourly and $3 max need to have good understanding of English

I'm in the process of opening a Caribbean cuisine restaurant and need a creative designer to help me craft a beautiful, modern menu. Key Requirements: - **Design Style**: The ideal menu should embody a 'Modern' aesthetic, reflecting a contemporary take on traditional Caribbean elements. - **Format**: This menu will be a print version, not digital. Ideal Skills...appealing and cohesive designs. - **Menu Design Experience**: Previous experience in designing menus, especially for restaurants, is a major plus. - **Understanding of Caribbean Aesthetics**: While not mandatory, a familiarity with or an appreciation for Caribbean visuals would be great. If you have a keen eye for design, love the Caribbean culture, and can bring a fresh, modern perspective to the table, I...

I am looking for an efficient data entry expert to assist me in entering textual, numerical, and image-based data. The project involves a medium amount of data that needs to be meticulously transferred to an Excel file. Your responsibility will include, but is not limited to: - Inputting textual data while maintaining accuracy. - Adding numerical data precisely. - Uploading images correctly. An ideal freelancer for this job would have a keen eye for detail, substantial experience with Excel, and the ability to handle different types of data. Prior knowledge in image uploading and handling is a plus. You should also pride yourself on accuracy and efficiency. In your proposal, please share a brief summary of your experience, including one to two data entry projects you hav...

Automated report using dashboard in Excel The report interface should be similar look to the pic attached. The Excel file for data source should be able to be used for Power BI. Two dashboards: 1- for multiple project management status reporting 2- for ad-hoc task management The data source is in an Excel sheet with a manual entry

I'm looking for a skilled professional who can create a 1-minute live video on our website. This live video will be streamed using the front camera and will serve as a product demonstration. The ideal candidate for this project should have experience in: - Video production and live streaming - Web development (to integrate the video on our site) - Understanding of live video interaction features Key requirements: - Create a 1-minute long live video - Use the front camera - Support real-time comments - The video should be engaging and visually appealing - Ability to optimize the video for web streaming - Ensure the video is compatible and functional across different web browsers - Deliver a product demonstration that is clear and concise - Implement interactive elements...

I'm looking for a data engineer with solid Pyspark knowledge to assist in d...that consists of creating an application that runs on Airflow and connects to an API with survey metadata with values such as if it was opened, if it was answered, etc, then it should generate a zip file with all the data in jsons and save it in a S3 bucket. Once in the bucket you must save the information in a Hive table. All the code should be from Pyspark and there is a similar application that saves the raw survey data that you can take as reference. You need to create the table and generate the code, the end client is Expedia and it should be done using their environment, I would give you the credentials and ask what you need with my colleagues. If you like we can have a video call ...

I'm seeking a skilled professional to enter 100-500 text entries for me. Key Responsibilities: - Entry of primarily textual data - Handling 100-500 entries Ideal Skills: - Proficient with Microsoft Excel - Excellent attention to detail - Strong typing and data entry skills. Experience in similar projects will be highly appreciated. I look forward to your bids for an efficient data entry task.