Excel vba data macro일자리

Hello Sophia, Attached is a Excel for translation into Ukrainian. SLA - March 11th. Thank you, G

...Freelance Data Analyst (Advanced Excel & Power BI Expert) Job Description: We are looking for a skilled freelance data analyst with strong expertise in advanced Excel, data management, dashboard creation, and Power BI. The ideal candidate should be able to analyze complex datasets, generate insights, and build interactive dashboards to support business decision-making. Key Responsibilities: Manage and clean large datasets efficiently. Develop and automate dashboards in Excel & Power BI. Perform data analysis to derive actionable insights. Create visual reports and interactive dashboards for stakeholders. Ensure data accuracy and integrity. Requirements: Proficiency in advanced Excel (PivotTables, VLOOKUP, Power Q...

I have a project that involves cleaning mixed data in Excel. Key Tasks: - Remove duplicates - Handle missing values - Standardize formats Ideal Skills: - Proficient in Excel - Experienced in data cleaning - Attention to detail and ability to follow specific instructions

I'm looking for an Excel expert who can make some changes to an Excel file. The task must be completed today.

...Italian. In addition, I have 2 files of phrases (totaling 188 phrases) that need to be translated, though audio is not required for these. Key Requirements: - Utilize an online voice synthesizer as per the attached instructions or any alternative that produces equivalent output. - Deliver the .mp3 files as 3 individual ZIP files, corresponding to each word list. Ideal Skills: - Proficient in Excel - Strong attention to detail (ensuring all output files are consistent in volume) - Familiarity with the Italian language (not compulsory, but preferred) - Native or advanced proficiency in simplified Chinese or Arabic (a plus, as we can discuss extending the project to include these languages) Additional Information: - A female voice should be used for female-specific words, and a ...

I'm seeking an experienced Excel professional to assist me in creating a dynamic table that will track employee data. Key Requirements: - The table should allow for filtering and sorting of data to facilitate easy navigation and analysis. - Data will be entered manually, so the structure needs to accommodate ease of input and maintenance. Ideal Skills: - Advanced Excel skills, particularly with creating dynamic tables. - Experience with data management, preferably with employee data. - Good communication skills to understand and meet project specifications.

Steps: 1. Go to 2. An Excel sheet with specified columns will be shared with you 3. Search database by state and compile information such as company, contact, url, email address, etc.

...proficient Excel developer to transform an open-source R-Script used for calculating Scope 1, 2, and 3 emissions of buildings into a user-friendly Excel tool. Our clients struggle with R, so it is crucial that the Excel tool has the same functionalities and is easy to use. Key Requirements: - Excel tool must accommodate both numerical and categorical data inputs. - The tool must include the three calculators for Scope 1, 2 and 3 emissions. - Consistency with R-output is vital; the XLS output must match the R-output exactly (see tables 1 to 6). - The interface should be detailed and similar to the R-Script output layout. - Front-end with input and output, backend with calc and datasheets - No VBA/macros, only formulas, VBAs are blocked Ideal Sk...

Aufgabenbeschreibung: Excel mit VBA-Makros (Datenbank für Venture Capital, Private Equity und private Investoren mit Makros) ? Projektziel: Erstellung einer Excel-Datenbank mit VBA-Makros, die Venture Capital (VC)-Geber, Private Equity (PE)-Geber und private Investoren verwaltet. Die Dateneingabe erfolgt ausschließlich über benutzerfreundliche Eingabemasken. Die Datenbank enthält eine automatische Suchfunktion mit scrollbarer Liste, eine Investitions- und Dealverwaltung, eine Dokumentation der Kommunikation mit Kapitalgebern sowie ein Reporting mit Diagrammen. ? 1. Tabellenstruktur & Funktionen Blatt Funktion Blatt 1: Eingabemaske für Kapitalgeber (VC, PE, Privatperson) Erfassung neuer Kapitalgeber mit Deduplizierung & ID-Verg...

...professional who can assist me in generating customer invoices in pdf format in bulk using a Microsoft Word 365 template and data from Excel spreadsheets. Your task will involve: - Utilizing a provided Word template to create invoices - Pulling customer contact details, an itemized list of purchases, payment terms and conditions, and a QR code of my company from Excel spreadsheets Ideal candidates should be proficient in Microsoft Word 365 and Excel, with experience in bulk document creation. Attention to detail is crucial to ensure all invoices are accurate and correctly formatted. The deliverable expected is a macro enabled excel which can take the input data from an excel, take the invoice template in the word format and shou...

I need a professional to generate customer invoices in bulk based on a Word template and data in a single Excel sheet. The generated invoices should be in PDF format. Key Requirements: - Proficiency in Microsoft Word and Excel, specifically Office 365 - Experience in bulk invoice generation - Ability to follow a Word template precisely - Skills in converting Word documents to PDF The data is organized in a single sheet with all the necessary information. The ideal freelancer for this project should be detail-oriented to ensure each invoice is correctly generated without errors.

...neuen ERP-Systems für unser Vertriebsunternehmen. Das Projekt ist bereits weit fortgeschritten; derzeit läuft die Parallelphase, es sind aber immer noch Anpassungen und Fehlerbehebungen nötig. Einsatzort: Aachen-Oberforstbach Zeitlicher Umfang: nach Bedarf Folgende Kenntnisse setzen wir voraus: - Microsoft Office 365 - Microsoft Office, insbesondere Access/Excel - Microsoft SQL Server - Programmiersprache VB.NET - EDI (Electronic Data Interchange) - Kenntnisse im Umgang mit HP-Hardware, Server & Storage (wir setzen eine MSA1050 und ProLiant Server ein) - Kenntnisse im Umgang mit VMware - Kenntnisse im Umgang mit Veeam - Kenntnisse im Bereich Windows Server, Microsoft Active Directory - Firewalls...

' STRATA COLLECTIONS VERIFICATION TOOL ' This Excel workbook serves as a central verification tool for collections across multiple systems ' Structure and key formulas provided below '============================================== ' WORKSHEET: Import_Controls '============================================== ' Purpose: Tracks import status from multiple systems and standardizes data ' Key components: ' Import Status Tracking Table ' Columns: System_Name | Last_Import_Date | Records_Imported | Exceptions_Found | Status ' Data Source Configuration Table ' Columns: System_Name | Report_Type | Standard_Headers | Column_Mapping ' Import Instructions (Protected cells) ' Step-by-step guid...

I need someone to reproduce safety documents into an Excel Spreadsheet or Word. The reproduced documents should incorporate safety protocols and procedures. Ideal Skills: - Proficiency in Excel - Attention to detail - Understanding of safety protocols and procedures Please note, it is important that the reproduced documents are accurate and comprehensive in their representation of the original safety documents. I have attached only 3 pages of pics of the doc I require to be reproduced, in total the doc is 8-10 pages.

I'm looking for a reliable freelancer to help me with a data entry project for 600 clinics. The task involves entering specific contact details into an Excel spreadsheet. Data Entry Requirements: - Inputting the phone numbers and email addresses of the clinics. Ideal Skills: - Proficiency in Excel - Attention to detail - Previous data entry experience - Ability to maintain confidentiality and handle sensitive information responsibly. I expect the work to be done accurately and within a reasonable timeframe. Please include your estimated time for completion in your bid.

Detailed Explanation of the App Idea for the Developer 1. Overview: An entertainment mobile application for Android and iOS that allows users to engage in live-streamed game challenges, such as chess, card games, and dominoes. Users can place monetary bets, and winnings are distributed as foll...Required Technologies: Development Language & Framework: Flutter (for iOS & Android support). Game Engine: Flame Engine (for 2D game development). Live Streaming: Integration with WebRTC or other streaming services (OBS/WebSockets). Transaction Management: Integration with electronic payment systems like Visa, Mastercard, Stripe, or PayPal. Database Management: AWS Amazon database server. An Excel file is attached with detailed requirements. If you have any questions, feel f...

I need a professional spreadsheet designed to help me manage my personal finances more effectively, that will be used to sell after. I want it to be feminine appearing, girly, light pink colors K...should be able to help me monitor my spending. - Investment tracking: I need a section dedicated to keeping an eye on my investments. Integration: - Expense categorization: I want the spreadsheet to have the ability to categorize my expenses automatically. - Reporting tools: It should have built-in reporting tools to give me an overview of my financial health at a glance. Ideal Skills: - Advanced Excel/Spreadsheet skills - Financial planning knowledge - Experience with creating personalized finance trackers Please, make sure to provide examples of similar projects you've complet...

I need an Excel expert to improve my Excel sheet. It needs to be more user friendly and visually appealing as it will be used by multiple people. Ideal skills for this project include: - Expertise in Excel - Experience in data organization and visual formatting - Ability to create interactive elements Please note, I have not specified any particular data visualization techniques or aspects to improve in the Excel sheet. I am open to your professional suggestions to enhance its usability and appeal.

...billing, contracts, and user role management. --- ? Detailed Software Requirements: 1️⃣ AI Integration for Smart Analysis Automated result interpretation, identifying abnormal values with smart comments. AI-powered recommendations suggesting additional tests based on abnormal results. Machine Learning capabilities for detecting disease patterns and providing predictive analytics. Advanced data analysis for predicting conditions like diabetes and liver diseases. 2️⃣ Automated Commenting System for Test Results Auto-generated comments for abnormal values based on medical standards. Automatic flagging of results (High H – Low L – Normal). Manual comment customization by doctors or technicians. 3️⃣ Auto-Calculated Fields & Formulas Real-time automatic ...

I'm looking for a small Python script that will scrape an e-commerce web...scrape an e-commerce website for product details and prices. Key Requirements: - The script should be adept at web scraping, collecting data on various products and their prices from the specified e-commerce site. - It should be able to handle potential hurdles such as CAPTCHAs and IP bans without interruption. Ideal Skills: - Proficiency in Python, especially with libraries like Beautiful Soup, Scrapy, or Selenium. - Previous experience with web scraping, particularly from e-commerce websites. - Understanding of data extraction, transformation and loading (ETL) processes. Please note that the script's ultimate aim is to automate the task of collecting this data, making it easier f...

I need to convert this MS Project gantt into god looking excel gantt

I am in need of a comprehensive database featuring all conference halls and wedding venues within hotels across the United Arab Emirates. The database should include vital information such as each venue's capaci...halls and wedding venues within hotels across the United Arab Emirates. The database should include vital information such as each venue's capacity, available amenities, booking price and other detailed information that will be discussed. The data should be delivered in an Excel spreadsheet. Ideal Skills and Experience: - Proficient in data collection and database creation - Prior experience with research in hospitality industry preferred - Skilled in Excel with ability to format data for clarity and usability - Excellent attention to...

Descripción del Proyecto: Buscamos un desarrollador o equipo de desarrollo para crear una plataforma web que permita la generación, emisión, y validación de certificados de cursos en formato PDF, con las siguientes funcionalidades clave: Funcionalidades Requeridas: Generación de Certificados Personalizados Emisión de certificados en PDF utilizando plantillas predefinidas. Po...Generación de QR dinámico con enlace de validación. Entregables: Código fuente y documentación del sistema. Plataforma completamente funcional. Instrucciones de instalación en nuestro servidor. Soporte técnico inicial y posibles mejoras. Si tienes experiencia en el desarrollo de este tipo de plataformas, envíanos tu pr...

...precisión de la información ingresada. * Posible integración con otras herramientas (HubSpot - Opcional). Realizar pruebas exhaustivas: Asegurar que la aplicación funcione sin errores en diferentes dispositivos y escenarios. Proporcionar documentación: Crear documentación clara y concisa sobre el funcionamiento de la aplicación. Detalles del Proyecto: El proyecto ya tiene una base construida en excel, pero requiere adaptación a appsheet, mejoras y optimizaciones. Se proporcionarán acceso a Google Sheets y a la aplicación AppSheet. Se espera una comunicación fluida y actualizaciones regulares sobre el progreso del proyecto. Se proporcionará la documentación necesaria para la total comprens...

...someone to help me create attractive and insightful sales reports in Excel for weekly use at the office. Key elements of the reports: - Sales data: This will be the core of the reports - Charts and Graphs: Visual representations of the data to help illustrate trends and comparisons - Summary Tables: To condense the data into easy-to-read formats - Trend Analysis: To identify patterns over time Ideal skills and experience for the job: - Advanced Excel skills: Proficient in creating complex spreadsheets and utilizing Excel's full range of features - Data Visualization: Experience in creating engaging charts and graphs - Analytical Skills: Ability to conduct trend analysis and interpret findings - Attention to Detail: Ensuring all data...

I'm looking for an expert in Excel to create or fix a loan calculator for me. The calculator should take various loan parameters and compute different outputs. Specific Parameters: - Loan amount - Loan term - Fixed interest rate - Fees - Prepayments Calculations Required: - Monthly repayment amounts - Total interest paid - APR calculation - Total amount paid Additional Input Options: - Fees - Prepayments - Grace period Ideal skills for this project include advanced Excel proficiency and experience with financial modeling. Please bid only if you can deliver a professional and accurate tool.

Please note that the Budget is fixed - Need very beginner skills users only - budget is a...improvement suggestions 2) Answer on your own for about 80 questions 3) Compile your answers in Excel worksheet and format as required. -this is a simple task and will require up to 5 sessions of 2 hours each via chat -Project budget is fixed and it is not by hour -Need users with beginner skills only -Please note no place holder bid - what you bid will be your final price for this task I'm looking for beginner users of social media apps to provide feedback on a new app. The primary focus is on user experience. You will need to compile your observations and feedback in an Excel spreadsheet. Ideal Skills and Experience: - Familiarity with a variety of social media apps - Basic ...

