2144 Courses

Duration 3 Days 18 CPD hours This course is intended for This course is geared for attendees with Intermediate IT skills who wish to learn Computer Vision with tensor flow 2 Overview This 'skills-centric' course is about 50% hands-on lab and 50% lecture, with extensive practical exercises designed to reinforce fundamental skills, concepts and best practices taught throughout the course. Working in a hands-on learning environment, led by our Computer Vision expert instructor, students will learn about and explore how to Build, train, and serve your own deep neural networks with TensorFlow 2 and Keras Apply modern solutions to a wide range of applications such as object detection and video analysis Run your models on mobile devices and web pages and improve their performance. Create your own neural networks from scratch Classify images with modern architectures including Inception and ResNet Detect and segment objects in images with YOLO, Mask R-CNN, and U-Net Tackle problems faced when developing self-driving cars and facial emotion recognition systems Boost your application's performance with transfer learning, GANs, and domain adaptation Use recurrent neural networks (RNNs) for video analysis Optimize and deploy your networks on mobile devices and in the browser Computer vision solutions are becoming increasingly common, making their way into fields such as health, automobile, social media, and robotics. Hands-On Computervision with TensorFlow 2 is a hands-on course that thoroughly explores TensorFlow 2, the brandnew version of Google's open source framework for machine learning. You will understand how to benefit from using convolutional neural networks (CNNs) for visual tasks. This course begins with the fundamentals of computer vision and deep learning, teaching you how to build a neural network from scratch. You will discover the features that have made TensorFlow the most widely used AI library, along with its intuitive Keras interface. You'll then move on to building, training, and deploying CNNs efficiently. Complete with concrete code examples, the course demonstrates how to classify images with modern solutions, such as Inception and ResNet, and extract specific content using You Only Look Once (YOLO), Mask R-CNN, and U-Net. You will also build generative dversarial networks (GANs) and variational autoencoders (VAEs) to create and edit images, and long short-term memory networks (LSTMs) to analyze videos. In the process, you will acquire advanced insights into transfer learning, data augmentation, domain adaptation, and mobile and web deployment, among other key concepts Computer Vision and Neural Networks Computer Vision and Neural Networks Technical requirements Computer vision in the wild A brief history of computer vision Getting started with neural networks TensorFlow Basics and Training a Model TensorFlow Basics and Training a Model Technical requirements Getting started with TensorFlow 2 and Keras TensorFlow 2 and Keras in detail The TensorFlow ecosystem Modern Neural Networks Modern Neural Networks Technical requirements Discovering convolutional neural networks Refining the training process Influential Classification Tools Influential Classification Tools Technical requirements Understanding advanced CNN architectures Leveraging transfer learning Object Detection Models Object Detection Models Technical requirements Introducing object detection A fast object detection algorithm YOLO Faster R-CNN ? a powerful object detection model Enhancing and Segmenting Images Enhancing and Segmenting Images Technical requirements Transforming images with encoders-decoders Understanding semantic segmentation Training on Complex and Scarce Datasets Training on Complex and Scarce Datasets Technical requirements Efficient data serving How to deal with data scarcity Video and Recurrent Neural Networks Video and Recurrent Neural Networks Technical requirements Introducing RNNs Classifying videos Optimizing Models and Deploying on Mobile Devices Optimizing Models and Deploying on Mobile Devices Technical requirements Optimizing computational and disk footprints On-device machine learning Example app ? recognizing facial expressions

