Excel vba databaseemplois

I am looking for an Excel expert who can help me create a dynamic and visually appealing Trend chart that can effectively communicate data composition over time. Key Requirements: - The chart must be able to clearly represent data changes over a period of time, showcasing the shifting proportions of different components. - The data for the chart will be provided in an Excel file. The freelancer will need to effectively structure this data to make it compatible for chart creation. - The chart should be designed with the latest Excel standards to ensure compatibility and ease of use. Ideal Candidate: - Strong proficiency in Excel, with a focus on chart creation. - Experience in creating dynamic and interactive charts in Excel. - Ability to understand and...

I'm currently working on a financial analysis project through Microsoft Excel and require assistance with data structuring specifically for pivot tables. I aim to feed this data into a comprehensive dashboard. The Excel spreadsheet encompasses multiple periods of financial data. Key Aspects: - Data included in the pivot tables are dates of financial periods, types of financial information, and identifiers such as multiple General Ledger accounts, categories and subcategories. - The task involves transforming this spreadsheet data into an appropriate format suitable for creating a pivot table and consequent dashboard. Skills and Experience: - Proficiency in Microsoft Excel, particularly in the handling of complex data and pivot tables. - Experience in financial...

I require a Power Bi expert to assist with transferring and analyzing our sales data, currently stored in a spreadsheet format (CSV, Excel). The main element I need to focus on within the analysis is the sales trends over time. The ideal candidate would have: - Strong skills in data transfer and analysis in Power BI - Experience dealing with sales data - A keen eye to identify and present trends over time effectively. To confirm, your task will involve: - Transferring sales data from a CSV/Excel file to Power BI - Conducting detailed analysis focusing on sales trends over time - Presenting these findings in a useful and understandable format.

I need help with Excel It is advance level so please be careful when you apply. Thanks.

Cuento con datos operacionales en Excel de mi trabajo, y necesito transformar esa data a dashboards y procesar data en un ambiente web. I have operational data in Excel from my work, and I need to transform that data into dashboards and process data in a web environment.

I am seeking a talented developer who specializes in BioTime database development. The database will primarily be used as an attendance system for my staff. Key Functionalities: - Data Entry and Retrieval: You will implement mechanisms to input and retrieve staff attendance records. Data to be Managed: - Staff Attendance Records: The system should capture and store staff's check-in times, check-out times, and leave entries. Ideal Skills and Experience: - Proficiency in working with BioTime databases. - Demonstrable experience in building data entry and retrieval functionalities. - Prior projects dealing with attendance systems or related fields will be a significant plus.

Extract the industry data from the IBIS reports and populate the Excel template

I need an Excel sheet that will empower me to manage my call center effectively by providing me with real-time insights into the number of agents needed per hour. Key Requirements: - The sheet should offer a graphical representation of the data, enabling me to quickly understand the changes in agent demand. - It must calculate and display the total call duration per agent,hourly agent demand, and the average wait time for callers. Data should be updated on a daily basis to ensure the most current and accurate information is available. Ideal Skills: - Proficiency in Excel and ability to create dynamic tables and graphs. - Experience in designing forecasting models would be a plus. - Strong understanding of call center operations and key metrics. The ideal freelancer ...

...inventory database simultaneously and check items out (never in) while recording user ID# and department needing the inventory. - Email Reports: Generate and send end-of-day reports using O365 account(s), from two devices used to scan items. - Easy Database Edits: Ensure the end users at the department level can easily make necessary edits to the inventory database. Dataset is roughly 900 items recording the item name (description), Item Number 7 digits, the cost of the item. Dataset can live in excel or access preferably I'm looking for a programmer with experience in developing Windows applications, particularly inventory management systems. It's essential that the program is intuitive and streamlined for easy use by multiple team members. Fami...

I have a Power BI file that is insanely slow and unusable. It has some glitch that has drastically slowed it down and cannot be resoled. So I need this file to be recreated in a superfast and fully efficient Excel by using formulas and VBA codes. More details to be share with winner.

