How to use microsoft excel formulasJobb
Vänligen Vänligen Registrera dig eller Logga in för att se mer information.
I'm looking for an experienced graphic designer to create a professional estimate cover page template on Microsoft Word. This template exclusively has to be in the Letter format (8.5in x 11in). The created template must be easy-to-edit and should contain the following elements: • My company logo • Space for contact details • Space to include a project title • A designated location to place a project photo Ideally, the design should incorporate my company logo and colors to maintain brand consistency. Proficiency in Microsoft Word and graphic design are critical for this role. An understanding of design aesthetics would also be beneficial. The completed project should deliver a finished template file that is ...
...me develop a digital scorecard in Microsoft Excel. The ideal candidate will have experience in Excel data management, visualization, and automation functionalities. Key Requirements: - Microsoft Excel proficiency: The digital scorecard will be based on Microsoft Excel, and as such, the freelancer must be highly skilled in this software. - Data entry fields: The scorecard should have user-friendly data entry fields, allowing for the easy input of information. - Interactive charts and graphs: The scorecard should include interactive charts and graphs that visually represent the data. - Automated calculations and summaries: The scorecard should automate calculations and summaries based on the data entered. Skills/Experience: - Proficiency ...
I am in need of a skilled data entry freelancer to assist in inputting textual data from digital files into an Excel spreadsheet. Key Responsibilities: - Accurately inputting textual data into an Excel spreadsheet. Ideal Skills and Experience: - Proficiency in data entry, particularly with textual data. - Familiarity with Excel and the ability to work efficiently with spreadsheets.
Good day. Trust you're well. I have a project that I need to download multiple PDF documents from website and compile them into 1 excel spreadsheet. Would you be willing to help with this?
You'll need to customize your UET tag tracking code to report a custom event. To do so, copy and modify the code attached and add to your UET tag tracking code. Needs to be done via GMT
I am looking for an Excel VBA script coder to assist me with a project for generating tags for e-commerce products from the description. Products are car spare parts. Need to tag the products with names of make, model, variant. Specific requirements: - - Generate tags for e-commerce products in a excel sheet. The product description is saved in Column A and the tags should be generated by referring to the list of available tags. Please see the excel sheet attached here. _ One product can have multiple tags associated with it from the tags list, The VBA script should run and generate tags while referring to the data in other sheets for tag names. Please see the excel sheet attached. Ideal skills and experience: - Proficiency in E...
I’m seeking a highly skilled Google Sheets professional to assist with the creation of a thorough tracker for my farm’s harvest and sales data. Currently, I'm using a basic Google Sheet to track these details, but I need a more comprehensive, automated solution. The tracker will need to detail: - Crop type (specializing in fruits and vegetables) - Quantity harvested - The date of harvest - The sale price of each item - Purchaser name - Remaining stock (calculated by subtracting the amount sold from current inventory) Ideal skills and experience for this project would include Google Sheets or Excel expertise, incorporating automated calculations, and the ability to create a user-friendly layout. Knowledge of or experience with farming or...
I need a medium complexity genetic algorithm developed for personal use. This algorithm will be used primarily for optimization purposes. Key Points: - The genetic algorithm is to be designed for medium complexity tasks, akin to solving scheduling or routing problems. - This is a personal project, so the output should be user-friendly and intuitive. Ideal Experience: - Strong background in genetic algorithm development. - Prior experience in developing medium complexity algorithms, ideally with applications in scheduling or routing. - Ability to create user-friendly interfaces and provide necessary guidance for personal use.
I'm looking for a professional who specializes in cleaning text data to help me with my project. Key Responsibilities: - Identify and remove duplicates within the text data - Correcting typos, spelling mistakes, and grammatical errors - Standardize the data in terms of formats and consistency I need someone who can handle this project within a month. Ideal Skills: - Proven experience in data cleaning, specifically with text data - Proficiency in text mining and natural language processing - Attention to detail and accuracy - Effective communication skills to keep me updated on the progress of the project. If you have these skills and are available to start working on the project as soon as possible, I'd love to hear from you.
I need to convert scanned PDF pages into a simple, text-only Word document. The original PDFs contain images with text. Key Requirements: - Extracting text from scanned PDFs - Converting extracted text to Word - Maintaining the text only, no formatting required Ideal Freelancer: - Experience with OCR (Optical Character Recognition) tools for extracting text from scanned documents - Proficiency in Microsoft Word for converting the extracted text - Familiarity with handling PDFs containing images with text - Attention to detail to ensure accurate extraction of text Please note that the final deliverable should be a clean, text-only Word document that accurately captures the content from the scanned PDFs.
...Convert the excel data to Sage300 GLGE entries: Help in converting data from the excel details data to Sage300 excel format to import them directly inside Sage 300 ERP to create the needed GLGE entries automatically. 2- Support Sage300 Integration (AM Acquisition app): The application you developed previously needs an update. In the current process of creating Acquisition Entries based on shipments, all items are being transferred to the Fixed Asset module, irrespective of the data. The necessary update involves ensuring that only records with relevant data are migrated automatically when shipments are loaded in the application. Specifically, records without asset details (Sage optional fields) should be flagged as ignored. Th...
I need a proficient data entry operator to assist a task involving typing handwritten documents into Excel spreadsheets. The ideal candidate would have previous experience in data entry, and a high speed typing ability. Accuracy is key in this project, as they'll be transcribing valuable information, it's critical every detail is correct. Time management skills are also important, as there's a specific deadline to complete the task. If you've done similar jobs in the past, please mention it in your proposal. I look forward to working together.
I'm looking for a freelancer who can convert my existin...freelancer who can convert my existing Google Document into a Word document, ensuring that the finished product is identical to the original in terms of formatting and layout. This includes, but is not limited to: - Preserving the structure, font styles, and general format. - Carefully replicating charts and graphs. The successful candidate will be proficient in both Google Docs and Microsoft Word, and will have a thorough understanding of document conversion processes. Knowledge of how to effectively realize charts and graphs in Word is desirable. The final Word document needs to be downloaded to my local computer. Overall, the emphasis is on attention to detail to...
I need help populating an Excel sheet with 378 company websites. - The task involves searching the internet for the website of each company and entering it into the Excel sheet. - If a company doesn't have a website, please mark it as 'No Website'. - All URLs should be inserted in a new column in the existing Excel file. I would prefer the URLs to be in the format '' or ''. Ideal Skills: - Proficiency in Excel and web research. - Attention to detail to accurately populate the data. - Strong communication to flag issues or ask questions during the process.
It just suddenly started happening. Shutdown and Restart don't change it. Windows 10 Microsoft Office Home and Student 2016 The attached jpg DID shows: 1. What ChatGPT told me to do. 2. I did it. 3. The huge Caps Lock On/Off image still appears when I press the Caps Lock key. I also checked Word Options - Advanced - Editing Options but there's apparently nothing related to the Caps Lock key (see other attached jpeg.)
Any one experienced with octoparse or any other web scrapping tool can easily complete this straight forward web scrapping project. Please see this google drive link for instruction and check attached excel where sample scrapping is done for you.
...professional who can craft a comprehensive brand profile designed to catch the eye of Millennials, helping us establish a solid, professional image. This brand profile will be used for us to join bazaars & offline events. Key Requirements: - Create a professional Brand profile for us, which includes: - Brand Concept - Social Media Account - Profile - Sales Channel - Product Catalog I'm looking for a creative mind who can help me develop a unique and appealing brand concept. Ideal Skills and Experience: - Proven experience in brand concept development. - A keen understanding of the Millennial demographic and what appeals to them. - Proficiency in English, able to write in perfect English language. This project is crucial for us to establis...
Wir sind ein Gastronomiebetrieb und möchten die Kontrollen und Übersichten über diverse Verkäufe, Arbeitszeiten der Mitarbeiter und ähnlichem vereinfacht und am besten mit Automationen in Excel-Listen eintragen. Auswertungen der Verkäufe usw. werden per Mail des Kassensystem-Dienstleisters an uns gesendet. Diese Auswertungen sollen dann in die Excel-Listen eingefügt werden. Mit wenig oder am Besten, durch Automationen, mit keinem Aufwand. Sinn ist es Arbeitszeit zu sparen und Fehler zu vermeiden.
...Analyst Freelancers** ### Overview We are seeking a skilled data analyst to organize and create detailed furniture packages for various property types and customer segments. The goal is to systematically structure these packages in Excel, covering multiple styles and accommodating property sizes from studio apartments to 4-bedroom homes. Each style will cater to different client types: holiday homes, new homeowners, expats, and investors. ### Objectives - **Create Defined Furniture Packages**: Develop comprehensive lists of items included in each package tailored to specific client types and property sizes. - **Organize Data Efficiently**: Present the data in a clear, accessible format in Excel that allows our team to understand ...
I'm in search of a talented and hard-working freelancer to help me with an Excel task. The job at hand is complex and demands someone with strong analytical skills and attention to detail. The primary objective of this project is to achieve a high level of accuracy and efficiency in the output. Thise means that the quality of work is paramount. To succeed in this role, you must have a good understanding of Excel, be able to think logically, and work meticulously. Key Skills & Experience: - Proven track record in Excel data management - Strong analytical and problem-solving abilities - Attention to detail - Ability to work autonomously I look forward to receiving your application, and I will be in t...
I need a Google document converted into a Word document (.docx). The key details of the project include: - Converting a Google document to a Word document while preserving the original formatting. This means that the final Word document should look exactly like the original Google document. - No content updates or edits are required during the conversion process. The focus is solely on the correct and accurate conversion of the existing content. Ideal Skills & Experience: - Proficiency in Google Docs and Microsoft Word - Strong understanding of formatting preservation - Experience with document conversion - Attention to detail to ensure accuracy - Timely delivery of the converted file
...process of time-stamp duration reporting in Excel. The solution I'm seeking should ideally have the following components: I have a report (excel-sheet) exported from a system that I use in a weekly basis, however in this report, the date and time of processing exported in a form of “timestamp” and in order to calculate elapsed time of each stage in cycle, every time I have to do the followings: - Fix the format issue in excel since system always export data in a form of “timestamp” and there is no to fix that. - Exclude non-working hours for each stage/ elapsed time. - Exclude Weekends (Friday & Saturday). - Sum up the total of elapsed times Do you have a solution that I can use the as tool eithe...
I am looking for an experienced freelancer to assist with a data entry project. The task includes entering both text and image data taken from a medium-sized collection of Word documents. This is not a minor task as it involves inputting between 100 and 1000 entries. The ideal candidate should have: - Familiarity with Microsoft Word and data entry practices - The capability to handle both text and image data effectively - Strong attention to detail for accuracy - Ability to commit until project completion Please ensure your bid reflects your experience and your expected completion time. With the right set of skills, this task can be accomplished effectively and in a timely manner. Looking forward to your proposals.
...the go-to destination for clients across Asia, both in the public and private sectors. Our track record speaks volumes: a tapestry of client testimonials, groundbreaking intellectual property, and a legacy of delivering exceptional consulting and training experiences across diverse industries and functions. What We Offer: We're on the lookout for dynamic individuals to join our team of All-Source Intelligence Consultants. If you're someone who thrives on analysis, production, and delivering top-notch intelligence products, then you're exactly who we're searching for. Whether you're a seasoned pro or a rising talent looking to make your mark, we offer the perfect platform to showcase your skills and earn without limits. Why You'...
I'm looking for a freelancer who can provide me with the links to Facebook pages of specific public figures/politicians, total of 1215 (IMPORTANT! I need only pages, NOT private profiles). The links should be delivered in google sheets which I will provide, along with the names. Key Requirements: - Compile a list of specified Facebook pages - Deliver the links in google seets Ideal Skills and Experience: - Proficiency in Internet Research - Experience with Excel or Google Sheets - Strong attention to detail - Ability to follow instructions accurately
...skilled freelancer to enhance my Google Spreadsheet with a few specific features 1. Protect on Edit Functionality: I'd like to add a protection mechanism that ensures the spreadsheet can be edited by all users but avoids accidental changes to existing data. 2. Automated Data Analysis: I'm looking to automate the process of data analysis in the spreadsheet. Your solution should be efficient and user-friendly. 3. Make analysis available in existing web page 3. Export to other existing database It is important that the sheet can be accessed and run from Google Workspace with mainstream browsers without requiring usr to download extensions, run scripts, etc Happy to work on time based payments and will contract item 1 first and...
I am seeking a seasoned content creator(female) who can bring my fashion brand to life with engaging articles, captivating videos, thought-provoking infographics, and innovative storytelling approaches. - Your responsibility: - Deliver fresh, stylish, and relevant content on a weekly basis, tailored towards fashion - Creativity and an in-depth understanding of fashion trends is a must - Ideal skills: - Exceptional writing and editing skills - Proficient photography and videography skills - Ability to convey fashion narratives in a compelling, authentic way - Proficient in Adobe Suite, Canva, Microsoft designer for creating infographics Experience in both the fashion and digital content creation space will be highly regarded. Express your flai...
DESEO HACER UN CAMBIO DE TARIFAS DE UN DOCUMENTO EN WORD DONDE ACTUALIZAR EN BASE AL TEXTO INICIAL SOLAMENTE MODIFICAR LOS IMPORTES QUE SE INDICAN CON LOS CONCEPTOS E IGUALMENTE A EXCEL POR APARTADOS
...seeking a skilled individual to accurately convert a PDF document into a Word document. The prime purpose of this conversion is for extracting text. - The project demands the highest level of precision, with a requirement for 100% accuracy in the extracted text. Any mistakes in conversion could result in significant inaccuracies, hence meticulous attention to detail is vital. - It's imperative that the Word document maintains the original format of the PDF for consistency and ease of navigation. The freelancer must be well-versed with advanced Word formatting to accurately replicate the original PDF layout. Ideal skills: - Proven experience in data entry and document conversion - High level of accuracy and attention to detail - Strong understanding of...
...Opening: Timezone: UAE : Note: If required, the candidate may need to travel to the UAE. However, the client will inform the resource once onboarded. About Company: We are the thought leaders in the IT industry, envisioning and crafting the best future for clients from across the world using our technological intellect. There stands only one motto--pick up on every opportunity to develop innovative applications for startups and enterprises to grow and advance in the digital space. If the challenge is digital transformation, the solution is TRooTech and nothing less. Please visit our website Linked-in profile Detailed Job Descriptions - Strong proficiency in Microsoft Dynamics 365 for Finance and Operations (D365 FinOps), including
...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
Vänligen Vänligen Registrera dig eller Logga in för att se mer information.
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...
