8444 Online Education courses

Overview   With the ever-increasing demand for Anti-Money Laundering (AML) in personal & professional settings, this online training aims at educating, nurturing, and upskilling individuals to stay ahead of the curve - whatever their level of expertise in Anti-Money Laundering (AML) may be.   Learning about Anti-Money Laundering (AML) or keeping up to date on it can be confusing at times, and maybe even daunting! But that's not the case with this course from Compete High. We understand the different requirements coming with a wide variety of demographics looking to get skilled in Anti-Money Laundering (AML). That's why we've developed this online training in a way that caters to learners with different goals in mind. The course materials are prepared with consultation from the experts of this field and all the information on Anti-Money Laundering (AML) is kept up to date on a regular basis so that learners don't get left behind on the current trends/updates.   The self-paced online learning methodology by Compete High in this Diploma in Anti-Money Laundering (AML) course helps you learn whenever or however you wish, keeping in mind the busy schedule or possible inconveniences that come with physical classes. The easy-to-grasp, bite-sized lessons are proven to be most effective in memorising and learning the lessons by heart. On top of that, you have the opportunity to receive a certificate after successfully completing the course!   Instead of searching for hours, enrol right away on this Diploma in Anti-Money Laundering (AML) course from Compete High and accelerate your career in the right path with expert-outlined lessons and a guarantee of success in the long run.   Who is this course for?   While we refrain from discouraging anyone wanting to do this Diploma in Anti-Money Laundering (AML) course or impose any sort of restrictions on doing this online training, people meeting any of the following criteria will benefit the most from it: Anyone looking for the basics of Anti-Money Laundering (AML), Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in Anti-Money Laundering (AML), Anyone looking for a certificate of completion on doing an online training on this topic, Students of Anti-Money Laundering (AML), or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity   Career Path   This Diploma in Anti-Money Laundering (AML) course smoothens the way up your career ladder with all the relevant information, skills, and online certificate of achievements. After successfully completing the course, you can expect to move one significant step closer to achieving your professional goals - whether it's securing that job you desire, getting the promotion you deserve, or setting up that business of your dreams.  Course Curriculum Module 1 - Introduction to Money Laundering Introduction to Money Laundering 01:00:00 Module 2 - The Role of The Money Laundering Reporting Officer The Role of The Money Laundering Reporting Officer 01:00:00 Module 3 - Risk-based Approach to Money Laundering Risk-based Approach to Money Laundering 01:00:00 Module 4 - Customer Due Diligence Customer Due Diligence 01:00:00 Module 5 - Record Keeping Record Keeping 01:00:00 Module 6 - Suspicious Conduct and Transactions Suspicious Conduct and Transactions 01:00:00 Module 7 - Staff Training Awareness and Training Staff Training Awareness and Training 01:00:00

Overview With the ever-increasing demand for Email Marketing in personal & professional settings, this online training aims at educating, nurturing, and upskilling individuals to stay ahead of the curve - whatever their level of expertise in Email Marketing may be. Learning about Email Marketing or keeping up to date on it can be confusing at times, and maybe even daunting! But that's not the case with this course from Compete High. We understand the different requirements coming with a wide variety of demographics looking to get skilled in Email Marketing . That's why we've developed this online training in a way that caters to learners with different goals in mind. The course materials are prepared with consultation from the experts of this field and all the information on Email Marketing is kept up to date on a regular basis so that learners don't get left behind on the current trends/updates. The self-paced online learning methodology by compete high in this Email Marketing course helps you learn whenever or however you wish, keeping in mind the busy schedule or possible inconveniences that come with physical classes. The easy-to-grasp, bite-sized lessons are proven to be most effective in memorising and learning the lessons by heart. On top of that, you have the opportunity to receive a certificate after successfully completing the course! Instead of searching for hours, enrol right away on this Email Marketing course from Compete High and accelerate your career in the right path with expert-outlined lessons and a guarantee of success in the long run. Who is this course for? While we refrain from discouraging anyone wanting to do this Email Marketing course or impose any sort of restrictions on doing this online training, people meeting any of the following criteria will benefit the most from it: Anyone looking for the basics of Email Marketing , Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in Email Marketing , Anyone looking for a certificate of completion on doing an online training on this topic, Students of Email Marketing , or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity Career Path This Email Marketing course smoothens the way up your career ladder with all the relevant information, skills, and online certificate of achievements. After successfully completing the course, you can expect to move one significant step closer to achieving your professional goals - whether it's securing that job you desire, getting the promotion you deserve, or setting up that business of your dreams.    Course Curriculum Chapter 1_ Introduction Introduction 00:00 Chapter 2_ Basic Elements of A Sales Letter Basic Elements of A Sales Letter 00:00 Chapter 3_ Tips on Writing a Sales Letter Tips on Writing a Sales Letter 00:00 Chapter 4_ Pitfalls and Mistakes Pitfalls and Mistakes 00:00 Chapter 5_ Writing A Sales Letter Writing A Sales Letter 00:00 Chapter 6_ The Rules of Writing A Sales Letter The Rules of Writing A Sales Letter 00:00

