How to use pivot table data in formulas punët

I'm looking for a skilled interior designer who can help me transform my home into a combination of modern an...five key areas: - Living Room - Kitchen - Bedroom - Bathroom - Study The ideal candidate must have a strong background in modern and ethnic Indian interior design and ample experience in transforming various spaces into sleek, contemporary environments. You should be able to bring fresh, innovative ideas to the table and harmoniously blend functionality with aesthetic appeal. A keen eye for detail, excellent communication skills, and the ability to understand and incorporate my preferences into the design are essential. If you have a portfolio showcasing similar projects, that would be a big plus. Ideally, you should be located ...

...professional adept at advanced Excel functions to create a spreadsheet, which would organize and manage our worker rota for late shifts from Monday to Friday. We have two sites, including inpatient and outpatient pharmacies, which need coverage. Key functionalities of the required Excel Spreadsheet: 1. Worker Availability: - The ability to input more than 20 workers' availability. - An advanced combination of automatic and manual assignment based on the available days of our workers considering part-timers. 2. Worker Ability: - A system to allow input about the worker's ability to cover specific sites, based on their previous experience. The ideal freelancer should have a high proficiency in Excel, including VBA, Macros, ...

I need a skilled Excel user to help me format a single spreadsheet and create formulas to automate some calculations. Key Responsibilities: - Format the spreadsheet to make it visually appealing and easy to read. - Create formulas to automate calculations based on the data input. - Ensure the spreadsheet is user-friendly and easy to update. Ideal Skills and Experience: - Proficiency in Excel, particularly in data formatting and formula creation. - Prior experience in handling data-heavy spreadsheets. - Strong attention to detail to ensure accurate data processing. - Ability to work independently and deliver the project in a timely manner.

use translationpress and deepl to auto translate wp into many languages

...experienced in making comedy content. Your main roles will involve: - Creating and executing comedy sketches for TikTok. - Writing your own scripts for the comedy content. To increase brand awareness, your content should be engaging and hilarious to prompt widespread shares and likes on the platform. The ideal candidate should have: - A background in comedy scriptwriting. - Proven experience in creating comedy content. - Familiarity with the TikTok platform and understanding of its algorithm. - Ability to work independently and within strict deadlines. - Capability to measure the impact of content on brand awareness. If you can create rib-cracking, unique, and engaging TikTok content, you could be the perfect fit for this role. The po...

I am searching for a knowledgeable expert in Microsoft Excel who can assist me with a variety of tasks. Specifically, I require aid with formulas and functions, and formatting and design. More specifically, I need assistance with summation and averages, and VLOOKUP and INDEX-MATCH commands. The ideal candidate would have substantial proficiency and experience with Excel, with an emphasis on utilising complex formulas and creating aesthetically appealing and comprehensible spreadsheets.

...ideas to life through both graphics and video content creation for my social media platforms. I prefer to work with someone who is proficient in Adobe Photoshop, CorelDRAW, Adobe Illustrator, and Canva. You should have a good eye for detail and a keen understanding of what makes content engaging on social media. The job entails creating content of various types, including images for posts, short video clips, and infographics. You should be able to adapt your style and skills across these different formats, ensuring that each piece you create resonates with my target audience. While I've skipped over specifying a particular style or theme for the content, I value creativity and originality. I'd like you to bring fresh ideas to the ...

I've got a small batch of personal photos that I'd love to have professionally edited. - The pictures need to be enhanced to bring out their best qualities, without looking overdone. - I'd like any unwanted elements removed. It's crucial that the edits are subtle, yet impactful. - The final images should be suitable for personal use, like printing and framing. Ideal Candidate: - Experience in photo editing and retouching - A good eye for detail and creative sensibility - Ability to deliver a high-quality, professional finish. I'm looking for someone who can work efficiently and is open to a few revision rounds, if needed. Please get in touch if you can bring my personal photos to life.

