34180 Courses

Description Be a skilled sales assistant and follow the recent trends in sales with the Sales Assistant Training course. Traditional sales techniques have changed tremendously over the last decade. No matter whether you are working in a shop, showroom or other sales points, you need to know different skill sets along with the appropriate communication skills. The course is suitable for the people who want to start their journey in the sales field. The individuals who are already in the sales sector will also be benefited from the course. Throughout the course, you will learn the best ways of promoting yourself and your product. The course also helps you to increase your self-confidence and belief so that you can deal with people easily. By the end of the course, you will be able to work confidently as a sales assistant. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Sales Assistant Training is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Sales Assistant Training is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Introduction Introduction to this course 00:03:00 Overview Overview of the modules 00:02:00 Preparation Beliefs 00:07:00 Mentors 00:09:00 Applying for sales positions 00:07:00 Interviews Interview preparation 00:04:00 First Impressions 00:05:00 Painting pictures with words 00:02:00 Closing interviews 00:04:00 Conclusion Conclusion 00:01:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Duration 2 Days 12 CPD hours This course is intended for This course assumes that you have successfully completed the Administering BIG-IP course, or equivalent, and have hands-on experience working in a production BIG-IP environment for several months. You should have a solid understanding of the environment in which the BIG-IP is deployed. This course is meant for BIG-IP administrators, network engineers, applications engineers, etc., who will be responsible for troubleshooting problems associated with their BIG-IP system. This course gives networking professionals hands-on knowledge of how to troubleshoot a BIG-IP system using a number of troubleshooting techniques as well as troubleshooting and system tools. This course includes lectures, labs, and discussions. Module 1: Setting Up the BIG-IP System Introducing the BIG-IP System Initially Setting Up the BIG-IP System Archiving the BIG-IP System Configuration Module 2: Reviewing Local Traffic Configuration Reviewing Nodes, Pools, and Virtual Servers Reviewing Address Translation Reviewing Routing Assumptions Reviewing Application Health Monitoring Reviewing Traffic Behavior Modification with Profiles Reviewing the TMOS Shell (TMSH) Reviewing Managing BIG-IP Configuration Data Reviewing High Availability (HA) Module 3: Troubleshooting Methodology Step-By-Step Process Step 1: State the Problem Step 2: Specify the Problem Step 3: Map the System Step 4: Develop Possible Causes Step 5: Test Theories Step 6: Iterate Until Root Cause Identified Documenting a Problem Putting Troubleshooting Steps to Use Module 4: Working with F5 Support Leveraging F5 Support Resources AskF5.com DevCentral iHealth Leveraging F5 Labs Working with F5 Technical Support Running End User Diagnostics (EUD) - Hardware Only New Platform Diagnostic Tools Always-On Management (AOM) Subsystem Requesting Return Materials Authorization F5?s Software Version Policy Managing the BIG-IP License for Upgrades Managing BIG-IP Disk Space Upgrading BIG-IP Software Module 5: Troubleshooting ? Bottom to Top Introducing Differences between BIG-IP and LINUX Tools Troubleshooting with Layer 1/Layer 2 Tools Troubleshooting with Layer 2/Layer 3 Tools Troubleshooting with Layer 3 Tools Troubleshooting with LINUX Tools Troubleshooting Memory and CPU Troubleshooting with watch Troubleshooting with Additional tmsh commands Module 6: Troubleshooting Tools tcpdump Wireshark ssldump Fiddler diff KDiff3 cURL Module 7: Using System Logs Configuring Logging Log Files Understanding BIG-IP Daemons Functions Triggering an iRule Deploying and Testing iRules Application Visibility and Reporting Module 8: Troubleshooting Lab Projects Network Configurations for Project Additional course details: Nexus Humans F5 Networks Troubleshooting BIG-IP 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 F5 Networks Troubleshooting BIG-IP 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 3 Days 18 CPD hours This course is intended for This course is suitable for anyone responsible for configuring, managing or supporting a Veeam Availability Suite v10 environment. Overview After completing this course, attendees should be able to: Describe Veeam Availability Suite components usage scenarios and relevance to their own environment. Effectively manage data availability in on-site, off-site, cloud and hybrid environments. Ensure both Recovery Time Objectives (RTOs) and Recovery Point Objectives (RPOs) are met. Install and configure Veeam Availability Suite into their environment, ensuring data is protected effectively. Adapt with an organization's evolving technical, business and regulatory needs. Ensure recovery is possible, effective, efficient, secure and compliant with business and legal requirements. Provide visibility of the business data assets, and produce effective reports and dashboards to monitor performance and risks. Conduct basic troubleshooting and analysis of their Veeam Availability Suite environment. This three-day, technical deep dive Veeam© Availability Suite? v10: Configuration and Management training course is focused on teaching IT professionals the skills to configure, manage and support a Veeam Availability Suite v10 solution. With extensive hands-on-labs, the class enables administrators and engineers to effectively manage data in an ever-changing technical and business environment, bringing tangible benefit to businesses in the digital world. Introduction Describe RTOs and RPOs, what they mean for your business, how to manage and monitor performance against them The 3-2-1 Rule and its importance in formulating a successful backup strategy Identify key Veeam Availability Suite components and describe their usage scenarios Building Backup Capabilities Backup methods, the appropriate use cases and impact on underlying file systems Create, modify, optimize and delete backup jobs, including NAS Backup jobs. Explore different tools and methods, such as BitLooker? and Deduplication, to maximize environment performance Global Settings and their usage to prevent production performance bottlenecks, encrypt network traffic data and control network jurisdiction Restoring from Backup Identify and describe the different restore tools and their features. Ensure you have the confidence to use the correct restore tool at the right time Using Secure Restore to prevent the restoration of malware Disaster recovery from backup, respond accordingly to a variety of real-world recovery scenarios Backup Copy Jobs Simple vs Advanced Backup Copy Jobs, how to create and modify them using best practices to ensure efficient recovery Utilizing tape jobs, how to create and modify Replication Identify and describe the options available for replication, the use cases and impacts of using Create, modify and delete replication jobs, outline considerations to ensure success Failover Identify and describe in detail, failover features and the appropriate usage Develop, prepare and test failover plans to ensure recovery Disaster recovery from replica, respond accordingly to a variety of real-world recovery scenarios Advanced Repository Capabilities Ensure efficiency by being able to select appropriate transport modes while being aware of the impact of various backup functions on the infrastructure Ensure scalability by integrating off-site S3 storage Ensure compatibility with existing deduplication appliances Testing Backup and Replication Testing backups and replicas to ensure you can recover, what you need, when you need to Configure Veeam DataLabs? and setup sandbox environments based on backup, replicas and storage snapshots Using Veeam DataLabs Staged Restore to manage and comply with General Data Protection Regulation (GDPR) legislation before releasing restores to production Veeam Backup Enterprise Manager Manage multiple Veeam Backup & Replication? installations from a single web console, maintaining a view of your entire virtual environment, ensuring data protection of ROBO and Enterprise environments. Create user and group roles, delegate workloads whilst maintaining data control Enable encryption password loss protection, helping to restore encrypted data in case of lost or forgotten encryption passwords Veeam ONE Monitor your Virtual, Physical and Cloud environments with Veeam ONE? and assess the different views available Configure Veeam ONE for your specific technical and business requirements, describe the alarm options available and how to customize their usage Set up, use and customize Veeam ONE Reporter, creating the reports and dashboards you require technically and for the business Support Locate, migrate or restore backup configuration Identify and locate appropriate support resources Troubleshooting methodology to identify, isolate and remediate support issues Additional course details: Nexus Humans VEEAM-VMCE Availability Suite v10.0: Configuration and Management 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 VEEAM-VMCE Availability Suite v10.0: Configuration and Management 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.