Database Basics is one of our best selling and most popular course. The Database Basics is organized into 9 modules and includes everything you need to become successful in this profession. To make this course more accessible for you, we have designed it for both part-time and full-time students. You can study at your own pace or become an expert in just 9 hours! If you require support, our experienced tutors are always available to help you throughout the comprehensive syllabus of this course and answer all your queries through email. Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessment Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £99. Please note that overseas students may be charged an additional £10 for postage. CPD Certificate of Achievement from Janets Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Endorsement This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment To successfully complete the course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the course. After successfully passing the exam, you will be able to apply for Quality Licence Scheme endorsed certificate of achievement. To verify your enhanced skills in the subject, we recommend that you also complete the assignment questions. These can be completed at any time which is convenient for yourself and will be assessed by our in-house specialised tutors. Full feedback will then be given on your current performance, along with any further advice or support. Who is this course for? Database Basics is suitable for anyone who want to gain extensive knowledge, potential experience, and expert skills in the related field..

Duration 2 Days 12 CPD hours Overview - You will learn advanced Adobe Captivate concepts. - You will learn to create highly interactive software simulation and to control the text that appears in the recording?s text captions by editing Captivates text capture templates. - You will create responsive lessons (using Fluid Boxes and Breakpoints) that automatically reflow to fit just about any kind of display including desktops, laptops, tablets, and smart phones. - Learn new features that Captivate now supports; such as, Virtual Reality with 360-degree images and videos along with interactive videos. - Fine-tune your Captivate production skills by leveraging object styles, master slides, themes, and advanced actions. - Engage your learners by adding variables, widgets, and learner interactions (including drag and drop) to your eLearning. - Learn to create object styles, apply them globally, and import and export them. Knock large projects down to size by learning to create branch groups. - Create branching scenarios that allow learners to plot their own path through your course. - You will also learn to create templates. - Ensure your eLearning can be used by people with disabilities by adding such 508-compliant features as accessibility text, keyboard shortcuts, and closed captions. - Enable Captivates reporting features and, along the way, learn about Learning Management Systems, SCORM, SCOs, Manifests, and content packages. A course that teaches the higher-end, more advanced functionality of Adobe Captivate 2019. 1 - INTERACTIVE SOFTWARE SIMULATIONS AND CAPTION PRE-EDITING Rehearse a Script Set Recording Preferences Record a Simulation Edit a Text Capture Template 2 - OBJECT STYLES, PROJECT SHARING, AND BRANCHING Create a New Style Apply an Object Style Globally Export and Import an Object Style Name a Slide Copy/Paste Project Assets Use Buttons to Create a Branch Explore the Branching View Create a Branch Group 3 - VARIABLES AND WIDGETS Add Project Information Insert a System Variable Edit a System Variable Create a User Variable Use a Variable to Gather Learner Data Insert and Format a Widget 4 - INTERACTIVE VIDEOS AND VIRTUAL REALITY Insert an Interactive Video Add Bookmarks Add Slide Overlays Create a Virtual Reality Project Add a Text Hotspot Add an Audio Hotspot Add a Quiz to a Virtual Reality Project 5 - INTERACTIONS Insert a Process Circle Create a Basic Drag and Drop Interaction Manage Drag and Drop Buttons and Write Captions Create a ?Trick? Retry Slide Explore an Advanced Drag and Drop Project Create an Advanced Drag and Drop Interaction Change the States of a Smart Shape Use States to Swap Images 6 - ACCESSIBLE ELEARNING Set Document Information Enable Accessibility Add Accessibility Text to Slides Import Slide Audio Add Shortcut Keys Add Closed Captions Set a Tab Order 7 - ADVANCED ACTIONS Use a Completed Action Name Objects Create a Mask Control Object Visibility Create a Standard Advanced Action, Attach an Action to a Button Group Timeline Objects Create a Variable Create a Conditional Action Create Decision Blocks 8 - PROJECT TEMPLATES AND MASTER SLIDES Work with the Main Master Slide Work with Content Masters Apply a Master to Filmstrip Slides Edit a Master Apply a Theme Create a Custom Theme Review a Template Create a Project Based on a Template Create a Project Template 9 - RESPONSIVE PROJECTS Customize Breakpoints Save a Standard Project As Responsive Insert and Name Fluid Boxes Resize Fluid Boxes Add Content to Fluid Boxes Switch Modes Use the Position Inspector Modify a Single Breakpoint Exclude from View Add a New Breakpoint Position and Link Objects Edit Breakpoint Object Styles 10 - REPORTING RESULTS Set Quiz Reporting Options Create a Manifest File Report a Button Interaction Adjust Slide Object Interaction Preview in SCORM Cloud Publish a Content Package Create an Inquisiq LMS Account Create an LMS Course Attach a Lesson to a Course Test an eLearning Course Additional course details: Nexus Humans Adobe Captivate 2019 - Beyond The Essentials training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Adobe Captivate 2019 - Beyond The Essentials course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 2 Days 12 CPD hours This course is intended for This course is intended for Sales Representatives (SR), Sales Managers and End-users who have an interest in the Sales components of Dynamics 365. Students should have an existing working knowledge of either Microsoft Dynamics 365 or Microsoft Dynamics CRM. As a minimum, students should attend the prerequisite course Introduction to Microsoft Dynamics 365 Overview Understand the features and tools that exist in Microsoft Dynamics 365 for SR?s and Sales Managers. Be familiar with the stages of the Sales Order. Process in Microsoft Dynamics 365. Understand the fundamentals of Lead and Opportunity Management. Be able to track, manage, qualify Leads and convert to Opportunities and related customer records in Microsoft Dynamics 365. Know how to disqualify and cancel Leads, and convert Activity records to Leads and Opportunities. Understand how to collaborate on Opportunities with other SR?s and close Opportunity records as Won and Lost. Be able to track Competitors and Stakeholders. Understand how to view Resolution Activities. Add Products and Write-In Products to Opportunities. Build and maintain a repository of Products, Product Bundles and Product Families in the Product Catalog. Configure Unit Groups, Price Lists and Discount Lists. Work with Product Properties and view a Product Hierarchy. Create Quotes and add Products. Work with the Sales Order Process to convert Quotes to Orders and Invoices. Fulfill Orders and manage Invoice payments. Explore the Sales Reports and create a custom Sales Report using the Reporting Wizard in Microsoft Dynamics 365. Understand the significance of Sales Goal Management and Metrics in Microsoft Dynamics 365. Explore the Sales Charts and Dashboards and create a custom Sales Dashboard in Microsoft Dynamics 365. This course provides students with a detailed hands-on experience of the Salesfeatures and components of Microsoft Dynamics 365. Introduction Sales Order Process Scenarios An Introduction to Sales in Dynamics 365 The Dynamics 365 Platform Dynamics 365 Sales Fundamentals Security Considerations Where to get Help Further Reading and Resources Lead Management The Lead Management Process Working with Lead Records Working with the Lead Form Lead Assignment Leads and Activities Qualifying a Lead Disqualifying a Lead Opportunities Management Introduction to Opportunities The Opportunity Views The Opportunity Form Opportunity Sales Process Closing an Opportunity Resolution Activities Products Introduction to the Product Catalog Adding Products Configuring Unit Groups Price Lists and Price List Items Quotes, Orders and Invoices Introduction to Order Processing Adding Products to an Opportunity Working with Quotes Working with Orders Working with Invoices Sales Analysis Introduction to Sales Analysis in Dynamics 365 The Sales Reports The Reporting Wizard Working with Sales Charts Working with Sales Dashboards Working with Sales Goals and Metrics

