Excel interview questions jobs

I need an Excel macro to move records between two sheets in the same workbook. Here's the challenging part: records should be relocated based upon logical condition within a certain range of values in designated columns. Time isn't a constraint but proficiency in scripting Excel macros and strong grasp of logical functions is mandatory. Clean and efficient code is valuable. Understanding of data management in Excel is also desirable. Patience needed to iterate and perfect the code. Please apply if you meet these criteria.

...specifically Word & Excel, who can assist me in managing specific tasks. In Microsoft Word, the following tasks are needed: - Formatting Documents: Your skills should be top-notch in bringing out an excellent document format that is pleasing to the eyes and understandable. - Creating Templates: I need help in creating various templates for different types of documents. In Microsoft Excel, your tasks would include: - Data Analysis: I require someone with exceptional skills in analyzing data, to extract useful information that will guide my decisions. - Creating Formulas: You should be fluent in the use of various Excel formulas to facilitate swift and accurate calculations. The ideal candidate must have substantial experience in handling such tasks in Microso...

I'm looking for a skilled Excel professional to help create a spreadsheet that will serve as a route tracker for my delivery business. Key Requirements: - The primary purpose of the spreadsheet is to track the various routes that my delivery personnel drive. - I need the spreadsheet to detail the start and end points of each route, the distance traveled, and the time taken for each route. Skills and Experience: - Proficiency in Excel, particularly in creating complex but user-friendly spreadsheets. - Familiarity with data tracking and analysis, particularly in the context of logistics or similar fields, would be a significant advantage. - The ability to accurately incorporate the different data types and calculations required for route tracking.

i need 2 menus extracted from a webpage the most important columns (data points) will be category name product name, product price, product description. example: STARTERS - ONION BHAJI - 4.50 - Our own onion fritters with salad and sauce. Contains gluten. i have started the process for u to make life easier no time wasters if u do nice job i can give u more menus in the future

I am seeking an expert who can accurately and efficiently convert two PDF files with around 110 pages into an Excel document. The PDF contains data tables as low-resolution images. No data transformation is required, just a transcription. The successful freelancer should have: - Either AI software to automatize the conversion - Or transcription skills to the the labour manually - A high degree of accuracy is needed - The capability to finish the project in a timely manner Please ensure that your bid accurately reflects your ability to handle a large-scale transcription job like this. Attached you'll find an extract of the document due to size limitations. There are in total 106 pages of the same table.

I am in need of a well-crafted wedding speech. As the groom, my speech needs to capture the laughter, love, and sentiment of our relationship. The speech should include: - A humorous story from when we first met - A loving account of why I fell in love with my bride-to-be - A sentimental anecdote that captures our relationship's essence. An ideal candidate for this project would excel in creative writing, possess a strong understanding of tone and pacing, and have experience writing wedding speeches. The ability to balance humor, sentiment, and heartfelt words is crucial.

