14629 Courses

Diploma in Counselling and Psychology Diploma in Counselling and Psychology addresses cultural diversity, interpersonal and family relationships, vocational adjustment, and rehabilitation from a developmental perspective. Psychologists address individual, couple, family, community, and workplace problems in this field. Vocational counselling, substance abuse, rehabilitation, education, marital and family therapy, and community mental health are the most common specialities in counselling and psychology. This Diploma in Counselling and Psychology course aims to provide you with in-depth knowledge of Counselling and Psychology. Learn how to help people deal with personal and professional difficulties. There are numerous opportunities to work in well-known institutions and companies. Enrol in our Diploma in Counselling and Psychology: Diploma in Counselling and Psychology today to become a human mind expert and take the first step toward a psychologist or counsellor career. Why choose this Diploma in Counselling and Psychology course from the School of Health Care? Self-paced course, access available from anywhere in the world. High-quality study materials that are easy to understand. Course developed by industry experts. After each module, there will be an MCQ quiz to assess your learning. Assessment results are generated automatically and instantly. 24/7 support is available via live chat, phone call, or email. Free PDF certificate after completing the course. Special Offers of this Diploma in Counselling and Psychology Course: This Diploma in Counselling and Psychology: Diploma in Counselling and Psychology Course includes a FREE PDF Certificate. Lifetime access to this Diploma in Counselling and Psychology: Diploma in Counselling and Psychology Course Instant access to this Diploma in Counselling and Psychology: Diploma in Counselling and Psychology Course 24/7 Support Available to this Diploma in Counselling and Psychology: Diploma in Counselling and Psychology Course Diploma in Counselling and Psychology Learning Outcomes After completing this Diploma in Counselling and Psychology: Diploma in Counselling and Psychology, the learner will be able to: Gain a thorough understanding of counselling. Understand the therapeutic relationship. Gain in-depth knowledge about positive psychology. Understand psychoanalytic therapy. Understand person‐centred therapy. Understand Adlerian therapy. Understand psychoanalytic therapy. Understand Gestalt Therapy & cognitive‐behaviour therapy. Understand family therapy & feminist therapy. Who is this course for? Diploma in Counselling and Psychology This Diploma in Counselling and Psychology: Diploma in Counselling and Psychology is designed for anyone who wants to gain knowledge in counselling and psychology. Requirements Diploma in Counselling and Psychology To enrol in this Diploma in Counselling and Psychology Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Diploma in Counselling and Psychology Course. Be energetic and self-motivated to complete our Diploma in Counselling and Psychology Course. Basic computer Skill is required to complete our Diploma in Counselling and Psychology: Diploma in Counselling and Psychology Course. If you want to enrol in our Diploma in Counselling and Psychology: Diploma in Counselling and Psychology Course, you must be at least 15 years old. Career path Diploma in Counselling and Psychology After completing this Diploma in Counselling and Psychology: Diploma in Counselling and Psychology, candidates may pursue careers such as: Operating Own Counselling Practice Careers Counsellor or Adviser Family and Marriage Counsellor Rehabilitation Counsellor

Diploma in Health and Social Care Management Level 6 Training Are you looking for a rewarding career that will allow you to help people succeed in their daily lives? Are you considering a career as a nurse, paramedic, health visitor, or social worker? Are you looking for a way to break into the healthcare industry? If this is the case, the Level 6 Diploma in Health and Social Care Management can assist you in developing skills and knowledge that will propel your career forward and open doors to enticing opportunities! Students can demonstrate their abilities by producing evidence from their work activities to meet national occupational standards. Through this Level 6 Diploma in Health and Social Care Management course, learners will acquire care management skills in the health and social care sector. Enrol in our Level 6 Diploma in Health and Social Care Management today and make a life-changing decision, gaining the knowledge you need to transform your career. Main Course: Level 6 Diploma in Health and Social Care Management Free Course: Course 01: Healthcare Assistant Course 02: Healthcare Management Training Course 03: Level 2 Certificate in Understanding Working in the Health Sector [ Note: Free PDF certificate as soon as completing Diploma in Health and Social Care Management Level 6 Training Course] Diploma in Health and Social Care Management Level 6 Training This Diploma in Health and Social Care Management Level 6 Training course consists of 13 modules. Assessment Method of Diploma in Health and Social Care Management Level 6 Training After completing Level 6 Diploma in Health and Social Care Management Course, you will get quizzes to assess your learning. You will do the later modules upon getting 60% marks on the quiz test. Certification of Diploma in Health and Social Care Management Level 6 Training After completing the Level 6 Diploma in Health and Social Care Management course, you can instantly download your certificate for FREE. The hard copy of the certification will also be delivered to your doorstep via post, which will cost £13.99. Who is this course for? Diploma in Health and Social Care Management Level 6 Training This Diploma in Health and Social Care Management Level 6 Training course is ideal for working or planning to work in hospitals, health and social care Organisations. Requirements Diploma in Health and Social Care Management Level 6 Training To enrol in this Diploma in Health and Social Care Management Level 6 Training Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Diploma in Health and Social Care Management Level 6 Training Course. Be energetic and self-motivated to complete our Level 3 Award in Health and Social Care Course. Basic computer Skill is required to complete our Level 3 Award in Health and Social Care Course. If you want to enrol in our Level 3 Award in Health and Social Care Course, you must be at least 15 years old. Career path Diploma in Health and Social Care Management Level 6 Training