I'm in need of an AI model that can predict outcomes in a binary pattern system, specifically with financial data. This model should utilize deep learning techniques, particularly Long Short-Term Memory (LSTM) networks, and historical pattern analysis to achieve over 90% accuracy in predictions. Additionally, the model should be able to provide smart decision-making recommendations for managing risk. Key Requirements: - The model should be trained primarily on financial data. This could encompass data from various financial sectors, such as the stock market, cryptocurrency market, and forex market. - The historical financial data will be provided in Excel sheets, so the model should be able to process and learn from this format efficiently. Ideal S...

I need full contact information extracted from PDF/Word documents and inputted into an Excel spreadsheet. The information includes feedlot names, personal names, email addresses, phone numbers, physical addresses, and capacity. - The contact details need to be organized in separate columns for each detail in Excel. - Ideal candidates will have excellent attention to detail, proficiency in Excel, and experience with data extraction.

I'm in need of an Excel expert to help create some quality review and financial spreadsheets for a children's care organisation. The primary focus will be on tracking expenses. I need the spreadsheets to: - Provide monthly summaries of individual expense categories - Be formatted with charts and graphs, detailed tables, and summary notes for each monthly overview A quality review would include a lot of info that I would be happy to discuss Ideal candidates should have: - Extensive experience with Excel - A knack for creating clear, comprehensible financial tracking spreadsheets - A good understanding of how to incorporate visual data representation. Your expertise can make a significant difference in our financial oversight and planning, and quality re...

