Excel vba projects trabalhos

I require professional assistance with data entry. More specifically, the task involves typing information from digital documents, such as PDFs, Word files, and Excel spreadsheets, into an Excel spreadsheet. The ideal freelancer for this job is proficient in data entry and is highly skilled in using Excel.-Accuracy and attention to detail are key skills that would make this project a success.

I'm seeking a skilled personal assistant to support my dual role as an orthodontist and ent...business. Strong organizational skills to manage various tasks efficiently. Excellent communication abilities for handling correspondence and coordination with multiple stakeholders. Financial diligence with a keen eye for invoicing and payment processes. Technical aptitude with project management platforms and instant messaging for streamlined task management. Time Management: The assistant must excel at prioritizing and managing a diverse task load within tight deadlines. Adaptability: Ready to handle diverse tasks and adapt to new challenges as they arise in a dynamic work environment. Confidentiality: Must maintain the highest level of discretion with sensitive patient and busine...

I am seeking a competent web crawling specialist who can efficiently extract text content from a specific website's news updates. Here’s what I require: • Extract ...specialist who can efficiently extract text content from a specific website's news updates. Here’s what I require: • Extract information from news updates within the target website. • Save the extracted data in Excel format. • Deliver clean, organized, and structured data. Ideal skills and experience: • Expertise in web crawling and scraping tools. • Previous experience working with news or media websites. • Proficiency in data extraction and Excel. • Strong attention to details. I appreciate a freelancer who can show some examples of their p...

I'm in need of an Excel expert to Create Macros. I have two spreadsheets. On each spreadsheet i have an input form. When the form has been entered and the user clicks "Enter Asset" each of the filled out cells (as per the File - "Template Code Functions") should be transferred to the "Data Collection Spreadsheet". Just enter into the next unused row. When the asset has been added successfully the cells marked as "Yes" as per the "template code functions" for "Reset on data entry" shall be empty on the input form. There are two spreadsheets, they are slightly different from each other.

I need a professional to create an advanced Excel-based sales forecasting model. This model will integrate data on sales volume, revenue, and customer demographics, across various time periods - monthly, quarterly, and yearly. Key requirements: - Incorporate Sales Volume, Revenue, and Customer Demographics - Develop the model for Monthly, Quarterly, and Yearly forecasting - Integrate and track Gross Profit Margin, Conversion Rate, and Average Order Value as key metrics Ideal Skills & Experience: - Advanced Excel Proficiency - Proven track record in Sales Forecasting - Experience with Power BI for data visualization - Strong understanding of Gross Profit Margin, Conversion Rate, and Average Order Value in a sales context This project is crucial to our business planning...

I need a comprehensive statistical analysis ...my survey data using descriptive statistics, and I'd like the results presented in visually engaging charts and graphs. Your main tool for this should be Microsoft Excel. Key Responsibilities: - Perform a detailed descriptive statistical analysis of my survey data. - Translate the findings into easy-to-understand charts and graphs. - Ensure all the visualizations are created using Microsoft Excel. Ideal Skills and Experience: - Proficiency in statistical analysis, particularly in descriptive statistics. - Strong experience in creating visual representations of data through charts and graphs. - Expertise in using Microsoft Excel for data visualization. - Ability to present complex statistical information in a clear a...

I need a skilled Excel expert to create a comprehensive spreadsheet and optimize its formulas and functions. The project needs to be completed within a month. Key Tasks: - **Spreadsheet Creation**: The successful freelancer will be responsible for creating a detailed spreadsheet that will serve as a part search tool. - **Formula and Function Optimization**: I need assistance in optimizing the formulas and functions within the spreadsheet. This is to ensure the tool is efficient, accurate and user-friendly. I would like to have a new parts search screen made up similar to the one attached ( Storeroom Parts Locator. ) but using the attached excel sheet (inventory Report) Nice UI on front page would be great! should be able to search for description and or part number. re...

About the Role: A renowned leader in digital security is actively seeking a skilled Golang Developer for a contract role focused on developing a Golang agent for SSL certificate management, which will interface with a PHP API. This opportunity is ideal for back-end development professionals who excel in automation, system operations, and delivering high-quality outcomes in a remote environment. Project Overview: As a Golang Developer, you will be instrumental in: - Developing a Golang agent to manage SSL certificate lifecycles, interfacing with a PHP API. - Implementing features such as system monitoring, logging, and robust error handling. - Performing thorough testing and optimizations to ensure system reliability and efficiency. - Collaborating with remote teams to ensure seaml...

