Excel interview questions for business analyst jobs

As a small commercial general contractor, I'm seeking professional assistance to improve my Excel workbook used for estimates and bids. The ideal candidate for this task should have: - Top-notch Excel skills, specifically understanding VLOOKUP functions and formulas for summing totals. - Experience in creating automatic calculations to streamline my estimation process. - A knack for designing and customizing Excel templates. - A solid understanding of construction or a similar industry would be a huge plus. Specific tasks include: - Building automated calculations for summing totals and utilizing VLOOKUP functions. - Customizing Excel templates, specifically for the cover sheet, project details sheet, and bid ...

I am actively seeking 50 dedicated women to assist with part-time digital marketing on Facebook and Instagram. Ideal candidates are those with: -No skills required - 10th pass can also apply - work from home opportunity - Training and guidance will be provided This is an exclusive opportunity for women only. If you're looking to excel in a digital marketing role, please place your bid.

I'm in need of a skilled survey designer to help me create a structured questionnaire that'll measure the success and efficiency of our IT services. Key Requirements: - Create a comprehensive survey that includes various ...measuring areas like response time, uptime/downtime, and customer satisfaction. - Ensure the survey is structured in a way that it can be deployed on a monthly basis - The survey should be easily understandable by the respondents and generate actionable insights for our IT team. Ideal Skills and Experience: - Proficiency in designing surveys with a focus on KPIs - Knowledge of IT services and various KPIs associated with them - Experience in designing reports for IT service performance - Ability to create clear and concise questions tha...

I'm looking for a talented individual who can help me develop an LLM text model which behaves like a virtual girlfriend. This text model must be engaging in intelligent dialogues with emotions and feelings. Here are the primary requirements for this project: - Create an AI-driven text model: I need a text model that is capable of engaging in intelligent dialogues. This means understanding context, providing relevant and meaningful responses, and exhibiting emotional intelligence. - Incorporate emotional responses: The text model should be capable of expressing emotions and feelings in a realistic manner. This is crucial for creating a believable and engaging virtual girlfriend. - The model can be trained from scratch or, if you have knowledge of current models, a...

...grants for my carpet cleaning business. This will mark my first foray into grant applications, hence I am looking for a specialist who can guide me through this process effectively. Specifically, I need assistance with: - Writing a persuasive grant proposal. While I am open to providing any needed information about my business, I rely on your expertise to translate it into compelling content that would maximize my chances of getting the grant. Ideal skills and experience: - Experience with grant applications, particularly minority grants for small businesses. - Outstanding written communication to eloquently express my business needs and potential. - Proven track record of successful grant applications. - Excellent research skills to ensure ...

I am making a GANTT chart and need to make it highlighted. the chart is created using highlight formula instead of using basic insert chart option. I need help to do a part of it. Video explanation of the problem: Excel file I am working on is attached: The ideal chart should look like the attached image: Looking for the cheapest service as this is almost done.

I am looking for a talented developer to help me implement a comprehensive quiz management system for my personal project. Key requirements include: - Ability to manage multiple choice, true or false, and open-ended quizzes - Provide access to these quizzes through both a website and a mobile application - Incorporate user account management for both quiz administration and participation Skills and experience in the following areas are essential: - Full stack development - Proficiency in developing both web and mobile applications - Previous experience with managing and implementing complex systems with multiple user roles The successful candidate should be able to deliver a high quality, user-friendly system within a reasonable timeframe. 1. Quiz manager: Implem...

I have ongoing work related to our previous project 'M2firstlady Credit Repair Business Logo'

I'm looking for a talented web designer to create a professional and sleek website that will help me promote my business/service effectively. Key Features: - Contact Form: The website must have an easily accessible contact form to allow potential customers to reach out to me easily. - Testimonials Section: A dedicated section where I can showcase feedback and testimonials from satisfied customers. - Service Listings: Clear and concise listings of the services I provide, helping visitors understand what I offer. I'm looking for someone with expertise in web design, a keen eye for detail, and the ability to create a user-friendly, visually appealing website. It's crucial that the design reflects the professional and sleek image I'm aiming ...

Seeking a long-term Python Data Scientist and Generative AI expert Your task is to develop a prototype chatbot that i...Scientist and Generative AI expert Your task is to develop a prototype chatbot that is powered by Generative AI and Large Language Model (LLM) to respond to user queries using domain-specific knowledge and RAG implementation. The project will focus on integrating LLM frameworks, managing data preprocessing, and implementing the chatbot's user interactions. ONLY people who respond to below screening questions will be considered: 1) Did you fine-tune an LLM model using LoRA or QLoRA? If so, which model did you fine-tune, and what was the use case? 2) Do you have a GitHub profile? If so, can you share the link? 3) Are you proficient in English, and what is yo...

