How to use microsoft excel formulas jobs

I'm in need of a comprehensive Business Evaluation report. This report is meant to serve as an evaluation of a company's performance. - Contents: The report should include the following sections; - Executive Summary: A summarized version of the main findings. - Company Description: A detailed account of the company under evaluation. - Industry Analysis: A comparison of the company's performance within its industry. The ideal freelancer for this task would have substantial experience in business report writing and the ability to present data in a clear, readable manner. Expertise in Microsoft Word is a must. A deep understanding of industry analysis and company description is also desirable.

I have bank statements from Bank A that I need converted into an Excel spreadsheet. The specific transactions you'll be dealing with are both deposits and withdrawals. Here's what I need: - A thorough and meticulous translation of each individual transaction: both deposits and withdrawals. - Once this data is entered into the spreadsheet, I need you to sort it by transaction type. This role requires expertise in Excel and a keen eye for detail is essential, as the integrity of the data will be paramount. Knowledge about financial transactions, specifically deposits and withdrawals, will be useful. A background in bookkeeping or accounting will also be a plus.

...adept at enhancing and editing pictures. The pictures I need to be edited are meant for personal use, and they are a of a father and son. Key Requirements: - Color Correction - Retouching - Background Removal - The pictures should be edited in a natural and realistic style. I'm looking to work with a professional who can make these pictures even more special. Ideal Skills and Experience: - Proven experience in picture editing, especially for personal use - Ability to deliver clean, natural and realistic editing - Attention to detail - Strong communication skills, as we may need to discuss the editing direction. Please provide examples of your previous work, especially if you've edited family or portrait pictures before. I...

I'm seeking an experienced developer to create an online script that can automate the conversion of CSV files. Script must be browser based and linux based. No preference on programming language. Source file will need to be uploaded to CSV converter, and script will sort data and rename columns based of pre-existing requirements. Once conversion is finished, download link generated to download updated CSV.

