2033 Courses delivered Online

Most people only use a fraction of Excel's capabilities. This workshop shows what you've been missing! This course will help participants: Nest formulas Get the most from pivot tables Use conditional formatting Write array formulas Explore the lookup functions Calculate by criteria Use 'goal seek' and 'scenario manager' for what-if analysis Record macros 1 Nesting formulas Principles of nesting formulas together Using IF with AND or OR to answer questions Nesting an AND function in an IF Nesting an OR function in an IF 2 Advanced pivot table reports Grouping dates, numerical and text items Running percentage analyse Running analyses to compare data Inserting Field calculations Finishing off with a user-friendly dashboard 3 Advanced conditional formatting Colour table rows based on criteria in it Applying colour to approaching dates Exploring the different rule types 4 Lookup functions Going beyond the VLOOKUP function Lookups that retrieve data from left or right The versatile INDEX and MATCH functions Retrieving data from columns with duplicates 5 Calculate by criteria Using SUMIFS to sum by criteria Finding an average by criteria with AVERAGEIFS Use SUMPRODUCT to multiply then add different values 6 What-if analysis Use Goal Seek to meet targets Forecast reports with the Scenario Manager 7 Recording Macros Macro security Understanding a Relative References macro Recording, running and editing macros Saving files as Macro Enabled Workbooks Introduction to VBA code Making macros available across workbooks Add a macro button to the Quick Access toolbar

Training, in broad terms, is the process of teaching someone or a group of people to do something new or better. However, for the professional trainer, effective and efficient training entails far more than this. The purpose of this Train the Trainer course is to introduce the skills, knowledge, and character traits that are at the heart of effective training. Effective training requires far more than simply presenting candidates with new ideas and expecting them to respond appropriately. The effective trainer is a charismatic and inspirational leader who naturally develops trust and respect in delegates. Through this Train the Trainer course you will learn how to identify and respond to individual candidates' unique needs, engage even the most difficult audiences, and become a confident communicator. Learn about the art of effective performance management, the value of conflict resolution skills, and a detailed breakdown of the effective workshop planning process. Learning Outcomes After completing this Train the Trainer Course course, learner will be able to: Gain a thorough understanding of needs assessment Gain in-depth knowledge about adult learners Understand training styles Gain a solid understanding of today's learner Know how to write instructional objectives Understand selecting, designing, and developing active-training methods Know how to create a positive learning environment Know how to use visual aids Know how to evaluate training Know how to train across cultures Understand storytelling as a training technique Know how to use technology in training Understand the business of consulting Why Choose Train the Trainer Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. Train the Trainer Course developed by industry experts. MCQ quiz after each module to assess your learning. Automated and instant assessment results. 24/7 support via live chat, phone call or email. Free PDF certificate as soon as completing the Course. ***Others Benefits of this Train the Trainer Course Free One PDF Certificate Access to Content - Lifetime Exam Fee - Totally Free Unlimited Retake Exam [ Note: Free PDF certificate as soon as completing the Train the Trainer Course] Detailed course curriculum *** Trainer : Train the Trainer *** Module 01: Assessing Needs Module 02: Understanding Adult Learners Module 03: Training Styles Module 04: Understanding Today's Learner Module 05: Writing Instructional Objectives Module 06: Writing an Instructional Plan Module 07: Selecting, Designing, and Developing Active-Training Methods Module 08: Delivering Training Module 09: Using Visual Aids Module 10: Working with Groups Module 11: Using Creativity Module 12: Evaluating Training Module 13: Training Across Cultures Module 14: Storytelling as a Training Technique Module 15: Using Technology in Training Module 16: Training On the Job Module 17: Training During Tough Times Module 18: The Business of Consulting: Internal and External Assessment Method After completing each module of the Train the Trainer Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification After completing the MCQ/Assignment assessment for this Train the Trainer course, you will be entitled to a Certificate of Completion from Training Tale. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? This Train the Trainer Course is ideal for both existing and future instructor, as well as business owners, managers, human resources personnel, and anyone involved in employee training or development. Requirements There are no specific requirements for this Train the Trainer Course because it does not require any advanced knowledge or skills. Career path The knowledge you will gain through this Train the Trainer Course may lead you to a variety of career opportunities. Such as: Trainer Learning Consultant Curriculum Developer Skills Trainer Crew Trainer Training Coordinator Training Instructor Certificates Certificate of completion Digital certificate - Included