Hey there! We're searching for a talented developer to help us convert an existing HTML/CSS/JS project into Builder.IO. If you're experienced with and have a knack for turning static projects into dynamic, user-friendly websites, we want to hear from you! You'll be taking our current HTML/CSS/JS project and transforming it into a custom website, ensuring it's responsive and looks fantastic on all devices. You'll also collaborate with our design and content team to create a seamless and visually appealing experience. We're looking for someone with proven experience in , strong skills in HTML, CSS, and JavaScript, and a passion for creating beautiful, functional websites. pls answer my questions on your proposal. Do you hav...

I am considering the development of a boutique hotel in Lombok, Indonesia, targetting particularly the surfers from Australia, Bali, New Zealand, Europe. The hotel would be the only hotel close to Desert Point, one of the most well known surfing spot globally. Scope includes contacting Surrfing Clubs in europe and asia and ask them a dozen of questions to gauge the level of interest for booking rooms in the hotel as well as their preferences for different hotel amenities and features.

I am looking for a Cantonese-Spanish translator to accompany me on a daytime business trip to Guangzhou in June (06/28, 07/1-2-3). The trip will last less than a week and involves business negotiations. Ideal candidates should be: - Speaks Cantonese and Spanish fluently. - Strong in industry-specific terminology, particularly in business. - If possible, have some experience in exports. Your main responsibility will be to help me with translations during the different business meetings that are scheduled. Their role is crucial to ensure fluid communication. Your support will be greatly appreciated.

I need a designer for a flyer/postcard promoting my service-based business. This piece plays a significant role in announcing our offerings to the market. Key Requirements: - Design should promote our business services effectively. - Match the design color scheme with our existing business logo colors. Ideal Skills: Freelancers with experience in designing marketing/advertising materials, particularly for service-based businesses, will be ideal for this project. A keen sense of color matching and understanding of marketing strategies will be beneficial.

I'm looking for an experienced professional who can create a custom Microsoft Excel spreadsheet for me. This spreadsheet will be designed to generate GUIDs (Globally Unique Identifiers) in a random fashion. The GUIDs will be used for database record identification. Key Requirements: - Development of a custom Microsoft Excel spreadsheet. - Implementation of a random GUID generation mechanism. - Ensuring the functionality for database record identification. Ideal Skills & Experience: - Proficiency in Microsoft Excel, particularly in custom formula creation. - Strong understanding of GUIDs and their usage in database systems. - Previous experience in developing similar solutions. I'm looking for someone who can deliver a...

I'm looking for a professional who can convert my Amibroker AFL script into a TradingView Pine Script. The converted script should be able to generate buy/sell signals and provide backtesting capability. The ideal candidate should have experience in: - Amibroker AFL and TradingView Pine Script languages - Developing buy/sell signals - Implementing backtesting functionality Moreover, my trading strategy is based on breakout patterns. The converted script should reflect this strategy and incorporate the following indicators: - Moving Averages - Relative Strength Index (RSI) - Supertrend I'm looking for a freelancer who can deliver a polished and fully functional script that mirrors the performance of the original AFL script in TradingView. Feel free to ask any add...

I'm seeking an experienced Excel professional to assist with a small data entry project. Key Responsibilities: - Data entry with formulas: You should be proficient in Excel and comfortable working with spreadsheets that require formulas. - Handling digital data: You will be provided with data in a digital format, likely an Excel or CSV file. Ideal Skills: - Advanced Excel skills: You should be well-versed in Excel, particularly in data entry and formulas. - Attention to detail: Precise data entry is crucial for this project. - Efficient and organized: I'm looking for a freelancer who can manage their time and workload effectively. Please note that this is a straightforward project with no requirement for data analysis ...

I'm urgently requiring a skilled professional to assist with three key HR functions in my growing small business. These include: - Hiring and Recruitment: Expertise in this area is especially critical as choosing the right candidates is the backbone for a successful venture. - Training and Development: Your role would be to design and implement development strategies to nurture employee skills and maximize their job performance. - Performance Management: To ensure alignment with business goals, you would be in-charge of setting up a performance management system and spearheading the process. It is paramount for the ideal hire to have experience with implementing such functions within a smaller organization, understanding the unique challenges and opportun...

Hi, apologies again for the delay. Here is a renewed project. Let me know if you have any questions.

