How to use microsoft excel formulas jobs

I am in need of a freelancer who can create paginated Access reports. The job involves: - Using data from MS-Access to use in the report. - Converting the extracted data into paginated reports. - Very good knowledge of SQL. The perfect candidate will be proficient in manipulating SQL language and creating Access reports, with a keen eye for detail and a some understanding of sales data. Background in SQL language and Microsoft Access report is advantageous. Attached is a sample of the report I need the candidate to perform, but in much better format and with the correct information extracted for each column.

I am seeking a proficient developer who can create a comprehensive system using O365 MS Forms...Creating a form using O365 MS Forms that incorporates more than 20 questions, all requiring text input. - Integrating Microsoft Lists to store the responses from the form, including the list of questions and best practices. - Utilizing Power Automate to fully automate the process and generate a MS Word report. Key skills required include: - Excellent proficiency in O365 MS Forms - Experience using Power Automate - Knowledge on integrating Microsoft Lists - Ability to work with MS Word report templates, as a specified layout will be provided. This project requires a developer with a keen attention to detail, excellent technical abilities an...

Looking for a skilled freelancer to efficiently transfer 500 questions from Microsoft Word to an Excel spreadsheet. This task requires precision and attention to detail. If you have experience with data entry and are proficient in both Word and Excel, we'd like to hear from you. This is a straightforward project with clear instructions, offering flexibility and a competitive rate. Join our team and help us streamline our data management process.

I'm in need of a freelancer who has a vast list of verified dentist emails. This list should include the individual's name, company name, city, email address, and phone number. My main goal for this project is to utilize this list for a national level marketing outreach. Ideal Skills and Experience: - Proven experience in Email List Building, particularly in the dental industry. - Strong attention to detail to ensure the validity and quality of the email list. - Ability to work efficiently and deliver the list in an Excel spreadsheet format. Please only apply if you have a pre-existing, substantial list of dentist emails. The quality of the contacts is crucial for the success of my marketing campaign.

...web developer who will build a custom website tailored to my specifications. The project will involve creating an informational website incorporating several features. Here are the specifics: Custom Functionality: • Informational pages - The backbone and main focus of my site. Site Features: • About Us section - This will provide visitors with a comprehensive view of what my business is about. • Team Bios - I want a section where information about the people behind the business can be displayed. • FAQ - A section that will detail answers to frequently asked questions will be required. Ideal Skills and Experience: For this project, you should excel in custom-built web development, have an understanding of infopages design, and be able to...

My project requires accurate typing of a typed page into a Microsoft Word document. It's necessary to have prior typing experience services to take on this project. Essentials to note: - The text should be typed in a standard format which is easy to follow - The font of choice should be Times New Roman, size 12 A sharp eye for spelling errors and ability to maintain formatting consistency. 8x11.5 typed page NOT in landscape view. Proven experience with MS Word is beneficial and will be preferred.

I'm currently working with two Excel sheets for inventory data. I need help with applying VLOOKUP functions to these sheets. I need the correct formula to lookup the Sheet 1 Column A data, in Sheet 2 Column B, and apply Sheet 2 Column B data in Sheet 1 Column B - please see attached. Key Requirements: - Understand and implement VLOOKUP formula to connect data between the two sheets. - Ensure the VLOOKUP function is working correctly and efficiently. Ideal Skills and Experience: - Proficiency in Excel functions, particularly VLOOKUP. - Prior experience working with Inventory data is a plus. - Attention to detail and accuracy in data manipulation. Please reach out if you're confident in your Excel skills and can assist with t...

I'm in need of a skilled IT professional to help with my Outlook email exchange. Specifically, I require: - The implementation of DMARC to my Microsoft 365 account. - Guidance on domain registration and setup. I'm currently not sure about my domain registration status and would appreciate help understanding and potentially setting this up. Ideally, I'm looking for individuals who not only have a deep understanding of Microsoft 365, DMARC, and Outlook email exchange but also have experience assisting less tech-savvy individuals in navigating the process. Your communication skills and ability to explain complex IT procedures simply would be highly valuable in this project.