Duration 4 Days 24 CPD hours This course is intended for This course is geared for attendees with Intermediate IT skills who wish to learn Computer Vision with tensor flow 2 Overview This 'skills-centric' course is about 50% hands-on lab and 50% lecture, with extensive practical exercises designed to reinforce fundamental skills, concepts and best practices taught throughout the course. Working in a hands-on learning environment, led by our Computer Vision expert instructor, students will learn about and explore how to Build, train, and serve your own deep neural networks with TensorFlow 2 and Keras Apply modern solutions to a wide range of applications such as object detection and video analysis Run your models on mobile devices and web pages and improve their performance. Create your own neural networks from scratch Classify images with modern architectures including Inception and ResNet Detect and segment objects in images with YOLO, Mask R-CNN, and U-Net Tackle problems faced when developing self-driving cars and facial emotion recognition systems Boost your application's performance with transfer learning, GANs, and domain adaptation Use recurrent neural networks (RNNs) for video analysis Optimize and deploy your networks on mobile devices and in the browser Computer vision solutions are becoming increasingly common, making their way into fields such as health, automobile, social media, and robotics. Hands-On Computervision with TensorFlow 2 is a hands-on course that thoroughly explores TensorFlow 2, the brand-new version of Google's open source framework for machine learning. You will understand how to benefit from using convolutional neural networks (CNNs) for visual tasks. This course begins with the fundamentals of computer vision and deep learning, teaching you how to build a neural network from scratch. You will discover the features that have made TensorFlow the most widely used AI library, along with its intuitive Keras interface. You'll then move on to building, training, and deploying CNNs efficiently. Complete with concrete code examples, the course demonstrates how to classify images with modern solutions, such as Inception and ResNet, and extract specific content using You Only Look Once (YOLO), Mask R-CNN, and U-Net. You will also build generative adversarial networks (GANs) and variational autoencoders (VAEs) to create and edit images, and long short-term memory networks (LSTMs) to analyze videos. In the process, you will acquire advanced insights into transfer learning, data augmentation, domain adaptation, and mobile and web deployment, among other key concepts. Computer Vision and Neural Networks Computer Vision and Neural Networks Technical requirements Computer vision in the wild A brief history of computer vision Getting started with neural networks TensorFlow Basics and Training a Model TensorFlow Basics and Training a Model Technical requirements Getting started with TensorFlow 2 and Keras TensorFlow 2 and Keras in detail The TensorFlow ecosystem Modern Neural Networks Modern Neural Networks Technical requirements Discovering convolutional neural networks Refining the training process Influential Classification Tools Influential Classification Tools Technical requirements Understanding advanced CNN architectures Leveraging transfer learning Object Detection Models Object Detection Models Technical requirements Introducing object detection A fast object detection algorithm ? YOLO Faster R-CNN ? a powerful object detection model Enhancing and Segmenting Images Enhancing and Segmenting Images Technical requirements Transforming images with encoders-decoders Understanding semantic segmentation Training on Complex and Scarce Datasets Training on Complex and Scarce Datasets Technical requirements Efficient data serving How to deal with data scarcity Video and Recurrent Neural Networks Video and Recurrent Neural Networks Technical requirements Introducing RNNs Classifying videos Optimizing Models and Deploying on Mobile Devices Optimizing Models and Deploying on Mobile Devices Technical requirements Optimizing computational and disk footprints On-device machine learning Example app ? recognizing facial expressions