I need a skilled Excel specialist to handle the automation of tasks in my daily-updated Excel file. Key Responsibilities: - Develop basic macros to automate tasks: I need macros to simplify and speed up the daily operations in the Excel file. Ideal Skills and Experience: - Proficiency in Excel: You should be very familiar with Excel tools and functions, especially in the area of macro creation. - Experience in automation: Previous experience in automating tasks in Excel, especially on a daily basis, would be highly beneficial. - Detail-oriented: The tasks are basic but they need to be carried out consistently and accurately on a daily basis. - Time management: You should be able to create a system that keeps up with the daily updates. I am o...

...and my sample resume and you have to tailor it according to the role. It should be ATS-friendly and should have a score of a minimum of 85 % in resume worded. I have ready chatbot prompt to make your task easier so that each application resume will take less than 10 minutes. I just need the resume and its score's screenshot, I will add the job link in an Excel sheet so that it is organized properly. You will add resume's link in the same excel sheet, you could upload resume in folders on google drive. Is this task doable for you? Below is a sample job description -: "Position: Site Reliability/Observability Engineer (SREs). Location: Johnston, RI or Phoenix, AZ (4 - 5 days onsite). Duration: FTE Objectives of this role: Run the production environment ...

I am seeking a VBA developer to help with my Excel automation tasks and creating a set of macros. Key Requirements: Need to extract data from pdf in a way which I want - The primary task involves the automation of Excel processes. - The developer is expected to create macros that will streamline and simplify certain operations within the Excel sheets. - The primary automation requirement is extracting data from different types of PDF documents. Further Details: - The VBA developer should be able to extract data from text-based PDFs, scanned PDFs, and password-protected PDFs. - The extracted data needs to be accurately transferred to Excel. Ideal Skills: - Proficient in VBA and Excel; - Experience with data extraction from differe...

I'm in need of a freelancer who is proficient in Tally ERP9, particularly the Silver Edition and Excel. The task involves specifically handling bank transactions. Key Responsibilities: - Transcribing bank transactions into Tally ERP9 Silver Edition - Organizing and managing the data accurately in Excel - Ensuring all data is updated in a timely and accurate manner Ideal Freelancer: - Proficient in Tally ERP9 Silver Edition - Strong experience in data entry - Skilled in Excel, particularly in data organization - Detail-oriented and accurate in data management Communication: I prefer updates and feedback to be sent via email. Clear communication and prompt responses are highly valuable to me.

...excessively time-consuming. We require a more efficient algorithm to enhance the speed and effectiveness of these exact match lookups. Project Objectives: Develop a Python script that can perform exact match lookups quickly and accurately. Ensure the integrity and accuracy of the lookups to maintain database cleanliness. Key Requirements: Efficiency: The algorithm must reduce the time complexity compared to the current linear search approach. Accuracy: As the script is intended for database cleaning, the precision of matching cannot be compromised. Ideal Candidate Profile: Proficient in Python, with a strong background in data processing and text analysis. Experience with efficient data search algorithms and possibly with text matching techniques. Ability to write clean...

As a WordPress expert with a deep understanding in PHP and AI programming, I'm looking to give my website a much-needed overhaul. What's urgently needed are: - An enhanced user interface to improve the overall aesthetics and user experience....times - A user feedback analysis mechanism to address customer grievances - Food image recognition to classify food items accurately - Recipe Generation for unique cooking ideas - Predictive inventory management to avoid food wastage - Nutritional analysis for healthier meal choices - Personalized recommendations to provide a unique user experience. Freelancers bidding on this project should excel in WordPress, PHP development and AI programming, with a proven portfolio in building complex websites with excellent UX and int...

The process is Visit Search for: Drainage companies Glazing repair Boiler repairs in London Open a google sheet and write the following in the sheet: Company name Website Officers name Establish the limited company name and visit Type in the company name and then go to officers and type the name of the officee on the spread sheet. Visit the website and go to the contact us page. Fill out the contact us page Name: Chris Number: Email Message: Hello (enter the name of the officer) I am the CEO of and I came across your business, we are an AI company for trades people and we are looking for a partner we can offer our Job booking AI tool to for free for a month, please can you send me your email and I will send over details for your review.