I need a VBA operation to transfer data from my Excel file into a Word document. The data includes tables, charts, and text content. The key requirement is to maintain the original formatting from Excel in the Word document. Ideal skills and experience for the job: - Proficiency in VBA programming - Experience with Excel and Word automation - Attention to detail for formatting consistency - Ability to understand and execute tasks based on specific data types (tables, charts, text content).

...and let you focus on what truly matters? Look no further! I offer a versatile skill set to optimize your daily tasks and special projects: * Microsoft Office Mastery: From creating impactful PowerPoint presentations to analyzing complex data in Excel, I provide tailored solutions for every need. * Creative Canva Design: Bring your ideas to life with attractive and professional designs for social media, presentations, reports, and more. * Swift and Accurate Typing: Transcribe your documents quickly and accurately, saving you time and effort. * Thorough Data Review: Ensure the quality and accuracy of your information with meticulous and detailed review. Additional Benefits: * Flexibility and adaptability to your requirements. * Punctual delivery and adherence to...

I need an Excel sheet to track my child support payments. The primary data points to monitor include payment amounts and dates. Additionally, I need the sheet to calculate and summarize total payments received, as well as providing a monthly and yearly summary. Ideal skills for this project include: - Proficiency in Excel - Ability to create complex formulas - Experience with data tracking and summarization The formatting of the sheet should be in a standard table format, without the need for any color coding or custom headers and footers.