Need an accounting and valuation expert with good excel skills.

I need an Android application that can process a provided Excel file and display the data in various ways. Key Features: - The app should be able to read the Excel file I provide. - It should show the numeric data per line and column as specified in the Excel. - It should also be able to perform statistical analysis on the data. - The app should provide graphical representation of the data. Users should be able to interact with the data within the application in a 'view only' mode. Ideal Skills: - Proficient in Android app development - Experience with Excel data processing - Ability to implement statistical analysis in an app - Familiarity with graphical representation in mobile apps - Excellent understanding of data visualization Please let me ...

I'm in need of someone who can create a simple JPEG in a 2:3 (portrait) including the attached info on hoeg not excel format. The design style should predominantly be green and favor a minimalist approach. THIS IS FOR THE WEBSITE Key Responsibilities: - Creating a JPEG media card design. - Utilizing a 2:3 (portrait) layout. - Integrating a predominantly green color scheme. - Implementing a minimalist style. Ideal Skills: - Proficient in graphic design. - Prior experience with media card layouts. - In-depth knowledge of color theory. - Advanced user of design software (Adobe Suite, etc.) - Understanding of minimalist design principles. Please include samples of prior work, especially with media card layouts. Looking forward to seeing your creations!

I am looking for a Tableau professional who can help me create a comprehensive and visually appealing dashboa...visually appealing dashboard. The primary users of this dashboard will be our business executives, so it is crucial that it is designed with their needs in mind. Ideal Skills and Experience: - Proven experience working with Tableau, ideally with a focus on dashboard creation. - Strong understanding of data visualization techniques and best practices. - Ability to connect and work with data from Excel spreadsheets. - Previous experience designing for business executives is a plus. The nature of the business is Sales, in South Africa. Test data is available. I would require you to create some dashboards that tell an enriching story. I would love to discuss more during ou...

I'm looking for a competent bidder who can secure new projects for my existing tech company. The primary goal of this project is to increase revenue through winning bids on Freelancer. The projects we are targeting are primarily within the Technology & Software sector. Key Requirements: - Proven track record in securing projects on Freelancer - Excellent communication skills to negotiate terms and foster client relationships - Demonstrable success in increasing revenue for businesses - Prior experience in securing projects within the Technology & Software industry is highly desired As the successful bidder, you will be a key part of our team and instrumental in driving our business growth. Looking forward to your bids.

I have an excel SS that I need some quick formula help with. No VBA please. Table with expenses, then another table dividing up. I need the expense categories divided over months as per quantaty of time it is used. Explained in the SS attached. I need this done ASAP. Your responsibilities: - Understand the project financials and structure the Excel to match - Create a Gantt style tallies that captures my project expenses effectively Skills and Experience: - Solid expertise in advanced Excel functions - Experience in financial tracking, preferably in project management - Ability to work fast and deliver quickly Note: I didn't specify the expense categories so it should be customizable to accommodate any kind of expense. However, quick delivery is of ut...

I'm looking for an individual proficient in data entry, email management, online research, and making phone calls. Your daily tasks will primarily involve: - Performing data entry tasks using Microsoft Excel - Managing email communications effectively and promptly - Conducting online research as required - Making certain phone calls when necessary -Schedule is 9am-3pm CST (Monday-Friday) In addition, experience with project management software 'Click Up' will be highly favored. A strong work ethic, attention to detail, and excellent communication skills are fundamental for this role. The selected candidate will be expected to perform these tasks on a daily basis. Your ability to meet deadlines and work independently will contribute significantly to the smooth operat...

...symbolic, embodying the spirit of the deck rather than focusing on our brand name or a product-related visual. The ideal candidate for this role should have strong experience in graphic design, particularly in modern design and abstract logo creation. They should be innovative, with the ability to transform a classic item into something new and fashionable. If this sounds like a project you'd excel in, I'd love to hear from you. Please note that the design should consider Arabic and English...

I need a excel data sheet typist frequent in basic as well as skillful skills. There's no error in the formats and also professionally done with great effort.