I'm seeking an experienced app developer to create a business mobile application that's compatible with both iOS and Android platforms. Key Features Required: - Integration with a payment system to facilitate transactions within the app. Ideal Candidate Skills: - Strong cross-platform development experience (iOS and Android). - Proven track record in integrating payment systems in apps. - Familiar with creating robust, secure financial transaction systems. - Solid understanding of UI/UX for business apps on both platforms. Please include examples of business apps with payment integration you've previously developed in your proposal. Thanks!

I am seeking an experienced Excel expert to help resolve an issue with a percentage calculation in my Excel spreadsheet. Despite following standard procedures, the result is incorrect, and I need assistance to identify and correct the problem. Details: I am working with the following data in my spreadsheet: Total Costs for the Job (Cell V14): $241,779.50 Total Collected (Cell V17): $289,844.00 Profit (Cell V15): Calculated as =V17 - V14, resulting in $48,064.50 I need to calculate the profit as a percentage of the total costs, and this should be displayed in cell V16. The formula I am using is: = ( ? 15 / ? 14 ) ∗ 100 =(V15/V14)∗100 Given the values: = ( 48 , 064.50 / 241 , 779.50 ) ∗ 100 = 19.88 % =(48,064.50/241,779.50)∗100=19.88% How...

...professional who can help me draft a comprehensive business plan for my digital library project. The plan will play a crucial role in securing a sponsor to support our objective of promoting literacy and education through a digital platform, targeting the general public. The Idea of the project is to translate sceintific papers/articles onto the Arabic language. Articles will be primerly from the English language for the time being but the longer aim is to include more languages, like chinese/russian/german/french..etc. some articles will require permissions but we can start with open source articles as a start. the articles will be published after translating them into arabic in a website and then they will be available to read for free, but for downl...

Needed: Remote Part-Time WordPress Designer / Publisher ? Please read the entire project and respond only if you are the right candidate and agree with the salary. Automated bids will be ignored. About the Role: Are you a passionate WordPress enthusiast who loves design and development? We are looking for a Remote Part-Time WordPress Developer / Publisher to join our dynamic team. This role offers the flexibility to work from anywhere in Pakistan, collaborating with team members to create and maintain stunning WordPress websites. Responsibilities: Design & Development: Crafting visually appealing and fully functional WordPress websites. Content Management: Publishing and updating content across WordPress sites efficiently. Blog Management: Editing, publishing, and maint...

I'm in search of a skilled data analyst with expertise in health and medicine for a comprehensive meta-analysis project - Focusing on the health and medicine subject area - Including data sources from peer-reviewed journals - Presenting the results in graphical charts, statistical tables, and a narrative summary Ideally, you should have experience in: - Meta-analysis, especially within the health and medicine domain - Working with various data sources, particularly from peer-reviewed journals - Proficiency in creating and interpreting graphical charts and statistical tables - Crafting a concise and informative narrative summary from the analysis This project requires attention to detail, critical thinking, and the ability to synthesize complex information. Experience...

I need to make updates to userform so that empty dates do not affect filter on table. Right now leaving date field empty hides all the rows of table. Few more updates needed and more details will be shared with selected freelancer.

I'm looking for a data scraping specialist proficient in leveraging social media platforms, business directories and website scraping. The goal is to create an Excel sheet with approximately 500 entries for market research purposes. Skills & Requirements: - Proficient in data scraping from multiple sources - Capable of filtering and sorting data - Able to extract and compile the following data fields: zip codes, locations, contact information, business name and industry. The successful candidate should demonstrate experience in similar projects, showcasing their ability to find and compile information efficiently and accurately for market research purposes.

I'm currently running Google ads for my business and I want an expert to optimize it. I'm looking for someone who can help me to maximize the effectiveness of my Google Ads campaign.

Company Overview: We specialize in providing innovative automation solutions for small businesses, including CRM, marketing automation, graphic design, and print solutions. Our goal is to streamline operations and drive growth with smart, reliable, and professional tools. Design Guidelines: Concept and Style: Modern and Professional: The logo should reflect a contemporary and professional look. Innovative and Smart: Emphasize the innovative and intelligent nature of our automation solutions. Fluidity and Flow: Incorporate elements that suggest smooth operations and efficiency. Color Palette: Primary colors: Consider using blues, greens, or grays to convey trust, innovation, and reliability. Accent colors: Orange or silver can be used as accent colors to add vibrancy and modernity...

I'm seeking an experienced professional to develop a comprehensive and effective Confidential Information Memorandum (CIM) for my technology business. This document will be a key tool in the sale of the company and needs to be of a high standard to attract potential investors. Key Requirements: - Industry Expertise: A strong background in the technology sector and a good understanding of the current market trends is crucial. Previous experience in creating CIMs for tech companies will be highly valued. - Financial Information: You will need to provide detailed historical financial information of the company, likely the past 3-5 years. This will need to be presented in a professional and engaging manner to showcase the company's financial health and growth po...

