Excel spreadsheet tutorialpekerjaan

I want to re-order some data on a spreadsheet. The picture attached shows you what I need doing. The excel spreadsheet is attached. I'd like the formulas in the spreadsheet left in there, so I can learn how to do it in future!

You should be having a YouTube and a Facebook account. In this project, you will be primarily focusing on entering data into spreadsheets. This job comes with an important responsibility as the data provided must be organized and prepared for analysis. Here's what I'm looking for: - Expertise in data entry work, particularly with Excel. - Strong attention to detail when transferring data. - Knowledge in data analysis; however, no specific analysis method required. - A strong candidate for this job would have prior experience with similar tasks, as well as strong analytical skills to help transfer the data accurately. Here is the task. @VegasMatt/videos Order the videos by latest it will be easier Go through

As we dive deeper into data analysis, an improved visual representation of our findings is required. Consequently, we need someone proficient in Excel and experienced in conditional formatting. Your task will be: - To apply conditional formatting within a certain range on our Excel data. - To highlight values which fall within this range, rather than color coding them. Skills required: - Proficiency in MS Excel. - Experience in conditional formatting. - Attention to detail. We look forward to having a clearer and more streamlined view of our data.

I am in need of a highly proficient developer with expertise in JavaScript, Excel, and PHP for automation tasks associated with excel sheets. Though specific tasks directly related to JavaScript and PHP scripting were not defined, the focal task is oriented towards developing excel macros specifically designed for sheet automation. Key Responsibilities: - Macro development for excel automation - May also involve JavaScript coding and PHP scripting Ideal Candidate: - A demonstrated history of successful macro development and Excel automation - Solid understanding and command of JavaScript and PHP - Ability to provide a detailed project proposal Please include in your application your relevant experience, your past work particularly relating to macro de...

Creating an Accounting Excel Sheet and create an automation form.

...seeking a skilled developer to create database or programme to accurately reconcile multiple csv files of data from different time periods into a single spreadsheet. Individual csv files need to be imported to create a single worksheet or report keeping the time period data distinct. The project includes: - Understanding of multiple CSV databases. - Accurate importation of each CSV file into a worksheet report. - Ensuring the integrity of the data during the importation process. Ideally, the candidate should possess: - Strong data analysis skills. - Experience with handling large CSV files. - Proficiency in Excel or similar spreadsheet application with understanding of database structures. - Attention to detail to maintain data accuracy. - Knowledge on data r...

I'm in need of a data analyst, capable of performing descriptive statistics and correlation tables, along with two linear regressions using Excel. I aim to identify trends and patterns that will help in improving operational efficiency and bolstering data-driven decisions. • The project involves analysis of data sourced from a Spreadsheet/Excel file. • The ideal freelancer should be skilled in Excel, descriptive statistics, linear regression and data interpretation. • The purpose of the research is not just to understand the current state of affairs but to make strategic decisions for the future. • A background in market research will be beneficial for the project. Your task will be to provide me with a comprehensive report deta...

I'm seeking a skilled web scraper to extract valuable data from Website 1. The data to be extracted includes the company name, address, location, phone number, and email. The priority of extraction should be the phone nu...location, phone number, and email. The priority of extraction should be the phone numbers and emails first, followed by the rest. - Extract information from Website 1 - Prioritize phone number and email extraction - Populate a single Excel sheet with all fields The ideal freelancer for this job should have robust skills and experience in data extraction, web scraping, and Excel. Timeliness and accuracy are of utmost importance. If this sounds like a project that matches your skills, I'd love to hear from you! Need to Extract data from attached...

I am looking for a proficient professional who can create an advanced Excel Gantt chart for me that is produced from a table extracted from Salesforce. This would involve: - Incorporating elements of task scheduling and progress tracking into the Gantt chart. - Completing the project within a span of 1-2 weeks. - Breaking down each task on a weekly basis to provide a comprehensive visualization of the project timeline. Skills needed for the job would include proficiency in Microsoft Excel, experience in creating Gantt charts, a good understanding of project management principles, excellent time-management skills and attention to detail. Familiarity with task scheduling and progress tracking would be essential.

