Advanced excel interview questions and answers jobs
...to compile and analyze raw ad spend data from Google Ads and Facebook Ads. This data will be used in correlation with sales data from Excel Sheets. The goal of this task is to determine if the presented ad spend had a significant impact on total sales or sales in our stores. The data spans from May 2016 to May 2024. Key Requirements: - Compile ad spend data from Google Ads and Facebook Ads, and sales data from Excel Sheets. - Perform trend analysis on the data sets to determine if any discernable impact exists between the ad spend and sales. - The focus should be on whether ad spend, regardless of platform, led to a measurable and discernable difference in sales. Ideal Skills: - Strong data analysis and interpretat...
...seeking a skilled and experienced C# developer with expertise in the .NET framework. The primary task at hand is to implement advanced background job features within the project, with a specific focus on Asynchronous Processing and Queue Management. Key Deliverables: - Implement Asynchronous Processing: The developer should be able to design and implement a system where tasks can be processed concurrently, allowing for better performance and resource utilization. - Implement Queue Management: The project requires a developer who can set up a robust queue management system, ensuring tasks are executed in the correct order and at the right time. Specific Requirements: - Maximum Queue Size: The system needs to be designed with scalability in mi...
...developer to create an exciting and engaging Augmented Reality (AR) application, specifically designed for iOS and Android platforms. Key Requirements: - Dual Platform: The application must be compatible with both iOS and Android devices, ensuring a broad user reach. - Augmented Reality: Primary focus of the app will be on utilizing AR technology to display and interact with objects in real-time. - User Engagement: The application should be designed to engage users with technology and streamline manual processes. Ideal Skills: - Proficiency in AR development for both iOS and Android - Experience with developing engaging and interactive applications - Strong understanding of user-friendly design and interface - Abili...
...build tuned pipe , expansion chamber for dirt bike. I do know all my dimensions lenght and diameters. I want to be able to draw a line wich will be my centerline and then on this line i want customize every lenght and diameter of each section. Then had radius in sections. I would like to to be able to divide each sections in strip section to be then cut on my plasma. I have included a YouTube video to show what i am looking for . I want to have a reference line that i can curve on every axis along the length required in order to follow the curved and straight section needed. - On that line I want to have adjustable point to be able to adjust length and diameter for each my subsection. Because each pipe is build with many differents cones -Each
...experienced developer or team to create and integrate an advanced automated options trading bot into my Demat account via API. This project will involve the development of a bot that utilizes both predetermined trading signals and artificial intelligence to adapt to market conditions. The successful candidate will work closely with me to ensure the bot operates within the parameters of my trading strategy while maximizing efficiency and profitability. Key aspects of the project include: - Understanding the intricacies of options trading and the specific requirements of my strategy. - Developing a robust and secure bot that can perform high-frequency trades with precision. - Implementing machine learning algorithms to enable the bot to learn fro...
...Market Research and Mystery Shopping company. We undertake worldwide mystery shopping visits and audits. This assignment is an audit of an Examination Centre, checking that the security standards are being met. You MUST HAVE fluent English skills, and you must be able to communicate in a professional manner and be smart and well-presented, as you will be representing us during the audit. As an auditor, you will arrive at the test center an hour before the start of the exam, give your ID, show a letter of authorization, which we will provide for you beforehand, and tell them what you are there to do. You will then sit with the TCA or the manager and ask a series of questions, and ask to see various things. The audit itself...
Translation of two files, from English to Hebrew. File #1 contains 8 rows of text in Excel format, 119 English words. File #2 contains 85 rows of text in Excel format, 2,035 English words.
...to drive innovation, optimize processes, and create value for our clients. Mission: Our mission at is to empower organizations by integrating advanced AI technologies into their operations, enabling them to make data-driven decisions, boost productivity, and stay ahead in the competitive market. Our Services: At , we offer a comprehensive range of AI services tailored to meet the unique needs of our clients. Our services include: ∙AI Consulting: We provide expert guidance and strategic insights to help businesses understand and integrate AI technologies effectively. ∙Custom AI Solutions: Our team of skilled developers and data scientists design and develop bespoke AI solutions that address specific business challenges a...
I'm in need of an intermediate level Java trainer who would help uplift my skills in this area. The selected freelancer must be proficient in: - Core Java - Java frameworks including, but not limited to, Spring and Hibernate - Advanced Java such as J2EE, JSP, Servlets In-person sessions are preferred, so facilitators who can deliver on-site training will be much appreciated. Prior experience in delivering Java-based tech training programs would be great. The perfect freelancer for this role is one who possesses precise technical knowledge, patience, as well as excellent teaching skills.
'Alvo' means 'Target' in Portuguese. Business overview: Alvo is an expert sales prospecting services. We connect our customers with the right prospects, helping them to grow their pipeline and close deals faster. What We Do: Identify Ideal Prospects: Our team uses advanced data analytics to pinpoint the perfect leads for your business. Engage Effectively: We craft personalised outreach email campaigns that resonate with your target audience. Logo colours: Please look at logos with orange, white and maybe green. Logo feeling: clean, modern, technology and if possible a design that makes you think of a target or dart board.
I require an experienced business plan writer for my tech start-up. Our primary goal is not only to guide operations but most importantly, secure funding. - Firs...the task an innovative feel. So, a flair for crafting compelling narratives around technology projects is a must. - Secondly, we're at the start-up stage. Consequently, the potential for growth and scalability is immense. Candidates should be able to effectively communicate this potential onto paper. - Lastly, I would like to attract investors. Your experience in pitching businesses to investors, understanding their expectations and key concerns, will be highly appreciated. Skills ideal for this job would be advanced understanding of the technology industry, experience in start-up development, a...
We have a list of around 4,795 energy consultants. This list contains the name of the consultant, the company name they work for, contact information including general email address, telephone number, website, and address. However, we need you to find out the personal corporate email address of each consultant, and insert it into Column K in the Excel sheet. Check the attached file. Time : 48 Hours Budget 50$ Lowest Bidder will win Milestone Payment : no advance milestone payment. After Completed work get payment. Thanks
...This includes a cover and back page, a table of contents, an "About Us" page, and an introduction. MAIN SECTION OF THE BROCHURE: 01. 31 SERVICE PAGES: Each of these pages presents a specific IT service of our company. 02. 8 CATEGORY PAGES: These pages group various services under thematic focuses. 03. INDEX PAGE: A comprehensive table of contents listing all services, categories, and the additional service page, 04 facilitating easy navigation and quick access within the brochure. 04. INTRODUCTION: A brief introduction to the brochure, outlining its purpose and providing context for the content. 05. "ABOUT US" PAGE: This page provides an overview of our company, mission, vision, and values. 06. COVER PAGE: The front cover o...
...create a unique, modern and minimalist logo for our brand "COSPN". This logo will serve as a representation of the values that we stand for and embody, which include professionalism, modernity and trustworthiness. Key Requirements: • The logo should combine imagery and text. • The color scheme must be Onxy (#353935) or similar & Gold, and no other colors should be used. • The final design should reflect modernity. • The design should be minimalist. • The final deliverable must include the source file with all the fonts and elements used. • Need 3 PNG files, one is full black, one full white, one actual color. Skills and Experience: • Proficient in major design software (Adobe Illustrato...
I'm seeking a freelancer to correct the date format in my Excel sheet that is currently not displaying correctly. Key Requirements: - The Excel sheet must display dates in the format DD/MM/YYYY. Additional Details: - The corrected date format is only required on specific sheets within the same workbook, not all sheets. Ideal Skills & Experience: - Proficiency in Excel and its date formatting functions - Experience with correcting date format issues in Excel - Attention to detail to ensure all specified sheets are updated correctly.
I need a freelancer to search List of Medical centers & Hospitals in Australia. Currently we have a list of centers & hospitals but need to search & add about 3000 more which are not included there (Including the contact details). We need a complete file with accurate detils & milestone will not be released until the work is checked. All centers should be added as per the state. Please quote with the time period & the exact fees you will charge for this. Ongoing work for successful candidate.
...fulfilled this week. I'm in need of a professional who can assist me with creating workflow automations and integrating with Microsoft applications. We will organise a teams sessions and go through the desired customizations , all the work is done via remote access. I have a Microsoft environment comprising of SharePoint, Outlook, Teams, Word, Excel, and PowerPoint. Some tasks need to be automated such as document approval , collaborations and other SharePoint settings. Ideally, you should be highly proficient in Power Automate (Microsoft's workflow automation tool) and have strong experience in integrating various Microsoft applications. A background in SharePoint, Outlook, Teams, and the Office suite is a big plus. Your pr...
I'm in search of a se...developer with extensive Laravel framework expertise, experience in developing scalable web applications, and a deep understanding of API integration. I aim to build a robust Laravel application with a myriad of advanced features and functionalities. As the chosen developer, you will be tasked with: - Leveraging your Laravel framework expertise to create an efficient and error-free application. - Drawing from past projects to guide the development of a scalable web application. - Demonstrating your API integration knowledge by seamlessly incorporating various third-party systems. If you have a rich portfolio that showcases your Laravel prowess, experience in building scalable web applications, and a knack for successful A...
I have a basic school project that requires inputting provided data into Microsoft Excel. Here are the specifics: - You will be provided with a simple dataset. - The main objective of the project is to input data from this dataset accurately based on the given instructions. The ideal freelancer for this project would be someone who is: - Proficient in Microsoft Excel. - Detail-oriented to ensure accurate data input. - Able to follow provided instructions carefully.
...automate the management of absences within our company using VBA Excel. The goal is to simplify and optimize absence tracking, reporting, and data analysis to save time and improve accuracy. **Project Description:** The project involves developing an automated solution in Microsoft Excel that includes: 1. **Absence Data Entry:** - Interactive forms for entering absences (sickness, vacations, authorized absences, etc.) - Data validation to ensure accuracy and consistency. 2. **Automatic Absence Calculation:** - Automatic calculation of absence days per employee. - Tracking different types of absences and their quotas (paid leave, sick days, etc.). 3. **Report Generation:** - Creation of weekly, monthly, and annual...
...experience and making it easier to navigate through our products. - Membership subscriptions: The site should be capable of handling user subscriptions, privileges, and member-specific content. - Advanced analytics: It's crucial for us to have clear insights into user behavior, sales, and product performance. So, the site should be integrated with advanced analytics tools. Furthermore, I'd like the payment gateways PayPal, Stripe, UPI, and credit card to be seamlessly integrated on this website. The ideal candidate should have: - Proficient experience in WordPress e-commerce development. - Experience in integrating membership subscriptions, custom product filters, and advanced analytics tools. - Strong knowledge of int...
I need help with a data entry task that involves copying and pasting data from PDF documents into an Excel spreadsheet. Key points: - The task involves strictly copy and paste work, no data cleaning or formatting is required. - The primary source of data is PDF documents, so proficiency in extracting data from PDFs is a plus. - The data should be accurately transferred into an Excel spreadsheet. Ideal Freelancer: - Proficient in PDF data extraction and Excel. - Attention to detail is crucial. - Previous data entry experience is preferred.
...pull data from our existing Excel spreadsheets and update daily. Key Features Required: - Job Status: This will give us a clear overview of the number of open positions, positions in the interview stage, and positions that have been filled. - Recruitment Pipeline: Visual representation of where in the recruitment process our candidates are, from application to hire. - Applicant Information: A detailed breakdown of our applicants, their demographics, and the source from which they applied. - Application Source: Analysis of the effectiveness of our recruitment sources. - Time to Hire: Ideally, a calculation of the time it takes to move a candidate from application to hire. - Candidate Demographics: A clear summary of the demographics of our applicants. ...
I am in need of a diligent professional who can assist in extracting text data from PDF files and accurately inputting the information into an Excel spreadsheet. The job calls for attention to detail and excellent data entry skills. Essential Skills and Experience: - Proficiency in Data Entry - Expertise in Excel Your responsibilities will include: - Accurately converting text data from PDF files into Excel - Ensuring data integrity through careful data entry - Delivering the project on time Ideal candidates would have prior experience in handling similar tasks. Your accuracy and commitment to the task at hand will be pivotal to the outcome of this project. Looking forward to receiving your bids.
...overdue tasks and calculate completion percentages. - Data sorting and filtering functionalities are a must. I want to be able to sort my tasks by due date, priority or completion status. - Conditional formatting is also needed. I'd like the cells to change color based on task status (e.g., incomplete, complete, overdue). Platform and Updating: - I prefer the use of Google Sheets for this project. - I plan to update the spreadsheet manually. This means that the sheet should be user-friendly and easy to navigate, with clear headings and sections that I can easily edit and add to. Ideal Skills: - Proficiency in Google Sheets and advanced knowledge of its functionalities. - Experience in creating automated spreadsheets with fea...
...documentary project for online media. - Event Type: Documentary/Interview/Broll Your primary task would be capturing the essence of these important topics through high-quality video. I'm looking for a professional who can bring creativity and passion to this project. Key requirements: - Proficiency in operating professional cameras and related equipment - Prior experience working on documentary projects, especially related to social issues - Proven ability to capture compelling, high-quality footage While I don't require editing services as part of this project, your understanding of how footage will be used in post-production would be an advantage. If you have the right skills for this opportunity, please share your portfolio and any relevant...
...proficient in Advanced Custom Fields Pro. I already have a WordPress website up and running - your assistance is required to configure ACF fields for the creation of more dynamic content pages. Key Requirements: - Proficiency in Advanced Custom Fields Pro - Experience with WordPress development - Strong understanding of dynamic content creation Your role will be focused solely on configuring and output ACF fields. I will provide you with the details and specifications for the dynamic content pages to be created. The main goal is to ensure that the website's content is not only visually appealing but also functional and easy to manage. Your past experience with similar projects is very crucial, and examples of your work will be hig...
I am in need of a skilled Excel professional who can create a comprehensive Excel dashboard focused on data analysis. The dashboard will integrate with various Excel files to provide real-time data updates. Key Requirements: - Create an Excel dashboard that primarily focuses on data analysis - Integrate the dashboard with multiple Excel files - Ensure that the data updates are in real-time Ideal Skills: - Proficiency in Excel - Experience in creating complex and dynamic dashboards - Knowledge of data analysis techniques - Familiarity with real-time data integration This project is ideal for an Excel expert who can not only design a visually appealing dashboard but also ensure that it is highly functional for data analysis purposes.
...tax planning and return preparation advise and services for my NEW business with no employees in Wyoming. Key Requirements: - Expertise in business tax preparation - Wyoming LLC jurisdiction knowhow - Minimum 5 yrs similar experience , please share profile if available! - Companies preferred and must be able to provide written advise / reply to my queries that , I will share with the selected company / individual. - Previous experience with LLCs - Knowledge of Wyoming tax regulations - Ability to provide tax planning and advice The ideal candidate would also be able to represent my company with the IRS if necessary. It's important for me to find someone who can help me navigate the tax landscape for my new business. Please specify your...
We seek an Excel expert with experience in developing Bill of Materials (BOM) and Inventory management solutions tailored for small home businesses. The focus is on simplicity and functionality without the need for a commercial product presentation. **Key Features Needed:** - A user-friendly Excel workbook that manages electronic components, their stock levels, and inventory updates post-sales efficiently. - BOM creation from inventory items with an ability to incorporate "other costs" into each assembly. - Stock purchase entries should automatically update inventory quantities and costs. - Detailed sales tracking with automatic inventory quantity adjustments. - Low stock level notifications via highlighted rows in the spreadsheet. ...
...understanding of data modeling and transformation for the purpose of creating an intuitive dashboard. This dashboard will primarily focus on showcasing our sales and market data. Most of the data would be related to Transportation and Logistics Domain, for eg : Port Wise Performance Customer Support Analysis Database would be PostgreSQL Key Components: - Incorporation of various visuals such as line and bar graphs, pie and doughnut charts and maps to effectively represent geographical data. - Advanced skills in handling complex sales and market data, and ability to visualize this in a digestible manner are essential for this task. - Familiarity with creating reporting tools using similar datasets will be highly appreciate...
I'm seeking an individual who is well-versed with Excel for data entry tasks. This primarily involves typing and organizing data. Here's what you'll be doing: - Typing out data and organizing it in Excel spreadsheets - Ensuring accuracy and efficiency in data entry Applications should include: - Examples of past work, particularly those related to data entry and Excel Ideal freelancers for this job are those who: - Have prior experience in data entry - Are proficient in using Excel - Possess strong attention to detail, ensuring accuracy in their work.
I'm seeking a skilled developer to create a website similar to , but focused on AI-powered image generation. I intend for the AI to allow users to create customized images by uploading reference images. Key Objectives: - Develo... Required Skills: - Proficiency in web development, particularly in creating user-friendly interfaces - Experience with integrating third-party AI applications, specifically StableDiffusion or Dall-E - Skilled in managing image uploading and processing - Prior experience with similar projects preferred I'm open to suggestions for the best approach to implementing this AI functionality, so proposals should include a plan for how you would approach this project. The site should be optimized for both desktop and mobile devices. Feel free to ...
...JavaScript Developer with expertise in ElectronJS, ReactJS, OpenCV/TensorFlow, and ExcelJS to join our team. The ideal candidate will be responsible for developing and maintaining desktop applications using ElectronJS, building and managing user interfaces with ReactJS, and implementing OpenCV and TensorFlow. Additionally, the role requires the ability to read and manipulate Excel files using ExcelJS. The candidate should be proficient in JavaScript and have a strong understanding of its ecosystem. They should possess extensive experience with ElectronJS for building cross-platform desktop applications. Familiarity with OpenCV and TensorFlow is essential, as is experience with ExcelJS or similar libraries for handling Ex...
I am looking to automate certain repetitive tasks that are currently performed in Excel using Power Automate. - Main Objective: The chief goal of this project is to automate data comparison tasks. This will greatly improve productivity and minimize errors that may come with manual comparison. - Ideal Experience: The ideal freelancer for this task should have extensive experience in Excel and Power Automate and should have successfully completed similar jobs in the past. A strong understanding of data comparison techniques and working with excel spreadsheets will be highly beneficial. - Skill Set: Key skills required include Excel, Power Automate, and a good understanding of data processing and workflow automation.
I'm in need of a skilled individual who can scrape data from various websites for the purpose of lead generation. The data should be delivered in Excel or CSV format. Key Requirements: - Proficient in web scraping - Experience with lead generation - Ability to deliver data in Excel/CSV Ideal Skills: - Proficiency in Python/R for web scraping - Previous experience in similar projects - Strong understanding of lead generation techniques If you have experience in web scraping and lead generation, I'd love to hear from you.
I'm in need of a Telegram Bot and corresponding Web application for the wellness industry. Key Features for the Telegram Bot: - **User Registration**: The ability for users to sign up and create their own accounts. - **Daily Health Tips**: A feature that provides users with helpful health tips on a daily basis. - **Fitness Tracking**: The bot should enable users to keep track of their fitness progress. Key Features for the Web Application: - **Wellness Resources**: A comprehensive library of wellness resources for users to access. - **Appointment Scheduling**: An integrated system for users to book wellness appointments. - **Community Forum**: A platform for users to share experiences, ask questions, and support one another. - **Fitness Challenge**: A se...
I need a proficient video editor skilled in advanced editing techniques like special effects and transitions. The project involves enhancing an instructional/tutorial video using animated graphics and text. CRUCIAL REQUIREMENTS: - Proven experience in advanced video editing - Excellent in animated graphics and text production - Background in creating engaging instructional videos Your expertise and creativity will help bring these tutorial videos to life, enhancing their effectiveness and engagement level.
...that involves reading text from PDF files and answering questions based on the content. This task must be completed without using any external libraries. The ideal candidate should have strong programming skills and experience with text processing and file handling. Project Details: Objective: Extract text from provided PDF files and answer specific questions based on the content. Requirements: No use of external libraries for PDF reading and text extraction. Write custom code to parse and process the PDF files. Develop a method to accurately answer questions using the extracted text. Deliverables: Custom code/script for reading text from PDF files. A function or method to process the text and generate answers...
...specifically. Key requirements and details: - The video should effectively highlight the program's three main selling points: its course recognition by Singapore Association of Counselling, our experienced faculty, and the hands-on practical training the students receive. - Aim for a balance of engaging visuals, compelling narrative, and informative content that appeals to individuals considering a career shift into counselling psychology. - We'll need the final video to be high-quality and suitable for promotional purposes across various online platforms. The ideal candidate for this job will have: - Proven experience in creating promotional videos, ideally for educational programs or courses - A solid understanding of the psychology of career ch...
...for a detail-oriented freelancer to help us gather specific icons from and organize them into an Excel table. The icons are for various amenities that will be listed on a real estate website. Responsibilities: • Search for icons on that match the list of amenities provided. The premium version of Flaticon may be used. • Ensure each icon matches the style and aesthetic suitable for a modern real estate website (in the style as attached files). • Document each icon in an Excel table with two columns: Title and Classname. List of Amenities: • See attached file. Requirements: • Experience with and familiarity with downloading and organizing icons. • Proficiency in Excel. • Attention to detail...
I'm in need of meticulous and organized professional who can effectively manage data entry, document organization, and scheduling tasks. The scope of the project includes: - Streamlining data entry processes - Organizing and managing key documents, specifically financial statements - Handling a dynamic schedule effectively The ideal candidate should be proficient with Microsoft Excel and Google Suite (Docs, Sheets, Calendar). Your expertise will help us improve our administrative operations efficiently and effectively.
...identifying preventative strategies for falls among the elderly in their home environment. Ideal skills and experience for the job include: - Proven background in designing research protocols, particularly within the field of geriatrics or injury prevention. - Comprehensive knowledge of the root causes of falls among the elderly. - Ability to develop strategies that are not only preventative but also feasible to implement within a home environment. - Prior experience with geriatric and/or home-based research is a plus. - Strong analytical skills to identify common risk factors and propose evidence-based solutions. - Excellent communication skills to clearly articulate the protocol's objectives, methods, and expected outcomes. Key aspects that the rese...
I have an Excel file that needs to be formatted with some basic arithmetic formulas. Key Requirements: - I need the data in the cells to be formatted to phone number style. - Basic arithmetic formulas are required for this project. The level of statistical analysis you'd need to provide is basic, such as mean, median, or mode. Ideal Skills/Experience: - Proficiency in Excel and formulas is a must. - Experience with basic statistical analysis is preferred. Please get in touch with your credentials and prior work samples. Thank you.
I am looking for a freelancer to develop an AI chatbot model (NLP) that will be deployed on my website. Chatbot Features: ----------------- 1. AI model would be pre-trained on our existing chat dialog flow (questions & answers) and company documents 2. Customers should be able to enter their data through chat dialog flow (Already existing) and train this AI model 3. Model should have document input link which will be used in future to train the model 4. The model used should be able to call API's (Intent/actions functionality) in future (Not in scope of this project) You must have delivered similar LIVE project to be chosen.
I need a detailed spreadsheet of information taken from public meetings. The content I'm seeking to compile involves: - Date of the meeting - Detailed descriptions of action items that were voted on, including the specific amounts. In this assignment, precision, attention to detail, and understanding of meeting notes is crucial. Mastery of Excel and experience handling similar tasks is required. Familiarity with action items and the voting process in public meetings will be a plus.
I'm in need of a VBA script that can generate textual reports from Excel spreadsheets. Key Requirements: - The VBA script should focus on generating textual reports, without the need for incorporating charts or graphs. - The data source for the report generation will be Excel spreadsheets. Ideal Skills and Experience: - Proficiency in VBA coding and automation. - Strong understanding of Excel and its data manipulation capabilities. - Prior experience in report generation through VBA is highly preferable.
This is the variant table with these fields CREATE TABLE ( id varchar(255) NOT NULL DEFAULT uuid_generate_v4(), name_lang json NOT NULL DEFAULT '{}'::json, data_area varchar(255) NULL, description json NULL DEFAULT '{}'::json, "type" bit(1) NULL, active bool NULL, created_by varchar(128) NOT NUL...NULL DEFAULT now(), code varchar NULL, product_id varchar NULL, variants_data varchar NULL, long_description json NOT NULL DEFAULT '{}'::json, approved_by varchar NULL, web_image varchar NULL, mobile_image varchar NULL, CONSTRAINT sku_pk PRIMARY KEY (id) ); what we want is we need to pass the id of variant in the variant data table as variant and the id of data variant we need to pass it to sku id create CRUD APIS for three of th...