Hey! I have experties on statistical analysis.

We are looking for a freelancer to scrape product information from Website and organize it in an Excel spreadsheet. Key Requirements: - The script should extract all text content and images displayed on the homepage need be add to excel file

...constantly updated depending on the configuration. 6. After completing the configuration, no order should be created in the system, but an offer should be created automatically as an Excel file, which is not sent to the customer, but to the office sales department, which checks the offer and can see which parts have been added, so that prices are added and finally sent to the customer. A second Excel file must also be created for production so that they know which parts are required for construction. 7. Synchronise article and customer master data between Majesty and Odoo. Majesty can only export the data using an Excel file and has no API. 8. Design customisation so that configurations that have already been made are collapsed, so that the page remains clearer due ...

IA-calculated Excel Sheet Want to design an auto-calculated editable quotation, Purchase order, Invoice, and company letterhead in Excel and log-register quotation price and list in excel details as below All the Reports , Log, Purchase Order Quotation has to be Printed in PDF Sample Attached Customization is required as per our requirement The Provided Sample Sheets all Need to Be Combined in One Sheet Excel ERP Template Sales Pipeline Excel Template Excel Quotation Generator with Database Commercial Invoice Generator Excel Template Contractor Invoice Excel Template Vender List, Client List , Purchase order , Quotation & Invoice Log Excel Purchase Order Generator and Tracker Employee Attendance Tracker and Payroll Exce...

I'm looking for a freelancer to create an Excel dashboard that will be linked to a Microsoft PowerApp. The dashboard will be used for monitoring various data points. Key Details: - The dashboard will need to be dynamic and allow for updates directly from a database. - The successful freelancer will need to demonstrate experience in creating similar solutions in the past and provide a detailed project proposal for this task. The ideal candidate will have: - Proficiency in Excel, particularly in the creation of dynamic dashboards. - Experience with database connectivity and management. - Previous work examples that showcase their ability to create effective and user-friendly solutions. - Strong communication skills and a proactive approach to project management. I'...

I have a medium-sized Excel dataset that needs to be cleaned and analyzed. The tasks include formatting cells, filtering, and sorting data. Moreover, I'm looking for a professional who can conduct statistical analysis on this dataset. Key tasks: - Formatting cells: This involves making sure that the data is presented in a readable and visually appealing format. - Filtering and sorting: The freelancer should be able to organize the data in a way that makes it easy to understand and analyze. - Statistical analysis: The dataset needs to be analyzed statistically. This means that the freelancer should be proficient in statistical tools and techniques. Ideal candidate: - Proficient in Excel: The freelancer should have excellent skills in using Excel for data cleaning...

In need of a detailed-oriented freelancer for an alphanumeric data entry ...freelancer for an alphanumeric data entry project using information sourced through online research. Key Responsibilities: - Source relevant information using online research methodologies - Accurately input alphanumeric data into a system - Ensure the final data is properly structured and error-free The final data should be delivered in an Excel spreadsheet format. Ideal Skills: - Experience with online research tools - Proficient in Excel - Fast typing skills - High attention to detail - Previous experience in alphanumeric data entry roles. The success of the project will be measured by the accuracy of inputted data. Proven examples of prior work in a similar data entry position will be...

I am in need of a sharp and detail-oriented freelancer to assist me in a unique data entry task. Your primary responsibility will be to find pictures that correspond to specific words, and organize them in an Excel database. This project is crucial for the development of a comprehensive picture-based database. Key Responsibilities: - Search for images that match specific words - Organize the found images in an Excel database Ideal Skills and Experience: - Proficiency in using Excel for data entry - Strong attention to detail - Ability to efficiently find and match images - Prior experience working with picture databases would be a plus Please ensure that the images you find are high quality and in either JPG or SVG formats. Your work will be integral in the creation...

I'm looking for a PowerBI expert to set up a dashboard for our construction project. This dashboard should pull data from Excel spreadsheets and provide valuable insights into our construction progress. Key Requirements: - Integrating Excel Spreadsheets: The primary data source for this project will be Excel spreadsheets. Your ability to connect and visualize data from this source is vital. - Construction Progress Monitoring: The dashboard's main focus should be on monitoring our construction progress. This includes: - Project Timeline: Displaying where we stand in terms of project timeline against the planned schedule. - Budget Utilization: Visualizing how the budget is being utilized in real-time. - Resource Allocation: Demonstrating how resources a...

