What is a pivot table excel jobs

I'm looking for someone with strong data gathering skills who can create a comprehensive Excel spreadsheet. The spreadsheet must contain a list of all Australian suburbs along with their corresponding Local Government Areas (LGA). The essential points to be kept in mind are: • The list should be sorted by council areas for easy navigation. • Only the name of the suburbs and their corresponding council areas are required. No additional components such as population or region data are necessary. This project might require advanced web searching capabilities and attention to detail to ensure accuracy of the compiled list. Experience in data extraction is highly desirable.

I'm looking for an interior designer to completely transform my living room into a minimalist haven. My living room is less than 40 square mt and I am interested in a simple yet sophisticated aesthetic. Key tasks include: * Analyzing the current state of the room and suggesting improvements * Developing a new layout plan * Providing a minimalist design concept that maximizes available space Ideal Skills and Experience: * Proven experience in minimalist interior design * Portfolio of designs for comparable spaces * A deep understanding of space planning and functionality * Creativity and innovative approach in using small spaces effectively Your bid should include design plan, sourcing furnishings and accessories, and implementation over...

I need someone who can create a database in MS Excel for Invoices Log (tracking for already processed invoices) with the following features. 1- A list of all invoices (Master List). 2- A list of all Contracts. 3- A list of all Purchase Orders. 4- A list of Approvers who is approving the invoices. 5- A list of Accounts. 5- All of these list should be linked with each other. There should be a Dashboard (Main Page) with link to the pages (Add Invoice, Search Invoice, Search Approver, Search Contract, Search PO, Search Account and Reports pages) on the top, and below the page list there should be the statistical data of the database. For Add New Invoice page, I should be able to add an invoice details, and if it's related t...

I'm in need of someone skilled in Microsoft Excel for a couple of tasks. - **Formatting:** Firstly, I require assistance in formatting the spreadsheet. This will include ensuring that the data is clear and easy to read. I would like the spreadsheet to look professional. - **Formula checking:** While the formulas used are not too complex, I still want them to be checked thoroughly for accuracy and consistency. This will mainly involve basic arithmetic operations. I'd appreciate it if you have a background in financial analysis. It would be helpful to have a good eye for detail as well.

The target is to write a Java, console program (public static void main) that will generate a docx Word file. Program needs to use docx4j library () Programm needs to generate many parts: Heading1, Heading2, Heading3, every with some content (lorem ipsum) Make a table of contents (showing on which page is a given Heading1, Heading2, Heading3 - not hard coded, but detected) Heading1 --Heading2 ----Heading3 ----Heading3 --Heading2 ----Heading3 ----Heading3 Heading1 --Heading2 ----Heading3 ----Heading3 --Heading2 ----Heading3 ----Heading3 In the text put links to a concrete Headings, eg. "read in Heading2 - abc (page 4)" - it should be link to this section and "(page 4)" should Make a footer sh...

I'm seeking a skilled UI designer for an iPad application focused on managing a restaurant's operations. The UI should be user-friendly and ideally suited for a restaurant environment. Key Features: - Order Management: I need the UI to include order tracking and menu customization features. I also require the ability to visualize the restaurant's floor layout to manage the orders efficiently. - Table Management: The UI must allow for table reservations, status updates, and merging. It should help in optimizing table assignments and order efficiency. - Inventory Management: The UI should support managing the restaurant's inventory to streamline operations and track costs. - Staff Management: I need a simple way to manage ...

...seeking a talented architect/interior designer to conceptualize a small capacity (up to 50 people) e-sport arena. This space should be multi-purpose, with areas for table top and card games, "video game tables", as well as adaptable space for B2B events or co-working. Key project elements: - The e-sport gaming area is the central focus. - A comfortable and homey interior design style is preferred. - Despite the diverse usage, the space should flow naturally and cohesively. - Incorporate dining areas where players can eat while engaging in video games. - The design should be flexible to also accommodate B2B events or transform into a co-working environment when needed. Ideal candidates should have: - Prior experience in ar...

...experienced, talented individual to create an accurately measured floor plan based on a sketch, and perhaps 3d renderings if we align on the 2d. This project will require the inclusion of the following primary facilities: - 4-6 Treatment rooms - Sauna or steam area and day spa space - single-stall showers, changing areas, bathrooms - 1 yoga studio - Mixed use lounge with communal table, lounge area, and hidden AV - front desk - Spa Retail area - lockers - back office area for laundry, storage, and staff break If you have innovative and creative ideas beyond my sketch to further enhance the floor layout to attract more customers, they are more than welcome! You will be working closely with me to design a floor plan that truly captures the essence and objectives of...