...converting various Excel, Word, and PDF documents, making up a total of 32 pages, into a comprehensive and printable directory. Here's what would make you a great fit for this: - Proficiency in data entry and conversion between formats. - Strong skills in Excel, Word, and creating PDFs. - Experience in building and formatting directories. - A track record of delivering high-quality, print-ready documents. Key Tasks Include: - Collation and organization of information from different files. - Conversion of these files into a uniform, printable PDF. - Quality checks to ensure formatting remains consistent and ready for print. Please bear in mind, the final directory is not intended to be searchable. It should be built and formatted for printing while en...

I require a proficient expert to devise a comprehensive assessment test targeting advanced skills on Microsoft Office's Word, Excel, and PowerPoint. The objective of this sophisticated test will be to gauge the advanced proficiency level of test-takers, with expected deliverables including: - Word proficiency: Ability to create and format advanced documents. - Excel proficiency: Demonstrate potent data analysis and reporting skills. - PowerPoint proficiency: Proficiency in creating and designing effective presentation layouts. The ideal freelancer for this job will be an expert in Microsoft Office Suite, with solid experience in creating similar tests or training materials. Familiarity with modern educational standards and requirement...

I require a professional with a meticulous eye for detail and proficiency in spreadsheet tools, such as Excel, to handle my data entry project. The data, which needs to be manually inputted, will be derived from scanned documents. Your role will primarily involve re-typing the content into neat and orderly spreadsheets. Ideal skills that you must possess include: - Speed and accuracy in typing - Proficiency in data entry and management - A keen eye for spotting errors or inconsistencies - Familiarity with spreadsheet tools like Excel - Ability to handle confidential information if it arises Your previous experience with similar projects will be a definite advantage. Kindly ensure you include it in your proposal. Please also highlight your availability...

...need of a creative illustrator with a knack for abstract design who can bring my unusual concept to life. The task involves crafting a unique image of an omega man swinging a cricket bat, with a mosquito/fly at the end of the bat being squished. - I'm looking for an abstract style, so creative, out-of-the-box thinking is crucial. - The illustration is intended for personal use, so it should be exclusive and tailored for this purpose. - A bright and vibrant color scheme is preferred to make the image pop. Ideal Skills: - Strong background in illustration, with a portfolio that showcases abstract concepts. - Proficiency in using color to create visually striking and engaging designs. - Ability to understand and execute on a unique, tailored visua...

I need assistance with Excel, specifically with its worksheet formatting feature. My main goal is to create tables and charts to visually represent my financial data. The perfect freelancer for this job should have extensive experience in data visualization, especially when it comes to: Creating accurate formulas displaying in a clean manner

As an experienced graphics designer, I need your help to create PNG and Adobe Photoshop artworks strictly for print designs. These designs must align with the specifics in the artwork samples that will be provided. Experience with color matching is a prerequisite since the color scheme should strictly adhere to the provided samples. The sizes and dimensions for each design will be given in an attached excel file, and I require the artworks to follow these exact measurements. Bullet points: - Print design expertise - Excellent color matching skill - Ability to adhere to specific dimension requirements in artworks - Proficient in PNG and Adobe Photoshop Bid you price for all 6 designs together.

I'm seeking a freelancer with outstanding Excel skills to compile a comprehensive list for personal contacts. The required data for each contact includes: - Name - Address - Phone number It's essential to meticulously organize and enter the required data into the spreadsheet. Precise attention to detail is crucial to ensure no errors are made when adding the details. While there isn't a specific order for the data I will provide you with, I expect clear and uncluttered presentation will be kept as a consistent standard. The ideal freelancer should have: - Proven experience with data entry - Keen attention to detail - Excellent organizational skills - Proficient Skills in Microsoft Excel. If this sounds like ...

I'm looking for a skilled freelancer who can develop a comprehensive Excel dashboard for tracking financial performance. This will primarily involve creating charts and visual representations of the following data: - Sales Data - Expenses Data - Profit Data The main purpose of this dashboard is to facilitate easy tracking and visualization of our financial performance. Ideally, successful freelancers will have: - Relevant experience creating Excel dashboards for financial tracking - A deep understanding of accounting principles

Utilizing my knowledge of Excel and APIs, I need a freelancer to exceed Power Query's data size limitations. This is to compile a list of 266 pairs from Binance, which will be sent to you. The final output must: - Bypass Power Query's current limitation from 1000 to 2584. - Arrange the pairs in order of their price. Your solution will enable real-time updates of this data in Excel. It would be beneficial if you have previous experience managing API calls and dealing with large data sets in Excel. Proficiency in real-time data extraction and handling is also crucial. need it fast around 2 Hours not more then this, i had the excel to work on just make this on new sheet

