Cara membuat data di excel 2010 jobs
I'm looking for a professional with excellent data entry skills to help me transcribe mixed data from physical documents into an Excel spreadsheet. Requirements: - Proficient in Excel and data transcription - Able to accurately transcribe mixed data (text and numeric) - Experience working with physical documents - Attention to detail to ensure data is entered correctly
I need an Excel macro that can automate the creation of product labels. The macro should be able to generate labels that include: - SKU number - SKU Description - UOM (Unit of Measure) - Up or Down Arrow The ideal freelancer for this project should have extensive experience in Excel and VBA (Visual Basic for Applications) for creating macros. Please provide examples of similar projects you have completed. The macro should recognize various size labels based on avery sheet label sizes. The Description, font size and number of characters should adjust based on size of label. I have existing file but would like to review as I speak to a developer to ensure needs are understood before sharing.
Excel project as discussed And separating the pdf bills
I'm looking for an Excel expert to set up a comprehensive database for tracking customer information, specifically contact details and addresses. Key Requirements: - Design an Excel database to track customer information effectively. - Incorporate automated data entry forms to streamline data input. - Develop customizable reporting templates for tailored data analysis and reporting. Ideal Skills & Experience: - Proficiency in Microsoft Excel, with extensive experience in database setup. - Prior experience in designing automated data entry forms and customizable reporting templates. - Knowledge in data analysis and reporting.
I need assistance with data entry and PDF file management. Specifically, I have a series of PDF bills that need to be processed. Tasks: - Enter bill details from the PDF into an Excel sheet with specific column headings. - Split the PDF files into smaller PDFs based on date ranges. Ideal Skills: - Proficient in Excel with experience in data entry. - Familiar with PDF splitting software or tools. - Attention to detail to ensure accurate data entry and proper file splitting.
I'm in need of a skilled developer who can create an API for me that retrieves various product data in real-time. This includes everything listed on an Excel file I will provide, such as price information, inventory status, and product descriptions. Key responsibilities: - Develop an API that can retrieve all product data listed on the provided Excel file - Ensure the API operates in real-time - Implement necessary data transformation for optimal retrieval Ideal skills and experience: - Proficient in API development - Experience with real-time data retrieval systems - Familiarity with handling and transforming data from Excel - Prior experience with product data APIs is a plus. Please bid only if you can deliver a hig...
I'm seeking an efficient and detail-oriented freelancer for manual Excel data entry of product inventory. The job primarily involves: - Inputting data from various sources into Excel spreadsheets - Ensuring the accuracy and completeness of the data - Identifying and rectifying data discrepancies Ideal candidates should have: - Proficiency in Excel - Excellent attention to detail - Experience with data entry - Skills in identifying and correcting errors in data Please apply if you have these skills and are ready to start immediately.
I'm looking for a skilled Excel developer who can create a customized desktop-based Excel application for me. This application should help me track my progress on various claims, manage each claim, and keep a record of estimates I need to write and follow-up calls I need to make. Key Features: - Progress Tracking: I should be able to see my progress on each claim. - Claim Management: Each claim needs to be accounted for. - Follow-Up Reminder Notifications: The application should have a system for reminding me of follow-up calls so no claim gets lost or forgotten. The ideal freelancer for this project should have extensive experience with Excel and desktop application development. They should be able to deliver a comprehensive tracker that is easy to navi...
I'm looking for an experienced SAP OOPS coder with a strong focus on ALV Reports. Key Requirements: - Expertise in implementing factory method ALV grid output - Ability to import data from Excel into ALV Reports Skills and experience: - Proficiency in SAP OOPS coding, particularly in ALV Reports - Prior experience in Module Pool programming - Knowledge of creating and manipulating ALV Reports for various functionalities - Strong understanding of Object-oriented programming within SAP - Familiarity with Excel data import processes in SAP OOPS
I need assistance in creating a Macro that would convert data from multiple worksheets in an Excel workbook into pipe-delimited flat files. - Data Source: The data is sourced from multiple worksheets within the same Excel workbook. - File Representation: I want specific worksheets to be converted into flat files, not all of them, nor a single combined file. -Worksheet Selection: The specific sheets to be included in the conversion follow a particular naming pattern. - Create header from a specific cell in worksheet and pull data from specific row Ideal skills for this project should include: - Proficiency in Excel Macro Please include examples of similar past projects in your bid.
...am in the process of developing an Excel spreadsheet for a project. I require professional assistance in creating this spreadsheet, which will primarily involve numerical data. Key Needs: - Implementation of Formulas and Functions: I need these to manipulate and analyze the data effectively. - Creation of Charts and Graphs: These will be used to visually represent the data, so I need someone skilled in designing clear, accurate, and visually appealing graphs. - Using Pivot Tables: I need help in organizing and summarizing my data using pivot tables. Ideal Skills: - Advanced Excel expertise: You should be proficient in using Excel and have a strong understanding of its features. - Data Analysis Skills: You should be able to help ...
...automate the processing of results from Microsoft Forms. This includes generating reports in Excel and sending automatic emails via Outlook based on the results. For example if the answer to one of the questions on the microsoft form is "NO" an email will automatically send to a specific email address with other key data from the microsoft form. Key requirements: - Create an automated system to generate Excel reports from Microsoft Forms results. - Develop a mechanism for sending automatic emails through Outlook based on the data. - Ensure the system is user-friendly and efficient. Skills & Experience: - Proficient in Microsoft Forms, Excel and Outlook. - Previous experience in automation of data processing preferred. - Strong u...
I need assistance with entering text data from online content into Excel. The job involves basic formatting such as using bold and italics where needed. Ideal skills and experience for the job include: - Proficiency in Excel - Attention to detail - Ability to follow formatting instructions - Familiarity with data entry from online sources
I need an experienced Excel professional to refine my financial report. The tasks will primarily involve: - Creating visually appealing and informative graphs and charts - Specifically, I need a pie chart to represent a portion of the data An ideal freelancer for this project should have: - Extensive experience with Excel, particularly in working with financial reports - A keen eye for detail, ensuring all visual representations are accurate and well presented - Skills in creating engaging and informative visuals that can enhance the readability and understanding of the report Please include examples of similar projects you've completed in your bid. Thank you!
I need an experienced Excel professional to refine my financial report. The tasks will primarily involve: - Creating visually appealing and informative graphs and charts - Specifically, I need a pie chart to represent a portion of the data An ideal freelancer for this project should have: - Extensive experience with Excel, particularly in working with financial reports - A keen eye for detail, ensuring all visual representations are accurate and well presented - Skills in creating engaging and informative visuals that can enhance the readability and understanding of the report Please include examples of similar projects you've completed in your bid. Thank you!
I need a simple yet effective Excel dashboard to track various project management KPIs. Key Features: - Track a combination of Time-related, Cost-related, and Quality-related KPIs. - Display all KPIs in a clear and organized table format. - Designed for manual data entry, no need for importing data from external sources. Ideal candidates for this project should have: - Proficient Excel skills, particularly in creating tables and managing data. - Previous experience in project management and understanding of relevant KPIs. - Ability to deliver a user-friendly and intuitive dashboard.
I'm seeking assistance with Power BI for the creation of reporting dashboards. Key requirements: - Connecting to Excel sheets as the primary data source. - Crafting interactive dashboards featuring charts and graphs. Ideal candidates should have: - Proficiency in Power BI. - Experience with Excel data connections. - Skills in designing interactive visualizations.
We are looking for a developer who can create a model using the Amazon API. We will provide access to the API. Below are the ...our Shopify store. Checking each listing one by one for price and stock updates is a tedious and time-consuming task. Task Description: We will provide a list of ASINs in an Excel file. Your task is to use the Amazon API to fetch the following data for each ASIN: Current Price Stock Status (in-stock or out-of-stock) This data should be updated daily. Example Scenario: On January 1, 2025, 1,000 listings are uploaded to our Shopify store with a price of $99 and stock of 10 units each. By January 2, 2025, the price for some products changes to $109, and stock drops to 5 units. Using the Amazon API, we need the updated data reflecting the...
I'm looking for an RPA developer with extensive experience ...developer with extensive experience in Microsoft Power Automate Desktop or UIPath. The primary goal is to automate repetitive tasks that involve data entry and file/document management. The automation should specifically interact with Excel and our own in-house ERP system. Key Responsibilities: - Implementing RPA solutions using Microsoft Power Automate Desktop - Automating data entry and file/document management tasks - Ensuring smooth interaction with Excel and our in-house ERP Ideal Skills and Experience: - Proficiency in Microsoft Power Automate Desktop - Prior experience with automating data entry and file management tasks - Familiarity with Excel and ERP systems - Strong und...
Hi. It’s supposed to generate teams based on data from several sheets, but it’s not working as I need. Additionally, I would like to have a button to update the data for each game week. I’m attaching the code so you can review it and help me out if possible. Thanks in advance!
I'm looking for an RPA developer with extensive experience in ...an RPA developer with extensive experience in Microsoft Power Automate Desktop. The primary goal is to automate repetitive tasks that involve data entry and file/document management. The automation should specifically interact with Excel and our own in-house ERP system. Key Responsibilities: - Implementing RPA solutions using Microsoft Power Automate Desktop - Automating data entry and file/document management tasks - Ensuring smooth interaction with Excel and our in-house ERP Ideal Skills and Experience: - Proficiency in Microsoft Power Automate Desktop - Prior experience with automating data entry and file management tasks - Familiarity with Excel and ERP systems - Strong und...
I have a comprehensive Excel file containing purchase and sale details that needs thorough analysis and a dashboard built in a corporate visual style. Key Requirements: - Dashboard: It should display stock quantity, total amount, and total quantity, broken down by brand, type, and color. - Stock Analysis: I need to see overall stock quantities by brand, type, and color, as well as date-wise tracking to see if a specific product is sold from a purchase date using FIFO method. - Purchase Details: Total quantity and amount of purchases should be calculated, alongside a slicer to view specific combinations of brand, type, and color. A macro to add new entries is also required. - Sale Insights: Total quantity and amount of sales, with a slicer for specific combinations, a macro for new...
Write a heading in your bid: Your location & if civil engineer then yes /if not then no for eg. " Lucknow, yes/No" Note: please read the project details before bid . I will only ...only consider the profile with heading only. I need Lucknow candidate for this project. And if you are a civil engineer then type yes otherwise no. I'm looking for a civil engineer based in Lucknow to assist with a data entry project. The ideal candidate will have experience in construction and be able to understand the context of the data. Key Responsibilities: - Data entry from PDF files into Excel spreadsheets - Ensuring accuracy and attention to detail Skills and Experience: - Based in Lucknow - Civil engineer - Familiarity with construction project data...
I'm looking for an Excel expert to create a financial data sheet for budget tracking. The sheet will need to: - Support budget tracking - Include automatic calculations Ideally, you have prior experience in creating similar sheets and can provide examples of your work. Your understanding of financial data and budget tracking will be crucial to the success of this project. Please ensure you have the necessary skills to create a comprehensive, user-friendly Excel sheet.
I need assistance in extracting data from PDF documents and entering it into an Excel spreadsheet. Data to be extracted: - Invoice Number - Date - $ Amount Looking forward to your bids!
I'm looking to set up a straightforward cloud flow with Microsoft Power Automate. This flow should be triggered whenever any changes occur in a specific Excel file stored in SharePoint. Key Features: - Activation of a pre-written desktop flow upon detecting any alterations in the Excel file. - No additional tasks or notifications required post desktop flow execution. - The sole trigger for this cloud flow is any sort of modification to the Excel file. Requirements: - Proficiency in Microsoft Power Automate is essential. - Experience with SharePoint and Excel is highly desirable. - Skills in setting up simple, effective automation flows. Please note, this project does not require any error handling or notifications in case of flow failures.
I'm seeking an experienced professional to manage and enhance our Kaufland account over the next three months. If you excel in this role, there's potential for continued employment. Your primary responsibility will be to increase sales through targeted marketing campaigns on Kaufland, as well as optimizing our product listings for maximum visibility and appeal. Previous experience with Kaufland is a must, and a proven track record of driving sales on the platform will be a significant advantage. Our marketing strategy will be focused on Kaufland-specific ads. Therefore, familiarity with the platform's advertising systems and strategies is crucial. Your ability to create compelling ad content and strategically position our products within the marketplace will be key ...
...to be replaced by this application. - An application capable of managing a fleet of new and/or used vehicles (Cars, Motorcycles, Other Vehicles), detailing every minute characteristic of the vehicles. - Every detail of the vehicle is stored in order to have a detailed record even years later. - General vehicle data and accessories - Purchase data: supplier, invoice payable, cost, depreciation and vehicle stock in our fleet - Sales data with details of minimum price to be realised, final price, deposit, as well as invoices for the sale and transfer of ownership costs. These can also be automatically created with a single click. - Printout of sales contracts, order proposal, declaration of liability, for...
I'm seeking a meticulous data entry expert who can assist in manually entering data from my scanned documents into an Excel spreadsheet. Ideal Skills: - Proficient in data entry - Excellent attention to detail - Familiarity with Excel Experience Required: - Previous experience with manual data entry from scanned documents is a plus - Proven track record of maintaining data accuracy
Top Skills, Strengths, and Experience: I excel in digital marketing and sales, with a proven ability to craft effective strategies that drive results. My expertise includes social media marketing, SEO, lead generation, and conversion optimization. I have strong analytical skills, enabling me to identify growth opportunities and deliver data-driven solutions. My communication and relationship-building skills are a key strength, helping me connect with clients and foster long-term partnerships. Services Offered: Digital Marketing Strategy Development: Crafting tailored campaigns to meet business goals. SEO and Content Marketing: Improving online visibility and engaging target audiences with high-quality content. Social Media Management: Creating, scheduling, and analyzing c...
...Performance Indicators (KPIs), which are outlined in a provided PDF. Initially, the data source will be from Excel. Language: Arabic then English Key Details: - Primary Users: The dashboard is intended for Executives, so it should be intuitive and visually appealing. - Visualizations: The dashboard should include a variety of visualizations, specifically Bar charts, Line graphs, and Pie charts. - KPIs: The KPIs to be tracked have already been defined and can be found in the PDF document. Ideal Skills: - Extensive experience with Power BI/Tableau - Ability to create executive-level dashboards - Proficiency in Excel - Knowledge of data visualization best practices - Experience interpreting and visualizing business data Your bid should reflect your ex...
I need an experienced Excel expert to correct errors on my existing timesheet salary calculator. Skills and experience required: Strong proficiency in Excel, experience in financial modelling, and familiarity with creating interactive and automated Excel sheets.
I'm looking for someone to edit my inventory data in Excel. The task involves moving data from one file to a new one with a different layout. The new layout requires: - Reordering columns - Adding new fields - Combining data from multiple sheets There are specific formatting requirements for the new layout, which includes the use of certain cell colors and font styles. Ideal candidates for this project should have: - Extensive experience with Excel - Strong attention to detail - Ability to follow specific formatting guidelines - Experience working with inventory data.
...skilled data scraper to extract information from the Costco mobile app. The task involves multiple locations and specific product IDs. here is the app: I have attached the locations, productids for which data needs to be scraped. I have also attached the sample data for fields which we need. Key Requirements: - Scrape data from the Costco mobile app for various locations and product IDs. - Gather a pre-defined list of information for each product (to be shared in an Excel file). - Output the data in a CSV file. Initially, I need the data for one location. If the first batch is successful, I will require the code used for the scraping as well. Ideal Skills: - Proficient in data scraping and using tools for web and app dat...
I'm seeking an experienced Amazon FBA Stock Manager to estima...include: - Forecasting sales for current products - Managing seasonal inventory trends - Coordinating with logistics partners - Analyzing sales data The ideal candidate should have: - Strong analytical skills - Excellent understanding of Amazon's marketplace dynamics - Experience in managing stock levels to maximize in-stock rates for both new and existing products - Ability to maintain a healthy Inventory Performance Index (IPI). Prompt communication is key, especially when informing the team about stock in China that needs to be liquidated. Skills in market demand forecasts, competitor analysis and supplier lead times are crucial. Proficiency in Excel is a must, and familiarity forecasting tools w...
I'm seeking an experienced Amazon FBA Stock Manager to estima...include: - Forecasting sales for current products - Managing seasonal inventory trends - Coordinating with logistics partners - Analyzing sales data The ideal candidate should have: - Strong analytical skills - Excellent understanding of Amazon's marketplace dynamics - Experience in managing stock levels to maximize in-stock rates for both new and existing products - Ability to maintain a healthy Inventory Performance Index (IPI). Prompt communication is key, especially when informing the team about stock in China that needs to be liquidated. Skills in market demand forecasts, competitor analysis and supplier lead times are crucial. Proficiency in Excel is a must, and familiarity forecasting tools w...
...delivering a detailed database of 7,000 US companies. Each company profile must encompass key details like the company name, and its associated emails (e.g CEO email, Owner email, Founder email etc.) along with the website. Key Requirements: 1. All data must be current and verified for precision. 2. Data must be sourced from credible platforms to ensure uniqueness, eliminating any duplication. 3. Final data should be presented in an orderly Excel or Google Sheets format. 4. Timely delivery within 7 days from the project start date. 5. Proficient use of data scraping and verification tools and platforms. Please ensure to read the project description carefully before bidding. If you're not in agreement with the budget or are unable to fulfill the ...
...delivering a detailed database of 7,000 US companies. Each company profile must encompass key details like the company name, and its associated emails (e.g CEO email, Owner email, Founder email etc.) along with the website. Key Requirements: 1. All data must be current and verified for precision. 2. Data must be sourced from credible platforms to ensure uniqueness, eliminating any duplication. 3. Final data should be presented in an orderly Excel or Google Sheets format. 4. Timely delivery within 7 days from the project start date. 5. Proficient use of data scraping and verification tools and platforms. Please ensure to read the project description carefully before bidding. If you're not in agreement with the budget or are unable to fulfill the ...
...restrictions: - Visibility of Microsoft Word and Excel icons on all local users' desktops. - Display of a specific, read-only folder on the C drive on all local users' desktops. The folder is a custom one, please reach out for specifics. The technician must have Windows 11 23H2 to ensure effective troubleshooting. Microsoft's Office 2021 should be included in the XML. Ideal skills and experience for this project include: - Proficiency in creating assigned access XML files for Windows 11 - Familiarity with Microsoft Configuration Designer - Access to Windows 11 23H2 and Office 2021 for effective troubleshooting - Ability to follow specific, detailed requirements attached is the xml file i am working with, i need someone that can edit it in order for word,ex...
**Project Description: I am seeking a skilled freelancer to transform an existing employee schedule from a basic Excel format into a modern, visually appealing design. The goal is to enhance the user interface and overall aesthetics, making it intuitive and easy to navigate for both management and staff. The redesigned schedule should incorporate interactive elements and be adaptable to various devices, ensuring accessibility and usability. The ideal candidate will have experience in UI/UX design and a strong understanding of creating visually engaging digital tools.
I need a professional-grade Excel template with dropdown lists to help track visa statuses for employees. The template should have the following fields: - NAME/LAST NAME - PROFILE (Dropdown: RADS or OPS) - CONTRACT TYPE (Dropdown: FT or PT) - VISA PROCESS CALL (Dropdown: yes, not yet) - DATE (blank) - VISA (Dropdown: requested, lodged, granted, renewed) - FAMILY (Dropdown: yes, no) - VISA EXPIRES (blank) - PASSPORT NO (blank) - PASSPORT EXPIRES (blank) - RELOCATION (Dropdown: initial consultation, 5 days package, in progress) - FLIGHT (Dropdown: initial consultation, booked) - IT (Dropdown: requested, not yet) - CONTRACT (Dropdown: signed, approved, amended, in progress) - REPORTING COUNTRY (Dropdown: SCAN, UK, NA) - COUNTRY (Dropdown: AUS,NZ) - OFFICE LOCATION (Dropdown: Noosa, Sy...
...expert in data research who can help me investigate customer data. The primary focus will be on gathering staff contact information for 250 companies. I want the entire staff contact list with email and phone. This is the list of the 250 companies with their website links. Example of the staff list for first company CRMLS The ideal freelancer for this project should have: - Proven experience in market research, particularly customer data. - Strong analytical skills to interpret complex data sets. - Proficiency in Excel to organize and present the data. The final deliverable should be in the form of detailed Excel spreadsheets that clearly present the researched customer data. Provide
I need a PowerBI dashboard to monitor project performance. The dashboard should track progress against milestones and budget vs actual costs. The data sources include Excel spreadsheets and various Cloud services. Ideal skills and experience for this job include: - Proficiency in PowerBI - Experience in project performance tracking - Skills in connecting PowerBI to Excel and Cloud services - Expert in data visualization and interpretation -Understanding of budgeting terms - developing a dashboard that can be updated by end user
I'm looking for a skilled developer to build an app delivering professional services (task management/organisation). This app should be av...that information will then need to be collated and presented to other users. Key Features: - Task management capabilities - User-friendly interface - Notifications - Capacity to involve multiple users - Users will input preferences and information will be provided/priorities will be amended based on those preferences - On the 'backend', I want it to create something like an excel spreadsheet, so data can be gleaned and used - Cross-platform compatibility Ideal Skills: - Proficiency in iOS and Android app development - Experience in building apps - Strong UI/UX design skills Please provide examples o...
I'm in need of a freelancer who can help me draft an audit report for a small city. The ideal freelancer for this project should be a seasoned report writer with extensive experience with Microsoft word and excel.
...professional to extract data from 500-700 high-quality photographed pages containing handwritten text. The primary task is to accurately digitize the information into a structured format. The key fields to extract and verify are: Full Name Email Address Phone Number Permission for Commercial Communications (marked as "Yes" or "No"). Consent for Image Rights Usage (indicated by an "X" or no mark). Additionally, if the process allows automation or is otherwise feasible, we would like to capture the following optional fields: Last Name Country Language City Instagram Handle Date of Birth Correlation with Photo File Number The Name, Email, and Phone Number fields are critical and must be thoroughly checked to ensure zero errors. Requ...
...support, customized control panel per user. Modern Interface: Clean, user-friendly and mobile-friendly interface. Per Message Charge: A system of charging per message sent. Users are charged according to the campaign type and sending volume. 2. WhatsApp Marketing Tools Bulk Message Sending: Sending messages to multiple people with a single click. Uploading Contacts: Uploading numbers in bulk via Excel/CSV file. Message Scheduling: Automatic sending of messages at a specific date and time. Multimedia Messages: Sending messages that support images, videos, documents and other media files. 3. Chatbot Features Auto Responder: Automatic sending of predefined responses to incoming messages. Smart Chatbot: Customizable message flows based on user behavior. Keyword Detection: Sending m...
E-commerce Product Optimization Overview: Our website's navigation is hindered by an overwhelming number of products and outdated categories, making it difficult for customers to find and compare items. We are seeking a project-based contractor to streamline and reorganize our product categorization, improving usability and searchability for a better ...Function-Based Categorization: Products are grouped by primary function, enabling intuitive exploration, discovery, and comparison. Streamlined child categories under each parent category to eliminate redundancy. Products are assigned to the most relevant single category, avoiding cross-category duplication. Next Steps Enhanced product titles and descriptions based on logical categories Skill Sets: Excel chat-GPT Familiarity...
I'm in need of a skilled web scraper capable of extracting data from a webpage with 5,500 products. These products do not have variants, which should simplify the task. Data to be scraped: - Product name - Product Part Number - Product description (The product descriptions aren't formatted the same way for each product. They are inconsistent but similar.) The final deliverable should be an Excel/CSV file containing all the scraped data, sorted by product name. Ideal skills for this project include: - Proficient in web scraping - Proficient with AI - Experienced in data organization and Excel/CSV Please, only bid if you can deliver quality work in a timely manner. Thank you!