I'm looking for a professional freelancer to convert a 300-line PDF bank statement into an Excel report for reporting purposes. The specific bank statement details that need to be included are Date and Description as well as Debit and Credit amounts. Key Requirements: - Extract date and description details from the bank statement - Extract Debit and Credit amounts from the bank statement - Must have a clear understanding of date formatting in Excel Ideal Skills/Experience: - Must have extensive experience in data entry and Excel - Should have a good understanding of banking terms - Attention to detail is critical - Previous experience in bank statement conversion will be advantageous.

I am in need of an Excel Macro skilled professional, who can automate my manual work of generating operational data reports. My preferred output format for these reports is Excel spreadsheets. Key Responsibilities: - Design and create a macro in Excel for automatic report generation using operational data - Ensure the macro is accurate and efficient, cutting down the time spent on report creation Ideal Skills: - Excellent understanding of Excel Macros and VBA - Experience in creating automated report generation systems - Familiarity with handling operational data is preferable.

We are looking to collect the current prices for 5 specific procedures from local clinics. We need a call center to call 200 dental clinics from a list that we have already created to inquire about pricing. You will be calling as if you are an interested patient inquiring about getting the procedure. You will then fill out the 5 procedure costs on the excel sheet. We are hoping to hire a call center that speaks English with minimal accent. We have a general script. Each phone call should not last more than a few minutes. You need to have more multiple people on your team as we would like this project done very quickly. You also must be able to call from a US based phone number and have it show up on the caller ID. Start immediately. Pay is $250. Do not bid higher, as we will not...

I'm looking for someone proficient in Excel to assist with data entry and basic data analysis. Requirements: - The task involves entering numerical data into an Excel sheet. - The data is for both analysis and record-keeping, so accuracy is crucial. - I also need some basic Excel functions applied to the data, particularly summation and averages. Skills & Experience: - Proficient in Excel with experience in data entry - Knowledge of basic Excel functions (sums, averages) - Attention to detail for accurate record-keeping - Some experience with data analysis would be a plus Looking forward to your bids. Thank you.

I'm in need of a skilled professional who can adeptly handle both copywriting and Excel data analysis tasks. For this project, the copywriting will need to be informative in nature. Aim it towards industry professionals, with the intent of providing detailed information in an engaging, digestible format, not advertising or branding. Excel expertise should include, but not be limited to, proficient data analysis capabilities to make sense of complex datasets. Ideal skills for the job: - Proven experience in copywriting, specifically informative writing. - Strong knowledge of Excel, particularly in the field of data analysis. - Ability to communicate complex information in an understandable manner to industry professionals. - Excellent attention to detail. - Proact...

I'm seeking an individual proficient in Excel, with significant experience specifically in entering statistical data. The task revolves around efficiently and accurately typing numbers into an Excel sheet, which will then be processed for statistical analysis. Key Responsibilities: - Accurately input numerical data into Excel - Familiarity with statistical data is advantageous - Format inserted numbers as percentages Ideally, the individual will have stellar attention to detail, the ability to work under tight deadlines, and a strong grasp of handling statistical data. Prior experience in a similar role will definitely give you an edge.

I'm looking for a professional who can assist me with organizing financial data in an Excel sheet. This organized data will be used for reporting purposes. Key Responsibilities: - Inputting and arranging financial data - Ensuring accuracy and consistency of data - Creating a well-structured Excel sheet for reporting Ideal Skills and Experience: - Proficiency in Excel and data entry - Attention to detail and accuracy - Understanding of financial data - Experience with creating reports from data The successful freelancer will need to have a keen eye for detail, as the accuracy and correctness of the data is crucial for its utilization in our reporting.

I'm in need of an Excel database creation expert to help me establish a system to store and manage customer information. The project is time-sensitive, so I need someone who can get on it ASAP. Key Responsibilities: - Building an Excel database for customer information, possibly by using Chat GPT for data population - Ensuring the database is well-structured and easy to navigate for future reference - Implementing any necessary formulas or functions that can enhance the utility of the database - Ensuring the project is completed in a timely manner, as I need it done ASAP Ideal Skills: - Proficiency in Excel, with experience in database creation and management - Knowledge of using Chat GPT for data entry is a plus - Ability to structure data in a clear and organ...

