I have a task I need automated using an Excel macro. The specific function I need is data filtering from various sheets. - The Macro Task: The job involves creating a macro that filters data to different sheets. - Data Filtering: Notably, the filtering should be done based on specific criteria. I require a system that intelligently separates and filters information to various sheets. - Work Scope: I need the data filtered from multiple sheets, not limited to sheets 2, 3, or 4. The project might involve other sheets as well. Ideal freelancers for this job will have strong experience in Excel macros, data filtering, and automation scripts. Expertise in efficient data handling and manipulation are essential.
We have a requirement to work with Excel Power Pivot, Power Query Editor and prepare a Report. Very normal report and can be completed within couple of hours by an expert. I can pay maximum of INR1500/2000 for this first project but I will ensure, all my future work will be assigned to you. Looking for someone whom I can bank on for future. Thank you!
I am in need of an Excel specialist who can handle a large dataset of over 51,000 records. The data centers around employee contributions to political candidates. Specifically, I require detailed analysis on: - Contribution patterns - Candidate preferences - Employee demographics As an Excel expert, you should be proficient in working with pivot tables and be able to identify trends within large sets of data. Your experience managing, analyzing, and interpreting datasets should be well demonstrated. In addition, there is a particular interest in providing a thorough analysis of contributions based on political parties. This will help to understand better the political leanings within the dataset. To apply, please highlight your relevant experience. I look forward to seein...
I urgently need proficient help with excel. The tasks to handle include but not limited to; - Data entry. - Data analysis using relevant tools. - Leverage advanced excel formulas and functions to streamline data processing. The data to handle resides within 1-5 sheets and contains both numeric and categorical data. Ideal skills for the job include; - Advanced proficiency in Excel. - Deep knowledge of data analysis methodologies. - Quick data entry skills. - Understanding of Excel functions and formulas. Experience in processing both numeric and categorical data on Excel is crucial.
I'm seeking a detail-oriented freelancer with strong skills in text data entry, Excel, and who is comfortable working with less than 500 pages of data. Key Requirements: - Proficiency in text data entry - Strong familiarity with Excel - Able to handle less than 500 pages of data The ideal freelancer should efficiently turn raw data into an organized Excel spreadsheet. Accuracy is vital in this job, as any mistake could lead to incorrect data analysis. Please provide evidence of your past experience in text data entry and working with Excel.
...exercise materials for Excel, with a particular focus on Excel Macros, Array formulae, forecasting, countif, if statements, and all LOOKUPs. All exercises should come from dataset or data files KEY REQUIREMENTS: - The labs should cover 10 advanced topics, including but not limited to Excel Macros. - For each topic, I need 5 well-thought-out lab exercises created with step-by-step answers. - The exercises must be suitably challenging for advanced-level Excel users. - Each exercise should come with a step-by-step questions and answers guide to aid understanding. IDEAL SKILLS: - Extensive knowledge of Excel, especially in Macros and VBA programming - Proven experience in developing training materials or lab exercises. - Familiarity with financial...
I'm in need of an expertly designed Excel spreadsheet that will serve as a dynamic sales reporting template. This tool will play a significant role in tracking and analyzing data related to various aspects of sales. The successful candidate in this role will incorporate tracking capabilities for variables such as: - Product sales - Revenue by customer - Customer % of revenue Furthermore, the spreadsheet should provide robust reporting on seasonality, current month vs prior year, and fiscal year to date (FYTD) vs the prior year. This comparative analysis is crucial in understanding trends and informing strategic decision making. Ideal Skills and Experience: - Proficiency in Excel - Experience in creating dynamic reporting tools - Understanding of sales data analysis - ...
...include are: - The variety of benefits for businesses who choose to lease vehicles, each outlined clearly and concisely. These should include cost savings, tax benefits, and the flexibility that leasing provides. - A comparison of different car leasing options available in the market. This should be visually effective, with easily digested information allowing viewers to easily grasp the differences. Models are as follows: Mitsubishi ASX, Outlander & L200 BMW 330i M sport, X1 - Testimonials from satisfied clients who have used these services. This can be in the form of quotes, case studies or short success stories. The target audience includes business owners and organizations already utilizing leasing services, potentially looking for a more affordable option. The key ...
This project entails creating a Power BI report that is linked to Excel spreadsheets for trend analysis purposes. The main user of this report will be the sales team. I'm seeking a professional with: - Expertise in Power BI and trend analysis - Proficiency in handling and linking Excel spreadsheets to Power BI - Familiarity with sales data and crafting useful reports for sales teams. Your primary objective will be to create a functional, insightful Power BI report, providing our sales team with meaningful trend analysis based on our historical data stored in Excel spreadsheets.
For Excel sheet data typing, you'd be looking for someone proficient in data entry and manipulation, preferably with experience in Excel. Here are the ideal skills and experience: Proficiency in Microsoft Excel Accurate and fast typing skills Attention to detail to ensure accurate data entry Familiarity with common data manipulation tasks in Excel such as formatting, sorting, and filtering Ability to handle large amounts of data efficiently Knowledge of basic formulas and functions in Excel for data analysis and manipulation Experience in working with different types of data formats and structures Strong organizational skills to manage and organize data effectively Ability to troubleshoot and resolve data entry issues Understanding of data privacy a...
Need to upgrade my existing excel macro, very simple project
For this project, I need an individual experienced in data entry to transfer 159 sets of data from an Excel file into an invoice system. I won't specify the exact data to be transferred, but expect that it could be a mix of customer information, product details or payment details. When applying, don't feel the need to highlight past work, experience or provide detailed project proposals unless you feel it is relevant. Expected Organization of Data: - The data must be arranged by date once in the invoice system. Ideal Skills: - Proficiency in Excel and Invoice systems - Strong attention to details - Efficiency and accuracy in data entry.
Unify TXT files into Excel. (This data is good) This is a data merge project. Merge data from 3 txt files into excel. This is NOT a simply copy paste. The data needs merged. The data from 2 of the files will become columns of data in the 'master file' (see below) Download 2 files from here: Download 1 file from here: Note: This is public data it is completely permisable to use it. The files listed are: Deeds - don't use this file Owner: 1,817,424 lines. Step #1 for this file: Delete all rows that the aka pct_own is 0.000. This data will become columns of data in the master file ie: Owner 1 ln_num
For this project, I need an individual experienced in data entry to transfer 159 sets of data from an Excel file into an invoice system. I won't specify the exact data to be transferred, but expect that it could be a mix of customer information, product details or payment details. When applying, don't feel the need to highlight past work, experience or provide detailed project proposals unless you feel it is relevant. Expected Organization of Data: - The data must be arranged by date once in the invoice system. Ideal Skills: - Proficiency in Excel and Invoice systems - Strong attention to details - Efficiency and accuracy in data entry.
...need an Excel VBA utility that is able to perform calculations, specifically advanced financial modeling for cost using VBA & Macros. I require complex projections for various scenarios to be calculated through this utility. This tool should enable me to: - Efficiently perform cost calculation for a project and financial based on inputs - Efficiently calculate the cashflows automatically based on the inputs. - Generate advanced financial projections incorporating different scenarios. Ideally, the freelancer taking this project on would have a robust background in both financial analysis and Excel VBA programming. Proficiency in financial modeling (Including Project cost calculation) and a solid understanding of finance principles is necessary. Experience with develo...
...proficient with Blazor C#. Our project currently has few runtime error that needs a fix. Specifics about when and where this error occurs will be provided after we've started. There are only two pages that needs your fixing. 1. location page Show Message that data has been edited, saved or delete. When user clicks on specific item data to be loaded in textbox Search is not working Export data to excel with formatting 2. Login page Issue with adding new user (password not getting captured) Add roles and claims (department) When user click on user form the table it should Edit user details including email address Only admin user to have right to Add/edit this page. Other user can only view the details. Search is not working. When new user is create a Confirmation email shou...
I urgently require an adept designer with proficiency in graphic design, logo creation, and branding. Mastery in Adobe Illustrator will be beneficial to the successful completion of the project. Responsibilities: * Examine and enhance the visual design of the existing PowerPoint presentation. * Improve content organizat...Responsibilities: * Examine and enhance the visual design of the existing PowerPoint presentation. * Improve content organization. * Incorporate engaging animation effects. * Execute graphic design tasks including logo design and branding. Candidates with keen attention to detail, a commitment to meeting tight deadlines, and a background in corporate or formal PowerPoint presentation design will excel in this role. Immediate ability to start on the project is a ...
I need assistance with data collection from online databases, primarily working with customer data. This role involves gathering and organizing necessary information into a structured and usable format, and will require: - Proficiency in browsing different online databases with a keen eye for detail - Expertise in organizing large sets of customer data - Verification skills to ensure data accuracy - Excellent understanding of data privacy standards Experience in similar projects will be highly appreciated. Knowledge of CRM systems will be a bonus, but is not mandatory. A successful partnership on this project could lead to long-term collaboration.
macro based excel project with auto copy data and paste in chrome through selinium
Your report/dashboard should answer the following questions posed by the sales director of the client: 1. What is the total number of orders catered by the firm? There should be a date filter in the dashboard. 2. What is the revenue earned by the firm? 3. What is the total discounted value (base price - check out price) * number of orders? 4. What is the overall discount %? 5. What are the top 5 selling categories? 6. Does the operational area of the store influence number of orders? 7. Are emails & product features on the homepage an effective mode of promotion? 8. What will be the next 5 weeks forecasted weekly quantity sold for each center, city, and meal category (you may use a simple trend-based forecasting method)? You need to submit your PBIX file work as a zip.
I'm in need of a proficient Data Entry operator who can efficiently handle tasks like data entry, content management, and file organization on a daily basis. The job requires some familiarity with basic Web and Network technologies like Wordpress, Godaddy, etc . General understanding of website operation are needed. Wo...handle tasks like data entry, content management, and file organization on a daily basis. The job requires some familiarity with basic Web and Network technologies like Wordpress, Godaddy, etc . General understanding of website operation are needed. Workloads will vary, as the work requirements are not on a fixed schedule or volume. Proficiency with data related software is highly advantageous. Excel knowledge is must. If worked on Tools like Zoho etc, it wil...
I need a thorough data collection process to collect Ceramic & Porcelain Tiles Importers within Vietnam. This project requires: - Collection of contact information and company details. - The data needs to be organized in an Excel spreadsheet. - Include data for all importers, regardless of volume or frequency of importing. Ideal skills and experience for the job: - Strong data scraping and crawling capabilities. - Proven experience with swift and accurate data entry. - Proficiency in Excel.
I'm in need of a Python programmer skilled in web scraping to help me extract text content from mostly text-based PDF files. Requirements: - Extensive experience in Python and specifically Python libraries for web scraping. - Should deliver the extracted text content in an Excel file. Ideal Skills: - Experience in PDF scraping, especially text-based. - Strong Python programming skills. - Excel file formatting. This will involve working with mostly text-based PDFs and programming a Python script to scrape the text content, and subsequently placing that data into an Excel file. Experience with similar projects will be highly advantageous. The ability to meet deadlines is a must.
Is a task require basic Excel skills with four tasks in total need it in 5-6 hours
I require a qualified specialist to generate sales leads for my green fertiliser project targeted at farmers, agricultural businesses, and gardeners in the UK. Your tasks will include: - Enhancing visibility through SEO optimisation - Website codi...farmers, agricultural businesses, and gardeners in the UK. Your tasks will include: - Enhancing visibility through SEO optimisation - Website coding in PHP - Creating engaging and informative web content and blogs - Using LinkedIn Sales Navigator for lead generation Your understanding of the farming world will be a great asset for this project. Delivery of the sales leads should be through an Excel spreadsheet, Emails, and my CRM platform. Past experience in a similar role, particularly within the agricultural industry, will be highly...
I am looking for a developer to create a multilingual WhatsApp chatbot. The chatbot must be built on Twilio, and should be capable of answering user queries promptly and effectively in both Arabic and English. Skills and experience needed for this project: - Proficiency in chatbot development, specifically on the Twilio platform - Experience in designing chatbots that excel in query resolution - Strong command of both Arabic and English in a development context Please make sure to highlight any similar projects you've completed in your proposal, with specific details on chatbot functionality and multilingual support.
I need an experienced Excel and VBA specialist to assist with a project that involves data cleaning and generating reports from a CSV file. This file contains dates and times against power usage for apartments and needs to be processed in Microsoft Excel. The job tasks include: - Fixing inconsistent data entries in the CSV file - Extracting time of usage for each apartment - Creating a repeatable VBA script for future use Ideal freelancers will have strong experience in: - Microsoft Excel for managing and manipulating CSV files - VBA for creating automated tasks related to data cleaning and report generation Your help will save me time and effort in terms of managing this CSV file and creating valuable reports in the future. Successful completion of this pro...
...a proficient developer to build a robust database that can handle CSV files larger than 1MB. The data contained within the CSV files are a mix of text, numbers, and dates. The designed database needs to be optimized for handling large data sets efficiently. Key Requirements: 1. Capability to import CSV files holding data larger than 1MB. 2. Database should be tuned to store and manage text, numbers, and dates. 3. In case of duplicity in the CSV files, the system should be designed to retain existing data, rather than overwriting or creating new records. Ideal Skills: - Proficiency in database design, implementation, and management - Experience handling and managing big data - Strong understanding of handling CSV files - Ability to safeguard agains...
I'm looking for an experienced Power BI professional to help me create an interactive and insightful dashboard. Here's a brief of what I need: - Implement Interactive Dashboards: With emphasis on user engagement, the dashboards should be interactive and user-friendly. - Data Visualization: The dashboard should visually represent the data from Excel spreadsheets in a clean, easy-to-understand format. - Interactive Charts & Drill-Down features: I want a dashboard where users can interact with charts and explore detailed views of our data. Ideal Skills: - Experience in Power BI - Proficient in data visualization - Deft with interactive chart development, and drill-down feature set up Your task is to guide me on how to create this, using an existing example as ...
i have excel framework that contains multiple user inputs the convert the outputs to a graphs and charts i need to convert the excel sheet to a website.
I am in need of an Excel expert who can successfully create rows in an Excel sheet with a dropdown list that allows multiple choices. These choices should be exclusively filled with text data. Key project tasks include: - The text data should be extracted from pre-existing Excel sheets that I will provide. - Any row that utilizes these dropdown lists must be color-coded differently, with the format contingent on differing data values. Ideal skills for this job would primarily include advanced knowledge of Excel or a similar spreadsheet software. Familiarity with text data extraction and color-based conditional formatting would also be of advantage. Previous experience managing similar tasks and a keen eye for detail would make you a standout candidat...
I am in need of an experienced Microsoft Excel expert who can create a specialized personnel cost budget template. This template should include: - Automatic calculations. - Cost categories for Salaries and Wages, along with Benefits and Bonuses. Experience in financial modeling and budgeting would be ideal to ensure accurate automatic calculations are set up. You will be creating this from scratch, so creativity and attention to detail are also required. Please provide samples of similar Excel projects you've completed in the past. Adequate knowledge of personnel finance management is a plus.
I am in need of data entry and web scraping experts who can assist me with a project. The tasks that need to be completed include both data entry into a spreadsheet and web scraping for specific information. The final data should be delivered in Excel format. I have a specific deadline for the project and it needs to be completed within a week. Ideal skills and experience for this job include: - Proficiency in data entry and web scraping techniques - Experience with spreadsheet software such as Excel - Knowledge of web scraping tools and techniques - Attention to detail and accuracy in data entry - Ability to meet tight deadlines and work efficiently If you have the necessary skills and experience, please submit your proposal.
I'm in need of an Excel programmer who is proficient with VBA. The task involves creating a VBA scroll bar that changes values within a specific cell. The cell's contents should be adjusted in increments of 0.01 through the scrollbar's activities. - Proficiency in Excel and VBA is a must. - An understanding of user interface designs with Excel is ideal. - The candidate should be capable of testing and debugging functions within Excel. Your main goal is to create a VBA scroll bar that can accurately manipulate cell contents. Your work will be deemed successful when the scrolling alters the cell value as per the increment specified. Reach out if you have the necessary skills and can get this job done.
I am looking for an Excel expert who can assist with implementing logical formulas and calculating percentage-based results for different strategies. There are three key strategies that require your attention: Strategy A, Strategy B, and Strategy C. Your tasks would include the following: - Implementing logical operations to enhance data organization. - Entering information pertinent to each strategy. - Calculating and displaying the percentage of each strategy. Ideally, you should have extensive experience in Excel calculations and logical operations. Proficiency in data analysis and reporting is also a plus. I am in need of an individual who can accurately interpret and implement my strategy-focused approach in Excel. Your output will provide a foundation for cru...
Core Functionalities 2.1 User Authentication and Management User Registration: New users can register in the system. Login/Logout: Users can log in or out of the system with their credentials. Profile Activation: Admin will activate newly registe...data to the CRM system. Earnings Management: Specific earnings will be assigned to users upon task completion. Withdrawal Requests: Users can request to withdraw their earned amount once it exceeds a predetermined minimum balance. 2.4 Financial Reporting and Admin Panel Earnings Reports: Admin can view total earnings, user-wise earnings, and date-wise earnings. Export to Excel: Admin can export financial reports to Excel. Admin Dashboard: Admin can use a central dashboard to manage all aspects of the CRM add more requirement wh...
As an individual heavily invested in financial tasks, I need assistance with advanced Excel functions. My project focuses on two main areas: data analysis and usage of specific formulas. Tasks include: - Data Analysis: This entails financial analysis and data visualization. You'll be dealing primarily with fiscal data and you'll need to make the data meaningful and easier to understand. - Formulas and Functions: You'll be carrying out tasks that require an expert knowledge of VLOOKUP and IF functions. An ideal freelancer would be one who's proficient in Excel, specifically with experiences in handling VLOOKUP and IF functions, and someone who has a strong grip on financial analysis and data visualization. A keen eye for detail and ability to deliver ac...
I'm in need of a data scraping expert to extract specific baseball statistics from a certain website. () - **The job will include:** Creating a file that can be executable on command. Could be excel or other that pulls the data required from website ( see file for details). I should be able to pull this data repeatedly over time with the fresh data of the day. - **Ideal skills and experience:** Candidates should have experience in web scraping, especially with sports data, proficiency in a programming language suitable for data scraping (such as Python) and a good understanding of baseball statistics. The website requires a login to get in. This task requires precision and an analytical mindset to ensure the accuracy and relevance of the data scraped. If all goes wel...
As a client deep within the Arts & Entertainment industry, I'm on the hunt for a seasoned professional. Whether it's a full-time, part-time, or freelance job you desi... or freelance job you desire, this could be your opportunity. Ideal Candidate: - Has significant experience or background in the Arts & Entertainment field. - Can demonstrate their expertise through their previous works and accomplishments. Application Requirements: - It is crucial to list your relevant experience. This shows me your readiness to take on the tasks at hand and your ability to excel in this field. Please note that skipping the type of job you're looking for won't affect the hiring process; what matters most is your capability to deliver, whether as a full-time employee,...
I'm in need of assistance with certain advanced functionality in Excel. My project heavily depends on modifying complex Excel files and requires a specialist with a strong grip on: - Formulas and functions: Ability to apply and manipulate these is critical. - Statistical Functions: Will be used extensively, so expertise in this subset is necessary. - Lookup & Reference Functions: Another function set that the project necessitates. I'm looking for someone with remarkable ability to use these features to streamline data analysis and visualization. The completion timeline for this project is within the next month. Proven proficiency in Excel and the capacity to adhere to the given timeline is mandatory.
...an expert in Excel to help me create a jobmatch system. This project involves listing various workfields like a hotel, restaurant, bar, coffeeshop, warehouse, detailsshop, and customer service, and their related job roles on an Excel sheet. The complex part of the project is, each job role needs to be evaluated for similarity with a focus on three major elements: - Hardskills, Softskills and qualifications - Experience and education - Personality traits Moreover, these elements should not bear equal weight but must be individually customized. The weight for each criterion in a jobmatch process should be custom-tailored. Chat GPT can be used to understand the weights for each workfield Ideal candidates will possess: - An in-depth understanding of data analysis in ...
I'm seeking a...business analyst, skilled in MS Visio, to convert my existing Excel diagram of a business process into the latest version of MS Visio. Specifically, your task will be: - Shifting flowcharts and swimlane diagrams from Excel to MS Visio - Implementing color formatting and thoughtful annotations to the converted diagrams - Ensuring all diagrams maintain a professional and corporate style throughout. The ideal fit for this project would be detail-oriented and have excellent knowledge in MS Visio and business process modelling. Their expertise should be evident in providing sleek, professional, and corporate-looking diagrams. Prior experience in working with similar projects is a significant advantage. NOTE: I will provide the excel file and candida...
I'm in need of a dedicated data entry specialist, who is adept in Data entry of commercial invoices. Key Responsibilities Include: * Accurately entering invoice data into Microsoft Excel spreadsheets. * Ensuring adherence to specific formatting requirements, details of which will be provided upon project commencement. A deep understanding of Microsoft Excel and precision in data entry is crucial for this role. Experience with processing invoices is highly desirable. Attention to detail and maintaining the integrity of confidential information are also essential for this project. Project Description: We have a pressing requirement for a meticulous and detail-oriented freelancer to assist us with data entry tasks. We possess over 150 Invoice Documents related to Carg...
I'm seeking a skilled individual who can scrape text content from a PDF. A high level of attention to detail is needed as the data must be accurate. Key Project Requirements: - Excellent web scraping skills specifically around extracting text data from PDF files. - Ability to deliver scraped data in Excel format. - Efficient and accurate data extraction is a priority. Ideal Skills and Experience - Proven experience in web scraping, especially from PDFs. - Knowledge of saving data into Excel. - Capable of maintaining data accuracy. - Familiarity with captcha handling. I'm looking forward to your bid and answering any questions you might have about this project.
I am in need of a service that includes text data entry into Microsoft Excel. The specific requirements are as follows: - Expertise in text data entry. The data to be entered is purely textual, no numbers or alphanumeric data are involved. - The text data needs to be organized in Alphabetical order. A systematic and meticulous eye for detail is required to ensure accuracy and consistency in the arrangement of the text data. - You must have a thorough understanding and extensive experience working with Microsoft Excel. It is the platform where the text data will be entered, sorted, and stored. Accuracy, efficiency, and confidentiality are paramount in this project, hence, the ideal freelancer is a seasoned professional with above reproach data entry skills and a stellar tr...
Seeking a detail-oriented freelancer to help with a data entry project. The ideal candidate should have: - Knowledge and experience entering text data from digital files into Excel. - Experience in Excel table formatting, ensuring the structured and organized presentation of data. - Skilled in data management, able to maintain integrity and accuracy of the information. - Attention to details to avoid mistakes during data entry. This project requires specific skills in Excel and keen attention to detail. Make sure you are comfortable with handling and managing digital files and you’re equipped with good typing speed and accuracy.
I require a meticulous professional to aid in text and numerical data entering into an Excel file. - Data Entry Scope: The workload involves entering 850 rows/5 columns of data into 1 workbook/28 sheets . This is a one-time assignment needing immediate attention. - Skill Set: The ideal candidate would have experience in data entry and a keen eye for detail to ensure accuracy. Proficiency in Excel is a necessity. Looking forward to a productive engagement.
I need an Excel whizz capable of effectively entering and organizing both numerical and textual data in my spread-sheet. You should have: - Proficiency in Excel, particularly with data entry and organization functions. - Exceptional attention to detail, ensuring no data is mismanaged. - A good understanding of organizing data chronologically. Your task will involve: - Inputting a mix of textual and numerical data in an Excel sheet. - Organizing this data chronologically. - Ensuring data accuracy and integrity. Your keen eye for order and structure alongside your Excel proficiency will be crucial to the successful completion of this project.
Data entry project requiring transcribing documents into Excel spreadsheets. Ideal candidate should have experience in accurately transcribing a large number of documents. Preferred format for the transcriptions is Excel Spreadsheet. Project involves transcribing more than 20 documents.
