13285 Manager courses in Huntingdon delivered Online

Duration 5 Days 30 CPD hours This course is intended for This course is designed primarily for network and software engineers who are interested in learning about automation and programmability and hold the following job roles: Consulting systems engineer IoT Designer Network administrator Network engineer Network manager Sales engineer Systems engineer Technical solutions architect Overview After taking this course, you should be able to: Explain the fundamentals of Cisco IoT and list common devices involved List the common protocols, standards, and data flows of IoT Explain the Cisco IoT, common needs, and the corresponding solutions Explain how programmability can be used to automate and make operations, deployment, and support of Cisco IoT more effective Describe common Cisco IoT applications and how they apply to Cisco IoT use cases Explain the functions and use cases for Cisco security applications and Cisco IoT This course prepares you to develop Internet of Things (IoT) applications for Cisco© IoT edge compute and network architecture. Through a combination of lessons and hands-on experience, you will learn to implement and deploy Cisco IOx applications using Cisco Field Network Director and Cisco Kinetic. This course covers designing, deploying, and troubleshooting edge applications, and understanding the use of management tools, so you can control your industrial network and connected devices at scale. This course will prepare you for the certification exam 300-915 Developing Solutions Using Cisco IoT and Edge Platforms (DEVIOT), a concentration in the CCNP DevNet track. Course Outlines DEFINING CISCO IOT IOT NETWORKING AND OTHER DEVICES EXAMINING IOT PROTOCOLS EXAMINING IOT STANDARDS RECOGNIZING CISCO IOT NEEDS AND SOLUTIONS USING PROGRAMMABILITY WITH CISCO IOT DESCRIBING CISCO IOT APPLICATIONS: CISCO IOX DESCRIBING CISCO IOT APPLICATIONS: CISCO KINETIC AND CISCO FIELD NETWORK DIRECTOR DEFINING CISCO SECURITY APPLICATIONS Lab outline Use an MQTT Consumer to Subscribe to Sensor Data Use Cisco IOx Applications to Receive and Process Sensor Data Troubleshoot a Sensor Connection Use and Interpret Freeboard Data Use and Interpret Grafana Data Use and Interpret Kibana Data Cisco IOx Familiarity Lab Develop and Deploy a Cisco IOx Application Troubleshoot Cisco IOx Navigate Cisco Field Network Director Explore Cisco Field Network Director API Additional course details: Nexus Humans Cisco Developing Solutions Using Cisco IoT and Edge Platforms v1.0 (DEVIOT) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Cisco Developing Solutions Using Cisco IoT and Edge Platforms v1.0 (DEVIOT) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 5 Days 30 CPD hours This course is intended for Although there are no mandatory prerequisites, the course is particularly suited for the following audiences: Cybersecurity engineer Cybersecurity investigator Incident manager Incident responder Network engineer SOC analysts currently functioning at entry level with 2+ years of experience Overview After taking this course, you should be able to: Describe the types of service coverage within a SOC and operational responsibilities associated with each. Compare security operations considerations of cloud platforms. Describe the general methodologies of SOC platforms development, management, and automation. Explain asset segmentation, segregation, network segmentation, micro-segmentation, and approaches to each, as part of asset controls and protections. Describe Zero Trust and associated approaches, as part of asset controls and protections. Perform incident investigations using Security Information and Event Management (SIEM) and/or security orchestration and automation (SOAR) in the SOC. Use different types of core security technology platforms for security monitoring, investigation, and response. Describe the DevOps and SecDevOps processes. Explain the common data formats, for example, JavaScript Object Notation (JSON), HTML, XML, CommaSeparated Values (CSV). Describe API authentication mechanisms. Analyze the approach and strategies of threat detection, during monitoring, investigation, and response. Determine known Indicators of Compromise (IOCs) and Indicators of Attack (IOAs). Interpret the sequence of events during an attack based on analysis of traffic patterns. Describe the different security tools and their limitations for network analysis (for example, packet capture tools, traffic analysis tools, network log analysis tools). Analyze anomalous user and entity behavior (UEBA). Perform proactive threat hunting following best practices. The Performing CyberOps Using Cisco Security Technologies (CBRCOR) v1.0 course guides you through cybersecurity fundamentals and prepares you for the role of Information Security Analyst on a Security Operations Center team. You?ll learn to automate for security using cloud platforms and how to apply your knowledge to real-world scenarios Course Outline Understanding Risk Management and SOC Operations Understanding Analytical Processes and Playbooks Investigating Packet Captures, Logs, and Traffic Analysis Investigating Endpoint and Appliance Logs Understanding Cloud Service Model Security Responsibilities Understanding Enterprise Environment Assets Threat Tuning Threat Researching and Threat Intelligence Practices Understanding APIs Understanding SOC Development and Deployment Models Performing Security Analytics and Reports in a SOC Malware Forensics Basics Threat Hunting Basics Additional course details: Nexus Humans Cisco Performing CyberOps Using Cisco Security Technologies (CBRCOR) v1.0 training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Cisco Performing CyberOps Using Cisco Security Technologies (CBRCOR) v1.0 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.