I'm in need of a freelancer who is proficient in Tally ERP9, particularly the Silver Edition and Excel. The task involves specifically handling bank transactions. Key Responsibilities: - Transcribing bank transactions into Tally ERP9 Silver Edition - Organizing and managing the data accurately in Excel - Ensuring all data is updated in a timely and accurate manner Ideal Freelancer: - Proficient in Tally ERP9 Silver Edition - Strong experience in data entry - Skilled in Excel, particularly in data organization - Detail-oriented and accurate in data management Communication: I prefer updates and feedback to be sent via email. Clear communication and prompt responses are highly valuable to me.

Presupuesto 9 dólares Realizar una hoja de calculo que me arroje el puntaje y la posicion de una oferta respecto a las otras deacuerdo a unas formulas que asignan puntaje deacuerdo al valor que oferten

I'm in need of a comprehensive Excel workshop system that can handle all the necessary features, including open job cards, inventory templates, dashboards, bills, estimations, and work orders. Here's what I'm looking for: - **Open Job Cards:** The system should be equipped with a section for open job cards where I can easily manage and keep track of ongoing tasks. - **Inventory Management:** I prefer a manual entry for inventory items. The system should facilitate the creation and maintenance of inventory templates in an easy and efficient manner. - **Dashboards:** The dashboards should be highly customizable and provide me with a detailed overview of all the key metrics that I need to monitor regularly. The level of customization should be advanced, allowing me ...

I need a capable hand to create an AI tool for an Android game that's similar to Subway Surfers. This tool should be built to perform at an intermediate level, hence, it shouldn't struggle with achieving basic tasks but doesn't have to excel at the hardest ones. The ideal freelancer for this job should have experience a deep understanding of artificial intelligence. Key Requirements: - AI Character Movement: The tool must automate the character's movements throughout the game. - Collecting Power-Ups: The AI tool should be clever enough to identify and collect power-ups. - Dodging Obstacles: It is essential that the tool ensures the character constantly avoids obstacles to prolong gameplay. Please note, it's crucial that the tool works seamlessly on Andr...

financial modeling of a project real estate with excel

Tenho em base de dados a localização de imóveis (POLYGON) - com vários pontos de coordenadas. Pretendo efetuar zonamentos e associar um valor para a localização destes imóveis que tenho em base de dados para posteriormente trabalhar números em folha de excel.

I'm looking for an expert in data scraping to effectively extract text data from online databases. Primarily, I am interested in customer details. This data will be pivotal to my operations. Key tasks include but are not limited to: - Extracting textual data from specified online databases - Focusing on customer details during extraction - Organizing the extracted data in an easily accessible format The ideal candidate is proficient in data scraping and has a deep understanding of online databases. Proficiency in using tools and scripts for scraping is necessary. Previous experience with customer data extraction will be a plus. A rigid approach to data privacy and ethical scraping standards is imperative. Accuracy, efficiency, and detail-orientation are crucial skills for this posi...

I require a skilled native Japanese transcriber to convert my audio recordings to text format. The nature of these audio files primarily involves conversations, and the sound quality is high with minimal background noise. To excel in this task, you should: - Have proficiency in Japanese language and transcription techniques. - Be capable of identifying different speakers during the conversations. - Ensure all transcriptions are returned with excellent grammar and spelling. Preferably, you'll have experience with transcription software and can provide evidence of your skills and experience in such projects. Your attention to detail and commitment to the agreed timelines will be paramount in this engagement.

I'm looking for a skilled German translator to translate a large volume of content from English to German. The content is related to accounting and POS software. The source material is in Excel format and contains over 10,000 words. Ideal Skills and Expertise: - Fluent in both English and German - Proven experience in translation, particularly related to technical or software content - Proficient in working with Excel files Please note that the translation must be accurate and precise to ensure that the technical terms are properly translated. Your familiarity with accounting and POS software terminology is highly desirable. The software is up to 90% translated, we need translator for correction and addition.