Unique bears, a comprehensive kit of all you need to create your very own bear keyring

Description: The 70-640 - Configuring Windows Server 2008 R2 Active Directory course provides the required information that you should know about 70-640: Configuring Windows Server 2008 R2 Active Directory. The course will teach you how to install the Active Directory role, or how to work with Active Directory objects. In the course, you will also learn about the GPOs (Group Policy Adjectives), what Group Policy objects are, restricted Group Policies. You will know analysing security settings, using the Security Configuration Wizard, deploying software with Group Policy, understanding Group Policy Scope, how Group Policy settings are processed, verifying Group Policy settings, and enabling Auditing. You will also be able to manage users and groups with the AD, working With Domain Controllers, adding DNS, securing the authentication process, monitoring and supporting AD, planning Active Directory deployment, IDA solutions, and Active Directory Certificate Services. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? 70-640 - Configuring Windows Server 2008 R2 Active Directory is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our 70-640 - Configuring Windows Server 2008 R2 Active Directory is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Installing the Active Directory Role What is IDA? FREE 00:16:00 How to Install the AD DS Role 00:11:00 Creating a Windows Server 2008 Forest 00:22:00 The New Windows 2008 Server Core 00:09:00 Installing AD DS Server Core 00:02:00 Domain Controller 00:20:00 Working With Active Directory Objects Working with the MMC 00:19:00 Custom MMC 00:14:00 Working with Objects in Active Directory 00:12:00 How to Search Through Active Directory 00:07:00 Using Active Directory 00:13:00 Securing and Delegating AD Objects 00:12:00 Delegation 00:05:00 Adding Computer Accounts to AD 00:08:00 Organizing AD with Container Objects 00:13:00 Joining the Demo 00:08:00 Working With Computer Objects and Accounts 00:17:00 Recycling the Computer Account 00:01:00 Automating Computer Account Creation 00:08:00 Automating Computer Creation 00:04:00 Understanding GPOs Using Group Policy 00:04:00 What Are Group Policy Objects 00:21:00 Group Policy 00:05:00 Restricted Group Policies 00:02:00 Restrcted Group 00:03:00 Analyzing Security Settings 00:12:00 Using The Security Configuration Wizard 00:05:00 SCW 00:08:00 Deploying Software with Group Policy 00:10:00 Software Deployment 00:02:00 Understanding Group Policy Scope 00:11:00 How Group Policy Settings are Processed 00:09:00 Group Policy Scope 00:11:00 Verifying Group Policy Settings 00:05:00 Verifying Group Policy 00:03:00 Enabling Auditing 00:13:00 Auditing 00:05:00 Managing Users and Groups with AD Automating User Account Creation 00:10:00 Automating User Accounts 00:07:00 Working with User Attributes 00:15:00 User Account Administrative Tasks 00:05:00 Supporting User Accounts 00:04:00 Using PowerShell to Create User Accounts 00:09:00 Creating Users with PowerShell 00:07:00 Creation and Management 00:08:00 The Basics of Groups 00:25:00 Managing Group 00:08:00 Best Practices for Using AD Groups 00:08:00 Automating Group Creation 00:05:00 Automating Creation of Groups 00:06:00 Advanced Group Options 00:09:00 Administering Groups 00:05:00 Working With Domain Controllers Installation Options 00:06:00 How to Install a Domain Controller 00:06:00 Introducing the Operations Masters 00:11:00 Designing Where to Deploy the Operation Masters 00:14:00 FSMO 00:03:00 SYSVOL Replication with DFS 00:02:00 Adding DNS DNS Basics 00:15:00 DNS Definitions and Terms 00:17:00 DNS 00:05:00 Setting up DNS for the Enterprise 00:09:00 Global Names 00:09:00 Securing the Authentication Process Password Security Policies 00:15:00 Passwords 00:03:00 Introducing the Read-Only Domain Controller 00:06:00 Installing the RODC 00:05:00 Auditing Authentication Events 00:03:00 Account Logging 00:03:00 Monitoring and Supporting AD Preparing for Recovery 00:10:00 Active Directory Tools 00:24:00 Monitoring Active Directory Performance 00:11:00 Performance Monitor 00:09:00 Planning Active Directory Deployment What Are Sites 00:27:00 Deciding on Site Boundaries 00:07:00 Sites and Subnets 00:08:00 Working with Global Catalog Placement with AD Partitions 00:09:00 Controlling Replication Between Sites 00:20:00 Managing the Global Catalog 00:04:00 Configuring AD Trust Relationships 00:32:00 Trusts 00:03:00 Choosing the Domain and Forest Functional Levels 00:07:00 IDA Solutions Understanding AD FS 00:10:00 Installing AD FS 00:01:00 Configuring and Using AD FS 00:03:00 Understanding AD RMS 00:10:00 Installing AD RMS 00:03:00 Configuring and Using AD RMS 00:07:00 Understanding AD LDS 00:08:00 Installing AD LDS 00:02:00 Installing AD LDS 00:05:00 Configuring and Using AD LDS 00:07:00 Security Review 00:04:00 Active Directory Certificate Services Understanding AD CS 00:29:00 Installing AD CS 00:02:00 Configuring and Using AD CS 00:08:00 Mock Exam Mock Exam- 70-640 - Configuring Windows Server 2008 R2 Active Directory 00:20:00 Final Exam Final Exam- 70-640 - Configuring Windows Server 2008 R2 Active Directory 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

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

