Excel vba include external macroprojekty

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...

A CPA needs to perform an Audit and/or a Comprehensive Financial Review. Financials need to be certified. The certification to express his/her findings – “no deficiencies” is what we are seeking once completed. Our small business has a bookkeeper and accountant, but we need an external CPA to provide this report. The audit/financial review does not have to contain any budget or financial information. This report is part of our company's requirement to become an accredited organization. Candidate Must: -Be a CPA -Work in the US

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.

...to future business growth. Target: Marketing & Customer Engagement Technology Replication: Build a custom solution that replicates the core functionality of Metricool and Aiseney. Unified Platform: Integrate both aspects into a single backend system, creating a seamless customer management tool. Custom Enhancements: Add requested adjustments and features that are currently unavailable in the external tools. WhatsApp Optimization: Design a streamlined and efficient WhatsApp management interface, including automation options where appropriate. Additional Considerations Scalability: Design with the future in mind. The system needs to easily handle more branches, users, and transactions as your franchise grows. Training & Support: Plan upfront for comprehensive user traini...

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 ...

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. ...

...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.

We are a Premier Online Coaching Platform, evidence-driven, thriving to build an unbreakable mindset. This is also India's first website that calculates the exact number of calories with detailed macro nutrient distribution for a particular person based on their bio feedback. The website is absolute new, and nothing has been done yet apart from creating the entire thing as of now. There are a few tweaks and updates along with SEO that I need on the website to make it more human, interactive, responsive, fast & user friendly both in terms of desktop and mobile. These are the detailed requirements as of now: 1. Forms, Thank You pages upon submitting forms, making purchases and email responses. 2. Replace contact button from the home page and menu with a simple white band

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...

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 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.

Confectionner unemodélisation financière d'un projet immobilier sur excel

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...

...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 complex sales data into an easily navigable and comprehensible forma...

I'm in need of a tech-savvy individual to 1. Set up a subdomain for our WIX website 2. Redirect the sub-domain permanently to an external website Current Website - Subdomain to create - Link subdomain to external site -

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...

I am looking for a freelancer to creating a custom carrier board that is specifically designed for Raspberry Pi Compute Module 4. Features: - It should include an Ethernet - Type-C USB port power power. - We're also looking at equipping it with a 4G mobile module (SIM7600 or equivalent that work in Australia/Telstra). - 1 X Sim slot. - 2 X External antenna connectors SMA - 1 X Power LED for CM4 - 1 X Activity LED for CM4 - 1 X Multicolour LED for signal strength of mobile module. - The carrier board should be made as small as possible. Skills and experience: - Freelancers interested need proficiency in electronics and PCB design, along with a deep understanding of Raspberry Pi Compute Module 4. Experience in custom carrier board design and SIM7600 or ...

...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 need the drawings of a house redone for a project I am working on, they won’t be built, so they are purely fictional, they are attached to the project and need to be redone in CAD or hand-drawn or another professional construction drawing tool. produce a portfolio of high-quality, fully annotated...project I am working on, they won’t be built, so they are purely fictional, they are attached to the project and need to be redone in CAD or hand-drawn or another professional construction drawing tool. produce a portfolio of high-quality, fully annotated 2D freehand sketches or digitally drawn of the exterior of a two-storey building to help the client for the project understand and visualise the external appearance of the building. Just redraw the pictures already attach...

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...

...Content Length: Articles should be between 3000 to 4500 words in length to provide comprehensive coverage of the topic while maintaining reader engagement. Longer articles may be warranted for complex topics requiring in-depth analysis and discussion. Internal and External Linking: Include relevant internal links to other pages on the website to improve navigation and promote deeper engagement. Incorporate authoritative external links to reputable sources to enhance credibility and provide additional context. Image Optimization: Include relevant images, infographics, and visuals to supplement the text and enhance the reader experience. Optimize image file names, alt tags, and descriptions with appropriate keywords to improve accessibility and SEO. SEO Tools a...

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

Proszę, Zarejestruj się lub Zaloguj, żeby zobaczyć szczegóły.

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.

...retailers and online marketplaces in Australia. Some of these Australian websites/competitors include: - - - - - There is also a similar competitor called , that gets the prices of thousands of retailers across australia and displays it to the customer. If we can see how they are achieving this or tap into that data, that will add to this perfectly. if possible, we also need to collect data from the bigger marketplace giants such as , facebook marketplace (AU) and even amazon. If not possible, we can discuss getting data through external API tools such as or The end goal for collecting this data is to input

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

I'm searching for a freelancer with solid experience and in-depth knowledge about real estate excel modelling. I need an Australian-based freelancer who has real estate experience. We have existing excel models that with the recent departure of our CFO, need someone to drive them while we find a replacement. The inputs will be provided by the project team and a hand over with the person who built the model is also possible if needed. Whats required is someone to ensure the models are used correctly. There is both a project specific model used for analysing whether a particular feasibility meets our hurdle rates along with a fund model that rolls multiple projects together along the operation of the manager. We primarily need the freelancer to input the data and...

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...

...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 eye for accuracy Applications: - Please include details of your past work experience. Showcasing relevant p...

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.

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...

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...

...Menu: Patients can submit detailed treatment requests if none exist already. Chat Menu: Direct messaging with the doctor. 3. Staff Backend: Dashboard Menu: Overview of appointments, prescription requests, treatment requests, patient messages, and unpaid invoices. Appointments Menu: Manage and view all appointments in a list or calendar view, with functionalities to book and integrate with external video consultation platforms. Prescriptions Menu: Manage prescriptions, including creating new ones, updating existing ones, and automated PDF generation for emailing to patients. Patients Menu: Detailed view of patient profiles, including medical data and interactions, with options to edit or deactivate accounts. History Entries Menu: Create and view detailed medical history e...

...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 complex sales data into an easily navigable and comprehensible forma...

I'm seeking an architect with a flair for traditional styles to help with the design of a residential project. Key Responsibilities: - Construction planning and design - Drafting traditional architectural designs - Collaborating on potential modifications Ideal Candidate: - Proven experience in residential architecture - Strong portfolio in traditional design styles - Excellent problem-solving skills Please note, the client has not stated preferences for specific elements such as an open floor plan or large windows. Applicants are free to make suggestions based on their own expertise and understanding of traditional residential designs.

Proszę, Zarejestruj się lub Zaloguj, żeby zobaczyć szczegóły.