Training, in broad terms, is the process of teaching someone or a group of people to do something new or better. However, for the professional trainer, effective and efficient training entails far more than this. The purpose of this Train the Trainer course is to introduce the skills, knowledge, and character traits that are at the heart of effective training. Effective training requires far more than simply presenting candidates with new ideas and expecting them to respond appropriately. The effective trainer is a charismatic and inspirational leader who naturally develops trust and respect in delegates. Through this Train the Trainer course you will learn how to identify and respond to individual candidates' unique needs, engage even the most difficult audiences, and become a confident communicator. Learn about the art of effective performance management, the value of conflict resolution skills, and a detailed breakdown of the effective workshop planning process. Learning Outcomes After completing this Train the Trainer Course course, learner will be able to: Gain a thorough understanding of needs assessment Gain in-depth knowledge about adult learners Understand training styles Gain a solid understanding of today's learner Know how to write instructional objectives Understand selecting, designing, and developing active-training methods Know how to create a positive learning environment Know how to use visual aids Know how to evaluate training Know how to train across cultures Understand storytelling as a training technique Know how to use technology in training Understand the business of consulting Why Choose Train the Trainer - Training Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. Course developed by industry experts. MCQ quiz after each module to assess your learning. Automated and instant assessment results. 24/7 support via live chat, phone call or email. Free PDF certificate as soon as completing the Course. ***Others Benefits of this Train the Trainer - Training Course Free One PDF Certificate Access to Content - Lifetime Exam Fee - Totally Free Unlimited Retake Exam [ Note: Free PDF certificate as soon as completing the Train the Trainer - Training Course] Detailed course curriculum *** Train the Trainer - Training Course *** Module 01: Assessing Needs Module 02: Understanding Adult Learners Module 03: Training Styles Module 04: Understanding Today's Learner Module 05: Writing Instructional Objectives Module 06: Writing an Instructional Plan Module 07: Selecting, Designing, and Developing Active-Training Methods Module 08: Delivering Training Module 09: Using Visual Aids Module 10: Working with Groups Module 11: Using Creativity Module 12: Evaluating Training Module 13: Training Across Cultures Module 14: Storytelling as a Training Technique Module 15: Using Technology in Training Module 16: Training On the Job Module 17: Training During Tough Times Module 18: The Business of Consulting: Internal and External Assessment Method After completing each module of the Train the Trainer - Training Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification After completing the MCQ/Assignment assessment for this Train the Trainer - Training Course, you will be entitled to a Certificate of Completion from Training Tale. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? This Train the Trainer - Training Course is ideal for both existing and future instructor, as well as business owners, managers, human resources personnel, and anyone involved in employee training or development. Requirements There are no specific requirements for this Train the Trainer - Training Course because it does not require any advanced knowledge or skills. Career path The knowledge you will gain through this Train the Trainer - Training Course may lead you to a variety of career opportunities. Such as: Trainer Learning Consultant Curriculum Developer Skills Trainer Crew Trainer Training Coordinator Training Instructor Certificates Certificate of completion Digital certificate - Included

Duration 5 Days 30 CPD hours The Implementing Cisco Application Centric Infrastructure (DCACI) v1.1 course shows you how to deploy and manage the Cisco© Nexus© 9000 Series Switches in Cisco Application Centric Infrastructure (Cisco ACI©) mode. You will learn how to configure and manage Cisco Nexus 9000 Series Switches in ACI mode, how to connect the Cisco ACI fabric to external networks and services, and the fundamentals of Virtual Machine Manager (VMM) integration. You will gain hands-on practice implementing key capabilities such as fabric discovery, policies, connectivity, VMM integration, and more. This course earns you 40 Continuing Education (CE) credits towards recertification. Additional course details: Nexus Humans Cisco Implementing Cisco Application Centric Infrastructure - Advanced v1.2 (DCACIA) 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 Cisco Implementing Cisco Application Centric Infrastructure - Advanced v1.2 (DCACIA) 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 5 Days 30 CPD hours This course is intended for Motivations: Use and manage containers from first principles & architect basic applications for Kubernetes Roles: general technical audiences & IT professionals CN251 is an intensive cloud native training bootcamp for IT professionals looking to develop skills in deploying and administering containerized applications in Kubernetes. Over the course of five days, students will start with learning about first principles for application containerization followed by learning how to stand up a containerized application in Kubernetes, and, finally, ramping up the skills for day-1 operating tasks for managing a Kubernetes production environment. CN251 is an ideal course for those who need to accelerate the development of their IT skills for a rapidly-changing technology landscape. Additional course details: Nexus Humans Cloud Native Operations Bootcamp 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 Cloud Native Operations Bootcamp 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 aimed at anyone currently working with data who is interested in using data visualisation to more effectively communicate their results. Overview At completion, delegates will understand how data visualisations can be best used to communicate actionable insights from data and be competent with the tools required to do it. Visualising data, and analytics results, is one of the most effective ways to achieve this. This course will cover the theory of data visualisation along with practical skills for creating compelling visualisations from data. Course Outline The use of analytics, statistics and data science in business has grown massively in recent years. Harnessing the power of data is opening actionable insights in diverse industries from banking to horse breeding. The companies doing this most successfully understand that using sophisticated analytics approaches to unlock insights from data is only half the job. Communicating these insights to all of the different parts of an organisation is just as important as doing the actual analysis. Visualising data, and analytics results, is one of the most effective ways to achieve this. This course will cover the theory of data visualisation along with practical skills for creating compelling visualisations from data. To attend this course delegates should be competent in the use of data analysis tools such as reporting tools, spreadsheet software or business intelligence tools. The course will explore the following topics through a series of interactive workshop sessions: Fundamentals of data visualisation Data characteristics & dimensions Mapping visual encodings to data dimensions Colour theory Graphical perception & communication Interaction design Visualisation different characteristics of data: trends, comparisons, correlations, maps, networks, hierarchies, text Designing effective dashboards