Project Management: Project Management Course Online Unlock the Power of Project Management: Project Management Course: Enrol Now! Project management professionals are required at all levels in both the private and public sectors. Project Management: Project Management Course is a sector that focuses on the planning, implementation, and supervision of critical projects that are at the heart of the modern business. The Project Management: Project Management Course will introduce you to both fundamental and cutting-edge project management concepts. Throughout seventeen engaging modules, you will learn about project tools, techniques, and standards, as well as what is used in your organization. This Project Management: Project Management Course will help those new to project management lead and contribute to projects more effectively. Defining a project, planning a project, managing project quality and risk, managing project scope, managing project time, managing project communication, and managing global projects are some highlights of the course. Main Course: Level 7 Project Management Course Free Courses included with Project Management: Project Management Course: Along with Project Management Course you will get free Anger Management Along with Project Management Course you will get free Level 1 Business Management Special Offers of this Project Management: Project Management Course: This Project Management: Project Management Course includes a FREE PDF Certificate. Lifetime access to this Project Management: Project Management Course Instant access to this Project Management: Project Management Course 24/7 Support Available to this Project Management: Project Management Course Project Management: Project Management Course Online You will learn both conventional and modern project management ideas during our Project Management: Project Management Course. With the help of our Project Management: Project Management Course's 17 interesting modules, you'll learn more about the methods, standards, and methodology adopted in projects as well as those employed by your company. Those who are new to project management will also benefit from this Level 7 project management course by learning how to lead and participate in projects more successfully. The Project Management: Project Management Course's features include defining a project, planning a project, managing project quality and risk, managing project scope, managing project time, managing project communication, and managing global projects. Who is this course for? Project Management: Project Management Course Online This Project Management: Project Management Course is ideal for project managers and owners who wish to improve their skills and abilities. Professionals looking to upgrade their efficiency and productivity can also benefit from this Project Management: Project Management Course. Requirements Project Management: Project Management Course Online To enrol in this Project Management: Project Management Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Project Management: Project Management Course Be energetic and self-motivated to complete our Project Management: Project Management Course. Basic computer Skill is required to complete our Project Management: Project Management Course. If you want to enrol in our Project Management: Project Management Course you must be at least 15 years old. Career path Project Management: Project Management Course Online Project Management: Project Management Course carries wide and diverse career choices, which include: Project Assistant Project Management Support Project Analyst Project Coordinator

Dog Training: Dog Training Course Online This Dog Training: Dog Training Course aims to provide candidates with the knowledge and understanding required to pursue a career in canine care. Learners will understand the fundamentals of canine anatomy, physiology, and behaviour and will be able to provide physical enrichment for canines in their care. This Dog Training: Dog Training Course begins with fundamental knowledge of Dog Training and Husbandry and progresses to share expert knowledge. This Dog Training: Dog Training Course will provide you with a comprehensive understanding of Dog Training and Husbandry, including key concepts, strategies for using it, and in-depth knowledge. The Dog Training: Dog Training Course is completely online. With a smart device and the internet, you can access this Dog Training: Dog Training Course from anywhere in the world. Enrol Dog Training: Dog Training Course today and take the next step towards your personal and professional goals. Why choose this Dog Training: Dog Training Course from the School of Health Care? Self-paced Dog Training course, access available from anywhere in the world. High-quality study materials that are easy to understand. Dog Training: Dog Training Course developed by industry experts. After each module, there will be an MCQ quiz to assess your learning. Assessment results are generated automatically and instantly. 24/7 support is available via live chat, phone call, or email. Free PDF certificate after completing the Dog Training: Dog Training Course. Courses you will get with This Dog Training: Dog Training Course: Course 01: Dog Training Course 02: Level 5 Animal Care & Nutrition Course 03: Dog First Aid [ Note: Free PDF certificate as soon as completing the Dog Training: Dog Training Course] Dog Training: Dog Training Course Online Unlock the full potential of your canine companion with our Dog Training: Dog Training Course. Starting with the basics, this Dog Training: Dog Training program gradually expands to advanced techniques, offering a deep understanding of dog behavior and husbandry. Whether you're a novice or an experienced dog owner, the Dog Training: Dog Training course covers essential strategies and methods to master effective training. Accessible entirely online, you can take the Dog Training: Dog Training course from anywhere, using just your smart device and the internet. Elevate your skills today and become an expert in Dog Training: Dog Training! Who is this course for? Dog Training: Dog Training Course Online This Dog Training: Dog Training Course is ideal for anyone working in animal care or who wants to learn more about dog training and husbandry so they can better support their own dogs. Requirements Dog Training: Dog Training Course Online To enrol in this Dog Training: Dog Training Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Dog Training: Dog Training Course. Be energetic and self-motivated to complete our Dog Training: Dog Training Course. Basic computer Skill is required to complete our Dog Training: Dog Training Course. If you want to enrol in our Dog Training: Dog Training Course, you must be at least 15 years old. Career path Dog Training: Dog Training Course Online