I am seeking for a C# expert with a good understanding windows api who can provide comprehensive tutoring on how to print a DirectX window. My skill level in C# and DirectX is intermediate, but I want to deepen my understanding of the DirectX window's printing process. Experience in graphics programming is required as I already have some knowledge in this area. Ideal Skills: - Proficiency in C# and DirectX - Ability to explain complex technical concepts in an understandable manner - Prior teaching or tutoring experience - Extensive background in graphics programming. By the end of this project, I expect to grasp the intricacies of the DirectX window's printing process and be able to implement it independently.

I need a freelancer skilled in Excel who can create a sales tracking sheet for me. My focus is on monitoring the sales revenue of my business. Here's what I'm looking for: - A sheet where sales data can be manually input - A system that can effectively track AR from the customers Ideal Skills and Experience: - Advanced Excel expertise - Experience in data entry - Your role will involve not only creating the system, but also ensuring that it's easy for a person without a technical background to use. I'm hoping that this project can be completed efficiently, with minimal revisions needed.

...take on fantasy romance. **What to Include in Your Proposal:** - A brief overview of your experience in fantasy and romance genres. - Samples of past work that showcase your storytelling skills and ability to capture the essence of fantasy romance. - Your approach to creating enchanting tales within the constraints of a short story format. This project is the perfect opportunity for writers who excel in delivering impactful narratives in a brief format. If you have a talent for creating worlds where love knows no bounds and every sentence is a step into the magical unknown, I invite you to submit your proposal. Let’s create something truly magical together....

Necesito modificar un archivo csv que está alojado en un servidor, modificar mapear etc

We are seeking a skilled data researcher to assist us in finding leads of Health Care Providers who are utilizing Athena or ModMed (Ema) EHR systems. To apply, please provide us with a sample lead that includes the following information: -First Name -Last Name -Company Name -Email Address -Industry Ensure that the provided contacts are actively using Athena or ModMed (Ema) EHR ...high-quality, relevant leads within specified criteria. Payment: Payment for this initial task will be $50 for each completed project, based on the quality and relevance of the leads provided. Upon successful completion, further discussion regarding ongoing rates and collaboration will be considered. How to Apply: Please submit a sample list of leads that meet the outlined requirements in a spreadsheet...

...with questions from a spreadsheet. We have 5 different categories of questions, with 40 questions in each category. Each question will be transferred onto its own card. We already have created the photoshop templates for the 5 different categories. We just need the text transferred and centered on each document. If it would be easier for you, it could be done in Adobe Illustrator instead. Please see the Text Centering to see how we want the text centered. Please see the Text Centering to see how a sample of multiple cards with different amounts of text, all centered properly. Please see the File Naming to see how we want 1 file per card, and how it is to be named by the category followed by the number (which will be found on the spreadsheet). Please respond by

I am looking for an expert in chatbot development who can construct a bot capable of engaging in meaningful discourse based on the contents of differing PDF documents. The chatbot will need to be fully integrated into an existing website, and should excel in suggesting relevant content from PDF files based on user interaction. Major functionalities include: - Ability to parse and understand content from a series of PDF documents - Skilled at suggesting relevant PDF material based on user chat inputs - Capacity to adapt dynamically to regularly changing PDF content Ideal applicants should possess strong skills in artificial intelligence, natural language understanding, machine learning, and web development. Past experience with dynamic chatbot development would be a significant ass...

I'm seeking an experienced software developer to create a Microsoft Office Add-in or application that could function in Word and Excel. This digital tool should be designed with artificial intelligence capable of recognizing factual and procedural questions within the documents. With a foundation in machine learning and chatgpt, it should be apt in offering answers by analyzing previous documents and accessing website information. I'd like the system to be versatile in its response presentation; it should present suggested answers both within the document and/or in a pop-up window. Looking forward to working with someone who has: - Significant experience in AI and Machine Learning - Understanding of Natural Language Processing for question detection - Proven track recor...

