Example macro excel automatically fill information workbook işler

I have text data stored in a MySQL database that needs to be cleaned and formatted in Excel. Key Tasks: - Identify and correct errors in the data - Eliminate irrelevant information - Standardize data for consistency - Ensure data integrity and quality Key Skills: - Proficiency in MySQL database management - Strong experience in data cleaning and manipulation - Expertise in Excel for data formatting - Attention to detail for identifying anomalies and inconsistencies - Ability to ensure data quality and integrity We need a freelancer with a keen eye for detail and strong data management skills to take on this task. A background in data science or analysis would be highly beneficial. Please include examples of similar projects you have completed in your application.

I am looking to develop an automated Excel Workbook specialized in the area of cost reporting. Key components I need are: - Calculation Formulas: Enable the workbook to calculate various financial metrics automatically. Should include revenue, expenses, and profit calculations. - Analytical Charts: The workbook should be able to visually represent the data and calculations such as revenue, expense, and profit trend lines. - Advanced Analysis: In addition to basic calculation formulas, the workbook should be able to analyze profit margins and handle cost variance analysis. It should have the functionality to run scenario analysis based on different inputs. Ideal candidates should have strong skills and experience in advanced Excel, partic...

As a healthcare company, we are in need of a financially savvy individual for financial forecasting, budgeting and planning tasks. Your tasks will likely involve: Project Overview The purpose of this project is to develop a financial model that compares the profitability of leasing machines with consumables versus selling them outright. The model will take into account the operating costs and revenue generated from consumables to determine the most profitable approach for the distributorship. Project Objectives Create a comprehensive financial model that compares leasing and selling machines Identify key variables and assumptions for the model, such as machine costs, consumable prices, and operating expenses Determine the potential profit margins for both leasing and selling scenarios P...

I am in need of an expert researcher to build an email list composed exclusively of Tax Advisers, Tax Advisors and Tax and Audit Firms operating within Germany. The primary purpose of this email list is for im...service offerings. Ideal Skills: - Proficient in online research - Proven experience in data collection and management - Background in marketing or business development preferable - Excellent proficiency in English and some understanding of German language would be beneficial. Outcome: - An accurate email list with verifiable contacts - Must be formatted in a clear, organized manner (Excel CSV preferred) This is a venture that requires a good understanding of the targeted industry. With your expertise, we hope to successfully reach out to our prospective clients. ...

Job Title: Sales Outreacher Company: KT Studio About Us: KT Studio specializes in growing personal brands and businesses, focusing on YouTubers and influencers aiming to enhance their growth and efficiency. Role: Sales Outreacher...outliers) Experience: 1 month to 2 years (training provided for beginners) Application Process: If you are driven by success and ready to seize this exciting opportunity, send a DM with the word "outreacher" along with your cover letter and resume showcasing your sales experience and why you are the perfect fit for this role. Highlight any achievements or skills that demonstrate your ability to excel in sales and client relations. We are seeking a standout candidate to join our elite team, and exceptional performers will enjoy a rewarding career...

I require an accomplished IT trainer proficient in implementing training in multiple areas - programming languages, networking, cybersecurity, Java full stack developer coursework, Python full stack developer coursework, Java Testing, Python testing, SAP, Devops, Power bi, Data science and Excel. The preferred programming languages for the training leverage are Java, Python, and SAP. I have a preference for trainers with recognized qualifications or certifications, demonstrating their competence in the field. Proven experience in delivering engaging and effective IT training is essential.

I am seeking an Excel expert capable of calculating First in First out (FIFO) for tech stocks that I own. Your responsibilities will include: - Taking provided data including purchase date, purchase price, stock ticker symbol, stock splits, the number of shares purchased, the number of shares sold and the respective dates - Arranging and analyzing these data accurately in an Excel document utilizing the FIFO methodology - Assessing if the stock sale is subject to tax due to the tax exemption for holding the stock for longer than 3 years The ideal freelancer would have: - Extensive experience with Excel - Familiarity with the FIFO method - Strong understanding of tech stocks This job will require attention to detail and precision. It's crucial the final produ...

I'm in need of a skilled copy typer to assist me with converting a variety of documents into a digital format. The documents I need typed are a mixture of printed and scanned materials. Key Requirements: - Copy typing experience, particularly with printed and scanned documents - Accurate replication of the original content - Ability to match formatting to the original document Copy required in excel