Sports Nutrition: Sports Nutrition Course Online Unlock the Power of Sports Nutrition: Sports Nutrition Course Online: Enrol Now! If you want to learn about Sports Nutrition: Sports Nutrition Course and become an expert in the field, you have arrived at the right place. Whether you are a bodybuilder, a professional athlete, or simply working out to improve your health, sports nutrition is important for getting the most out of your physical activity. Better nutrition and hydration decisions can lead to improved performance, recovery, and injury prevention. If you regularly exercise and want to gain sound advice and specialist knowledge in this area, this Sports Nutrition: Sports Nutrition Course is perfect. This Sports Nutrition Course will give you sports nutrition advice to help you understand the main nutritional areas and keep your diet well balanced, healthy, and supportive towards the fitness level you want to maintain or achieve. The purpose of this Sports Nutrition: Sports Nutrition Course is to teach an individual about the fundamental and advanced mechanisms of nutrition as a whole that will help an athlete perform at his or her best. Main Course: Sports Nutrition Course Free courses included with Sports Nutrition: Sports Nutrition Course. Along with Sports Nutrition Course you will get free Personal Trainer Along with Sports Nutrition Course you will get free Sports First Aid Special Offers of this Sports Nutrition: Sports Nutrition Course: This Sports Nutrition: Sports Nutrition Course includes a FREE PDF Certificate. Lifetime access to this Sports Nutrition: Sports Nutrition Course Instant access to this Sports Nutrition: Sports Nutrition Course 24/7 Support Available to this Sports Nutrition: Sports Nutrition Course Sports Nutrition: Sports Nutrition Course Online You'll receive professional advice from our Sports Nutrition: Sports Nutrition Course on how to meet your fitness objectives. Sports nutrition offers you the individualized techniques required for individualized nutrition guidance, rehabilitation, and training. This Sports Nutrition: Sports Nutrition Course will also teach you about the healthy digestive system. After completing this sports nutrition course, you'll be able to provide customers sound advice on how to regulate their weight. Who is this course for? Sports Nutrition: Sports Nutrition Course Online The Sports Nutrition: Sports Nutrition Course is designed for candidates who want to advance their careers as a Nutritionist, Chef, Dietician, Health Service Manager. Athletes, coaches, and personal trainers can also enrol in this Sports Nutrition Course for self-improvement. Requirements Sports Nutrition: Sports Nutrition Course Online To enrol in this Sports Nutrition: Sports Nutrition Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Sports Nutrition: Sports Nutrition Course. Be energetic and self-motivated to complete our Sports Nutrition: Sports Nutrition Course. Basic computer Skill is required to complete our Sports Nutrition: Sports Nutrition Course. If you want to enrol in our Sports Nutrition: Sports Nutrition Course, you must be at least 15 years old. Career path Sports Nutrition: Sports Nutrition Course Online This Sports Nutrition: Sports Nutrition Course will help you open up opportunities in the following career paths: Sports Nutritionist Food Technologist Lead Nutritionist Personal Trainer Fitness instructor Gym Instructor etc.

Level 2 Certificate in Understanding Domestic Abuse Course Online According to the annual Crime Survey, almost 2.5 Million adults experience domestic abuse: domestic abuse each year. Furthermore, one in every five children witnesses or is a victim of domestic abuse: domestic abuse as a child. Although domestic abuse: domestic abuse is often an unreported crime, most cases are kept hidden. This Level 2 Certificate in Understanding Domestic Abuse Course aims to increase learners' awareness and understanding of domestic abuse: domestic abuse and its impacts. Domestic abuse: domestic abuse and its impacts must be understood by those working in various fields, including healthcare, social care, childcare, education, and housing. Why choose this Level 2 Certificate in Understanding Domestic Abuse Course from the School of Health Care? Self-paced course, access available from anywhere in the world. High-quality study materials that are easy to understand. Level 2 Certificate in Understanding Domestic Abuse Course developed by industry experts. After each module, there will be an MCQ quiz to assess your learning. Assessment results are generated automatically and instantly. 24/7 support is available via live chat, phone call, or email. Free PDF certificate after completing the Level 2 Certificate in Understanding Domestic Abuse: Domestic Abuse Course. Main Course: Level 2 Certificate in Understanding Domestic Abuse Course Free Courses included with Level 2 Certificate in Understanding Domestic Abuse Course Course 01: Equality and Diversity Course 02: Healthcare Management Training Course 03: Level 5 Mental Health First Aid Certification Course 04: Mental Health Support Worker Special Offers of this Level 2 Certificate in Understanding Domestic Abuse: Domestic Abuse Course: This Level 2 Certificate in Understanding Domestic Abuse: Domestic Abuse Course includes a FREE PDF Certificate. Lifetime access to this Level 2 Certificate in Understanding Domestic Abuse: Domestic Abuse Course Instant access to this Level 2 Certificate in Understanding Domestic Abuse: Domestic Abuse Course 24/7 Support Available to this Level 2 Certificate in Understanding Domestic Abuse: Domestic Abuse Course [ Note: Free PDF certificate as soon as completing the Level 2 Certificate in Understanding Domestic Abuse: Domestic Abuse Course] Level 2 Certificate in Understanding Domestic Abuse Course Online This Level 2 Certificate in Understanding Domestic Abuse: Domestic Abuse Course consists of 04 modules. Course Curriculum of Level 2 Certificate in Understanding Domestic Abuse Course Module 01: Understand Domestic Abuse Module 02: Understand the Signs and Risk Factors Associated with Domestic Abuse Module 03: Understand the Impact of Domestic Abuse Module 04: Understand Policy, Response and Intervention in Relation to Domestic Abuse Assessment Method of Level 2 Certificate in Understanding Domestic Abuse Course After completing Working in Level 2 Certificate in Understanding Domestic Abuse: Domestic Abuse Course, you will get quizzes to assess your learning. You will do the later modules upon getting 60% marks on the quiz test. Apart from this, you do not need to sit for any other assessments. Who is this course for? Level 2 Certificate in Understanding Domestic Abuse Course Online This Level 2 Certificate in Understanding Domestic Abuse: Domestic Abuse course is ideal for anyone who has a responsibility to support those experiencing domestic abuse: domestic abuse. Special Note: Our Level 2 Certificate in Understanding Domestic Abuse: Domestic Abuse Course is not a regulated course. If you prefer to get qualified, you can look at the following options: NCFE CACHE Level 2 Certificate in Understanding Domestic Abuse: Domestic Abuse Requirements Level 2 Certificate in Understanding Domestic Abuse Course Online To enrol in this Understanding Domestic Abuse: Domestic Abuse Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Understanding Domestic Abuse: Domestic Abuse Course. Be energetic and self-motivated to complete our Understanding Domestic Abuse: Domestic Abuse Course. Basic computer Skill is required to complete our Understanding Domestic Abuse: Domestic Abuse Course. If you want to enrol in our Understanding Domestic Abuse: Domestic Abuse Course, you must be at least 15 years old. Career path Level 2 Certificate in Understanding Domestic Abuse Course Online Upon completing this Level 2 Certificate in Understanding Domestic Abuse: Domestic Abuse course, you can become familiarised with the response and support of those domestically abused.