I have given Start time, Interval, End time in excel When i give start time(Ex:9:15), when that time reached E col data automatically copied in into G col, Next Interval is 10 Mins, When 9:25 reached E col data automatically copied in into H col, When 9:35 reached E col data automatically copied in into I col,When 9:45 reached E col data automatically copied in into J col, When 9:55 reached E col data automatically copied in into K col, When 10:05 reached E col data automatically copied in into L col, When 10:15 reached E col data automatically copied in into M col.(H col vale > G col, that cell is green, H col vale < G col, that cell is red, same process for all col) 9:15-9:25 is 1 10Mins during that time, how many time(count) E col value>G col value( Ascending not dece...

I'm seeking a proficient freelancer with an analytical mindset for my Excel project. You will be tasked with interpreting numerical data through pattern analysis. Key Responsibilities: - Data Conditioning: Your primary task will be to condition the numeric data in my Excel project. - Analysis and Interpretation: Execute pattern analysis on the conditioned data to decipher meaningful insights. Skills and Experience: - Proficiency in Excel numeric data handling - Strong experience in pattern analysis - Remarkable numerical competency - Excellent analytical skills If you have a knack for translating raw data into insightful findings, this project is for you. I look forward to your bids!

I seek a solution-oriented software developer to create a specialized software for my Windows system, which can apply multiple prediction models to an Excel sheet. Key Functions: - Incorporating various prediction models: This includes not only regression, classification, and clustering models, but also decision trees, neural networks, random forests, and support vectors. Ideal Candidate: - Expertise in developing Windows compatible software - Strong understanding of data prediction models - Knowledgeable in Excel functionalities - Ability to integrate sophisticated prediction algorithms The final outcome should be a user-friendly software that enhances my productivity by allowing me to apply versatile prediction models to my data effortlessly.

I have a massive inventory I need help with. I want to transfer the data from the website to an Excel spreadsheet. This involves both text and numeric data, which includes fields such as Vendor Name, Address, City, State, Zip, Dimensions, Country, Memo, and Remarks. Key Responsibilities: - Complete copying and pasting the required data from the website to the Excel spreadsheet - Maintaining the accuracy of the data - Ensuring the data is organized properly in the spreadsheet You should have: - Proficiency in Excel - Experience in data entry - Attention to detail - Good organizational skills - Ability to follow instructions accurately If you have a good internet connection, a reliable computer, and a decent amount of time to spare, this task is right for you. Please...

I a...of a skilled software developer who can convert a set of questions into a specific format in a word file. - Desired Format: The questions need to be converted into a multiple-choice format. - Answer Display: The answer choices need to be displayed below each question. - Styling and Formatting: Each question should be numbered and the answer options should be formatted with letters. Ideal skills for this project include: - Strong knowledge and experience in software development - Proficient in Microsoft Word formatting - Attention to detail and precision - Ability to follow specific formatting guidelines - Excellent communication skills to ensure the final product meets all requirements Please let me know if you have any questions or if you think you're th...

...who have already implemented hundreds of Elementor only pages. Also we do not require the mates, who do all things in CSS instead in Elementor. CSS is a last path for us, if Elementor integrated solution will not work. So if you are such a CSS guy, this job is also not the right one for you. If you are a manager or sales persons and not the Elementor developer, you will fail in the interview, since the interview will be on detailed technical level. And be aware - we had already a lot of interviews - and ALL sales or manager person failed them. The only person who will proceed are the Elementor developers themself. In addition to Elementor pro expertise, I'm also looking for someone with experience setting up and implementing Advanced Custom Fields Pro (ACF Pro), a...

Hi I will do excel job as we have discussed

I need a fully bilingual professional (I will interview in English) to do some tasks for my agency such as: PR Outreach Content editing or creating CRM management Email marketing Email scraping Researching Organizing data in spreadsheets Copywriting Wordpress And others You must be a fast learner, attentive, curious, with great writing skills. Looking for someone that pays attention and doesn’t keep making the same mistakes. This job will start part-time as a test period, after that it will be full-time. Payment for part-time during trial period: Fee: 250 USD Performance bonus: 50 USD Results bonus: 50 USD If your work complies with my quality requirements and you give more than asked, you’ll get performance and results bonuses each month. After a two-month...

I need a simple calculator with basic mathematical operations - addition, subtraction, multiplication and division. This calculator should be designed to be clean and minimalist, fitting in with the look of my site. Key Requirements: - Develop a simple calculator from scratch using HTML, CSS and JavaScript - Implement the calcu...project - Design aesthetics are important, so the calculator should be minimalist and clean - The calculator must be fully functional with the above-mentioned operations. Ideal Freelancer: - Proficient in HTML, CSS and JavaScript - Experience with designing and integrating widgets into websites - Able to ensure cross-browser compatibility for a seamless user experience If you have any further questions, feel free to ask and I'll be happy to provid...

I am in search of a professional who can help troubleshoot my website's current HTTP ERROR 500 issue. The error occurs when loading pages on the site, and it is affecting the site in its entirety. I have identified a recent server configuration change, which seems to be the culprit. Key Requirements: - Expertise in troubleshooting and resolving HTTP ERROR 5...troubleshooting and resolving HTTP ERROR 500 - Understanding of server configuration and its impact on website performance - Experience with website maintenance and issue diagnosis Your responsibility will be to identify the root cause of the issue, likely related to the server configuration change, and to implement a fix that will resolve it. Feel free to reach out if you have any further questions or require addition...

Good afternoon, I am a University Professor of Psychology and I have a project funded by FCT in the field of criminology. I would like to develop software (which I have partially programmed in Excel already). This software aims to: 1) work with dichotomous variables that are temporally distinct (for example, at 3 or 4 fixed and different times); 2) map all the sequences that appear in the sample more often than expected by chance, i.e., more than the upper CI of the multiplication of their individual probabilities (each variable at each time would generate a different sequence), and then assess each sequence's probability of predicting a dichotomous event, calculated via ORs. From the list of variables that appeared first in time, let's say, the first assessment was at ag...