Level 2 Certificate in Understanding the Safe Handling of Medication in Health and Social Care Are you hoping to learn about medication handling or health and social care? The Level 2 Certificate in Understanding the Safe Handling of Medication in Health and Social Care Courses will help you understand medication safety in health and social care environments. This Level 2 Certificate in Understanding the Safe Handling of Medication in Health and Social Care course aims to teach about supply, storage, and keeping audit reports on medication processes. Also, this Level 2 Certificate in Understanding the Safe Handling of Medication in Health and Social Care course is perfect for learning essential needs for safe administration. After finishing the Level 2 Certificate in Understanding the Safe Handling of Medication in Health and Social Care, you will have detailed knowledge and confidence in this topic. Enrol in the Level 2 Certificate in Understanding the Safe Handling of Medication in Health and Social Care to become a competent and caring health and social care worker. Learning Outcomes of Level 2 Certificate in Understanding the Safe Handling of Medication in Health and Social Care Course In this Level 2 Certificate in Understanding the Safe Handling of Medication in Health and Social Care program, you will learn about: Various types of medications, their applications, and their side effects. Through the Level 2 Certificate in Understanding the Safe Handling of Medication in Health and Social Care course you can understand the various routes of administration as well as how to handle and prepare various types of medication. Enhance your understanding of how to monitor patients for any bad responses and respond accordingly by this Level 2 Certificate in Understanding the Safe Handling of Medication in Health and Social Care course. This Level 2 Certificate in Understanding the Safe Handling of Medication in Health and Social Care course describes the fundamentals of drug storage and disposal. You can increase the capability to comprehend and analyse medication-related information and effectively transmit it to others with the help of this Level 2 Certificate in Understanding the Safe Handling of Medication in Health and Social Care course. This Level 2 Certificate in Understanding the Safe Handling of Medication in Health and Social Care course explains the competence in performing pharmacological treatments in a safe and effective manner. Main Course: Level 2 Certificate in Understanding the Safe Handling of Medication in Health and Social Care Free Courses are including with this Level 2 Certificate in Understanding the Safe Handling of Medication in Health and Social Care Course Along with The Level 2 Certificate in Understanding the Safe Handling of Medication in Health and Social Care Course, We Offer a free Level 2 Certificate in Preparing to Work in Adult Social Care Course Along with The Level 2 Certificate in Understanding the Safe Handling of Medication in Health and Social Care Course, We Offer a free Level 2 Certificate in Understanding Safeguarding and Prevent Course Along with The Level 2 Certificate in Understanding the Safe Handling of Medication in Health and Social Care Course, We Offer a free Diploma in Mastering Psychology Healthcare Management Training Course Special Offers of this Level 2 Certificate in Understanding the Safe Handling of Medication in Health and Social Care Course This Level 2 Certificate in Understanding the Safe Handling of Medication in Health and Social Care Course includes a FREE PDF Certificate. Lifetime access to this Level 2 Certificate in Understanding the Safe Handling of Medication in Health and Social Care Course Instant access to this Level 2 Certificate in Understanding the Safe Handling of Medication in Health and Social Care Course Get FREE Tutor Support to this Level 2 Certificate in Understanding the Safe Handling of Medication in Health and Social Care Course Level 2 Certificate in Understanding the Safe Handling of Medication in Health and Social Care Modern medications are potent substances that provide global benefits to millions of people. However, improper handling or use of these medications can have detrimental, even lethal, effects. Anybody who handles pharmaceuticals needs to be up to date on safe medication handling practices. An excellent introduction to the different types of medications and how to record, store, and handle them is provided by this Level 2 Certificate Understanding the Safe Handling of Medication in Health & Social Care course. Who is this course for? Level 2 Certificate in Understanding the Safe Handling of Medication in Health and Social Care This Level 2 Certificate in Understanding the Safe Handling of Medication in Health and Social Care qualification is ideal for anyone who wants to improve their knowledge of safely handling medicines. Requirements Level 2 Certificate in Understanding the Safe Handling of Medication in Health and Social Care To enrol in this Safe Handling of Medication in Health and Social Care Course, students must fulfil the following requirements. To join in our Safe Handling of Medication in Health and Social Care Course, you must have a strong command of the English language. To successfully complete our Safe Handling of Medication in Health and Social Care Course, you must be vivacious and self driven. To complete our Course, you must have a basic understanding of computers. A minimum age limit of 15 is required to enrol in this Course. Career path Level 2 Certificate in Understanding the Safe Handling of Medication in Health and Social Care This Level 2 Certificate in Understanding the Safe Handling of Medication in Health and Social Care course can lead to roles such as Care Worker or Pharmacy Assistant.

