What is vba in excel jobs
I'm in need of a comprehensive Excel workbook that can assist in managing and scheduling both staff and volunteers. The workbook should be capable of: - Scheduling staff and tracking days off - Computing hours and calculating salaries Additionally, the workbook should enable viewing the schedule in Gantt charts. Ideal candidates for this project should have a strong background in Excel, particularly in creating complex workbooks with various functions. Experience in HR or volunteer management is a plus. Please note, I will be providing the data necessary for hours computation and salary calculation.
Instructions for Data Scraping Task Your task is to extract specific information from job posting links. Below are the detailed requirements: Data Points to Scrape: 1. Company Information: - Company Name - Company Details: Brief about the industry or type of work they do. - Company Website - LinkedIn Page: URL to the company’s official LinkedIn page. 2. Email IDs (3 Required): - Find 3 individuals' email IDs from the following departments: - Admin - Human Resources - Head of Sales/Top Leadership (CXO level in Sales) - Marketing Head/Top Leadership (CXO level in Marketing) - Founders/CEOs/Co-founders/Owners 3. Email Requirement: - The email IDs must be professional (e.g., `name at `). - Avoid generic emails...
I need a freelancer who can assist me with data extraction from PDF files. The task involves: - Extracting text content from PDF files. - Accurately entering the extracted data into an Excel file. Ideal skills and experience for the job: - Proficiency in data entry with high attention to detail. - Prior experience with PDF data extraction and Excel. - Ability to maintain confidentiality and handle sensitive information with discretion.
Project Overview: IS-Website Frontend Development Goal: Create a modern, professional, and user-friendly website to showcase Idealistic Solutions' offerings. Backend: Existing API (92% complete). The freelancer will not develop any backend logic. Frontend Technologies: React: JavaScript library for building the user interface. : React framework for server-side rendering, routing, and performance optimization. GitHub: For version control, collaboration, and deployment. CSS Framework/Library: (Suggest: Tailwind CSS or Material UI) - To be discussed with the freelancer for consistency and speed. API Interaction: The freelancer will be responsible for integrating with the provided API to fetch and display data. Testing: The freelancer will implement unit and integration tests to ...
I'm looking for a skilled data analyst and Python programmer to create a code in Jupyter Notebook for analyzing data from Excel files. The project involves: - Primarily focusing on data analysis - Utilizing Pandas and NumPy libraries Ideal candidates should have: - Extensive experience with data analysis and Python programming - Proficiency in using Pandas and NumPy - Ability to work with Excel files - Familiarity with Jupyter Notebook Please include in your bid examples of similar projects you've completed. You are required to write the necessary program and create an effective presentation describing: The military spending of at least the top 10 nations (in military spending) Compare the data to that country’s GDP, Compare ...
I'm in need of an Excel expert who can help automate some of my book-keeping tasks. The main focus will be on reconciling accounts. Your responsibilities: - Utilise experience with excel formulas and macros to refresh existing reconciliation process for the book-keeping and management reporting of a small UK charity. - Ensuring accuracy and efficiency in the automation. Ideal skills and experience: - Proficiency in Excel, particularly in using formulas and creating macros. - Background in book-keeping and accounting. - Experience in automating tasks in Excel.
I'm looking for an Excel expert who can create a dynamic data visualization tab for analyzing financial data specifically for ROI metrics. The main focus will be on cost savings and investment returns. Key Requirements: - Use of Charts and Graphs: I need clear and engaging visual representations of the data. - Pivot Tables: Help in summarizing the data and making the analysis more manageable. - Conditional Formatting: To highlight key trends and important information in the data. Ideal Skills: - Advanced Excel: Proficiency in using Excel's more complex features. - Financial Analysis: Understanding of financial data and metrics. - Data Visualization: Ability to present data in a clear and engaging way. Please only bid if you can delive...
...construction crews into Excel for weekly costing purposes. - Data: Approximately 80 sheets per day, each covering 5–20 personnel - Delivery: I will send these sheets in a couple of batches on Friday / Monday. I need the completed task back first thing Tuesday. - Duration: This will be a weekly task for the next three months. - Resources: I can provide the employee names in Excel format, which will help improve data validation and accuracy. Skills and experience: - Proficiency in any spreadsheet software (Microsoft Excel, Google Sheets, etc.) - Experience in data entry - Attention to detail - Good communication skills Communication: My preferred method is email. I need someone who is reliable and can communicate ef...
I am looking for someone to copy and paste ALL the titles from my website into an Excel sheet You must copy and paste everything, EVERYTHING, EEEEEVERYTHING I will check only once and, if I find anything missing, the job will be rejected I have three websites. the budget is CAD$30
I have a corrupted Excel file that I'm unable to recover myself. The file contains complex formulas, and I'm unsure how it was corrupted - it could have been from a software crash, a virus attack, or an unexpected shutdown. - Any experience with data recovery from Excel files would be a plus
I'm in need of a professional who can create a product sales invoice in Excel for my business. The ideal freelancer for this project should have extensive experience with Excel and be able to incorporate specific features into the invoice. Key features include: - Automatic tax calculation - Discount options - Customizable logo and branding Each invoice needs to detail each product with: - Product description - Quantity and unit price - Product code or SKU It's crucial that the freelancer understands how to design an invoice that is both functional and visually appealing, reflecting my brand identity.
I have a 30-page PDF spreadsheet that is currently a scanned image. I need this data transcribed into Excel. The data is consistent across the pages, but primarily consists of text and some numbers. Key requirements: - PDF is a scanned image - Data is text-based - Needs to be converted into Excel Ideal skills: - Proficient in data entry and transcription - Familiar with Excel - Attention to detail to ensure accurate data transfer
I need an Excel spreadsheet to monitor the billed hours of each of our automotive technicians, as well as their total team hours each day. This tracking should be in relation to the daily goals we've set for them. This website gives some example of what I'm after Key Features: - A bar chart graphic display to visualize the data (along with actual numbers) - Tracking for individual technician hours and combined team hours - Comparison of hours worked against daily goals for individual as well as team -The graphic should represent how close to the set goal they are. Below 80% is red, 80-99.9% is yellow and 100% and up is green. Our automotive technicians are paid a bonus based their actual billed hours vs their target goal for billed ...
I'm looking for a comprehensive three sta...statement model to assist with investment analysis on the company ASML. This model should encompass the following financial statements: - Income Statement - Balance Sheet - Cash Flow Statement In addition to the standard financial statements, the model should also include: - Discounted Cash Flow (DCF) analysis - Comparable company analysis (Comps) - Sensitivity analysis Ideal candidates should have extensive experience in financial modeling and investment analysis. Proficiency in using Excel for complex calculations is crucial, as is a solid understanding of DCF and Comps methodologies. A background in finance or a related field would be beneficial. Your expertise will help guide investmen...
I need a skilled Excel professional to update my spreadsheet. The updates involve enhancing the existing formulas and functions, as well as improving the design and formatting. The base document just needs minor updates and needs to extend monthly from 2025-2035 Key Requirements: - Expertise with Excel functions and formulas - Strong skills in design and formatting Please note, the specific functions and formulas that need to be implemented have not yet been determined. However, you should be comfortable using lookup functions (like VLOOKUP, HLOOKUP), statistical functions (like AVERAGE, MEDIAN), and logical functions (like IF, AND, OR). Your ability to understand and manipulate data will be crucial to the success of this project. Ideal Skills: - Advanced Excel...
I'm in need of an Excel specialist. The main task involves creating an advanced Excel formula to assist with financial calculations, specifically focusing on data lookup. Key Tasks: - Design and implement an advanced Excel formula to perform financial calculations - Focus on data lookup aspects - Potential use of VLOOKUP, INDEX and MATCH, XLOOKUP or other relevant functions Ideal Skills: - Strong proficiency in Excel, especially with advanced formulas - Experience with financial calculations - Ability to translate complex data into understandable results - Familiarity with data lookup functions If you can help me navigate this task, please make a bid.
I'm seeking an Excel expert to assist with my financial data. The primary task will be to combine data and formulas to generate comprehensive reports. Ideal Skills and Experience: - Advanced Excel skills with extensive experience in handling financial data - Proficient in combining various types of formulas - Strong report generation skills - Previous experience with financial data analysis highly preferred.
I'm in need of an Excel course aimed at beginners. Key Course Topics: - Basic formulas and functions: Teach how to use simple formulas and functions in Excel. - Data entry and formatting: Focus on how to input data and format it correctly. - Charts and graphs: Introduce the basics of creating and interpreting charts and graphs. - Pivot Tables Content Delivery: The course should be delivered through engaging video tutorials. Ideal Skills: The freelancer should have a strong proficiency in Excel, experience in course development, and skills in video production. Experience in teaching or creating educational content is a plus.
...search for prices and provide URLs in an Excel sheet. - Call companies for pricing and stock availability. Only consider companies that can deliver directly from stock. - Delivery must be to Mumbai. Products: - Birch wood: 12 mm thick, water resistant limed, in two sizes (2.40x1.20 meter - 30 pieces and 3.00x1.50 meter - 30 pieces). - Wooden beams: 4cm x 14cm and 6 meters long (most economical option) - 100 pieces. Requirements: - At least 3 accurate prices from different companies for both products. - Task needs to be completed by 19:30 India time on Friday 10 January. Ideal Skills and Experience: - Proficient in English and Hindi. - Excellent communication and negotiation skills. - Experience in sourcing and purchasing. - Familiarity with local wo...
...simply at home OR with simple chemical equipment for blends that can be applied on the scalp tropically with a derma roller to help absorption. The purpose is to add natural ingredients that effectively and scientifically block DHT with established safety profiles. this product is intended hair growth and reduce hair loss triggered by androgenic alopecia. i need you to tell me where to buy the ingredients and how to mix them and the specific ratios I need you to also mention if this formulation can be saftely mixed with minoxidil or not I need two formulation: 1- is water soluble and non greasing, doesn't weigh down the hair and is derma roller safe 2- the other formulation cab be oil based and it needs to be safe for derma roller as well it mu...
I have an Excel billing sheet and need a new Excel document that connects with it. The purpose of this document is to pull a few fields from the billing sheet and present them in a form layout. Key requirements: - The new Excel should pull the following fields from the billing sheet: - Invoice Number - Client Name - Total Amount Due - Date of Service - Service Code Ideal skills for the job include: - Proficient in Excel - Experience with designing forms in Excel - Knowledge of linking data between Excel sheets.
As discussed basically want it to look like an excel sheet, all the scanner names lined up at the top and have the stocks come down under each. and scanner in this order Multi Scanner, Breakout High, Daily High, Volume Inc. , % to change gainer, Intra Day Rise, Hug 9 EMA, HODspike, 2minSpike2. Have scanners update every 2-3 min.
I'm seeking a data analyst skilled in TTR (Turnaround Time) evaluation, specifically focusing on trends over time. Key Requirements: - Analyze historical TTR data to identify trends over time. - Utilize provided Excel/CSV files for the analysis. - Present findings in a clear and understandable manner. Ideal Skills: - Proficient in data analysis and statistics. - Experience with TTR analysis. - Able to work with Excel/CSV data files.
I need a data analyst to evaluate an Excel spreadsheet containing project data. The analysis should cover run rates, forecast dates, and schedule adherence on a weekly basis. Ideal Skills: - Proficient in Excel - Experienced in data analysis - Able to interpret project metrics No set rules for this analysis; it is simply a test to assess your ability to perform basic data analysis.
I'm Mandeep Kaur, a 25-year-old seeking help with data entry tasks. You will be primarily tasked with: - Excel data entry - Assisting with filling out application forms Skills & Experience: - Proficient in Excel - Detail-oriented and able to accurately fill out forms - Previous experience with data entry preferred Looking forward to your bids!
CREATE DATA BASE AND PROJECT WITH POWER BI ANALYSIS PROJECT WILL BE 1 DASHBOARD + 1 VBA CODE TO COLLECT DATA + ANALYSIS REPORT
...Track domain renewal dates - Add and remove domains in bulk - Move domains between different portfolios - Name portfolios (e.g., Generics, traffic, jamesdomains, etc.) - Import domain name revenue for cost comparison - Add domain name costs per extension (e.g., .com, .net, .xyz, etc.) to monitor yearly costs of each portfolio - Export files per portfolio, as well as a global export - Backup daily and send via email The script should use a simple Username & Password authentication method. The ideal freelancer for this project should have prior experience in domain management and web script development. Knowledge of domain valuation and renewal processes is a plus. The script should allow for import/export in CSV and Excel formats. ...
Description: We need a creative, high-quality logo for Vocabble, a vocabulary-building board game for kids (same as Scrabble game - image atta...Requirements: Game Name: The logo must prominently feature Vocabble. Slogan: Include a slogan like below: "Play, Learn, Master English" "Building Brighter Minds!" "Unlock the Power of Words!" "Play, Learn, Excel!" ..... or you can suggest one. Design Style: Clean, modern, and colorful, appealing to families. Avoid overly complex elements. Format: Deliver in vector format (illustrator/corel draw format )and high-resolution PNG/JPEG for print and digital use. Need source file with all the fonts and elements. If you have any questions, pls dm me. Thanks. We’re looking for a logo that...
I'm in need of a seasoned full stack developer specialized in Laravel and Vue for creating a custom web application with a primary focus on data analytics and reporting. Key Responsibilities: - Develop a robust custom web application - Implement user management features - Integrate data analytics and reporting functionalities - Ensure seamless integration with various data sources Ideal Skills: - Proficiency in Laravel and Vue - Extensive experience in REST API development - Strong background in data analytics and reporting - Skilled in working with databases (e.g., MySQL, MongoDB) and APIs (e.g., REST, GraphQL) The project will involve integrating with multiple data sources, including databases and APIs. Experience with external data sour...
...transform multiple Excel sheets into an interactive Power Apps platform for various users. The project also includes the creation of a comprehensive dashboard. Key Requirements: - Transforming Excel sheets into a user-friendly Power Apps - Developing a dashboard tracking performance metrics, operational statistics, and assisting with actions and decisions Dashboard Visualizations: - Bar charts and line graphs - Pie charts and donut charts - Tables and matrices - Conditional formatted tables Additional Considerations: - Power App must support multiple clients in an Active Directory format Ideal Skills and Experience: - Proficiency in Power BI and Power Apps - Experience in creating interactive dashboards - Knowledge of Active Directory configuratio...
I'm in need of a Python script that can extract numerical data from an Excel/CSV file. The ideal freelancer for this project should: - Have extensive experience with Python, particularly in data extraction. - Be proficient with handling Excel and CSV files. - Be able to write clean, efficient code. Please note, the data will be purely numerical. The script will need to be able to handle large datasets with ease.
Build quote template as below - 1. Polish quote template 2. Macro to create new tab 3. Macro to add new slot in existing quote 4. PDF generation with Inclusion and Exclusion List 5. Push quote info to CRM (if API exists)
I need to create 1 or 2 shortcut keys with macros in Excel for automating the formatting and reporting of my data. Ideal skills for this job: - Proficiency in Excel - Experience in creating and implementing macros - Ability to automate tasks efficiently
Hi, we need the attached PDF document to be translated from Italian to German, destination: Switzerland. We don't have the OCR for this, but I send you both the Word editable document of the first part, and the Excel that contains the following part (table). Please, use the Word and the Excel documents to create one only final document, like the PDF. I kindly ask you to add [unleserliche Unterschrift] wherever a signature appears. We don't have any specific deadline for that.
I'm in need of a detail-oriented, experienced professional to assist with various bookkeeping tasks. Key Responsibilities: - Recording transactions: Timely and accurately inputting all financial data - Reconciling accounts: Ensuring all accounts are balanced and discrepancies are addressed - Generating financial reports: Preparing clear and concise financial statements - Budgeting: Assisting in the preparation of budgets - Auditing: Conducting internal audits to ensure financial accuracy - Forecasting: Providing financial forecasts to aid in strategic planning - Invoicing: Preparing and sending out invoices - Project bookkeeping: Keeping track of finances for specific projects - Must know QuickBooks, NetSuite and Excel Ideal Candidates Should Have: - Ext...
...Audience: 5,000 recipients. Data provided in Excel format (includes recipient email addresses and other necessary details). Email Content: Email 1: Includes a dynamic, clickable banner and text for sports bettors. (both provided by me. Naturally I want your input). Email 2: Sent three days after the first email, includes new text aimed at casino and slots players (provided by me). Sending Details: Emails should be sent from a professional-looking sender name such as: "Mike Spencer – Your V.I.P. Host". The sender email address must be configured to forward any replies directly to my email. Testing and Approval: A test email must be sent to my email for review and approval before the mass email is sent. Delivery Requirements: Emails must be delivered ...
I need an existing Excel spreadsheet, which tracks employee data, to be transformed into a secure, user-friendly system. Key Requirements: - The system should provide view-only access to certain users, while others can edit designated sections. - It should automate calculations and formulas, as well as validate data entries to ensure accuracy. Ideal Skills: - Proficient in Excel with experience in spreadsheet security and access control. - Capable of creating automated systems within Excel. - Previous experience with HR-related spreadsheets is a plus.
In my company the arrival of the inventory to the warehouse is recorded manually in the attached excel file, in the tab "ARRIVO PRODOTTI". Each product is assigned a specific row. For each row the following columns are filled in: ARTICOLO (item code) DESCRIZIONE (item description) DATA PREVISTA (estimated availability date) I° REVISIONE DATA (first revised availability date) II° REVISIONE DATA (second revised availability date) III° REVISIONE DATA (third revised availability date) QTY (quantity) STATO (status) I would need a button for each row, next to the column STATO. The button, powered by a macro, when pushed should trigger an email to be sent to a list of internal recipients, with subject and text filled ...
...electricity and water bill data (PDF format) into a specific Excel structure. We will provide sample bills AND a detailed mockup of the desired final output format. This ensures your solution directly addresses our exact needs. Data Points (extracted from PDFs): Company Name Flat/Shop Number Account Number Disconnection Notices (flag/status) Electricity, Water Consumption Municipality Period Start Date, End Date Previous Balance, Total Amount Due Key Requirements & Deliverables: Automated Extraction & Formatting: Develop a Power Query workflow to: Pull data points reliably from PDFs according to the provided format guide . Structure the extracted data into Excel sheets exactly matching o...
I'm looking for a WordPress professional to assist with the installation and configuration of SEO and OTP plugins on my site. 1. I want to add data by one person or by team or upload contacts in bulk, I want to have the facility to get contacts approval? When a new listing is added in my website a. From link posting advertisement- , the advertiser should get whats app or mail or SMS for confirming or declining the advertisement. or b. Upload bulk listings available in excel file containing listings data from admin panel using plugin wpallimport plugin, all numbers should get whats app or mail or SMS for confirming or declining the advertisement. 2. Need to disable the mail id as mandatory field and would like to have
I'm looking for an expert who can gather 5000 verified email IDs of researchers in the fields of agri-business, food, and retail from global sources, particularly focusing on academic journals, google scholar, and university directories. The email list should be delivered in an Excel spreadsheet. Key Requirements: - Expertise in data collection and verification - Familiarity with academic journals and university directories - Proficiency in creating and delivering data in Excel Ideal Skills and Experience: - Previous experience in similar data collection projects - Strong attention to detail for email verification - Excellent understanding of agri-business and related fields
I'm in need of professional Excel templates tailored for the construction industry. These will be specifically for quotations and invoices. Key Requirements: - The templates must include: - Client details and project scope - A breakdown of material and labor costs - Payment terms and due dates - The templates should be visually appealing and aligned with our brand: - Incorporating our company logo and branding colors - Special layout and design elements Ideal Skills and Experience: - Proficient in Microsoft Excel with a strong understanding of template design - Previous experience in the construction industry is a plus - Graphic design skills to ensure a professional and appealing layout - Attention to detail to ensure all necessa...
Excel Spreadsheet & Invoice Creation Assistance Excel Spreadsheet & Invoice Creation Assistance
I need someone to convert my 28 page bank statement from PDF to Excel. - You will need to extract all details from the bank statement. - The data should be formatted into a standard table format on Excel. - No further data processing is required after extraction. Ideal candidates will have: - Experience in data entry and PDF to Excel conversion - Attention to detail to ensure all information is accurately captured. check sample
I need assistance with managing hospital paperwork and invoicing using Microsoft Excel. Requirements: - Managing patient records and billing/invoices in Excel - Utilizing an existing template for patient records - Following a specific format for billing and invoices Ideal Skills: - Proficient in Microsoft Excel - Detail-oriented with ability to follow specific formats and templates - Experience with hospital paperwork and invoicing preferred.
Want to recreate this spreadsheet to add another section, a sixth one called Operations Also want to add our company logo
...customer portal. It will have 30 pages with different functions and all pages should be responsive. Pages will include but won’t be limited to: Business portal/CRM - Registration. - Settings (with business info.) - Login. - Events (where businesses can see all there events) - Create an event. - Edit event. - Create a menu. - Event summary and food order. - Individual food order. - Exports to excel - Food orders(sorted by course and table). - seating management Customer portal - Register. - Login. - Register and create an event. - Login and create an event. - Customer profile page. - Future events. - Past events. - Event details - Info page. - Event details - Food orders. - Guest food order - single page. - Food menu. - Guest list. - Add an admin. - seating manage...