...following are the steps:- a) Excel file containing Product url list of about 300 products, all from the same website b) We should be able to run a macro etc, which we need to do multiple times daily c) When we run the script, it should check if for all those 300 products, there is a MSRP pricing appearing on the website d) The products have many variations, so it should check for all the varitions e) It should create each variation entry into a seperate column and highlight that product as a variation f) If any variation does not have MSRP price appear, then it should highlight that G) If the MSRP is appearing for variation, then it should fetch and enter that number. It is very easy and simple work. Bid only if you can do within next 24 hours. See the attached excel fil...

I am seeking a skilled Freelancer to develop a comprehensive sales dashboard on Excel. The purpose of this project is to streamline our sales data for easy comparison and analysis on a daily, monthly, and quarterly basis. Key Features Required: - The ability to compare daily sales with last day's and last year's sales. - Monitor monthly actual vs budget vs last year. - Track quarterly sales performance. - Special attention should be given to the revenue growth metric. Ideal Experience and Skills: - Excel mastery - Proven experience in creating interactive dashboards - Knowledge in sales data analysis - Ability to create a user-friendly interface where data can be manually input efficiently and effectively Your role will heavily involve the organization of comp...

I'm in need of a skilled branding professional ...versions can be used. - Typography Guidelines: Detailed information about the fonts and typography style that should be used in all our communications. - Merch Guides: Design suggestions and guidelines for any promotional or merchandise items that we may produce. - Store Design: Guidance on the color scheme, logo placement, and overall aesthetic that should be maintained in our physical store. To excel in this project, you should have a proven track record of creating brand guidelines. Proficiency in graphic design, branding, and an understanding of the pet grooming industry would be advantageous. Your work should be detailed, professional, and easy to understand. A great attention to detail and a strong sense of creativity are...

...professional who can set up an Azure data storage account to store Excel data, particularly with the following key features in mind: - **Data Type and Source**: The data I'm working with is primarily Excel based, so having experience with managing structured data storage in Azure is a must. - **Frequency of Updates**: The data will be updated on a weekly basis, so the storage solution needs to seamlessly accommodate this. - **Purpose of Storage**: The primary purpose of storing this data in Azure is for data analysis. While not the only use, ensuring that the storage solution allows for easy and efficient data analysis is crucial. The ideal candidate should have prior experience with Azure data storage, particularly in managing Excel data, and should be a...

I'm looking for an experienced backend developer to handle database management and API integration for my project. Key Responsibilities: - Implement and manage a MySQL database efficiently. - Develop and integrate APIs to ensure seamless communication between front-end and database. Ideal Skills: - Proficiency in MySQL is a must. - Strong experience in API integration. Experience with other databases and backend technologies like Python, Java, and Node.js would be a plus. The chosen freelancer will need to understand the project's requirements thoroughly and communicate effectively with the front-end team to ensure a well-functioning, reliable backend system.

I am launching a new enterprise and require an expert in OCR technology to design a program for me. The main function of this program would be to detect and digitize human handwriting from forms, consolidating that information into an Excel sheet. There would be a subsequent function for field extraction to compile a final report. - Desired Skills and Experience: • Proficiency in OCR technology for handwriting detection • Experience in custom software development • Excel programming expertise for auto-consolidation of data • Knowledge of report generation mechanisms within software Successful execution of this task would drastically streamline data processing in my start-up. To increase accuracy, the OCR program needs to be trainable, in order to reco...

I have a simple flowchart in Excel that I need converted to DrawIO format. The purpose of this flowchart is for internal ISO 9001 documentation , so it needs to be clear, easy to understand, and look somewhat formal, so Font style and Color scheme should be appropriately chosen. I'm looking for a freelancer with experience in graphic design, particularly flowchart creation and DrawIO, who can give this flowchart a clean, professional look. The excell file will be provided to you, so you can copy/paste the text. I do not expect you to change the content. There might be additional flowcharts in the future, so potentially repeat business. When bidding, let me know whether or not you have experience with ISO documentation drafting, which might be a plus.