I'm urgently in need of a proficient freelancer who can help with a crucial data entry task. Unfortunately, I skipped some questions, so I'll provide more context. The task is a one-time project, but the data type to be entered is not fixed yet, it could be either numerical data, textual data or a mix of both. Ideal Skills Needed: - Efficient in Excel Data Entry - Experience with Online Form Filling - Proficient in Copy-Pasting Data This project requires some urgency so a quick turn around will be highly appreciated.

I have a website in Plesk, custom PHP. I have a control panel where I can publish blog posts in the website. I need a way that, whenever anyone publishes a blog post in the website, it will automatically be published in Linkedln company group, this is done VIA Linkedln API but I need some help with the coding.

Following are the requirements of task to be fulfilled. ...the requirements of task to be fulfilled. 1- Task is to visit the both locationsphysically and Take 5 to 6 geotagged photos of with name board captured and from outside the building. 2- Get the verification form filled, signed and stamped by the HR of both locationsand also stamp the certificate. 3- Get the details of verifier, Name, Designation, Department and Contact. 4- In case of refusal to fill form, take the written refusal with stamp or sign as a proof. 5- If the comapnies does not found on given address than take the 7 to 8 geotagged photos of exact address with right left name boards photos and make a small few seconds video of address . Also get the details of any nearby business ( Name of person, Business name a...

I'm in need of an expert in data entry, particularly in Microsoft Excel. The task revolves around basic data entry, which includes names, email addresses, and other related simple information. Ideal Skills and Experience: - Proficiency in Microsoft Excel - Previous experience in basic data entry - Strong attention to detail - Ability to handle repetitive tasks accurately and efficiently Your primary responsibility will be to accurately transcribe and input the data provided into the Excel spreadsheet. Your attention to detail will be crucial, as even small errors could have significant repercussions. Please make sure you are comfortable with the given task before placing a bid.

I'm looking for an experienced Excel expert to assist with my data analysis and formula creation tasks. - Data Analysis: I need you to help me with both statistical and financial analysis. It's essential that you are comfortable and proficient with these kinds of data analysis within Excel. - Formula Creation: You'll also be responsible for creating various formulas, particularly related to budgeting and financial forecasting. Experience in working with such data to build accurate and efficient formulas is a must. I'm looking for someone who can quickly understand the data, provide insightful analysis, and create the necessary formulas for financial tasks.

I have a pdf of a report which I need in Word format as a template. It should include check boxes which allow different options (no check, colour fill, outline, colour fill and outline) so it needs to be programmed in MS Word Developer. I have attached a sample of how these checkboxes would look

Following are the requirements o...is to visit the O.P.I Zentrum für Zahnmedizin & Chirurgie physically and Take 5 to 6 geotagged photos of with name board captured and from outside the building. 2- Get the verification form filled, signed and stamped by the HR of Zentrum für Zahnmedizin & Chirurgie and also stamp the certificate. 3- Get the details of verifier, Name, Designation, Department and Contact. 4- In case of refusal to fill form, take the written refusal with stamp or sign as a proof. 5- If Zentrum für Zahnmedizin & Chirurgie does not found on given address than take the 7 to 8 geotagged photos of exact address with right left name boards photos and make a small few seconds video of address . Also get the details of any nearby business ( Name of...

Need someone to enrich a lead list of 450 with country names (country of the company).

...plugin. Key Project Details: - The main goal of this integration is to automate our appointment scheduling process. - Individual staff members will be responsible for managing the booking settings and appointments post-integration. Your responsibilities: - Configuring Google Calendar: Ensure that appointments made on the website are automatically synced with our Google Calendar. - Setting up Zoom links: Implement a feature where a Zoom link is automatically sent to the customer once they've scheduled an appointment. Ideal Candidate: - Proficient in Wordpress: You must have a solid understanding of Wordpress development. - Experienced in API integration: Prior experience with Google Calendar and Zoom API integration is a big plus. - Familiar with Webba booking plu...

I need a savvy social media marketing team to create an engaging Instagram post designed to increase brand awareness. The post will be centered around product promotion. - Main goal: Increa...promotional content for products geared towards parents is a plus. 1-page(I want to dynamically change the words) For Singapore Corporate Secretarial Firms These are Totally Free of Use Check this out 2-page * T-Bizfile - Filing, reporting, and syncing of information with Bizfile * T-Sign - Digital signing services with clients * T-Drive - Store any data on cloud storage * T-Bank - Synchronize bank statements with local banks * T-Task - Tasks are automatically generated * T-Doc - All filing documents are automatically generated * T-Bot - Communicate with potentia...

...displaying their contact information, home city, current location, photo gallery content sellers as photographers can be tagged in their photos and view only by other content creator users, video gallery, social media links, upcoming travel events, paywall, profile can be set visible for free or visible only by week or monthly subscription, able to receive endorsements and reviews from their fans, contact formulary, chat with fans free and paid, video call with fans free and paid, button with a travel request that can be used by the fan user and the content creator users can accept or refuse, if accepted a formulary will display for the fan user to fill up and will be send to the content creator user. 2. Tier 2 Paid: bio page displaying their contact information...

...WooCommerce developer to create a highly customized checkout plugin for my e-commerce platform. Key Features Required: - Customized Checkout Fields: The plugin should support custom fields for user input. - Payment Gateway Integration: I need support for two different payment gateways. These should be automatically shown based on the customer's chosen country. - Specific Order of Information: The checkout process should be divided into clear steps: Shipping information, Billing information, Order review and finally, Payment options. - Customized Graphic Layout: I want the plugin to have a tailored design that fits my brand's visual identity. Other Important Requirements: - Smooth User Experience: The checkout process should be seamless, with no un...

fixing following issues In the menu, add the "Services" option between "Home" and "Contact". Each service category should have a gallery of images showcasing examples of completed work. For example, for the "Bodenleger" service, we would like a gallery of images displaying installed floors. Implement a system to automatically import current reviews into the dedicated section of the MyHammer website. Additionally, we would like the website to display reviews that will soon be available on Google. Verify the proper functioning of the contact form, ensuring that all fields are fillable and that submitting the form leads to the correct reception of requests. Cookie feature

I am currently looking for Indonesian residents who have personal experiences relating to Dengue Fever. You will be asked to participate in a one-hour interview to speak a...Duration: 1 hour via Zoom Remuneration: USD 10 Respondent must: - EITHER Received at least 1 dose of a dengue fever vaccination in the last 6 months (age 18-45) - AND / OR are the parent / guardian of a child or adolescent (age 6-17) who has received at least 1 dose of a dengue fever vaccination in the last 6 months Prior to being selected, there will be a short screener form that you will have to fill up. The purpose of this screener would be to check if you qualify for a study we are conducting. The incentives will only be given if you meet the screening criteria and complete the 1 hour interview. lessMore/...

I am seeking a proficient software developer to create a mobile application that primarily serves to deliver information. Here are the specific requirements: - The app should be designed for the Android platform. - The core functionality of the app is information delivery in a user-friendly and accessible manner. - The design should be intuitive with an easy to navigate interface. Ideal Skills and Experience: - Excellent proficiency in Android app development, with a robust portfolio of completed projects. - Strong understanding of information architecture and UX principles. - Experience in creating apps with similar function will be an advantage.

...system for user registration and administration. Design a user-friendly interface tailored for an age group of 25–55, ensuring simplicity and ease of navigation. Develop dual dashboards: a main user dashboard for daily activities and an admin dashboard for backend operations. Enable the admin to create and manage customizable form templates for different users. Provide functionality for users to fill out, save, submit, and print forms as needed. Incorporate secure electronic signature capabilities to validate documents within the app. Ensure robust security measures are in place to protect user data and privacy. Required Skills: Expertise in full-stack development with a focus on creating intuitive user interfaces and scalable backend infrastructures. Strong expe...

...basic shopping cart system that allows users to add products to their cart and proceed to checkout. - Payment Gateway: The store must integrate with a reliable payment gateway to process transactions securely and promptly. Digital Product Delivery I envision a straightforward process for handling digital product delivery. After a successful payment has been made, the digital product should be automatically available for download. This process should be seamless and intuitive for the customers. Ideal Skills and Experience: - Previous experience in developing online stores, particularly those with digital product sales. - Proficiency in integrating APIs, especially those related to product catalog, shopping cart, and payment gateway. - Strong understanding of e-commerce and digit...

I'm looking to incorporate a JavaScript function in my website where, upon a user inputting a valid zipcode, they are automatically redirected to a specific URL based on the zipcode. If the zipcode is invalid or unrecognized, it should handle it adequately. Same functionality as this plug - pro version -- unlimited zipcodes / unlimited URL's

Title: Collecting product information of vehicle’s autonomous driving device <Overview> Please collect product information on vehicles that have or will have the technologies described in the “Technology Description” section below. <Technology Description> This article describes a new type of driving assistance device. This device automatically adjusts the steering angle of your vehicle based on the driving line of the vehicle in front, and operates to maintain the target driving line. In addition it also has the ability to adjust the speed of the vehicle to maintain a certain distance from the vehicle in front, and the ability to drive the vehicle according to the driving pattern of the vehicle in front. Furthermore, this device stops ...

I need a freelancer who can assist me with moving data from Excel to an Oracle database. Responsibilities: - Copy data accurately from Excel to the database - Ensure all data is consistent and properly formatted Ideal Skills and Experience: - Proficiency in Excel - Experience with Oracle databases - Detail-oriented - Proven track record handling data migration tasks

I am looking for an expert data entry freelancer who can efficiently and accurately transfer text data into a Microsoft Excel format. - The final delivery should be in a Microsoft Excel file format. - The preferred data structure in the Excel file should be row-wise. - Excellent attention to detail and proficiency in Excel is a must for this job to ensure data is entered correctly. I look forward to working with someone who respects deadlines, has a solid understanding of data entry requirements, and values quality service. This project could lead to long term engagement if successfully completed.

I need an experienced HR professional to assist with our company's recruitment and hiring process. - The role will involve helping us fill positions ranging from entry-level to senior/executive level. You will be instrumental in attracting, screening, and selecting qualified candidates. - Your focus will be on evaluating candidates' education and experience, ensuring the positions are filled with candidates that meet our qualification standards. The ideal candidate should have a proven track record in recruitment and hiring. Experience in a startup environment or understanding of the technology industry would be a plus. Previous experience in recruitment for roles requiring a mixture of educational and professional experience is highly desirable.

I need an expert in Excel macros to develop a tool for me that would allow me to automate some specific tasks as I work in Excel. Key Specifications: - The tool needs to be able to automatically format cell values. I will provide the existing format and the new format that I want. - It should be able to add text boxes to specific cells in the Excel file. The content of the text boxes will vary depending on the content of the respective cells. - The tool should allow me to delete specific columns based on the value in a particular cell. Ideal Skills: - Proficiency in Excel macros/VBA - Prior experience in customizing Excel files - Good communication to understand my needs and implement them accurately I have an excel sheet with production...

I'm in need of a system that can transform my existing PDF into word file...existing PDF into word file. - The first needs to be a Word document, containing a fillable form. This form should encompass text fields, check boxes and date fields, mirroring those found in the original PDF. - The second is an Excel spreadsheet, which is to be linked directly to the Word form. This link should enable automated data transfer between the two, minimising the need for manual data input processes. Proficiency in Word, Excel, PDF conversions and data automation would be ideal for this project. Understanding of complex form creation and Excel-to-Word data linking is also crucial. This endeavour requires precision and a strong attention to detail to ensure data accuracy an...

I have 73 PDFs that I need to be converted into separate Excel sheets. The Excel sheets need to follow a specific format, which is in table form with specific columns. Key Requirements: - Convert 73 PDFs into rows of an Excel sheet - The Excel needs to follow a pre-defined format, which I will provide. - The pre-defined format is in the form of tables with specific columns The Excel sheets should contain all the data as shown in the template with a separate summary tab with the following: - Average and standard deviation for each part - Average and standard deviation parts total by invoice - Average and standard deviation trip charge - Average and standard deviation Material markup % - Average and standard deviation Hours - Average and standard deviati...

I am in need of a freelancer who can help me convert a bulk of my purchase invoices from PDF format to Excel. - The PDF invoices are all Text-based and thus, the conversion can be automated. - The original scanned PDF will also be provided if needed. - The Excel sheet should have the following fields: - Vendor information, Invoice number, Invoice date, Purchase details (Product Name, Uom, Qty, Rate, VAT, Total) - I prefer all the invoices to be organized in a single sheet in the Excel file. Ideal skills for this job include proficiency in data extraction, PDF to Excel automation, and a keen eye for detail when it comes to organizing data. A background in finance or accounting would be a plus, as it will help in ensuring the accuracy of the extract...

I'm searching for a highly skilled Web3 designer to build and launch a Web3 website. This individual should excel in user interface design, creating visually pleasing and intuitive designs for a seamless user experience. Key responsibilities will include: - Developing a user-friendly Web3 website design - Incorporating decentralized identity feature in the website Expertise and Skills required: - Proficiency in Web3 designing - Previous experience with decentralized identity - Solid understanding of Blockchain - Proficiency in user interface design Ideally, you should have an impressive portfolio of previous Web3 design work. Looking forward to a designer who can deliver a high-quality user interface and contribute innovative ideas for site features.

...description and other fields manually. When giving out an item, the staff will scan the product code or manually enter the internal code of the item. The item description should then appear, allowing the user to input the recipient's name, their prayer group, and the quantity. The inventory should automatically reduce when an item is given to a church member. Additionally, we should receive an alert if the item quantity falls below a certain level. We are not going to have less than 100 different items. For example, Mens Shirt Medium will have the same product code and internal item which ever seller we purchase it from. We want to keep it simple. We are looking for someone to create this and giving us a detailed document explaining the tables and fields so that w...

Grâce a l'ocr et AI je veut créer une plateforme en ligne pour récupérer les factures scannées ou photographier ou les bon et pourvoir lire tout les informations de la facture grâce a l'ocr et reconnaître les différentes type de factures grace au machine learning et a la fin récupérer les données dans un fichier excel ou csv ou dans une base de données grâce a la configuration de chaque rebrique et colonne.

...assembly in the blueprint to ensure the final product is simultaneously practical, user-friendly, and aesthetically pleasing. The bookshelf should be not only a storage unit but also an exquisite piece of homeware. ------------------------------------------------------------------------------- All of the above is just freelancer's AI text. What I want is designs for wall-mounted bookshelves to fill a vaulted space in my loft with a variety of shelf sizes to accommodate books, artwork, and various knick-knacks, based on a sketch I will attach. I intend each shelf to be made of 10"x2" or 10"x1" stained wood unless a variation is recommended. The wall is vaulted, some of the shelves are at diagonals for an interesting design, the shelves will open up and ov...

I'm a fitness coach, specializing in strength training and am in need of comprehensive fitness sheets. These should contain detailed information in four key areas: 1. Exercise Descriptions: Detailed information about strength training exercises, including diagrams or images, written instructions, and any necessary safety advisories. 2. Diet Plans: Nutrition recommendations and daily diet plans tailored to support strength training. These may include recommended meals, macro or calorie counts, and advice on supplements if necessary. 3. Progress Trackers: A system for tracking training progress, such as weight lifts, cardio fitness levels, and body measurements. A visually appealing, easy-to-understand format is important. 4. Daily Macros/Calories Checks: A stra...

As a company, we're currently in need of a seasoned Power BI expert, well-versed in creating engaging dashboards and detailed reports. Key Responsibilities: - Develop and desi... Key Responsibilities: - Develop and design interactive dashboards and reports - Generate in-depth, data-driven reports - Provide data analysis and insights Key Requirements: - Proficiency in Power BI - Strong experience in creating interactive dashboards and detailed reports - Skilled in data analysis and providing insights The project will involve connecting to data sources primarily from Excel spreadsheets. The main audience for the dashboards and reports will be our data analysts. To ensure that you're the right fit for this project, please provide examples of your previous work in Power B...

...that will automatically backup my Filevine information to Microsoft OneDrive. Key Requirements: - Transfer data from Filevine to OneDrive: I need all information stored on my Filevine account securely backed up to my Microsoft OneDrive account. - One-time setup: I need the system to be set up to back up all existing data on my Filevine account to my OneDrive. - Automation: The process should be automated to ensure all new data added to Filevine is backed up without manual intervention. I'm expecting the following from the freelancer: - Experience with API Integration: You should be experienced with connecting and transferring data between different cloud services using their APIs. - Automation Skills: Ability to set up a system to carry out the bac...

...Requisitos: - Residente en Venezuela - Título universitario en Contaduría Pública, con al menos 3 años de experiencia relevante prioritariamente en contabilidad, seguido de experiencia en fiscalidad y tributación. - Profundo conocimiento de las normativas y procedimientos en contabilidad, tributación y fiscalidad a nivel nacional e internacional. - Nivel intermedio (preferentemente avanzado) de Excel, capaz de gestionar y analizar grandes volúmenes de datos financieros. - Dominio del inglés, con competencias para la comunicación efectiva y la elaboración de informes financieros. - Disponibilidad para trabajar en horario completo y de manera exclusiva en modalidad Home Office. - Equipo de cómputo o laptop...

...handling specifically relating to Excel spreadsheets. The ideal candidate will be responsible for: - Sorting the data to make it more organized and user-friendly. - Cleaning the data. This may entail tasks such as detecting and correcting errors, and potentially removing any duplicates (however, a clear plan on handling this aspect will be shared later in the project, since the specific data cleaning operations were not predefined). - Separating the data as requested. This is a time-sensitive project requiring completion as soon as possible. Therefore, the individual needs to be adept at working under pressure and towards tight deadlines. The perfect fit would be someone with a proven track record handling similar tasks, demonstrating a strong proficiency in Excel and a ...

I am seeking a proficient Power BI expert for a project that in...this project is to analyze business data, visualize it for presentations, and create interactive dashboards. Key Responsibilities: - Designing and developing Power BI dashboards and reports - Implementing data modeling and transformation - Connecting data from Excel spreadsheets Ideal Skills: - Strong understanding and experience in Power BI - Proficiency in data modeling and transformation - Experience in creating engaging and interactive dashboards - Prior experience in analyzing business data - Experience in working with Excel spreadsheets Your successful completion of this project will help in gaining valuable insights from our business data, and ultimately facilitate data-driven decision making within ...

I will do enlisted task. Renovation Brands needs an analytical assistant to support our FP&A department in a variety of tasks. The ideal candidate will have experience with Excel and running/modifying SQL (no need to have experience writing it). Tasks will include things such as downloading data from ERP or SQL, Refreshing files and validating refresh worked, troubleshooting errors in execution, etc.

Investment decision model excel

I'm looking for someone with a solid understanding of the market and strong research skills to help identify multi-brand women's clothing retailers in the UK and USA. The project involves finding both online and physical retailers that also have an online presen...online presence. The ideal candidate will have experience in market research, preferably within the fashion or clothing industry, and possess excellent analytical skills. Knowledge of the retail sector is crucial, and having access to premium market research tools would be a plus. Please include details of your experience and your research approach in your proposal. Note that we will provide an Excel sheet for the data, and we are offering $50 for every 1000 records. Please apply only if the budget is acceptabl...

...technical project report. The report is almost complete, but I need someone who can tweak the layout and add a few extra pages to make it look polished and professional. Key requirements include: - Adjusting margins: Ensuring proper spacing for a clean, organized look - Modifying font styles and sizes: Making sure the text is consistent, readable, and aesthetically pleasing - Creating an automatically generated Table of Contents: Ensuring that the TOC is correctly linked to the corresponding sections in the report Ideal candidates should have: - Proficiency in Microsoft Word and experience with complex document formatting - Strong eye for design and attention to detail - Ability to work efficiently and meet deadlines - Previous experience with technical reports is a plus but n...

I need a talented statistician to help determine if there is an association between gender and different types of admission sources from the Emergency Department (ED). The analysis will not be limited to a particular admission source. The data for the project will be supplied in an Excel file format. Freelancers are required to have proficiency in Excel and a deep understanding of statistical tests, particularly Chi-Squared tests. In your application, please include: - Your past work relating to statistical analysis - How you plan to execute this project utilizing the Chi-Squared Test - An estimated timeline for completion I look forward to working with you on this exciting project!

I've compiled an Arabic-Chinese dictionary in an Excel file and I'm seeking a skilled developer to convert this into a user-friendly software. This software will be exclusively for laptop or computer use, and should operate offline. Key requirements: - Experience with software development for Windows and Mac operating systems - Proficient in programming languages suitable for offline software - Ability to create a user-friendly interface The ideal freelancer will have experience in developing functional and user-friendly software. I would like this project completed within a month, so I'm looking for someone who can work efficiently, while also maintaining high-quality standards.