Join our Microsoft Excel course and discover your hidden skills, setting you on a path to success in this area. Get ready to improve your skills and achieve your biggest goals. The Microsoft Excel course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The Microsoft Excel course is designed to teach you the important stuff quickly and well, helping you to get off to a great start in the field. So, what are you looking for? Enrol now! You will Learn The Following Things: Learn strategies to boost your workplace efficiency. Hone your skills to help you advance your career. Acquire a comprehensive understanding of various topics and tips. Learn in-demand skills that are in high demand among UK employers This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Microsoft Excel. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-to-one support from a dedicated tutor throughout your course. Study online - whenever and wherever you want. Instant Digital/ PDF certificate 100% money back guarantee 12 months access Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement After completing the Microsoft Excel course, you will receive your CPD-accredited Digital/PDF Certificate for £5.99. To get the hardcopy certificate for £12.99, you must also pay the shipping charge of just £3.99 (UK) and £10.99 (International). Who Is This Course for? This Microsoft Excel is suitable for anyone aspiring to start a career in relevant field; even if you are new to this and have no prior knowledge, this course is going to be very easy for you to understand.  On the other hand, if you are already working in this sector, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Microsoft Excel course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career Path The certification and skills you get from this Microsoft Excel Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors. Course Curriculum Unit 01: Excel from A-Z Course Introduction Excel from A-Z Course Intro 00:03:00 Excel Job Opportunities 00:03:00 Excel Job Types 00:04:00 Microsoft Excel Marketplace 00:04:00 What is Microsoft Excel? 00:04:00 Who is This Course For? 00:03:00 Unit 02: Getting Started With Excel Finding & Opening Excel 00:01:00 Excel's Start Screen 00:03:00 Explaining the Excel Interface 00:03:00 Excel Interface Continued 00:01:00 Excel Workbook vs. Excel Worksheet 00:02:00 Saving an Excel Document 00:04:00 Customizing the Quick Access Toolbar 00:02:00 Customizing the Excel Ribbon 00:03:00 Excel Shortcut Keys 00:02:00 Unit 03: Values, Referencing and Formulas Creating Excel Labels 00:03:00 Entering Numeric Values in Excel 00:03:00 Formatting Date Values in Excel 00:05:00 Building Basic Formulas in Excel 00:05:00 Order of Operations 00:06:00 Relative vs. Absolute Cell References 00:07:00 Unit 04: Intro to Excel Functions Excel Functions Explained 00:03:00 The SUM() Function 00:08:00 The MIN() & MAX() Function 00:04:00 The AVERAGE() Function 00:02:00 COUNT() Functions 00:05:00 Unit 05: Adjusting Excel Worksheets Moving & Copying Data 00:07:00 Insert & Delete Rows and Columns 00:05:00 Adjusting the Width and Height of Cells 00:05:00 Hiding and Unhiding Excel Rows and Columns 00:04:00 Renaming, Moving & Deleting Excel Worksheets 00:05:00 Adding Protection to Specific Cells 00:04:00 Protecting the Structure of a Workbook 00:02:00 Adding a Workbook Password to Open File 00:02:00 Unit 06: Visually Pleasing Cell Formatting Formatting Fonts and Cell Background Color 00:05:00 Adding Cell Borders 00:05:00 Formatting Data Appropriately 00:05:00 The Magic behind Excel's Format Painter 00:03:00 Creating Styles for Formatting Efficiency 00:06:00 Merging Cells for a Cleaner Look 00:03:00 The Power of Conditional Formatting 00:06:00 Unit 07: How to Insert Images and Shapes! Grab User's Attention using Illustrations 00:09:00 Customizing Icons 00:05:00 Create Compelling Graphics with SmartArt 00:06:00 Unit 08: Visualize Data with Charts The Commonly Used Column Chart 00:03:00 Changing the Chart Design.mp4 00:02:00 Formatting Elements of a Chart 00:06:00 Modifying the Data, Type & Location of a Chart 00:06:00 Unit 09: Excel's Printing Options Print Preview Options 00:04:00 Excel's Page Layout View 00:07:00 Printing a Specific Range of Cells 00:03:00 Converting Spreadsheets to PDF Files 00:02:00 Unit 10: Benefits of Using Excel Templates Why Create an Excel Template 00:01:00 How to Create an Excel Template 00:05:00 Unit 11: Working with Excel Datasets How to Prepare Data for Analysis 00:04:00 How to Sort Data in Excel 00:03:00 Multi-Level Sorting 00:03:00 Custom Sorting Datasets in Excel 00:02:00 Applying Filters to Datasets 00:05:00 Creating Subtotals within a Dataset 00:06:00 Converting Datasets into Tables 00:06:00 Little Slice of Pie Charts 00:05:00 Finding & Removing Duplicate Values 00:07:00 Unit 12: Excel Database Functions The SUMIF() Function 00:09:00 The DSUM() Function 00:08:00 The DSUM() Function Cont. 00:07:00 The SUBTOTAL() Function 00:06:00 Unit 13: Excel Data Validation What is Excel Data Validation? 00:02:00 Creating a Drop Down List with Data Validation 00:07:00 Different Types of Excel Data Validation 00:06:00 Adding Custom Alerts to Data Validation 00:07:00 Creating a Dynamic Drop Down List 00:03:00 Complex Validation: Dependent Drop Down List! 00:09:00 Unit 14: Excel PivotTables Creating an Excel Pivot Table 00:06:00 Modifying Excel PivotTables 00:06:00 Grouping & Filtering PivotTable Data 00:06:00 Drilling Down into PivotTable Data 00:02:00 Creating Pivot Charts & Utilizing Slicers 00:08:00 Unit 15: Excel's PowerPivot Add-In What is PowerPivot? 00:04:00 Activating the Excel PowerPivot Add-In 00:02:00 Creating Relationships between Data Tables.mp4 00:06:00 Using Data Models to Create PivotTables 00:05:00 How to Create PowerPivot KPI's 00:08:00 Unit 16: Excel's Conditional Functions Excels IF Function 00:05:00 IF() Function with AND() Criteria 00:05:00 IF() Function with OR() Criteria 00:05:00 Nesting Multiple IF() Functions 00:07:00 The COUNTIF() Function 00:04:00 Key Benefits of Named Ranges 00:04:00 Unit 17: Excel's Lookup Function VLOOKUP() Function 00:09:00 The Beauty of Excel's IFERROR() Function 00:04:00 HLOOKUP() Function 00:06:00 The INDEX Function 00:05:00 MATCH() Function 00:05:00 INDEX() and MATCH() Combined 00:05:00 Two-Way Lookup with INDEX() and MATCH() 00:04:00 Unit 18: Text Based Functions in Excel LEFT(), RIGHT() and MID() Function 00:07:00 Extracting Specific Text using LEN() & SEARCH() 00:13:00 Combining Text with CONCATENATE() 00:06:00 Quick Tips & Other Text Based Functions 00:06:00 Unit 19: Auditing Formulas and Views in Excel Tracing Precedents & Dependents in Formulas 00:04:00 Showing Formulas 00:02:00 Grouping Data 00:03:00 3D Referencing in Formulas 00:05:00 Utilizing the Watch Window in Excel 00:03:00 How to Freeze Panes in Excel 00:03:00 Unit 20: Excel's 'what If?' Tools Excel's Scenario Manager Tool 00:06:00 Goal Seek in Excel 00:06:00 Compare Results with Excel Data Tables 00:04:00 Solver Tool 00:11:00 Unit 21: Welcome to Excel VBA The Power Behind Excel VBA 00:03:00 A Look Inside the Visual Basic Editor (VBE) 00:04:00 Recording a Macro 00:09:00 Saving & Opening a Macro-Enabled Workbook 00:02:00 Unit 22: The VBA Language Modules and Procedures 00:07:00 Objects, Methods and Properties 00:06:00 Excel VBA Variables 00:05:00 Unit 23: Writing VBA Code Referencing a Range 00:13:00 InputBox & MsgBox 00:06:00 Using Variables in VBA Code 00:05:00 If Then Else Statement 00:10:00 Worksheet Functions inside VBA 00:08:00 Creating User Defined Functions 00:09:00 User Defined Functions within VBA Scripts 00:06:00 Unit 24: Important VBA Tools and Logic Find Last Row of Data 00:06:00 Find Last Column of Data 00:03:00 With Statement 00:05:00 Debugging & Error Handling 00:07:00 Debugging & Error Handling Cont. 00:07:00 Unit 25: Excel VBA Loop For Next Loop 00:09:00 Do Until Loop 00:06:00 For Each Loop 00:04:00 Unit 26: Triggering Macros Assigning Macros to Shapes 00:04:00 Form Controls vs ActiveX Controls 00:08:00 Worksheet Events 00:04:00 Workbook Events 00:03:00 Fun with VBA Events! 00:07:00 Unit 27: Excel User Forms Creating an Excel UserForm 00:03:00 Adding Controls to UserForms 00:10:00 How to Show an UserForm 00:03:00 Passing TextBox Values to Desired Cells 00:07:00 Passing Option Buttons to Desired Cells 00:07:00 UserForm ComboBoxes 00:08:00 Clearing Values from UserForm Controls 00:03:00 How to Close an UserForm 00:02:00 UserForms and Protected Sheets 00:05:00 Unit 28: Starting a Career in Excel Creating an Excel Resume 00:05:00 Getting Started with Freelancing 00:06:00 How to Become an Excel Freelancer 00:05:00 Top Freelance Websites 00:05:00 How to Get Your First Client 00:08:00 Personal Branding 00:07:00 Networking Do's and Don'ts 00:04:00 Importance of Having a Website 00:04:00 Resources Resources - Microsoft Excel 00:00:00