Sexual Harassment Awareness Training course offers comprehensive insights into recognising, understanding, and effectively managing instances of sexual harassment within the workplace. This Sexual Harassment Awareness Training online course delves into the different types of harassment, exploring both its psychological and social impacts, as well as the legal standards designed to protect individuals and uphold equality. Learners will gain practical knowledge of workplace policies, procedures, and best practices for addressing harassment, alongside techniques to create a safe, inclusive environment for all employees. With modules covering the nuances of dealing with toxicity, fostering respect, and understanding equality, this training equips individuals to advocate for positive workplace dynamics and ensure professional boundaries are maintained. Learning Outcomes of the Sexual Harassment Awareness Training Course By completing this Sexual Harassment Awareness Training course, learners will: Understand the impact and consequences of sexual harassment in professional settings. Identify various types and signs of sexual harassment. Familiarise themselves with workplace policies and relevant legal standards. Learn effective methods for addressing and preventing incidents of harassment. Gain insights into fostering inclusivity to minimise toxicity and promote equality. Key Features of the Sexual Harassment Awareness Training Course CPD-accredited certification for career enhancement. Flexible, on-demand learning with expert-developed resources. Continuous support from experienced industry professionals. Requirements Open to everyone; no prior experience required. Accessible on any internet-enabled device. CPD Certificate from Course Gate Upon successful course completion, learners may obtain a CPD certificate: PDF for £9, a hard copy for £15, or both for £22. Who Is This Sexual Harassment Awareness Training Course For? HR managers and team leaders aiming to reinforce workplace safety. Individuals seeking a deeper understanding of harassment issues. Professionals committed to promoting a respectful, harassment-free workplace. Career Path This Sexual Harassment Awareness Training enhances skills for roles such as: Human Resources Specialist Workplace Compliance Officer Employee Relations Manager Equality and Diversity Advisor

