Excel vba look data sheet jobs
I'm in need of a professional who can extract data from a corporate website and compile it into an Excel spreadsheet. Key Requirements: - Extract data from a corporate site. - Data includes: Shopping Centre Name, Street Address, Suburb, State, and Post Code. - Focus on all store locations in New South Wales (NSW). - Use web scraping techniques for data extraction. Ideal Skills: - Proficiency in web scraping. - Experience with data extraction from corporate sites. - Excel spreadsheet management skills. - Familiarity with New South Wales geography is a plus.
I need a proficient Excel expert to help me with a VLOOKUP task involving my inventory data. Specific task: - The VLOOKUP function needs to match exact quantities within my inventory. Ideal Skills: - Advanced proficiency in Excel, particularly in using VLOOKUP. - Prior experience in inventory management is a plus.
...delivering a detailed database of 7,000 US companies. Each company profile must encompass key details like the company name, and its associated emails (e.g CEO email, Owner email, Founder email etc.) along with the website. Key Requirements: 1. All data must be current and verified for precision. 2. Data must be sourced from credible platforms to ensure uniqueness, eliminating any duplication. 3. Final data should be presented in an orderly Excel or Google Sheets format. 4. Timely delivery within 7 days from the project start date. 5. Proficient use of data scraping and verification tools and platforms. Please ensure to read the project description carefully before bidding. If you're not in agreement with the budget or are unable to fulfill the ...
I am looking for a vibrant, fun, and colorful menu design for my takeaway pizza and pasta business. The menu should be a double-sided sheet. It needs to highlight our popular dishes, and include ingredients and descriptions. Key Requirements: - A knack for creating engaging, colorful designs - Experience in menu design, particularly for food services - Strong understanding of layout for a double-sided sheet - Ability to succinctly include ingredients and descriptions without cluttering the design - Creative approach to presenting our popular dishes and special offers Your proposal should showcase your previous work in similar projects, ideally with fun and colorful designs. Please provide a timeline and cost estimate for this project.
I'm looking for a skilled Google Sheets expert to create a comprehensive wealth tracker for me. The spreadsheet needs to accommodate various income sources, including Wages/Salary, Side Hustles, and Business income. It should also factor in both personal and business debts, such as Credit ...Investment accounts I would like this spreadsheet to mimic a budget template I've attached, but modified to fit my needs. Ideal Skills and Experience: - Proficiency in Google Sheets - Experience with financial tracking spreadsheets - Ability to understand and implement complex requirements - Good communication skills for understanding my needs and providing updates. Here is a link to some dummy data.
I'm looking for an expert in financial modelling to create a comprehensive Excel model for my new business. The model will be used primarily for an investor presentation, so it needs to be robust and compelling. Key Requirements: - Inclusion of all essential financial statements: Income statement, Balance sheet, and Cash flow statement. - Projections covering a period of 5 years. Ideal Skills: - Expertise in financial modelling and Excel. - Experience with investor-focused financial presentations. - Ability to create clear and precise financial statements.
I'm...Grocery Items Database suitable for an online app and website. The database needs to be in Excel format, and must include: - UPC, Bar code - Product Name - Product description - Unit - MRP - Multiple high resolution images The database should cover all branded standard grocery items across the following categories: 1. Fruits 2. Vegetables 3. Grocery & Staples 4. Breakfast & Dairy 5. Biscuits & Snacks 6. Beverages 7. Personal Care 8. Home Care Ideal Skills: - Database Management - Data Entry - Research Please note: - The data should be free from copyright restrictions and not sourced directly from Google. - I will need an initial sample to assess the quality of the information and images. - Data needs to be structured in a category-w...
I need an Excel file containing my bank transactions converted into a QFX file, which can be imported into Quicken. Ideal Skills and Experience: - Strong proficiency in Excel - Experience with file conversion to QFX - Familiarity with Quicken software - Attention to detail to ensure all transactions are accurately converted.
I have an Excel file that contains crucial customer information. I need it organized correctly to facilitate better understanding and accessibility. Requirements: - Primary focus on organizing Names and Contact Details. - Each contact's item should be in its own column: Name, Email, Street, City, State, Post Code, and Country. Ideal Skills and Experience: - Proficiency in Excel - Experience in data organization - Attention to detail
I'm in need of a comprehensive operating and financial model in Excel for a new venture. The model should encompass an operations section, a financing component (balancing both Debt and Equity), and generating complete Profit & Loss and Balance Sheet outputs. Key Requirements: - Detailed representation of production costs, sales volume, employee expenses, and capital costs in the operations section. - Consideration of daily hire rates, income from asset disposal, build period expenses, and utilisation metrics. - The financing section should adequately reflect a mixture of Debt and Equity. - Major sensitivities to be clearly presented within the model. Ideal Skills and Experience: - Proficiency in Excel with a strong background in financial modelling. - Prev...
I need an Excel dashboard created to track H2S material limits. The primary data source will be Excel Spreadsheets. The dashboard should allow me to monitor: - Material Suggestions I would like the data to be visualized using Pivot charts. Attached file has some created dashboard but they do not provide accurate data. Need to modify it and make more accurate. Ideal skills for this job include Excel proficiency, data visualization, and experience with dashboard creation.
I'm seeking an expert to perform calculations for my draft financial statements (Balance Sheet, Income Statement, Cash Flow Statement) in accordance with IFRS, ready for audit submission within the next 3 hours. Please note that I only require a review of my existing supporting notes, not the creation of new ones. Industry: Service. Ideal skills and experience: - Proficient in IFRS - Experienced in financial statement preparation - Able to review and assess supporting notes - Background knowledge in Service industry finance is a plus.
I'm in need of an Excel expert who can help me build a comprehensive workbook to capture end of shift data from multiple locations. Key categories to include: - Delays OS&D - Scanning/PLS Cube Outs - Equipment Issues - Driver Issues - Safety Crucial categories for reporting: - Delays OS&D Specifics for managing Delays OS&D: - I need to be able to list specific delays Ideal skills and experience: - Proficient in Excel - Data management experience - Ability to create user-friendly and efficient workbooks.
I'm seeking help with ICDL programming, specifically focusing on Excel, Word, and PowerPoint. Ideal Skills: - Proficient in Excel, Word, and PowerPoint. - Experienced in teaching or tutoring ICDL content. - Able to prepare for certification assessments. Key Tasks: - Assist with understanding and practical application of ICDL concepts. - Provide targeted help with Formulas and Functions in Excel. - Support with general use of Word and PowerPoint. - Prepare for certification.
...project and need assistance with Microsoft Excel and PowerPoint. Microsoft Excel: - Data Entry & Formatting: I have a lot of data that needs to be entered and formatted correctly in Excel. - Creating Formulas & Functions: I need someone who is skilled in Excel to create appropriate formulas and functions to manage my data. - Data Analysis & Visualization: The project will require some data analysis and I would appreciate help visualizing the data using Excel tools. Microsoft PowerPoint: - Creating a Presentation: I need a PowerPoint presentation to accompany this project, so experience in creating engaging and clear presentations is a must. Ideal candidates should have: - Advanced skills in Micro...
I need assistance with an Excel spreadsheet. The task involves adjusting column D to ensure all wrapped text is readable. - Number of Rows: The column contains between 100 and 500 rows. - Software: The file is in Microsoft Excel. - Specifics: Only column D needs to be adjusted, not the entire spreadsheet. Ideal skills for this project include proficiency in Microsoft Excel, attention to detail, and experience with data manipulation and formatting in spreadsheets.
I'm looking for an Excel expert to help me with a task related to tracking revenue. The primary focus will be on creating projections based on available market growth data. Key Responsibilities: - Analyze market growth data to create revenue projections - Use advanced Excel skills to apply necessary equations and techniques Ideal Skills: - Proficient in Excel, particularly with financial equations - Experience in revenue tracking and forecasting - Strong analytical skills to interpret market data
I'm looking for an Excel expert to help me create a comprehensive inventory management spreadsheet for my business. Key Requirements: - Inclusion of all our supplier's items that we sell - Categorization of items by product type The ideal freelancer for this project should have extensive experience with Excel and inventory management systems. They should be able to create a user-friendly, efficient, and organized spreadsheet that meets these requirements.
I'm seeking a software developer to create a Windows-compatible solution for managing estimates, sales/purchase orders, and invoices for our dealer network. Key Requirements: - Create a user-friendly interface for managing estimates, sales orders, purchase orders, and invoices. - Design the software with a primary focus on generating estimates. - Incorporate customi...operating system. The ideal candidate will have: - Extensive experience in software development, particularly for Windows. - Proven skills in designing user-friendly interfaces. - Prior experience in developing software for managing sales and purchase orders, and invoices. - Ability to create customizable templates within the software. - Strong understanding of the needs of a dealer network. I look forward to ...
I need an Illustrator expert to separate out the layers of a color wheel for me. The separated layers will be used for print materials, so it's crucial that they are prepared...Expert level proficiency in Adobe Illustrator - Prior experience with preparing files for print - Ability to deliver the final file in PDF format I want each of the 4 color rings to be represented as a full circle so I can make a 3D version the print and each layer is a full circle with color going to the center as a slide of the “pie”. The largest circle should be able to print on an 8.5x 11 sheet of paper and the other circles should be the same ratio as compared to the largest level 4. So the end product will be 4 separate circles in pdf pages that are the same relative size to each other...
...expert to update my Excel dashboard. This dashboard is currently used for reporting the daily status of equipment. The update should streamline the process, making it faster and more convenient. Key Tasks: - Revamp the Excel dashboard to improve its efficiency - Incorporate equipment status and availability as primary data points - Ensure the new setup accommodates future needs - Due to much formula, the sheet is slow to navigate Currently, I manually input the status and availability of equipment into the dashboard. The updated dashboard should ideally reduce the manual workload and make the reporting process more efficient. Skills and Experience Required: - Proficiency in Excel, with a strong understanding of dashboard creation and management - E...
I need an expert in Excel VBA to breathe new life into my project. The enhancements will involve: - **Data processing and automation**: Improving the efficiency and speed of data handling processes. - **User interface enhancements**: Making the project more user-friendly with better forms, buttons, and navigation. - **Integration with external systems**: Ensuring seamless connectivity with other platforms and systems. The user interface improvements will focus on: - **Forms and input fields**: Streamlining data entry and enhancing usability. - **Buttons and navigation**: Simplifying the user journey through the project. - **Report layouts and visuals**: Upgrading the presentation of data for better comprehension. Visually, the reports will need...
I am looking for a Hindi-speaking individual to visit our warehouse in Port Klang, Malaysia. The purpose of this visit is to teach a small group of our Indian staff (1-5 members) basic computer skills. Skills to be taught include: - Using a web browser - Using Google Sheets - Using Microsoft Excel The level of proficiency we aim for is basic. Your role will be crucial in helping our staff become more computer literate and improving their productivity. Ideal candidates will have: - Proficiency in Hindi and Malay - Strong knowledge of basic computer skills - Experience in teaching or training - Patience and good communication skills
1) Collect data, examine it, and identify any duplicates or outliers, ensuring its completeness and accuracy. 2) Create a table and organize the data in a clear and easy-to-understand format. 3) Provide statistical analysis using mean, median, mode, variance, standard deviation, and other relevant metrics. 4) Present charts that illustrate the relationships between variables 5) Present charts that help predict future trends, identify gaps, and improve performance and operational efficiency.
...for me, and I haven’t got the time to complete this questionnaire sheet this weekend, so may I request your professional English writing expertise. Fill out the attached sheet to provide input for this comedy writing material based on rationality in everyday life. I welcome you to read the following first, then check out the sheet, place a bid. It would be kind of you to provide the answers using quality English grammar in the attached Excel spreadsheet within 2 days. Allow me to observe your progress after the first hour so I can provide early feedback on your answers. Get into the spirit of comedy writing, consider all the witticisms and wordsmith techniques, and provide your best answer to each of the questions (70+). Look for inspiration onl...
I need assistance with my Excel workbook. - Software: The data is in Excel. - Tabs: The workbook contains 1-5 tabs. - Specific Columns: Only column D is being checked for hidden text. The project involves going through the rows on each tab and widening the rows in column D so all of the wrapped text can be read.
I'm looking for a one-time web scrape of an eBay page containing 5,500 products. The products do not have any variants, which should simplify the task. Data to be scraped: - Product name, price, category, subcategory, brand - Product description and images The final deliverable should be an Excel/CSV file containing all the scraped data. Ideal skills for this project include: - Proficient in web scraping - Experienced in data organization and Excel/CSV Please, only bid if you can deliver quality work in a timely manner. Thank you!
I'm looking for a proficient Python developer who can create a script for me. The specifics of the project, such as the script's primary purpose, the type of data it will process, and the input format it should accept, have not been defined yet. Therefore, I'm open to suggestions based on what you think would be the best fit for a Python script. Read the file attached for details and say ''Halo' so i know you have read the details Ideal Skills and Experience: - Proficiency in Python - Experience in creating Python scripts - Ability to work with various data types - Knowledge of different input formats, such as CSV, JSON, and Excel files - Creativity in proposing suitable script purposes Budget is 30 usd it could lead to long term Pl...
I need assistance with renumbering my Excel file. The task involves: - Sequentially numbering all rows in column B with simple integers (1, 2, 3, ...). The freelancer should be proficient in Excel and have experience with data manipulation and formatting.
I have an Excel sheet locked with input data that needs adjustment for proper calculations. The sheet is primarily for data analysis. Key Tasks: - Unlock the sheet to facilitate modifications - Adjust specific numbers to correct data input errors - Modify calculation formulas to ensure accurate outcomes Ideal Skills and Experience: - Proficiency in Excel, including unlocking sheets, modifying data, and adjusting formulas - Strong attention to detail to identify and correct data input errors - Experience in data analysis to understand the context and purpose of the adjustments
I need mixed data (text and numbers) from a PDF entered into an Excel spreadsheet. The ideal freelancer should be proficient in data entry, have excellent attention to detail, and be experienced in working with both PDFs and Excel. Key Requirements: - Entering mixed data (text and numbers) from a PDF into an Excel spreadsheet - Formatting the data into standard tables - Applying conditional formatting as per the requirements Please ensure you have a strong understanding of how to implement conditional formatting in Excel, as this will be a crucial part of the task.
...with the private lending or real estate industry, this is a perfect opportunity for you! Key Responsibilities: Content Creation: -Write professional, compelling email copy tailored to real estate investors and borrowers. - Design engaging visuals (images, infographics) to make emails visually appealing and effective. - Create email campaigns focused on: - Case studies of successful deals. - Term sheet offers and financing options. - Educational content (e.g., private lending tips, real estate financing strategies). SendGrid Campaign Management: - Set up and manage email campaigns using SendGrid’s Marketing Campaigns feature. - Create personalized email templates with dynamic fields for recipient-specific details. - Schedule campaigns and set up automated sequences (e.g.,...
I'm looking for a skilled VBA programmer to enhance my existing code. Around 75% of the code is already written to read data from CSV/Excel. The enhancements should facilitate the generation of summary reports, creation of various types of graphs and additional data processing functionalities. Key Responsibilities: - Modify existing VBA code to create summary reports. - Develop functionality to generate Bar charts, Line graphs, and Pie charts. - Implement additional data processing capabilities including data filtering, sorting, and aggregation. Ideal Skills: - Proficiency in VBA - Experience with Excel and CSV data processing - Strong understanding of data visualization techniques - Ability to create comp...
I'm looking for a proficient Python developer who can create a script for me. The specifics of the project, such as the script's primary purpose, the type of data it will process, and the input format it should accept, have not been defined yet. Therefore, I'm open to suggestions based on what you think would be the best fit for a Python script. Read the file attached for details and say ''Halo' so i know you have read the details Ideal Skills and Experience: - Proficiency in Python - Experience in creating Python scripts - Ability to work with various data types - Knowledge of different input formats, such as CSV, JSON, and Excel files - Creativity in proposing suitable script purposes Please feel free to propose what you think would...
I have a set of 69 KPIs in an Excel sheet, spanning across 10 projects. I need a performance formula that will automatically provide the KPIs/projects status based on specific thresholds. It's important to note that some of the KPIs are negative metrics. In addition, I require an interactive dashboard for these KPIs. The entire project is in Arabic. Key requirements: - Devise a performance formula that can assess the KPIs/projects status based on predetermined thresholds - Create an interactive dashboard in Microsoft Excel - Understand and cater for negative metrics within the KPIs - Project is in Arabic, hence understanding or capability to work in Arabic is a plus Ideal skills and experience: - Proficient in Microsoft Excel - Experience in creating int...
Emerging Market Bond Data Extraction Project overview Extraction of trading data for sovereign bonds from specified countries over the last 30 trading days, replicating the structure of an example Excel file. Data needs - Data extraction for last 30 trading days of sovereign bonds from Kenya, Burkina Faso, Sao Tome and Principe (São Tomé-et-Príncipe), Ghana, Liberia, Zimbabwe, Peru, El Salvador, Sierra Leone, and Namibia. - Platforms that may be used include Cbonds, Bloomberg, Refinitiv Eikon, or Market Axess, etc... - Specific data columns required: issue (bond name and detail), date, time of last trade, stock exchange, bid, ask, bid ask spread, min, high, close, indicative and indicative type, volume of transactions in mon...
I'm looking for a freelancer who can enter data from an Excel sheet into my e-commerce website. This task involves working with electronics products and requires attention to detail and technical understanding. Key Responsibilities: - Enter product data from Excel(upto 5K data) into the website. - Include all necessary product descriptions, focusing on technical specifications and usage instructions. - Upload product images alongside the descriptions.
...this is a perfect opportunity for you! Key Responsibilities: Content Creation: - Write compelling and professional email copy tailored to real estate investors and borrowers. - Design engaging visuals (images, infographics, or graphics) to make emails more appealing and informative. - Create email campaigns that: - Highlight case studies of successful deals. - Showcase financing options and term sheet offers. - Provide educational content (e.g., tips on real estate financing). Email Campaign Management: - Use email marketing platforms (e.g., Mailchimp, MailerLite, SendGrid) to schedule and send campaigns. - Set up automated email sequences (e.g., follow-ups or drip campaigns). - Ensure each email includes clear CTAs (e.g., schedule a call, request more info). Campaign Optimiz...
I need assistance uploading 1000 products to my Magento store. Product Information: - I have all the product details ready which include descriptions, images, and pricing. - The information is not in a standard format, so some preliminary data processing may be needed. Skills and Experience Required: - Extensive knowledge and experience with Magento is essential. - Proficiency in data processing and Excel is required, as the product information will need to be formatted for Magento. - Attention to detail is critical to ensure all product information is uploaded correctly.
I'm seeking assistance in creating an Excel spreadsheet dedicated to customer data entry. The primary focus will be on tracking customer contact details. Key Requirements: - Proficient in Microsoft Excel - Experience in data entry - Ability to maintain accuracy and confidentiality Ideal Skills: - Data Management - Attention to Detail - Proficiency in Excel Functions and Formulas
I'm a concert pianist seeking a professional Wix developer to revamp my website. It already exis... with the addition of a Media/Listen page akin to that features my Spotify recordings. Site Sections: - Biography - Concert Schedule - Media/Listen Page - Gallery - Editions - Contact Key Requirements: - Multilingual: English, Portuguese, Spanish - Clean, modern design - Integration of newsletter signup, event booking, and an online store for sheet music or recordings Skills & Experience: - Proficiency in Wix - Web design experience with a modern, clean aesthetic - Multilingual site development - E-commerce integration - Experience with audio embedding from Spotify I will provide all necessary materials. Thank you for your interest.
I have over ten Excel files containing sales figures organized by product. All these files have the same format, making them straightforward to merge. I'm seeking a freelancer who can expertly consolidate these files into one comprehensive total sheet. Ideal Skills: - Proficient in Excel - Data Analysis - Attention to Detail - Experience with Data Consolidation
I'm seeking a detail-oriented freelancer for data entry of a food menu in an Excel sheet. The task involves cataloging items with their name, price, and description. Key responsibilities: - Accurately inputting data into an Excel sheet - Finding and selecting appropriate images from stock photo websites - Ensuring descriptions are correct and relevant Ideal skills: - Proficiency in Excel - Strong attention to detail - Experience with data entry tasks - Ability to source relevant images online We shall be sharing a PDF menu card rest all to be done
I'm looking for an Excel sheet that generates newspaper bills for approximately 150 houses on a weekly basis. This should include the delivery charge and provide a total for each week, as well as a 4-week total, excluding holidays or days when the paper isn't delivered. Key Requirements: - The bill should include the house number and address, total number of papers delivered, and the week's total cost including the delivery charge. - I need to manually enter non-delivery days. - The final summary of the total weekly and 4-week costs should be displayed in the same Excel sheet. Ideal Skills & Experience: - Proficiency in Microsoft Excel, particularly in creating complex sheets with formulas and functions. - Previous experience in creat...
I need a meticulous professional to assist with data entry from scanned documents. The data consists of both text and numbers, and needs to be accurately transferred into an Excel spreadsheet. Ideal Skills: - Proficiency in Excel - Excellent attention to detail - Prior experience with data entry from scanned documents - Ability to handle mixed data types (text and numbers) - Strong organizational skills
I'm looking for a proficient Python developer who can create a script for me. The specifics of the project, such as the script's primary purpose, the type of data it will process, and the input format it should accept, have not been defined yet. Therefore, I'm open to suggestions based on what you think would be the best fit for a Python script. Read the file attached for details and say ''Halo' so i know you have read the details Ideal Skills and Experience: - Proficiency in Python - Experience in creating Python scripts - Ability to work with various data types - Knowledge of different input formats, such as CSV, JSON, and Excel files - Creativity in proposing suitable script purposes Please feel free to propose what you think would...
I need assistance with an Excel task. The project involves adding rows in Excel based on a specified number in a cell. Key Requirements: - Adding new rows containing specific formulas - Ensuring that the formulas in the new rows reference fixed cells Ideal Skills and Experience: - Proficient in Microsoft Excel - Experienced in working with Excel formulas - Detail-oriented with a good understanding of fixed cell references in Excel
I'm looking for a proficient Python developer who can create a script for me. The specifics of the project, such as the script's primary purpose, the type of data it will process, and the input format it should accept, have not been defined yet. Therefore, I'm open to suggestions based on what you think would be the best fit for a Python script. Read the file attached for details and say ''Halo' so i know you have read the details Ideal Skills and Experience: - Proficiency in Python - Experience in creating Python scripts - Ability to work with various data types - Knowledge of different input formats, such as CSV, JSON, and Excel files - Creativity in proposing suitable script purposes Please feel free to propose what you think would...
I need a professional who can help me send my HTML form data to a Google Sheet via Google Apps Script without messing with my existing HTML form code. Key Requirements: - Expertise in Google Apps Script - Proficient in HTML and JavaScript - Experience in integrating HTML forms with Google Sheets - Ability to work with existing code without disruption Details: - I have a Google Sheet already set up to receive the data - I need all data fields from my HTML form to be sent to the Google Sheet Please ensure that you don't alter my original HTML form code.
...creating compelling social media posts that resonate with target audiences. In addition to my writing expertise, I offer video editing and creation as a secondary skill, allowing clients to develop content from script to screen. My experience spans editing explainer videos, social media content, and ads, allowing for a seamless process that strengthens your brand’s message. As a Virtual Assistant, I excel in efficiently managing administrative tasks, from email management to digital marketing. My expertise in social media marketing is particularly beneficial for managing e-commerce sites and ad campaigns, boosting conversions and brand visibility. I’m committed to delivering exceptional service, ensuring every project meets the highest standards. Let’s collab...