Duration 3 Days 18 CPD hours Overview The goal of this course is to enable technical students new to Cassandra to begin working with Cassandra in an optimal manner. Throughout the course students will learn to: Understand the Big Data needs that C* addresses Be familiar with the operation and structure of C* Be able to install and set up a C* database Use the C* tools, including cqlsh, nodetool, and ccm (Cassandra Cluster Manager) Be familiar with the C* architecture, and how a C* cluster is structured Understand how data is distributed and replicated in a C* cluster Understand core C* data modeling concepts, and use them to create well-structured data models Be familiar with the C* eventual consistency model and use it intelligently Be familiar with consistency mechanisms such as read repair and hinted handoff Understand and use CQL to create tables and query for data Know and use the CQL data types (numerical, textual, uuid, etc.) Be familiar with the various kinds of primary keys available (simple, compound, and composite primary keys) Be familiar with the C* write and read paths Understand C* deletion and compaction The Cassandra (C*) database is a massively scalable NoSQL database that provides high availability and fault tolerance, as well as linear scalability when adding new nodes to a cluster. It has many powerful capabilities, such as tunable and eventual consistency, that allow it to meet the needs of modern applications, but also introduce a new paradigm for data modeling that many organizations do not have the expertise to use in the best way.Introduction to Cassandra is a hands-on course designed to teach attendees the basics of how to create good data models with Cassandra. This technical course has a focus on the practical aspects of working with C*, and introduces essential concepts needed to understand Cassandra, including enough coverage of internal architecture to make good decisions. It is hands-on, with labs that provide experience in core functionality. Students will also explore CQL (Cassandra Query Language), as well as some of the ?anti-patterns? that lead to non-optimal C* data models and be ready to work on production systems involving Cassandra. Session 1: Cassandra Overview Why We Need Cassandra - Big Data Challenges vs RDBMS High level Cassandra Overview Cassandra Features Optional: Basic Cassandra Installation and Configuration Session 2: Cassandra Architecture and CQL Overview Cassandra Architecture Overview Cassandra Clusters and Rings Nodes and Virtual Nodes Data Replication in Cassandra Introduction to CQL Defining Tables with a Single Primary Key Using cqlsh for Interactive Querying Selecting and Inserting/Upserting Data with CQL Data Replication and Distribution Basic Data Types (including uuid, timeuuid) Session 3: Data Modeling and CQL Core Concepts Defining a Compound Primary Key CQL for Compound Primary Keys Partition Keys and Data Distribution Clustering Columns Overview of Internal Data Organization Overview of Other Querying Capabilities ORDER BY, CLUSTERING ORDER BY, UPDATE , DELETE, ALLOW FILTERING Batch Queries Data Modeling Guidelines Denormalization Data Modeling Workflow Data Modeling Principles Primary Key Considerations Composite Partition Keys Defining with CQL Data Distribution with Composite Partition Key Overview of Internal Data Organization Session 4: Additional CQL Capabilities Indexing Primary/Partition Keys and Pagination with token() Secondary Indexes and Usage Guidelines Cassandra collections Collection Structure and Uses Defining and Querying Collections (set, list, and map) Materialized View Overview Usage Guidelines Session 5: Data Consistency In Cassandra Overview of Consistency in Cassandra CAP Theorem Eventual (Tunable) Consistency in C* - ONE, QUORUM, ALL Choosing CL ONE Choosing CL QUORUM Achieving Immediate Consistency Overview of Other Consistency Levels Supportive Consistency Mechanisms Writing / Hinted Handoff Read Repair Nodetool repair Session 6: Internal Mechanisms Ring Details Partitioners Gossip Protocol Snitches Write Path Overview / Commit Log Memtables and SSTables Write Failure Unavailable Nodes and Node Failure Requirements for Write Operations Read Path Overview Read Mechanism Replication and Caching Deletion/Compaction Overview Delete Mechanism Tombstones and Compaction Session 7: Working with IntelliJ Configuring JDBC Data Source for Cassandra Reading Schema Information Querying and Editing Tables. Additional course details: Nexus Humans Introduction to Cassandra (TTDS6776) 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 Introduction to Cassandra (TTDS6776) 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 4 Days 24 CPD hours This course is intended for This class is intended for experienced developers who are responsible for managing big data transformations including: Extracting, loading, transforming, cleaning, and validating data. Designing pipelines and architectures for data processing. Creating and maintaining machine learning and statistical models. Querying datasets, visualizing query results and creating reports Overview Design and build data processing systems on Google Cloud Platform. Leverage unstructured data using Spark and ML APIs on Cloud Dataproc. Process batch and streaming data by implementing autoscaling data pipelines on Cloud Dataflow. Derive business insights from extremely large datasets using Google BigQuery. Train, evaluate and predict using machine learning models using TensorFlow and Cloud ML. Enable instant insights from streaming data Get hands-on experience with designing and building data processing systems on Google Cloud. This course uses lectures, demos, and hand-on labs to show you how to design data processing systems, build end-to-end data pipelines, analyze data, and implement machine learning. This course covers structured, unstructured, and streaming data. Introduction to Data Engineering Explore the role of a data engineer. Analyze data engineering challenges. Intro to BigQuery. Data Lakes and Data Warehouses. Demo: Federated Queries with BigQuery. Transactional Databases vs Data Warehouses. Website Demo: Finding PII in your dataset with DLP API. Partner effectively with other data teams. Manage data access and governance. Build production-ready pipelines. Review GCP customer case study. Lab: Analyzing Data with BigQuery. Building a Data Lake Introduction to Data Lakes. Data Storage and ETL options on GCP. Building a Data Lake using Cloud Storage. Optional Demo: Optimizing cost with Google Cloud Storage classes and Cloud Functions. Securing Cloud Storage. Storing All Sorts of Data Types. Video Demo: Running federated queries on Parquet and ORC files in BigQuery. Cloud SQL as a relational Data Lake. Lab: Loading Taxi Data into Cloud SQL. Building a Data Warehouse The modern data warehouse. Intro to BigQuery. Demo: Query TB+ of data in seconds. Getting Started. Loading Data. Video Demo: Querying Cloud SQL from BigQuery. Lab: Loading Data into BigQuery. Exploring Schemas. Demo: Exploring BigQuery Public Datasets with SQL using INFORMATION_SCHEMA. Schema Design. Nested and Repeated Fields. Demo: Nested and repeated fields in BigQuery. Lab: Working with JSON and Array data in BigQuery. Optimizing with Partitioning and Clustering. Demo: Partitioned and Clustered Tables in BigQuery. Preview: Transforming Batch and Streaming Data. Introduction to Building Batch Data Pipelines EL, ELT, ETL. Quality considerations. How to carry out operations in BigQuery. Demo: ELT to improve data quality in BigQuery. Shortcomings. ETL to solve data quality issues. Executing Spark on Cloud Dataproc The Hadoop ecosystem. Running Hadoop on Cloud Dataproc. GCS instead of HDFS. Optimizing Dataproc. Lab: Running Apache Spark jobs on Cloud Dataproc. Serverless Data Processing with Cloud Dataflow Cloud Dataflow. Why customers value Dataflow. Dataflow Pipelines. Lab: A Simple Dataflow Pipeline (Python/Java). Lab: MapReduce in Dataflow (Python/Java). Lab: Side Inputs (Python/Java). Dataflow Templates. Dataflow SQL. Manage Data Pipelines with Cloud Data Fusion and Cloud Composer Building Batch Data Pipelines visually with Cloud Data Fusion. Components. UI Overview. Building a Pipeline. Exploring Data using Wrangler. Lab: Building and executing a pipeline graph in Cloud Data Fusion. Orchestrating work between GCP services with Cloud Composer. Apache Airflow Environment. DAGs and Operators. Workflow Scheduling. Optional Long Demo: Event-triggered Loading of data with Cloud Composer, Cloud Functions, Cloud Storage, and BigQuery. Monitoring and Logging. Lab: An Introduction to Cloud Composer. Introduction to Processing Streaming Data Processing Streaming Data. Serverless Messaging with Cloud Pub/Sub Cloud Pub/Sub. Lab: Publish Streaming Data into Pub/Sub. Cloud Dataflow Streaming Features Cloud Dataflow Streaming Features. Lab: Streaming Data Pipelines. High-Throughput BigQuery and Bigtable Streaming Features BigQuery Streaming Features. Lab: Streaming Analytics and Dashboards. Cloud Bigtable. Lab: Streaming Data Pipelines into Bigtable. Advanced BigQuery Functionality and Performance Analytic Window Functions. Using With Clauses. GIS Functions. Demo: Mapping Fastest Growing Zip Codes with BigQuery GeoViz. Performance Considerations. Lab: Optimizing your BigQuery Queries for Performance. Optional Lab: Creating Date-Partitioned Tables in BigQuery. Introduction to Analytics and AI What is AI?. From Ad-hoc Data Analysis to Data Driven Decisions. Options for ML models on GCP. Prebuilt ML model APIs for Unstructured Data Unstructured Data is Hard. ML APIs for Enriching Data. Lab: Using the Natural Language API to Classify Unstructured Text. Big Data Analytics with Cloud AI Platform Notebooks What's a Notebook. BigQuery Magic and Ties to Pandas. Lab: BigQuery in Jupyter Labs on AI Platform. Production ML Pipelines with Kubeflow Ways to do ML on GCP. Kubeflow. AI Hub. Lab: Running AI models on Kubeflow. Custom Model building with SQL in BigQuery ML BigQuery ML for Quick Model Building. Demo: Train a model with BigQuery ML to predict NYC taxi fares. Supported Models. Lab Option 1: Predict Bike Trip Duration with a Regression Model in BQML. Lab Option 2: Movie Recommendations in BigQuery ML. Custom Model building with Cloud AutoML Why Auto ML? Auto ML Vision. Auto ML NLP. Auto ML Tables.

