What is pivot table in ms excel jobs
I have an Excel sheet full of text data that I need typed up. The data is currently in a PDF file, so you'll have to extract it from there. Once the data is in the Excel sheet, it needs to be organized into tables. Key Requirements: - Data entry of text from a PDF into Excel - Organizing text data into tables in Excel Ideal Skills: - Proficiency in Excel - Fast and accurate typing - Attention to detail - Experience with data formatting in Excel Looking for someone who can complete this task in a timely and error-free manner.
...we will provide a theme for each case. This project is for the first case then we will look to do the remaining 29. The budget is $10 per case The first case theme is for a creator called Riiski you can see his theme is green and also with a crocodile which we would like to use. so we want the case to be themed for Riiski and also a title given to the case called the Riiski Creator Case Riiski twitter : Ill attach the croc and the twitter header so you get an idea of theme. Remember we still want to see the CASE elements so it still looks like a case just apply the theme to it so you kind of SKIN the theme onto the case. I have attached our logo as well Case Gone Wild in the green theme. Budget is $10 for the first case with a $5 B...
There is a sample site, it will be cloned and the web design will be designed. the site will be cloned
I'm seeking an Excel expert to help me with data analysis, formulas, and pivot tables. I work with Excel 2019. Key Responsibilities: - I want to see the mode of payment according to date wise in report sheet according to datewise Ideal skills and experience: - Proficient in Excel 2019. - Expertise in data analysis, formulas, and pivot tables. - Experience in creating automated reports or dashboards (desirable but not mandatory). - Excellent communication and problem-solving skills.
Productphotos and photos, what is possible between google search photo? Hello, when we click right on google chrome and click on the button photo via google lens search. than come the same photo on another pages, is anything possible to make, that not possible is too search the same photo ?
...Seller Data: The main purpose of this project is to gather information about the sellers on the Miravia platform (). This includes the shop_id shop_name Ivl1_cate_name product_number avg_price shipping_duration company_location phone_number email_address vat_number company_name shop_rating shipping_on_time % followers comments etc. I require 10,000 entries of data I require the data to be well-structured and organized into a CSV or Excel file for further analysis. Skills and Experience: - Proficiency in Web Scraping: The ideal candidate should have extensive experience in web scraping and data extraction. - Attention to Detail: Since the project involves gathering a wide range of data points, having a keen eye for detail is crucial to ensure accur...
I'm in search of a skilled presentation designer who can help me create a visually appealing and impactful presentation to showcase my career accomplishments. I already have all the essential data ready, and I'm looking to convey the following: - My professional journey, including accomplishments, lessons learned, and personal development. - Specific results from my work, both before and after certain milestones. Here are some key details you should consider: - The presentation should be concise and to the point, with the goal of promoting my career. - I aim to use this presentation for both personal promotion and interview purposes. The ideal freelancer for this job should be proficient in: - Crafting engaging presentations, with a good understanding of narrat...
In order to further our online presence, we’re on the hunt for an experienced SEO expert who can help us boost web traffic, improve our search engine rankings on Google, and ultimately generate more leads and sales. To give you an idea of where we're currently at, we've made minimal efforts in SEO, and we're eager to expand upon this. The desired candidate would: - Have a deep understanding of Google’s ranking algorithm - Be up-to-date on the latest SEO strategies and trends - Have proven experience in driving traffic, improving rankings, and generating leads/sales - Be based in or have expert knowledge of the Indonesian market. We're excited to see what you can bring to the table and help our business grow...
I am looking for an expert to assist in creating a dynamic Power Bi dashboard. This job should revolve around integrating data from Excel spreadsheets and designing a variety of data visualizations. Key Responsibilities: * Guide me in creating the dashboard on my company account. * Connect the Power Bi dashboard to Excel spreadsheets as the primary data source * Develop compelling data visualizations using pie charts, line graphs, and bar charts * Configure the dashboard to refresh data on a weekly basis Ideal Candidate: * Strong experience with Power Bi and data analysis * Proficient in handling Excel data * Expertise in creating different types of charts * Ability to work with time-based data refreshing schedules Scope of Work: The...
...mission planning. The initial phase of this project requires a meticulous approach to data preparation, which is critical for the success of our subsequent modeling efforts. The challenge lies in acquiring as much relevant data as possible for accurate predictions. Project Scope: 1. Preparation Stage: The freelancer will be responsible for identifying and researching all available sources of space debris data, both free and paid. This includes a comprehensive evaluation of data providers to ensure the data's relevance and quality. The output at this stage will be an Excel table summarizing the research, which will include provider names, links to data or registration, pricing (if it is a paid source), additional requirements from the provider, a...
STRICLY NO A.I (there is always spelling mistakes) I'm in need of a professional logo designer for my company, Precision Pipe Repair. The logo will be an abbreviated version, featuring the initials 'PPR' along with a combination of text and symbol. Logo : PPR Company Motto : Second To None Key Requirements: - Initials (PPR) should be the central focus of the logo - A combination of text and symbol should be included - The design should exude an aura of prestige and look perfect on a trucker's hat, polo shirt, etc. - The theme colours of the logo are Green and Black, in line with our existing logo Font Style: - The font should be bold and modern, but also reflect strength, futurism, technology, and professionalism. A robotic style is des...
I need an experienced graphic designer who can help me enhance the design of basic ID cards for my organization's 44 employees. Key Requirements: - I will provide an Excel file with detailed employee information. This should be included in the design. - Each ID card should include the employee's Name, Employee ID Number, Date of Birth, Emergency Contact Number, and the Company Address. - The design should be professional and visually appealing. I'm looking for someone who can take on this task urgently and provide high-quality work within a short timeframe. Your past experience in designing functional and aesthetically pleasing ID cards will be a huge advantage.
I'm looking for a talented web designer to build a fitness website focusing on a robust online booking system. The priority functionality should be to enable booking for nutritional consultati...designer to build a fitness website focusing on a robust online booking system. The priority functionality should be to enable booking for nutritional consultations, meal plans, and workout programs. Ideal Skills: - Proficiency in web design - Experience with online booking systems - Background in designing fitness or nutrition websites Design Preferences: Given that I have no specific design preferences, I would love it if you could bring your unique ideas and creative instincts to the table. Your portfolio, showcasing your previous works, will play a significant ro...
I need a detail-oriented professional to help with my bookkeeping and prepare financial statements using Excel. Key Responsibilities: - Regularly update my Excel spreadsheets with day-to-day transactions - Prepare monthly financial statements for my business Ideal Skills & Experience: - Strong Excel skills, including advanced functions and formulas - Experience in bookkeeping and financial statement preparation - Attention to detail and a good understanding of accounting principles Please note: - The role is likely to require around 10 hours of work per month - I may consider transitioning to a more robust accounting software in the future, so experience with QuickBooks or Xero would be a plus.
...skilled freelancer well-versed in comprehensive social media management, specifically on Facebook and Instagram. Your tasks will include: - Creating compelling content which aligns with my brand's voice - Managing targeted ad campaigns - Analyzing campaign data for optimization - Crafting engaging video content - Boosting relevant ads - Providing weekly written reports - Establishing and tracking KPIs and ROI The main goal of this campaign is to enhance brand awareness and effectively generate leads. The intended target audience is those between the ages of 28 and 55. Ideal candidates should have a wealth of experience in social media content creation, strategic ad campaign management, data analysis, video production, and marketing report writing. ...
I need some help with ...need some help with a data model I created in Power Pivot. I have 2 data sets: one is Sales and the other is Stock. I have added both data sets to my data model and am now trying to create a pivot which pulls data from both tables. My Sales table pulls the data perfectly but the Stock table does not. Some context... When I pulled the data into the data model I added a column which I called DataModelLink. This created a 1 (Sales) to many (Stock) relationship between the two tables. As an example, I tried to pull the data of one particular style which had one line in the Sales table but 2 lines in the Stock table. For this reason, my Pivot is only reading one of two of the ...
Seeking a skilled programmer adept in WordPress for custom coding work and form layout adjustments. Requires proficiency in backend management, specifically relating to data capture, viewing, and exporting in Excel format. A highlight of the project entails the customization of our existing WordPress theme and the integration of new, unspecified features. Lack of detailed request emphasizes the need for a freelancer capable of intuitive problem solving. Primary tasks include: - WordPress custom coding - PDF form adjustments - Data capture and export to Excel Ideal candidate should have knowledge and experience in custom coding, WordPress navigation, and form data handling. Exceptional problem-solving skills are highly appreciated. Undefined proje...
I'm looking for a freelancer with expertise in data entry to assist with tasks in Excel. Tasks: - You'll be working to enter data into an Excel sheet. Nature of Data: - The data to be entered will be a mixture of numerical and textual. Size of Project: - You'll be handling an Excel sheet containing between 100-500 rows and columns. Required Skills: - Proficient in Microsoft Excel - Fast typing skills with a strong attention to detail. - Strong numerical and textual data entry skills.
...obesity program being implemented in 5 health community clinics in Chula Vista, CA. Another 5 clinics in Poway,CA were chosen by the evaluator for comparison. The program has not yet started. They would like you to evaluate whether the intervention was implemented as intended. You will evaluate the behavioral changes stemming from the 12-week program for 30 people at each clinic at 3 follow-up time points. They shared with you that they intervened in steps, which involved preparation, action, and maintenance around exercise. They encouraged community members to walk/run 3 days a week and eventually make it a life-long habit. The main outcome was minutes of walking/running per week. Participants were asked: “How many minutes did you walk or ru...
...me synchronize employee attendance records from ZkTeco ZkTime 5.0 to MSSQL on my local server. This is a daily batch update process. Key Points: - You will need to understand how to fetch the attendance data and ensure its accuracy during the synchronization process. - The data should be structured in MSSQL in a way that allows for easy querying and reporting. - The process should be efficient and reliable, with error handling mechanisms in place. Skills needed: - Proficiency in ZkTeco ZkTime 5.0 - Strong experience in working with MSSQL databases - Excellent understanding of data synchronization processes - Ability to work with structured data and maintain normalized relations in a table-based format. Ideally, I'm looking...
I'm searching for a detail-oriented freelancer with extensive experience working with Excel. - This task involves typing text data into an Excel spreadsheet. - The data entered will be a mixture of both structured and random entries. Thus, a keen eye for detail and the ability to maintain organization amidst complexity is key. - As a crucial aspect of this project, I require error checking to ensure the highest quality of work. The ideal candidate should have experience and knowledge in Excel data validation. - For successful completion of this project, accuracy and attention to detail are paramount. Candidates with previous background in similar tasks will be highly regarded.
>>Read first<< this is not a project this is a full-time job you will join our team of 14 devs don't bid blindly you will be ignored if you don't reply and start your text with >>Full Time Job << your bid will be ignored bid your monthly salary ask This is a full-time job 40h/w if you are not free don't apply --------------------------------------------- We are seeking a seasoned freelancer with strong experience in both Wordpress and Laravel platforms. this is not per project we have a lot of projects already. Key Requirements: 1. Proven expertise in both Wordpress and Laravel 2. Ability to cater to a diverse range of web development requirements 3. Quick turnaround on tasks and feedback 4. Active particip...
I'm looking for a professional with deep knowledge and experience in Drupal 10 and Microsoft 365 Suite (MS Forms, PowerApps, Power Automate, SharePoint Online). • Drupal 10 Services: The Drupal 10 project should include features like custom theme development, content management system, user registration and login, search functionality, and issue troubleshooting. - Theme Development: The custom theme should adhere strictly to our corporate branding guidelines and styleguides. • Microsoft 365 Services: The professional should also have expertise in MS Forms, PowerApps, Power Automate, SharePoint Online, and related M365 knowledge and competencies to ensure smooth operation of the systems. In total, this project will involve approximate...
I am seeking a talented graphic designer to create a timeless class...captivate my target audience. The logo should strongly resonate with our audience in order to attract and retain their attention. It is necessary for any prospective freelance designers to deliver: - A highly detailed project proposal. - A clear understanding of traditional design principles. - A unique approach to maximizing target audience attraction. Ideal skills and qualification required for this job include: - Prior experience in designing classic logos. - Solid concepts on classic style branding. - Able to deliver on detailed project proposals. Your proposal should effectively illustrate how your design will engage my intended audience. I look forward to seeing the innovative concepts you...
...before you bid Kindly bid if you are experienced in image editing...set in pixel -900 X 700+save to .png format and webp format The sample of the requirement is attached for your reference.... your quote will be considered for 1000 products images. All the images is for grocery shop 1) All products should be cropped individually from the brochure or image or website link, The same shall be shared to you as per the required data. Any visible imperfections need to be painstakingly cleared off. Each picture will have to be improved in terms of lighting and contrast to make it more visually appealing. 2) the Size of the image should be 900 X 700 (Sample attached for your reference) 3) No Duplicates images should be created even if the brochure /excel...
I am searching for a proficient and attentive freelancer to assist with data entry tasks, specifically within Microsoft Excel. The role will require the successful candidate to be highly tech-savvy, with a strong background in Excel and an eye for detail. Key Responsibilities: - Handle diverse data entry tasks within Microsoft Excel - Ensure accuracy and consistency throughout the Excel spreadsheets - Offer quick turnaround times for tasks, while maintaining quality Ideal Skills: - Excellent knowledge and proficiency in Microsoft Excel - Previous experience in data entry roles - Strong attention to detail and accuracy - Ability to work quickly and efficiently under minimal supervision.
...video ad for the upcoming release of my game. The main aim of the video ad is to promote the new release to hardcore gamers. Key Requirements: - The video should be engaging and fun, capturing the essence and excitement of the game. - The style should be casual and accessible, appealing to the hardcore gaming community. - Utilize the gameplay clips I've taken to create a high-energy, captivating narrative. Ideal Skills and Experience: - Proven experience in creating video ads, particularly in the gaming industry. - Proficiency in video editing software and techniques. - Ability to understand and cater to the preferences of hardcore gamers. I'm looking for a freelancer who can bring fresh and creative ideas to the table, and deliver a hig...
I'm looking for a skilled professional with experience in creating visual merchandising and store layout designs. For this project, you will build on the data model you created in Project 1. You will be analyzing and creating visualizations of the data contained in your Access databases. All instructions for the project can be found in the PDF attached. Ideally, the successful freelancer should have: - A strong portfolio showcasing past retail design projects - Proficiency in retail space planning and product display - A deep understanding of customer flow optimization - Excellent communication skills to understand my vision and bring it to life - Ability to deliver the final visualizations in MS Access format Please provide examples...
...posting automated generic content previously** We’re looking to create a simple admin page that will list all female users, with pagination. The purpose of this page is to allow us to mark users that we suspect are spammers This will involve adding a new marked_as_spammer boolean flag to the users table The page should have a title of “Spam Review” The page should have two tabbed sections. One labelled “To Review” and another labelled “Spammers” The “To Review” section should list all female users where marked_as_spammer is false, ordered by user creation date descending, paginated 50 per page The list of users should be in a table with each row having a checkbox and username Clicking on a us...
...information for 25 agencies specializing in scripting video sales letters (VSLs). The task involves sourcing and validating agency names, email addresses, and website links, then recording these details into a spreadsheet. Responsibilities: -Conduct basic research to locate contact information for 25 specified agencies. -Validate that email addresses are current and active. -Accurately enter all data into a provided spreadsheet format. Requirements: -Experience in data collection and validation. -Proficiency in basic research and use of spreadsheets (e.g., Google Sheets or Microsoft Excel). -Ability to deliver accurate results within a set timeframe. -Project Length: Short-term, estimated completion within one week. ( MAX 80 AUD as a test round, if the w...
I need an Excel 365 PowerQuery or VBA script that can fetch daily market data and handle potential data source interruptions or changes. Google Shhets example =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). <Where C31 = Cell containing the Stock eg GB00B8XYYQ86, LU1033663649 or GB00B0CNH163 I need an identical function in MS365 Excel - either with PowerQuery OR VBA (preferable) Ideal skills: - Proficiency in Excel 365 and PowerQuery and VBA - Experience in web scraping and handling dynamic data sources. I am after a fixed quote for this project.
...description post. We are looking for a motivated and successful grant writer located within Canada! The grant writer will be responsible for locating, researching, and applying for potential funding opportunities in order to ensure successful grant approvals. The Grant Writer MUST be Canadian or have the expertise and experience with the Canadian government, ideally living in Canada and speaks and writes English Fluently. They MUST specialize in IT/digital marketing/ ecommerce/employee hiring grants They MUST have a proven strong track record of total grants submitted vs approvals in the last year within Canada. They are responsible for finding funding opportunities for our organization and writing polished proposals to earn Ontario & Federal gover...
Project Title: "Customer Order Management System" for an online retail business in MS Access. Objective: To develop a comprehensive database system that allows for efficient tracking and management of customer orders, inventory, and shipping. Key Features: 1. Customer Management - Store customer information including name, address, email, and phone number. - Track customer order history. - Customer feedback and preferences. 2. Inventory Management - Maintain a detailed list of products, including product ID, name, description, quantity in stock, and reorder levels. - Automated alerts for low stock levels. 3. Order Management - Enable creation of new orders with customer information, order details (product, quantity, price), and shipping met...
I'm on the lookout for a skilled Flutter developer to create a cross-platform (iOS and Android) restaurant application w...browse various menu categories and individual meal descriptions. - Online Ordering: Requisite infrastructure for placing orders online, including a secure payment process system. - Reservation System: Must include a highly-efficient table reservation system with instant confirmation. Ideal Skill set: - Extensive knowledge and experience with Flutter app development - Strong fluency in Dart programming language - Proficiency in implementing secure online payment gateways - Previous experience with restaurant or similar e-commerce applications is a plus In your bid, please furnish samples of your previous work and estimated t...
...create a custom CRM system in Excel for my business. Key requirements: - Sales Tracking: I need a system that allows me to monitor sales performance and forecast future sales. - Task Management: The CRM should have a task management feature to help me organize and prioritize my daily activities. Additional details: - The system will be used by a small team of 1-10 users, so it needs to be user-friendly and easy to navigate. - No integration with other software or platforms is needed at this time, so the focus will be solely on creating a robust, efficient Excel-based CRM. Ideal skills and experience for this job would include: - Proficiency in Excel, with a clear understanding of how to create complex formulas and visual representations of da...
...vision for a unique, customizable emoji of myself in a PNG editable format. The scope of the project includes: - Facial Expression Customization: You should be able to render advanced facial expressions, capturing nuanced emotions such as smirking and pensiveness among others. - Platform: Though the primary deployment platform isn't specified, a PNG format that can openly be edited and used across varied platforms is required. Ideal Skills: - Graphic Design: Expertise in designing refined, elegant, and vibrant PNG emojis. - Creativity: Ability to bring intuitive and refreshing ideas to the table. - Attention to detail: Capability to capture and design nuanced facial expressions accurately. A proven track-record on similar projects or in creatin...
Dough one Sources is looking candidates for Senior Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 200 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VB...
I'm in immediate need of a cloud-based stock management software with barcode generation, scanning, stock quantity tracking, and weight measurement functions. The system should enable me to: - Generate and scan barcodes for every product in my stock - Track the quantity of each item I have in stock - Measure the weight of my stock in grams I prefer a cloud-based solution that can be accessed and updated from any internet-connected device. The software should have an easy to use interface and be able to: - Enable manual entry of stock data - Support updating stock information by scanning barcodes - Automatically update stock data from my sales records The software could be developed in Excel, as long as it's accessible online. As a fre...
I need an Excel sheet created with the primary purpose of data analysis. This sheet should have the following features: - Data Sorting and Filtering: This is crucial for making the analysis process efficient and easy to navigate. I need the sheet to be able to handle large amounts of data and allow for quick and convenient sorting and filtering. - Data Visualization: In addition to the data analysis, I also require the sheet to include line graphs. I believe that visualizing the data will make it much easier to understand and interpret. The ideal freelancer for this project is someone with a strong background in Excel and experience in creating data analysis tools. It is important that the final product is user-friendly and ...
I'm in need of a freelancer to assist with data cleaning from PDF documents. The task involves organizing the data into an Excel spreadsheet. Ideal skills for this role include: - Proficiency in data cleaning techniques - Strong attention to detail - Proficient in Excel for organizing data - Previous experience in similar data entry tasks
More details: What specific functionalities do you want for your Shopify website? Custom theme development, Responsive design, Integration with third-party apps Do you have a design or wireframe for your website? Yes Do you have a preference for certain third-party apps to be integrated with your website? This question was skipped
I want to scrape daily leads from LinkedIn Jobs, Indeed Jobs, , etc. The task involves extracting data from these job sites and exporting it to Excel sheets. It would be preferable to have some kind of automation that reduces human dependency in obtaining leads every day. If someone has already set up a similar process before, I would prefer that. Preference will be given to those who have previously performed lead extraction tasks for recruitment websites.
I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create u...
The app is supposed to: - Search for specific product and add it in the cart with all needed information: delivery location, accessories, quantity. (Example: HP laptop with 14in size) - Compare the product price and service quality in the platforms and give results of the comparison. ( example: price in Amazon for the laptop is 1000$, delivery time is 3 days, the reviews are 4 star. Same for other platforms) - Direct the user to the selected platform to complete the purchase. (Example: to purchase the laptop from Amazon)
Delete blank page in Word document and tell me HOW to do it. 10 dollars only
I'm in need of a developer who can create a n8n script to login to a specific website and extract stock data for multiple companies. Key features of this project include: - Extraction of table data: You should have knowledge and experience working with web data extraction, specifically with table data. - Selection of stocks data: The script should have the ability to select and extract information from the stock table. - Capability for multiple companies: The tool should be versatile to handle data extraction for multiple companies, not limited to just one. Experience in the use of n8n for data extraction from websites, especially in the finance sector, will be a significant advantage for this project. One of the page is: And t...
I'm in need of an interior designer with experience in modern design aesthetics who can completely transform my living room and dining area. My preference is for a neutral color scheme with whites, grays and browns being the prominent tones. Key Elements include: - A medium sized and mpressive dining table, as I often entertain guests - A comfortable seating area that promotes relaxation, chats, and comfort. - Media Wall - Maximization of natural lighting - an aesthetic that capitalizes on light will be highly favored - Incorporation of features like a console, mirrors, wall art, center rugs, a media wall, and sofas with accent that combine style and utility. Special Attention should be paid to: - Nice, lush curtains that complement the modern aestheti...
When button clicked, the field of another table will changed to required. Only FTP no cpanel
Need advanced SQL including stored procedures, functions, based on existing SQL code. Need c# coding with dojo -Ideal Skills/experience * c# with dojo * MS SQL Server proficient. * Expert in advanced SQL features like stored procedures, functions. * complex SQL queries. * generating SQL reports from tables.