I need some one to clean a file that has names and addresses The field with the name has business names and first and last name combined. I need them separate. Also some time there are two name or a last name and then the first name of a husband and the first name of the wife I need all that in separate fields See attached sample

Need a dev to advise on building the checkout buttons for my website, I'd prefer to use the pre-built butons for check out however I'm still looking to see how to include some custom information such as user details (for digital goods). Then on the receiving end either use IPN or similar to process that. You will need to talk me through what are the options, further work could be optional. Start your bid with "I do paypal"

I need two outdoor cooking tables based on the document specs provided. I am looking for scaled, cad drawings that can be given to the custom carpenters

I'm looking for an experienced freelancer to develop new widgets for our current ...widgets: Charts, Tables - Charts: Line charts, Bar charts, Pie charts - Tables: Data tables, Summary tables, Pivot tables These widgets will a show the following: - Top ten Selling Items (# units sold and $) - Upsells (# units sold and % of overall sales) - Modifiers (# units sold and % of overall sales) - Daily specials ($ sold and % of overall sales) The ideal candidate should have: - Proven experience in developing widgets for Sisense - Proficiency in creating various types of charts - Strong understanding of data table structures - Ability to design and implement effective summary and pivot tables I'm looking for a committed freelancer who can deliver ...

I require an experienced and proficient VBA developer to create a code that automates data entry tasks in Microsoft Excel. The main objective is to significantly increase productivity and ensure accuracy by automating repetitive data entry procedures. Ideal skills would include: - Vast knowledge of VBA and Excel - Prior experience in developing automation scripts - Exceptional attention to detail - Ability to work within strict deadlines

I need assistance with formatting a Word document. It is a 47 page word document that needs to be formatted in terms of look and feel. There are 4 table of contents in the document to be formatted and the page numbers of the document have to be fixed. There is a 13 page pdf that needs to be converted to Word and added to the document. The job has to be completed in the next 12 hours.

I'm in need of a seasoned Excel expert who's proficient at conducting optimization analysis to solve a real-world problem. Key Requirements: - Profound understanding of optimization analysis - Ability to work efficiently and quickly - Experience with diverse Excel functions Please note that the specific goal of the optimization analysis requires maximizing profits, minimizing costs, or optimizing resource allocation. Your expertise in this area will be crucial to our success.

I need assistance with formatting a Word document. It is a 47 page word document that needs to be formatted in terms of look and feel. There are 4 table of contents in the document to be formatted and the page numbers of the document have to be fixed. There is a 13 page pdf that needs to be converted to Word and added to the document.

...tables from a PDF file into an Excel spreadsheet. The job involves transferring text and numbers from a multi-page PDF table to an Excel document. I have attached the PDF. The analysis should start from page 7. Here's what the project entails: - Converting data from a PDF table that includes both text and numbers - Handling tables that span across multiple pages in the PDF - Transferring the data to Excel without any need for specific formatting or layout changes - Provide the developed script used to obtain the records from the tables. As a freelancer, you should have: - Proficiency in PDF to Excel data conversion - Ability to work with complex table structures - Attention to detail to ensure acc...

**Contest: Excel Specialist Wanted for Comprehensive Property Portfolio Management Tool!** Are you an Excel virtuoso with a passion for crafting intricate and comprehensive spreadsheets? We're embarking on a quest to develop the of a cutting-edge Property Portfolio & Financial position Management Tool for our discerning clients. If you possess the expertise to meticulously organize data, create advanced formulas, and design visually captivating presentations, this contest is tailored for you! Join us in revolutionizing property portfolio management with a document that sets the standard for clarity, accuracy, and usability. I would like to be able to edit if required in the future therefore 2 copies will be required. 1 being passwo...

I'm looking for a talented, imaginative logo designer to create a Christmas fair logo, which I'll provide. I require someone who understands the festive spirit and can bring fresh, creative ideas to the table. Key requirements include: - Incorporating the general typography style, color scheme, and layout composition of the provided logo, while ensuring it's not a direct replica. - Bringing a modern, eye-catching touch to the design that's aligned with the Christmas theme. - Your creativity and skills in adapting and enhancing existing designs are crucial to this project. Content: Rotary Masterton Christmas Fair Ideal Skills: - Graphic Design - Logo Design - Creative Thinking - Branding - Attention to Detail - Familiarity with C...

