Excel aptitude questions answers 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 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 to a contract or purchase order, I should be able to add ...

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.

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

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'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.

We are developing a project that we believe needs guidance and advice from an experienced scientist with specialized knowledge in the field of neuroinflammation. Your Expertise: - Microglial activation - Cytokine signaling Our Project: - In surgical patients, we are studying questions that relate to post-operative problems. In this group, you will give consultation on the serological evaluations that relate to neuroinflammation. Research Goal: - We aim to uncover a new understanding about the brain, hopefully leading to unexplored conversations within our field. Ideal candidates should have proven and published experience in neuroinflammation research, particularly involving microglial activation and cytokine signaling. (Note that the actual serological measurements will be ...

I need an expert to convert 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 accurate transfer of all informati...

**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 password and field protected and the othe...

I've included feedback from previous clients in this proposal regarding past projects as well as examples of previous work for you to review. On the final page, you'll find the pricing details for your project. If you have any questions after reviewing this proposal, feel free to touch base. Start

I'm facing an issue with my WooCommerce product category URLs not displaying the products. I'm looking for a WooCommerce expert who can resolve this problem. Key Tasks: - Investigate and identify the root cause of the issue - Fix the problem with the product category URLs not populating with products Id...expert who can resolve this problem. Key Tasks: - Investigate and identify the root cause of the issue - Fix the problem with the product category URLs not populating with products Ideal Candidate: - Experience in working with WooCommerce - Familiarity with resolving issues related to product categories - Strong problem-solving skills and attention to detail Feel free to ask any additional questions if needed. Add Woocomm23 to your bid or it will be con sidered spam...

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 can create a tool that not on...

very simple trivia game ask 10 questions with true/false answers capture user details at the beginning answer 10 questions log user details and response times in a leaderboard, save user details to a CSV file More details to the person who can show skill in this area to work on windows in portrait mode

I'm seeking a Flutter developer to create a quiz app that's compatible with both iOS and Android. Key Features: - Register with Google and Facebook - Category list - Leaderboard - Quiz screens - Quiz results - Profile and settings pages The app will be centered around multiple choice questions quizzes. Skills Required: - Proficiency in Flutter - Experience with integrating social media registration (specifically Facebook) - API integration capabilities - Familiarity with quiz app development - Ability to implement a clean, user-friendly UI for the mentioned pages Interested freelancers should be able to work efficiently and provide a polished final product. Please share your relevant past work for consideration.

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.

I 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 large amount of data, so attention to d...

I need to 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- Generate report even i...

...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 your experience with Excel a...

I am seeking an expert in data entry, particularly in the tasks of document conversion, data processing, and data verifi...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, and meticulousness a...

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 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

Integration of the clients CRM/ERP's so that the bot can answer to the client with human language. with the Intranet. 2 When the CUSTOMER MESSAGES DETECT If it is Customer or not and create a different communication based in the data in the system so answer the questions. After answering the questions, read our intranet If there is no response, I will pass it on to my colleague and pass it on to Human.

I am in search of a talented designer who can navigate through a few uncertainties. Unfortunately, I skipped some essential questions, leaving some ambiguity in specific aspects of the project. Your job: - Adaptable enough to handle logo, brochure, or flyer design since the service needed wasn't defined - Skilled at multiple graphic design styles because a specific theme wasn't selected - Able to derive the best decisions for the goals of the project as the purpose wasn't specified Skills & Experience: - Proficient in modern, vintage, and minimalistic design styles - Experience with brand identity, marketing, and informational designs is a plus - Problem-solving ability and creativity to fill in the information gaps This project presents an exciting challeng...

I'm 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 systems. The o...

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.

Job Title: Paralegal Job Summary: We are seeking a highly organized and detail-oriented Paralegal to join our team. The successful candidate will assist with responding to complaints, drafting legal documents, and providing administrative support to our legal department. Responsibilities: - Respond to complaints and draft legal documents such as answers, motions, and discovery responses - Organize and maintain legal files and documents - Conduct legal research and provide support to attorneys - Assist with document review and production - Provide administrative support to the legal department Requirements: - Associate's degree in Paralegal Studies or related field - 1-2 years of experience as a Paralegal - Strong knowledge of legal procedures and terminology - Excellent o...

...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 automation and customization. - Strong background in user management and access control systems. - Previous...

As an IT c...initial setup and account creation for new customers. This includes ensuring that the account is properly configured and the customer receives necessary information to get started. - Ongoing Support and Follow-up: Your role doesn't end at onboarding. We need you to maintain an open line of communication with clients, ensuring they're satisfied with our services. This includes answering their questions and providing necessary guidance. Ideal candidate: - Native Italian speaker with fluent English - Experience in customer service and account management - Strong communication and problem-solving skills - Familiarity with IT or tech industry is a plus Your role is crucial in maintaining positive client relationships and ensuring their needs are met in a timely a...

...segmenting primary school level maths questions based on the specific skills required to answer them correctly. The task will be to review 50 past papers - containing approx 50 questions each. For each question, I need someone to: - cut & paste an image of 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 quest...

...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 BeautifulSoup or Scrapy - Understanding of scheduling tasks in Python - Familiarity with working with databases, especially CSV or Excel files I'm open to discuss further enhancements and up...

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 income tax laws and ...

I'm looking for an enthusiastic and passionate individual or team from Indonesia who can lead TikTok live streams in English to promote my products. Key Responsibilities: - Conducting engaging, entertaining and informative live streams - Promoting and showcasing my products in a natural, authentic way - Engaging with the audience, answering their questions and encouraging participation Ideal Skills and Experience: - Fluent in English - Experience in hosting live streams, preferably on TikTok - Passion for and understanding of product promotion - Excellent communication and presentation skills - Ability to engage with an audience and encourage participation Please note that I am specifically looking for an entry-level individual or team with less than a year of experience, s...

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.

I'm starting a new company, RC Construction and Hydraulics LLC, a home renovation and hydraulic repair company. I need a logo that conveys strength, reliability, efficiency, simplicity, expertise and trustworthiness. I'll be using this logo across various platforms, including our website, social media, printed materials like business cards and brochures, and physical product...brochures, and physical products or packaging. The logo is to be designed using the color palette: Brown #8B4513, Steel Blue #4682B4, Slate Gray #708090, Dark Olive Green #556B2F, and Light Gray #556B2F. The typography should consist of the Header Font: Roboto Condensed and Body Font: Open Sans. But open to creative input regarding font type. FINAL FILES IN PNG & PSD. Feel free to ask any questio...

...developer to create an AI customer service chatbot for my business. You will be using OpenAi api. You will need to extract all email from our gmail account to train the model. The model should be able to create response to customer queries using the training data. This will be a chrome extensions. The primary functionality I need is for it to be able to effectively respond to frequently asked questions (FAQs). Key Project Details: - Platform: The chatbot should be developed specifically for my business - Functionality: The primary function of the chatbot should be to accurately answer customer's FAQs. - Language Support: I am not sure if multiple languages will be required at this stage, but the ability to add this in the future is a plus. Ideal Skills and Experienc...

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 profess...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 ...

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.

Hi, I am a political science student and I am considering conducting research regarding formal documents' verification services in different countries, focusing on notary and apostille signatures. I am looking for someone who recently went through the process of notarizing documents in the EU, who can answer some basic questions regarding the process. Thank you for contacting me!

I need help with data entry and formatting for a Google Sheet. The data is to be sourced from ONLY 1 Website. Key Tasks: - Copy-pasting text information and images or screenshots from Website 1 into a Google Sheet. - Formatting the data in the Google Sheet with columns and tables. Ideal Skills: - Proficiency in data entry, spe... Ideal Skills: - Proficiency in data entry, specifically with Google Sheets. - Strong attention to detail to ensure accuracy and completeness of the data. - Ability to organize data efficiently using columns and tables along with images etc for capturing the User flow in a tree form . Example the website has Question 1 and N number of responses. Based on the responses there are different questions based on the responses. Need to capture that in a tr...

I'm seeking a proficient editor with an aptitude for scientific and health (medicine) topics. This project will involve meticulously editing for grammar, spelling, and structure, as well as providing a succinct but informative introduction based on researched data. Key Responsibilities: - Edit and proofread text for a wide variety of scientific and health-related articles. - Conduct brief overview research on introduction sections using academic articles. Ideal Skills: - Proven experience in editing academic papers, specifically in the science and health fields. - Familiarity with scientific terminology and academic resources. - Attention to details in grammar, spelling, and structure. - Strong research abilities.

...minimalist design. Here's a detailed list of what I am looking for: - Training log section per training session - Technique library or pages dedicated to techniques - Progress tracker which includes tracking for belts, stripes, seminars, competition history - Sections for gratitude, mindfulness, wellbeing, and meditation challenges - Pages with inspirational quotes - Blank pages filled with key questions and prompts about jiu jitsu eg: What are your short, medium and long term SMART goals. What does jiujitsu mean to you? Why should you compete? What lessons do you learn that are transferable to every day life? - sections with tips surrounding training, lifestyle, nutrition and mental health The ideal candidate should be a high level practitioner with strong knowledge of j...

I need help with my Microsoft Excel project! Specifically, I require assistance with the following: - **Formulas and Functions:** - Basic arithmetic operations. I don't need anything too complex, just fundamental formula structures. - **Automation:** - No macros for repetitive tasks are required, but I need guidance on setting up conditional formatting rules within the document. I'm looking for a Freelancer who is experienced in Excel and is comfortable with basic arithmetic operations and conditional formatting. You should be able to provide clear, concise, and easy-to-follow guidance. A strong attention to detail and excellent communication skills are a must. If you're proficient in these areas, I'd love to hear from you!

I'm in need of an experienced VBA developer who can create custom macros for me, specifically to assist in automating tasks within Microsoft Excel. I'd like to streamline processes and increase efficiency within the software. Key requirements: - Proficient in VBA: You should be well-versed in VBA programming and have a proven track record of creating efficient and effective macros. - Microsoft Excel expertise: Experience in working extensively with Excel is a must. - Automation focus: The macros need to automate a variety of tasks, including data entry, report generation, and potentially formatting. While the complexity of the data manipulation needed isn't explicitly detailed, please be prepared to work on tasks ranging from basic calculations to more...

Hi there, We are a travel agency looking for an expert in API integration to answer the following questions: Is it possible to connect and our own booking system to check and update automatically accommodation availability, rating, pricing and meals within our internal booking system? It should take into consideration a radius of 5-10km from a certain city point. Our own booking engine works automatically as follows, it sends a booking request to the accommodations on a certain accommodation list (from the first to the last one on that list) following a rule: if the first accommodation on the list denies our booking request, automatically the request will be sent to the second on the list, and so on. What will the requirements?

I need a freelancer to help me gather phone numbers from clothing stores in County . You'll be provided with the location and shops to focus on. Key Responsibilities: - Utilize street view to identify shops - Collecting phone numbers of all...numbers from clothing stores in County . You'll be provided with the location and shops to focus on. Key Responsibilities: - Utilize street view to identify shops - Collecting phone numbers of all such shops - Organize and input these numbers into an Excel spreadsheet Ideal Skills: - Proficient in using street view and other location tools - Detail-oriented and capable of data entry - Comfortable using WhatsApp for communication This is a straightforward project, but attention to detail is crucial. Feel free to reach out if you...

I am in need of an imaginative and technically proficient after effects editor. The nature and style of the videos are not specified, so versatility and adaptability will be crucial in this role. I am looking for someone who can make a stage background with our logos for a sporting event open to your ideas - it will be for a bodybuilding event and need it to be u...Superior knowledge in After Effects - Ability to adapt to different video styles - Command over text/caption placement, colour grading, filter application - Creative editing and ability to replace or remove elements - Exceptional time management for delivering within the desired length - Detail oriented, with reputable work ethic. Experience preferred, but not necessary if you can demonstrate an aptitude for the task...

...cover aesthetics. My book dives into the genre of self-help, with a focus on delivering a message of empowerment to the readers aged 20-30. Title - ATOM JOBS Sub Title - 9 Dream Job Secrets with AI Background Color - white Author Name: Akhilesh Telkar Ideal candidates should have: - Proven experience in designing captivating book covers, particularly in the non-fiction and self-help genres. - Aptitude for understanding the target audience and creating designs that appeal to them. - Excellent communication skills to understand the vision for the book cover and bring it to life. Impress me with your portfolio and let's collaborate to create a book cover that speaks directly to the audience, visually conveying the mood and theme of the book. Ideally, the cover should intri...

...management. - Expert knowledge of various safety threats and first-hand experience in planning for and mitigating these issues at events. - Excellent crisis and crowd control management skills. - Relevant qualifications in safety and emergency management NEBOSH ICG as minimum - excellent communication management - experience in generating reports - advanced Microsoft skills particularly in (words, excel and power point) Your role will be pivotal in ensuring our events are safe, enjoyable and error-free. The ideal candidate will anticipate issues before they arise and resolve them swiftly when they do. Your proficiency in maintaining safety at massive events will be the key to a long-term partnership. Location: KSA Period: 3 months (extendable) Commencing approx: Aug-Sep 2024...

...conditions. It should facilitate easy data input from Excel and offer detailed comparisons, with the ability to export results to Excel. Offer Creator: The freelancer should create functionality for users to customize sales offers by selecting and modifying purchase conditions, adjusting margins, and generating offer views exportable to Excel. Order Recording: Develop a user-friendly interface for recording orders by selecting sales and purchase offer IDs, entering customer-requested details, and generating informative tables for efficient processing. Inquiry: Enable users to upload customer lists for comparison with purchase prices, configure margins, and calculate selling prices directly. The module should support export to Excel for convenience. ...