17734 Courses

CRRUK equips professionals with the concepts, skills and tools to build conscious, intentional relationships, and to coach relationship systems of any size.

CIMA P3, 100% Pass Guarantee, Full Learning and Revision Components, Tests, Mock Exam, Tutor Support and CIMA Approved Materials Included, Exceptional Pass Rates

CIMA E3, 100% Pass Guarantee, Full Learning and Revision Components, Tests, Mock Exam, Tutor Support and CIMA Approved Materials Included, Exceptional Pass Rates

CIMA F3, 100% Pass Guarantee, Full Learning and Revision Components, Tests, Mock Exam, Tutor Support and CIMA Approved Materials Included, Exceptional Pass Rates

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

Advanced laparoscopic and open gynaecological surgery course, content mapped to the RCOG ATSM and SITM curriculums for benign abdominal surgery open and laparoscopic and benign gynaecological surgery.

Improving with stretch fabric - next steps with your overlocker / serger. Spend 3 hours playing with your overlocker to develop your knowledge and get to grips with Seaming, Flatlocking, Blind Hems, Pintucks, Lettuce edging, Rolled Hems and Complex fabric handling e.g. velvet/chiffon/spandex

Linux administration and command line

Why Choose Rhino Introduction to Intermediate Training Course? Learn: 3D NURBS models. Master: Surfacing modeling. Interface: Rhino's navigation. Rendering Skills: Enhance presentations with Rhino renderings. Check our Website Flexible Scheduling: 1-on-1 training sessions according to your convenience. Choose any hour between 9 a.m. and 7 p.m., Mon to Sat. You can call us at 02077202581 to book over the phone. Duration: 10 hours. Methods: Personalized training either in-person, or live online. Introduction and Navigation Become acquainted with Rhino's interface, menus, and screen layout. Efficiently traverse through Rhino models, ensuring precision in 2D lines, polylines, and NURBS curves. Utilize modeling setup features, incorporating constraints like snap, ortho, and planar for accuracy. Leverage object snaps and Smart Track functionality to enhance precision. Solid and Surface Modeling Develop rapid 3D solids and surfaces, employing Rhino's organized layering system. Utilize coordinates and constraints for meticulous modeling, exploring 3D space and elevations. Create diverse shapes, such as rectangles, circles, arcs, ellipses, and polygon curves. Elevate models with Rhino render and render color, incorporating free-form curves, helix, and spiral curves. Efficiently handle model views with pan, zoom, and view management tools. Implement various editing commands for curve manipulation and transform curves into surfaces and solids. Utilize history tracking for advanced editing and execute general editing actions: move, copy, rotate, mirror, and scale. Create arrays with both polar and rectangular arrangements and employ boolean operations like union, difference, and intersection. Offset curves and surfaces effectively, ensuring meticulous detailing. Intermediate Edit and Surfacing Introduce key NURBS modeling concepts and terminologies. Edit curves and surfaces via control point manipulation and rebuild them for optimal refinement. Employ the nudge modeling aid for precise adjustments and generate deformable shapes. Create curves through projection techniques and split surfaces using curves and surfaces. Blend surfaces seamlessly, utilizing symmetry tools, lighting, and rendering effects. Convert intricate 3D objects into detailed 2D drawings, expertly crafting page layouts. Advanced Surfacing and Solid Modeling Construct model primitives and solid text, employing techniques such as pipe and extrusion. Modify solids efficiently using Boolean tools, expanding your surface modeling capabilities. Employ techniques like extrusion, lofting, and revolving for intricate surfaces. Create sweeps using 1 and 2 rail curves, mastering surface network techniques for complex shapes. Upon completion, you will: Master Rhino Tools: Navigate interfaces, utilize advanced tools for precise modeling, and employ features like object snaps and Smart Track. Expert Solid and Surface Modeling: Develop intricate 3D solids and surfaces, create diverse shapes, and use Rhino render effectively. Advanced Editing Skills: Apply intermediate and advanced editing techniques, including symmetry tools and realistic rendering. Precision Modeling: Utilize coordinates, constraints, and advanced aids for accurate detailing and problem-solving. Professional Project Execution: Create high-quality renderings, 2D drawings, and polished 3D models for real-world design scenarios. Upon completion, you'll be adept at 3D modeling, product design, and architecture, positioning you as a valuable asset in the design industry. Why Choose Our Rhino Courses? Rhino, also known as Rhinoceros, stands as a robust 3D computer graphics and computer-aided design software, utilized extensively in domains like architecture, industrial design, and multimedia. Our Rhino courses are meticulously crafted to empower you in mastering this software. Led by seasoned instructors, our courses provide a comprehensive understanding of Rhino, enabling you to create exceptional designs. Rhino 3D Training: Our Rhino 3D training caters to beginners and those seeking advanced techniques. Course Highlights: Precise 3D Modeling: Master free-form 3D NURBS models with precision. Advanced Functionality: Explore Rhino's features, including advanced surfacing commands. User Interface Mastery: Navigate Rhino's interface and hone skills in curves, surfaces, and solids. Expert Guidance: Acquire expertise in Rhino's modeling environment under expert guidance. Modeling Techniques: Learn free-form and precision modeling techniques. Modeling Aids: Utilize tools for accurate modeling and create basic Rhino renderings. Benefits of our Courses: Expert Guidance: Receive instruction from experienced architects and designers, providing practical, real-world insights for comprehensive learning. Comprehensive Resources: Access bespoke video tutorials for additional learning and reference, enhancing your understanding of the course materials. Digital Reference Material: Receive a digital reference book to support your revision efforts, providing a comprehensive resource for your studies. Ongoing Support: Enjoy free after-support through phone or email even after course completion, ensuring continuous assistance and guidance. Tailored Learning Experience: Customize your learning journey by adapting the syllabus and projects to align with your specific needs and interests, fostering a personalized educational experience. Certificate: Upon completion, earn a certificate from us, validating your achievement and recognizing your expertise in the field.

