1st excel vba project jobs
As an e-commerce store owner operating on Shopify, I am seeking a capable professional with experience and skill in product listing to manage the numerous products I intend to have on my store, as their number exceeds 100. To excel in this project, you'd need to demonstrate a track record of successful Shopify management with an emphasis on: - Expertise in handling high volume product listing (above 100 items) - Excellent attention to detail for product descriptions, images, pricing, etc. - Efficient time management skills - Familiarity with SEO principles and application in product listings to drive visibility in organic searches - Knowledge of Shopify's back-end to ensure seamless experience for shoppers Your role will not only contribute to the establishment ...
...developing web applications. # Project Documentation: Lead Management System ## Frontend ### User Login - Users log in with provided credentials (login ID and password). - After login, view new and previous leads. ### Lead Details - Click on a lead to view details. - Options: Edit remarks, Send new quote, Call later. #### Edit Remarks - User can edit remarks related to the lead. #### Send New Quote - Input: - System capacity - Quote amount - BOS cost - I&C cost - Net metering cost - Liaisoning cost - Dealer margin #### Call Later - Schedule a call with date and set a reminder. ### Submission - After inputting data, submit the details. ## Backend ### User Management - Create and manage user accounts. ### Lead Management - Upload leads from Excel...
I am in need of an Excel expert who can assist me with analyzing and reporting a Warranty cost management. Tasks would predominantly include: - Conducting thorough Warranty Coasting analysis on provided data - Developing comprehensive reports on findings - Applying any additional information to point out where the cost were higher. The ideal candidate will: - Have extensive experience with Excel, particularly in data analysis and reporting - Have the ability to use Excel to conduct performance analysis This role does not require VBA macro knowledge but it would be advantageous. Proficiency in data management, manipulation, and interpretation is essential. Along with a knack for turning raw data into comprehensive and meaningful reports.
I'm in need of a full-time, 1st level support professional proficient in German. Your role will primarily involve: - Communicating with customers via Phone and Email. - Assisting with technical issues related to our SaaS product. The ideal candidate should possess excellent communication skills in German and English, a strong understanding of SaaS products, and prior experience in a technical support role. This is a full-time role (40 hours per week) so ensure you have the capacity to commit to this workload.
...specific text details, consisting of Titles and 20 different fields of text or numeric data from individual pages and compile them into a single spreadsheet. This task requires attention to detail as the fields are consistent across all pages, hence it is imperative they are accurately represented in the spreadsheet. Ideal Skills: - Data extraction expertise - Attention to detail - Proficiency in Excel - Web scraping abilities - Understanding of titles, text or numeric data fields extraction I want a sheet with data on the 600 schools associated with the U.S. Interscholastic Sailing Association and its seven districts listed on this page: Each school has data on the team listed on its own page, we need this data, as shown here:
I am seeking a professional with expertise in accounting for a part-time position. The engagement will require them to work twice a month. Their main responsibilities will be: - Financial statement preparation - Bookkeeping - Payroll The ideal individual should have extensive experience managing these tasks. Proficiency in the use of Excel spreadsheets as an accounting tool is a must. As this is part of the software I currently utilize, I would greatly appreciate candidates who can effortlessly navigate this tool in fulfilling their duties. In-depth understanding of tax laws and regulations will be considered an added advantage.
I'm looking for a creative and skilled graphic designer to create a unique, digital invitation for my daughter's 1st birthday. Specifications: - Theme: Butterfly or Floral. The design should incorporate butterfly or floral elements in a tasteful and charming way. - Color Scheme: The colors should primarily be pink and purple. I'm open to the inclusion of complementary colors if it enhances the design. - Elements: While I don't need any specific elements like personal photos or caricatures, I would like the invitation to feature text and design elements thoughtfully. Ideal Experience/Skills: - Previous experience in graphic design, particularly with digital invitations or similar projects - Strength in color theory and thematic design - Highly imaginative w...
I need an expert freelancer who would help with extracting data related to contact information for all businesses in our region. The project involves web scraping and data mining to extract the required information. Required Data in Excel: - Business name - Business address - Business City/town/village - Business Products or Services - Website - Business contact name - Phone number - E-mail address By the end of this project, I am expecting to have a comprehensive list of relevant businesses including their locations, the products or services they offer and their respective contact info. Your work will play a crucial role in helping me connect with potential business leads in this industry. Ideal skills and experience for the job: - 2+ years of experience in data m...
I'm in need of a professional who can set up an automatic data entry system for my Excel sheets. My goal is to improve efficiency and accuracy in my tasks. Key Responsibilities: - Automating the entry of mixed data types (texts and numbers) in Excel - Sourcing these data from an online database Ideal Skills and Experience: - Expert knowledge in Excel and automation processes - Proven experience in dealing with complex data and online databases - Ability to ensure that data is captured accurately and efficiently. Ultimately, I need someone who can implement this automation seamlessly with accurate results. Your contributions will significantly improve my data management processes.
As a client, I'm seeking a skilled developer to design a reporting tool. Key Requirements: - Proficiency in Java, Python, and C++. The chosen developer must have extensive experience developing with these languages as the reporting tool will need to be compatible with all. - The reporting tool needs to have specific features including data visualization and the ability to export data to PDF/Excel. - The tool must be designed to connect to a database for importing data. Ideal Skills and Experience: Experience in developing reporting tools, expertise in data visualization, database connectivity, and data exporting. Familiarity with Java, Python, and C++ is mandatory. Experience in handling data in various formats and creating customizable dashboards is a plus.
My goal is to clean text data in my Excel worksheet. The main agenda of doing so is to facilitate descriptive statistical analysis. Therefore, I need a service provider who: - Has a broad understanding and hands-on experience in data cleaning, especially text data. - Is proficient in Excel and detailed-oriented to avoid manipulation errors. - Possesses skills in statistical analysis, specifically descriptive statistics. Your responsibility will not only include cleaning the text data but also preparing it for subsequent tasks of statistical examination.
...should be presented to track your work - focus of the Seo will be to increase traffic to website - rank 1st on google and see an improvement in sales YOU SHOULD BE ABLE TO DO A KEYWORD SUGGESTIONS FOR THE WEBSITE - - SEO Strategy: Your approach should be particularly targeted towards enhancing my overall search engine rankings and hence, augmenting the online sales. - Webpages: The focus of this SEO service could vary across different pages or sections of my website. However, these specifics will be discussed in detail once we proceed. So expertise in optimizing different website sections is expected. - Timeline: While I've not provided a specific timeline for the project completion, I am looking for someone who can show clear progress in my website's SE...
I need a freelancer skilled in data visualization and Excel to convert an Excel file into a pivot chart showing the top 10 diseases. The chart should focus on disease prevalence, using the disease data provided in the file. Essential skills and experience: - Excellent knowledge of Excel and data visualization - Ability to accurately portray data - Strong attention to detail - Proven track record creating visuals from raw data Tasks include: - Analyzing the provided Excel file to understand the data - Creating a bar chart that highlights the top 10 diseases - Ensuring the chart is accurate and easy to understand Looking forward to receiving proposals from freelancers who understand the significance of accuracy in data presentation.
I'm looking for an adept Excel user to correct the data display problem in my existing small spreadsheet. Here's what I need help with: - The data in the spreadsheet isn't displaying properly. I need someone who can troubleshoot and correct the problem. - I would like to have color-coded cell conditions implemented to represent the presence of specific text. This means that cells containing certain text strings should display in different colors. This would provide a clear and colorful representation of text conditions throughout my document. Proficiency in Excel, particularly in handling display issues and cell formatting, is critical for this project. You'll need an understanding of how to apply color conditions based on text presence in Exc...
I require a quick and accurate data entry specialist to input numerical and textual data, sourced from an online database, into my system. With an estimated total of 100 to 1000 entries, the ideal candidate should be proficient in data mining and Excel. The high degree of precision needed mandates thorough experience with similar projects.
Infographic designer that can design a chart that shows the information in the excel chart. The excel chart has 52 accounting applications with a logo of each and characteristics and features. The chart need to be printed in different sizes a2,a3, a0 and one large chart one meter by three meters. A logo for the chart is required title (Accounting digital innovation lab ADIL). The chart can be as a circle with the 52 logos and the title at the middle or a creative graph of amazing shape.
am seeking a competent data entry specialist with excellent attention to detail and proficiency in Tally. The assignment entails adding around 300 entries from an excel file to tally data (i.e. update company Tally Books ). Each entry in excel has comments that specifies the heading & vendor name for the data entry. Once the data is entered the same will be verified by us for correctness. Key Responsibilities: - Organizing extensive financial data within Tally with accuracy and precision - Ensuring the data is properly categorized and easy to understand - Verifying the accuracy of the financial data, correcting any errors, and handling any discrepancies. Ideal Skills and Experience: The ideal candidate should be precise, meticulous, incredibly organized, and possess th...
I need assistance with creating spreadsheets for managing sales records in Microsoft Excel. This project's specific responsibilities would primarily include: - Developing precise and effective spreadsheets to capture all relevant sales data. Considering the nature of this project, it would be ideal if you have: - Extensive experience in Microsoft Excel, specifically in constructing spreadsheets. - Proficiency in managing and organizing sales records. - An understanding of best practices when it comes to data management in Excel. Please note, no project management fields need to be included in the spreadsheets. Your key objective will be to create spreadsheets that simplify the data entry process and effectively organise sales records.
I am in need of expert help in organizing less than 1000 entries of customer data on a spreadsheet. The data includes various customer details that currently lack structure, making it challenging to retrieve specific information. Ideal Skills and Experience: - Expert knowledge in using spreadsheet tools such as Excel or Google Sheets - Strong experience in data organization on spreadsheets, specifically customer data - Attention to detail is vital as the data should be organized in a manner that enables easy location of specific entries - Understanding of customer data privacy requirements necessary
I am in need of a financial consultant with specific skills in Excel to help me enter financial statements data correctly and promptly. Requirements for this project include: - In-depth knowledge in financial consultancy - Proficiency and experience in Microsoft Excel - Ability to manage and organize financial statements efficiently - Attention to detail and high level of accuracy Please bid with confidence if you meet these requirements and are capable of delivering high-quality results in a timely manner.
I'm seeking an expert to design and implement an interactive touchscreen display system with midi keyboard that will serve an educational purpose for museum visitors of all ages. Requirements: - Develop an engaging and intuitive user interface in in a first of two steps (second optional) - 1st step renew and update a working system (current version available) based on "open office show" - update layout - update content - update multimedia functions - Capable of displaying cross-generational content in a modern and interesting style - Incorporate a diverse mix of multimedia elements - 2nd step (optional) develop the system on a more professional basis with a content management system Content to Include: - Text-based information for in-depth lea...
I am in need of a professional proficient in Excel VBA coding. The right person for this job should have: - Extensive Excel VBA experience - A strong record of creating effective data analysis tools - Proficiency in automating repetitive tasks to enhance productivity. The project will involve: - Developing custom VBA code to streamline data analysis processes - Crafting automation tools for repetitive tasks to increase efficiency Candidates should have demonstrable experience with similar projects, showcasing their ability to take in requirements and effectively translate them into actionable, efficient solutions. Skilled in time management and a keen eye for detail will make you a standout candidate. Your main goal will be to tailor an exis...
I'm in need of an efficient individual to assist with typing data from JPEG invoice images into an Excel spreadsheet. KEY JOB DETAILS: - Your tasks will involve transferring grand total amount data from approximately 120-150 invoices. - The specific data required from each invoice include: Invoice File Name and the GRAND TOTAL amount. SKILLS AND EXPERIENCE: - Strong attention to detail - Proficiency with Microsoft Excel Keep in mind, the project will only be deemed complete once all data has been entered accurately. Speed and precision are a must for this job.
I'm currently seeking a proficient freelancer for a data entry project. The task will involve sourcing numeric data from online resources, and accurately inputting them into a Microsoft Excel file. Key requirements include: - Excellent attention to detail to minimize errors in data entry - Proficiency with using Microsoft Excel and online research tools - Previous experience performing similar data entry jobs successfully Your responsibilities will include sourcing the data and ensuring it is correctly and accurately entered into the Excel file. The final Excel file must be formatted correctly to enable easy use and manipulation of the data. If you possess these skills and experiences, please feel free to place your bid.
I'm in need of a detail-oriented professional to provide administrative support, specifically focused on processing business trip receipts / record into provided excel template Your responsibilities include: - Use Excel. - Organised - NOT part of agency / provider service
I am seeking a freelancer with strong data entry skills to transpose numerical data from PDF files into an Excel spreadsheet. Key Requirements: - Accuracy in typing numbers and data extraction from PDF files - Proficient in Microsoft Excel for data planning and management - Able to perform a simple copy-and-paste activity without error Preference will be given to applicants who have prior experience in numeric data entry and PDF data extraction. The ability to diligently check work for any errors is critical to the role.
...integration plan in excel for me. Various workstreams including Finance, Commercial, HR, IT, etc should be structured into separate sheets within the file. Key features should include: - Workstream Organization: Every workstream will have its dedicated sheet. - Finance Tracking: The finance sheet should be capable of recording and tracking all related data. - Commercial Analysis: A sheet to monitor commercial aspects following the merger. - HR Management: A comprehensive sheet to manage all HR related tasks post-merger. - IT Integration: A sheet to plan and track IT integration process. Ideally, I would like someone with experience in mergers & acquisitions, process inprovement and change management to take on this task. It would be useful if the freelancer has a backgrou...
I'm looking for a detail-oriented data entry specialist to help me extract financial data, particularly remuneration details, from approximately 50 annual reports. I need these details entered accurately into an Excel table I can later analyse. Tasks: - Extraction of financial data from annual reports - Focusing on remuneration information: salary information and sitting/attendance fees - Accurate data entry into Excel Ideally, you have prior experience with financial statements and can pay strong attention to detail. Familiarity with Excel and financial data entry is a must! Accuracy and efficiency are paramount in this job. Here are some links where the annual reports (Year end 2023 or 2022 if 2023 is not available) would sit:
I am looking for an advance Excel expert who can do data analysis of manpower position in an organisation. Sample work is attached in Excel data will he a bit complex.
I'm in need of a creative person with a vision for a 3D rendering of a Mediterranean style house facade. Leveraging your expertise and creativity, I would like you to introduce these elements: • Lush landscaping • Decorative arches and columns • Rounded walls Depict...experience should include, but not be limited to; • 3D rendering • Architectural design • A keen eye for landscaping design I am set on the floor layout. Happy to make some minor changes to suit the facade loking at introducing some drapped plants from the balcony and open to roof or flat roof option. I am looking at a modernised version of Mediterranean to better blend with the area. If you excel at providing creative perspectives, this is the opportunity for you. Let's b...
I need a data analyst to thoroughly assess my sales data. The information is stored in Excel and needs to be analyzed urgently to determine key metrics that will enable me to make informed decisions with regards to our vending machines. The most critical details to extract include: - Product sales: Identifying which items sell more than others - Most popular products: Discovering the specific products customers prefer - Sales volume: Understanding our overall sales output The ideal freelancer should be proficient in Excel and data analysis. Previous experience working with sales data would also be advantageous. Time is of essence for this project and would require immediate prioritization.
I have a logo design at hand and need assistance in converting it into a digital format that can be used for several platforms. Here are the specifications: Std Logo Size (see attached photos) Colours:- Light Blue #acdbdf; Green #bcbb69; Dk Purple #3b3862 Cream f7f7e8 I would like the same logo available in 2 colour ways using the same colours. 1st Colour Way - as shown in above link with no background (just logo no background); Writing (words)is in Dark Purple, and the light blue replaces the cream - left spiral green and 'S' shape double spiral is light blue. I have just realised the cream will not show up on white paper. 2nd Colour Way being for business card - as per last image above but with purple background (business card size or logo on its own - (need to disc...
...e-commerce platforms. The task involves: - Using Python to scrape a sample size of 2000 product details specific to the "Health and Beauty" category in Vietnam marketplace - Gathering specific details from each product including price, number of purchases, customer reviews, title, description, specifications, rating, category/sub-category, seller, and user comments. - Exporting the data into excel sheets as in attachments - Provide documentation detailing the scraping process and data format. - Provide code that is modular, well-documented, and easy to maintain. Ideal skills and Experience: - Proficiency in Web Scraping - Knowledge of E-commerce platforms, Shopee in particular - Familiarity with the "Health and Beauty" category on e-commerce platforms - Inf...
I need assistance correcting an Excel column calculation. An error labeled "#SPILL!" pops up whenever the calculation is attempted. I require someone who can fix it quickly.
...require my direct attention. - Client Relationship Management: Maintaining a professional relationship with our clients. Helping to build and maintain strong, long-lasting relationships. Schedule meetings, send reminders, and follow up with clients to ensure their satisfaction and keep them engaged with our services. - Data Entry: Accurately entering and updating pertinent data. Familiarity with Excel or similar software will be beneficial. - Bidding Task: Take charge of identifying and bidding on relevant projects across multiple platforms. This involves creating compelling proposals that highlight our strengths and match the client's requirements. Requirements: Proven experience as a Virtual Assistant, particularly in inbox management, client relationship, and bidding ta...
I am in need of an Excel expert who can assist me with analyzing and reporting a Warranty cost management. Tasks would predominantly include: - Conducting thorough Warranty Coasting analysis on provided data - Developing comprehensive reports on findings - Applying any additional information to point out where the cost were higher. The ideal candidate will: - Have extensive experience with Excel, particularly in data analysis and reporting - Have the ability to use Excel to conduct performance analysis This role does not require VBA macro knowledge but it would be advantageous. Proficiency in data management, manipulation, and interpretation is essential. Along with a knack for turning raw data into comprehensive and meaningful reports.
To bring my docu-series to life, I need a creative, skilled freelancer/video editor who can incorporate artificial intelligence-based animation (to look like real video footage and images) when we dont have other available images to fill in. 1st show is a historical timeline of the 1935 Pacific Expo & creation of Intl Cottages in San Diego CA. Remainder of series is about diverse cultures of the intl houses - their art, music, food, traditions to include one cultural cottage. Each episode is approx. 26 minutes. I'll supply b-roll and interview in MP4 format. I can add VO at end but open to suggestions to make this engaging. Your tasks will include: 1. Watching and understanding the content of this first episode. 2. Creating and applying lifelike AI animation to enhance th...
I'm seeking an expert in financial forecasting to help construct a comprehensive model for a multi-vendor eCommerce marketplace. This platform wil...5-year forecast period The perfect candidate will understand the nuances of an eCommerce business and be able to leverage that understanding to present an accurate and comprehensive financial model. Experience in forecasting for global markets is a plus. Accurate data will be the heart of this model and the forecast should encompass all necessary elements to ensure its precision. I have one excel based financial forecast made by a firm for a while ago with a set budget. And i want to change the budget to a higher one. Plus this budget are only based on the indian market and not broader to include China, EU for vendors and global...
We are seeking a skilled Electrical Engineer with expertise in PCB design using Altium Designer to execute the panelization of 7 distinct PCB designs. The successful candidate will be r...designs. The successful candidate will be responsible for preparing and optimizing each design for manufacturing (DFM) and ensuring efficient utilization of PCB space during panelization to minimize costs and enhance production efficiency. Deliverables: -Panelized PCB design in Altium Designer format (.PcbDoc). -Gerber files for the panelized design. -Bill of Materials (BOM) for the design in Excel or CSV format. -Pick and place files (.CSV) for automated assembly. Requirements: -Proficiency in Altium Designer for PCB layout and panelization. -Experience with DFM principles and PCB manufacturing ...
Type the Text from the images to Excel as per the sample provided.
I'm looking for a resourceful freelancer who has proficiency in Microsoft Excel. The task at hand is to develop a method that can effectively compare two Excel files. The detailed requirements are as follows: - You need to focus primarily on the 'Cell Values' while comparing. Other aspects such as cell formatting or column structure are not part of the scope. - If differences are found during the comparison, they need to be highlighted. - As for the highlighting, all differences should be marked in one uniform color. This comparison should be accurate and easy to comprehend. It's an ideal opportunity for someone with a good eye for detail and strong Excel skills. Previous experience in similar tasks would definitely add value.
I need someone proficient in WordPress and WooCommerce to help me upload 3 CSV files, each containing 50,000 products, to my eCommerce site within a 24-hour timeframe. The CSV files, formatted in Excel, consist of product details including the product name, descriptions, and images. Note that there are no size or color variations in the products. This project requires: - Expertise in WordPress and WooCommerce product upload. - Familiarity with Excel CSV formats. - Fast and efficient working capacity to meet the 24-hour deadline. - Accuracy in uploading product details as provided. - Familiarity with image uploading and placement in product descriptions. The lowest bid will be favored, however, adherence to the requirements and timeframe is paramount.
I am seeking a professional with ...analyze data from a series of surveys. This analysis will be extracted from an Excel file. The successful freelancer will have the following: - Strong SPSS knowledge and experience - Proficiency in creating and interpreting statistics - Proficient in Excel data handling - Prior experience with survey data interpretation - Clear communication and report writing skills Your duties will involve: - Translating the Excel data to SPSS - Conducting a statistical analysis on the survey data - Presenting the data in a clear and concise manner, suitable for presentation to non-technical stakeholders - Communicating findings and potential implications clearly Applicants with example or a portfolio of prior similar SPSS and Excel p...
Looking for a proficient data entry specialist with excellent attention to detail. The role will consist of entering strictly numeric data into an Excel spreadsheet according to a specified format and template. Key Duties - Precise entry of numeric data data - Adherence to a specific format and template provided - Ensuring data quality is maintained Key Skills & Experience - Proficiency in Excel - Strong accuracy and detail-orientation - Prior experience in numeric data entry is preferred - Organized and able to work within strict timelines.
I am in need of a freelancer with basic knowledge in Excel for a data entry job. The data to be entered is mixed; consisting of both text and numbers. This project is ideal for those starting up in data entry or seeking to further enhance their skills in Excel. The successful freelancer should be detail-oriented, organized and committed to meet deadlines. A basic understanding of Excel is a must.
Hello, I am looking for a freelancer to help me with data entry. Specifically, I need help with spreadsheet formatting. I am open to any suggestions for templates or formats. The dataset is quite small, with less than 100 entries. Ideal Skills and Experience: - Proficient in Excel or Google Sheets - Experience with formatting and organizing data in spreadsheets - Attention to detail and accuracy in data entry
Looking for skilled Odoo developers to help build an effective Inventory Management system. Key system features needed: - Stock Level Tracking: The main function required is the ability to track the stock level consistently. Ideal Skills and Experience: - Proven ability in Odoo development. - Knowledge and application in Inventory Management. - Experience in setting up stock level tracking in past projects. Please note, clarity on the scale of stock monitoring is pending. Further details will be provided during the selection process. Freelancers who can adapt and adjust to changing requirements are preferred.
As a business owner, I am handling numerous files with more than 20 sheets each. To streamline my tasks, I require a professional freelancer adept at Excel data entry and formulas/functions. Key Requirements: - Efficient data entry on a multitude of Excel spreadsheets - Proficiency in applying Excel formulas and functions such as VLOOKUP/HLOOKUP, IF, AND, OR functions, and more. - Familiarity with handling Pivot tables and charts, able to use these for data analysis - Ability to work with large data sets and ensure correct input. The best suit for this job would be someone with excellent attention to detail, sound knowledge of Excel features to navigate extensive files, and proven experience in handling sizable data sets.