I'm in need of a proficient web developer to construct an e-commerce website with a methodical, corporate design. Key Specifications: ...developer to construct an e-commerce website with a methodical, corporate design. Key Specifications: - Implement e-commerce capabilities, enabling efficient online transactions. - Integrate Skrill as the website's payment gateway. Prior experience with Skrill integration will be highly advantageous. - Execute a professional, corporate aesthetic for the website design. Preference for developers who excel in creating such layouts. Ideal Skills and Experience: - Proficiency in web development - Experience with e-commerce website creation - Familiarity with Skrill payment gateway - Strong track record in creating professional, corpor...

I'm in need of a proficient web developer to construct an e-commerce website with a methodical, corporate design. Key Specifications: ...developer to construct an e-commerce website with a methodical, corporate design. Key Specifications: - Implement e-commerce capabilities, enabling efficient online transactions. - Integrate Skrill as the website's payment gateway. Prior experience with Skrill integration will be highly advantageous. - Execute a professional, corporate aesthetic for the website design. Preference for developers who excel in creating such layouts. Ideal Skills and Experience: - Proficiency in web development - Experience with e-commerce website creation - Familiarity with Skrill payment gateway - Strong track record in creating professional, corpor...

We're a service organization that uses a customer database that can be exported into an excel format that we want our service paperwork to reference and auto-populate in specific text fields. Any changes in the spreadsheet need to be reflected in the service form PDFs. So, we're in need of a competent developer experienced in Excel, PDF manipulation, and integration. Your task will be to create functional PDFs with formulas that reference my Excel spreadsheets. Key Aspects: * Proficiency in using Microsoft Excel * Expertise in Lookup and reference formulas mainly VLOOKUP, INDEX * Ability to develop a system that integrates PDFs with Excel spreadsheet to reflect real-time changes. We're looking for an expert who can deli...

I need to create an addon for excel where I will send email using the built in mailmerge and outlook will be used to send the email. The addon needs to: 1) monitor for replies sent from these email 2) if no email is received from the domains (as replies may come from a different person) where the email was sent, outlook will trigger a calendar reminder to send a follow up email 3) an email follow up template should be automatically created in the calendar and when I click it, I shouldn't have to add anything extra, except maybe to change the name of the recipient (or if the addon can pick up the name from the first email, that would be best) and then I can click send.

I'm seeking an expert who has comprehensive skills in product analysis primarily focussing on different categories. This role involves identifying profitable ite...for each product Mandatory Skills: - Previous experience using 1688, Taobao and etc. - Proficiency in product analysis. - Ability to work with Russian text and marketplaces using a translator. - Understanding of how to use Keepa, Helium10, and JungleScout software to find trending product. - The ability to use Excel/Google Sheets In this task you will need to find 10 items and analyse them. I'm looking for long term business in case of successful completing the task. I'm pinning Excel with the template how it must be filled to calculate profit from the product. Also you will need to analyse Amazon...

My name is Frezier, I am looking for a developer who will create Nuxt SPA User Authentication and role-based authorization with Laravel Sanctum Idealy I need to create tutorial site Also I need inteface like this where user able to change topic on left bar while they may able to change cause at the top The code should be clean and easy to read and understand

...currency (RON - Romanian Leu). The final deliverable will be an Excel spreadsheet that not only presents the translated information but also aligns the financial data with Italian accounting standards, ensuring clarity and compliance for stakeholders in Italy. Objectives 1. Translation Accuracy: To ensure the financial statements are accurately translated from Romanian to Italian, capturing all financial terminologies and nuances without loss of meaning. 2. Compliance with Italian Accounting Standards: To reclassify the financial data in accordance with Italian Generally Accepted Accounting Principles (GAAP), ensuring that the reclassified balance sheet reflects the formats and categorizations typical in Italy. 3. Excel Proficiency: To leverage Excel's c...

I have a task that requires impeccable detail; the conversion of 810 pictures in HEIC format into an accurate Excel spreadsheet. These pictures need to be translated with exact precision, mirroring their every aspect. However, there's no need for you to worry about including any functions or formulas, just the raw data. All images have been taken with high clarity, so you'll have no trouble discerning the numbers and characters. We're looking for someone with the following skillsets: - Proficient in Excel - Detail-oriented - Experiences in Data Entry - Familiar with HEIC format images