I am in need of a developer who can assist me in converting my existing Flask API into an Assistant GPT openai. The ideal candidate will be skilled in Python and GPTs Assistant and have a proficient understanding of Flask A...need of a developer who can assist me in converting my existing Flask API into an Assistant GPT openai. The ideal candidate will be skilled in Python and GPTs Assistant and have a proficient understanding of Flask APIs. As the project involves converting the API into an Assistant GPT, experience with AI and NLP models will be a huge plus. Please note that there was a technical error in the questions, hence the repeated skips. It is highly important that the converted system maintains the functionalities of the original API while being able to run as an Assi...

I'm looking for a professional to verify the phone number for my Google Business profile to enhance its credibility and visibility. Key Requirements: - The verification method should be of Landline number. Ideal Skills and Experience: - Experience in managing Google Business profiles. - Proficiency in verifying phone numbers using SMS. - Knowledge of best practices to increase trust with customers and enhance visibility on Google Business.

...videos will be used to promote a specific product or service across multiple platforms. Platforms: - The final products will be optimized for social media, web and also suitable for email marketing campaigns. Audience: - Specifically targeting age group 36-45 and above. Therefore, the design, tone, and messaging of the videos should be relatable and appealing to this demographic. Ideal Skills: - Proficiency in video editing softwares - Solid understanding of digital marketing and social media trends - Experience in creating content for age group 36+ - Ability to deliver on time, maintaining the high quality. Should you have any additional questions or need more details, please feel free to ask. I'm looking forward to seeing your creative vision com...

This is my website link I have used "Classima – Classified Ads WordPress Theme" theme. I want to upload date from xls sheet. Excel attached for your reference. Raduus Theme is not providing support and they only provides category and location import options. Can you help me to import data

I've got a list of company names on an Excel sheet that I need you to help me with. Here's how you can assist: - **Scraping from Multiple Platforms**: I need you to scrape email addresses, phone numbers, and any available social media accounts of these companies. You'll need to do this across Yelp, Google Maps, and TripAdvisor. - **Social Media Scraping**: In addition to the primary two platforms (Instagram and Twitter), I'll also need you to scrape Facebook accounts if available. Ideal candidates for this project should have: - **Web Scraping Experience**: A good knowledge of web scraping techniques and tools, which will ensure you can obtain accurate and reliable data. - **Data Mining Knowledge**: The ability to identify and extract the necessary data...

I urgently need a competent videographer with personal camera and sound equipment to produce engaging, high-quality videos over a two-day period amounting to about 10 hours. These videos will include event coverage and conducting interviews. Key Requirements: * Ability to film in indoor locations. * Adeptness in filming both event videos and interviews. * Expertise to create videos aimed at both marketing and promoting our brand and providing educational information. Skills and Experience: * Solid videography experience. * Proficient use of personal camera and sound equipment. * Proven track record of working on marketing and promotional casings, as well as informative and educational projects.

(Business Development Executive) (with good track record) + Must have strong Sales Managerial Experience in any B2B SaaS company OR been as a Sales Partner. + Experience in dealing with B2B + USA Market + Must be interested in taking on new challenges. + Should have hands-on experience. + Only Freelancers are Allowed (No Agencies or No Companies) Fixed Price Project: $3000 / Project

I have an protected password .mpz format that I need to have the program can unlocked and converted into a readable format, preferably Excel or CSV. - The file contains both textual and numerical data, so I need the converted file to maintain this integrity. - I intend to use the data primarily for reporting purposes, so it is essential that the conversion is accurate and all data is preserved. I'm seeking a skilled professional with experience in file format conversion and data handling. The ideal freelancer should be proficient in Excel and adept at handling mixed data formats. This project is crucial and I'm looking for someone who can deliver a high-quality and precise conversion.

...functionality: Users can purchase vouchers at half price. - Condition: To avail the voucher, the user must share the app link with 10 other users. - Success criteria: If the user successfully shares the link with 10 users, they can redeem the voucher at half price. - Failure criteria: If the user fails to share the link with 10 users, they will receive a 10% discount on the voucher instead. Some more questions - Can the voucher sharing process be automated or tracked within the app? Ideal Skills and Experience: - Proficient in mobile app development, particularly customization on existing apps. - Strong UI/UX design capabilities to ensure a seamless user experience. - Experience with integrating push notifications and payment gateways. - Familiarity with backend development ...