...experienced Excel guru to help create / identify two specific formulas on my spreadsheet. This project is URGENT. The right excel Guru can probably figure this out in less than an hour. Easy money. The first formula is related to searching a cell for one of four words and populating an adjacent column with a correlating value, based on the word found. The four words to be searched for are "Low", "Medium", "High", and "Not currently a priority". The adjacent cells are to be populated with correlating values 1, 2, 3, and 0 (to generate a Score). The cells are currently blank, and users of the spreadsheet will fill these cells by selecting from a drop-down list (of these 4 words). The objective is ...

I'm in need of a skilled digital marketing professional who can significantly increase the Domain Authority of my B2B website. This project is crucial as it's directly linked to my overall SEO strategy and online visibility. Key Goals: - Improve the search engine rankings of my website - Increase organic traffic to the site - Enhance the online visibility of my brand Ideal candidate: - Extensive experience in digital marketing, particularly in boosting domain authority - A proven track record of improving search engine rankings and increasing organic traffic - Demonstrable expertise in enhancing brand visibility through effective online strategies Your proposal should focus on your relevant experience, particularly on how you pl...

I'm looking for a skilled video editor who can...social media platforms, specifically Instagram, YouTube, and TikTok. Key Responsibilities: - Conduct advanced color correction to ensure the video is visually appealing and on-brand - Enhance audio quality to make the video engaging and professional - Optimize the video for each platform's specifications and requirements I need a professional with: - Proven experience in advanced video editing, including color correction and audio enhancement - Familiarity with social media content requirements and trends - Excellent communication skills and ability to understand and implement feedback I'm looking for someone who can bring creativity and technical expertise to the table, helping m...

...assistance with a specific task related to Excel. This task involves the careful extraction of data from Excel into a pivot table. The data in question is financial in nature, and more specifically, the focus is on expenses. Here is what I require: - Just the expenses data extracted from the Excel file and made available for the creation of a pivot table. - You'll need to determine the format of the data in the Expenses column. Your skills and experience: - Advanced knowledge of Microsoft Excel, especially in working with different types of data. - Proven experience in handling financial data, specifically expenses. - Ability to interpret varying formats ...

...club's essence to life through a captivating T-shirt design. Here's what I'm looking for: - **Color Scheme:** I'm open to suggestions. Any color palette that you believe can capture the spirit of our club is welcome. - **Theme:** The design should revolve around the theme of theater. It should resonate with the dramatic arts and the essence of performance. - **Elements:** Please incorporate the following elements into the design: - Masks: Symbolizing the theatrical nature of our club - Curtains: Representing the opening and closing of our performances - Spotlights: To highlight the spotlight our club shines on its members and their talents - Cap: A subtle addition that represents our club's official attire Your design should be vis...

**NO OR LIMITED EXPERIENCE IS OK - FEEL FREE TO APPLY. DO NOT USE GENERIC BID TEXT (NO COPY PASTING)*** Role is perfect for motivated and learning individuals who are eager for feedback and want to grow skills. Duration is 30 days internship. Those who surpass expectations will receive a serious offer to stay on team with better compensation. Sample tasks and responsibilities include, and are NOT limited to: 1. Research key topics or areas of interest and presenting options for the next steps. -> googling 2. Executing next steps and promptly executing action items from discussions. -> take instructions and act fast 3. Propose options from research as requested -> more googling 4. Be able to advise proactively on details including ...

...well-connected individual who can collaborate with me to source high-end individuals for a unique project. Key responsibilities: - Sourcing Billionaire Club Presidents: Utilize professional networking sites, exclusive events, direct outreach, and connections to identify suitable candidates. - Running Portfolios: Coordinate the portfolios of these individuals, tracking their performance and making strategic adjustments as needed. - Generating Portfolios via Events: Plan and execute events that attract potential club presidents and generate new portfolios. The ideal candidate should have: - Proven experience in sourcing high-net-worth individuals - An existing network in the business and finance world - Strong project management skills, especially in ...