...in need of a developer to help me transform the tables on my web platform into a downloadable Excel sheet. This needs to be done in a way that the Excel sheet maintains the same order and all data fields as seen on our website. Job requirements: - Extract all data fields from our websites data tables - Develop a downloadable Excel sheet functionality for each table - Ensure the data maintains the same order as on the website - Use PHP and Javascript languages Key details: - Users are expected to download updates on-demand - The Excel sheet should be styled to match the website's design I'm looking for a developer who is proficient in both PHP and Javascript and has prior experience working with similar data tr...

I need assistance with...facilitated by a dropdown menu. The specifics of my requirements are as follows: - Web Browser: The automation should be compatible with either Google Chrome or Microsoft Edge. - Handling Dynamic Elements: I am not positive about the need for the automation to handle dynamic web page elements. This will require some assessment or flexibility in the solution. The ideal freelancer for this project should have: - Proficiency in VB.Net or C# with Visual Studio 2017 or higher. - Experience with web page automation. - Knowledge of automating input through dropdown menus on web pages. - Familiarity with Google Chrome, Firefox or Microsoft Edge automation. I would appreciate the project being completed within a month, as I am on a defined timeline f...

...solution to fetch real-time stock prices from the National Stock Exchange (NSE). The fetched data should populate in an Excel spreadsheet and refresh every second. Key Responsibilities: - Scrutinize the dedicated NSE platform to fetch live stock prices - Develop a method to automate data update in Excel every second Mandatory Skills: - Proficiency in Excel, with particular emphasis on data extraction and automation - Knowledge and experience of the NSE online system - Familiarity with automatic data retrieval and real-time updating This project must maintain a high standard of accuracy, as any mistakes could lead to misinformed financial decisions. Hence, meticulousness in data management and understanding of stock market trading is...

I'm seeking assistance with a data cleanup project using MS Excel. - The task involves deleting specific rows and columns from spreadsheets. - The data to be removed should meet particular criteria, which I'll provide. - For rows, the criteria will be either empty cells or certain values. - As for columns, the criteria will be the same. No urgent deadline, so you can work at your convenience. Ideal skills for this job include: - Advanced proficiency in MS Excel - Strong understanding of data handling - Attention to detail - Experience in data cleansing in Excel Looking forward to working with a skilled and efficient Excel freelancer.

Set up MailWizz and run several tests to verify that bulk sending emails is working properly. The personalization of emails consists in include information extracted from the Excel file (MailWizz ) and insert it into the text of the email (MailWizz Test ) Likewise, the freelancer will teach how it works to be able to carry out the next campaigns autonomously. To do this, the freelancer will make a video tutorial.

...an Excel expert to help me create a dynamic visualization dashboard for health data. - The dashboard will focus on a range of health data - It will need to display specific and diverse health metrics such as age, type of therapy given, time periods, and mortality - so be able to calculate mortality, time periods, - Each individual's health record data will be detailed in a specific manner ie data will be entered as numeric code -Each patient will have about 20 data points Ideally graphs will have consistent coloring eg PD patients orange, HD = green etc- to allow for intuitive understanding The ideal freelancer for this project needs to have: - Proficiency in Excel, especially in creating dynamic and interactive dashboards. - E...

I'm seeking an experienced freelancer with expertise in Excel and data management. My project involves merging 5 sheets into one and matching up all of the data lines to be merged. Key Responsibilities: - Keeping the same layout as the source documents during the merging process. - Merging data from different documents in new columns in one sheet. Ideal Skills: - Proficiency in MS Excel and data manipulation. - Experience in creating and managing complex spreadsheets. - Attention to detail. Please provide examples of previous similar work in your proposal.

I'm in need of an experienced VBA Excel programmer for automation of repetitive tasks, creation of custom Excel functions, and assisting with data analysis and visualization. Key Responsibilities: - Develop and implement VBA automation for my repetitive tasks - Scripting and designing customized Excel functions - Contribute expertise to data analysis and visualization tasks. Ideal Skills and Experience: - Fluent with Excel Macros and VBA - Robust knowledge in data analysis and visual representation - Flexible to work with any version of Excel I'm looking for a completion timeline of within the next month.