Duration 2 Days 12 CPD hours Overview #NAME? A course that teaches the core Adobe Captivate skills needed to create eLearning courses. 1 - EXPLORING CAPTIVATE Explore a Finished Captivate Project Zoom and Magnify Navigate a Project Explore and Reset the Workspace Preview the Entire Project 2 - NEW PROJECTS & SOFT SKILLS ELEARNING Create a Blank Project Add Images to Placeholders Import Images Use a Smart Shape as a Button Disable Click Sounds 3 - SCREEN RECORDINGS Rehearse a Script Review Recording Settings Review Recording Modes Record Using Multiple Modes Record a Custom Simulation Record a Demonstration that Pans Manually Record the Screen 4 - VIDEO DEMOS Record a Video Demo Add a Video Zoom Add a Video Pan Smooth a Mouse Path and Show Visual Clicks Split a Video Trim a Video Insert a Video Project into a Standard Project Publish a Video Demo 5 - CAPTIONS, STYLES, TIMING, AND ROUND TRIPPING Insert and Edit Text Captions Edit the Default Caption Style Change a Callout Type Used by a Text Caption Control Slide Timing Control Slide Object Timing Check Spelling Align Slide Objects Export Captions to Word Import Captions from Word into Captivate 6 - POINTERS, PATHS, PATHS, BOXES, AND BUTTONS Control Mouse Effects Edit a Mouse Path Clone an Object Style Insert a Highlight Box Insert an Image Button Control Appear After Timing 7 - IMAGES AND VIDEOS Insert, Resize, and Restore an Image Import Images into the Library Resize, Transform, and Align Images Manage Unused Library Assets Create an Image Slideshow Insert a Video Set Video Properties 8 - AUDIO Work with Rollover Captions Import Audio onto a Slide Object Import Background Audio Add a Slide Note Calibrate a Microphone Record Slide Audio Import Audio onto a Slide Edit an Audio File Insert Silence Convert Text-to-Speech 9 - STATES, ANIMATIONS, AND OBJECT EFFECTS Change State Views for a Button Add an Animation to a slide Insert a Text Animation Apply an Effect to a Slide Object Apply a Free Fall Effect to an Object 10 - SOFTWARE SIMULATIONS Hide the Mouse Replace Phrases Insert a Click Box Insert a Text Entry Box 11 - WORKING WITH POWERPOINT Create a Project from a Presentation Edit the Source Presentation Synchronize with Source Rescale a Project 12 - QUIZZING Edit Quizzing Object Styles Set the Quiz Preferences Question Slides Insert Question Slides Edit a Question Slide Compare Submit All to Submit Buttons Insert a Knowledge Check Review a GIFT File Import a GIFT File into a Project Create Question Pools Move Questions to Pools Insert Random Question Slides 13 - PUBLISHING Apply a Skin Edit, Save, and Delete a Skin Name Slides Check Publish Settings and Add a Loading Screen Publish as SWF and PDF Run the HTML5 Tracker Publish as HTML5