I'm requiring assistance with a meticulous task of transferring text data from a website. The data on the site is neatly arra...requiring assistance with a meticulous task of transferring text data from a website. The data on the site is neatly arrayed in table format, and I need someone to manually sift through and copy the specific fields of 'Name', 'Date', and 'Description' into an Excel file. Ideal candidate would have: - Excellent attention to detail - Proven experience with manual data entry - Proficient in Excel - Understanding of structured web content This task requires patience, a keen eye for detail, and expertise in transforming web data into organized Excel entries. Interested freelancers need to commit to high level...

I am looking for Excel experts who can assist me with creating formulas and functions within a week. I have wholesale mobile shop. I want excel works for example desboard in one sheets and custumer sheets which contain debit credit ,describtion and total amount one more important all costumer name on desboard and if debit or credit amount also show on desboard please also look for attect excel file

I require an expert in Excel financial calculations to design a spreadsheet to calculate commission on sales. The main purpose is to drive commission payments based on a tiered structure. It will be used to manage commission payments linked to sales figures above a specified target. Ideal Skills: - Extensive experience in Excel spreadsheet design, particularly with financial calculations - Experience in tiered commission structure calculations - Strong understanding of financial data management. Responsibilities: - Design and implement Excel spreadsheet for commission calculations - Ensure accuracy of calculations based on the tiered commission structure.

Hi Ishaq. Can you have a look at this app for us. We want to convert it from a commend line batch file to a GUI app in Python. We had one of our team build the app in C# a few years ago, but he has left and we have the source code. The app will extract an image from an excel spread sheet based on the column ref and put the image into a nominated directory with the imaged named as per another column in the source excel spreadsheet. I can send yu a full demo of the app. regards Rob

Buatkan saya kalkulator sederhana untuk menghitung jumlah keb...yang digunakan berbasis android tanpa menggunakan jaringan untuk menunjang wilayah kebun yang sulit sinyal. Konsep dari aplikasi tersebut yaitu user tinggal memasukan jumlah pohon(SPH) untuk mengetahui berapa jumlah untilan yang dibutuhkan pada setiap lahan. jadi aplikasi otomatis akan menghitung berdasarkan rumus dosis yang diinginkan. Pada lampiran sudah saya berikan gambaran aplikasinya dengan excel. Apabila nilai SPH diubah otomatis jumlah untilan besar dan kecilnya akan menyesuaikan. untilan kecil sediri merupakan nilai desimal dari untilan besar yang dihitung ulang dengan rumus lainnya sesuai dosis. Nilai desimal tersebut apabila kurang dari 7, tapi apabila bernilai 7 atau lebih maka jumlah untilan besar dibulatka...

...and detail-oriented individual to conduct targeted web research. The task involves searching a specific website, using geolocation as the primary criterion, and collating the data of various companies into the excel spreadsheet I will provide. Key Tasks: - Browse the provided website and search explicitly based on geolocation. - The geolocations of interest are predetermined and are stated within my excel sheet. Data Collection: - Oddly, I do not require some common fields like company name, address, or phone number. - Ensure accuracy and completeness of data collated into the excel spreadsheet. Ideal Skills and Experience: - Proficiency in advanced web research and data entry. - Working knowledge of geolocation-based search - Attention to detail and a keen ey...

I'm in need of a skilled data entry specialist, specifically someone with experience in Excel and online data entry. Key Project Details: - The task at hand is small and involves less than 100 records, so the workload is manageable. - Primarily, I'm looking for someone who can analyze the data rather than just inputting it. Ideal Skills: - Proficiency in Excel and online data entry tools. - Strong analytical capabilities. - Previous experience with similar, small-scale data entry projects would be an advantage. I'm eager to work with a diligent, detail-oriented freelancer who can ensure that the data is accurately inputted and analyzed.