Duration 3 Days 18 CPD hours This course is intended for This intermediate course is for application programmers who need to write embedded SQL COBOL or PL/I programs in either a DB2 9 or DB2 10 for z/OS environment. Overview Incorporate static SQL statements in an application program Prepare the program for execution Validate execution results are correct Produce code to support multiple rows being returned from the database manager using cursors Identify considerations regarding units of work, concurrency, and restart of programs Identify differences between static and dynamic SQL Provide test data for applications Discuss program and DB2 options relative to performance of static SQL This course enables you to acquire the skills necessary to produce application programs that manipulate DB2 databases. Emphasis is on embedding Structured Query Language (SQL) statements and preparing programs for execution. CV720G;CF82G;DB2 Concepts Identify DB2 family products Explain DB2 workstation component functions Identify DB2 objects Identify the key differences between static SQL and other application alternatives for accessing DB2 data Program Structure I Embed INSERT, UPDATE, DELETE and single-row SELECT statements in application programs Effectively communicate with DB2 when processing NULL values and determining success of statement execution Demonstrate use of DB2 coding aids Code CONNECT statements within an application program Identify connection types and impacts on a unit of work Program for the Call Attach Facility (CAF) Program Preparation Identify the additional steps necessary to prepare a program that contains embedded SQL for execution Describe the functions of the DB2 PRECOMPILE and BIND processes Describe factors relevant to the BIND process, including RUNSTATS positioning, package status, parameters, and authorization requirements Program Structure II Use DECLARE, OPEN, FETCH, and CLOSE CURSOR statements to handle select criteria that may return multiple rows in application programs Issue positioned UPDATE and DELETE statements Identify how scrollable cursors can be used Recovery and Locking Concepts Define a unit of recovery Identify the basic locking strategies used by DB2 Dynamic SQL Introduction Describe the difference between static and dynamic SQL List the types of dynamic statements Code dynamic SQL in a program Managing Test Data Identify methods to insert data into a table Use the LOAD or IMPORT utility Identify the purpose of the RUNSTATS utility Identify the purpose of the REORG utility Performance Considerations Use programming techniques that enhance DB2 application performance by following general guidelines, using indexable predicates, and avoiding unnecessary sorts Identify the access paths available to DB2 List common causes of deadlocks and avoid such causes when possible Use the EXPLAIN tools as aids to develop applications that emphasize performance Additional course details: Nexus Humans CV722 IBM DB2 11 for z/OS Application Programming Workshop 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 CV722 IBM DB2 11 for z/OS Application Programming Workshop 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 is an intermediate and beyond level SQL course geared for experienced end users, data scientists, business analysts, application developers and database administrators. Students should have recently attended a basic SQL class or have equivalent experience. Overview This course is approximately 50% hands-on, combining expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Our engaging instructors and mentors are highly experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Working in a hands-on learning environment led by our expert practitioner, attendees will learn advanced skills needed to: Advanced Query Techniques Manipulating Table Data Using SQL's Data Manipulation Language (DML) User-Defined Functions Stored Procedures Triggers A company?s success hinges on responsible, accurate database management. Organizations rely on highly available data to complete all sorts of tasks, from creating marketing reports and invoicing customers to setting financial goals. Data professionals like analysts, developers and architects are tasked with creating, optimizing, managing and analyzing data from databases ? with little room for error. When databases aren?t built or maintained correctly, it?s easy to mishandle or lose valuable data. Our SQL Programming and Database Training Series provides students with the skills they require to develop, analyze and maintain data and in correctly structured, modern and secure databases. Next Level SQL explores how to identify and use advanced querying techniques to manipulate and index tables. All hands-on work in this course is ANSI SQL compliant and should work with most SQL databases such as Oracle, SQL Server, MySQL, MS Access, Informix, Sybase, or any other ANSI SQL compliant database. Advanced Query Techniques Join inner outer (Left, Right, Full) Subqueries Simple Correlated Using the Exists Operator Tips for Developing Complex Queries Performing Set Operations Aggregating Results Using Group by Creating Temporary Tables Manipulating Table Data Using SQL's Data Manipulation Language (DML) Inserting Data into Tables Updating Existing Data Deleting Records Truncating Tables Implementing Data Integrity with Transactions Beginning Explicit Transactions Committing Transactions Rolling Back Transactions User-Defined Functions Definition and Benefits of Use CREATE FUNCTION Syntax RETURN Clause and the RETURNS Statement Scalar vs. Table Functions Comparison with Stored Procedures Returning Scalar Values and Tables ALTER and DROP FUNCTION Stored Procedures Definition and Benefits of Use CREATE PROCEDURE Syntax Variables and Parameters Control of Program Flow ALTER and DROP PROCEDURE Implementation Differences Triggers Definition and Benefits of Use Alternatives (e.g., Constraints) CREATE TRIGGER Syntax Trigger Types 'Inserted' (or 'NEW') and 'Deleted' (or 'OLD') Tables Event Handling and Trigger Execution ALTER and DROP TRIGGER Additional course details: Nexus Humans Advanced SQL Programming (TTSQL005) 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 Advanced SQL Programming (TTSQL005) 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.