...expert to help transform my Pdfs question catalog into a specific CSV format. The targeted CSV format is as follows: number;Filename;question;answer1;answer1correct;answer2;answer2correct;answer3;answer3correct;answer4;answer4correct. - Purpose: The purpose of this project, namely, is to make the data compatible with a specific system. - Assistance Required: Depending on the case, some data entries may need reformatting prior to transformation, ensuring they are structured correctly. - Data Type: The 'question' and 'answer' columns contain mixed data, both textual and numerical. Ideal Candidate Skills & Experience: - Experience in data manipulation and transformation using Excel and CSV formats. - Proficiency in data cleaning...

I have a set of printed documents that need to be converted into an excel file. The data primarily consists of text, and the excel sheet has 1-5 columns. Key Responsibilities: - Inputting data from printed documents accurately and efficiently into the excel sheet - Ensuring that the text data is correctly organized within the specified columns Ideal Skills and Experience: - Proficiency in typing and data entry - Experience with Excel or other spreadsheet software - Attention to detail and accuracy to prevent errors - Ability to handle and convert printed documents to digital format Your work will be essential in transforming this printed data into a digital, easily accessible and analyzable format.

I need professional help to accurately enter and organize text data in an Excel sheet. The text has to be arranged in alphabetical order. I'd also appreciate some expert input in making the document more readable with the appropriate font styles. Ideal Skills and Experience: - Proficiency in Microsoft Excel including formatting - High accuracy in data entry - An understanding of best practices when it comes to data organization - Strong attention to detail and ability to follow specific instructions Requirements: - Type text data into Excel Sheet - Organize data in alphabetical order - Apply appropriate font styles to improve readability.

...input them into Excel. The PDF files contain complex data layouts, including tables and images. Key Requirements: - Extract and organize the text, tables, and images from the PDF files into Excel - Maintain correct data alignment and structure - Apply basic Excel formatting, such as font styles, cell borders, and column width adjustments You are expected to: - Have experience with PDF to Excel conversions, particularly with complex layouts - Be proficient in handling searchable text PDFs - Demonstrate knowledge in basic Excel formatting techniques I'm looking for a freelancer who can efficiently convert these PDFs into Excel without compromising the data integrity and layout. If you have experience with similar projects and...

Keyword research with up to 1 alternative and corresponding search volume for the languages ENG, FRA, ITA and target markets England, Italy, France. Please enter the exact search volume, not from... to... as displayed by Google Ads Alternative can be an alternative spelling or a synonym. The subject areas are 'casting' and 'forge' Keyword 1 is the preferred keyword No 1:1 translations, it's about keywords, search intentions and not terminology. Keywords in the target language can also be longer or have a different order. The corresponding keyword in the target language may be missing. COMMENT: Please fill out the Excel file containing 157 Keywords Instructions can be found in the Excle file unter "Anleitung"

...employee based in the UK. I'm looking to have a Microsoft Access database built to help manage various aspects of my business. Ideal Skills and Experience: - Proficiency in Microsoft Access database development - Understanding of the commercial cleaning business operations - Knowledge of database design and implementation Key Features: - **Employee Database**: - Store employee contact information - Track employee work schedules - Monitor employee performance - Manage Payroll - **Client Databases**: - Store client contact information - Track client preferences for tailored services - Ability to generate client reports - **Alert System**: - Employee task reminders: to ensure tasks are completed on time - Client appoin...

...an individual dealing with financial data, I am in need of an expert who can perform a time series analysis on specific financial ratios. This task will be performed in Excel and will require expertise in: - Data manipulation - Forecasting techniques - Time series analysis, specifically with financial ratios The ideal candidate should have solid experience in forecasting and weighted moving average (WMA) methods. Due to the nature of the project, a background in finance or a related field would be advantageous. This job is best suited for individuals familiar and skilled with Excel operations, especially in relation to time series analysis. Proficiency in dealing with financial data is a paramount because the project focus is entirely on financial ratios...