I'm currently in need of a dedicated professional who can build a machine that focuses on strictly manipulating and controlling small volumes of liquid, less than 100mL. The machine should be designed to provide good accuracy and consistency in liquid volume control. Here's what I'm seeking: - No preference for mater...upto 6 liquid sources w/o human interventions during the process. - Control the device from a mobile app. - Keep the size of the machine smaller than 40cm (w) , 60cm (H), 40cm (D). - Keep the cost of manufacture below US$100. - Delivery: The completed apparatus should be reliable, durable, and easy to operate. A user manual or guide would be beneficial. Please make sure to include any relevant questions about the project in your bid. Looking forward ...

Good afternoon, I am a University Professor of Psychology and I have a project funded by FCT in the field of criminology. I would like to develop software (which I have partially programmed in Excel already). This software aims to: 1) work with dichotomous variables that are temporally distinct (for example, at 3 or 4 fixed and different times); 2) map all the sequences that appear in the sample more often than expected by chance, i.e., more than the upper CI of the multiplication of their individual probabilities (each variable at each time would generate a different sequence), and then assess each sequence's probability of predicting a dichotomous event, calculated via ORs. From the list of variables that appeared first in time, let's say, the first assessment was at a...

...interfaces should be seamlessly connected to a SQLite database. This involves ensuring proper data transfer, retrieval, and storage. ** There is a note to be considered there are a survey pages the user answers the questions and then the application make a schedule based on these answers and the user preferences . Then the data should be passed to the plan page and create the schedule Here is the interfaces ( you need to work only on these interfaces) The survay pages : TripName, ChooseDestination, Survay, Survay2, PreparingTrip The plane page: when the user answers the questions the program make a schedule based on these answers and the user preferences. The home page: contains information of specific restaurant The edit attraction pages : Manage Attractions,Ma...

Seeking experienced PHP developer to modify our site, to suit our needs. There are several modifations that need done. You MUST be ONLY working on our project. If you have other projects going on at the same time then this is not the right fit. We want ONE individual to make changes and NOT an agency. This site is FARMART Shopping cart softwar...by Botble. It is written with Laravel in plug in format, so you must have experience with this type of code structure before the project is awarded. Once awarded milestone for the first days fixes will be activated, and payment will be released once the modification is live on our site verified to be working. You can check out the sample code here: If you have questions and or you are ready to start, please ping me now.

Please Sign Up or Login to see details.

I have code for login trading accound and fetch token data. I need to update code to my system. I need to collect live data from the web and candle stick, Mins Intervals are in Dropdown box, I can choose any minutes interval, I need you to collect Last 5 candle data from the Excel in the web and other details for each token, I will give token name in the excel, It will automatically display the rows of data. If i chanage time interval it will display those data only. Note: I dont know about coding, If you install the code and run successfully at my system thereafter I will hire you and release the payment. If you agree this term you will apply this task Budet is 600 INR and Good review, Dont expect more I am not big fish. it is difficult job dont come for Money you should ...

I'm in need of an expert in Power BI to create a real-time monitoring dashboard for me. Key requirements: - The dashboard should connect to multiple Excel spreadsheets. - It should be set to automatically refresh its data in real-time. I'm looking for a freelancer with: - Prior experience with Power BI, particularly in creating monitoring dashboards. - Proficiency in handling real-time data connections. - Strong understanding of Excel data sources. Please share your relevant experience in your proposal. Thank you.