🚀 Unlock the Power of Quality Assurance with Our Software Testing Course! 🚀 Are you ready to take your career in the tech industry to new heights? Dive into the world of software testing and equip yourself with the essential skills needed to ensure top-notch quality in every digital product! Our comprehensive Software Testing course is your gateway to mastering the art of detecting bugs, ensuring functionality, and delivering seamless user experiences.   Why Software Testing Matters? In today's fast-paced digital landscape, flawless software performance is non-negotiable. Every glitch, bug, or malfunction can cost a company its reputation, customers, and revenue. That's where software testing comes into play. By meticulously examining code, analyzing system functionalities, and running rigorous tests, software testers play a crucial role in identifying and rectifying issues before they escalate.   Benefits of Our Software Testing Course Stay Ahead of the Curve: In an industry that's constantly evolving, staying stagnant is not an option. Our course provides you with the latest techniques, tools, and methodologies in software testing, ensuring you're always ahead of the curve. Enhance Product Quality: Become the guardian of quality by learning how to conduct thorough tests that identify even the most elusive bugs. With your expertise, you'll contribute to the creation of robust, reliable software that delights users. Boost Employability: Employers are constantly on the lookout for skilled software testers who can ensure their products meet the highest standards. By completing our course, you'll enhance your employability and open doors to exciting career opportunities. Save Time and Resources: Catching bugs early in the development process saves both time and resources. Our course teaches you how to implement efficient testing strategies, helping companies streamline their workflows and minimize costly rework. Earn Recognition and Respect: As a proficient software tester, you'll earn the respect of your peers and recognition from industry leaders. Your ability to deliver flawless software solutions will position you as a valuable asset in any organization.   Who is This For? Our Software Testing course is perfect for: Aspiring QA Engineers Software Developers looking to expand their skillset IT Professionals interested in quality assurance Students pursuing a career in technology Anyone passionate about ensuring top-notch software quality No matter your background or experience level, if you're eager to dive into the world of software testing, this course is for you!   Career Path Upon completing our Software Testing course, you'll be well-equipped to pursue a variety of exciting career paths, including: Quality Assurance Engineer: As a QA engineer, you'll be responsible for ensuring that software products meet the highest quality standards. You'll design and execute tests, identify defects, and collaborate with developers to resolve issues. Test Automation Engineer: Automation is becoming increasingly essential in software testing. As a test automation engineer, you'll leverage tools and scripts to automate repetitive testing tasks, improving efficiency and accuracy. Software Development Engineer in Test (SDET): SDETs combine development and testing skills to create robust testing frameworks and tools. They play a crucial role in ensuring the reliability and scalability of software systems. Quality Assurance Manager: With experience and expertise, you could advance to a managerial role overseeing QA teams and processes. Quality assurance managers are responsible for setting testing standards, optimizing workflows, and ensuring the overall quality of deliverables.   Don't Miss Out on This Opportunity! Are you ready to embark on an exciting journey into the world of software testing? Enroll in our Software Testing course today and unlock the door to a rewarding career in quality assurance. Join thousands of satisfied students who have transformed their careers with our comprehensive training program. Don't wait - secure your future in tech today!   FAQ (Frequently Asked Questions) - Software Testing Q1: What is software testing, and why is it important? Software testing is the process of evaluating a software application or system to ensure that it meets specified requirements and works as expected. It involves executing a program or system with the intent of finding errors or bugs and verifying that the software meets its quality and performance objectives. Testing is crucial for several reasons: It helps identify and fix defects or bugs early in the development process, reducing the cost of fixing issues later. It ensures that the software meets user requirements and expectations, enhancing user satisfaction. Testing improves the reliability, usability, and performance of software applications, thereby increasing their overall quality. It helps build confidence in the software's correctness and functionality, leading to better adoption and success in the market. Q2: What are the different types of software testing? There are various types of software testing, each serving different purposes and objectives: Unit Testing: Tests individual components or modules to ensure they function correctly in isolation. Integration Testing: Verifies that multiple components work together as expected when integrated. System Testing: Evaluates the entire system's functionality and performance in the context of the intended environment. Acceptance Testing: Validates that the software meets user requirements and is ready for deployment. Regression Testing: Ensures that changes or updates to the software do not adversely affect existing functionality. Performance Testing: Evaluates the software's responsiveness, scalability, and stability under different workload conditions. Security Testing: Identifies vulnerabilities and weaknesses in the software to prevent unauthorized access or data breaches. Q3: When should testing be performed in the software development lifecycle? Testing should be integrated into the software development lifecycle from the early stages and conducted iteratively throughout the process. Ideally, testing starts as soon as individual components or modules are developed and continues through integration, system development, and acceptance testing phases. Iterative testing allows for early detection and resolution of issues, reducing the risk of defects accumulating and impacting the final product. Q4: What are some common challenges in software testing? Incomplete or unclear requirements: Lack of clear specifications can make it challenging to determine what to test. Time and resource constraints: Limited time and resources may restrict the extent of testing that can be performed. Changing requirements: Frequent changes in requirements can lead to scope creep and require retesting. Complexity of software: Testing complex systems with intricate dependencies can be challenging and time-consuming. Test environment setup: Creating and maintaining test environments that mimic production can be complex and costly. Effective communication: Ensuring clear communication among stakeholders, developers, and testers is essential for successful testing. Course Curriculum Module 1 Introduction to Software Engineering Introduction to Software Engineering 00:00 Module 2 Software Design Principles and Testing Software Design Principles and Testing 00:00 Module 3 Software Maintenance and Evolution Software Maintenance and Evolution 00:00 Module 4 Software Project Management Software Project Management 00:00 Module 5 Software Configuration Management Software Configuration Management 00:00 Module 6 Software Project Metrics and Measurement Software Project Metrics and Measurement 00:00

