Data pekerjaan excel jobs
...conversion of 2 separate PDF documents. One will need to be converted into Microsoft Excel and the other converted into Microsoft Word format. The scope of work is as follows: - Convert one PDF file into an Excel document. Formatting similar to the existing PDF document must be maintained in the Excel file. This includes all text, numbers, tables, graphs, forms, etc. - Convert specific sections/pages of the same PDF file into a Word document. Details on which sections/pages to convert will be provided during project discussion. Ideal Skills for the Project: - Proficiency in converting PDF to Word and Excel while maintaining the layout and format. - Attention to detail to ensure accurate and precise data is extracted. - Ability to meet tight deadl...
I require assistance with creating a custom Excel KPI document for my business to track crucial performance indicators like Sales Revenue and Productivity. Expertise in Excel along with an understanding of KPI tracking is necessary for this project. Specific requirements include: - The KPIs of focus are Sales Revenue and Productivity. - The data or metrics we need to track include Monthly Sales Revenue, Quarterly Sales Growth, Employee Productivity and Project Completion Rate. - All sales revenue data should be represented as a Bar Chart in Excel. As such, the ideal freelancer should be proficient in Excel formulas and charts creation, and have previous experience with KPI tracking and reporting documents. Understanding of business performance ...
...creation of weekly MIS reports using Excel. The selected candidate will have: - Expertise in Excel and data manipulation - A deep understanding of sales data - A proven track record in automating data reporting tasks Tasks will include: - Understanding my sales data structure and reporting needs - Designing and implementing a process to extract significant data - in this case, Revenue, from my Excel sheets - Setting up an automatic report generation mechanism This project will require a tool or macro that can generate these reports on a weekly basis, without fail. The tool or macro should be straightforward to use and should effectively sort and analyze the data to produce the desired reports, highlighting Revenue, which...
I'm seeking the expertise of an Excel pro who can whip up a complex formula to accomplish three main calculations: Sum, Average, and Count. This formula must be applicable not just to a designated range of cells but to an entire sheet. To make it even more challenging, the formula should be set to auto-update with each change in value regardless of cell. Here's what the ideal candidate brings to the table: • Advanced Excel skills, including creation of complex formulas • Experience in setting auto-updates in Excel based on cell value changes • Ability to ensure flawless application of the formula to an entire sheet The complexity of this task calls for an individual who isn't just familiar with Excel but owns it. If this sounds ...
We have about 1000 orders per month. Looking for a book keeper to constantly record cost and perform profit analysis on a monthly basis. The cost consist of 2 parts. Dropship - which we will be sharing excel with order number for vlookups. In-stock ships, which we can develop a standard cost. Besides recording, will also need the individual to check our bank statements ensuring receivable and debits are exactly as invoiced.
Looking for a proficient freelancer to convert a PDF document that contains detailed P&L information into an Excel document. There's no specific expense, revenue, or net income data that need to be targeted; I need all the financial data to be migrated. Formatting the Excel document isn't necessary. Your application should include: -Your past relevant work -Your experience in similar projects -Detailed proposal: state what your plan of action would be for this project Ideal candidate should have experience in working with financial documents, specifically P&L statements, and expertise in Excel and data extraction.
...can assist me with the data entry from physical documents into MS Excel. Specifically, I need someone who can accurately and efficiently enter data from physical documents into an Excel spreadsheet. Requirements: - Proficiency in MS Excel and data entry - Attention to detail to ensure accurate data entry - Ability to work efficiently and meet deadlines Ideal Skills and Experience: - Previous experience with data entry from physical documents - Familiarity with Excel formulas and functions for data manipulation and organization - Strong organizational skills to ensure data is entered accurately and consistently If you are a detail-oriented individual with experience in data entry and MS Excel...
...table in Excel. This pivot table will need to bring data from one table and import it into another. The data I am working with involves Excel spreadsheets and falls under the umbrella of Product data. Ideally, the freelancer tasked with this project will have a keen understanding of Excel and pivot tables, be able to understand and organize data effectively. The pivot table should produce the following: - Show data grouped by product categories - Demonstrate an understanding of how to work with and manipulate Excel spreadsheets - Create an organized and easy-to-read pivot table The ideal freelancer for this project should have the following skills and experience: - Excellent knowledge of Excel and pivot tables - Exp...
I am seeking a api excel query editor to convert a Postman API call into a Microsoft Query Editor. you need skills in Excel, API utilisation, and Microsoft Query Editor. YOu can see query working in Postman scripts (we have so you can import).
I'm in need of an Excel formula expert who can help streamline my data analysis process. This project revolves around employing Excel formulae to automate tasks, specifically focusing on compiling and analyzing data. Key Requirements: - Involvement in building Excel formulae for data analysis. - Proficiency in automating tasks using Excel. Expected Outcome: - The desired result is the creation of an Excel formula that effectively automates the process of compiling and analyzing data. Your task would be to develop a formula which can handle large datasets with ease and deliver accurate results. Please, note that experience in similar projects and a deep understanding on how to manipulate and analyze data using ...
I am in need of a Social Media Manager with a proven track record in handling diverse platforms. The ideal candidate should be familiar and have a solid understanding of Facebook, Instagram, Twitter, Pinterest, Youtube, Linkedin, and Tik Tok. Tasks involved will not only include basic ...results. - Growth Strategy: Devising and implementing a strategy to grow followers and reach organically. Our target audience includes: Millennials, Parents, Business Professionals, College Students, and residents of San Diego. Therefore, an understanding of these demographics would be beneficial. To excel in this role, you should have relevant experience in managing multiple social media accounts, excellent content creation skills, a knack for connecting with audiences, and strategic data...
I am expecting high-quality work on this project that deals predominantly with Excel data manipulation. You'll be tasked with defining and implementing Excel formulas and functions, specifically data lookup and reference functions. This project has one primary purpose: to enhance the user experience for my team as they work with complex datasets. This is a unique opportunity for someone with significant experience in Excel (particularly in crafting data lookup formulas) to apply their skills. Strong attention to detail and an analytical mind are certainly appreciated.
II. SCOPE OF WORK: 1. Two line items will be...will be created using the figures provided from the attached “Development loan request feb 3 2024” spreadsheet , the “R23058.03-PL-PHASING-C101” phasing map, and the loan terms, 5 years, 8% interest due quarterly with varying origination dates. This line item will be inserted below the Land Sale Infrastructure and Operating Cost. 3. Release values and lot data for each of the development areas will be calculated from the provided lot data. 4. Expenses will be calculated across phasing areas and will be allocated per lot. 5. Line items are rounded to the nearest dollar. III. DELIVERABLES: a. A proforma spreadsheet similar to the provided “SAMPLE PROFORMA V1 2-15-24” spreadsheet with mod...
...can design a comprehensive project tracker/dashboard within an Excel format. The purpose is to be able to clearly track and monitor over 60 different projects in active, future or completed stages. Key features that need to be included are: -Project name -Description -Resource allocation (specifying the departments involved - SCADA, Settlements, Operations, Metering, Control, Contracts, IT, Executive) -Status -Completion date -Notes -Charts/graphs for visual representation of project progress The way we organize resource allocation within projects is crucial. The ideal candidate must have a solid understanding of project management and data visualization, with past experience on related projects being a plus. Proficiency in Excel, including advanced features, and...
I am looking for an Excel expert to enhance the functionality and automation of my present personal financial budget workbook. This upgrade is necessary to improve the accuracy, convenience, and efficiency of interacting with my financial data. Your responsibilities will be: * Improving overall functionality for a smoother user interaction. While automating some processes was not specified, the enhancement should focus on making the workbook more efficient, reducing the time and effort needed to key in financial data. Ideal individual should: * Be proficient with Excel * Have prior experience in projects requiring similar Excel enhancements. * Be able to offer suggestions for further efficiency improvements. * Be meticulous and detail-oriented
Hi, basically this is what I need An excel workbook that can capture weekly times worked by various different employees and various projects I have about 6 employees, needs to allow to add one or two more just in case And we work on around 5/6 projects every week I need to be able to record each day, each employee, one or two different project entries, add up the hours And then at the end of it all I need to have a summary page for that week, which includes the employee and all the different hours he worked for that week Should be simple enough I think, for someone who knows pivot tables well I will give you the project names to start and the employee names
I am searching for a specialist capable of identifying three top winning products and standout kitchen products for my dropshipping business. Your respons...monthly search volume - Relevance of keywords to the product's niche Required skills: - Market research - Competitor analysis - E-commerce - Familiarity with dropshipping model Pease provide research for TOP 3 winning products and categories and separate for Kitchen whares. Candidates with experience in product research for dropshipping stores will have the edge. When you bid, please add excel sheet with sample, how would looks like result. and also, please provide feedback or real sample of research result. Budget for this project is 100eur max. When you bid, please add KW "101kw" so that I know you re...
...proficiency in Excel macros to carry out two specific tasks on trading data related to the stock market and cryptocurrencies. TASKS: - Data Analysis: I need to analyze the heavy trading data I have. Therefore, I need someone who can build smart macros that won't just ease the process but would refactor my data into meaningful information. - Data Recording: Alongside analyzing, my macros should also enhance excel to record my trading data meticulously. IDEAL CANDIDATE: Having a good hand at using Excel for data-related tasks is very much expected. However, having experience in dealing with trading data and designing macros for the same will really set you apart. Looking forward to seeing applications ...
I'm seeking an experienced data analyst who can assist in visualizing my data through Power BI dashboards and Excel reports. What the Project Involves: - Creating visually appealing and easily interpretable reports using Power BI and Excel - The data sets primarily to be utilized for these dashboards are sales data Specific Requirements: - Track the following user behavior metrics on the Power BI dashboard * Click-through rates * Conversion rates * Bounce rates Skills and Experience Required: - Experience creating Power BI dashboards and Excel reports - Experience in working with Sales data - Ability to create meaningful and actionable visualizations - Background in tracking and interpreting user behavior data wi...
I am in ...accurately perform data entry tasks and assist me in organizing my Online sales data into an Excel file. Here are the essential project details: - The role primarily revolves around data entry and organization. - The required information to be entered and organized pertains to sales data. - The specific sales data details that need to be entered include the product sold, the sales date, and the sales amount. - An additional critical detail is the conversion of the currency to ILS (Israeli Shekel). The ideal freelancer for this job would have experience with: - Data entry tasks and Excel management. - Familiarity with sales data, specifically within the E-commerce platform. - Currency conversion within Excel...
I'm looking for someone...office space (between 100-500 sq ft). Key Job Requirements: - Developing a 3D layout design using professional tools like AutoCAD, SketchUp, and Revit. - Creating an excel sheet cataloging the necessary items with detailed specifications for each piece. Skills and Experience: - Expertise in AutoCAD, SketchUp, and Revit - Experience in office space planning and furniture layout design. - Knowledgeable about various office furniture brands as specific brands need to be incorporated into the design. - Excellent understanding of ergonomics and spatial design. - Strong attentiveness to detail when cataloging items in an excel sheet. Looking forward to working with a dedicated professional who can transform a medium-sized space into an optimiz...
In this project, the primary task would comprise extensive cleaning of text data in an Excel dataset. This dataset is impressively large involving more than 5000 rows and columns. Specifically, areas that require intervention are: • Correcting typographical errors and incorrect spellings • Removal or replacement of irrelevant characters or symbols • Addressing inconsistencies in capitalization Ideal candidates for this job would have: • Proven experience in advanced Excel data cleaning • High level of attention to detail • Ability to handle large datasets • Proficiency in English for precise correction of typographical errors Your job would be to comb through the dataset and systematically eliminate these errors, ma...
I am seeking a meticulous freelancer for a data entry project, which involves both text and numerical entries. While there isn't a specific format or template to adhere to, I expect neatness and high level of accuracy. With the software for the data entry not specified, it would be ideal to have a candidate that is well-versed in a variety of programs including Microsoft Excel, Google Sheets, and other similar data entry software. The successful freelancer should ideally possess the following: - Proficiency in data entry with a keen eye for detail - Flexibility with various data entry software - Ability to handle text and numerical data entry - High level of accuracy - Ability to meet deadlines and manage time effectively.
I'm in need of a skilled graphic designer to create a unique, watercolour-style logo and banner design for my online store. This is an exciting opportunity for creative minds who excel at transforming concepts into meaningful visuals. Here's a bit more about what the project entails: - Develop a logo in a watercolour style with images that I will provide - Preferred colours: dark ccolours, black and grey Ideal skills and experience for the project: - Proven experience in logo design - Strong portfolio featuring watercolour-based designs - A keen eye for color pairing - Creativity, originality, and strong visual skills If you have these skills and experiences, I would love to hear from you. This project has the potential to lead to more work in the future.
...can assist me with the data entry from physical documents into MS Excel. Specifically, I need someone who can accurately and efficiently enter data from physical documents into an Excel spreadsheet. Requirements: - Proficiency in MS Excel and data entry - Attention to detail to ensure accurate data entry - Ability to work efficiently and meet deadlines Ideal Skills and Experience: - Previous experience with data entry from physical documents - Familiarity with Excel formulas and functions for data manipulation and organization - Strong organizational skills to ensure data is entered accurately and consistently If you are a detail-oriented individual with experience in data entry and MS Excel...
...store and retrieve data efficiently and effectively. We're dealing with over 500 tables and data points, so the design must be optimized for extensive data handling. - Second, the database should be capable of analyzing the data and generating reports. Thus, applicants with a strong background in data analysis will have an advantage. - Last but not least, the system must integrate perfectly with our existing systems to allow smooth data transfer and operation. Skillset and Experience: - Proficient in MySQL DB design, data modeling, and optimization - Skilled in data storage and retrieval mechanisms - Expertise in data analysis and report generation - Experience in integrating databases with other systems - Pro...
My goal is to build a basic application that can pull website data and Excel information, and eventually transition into a SaaS product. The app will not merely pull the data, but it will showcase it in visually interesting and interactive ways. I'm seeking professionals with following requirements: - Strong skills in app development and data integration - Experience in working with Website data and Excel - Proven expertise in creating charts, graphs, interactive visualizations, and dashboards The project timeline is aggressive - I need completion as soon as possible. If you have the skills and ability to commit to a fast-paced project, I'd love to hear from you.
I need a highly skilled and experienced professional to handle my eBay listings. This includes: - Creating product listings: You'll be expected to accurately craft product listings that not only showcase the items effectively but are also appealing to p...information regularly, and ensuring the database is well-organised. - Managing Customer requests: If customers have queries or issues with listings, I'd need you to handle them promptly and professionally. This is a four-day-per-week role, working 6 hours each day (Monday to Thursday). Training is available for the right candidate. Ideal freelancers would have a deep understanding of eBay, Microsoft Excel, Word and image editing software. To increase your chances of success, please include examples of your past work ...
I'm currently utilizing Excel 2016 in which I've integrated a substantial amount of customer data. The project requires the expertise of an individual with in-depth knowledge of Excel formula creation. Key responsibilities will include: - Crafting customized Excel formulas to efficiently process and analyze a wide variety of customer data Skillset and Experience: - Proficiency in Excel 2016 is mandatory - Proven experience with crafting Excel formulas - Proficiency in managing customer data effectively and efficiently for better analysis Please note that error fixing and optimization tasks are not part of the project. I solely need you to focus on creating unique and efficient formulas tailored to my needs and dataset.
I urgently require a data entry specialist to assist me with data organization tasks on Excel. As a critical part of this project, you will be required to sort and organize various data, with a strong emphasis on accuracy and attention to detail. Key tasks will include: - Sorting and organizing text, numbers, and images in Excel. - Creating formulas to perform calculations and manipulate data. - Conducting data analysis, including the creation of charts to illustrate findings. Ideal skills and experience for this job: - Proficiency in Microsoft Excel - Familiarity with critical Excel functions such as Vlookup, Pivot tables, and Conditional formatting. - Prior experience with data entry projects, particularly those in...
I'm in need of a seasoned professional, who is experienced in data entry. Your primary role will involve: - Copying specific data. - Pasting into a pre-formatted Excel template I will provide. Who can apply? Ideal applicants should be proficient in Microsoft Excel and have sound experience with data entry, particularly copying and pasting data. Attention to detail is key in this role, to ensure complete accuracy of the data copied. Familiarity with Excel files is also required. Please show proof of similar tasks you've completed previously.
I require a reliable professional to assist with spreadsheet data entry sourced from PDF scanned documents. This task requires accuracy and attention to detail as the information will be utilized for important analysis and reporting. - Ideal Skills and Experience: - Proficient in Excel or similar spreadsheet software. - Experience in data entry from scanned documents, particularly PDF format. - Strong typing skills, emphasizing precision. - Ability to read and interpret various types of documents. - Proven ability to work with confidential or sensitive information. Please quote efficiently considering the complexity of data extraction from a PDF scan. I look forward to working with a diligent and meticulous individual on this project.
I'm seeking an experienced Excel user to type in less than 500 text entries into an Excel sheet. The data will be organized into rows and columns. Skills & Experience Required: - Proficiency in Microsoft Excel - Proven experience in data entry - Attention to detail Looking forward to seeing your bids.
...products , sells vegan services . the data must be categorised per industry . The main task of this project is web scraping to compile a comprehensive list of vegan companies. I want to prioritize data from company websites. so i need at least 100 vegan restaurants , grocery stores , manufacturers of food products , hotels that are vegan , or offer vegan meals , airline companys , vegan leather companys , vegan nutritional specialists , Vegan Doctors , that are vegan from each country . start with major cities in the world . countries USA . canada , uk , spain , south africa , austrailia, India , Key pieces of information needed for every company: - Company Name - Product Description - Location - Services offered - their logo i can give i a excel spreadsheet t...
I am seeking an experienced professional, skilled in typing text, data entry, and Excel sheet preparation. I require assistance with approximately 10-50 pages of work. - The project involves both typing text and data entry tasks. Accuracy is paramount. - Furthermore, an essential part of this project is Excel preparation. This is more than just basic data entry and formatting. Adept knowledge and application of Excel macros and pivot tables is a must. Ideal candidates for this project would possess strong typing skills, a keen eye for detail, and advanced Excel capabilities, especially in the creation and utilization of pivot tables and macro functions. A strong track record for precision in data entry tasks is also necessary.
...expert who can help with automation in Excel. The specific tasks will be discussed more in detail once we've settled on the right freelancer, but it will involve creating macros to streamline operations. Key Responsibilities: - Developing and implementing macro scripts - Enhancing the existing process to improve efficiency - Offer solutions and improvements in the process Ideal Skills: - Proficiency in Microsoft Excel - Proven experience in developing macros - Strong comprehension of Excel functions and VBA - Excellent problem-solving abilities - Ability to work independently This project is a great opportunity for anyone who loves problem-solving and efficiency. Your contributions will make a significant impact by streamlining our operations in Excel...
Hi We are a start-up English online courses Academy in Egypt, and we are looking for a remote VA/Data entry person who is willing to grow with us (hopefully, the project can develop into a long-term project). The salary and budget are very tight, because we are just starting out. But we hope that the budget will increase in the future, once the business become up and running. I am searching for a remote VA and Data entry professional, who can help me promote my English Academy on social media (Facebook, Instagram, and TikTok). The VA tasks will be as follows: 1. Create weekly 10 posts (Images) (about English-Learning content) on Canva. You can use AI to find ideas. These 10 posts will be used to share them on social media across the week. (2 posts per day x 5 days a week)...
As a passionate data analyst, I will share you more details freelancer.com. I need it urgently. Thanks
I'm in need of a detail-oriented data entry operator with a strong command of Microsoft Excel, particularly around intermediate-level skills, such as using VLOOKUP and HLOOKUP functions. Your tasks will primarily focus on: - Entering data accurately and efficiently into Excel - Formatting data in a standard format to maintain consistency - Creation of visually complex charts and graphs is not required, however, a basic understanding is appreciated. Ideally, you would have previous experience in data entry positions and a demonstrated ability to manipulate Excel functions at an intermediate level. Do you have what it takes to ensure accuracy and speed in data entry? This might be the perfect opportunity for you.
I'm in need of a specialist by my side who understands the power of conditional formulas in Excel. My focus is on performing specific calculations based on certain conditions within my financial records. Key Tasks: - Developing and refining conditional formulas in Microsoft Excel - Ensuring accurate and efficient calculations on financial records - Quality checking for any potential errors Ideal Freelancer: The right person for this project is an adept Excel user with a deep comprehension of conditional formulas. Prior experience in financial data management would add a feather in your cap. Moreover, if you have a knack for spotting and resolving errors in data analysis, you might be the perfect fit.
...expert who can help with automation in Excel. The specific tasks will be discussed more in detail once we've settled on the right freelancer, but it will involve creating macros to streamline operations. Key Responsibilities: - Developing and implementing macro scripts - Enhancing the existing process to improve efficiency - Offer solutions and improvements in the process Ideal Skills: - Proficiency in Microsoft Excel - Proven experience in developing macros - Strong comprehension of Excel functions and VBA - Excellent problem-solving abilities - Ability to work independently This project is a great opportunity for anyone who loves problem-solving and efficiency. Your contributions will make a significant impact by streamlining our operations in Excel...
I am currently seeking a passionate and skilled writer with experience in eBook writing to work on a "how-to" eBook about public speaking, specifically designed for an intermediate level audience. This project comes with a budget of $70 USD for a 7,000 words manuscript. Your tasks...completion of this project, I will have full rights to the eBook and all its content. Project requirements: - Must provide previous work samples - Must adhere to the project deadline of 14 days - Experience writing "how-to" eBooks or similar contents Please note that full payment will only be issued upon the completion of the project, with No upfront fee. If this sounds like a project you can excel at, don't hesitate to send in your past work samples for my reference and I...
I'm looking for an expert database developer to replace our current Excel-based performance tracking system. We have 150-200 drivers whose information we need to store and analyze. Data includes: - Driver Names - Delivery Volume and Stops Made - Hours Worked, Breaks, Punch In/Out - Delivery Stops Completed Per Hour Having daily access to this data is critical for managing our operation effectively. It's imperative that the database is designed for easy querying on any given day. In addition, automated report generation is a significant upgrade I’m looking for. Specifically, the database should be able to create: - Delivery Performance Reports - Work Hours Reports The ideal candidate for this project should have a strong background in database desi...
I'm in the market for an experienced accounting professional who can competently handle a range of tasks. The scope of work will include: - Bookkeeping - Financial analysis - Tax preparation You should be well-versed in QuickBooks, Excel and Xero as they are the main tools for my accounting tasks. Your role also entails delivering weekly accounting updates and reports. Please only bid on this project if you have a clear understanding of these applications and tasks. Previous experience in similar positions is highly desirable.
...for an expert in data visualization who is experienced with Excel, particularly in creating interactive line graphs. I have a recurring monthly data set with complex multidimensional features that I'd like to transform into clear, understandable visual representations. Key Tasks: - Create line graphs from multi-variable, multidimensional monthly data - Ensure the graphs are as interactive and user-friendly as possible - Provide insights on the patterns and trends from the data Ideal Candidate: - Proficient in Microsoft Excel and data visualization tools - Must have experience dealing with complex data sets - Able to produce minimalistic, clear, and interactive graphs - Possesses excellent attention to detail and stron...
This project involves the creation of an Excel sheet that's intelligently designed to use multiple 'if' statements in order to compute which tier of payments is due, in accordance with the tier specifications provided. You'll be working with payment tiers that are consistent for all calculations. All the 'if' statement conditions will be based on the Payment Amounts; you'll need to structure your statements primarily around this element. Key project specifics: - The 'if' statements will be based on specific payment tier ranges. - Detailed guidance and specifications for these tiers will be provided. Ideal Skills: - Proficiency in Excel and excellent command over using 'if' statements - Exceptional attention to detail ...
...para generar textos. - Mantener un lenguaje claro, concreto y consistente en todas las descripciones. Requisitos: - Cumplir con los plazos establecidos. - Las descripciones son en español. - Se puede utilizar software como Selenium, Puppeteer o Headless para las capturas de pantalla. - Familiaridad con el uso de herramientas de generación de contenido como ChatGPT. - Se entregarán todo en excel. ----------- Ejemplo de Estructura de Descripción: - Imagen captura de pantalla o logo. - Descripción: Breve introducción a la aplicación y su propósito. - Funcionalidades: Detalles sobre las características principales de la aplicación. - Ventajas: Beneficios específicos que ofrece la aplicación...
Necesito a alguien con un gran entendimiento y experiencia en la recopilación de datos. El proyecto consiste en obtener datos de texto de fuentes abiertas al público. Responsabilidades clave: Recopilar datos de texto específicos de diversas plataformas públicas. Garantizar una recopilación de datos precisa y detallada. Devolver los datos en formato Excel con una estructura concreta. Freelancer ideal: Debe ser detallista. Experiencia en la recopilación de datos de fuentes públicas. Fuertes habilidades de investigación.