I'm looking for an expert in data visualization to help me code some line charts in my existing spreadsheet. Key Requirements: - Create line charts from existing sheet data. - Implement a dual data selection system: some data will be chosen automatically based on predefined rules, while other data will be manually selected by the user. - Ensure that the charts are complex enough to accurately represent the data while still being user-friendly. Ideal Skills: - Advanced Excel or Google Sheets skills. - Strong coding knowledge, particularly in spreadsheet programming languages. - Experience with data visualization and creating complex charts. - Ability to understand and implement predefined rules for data selection.

I need a freelancer to help me with two tasks. Part 1: I need a complete list of email contacts from a local government website. The data needs to be organized in an Excel spreadsheet, including the names, titles, email addresses and contact numbers (where available). Part 2: Using a provided email address, you will send out 50 emails daily until the entire list is exhausted. Ideal Skills: - Proficiency in data entry and Excel - Experience with email marketing - Attention to detail - Ability to follow instructions precisely Please note, I expect the number of emails to exceed 1000.

I'm looking for a Virtual Assistant who is eager to learn and doesn't need to have any prior experience. This role will primarily focus on organizing files for a medical company, creating documents in Excel or Google Docs/Google Sheets, and assisting with various tasks. Key Responsibilities: - Organizing files categorically - Creating reports, spreadsheets, and presentations Ideal Candidates Will: - Have a basic understanding of Excel and Google Docs/Google Sheets - Be willing to learn and take initiative - Have strong organizational skills