🔍 Unlock Your Potential with the Certificate in KYC & Customer Due Diligence! 🔍 Are you ready to embark on a rewarding journey towards mastering KYC (Know Your Customer) and Customer Due Diligence? Look no further! Our comprehensive Certificate in KYC & Customer Due Diligence equips you with the essential knowledge and skills to thrive in the dynamic world of compliance and risk management. 🎓   🌟 Benefits of Taking the Course: Stay Compliant: In today's regulatory environment, compliance is paramount. By enrolling in our course, you'll gain a deep understanding of KYC regulations and customer due diligence processes, ensuring your organization remains compliant with legal requirements. Risk Mitigation: Identify and mitigate potential risks associated with customer onboarding and ongoing monitoring. Learn effective risk assessment techniques to protect your organization from financial losses and reputational damage. Enhanced Career Opportunities: Stand out in the job market with a valuable certification in KYC & Customer Due Diligence. Whether you're looking to advance in your current role or explore new career opportunities, this certificate will open doors to a wide range of roles in banking, finance, consulting, and more. Confidence in Decision-Making: Develop the confidence to make informed decisions when it comes to customer onboarding, risk assessment, and compliance procedures. Gain practical insights from industry experts to navigate complex compliance challenges effectively. Professional Growth: Invest in your professional development and stay ahead of the curve in an ever-evolving industry. Our course provides you with the knowledge and skills needed to excel in your career and pursue exciting growth opportunities.   🎯 Who is this for? Compliance Professionals: Stay updated with the latest regulations and best practices in KYC and customer due diligence. Banking and Financial Services Professionals: Enhance your expertise in compliance and risk management to advance your career in the financial industry. Legal and Regulatory Specialists: Deepen your understanding of regulatory requirements and compliance frameworks to better serve your clients. Entrepreneurs and Business Owners: Ensure your business operates in accordance with regulatory standards and safeguards against potential risks. Anyone Interested in Compliance: Whether you're new to the field or seeking to broaden your knowledge, this course is suitable for individuals from diverse backgrounds interested in compliance and risk management.   🚀 Career Path: Upon completing the Certificate in KYC & Customer Due Diligence, you'll be well-equipped for a variety of roles, including: KYC Analyst: Perform thorough due diligence on customers to verify their identities and assess associated risks. Compliance Officer: Ensure adherence to KYC regulations and implement robust compliance frameworks within organizations. Risk Manager: Identify, assess, and mitigate risks associated with customer relationships and transactions. AML (Anti-Money Laundering) Specialist: Detect and prevent money laundering activities by implementing effective AML procedures and controls. Financial Crime Investigator: Investigate suspicious activities and conduct forensic analyses to combat financial crimes. Consultant: Provide advisory services to organizations on KYC and customer due diligence best practices and regulatory compliance.   Don't miss out on this opportunity to take your career to new heights! Enroll in the Certificate in KYC & Customer Due Diligence today and become a sought-after expert in compliance and risk management. 💼 Ready to take the next step? Contact us now to learn more about our course offerings and kickstart your journey towards success! FAQ (Frequently Asked Questions) for Certificate in KYC & Customer Due Diligence Course Q1: What is KYC (Know Your Customer) and why is it important? A: KYC, or Know Your Customer, is a process through which businesses verify the identity of their clients. It involves collecting and assessing information about customers to ensure they are who they claim to be and to assess the risks associated with doing business with them. KYC is crucial for preventing financial crimes such as money laundering, terrorism financing, and fraud. By knowing their customers, businesses can mitigate risks and comply with regulatory requirements. Q2: What is Customer Due Diligence (CDD) and how does it relate to KYC? A: Customer Due Diligence (CDD) is a component of the KYC process. It involves gathering information about customers to assess their risk profile and to understand the nature and purpose of their transactions. CDD helps businesses make informed decisions about the level of risk associated with each customer and enables them to implement appropriate risk management measures. CDD is essential for ensuring compliance with anti-money laundering (AML) and counter-terrorism financing (CTF) regulations. Q3: What are the key components of a KYC/CDD program? A: A comprehensive KYC/CDD program typically includes the following key components: Customer Identification: Verifying the identity of customers using reliable and independent sources of information. Customer Risk Assessment: Assessing the risk associated with each customer based on factors such as their identity, occupation, transaction patterns, and geographic location. Ongoing Monitoring: Continuously monitoring customer transactions and behavior to detect any suspicious activity or changes in risk profile. Enhanced Due Diligence (EDD): Conducting enhanced due diligence on high-risk customers, such as politically exposed persons (PEPs) or customers from high-risk jurisdictions. Record-Keeping: Maintaining accurate and up-to-date records of customer information and due diligence activities to demonstrate compliance with regulatory requirements. Q4: Who should undergo KYC/CDD training? A: KYC/CDD training is essential for professionals working in industries such as banking, financial services, insurance, real estate, and gaming, where there is a high risk of financial crime. This includes compliance officers, risk managers, customer relationship managers, and frontline staff responsible for customer onboarding and due diligence processes. Additionally, regulatory bodies often require individuals working in these industries to undergo KYC/CDD training to ensure they have the necessary knowledge and skills to fulfill their compliance obligations. These FAQs provide a general overview of KYC and Customer Due Diligence. For more detailed information and specific training requirements, individuals should consult with accredited training providers or regulatory authorities in their jurisdiction. Course Curriculum Module 1 - Introduction to KYC Introduction to KYC 00:00 Module 2 - KYC Requirements in the UK KYC Requirements in the UK 00:00 Module 3 - Customer Due Diligence Customer Due Diligence 00:00 Module 4 - KYC Process _ Procedures Guide KYC Process Procedures Guide 00:00 Module 5 - AML (Anti-Money Laundering) AML (Anti-Money Laundering) 00:00 Module 6 - KYC and AML - Key Differences and How They Work Together KYC and AML - Key Differences and How They Work Together 00:00 Module 7 - KYC and AML Regulations in the UK KYC and AML Regulations in the UK 00:00 Module 8 - Reasonable Methods in KYC Verification Reasonable Methods in KYC Verification 00:00