I'm in need of a PowerBi expert to resolve a critical error for me. The error message reads: "Failed to save modifications to the server. The error returned: 'Relationship '59f250b2-ca16-47f4-8a50-ba4d8636a1ed' points to deleted column 'Setter 2' in table 'Bridge of Setter'." - Urgency: The task should be completed within 24 hours. - Documentation: I don't need any documentation on how the issue is resolved, just the solution itself. - Dataset Access: Unfortunately, I can't provide access to the original dataset. The expert will need to resolve the issue without it. Skills and experience required: - Proficient in PowerBI with experience in resolving server-related errors. - Ability to work under tight...

If possible, I would like to have the wrinkles on the white cloth that hangs in front of the table to be removed so that it looks smooth.

I need a software expert to develop a program that scrapes text content off of multiple websites and then cross-references this data against another site. Key Requirements: - The software should effectively pull out text content from all provided sites. - The text content should be in a plain text format, ready for easy analysis and interpretation, preferably in an excel spreadsheet or comma delimited list. - The cross-referencing component is crucial, as the software will need to compare the data scraped with that of another website. Qualifications: - Background in Data Scraping and Software Development. - Previous experience with cross-referencing data. - Proficiency in handling different data formats. In essence, I'm looking for someone who c...

I am looking for someone skilled in Microsoft Excel and Power Automate. This task involves creating an automation system that sends emails to our internal team members based on given triggers. The automation should trigger when: - An event's start date is approaching - An event's deadline is nearing The email content should serve as a reminder of the approaching start dates. It's pivotal that the chosen freelancer can work with accurate detail to ensure that no deadlines are missed. A deep understanding of Excel, or similar spreadsheet software, automation, and email systems is required for this task. Experience working with scheduling and deadline tracking will be an advantage.

...require an expert in Excel to help me with a statistical analysis of my sales data. The key tasks for this project are: - Conducting statistical analysis: I need you to run a detailed statistical analysis on my sales data. This will involve using advanced Excel functions to analyze variables such as sales trends, forecasts, and correlations. The ideal candidate for this project should have: - Proficiency in Excel: The chosen freelancer should have a deep understanding of Excel and be skilled in using advanced functions. - Statistical Analysis Expertise: Experience in statistical analysis is crucial, as you will be required to interpret the data and provide insights. - Attention to Detail: The work involves handling a lar...

As a reputable company, we are currently in need of a seasoned and results-oriented freelance Project Manager. In this role, you'll be the cornerstone of our client engagement process, responsible for leveraging your extensive experience in marketing projects to manage and assist in sales improvement. Key Responsibilities: - Attend Zoom calls with clients to meticulously understand their needs and requirements. - Act as a pivot in the client engagement process, effectively promoting our services to close deals. - Utilize your expert knowledge and experience in marketing projects to drive sales. Key Requirements: - Previous experience managing marketing projects is essential. - Exceptional communication skills, specifically through Zoom calling. - P...

...improve the existing features of an Excel macro, focusing on enhancing the user interface and experience. Key points: - The primary goal is to make the macro more user-friendly, interactive, and provide better feedback to users. Ideal skills: - Advanced Excel Skills - VBA and Macro Programming - Strong UI/UX design capabilities - User Feedback Integration Please bid if you have experience in enhancing Excel macros in a user-friendly manner and can improve the UI/UX by adding interactivity and feedback. I have a macro working fine. We need 3 improvements: 1- Label photos as A, B and C / 1, 2 and 3 then macro relabel photos per photo matrix 2- Instead to use “SN” in the folder name I want to use “setup” 3- 3- G...

I'm looking for a skilled freelancer who can help automate various tasks in Excel. This includes, but is not limited to, data entry, formulas, and calculations. Key responsibilities: - Automating data entry processes within Excel - Implementing advanced formulas and calculations to streamline calculations - Generating reports and carrying out data analysis using Excel - Ensuring the accuracy and integrity of automated processes Ideal skills and experience: - Proven experience in automating tasks in Excel - Advanced knowledge of Excel functions and formulas - Ability to understand complex data sets and create accurate reports In your application, I'd like to see: - Examples of similar projects you've worked on - Details of y...

to do table of authorities as discussed

...can transform my living room into a very modernized, stylish space. Key Requirements: please see the living room in the first floor with 2 ACs and one desert coller with two windows. the large window is open to the roof of a setting room downstair. we need 1- modernized the first floor seating area where the tv is , you can change the lights and doors color. 2- for the setting room in ground floor, i need to remove the roof of the setting room down stair to be a sky light, seiling need to be higher ..pay attention to first floor . 3- need to design the skylight as it is seen from the seating room in first floor . 4- need every thing with deminsions 5- need more than one option 6- announced winner must do a wolk through - Your prima...