About Course Advanced C++: Master the Language of Champions Learn the advanced C++ concepts and techniques you need to build high-performance software applications. In this comprehensive course, you will learn: Generic programming with templates Metaprogramming with constexpr and reflection Advanced object-oriented programming techniques Concurrency and parallelism Performance optimization This course is designed for experienced C++ programmers who want to take their skills to the next level. You will learn from an experienced C++ developer who will teach you the concepts and skills you need to succeed. By the end of this course, you will be able to: Write high-performance, efficient, and maintainable C++ code. Use advanced C++ features to solve complex problems. Design and implement complex software applications. Build a portfolio of real-world C++ applications Throughout the course, you will work on a variety of hands-on projects to build your skills and create a portfolio of real-world C++ applications. Enroll today and start your journey to becoming a C++ expert! Bonus: Get access to the instructor's personal collection of C++ resources. Why learn advanced C++? C++ is a powerful and versatile language that can be used to build a wide variety of software applications. It is also one of the most in-demand languages in the software industry. Learning advanced C++ will give you a significant advantage in the job market and allow you to build more complex and sophisticated software applications. Here are some of the benefits of learning advanced C++: C++ is a high-performance language that can be used to build fast and efficient software applications. C++ is a versatile language that can be used to build a wide variety of software applications, including operating systems, embedded systems, games, and more. C++ is an in-demand language in the software industry, and there are many job opportunities for C++ programmers. Learning advanced C++ will give you a significant advantage in the job market and allow you to build more complex and sophisticated software applications. So what are you waiting for? Enroll in this course today and start your journey to becoming a C++ expert! What Will You Learn? Learn to program with one of the most powerful programming languages that exists today, C++ Master on every advanced C++ programming topics Learn to code C++ from scratch for application development Coding advanced problem statements using the C++ concepts Setting up a local C++ coding environment to create your own coding practices Develop skills on real-world class, object and methods programming techniques Learn how to implement C++ templates, template functions, and classes How to handle error, exception handling and catch real time app errors Apply overloading methods and deep inheritance to how code reusing for your development Polymorphism and abstract classes to implemeting secure code in multiple methods Learn to Apply overloading techniques in C++, Dynamic operators and conversions Course Content Getting Started with C++ Introduction Course Curriculum Getting Started on Windows, Mac or Linux How to Ask Great Questions FAQ's Get and Installing Visual Studio Creating Project C++ Hello World Program Compile and Run a CPP program C++ Object Oriented Programming (theory) Introduction What Are oops Data Structures What Are Access Modifiers C++ Classes Introduction Creating a Class Creating an Objects Class Methods Adding Parameters Constructors Constructor with Parameters The Destructor Get and Set Methods Access Modifiers Static Members C++ Objects and Methods Introduction Constant Objects and Functions Pointers to Class and Object Array of Objects C++ Operator Overloading Introduction Overloading the Equality Operator Overloading the Stream Insertion Operator Overloading the Stream Extraction Operator Overloading the Binary Arithmetic Operators Overloading the Assignment Operators Overloading the Unary Operators Overloading the Subscript Operator Inline Functions C++ Inheritance and Polymorphism Introduction Inheritance Protected Members Constructors and Inheritance Destructors and Inheritance Overriding Methods Polymorphism Abstract Classes Final Classes and Methods Deep Inheritance and Methods Multiple Inheritance C++ Error Handling and Exceptions Introduction What Are Exceptions Throwing an Exception Catching an Exception Catching Multiple Exceptions Create Custom Exceptions C++ Templates Introduction Creating a Function Template Function Template Arguments Overloading a Function Template Creating a Class Template Templates with Multiple Parameters A course by Sekhar Metla IT Industry Expert Xpert Learning RequirementsGood to have C++ basic, intermediate to start hereNo software is required in advance of the course (all software used in the course is free) Audience C++ Advanced level developers curious about programming Anyone interested in learning the Advanced concepts of C++ Anyone who wants to grasp the concept with real-world examples of coding Anyone who wants to become a proficient software developer Anyone who wants to become an independent programmer Audience C++ Advanced level developers curious about programming Anyone interested in learning the Advanced concepts of C++ Anyone who wants to grasp the concept with real-world examples of coding Anyone who wants to become a proficient software developer Anyone who wants to become an independent programmer

Sage 50 Payroll Complete Course Course Overview: The "Sage 50 Payroll Complete Course" is designed to provide a thorough understanding of payroll processing using Sage 50 software. It covers everything from the basics to intermediate-level payroll management, enabling learners to confidently handle payroll operations. This course is ideal for those looking to enhance their payroll skills and streamline processes in line with UK regulations. Learners will gain essential knowledge on managing employee records, tax calculations, and statutory deductions, providing them with the tools to ensure accuracy and compliance. By the end of the course, participants will be equipped to manage payroll functions efficiently, saving time and reducing errors, making them invaluable assets to any organisation. Course Description: This course offers in-depth coverage of Sage 50 Payroll, starting with essential payroll concepts and progressing to intermediate-level skills. Learners will explore topics such as setting up and maintaining employee records, calculating PAYE, National Insurance, and pension contributions, as well as processing holiday pay, sick leave, and other statutory deductions. The course is structured to help learners understand the complexities of payroll management, ensuring they can apply the knowledge in real-world scenarios. Throughout, learners will gain the confidence to navigate Sage 50 Payroll software and understand the payroll process within a UK context, adhering to current laws and regulations. Sage 50 Payroll Complete Course Curriculum: Module 01: Sage 50 Payroll For Beginners Module 02: Sage 50 Payroll Intermediate Level (See full curriculum) Who is this course for? Individuals seeking to gain proficiency in payroll management. Professionals aiming to advance their career in payroll administration. Beginners with an interest in payroll or accounting roles. Anyone looking to understand UK payroll processes. Career Path: Payroll Administrator Payroll Manager HR Officer Accounts Assistant Finance Officer