Overview This complete education course will improve your Project Management Training.This wide curriculum gives you the skills and information you need to succeed in this fast-paced industry, and the highly desired CPD accreditation can further improve your resume. With this training, you'll be prepared for a quick rise rather than taking it step by step up the career ladder. Participate now to see how your project management skills increase significantly! Why Choose this Project Management Bundle? FREE Project Management CPD-accredited certificate Get a free student ID card with Project Management training (£10 applicable for international delivery) Lifetime access to the Project Management course materials The Project Management program comes with 24/7 tutor support Get instant access to this Project Management course Learn Project Management training from anywhere in the world The Project Management training is affordable and simple to understand The Project Management training is entirely online How will I get my Project Management certificate? Upon successful completion of the Project Management Training course, obtaining your certificate is a straightforward process. Here's how it works: Course Completion: Once you've successfully finished the course, you'll be eligible to receive your certificate. Order Your Certificate: You can conveniently order your certificate directly through our platform. Who is This Project Management course for? There is no experience or previous qualifications required for enrolment on this Project Management Training. It is available to all students, of all academic backgrounds. Requirements Our Project Management Training course is designed for maximum flexibility and accessibility: It is optimised for use on PCs, Macs, laptops, tablets, and smartphones. Study easily on your tablet or smartphone, accessible with any Wi-Fi connection. No time limit for completion; study at your own pace and on your own schedule. Basic English proficiency is required to ensure effective learning. Career Path Having this Project Management qualification will enhance your CV and open you up to multiple sectors, such as : Project Manager: £45k - £90k per year Project Coordinator: £35k - £70k per year Program Manager: £50k - £95k per year Project Analyst: £30k - £65k per year Project Management Consultant: £55k - £100k+ per year Note: Salaries vary based on experience, location, and industry. Course Curriculum 12 sections • 86 lectures • 03:24:00 total length •1.1 Introduction to Project Management: 00:04:00 •1.2 6 Pathways of Project Management: 00:03:00 •1.3 Course Structure: Simplified Framework: 00:01:00 •1.4 System Thinking: 00:01:00 •1.5 Project Timeline: 00:01:00 •1.6 Pyramid Project: 00:03:00 •2.1 Project: 00:02:00 •2.2 Project Management mbmbmbm: 00:01:00 •2.3 The Matrix Environment: 00:04:00 •2.4 Enterprise Environmental Factors and Organisational Process Assets: 00:01:00 •2.5 Project Constraints: 00:01:00 •2.6 Process Groups: 00:03:00 •2.7 Integration Management: 00:02:00 •2.8 Stakeholder Management: 00:01:00 •2.9 Scope Management: 00:01:00 •2.10 Schedule Management: 00:01:00 •2.11 Cost, HR, Quality and Risk Management: 00:02:00 •2.12 Communication and Procurement Management: 00:01:00 •2.13 Knowledge Areas and Process Groups: 00:01:00 •3.1 Develop Project Charter: 00:05:00 •3.2 Project Charter Template: 00:06:00 •3.3 Timeline View of Project Documents: 00:01:00 •4.1 Identify Stakeholders: 00:04:00 •4.2 Stakeholder Register Template: 00:01:00 •4.3 Timeline View of Project Documents: 00:04:00 •5.1 Project Scope: 00:04:00 •5.2 Collect Requirements: 00:02:00 •5.3 Define Project Scope: 00:01:00 •5.4 Create WBS: Work Breakdown Structure: 00:03:00 •5.5 Project Scope Baseline: 00:06:00 •5.6 Timeline View of Project Documents: 00:01:00 •5.7 Microsoft Project: 00:02:00 •5.8 MS Project - User Interface Explained: 00:02:00 •5.9 MS Project - Entering Scope Items: 00:06:00 •6.1 Define Activities: 00:04:00 •6.2 Sequence Activities: 00:02:00 •6.3 Estimating Activity Durations: 00:02:00 •6.4 Develop Schedule Process: 00:01:00 •6.5 Critical Path Method: 00:03:00 •6.6 Compressing Schedule : Crashing and Fast-tracking: 00:03:00 •6.7 Timeline View of Project Documents: 00:01:00 •6.8 Microsoft Project - Entering Activities and Duration: 00:03:00 •6.9 Microsoft Project - Sequencing Activities & Creating Gantt Chart: 00:07:00 •6.10 Microsoft Project - The Project Schedule: 00:06:00 •7.1 Estimated Costs: 00:03:00 •7.2 Determined Budget: 00:01:00 •7.3 Timeline View of Project Documents: 00:01:00 •7.4 Estimate Activity Resources: 00:02:00 •7.5 Timeline View of Project Documents: 00:01:00 •7.6 Plan Quality: 00:04:00 •7.7 Timeline View of Project Documents: 00:01:00 •7.8 Introduction to Risks: 00:03:00 •7.9 Identify Risks: 00:02:00 •7.10 Perform Qualitative Risk Analysis: 00:04:00 •7.11 Perform Quantitative Risk Analysis: 00:01:00 •7.12 Plan Risk Responses: 00:02:00 •7.13 Timeline View of Project Documents: 00:01:00 •8.1 Plan Communication: 00:02:00 •8.2 Timeline View of Project Documents: 00:01:00 •8.3 Plan Procurement: 00:02:00 •8.4 Timeline View of Project Documents: 00:01:00 •9.1 HOW are things done on the project: 00:06:00 •9.2 Develop Project Management Plan: 00:01:00 •9.3 Individual Management Plans: 00:04:00 •9.4 Timeline View of Project Documents: 00:01:00 •9.5 Timeline View of Project Documents-2: 00:01:00 •9.6 Direct and Manage Project Work: 00:04:00 •9.7 Timeline View of Project Documents: 00:01:00 •9.8 Manage Project Knowledge: 00:02:00 •9.9 Timeline View of Project Documents: 00:01:00 •9.10 Monitor and Control Project Work: 00:02:00 •9.11 Timeline View of Project Documents: 00:01:00 •9.12 Perform Integrated Change Control: 00:04:00 •9.13 Steps to perform Change Control: 00:05:00 •9.14 Timeline View of Project Documents: 00:01:00 •9.15 Budget at Completion: BAC: 00:05:00 •9.16 Planned Value: PV: 00:02:00 •9.17 Earned Value: EV: 00:02:00 •9.18 Schedule Variance (SV) & Schedule Performance Index (SPI): 00:02:00 •9.19 Actual Cost(AC), Cost Variance and Cost Performance Index: 00:03:00 •9.20 Budget Forecasting - Estimate at & to completion: 00:06:00 •9.21 Close Project or Phase: 00:03:00 •9.22 Timeline View of Project Documents: 00:01:00 •Resources - Project Management Training: 00:00:00 •Assignment - Project Management Training: 3 days •Order Your Certificate: 00:00:00