I am seeking an exp... particularly in the tasks of document conversion, data processing, and data verification. This role necessitates the management of confidential and sensitive information, hence, a demonstrated respect and understanding for data privacy is paramount. Key Responsibilities: • Document conversion • Data processing • Data verification Required Skills and Experience: • Proficient with MS Excel • Demonstrated experience in similar roles handling sensitive data • Strong attention to detail • Respect for privacy and confidentiality Note: Familiarity and experience with utilizing formulas and pivot tables within Excel are highly desirable, given the nature of tasks to be performed. Integrity, diligence,...

I need assistance with copying & pasting data from spreadsheets. The dataset is less than 1,000 entries. Ideal skills and experience for this job: - Experience with data entry, especially from spreadsheets - Attention to detail - Proficiency in Excel - Ability to meet deadlines It's a straightforward task. The goal is to ensure the data is accurately copied and pasted.

I need an experienced Excel programmer to automate repetitive tasks and create custom VBA macros for my project. This assignment requires basic level tasks, so extensive experience in complex macros isn't necessary. Here is what I expect: - Automation of several repetitive tasks to streamline workflow and increase productivity - Creation of custom VBA macros from scratch Ideal Candidate: - Extensive experience with Excel automation and VBA macros - Ability to comprehend and successfully complete basic level assignments - High attention to detail and accuracy Please include your Excel automation and VBA macros experiences in your application. I look forward to working with you on this project.

I'm looking to develop a custom indicator on the TradingView platform. This indicator needs to be a combination of a Zigzag indicator and a Pivot indicator, which can be tailored based on my specific requirements and trading rules. Key Features: - Custom Zigzag Indicator: The indicator should be able to identify the various price swings in the forex market in a zigzag pattern. - Pivot Indicator: It should also be able to calculate and mark pivot points based on the price action. - Customizable: The indicator should be flexible and adjustable to my specific trading strategies and preferences. - User-Friendly: It should be easy to use and understand for a trader, with clear visual markers and alerts. Skills and Experience:...

I'm starting a new business management company and I need a top-notch logo designer to help me establish a strong brand identity. Key Requirements: - I envision a modern/minimalist style for the logo, so experience in contemporary design is a must. - Your application should clearly showcase your relevant experience in logo design, particularly for business or corporate clients. Please include a portfolio of your past work. - The ideal freelancer for this job would be able to come up with at least 2-3 unique, original concepts for the logo. I'm excited to see what you can bring to the table!

I need some one to clean a file that has names and addresses The field with the name has business names and first and last name combined. I need them separate. Also some time there are two name or a last name and then the first name of a husband and the first name of the wife I need all that in separate fields See attached sample

Please Sign Up or Login to see details.

Hello work will be done as 1 - FTP Testing status in popup 2- Show failed testing domain in the new table on same page 3- Change the PIN CODE from backend 4- Able to upload files on the root directory 'Public_html'

...seeking an experienced Excel wizard capable of making my inventory report more dynamic and adaptable. Here's what I need: - Total Calculations: The report doesn't currently update the total inventory count and monetary value when I adjust the count of individual items. I require this to be automated so the totals are accurately recalculated whenever an inventory count changes. - Regular Updates: Going forward, I will be regularly updating inventory counts on a weekly basis. I would appreciate if the system is simplistic and user-friendly for regular updates. Ideal Freelancer Skills: - Advanced knowledge of Excel functionalities - Experience on inventory management systems - Meticulous attention to detail - Ability to create user-friendly ...

I'm looking for a skilled engineer who can design a self-supported steel chimney for a metal manufacturing plant. This chimney will be integral to industrial emissions control. Tasks Include: - Tailoring the design to accommodate the specific needs of a metal-manufacturing environment. - Incorporating robust safety features and compliances for high-temperature metal emissions. Ideal skills: - Structural Engineering - Industrial Design - Knowledge of industrial emissions standards - Experience with metal manufacturing processes.

I'm in need of a skilled developer who can create an AI portal that is capable of efficiently extracting table data from PDF documents. The extracted data should be organized and saved into a customized Excel template. Additionally, the system should be designed to assign different user IDs with varying levels of access control. Key Requirements: - Develop an AI portal with the capability to extract table data from PDFs. - Organize and save the extracted data in Excel using customized templates based on the source PDF. - Implement a user management system that assigns different access controls to various user IDs. Ideal Skills and Experience: - Proficient in AI development and data extraction techniques. - Expertise in Excel...