I'm looking for an experienced web scraper to gather data on pendants from the Jewelry Unlimited website. The data should include: - Title and description of the pendants - Price and availability - Images The data should be delivered in an Excel file, categorized by type (e.g., religious, miscellaneous). Ideal Skills: - Proficient in web scraping - Excellent data categorization abilities - Familiarity with Excel Experience with e-commerce data scraping is a plus. Please provide a sample of your previous work if available.

I'm looking for an expert in data visualization to help me code some line charts in my existing spreadsheet. Key Requirements: - Create line charts from existing sheet data. - Implement a dual data selection system: some data will be chosen automatically based on predefined rules, while other data will be manually selected by the user. - Ensure that the charts are complex enough to accurately represent the data while still being user-friendly. Ideal Skills: - Advanced Excel or Google Sheets skills. - Strong coding knowledge, particularly in spreadsheet programming languages. - Experience with data visualization and creating complex charts. - Ability to understand and implement predefined rules for data selection.

...a Windows-compatible web app to automate data entry and web scraping. Key Responsibilities: - Design an interface for data input - Automate data filling into specified fields on the given webpages - Scrape the resulting data into an Excel file (XLSX format) - Ensure subsequent searches add to the database, overwriting previous similar entries Webpages to be used: - - - Data for testing: - ID type: Company - UEN: 614H - Vehicle number: XD9577M - Date: today The ideal candidate should have: - Extensive experience with web scraping and data automation - Proficiency in creating Windows-compatible

See chat for instructions