Overview School is the place where young, brilliant minds develop and flourish! Take your career into the next level and work in a field with means to develop the future of the society by joining our comprehensive Focus Awards Level 3 Award in Supporting Teaching and Learning in Schools course. This Focus Awards Level 3 Award in Supporting Teaching and Learning in Schools is a professional course that has been developed in accordance with awarding body standards to help you advance your career prospects. It is an introductory level 3 award that will teach you about teaching and learning concepts specifically relevant to children and young people in primary, secondary, or special schools. This level 3 award in supporting teaching and learning in schools focuses on giving you the skills and knowledge you need to look after children and youth, keep them safe, and communicate effectively.Enrol today and start your learning journey! Benefits you will gain: Top-notch e-learning materials Modules availability 24/7 An easy-to-use online learning platform Flexible learning hours Level 3 Award in Supporting Teaching and Learning in Schools (Regulated qualification) Exquisite customer service Qualification Focus Awards Level 3 Award in Supporting Teaching and Learning in Schools.  Description Learners must achieve all 4 mandatory units to achieve a total credit of 12.From this course you will: Familiarise yourself with the concept of supporting teaching and learning schools Understand how to communicate with children and young people Know how to maintain professional relationships with children and adults Comprehend how schools as an organisation works Study the development process of child and adults Be able to safeguard the wellbeing of children and young people Qualification Purpose This comprehensive Focus Awards Level 3 Award in Supporting Teaching and Learning in Schools course is designed to help students master the knowledge and skills they'll need to function effectively in supporting teaching and learning in schools. Who is this course for The Focus Awards Level 3 Award in Supporting Teaching and Learning in Schools course is for individuals wanting to serve as a qualified professional in the educational sector. Individuals who wish to achieve a sought-after teaching and learning certificate will benefit from its excellent training. Entry Requirements There are no specific entry requirements for this qualification. This qualification is accredited for learners who are at least 16 years old. Focus Awards does not set any other entry requirements, but training providers or colleges may have their own guidelines. Progression Learners wishing to progress from this qualification can undertake the following qualifications: Level 3 Certificate in Supporting Teaching and Learning in Schools Level 3 Certificate in Cover Supervision of Pupils in Schools Level 3 Diploma in Specialist Support for Teaching and Learning in Schools Intermediate/Advanced Level Apprenticeship in Supporting Teaching and Learning in Schools Total Qualification Time Total Qualification Time is comprised of GLH and an estimate of the number of hours a learner is likely to spend in preparation, study or any other learning including assessment, which takes place as directed by, but not under the supervision of a lecturer, supervisor or tutor. Total Qualification Time for this qualification is hours. Guided Learning Hours These hours are made up of all contact time, guidance or supervision of a learner by a lecturer, supervisor, tutor, trainer or other appropriate provider of education or training. Guided Learning Hours for this qualification is 80. Method of Assessment: The Focus Awards Level 3 Award in Supporting Teaching and Learning in Schools (RQF) is internallyassessed and externally assured by Focus Awards.Each learner is required to create a portfolio of evidence that demonstrates the achievement of all thelearning outcomes and the assessment criteria associated with each unit.The main pieces of evidence for the portfolio could include: Assessor observation - completed observational checklists on related action plans Witness testimony Learner product Worksheets Assignments / projects / reports Record of oral and written questioning Learner and peer reports Recognition of prior learning (RPL) Evidence may be drawn from actual or simulated situations where appropriate and where permitted by the relevant Sector Skills Council or Sector Skills Body. Career path After receiving the Focus Awards Level 3 Award in Supporting Teaching and Learning in Schools certification, you would be eligible to function as a competent professional as: Senior Teaching Assistant Senior Learning Support Assistant Senior Special Educational Needs Assistant Course Curriculum 15 sections • 40 lectures • 00:00:00 total length •Induction Form: 00:00:00 •Registration Entry Form: 00:00:00 •1. The Principles of Developing Positive Relationships With Children, Young People and Adults: 00:00:00 •2. Communication with Children, Young People and Adults: 00:00:00 •3. Legislation, Policies and Procedures for Confidentiality and Sharing Information, Including Data Protection: 00:00:00 •Unit 01 Assignment: 00:00:00 •1. The Structure of Education from Early Years to Post-compulsory Education: 00:00:00 •2. How Schools are Organised in Terms of Roles and Responsibilities: 00:00:00 •3. Ethos, Mission, Aims and Values of a School: 00:00:00 •4. Laws and Codes of Practice Affecting Work in Schools: 00:00:00 •5. The Purpose of School Policies and Procedures: 00:00:00 •6. The Wider Context in Which Schools Operate: 00:00:00 •Unit 02 Assignment: 00:00:00 •1. Different Aspects of Development From Birth to Adulthood: 00:00:00 •2. Personal and External Factors That Affect Child Development: 00:00:00 •3. Theories of Development and Frameworks to Support Development: 00:00:00 •4. Monitoring and Assessing Children: 00:00:00 •5. Barriers to the Development of Children and Young People: 00:00:00 •6. Early Intervention: 00:00:00 •7. Possible Effects of Different Transitions on Children and Young People's Development: 00:00:00 •Unit 03 Assignment: 00:00:00 •1. Current Legislation and National Guidelines for Safeguarding: 00:00:00 •2. Safeguard Children and Young People: 00:00:00 •3. Inquiries and Serious Case Reviews and Sharing the Findings to Inform Practice: 00:00:00 •4. Data Protection, Information Handling and Sharing: 00:00:00 •5. A Person-Centred Culture: 00:00:00 •6. Partnership Working and Safeguarding: 00:00:00 •7. Roles and Responsibilities of Different Organisations: 00:00:00 •8. Policies and Procedures to Protect Children and Young People and Adults Who Work With Them: 00:00:00 •9. How to Report Concerns about Practice in the Work Setting: 00:00:00 •10. Child Abuse Indicators: 00:00:00 •11. Responding to Children and Young People's Disclosures of Abuse: 00:00:00 •12. Concept of bullying: 00:00:00 •13. Develop Self-esteem and Self-confidence: 00:00:00 •14. Resilience: 00:00:00 •15. Strategies to Help Children Protect Themselves: 00:00:00 •16. Empowerment: 00:00:00 •17. Importance of E-safety: 00:00:00 •Unit 04 Assignment: 00:00:00 •Submit Your Assignments: 00:00:00