I'm looking for a talented individual who can work remotely on a regular basis to improve the user experience of my website. Within the United States of America ?? only ..! Key responsibilities include: - Analyzing the current user journey - Identifying areas for improvement - Implementing changes to enhance user experience To excel in this role, you should have: - Proven experience in UX and UI design - An understanding of web design principles - Strong analytical skills - A creative mindset - Excellent communication abilities This is a remote role and the work can be done from the comfort of your home. If you're looking for a flexible, engaging project that allows you to make a tangible impact on a website, then this is a perfect opportunity for you.

Please Sign Up or Login to see details.

Hello, I am currently seeking a skilled freelancer experienced in Amazon Connect to assist with an important integration project. My business provides appointment management solutions, and we are ...webhook integrations. - A portfolio or examples of similar projects completed. **What I Need From You:** - Confirmation of your experience with Amazon Connect. - Any specific examples of similar integrations you have done in the past. - Your approach to ensuring a seamless and efficient integration. - Estimated timeline and cost for the project. Please respond with your detailed approach and any questions you might have about the project. I am looking forward to collaborating with a knowledgeable and dedicated professional who can help us improve our client communication system. Bes...

I have a detailed list of 45 requirements that need to be implemented into an Excel report. The primary goal of this report is data analysis. Key Responsibilities: - Implement 45 requirements into an Excel report - Ensure all requirements are met accurately - Optimize the report for effective data analysis The ideal candidate should have: - Proficiency in Python - Experience working with Excel - Strong understanding of data analysis - Proficiency in Pandas and NumPy If you have experience with similar projects and are confident in your ability to provide thorough, accurate work, please submit your proposal.

I'm looking for a knowledgeable freelancer with solid experience in MS Access 2016 and Excel. Key Components: - MS Access programming: The successful candidate must be comfortable building databases on MS Access 2016. This project will specifically focus on managing customer information. - Excel integration: Expertise in linking data between Access and Excel is crucial. You'll be expected to establish a seamless and functional link between the MS Access database (housing the customer information) and Excel. Ideal skills and experience: - Proficiency with MS Access 2016 - Proficiency with MS Excel - Experience in handling customer data - Expertise in data linking between MS Access and Excel - Strong data management skills ...

I urgently need a proficient Excel specialist to assist with the creation and formatting of spreadsheets. Key responsibilities include: - Spreadsheet Creation: Develop new Excel sheets to efficiently manage data. - Data Cleaning and Formatting: Ensure that entered data is accurate, organized, and as per a specific format for easy understanding. Your meticulous attention to detail and expertise in Excel data entry will be critical in this role. The volume of data to be handled is unclear at this moment, as this aspect was not specified. Please prepare to handle both small and large batches of data. This project is time-sensitive and completion at the earliest would be appreciated.

I have a detailed list of 45 requirements that need to be implemented into an Excel report. The primary goal of this report is data analysis. Key Responsibilities: - Implement 45 requirements into an Excel report - Ensure all requirements are met accurately - Optimize the report for effective data analysis The ideal candidate should have: - Proficiency in Python - Experience working with Excel - Strong understanding of data analysis - Proficiency in Pandas and NumPy If you have experience with similar projects and are confident in your ability to provide thorough, accurate work, please submit your proposal.

anatomy questions in q bank form

...for a web development interview, with a focus on JavaScript. I need someone who understands JavaScript concepts deeply, knows recent industry trends, and can guide me through common interview questions and solutions. **Responsibilities:** 1. Assess my current knowledge and skill level in JavaScript thoroughly. 2. Create a personalized learning plan tailored to my strengths and areas needing improvement. 3. Provide practical guidance and real-world examples to refresh and deepen my understanding of JavaScript concepts, covering: - Data types and variables - Functions and scope - Object-oriented programming - DOM manipulation - Asynchronous JavaScript (Promises, async/await) - ES6+ features - Error handling 4. Prepare me for common interview...

I am looking for an expert in Microsoft Excel to develop a tool to track changes between two Excel sheets. Key requirements include: - The ability to identify and track both text and numeric data changes between two sheets. - The tool should not only monitor existing data, but also be built to manage changes related to data newly added in future. - Changes identified need to be grouped and clearly displayed in a separate tab within the same workbook for ease of review. Skills and Experience: - Proficient in Microsoft Excel - Background in data analysis - Experience in creating custom Excel tools - Strong attention to detail in order to identify both major and minor changes in data.