Duration 2 Days 12 CPD hours This course is intended for Network engineers, technical support personnel, reseller support engineers, and others responsible for implementing and/or maintaining the Juniper Networks products covered in this course. Overview Introduction to carrier Ethernet Describe the function of an Ethernet LAN Describe Ethernet frame filtering Implement VLAN tagging Implement IRB Implement a virtual switch Describe interconnecting routing instances Describe provider bridging Configure and monitor provider bridging Configure and monitor provider backbone bridging Explain the purpose of the Spanning Tree Protocol (STP) Configure and monitor the STP, the RSTP, the MSTP, and the VSTP Explain the purpose of bridge protocol data unit (BPDU), loop, and root protection Describe the basic operation of link fault management (LFM) Describe the basic operation of connectivity fault management (CFM) Configure and monitor Ethernet OAM Describe and configure Ethernet Ring Protection (ERP) The Junos Service Provider Switching course is a two-day course that provides students with intermediate switching knowledge and configuration examples that are most common in a Service provider implementation. Course Outline Course Introduction Carrier Ethernet Ethernet in the WAN Ethernet Standards Organizations MX Series Layer 2 Features Ethernet Switching and Virtual LANs Ethernet LANs Bridging Configuring and Monitoring VLANs Configuring and Monitoring IRB Layer 2 Address Learning and Forwarding Layer 2 Firewall Filtering Virtual Switches Routing Instances Overview Configuring and Monitoring Virtual Switches Interconnecting Routing Instances Provider Bridging Expanding the Bridged Network Provider Bridging Configuring and Monitoring Provider Bridging Provider Backbone Bridging Configuring and Monitoring Provider Backbone Bridging Spanning-Tree Protocols Overview of STP Overview of RSTP Overview of MSTP Overview of VSTP Configuring and Monitoring Spanning-Tree Protocols Understanding BPDU, Loop, and Root Protection Ethernet OAM OAM Overview LFM CFM Configuring and Monitoring OAM Ethernet Ring Protection ERP Overview Configuring and Monitoring ERP LAG Overview Configuring and Monitoring a LAG

Play is more than just a pastime for children; it's a crucial element in their development. The Child Playwork course delves into the scientific principles and theories that underpin playwork, exploring its profound impact on children's physical, emotional, and cognitive growth.