I'm in need of a proficient data entry specialist, who can handle mixed data types (both text and numerical) from online databases. Key Responsibilities: - Source and collect mixed data from various online databases - Accurately input the data into an Excel spreadsheet Ideal Skills and Experience: - Proficient in Excel and data entry - Experience with online data sourcing - Attention to detail and accuracy

I'm looking to purchase detailed data from all seasons of US Shark Tank. The data should include full texts of conversations between entrepreneurs and investors, as well as all other relevant variables. The ideal format for this data is Excel or CSV files. Key Requirements: - Full transcripts of all Shark Tank discussions - All other pertinent data points from the show - Data delivered in Excel/CSV format Skills and Experience: - Proficiency in data collection and analysis - Familiarity with Shark Tank and understanding of its data - Ability to organize and present data in Excel/CSV files

I'm seeking an experienced data analyst or Excel expert to set up a Weekly Sales and Stock Intake (WSSI) model in Excel. Key Requirements: - The WSSI should incorporate sales data, stock levels, and purchase orders - The model should facilitate data import from CSV files - Prior experience with WSSI or similar forecasting models is highly preferred - Strong Excel skills are mandatory, knowledge of data visualization tools is a plus. Please provide examples of similar projects you have completed in your proposal.

I'm looking for a professional with advanced Excel skills, particularly in using Pivot Tables. I have a dataset related to our sales and I need someone who can analyze this data and generate insights on our monthly sales trends. Ideal Skills: - Extensive experience with Excel, particularly Pivot Tables - Proficiency in data analysis - Ability to derive insights from complex data sets Please provide a quote and a brief overview of your relevant experience. Thank you!

I'm seeking an expert in data mining and lead generation to find email contacts of Purchase Managers of companies ( I have data of the companies in excel format) Requirements : - 1) I have a ready list of name of companies ( 236 entries) 2) Find out email of purchase managers or generic email id from their website or other place on google and make a list of the email ids. The successful freelancer will have the opportunity for ongoing work as I expand my outreach efforts.

I'm looking for an Excel expert to create a complex, formula-driven data entry sheet for our production line planning. Key Requirements: - The sheet should primarily assist in production scheduling. - It must be able to take into account machine availability as a key data input. The machine availability will be tracked through manual entry, so the sheet needs to be user-friendly and intuitive for this purpose. Ideal skills include: - Advanced Excel skills, particularly in creating complex formulas. - Experience in production planning. - Ability to design user-friendly interfaces in Excel. This project will greatly enhance our production efficiency, so I am keen to work with someone with a proven track record in similar projects.

I'm in need of a skilled professional who can assist with extensive Excel data entry and analysis. Key tasks will include: - Data cleaning and organizing: Sorting through large sets of data to ensure accuracy and completeness. - Formulas and calculations: Applying appropriate formulas and performing calculations as necessary. - Creating charts and graphs: Visualizing data in a clear and concise manner. Ideal candidates should have significant experience with Excel, particularly in data entry, cleaning, and analysis. Proficiency in using complex formulas, as well as creating informative charts and graphs, is crucial.

I'm in need of an accountant who can extract specific transaction details from my bank statements and organize them into an Excel spreadsheet. The information is primarily for personal tracking and budgeting. Ideal Skills and Experience: - Proficiency in financial analysis - Experience with bank statement reviews - Excellent Excel skills - Attention to detail Specific Requirements: - The extracted data should only include the transaction descriptions.

I need 4 PDFs containing bank transaction data converted into 4 Excel sheets. All records should be intact and transactions should be structured properly in a standard table format. The Excel sheets should have the same columns as the PDFs. Ideal skills for this job include: - Proficiency in Excel - Experience with data conversion from PDF to Excel - Attention to detail to ensure all records are intact

I have a simple project where I have a labor planning tool that is used for manufacturing tools to collect data and plan their next years labor. See the attached excel file. I would like to use some AI prompts to evalaute the historical data entered and then populate the data input cells on the right side of the excel sheet instead of them being manual entires like they currently are.