...creative ad designer who specialises in Facebook advertising. The aim is to produce an advert which can be translated into multiple languages to target different countries. The ad is for a downloadable video course, for those whose native language is not English, teaching what to say in a job interview in English. Predominantly my market would be working professionals aged between 25 and 50 who are likely to have to attend job interviews in English. Main tasks would be : - Creating an engaging Facebook ad - zeroing in on target group of potential customers (possible later task) - designing an effective landing page for ad clicks current page (in Italian) can be found at I can provide a translation

Thank you!

I have a ...plan drafted on which I want to have converted into Excel. The Excel file should mirror the plan in all aspects, including costs, expenses, revenue, and financial projections. Key Requirements: - The Excel file should be a faithful recreation of the original financial plan, ensuring that all details are accurately transferred. - It should include all costs, expenses, revenue figures, and financial projections. - You will need to have experience in financial planning, specifically in converting plans from to Excel. To be clear: I do not need business plan development, I need mostly technical work of converting one form of financial plan to the other (Excel file). Specifics: - I do not need any charts in the Excel file, but th...

Hello, I am looking for someone who can help me review a locker service in Spain. The job requires: Being stationed in Spain. Ordering a package to the locker. Picking up the package from the locker. Answering questions regarding the service. Let me know if you are interested and available for the job.

Hi there, I am looking for a professional Digital Marketer for my affiliate product link promotion who has confidence enough in their skills to bring me sales, You must be an expert digital marketer with enough Experience in the market, otherwise, you will just be wasting your money and time, your work is to promote my affiliate link and bring me sales and you will ONLY get paid after you bring me sales. Apply only if you are sure you can bring sales. Contact me if you have any questions about this job.

...am looking for a developer who can create an Android mobile optical reader application using OpenCV for image filtering. The main purpose of the application is to apply image filtering effects to the captured images. I would like to have an application made that will read the rectangular optical form with 25 questions and 5 options specified in the appendix, with a phone camera. Through the application, first the user will enter the answer key of the exam, then the correct/wrong/blank questions should be calculated by determining the options marked with the appropriate image processing algorithm. In addition, the number of times each question was marked as correct, how many times as incorrect and blank should be kept during each determination. The applicatio...

I'm looking for an experienced videographer to capture various aspects of a visit to a company HQ in London. This project will include: - Filming interior shots of the HQ - Filming interviews with employees (YouTube presenter will conduct the interviews) - Capturing B-roll footage of the surrounding area The visit date is Tuesday 18th May. The purpose of the video is to generate a YouTube video that will captivate and engage YouTube viewers. The ideal freelancer should have prior experience in corporate videography, and creating dynamic YouTube content. Please provide samples of previous work of a similar nature when applying.

Please Sign Up or Login to see details.

I'm in search of a professional to create monthly sales reports in Excel. We need to create several tables starting from the attached files starting from input file 1 1- In input file 1 you need to filter the data in column B and take into consideration only "Order payment" and "Refund". 2- Filter the rows of input file 2 (attached), column D "Product Details" so that the different product details appear only once and report them in the VAT output file so as to have only 2 Product Name columns (in which the "product details of input file column 2" are listed. (example VAT file attached) 3- The app must check that all the lines present in column D "Product details" of the input file 1 are present in column A of the VAT output f...

...seeking a highly skilled Front-End Developer with a strong focus in React(using Typescript) and a minimum of 12+ months of experience in creating web applications. You will be responsible for the development, design, and implementation of our new website's front-end aspects. This is a **6-month contract** position with a competitive hourly rate. **Key Responsibilities** - Developing new user-facing features using React.js and Typescript - Building reusable components and front-end libraries for future use - Familiarity with RESTful APIs and integrating front-end with back-end services. - Optimizing components for maximum performance across a vast array of web-capable devices and browsers - Implementing an intuitive user interface - Designing engaging website...

...fixed (if you ask for more, you will be blocked and if you bid over the amount in the project, your bid will be hidden), and I will discuss everything via private message. I am looking for a dev to start today on this and would like it done by tomorrow. It is not terribly hard work or that time consuming. I will provide logins only once I have awarded. I am not giving out logins ahead of time. If you ask during the messaging process, you will be blocked. Also, I anticipate that quite a few will be capable of completing this task. If I reach out to you, after I send the project details, you must explain to me why you are the one I should pick. You are welcome to ask questions in there but I have been very thorough in my project details. If you need to ask alot of ...

I have an Excel sheet that requires data filtering. From One sheet i want the following 1) Deletion of few records with some keywords 2) Make one sheet with unique data 3) No of repeated records. 4) Mobile number format to be changed