Duration 0.5 Days 3 CPD hours This course is intended for This course is designed for business professionals in any functional role who need to participate in Zoom meetings and webinars, and who may also be called on to host Zoom events. Overview In this course, you will participate in and host Zoom meetings to collaborate with others. You will: Use Zoom as a meeting participant. Use Zoom to host meetings. Customize Zoom settings. Manage Zoom contacts. With people transitioning to working remotely, virtual meetings have become the norm and, as a result, the Zoom video conferencing tool is gaining attention and usage. If Zoom has become part of your professional or personal life, this course will help you be a more confident and productive Zoom user. In this course, you will participate in and host Zoom meetings, use Zoom productivity tools such as breakout rooms and contacts, and apply Zoom security and personalization. Using Zoom as a Meeting Participant Topic A: Join a Zoom Meeting Topic B: Participate in a Zoom Meeting Topic C: Collaborate in a Meeting Using Zoom to Host Meetings Topic A: Schedule a Meeting Topic B: Host a Meeting Topic C: Use Breakout Rooms Topic D: Compare Meetings and Webinars Customizing Zoom Topic A: Customize Settings in the Zoom Web Portal Topic B: Customize Zoom Desktop Client Settings Managing Zoom Contacts Topic A: Add Zoom Contacts Topic B: Chat with Zoom Contacts

