Excel vba and macros courseKazi
Neme Deepak kumar s/o bhagwan das vill saraiya bhood post araul kanpur nagar
i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want d...
hi hi hi hi hi hi h h h h h h h h h h h h h h h h h h h h h a sakjsa ;ls dsaj slk s sdskssd sj skskl
...need digitized and transformed into an Excel spreadsheet. The document consists of approximately 238 pages, and I require the following: - Organization: Calls, texts, and data should be separated into distinct columns in the spreadsheet. - Data Layout: The information should be laid out in an ordered manner which we will discuss further. Additional requirements include: - Calculations: The Excel sheet should include specific calculations like total call duration and data used. - Data Fields: The "To/From", "City", and "Time" fields should be organized in distinct columns within the spreadsheet. Ideally, I'm looking for a freelancer with: - Proficiency in PDF to Excel conversion. - Strong organ...
I require an experienced and proficient VBA developer to create a code that automates data entry tasks in Microsoft Excel. The main objective is to significantly increase productivity and ensure accuracy by automating repetitive data entry procedures. Ideal skills would include: - Vast knowledge of VBA and Excel - Prior experience in developing automation scripts - Exceptional attention to detail - Ability to work within strict deadlines
I'm in need of a seasoned Excel expert who's proficient at conducting optimization analysis to solve a real-world problem. Key Requirements: - Profound understanding of optimization analysis - Ability to work efficiently and quickly - Experience with diverse Excel functions Please note that the specific goal of the optimization analysis requires maximizing profits, minimizing costs, or optimizing resource allocation. Your expertise in this area will be crucial to our success.
I need an expert to convert tables from a PDF file into an Excel spreadsheet. The job involves transferring text and numbers from a multi-page PDF table to an Excel document. I have attached the PDF. The analysis should start from page 7. Here's what the project entails: - Converting data from a PDF table that includes both text and numbers - Handling tables that span across multiple pages in the PDF - Transferring the data to Excel without any need for specific formatting or layout changes - Provide the developed script used to obtain the records from the tables. As a freelancer, you should have: - Proficiency in PDF to Excel data conversion - Ability to work with complex table structures - Attention to detail to ensure accurate transfer of...
I need to modify a website and create additional pages. You have experience and knowledge in it, and of course it will be compatible with all screens and different browsers.
**Contest: Excel Specialist Wanted for Comprehensive Property Portfolio Management Tool!** Are you an Excel virtuoso with a passion for crafting intricate and comprehensive spreadsheets? We're embarking on a quest to develop the of a cutting-edge Property Portfolio & Financial position Management Tool for our discerning clients. If you possess the expertise to meticulously organize data, create advanced formulas, and design visually captivating presentations, this contest is tailored for you! Join us in revolutionizing property portfolio management with a document that sets the standard for clarity, accuracy, and usability. I would like to be able to edit if required in the future therefore 2 copies will be required. 1 being password and ...
Hi Md Zoherul I.,I need 26 signs made. 18 hole just like a golf course. 12"x18" I will send you the old signs to use to create newer version signs. I will need these in vector format.
I need a software expert to develop a program that scrapes text content off of multiple websites and then cross-references this data against another site. Key Requirements: - The software should effectively pull out text content from all provided sites. - The text content should be in a plain text format, ready for easy analysis and interpretation, preferably in an excel spreadsheet or comma delimited list. - The cross-referencing component is crucial, as the software will need to compare the data scraped with that of another website. Qualifications: - Background in Data Scraping and Software Development. - Previous experience with cross-referencing data. - Proficiency in handling different data formats. In essence, I'm looking for someone who can crea...
I'm looking for an experienced videographer to shoot 10-20 videos for my online course. All footage will be raw, with no editing required. Editing could also be included if you possess that skill. Key requirements: - Experience with online course video production - Ability to shoot high-quality videos - Reliable and timeline-oriented Please share examples of your previous work.
I am looking for someone skilled in Microsoft Excel and Power Automate. This task involves creating an automation system that sends emails to our internal team members based on given triggers. The automation should trigger when: - An event's start date is approaching - An event's deadline is nearing The email content should serve as a reminder of the approaching start dates. It's pivotal that the chosen freelancer can work with accurate detail to ensure that no deadlines are missed. A deep understanding of Excel, or similar spreadsheet software, automation, and email systems is required for this task. Experience working with scheduling and deadline tracking will be an advantage.
I require an expert in Excel to help me with a statistical analysis of my sales data. The key tasks for this project are: - Conducting statistical analysis: I need you to run a detailed statistical analysis on my sales data. This will involve using advanced Excel functions to analyze variables such as sales trends, forecasts, and correlations. The ideal candidate for this project should have: - Proficiency in Excel: The chosen freelancer should have a deep understanding of Excel and be skilled in using advanced functions. - Statistical Analysis Expertise: Experience in statistical analysis is crucial, as you will be required to interpret the data and provide insights. - Attention to Detail: The work involves handling a large amount of da...
Geo-Target Report for Reston National Golf Course Geographic Distribution of Customers Local Area Analysis: Breakdown of customers within a 10-mile radius. Analysis of nearby neighborhoods and communities. Heatmap visualization showing customer density. Regional Analysis: Breakdown of customers within a 50-mile radius. Analysis of major towns and cities contributing to the customer base. Heatmap visualization showing customer density. Sample Visualizations Heatmap of Customer Distribution: Shows areas with the highest concentration of customers. Bar Chart of Top 10 Cities/Towns: Displays the cities/towns with the most customers. Pie Chart of Customer Age Groups: Illustrates the distribution of customers by age group. Map of National Customer Reach: Highlights the state...
...improve the existing features of an Excel macro, focusing on enhancing the user interface and experience. Key points: - The primary goal is to make the macro more user-friendly, interactive, and provide better feedback to users. Ideal skills: - Advanced Excel Skills - VBA and Macro Programming - Strong UI/UX design capabilities - User Feedback Integration Please bid if you have experience in enhancing Excel macros in a user-friendly manner and can improve the UI/UX by adding interactivity and feedback. I have a macro working fine. We need 3 improvements: 1- Label photos as A, B and C / 1, 2 and 3 then macro relabel photos per photo matrix 2- Instead to use “SN” in the folder name I want...
...skilled freelancer who can help automate various tasks in Excel. This includes, but is not limited to, data entry, formulas, and calculations. Key responsibilities: - Automating data entry processes within Excel - Implementing advanced formulas and calculations to streamline calculations - Generating reports and carrying out data analysis using Excel - Ensuring the accuracy and integrity of automated processes Ideal skills and experience: - Proven experience in automating tasks in Excel - Advanced knowledge of Excel functions and formulas - Ability to understand complex data sets and create accurate reports In your application, I'd like to see: - Examples of similar projects you've worked on...
I am see...data entry, particularly in the tasks of document conversion, data processing, and data verification. This role necessitates the management of confidential and sensitive information, hence, a demonstrated respect and understanding for data privacy is paramount. Key Responsibilities: • Document conversion • Data processing • Data verification Required Skills and Experience: • Proficient with MS Excel • Demonstrated experience in similar roles handling sensitive data • Strong attention to detail • Respect for privacy and confidentiality Note: Familiarity and experience with utilizing formulas and pivot tables within Excel are highly desirable, given the nature of tasks to be perf...
I need assistance with copying & pasting data from spreadsheets. The dataset is less than 1,000 entries. Ideal skills and experience for this job: - Experience with data entry, especially from spreadsheets - Attention to detail - Proficiency in Excel - Ability to meet deadlines It's a straightforward task. The goal is to ensure the data is accurately copied and pasted.
I need an experienced Excel programmer to automate repetitive tasks and create custom VBA macros for my project. This assignment requires basic level tasks, so extensive experience in complex macros isn't necessary. Here is what I expect: - Automation of several repetitive tasks to streamline workflow and increase productivity - Creation of custom VBA macros from scratch Ideal Candidate: - Extensive experience with Excel automation and VBA macros - Ability to comprehend and successfully complete basic level assignments - High attention to detail and accuracy Please include your Excel automation and VBA macros experiences in your application. I look forward ...
I need some one to clean a file that has names and addresses The field with the name has business names and first and last name combined. I need them separate. Also some time there are two name or a last name and then the first name of a husband and the first name of the wife I need all that in separate fields See attached sample
...form so that visitors can get in touch with me easily. - Image Gallery: to show those with skill sets work, and previous projects Completed - Matchmaking for Skill Set/Hiring: This is a unique feature I'm looking for. I need a mechanism that can match the skills of my members with the needs of other members - Training Area: This will be different from a standard blog. I want to provide a platform for training resources where members can obtain free simple training videos or blogs to refer to as a member, or for a price depending on level of training, be may he’d with a trainer for a course. Must provide to access and charge a service fee for both the trainer providing the service and the trainer if not in the free area A section to upload short v...
...experienced Excel wizard capable of making my inventory report more dynamic and adaptable. Here's what I need: - Total Calculations: The report doesn't currently update the total inventory count and monetary value when I adjust the count of individual items. I require this to be automated so the totals are accurately recalculated whenever an inventory count changes. - Regular Updates: Going forward, I will be regularly updating inventory counts on a weekly basis. I would appreciate if the system is simplistic and user-friendly for regular updates. Ideal Freelancer Skills: - Advanced knowledge of Excel functionalities - Experience on inventory management systems - Meticulous attention to detail - Ability to create user-friendly systems. T...
I'm looking for a skilled engineer who can design a self-supported steel chimney for a metal manufacturing plant. This chimney will be integral to industrial emissions control. Tasks Include: - Tailoring the design to accommodate the specific needs of a metal-manufacturing environment. - Incorporating robust safety features and compliances for high-temperature metal emissions. Ideal skills: - Structural Engineering - Industrial Design - Knowledge of industrial emissions standards - Experience with metal manufacturing processes.
...efficiently extracting table data from PDF documents. The extracted data should be organized and saved into a customized Excel template. Additionally, the system should be designed to assign different user IDs with varying levels of access control. Key Requirements: - Develop an AI portal with the capability to extract table data from PDFs. - Organize and save the extracted data in Excel using customized templates based on the source PDF. - Implement a user management system that assigns different access controls to various user IDs. Ideal Skills and Experience: - Proficient in AI development and data extraction techniques. - Expertise in Excel automation and customization. - Strong background in user management and access...
1. Right now I think there are 3 courses - I want there to be 5 (Anatomy, Biochemistry, Microbiology, AI Medical Mnemonics, ZAP-70 Resources) 2. Each course should have its own thumbnail, similar in style (I'll send these to you) 3. Lets discuss what each course needs done: -Anatomy: this course is only at its beginning. I have 5-6 videos, which I will send you, and these need to be uploaded. Each video has an associated pdf or image that should be added to the lesson ...
I'm looking for a dedicated and knowledgeable curriculum developer to create a comprehensive course on Post Natal Care. The curriculum is intended for vocational training, focusing on the essential skills and techniques related to post natal care for both new mothers and their babies, with a touch of basic nursing and massage therapy. Key Responsibilities: - Develop an engaging and structured curriculum that covers the fundamentals of post natal care - Incorporate basic nursing skills relevant to post natal care - Integrate safe and effective massage therapy techniques beneficial to new mothers and their infants - Ensure the curriculum is tailored to a vocational training audience, with a practical and hands-on ap...
NO PLACEHOLDER BIDS! I am looking for a freelancer who can set up a perfect system for me to maintain wordpress sites. Existing plugins can of course be used. Requirements: - Automated updates of plugins and CMS of Wordpress pages after connection - Automatic backups of websites before updates. It is important that the websites do not have access to each other's backups. - Automatic uptime check - Automatic malware check (if possible, e.g. by Ninja Firewall) We currently use MainWP and also have Pro versions for this. Likewise for BackWPUp. It is important to me that the freelancer has experience with this and provides me with precise solution proposals.
...in a Google Sheets / Excel document with the following information: - skill required (copied from title of Google Slides document) - page number of Google Slides document that the question appears on Key Requirements: - The questions are from primary school level math exams, so a good understanding of these topics is crucial. - You will need to effectively categorize each question based on the specific skills that need to be applied to solve them. - Proficiency in creating detailed digital reports is a must. - You will be required to understand the purpose of the task - to analyze what skills students need to pass these exams. Ideal Candidate: - Experience in educational administration or education itself would be an advantage. - Strong analytical skills and...
...basis. The scraped data should be efficiently saved to a CSV or Excel file for easy review. Capable of being plugged to a distribution app. Key Requirements: - Develop a Python-based web scraper that targets a website to extract text data - The scraper should be designed to run on a weekly schedule - Ensure that the code is concise and easy to understand for potential future modifications - Store the scraped data in a CSV or Excel file format Skills and Experience: - Proficiency in Python programming - Experience with web scraping libraries such as BeautifulSoup or Scrapy - Understanding of scheduling tasks in Python - Familiarity with working with databases, especially CSV or Excel files I'm open to discuss further enhancements and upd...
I'm looking for a proficient Excel professional to develop a multi-country income tax calculator. This tool will primarily serve individual taxpayers, and potentially other user groups. Key Requirements: The calculator should support income tax calculations for multiple countries. This requires a deep understanding of tax laws and calculations in each country. - The tool should be user-friendly and intuitive, catering to users with different levels of tax knowledge. - It should be well-structured, with separate sections for each country to avoid any confusion for the end-users. Ideal Skills and Experience: - Advanced Excel proficiency, with experience in creating complex calculators or financial models in Excel. - In-depth knowl...
I need an expert to develop a macro tailored to automating report production tasks in Microsoft Excel. The main purpose of this project is to streamline the process of regular report production and increase overall efficiency. Ideal skills and experience include: - Proficient in Microsoft Excel - Experience in macro development to automate tasks - Knowledge in automating report production Your role will involve designing and implementing a suitable macro for regular report production in Excel. I'm looking for someone who can provide a timely and efficient solution.
I'm seeking a skilled virtual assistant with proven communication abilities, to work specifically in US timezone. Your main duties will include: - Bidding on projects: You will need to represent our brand professionally and persuasively when bidding on projects. - Communicating with leads: You'll be responsible for using various messaging platforms to engage with potential clients and leads. Ideal candidates should excel in written communication and have a knack for sales. Proficiency in project management tools is a plus. Our preferred mode of communication with leads is through messaging platforms.
Looking for a Python & Active Directory Expert to create a script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, group policy etc. and export to a MS Excel File. More information attached.
We are looking for a 60-second video that will be used to introduce an online course about diamond jewellery in MasterClass style. The video needs to be created in an inspirational and motivational style to engage the viewer and create a sense of excitement. See examples here: You can use stock video content from sites like: Key Requirements: - Create a 60-second video - Target audience: Young adults (18-34) - Style: Inspirational and motivational Ideal Skills: - Video production - Creative direction - Understanding of young adult audience psychology Experience: - Prior work on similar product introduction videos - Experience creating inspirational or motivational content - Proven track record of engaging young
...production team of the TIKTOK Operation course, and I am looking for several TIKTOK creators who can face the camera to imitate and shoot simple oral videos. You don't need to have a lot of social media experience, as long as you're willing to try. Your main responsibilities include: - Execute video shoot according to the script we provided. - You can also write your own script based on the content we provide or improve. To increase brand awareness, your content should be engaging and cause widespread sharing and liking on the platform. The ideal candidate should have: - Look comfortable in front of the camera. - Fluent in English or Spanish - We cater to the North American market, which would be great if you are American or Mexican Ability ...
We are looking for a 60-second video that will be used to introduce an online course about diamond jewellery in MasterClass style. The video needs to be created in an inspirational and motivational style to engage the viewer and create a sense of excitement. See examples here: You can use stock video content from sites like: Key Requirements: - Create a 60-second video - Target audience: Young adults (18-34) - Style: Inspirational and motivational Ideal Skills: - Video production - Creative direction - Understanding of young adult audience psychology Experience: - Prior work on similar product introduction videos - Experience creating inspirational or motivational content - Proven track record of engaging young
...focus on Autocad 2023 and be delivered in a written document format. The guide need to be focused on drawings from building services/installations designs in constructions (HVAC & Plumbing area) With the following necessary instructions: - it need to treat primary 2D and in 2 chapters 3D modelling - It need to have table of contents - 14 chapters - image/text ratio maximum 35/75 - Each chapter will have to have 2 exercises to solve at the end, including the solutions, separately, for them - formated on A5 - gramitacally and tehnically correct text - verified in Turnitin, max 10% plagiarism. - images must be color. - minimum 100 pages Key Focus Areas: - Basics of Autocad interface: Explanation of the key tools, menus, and workspace within Autocad 2023. -...
...Moodle courses, and integrating the two platforms seamlessly. Key Project Details: - Drupal Website Development: I'm looking for someone who has extensive experience in Drupal to create a professional, user-friendly, and responsive informational website. - Moodle Course Creation: The ideal candidate will be able to develop engaging and interactive Moodle courses consisting of text-based lessons, video tutorials, and interactive quizzes. The courses should be structured in a way that is both informative and engaging for learners. - Drupal and Moodle Integration: I'm looking for someone who has experience in integrating Drupal websites with Moodle. The goal is to create a seamless user experience where learners can easily naviga...
I need help with my Microsoft Excel project! Specifically, I require assistance with the following: - **Formulas and Functions:** - Basic arithmetic operations. I don't need anything too complex, just fundamental formula structures. - **Automation:** - No macros for repetitive tasks are required, but I need guidance on setting up conditional formatting rules within the document. I'm looking for a Freelancer who is experienced in Excel and is comfortable with basic arithmetic operations and conditional formatting. You should be able to provide clear, concise, and easy-to-follow guidance. A strong attention to detail and excellent communication skills are a must. If you're proficient in these areas, I'd l...
I'm in need of an experienced VBA developer who can create custom macros for me, specifically to assist in automating tasks within Microsoft Excel. I'd like to streamline processes and increase efficiency within the software. Key requirements: - Proficient in VBA: You should be well-versed in VBA programming and have a proven track record of creating efficient and effective macros. - Microsoft Excel expertise: Experience in working extensively with Excel is a must. - Automation focus: The macros need to automate a variety of tasks, including data entry, report generation, and potentially formatting. While the complexity of the data manipulation needed isn't explicitly detailed, pleas...
...that collects the names, emails, and phone numbers of leads in real-time as soon as they visit a specific page. The collected data should be simultaneously sent to GoHighLevel (GHL) CRM for automated text and phone call follow-ups, as well as to an Excel sheet for manual review and further action. Key requirements: - Pixel Integration: Develop and implement a pixel solution that captures lead data. - Real-Time Collection: Ensure the system collects data instantly when a lead lands on the specified page. - GoHighLevel (GHL) Integration: Connect the system to GHL for automated text and phone call follow-ups. - Excel Integration: Enable the system to send collected lead data to an Excel sheet via email. Ideal skills and exper...
I require an experienced web developer to build an e-learning web application. The primary audience will be college students. Key Features: - User authentication for security - Course management system for curriculum organization - Progress tracking to monitor student development Learning Resources: - Videos and interactive exercises for active, engaging learning - Quizzes to assess understanding and retention. The ideal candidate will possess a proven track record in web development, specifically with e-learning platforms, and a deep understanding of user experience design for educational purposes.
I need a freelancer to help me gather phone numbers from clothing stores in County . You'll be provided with the location and shops to focus on. Key Responsibilities: - Utilize street view to identify shops - Collecting phone numbers of all such shops - Organize and input these numbers into an Excel spreadsheet Ideal Skills: - Proficient in using street view and other location tools - Detail-oriented and capable of data entry - Comfortable using WhatsApp for communication This is a straightforward project, but attention to detail is crucial. Feel free to reach out if you have any questions.
I am seeking a proficient and reliable safety advisor for a substantial lineup of Music Concerts, Sporting Events, BLVDs, malls etc. Ideally, you will have a strong level of experience and skills in managing safety issues at large scale events with an expected attendance of more than 5,000. Key Responsibilities: - Develop and implement robust safety measures addressing key anticipated issues including Crowd Control, Medical Emergencies, and Fire Hazards. - Review and approve all safety arrangements and plans prior, during and after the event, - Continuously monitor safety compliance during the event. - Quality control - Auditing and monitoring - Document management - Policy and procedures implementation - Other events sa...
...offer creation, order recording, item creation, and purchase analysis. Offer Comparator: The app should allow users to upload supplier offers, compare them against existing database entries, and identify the best offers based on configurable conditions. It should facilitate easy data input from Excel and offer detailed comparisons, with the ability to export results to Excel. Offer Creator: The freelancer should create functionality for users to customize sales offers by selecting and modifying purchase conditions, adjusting margins, and generating offer views exportable to Excel. Order Recording: Develop a user-friendly interface for recording orders by selecting sales and purchase offer IDs, entering customer-requ...
I am in need of an expert in B2B lead generation to help me with a specific project. The task involves targeting a loc...in need of an expert in B2B lead generation to help me with a specific project. The task involves targeting a local area for potential angel and private investors for an H.M.O in the health sector. Key Job Requirements: - Identify and compile a list of 50-100 angel or private investors from the local area. - Investors must have a previous history of investing in the health sector. - Delivery of the leads in an Excel spreadsheet format. Ideal Candidate: - Proven experience in B2B lead generation. - Good knowledge of the health sector and investment trends. - Excellent research skills. - Proficient in data management and Excel. -...
...seeking an experienced data scientist with expertise in Python and R for a project that involves time series data visualization and statistical analysis. Key Responsibilities: - Conducting data visualization to present insights in a clear and compelling manner - Performing statistical analysis to extract meaningful patterns and support decision-making I will provide you with a working file that retrieves data from our Python/R library. Your responsibility would be to process and analyze this data. We use Python/R with Jupyter notebooks. Ideal Skills: - Strong proficiency in Python - Experience with data visualization tools such as Matplotlib, pyplot and of course Pandas - Proficiency in statistical analysis methods and t...