I am in need of a competent networking engineer with a background in C/C++ to help me design and implement a fresh networking solution. I need someone who can code our algorithm in computer network. The aim is to display the company/lab network infrastructure using the provided connections and device details Excel sheet, so the goal is to build a C/C++ code that displays a layer-2 diagram which represents all types of connectivity within the lab.

I have a data entry project that requires manual entry from physical documents into Excel. Specifically, I need you to: - Accurately transcribe the data from physical documents into Excel - Include custom charts and graphical representations to visually communicate the data. Ideal skills for this project include: - Proficiency in Excel, especially in data entry and creating visual representations - Attention to detail for accurate transcription of data from physical documents to digital format. Your work should not only be precise in data entry but also visually appealing and easy to comprehend, with the use of appropriate charts and graphical representations.

I'm seeking a proficient data scraper to extract text content from a targeted website. Ideal Skills - * Expertise in web scraping technologies * Keen attention to detail to ensure d...proficient data scraper to extract text content from a targeted website. Ideal Skills - * Expertise in web scraping technologies * Keen attention to detail to ensure data accuracy * Strong communication skills to understand my specific needs. Unfortunately, I neglected to specify how I would like the data to be formatted, so please ensure you can offer several options such as CSV, JSON, and Excel files. I didn't provide a timeline as well, however, we can discuss about your availability and agree on a flexible deadline. Kindly submit your proposal with relevant experience and estimated...

I'm seeking a skilled personal assistant to support my dual role as an orthodontist and ent...business. Strong organizational skills to manage various tasks efficiently. Excellent communication abilities for handling correspondence and coordination with multiple stakeholders. Financial diligence with a keen eye for invoicing and payment processes. Technical aptitude with project management platforms and instant messaging for streamlined task management. Time Management: The assistant must excel at prioritizing and managing a diverse task load within tight deadlines. Adaptability: Ready to handle diverse tasks and adapt to new challenges as they arise in a dynamic work environment. Confidentiality: Must maintain the highest level of discretion with sensitive patient and busine...

I require professional assistance with data entry. More specifically, the task involves typing information from digital documents, such as PDFs, Word files, and Excel spreadsheets, into an Excel spreadsheet. The ideal freelancer for this job is proficient in data entry and is highly skilled in using Excel.-Accuracy and attention to detail are key skills that would make this project a success.

I'm seeking a skilled personal assistant to support my dual role as an orthodontist and ent...business. Strong organizational skills to manage various tasks efficiently. Excellent communication abilities for handling correspondence and coordination with multiple stakeholders. Financial diligence with a keen eye for invoicing and payment processes. Technical aptitude with project management platforms and instant messaging for streamlined task management. Time Management: The assistant must excel at prioritizing and managing a diverse task load within tight deadlines. Adaptability: Ready to handle diverse tasks and adapt to new challenges as they arise in a dynamic work environment. Confidentiality: Must maintain the highest level of discretion with sensitive patient and busine...

I am seeking a competent web crawling specialist who can efficiently extract text content from a specific website's news updates. Here’s what I require: • Extract information from news updates within the target website. • Save the extracted data in Excel format. • Deliver clean, organized, and structured data. Ideal skills and experience: • Expertise in web crawling and scraping tools. • Previous experience working with news or media websites. • Proficiency in data extraction and Excel. • Strong attention to details. I appreciate a freelancer who can show some examples of their previous data extraction projects, especially in a news context.

I'm in need of an Excel expert to Create Macros. I have two spreadsheets. On each spreadsheet i have an input form. When the form has been entered and the user clicks "Enter Asset" each of the filled out cells (as per the File - "Template Code Functions") should be transferred to the "Data Collection Spreadsheet". Just enter into the next unused row. When the asset has been added successfully the cells marked as "Yes" as per the "template code functions" for "Reset on data entry" shall be empty on the input form. There are two spreadsheets, they are slightly different from each other.