Duration 4 Days 24 CPD hours This course is intended for Application developers who want to increase their understanding of Spring and Spring Boot with hands-on experience and a focus on fundamentals Overview By the end of the course, you should be able to meet the following objectives: Spring configuration using Java Configuration and Annotations Aspect oriented programming with Spring Testing Spring applications using JUnit 5 Spring Data Access - JDBC, JPA and Spring Data Spring Transaction Management Simplifying application development with Spring Boot Spring Boot auto-configuration, starters and properties Build a simple REST application using Spring Boot, embedded Web Server and fat JARs or classic WARs Implementing REST client applications using RestTemplate and WebClient Spring Security Enable and extend metrics and monitoring capabilities using Spring Boot actuator Utilize Spring Boot enhancements to testing This course offers hands-on experience with the major features of Spring and Spring Boot, which includes configuration, data access, REST, AOP, auto-configuration, actuator, security, and Spring testing framework to build enterprise and microservices applications. On completion, participants will have a foundation for creating enterprise and cloud-ready applications. Introduction to Spring Java configuration and the Spring application context @Configuration and @Bean annotations @Import: working with multiple configuration files Defining bean scopes Launching a Spring Application and obtaining Beans Spring JAVA Configuration: A Deeper Look External properties & Property sources Environment abstraction Using bean profiles Spring Expression Language (SpEL) Annotation-based Dependency Injection Component scanning Autowiring using @Autowired Java configuration versus annotations, mixing. Lifecycle annotations: @PostConstruct and @PreDestroy Stereotypes and meta-annotations Factory Pattern in Spring Using Spring FactoryBeans Advanced Spring: How Does Spring Work Internally? The Spring Bean Lifecycle The BeanFactoryPostProcessor interception point The BeanPostProcessor interception point Spring Bean Proxies @Bean method return types Aspect-oriented programming What problems does AOP solve? Defining pointcut expressions Implementing various types of advice Testing a Spring-based Application Spring and Test-Driven Development Spring 5 integration testing with JUnit 5 Application context caching and the @Dirties Context annotation Profile selection with @Active Profiles Easy test data setup with @Sql Data Accss and JDBC with Spring How Spring integrates with existing data access technologies Data Access Exception hierarchy Spring?s Jdbc Template Database Transactions with Spring Transactions overview Transaction management with Spring Transaction propagation and rollback rules Transactions and integration testing Spring Boot Introduction Introduction to Spring Boot Features Value Proposition of Spring Boot Creating a simple Boot application using Spring Initializer website Spring Boot Dependencies, Auto-configuration, and Runtime Dependency management using Spring Boot starters How auto-configuration works Configuration properties Overriding auto-configuration Using Command Line Runner JPA with Spring and Spring Data Quick introduction to ORM with JPA Benefits of using Spring with JPA JPA configuration in Spring Configuring Spring JPA using Spring Boot Spring Data JPA dynamic repositories Spring MVC Architecture and Overview Introduction to Spring MVC and request processing Controller method signatures Using @Controller, @RestController and @GetMapping annotations Configuring Spring MVC with Spring Boot Spring Boot packaging options, JAR or WAR Rest with Spring MVC An introduction to the REST architectural style Controlling HTTP response codes with @ResponseStatus Implementing REST with Spring MVC, @RequestMapping, @RequestBody and @ResponseBody Spring MVC?s HttpMessageConverters and automatic content negotiation Spring Security What problems does Spring Security solve? Configuring authentication Implementing authorization by intercepting URLs Authorization at the Java method level Understanding the Spring Security filter chain Spring security testing Actuators, Metrics and Health Indicators Exposing Spring Boot Actuator endpoints Custom Metrics Health Indicators Creating custom Health Indicators External monitoring systems Spring Boot Testing Enhancements Spring Boot testing overview Integration testing using @SpringBootTest Web slice testing with MockMvc framework Slices to test different layers of the application Spring Security Oauth (Optional Topic) OAuth 2 Overview Implementing OAuth 2 using Spring Security OAuth Reactive Applications with Spring (Optional Topic) Overview of Reactive Programming concepts Reactive Programming support in Spring Using Spring?s reactive WebClient Additional course details:Notes Delivery by TDSynex, Exit Certified and New Horizons an VMware Authorised Training Centre (VATC) Nexus Humans VMware Spring: Core Training 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 VMware Spring: Core Training 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.