Course Overview "Stock Trading Analysis with Volume Trading" is designed to provide learners with a comprehensive understanding of how to leverage volume analysis in stock trading. This course covers essential volume indicators, strategies, and techniques, empowering learners to make informed trading decisions. The course aims to enhance trading skills by explaining how volume trends can influence stock price movements, offering learners practical insights into market behaviour. By the end of the course, learners will have the ability to interpret volume data, use it to spot market trends, and apply it within their trading strategies, enhancing their confidence and decision-making capabilities in stock trading. Course Description This course delves into the critical aspect of volume analysis in stock trading, providing a thorough exploration of how trading volume can provide valuable market insights. Learners will study various volume indicators and their applications, uncover trading strategies that incorporate volume as a key factor, and gain the skills necessary to identify profitable market movements. The course also includes practical examples and analysis to demonstrate how volume impacts stock trends, while familiarising learners with the tools used in volume trading. By completing this course, learners will develop the expertise to utilise volume trading strategies to enhance their trading performance and make more informed decisions in real-time market scenarios. Course Modules Module 01: Volume Analysis Module 02: Volume Studies and Indicators Module 03: Volume Trading Strategies and Techniques Module 04: Examples and Analysis Module 05: Trading Platform (See full curriculum) Who is this course for? Individuals seeking to enhance their stock trading skills Professionals aiming to develop expertise in volume trading strategies Beginners with an interest in stock market analysis Anyone looking to understand the role of volume in trading decisions Career Path Stock Trader Financial Analyst Investment Advisor Trading Platform Specialist Portfolio Manager