Looking for someone can do screensharing with me and provide guidance and explain processes on FICO related questions/issues especially in EBS and lockbox related tickets. Currently have some EBS scenarios need to troubleshoot, we have several issues with it. We are looking to "upgrade" lockbox process. Project Description: SAP FICO Support with Expertise in Banking/EBS/Lockbox Skills and Experience Required: - Extensive experience and expertise in SAP FICO module including support and multiple implementation including S/4 - Expert in EBS and lockbox in terms of support and implementation for payment heavy company

I need a professional to create an advanced Excel-based sales forecasting model. This model will integrate data on sales volume, revenue, and customer demographics, across various time periods - monthly, quarterly, and yearly. Key requirements: - Incorporate Sales Volume, Revenue, and Customer Demographics - Develop the model for Monthly, Quarterly, and Yearly forecasting - Integrate and track Gross Profit Margin, Conversion Rate, and Average Order Value as key metrics Ideal Skills & Experience: - Advanced Excel Proficiency - Proven track record in Sales Forecasting - Experience with Power BI for data visualization - Strong understanding of Gross Profit Margin, Conversion Rate, and Average Order Value in a sales context This project is crucial to our business planning...

I need a comprehensive statistical analysis ...my survey data using descriptive statistics, and I'd like the results presented in visually engaging charts and graphs. Your main tool for this should be Microsoft Excel. Key Responsibilities: - Perform a detailed descriptive statistical analysis of my survey data. - Translate the findings into easy-to-understand charts and graphs. - Ensure all the visualizations are created using Microsoft Excel. Ideal Skills and Experience: - Proficiency in statistical analysis, particularly in descriptive statistics. - Strong experience in creating visual representations of data through charts and graphs. - Expertise in using Microsoft Excel for data visualization. - Ability to present complex statistical information in a clear a...

I need a skilled Excel expert to create a comprehensive spreadsheet and optimize its formulas and functions. The project needs to be completed within a month. Key Tasks: - **Spreadsheet Creation**: The successful freelancer will be responsible for creating a detailed spreadsheet that will serve as a part search tool. - **Formula and Function Optimization**: I need assistance in optimizing the formulas and functions within the spreadsheet. This is to ensure the tool is efficient, accurate and user-friendly. I would like to have a new parts search screen made up similar to the one attached ( Storeroom Parts Locator. ) but using the attached excel sheet (inventory Report) Nice UI on front page would be great! should be able to search for description and or part number. re...

About the Role: A renowned leader in digital security is actively seeking a skilled Golang Developer for a contract role focused on developing a Golang agent for SSL certificate management, which will interface with a PHP API. This opportunity is ideal for back-end development professionals who excel in automation, system operations, and delivering high-quality outcomes in a remote environment. Project Overview: As a Golang Developer, you will be instrumental in: - Developing a Golang agent to manage SSL certificate lifecycles, interfacing with a PHP API. - Implementing features such as system monitoring, logging, and robust error handling. - Performing thorough testing and optimizations to ensure system reliability and efficiency. - Collaborating with remote teams to ensure seaml...

I require a comprehensive business proposal, business plan and digital flyer for my ecommerce startup, mainly for the purpose of enticing potential investors. This should include: - A detailed description of initiatives and the target market, based on specifics that will be provided. - Revenue projections and financials, forming an essential part of the p...part of the proposal, which will encompass sales projections, cost forecasts, and a break-even analysis. This project involves a onetime event, hence, an understanding of what gets investors interested is vital. As we progress, I will provide all necessary basic details pertaining to my startup. Since my time is limited, I highly anticipate to work with a professional who can ask the right questions to capture all required in...

Hello. We are hosting our own remote support software similar to TeamViewer called ConnectWise Control. This is hosted on our own servers, and we have this built into our software so that customers can just click one button to create the support sessions which then a customer support staff can connect to the computer. We have now updated this software, and we need to make some adjustments t...velopers/Session_Manager_API_Reference We will need is a small sample software (In C#) that connects to our server and create a support session. The software should connect to our servers and create the support session with the computer name where the software is run. We also have a similar sample software that connects to our old server if that could be of any help. Just ask if there is any ques...

Need an accounting and valuation expert with good excel skills.