I'm in need of an Excel database creation expert to help me establish a system to store and manage customer information. The project is time-sensitive, so I need someone who can get on it ASAP. Key Responsibilities: - Building an Excel database for customer information, possibly by using Chat GPT for data population - Ensuring the database is well-structured and easy to navigate for future reference - Implementing any necessary formulas or functions that can enhance the utility of the database - Ensuring the project is completed in a timely manner, as I need it done ASAP Ideal Skills: - Proficiency in Excel, with experience in database creation and management - Knowledge of using Chat GPT for data entry is a plus - Ability to structure data in a clear and organ...

I'm in need of a skilled professional who can adeptly handle both copywriting and Excel data analysis tasks. For this project, the copywriting will need to be informative in nature. Aim it towards industry professionals, with the intent of providing detailed information in an engaging, digestible format, not advertising or branding. Excel expertise should include, but not be limited to, proficient data analysis capabilities to make sense of complex datasets. Ideal skills for the job: - Proven experience in copywriting, specifically informative writing. - Strong knowledge of Excel, particularly in the field of data analysis. - Ability to communicate complex information in an understandable manner to industry professionals. - Excellent attention to detail. - Proact...

I am seeking a VBA expert with extensive experience in Excel for the creation of a custom macro. The specific task will involve designing a macro that can efficiently audit the financial records of a Trust. The audit should be conducted at a yearly level, ensuring accuracy and comprehensiveness in the review. Key tasks for the project include: - Building an automated audit tool: The macro should be capable of assessing financial records of the Trust with minimal manual intervention. - Ensuring high level of detail: The work is format based. Proper posting of the records should be done repeatedly year on year - Application in Excel: The macro should be fully functional in Excel, allowing for easy integration into the Trust's existing data management proces...

...three-pronged job involving: 1. Entering Contact Information: You will input a myriad of contact details into an Excel spreadsheet. Accuracy is paramount. 2. Updating Databases: You'll be responsible for ensuring that all existing data is up-to-date. If a discrepancy is noticed, you will correct it. 3. Transcribing Documents: Transcription services are required. You need to accurately transcribe information from diverse documents. In addition to the aforementioned tasks, this job involves email verification for all entries; without exception. Needless to say, your keen attention to detail would be required to spot and correct any errors. The ideal candidate would have past experience with Excel spreadsheets, database management, and transcription. Excellent typing ...

...analysis. Achieve monthly targets of 150 salons signed and 3,000 app downloads to qualify for performance bonuses. Provide real-time geolocation updates during field movements. Candidate Requirements: Minimum 2 years of experience in B2B sales, preferably within the beauty, wellness, or tech industries. Strong understanding of sales strategies and customer relationship management. Proficient in Excel and capable of managing basic sales data analysis. Exceptional communication and interpersonal skills. Ability to commit to BookBook's unique brand and sales approaches. Must be organized, self-motivated, and capable of working under pressure to meet sales targets. Compensation and Incentives: Monthly salary of £2,000 after taxes. Promising £4,000 compensation follow...

I'm seeking an expert to revise an annual financial model for a Saas Startup. The successful bidder will be tasked with modifying revenue projections, adjusting expense figures and adding new financial metrics. The final version of the model should be delivered as an Excel spreadsheet. This project requires deep knowledge of financial analysis, Excel forecasting tools and financial metrics. Familiarity with financial models and proven track record in creating or modifying them is essential.

...record includes creating and designing courses that resonate with diverse audiences, driving engagement and delivering tangible results. ⏰ **Timing Mastery**: You understand the importance of pacing and timing in course delivery. You'll orchestrate the flow of content to keep participants engaged and motivated every step of the way. ✍️ **Copywriting Skills**: Beyond just instructional design, you excel in crafting compelling copy that speaks to our target audience. Your words will inspire action and drive enrollment. ? **Quality Assurance**: Attention to detail is your middle name. You'll conduct thorough testing of the course materials to ensure seamless functionality and a superior learning experience. But that's not all! In addition to course creation, you&#...