Project Title: Radiologist Database Creation for Victoria, Australia Project Description: I am looking for a skilled and creative freelancer to compile a comprehensive list of all radiologists currently working in Victoria, Australia. The goal is to create a detailed database that includes their names, contact information, and relevant professional details. Requirements: Research and Data Collection: The freelancer should be proficient in online research and data scraping. Identify reputable sources, databases, and directories where radiologist information can be found. Collect accurate and up-to-date details for each radiologist. Data Fields: Full Name Clinic/Hospital Name Clinic Address Phone Number Email Address (if available) Specialization (e.g., diagnostic radiolog...

I'm in need of an Excel expert to meticulously update the product descriptions and prices in my catalog. The requirements include: - Updating: You'll be tasked with updating the product descriptions with new information and ensuring all the prices are current. - Catalog Size: The catalog comprises over 500 products, so attention to detail and ability to handle large volumes of data is crucial. - Formatting: Special formatting is not required, the new product descriptions and prices need to be consistent with the existing entries. Ideal Skills & Experience: - Proficiency in Excel: Successful candidates should have a high level of understanding and experience with Excel, particularly handling large datasets and using formulas. - Attention to Detail: Given...

Hello, I am looking for an experienced MS Excel programmer to enhance and automate an existing Excel spreadsheet. The primary goal is to streamline the workflow by automating calculations and consolidating rows based on unique identifiers. Project Objectives: Automate complex calculations to increase efficiency. Consolidate multiple rows based on specific unique identifiers. Ensure data integrity and accuracy throughout the spreadsheet. Requirements: Proven experience with advanced Excel functions, including macros and VBA. Ability to troubleshoot and optimize existing Excel formulas. Strong attention to detail and a commitment to delivering precise and reliable results. Please provide your rates, availability, and examples of similar projects you hav...

I am seeking a skilled Freelancer to develop a comprehensive sales dashboard on Excel. The purpose of this project is to streamline our sales data for easy comparison and analysis on a daily, monthly, and quarterly basis. Key Features Required: - The ability to compare daily sales with last day's and last year's sales. - Monitor monthly actual vs budget vs last year. - Track quarterly sales performance. - Special attention should be given to the revenue growth metric. Ideal Experience and Skills: - Excel mastery - Proven experience in creating interactive dashboards - Knowledge in sales data analysis - Ability to create a user-friendly interface where data can be manually input efficiently and effectively Your role will heavily involve the organization of comp...

I'm building a site in Oxygen with Advanced Custom Fields. I have created a custom post type with several different categories. I have then also created a custom archive template using a repeatable element. However, I can't get the archive template to display just the posts in the relevant categories. When I go to the front end categories, they either display nothing or all of them.

data entry (copy EAN code, SKU, and size) from label /image 2.300 label /image to Excel spreadsheet / google sheet file.

VBA EXCEL Bulk SMS Template

I need a detailed Microsoft Excel spreadsheet that tracks expenses related to Hurricane Ian and deducts them from my current house appraisal. Key aspects of the project: - **Expense Tracking**: The spreadsheet should offer a detailed list of expenses. These should be categorized (e.g. repairs, replacements, labor). - **Formula Integration**: It should also include formulas that automatically calculate the sum of these expenses. Ideal Candidate: - Proficient in Microsoft Excel - Experience creating detailed expense tracking sheets - Familiarity with property appraisal processes and calculations Please submit examples of similar spreadsheets you've created in the past.

Se necesita personal para delegar tareas sencillas administrativas: manejar email, hacer llamadas para informar a clientes (no ventas), y otras tareas típicas de secretariado. Tendrás una persona contigo dándote el training así como módulos de aprendizaje de tus tareas. 1. Manejo de Office (Outlook, Excel y Word). Indicar si sabes usar y configurar cuentas en MS Outlook. 2. Horario compatible con España - GMT+1 (tienes que tener disponibilidad desde las 12 en la mañana) 3. Voz agradable, simpática. De atención al cliente. 4. Indicar experiencia en redes sociales, cuales tienes y qué has hecho con ellas ¿solo uso personal o para alguna empresa? 5. ¿Qué resultados lograste en términos d...

I am looking for someone to help me create a comprehensive database of art galleries in Dallas, Texas. This will be used for market research purposes. Key Requirements: - The database should include the names, phone numbers, and email addresses of the art galleries. - For each entry, I also need the street address, city, state, and zip code to be included. Ideal Skills and Experience: - Prior experience in data collection and database creation would be highly valued. - Strong attention to detail is crucial to ensure accurate and complete information. - Familiarity with art-related databases would be a definite plus. The end goal is to have a well-organized, accurate and comprehensive database that can be used effectively for market research purposes.