Learning Objectives Introduction , Customizing Excel , Analyzing Data with Logical Functions , Working with Lookup Functions , Using Text Functions , Working with Date and Time Functions , Formula Auditing , What-If Analysis , Worksheet and Workbook Protection , Automating with Macros , Working with Form Controls , Ensuring Data Integrity , Collaborating in Excel , Importing and Exporting Data to a Text File , Conclusion   Pre-Requisites Excel 365 Introduction and Intermediate courses or equivalent experience.   Description This course will teach students advanced concepts and formulas in Microsoft Excel 365. Students will learn functions such as SUMIF, AVERAGEIF, and COUNTIF, advanced lookup functions, and complex logical and text functions. Additionally, students will experiment with auditing formulas and error checking, use the What-If Analysis tools, learn the options for worksheet and workbook protection, review advanced use of PivotTables and PowerPivot add-in, work with Macros, use form controls, and ensure data integrity in their worksheets and workbooks. Students will also learn about Excel's many collaboration features and import and export data to and from their workbooks. Course Introduction Introduction 00:01:00 Section 01 Lesson 01-Customizing the Ribbon 00:09:00 Lesson 02-Customizing the Quick Access Toolbar 00:06:00 Lesson 03-Customizing the General and Formula Options 00:04:00 Lesson 04-Customizing the AutoCorrect Options 00:03:00 Lesson 05-Customizing the Save Defaults 00:04:00 Lesson 06-Customizing Advanced Excel Options 00:03:00 Section 02 Lesson 01-Working with the Most Common Logical Functions 00:03:00 Lesson 02-Understanding IF Functions 00:06:00 Lesson 03-Evaluating Data with the AND Function 00:05:00 Lesson 04-Evaluating Data with the OR Function 00:03:00 Lesson 05-Creating a Nested IF Function 00:05:00 Lesson 06-Using the IFS Function 00:03:00 Lesson 07-Summarizing Data with SUMIF 00:03:00 Lesson 08-Summarizing Data with AVERAGEIF 00:02:00 Lesson 09-Summarizing Data with COUNTIF 00:02:00 Lesson 10-Summarizing Data with MAXIFS and MINIFS 00:03:00 Lesson 11-Using the IFERROR Function 00:03:00 Section 03 Lesson 01-What are Lookup Functions 00:03:00 Lesson 02-Using VLOOKUP 00:08:00 Lesson 03-Using HLOOKUP 00:03:00 Lesson 04-Using VLOOKUP with TRUE 00:04:00 Lesson 05-Using HLOOKUP with TRUE 00:02:00 Lesson 06-Using the Index Function 00:03:00 Lesson 07-Using the MATCH Function 00:03:00 Lesson 08-Combining INDEX and MATCH 00:04:00 Lesson 09-Comparing Two Lists with VLOOKUP 00:02:00 Lesson 10-Comparing Two Lists with VLOOKUP and ISNA 00:04:00 Lesson 11-Using the New XLookup Function-v2 00:07:00 Lesson 12-Using Dynamic Array functions-v2 00:06:00 Lesson 13-Other New Functions-v2 00:04:00 Section 04 Lesson 01-What are Text Functions 00:01:00 Lesson 02-Using CONCAT, CONCATENATE, AND TEXTJOIN 00:04:00 Lesson 03-Using Text to Columns 00:02:00 Lesson 04-Using LEFT, RIGHT, and MID Functions 00:03:00 Lesson 05-Using UPPER, LOWER, and PROPER Functions 00:02:00 Lesson 06-Using the Len Function 00:03:00 Lesson 07-Using the Trim Function 00:01:00 Lesson 08-Using the SUBSTITUTE Function 00:02:00 Section 05 Lesson 01-What are Date and Time Functions 00:02:00 Lesson 02-Using TODAY, NOW, and DAY Functions 00:03:00 Lesson 03-Using NETWORKDAYS and YEARFRAC Functions 00:03:00 Section 06 Lesson 01-Showing Formulas 00:03:00 Lesson 02-Tracing Precedents and Dependents 00:04:00 Lesson 03-Adding a Watch Window 00:04:00 Lesson 04-Error Checking 00:04:00 Section 07 Lesson 01-Using the Scenario Manager 00:07:00 Lesson 02-Using Goal Seek 00:03:00 Lesson 03-Analyzing with Data Tables 00:04:00 Section 08 Lesson 01-Understanding Protection 00:02:00 Lesson 02-Encrypting Files with Passwords 00:05:00 Lesson 03-Allowing Specific Worksheet Changes 00:02:00 Lesson 04-Adding Protection to Selected Cells 00:03:00 Lesson 05-Additional Protection Features 00:03:00 Section 09 Lesson 01-What are Macros 00:03:00 Lesson 02-Displaying the Developer Tab 00:03:00 Lesson 03-Creating a Basic Formatting Macro 00:05:00 Lesson 04-Assigning a Macro to a Button 00:03:00 Lesson 05-Creating Complex Macros 00:04:00 Lesson 06-Viewing and Editing the VBA Code 00:04:00 Lesson 07-Adding a Macro to the Quick Access Toolbar 00:03:00 Section 10 Lesson 01-What are Form Controls 00:02:00 Lesson 02-Adding a Spin Button and Check Boxes 00:04:00 Lesson 03-Adding a Combo Box 00:07:00 Section 11 Lesson 01-What is Data Validation 00:02:00 Lesson 02-Restricting Data Entry to the Whole Numbers 00:02:00 Lesson 03-Restricting Data Entry to a List 00:04:00 Lesson 04-Restricting Data Entry to a Date 00:02:00 Lesson 05-Restricting Data Entry to Specific Text Lengths 00:01:00 Lesson 06-Composing Input Messages 00:02:00 Lesson 07-Composing Error Alerts 00:03:00 Lesson 08-Finding Invalid Data 00:02:00 Lesson 09-Editing and Deleting Validation Rules 00:01:00 Section 12 Lesson 01-Working with Comments-v2 00:03:00 Lesson 02-Printing Comments and Errors 00:02:00 Lesson 03-Sharing a Workbook 00:04:00 Lesson 04-Co-Authoring in Excel 00:02:00 Lesson 05-Tracking Changes in a Workbook 00:03:00 Lesson 06-Working with Versions 00:03:00 Lesson 07-Sharing files Via Email-v2 00:03:00 Section 13 Lesson 01-Importing a Text File 00:04:00 Lesson 02-Exporting Data to a Text File 00:01:00 Course Recap Recap 00:02:00 Additional Materials Resource - Excel 365 Advanced 00:00:00 Final Exam Final Exam - Excel 365 Advanced 00:20:00

