Excel vba forKazi

...that utilize Excel and Microsoft Access. Here's what I'm grappling with: - Database design, query writing, and forms and reports design. - Comprehending lab instructions. - Applying theoretical knowledge in practical tests. - Interpreting results accurately. Although I possess intermediate knowledge about Microsoft Excel and Access, these topics are giving me a hard time. The ideal person for this role would be someone who can expertly guide me to enhance my understanding and application of these areas. You would need strong, practical experience in Excel and Microsoft Access, including proficiency in database, forms and reports design, as well as writing queries. Your teaching skills should include the ability to simplify complex concepts, and al...

【 overview 】 This time, we would like to ask you to develop a tool that automatically searches for landline phone numbers on Google and checks business hours. [Request details] ・Development details: Please develop a business hours search automation tool system on Google. - Desired function: System image ①Import an Excel file or CSV file containing only phone numbers to the system ② The system automatically searches Google and searches for the information you want, such as business hours search * Desired information → "Business hours", "Closed days", "Reviews" *There are some patterns that Google doesn't have, so I'd like you to add a flag for those cases as well. ③ After the search is complete, the information will b...

...Website Design - Graphic Design - UX / UI Design - SEO optimized content Pertinent Features: - My website will house detailed resource guides, so proficiency in organizing and categorizing large volumes of information is essential. - A clean, user-friendly navigation menu to direct users to the relevant guides. - It should be mobile and desktop friendly. This is a great opportunity for designers who excel in developing educational or resource-based platforms....

In my financial business project, I'm looking for a professional to help me schedule 10 to 15 online meetings per week with investors. Key responsibilities include: - Make a list of investor names/emails in Excel; - Collect emails that are actually valid; - Contact investors to collect email addresses. This would be a great opportunity, especially for those who do not have any skills developed to their full potential. If I close a deal with a client who comes to you, you will receive a commission (ranging from US$90, US$180, US$270 or US$360). Are you ready to join my financial journey? Your efforts can lead to fruitful rewards!

Estudiante avanzado o recibido Para realizar las tareas será indispensable contar con: Excel avanzado Disponibilidad horaria para conectarse Conocimientos en plan de cuentas, de gastos, uso se software contable, etc.) Algunas tareas: Tareas fiscales para DGI Contabilidad interna Pasado de comprobantes de compras y gastos Análisis financieros

I need to create an automatic functions to split the data in Excel. Can be created in Excel Macros or VBA

Looking for someone well-versed in Excel for efficient and accurate data entry of quantitative data. Skilled data entry specialists who can handle basic computations will be preferred. Knowledge in Excel formulas or functions might be necessary, but I'm not entirely certain at the moment. - Proficient in Excel - Demonstrable experience in data entry - Ability to perform computations - Knowledge of Excel formulas/functions a plus

Job Offer: Experienced React Developer for Web3 App Development About Us: Uncharted Fox is a private hedge fund specializing in managing investors' funds. Our core team comprises expert traders, and we're embarking on launching a new app. This app aims to streamline portfolio management for investors while prioritizing ease of use and security. Our primary business involves leveraging investors' liquidity, trading on their behalf, and delivering specific ROI with planned fees. Project Overview: We are seeking an experienced React developer to spearhead the development of a Web3 App. The project will leverage existing open-source solutions to expedite development, reduce costs, and ensure efficient execution. Key Features of the Web App: - User account manage...

Auditor Appointment & Filin...Preparation & Filing of Extract of Annual Returns & Financial Statements (0-100 transactions) if provided in Excel sheet. Preparation & Filing of Annual Returns Form AOC 04 (Financials Related Annual Return). Preparation & Filing of Annual Returns Form MGT 07 (Management Related Annual Return). Preparation & Filing of Minutes of 04 Board Meeting & Minutes of AGM. Preparation & Filing of Income Tax Returns (Company). FY 24-25 Preparation of Share Certificates (For All Shareholders). Preparation & Filing of 07 Mandatory Registers. Preparation & Filing of MPB-01 (Disclosure of Interest by Directors). Preparation & Filing of DIR - 08 (Disclosure of Non-Disqualification by Directors). KYC Dir- 3 for A...

I need a skilled professional to update my website's stock prices in real-time using excel. The project primarily involves: - Updating numerical data on my website - Ensuring accuracy and real-time updates - Using excel as the data source Ideal candidates will have: - Experience in data updating on websites - Proficiency in excel and data management - A good understanding of stock prices and real-time data management The goal of this project is to enhance the user experience on my website by providing accurate and real-time stock prices.