I'm seeking a seasoned Excel VBA developer to create a script that will regularly manipulate data within my Excel sheets. I have vba code run each 5 hours to export my excel sheets as pdf photos, but the problem here is my pdf photo sometimes not shown correctly, and sometimes its shows correctly. here is my vba code: For i = 1 To 57 '54 ' = False sheetxx(i).Select (Now + TimeValue("0:00:05")) ' "({1068})", True 'DoEvents pdffilename = fname2 & "" & sheetxx(i).Name & ".pdf" jpegfilename = fname2 & "" & sheetxx(i).Name & ".jpg" Shell ("D:khalid savescreenshot " & jpegfilename) ' (Now + ...

I need assistance with a simple Excel data entry task. This job purely consists of data entry and doesn't require any form of data analysis. The data I need entered includes names and addresses. Ideal Skills: - Proficiency in Excel - Attention to detail - Experience with data entry

I need a professional with excellent data entry skills to assist in cleaning and refining my existing data sets. The data is currently in Excel format, and I want it to be more organized and polished. Skills and Experience: - Proven data entry skills - Proficiency in Excel - Experience with data cleaning and refinement - Attention to detail Tasks to be completed: - Review the current data sets - Remove any inaccuracies or errors - Reorganize the data if needed - Ensure all data follows a consistent format The ideal candidate is someone with a keen eye for detail and the ability to handle large amounts of data efficiently. I expect prompt delivery and utmost accuracy in the task. If that's you, place your bid now!

I need a Python script that will help automate various tasks. Key tasks for this automation include: - File Management: the script should enable the organized handling of Word documents and Excel spreadsheets. - Data Entry: automation for data entry tasks. - Email Sending: automation for sending emails. The ideal candidate for this job should have: - Strong experience with Python scripting and automation. - Understanding of file management concepts and libraries in Python. - Ability to implement automated data entry and email sending functionalities. Looking forward to finding a professional who can deliver efficient, clean code for this project.

Hi Roman, If you remember, last year you did a project for me to show the list of participants of an event to me. I want to improve on that code and add some functionality and features to it. Would you be available? We can chat about the details, but basically, this is what I want: I have an Excel file with different sheets. For example, Founders, Advisors, Announcements, and Media. I want a code similar to the previous code (of course, more complicated) to read this Excel file and show the content of each sheet in a different format (as the amount of type of information is different). I will share an example of the Excel file with you. Are you available?

I'm seeking a talented developer with a solid understanding of Excel VBA and Python to develop a system that generates and runs Python code via a manual button within Excel. The Python code generated should have the capability to work with financial data specifically. Linguistic proficiency in Excel VBA and Python is required; knowledge in XLwings or a similar tool would be a significant advantage.

The website is designed primarily to serve as an informative platform about our services and broadcasting experience in the Free To Air sector. Information that needs to be conveyed on the website: 1. Detailed overview of the services we offer, outlining how we excel in the market. 2. Showcase our extensive experience in the field, driving confidence in our capabilities. The site will be mainly aimed towards potential clients and Free To Air broadcasters who are looking for reliable broadcast service providers. Ideal freelancers for this job should have proficiency in web design with experience developing informational websites for service-based businesses. Understanding of the broadcasting or related sector would be an advantageous, but not ...

I'm seeking to bring a remote administrative assistant on board for more than 20 hours a week to help me with various tasks. The ideal candidate should be proficient in Microsoft Office Suite and CRM software. Key Responsibilities: - Email Management: You'll be responsible for sorting, responding to, and organizing my emails. - Calendar Management: You'll be in charge of arranging meetings, appointments, and keeping my schedule up to date. - Data Entry: You'll assist in inputting and managing data. - Phone Calls: You'll also be expected to handle incoming calls and messages professionally. The successful candidate will have excellent communication skills and be able to work independently. Experience with Micr...

...need a skilled Wordpress expert to address a migration issue I'm facing with my website. Here's what I need: - **Migration Issue:** The problem I'm experiencing is related to theme and plugin compatibility following the migration from a server running PHP 7.2.4 where the site worked to a server running PHP 8.2. The front end of the site works but now access to the back end gives the error "There has been a critical error on this website. Learn more about troubleshooting WordPress." I need someone to correct the code so that it works correctly. I believe that the issue may be connected to WPBakery To excel in this project, you should be highly experienced in Wordpress, with a deep understanding of PHP...

I'm in need of a diligent and reliable virtual assistant to assist me with a range of tasks. Here's an overview of the key responsibilities and requirements: - Data Entry: The ideal candidate will be comfortable handling medium volume data entry tasks. This may include various forms of data manipulation, collection, and input. - Email Management: You'll be responsible for managing my email inbox. This includes reading, responding, and flagging important messages for my attention. - Appointment Scheduling: The role will also involve coordinating my schedule and setting up appointments. To excel in this role, you should have experience with: - Microsoft Office Suite, including Word, Excel, and PowerPoint. - CRM Software: Knowledge of Cu...

...professional who can create a business continuity plan (BCP) and IT policy for a financial and asset management company based in ADGM (Abu Dhabi Global Market). Key Deliverables: - BCP: The plan should cover data protection, disaster recovery, and network security. It needs to be tailored to a small business with less than 50 employees. - IT Policy: I require a thorough IT policy that aligns with best practices and the specific needs of my firm. Key Considerations: - My firm currently has 7 employees using Microsoft 365. There are basic existing IT infrastructure or policies in place. Hence, the BCP and IT policy should be designed from scratch. Ideal Skills: - Experience in creating BCPs and IT policies for financial companies. - Knowledge of data protection, di...

...the invoice to include a summary of the total income generated over the year. The summary should be kept simple and straightforward with a total sum, without the need for categorization or a monthly breakdown. Ideal Skills: - Strong attention to detail: The invoice should be well laid out and error-free. - Graphic Design: Experience in adding logos and making documents look professional is a plus. - Familiarity with accounting and invoicing: Some knowledge of these areas will be beneficial for understanding the context and importance of the data being presented. Please note that I don't need any interactive elements such as clickable links or formulas. The main focus here is on turning the raw billing data into a clear, professional invoice. You're go...

I am in need of a skilled engineer, with expertise in both Microsoft Power Automation and SharePoint. The main task will be the automation of email notifications. Ideal Skills: - Microsoft Power Automation - SharePoint - Experience in automating email notifications There's no rush on project completion, quality is key here and I'm flexible on the timeline. Please ensure you've the relevant experience before bidding.

I need to give the class on Microsoft. Thansk

...scraping data from a website and delivering it in an Excel file. The specifics of the project are as follows: I am looking for a person who will conduct scraping sessions for our business on a regular basis. Desired skills are knowledge of screen-scraper software, sql, Someone with Python knowledge will be better. Willing to follow instructions. Not cramped up with other jobs or other side hustles. Need to have solid internet connection. Expected work takes 5-10 hours per week, once fully trained. Must be responsible. Able to accept PayPal. - The source of the data is a website. This means the freelancer needs to have experience in web scraping. - The data should be delivered in an Excel file. Proficiency in handling and formatting data int...

I'm seeking an Airtable expert to assist me with a number of tasks, including data entry and organization, building custom workflows, and creating advanced formulas. Ideal candidates should have: - Previous experience working with Airtable, including data entry and organization, workflow creation, and complex formula design - A strong understanding of how to make the most of the tool, including its integrations and automations Please note that while my exact requirements in terms of the number of tables and views in my Airtable base, as well as specific integrations I need, have not been stated, I expect the freelancer to be able to adapt to my needs and work in an agile manner.

I'm seeking a detail-oriented freelancer for a text data entry project. The primary task is to input text data into a spreadsheet accurately. Additionally, these data must undergo sorting for seamless navigation and understanding. Key Responsibilities: - Text data entry into a spreadsheet - Implement effective sorting to organise the data Ideal Skills: - Proficient in Microsoft Excel - Strong attention to detail - Experience in data sorting techniques - Excellent typing skills The ideal candidate will possess a solid knowledge of Excel functionalities and data sorting. I look forward to connecting with passionate individuals eager to take on this task.

Multi-scenarios Custom Sales Commissions Excel Spreadsheets Dashboards. Develop a bespoke Microsoft Excel spreadsheet to accurately calculate sales commissions. The specifics: - The variables: the spreadsheet to take into account the Sales Volume, the Profit, and the Commission Percentage while computing sales commissions. - Calculation specifics: Commission should be determined accurately according to custom formulas (using the previous variables) that considers the Commission Percentage. - Data input: The spreadsheet will be easy to use, allowing to manually input the data for calculation. This tool (Multi-scenarios Custom Sales Commissions Excel Spreadsheets Dashboards) will enhance efficient determination...

Seeking a tech-savvy professional to establish an automated system leveraging ChatGPT and Make Automation. The aim is to: - Automatically extract specific information from a variety of documents including Word, PDF files, Excel Spreadsheets, and Scanned documents - Thoroughly analyze extracted content including text, tables, charts, and images for compliance and precision - Automatically generate comprehensive reports based on extracted information for easy reference For this task, proficiencies in AI, Machine Learning, ChatGPT, and automation are necessary. Likewise, experience in OCR technology for processing scanned documents will be valuable. Not only should the candidate be detail-oriented - they should also be adept at debugging and ensuring the system seamles...

I am looking for a skilled developer to create a system that can manage and sell chatbots with AI. The main components include: Control Panel Features: Ability to activate or deactivate chatbots Update chatbots with new responses or features Manage clients and their chatbots effectively Display statistics about chatbots usage Provide access to chatbots' configurations Include a client database with their contact information The system should enable me to sell, update, and manage chatbots with ease. On the flip side, my clients should be able to access their chatbots through a login and utilize them effectively in both English and Spanish. Additionally, it is essential that the chatbot can integrate and be used on social media platforms like Facebook...

I am in need of an expert who can assist me with the customization and setup of Microsoft Office applications. Key responsibilities: - Assessing my requirements and suggesting the best ways to customize the Microsoft Office software. - Configuring the settings and options of the software to meet my specific needs. - Providing step-by-step guidance to help me understand and use the customized features efficiently. Ideal Skills and Experience: - Proficient in Microsoft Office Suite (Word, Excel, Outlook). - Experience in customizing and setting up Microsoft Office applications for various purposes. - Excellent communication skills to explain technical information in a clear and understandable manner. Your assistance wo...

I require a clean and professional logo for my project management consulting business, Let’s Sort This Out, LLC. There isn't any specific imagery I am tried to, perhaps incorporate a pen, clipboard or excel style doc - I am 100% open to creative suggestions! Ideal designers will be experienced in corporate branding and able to present a portfolio of similar work.

I'm in a rush and need a ski...task is the detailed design phase. I need you to take concepts and transform them into detailed plans, elevations, and sections. There's a deadline to be mindful of, as the completion is needed as soon as possible. Key responsibilities include: - Translating architectural concepts into detailed designs - Creating detailed plans, elevations, and sections - Ensuring the design meets all necessary standards To excel in this project, you should have: - Proficiency in AutoCAD and 3D Max - A deep understanding of architectural design principles - Experience in detailed architectural design - The ability to work efficiently under pressure and meet tight deadlines If you're confident in your skills and can deliver ...

...Features: - Creating Quotations: The app should allow users to create comprehensive and customizable quotations, including options to choose profile, colour, glass, mosquito netting, etc. - Generating Invoices: Users should be able to conveniently generate invoices based on the created quotations. - Generating Tax Receipts: The app should also support the generation of tax receipts. Additional Requirements: - Save as PDF: The ability to save these documents in a PDF format is essential. - Customer Data: The app should maintain a database of customer information. - Edit Old Quotations: Users should be able to access and make changes to previous quotations. - User Management: The system will need to support 1 admin user with the ability ...

Thumbnail for my monetized/commercial/personal use YouTube video

I'm in need of a skilled professional who can scrape data from Google. The project requires the extraction of names and email addresses for specific profiles to be used as a potential leads database. Upon successful extraction, the data needs to be presented in an Excel spreadsheet, CSV, etc. Ideal Skills and Experience: - Proven experience in data extraction from websites - Proficiency in Excel - Strong attention to detail and accuracy - Experience in extracting usernames and emails is a plus Deliverables: - The extracted Data - The data must be clean, organized, and formatted in an Excel spreadsheet I look forward to receiving your proposals!

...analyst with expert-level MS Excel skills to provide a comprehensive understanding of the data and help build a comprehensive energy financial model. Key Deliverables: - Explanation of Cash flow projections - Explanation of ROI calculations - Explanation of Sensitivity analysis - Explanation of 5-year financial projection - Explanation of Manufacturing Financial Feasibility Modeling Data Inputs: - Revenue projections - Cost projections - Investment costs - Tax rates Inflation Handling: - Inflation should be included in the projections Ideal Candidate: - Proficient in MS Excel, capable of building complex models - Experience in financial modeling for the energy sector - Understanding of manufacturing financial feasibility modeling - Ability ...

نحن شركة تجارة إلكترونية نتعامل مع منتجات متنوعة ونبحث عن مدير إعلانات الوسائط الاجتماعية للانضمام إلى فريقنا. تشمل المهام على سبيل المثال لا الحصر: إنشاء الإعلانات على منصات التواصل الاجتماعي المختلفة إنشاء تقارير في Excel وGoogle Sheets بشكل يومي وشهري إيقاف الإعلانات التي لا تقدم عائد الاستثمار المقبول إنشاء إعلان جديد للحملة المتوقفة يجب أن يكون مدير الإعلانات متفرغًا فقط لهذا المشروع وغير ملتزم بأي مهمة أو وظيفة أو دراسة أخرى ساعات العمل: 6 أيام في الأسبوع، 10 ساعات يوميا يجب أن يجيد الوكيل اللغتين العربية والإنجليزية يجب أن يتمتع أيضًا بمهارات تواصل جيدة يمكن أن تعمل على إكسل أن يكون لديك خبرة كافية في إعلانات وسائل التواصل الاجتماعي والتسويق الرقمي

As we are Manpower Supply Agency, We would like to incorporate attendance day to day entry of our workers from this info we would like to automate payroll, billing and Government salutatory. and also a dashboard for overall performance of our agency. Skills and experience: - Human Resources and Employee Management expertise - Ability to create user-friendly interfaces - Experience with Single Sign-On (SSO) integration and other login methods - Capable of adding features like search functionality, photo upload, and editable fields - Excellent communication skills to understand our needs and translate them into a functional system.

...organise events on behalf of European trade bodies including an annual awards ceremony for a leading sports nutrient association which takes place in London. We are looking for an experienced Event Organiser to provide essential administrative and logistical support for the team in the UK and EU either on a freelance or fixed term contract to deliver an awards ceremony in London in December 2024. You will need a positive, can-do attitude, and be able to flex your approach and make decisions at speed when required. You will perform well under pressure and possess great attention to detail. This is a hybrid role with some scheduled time in the London office will be required along with attendance at the event itself. Responsibilities Assist i...

...data entry from PDFs into Excel, with some basic analysis required post-entry. Key Details: - The primary task is to type data from PDFs into an Excel spreadsheet. - I will provide the PDFs, they contain various types of information that need to be accurately transposed. - The data must be organized neatly and consistently in the Excel file. Data Analysis: - After the data entry, I will need basic analysis of the entered data. This includes simple calculations, averages, basic graphs, etc. - A grasp of Excel's basic analytical functions is essential for this part of the project. Desired Skills: - Proficiency in data entry, especially from PDFs to Excel. - Strong command of Excel, particularly for data management and basic ...

I'm seeking someone to migrate the content of a PDF DMS 5 book into an Excel spreadsheet. The Excel sheet should serve as a functional checklist with the disorder's name and its description only. Your mission is to categorize the disorders by chapters, mirroring the structure of the original DMS 5 book. Ideal Skills and Experience: - Proficient in data entry and Excel. - Organizational skills to categorize content effectively. I'm not looking for additional columns for notes or references, just an accurate transfer of the book's content to a checkist format de check list to facilitate reading a and diagnosis. Please apply if you're confident in your knowledge of this area and have the appropriate technical ...

...from Spain specializing in SEO, SEM, social media management, web design, and content marketing. Our goal is to help businesses grow and achieve their goals through effective and personalized digital marketing strategies. We want to open market to USA. Job Description: We are seeking a motivated and dynamic Sales Representative to join our team in the United States. This position is ideal for someone with a passion for sales and digital marketing, willing to work on a commission basis and capable of cold calling to generate new business opportunities. Responsibilities: Conduct cold calls to identify and contact potential clients. Present and sell our digital marketing services to businesses. Develop and maintain strong relations...

I need a skilled DevOps engineer with deep expertise in Ansible and experience in working with Microsoft Azure and Azure DevOps. Key Requirements: - Integrate Ansible into our Azure DevOps environment for setting up a comprehensive CI/CD pipeline. - Automate the deployment of applications using Ansible across our Azure infrastructure. Ideal Skills and Experience: - Extensive experience with Ansible, particularly in CI/CD context. - Proven track record of working with Microsoft Azure and Azure DevOps. - Strong understanding of automation tools and methodologies. - Excellent problem-solving skills and attention to detail. - Ability to work efficiently under pressure to meet tight deadlines.

I'm looking for a professional to help me with a CV in modern style, suitable for job applications. Key Requirements: - The CV should be well-crafted and tailored to the job market. - I need the CV in both Microsoft Word and PDF formats. Ideal Skill Set: - Prior experience in creating modern, job application-centered CVs. - Proficiency in Microsoft Word and PDF. - A good understanding of the current job market and employer's expectations. Please provide samples of your work and your estimated timeline for completion.

I am in need of a Microsoft Access specialist to create a straightforward database. The main aim of this project is the production of a simple database with a focus on data reporting. Key Points: - The database is intended for data reporting purposes. - There will be 1-5 different types of data entries (tables) in this database. - The final database should be equipped for generating various types of reports from the data it contains. - I am looking for a freelancer who can also document the database effectively. Ideal Skills and Experience: - Experience in designing and building Microsoft Access databases, specifically with a focus on reporting. - Strong knowledge of structuring databases for efficient reporting. - Ability to provide clear and concise documen...

We are an Ecommerce company dealing with variety products and we are looking for a Social Media Ads Manager to join our team. The tasks includes but not limited to: Creating the ads on different Social Media Platforms Create reports in Excel, and Google Sheets on a daily and monthly basis Turning off the ads which are not delivering the acceptable ROI Creating a new ad for the stopped campain The Ads Manager must be solely free for this project and not committed to any other task, job or study work hours: 6 days a week, 10 hours a day The agent must be fluent in both Arabic and English Must also have good communications skills Can work on Excel Have sufficient experience in Social Media Ads and Digital Marketing

I need assistance with extracting specific data from a voter list that comes in PDF format from the election commission. Here’s what I need: - Extract Name, FathersName, Age, Gender,...voter list that comes in PDF format from the election commission. Here’s what I need: - Extract Name, FathersName, Age, Gender, VoterID, and SerialNumber from the PDF voter list. - Placement in a standard Excel format is acceptable, no need for any specific formatting. - Not just a one-time service, I also need a software or script that can perform this PDF-to-Excel conversion automatically in the future. Ideal candidates for this project have advanced skills in data extraction, familiarity with handling election data and proficiency in developing an automated system for c...

...professional adept at advanced Excel functions to create a spreadsheet, which would organize and manage our worker rota for late shifts from Monday to Friday. We have two sites, including inpatient and outpatient pharmacies, which need coverage. Key functionalities of the required Excel Spreadsheet: 1. Worker Availability: - The ability to input more than 20 workers' availability. - An advanced combination of automatic and manual assignment based on the available days of our workers considering part-timers. 2. Worker Ability: - A system to allow input about the worker's ability to cover specific sites, based on their previous experience. The ideal freelancer should have a high proficiency in Excel, including...

I'm in urgent need of an experienced thumbnail creator to generate striking, vibrant thumbnails for various platforms such as YouTube, websites, and social media. *Style and Theme* Your designs should exude a colorful theme that's enticing and eye-catching. *Thumbnail Content* Each thumbnail should have captions incorporated in the design. The text should be readable without distracting from the overall appeal. To excel in this project, you need to be a skilled designer with a knack for creating visually stunning and colorful thumbnails. You should also have practical knowledge of designing for different platforms, and understand how to incorporate text seamlessly into your work. Past experience in a similar role will be advantageous.

I'm looking for a skilled front end developer to help me create a dashboard focused on data visualization,The primary objective of this project is to develop a robust data virtualization tool capable of interpreting, displaying, and analysing collision avoidance system data extracted from log files. This tool will enable users to load log files or Excel files, interpret the data, generate reports based on specified parameters, and visualise the insights using a web application or Power BI interface.

I'm looking for a skilled front end developer to help me create a dashboard focused on data visualization,The primary objective of this project is to develop a robust data virtualization tool capable of interpreting, displaying, and analysing collision avoidance system data extracted from log files. This tool will enable users to load log files or Excel files, interpret the data, generate reports based on specified parameters, and visualise the insights using a web application or Power BI interface.

I need a skilled Excel user to help me format a single spreadsheet and create formulas to automate some calculations. Key Responsibilities: - Format the spreadsheet to make it visually appealing and easy to read. - Create formulas to automate calculations based on the data input. - Ensure the spreadsheet is user-friendly and easy to update. Ideal Skills and Experience: - Proficiency in Excel, particularly in data formatting and formula creation. - Prior experience in handling data-heavy spreadsheets. - Strong attention to detail to ensure accurate data processing. - Ability to work independently and deliver the project in a timely manner.

use translationpress and deepl to auto translate wp into many languages

I am searching for a knowledgeable expert in Microsoft Excel who can assist me with a variety of tasks. Specifically, I require aid with formulas and functions, and formatting and design. More specifically, I need assistance with summation and averages, and VLOOKUP and INDEX-MATCH commands. The ideal candidate would have substantial proficiency and experience with Excel, with an emphasis on utilising complex formulas and creating aesthetically appealing and comprehensible spreadsheets.

I need a hand with entering a small amount of text and numbers data into a spreadsheet. Key Requirements: - The task involves a small amount of both text and numbers data entry. - The specific software to be used has not been specified by me, so you can work with what you're most comfortable with. Ideal Freelancer: - Proficient in data entry, with experience handling similar tasks. - Familiarity with popular data entry software, like Microsoft Excel and Google Sheets would be beneficial.