...the question into a Google slides / Powerpoint document - 1 question (or sub-question if it requires a different skill per page - 1 document for each paper - name the skill(s) that are required to answer each question - as the title for each page - create a new line in a Google Sheets / Excel document with the following information: - skill required (copied from title of Google Slides document) - page number of Google Slides document that the question appears on Key Requirements: - The questions are from primary school level math exams, so a good understanding of these topics is crucial. - You will need to effectively categorize each question based on the specific skills that need to be applied to solve them. - Proficiency in...

I'm looking for a Python developer to assist me in creating a web scraper that can extract specific text content from a website on a weekly basis. The scraped data should be efficiently saved to a CSV or Excel file for easy review. Capable of being plugged to a distribution app. Key Requirements: - Develop a Python-based web scraper that targets a website to extract text data - The scraper should be designed to run on a weekly schedule - Ensure that the code is concise and easy to understand for potential future modifications - Store the scraped data in a CSV or Excel file format Skills and Experience: - Proficiency in Python programming - Experience with web scraping libraries such as Beauti...

I'm looking for a proficient Excel professional to develop a multi-country income tax calculator. This tool will primarily serve individual taxpayers, and potentially other user groups. Key Requirements: The calculator should support income tax calculations for multiple countries. This requires a deep understanding of tax laws and calculations in each country. - The tool should be user-friendly and intuitive, catering to users with different levels of tax knowledge. - It should be well-structured, with separate sections for each country to avoid any confusion for the end-users. Ideal Skills and Experience: - Advanced Excel proficiency, with experience in creating complex calculators or financial models in Excel. - In-depth knowledge of...

I need an expert to develop a macro tailored to automating report production tasks in Microsoft Excel. The main purpose of this project is to streamline the process of regular report production and increase overall efficiency. Ideal skills and experience include: - Proficient in Microsoft Excel - Experience in macro development to automate tasks - Knowledge in automating report production Your role will involve designing and implementing a suitable macro for regular report production in Excel. I'm looking for someone who can provide a timely and efficient solution.

As a freelance videographer, I'm looking for an individual based in Thailand who can assist me with capturing some events. - Required Equipment: I'm looking for a camera person who has their personal DSLR camera, tripod, and lighting equipment. The quality of these pieces of equipment is important to me as I'm looking for high-quality footage. - Primary Task: Your primary task will be videography. This includes recording all relevant moments during the events I'll be attending. You should be adept at capturing the essence of an event and be able to anticipate and react quickly to different scenarios. - Focus of Videography: The focus of the videography will be on events. Your understanding of how to capture the energy and mood of an event through ...

I'm seeking a skilled virtual assistant with proven communication abilities, to work specifically in US timezone. Your main duties will include: - Bidding on projects: You will need to represent our brand professionally and persuasively when bidding on projects. - Communicating with leads: You'll be responsible for using various messaging platforms to engage with potential clients and leads. Ideal candidates should excel in written communication and have a knack for sales. Proficiency in project management tools is a plus. Our preferred mode of communication with leads is through messaging platforms.

Looking for a Python & Active Directory Expert to create a script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, group policy etc. and export to a MS Excel File. More information attached.

...looking for a creative logo designer who can help me create a logo for my company, Luminous Properties. As a land and property developer, it's crucial that the final design conveys trust and reliability. we care about environment and natural beauty, so we also like to have something that shows this on our logo. We want to have an icon that represent us and our name on our logo. Please submit your unique design, we will reject any auto generated logo or copy of other's concept. The ideal candidate should have: - A solid understanding of logo design, particularly in the context of property development. - Proven experience in creating logos that communicate trust and reliability. - A keen eye for aesthetics and detail. - The ability to bring i...

We are the production team of the TIKTOK Operation course, and I am looking for several TIKTOK creators who can face the camera to imitate and shoot simple oral videos. You don't need to have a lot of social media experience, as long as you're willing to try. Your main responsibilities include: - Execute video shoot according to the script we provided. - You can also write your own script based on the content we provide or improve. To increase brand awareness, your content should be engaging and cause widespread sharing and liking on the platform. The ideal candidate should have: - Look comfortable in front of the camera. - Fluent in English or Spanish - We cater to the North American market, which would be great if you are American or Mexican Ability to work independentl...

We are looking for a talented UX/UI designer to create a simple mobile app. The main function of the app is to receive notifications, similar to emails or SMS. A total of 12 layouts need to be designed. The logo and colors are already finalized, and there is an existing old design in Figma. Requirements: Experience: Proven experience in UX/UI design for mobile apps. Design: Simple, intuitive, and user-friendly layouts based on the existing Figma design. Compatibility: Designs should be suitable for both iOS and Android. Components: The layouts must include all necessary components for notifications, such as: Sender logo Sender verification status Timestamp formatting Title and short description of the notification Notification category Required Layouts:...