Excel vba filter sheets jobs
I have a need for a meticulous freelancer with solid web research and data entry skills. The project involves researching company details and the necessary data should be accurately entered into an Excel sheet. Key Responsibilities: - Detailed online research to gather specific company data. - Accurate data entry of information into Excel, adhering to specific guidelines. Ideal Candidate Skills: - Strong web research ability. - Very accurate data entry skills. - High proficiency in Excel. - Able to meet deadlines. - Excellent attention to details.
...provide attestation services for our financial documents. The selected freelancer will be responsible for reviewing, verifying, and attesting to the accuracy and authenticity of our financial statements by affixing their signature and stamp. Scope of Work: Review of Financial Documents: The freelancer will review our financial documents, including but not limited to income statements, balance sheets, cash flow statements, and any other relevant financial records. Verification of Accuracy: The auditor will verify the accuracy and completeness of the financial information presented in the documents, ensuring compliance with applicable accounting standards and regulations. Attestation and Certification: Upon satisfactory review, the freelancer will attest to the accuracy and authe...
I'm in need of a skilled freelancer with proficient online research and data entry skills. Responsibilities: - Conduct online research to collect necessary data - Expertise in entering numerical data precisely - Compile, verify accuracy and organize the information into a Excel spreadsheet Desired skills/experience: - Attention to detail - Experience in data entry - Excellent knowledge of MS Excel - Strong ability in online researching
...01 Signup Form with Phone, Email, Address Step 02 A chat box would open up with basic questions as; • Date for Booking • Time Period for Booking Step 03; Within the chat box the next question would be regarding the work profile Users can text to match profiles. Example: I want Bamboo Artisans Step 04: The Chat box will show all profiles for Bamboo Artisans as in the Directory or excel file Excel would be as simple as Skill Set, Profesional Profile Step 05: The User will select the profile they want and the next would be followed to payment gateway. Step 06. Post payment a confirmation message would be sent with contact details Service Provider Interface Step 01 Signup Form Step 02 Detailed Profile Step 03 View Bookings, View Amount which will b...
I'm looking to build a live dashboard that will display the results of both the Presidential and Local elections in real-time. Key Requirements: - I need the dashboard to be able to pull data from reliable sources(officials in polling station in an excel form) and refresh the data in real-time. This will facilitate the display of accurate and up-to-date results. - The design of the dashboard should be clean,animated,interactive, intuitive and easy to understand for users. It needs to be able to show data for both elections simultaneously with the help of a switcher between the two pages. - The dashboard should be mobile responsive, so that it can be viewed on various devices with ease. - The security of the data is paramount, so it's important that the dashboard is develo...
I'm in need of an Expert Excel programmer to help design a user-friendly Excel sheet focusing on stock and ledger management. Specifically, I'm interested in: - Incorporating Automatic Calculations: The ideal candidate should be able to create a system that automates complex calculations based on data inputs. - Dropdown menus: The sheet should offer an easy interface with dropdown menu options for hassle-free data inputs and editing. - Linking Stock and Sales: The sheet should be designed in such a way where the inventory updates automatically from sales data. So, a keen understanding of Excel's data integration and interconnection capabilities is necessary. - Essential Data Fields: My Excel sheet needs to include specific data fields like stock name, q...
...should allow for the easy management of inventory. - Warehouse Overview: An overview of warehouse status and stock levels should be clearly available. User Interface Design: - List View: I envision the inventory management interface as a list view with search and filter options for easy access and manipulation of data. Ideal Skills and Experience: - Proven experience in Python frontend development - Strong understanding and experience in Inventory management systems - Proficiency in creating user-friendly UIs with search and filter options - Ability to distill complex data into clear and actionable insights - Previous experience with warehouse management systems would be a great advantage. If you have the skills and experience needed, I'm looking forward to hearin...
I just need a list of employees from Linkedin Recruiter.. I will get in a google-meet or zoom meet with you, and I give instructions. _We need to find the list of 'Open to Work' People from a particular Company in India. The re...Work' People from a particular Company in India. The reason for doing that is, We want to look for employees, who are considering Job switch from this company. _we will together log into your Linkedin Recruiter account _We will look for 'open to work' candidates _we will export the list (around 313 people) in CSV or Excel or PDF format. _If exporting the list is costly, in that case, I will simply take screenshots of the List (of candidates), and will later convert that into excel sheet. **The Task will take maximum of 1...
I have a project that involves the entry of data from Excel into a new system. The data entries are in Excel format, and I estimate the total number of entries required to be between 100-500. The task will involve a mix of text and numeric data. Ideal Skills: - Proficiency in Excel - Strong attention to detail - Efficient, accurate data entry - Previous experience with data entry projects of similar scale This is a straightforward task that requires someone who can work accurately and efficiently. Meeting the estimated entry count and maintaining data quality are key.
Need an extremely competent financial modeler in Excel who is capable of working with a lot of date math in formulas. You need to work on a working model template. NOTE: Do not apply if you are not genuinely capable of working with complex models. I am looking for help because I'm busy, not because I'm not capable! I make huge financial model templates on topics people don't model. I made a model on "ESOP" (Ownership structures for startups). ISSUE A client input dates in a way I didn't test and I realized I built in circular references I wasn't aware of. TASK Remove circular references (Need to change logic a bit to do it, which is not simple) Ideally break test to see how I messed up date math when dates are similar so won't be issues wi...
I am in need of a robust and efficient inventory management system made in Excel. This project requires: - Tracking of product quantities and managing stock levels to ensure seamless operation - Cataloguing of each product's relevant information including its name, SKU/Part number, quantity, batch number and expiry date - Methods of updating system quantities should be manual entry and bar code scanning. Knowledge in these methods is required. Ideal candidates should have extensive experience in Excel and inventory management system creation, preferably with a sound understanding of retail or related sectors. They should also be adept at implementing bar code scanning into Excel systems. Sharp attention to detail and ability to optimize for efficiency and usab...
...has a strong understanding of Google Sheets API and real-time data integration. App should be able to display rates, track order status, display quote of products and other basic tabs like upload of pdf documents of catalogues, contact us, about us and social media links etc. I have attached a basic pdf document of what the app should look like. Will need UI improvements in it too. Key Responsibilities: - Develop an Android application that dynamically displays data from certain cells in Google Sheets. - The app should be designed to pull updates in real time, refreshing every minute. - It should provide a manual refresh data option for immediate update. Ideal Skills: - Extensive Android app development - Knowledge and experience with Google Sheets API - Re...
I’m looking for an Excel expert able to implement drop downs and inter sheet connections to manage my business ledger and stock updates on a weekly basis. Here are the project specifications: * There are currently less than 5 Excel sheets that need to be interconnected. * The primary intent of this interconnection is the cross-referencing of information. * The exchange of data to be implemented includes Inventory data, Financial data, and Sales data. The ideal candidate should possess advanced Excel skills, including knowledge and experience in cross-referencing various types of data across multiple sheets. Familiarity with business inventory, financials, and sales data is highly desirable. Please ensure your bid reflects your ability to fulf...
Title: Sales Representative Specializing in the Meat Industry in UAE Location: Remote, UAE Job Type: Freelance with a ...25% commission under our affiliate program for successful lead conversions post initial project. Application: If you are ambitious, detail-oriented, and have a deep understanding of the UAE meat market, we encourage you to apply. ******* NOTE: If you do not gather all 5 criteria for at least 40 companies - then there will be no payment. Please note this information needs to be gather in an excel and you need to show the correspondence for example WhatsApp conversation when acquiring the quote. This is not the type of data that can be pulled using software it needs to be carried out manually - prices of meat change weekly so I will know if you are not being...
I am in need of an experienced freelancer who can assist with various types of data entry tasks. This primarily involves: - Transcribing data from handwritten documents - Entering data from digital documents - Inputting data from spreadsheets The volume of data to be entered is moderate, falling between 100 - 1000 records. The preferred software for this project is Excel, therefore, proficiency and solid experience in using this application is necessary. Attention to detail and accuracy will be essential for this position. Understanding how to use spreadsheets effectively, and a proven track record in data entry are important skills that a suitable freelancer should possess.
I require an expert in Excel to build a comprehensive tracking file. This task involves: - Establishing a data entry form to easily input inventory and project progress details. Knowledge of creating user-friendly interfaces within Excel is beneficial. - Implementing automated calculations to streamline the data analysis process. Strong mathematical and analytical skills are essential. - Creating a graphical representation of data to facilitate understanding. Experience in data visualization is a must. The spreadsheet will track fewer than 10 types of inventory data and project progress data. Your familiarity with inventory management processes and project tracking would be highly valuable. This assignment calls for you to use Excel's capabilities optimally to produce...
I am looking to streamline my excel data entry process. Needs centralized on the automation of numerical data entry in my Excel spreadsheets. Key requirements: - Automate simple data entry into few columns. - Experience with Excel data entry automation required. - Should have good knowledge of Excel functionalities and automations. - Ability to handle numerical data efficiently. Experience in handling simple data entry (few columns) and automating the same would be ideal for this job. Reach out if you need more information and looking forward to your expert assistance in this process improvement.
I am seeking a proficient specialist in Excel 2010, with extensive experience in the creation of VBA Macros, designing data entry sheets, automating tasks, and generating reports. Key responsibilities include: - Design and develop efficient VBA Macros - Design accessible and streamlined data entry sheets - Automate various Excel tasks for increased productivity - Generate comprehensive and insightful reports Ideally, you have advanced knowledge of Excel and VBA Macro programming, demonstrating a proven track record in dealing with complex Excel projects. A strong understanding of spreadsheet automation and report generation is fundamental to execute this project successfully.
I'm in need of a seasoned credit analyst to assess the cr...impact the loan decision - Make informed loan approval or rejection decisions based on the applicant's creditworthiness Applicant Requirements: - Experience: Mid-level. I am looking for someone who has a proven track record in credit analysis, with a minimum of 2-3 years of relevant experience in the financial industry. - Software Proficiency: The ideal candidate should be proficient in Excel/Google Sheets to effectively analyze financial data. Familiarity with other financial tools would be a plus. This is a great opportunity for a skilled credit analyst to gain experience in assessing loan applicants and making informed, data-driven decisions. If you believe you have the necessary experience and skills,...
I...physical paper form, and the expected outcome is database creation. Key Responsibilities: - Accurately inputting data from physical papers into a digital format - Processing the data as per the project requirements - Ensuring the created database is structured and easily navigable Ideal Candidate: - Proven experience in data entry and data processing - Proficient in using tools like Excel or Google Sheets - Attention to detail and accuracy in data entry - Ability to understand and follow specific data processing instructions Your work will be crucial in enabling me to organize and analyze this data effectively. I am looking for someone who can take ownership of the task and deliver high-quality results within the agreed timeline. Please indicate your relevant experie...
I'm in search of a meticulous data entry specialist to assist with my Excel-related work. Key responsibilities: - Data entry: The work pertains to entering simple, text-based data into Excel sheets. - Data sourcing: This role requires you to source the data before entry. Ideal skills for this project: - Proficiency in Excel: A strong grasp of Excel functions and formulas is a must. - Data entry experience: Previous experience with data entry, especially in Excel, is preferred. - Research skills: A knack for sourcing data efficiently and accurately.
I have two PDF files that contain about 150 records each that I need entered into a single spreadsheet. I do not require any specific categorization, but rather a direct, one-to-one transfer of the information from the PDFs into the spreadsheet. The data fields needed are names, addresses, emails phone number etc Ideal Skills: - Proficiency in data entry - Experience with working on PDFs - A...need entered into a single spreadsheet. I do not require any specific categorization, but rather a direct, one-to-one transfer of the information from the PDFs into the spreadsheet. The data fields needed are names, addresses, emails phone number etc Ideal Skills: - Proficiency in data entry - Experience with working on PDFs - Attention to detail - Familiarity with spreadsheet software (such as ...
I need a proficient Excel user to create a workbook for my multiservice business. What I Require: - The ability to record both cash, check and card income, as well as expenditure for each. This tool needs to be able to accommodate and separate these different transactions for easy access and clarity. Desired Features: - It should automatically calculate the daily and monthly income for each category. - Must also offer a daily and monthly balance for cash flow. Skills & Experience: - Strong Excel skills are a necessity. - Ideally, the freelancer should have experience with creating business financial sheets. Timeline: - I'd like this project completed as soon as possible. Urgency is key.
I...physical paper form, and the expected outcome is database creation. Key Responsibilities: - Accurately inputting data from physical papers into a digital format - Processing the data as per the project requirements - Ensuring the created database is structured and easily navigable Ideal Candidate: - Proven experience in data entry and data processing - Proficient in using tools like Excel or Google Sheets - Attention to detail and accuracy in data entry - Ability to understand and follow specific data processing instructions Your work will be crucial in enabling me to organize and analyze this data effectively. I am looking for someone who can take ownership of the task and deliver high-quality results within the agreed timeline. Please indicate your relevant experie...
I'm in need of a freelancer who can assist me with the styling and formatting of an Excel spreadsheet. Your task will primarily involve applying cell style formatting. Specifically, I'm requiring assistance with: - Implementing cell style formatting. Please note that while the exact type of cell styles are not defined yet, I will be able to provide more details and guidance once the project begins. Ideal skills for this job would include: - Proficiency in Microsoft Excel - Previous experience with complex Excel formatting - Ability to work independently and on deadline Please, in your bid, include examples of any similar jobs you've completed.
... Seamless embed, maybe even uses website's CSS information? Picture or Icon Mobile Responsive: Features: * E-mail me the Lead with all information collected * Save in Google Sheets as a database * Main thing is to have it look nice and don't look out of place, similar font style, sizing, font size, etc * Use embed code to copy and past into my page builder * Create a plugin to help me customize the quiz, like images, text & size, etc. Desired Programming Language: PHP / SQL * I'm looking for the best deal possible, please be very competitive. * Milestone release upon completion
I'm looking for an Azure professional who can help me set up an Azure cloud solution to host my Excel data. The project involves: - Hosting Excel Data: I will provide you with an Excel file, which I would like hosted on Microsoft Azure. The data in this file will not be updated frequently, just once for now. - Web Application: I would like the Excel data to be accessed through a web application. This means you will need to set up a simple, user-friendly interface for viewing and possibly manipulating the data. Ideal Skills: - Experience with Microsoft Azure, particularly in hosting data. - Proficiency in setting up web applications. Please get in touch if you have the right expertise, and we can discuss the project further.
...Overview: Showcase popular services through a slider on the front end, adjustable by the admin. Customize service display based on date, name, or cost, with admin control. Implement a commission structure for admin's revenue, configurable via the admin panel. Key Features: User Authentication and Registration Product/Service Listings with Descriptions and Pricing Search and Filter Options Shopping Cart and Secure Checkout Process Comprehensive Order Management User Reviews and Ratings Personalized User and Supplier Profiles Centralized Admin Dashboard for Platform Management Inventory Management and Integration Analytics, Reporting, and Security Measures Responsive Design for Multi-device Accessibility Internal...
I am seeking a detail-oriented freelancer to input text and numerical data into 3 small Excel spreadsheets, containing 1 column each. 2 spreadsheets for emails, one called Minnesota, one called Midwest. 1 spreadsheet of inventory numbers. See attached. Only emails are needed. Inventory is on yellow paper Ideal Skills: - Proficient in Excel - Attention to detail - Knowledge of data organization and management Highlight the entries that you are not sure of, or the handwriting is to difficult to read. English fluency in a must.
The task centers around leveraging Python programming and machine learning skills to perform data analysis. The data to be analyzed are contained in an Excel sheet, specifically focusing on customer data. The ideal freelancer for this task should exhibit the following: - Strong proficiency in Python programming. - Solid experience with machine learning. - Familiarity with data analysis, particularly descriptive analysis. - Ability to accurately interpret customer data. The task requires a reading of the Excel sheet and performing data analysis based on the customer data contained within. The chosen Python and machine learning expert will focus on descriptive analysis techniques to extract meaningful insights. Your insights should guide our strategies in terms of customer se...
I'm in need of an experienced PowerShell script writer, specifically for Power BI associated data management tasks. As part of the project, code will be required to execute the following tasks: - Data extraction from Excel files, CSV files, and SQL databases - Transformation of data, including extraction and update of parameter values from Data Models in each Workspace Ideally, the freelancer would carry a strong understanding and hands-on experience with PowerShell scripting, Power BI, data transformation techniques, and working with database source files like Excel, CSV, and SQL formats.
Hello, I have 6 simple contact web forms that I would like recorded into a single matrix. The goal is to see the field alignment and comparison between the form data.
For this research-focused task, I am in need of someone to gather information about the parental leave policies of all Fortune 200 companies. The three key areas of consideration are: - Length of Paid Leave - Who is el...leave - Link to backup materials The data collected must be delivered in a spreadsheet format with links to the backup material in the spreadsheet as well. This project would be a great fit for someone with: - Proven experience in research & analytics - Demonstrated understanding of HR policies, especially parental leave - Detail-oriented and data-organized approach - Proficient user of Excel, Google Sheets, or similar tools. Your end deliverable will be a comprehensive spreadsheet, summarizing the length of leave, compensation during leave, and who i...
I'm seeking an expert data analyst specializing in financial data analysis for real estate development projects. The focus will be on the financial aspects of our upcoming construction project, specifically concerning future projections for the next 10 years. Candidates should be competent in: - Creating custom excel/ google sheet template - Forecasting Capital Expenditure - Predicting Cash Flow - Delivering revenue Projections Your role will involve analyzing, interpreting, and providing insights on these aspects. Proficiency in financial modeling and forecasting is a must. Knowledge about the construction sector will be highly regarded, and prior experience in real estate development is a bonus. To make informed decisions, we're relying on accurate and in-depth anal...
...- Valuation: A comprehensive evaluation of the company's worth. - Business summary: A concise overview of the company's operations and key strengths. - Risks: Identification and analysis of potential risks the company faces. - Industry analysis: Understanding the company's position and performance in the context of its industry. - Reach format report with 10k words, charts and infographics. - Excel modeling and native file is part of the deliverable. Ideal candidate would have: - Proven track record in financial analysis - Strong understanding of financial principles and methodologies - Previous experience in company valuation - Ability to present findings in a clear, concise and actionable format - Attention to detail and high analytical skills Please provide ...
I require a webpage which will primarily serve to display information by filtering it. Key functionality would involve options to add, remove, edit the items (by me only). Most importantly to filter them by anyone visiting the website. The items are filtered by multiple tags that the items should have, they can have 0, 1, 2 or many of the same “category” types. They also need to have categories for easy separation. The webpage will have roughly 100-200 items. More detailed information can be given privately. This webpage is for personal and group of friends use, not professional. The items themselves will consist of an icon of the item (32x32 pixel) and will follow the information on the items for the remaining 95% of the "item card"
I am seeking an experienced developer who is well-versed in React JS and Node JS for the development of an e-commerce platform. This platform will be designed to support a range of e-commerce functions, with the main focus being on product search and filter options. Key responsibilities & requirements: - Proficiency in React JS for front-end development - Experience with Node JS for back-end development - Strong understanding of e-commerce structures and functionalities - Ability to integrate user-friendly product search and filter options The ideal candidate should be someone who has not only the technical expertise, but also the vision and creativity to enhance the user experience through these key functionalities. A portfolio showcasing previous e-commerce project...
I need a skilled Excel professional to help me with data analysis and manipulation using the Solver add-in to solve optimization problems. Key Requirements: - Perform data analysis and manipulation in Excel - Apply Solver add-in to solve optimization problems Ideal Skills and Experience: - Strong proficiency in Excel - Prior experience with data analysis and manipulation - Familiarity with Solver add-in in Excel - Ability to interpret data to solve optimization problems - Attention to detail and accuracy for successful data manipulation Please include your relevant experience and how you can address the task described above in your bid.
I am looking for a skilled Excel dashboard developer to build a proficient tool to track vital business metrics a balance scorcard. The ideal candidate for this job should have: - Expertise in creating user-friendly KPI and balanced scor cards dashboards. - Understanding of various KPIs including revenue growth, customer acquisition, and conversion rate. Key Project Details: - I already have specific KPIs to be tracked and would share them with you post project initiation. - The dashboard should be designed to automatically update on a monthly basis based on manual input that would be added to calculation sheet for each kPI. - The dashboard must be easy to read, understand, and interactive. - the dash board should include risk alert for KPIs we are falling behind in My expectat...
I am seeking to create a marketplace using Magento for selling beauty and cosmetics from various brands. This platform will be complete with various essential features, comprehensive affiliate module, and multiple payment methods. - Marketplace Features: The site should contain product search and filter options, user reviews and ratings, and a secure shopping cart and checkout process. - Payment Methods: The platform should support multiple payment methods including Credit card, PayPal, Bank transfer, Boleto bancario, and Debito. - Affiliate Module: The marketplace will also need a robust affiliate module with functionalities including affiliate tracking and reporting, commission and payout management, promotional tools and banners, alongside a recruiting program. The ideal f...
1 have 1500 company names and i want to find their related instagram accounts. Key Responsibilities: - Conduct market research on Instagram to extract relevant data Ideal Candidate: attentive to details Location: Dubai Data collection: google sheets
...Overview: Showcase popular services through a slider on the front end, adjustable by the admin. Customize service display based on date, name, or cost, with admin control. Implement a commission structure for admin's revenue, configurable via the admin panel. Key Features: User Authentication and Registration Product/Service Listings with Descriptions and Pricing Search and Filter Options Shopping Cart and Secure Checkout Process Comprehensive Order Management User Reviews and Ratings Personalized User and Supplier Profiles Centralized Admin Dashboard for Platform Management Inventory Management and Integration Analytics, Reporting, and Security Measures Responsive Design for Multi-device Accessibility Internal...
I'm seeking a skilled web developer to build a multi-featured online shop similar to Amazon for my site. Key functionalities needed include: - Product Filters: Shoppers need to be able to filter their search by various options. - Size and Color Selection: It should be possible for buyers to pick their desired size and color prior to purchase. - Subscription Service: I wish to implement a subscription service offering monthly and yearly options, plus tiered pricing according to the number of products purchased. For payment, I've opted for Stripe payment integration and a bank transfer option. Therefore, experience in integrating these payment systems is essential. With your proposal, kindly attach website samples you’ve developed with similar requirements. By doing ...
We're seeking a talented 3D artist capable of producing captivating photorealistic renders and videos for a range of products. The ideal candidate must excel in rendering techniques, possess meticulous attention to detail, and have the ability to breathe life into products through stunning visual representations. Responsibilities: Create photorealistic 3D models of products. Develop high-quality textures and materials. Render product images and videos using industry-standard software. Collaborate closely with the creative team to ensure alignment with brand guidelines. Optimize renders and videos for various platforms. Requirements: Demonstrated expertise in 3D rendering, modeling, texturing, and lighting. Proficiency in industry-standard 3D software. A strong portfolio sho...
I'm looking for an Excel expert to develop an NSE options chain tool that will provide real-time data. The primary goal of this software is to facilitate educational purposes by explaining the basic concepts of options trading. Key Requirements: - Real-Time Data: The tool should be able to fetch and update real-time data from the NSE options chain. - Educational Focus: The content presented should be geared towards explaining the basic concepts of options trading in a clear and easy-to-understand manner. - Excel Proficiency: The ideal candidate should have a strong command over Excel and be able to integrate real-time data sources effectively. Ideal Skills and Experience: - Advanced Excel Skills: Proficiency in VBA and data connections is a must....
I'm in need of an Excel expert who can help me automate data entry and formatting tasks. I also need assistance in creating a macro to generate daily status reports. Key Tasks: - Automate data entry tasks - Automate formatting tasks - Create a daily status report macro Requirements: - Proficiency in Excel and VBA macro creation - Experience in automating data entry and formatting - Previous history of generating reports using VBA - Strong communication skills and ability to understand and translate my requirements efficiently.
I'm in need of a skilled Excel expert who can assist with advanced formulas and functions. The main task will be related to carrying over formulas in both the same sheet and different sheets. Key requirements: - Advanced knowledge and experience in Excel formulas and functions - Proficiency in carrying over formulas across multiple cells and sheets - Ability to efficiently manage and implement complex formulas Your responsibilities will include: - Identifying the most suitable formulas based on specific requirements - Implementing the formulas accurately and ensuring they work correctly - Carrying over these formulas as needed across multiple cells and sheets If you're an Excel guru with a strong background in advanced formulas and fu...