I need a fluent Arabic speaker who is proficient in Power BI to help convert an existing Excel file into a dashboard for performance tracking purposes. - KEY RESPONSIBILITIES: The practitioner will be proficient enough in Power BI to translate raw data into accessible and meaningful dashboard visualizations. Highlighting and tracking key performance indicators for strategic planning follow-up is a must for this role. - REQUIRED SKILLS: Understanding of Microsoft Power BI, an eye for design to ensure the visualization is as seamless as possible, and fluency in Arabic. Experience with Excel to Power BI conversions and strategic planning will be considered favorably. - IDEAL CANDIDATE: The freelancer should have a strong background in data analy...

We need to create an Excel Spreadsheet to track Cash income and expenses. We will begin with a specified amount of cash. First priority is to be able to know at any given time how much cash should be in the petty cash account. Would like to have a space for a weekly balance in order to identify losses or un recorded income/expense in a timely manner. At the end of each week, the keeper of the account will enter the actual amount of cash on hand. This should be subtracted from the recorded expenses and income and a + or - sum generated. (This allows us to catch and correct possible typo's and/or unrecorded income/expense in a timely manner) We want it to generate monthly totals to include Total Cash income Total Cash expenses. The cash expenses should be sub...

I'm in need of a freelance bookkeeper fluent in German for approximately 20 hours per week. Key responsibilities will include document research and debtor/creditor management. - Software Proficiency: You should have experience in Excel and a solid grasp of basic accounting principles. - Responsibilities: Duties will involve expense tracking, invoicing, and bank reconciliations. A keen, meticulous eye for detail is a requisite as well as outstanding organizational skills. A flexible, freelancer approach is ideal for this project. This role will suit someone who enjoys piecing together information and has excellent problem-solving abilities. Experience in a similar role would be a great advantage.

I am looking for an experienced Photoshop specialist to accomplish a small task that will take less than two minutes. Your main task will be to modify the content of the text within an image. The modification will involve replacing the existing text with a specific phrase provided upon project initiation. To excel in this job, you need to have a keen eye for detail to ensure precision in text modification and a good command of Photoshop. Fast turn-around would be much appreciated.

I'm seeking a skilled freelancer experienced in data entry and Excel to enter and transform a medium-sized set of customer records and product details. Key Responsibilities: - Accurately enter data, including customer records and product details into Excel templates - Transform raw data into more useful formats and ensure data integrity - Double-check entries for accuracy and fix any discrepancies Skills and Experience: - Expertise in data entry and Excel - Proficiency in transforming and structuring data - Previous experience handling equivalent tasks related to customer records and product details. Your expertise and attention to detail will be critical to ensure the accuracy and usefulness of the resulting data.

Looking for a meticulous and efficient professional to perform data entry into Excel. The type of data is not specific at this point and could include text, numbers, dates, or a combination. You must have good typing speed, strong attention to detail, and basic knowledge in Excel. Ideal Skills & Experience: 1. Expertise in Microsoft Excel 2. Strong attention to detail 3. High accuracy in typing 4. Experience in data entry Although not necessary, to improve your chances of being considered, you can include in your application: 1. Any examples of similar work you have done before. 2. Demonstrate your level of experience. 3. Provide a detailed project proposal. Currently, it's unclear how many sheets are there in the Excel file. Regardless, you ...

...from a proficient Excel user who can create two essential templates for me: An invoice template and an expense tracker. For the invoice template, I require the following fields and calculations to be included: - Item description and quantity - Unit price and subtotal - Tax calculations - Grand total I'd appreciate it if macros could be incorporated where needed for automation purposes. For the expense tracker, it needs to categorize various business expenses including, but not limited to: - Food and drinks - Transportation - Office Supplies - Site local purchase expenses The ideal freelancer for this project would have significant experience in Excel, specifically in creating detailed, user-friendly templates for pro...

I'm in search of a skilled data entry operator with an in-depth understanding of Excel's formulas and functions. The project includes both text and number entries which are reasonably simple in terms of their structure. The project details: - Data ...operator with an in-depth understanding of Excel's formulas and functions. The project includes both text and number entries which are reasonably simple in terms of their structure. The project details: - Data entry includes less than 500 entries - The structured use of Excel formulas and functions is critical - Both text and numerical data need to be accurately input Ideal candidates will have experience with data entry, Excel, numerical data, and text data processing. Reliability, accuracy, and attention to ...

Hi Umer S., Can you please convert the attached Quote to Excel as you have done for others. Require as soon as possible please.

I'm seeking a skilled freelance Data Clerk to enter and cross check the Korean Fields on a business card, including the key details such as Name, Job title, and Company name, and more. Your responsibilities: - Type all the fields on the business card on a Excel - Ensure the data being filled in the business card is accurate - There are 363 business cards need to type. - Estimated HR needed: 10 hr Sample of the Card:

Do you want to convert any PDF, JPG, PNG, or image files Are you looking for any kind of document conversion or need editing in your documents, You are on the right gig. MY SERVICES: ✅ Data Entry ✅ Web research ✅ Data Conversion ✅ Copy Paste Work ✅ Excel Data Entry ✅ JPEG to Excel or Word ✅ PDF to Excel or Word ✅ Real Estate Data Entry ✅ Language Translator ✅ Microsoft Excel ✅ Microsoft Word ✅ Lead Generation If you still have any questions or want to discuss prices for a custom project, don't hesitate to contact me. WHY ORDER FROM ME?? Fast Delivery, Never Late ✔ Message me if you're unsure or have project-specific questions Thank you

I'm in need of an Excel expert who can help me with a range of tasks. The project involves a large Excel file with over 10 sheets. The tasks include: - Data Analysis: I need someone who can help me analyze the data in the file, looking for trends, patterns, and key insights. - Chart and Graph Creation: I also need charts and graphs to be created based on the data. These should be visually appealing and easy to interpret. - Formulas and Functions: The data file includes a lot of mathematical calculations. I need an expert in Excel formulas and functions to help me with this. Specifically, the type of data analysis needed includes statistical analysis, trend analysis, and comparative analysis. The ideal freelancer for this project would have: - Prof...

More details: What type of data are you looking to have entered? Text How will the data be provided for entry? Digital files What is the preferred format for the final data? Excel

More details: We already have a excel workbook but need to improvise it and make it automated for calculations of XIRR, Investment Holdings, etc with monthly update of transactions User-friendly interface Intermediate to Advanced Skills required

More details: What specific data or information do you want to analyze in Excel? Financial data How do you prefer to receive the analysis results? Formulas What specific calculations or formulas do you need to perform in Excel? advanced & basic

More details: What specific tasks do you want to automate in Excel? Data entry, Data cleaning and formatting, Data analysis How many Excel files do you need to automate? 1-5 What is the approximate size of each Excel file? Less than 1MB

I am seeking the help of a back office staff to assist with a variety of tasks, including data entry, file management, and document organization. The ideal candidate will be able to work less than 10 hours per week. Requirements: - Proficiency in Excel, Google Sheets, and QuickBooks - Previous experience in data entry and file management - Strong organizational skills - Ability to work autonomously and efficiently - Excellent time management skills You will be responsible for maintaining and organizing essential documentation and assisting with other administrative tasks as necessary. This role requires excellent attention to detail, time management skills, and the ability to work independently.

I'm in need of an Excel-savvy individual who can competently create a detailed data entry listing. The purpose of this project is to list email addresses, data input should be as provided without necessarily having to be in any specific order. Along with each email address, you should also input the associated full name. This job requires attention to detail and proficiency in Excel. Previous experience in data entry would be advantageous.

...field of 1.8T. I have laminations made from the best material for permeability, which I have attached for your reference. I have tried winding a single coil, but the electromagnetic field is not strong enough. However, when I placed two independent winds on the coil connected in parallel, I realized that the electromagnetic force got stronger, even with double the voltage. Here are the specifications of the core laminations: 0.3mm thickness, 70mm x 150mm, and the core is 70mm x 70mm (radius of 3.949 or diameter of 7.898mm = area of 49cm2). The bobbin is 75mm x 75mm inside for wire radius 6.77cm or diameter 8.4628cm. The sides are radius 6.77cm diameter 13.540, and the length is 150mm. I need your job electronically in Word or Excel Please provide a sum...

Need to do data entry from chatgpt I to excel spreadsheet. Need basic math and English skills

...******* Project description : This is an intensive, manual work project that will take at least 4 hours of dedicated Excel skills Please proceed with reading further, only if you are willing to work hard and devote time to complete the task correctly. It CANNOT be automated or run via a script. It CANNOT be outsourced via code. Please do not waste your valuable time trying to do either. The task: There are 10 Excel workbooks, with approximately 1 million rows each. These contain the data for text messages sent via SMS to customers in the last 1 year. Your task is to sort and separate the messages into different sheets in each workbook. You will create 1 workbook for each month, e.g., messages sent between the first and last day of: 1. April 2023 2. ...

I need help with a resea...objective is to gather a list of law schools in the US, along with the emails of their deans and assistant deans. This research should be done on a state by state basis to ensure comprehensive coverage. The main deliverable would be an excel table with all the below information: - Basic information for each law school (name, state, city) - Contact information (general email and phone number) - Emails of deans and assistant deans The timeframe for completing this research project is less than a month, ideally within a week Ideal skills and experience for this job: - Proficiency in using research tools and databases -Attention to details - Strong organizational skills to ensure systematic approach by state - Ability to verify and en...

I am looking for a proficient Excel VBA developer to create a macro that can automate sending payslips to employees on a monthly basis. Key Requirements: - The VBA code should be able to extract the pay information from an Excel spreadsheet and generate a PDF file with the payslip. - The generated PDF file should then be attached to an email that is sent to the corresponding employee. Ideal Skills: - Proficiency in Excel VBA, including the ability to work with PDF files - Experience with automating email sending processes - Strong communication skills to ensure the solution meets our needs. Please note that this project is specifically for creating the VBA code for the payslip emailing system - the design and cont...

I have a CSV file containing 1 lakh records, with each record having a full address. I am looking for someone with advanced Excel skills who can convert these addresses into latitude and longitude. Ideal Skills and Experience: - Advanced Excel skills, particularly in data manipulation - Understanding of geolocation data and coordinate systems - Experience with data analysis and visualization, particularly with large datasets - Proficiency in working with CSV files The latitude and longitude data will be used primarily for data analysis. The final output should be in CSV format, which I will then use for further analysis. Given the large number of records, efficiency and accuracy are essential.

We are looking to hire individuals to assist us with product data management on our bigcommerce site. The job is as follows: Receive produc...site. The job is as follows: Receive product data sheets from manufacturers Match up product data from manufacturers to our product data sheet using an existing template Adjust product data for SEO optimization Locate, and do light editing on product images To confirm you have read this job posting please put the word pineapple in your response. Experience with automotive ecommerce sites is preferred but not required. You must have excellent attention to detail, and be able to work quickly. We have tens of thousands of products to onboard so it is imperative that you are familiar with best practices in Excel and can do multiple lines of...

I am seeking a freelance Excel expert to assist me with a project that involves intermediate-level use of Excel formulas and functions. The ideal candidate would be able to automate the process fully.

I require competent services for data transcription. This project involves the transcription of data from a total of 265 JPEG images into an excel spreadsheet. Example Jpeg attached. The Details: - The JPEG images contain a combination of both text and numbers. - An integral part of this project is that the data from each image should be transcribed into a separate tab on the Excel spreadsheet. Key Qualities: - Proficiency in data transcription from images (JPEG) is essential. - Advanced skill level in Excel data management. - A keen eye for detail to ensure text and numbers are accurately transcribed. Thus, if you possess a high attention to detail and proven proficiency in this kind of work, I invite you to make your bid.

I am looking for an experienced freelancer to create a comprehensive hiring tracker on Excel. The tracker should be linked with PowerPoint and automatically update the slides. Additionally, I need a detailed dashboard that displays the following data points about the hiring status: - Number of applicants - Stages of the hiring process - Open vs filled positions Furthermore, I would like the dashboard to include some extra information, specifically: - Source of applicants - Diversity statistics The ideal candidate for this job should have a strong background in Excel, PowerPoint, and data visualization. Experience in creating automated systems and dashboards for recruitment or HR purposes will be highly appreciated.

This text file is too large for my pc to handle. You will open this text file, and then save it into 10 excel files and send the excel files to me. The data needs to all be in the correct format. Find the file here: (this is public data) Click 'Real Property Data' Then open the real_acct file. This is the file I need divided up and sent to me at 10 excel files. So each file will contain about 10% of the big file. All data needs to be captured. You will send me a test file with 100 rows of data to see if it is correct. Your bid is your bid. Do not bid and then ask me 'what my budget is?' Read the requirements and follow them. type 'sunshine' in your bid.

I need a designer who can format documentation for my company. It's crucial that the documentation is in line with our corporate standards. Requirements: - The documentation will be supplied in Word or Excel and will need to be formatted in Canva to corporate standards (see examples) - The final files will be provided as both the original Canva working file and a print ready PDF. - The primary audience for this documentation is our employees, so it needs to be clear and easily understandable for them. The ideal candidate will have: - Proficient document layout skills. - A high level of written English. - The ability to proofread supplied documents for any errors, and check their own work before submission. - Experience in creating process document...

excel optimization problems using premade excel model involving costs/profits/promotion. Answers using excel solver. There are 2 parts. I have already completed. Now, I need to complete another. I need it within 2 hours. It's not too big work.

Mi ...academia de Microsoft Excel online dirigida a profesionistas en el área contable / financiera / administrativa alrededor de distintos países de habla hispana. Actualmente estoy buscando probadores o "testers" los cuales tendrán acceso completo a los diferentes cursos de la academia y luego de consumir los mismos, a través de una revisión multipuntos, brinden no solo una reseña y calificación sincera del mismo, sino que también brinden un reporte de mejoras y acciones a efectuar para que pueda mejorar el nivel del mismo. La persona(s) interesadas en ser probadores no necesitan un nivel alto de conocimiento de la herramienta, ni tampoco deben tener alto conocimiento financiero y contable ya que los cursos dispo...

I have a set of .rdf files that contain data which I need to have extracted and organized into an Excel spreadsheet. - Extract data from .rdf files. - Ensure the data is accurately transposed into the Excel spreadsheet. No further data manipulation is required, just a neat and efficient organization of the data in the Excel file. Prior experience working with .rdf files would be an advantage.

I'm looking for a talented developer who can create a script that can extract diverse data from multiple web pages and compile it into an Excel spreadsheet. Requirements: - Extraction of text content, images, and tables from various web pages - Script should be able to handle multiple web pages efficiently Ideal Skills and Experience: - Proficient in web scraping and data extraction - Strong experience with scripting and automation - Prior experience with extracting images and tables from web pages - Proficiency in Excel for data compilation - Ability to create a script that can run automatically on a weekly basis.

All in German!! I require an experienced data collector who can provide me a comprehensive Excel spreadsheet with 200 targets for cold calls. The subjects of interest are all freelance and independent salespersons based in Germany. The information about the targets should include: - Name - Contact Information (Phone number, Email) - Location - Website - Social Media account (LinkedIn) - Company Address - Company Name These professionals should represent the following types of companies: - Marketing Agencies - E-Commerce Companies - Recruiting There are no specific requirements regarding the years of professional experience. Any level of experience is acceptable as long as they fall under the freelance and independent salesperson category, based in Germany, and are associ...

I need a talented freelancer to design an Excel-based Tambola ticket generator with my specific requirements. This will enable me to generate a variety of tickets efficiently and effectively. Feature Requirements: • The ability to generate tickets with random numbers. • Numbers must be evenly distributed across each ticket. Skills & Experience: Ideal candidates will have: • Proven experience in Excel and VBA (Visual Basic for Applications). • Knowledge of number generation and distribution algorithms. • Attention to detail. • Ability to work within specified requirements. • Problem-solving skills, as unforeseen computing problems may arise. • Advanced knowledge in spreadsheet software to ensure the generator functi...

I'm looking for a skilled expert in excel Pivot tables. To help me create an excel master sales file where i can get my stores to fill a template and email it over to me and i could put that template in a folder and that would auto feed my master sales dashboard. - Analyzing product sales by category, and store sales from the EPOS data. - Identifying the sales trends per week/month/qtr - Focusing on the product sales data, specifically looking at the highest revenue-generating items. Ideal skills and experience for this job would include: - Proficiency in Excel and pivot tables, as the analysis will involve working with a large dataset. - Previous experience with EPOS data analysis would be highly beneficial. - Strong analytical skills and the abi...

More details: What specific tasks do you want to automate in Excel? Data entry, Data cleaning and formatting, Data analysis How many Excel files do you need to automate? 1-5 What is the approximate size of each Excel file? Less than 1MB

Am nevoie de transcrierea unor date de pe anumite documente intr-un fisier excel. Este vorba de doar 4 campuri (data, pret, serie, numar identificare) iar toate documentele au exact acelasi format. Documentele sunt in format fizic in Cluj-Napoca, Romania.

...title, I'm facing a problem with some Microsoft Excel files that have become corrupted and can no longer be opened. Key Requirements: - Expertise in recovery and repair of corrupted Microsoft Excel files - Proven background in data recovery projects - Possesses a good understanding of Microsoft Excel file structures and data - Ability to perform tasks without causing further data loss Here's a short overview of the issue: - The corrupted files were all made in Excel and I'm currently unable to open them Due to the nature of this work, discretion and confidentiality are critical. If you have the right skills and can handle this kind of sensitive project, let's talk. Your mission, should you choose to accept it, is to take these corru...