I need someone to build a excel workbook jobs
Looking for a professional with expertise in Excel to create spreadsheet templates for our business data analysis and financial tracking needs. Key Responsibilities: - Design spreadsheet templates that can effectively analyze various types of business data including: - Daily payments - Dues - Closed accounts - Daily totals - Carry forward amounts - Incorporate functions that assist in financial tracking. Ideal Skills and Experience: - Advanced proficiency in Excel - Excellent analytical skills - Previous experience in financial tracking and data analysis - Understanding of business processes and financial variables. Please provide examples of similar work accomplished and ensure you're able to meet all specified requirements.
I require a data analyst with proficiency in PowerBI to create a dashboard focused on analyzing compensation rates based on demographic details. I've attached a rough markup and source data. Will need this completed in a short timeframe due March 7th by 8am PT. The data source will probably need some cleaning in Power Query to be able to be presented accurately. You don’t need to recreate exactly, so feel free to add anything that you think would be worthwhile to look at. Thanks!!
I need a capable freelancer to extract both text and image data from a specific app and translate it into both Word and Excel formats. Here's what's required: - Extract text and image data from app - Efficiently rewrite this information into Word and Excel files - There's no need to organize the data according to any specific criteria within the Excel document, offloading it randomly is perfectly acceptable Preferably, the freelancer should have excellent data entry skills and proficiency in using Word and Excel. Experience with data extraction from apps would be a plus. There is around 800 questions.
I am looking for a skilled professional that can create an intuitive and reporting-rich Tableau dashboard from a set of data in Excel spreadsheets. Key Deliverables: - Data Analysis: Analyze the set of data from the Excel spreadsheet to create insightful visualizations and reports in Tableau in a user-friendly way. - Data Visualization: Develop a histogram visualization tool that will be included in the Tableau dashboard to enhance readability and clarity of insights derived from the data. - Data Filtering: Implement a Category-based filter system to ensure ease of use and data accessibility. This should allow users to effortlessly navigate through our data set. Ideal Candidate: - Proficient in Table...
I want to create an unlimited chrome tool or addon with functions like the addon below
I need a freelancer to do the following using Excel macro. 1. Collect Web URLs and name. Using my LinkedIn, I will open multiple tabs in the web browser (happy to use the browser of your choice). Each Tab will have a different person's profile. I will execute the macro prepared by the freelancer, this macro will do the following: a. Navigate to each tab. b. Collect URL in Excel (col A) c. Collect person's name in col B d. Collect person designation in col C. 2. I will manually review the data collected in Excel and create another list in a separate Excel containing the person's profile URL and message. I will execute the second macro created by the ...
I'm in need of someone with substantial experience in web scraping, particularly extracting data from dynamic and complex websites. The project involves two main tasks: 1. Web Scraping: - I require specific data from , specifically, the "All-Time High" (ATH) price data from any coin listed. It is important to be well-versed in scraping techniques to navigate the website and extract this specific piece of information accurately and efficiently. 2. Data Extraction: - Use Excel VBA macro to extract the data. In one column there will be the urls of the coins to extract the ATH, like this one - The macro will rerturn the ATH value in the next column. - The macro will run clicking a button. - The macro will end ...
...can create a customized Chrome extension for me aimed at my webmail client - webmail.free.fr. (ROUND CUBE) This extension needs to be capable of automating email sending processes by pulling recipient's data from Excel files on my desktop. Rather than a predefined email template, the extension should allow for dynamic content from these Excel files to be sent as the email body. Successful freelancers interested in this job should definitely mention their experience and extend their portfolio that highlights their skills ideally in the following areas: * Chrome Extension development * Automation processes * Experience in coding for webmail service – in this case, '' * Advanced knowledge of Excel and data handling ...
I have an excel sheet in which i have varied and diverse range of products from Audio Gadget Category. For each product, i have certain aspects which i want you to research and just fill it in. I will attach the screenshot of it for your reference. There are total 75 products and total of 7 aspects, as mentioned in the attached screenshot.
I need a person to type and hold data entry from PDF files to Excel Format. Aproximate 20 Pages of data concerning tablets and graphiics to bem digitalized.
I am in desperate need of an Excel expert with an accounting background who can fix the incorrect calculations and formatting issues plaguing my Balance sheet and Profit/Loss sheet. The historical data period needing corrections remains unspecified, implying it might range from a year or more. Here's what I need from you: - Proven track record working with Excel accounting - Fine attention to detail and accuracy - Ability to work with missing information - Prior experience in managing and fixing financial data - Expert knowledge of accounting principles and practices Your main role would be to meticulously review and correct any calculations and formatting, making sure my Balance sheet and Profit & Loss she...
I am in desperate need of an Excel expert with an accounting background who can fix the incorrect calculations and formatting issues plaguing my Balance sheet and Profit/Loss sheet. The historical data period needing corrections remains unspecified, implying it might range from a year or more. Here's what I need from you: - Proven track record working with Excel accounting - Fine attention to detail and accuracy - Ability to work with missing information - Prior experience in managing and fixing financial data - Expert knowledge of accounting principles and practices Your main role would be to meticulously review and correct any calculations and formatting, making sure my Balance sheet and Profit & Loss she...
I'm in search of a competent coder with specific skills in Macro for an Excel based project. The ultimate goal is to automate a certain process, thereby making tedious tasks less time-consuming and more efficient. Specifically, I am looking for someone who: - Has proven experience in Macro coding, particularly in relation to Excel - Can demonstrate a portfolio of past work that involved creating macros for the purpose of automating work processes - Is capable of understanding the workflow and creating a macro that reduces manual input You will be tasked with improving our existing workflow through automation by developing a custom Excel macro. Dialogue and communication will be crucial in understand...
I am currently in need of a professional with strong skills and experience in Microsoft Excel and English typing. The work will involve: - Typing text data onto an Excel sheet - The language predominantly used in the text data is English - The structure of the text data on the Excel sheet is unknown as I wasn't able to provide this information. An ability to work with data in both rows and columns or mixed formats might be required. Skills required: - Extensive experience using Microsoft Excel - English fluency - Fast and accurate typing skills - Attention to detail - Ability to work with potentially varying data structure. Please reach out if you feel this project suits your set of skills.
I'm in need of an expert who can perform a comprehensive financial analysis of cost structures, specifically organized by project, in my Excel data. Key Responsibilities: - Analyzing and interpreting complex cost structures from Excel data - Delivering a clear and concise report based on the analysis Ideal Skillset: - High proficiency in Excel - Solid background in financial analysis - Experience in cost analysis by project - Excellent data interpretation skills The output of this project will play a crucial role in refining our budgeting and financial planning. Expertise in handling similar projects is a must. Thanks in advance for your interest and bid.
...Each data set is a column. Each of the data sets/columns has 7 out of 49 numbers selected as Process numbers. These are given in bold red. Now, the last column, the rightmost column, is the target data set for prediction. All other columns are data sets to be used for training the model. The project's ultimate objective is to predict the 7 process numbers of that last column/data set using Machine Learning models. We are using as many as 5 different types of ML models to predict these 7 pattern numbers from the target data set which is the last column of each test sheet. During this process of prediction, we have come across certain observations. We had to solve those observations and improve the prediction accuracy by overcoming those observat...
Looking for an experienced Systems Engineer to aid in the development and integration of a user-friendly web dev and mobile application. Both platforms should facilitate effective and seamless interaction, focusing on functionality, performance, and security. System Development for a Truck Stop (Overnight Resting facilities / Truck Wash / Workshop / Inventory) We will supply Hand-held Scanners and Systems with an open API The Truck will enter the business premises and the registration Disc will be Scanned in - We need that info to drive back to a CSV file that is loaded on the new system and feed-back info of the truck, its owner etc - the system must also pull info of that truck and owner-company from the Accounting Package with financi...
Hello, Listen freelancers, this is a project in which you have to integrate Matrix login and signup in my flutter app and you should have expert knowledge of machine learning and device training. Thank you. Please bid no matter you are a beginner we will look after your skills.
I require a freelancer who can build an efficient VLOOKUP formula in Excel. Key details: - The VLOOKUP will be based on the 'Product Code' between two spreadsheets. - The lookup will be conducted in 'Column A’ on sheet 1 and compare sheet 2 with column b on sheet 2 - 'Column B' contains text-based values. The freelancer will need proficiency in Excel, and specifically in the creation and deployment of VLOOKUP formulas. Additionally, familiarity with product code databases or similar text-based lookups would be highly beneficial. Please ensure you can complete a project of this nature efficiently and accurately. It might seem straightforward, but I still need someone who can verify...
I need an expert in data entry, especially focused on excel data typing. I have multiple worksheets containing text and numerical data that needs accurate transcription. Ideal Skills & Experience: - Proficient in Excel - Familiarity with basic and intermediate features of Excel - High accuracy in data typing - Knowledge of currency formatting Job Specifications: - Data consists of both text and numbers. - The data will be from multiple worksheets, although they have a simple layout. - Currency formatting will be required in the typed data. - Precise data entry is mandatory as the information keyed in will directly influence further applications. Your role will not only include typing the data but also applying the correct currency f...
I am in need of an expert in Microsoft Excel to carry out complex data manipulation tasks in my spreadsheet. Core Responsibilities: - Perform data manipulation using advanced Excel functions and formulas. - Specifically, I require you to execute lookups in the Excel spreadsheet to locate and retrieve necessary data. This operation will be an integral part of this project. Key Skills and Experience: - Proven expertise in using Excel for complex data manipulation tasks. - Excellent understanding and practical experience with Excel functions and formulas - Specific experience in performing operations with lookups within Excel is paramount. - Efficient and detail-oriented with a knack for accurac...
I'm in need of a freelancer with extensive experience in Excel, specifically in applying VLOOKUP, IF, and SUM formulas. Task will mainly focus on: - Utilizing VLOOKUP to retrieve valuable data from a different sheet. - Employing IF and SUM formulas as necessary to enhance data analysis. The ideal freelancer for this project is expected to have a profound understanding of Excel functions and capabilities, and a proven track record in the efficient use of Excel for data analysis. Experience in data retrieval and comparison using VLOOKUP is highly essential for this role. Ability to cross-reference and perform calculations with accuracy is required. If you fit the description, let's get to w...
I am seeking a diligent freelancer with expertise in converting single column numeric data from PDF files to Excel. The ideal candidate should have: - Demonstrable experience with similar projects - Proficiency in data extraction or manipulation tools - Proven background in handling single column data specifically numeric Please make sure you include your past work in your application. Experience in the relevant field would be a plus. The tool is expected to accurately convert these numeric values, ensuring the integrity of the data remains intact. If you believe you're the right fit for this, I look forward to your proposals.
I have a need for an Excel expert to develop a macro that automates data entry. This will specifically involve autofilling data in my spreadsheet from an eForm. The information that needs to be automatically entered into Excel from the eForm is the email field. In this project, we ask for: • Automation of data entry from eForm to Excel using Macros • Sole focus placed on the email field for the autofill feature Successful freelancers should have an exceptional understanding and experience with Excel Macros. Your ability to work swiftly is crucial as this project is required ASAP. I am looking for consistent, open communication to ensure that all objectives are met to the re...
...looking for a proficient individual who can assist me with a data entry project. Here's a rundown of the requirements: - Your task will revolve around data entry specifically involving the process of copying and pasting. - You will work with data from PDF files, so a good understanding of this format is necessary. Being able to handle complex PDFs with limited Search/Find functionality would also be a key skill. - The end destination for the data will be an Excel Spreadsheet. Proficiency in Excel is a must, including creating and managing spreadsheets, sorting data into cells, and maintaining accurate and clean data. - The ideal candidate should have a keen eye for detail to ensure data accuracy, and soli...
I need an experienced freelancer to develop a comparative tool on Excel for use in the general insurance broking industry. The tool should be completed in 3 working days. Main functionalities should include: - Automated quotation generation - Comparative analysis of insurance policies - User-friendly interface The comparative analysis should look into: - Price comparisons - Coverage comparisons - Comparisons of policy terms and conditions The focus will be on Workmen Compensation policies. Therefore, your understanding and experience in this area of insurance would be greatly beneficial. Ideal Skills: - Proficiency in Excel - Expertise in VBA or Macros - Understanding of General Insurance Broking - Knowledge of Workmen Compensation Poli...
I'm looking for a skilled guy in selenium and python; who is able to make a tool for collect info from amazon, following those feautures: 1. The script logs in to the affiliate account using the provided credentials. 2. The script loads the source CSV file containing product URLs 3. It then start iterating over each row in the CSV file. 4. For each row, it reads the product URL from the specified column (Product URL). 5. It scrapes the product details using the extracted URL (these details will be scraped - Product Title, Category, Description, Image 1, Image 2 (if available), Image 3(if available), Number of Reviews, Starts(Rating) and Price) 6. It will then click on the “TEXT” option below “Get Link” on top and it will switch to...
I am in need of an experienced social media editor to creatively spruce up my reels for personal brand showcasing on Instagram and Facebook. The winning freelancer should excel in: - Clever and engaging editing for social media platforms, specifically reels format. - Understanding personal brands and how they are represented visually. - Delivery of high-quality, professionally edited content. Your foremost task will be to capture the essence of my personal brand in the aesthetic and theme of the reels. Storyboard creation based on my brand's tone will be a plus point. Send me a messages, and I will send a un-edited reel for you to edit. Please include relevant examples of your past reels edits in your bids.
I need an expert in Microsoft Excel to help create a comprehensive drill down from a concise set of exit interview data. - The source data consists of elements such as names and categories. - Specific information required from the drill-down includes reasons for leaving, exit employee comments, and the departments they worked in. - You will craft tools within Excel that will allow me to easily access and analyze this crucial insight at a glance. Skills needed: - Advanced knowledge of Microsoft Excel - data visual Your ability to communicate effectively in English and deliver prompt results is also very important in this project.
I am looking for a professional freelancer who can provide a solution for automating the 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...
...Django developer who can also handle back-end and meta integrations. My primary expectation for this role is to maintain an existing AI chatbot. The chatbot is currently functional but it's in need of improvements and optimizations. Key tasks: - Debugging and error fixes: I require someone with expertise in inspecting and fixing bugs, ensuring the bot performs tasks seamlessly. - Enhancing user experience: Adding interactive elements to the chatbot in order to enhance its functionality and make it more engaging to users is vital. Your experience in user interface design and commitment to improving user experience will be highly valued. - Integrating new features: We're always looking to stay ahead of the tech cur...
I'm looking to build a new React application that leverages a .NET API, all from scratch while utilizing an existing SQL database. - **Core Functionalities:** - **User Authentication:** Secure login system using email and password. This system should ensure that user data is protected and only authorized users can access the application. - **CRUD Operations:** The ability for users to create, read, update, and delete data within the database seamlessly. This includes managing user details, settings, and other data points relevant to the application. - **Role-Based Access Control (RBAC):** Different levels of access and permissions for users based on their role within the application. Specifically, I need two roles: Admini...
I am searching for a skilled developer who can design a web scraper that retrieves daily data. The Requirements: 1. Scrape text content and Excel data from pre-determined websites (only 1-2 websites). 2. Set up the system for daily scraping duties. Ideal Skills And Experience: - Profound knowledge of different scraping tools and techniques. - Excellent problem-solving skills. - Experience with Excel and text data. - Ability to work punctually and reliability for daily tasks. This project might require some adjustments and optimization, so ongoing communication is essential. Clear communication abilities and good comprehension of English will be a plus.
I need assistance with creating an Excel formula that effectively deals with addition. In row Q I have it in pounds and the next row I have discounted. Every pound I need Column R to add up just the pounds in increments of $5.00. To be more specific, the formula in focus is needed to add data across rows, which are continuous or next to each other. This means that the required action will involve reading and adding values across various cells on the same row. To make a successful bid, you should: - Be proficient in Microsoft Excel - Have a clear understanding of Excel formulas, specifically in dealing with addition operations - Have the capability to create formulas fo...
I'm on a search for an expert freelancer capable in data scraping, particularly from an Excel database to LinkedIn. Outlined below are the significant requirements for this project: - Source data extraction: Skillfully extract Names, Email Addresses, Job Titles, and LinkedIn URLs from an Excel database. - Detailed profiling: Leverage both extracted data and set criteria including Location, Industry, and Experience Level, to find the relevant LinkedIn profiles. - Volume handling: There are over 500 entries in the database that need to be processed, hence experience in handling large volumes of data is necessary. The ideal freelancer for this job should have experience in data scraping, Excel, and LinkedIn search. They should a...
I am looking for a resourceful virtual assistant who can help in various data-oriented tasks. The job may not be limited to, but majorly includes data entry, research, and email management as these will form the bedrock of the activities to be carried out. IDEAL SKILLS • Experience in data entry • Research abilities • Proficient in email management Though the specific tasks were skipped during the question phase, I expect your application to include details about your past work experiences where you carried out similar tasks. A comprehensive project proposal will also be beneficial. SOFTWARE PROFICIENCY It would be a plus if you have proficiency in tools like Microsoft Excel, Google Sheets, or any CRM systems....
FOR AU BASED FREELANCERS ONLY I'm looking for a skilled freelancer who can create a PDF document from an Excel spreadsheet. Here are the specifics: - Include data based on certain criteria from the spreadsheet. - Both numerical and text columns need to be incorporated in the PDF. I am uncertain about the styling and formatting of the document. Therefore, I ask you to suggest some options. An ideal candidate for this project will have proficiency in data handling, Excel manipulation, and PDF creation, with an eye for clear and engaging document design, which proves beneficial in suggesting viable format options.
52,237 from various links in excel database This process should extract: - Product name - Artist - Design details - Print Size - Print Shape - Price (this will have several variables, depending on shape and size) -Design Details This needs to be entered into excel database & product images saved into a folder we will provide a link for in drive
Hi, I'm looking for someone to do a simple task. I have 2 excel CSVs. I'm looking to divide each in half. I need one half labeled "Cleaned" and the other half labeled "Dirty", it doesn't matter which half as long as we keep the same titles of the files. I can pay $15 for this as it will take less than an hour and requires minimal skill. I'm looking for someone to do this in the next hour.
...this project, I am seeking an expert who can perform complex tasks in Excel, with a specific focus on data analysis, visualizations and automation of reports. The core responsibilities of the role will cover: - Extensive data analysis on multiple data inputs which majorly include call logs and agent productivity records. - Development of data visualizations that offer clear insights into the call center's performance. - Automation of reports for easy and hassle-free work flow. The chief goal of the project is to track the call center's performance and identify areas for improvement. An ideal candidate for this project needs to have proven experience in handling large data sets as well as the ability to create stunning, impactful vis...
I am eeking a skilled individual to assist me in the creation of a custom furniture package catalogue. The project is straightforward but requires attention to detail and a keen eye for design. I have an existing PDF catalogue that showcases furniture items for the common areas of a housing project. The goal is to expand this catalogue to include new items while maintaining the same format. However, I am also open to improvements in the design if you can enhance its visual appeal and functionality. Scope of Work: Catalogue Expansion: The primary task involves replacing furniture items to the existing catalogue. I will provide an Excel file and a PDF catalogue with details and i...
I am in need of a custom, comprehensive Excel spreadsheet creation, designed to support manual data entry. The spreadsheet should include capability to calculate formulas including but not limited to Sum, Average, and Count functions. The Essential Features: 1. **Data Collection**: The spreadsheet must be designed for manual data input. This means efficient, user-friendly navigation and data input methodology. 2. **Calculations & Reports**: Importance lies in its capability to not only store data but also generate actionable reports. These reports should have the: - Ability to sort data - Option for interactive charts - Summary statistics 3. **Design**: While there are no specific design elements or t...
I am currently using Office 365 and I need assistance converting multiple Excel files into PDF format. This task requires: - An understanding of Excel Office 365 to ensure seamless conversion - The capability to convert numerous files (not a one-off job) - Advanced knowledge in creating PDFs with specific, custom formatting, as this is essential to the project. Ideal skills and experience include: - Proficiency in Excel and its nuances, particularly Office 365 - Proven experience converting Excel to PDF in previous projects - Strong attention to detail, especially related to file formatting - Demonstrated ability to handle multiple files, ensuring each one retains its uniqueness in...
need 2 restaurant menu from a webpage entered into an excel sheet. ill send u excel template to show u example this is 2 menu only ill have more in future (if u do a good job) no time wasters
I need a software designed that can automate important tasks at my business. Here are the core functionality and features I expect: Functionality: - The ability to compare multiple Excel files - Generate detailed reports based on findings - Send automatic emails based on the reports created Features for Comparing Excel Files: - The system should find differences based on multiple criteria in Excel files - It should then be able to create comprehensive reports based on the differences found Ideal Skills: - Expertise in softwares that automate tasks and compare Excel files - Familiarity with task automation, report generation, and automatic email sending - Strong knowledge of Excel and its functionalities for dat...
I need a freelancer to assist with online data entry work. The task involves entering data on UK and worldwide business websites, with an intermediate level of complexity, as it includes multiple fields and references. Key Responsibilities: - Enter data with high accuracy - Handle multiple fields and references - Online data entry into Excel with real-time updates Ideal Skills and Experience: - Proficiency in internet, online business listings, MS Excel - Experience with online data entry tasks - Keen attention to detail - Strong understanding of data fields and references - Ability to uphold data confidentiality - Proven experience with intermediate to advanced data entry tasks
Hi Arman, Please create a quickbooks sop for the company. I will be sharing the excel sheets as discussed. Fadi
I am in search of a driven and talented freelancer who will provide me with high-quality B2B leads in the healthcare sector in United States. The ideal candidate should excel in generating potential business contacts and meeting set targets within the specified time frame. You'll be responsible for: * Identifying, contacting, and nurturing potential business leads in healthcare companies. * Researching companies and decision-maker profiles in detail to qualify suitability. * Maintaining meticulous records of interactions and prospects. Please note that your experience in lead generation, particularly within the healthcare sector, will be essential in securing this project. I value the importance of past experiences, so feel free to present ...
I am urgently in need of a professional freelancer who is adept at manual data entry. The amount of data is quite manageable, with less than 1,000 entries, however, we value quality and attention to detail over speed – we do not want the work to be rushed. Requirements and Tasks include: - You will be involved in manually entering data into a preformatted spreadsheet. - You must have a high attention to detail and no work can be missed – we need complete accuracy. - You must be efficient and organised in managing a small volume (less than 1,000 entries) of data. Ideal Skills Include: - Proven experience in manual data entry work. - Proficiency with spreadsheets and strong knowledge of Excel. -...
I'm in need of an expert with proficiency in Excel VBA macros to help me streamline data insertion in an excel file. Key specifics include: - The macro should allow data entry on the 'Main Sheet' - There will be three types of data input: numeric, text, and date/time - Additionally, the macro should perform certain operations on the numeric data: - Summation - Average calculation - Data sorting The ideal freelancer for this project should possess a robust knowledge of Excel, particularly in developing and implementing VBA macros. Experience in data manipulation tasks within excel would be an added advantage.