Estoy buscando un asistente virtual y administrativo para realizar las siguientes actividades operativas en un negocio: Revisar y agregar datos en documentos de Excel. Elaborar reportes en Excel. Gestionar la agenda de proyectos. Revisar y agregar tareas de proyectos en el calendario. Redactar minutas y resúmenes de juntas. Establecer prioridades de actividades. Registrar datos generales como facturas, órdenes y proveedores en el sistema ERP. Crear manuales de procedimientos en Word. Herramientas de manejo: Excel a nivel avanzado. Loop o Notion. Conocimiento de los procesos de un ERP. OneDrive (administración y manejo de archivos). OneNote y Word.

I need a freelancer with a deep understanding of Excel ,data management and social media to extract info from profile list that we have . As the project involves organizing approximately 20,000 rows of data, proficiency in handling large datasets will get you far in this task. Key Project Details: - Data Type: The data primarily comprises email addresses and phone numbers. - Links in Profile - Other profiles in the profile - Formatting: The data files contain labels, so you'll need to distinguish this information keenly. Ideal Skills: - Proficient in Excel - Expertise in data management - Data Scraper

I need an expert with strong Excel skills to create two simple line graphs. Though I didn't provide specifics, these will be used to illustrate financial data, so experience in creating graphs for financial analysis would be ideal. Fast turnaround is critical. I will share 2 images of sample graphs. You need to put same data but have to create it line graph and in excel. I need this now. If you can't do now then please dont waste my time.

I require a professional who can develop a detailed sales forecasting report leveraging Power BI. The project needs to be done within one day. Key Requirements: - Utilize data from Excel spreadsheets for the forecasting. - The sales forecast should be detailed, breaking down sales by product/service. - The forecasting model should be based on regression analysis. Ideal Skills: - Proficiency in Power BI. - Strong experience in Excel data analysis. - Proven track record in regression analysis for sales forecasting. - Ability to work under tight deadlines.

I am in need of a Visual Basics code in Excel that specifically focuses on equipment check-in and check-out functionality, while also automatically creating a record for each transaction. Key Features: - Equipment Check-in and Check-out: The primary purpose of the program is to allow users to easily check equipment in and out. - Automatic Inventory Status Update: The program should update the inventory status automatically, ensuring that the availability of each item is always up to date. Additional Features: - Daily Reports: The program should generate daily check-in and check-out reports - this would be beneficial for managing equipment usage and tracking. - Statistics: The program should also provide statistics on equipment usage. This could help in determining patterns of usag...

Transferring data from a jpg file to an excel table. With online access via google

I'm looking for a Power BI expert to help me set up a robust sales forecasting system. Responsibilities: - Integrate my Excel spreadsheets into Power BI Desktop - Design visually appealing and intuitive dashboards that clearly display sales forecasts - Utilize Power BI's capabilities to predict sales trends Ideal Skills: - Proficiency in Power BI Desktop - Expertise in Excel spreadsheet integration - Proven track record in sales forecasting - Strong communication skills to understand my business and its sales forecasting needs This project requires someone who can not only set up the technical aspects but also has a deep understanding of sales forecasting.

Seeking a tech-savvy professional to establish an automated system leveraging ChatGPT and Make Automation. The aim is to: - Automatically extract specific information from a variety of documents including Word, PDF files, Excel Spreadsheets, and Scanned documents - Thoroughly analyze extracted content including text, tables, charts, and images for compliance and precision - Automatically generate comprehensive reports based on extracted information for easy reference For this task, proficiencies in AI, Machine Learning, ChatGPT, and automation are necessary. Likewise, experience in OCR technology for processing scanned documents will be valuable. Not only should the candidate be detail-oriented - they should also be adept at debugging and ensuring the system seamlessly integrates...

I have a set of less than 10 excel spreadsheets that I use for various purposes. I'm looking for a talented professional who can re-work these sheets eliminating redundancy. Key objectives: - The primary goal of this rework is to automate repetitive tasks. I'm looking for someone who can introduce VBA scripts and macros to help me achieve this. - The spreadsheets are both independent and share common data. It will be important to create a system that can handle both types of sheets. Ideal skills: - Proficiency in Excel, VBA, and Macro programming is a must - Experience with data manipulation and automation - Ability to understand and work with a mix of independent and shared data I'm open to discussing the project requirements in more detail. ...