I need a freelancer with adept skills in data entry to assist with entering single random words into an Excel spreadsheet. Expertise in Excel and keen attention to detail will be necessary. No particular categorization or field-specific organization is required. However, accuracy in entry is crucial. This task will involve: - Data entry of single, random words into Excel - Ensuring accurate and error-free input - Delivering the completed project on time. Experience in data entry, particularly with Excel, is greatly preferred. Familiarity with handling text data will also be beneficial. Please ensure you're comfortable with such requirements before making a bid.

I'm seeking a skilled individual who can create a complex mathematical Excel program for me. This program will need to perform functions related to 401(K) CONTRIBUTIONS, MATCHING CONTRIBUTIONS, IRS LIMITS AND SPILLOVER. Data visualization focused on financial data. Key Requirements: - Develop financial models within Excel - Design data visualization​ techniques to present this financial data - Implement interactive graphs, allowing for visible outcomes based on different inputs. - Facilitate 'what-if' scenario changes, which will impact the outcome and must update correspondingly - Implement a system where variable inputs are updating corresponding outputs effectively. Ideal Skills & Experience: - Experience in Excel programming - Strong backgro...

...player's goal-scoring prowess. I'm seeking an Instagram video creator to craft engaging 1-minute videos highlighting an athlete's skills from soccer matches. The ideal candidate will extract compelling moments from VEO footage to create daily Instagram posts showcasing a particular player's talents. Payment will be per video, with potential for ongoing work based on efficiency and quality. If you excel at creating captivating sports videos and can deliver promptly, this opportunity is for you. Key Requirements: - Advanced video editing skills are mandatory. Expertise in motion graphics, advanced effects, and professional color grading will be highly valued. - In addition to showcasing the player's goal-scoring abilities, the videos should highlight gene...

Hlo! I have done MS in statistics. I read your job description. I have expertise in SPSS, R studio, excel, minitab, quantitative and statistical analysis. I will provide you with the finest work that perfectly aligns with your time and budget constraints. Thanks waiting for your response. Regards, Hira Mahmood

I need a freelancer who would bring paper-based text data into a digital, more manageable format like a spreadsheet. You will be working with physical documents, so strong attention to details and accuracy are essential. Conversely, transcribing or data entry experience and excellent typing skills would be appreciated. The goal is to get all the text data transcribed and formatted in a spreadsheet in a clear, concise, and organized manner.

Hi, you did an excel vba macro for me in 2019. It worked fine until now but it just broke, its not working anymore. can you help fixing it?

I require an automated system, coded in Python, to perform checks on Visa card validity through the website Key Requirements: - Know-how of Python programming. - Experience with automated testing. Deliverabl... Key Requirements: - Know-how of Python programming. - Experience with automated testing. Deliverable: - A Python script that can automatically run these checks and save them. Project Outcomes: - Verification of card validity. - The results need to be saved in an Excel (*.xlsx) file format or in my attachment Experience: - Freelancers with familiarity in Visa APIs, Python, and know-how of working with Excel files will find this task in their field of expertise.

I'm in need of someone who can create permanent, menus in both Microsoft Excel and OneNote - For Excel: The permanent drop-down menu should consist of various colors, always displayed on the screen ,that I don't have to click to open. - For OneNote: The permanent drop-down menu should consist of an array of tags, always displayed on the screen, that I don't have to click to open.

I am looking for an expert with proficiency in Microsoft Excel to redesign and update my current invoice template on Excel. You will maintain the agreed-upon overall structure but give it a fresh, modern aesthetic. The document must be made from scratch on a new Excel as the old design isn't saving in colour when saving on PDF. Colours must be the same as existing template. Your responsibilities will include: - Redesigning the template in accordance with the modern design principles. However, the overall structure of the existing invoice should be retained to ensure similarity. - Updating the existing invoice template to a more contemporary design yet similar to the existing document. - Potentially modifying formulas or adding new columns if necessary. Ideal ...

