How to use microsoft excel formulas jobs
...a creative professional to create a company letterhead that aligns with my brand. The letterhead should be sophisticated and professional. We already have a brief. We already have all the brand colours and elements but just need someone to put everything together on illustrator. There are 6 points on the brief. Key elements to be included: - Company logo - Company name and address - Contact information Deliverable Details: - The final design should be delivered in a Word document. Color Scheme: - The color scheme should match the company's brand colors. (colour code to be advised) Ideal Candidate: - A graphic designer with experience in creating company letterheads and a strong understanding of consistent branding. Your portfolio should display yo...
I'm in need of a proficient Excel and Word expert who can assist me with various tasks. Unfortunately, I did not specify the exact tasks nor provide a deadline for this project. However, I'm excited to review your proposal and discuss your experience in more detail. Please include your past work in Excel and Word with your proposal. This could be anything from template creation to complex data analysis and automation. The more detail you can provide about your past work, the better. In terms of my needs, I'll be looking for a flexible freelancer who can help out with a range of tasks. Experience in data analysis, formula creation, and automation in Excel would be particularly desirable, as would proficiency in creating and formatting te...
...knowledgeable professional to assist in the development of a comprehensive training program for individuals aspiring to become advanced pentesters. Key responsibilities: - Create a structured, in-depth training curriculum focused on web applications, networks, and mobile applications pentesting. - Design engaging and informative training materials that cater to an advanced level audience. - Provide hands-on examples, case studies, and practical exercises to reinforce learning. Ideally, the candidate should have: - Extensive experience in the field of pentesting, particularly in the areas of web applications, networks, and mobile applications. - Prior experience in designing and delivering training programs, workshops, or courses. - Strong communication skil...
...menu data, which exceeds 500 entries, in Excel. My project primarily involves handling text data. Here's what you would focus on: - Categorizing different types of food items. - Ensuring accuracy and consistency in data entry. While not a firm requirement, familiarity with culinary vocabulary could be beneficial. Additionally, someone proficient in MS Excel and particularly experienced in data categorization would be ideal. I appreciate your consideration and look forward to potentially working with you. Paid project: remote work Seeking Assistance: Categorizing Online Menu Data in Excel Hey guys, I hope you're doing well! I'm reaching out because I could use your expertise for a project I'm working on involving categori...
I have a highly encrypted XLSM file that I urgently need help with. This specific project involves making VBA in the file visible. I need someone with advanced VBA skills and experience in cracking down highly encrypted XLSM files. Key requirements: - Expertise in VBA for Excel - Experience with highly encrypted XLSM files - Ability to make VBA visible in such files Please only apply if you have previous experience in this area and can start immediately. BID NOW!!! Serious freelancers only with the skills since it is ASAP!!
I'm seeking an Excel expert to revamp my Google Sheets, transforming it into an interactive platform. Specifically, I need to integrate the XIRR calculation for my stock transaction data, which spans over 4 years. This will involve the addition of dropdown menus for transaction selection, buttons for XIRR calculation, and color coding for profit and loss data. Key Requirements: - Integrate XIRR calculation for stock transactions - Create dropdown menus for transaction selection - Develop buttons for XIRR calculation - Implement color coding for profit and loss data Additional Context: - I am using Google Sheets, not Microsoft Excel - I update my stock transaction data on a weekly basis Ideal Freelancer: - Proficient in Google Sheets - Experienced ...
I'm looking for a skilled web developer to create a data-driven website with interactive graphs and user access levels. The website will primarily serve as a platform for data visualization and export. Key Functionalities for Admin User: - **User Management:** The admin should have the capability to manage user accounts, including setting access permissions. - **Graph Creation:** The admin needs to be able to create visual representations of data. - **Data Viewing and Exporting:** The admin should be able to view all the data and export it to Excel for further analysis. Graphs Per Department: - **Data Points:** The graphs should focus on data from Sales, Expenses, Profit, and Number of Employees, using a rolling average approach for...
I am looking to have a novel, written in Microsoft Word, converted into an audio-book, that can be published with one of the established audio-book publisher, who lists all published audio-books in Google Play, Hoopla, Chirp, , Scribd, Storytel, Kobo, Libby, Librivox, Audible, Spotify, Kanopy, cloudLibrary, Apple Books, Loyal Books. Key Components: - Conversion of a fiction into an audio-book Skills and Experience: Ideal candidates should have: -Experience in converting fictions into audio-books - Familiarity with fiction writing - Ability to guide the author in publishing the audio-book
...PowerAutomate expert to assist in the weekly extraction of both text and numeric data from PDF files. The extracted data will then need to be arranged in a specific format in an Excel sheet. Key Responsibilities: - Extract both text and numeric data from PDF files - Perform the data extraction on a weekly basis - Arrange the extracted data in specific columns and rows in Excel Ideal Candidate: - Proficient in using PowerAutomate for data extraction - Experience working with PDF files and Excel - Attention to detail for correct formatting of data - Ability to meet weekly deadlines - Strong communication skills to verify data accuracy Please find attached pdf (extract) example (there is 5 different templates to use)...
I'm in need of a highly skilled AWS OCR specialist to help extract data from a large number of PDF invoices. We intend to export the extracted data into an Excel (XLSX) file. All invoices follow a consistent format, as shown in the attached sample. All invoices have been scanned at 300dpi resolution with searchable OCR enabled." Key Requirements: - Proficiency with OCR technologies, particularly those integrated with AWS services (Textract) - Experience with extracting data from PDFs, especially invoices. - Ability to export extracted data into Excel format. The freelancer will supervise the implementation process on our PC. Due to confidentiality, access to the invoices will be provided remotely on my PC
I need a data entry operator who is proficient with intermediate level data entry tasks in spreadsheets. The primary task will involve entering data from digital files like PDFs and Word documents into spread...intermediate level data entry tasks in spreadsheets. The primary task will involve entering data from digital files like PDFs and Word documents into spreadsheets. Key Responsibilities: - Accurately inputting data from digital files into spreadsheets. - Using formulas and sorting data within spreadsheets. - Ensuring the data is entered correctly and consistently. Ideal Skills and Experience: - Proven experience with spreadsheet data entry. - Proficient in using formulas and sorting data. - Attention to detail and high accuracy levels. - Ability to work ...
Need to redesign ERPNEXT UX with new design and structure. We need take inspiration from a reference ERp Microsoft Dynamics 365. Basically we need to redesign parent templates which will be used for mostly all screens in all modules.
I need a seasoned Excel Macro developer to help me create a macro to automate repetitive tasks and generate daily reports. Key Requirements: - The macro needs to be compatible with Excel 2016, as this is the primary version I'm working with. - I'll need to run the macro daily, so it has to be stable and reliable for consistent use.
I'm seeking an experienced MS Excel specialist for a freelance data analysis job. Key Responsibilities: - Execute thorough data analysis using Excel. - Generate actionable insights from the data. - Prepare and present reports based on findings. Ideal Candidate: - Proficiency in MS Excel. - Proven experience in data analysis. - Strong analytical and problem-solving skills. - Excellent attention to detail.
I need a meticulous and detail-oriented freelancer to assist with numerical data entry for the purpose of data analysis. Key Requirements: - The data you'll be working with is in a digital format, mainly in Excel and CSV files. - You will be responsible for accurately entering this numerical data. Ideal Skills and Experience: - Proficiency in Excel and data entry. - Experience with numerical data analysis. - Attention to detail and accuracy. - Ability to work with large sets of numbers efficiently.
I'm having a significant issue with my Google Sheet that needs sorting quickly. The main issue I'm dealing with is a formula error - when I try to make a hyperlink auto-populate after inputting a specific exercise, it just isn't working, which is causing a lot of frustration. Key Requirements: - Understands Google Sheets - Skilled in fixing formula errors - Fast turnaround time Ideal Skills and Experience: - Strong expertise in Google Sheets and formulas - Proven troubleshooting evaluation - Ability to deliver ASAP.
...Android apps. The purpose of this project is to create a finance app that facilitates expense and profit sharing. Main Features: - The app should be able to calculate profit share based on varying formulas. You should be comfortable with integrating complex calculation equations into the functionality. - Additionally, it should generate comprehensive reports for expense and profit sharing, making it easier for users to track and understand financial movements. Skills and Experience: - Proven experience in Android Development and finance-related apps - Strong knowledge of mathematical formulas - Exceptional skills in UI/UX design to ensure the app is user-friendly - Familiarity with report generation modules. The ideal candidate should be a...
I'm looking for an experienced professional to help me install a Domain Validation (DV) SSL certificate on my website hosting server. Key Requirements: - Install a Domain Validation (DV) SSL certificate - Experience and technical knowledge in SSL certificate installation on website hosting servers I already have the SSL certificate, so the main task will be the configuration and installation. Attention to detail and ensuring a smooth transition to HTTPS is crucial. Looking forward to working with a skilled individual who can get this done efficiently.
...Goal: The primary objective of this project is to implement robust asset management practices via a comprehensive depreciation forecast. I'm seeking a professional with: Creating a excel spreadsheet that i can download my asset register into and then have the worksheet calculate future annual depreciation say to 10 years. But also allow the ability to have the individual assets to be revalued either an increase or decrease in the original asset cost. This would mean the excel sheet would need to be able to take into account prior accumulative depreciation and adjust in the year we are currently reporting in. The attached file is current assets as at 30th June 2023. No depreciation has ran for FY24 01/07/2023 to pres...
...requiring assistance with Excel. This project is tailored for someone with experience in the following areas: - **Excel Expertise**: I'm looking for someone who is proficient with Excel, especially in handling data analysis tasks. The ideal candidate should be comfortable with manipulating large data sets and extracting key insights from them. - **Data Analysis Skills**: A strong background in data analysis is crucial. You should be able to interpret data, identify trends, and provide meaningful conclusions based on your analysis. - **Attention to Detail**: As this job involves working with data, high attention to detail is a must. The ability to spot errors or irregularities in data sets is crucial to the success of this p...
I need 1-5 videos, each less than 5 minutes long, transcribed into a legal document format. These transcriptions will be used in a court in Los Angeles, California by Tuesday, April 30th. Requirements: - Transcribe 1-5 videos, each within the 30-minute limit - Format the transcriptions in a legal document format - Ensure accuracy and clarity in transcription - Meet the specified...30-minute limit - Format the transcriptions in a legal document format - Ensure accuracy and clarity in transcription - Meet the specified deadline - Experience with legal transcription is highly preferred - Familiarity with court transcription standards and requirements in Los Angeles, CA is a plus If you have the necessary skills and can deliver top-quality transcriptions on time, I would love to hear...
I'm in need of a skilled accounting professional who can seamlessly handle a variety of accounting tasks for me on a daily basis. I require assistance in...Key Responsibilities: - Timely and accurate bookkeeping: Keeping track of all financial transactions. - Perform financial analysis: Analyzing financial data and creating financial models to support decision-making. - Tax preparation: Preparing and filing tax forms in a timely and accurate manner. Ideal Skills and Experience: - Proficient in Excel, Tally Prime, and Zoho Books. - Strong understanding of bookkeeping, financial analysis, and tax preparation. - Prior experience with daily accounting tasks. - Excellent attention to detail and organizational skills. - Strong communication skills and ability to...
I'm seeking a proficient developer to transform an existing Excel calculator into a web-embeddable format for integration on our website. The calculator should perform basic arithmetic operations and allow user input for the calculations. At the moment the user has to imput the item being stored and the size of the shed and it will tell them how much it can store of that item. We want this reversed and the user will put in the item they want to store and how much they want to store and it will calculate the size the shed will need to be. Key Requirements: - Convert an existing Excel calculator to a web-embeddable format - Ensure it performs basic arithmetic operations - Allow users to input values for the c...
...a talented artist and copywriter to create two persuasive sales pages. These pages will showcase two of my products, aiming to convince both potential customers and licensees of their value. Specific responsibilities will be: - Creating a photo-realistic 3D rendering of each product. I will provide the 3D models and product details. - Writing convincing sales copy that effectively communicates the value of the products, but more importantly - it sells the benefits (not the features). Ideal candidates should possess: - Excellent 3D rendering skills - Experience in persuasive sales copywriting - Understanding of how to appeal to both customers and licensee parties - Previous success in converting sales pages. This is a wonderful opportunity if you...
52 sheet for 52 week needs to contain mon-Friday. I will register everydays expense on that.
...contacting potential clients through cold calls, emails, and face-to-face meetings. • Set up meetings and/or calls with prospective customers to showcase our company profile and products to generate sales. • Proactively, identify customer needs and suggest appropriate products. • Build a strong and trusting relationship with customers for long-term engagements. • Regular follow ups with the customers to understand their concerns and feedback. • Proactively seek new business opportunities in the market. Requirements and skills: • Proven work experience as a Business Development Representative, Sales Associate, or similar roles. • Excellent communication and negotiation skills. • Experience working on Microsoft Of...
I need a document formatting specialist with proficient experience in Microsoft Word. Tasks include: - Adjusting margins and layout within the document, for a polished and professional appearance. - Inserting tables and graphics to enhance the presentation and display of information. - Applying styles and formatting text, utilizing Serif fonts (like Times New Roman) for consistency and readability. - Crafting a unique and eye-catching cover page design. - Document is 105 pages The ideal freelancer will have an eye for design and great attention to detail. Strong knowledge in Microsoft Word and experience in document styling are key for this job.
I am in need of a professional who has experience using VBA in MS Project to automate the process of generating project summary reports. So the person MUST have Ms Project experience to understand how project constructs data. Key tasks include: 1. Utilizing VBA to automate the generation of project summary reports. 2. These reports must provide a list of all tasks and their current status 3. in particular how to create a table of all tasks related to a Milestone - similar to Task path function for predecessors. The ideal freelancer for this project should possess strong skills in VBA and Microsoft Project. They should have a proven track record in automating and streamlining reporting processes. Previous experience in proj...
...dataset to tell a compelling story in an area of your choosing. This dashboard should offer insightful analyses highlighting trends, challenges, or opportunities within the selected field. You will conclude this project by creating a video presentation that explains your dashboard and its insights. Details of Assignment 1. Dataset and Topic Selection: Choose any publicly available dataset that interests you, whether related to environmental issues, public health, economics, sports, finance, real estate, or any other field. The key is to select a topic that allows for insightful data analysis and storytelling. 2. Tool Selection: You can use any data visualization tool you are comfortable with, such as Microsoft Excel, Power BI, Tableau, or others...
...research. You will have to be fluid with excel, online reasearch tools. This is a posting for a long-term VA who can perform various forms of online research and other tasks. Personal attributes required: 1. Speed and efficiency in online research. 2. Attention to detail and complete accuracy in all tasks. 3. Punctuality and ability to meet deadlines. 4. Ability to read/follow instructions carefully with attention to detail. Successful candidates will be required to complete two test works before the project is awarded. 1. Watching instructional video which explains the task. 2. Completing an 11 question quiz based on the video instructions. 3. Completing a small sample test on 5 medical centres to demonstrate understanding of...
...a whole. We are particularly interested in monitoring three key data sets: - Patient volume - Revenue - (PPC) This data need to be updated and reported on a monthly basis, presented in an accessible and understandable way for our administrative team. The reporting format we require is spreadsheet, so proficiency with Excel or a similar program is a necessity. Ideal candidates for this job would have: - Strong data analysis skills - Previous experience with financial and PPC data - Proficiency in Excel or similar spreadsheet software - Ability to deliver monthly updates in a timely manner Through this analysis, our goal is to gain a clearer understanding of how patient volume, revenue, and PPC are impacting our clinic and individual doctors...
...developer to create versatile AI agents capable of performing any assigned task such as data analysis, recommendation system tasks, programming, making phones calls, and operating as a chatbot. The project demands a developer who is highly proficient in various programming languages and is open to working with different platforms and frameworks. Ultimately I am looking to build a system that builds ai agents to build a conglomeration of different businesses ran by ai agents. Key requirements: - Development of AI agents capable of performing data analysis, recommendation system tasks, and chatbot functions. - Proficiency in Python, Java, and JavaScript preferred, but other languages are acceptable if they are more suitable for the task. - Familiarity with Ten...
we have 645 pages in the attached Excel spreadsheet that we need to write 150-200 words about the product as content for each page.
I am in need of an Excel expert who can assist me predominantly with data analysis tasks. More specifically, the ideal individual should be adept at: - Utilizing Excel effectively with the @Risk add-on, - Performing a Monte Carlo simulation to analyze risk, - Wielding strong analytic capabilities to interpret and communicate the simulation's results. The task will require a deep understanding of data analysis techniques, a keen eye for detail, and fluency in data visualization. This role is perfect for seasoned Excel professionals with past experience in risk analysis and simulation.
Hi, I want to create a proof-of-concept of a model that can search and retrieve information using microsoft document intelligence api with python code. As its a proof-of-concept a simple dummy dataset should suffice. My aim is to create a proof-of-concept for an Azure Ai Doc model that analyzes contracts and stores the output in a format that can be searched with using certain keywords.
I am looking for an expert in data analysis and excel who can compile specific data for certain doctors in our clinic. The data metrics required include: - Volume - Revenue - (PPC) The data should be organized both doctor-wise and clinic-wise for effective comparison and understanding. You should be able to present the data in an easy-to-understand, concise and visually appealing manner. Key skills required for the project include proficiency in: - Data analysis - Excel data manipulation - Understanding of PPC metrics - Attention to detail Experience in health-related data analysis would be a plus. Sub-headings should be WOW (week over week), MOM (month over month), MTD (month to date), and YTD (year to date), reflecting the volume, re...
I am looking for an expert in data analysis and excel who can compile specific data for certain doctors in our clinic. The data metrics required include: - Volume - Revenue - (PPC) The data should be organized both doctor-wise and clinic-wise for effective comparison and understanding. You should be able to present the data in an easy-to-understand, concise and visually appealing manner. Key skills required for the project include proficiency in: - Data analysis - Excel data manipulation - Understanding of PPC metrics - Attention to detail Experience in health-related data analysis would be a plus. Sub-headings should be WOW (week over week), MOM (month over month), MTD (month to date), and YTD (year to date), reflecting the volume, re...
...in need of an Excel VBA expert who can assist me with writing macros and automating data entry in my spreadsheets. The primary goal of these macros is to automate the data entry process and streamline the subsequent data analysis tasks. Key project requirements: - Building custom macros: I need help with building macros that can automate data entry tasks and facilitate data analysis. - Data analysis focus: The macros should be designed to support data analysis, particularly with a focus on data visualization. - Expertise in Excel VBA: Proficient in Excel VBA is a must, with a proven track record of designing and implementing complex, data-focused macros. - Understanding of data analysis: A strong understanding of data analysis is crucial to ens...
I'm looking for a talented graphic designer to create a unique and abstract logo to represent my brand and enhance my online presence. The ideal candidate should: - Have a strong portfolio of previous branding projects, especially abstract logos - Understand the importance of a logo in digital spaces, and its impact on branding - Be able to deliver a logo that is both visually appealing and memorable, ensuring it stands out in a crowded online environment
I need an expert in Microsoft Excel to create a functional, cleanly-designed household income and expenditure sheet from scratch. This task involves: - Data entry: This household finance sheet should allow for comprehensive tracking of earnings and spendings. - Formulas and calculations: The spreadsheet should automatically compute totals thereby providing a real-time, holistic view of my financial landscape. - Formatting and design: The sheet should be intuitively organized and visually appealing for ease of use. I haven't decided on a specific template yet, so there's an opportunity to be creative and propose a clear, easy-to-understand format. The sheet should have a basic level of detail, categorizing different types of inco...
I am currently seeking a knowledgeable, r...results-driven telesales representative for my established business. Your primary focus will be on cold calling potential customers to bolster relationships and generate new leads. Essential Skills and Experience: - Native proficiency or near native in English - Proven experience in telesales - Excellent communication and negotiation skills - Ability to handle sales rejection - Capable of meeting or exceeding sales goals - Strong knowledge in CRM tools and Microsoft Office In this role, you should demonstrate initiative, be persuasive, and able to generate interest in our product or service. We are looking forward towards an energetic professional who will be generating sales to meet our business goals. Hi...
Hi, I am a Civil Eng...experience in Construction Management from Amman-Jordan. I am now seeking a role that will allow me to leverage my skills and expertise while advancing my career to the next level. I am particularly interested in positions that offer leadership opportunities in innovative projects in the Gulf region (Saudi Arabia, UAE, Qatar, etc....), My background in Civil Engineering combined with a PMP certificate uniquely positions me to excel in roles that demand technical and professional skills. The milestone for this project will be to land a new job position, I'm open to discuss any suggestions on how to work this out. Attached a copy of my CV. Thank you for considering my request. I am eager to embark...
I need support in adapting my Excel sheet into a DataFrame, geared towards reporting purposes. While the Excel sheet structure is not concrete, the relevant columns to be extracted and placed in the DataFrame tend to be A, B, and C. However, I'm undecided at the moment on whether this extraction process should be manual or if the system should automatically detect and save the columns. Ideal Skills and Experience: - Expertise in Excel and data analysis tools - Experience in creating data frames for reporting purposes - Ability to advise on manual versus automatic extraction.
I need a skilled DNS expert to configure DNS records for Microsoft Exchange. I currently use BigCommerce as my domain registrar. Therefore, experience with BigCommerce and its DNS settings is crucial. Furthermore, knowledge and skill in BigCommerce and Klaviyo software will be advantageous. Kindly state your relevant experience in your application. Please note, your experience is pivotal to your selection. Currently run rackspace as email provider and klaviyo for email marketing. Need assistance in setting up DNS (MX records) to use with MS 365 Exchange (will migrate our 5 users to MS Exchange email vs POP rackspace)
I am looking for someone who can help me correct some formulas and formatting errors in my Excel spreadsheet. - The spreadsheet contains Sum and Count formulas that need to be fixed. - There are also formatting errors that need to be addressed. Ideal skills: - Proficiency in Excel - Experience with formula correction - Attention to detail for formatting errors.
...If you use any of these editors you will find Free Capcut an easy transition and a huge time saver using their AI feature: Filmora, DaVinci Resolve, Final Cut Pro X, Adobe Premiere Pro, Sony Vegas Pro I am looking for a Video Editor who is experienced in creating Youtube videos. Capcut AI will save a ton of time. I'll provide the script. CapCut video editor (free video editor) has Script/Text to Video. It creates the most the B-Roll, Captions, Voice, and Music. You will add more B-Roll, effects, text/titles. The videos are approximately 16-25 minutes. MUST use CapCut since it will save you a ton of time. (Very Easy to learn) This is an ongoing project. We need several videos. In your bid, tell me what video editor you are using. Your job is using...
...goals by providing end to end support at every stage of the IT hardware lifecycle i.e., from consulting, procurement, maintenance support all the way to Green Disposal and data destruction – all under one roof. Rextech Global propagates agility and delivers service excellence to our customers comprising Global Multi-National Companies across more than 180 countries worldwide. Our URL: - JOB DESCRIPTION: - Desktop Support Engineer Roles & responsibilities: Desktop Technician will provide day to day localremote desktop support, receive inbound calls, answer questions, troubleshoot and document steps performed to resolve challenges with hardware, software, and application issues in a ticketing system. The candidate will also need to f...
Need a excell sheet with a site with the total of all "contractor" that are set to the single projects. All contractors have thei own page, that u can upload a invoice who is saved on the web/sky. The single invoice that is uploaded is set by date, amount, billing nr, and are taget and subtaget with the right tag, that are selected from dropdowns. U can also leave a comment. Hi, Im interested. How long is it for you to finish this? I also wonder, how is your thoughts about the storing of the invoices/files that are uploaded. This should be on the web/sky. Also need a "scan" function, so we can compare a invoice towards a "offer from a supplier", so we can see if the price is corrext. So it needs to be possible to u...
I am looking for a specialist to set up a Microsoft 365, Fileshare, OneDrive, VOIP setup and configuration for a management team of approximately 10 people which should be accessible only to specific individuals or groups within my organization. Key tasks will be: - Configure accessibility and permissions - Enable both viewing and editing rights where needed The complexities relating to file versioning, content approval and check-outs or metadata fields are currently undefined. Therefore, the freelancer will need to be flexible and capable of handling the potential addition of these elements based on future determinations. Skills and Experience: - Proven experience in managing and setting up Microsoft 365, Fileshare, OneDrive, VOIP setup and co...