Duration 1 Days 6 CPD hours This course is intended for A Dynamics 365 Customer Engagement Functional Consultant is responsible for performing discovery, capturing requirements, engaging subject matter experts and stakeholders, translating requirements, and configuring the solution and applications. The Functional Consultant implements a solution using out of the box capabilities, codeless extensibility, application and service integrations. Overview After completing this course, you will be able to: Install and configure the application Identify common sales scenarios Complete a sales cycle Configure product catalog Manage customer records Utilize analytics tools with customer data Microsoft Dynamics 365 for Sales is an end-to-end application to manage the handling of customers and potential customers; tracking data against sales goals, automating your best practices, learning from your data and more. Sales Overview Sales overview Configuring Sales Module summary Working with Opportunities Manage customers Working with opportunities Embedded intelligence Playbooks Integrated sales tools Module summary Quotes to Orders Order processing overview Manage product catalog Create and manage quotes Create and manage orders and invoices Module summary Sales Analytics and Insights Overview Power BI AI for Sales Modules summary Additional course details: Nexus Humans MB-210T01 Dynamics 365 for Customer Engagement for Sales training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the MB-210T01 Dynamics 365 for Customer Engagement for Sales course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 1 Days 6 CPD hours This course is intended for Leaders, Managers, Individuals who lead meetings This course is designed to help leaders run effective virtual meetings as well as managing their team virtually. We will explore communication styles and understanding their team as well as productivity. This course involves a lot of open discussion as well as teaching leaders how to manage the virtual workplace and run productive meetings. Defining the Virtual Workplace What does it look like? Tools available Communication strategies Understanding communication styles Leading different communication styles Building a Virtual Workplace Strategy Goals & agenda Check-ins Communication strategies Virtual Leadership Strategies Making connections & check ins Managing virtual meetings with team members Defining availability & creating schedules Open Discussion & Action Plan