I require the expertise of a Power BI maestro who is proficient in creating dynamic, interactive and visually appealing reports from sales data. This project specifically involves: - Analyzing sales data I will provide in Excel format. - Constructing and designing a Power BI matrix table for reporting purposes The ideal candidate is proficient in Power BI and Excel with an in-depth understanding of sales data reporting. You should be able to translate complex data into informative visuals & interactive reports. Producing accurate, error-free analysis within arranged timeline is critical for the success of this project.

pasar informacion a excel. pasar informacion a excel

As a seasoned C# developer, I need to create a complex mapper function that can efficiently extract data from Excel. The .xlsx files contain variable patterns spread across different sheets, so having the flexibility to handle such diversity will be key for this task. Key Requirements: - Develop a mapper function in C# to process Excel files in .xlsx format. - Deal with variable data patterns having different layouts spread across numerous sheets. - Extract and process data from all sheets in the Excel file. Skills and Experience: - Profound expertise in C# programming. - Experience in handling Excel data with variable patterns across multiple sheets. - A robust understanding of data extraction processes. - Proven experience in developing mapping functions...

As the project lead, I am in urgent need of a self-driven and detail-oriented freelancer who specializes in online data entry. This project's volume isn't specifically set, but the selected individual should be prepared to handle a potentially large amount of data entry tasks. Tasks will include but are not limited to: - Prompt and accurate entry of data into our online system. Ideal candidates for this job should have the following skills and experience: - Proven online data entry experience, with references or portfolio to back it - Dedication to efficiency and accuracy - Ability to work under unknown volume pressure - Availability to start immediately would be an advantage Unfortunately, we have not yet established a definitive deadline, so freelancers with some de...

I am looking for a skilled data analyst who can proficiently use Excel to perform text matching between two different Excel files for the purpose of matching the most appropriate description given to a medical service code . No significance testing is needed in this project, it is purely a direct comparison task. I have particular requirements pertaining to "Data set A". Your role will be primarily centred around: - Matching text in one Excel sheet to another. - Consolidating data based on text matches. - Focusing specifically on "Data set A". Ideal candidates should be experienced in Excel, data consolidation and comparison. Knowledge on data set handling would be a plus. Please bid accordingly, ensuring your capabilities in these areas ar...

I'm looking for an experienced data manipulator who can efficiently reformat my data according to CRM-specific requirements. Specifically, I need the address and names in my data to be split into separate columns. Key requirements: - Break down the existing 'Address' field into: 'City', 'State', and 'ZIP code' columns. - Split 'Names' in...separate columns. Key requirements: - Break down the existing 'Address' field into: 'City', 'State', and 'ZIP code' columns. - Split 'Names' into two separate columns: 'First Name' and 'Last Name'. This does not require any data entry, just an understanding of data structures, and layout according to CRM needs. Ideal freelance...

I am setting up a new business, selling Moodle courses online. I will be using EKM as my website / payments platform. I will need to automate the following 1) Customer order in EKM Trigger = new customer order. Automate the entry of key data into a Google Sheet or Excel File 2) Customer details added to Google Contacts 3) Integration with Moodle - Creating a new Moodle account (if a new customer) - Giving access to the particular Moodle course that the customer has purchased I am still in the set up phase, so can design my processes / workflow to make automation easier (i.e. this is, relatively speaking, a blank piece of paper). I am seeking an expert who is proficient in Zapier automation. My project revolves around streamlining the user enrollment process. Project brief: -...

As a booming brand on Instagram, Facebook a...compelling Meta ads and formulating innovative strategies. *Key Areas of Focus:* 1. **Strategy Development:** Demonstrated experience in creating strategies to increase engagement on social media. 2. **Meta Ads Expertise:** Proven ability in leveraging Meta ads effectively. Experience creating captivating ads that drive engagement is key. 3. **Cross-Platform Proficiency:** Ideal candidate should excel in Instagram, Facebook, and YouTube; ability to create cohesive strategies across all platforms. Our perfect fit would be someone who is a pro at researching, understanding and connecting with our audience, inciting genuine interactions to foster a deeper relationship with our brand. Think you can make this happen? Then we can't wa...

I have a simple Excel VBA macro file (attached). The file shows up an additional toolbar on my personal PC, but does not show toolbar on client's PC. NOTE: The client can still run the macro code using the button placed on the grid. I just need to know the right group policy that needs to be setup correctly.