Please make wordpress site as atteched image. 1 column and respoinsive design.※If possible,bootstrap design. Anything is include dummy text and dummy images. I make inquiry and faq,sitemap page by myself and send you wordpress login details. Required Pages:Top page,fx,crypto-ex page,1 currency detail page Please make within $120(absolute requi...design.※If possible,bootstrap design. Anything is include dummy text and dummy images. I make inquiry and faq,sitemap page by myself and send you wordpress login details. Required Pages:Top page,fx,crypto-ex page,1 currency detail page Please make within $120(absolute requirement) and delivery within about 2 weeks and give me a progress report every about 4 days. I think only the table part is a little more challenging.

**NO OR LIMITED EXPERIENCE IS OK - FEEL FREE TO APPLY. DO NOT USE GENERIC BID TEXT (NO COPY PASTING)*** Role is perfect for motivated and learning individuals who are eager for feedback and want to grow skills. Duration is 30 days internship. Those who surpass expectations will receive a serious offer to stay on team with better compensation. Sample tasks and responsibilities include, and are NOT limited to: 1. Research key topics or areas of interest and presenting options for the next steps. -> googling 2. Executing next steps and promptly executing action items from discussions. -> take instructions and act fast 3. Propose options from research as requested -> more googling 4. Be able to advise proactively on details including ...

I've been facing issues with a MySQL table that seems to be taking up too much space in my database, despite there being no data in it. The table is almost 2MB in size while it has no rows at all. The database was originally like 50kb a few weeks ago. Recently we made some minor changes, like adding index. Then it suddenly become so huge. Key points: - Table size issue: The MySQL table is bloated despite having no data, and it's causing performance problems. - Insertion operations: The table is mainly used for inserts, which are what I need it to be optimized for. The work needs to be done remotely using anydesk. If you know how to do it, it should be just a few min fix.

I am searching for an experienced freelancer who is proficient in document formatting for Windows. I need my company manuals format fixed, the table of contents, page number, spacing, etc needs to be fixed The project entails: - Formatting 1-5 company manuals to enhance readability and presentation. - Ensuring consistency in all documents, including headers, footers, and design elements. Ideal candidate: - Proficient in MS Word formatting for Windows. - Experience in handling company manual formats. The selected freelancer will help me to deliver professional and well-structured company manuals.

We need to improve an already existing pitch deck. Our project is to bring UFCGYM to France. The goal is to convince investors to put money on the table with the pitch deck. For the pitch deck, we need to go to the next level by improving the general design, and also making more clear what the investor will gain from this project. We would like an investor focused pitch deck with a compelling presentation regrouping facts and figures A timeline with milestones on market number and our financial analysis Ensure clarity and simplicity by using clear and simple charts to present financial data, avoiding information overload on a single slide. Utilize data visualizations like bar charts, line graphs, pie charts, and ...

...looking for a developer to create a Bootstrap filter table with advanced filtering functionality. The table should be responsive and able to handle multiple columns. Here are the specific requirements for the project: *** DO NOT BID ON THIS PROJECT IF YOU HAVE NO UNDERSATNDING OF BOOTSTRAP OR SOME IDEA OF THIS PROJECT. A TEMPORAY SKETCH LAYOUT WITH A SAMPLE WITH BE APPRICATED TO HELP US IN MAKING A DECISON WHO TO AWARD THE PROJECT TO. *** Functionality: - Advanced filtering: The table should allow users to filter data based on multiple columns. - Custom filtering: Users should be able to specify criteria for filtering. Responsiveness: - The Bootstrap table should be responsive, ensuring optima...

...looking for a talented designer to create a visually appealing presentation, portfolio or catalogue. The primary goal of this project is to showcase products and services in a compelling way. I put no restrictions on the theme or color scheme, so I'm open to your suggestions and creative inputs. This project will involve creating an engaging design that is both aesthetically pleasing and functional. The content will mainly consist of images and descriptions of products and services. I'm looking for a designer who can create a sleek, modern design that is both informative and visually appealing. You need to use the attached file and info provided there. Just need to redisign. Also need to remove all watermarks from or...

...architectural and design services for a mixed-use property project. This entire space covers 35k sq ft with a front of 130*275. It's divided into three units and a 100 * 100 ft commercial complex. 1 st unit 4 master bed room ,1 kitchen with extra food space and wash area ,1 hall ,Pooja room (jk),jakusi, 2 nd 5 master bed room ,1 kitchen with extra food space and washing area ,Pooja room jakusi,1 hall ,1 room for office 3 Rd home theter,Jim , swimming pool ,table tennis 4 garden ,badminton court ,car parking Lazy river and whole home surrounded by water naturally - 5 Servant and guard rooms The commercial complex design should be modern, practical and appealing to businesses. Ideal skills and experience: - Proven experience in designing mixed-u...

I'm looking for a creative mind to produce engaging 15-second product level videos to be used in Meta & Pinterest Dynamic Product Level Video Ads. WHO YOU ARE: - You have a firm grasp on the interests and trends of our target demo (young families with kids; approx 20-45 years old) and can captivate this demographic through short video format - You are familiar with the short, snappy format of 15-second social media videos and can effectively convey a product's appeal in this timeframe. WHAT YOU'LL DO: - Develop compelling 15-second product videos from static images for Facebook, Instagram, Snapchat, and Pinterest. Ideal skills: - Proven experience in creating short social media videos - An understanding of Facebook, Instagram,...

...converting Excel formulas to Google Sheets, particularly with the VLOOKUP function. The problematic formula in question is central to my data analysis processes. I need a professional who can troubleshoot and effectively convert these formulas to be compatible with Google Sheets. Key Tasks: - Identify the source of the "IFERROR" error in the VLOOKUP formula as it functions in Google Sheets. - Modify the formula for accurate results in Google Sheets, ensuring it retains its original functionality post-conversion. Ideal Skills and Experience: - Proficient in both Excel and Google Sheets formulas and functions. - Strong experience with VLOOKUP and IFERROR. - Ability to troubleshoot and ad...

Hi Nima D., I noticed your profile and would like to offer you my project. We can discuss any details over chat.

Hi Nima D., I noticed your profile and would like to offer you my project. We can discuss any details over chat.

We need to improve an already existing pitch deck. Our project is to bring UFCGYM to France. The goal is to convince investors to put money on the table with the pitch deck. For the pitch deck, we need to go to the next level by improving the general design, and also making more clear what the investor will gain from this project. We would like an investor focused pitch deck with a compelling presentation regrouping facts and figures A timeline with milestones on market number and our financial analysis Ensure clarity and simplicity by using clear and simple charts to present financial data, avoiding information overload on a single slide. Utilize data visualizations like bar charts, line graphs, pie charts, and ...

Hi Nasima, about a year ago you delivered a ver simple logo for a company named Eduna. I'm restarting that project and I need a proposal template (a word document that i can use to deliver proposal) with a nice header and footer related to events planning , wedding planning , table decoration, etc.

I'm in need of a talented designer to create a label for my chemical and coatings product. The label will be used for product packaging. Key Requirements: - The design should be industrial in style, conveying a sense of reliability and professionalism. - It needs to be suitable for use with chemical and coatings products, so should reflect this in its visuals. Ideal Skills & Experience: - Experience in label design, particularly for industrial or chemical products. - A keen eye for detail and ability to create designs that are both aesthetically pleasing and practical. - Understanding of the importance of conveying the right message through design. This is a great opportunity for a designer looking to add an indust...

...I want the site to have certain features Key Features: - Course Information and Syllabus: I expect to have a section where I can upload all the necessary information regarding the courses I'm taking. - Student Login and Registration: There should be a secure login system for students to access the personalized information. - Grades, Student Education History, Fee Details: The website should allow me to keep track of my academic performance, educational history, and fee details. - Time Table: A feature that allows me to maintain my schedule and plan my time effectively. - Downloadable Documents: Users should be able to download important documents, such as course materials or assignment briefs. The primary purpose of this website is...

...developer who can create a personal college website for me. I want the site to be similar to my college's official website, but with some unique features. Key Features: - Course Information and Syllabus: I expect to have a section where I can upload all the necessary information regarding the courses I'm taking. - Student Login and Registration: There should be a secure login system for students to access the personalized information. - Grades, Student Education History, Fee Details: The website should allow me to keep track of my academic performance, educational history, and fee details. - Time Table: A feature that allows me to maintain my schedule and plan my time effectively. - Downloadable Documents: Users should be able ...

I'm looking for a...Social Media Marketing (SMM), to help generate more leads and sales for my business. Key requirements: - Develop and implement effective SEO strategies to drive traffic to our website. - Manage and optimize social media campaigns on Facebook and Instagram to engage with our audience and boost sales. - Monitor and analyze effectiveness of marketing content. -Lead generation and data collection to share with sales team The right person for this job should have a solid understanding of how each social media channel works and how to optimize content so that it is engaging on those channels. SEO expertise is a must. I'm excited to see how your skills can drive our business forward. Lo...

I'm in urgent need of a professional in Delhi or Noida who can assist with the customization of various home furnishing textile products. Key Deliverables: (Customized) - Curtains - Pillow covers - Table Runner - Fabric wall art - Throw blanket/ Throw curtains - Products (details to be provided) Your application should: - Showcase past work in home furnishing or textile customization - Demonstrate experience in this field - Include a detailed proposal on how you would approach this project - Most important should be from delhi or noida I'm under a tight deadline, so the quicker the turnaround, the better.

...Laravel developer to undertake crucial tasks within a large-scale project over a two-week timeline. The Laravel-specific requirements are as follows:- 1. Fix the Home Dashboard to display real data instead of dummy data in Laravel. 2. Implement form data transfer from the website to the CRM Enquiry Menu in Laravel. 3. Ensure that won enquiries are correctly displayed after conversion to contacts in Laravel. 4. Highlight the current menu item on the left in Laravel. 5. Correct CSV download functionality in Contacts, ensuring filters, headers, and special characters are handled properly in Laravel. 6. Enable clicking anywhere on the contact data table to open the view of that p...

I'm in need of a desktop software that can analyze a specific type of data within a PDF table. The software should: - Read and extract data from a PDF table - Compare this data against another table - Identify and save matching data in the form of an Excel file. The tables in question will contain numerical data only. Ideal Skills and Experience: - Proficiency in developing software for Windows - Experience with data extraction from PDFs - Strong capabilities in data comparison and analysis - Knowledge in Excel formatting - Understanding of numerical data handling.

...proficient Excel expert who can create an organized spreadsheet to track our monthly sales data. Key Requirements: - The spreadsheet should be organized by month. This means that the sales data for each month should be clearly separated. - The primary function required is to sum up the sales totals for each month. This will help us in tracking our sales performance over time. Ideal Skills/Experience: - Proficiency in Excel, with a good understanding of formulas and functions. - Prior experience in creating sales data spreadsheets would be a plus. - Attention to detail is crucial to ensure the data is accurately presented and calculated. Deliverables: - An error-free, well-organized spreadsheet that ...

Need to 2 single and separate webpages to display data from tables in MSSQL database

I'm looking to develop a corporate website with several pages, more than 10 in total. The website should have a professional and clean design, reflecting our company's ethos. We'd like to work with a developer who has experience in creating corporate websites and can bring new, innovative ideas to the table.

...marketer, I am looking for a Podcast Specialist to help me create an engaging podcast series focused on SaaS Marketing, Digital Marketing, and Business. Key Responsibilities: - Help conceptualize and structure podcast topics and content - Assist in scripting engaging episodes - Ensure professional audio editing and high-quality production - Make sure each episode is tailored for a combined audience of Small business owners, Marketers in SaaS industry, and Entrepreneurs in digital marketing Ideal Skills: - Deep understanding and experience in SaaS Marketing, Digital Marketing, and Business - Prior experience in podcast production, especially in the specified topics - Ability to create engaging content for multiple groups of liste...

I need assistance with performing formulas, calculations and descriptive analysis in Ms Excel. I am specifically focused on analyzing data using measures of central tendency - mean, median and mode. - **Tasks** - Insert and calculate formulas regarding the mean, median, and mode in the data. - Conduct descriptive analysis on the dataset. Ideal freelancers for this project should have strong analytical skills and extensive experience with Excel's formula and calculation functionalities as well as knowledge of statistical analysis. An understanding of central tendency measures (mean, median, mode) is crucial.

Seeking a proficient individual who is knowledgeable in Excel for data entry and calculation formula tasks. The project involves: - Manual data entry - Creating complex formulas - Maintaining a spreadsheet with 10-50 columns and rows Ideal skills and qualifications: - A high degree of precision and accuracy in data entry - Strong knowledge of, and experience with, Excel and its formulas. I would like my 24 month forecast converted to an excel spreadsheet so i can adjust inputs and project further.

We are seeking a skilled developer to create an automated process for extracting data from PDF files and converting it into JSON format. The PDFs, such as the example provided here, vary in format and column structure based on their categories. The solution should not require downloading the PDFs manually. Sample URLs Requirements: - Develop a tool or API endpoint for extracting data from PDF files located at given extracted PDF table data into JSON format. - Handle various PDF formats with different column

I'm in search of a PHP Developer with a proven track record of developing comprehensive ERP Solutions for the construction industry. We will looking for a ready application something more or less similar to our requirement. A existing pre developed application. Wherein customization can be done. Key Modules Required: - Quotation - Purchase - Project Management - Materials Management - Stock/Inventory - Billing - Accounts - Reports - Project Management - Cost Estimation - Procurement Specific Features for Project Management: - Task Management: The system should allow for easy task assignment and monitoring. - Resource Allocation: It should have a robust system for allocating and tracking resources. Specific Requirements for Cost Estimation: - Integrated Cost Database:...

I need to create an Excel dashboard to visualize our inventory data. It's not a complex task and should take around 20 to 30 minutes. What I need: - Display of inventory data on the dashboard using charts and tables - The table should contain: Ideal skills for this project: - Proficiency in Excel and creating visually appealing dashboards - Understanding of inventory data and its representation in tables

...scriptwriter to design an Airtable script that can effectively combine data from a single table that consists of parent-child relationships. The main task for this script will be to focus on combining data from the parent-child and combining it onto 1 row each. Specifically, the required updates will involve: - Combining Parent and all children data onto same row - Taking DOB field and splitting into a Month field and a Year field - The end result should be a base where I can upload a new CSV and it outputs the desired result into a new table that I can download a csv from The ideal candidate for this role is someone well-versed with airtable scripting and data management, specifically having a strong knowledge of number fields...

...designer to help me with my Squarespace website. The key areas of focus for this project are: - Redesigning the homepage layout: I want a fresh and modern look that improves the overall user experience and enhances visual appeal. - Adding new pages for products/services: I need to extend my site with new pages that feature my products/services. This requires a good understanding of Squarespace's page layout and structure. - Updating the website content: I need assistance in updating the current content on my site to make it more engaging and relevant. In addition to the above, I'm also looking for assistance with SEO optimization. This includes: - Enhancing the website's responsiveness and ensuring it's mobile-friendly. - ...

I am primarily seeking to increase my revenue through a rooted business transformation project that focuses on restructuring customer engagement. Here, the perfect freelancer for this assignment would bring to the table: - Extensive experience in customer engagement and retention strategies. - Proven proficiency in business transformation projects. - A deep understanding of how to optimize customer-facing operations. - Profound knowledge of the latest technologies to boost customer interaction. Your ideas and advice will be invaluable as we navigate this transition aiming to enhance our business model and widen our revenue stream.

...experienced professional to create a user form macro in MS Project Professional. The macro should have the following capabilities: The key functionality that the macro should have is the ability to filter the project based on selected criteria in the user form, including: - Project Phase: This is a custom field, or Text1 - (And) Work Phase: This is a custom field, or Text6 - (And) Custom Look-Ahead Formula's for 15, 30, & 60 day look-aheads. See attachment but the end user will select one of the three look-ahead options. For the Look-Ahead formula, it should be defined as: IIf(([Start]<([Status Date]+15, 30, or 60) And ([% Work Complete]<100))). It's extremely critical that the candidate has strong proficiency and understanding of MS ...

...development company, and I'm looking for a dedicated Excel expert to help me streamline my expense tracking process. Key Requirements: - I already have a template set up and in one of the tabs I have a CSV statement import. Your primary task will be to create a formula that can automatically pull data from a statement import into the relevant property tab. - The data should be ordered by date to ensure clarity and easy reference. - I have created a macro to change the debit figures to negative amounts in the spreadsheet. - I am open to changes/ideas on if it requires a different setup. Ideal Skills and Experience: - Advanced Excel skills are a must. You need to be comfortable working with complex ...