Duration 5 Days 30 CPD hours This advanced course teaches the design principles for creating a Citrix Virtual Apps and Desktops virtualization solution. In this training, you will also learn how to assess existing environments, explore different scenarios, and make design decisions based on business requirements. This course covers the Citrix Consulting approach to design and covers the key design decisions through lectures, lab exercises, and interactive discussions. You will also learn about additional considerations and advanced configurations for multi-location solutions and disaster recovery planning. This training will help you prepare for the Citrix Certified Expert in Virtualization (CCE-V) exam. Additional course details: Nexus Humans CWS-415 Citrix Virtual Apps and Desktops 7 Assessment, Design and Advanced Configuration 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 CWS-415 Citrix Virtual Apps and Desktops 7 Assessment, Design and Advanced Configuration 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.

London yoga teacher training course, led by senior teachers with decades of experience. Trauma sensitive, somatic approach. Online and in-person.

EFT is a powerful tool that can be used to increase self-acceptance and self-love. And our EFT course may be exactly what you need if you want to improve your health and personal development. Our EFT course will teach you the principles and techniques of EFT, as well as practical advice on how to apply the technique to your specific needs. This EFT course will not only provide you with the knowledge and skills to effectively use the technique, but it will also assist you in developing a deeper understanding of how your emotions affect your health and well-being. With this knowledge, you will be better able to make positive changes in your life and achieve your objectives. So, if you want to improve your health and personal development, an EFT course could be the solution. EFT, which combines ancient Chinese medicine and modern psychology, can help you heal emotionally and physically and achieve long-term change. Along with this EFT - Emotional Freedom Technique course, you will get 10 premium courses, an originalhardcopy, 11 PDF certificates (Main Course + Additional Courses) Student ID card as gifts. This EFT - Emotional Freedom Technique Bundle Consists of the following Premium courses: Course 1: EFT - Emotional Freedom Technique Course 2: Emotional Intelligence and Human Behaviour Course 3: Applied Behaviour Analysis (ABA) Expert Training Certification Course 4: Biohacking Your Physical and Mental Health Course 5: Stress Management Training Course 3: Counselling Course Course 7: Coaching & Mentoring Course 8: Level 2 Mindfulness for Wellbeing Course 9: First Aid Training Course 10: Nutrition Level 2 Course 11: Time Management Learning outcomes Discover the fundamentals of EFT and its applications in health and care. Develop the ability to assess and identify appropriate contexts for using EFT. Develop your ability to create and deliver tailored EFT treatments. Explore how to incorporate EFT into evidence-based treatments for mental and physical health issues. Recognise the potential for personal development and growth offered by EFT practice. Understand the relationship between EFT and traditional medicine. Discover the ethical implications of using EFT. Learn about the legal frameworks and policies that govern the use of EFT. So, don't wait up. Enrol in our EFT course and be better. Curriculum Course 1: EFT - Emotional Freedom Technique Module 01: What Is EFT (Emotional Freedom Technique)? Module 02: EFT and Emotions, The Brain (EFT with the body) Module 03: EFT Procedure Module 04: Detailed Instructions of EFT Module 05: Applying EFT to Physical Issues Module 06: Treating Children with EFT Module 07: EFT That Can Improve/ Heal Life & Tips Module 08: Doing Business with EFT Course 2: Emotional Intelligence and Human Behaviour Module 01: Human Behaviour and Basic Psychological Process Module 02: Evolutionary Perspective of Human Behaviour Module 03: Human Intelligence Module 04: Intelligence Test and Variations in Intelligence Module 05: Learning and Conditioning Module 06: Language and Communication Module 07: Introduction to Emotion Module 08: Emotion Influences Cognition Module 09: Stress, Anger and Conflict Module 10: Emotional Intelligence Module 11: Self-Leadership Module 12: Neuro-Linguistic Programming (NLP) Course 3: Applied Behaviour Analysis (ABA) Expert Training Certification Introduction to ABA ABA Component Breakdown Rules when Applying ABA Foundation Techniques of ABA ABA for Motor Skills ABA for Language Skills ABA for Cognitive Skills ABA for Visuospatial Skills Generalization in ABA Theory Course 4: Biohacking Your Physical and Mental Health Module 01: Introduction Module 02: Sleep - So MUCH More Than Just Rest Module 03: Blue Light & Red Light Module 04: Mindfulness & Movement Module 05: What You Put In Your Mouth is KEY! Module 06: Hidden Secret - 'Cryotherapy' Module 07: Importance Of PURE Air Module 08: Final Thoughts & Recommendations Course 5: Stress Management Training Beginning Concepts Specific Stress Management Techniques MORE Stress Reduction Strategies Still MORE Stress Reduction Techniques - Part 1 Still MORE Stress Reduction Techniques - Part 2 Still MORE Stress Reduction Techniques - Part 3 BONUS Video & Wrap Up! Special LIVE Bonus Video! Course 6: Counselling Course Introduction to the course Understanding Psychotherapy Starting Psychotherapy Practice Your Potential Clients in Therapy Different Types of Psychotherapy Internet Based Therapy Course 7: Coaching & Mentoring Module 1: Introduction to Coaching and Mentoring Module 2: Coaching and Mentoring: Objectives & Processes Module 3: Ethical Aspects of Coaching and Mentoring Module 4: Coaching and Mentoring Models Module 5: Effective Communication Skills Module 6: Personal Skills Module 7: Management Skills Module 8: Functional Skills Course 8: Level 2 Mindfulness for Wellbeing Introduction & First Concepts Understanding & Beating Anxiety More Anti-Anxiety Skills & Concepts Conclusion Course 9: First Aid Training Introduction to Workplace First Aid Legal Framework for Workplace First Aid Incident Management at Work Primary Survey Secondary Survey Basic First-Aid Techniques Dealing with Minor Injuries at the Workplace Secondary Illness Loss of Responsiveness and CPR Secondary Illness Breathing Problems Secondary Illnesses and Injuries Dealing With Fractures and Dislocations Call for an Emergency Course 10: Nutrition Level 2 Section 01: Nutrition Overview Section 02: Nutrition & Carbs Section 03: Nutrition & Proteins Section 04: Nutrition & Fat Section 05: Nutrition & Water Section 06: Micronutrients Section 07: Effortless Nutrition Section 08: Strategies to Do Today Section 09: Nutrition Myths Section 10: Bonus: Are Diet Foods Good For You? Course 11: Time Management Identifying Goals Effective Energy Distribution Working with Your Personal Style Building Your Toolbox Establishing Your Action Plan How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) If you want to get hardcopy certificates for other courses, generally you have to pay £20 for each. But this Fall, Apex Learning is offering a Flat 50% discount on hard copy certificates, and you can get each for just £10! P.S. The delivery charge inside the U.K. is £3.99 and the international students have to pay £9.99. CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone looking to improve their mental and emotional well-being should consider taking this EFT course. EFT is a powerful, tried and tested tool for emotional healing and personal development. It can help alleviate anxiety, depression, phobias, and stress, as well as help individuals to overcome traumas and past negative experiences. It can also help to improve relationships, boost self-esteem, and increase happiness. Requirements Our bundle is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path The following professions are most popular in this sector EFT Life Coach EFT Practitioner EFT Therapist EFT Energy Worker EFT Workshop Facilitator The salary range for EFT - Emotional Freedom Technique professionals in the UK is typically between £20,000 and £40,000 per year. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Emotional Freedom Technique) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

Duration 5 Days 30 CPD hours This course is intended for This course is intended for entry-level network administrators, network support and help desk technicians. Overview Upon successful completion of this course, students will be able to build, connect and manage networks, and IP traffic routing. In this course the student will learn to install, operate, configure and secure basic and enterprise networks. Networking BasicsNetworking ModelsNetwork AddressingPacket DeliveryDevice ManagementNetwork Security BasicsAdvanced Network Security with ACLsSwitchesAdvanced Switching ConceptsRoutersAdvanced Routing ConceptsBasic Network ServicesCisco Device ManagementTroubleshooting and Data CollectionAdvanced Switch RedundancyOSPF ConfigurationEIGRP ConfigurationPPP WANsFrame Relay WANsSecure VPNs and Tunneling Additional course details: Nexus Humans Cisco Networking 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 Cisco Networking 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.