Course Overview Grasp the opportunity to learn Microsoft Excel from the ABCs to an advanced level within one course. The Microsoft Excel Masterclass in 2021 course will start with the basics with MS excel and gradually turn you into an expert user. The Microsoft Excel Masterclass in 2021 course will first focus on the tools and functions of excel. You will comprehend the skills to create basic formulas in excel. In this step by the step learning process, you will have the adequate knowledge and ability to make all sorts of adjustments to your worksheets. The course will teach you many strategies for cell formatting. From the easy to follow modules, you will grasp the techniques to insert shapes and images into your sheets. You will also understand how to visualize your data in charts. In the end, you will study the benefits of using excel templates. The Microsoft Excel Masterclass in 2021 course will provide you with first-hand training on excel. Enroll in the course and take your excel skills to the next level. Learning Outcomes Get an introduction to Microsoft Excel and its functions Understand the process of data validation and data visualization Learn how to adjust excel worksheets Know about the conditional functions Familiarize yourself with the process of inserting images and shapes Who is this course for? Those who want to learn Microsoft Excel. Entry Requirement This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Certification After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path The Microsoft Excel Masterclass in 2021 course is a useful qualification to possess and would be beneficial for any related profession or industry such as: Business Professional Data Operator Administrative Officer Data Analyst 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:04: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:04: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 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 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:07: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 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 Excel's 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 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:14: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 Lopps 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 Masterclass in 2021 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Duration 1 Days 6 CPD hours This course is intended for The content is appropriate for test automation engineering roles, test manager roles, test lead roles, test architect roles, as well as developer roles. This course assumes you have a foundational understanding of testing and the purpose of automation. This course will be beneficial to anyone who is accountable for assessing, planning, designing, and implementing an integrated set of technology (testing infrastructure) that supports development, testing, and deployment. Overview Working in an interactive learning environment, led by our expert facilitator, attendees will learn to: Document the current state of test automation in your organization Define a custom test automation plan and architecture to fit their situation Create an initial implementation plan Identify initial key measures Develop a metrics dashboard for tracking the value of test automation Lay out a future strategy and roadmap to get there Introduction to Test Automation is a one-day, hands-on event designed to provide participants with the skills required to develop a custom test automation plan and architecture for their organization. Throughout the course, students will examine and work through various practical examples, learning how to create an integrated test automation plan and develop a test automation architecture. Participants will also learn about the possible real-world challenges they may face while trying to accomplish their goals, exploring the practical positive aspects of engaging their technical team, along with the possible frustrations of experiencing too much isolation between test automators and test designers. Getting Started Automation beginnings Software as a series of imperfect translations The Compelling Business Needs for Automation Automation the next opportunity Islands of Automation Getting products to market more quickly, at the right costs and quality Automation Challenges and Requirements Automation Challenges Test Automation Key Requirements Foundational material for your automation plan Templates Questions Examples Virtual Consulting included with this course Automation plan vision and strategy Vision, Strategy, Approach Example Defining your end in mind Deciding where to start Engaging Others Conducting a current state tools inventory Assessing your current state - tools and processes Tools inventory example and template Radar Chart as a means of presenting current state information Consider the best automation approach Waterfall vs. agile cycles of work Aligning tools with your methodologies Strategies for Automating The Test Automation Pyramid Developing your test automation architecture Blocks of automation capabilities Islands of Automation Integrated Tools Architecture Template Integrated Tools Architecture Examples Test automation architecture examples Examples of different test automation architectures and frameworks Selenium Key Test Automation Architecture Characteristics Acceptance test-driven and behavior-driven testing overview Test automation approaches FitNesse Cucumber Gherkin script overview Tool workflow Considerations for what to automate and when Categories of tests that might be automated We have many tool choices Key points in Test Tool Architecture Planning Piloting and Implementing automation Selecting and evaluating tools and rolling them out Selling Automation - qualitative questions Selling Automation - quantitative questions Measuring automation benefits Measures in technical terms Measures in business terms Measures of testing vs. measures of test automation Next Steps A few keys to success

