Level 3 & 5 Endorsed Diploma | QLS Hard Copy Certificate Included | Plus 5 CPD Courses | Lifetime Access
This course is intended for anyone who has already undertaken a basic body massage course training and would like to develop their knowledge of the common conditions that affect women, potentially leading them to book a treatment, with self help measures that they can suggest to their clients
Why choose SketchUp Course for Interior Designers and Architects with Layout and Vray? Introducing SketchUp Training Course tailored for Interior Designers and Architects. This comprehensive course is designed for interior designers and architects who want to master SketchUp for 3D modeling, Layout for creating construction documents, and V-Ray for rendering. Course info Duration: 10 hrs Method: 1-2-1, Personalized attention Schedule: Tailor your own hours, available from Mon to Sat between 9 am and 7 pm Explore the world of 3D drawing with Sketchup in this beginner-friendly course. With its user-friendly interface, Sketchup offers a gentle learning curve, allowing you to quickly grasp 3D geometries. As you become acquainted with the basic drawing tools, you'll uncover a plethora of advanced techniques to create intricate and complex 3D objects. Who Should Take This Course? This course is ideal for individuals seeking to utilize a 3D drawing tool to solve three-dimensional problems or engage in more advanced design endeavors. Our experienced tutors communicate in accessible English, avoiding complex jargon and ensuring clarity throughout the course. We offer a wealth of learning resources for you to access beyond live lessons. Stay up-to-date, practice, and review key concepts essential to your growth. Course Title: SketchUp Training for Interior Designers and Architects with Layout and V-Ray Course Course Duration: 10 hours Course Description: This comprehensive course is designed for interior designers and architects who want to master SketchUp for 3D modeling, Layout for creating construction documents, and V-Ray for advanced rendering. Participants will learn how to create stunning 3D models for their projects, produce detailed construction documents, and apply professional-grade rendering techniques to bring their designs to life. Course Outline: Module 1: Introduction to SketchUp (1 hour) - Overview of SketchUp for interior design and architecture - Interface and basic tools - Navigation and viewport controls - Creating and saving interior design and architecture projects Module 2: Creating Floor Plans (1 hour) - Importing floor plans and site plans - Drawing walls, windows, and doors - Creating and editing floor levels - Understanding Layers and Scenes Module 3: Adding Furniture and Fixtures (2 hours) - Importing furniture and fixtures from the 3D Warehouse - Creating custom furniture and fixtures - Placing and arranging furniture and fixtures in the space - Creating and editing custom materials Module 4: Advanced Modeling Techniques (2 hours) - Creating more complex 3D models using advanced tools - Using groups and components for model organization - Adding custom details and finishes Module 5: Layout for Construction Documents (2 hours) - Creating construction documents in Layout - Importing SketchUp models into Layout - Creating floor plans, elevations, and sections - Adding annotations and dimensions to construction documents Module 6: Introduction to V-Ray (1 hour) - Overview of V-Ray for SketchUp - Basic V-Ray interface and tools - Understanding V-Ray materials and textures Module 7: Advanced Rendering Techniques (1 hour) - Applying advanced rendering techniques to SketchUp models - Creating artificial lighting and using natural lighting - Adding entourage and landscaping to designs Module 8: Importing and Exporting (30 minutes) - Importing and exporting files from other software - Understanding file formats and compatibility - Exporting models for 3D printing Module 9: Conclusion and Next Steps (30 minutes) - Review of course content - Tips for further learning and resources - Q&A and feedback
Lean Six Sigma Yellow Belt Certification Program: Virtual In-House Training This course is designed to instill an in-depth understanding of Lean Six Sigma and a clear sense of what is required to define high-impact improvement projects, establish Lean Six Sigma measurements, and complete Lean Six Sigma projects using the systematic and proven Define, Measure, Analyze, Improve, and Control (DMAIC) methodology. This course is designed to instill an in-depth understanding of Lean Six Sigma and a clear sense of what is required to define high-impact improvement projects, establish Lean Six Sigma measurements, and complete Lean Six Sigma projects using the systematic and proven Define, Measure, Analyze, Improve, and Control (DMAIC) methodology. Participants will learn basic tools and techniques of Lean Six Sigma and those who pass a thirty-question exam (70% or above) will become a Certified Lean Six Sigma Yellow Belt. This course is delivered through four 3-hour online sessions. What you Will Learn You'll learn how to: Establish the structure that supports and sustains Lean Six Sigma Quality Identify and calculate key Lean Six Sigma Measurements (Sigma, DPMO, and Yield) Select successful, high-impact projects that match strategic objectives Document, measure, and improve key processes using the DMAIC (Define, Measure, Analyze, Improve, and Control) Methodology Utilize data-based thinking to make key business decisions Introduction to the Fundamentals and Vision of Lean Six Sigma Lean Six Sigma's focus on the customer, on quality, and on results The costs of poor quality Critical factors to consider when deploying Lean Six Sigma Lean Six Sigma as a process improvement methodology Lean Six Sigma metrics Why do it - ROI and payback for Lean Six Sigma Business Process Management Critical Lean Six Sigma roles and responsibilities Main aspects of managing the organizational change Project selection Metrics of Lean Six Sigma and the DMAIC Model How to strategically align business metrics and projects within an organization How to identify and measure quality characteristics which are critical to customers What does the customer (internal or external) really want from our products and services? Establishing appropriate teams and setting those teams up to be successful What defines a good measurement system? How are we doing (learning the secret to measuring the right things, right)? How to improve output measures by understanding and measuring the process Where are there defects (how to properly select and scope high-impact projects)? Where is the process broken (the Lean Six Sigma version of root cause analysis)? How to determine the process efficiency, or value add, of a process The appropriate use of quality tools Understanding the concept of variation and how to reduce knee-jerk reactions How to achieve breakthrough results for any key measure How can we ensure the identified improvements will be sustainable (the basics of process control)?
***24 Hour Limited Time Flash Sale*** Laboratory Technician (Microbiology, Infection Prevention and Control) Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter 'Laboratory Technician (Microbiology, Infection Prevention and Control)' Immerse yourself in the enriching world of scientific exploration with our "Laboratory Technician (Microbiology, Infection Prevention and Control)" course bundle. With eight premium courses at your fingertips, you'll be well-versed in laboratory techniques and best practices, paving your way for a rewarding career in the medical and health science fields. This Laboratory Technician (Microbiology, Infection Prevention and Control) bundle proudly includes three QLS-endorsed courses: 'Microbiology Laboratory Technician', 'Principles of Infection Prevention and Control', and 'Laboratory Technician Level 7'. These courses are crafted meticulously to provide a comprehensive understanding of key concepts and theories. Plus, upon completion, you'll receive a hardcopy certificate to enhance your professional credibility. Not just that, we also offer five relevant CPD QS-accredited courses: 'Biomedical Science', 'Basic Biology', 'Level 3 Diploma in Anatomy and Physiology of Human Body', 'Infection Prevention Training', and 'COSHH Training for Assessors'. These theoretical knowledge-based courses will form a solid foundation for your scientific expertise, providing you with an edge in the competitive job market. Choose our "Laboratory Technician (Microbiology, Infection Prevention and Control)" course bundle to build an enriching, rewarding future in the fascinating field of health and biomedical sciences. Key Features of the Laboratory Technician (Microbiology, Infection Prevention and Control) Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Laboratory Technician (Microbiology, Infection Prevention and Control) bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Microbiology Laboratory Technician QLS Course 02: Principles of Infection Prevention and Control QLS Course 03: Laboratory Technician Level 7 5 CPD QS Accredited Courses: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices. Course 01: Biomedical Science Course 02: Basic Biology Course 03: Level 3 Diploma in Anatomy and Physiology of Human Body Course 04: Infection Prevention Training Course 05: COSHH Training for Assessors In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle. Course 01: Professional CV Writing Course 02: Job Search Skills Course 03: Self-Esteem & Confidence Building Course 04: Professional Diploma in Stress Management Course 05: Complete Communication Skills Master Class Convenient Online Learning: Our Laboratory Technician (Microbiology, Infection Prevention and Control) courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Learning Outcomes: Upon completion of this Laboratory Technician (Microbiology, Infection Prevention and Control) bundle, learners will be able to: Understand key principles of microbiology, infection prevention, and laboratory protocols. Grasp the basic concepts of biology and biomedical sciences. Comprehend the anatomy and physiology of the human body. Understand the principles of infection prevention training and COSHH. Apply theoretical knowledge to real-world situations in a laboratory setting. Recognise professional standards and practices in laboratory technology. Leverage theoretical knowledge to advance career opportunities in the health sciences. The "Laboratory Technician (Microbiology, Infection Prevention and Control)" bundle offers a robust understanding of vital health science subjects. Comprising eight meticulously crafted courses, it provides a comprehensive overview of microbiology, infection prevention, laboratory practices, biology, biomedical science, human anatomy, physiology, and COSHH. The learning journey is enriched with valuable theoretical insights, which not only build foundational knowledge but also prepare learners for tackling real-world scenarios in a laboratory setting. This bundle offers a unique opportunity to enhance your understanding of these subjects, promoting personal growth and potential career advancement. CPD 270 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Laboratory Technician (Microbiology, Infection Prevention and Control) bundle is ideal for: Individuals interested in pursuing a career in health and biomedical sciences. Professionals looking to enhance their theoretical knowledge in microbiology and infection prevention. Aspiring laboratory technicians keen on refining their understanding of laboratory practices. Anyone looking to broaden their horizons in the field of biology and human physiology. Career path Microbiology Laboratory Technician: (£21,000 - £28,000) Infection Prevention and Control Specialist: (£31,000 - £41,000) Biomedical Scientist: (£27,000 - £37,000) Anatomy and Physiology Instructor: (£32,000 - £42,000) Infection Prevention Trainer: (£26,000 - £35,000) Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included
Become a browser automation master with Selenium WebDriver, JavaScript, and Node.js
Use Cases for Business Analysis: In-House Training The use case is a method for documenting the interactions between the user of a system and the system itself. Use cases have been in the software development lexicon for over twenty years, ever since it was introduced by Ivar Jacobson in the late 1980s. They were originally intended as aids to software design in object-oriented approaches. However, the method is now used throughout the Solution Development Life Cycle from elicitation through to specifying test cases, and is even applied to software development that is not object oriented. This course identifies how business analysts can apply use cases to the processes of defining the problem domain through elicitation, analyzing the problem, defining the solution, and confirming the validity and usability of the solution. What you will Learn You'll learn how to: Apply the use case method to define the problem domain and discover the conditions that need improvement in a business process Employ use cases in the analysis of requirements and information to create a solution to the business problem Translate use cases into requirements Getting Started Introductions Course structure Course goals and objectives Foundation Concepts Overview of use case modeling What is a use case model? The 'how and why' of use cases When to perform use case modeling Where use cases fit into the solution life cycle Use cases in the problem domain Use cases in the solution domain Use case strengths and weaknesses Use case variations Use case driven development Use case lexicon Use cases Actors and roles Associations Goals Boundaries Use cases though the life cycle Use cases in the life cycle Managing requirements with use cases The life cycle is use case driven Elicitation with Use Cases Overview of the basic mechanics and vocabulary of use cases Apply methods of use case elicitation to define the problem domain, or 'as is' process Use case diagrams Why diagram? Partitioning the domain Use case diagramming guidelines How to employ use case diagrams in elicitation Guidelines for use case elicitation sessions Eliciting the problem domain Use case descriptions Use case generic description template Alternative templates Elements Pre and post conditions Main Success Scenario The conversation Alternate paths Exception paths Writing good use case descriptions Eliciting the detailed workflow with use case descriptions Additional information about use cases Analyzing Requirements with Use Cases Use case analysis on existing requirements Confirming and validating requirements with use cases Confirming and validating information with use cases Defining the actors and use cases in a set of requirements Creating the scenarios Essential (requirements) use case Use case level of detail Use Case Analysis Techniques Generalization and Specialization When to use generalization or specialization Generalization and specialization of actors Generalization and specialization of use cases Examples Associating generalizations Subtleties and guidelines Use Case Extensions The <> association The <> association Applying the extensions Incorporating extension points into use case descriptions Why use these extensions? Extensions or separate use cases Guidelines for extensions Applying use case extensions Patterns and anomalies o Redundant actors Linking hierarchies Granularity issues Non-user interface use cases Quality considerations Use case modeling errors to avoid Evaluating use case descriptions Use case quality checklist Relationship between Use Cases and Business Requirements Creating a Requirements Specification from Use Cases Flowing the conversation into requirements Mapping to functional specifications Adding non-functional requirements Relating use cases to other artifacts Wire diagrams and user interface specifications Tying use cases to test cases and scenarios Project plans and project schedules Relationship between Use Cases and Functional Specifications System use cases Reviewing business use cases Balancing use cases Use case realizations Expanding and explaining complexity Activity diagrams State Machine diagrams Sequence diagrams Activity Diagrams Applying what we know Extension points Use case chaining Identifying decision points Use Case Good Practices The documentation trail for use cases Use case re-use Use case checklist Summary What did we learn, and how can we implement this in our work environment?
About this Training Course This 3 full-day course will provide a comprehensive understanding of the various types of transformer maintenance including breakdown maintenance, preventive maintenance, total productive maintenance, condition-based maintenance, proactive maintenance, and reliability-centered maintenance. All the expected problems in dry and oil-filled transformers will be discussed in detail. All the diagnostics, troubleshooting and maintenance required to ensure adequate operation of transformers will be covered thoroughly. This course will focus on maximizing the efficiency, reliability, and longevity of all types of transformers by providing an understanding of all commissioning requirements, repair and refurbishment methods of transformers. Training Objectives Equipment Diagnostics and Inspection: Learn in detail all the diagnostic techniques and inspections required of critical components of transformers Equipment Testing: Understand thoroughly all the routine tests, type tests, and special tests required for the various types of transformers Equipment Maintenance and Troubleshooting: Determine all the maintenance and troubleshooting activities required to minimize transformer downtime and operating cost Equipment Repair and Refurbishment: Gain a detailed understanding of the various methods used to repair and refurbish transformers Efficiency, Reliability, and Longevity: Learn the various methods used to maximize the efficiency, reliability, and longevity of transformers Equipment Sizing: Gain a detailed understanding of all the calculations and sizing techniques used for transformers Design Features: Understand all the design features that improve the efficiency and reliability of transformers Equipment Selection: Learn how to select all types of transformers by using the performance characteristics and selection criteria that you will learn in this course Equipment Commissioning: Understand all the commissioning requirements for transformers Equipment Codes and Standards: Learn all the codes and standards applicable for transformers Equipment Causes and Modes of Failure: Understand the causes and modes of failure in transformers System Design: Learn all the requirements for designing different types of transformer systems Target Audience Engineers of all disciplines Managers Technicians Maintenance personnel Other technical individuals (this course is suitable for individuals who do not have an electrical background) Course Level Basic or Foundation Training Methods Your specialist course leader relies on a highly interactive training method to enhance the learning process. This method ensures that all participants gain a complete understanding of all topics covered. The training environment is highly stimulating, challenging, and effective because the participants will learn by case studies which will allow them to apply the material taught to their own organization. Each delegate will receive a copy of the following materials written by the instructor: Excerpt of the relevant chapters from the 'ELECTRICAL EQUIPMENT HANDBOOK' published by McGraw-Hill in 2003 (600 pages) Transformer Testing, Maintenance and Commissioning Manual (covering all the tests, maintenance activities, protective systems and all commissioning procedures for all types of transformers - 350 pages) Trainer Your specialist course leader has more than 32 years of practical engineering experience with Ontario Power Generation (OPG), one of the largest electric utility in North America. He was previously involved in research on power generation equipment with Atomic Energy of Canada Limited at their Chalk River and Whiteshell Nuclear Research Laboratories. While working at OPG, he acted as a Training Manager, Engineering Supervisor, System Responsible Engineer and Design Engineer. During the period of time, he worked as a Field Engineer and Design Engineer, he was responsible for the operation, maintenance, diagnostics, and testing of gas turbines, steam turbines, generators, motors, transformers, inverters, valves, pumps, compressors, instrumentation and control systems. Further, his responsibilities included designing, engineering, diagnosing equipment problems and recommending solutions to repair deficiencies and improve system performance, supervising engineers, setting up preventive maintenance programs, writing Operating and Design Manuals, and commissioning new equipment. Later, he worked as the manager of a section dedicated to providing training for the staff at the power stations. The training provided by him covered in detail the various equipment and systems used in power stations. In addition, he has taught courses and seminars to more than four thousand working engineers and professionals around the world, specifically Europe and North America. He has been consistently ranked as 'Excellent' or 'Very Good' by the delegates who attended his seminars and lectures. He written 5 books for working engineers from which 3 have been published by McGraw-Hill, New York. Below is a list of the books authored by him; Power Generation Handbook: Gas Turbines, Steam Power Plants, Co-generation, and Combined Cycles, second edition, (800 pages), McGraw-Hill, New York, October 2011. Electrical Equipment Handbook (600 pages), McGraw-Hill, New York, March 2003. Power Plant Equipment Operation and Maintenance Guide (800 pages), McGraw-Hill, New York, January 2012. Industrial Instrumentation and Modern Control Systems (400 pages), Custom Publishing, University of Toronto, University of Toronto Custom Publishing (1999). Industrial Equipment (600 pages), Custom Publishing, University of Toronto, University of Toronto, University of Toronto Custom Publishing (1999). Furthermore, he has received the following awards: The first 'Excellence in Teaching' award offered by PowerEdge, Singapore, in December 2016 The first 'Excellence in Teaching' award offered by the Professional Development Center at University of Toronto (May, 1996). The 'Excellence in Teaching Award' in April 2007 offered by TUV Akademie (TUV Akademie is one of the largest Professional Development centre in world, it is based in Germany and the United Arab Emirates, and provides engineering training to engineers and managers across Europe and the Middle East). Awarded graduation 'With Distinction' from Dalhousie University when completed Bachelor of Engineering degree (1983). Lastly, he was awarded his Bachelor of Engineering Degree 'with distinction' from Dalhousie University, Halifax, Nova Scotia, Canada. He also received a Master of Applied Science in Engineering (M.A.Sc.) from the University of Ottawa, Canada. He is also a member of the Association of Professional Engineers in the province of Ontario, Canada. POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information post training support and fees applicable Accreditions And Affliations
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
This course is designed for absolute beginners and explains even the most basic concepts in Tableau from scratch. By completing this course, you will be able to create rich visualizations easily and confidently and have the knowledge required to crack the Tableau Desktop Specialist Exam.