Course Outcomes As an MHFAider® you will be able to:  Recognise those that may be experiencing poor mental health and provide them with first-level support and early intervention Encourage a person to identify and access sources of professional help and other supports Practise active listening and empathy Have a conversation with improved mental health literacy around language and stigma Discuss the MHFAider® role in depth, including boundaries and confidentiality Practise self-care Know how to use the MHFAider Support App® Know how to access a dedicated text service provided by Shout and ongoing learning opportunities with MHFA England Format Learners will be trained over four live sessions with an MHFA England Instructor Member, covering 14 hours of content in total. Learning takes place through a mix of instructor led training, group discussions, individual and group activities. Each session builds on the previous, enabling the learner to gain confidence in supporting others with a Mental Health First Aid action plan. We limit numbers to 16 people per course so that instructors can keep people safe and supported while they learn. We strive for all of our learning content to be as accessible and inclusive as possible. Takeaways Everyone who completes this course gets:  A hard copy workbook to support their learning throughout the course A digital manual to refer to whenever they need it after completing the course A wallet-sized reference card with the Mental Health First Aid action plan A digital MHFAider® certificate Access to the MHFAider Support App® for three years Access to ongoing learning opportunities, resources and exclusive events The opportunity to be part of the largest MHFAider® community in England Becoming a qualified MHFAider® Once you complete the Mental Health First Aid course, you can test your knowledge and build your confidence in your role as an MHFAider® with the internationally recognised MHFAider® qualification, RSPH Level 3 Award in Mental Health First Aid. Course Structure Session 1: Mental Health First Aid and the action plan The MHFAider® role and self-care Helpful and unhelpful language Useful models to support the role Session 2: What influences mental health? What is anxiety? Crisis first aid Active listening and empathy What are eating disorders? What is self-harm? What is substance misuse? Session 3: Applying the Mental Health First Aid action plan What is depression? What is suicide? Crisis first aid continued What is psychosis? Session 4: Recovery and lived experience Boundaries in the MHFAider® role Moving forward in the MHFAider® role My MHFA action plan