I'm seeking a proficient Excel user who can deftly analyze my amalgamation of patient's research data. The data in question comprises of medical histories, treatment outcomes, and demographic information. Further, I need an in-depth exploration of the correlation between investigations and treatment outcomes. The ideal candidate will need to: - Process and analyze lab test results, heart rate, and temperature records. - Correlate these factors with treatment outcomes. - Extract meaningful insights from medical histories and demographic data. Experience with health-related research data is a plus. Your analytical skills, attention to detail and knowledge of Excel are paramount.

As the client, I'm seeking a skilled Excel VBA macro specialist who can create an automated system for a repetitive task in our operation. The task in question involves a data entry form consisting of Product, Quantity and Price fields that needs to be automated. As a professional with deep knowledge in Excel VBA, automation and data entry, you have: - Proven experience in crafting Excel VBA macros. - Proficiency in automating repetitive tasks. - Extensive understanding of data manipulation. - Excellent knowledge of Excel formulas and functions. Your main job will be to create a macro to automate this data entry form. This will involve auto-filling data into the respective form fields where necessary. This efficiency-generating macro should serve to eli...

I need an Excel expert to customize specific features in my existing utility. The chosen freelancer will focus on the following: User interface modifications: I have a preference for a minimalistic design. The interface should be clean, intuitive and not cluttered for easy navigation. Formula automation: I want to automate various tasks like data validation rules, calculation automation and data sorting and filtering. You should be able to craft these tasks to improve efficiency in data administration. Data analysis enhancements: Lastly, I want to enhance the data analysis functionalities to help with strategic decision-making. The ideal person for this project should have in-depth experience with excel and particularly in building and customizing excel utiliti...

I am looking for an expedient and detail-oriented freelancer who can perform data entry tasks for my project within 1 to 2 weeks. The task will involve entering a mix of numeric and textual data accurately into an Excel spreadsheet. Requirements would include: - Proficiency in Excel for efficient data entry - Excellent attention to detail to ensure data accuracy - Ability to meet strict deadlines to complete the task within the agreed timeframe - Prior experience in data entry, specifically with mixed data types Preferred Skills: - Proficiency in Excel - Attention to detail - Time management skills - Experience with handling mixed data types This job will entail the completion of data entry requirements with attention to detail, speed, and accuracy. Pleas...

I'm seeking a proficient data entry specialist for a large task involving more than 500 records. The project requires entry of various types of data, including numeric, textual, and alphanumeric. Key...project requires entry of various types of data, including numeric, textual, and alphanumeric. Key Tasks: • Accurate entry of numeric, textual and alphanumeric data • Verification and correction of already entered data • Adherence to data privacy and confidentiality principles Preferred Skills: • Proficiency in Excel Spreadsheet use • Strong attention to detail • Previous experience in large-scale data entry Please note, the entered data needs to be formatted in an Excel Spreadsheet. I am looking for precision and atten...

I need expert guidance to optimize and integrate our in-house applications built on Django. Our applications range from AI chatbots for consultants to excel mapping. Django has already been installed, a main APP has been created, each application is intended to run as an API. Here's where you come in: - Optimize Application Performance: Help us enhance the speed and efficiency of our apps. - Integrate with External APIs: Guide us on how to effectively link our applications with external APIs. - AI Application Development: We want to create AI apps in a more efficient manner. Your insights will be valuable. I expect freelancers applying to this project to have: - Experience: relevant experience in Django and AI application development, and API integration. To make an inf...

I am on the look-out for skilled individuals who excel in the spheres of web creationn and social media marketing to join my agency. The primary goal of our agency is to increase brand awareness for diverse businesses, our target audience. Required Skills and Experience: - Expertise in web creation: Being able to create user-friendly and visually appealing websites is crucial. You should also be adept at responsive design to ensure the sites function well on varying devices. - Proficiency in social media marketing: Proven expertise in developing and executing social media strategies to boost brand visibility and engagement is needed. Familiarity with marketing analytics to monitor and adjust strategies as required would be advantageous. Past experience working with businesses and ...