Grab the opportunity to become an elite-level dog groomer. Utilise the skills of the course to open a dog grooming centre. Learn How to Set Up Your Dog Grooming Business.

Overview Master the art of leadership! Achieve organizational goals with maximum efficiency while working in a team. Keep the team morale high and motivate team members to perform well. The Transformational Leadership - Leadership Course & Training will introduce you to the hidden secrets of leadership and maintaining a team capable of accomplishing anything. Find out what it takes to be a leader with our leadership course. The Cutting-edge Transformational Leadership Skills, Tools, Tips and Strategies will help you get the job done.  This leadership course is equipped with exactly what future leaders need. Converting these plans to regular practice will help you rise to the top faster than you ever thought possible. What You'll Learn from This Course  This top-notch Leadership training can help you rise to the top faster than you ever thought possible. You'll learn about: Advanced transformational leadership skills Dealing with staff issues fast & effectively Eliminate old lies & misconceptions about leading New empowering & effective beliefs & values Powerful new skills and qualities to help you excel as a leader New ways to Improve Your Relationships With Staff To get the most out of your team The secrets of how real leaders succeed How to rise above the ordinary leader Why You Should Choose This Transformational Leadership - Leadership Course & Training Course from iStudy A few reasons to choose this Transformational Leadership - Leadership Course & Training Course over other generic courses that you find on the internet: Study at your own pace No hidden fees or exam charges Full Tutor support on weekdays (Monday - Friday) CPD Qualification Standards and IAO accredited Fully compatible with any device Efficient exam system, assessment, and instant results Free Printable PDF Certificate immediately after completion A hard copy certificate is available, and you can get one for just £9! No prior qualifications are needed to take this course Improve your chance of gaining professional skills and boost your earning potential All these and we have our customer support team always ready to help you and make your learning experience as smooth and as enjoyable as possible.  Enrol today and learn something new with iStudy. You'll find a full breakdown of the course curriculum down below. Take a look and see just how much this course offers. We're sure you'll be satisfied with this course. Old Belief Systems doesn't work for Modern Leadership. You need to know the Front-line Transformational Leadership Skills to stand out from the crowd. Different tools, strategies, and tips of Transformational Leadership will really help you to get the job done easily. CEO & celebrity trainer Prof. Paul will teach you the in-depth and hidden secrets of the leaders. Start your learning with top CEOs and team leaders to get impressive outcomes day by day. To be a better leader tomorrow, you need to start this premium Leadership Course & Training. This Leadership Course & Training can help you step forward faster than ever you imagined. Join Prof. Paul and learn the unknown secrets of psychology that are known to the most educated CEOs and leaders around the world.  This course is one of the trending courses in the UK. You will gain the necessary skills to perform well in this field. Specific modules in this course are designed to teach you the whole thing you need to know to become a successful professional in this sector. You can study this course at your own pace. Within a few hours, you will get an accredited certificate in this course. You can access the course easily from anywhere at any time. This course is designed for students, professionals, and for those who have a keen interest to know about this topic. To design this course, we have selected a professional, experienced tutor. The tutor will guide you throughout the course and will help you out with all your queries. You will get 24/7 support from our customer support team as well. What You Will Learn  Form this premium video course, you will learn the unknown secrets of transformational leadership Know the front-line leadership as well as the persuading strategies of top leaders of renowned organizations Learn how to deal with employee issues effectively and quickly Learn the hidden secrets of how real leaders prosper in their leadership skills Abolish misunderstandings about leading or leadership skills Know the leader's behaviour Learn a leader's strength factors Way to improve your skill above other leaders Learn something that new empowering and effective beliefs Hidden strategies to achieve the leadership goal You will learn mysteries of the world's best leaders Learn basic to advanced transformational leadership skills How to deal with staff issues easily Learn new skills to help you excel Learn how to get the most out of your team Improve your relationships with staff And much more!!! Enrol now!!! Who Is This Course For?  For those who want to be a Team Leader People in positions of authority CEO's Managers Entrepreneurs Foremen Business Owners Directors Future Leaders Requirements Computer Internet Access Career Path  If you complete the course, you will be able to know the strategies and secrets of Transformational Leadership. You will get the skill of successful leadership which help you to compete for those job position that requires leadership skill to manage employee or a huge number of staffs. After completing this course, you will be able to gain the necessary knowledge and skills required to succeed in this sector. All our courses are IAO accredited. So you will be able to add some qualifications to your resume. Introduction Introduction FREE 00:08:00 Foundational Concepts For Leaders Foundational Ideas That Create Powerful Leaders 1 FREE 00:03:00 Foundational Ideas That Create Powerful Leaders 2 00:13:00 Powerful Cutting-Edge Leadership Tips - Foundational Tips For Wise Leaders - Section 4 00:19:00 Tips For Wise Leaders - Section 5 00:10:00 Tips For Wise Leaders - Section 6 00:12:00 Tips For Wise Leaders - Section 7 00:10:00 Tips For Wise Leaders - Section 8 00:12:00 Tips For Wise Leaders - Section 9 00:15:00 Tips For Wise Leaders - Section 10 00:11:00 Tips For Wise Leaders - Section 11 00:10:00 Powerful Cutting-Edge Leadership Tips - Intermediate Tips For Wise Leaders - Section 12 00:10:00 Tips For Wise Leaders - Section 13 00:08:00 Tips For Wise Leaders - Section 14 00:12:00 Tips For Wise Leaders - Section 15 00:13:00 Tips For Wise Leaders - Section 16 00:12:00 Powerful Cutting-Edge Leadership Tips - Advanced Advanced Tips For Wise Leaders - Section 17 00:11:00 Advanced Tips For Wise Leaders - Section 18 00:15:00 Advanced Tips For Wise Leaders - Section 19 00:11:00 Advanced Tips For Wise Leaders - Section 20 00:12:00 Advanced Tips For Wise Leaders - Section 21 00:11:00 Advanced Tips For Wise Leaders - Section 22 00:13:00 Advanced Tips For Wise Leaders - Section 23 00:10:00 Advanced Tips For Wise Leaders - Section 24 00:11:00 Advanced Tips For Wise Leaders - Section 25 00:12:00 Final Thoughts For Wise Leaders Final Thoughts For Wise Leaders 00:08:00 BONUS VIDEO - 'Dealing With 'Problem Employees'' 00:05:00