As a beginner in Power BI, I need a proficient tutor to help me master all aspects of the tool including Data modeling, Creating visualizations and DAX formulas. I have various data sources such as Excel files, SQL databases and Web APIs which I'd like to connect with Power BI seamlessly. For this job, a deep understanding of Power BI and experience in teaching or tutoring are desired. Patience and ability to explain technical concepts to a newbie could be a good fit for the role. - Power BI mastery - Tutoring experience - Familiarity with Excel files, SQL databases and Web APIs - Patient and clear communication skills

I am seeking a skilled and detail-oriented Excel specialist to assist with data entry, data analysis, and formatting. Your job scope will require the following: - Accurate data entry into Excel. - Proficient use of SUM, AVERAGE, and COUNT Excel functions for detailed data analysis. - Knowledge in formatting Excel worksheets to ensure cohesiveness and professionalism. The purpose of this task is to effectively organize a large amount of data. The ideal candidate should have strong strategic thinking and problem-solving skills, as well as advanced Excel competencies within data organization. Previous experience in similar jobs will be a plus.

I need a skilled freelancer to copy and paste data from several websites into an Excel spreadsheet. Key Requirements: - Proficiency in data entry - Detail-oriented and precise - Familiarity with using spreadsheets Please deliver the data in the spreadsheet format. Let's discuss the specifics and get started on this project.

I need an advanced Excel spreadsheet created, compatible to both Windows and Mac. It will be used primarily for team collaboration, and should have the following key features: - Real-Time Editing: The ability for multiple team members to edit the sheet simultaneously, reflecting changes in real-time. - Task Highlighting: An in-built mechanism for highlighting overdue tasks, enabling focused teamwork and timely task completion. - Report Creation: A feature that allows the easy conversion of the sheet into plain text. The report should maintain much of the original formatting for clarity. - Task List: An organized task list creation feature, enabling team members to assign and keep track of tasks efficiently. The spreadsheet should also be editable as part of a ...

I'm in search of an Excel expert who can create a specific quotation formula for my window and door shop. The formula should: - Calculate per square meter cost - Incorporate various variables, including item price, quantity, discounts, profile price, glass price, mosquito net price, Extras, and installation - Categorize 'Extras' to include delivery and customization fees Ideal professionals for this project would have significant Excel experience, particularly with complex formula creation. Knowledge of cost calculation and financial modeling would be beneficial. Efficiency and attention to detail are key in this project.

I'm looking for a diligent data entry professional to assist with transferring text from various online sources into a structured spreadsheet format. Key Points: - The task involves pure text entry, requiring accuracy and attention to detail. - The data will be sourced from online content, so familiarity with the web and online research is preferred. - The final output should be a well-organized and error-free spreadsheet, most likely on platforms like Excel or Google Sheets. Ideal Candidates: - Proficient in data entry with a keen eye for detail. - Comfortable navigating online sources and extracting information. - Skilled in using spreadsheet software like Excel or Google Sheets. - Able to complete the task accurately and within the stipulated t...

I am looking for a data entry freelancer to transcribe handwritten notes into a spreadsheet. Key Responsibilities: - Accurately transcribe handwritten text into a spreadsheet format - Organize and format the data in a clear and structured manner Skills and Experience: - Proficient in data entry, especially from handwritten sources - Experience with spreadsheet software like Excel or Google Sheets - Attention to detail is crucial to ensure the accuracy of the transcription - Ability to work efficiently and deliver quality results within the agreed timeline. Please note that the data will be provided in handwritten notes, and must be transcribed into a spreadsheet.

We need to build a proof of concept to learn if a given tool will be useful for our company and implement in our packaging designing process. In order to do so I need a graphic designer with package design expertise. He/she must be well versed in Adobe Illustrator and its plugins. He/she'll have to work with Esko Dynamic Content: For more info on 'esko dynamic content check our their training on their last version: ) Job description: 1. Based on a Excel sheet containing translation to a package label saying, the designer will have to generate: a XML file containing the different language version to be applied on the package. The Excel sheet will contain 5 languages

I'm in need of an Excel wizard capable of constructing a precise, data-driven model specific to marketing data, as well as supply and demand. Key functionalities are to include: - Data Visualization: Proficiency in translating raw data into visual charts and graphs. Your work should result in a model that effectively communicates complex data in an easily digestible format for decision-making purposes. - Formula Calculations: You must be familiar with advanced Excel formula calculations to manipulate and compute data in ways that align with our specific market information. - Scenario Analysis: High proficiency in scenario analysis is key. Able to put together various ‘what-if’ scenarios in the Excel market model, taking i...