A Complete Guide for Effective LinkedIn Ads' is a comprehensive course that covers the fundamentals of setting up and managing successful LinkedIn Ads campaigns. Participants will learn to drive website traffic, utilize sponsored messages, generate leads, and effectively manage billing centers on the platform. Learning Outcomes: Understand the basics of LinkedIn Ads and their role in digital marketing. Learn how to set up LinkedIn Ads to drive targeted website traffic. Discover techniques for leveraging sponsored messages to engage with the audience. Acquire the skills to create and optimize LinkedIn Ads for lead generation. Gain proficiency in managing the billing center for efficient campaign budgeting and monitoring. Why buy this Excel VBA/Macros Foundations? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Excel VBA/Macros Foundations there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Excel VBA/Macros Foundations course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Excel VBA/Macros Foundations does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Excel VBA/Macros Foundations was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Excel VBA/Macros Foundations is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Section 01: Introduction Recording Macros vs Writing VBA 00:04:00 Understanding Objects in Excel VBA 00:07:00 Understanding VBA Syntax and Parts of Speech 00:10:00 Activating the Developer tab 00:01:00 Recording a basic Macro 00:05:00 Absolute vs Relative Macro recording 00:04:00 Section 02: Exploring the Visual Basic Environment Introduction to the Visual Basic Environment 00:02:00 The Project Explorer 00:02:00 The Properties Window 00:02:00 The Code Window 00:04:00 Immediate, Locals and Watch Window 00:03:00 Dealing with Modules 00:03:00 Comments in Excel VBA 00:01:00 Section 03: The Range Object Introduction and Changing Cell Values 00:10:00 Adding a text to a cell 00:01:00 Dealing with Named Ranges 00:03:00 Value vs Text Property 00:04:00 Row and Column properties 00:02:00 The Select Method 00:02:00 The Count Property 00:04:00 The Address Property 00:09:00 The Formula Property 00:03:00 The Number Format Property 00:07:00 The Font Property 00:08:00 Section 04: Understanding the Cells Collection Object What is the cells object? 00:06:00 Using the Cells collection to affect cells positionally within a range 00:05:00 Affecting all cells within a sheet 00:02:00 Combining Range and cells objects 00:03:00 Section 05: Working with Sheets/Worksheets Selecting Sheets 00:06:00 Adding Sheets 00:11:00 Sheets vs Worksheets 00:04:00 Copying Sheets 00:05:00 Moving Sheets 00:01:00 Deleting Sheets 00:04:00 Section 06: Understanding Variables in Excel VBA Introduction to Variables 00:06:00 Variable Data Types 00:09:00 Declaring Variables 00:14:00 Object Variables 00:08:00 Calling a procedure from Another Procedure & Variable Scope 00:03:00 Public and Private Variables 00:07:00 Declaring Constants 00:04:00 Exercises-Variables 00:06:00 Section 07: Dealing with Workbooks Referring to Workbooks-Different ways 00:04:00 Closing Workbooks 00:03:00 Adding and Saving Workbooks Part 1 - Save method 00:04:00 Adding and Saving Workbooks Part 2 - Save as method 00:10:00 Opening Workbooks 00:06:00 Section 08: Must Know Excel VBA Logic Finding the Last row 00:09:00 Finding the Last Column 00:04:00 Finding the next row 00:04:00 The WITH Statement 00:04:00 Comparison operators in Excel VBA 00:01:00 IF Statements- Simple IF Statements 00:07:00 IF THEN ELSE Structure 00:03:00 IF THEN ELSEIF Structure 00:07:00 Nested IFs 00:04:00 OR - AND logical operators 00:07:00 NOT Logical operator 00:03:00 CASE Statements Part 1 - Single Case Statements 00:09:00 CASE Statements Part 2 - Nested Case Statements 00:06:00 Case Statements-Exercise 00:01:00 GOTO and Labels 00:03:00 Section 09: Looping in Excel VBA Loops-Introduction 00:01:00 FOR NEXT Loop 00:11:00 Exit For 00:09:00 Exercise - For Next loop 00:01:00 FOR EACH Loop - Intro 00:07:00 FOR EACH Loops - More examples 00:05:00 Do Loop - Introduction 00:04:00 Do Loop Example 00:01:00 Do Until 00:02:00 Do While 00:02:00 Do while vs Do until - Movies Example 00:04:00 Exit Do Statement 00:05:00 Exercise - Do Loop 00:01:00 Section 10: Interacting with Your Users The Messagebox - Introduction 00:03:00 Messagebox -Inputs 00:07:00 Messagebox - Capturing the User's input 00:05:00 Adding a new line to your VBA Strings 00:02:00 The Inputbox - introduction 00:04:00 Inputbox - Example1 - Capturing a user's name 00:05:00 Inputbox -Employee Database Example Part 1 00:05:00 Inputbox -Employee Database Example Part 2 00:04:00 Exercise - InputBox 00:02:00 Section 11: Error Handling in Excel VBA Error Handling - Introduction 00:09:00 Different Error types in action 00:04:00 On Error Goto statement 00:04:00 Resetting the error handling Status with On Error Goto 00:02:00 The Err Object 00:07:00 Setting a Breakpoint 00:02:00 Section 12: Triggering Code with Events! Worksheet Events -Selection change 00:08:00 Worksheet Events - Worksheet Activate event 00:03:00 Worksheet Events - Deactivate event 00:02:00 Worksheet Events - Before Delete Event 00:02:00 Worksheet Events - Before Double click event 00:08:00 Worksheet Events - Before Right Click event 00:03:00 Worksheet Events - Calculate event 00:03:00 Enabling and Disabling Events 00:03:00 Worksheet events - Worksheet change event 00:11:00 Workbook Events - Follow Hyperlink event 00:02:00 Worksheet events -Exercise 00:01:00 Workbook Events - Workbook open event 00:05:00 Workbook Events - Workbook Activate event 00:02:00 Workbook Events - Workbook Before save event 00:06:00 Workbook Events - Workbook Aftersave event 00:04:00 Workbook Events - Workbook Beforeclose event 00:09:00 Workbook Events - Workbook BeforePrint event 00:03:00 Workbook Events -Workbook De-activate events 00:02:00 Workbook Events - New Chart event 00:08:00 Workbook Events -New sheet event 00:03:00 Workbook Events - Sheet calculate event 00:03:00 Workbook Events - Sheet De-activate event 00:06:00 Workbook Events - Follow Hyperlink event 00:02:00 Workbook Events - Workbook Window Activate event 00:06:00 Workbook Events - Workbook Window De-Activate event 00:02:00 Workbook Events - Window Resize event 00:02:00 Exercise- Workbook Events 00:01:00 Resources Resources - Excel VBA/Macros Foundations 00:00:00 Assignment Assignment - Excel VBA/Macros Foundations 00:00:00