The Quality Assurance (QA) Management Mini Bundle is your career boost if you're aiming for roles that demand high attention to detail, clear communication, and operational discipline. With a sharp focus on Quality Assurance, Logistics and Transportation, Purchasing and Procurement, Telephone Etiquette, and Negotiation Skills, this bundle is designed to make you hireable—fast. Employers are looking for versatile candidates who can balance compliance, customer interaction, and supply chain dynamics. This bundle signals that you're prepared with Quality Assurance, Logistics and Transportation, Purchasing and Procurement, Telephone Etiquette, and Negotiation Skills that hiring managers love to see. Description You don’t need to be told how competitive QA and operations roles are. Every hiring manager is looking for more than just one-dimensional experience. They want cross-functional professionals trained in Quality Assurance, Logistics and Transportation, Purchasing and Procurement, Telephone Etiquette, and Negotiation Skills. From managing product flow in Logistics and Transportation, to mastering sourcing through Purchasing and Procurement, to smoothing client calls with top-tier Telephone Etiquette, to closing deals using strong Negotiation Skills—this bundle shows you’ve got it all. And of course, it’s anchored by rock-solid Quality Assurance expertise. This isn't just about ticking boxes. It’s about transforming into a candidate who naturally brings Quality Assurance, Logistics and Transportation, Purchasing and Procurement, Telephone Etiquette, and Negotiation Skills into any work scenario. Think of the roles: QA analyst, procurement officer, operations coordinator, supply chain assistant, customer service rep. All need Quality Assurance, Logistics and Transportation, Purchasing and Procurement, Telephone Etiquette, and Negotiation Skills. Don’t wait until those roles are filled. FAQ Q: What roles is this bundle best for? A: Perfect for QA jobs, operations, logistics, procurement, and client-facing roles. If a job ad mentions Quality Assurance, Logistics and Transportation, Purchasing and Procurement, Telephone Etiquette, or Negotiation Skills—this is for you. Q: Is this bundle beginner-friendly? A: Yes. You don’t need prior experience to start benefiting from skills in Quality Assurance, Logistics and Transportation, Purchasing and Procurement, Telephone Etiquette, and Negotiation Skills. Q: Will I really use all five skills in one role? A: Absolutely. Modern roles require agility. Quality Assurance, Logistics and Transportation, Purchasing and Procurement, Telephone Etiquette, and Negotiation Skills overlap more than ever. Q: What’s the value of this bundle compared to separate courses? A: Enrolling in this bundle saves you from chasing individual certifications in Quality Assurance, Logistics and Transportation, Purchasing and Procurement, Telephone Etiquette, and Negotiation Skills. It’s one powerful, efficient step forward.

Learn to program with Python 3, visualize algorithms and data structures, and implement them in Python projects