I am looking for skilled programmers who have the expertise in converting Excel VBA macro codes into a cloud-based solution that can be run on MS Azure. Key Requirements: - Conversion of Excel VBA macro focusing on data analysis - Development of a scalable and secure MS Azure-based solution Ideal Skills and Experience: - Proficient in Excel VBA and cloud technologies - Experience in migrating Excel VBA macros to cloud-based platforms, especially MS Azure - Strong understanding of data analysis and cloud security - Proven track record in developing scalable cloud solutions

...The main purpose of this brochure is to promote our product/service and highlight the key benefits. Ideal Skills and Experience: - Expertise in traditional graphic design - Proven experience in brochure design specifically for product promotion - Ability to translate value propositions and benefits of our product/service into engaging visual presentation - Detail-oriented with excellent visual storytelling abilities Key Project Requirements: - Design a brochure with a classic and traditional aesthetic. - The brochure must effectively promote our product/service. - The design must highlight the benefits of our product/service - Creation of deliverables should be done in a timely and organized manner. This is a fantastic opportunity for those who excel in creat...

I'm in need of an accountant to handle our company's financial tasks in Gurugram. The primary responsibilities would include bookkeeping, financial statement preparation, and tax filing. Key Responsibilities: - Regular monthly bookkeeping. - Preparation of monthly financial statements. - Timely and accurate tax filing. We currently use Excel spreadsheets for our accounting, so proficiency in spreadsheets is essential. Experience with QuickBooks and Xero would be a plus, as we might decide to transition to one of these platforms in the future. The ideal candidate would be detail-oriented, organized, and able to work efficiently to meet our monthly accounting deadlines. Experience with corporate accounting and regulations in Guru...

Making a Excel based data model (based on some raw tables), will have to make a similar version of existing data model (that will be shared) by the end of Thursday (11th April) i..e in 2/3 days Existing model attached! Currently I have excel with tables of information

...specializing in PDF editing. My project demands attention to detail and accuracy, making it a perfect opportunity for someone with advanced PDF manipulation skills. - **Tasks at Hand:** - Text modifications to ensure all content is current and relevant. - Formatting updates for a sleek, professional look. - Image adjustments: insertion or removal as necessary. - Rigorous calculations for accurate representation of financial data. - **Project Goals:** - Achieve impeccable accuracy in data and calculations. - Ensure all documents meet professional standards in design and readability. - **Skills Required:** - Proficiency in PDF editing tools (Adobe Acrobat, etc.). - Strong grasp of document design and formatting. - Expertise in Excel or Word for potential conversion...

I require a freelancer proficient in Microsoft PowerPoint and Word to create a digital document. Key Requirements: * Creation of a coherent document, integrating both textual content and images. * Application of personalized design elements like custom colors, fonts, and branding materials. The ideal freelancer for this project has a keen sense of design, with experience in document formatting—deploying custom colors, fonts, and logos. Mastery in manipulating both PowerPoint and Word to create engaging and visually compelling resources is vital. Your portfolio showcasing similar projects will increase your chances.

data entry freelancer who can prepare excel sheet

I am seeking a skilled and creative shoe designer to create a compelling sneaker design specifically for the young adults demographic. My intention is to make a cutting-edge fashion statement, making this project ideal for designers who excel in creating trendy and edgy designs. Key requirements include: - Extensive experience in sneaker design - Strong understanding of current fashion trends, especially towards young adults - Ability to communicate concept ideas effectively - A portfolio that showcases previous work in the fashion footwear sector. Coupling your creative flair with function and fashion, the design should appeal to its target age group, while still demonstrating durability and comfort.

...sSharepoint expert to help me resolve a 'Page not loading' error on my Sharepoint site. The error is as follows: Sorry, something went wrong One of the properties of the Web Part has an incorrect format. Microsoft SharePoint Foundation cannot deserialize the Web Part. Check the format of the properties and try again. I will give you access to the server via Anydesk. If possible can you fix this asap tonight for me. Specific Tasks: - Investigate and identify the root cause of the 'Page not loading' issue - Develop and implement a solution to fix the error Ideal Skills and Experience: - Proficient in Sharepoint site development and customization - Extensive experience in troubleshooting and resolving Sharepoint errors - Strong probl...