1076 Logic courses in London delivered Online

Python Programming: Beginner To Expert Overview Unfold the potential within you, and embark on a journey of mastering Python programming - from the fundamental building blocks to the pinnacle of expertise. This comprehensive course, crafted with meticulous care, empowers you to transform from a curious novice to a confident coding maestro, wielding Python's power with finesse. Within these engaging modules, you'll delve into the core principles of Python, meticulously exploring data types, operators, control flow, and functions. As your proficiency blossoms, you'll conquer advanced topics like object-oriented programming, powerful libraries like NumPy and Pandas, and the art of crafting polished scripts. But this journey isn't merely about acquiring technical prowess; it's about unlocking a world of possibilities. By the course's end, you'll be equipped to embark on a rewarding career path, armed with the skills to tackle real-world challenges in diverse domains - from data analysis and web development to scientific computing and automation. Learning Outcomes Gain a solid foundation in Python syntax, data structures, and control flow mechanisms. Master essential functions, user input, and error-handling techniques. Explore advanced data types, object-oriented programming concepts, and popular libraries like NumPy and Pandas. Craft polished, reusable Python scripts for various applications. Confidently navigate the Python ecosystem and continuously expand your knowledge. Why You Should Choose Python Programming: Beginner To Expert Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Python Programming: Beginner To Expert is CPD certified and IAO accredited. 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 backgrounds. Requirements Our Python Programming: Beginner To Expert 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 You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Python Programming: Beginner To Expert Module 01: Introduction to Python Programming from A-Z Intro To Python Section Overview 00:06:00 What is Python Programming? 00:10:00 Who is This Course For? 00:05:00 Python Programming Marketplace 00:06:00 Python Job Opportunities 00:05:00 How To Land a Python Job Without a Degree 00:08:00 Python Programmer Job Roles 00:09:00 Python from A-Z Course Structure 00:04:00 Module 02: Getting Familiar with Python Getting Familiar with Python Section Overview 00:06:00 Installing Python on Windows 00:10:00 Anaconda and Jupyter Notebooks Part 1 00:08:00 Anaconda and Jupyter Notebooks Part 2 00:16:00 Comments 00:05:00 Python Syntax 00:02:00 Line Structure 00:03:00 Line Structure Exercise 00:07:00 Joining Lines 00:05:00 Multiple Statements on a Single Line 00:05:00 Indentation 00:08:00 Module 03: Basic Data Types Basic Data Types Section Overview 00:08:00 String Overview 00:10:00 String Manipulation 00:07:00 String Indexing 00:04:00 String Slicing 00:08:00 Printing 00:10:00 Python Variables 00:08:00 Integers and Floats 00:08:00 Booleans 00:02:00 Mini Project 1 : Letter Counter 00:20:00 Module 04: Python Operators Python Operators Section Overview 00:04:00 Comparison Operators 00:09:00 Arithmetic Operators 00:08:00 Assignment Operators 00:05:00 Logical Operators 00:13:00 Identity Operators 00:05:00 Membership Operators 00:02:00 Bitwise Operators 00:08:00 Module 05: Advanced Data Types Python Advanced Data Types Section Overview 00:11:00 Sets 00:06:00 List Overview 00:05:00 List Slicing and Indexing 00:04:00 Tuples 00:02:00 Dictionaries 00:11:00 When to use each one? 00:05:00 Compound Data Types 00:03:00 Module 06: Control Flow Part 1 Control Flow Part 1 Section Overview 00:15:00 Intro to Control Flow 00:01:00 Basic Conditional Statements 00:14:00 More Conditional Statements 00:05:00 For Loops 00:10:00 While Loops 00:12:00 Module 07: Control Flow Part 2 Control Flow Part 2 Section Overview 00:02:00 Break Statements 00:08:00 Continue Statements 00:05:00 Zip Function 00:07:00 Enumerate Function 00:04:00 List Comprehension 00:04:00 Module 08: Python Functions Python Functions Section Overview 00:03:00 Intro to Functions 00:02:00 Python help Function 00:03:00 Defining Functions 00:09:00 Variable Scope 00:08:00 Doc Strings 00:04:00 Module 09: User Input and Error Handling User Input and Error Handling Section Overview 00:02:00 Introduction to error handling 00:03:00 User Input 00:04:00 Syntax Errors 00:04:00 Exceptions 00:11:00 Handling Exceptions Part 1 00:08:00 Handling Exceptions Part 2 00:08:00 Module 10: Python Advanced Functions Python Advanced Functions Section Overview 00:05:00 Lambda Functions 00:05:00 Functions args and kwargs 00:10:00 Iterators 00:08:00 Generators and Yield 00:12:00 Map Function 00:14:00 Filter Function 00:08:00 Module 11: Python Scripting and Libraries Python Scripting and Libraries Section Overview 00:05:00 What is a script? 00:01:00 What is an IDE? 00:17:00 What is a text editor? 00:12:00 From Jupyter Notebook to VScode Part 1 00:15:00 From Jupyter Notebook to VScode Part 2 00:05:00 Importing Scripts 00:03:00 Standard Libraries 00:04:00 Third Party Libraries 00:06:00 Module 12: NumPy NumPy Section Overview 00:04:00 Why use NumPy? 00:04:00 NumPy Arrays 00:10:00 Reshaping, Accessing, and Modifying 00:07:00 Slicing and Copying 00:06:00 Inserting, Appending, and Deleting 00:10:00 Array Logical Indexing 00:04:00 Broadcasting 00:08:00 Module 13: Pandas Intro to Pandas 00:17:00 Pandas Series 00:17:00 Pandas Series Manipulation 00:17:00 Pandas DataFrame 00:17:00 Pandas DataFrame Manipulation 00:13:00 Dealing with Missing Values 00:10:00 Module 14: Introduction to OOP Functional vs OOP 00:06:00 OOP Key Definitions 00:04:00 Create your First Class 00:12:00 How to Create and Use Objects 00:06:00 How to Modify Attributes 00:12:00 Module 15: Advanced OOP Python Decorators 00:27:00 Property Decorator 00:09:00 Class Method Decorator 00:07:00 Static Methods 00:10:00 Inheritance from A to Z 00:21:00 Module 16: Starting a Career in Python Getting Started with Freelancing 00:09:00 Building A Brand 00:12:00 Personal Branding 00:13:00 Importance of Having Website/Blog 00:04:00 Do's and Don'ts of Networking 00:06:00 Creating A Python Developer Resume 00:06:00

Quality Guarantee: Promising training excellence, satisfaction gurantee Accredited by CPD UK & Quality License Scheme Tutor Support Unlimited support via email, till you complete the course Recognised Certification: Accepted by thousands of professional bodies Start Anytime With 1 year access to the course materials Online Learning Learn from anywhere, whenever you want Excel is an essential tool for data management and analysis and in this course, you will master everything from the fundamentals to advanced functionalities. You will learn to navigate the interface, create and format spreadsheets and perform calculations with ease and you will unlock the true potential of Excel for business and personal use. This course at a glance Accredited by CPD UK Endorsed by Quality Licence Scheme Understand the basics of Excel Know how to use Excel at an intermediate level Be aware of sum and numerical functions Understand how to manipulate text Know about logical functions Create effective spreadsheets Be confident with lookup functionality and date and time functions Easily use financial functions and sort and filter Progress to using Microsoft Excel at an advanced level Know how to create accurate and clear visual presentations Consolidate and validate data Use pivot table and what-if analysis Understand automation and macros Why Microsoft Excel Training Course right for you? Develop advanced skills in Microsoft Excel training course basic to advanced course, with this course. Learn from scratch or build on prior knowledge, to gain a good understanding of Excel functions. You will learn to accelerate your tasks efficiently using Excel techniques and formulae. The course covers how to create professional reports in no time, with Excel tools for data analysis and creating charts. This course will demystify the functions and tools in easy steps. It will teach you to work smart and save time. It is an excellent addition to your CV and is a valued skill in all businesses. Microsoft Excel Training Course Details Accredited by CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field.   The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Course Curriculum Microsoft Excel: Basic Level Introduction to Microsoft Excel 0101 Touring the Interface 0102 Enter Data & Saving Workbook 0103 Applying Formulas 0104 Changing a Worksheet's Structure 0105 Find, Replace & Spell Check 0106 Applying Fonts, Background Colors, and Borders 0107 Formatting Numbers and Dates 0108 Making the Fieces fit 0109 Inserting Headers & Footers and Repeating Rows 0110 Managing Large Workbooks Microsoft Excel: Intermediate Level Excel Essentials 0201 Formula Writing (Don't Miss This) Ex 0201 Formula Writing (Don't Miss this) Sum Count Average Functionality - With Conditions 0301 SumIf & SumIfs Ex 0301 SumIf & SumIfs 0302 Count Functions Ex 0302 Count Functions 0303 AverageIf & AverageIfs Ex 0303 AverageIf & AverageIfs Text Functions - Manipulating Text 0401 Change Case (Upper, Lower,Proper) Ex 0401 Change Case (Upper, Lower, Proper) 0402 Separating Text on Symmetrical Data Ex 0402 Separating Text on Symmetrical Data 0403 Separating Text on Non-Symmetrical Data Ex 0403 Separating Text on Non-Symmetrical Data Logical Functions - Working With Conditions 0501 If Functionality Ex 0501 IF Functionality 0502 If with AND Ex 0502 If with AND 0503 If with OR Ex 0503 If with OR 0504 If with 'AND' & 'OR' / IF with Countif Ex 0504 If with 'AND' & 'OR' / IF with Countif 0505 Nested IF (A Genie with 3 wishes) Ex 0505 Nested IF (A Genie with 3 wishes) Lookup Functionality - Burn Simple Find Technique 0601 Vlookup (Exact Match) # 1 Ex 0601 Vlookup (Exact Match) # 1 0602 Type of References (Use of $ sign) 0603 Vlookup (Exact Match) # 2 Ex 0603 Vlookup (Exact Match) # 2 0604 Double Vlookup Ex 0604 Double Vlookup 0605 Vlookup on Duplicate Values Ex 0605 Vlookup on Duplicate Values 0606 Vlookup (Approximate Match) Ex 0606 Vlookup (Approximate Match) 0607 Vlookup with If (Conditional Vlookup) Ex 0607 Vlookup with If (Conditional Vlookup) 0608 Hlookup (Exact Match) Ex 0608 Hlookup (Exact Match) 0609 Hlookup (Approximate Match) Ex 0609 Hlookup (Approximate Match) 0610 Lookup (Don't use this !) Ex 0610 Lookup (Don't use this !) 0611 Vlookup with Match (Create Magical Vlookup) Ex 0611 Vlookup with Match (Create Magical Vlookup) 0612 Match (Gives us Column/Row Index #) Ex 0612 Match (Gives us Column/Row Index #) 0613 Index & Match (Made for Each Other) Ex 0613 (1) Index & Match (Made for Each Other) Ex 0613 (2) Index & Match (Made for Each Other) Date & Time Function - A Tricky Game 0701 How Excel Records Date & Time 0702 Now, Today & Autofill 0703 DateValue & TimeValue 0704 Calculate WorkingDays 0705 DatedIf Financial Functions 0801 Loan Calculation (PMT, PPMT, IPMT etc.) Ex 0801 Loan Calculation (PMT, PPMT, IPMT etc.) 0802 Creating a Loan Table Ex 0802 Creating a Loan Table 0803 Calculate Depriciation Ex 0803 Calculate Depriciation Sort & Filter 0901 Basic Sorting & Shortcut keys Ex 0901 Basic Sorting & Shortcut keys 0902 Sorting Using Custom List Ex 0902 Sorting Using Custom List 0903 Horizontal Sorting Ex 0903 Horizontal Sorting 0904 Basic Filter & Shortcut Keys Ex 0904 Basic Filter & Shortcut Keys 0905 Filter Problem # 1 (Copy Filtered Data without hidden rows) Ex 0905 Filter Problem # 1 (Copy Filtered Data without hidden rows) 0906 Filter Problem # 2 (Pasting Values on Filtered Data) Ex 0906 Filter Problem # 2 (Pasting Values on Filtered Data) 0907 Filter Problem # 3 (Performing Calculation on Filtered Data) Ex 0907 Filter Problem # 3 (Performing Calculation on Filtered Data) 0908 Advanced Filter (Applying Complex Criteria's) Ex 0908 Advanced Filter (Applying Complex Criteria's) Microsoft Excel: Advanced Level Excel Charts - Visual Presentation 1001 How to create a chart 1002 Format Axis 1003 Plot Values on Secondary Axis 1004 Life of Pie (Charts) 1005 How to Show Axis Title 1006 How to Show Data Label 1007 Show data with chart in Data Table 1008 Column Chart 1009 Bar Chart 1010 Line Chart 1 1011 Line Chart 2 1012 Area Chart 1013 Pie Chart 1014 Pie of Pie or Bar of Pie 1015 Line Chart with Log Scale 1016 Bubble Chart 1017 Selecting Chart Elements 1018 Use of Format Dialog box 1019 Modifying Chart & Plot Area 1020 Modifying Data Series 1021 How to handle Missing Data 1022 Modifying 3-D Charts 1023 Creating Combination of upto 5 Different Charts 1025 Creating Picture Charts Data Consolidation - Multiple WorkBooks WorkSheets Consolidate Data using Excel Inbuilt Function Ex Consolidate Data using Excel Inbuilt Function Data Validation 1201 Applying Data Validation Ex 1201 Applying Data Validation 1202 Dependent Dropdown List Ex1202 Dependent Dropdown List Using Data Validation with Vlookup & Match Other Data Validation Examples Protection of Worksheet Workbook 1301 Worksheet Level Protection Ex 1301 Worksheet Level Protection 1302 Cell Level Protection Ex 1302 Cell Level Protection 1303 Hiding Formulas from Formula Bar Ex 1303 Hiding Formulas from Formula Bar 1304 Protecting Workbook Structure Ex 1304 Protecting Workbook Structure 1305 Workbook Level Protection Ex 1305 Workbook Level Protection Pivot Table & Techniques 1401 Understanding pivot Table 1402 Using Pivot Table in Real Scenario Ex 1402 Using Pivot Table in Real Scenario 1403 Grouping in Pivot Table Ex 1403 Grouping in Pivot Table 1404 Using Slicers (A Visually attractive Filter) Ex 1404 Using Slicers (A Visually attractive Filter) What-If Analysis & Solver Add-In 1501 Goal Seek (A Reverse Approach) Ex 1501 Goal Seek (A Reverse Approach) 1502 One Way Data Table 1503 Two Way Data Table 1504 Scenario Manager 1505 Solver Add-In Automation in Excel - Macros 1601 Record your first Macro 1602 Record Another Macro 1603 Assigning macro to a Shape, Button, Picture etc 1604 Editing or Deleting a Macro 1605 Security Settings of a Macro Who should take this course? Absolute beginners to Microsoft Excel People who wish to use Microsoft Excel more confidently People who wish to refresh their existing skills in Microsoft Excel Entry Requirements There are no academic entry requirements for this Microsoft Excel training course basic to advanced course, and it is open to students of all academic backgrounds. However, you are required to have a laptop/desktop/tablet or smartphone and a good internet connection. Assessment Method This Microsoft Excel training course basic to advanced course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner can grasp from each section. In the assessment pass mark is 60%. Certification Endorsed Certificate from Quality Licence Scheme After successfully passing the MCQ exam you will be eligible to order the Endorsed Certificate by Quality Licence Scheme. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is £65. Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35. FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org

Description The Implementing Cisco IP Routing is a qualifying exam for the Cisco Certified Network Professional CCNP, Cisco Certified Internetwork Professional CCIP, and Cisco Certified Design Professional CCDP certifications. This Cisco CCNP Implementing Cisco IP Routing (Route) v2.0 Training will help you to be certified Successfully with all the important knowledge and skills necessary to use advanced IP addressing and routing in implementing scalable and secure Cisco ISR routers connected to LANs and WANs. The exam also covers configuration of secure routing solutions to support branch offices and mobile workers. This is an advanced course on Cisco routing configuration for both IPv4 and IPv6. In this course, you will gain the knowledge to configure and optimize a routing domain using OSPF, EIGRP, BGP, PBR, IP SLA and configure redistribution when needed. It also includes the configuration of highly secure routing solutions to support branch offices and mobile workers. Assessment & Certification To achieve a formal qualification, you are required to book an official exam separately with the relevant awarding bodies. However, you will be able to order a course completion CPD Certificate by paying an additional fee. Hardcopy Certificate by post - £19 Soft copy PDF via email - £10 Requirements Our Cisco CCNP Implementing Cisco IP Routing (Route) v2.0 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. Routing Services Complex Enterprise Network Frameworks, Architectures, and Models FREE 00:15:00 Creating, Documenting, and Executing an Implementation Plan 00:09:00 Overview of IP Routing 00:12:00 RIPNG 00:26:00 Configuring the Enhanced Interior Gateway Routing Protocol Understanding EIGRP Terminology and Operation 00:14:00 Planning EIGRP Routing Implementations 00:03:00 Configuring and Verifying EIGRP 00:03:00 Enable EIGRP Routing 00:01:00 Define EIGRP Networks 00:03:00 Define Bandwidth on Interfaces 00:01:00 Enable and Disable EIGRP Automatic Summarization 00:01:00 Passive Interface 00:02:00 IP Default Network 00:03:00 Configure a Router to Advertise a Default Route as the Gateway 00:02:00 Example of the IP Route Next Hop Command 00:01:00 Example of the IP Route Quad Zero Command 00:01:00 Summarization in Discontiguous Networks 00:01:00 Configuring and Verifying EIGRP in an Enterprise WAN 00:03:00 Disabling Automatic Summarization 00:01:00 Frame Relay Using Dynamic Mapping 00:03:00 EIGRP over Layer 3 MPLS VPNs 00:02:00 EIGRP over Layer 2 MPLS VPNs 00:04:00 Configuring and Verifying EIGRP Authentication 00:04:00 Configure Authentication Mode for EIGRP 00:02:00 Configure the Key Chain 00:01:00 Optimizing EIGRP Implementations 00:05:00 Enable Authentication to use the Key Chain 00:01:00 EIGRP 00:21:00 Configuring the Open Shortest Path First Protocol Understanding OSPF Terminology and Operation 00:20:00 OSPF Packets 00:11:00 Planning OSPF Routing Implementations 00:06:00 Basic OSPF Verification and Configuration 00:09:00 Configuring Single Area OSPF 00:02:00 Configuring Multi Area OSPF 00:01:00 EIGRP over Layer 3 MPLS VPNs 00:02:00 OSPF Network Types 00:11:00 Assigning Router Priority 00:02:00 Override the Default Interface Cost 00:01:00 Configure a Key for Simple Authentication 00:01:00 Configure the MD5 Key-ID and Key 00:02:00 Verifying Simple Password Authentication 00:01:00 OSPF 00:19:00 Manipulating Routing Updates Assessing Network Routing Performance Issues 00:05:00 Using Multiple Routing Protocols on a Network 00:09:00 Redistribution Supports All Routing Protocols 00:01:00 Implementing Route Redistribution 00:07:00 Redistribute Routes into RIP 00:03:00 Redistribute Routes into OSPF 00:04:00 Default Metric for Routing Protocols 00:02:00 Redistributing Routes into EIGRP 00:05:00 Applying Metric Values for EIGRP 00:03:00 Modifying the Administrative Distance for all Routing Protocols 00:06:00 Changing OSPF AD 00:15:00 Controlling Routing Update Traffic 00:11:00 Route Map 00:10:00 Using Distribute Lists and Filter Incoming Routing Updates 00:03:00 Defining a Filter for Outgoing Routing Commands 00:02:00 Distribute List In or Out and Examples 00:06:00 Distribute Lists to Avoid Route Feedback 00:05:00 Fallbacks of Distribute Lists 00:01:00 Using Prefix Lists 00:02:00 Implementing Path Control Understanding Path Control 00:05:00 Similarities of ACLs and Prefix Lists 00:01:00 Implementing Path Control using Offset-Lists 00:02:00 Configuring a Prefix List 00:04:00 Implementing Path Control Using Offset-Lists 00:03:00 Verify Offset-Lists 00:01:00 Implementing Path Control using IOS IP SLAs 00:10:00 Cisco IOS IP SLAs 00:01:00 IP SLAs Applications 00:01:00 Operations - Responders and Sources 00:01:00 IP SLAs Operations 00:01:00 Steps to Deploying IP SLAs 00:01:00 IP SLA - ICMP ECHO and ICMP ECHO Sub Commands 00:04:00 IP SLA Schedules 00:05:00 Define Tracking Objects to Track the State of IP SLAs Operations 00:02:00 Configuring Track Delay 00:01:00 Configure a Static Route for IP SLAs Tracking 00:03:00 Verify IP SLAs using Method 1 00:02:00 Verify IP SLAs using Method 2 00:02:00 Implement Path Control using Policy-Based Routing 00:09:00 Implement Path Control using Policy-Based Routing 00:01:00 Configure PBR 00:01:00 Logical PBR Operation 00:01:00 Route-Map Commands for PBR 00:03:00 Match Statements and Conditions 00:03:00 Match Commands Used in PBR 00:01:00 Specify Criteria to be Matched using Prefix Lists of ACLs 00:01:00 Specify Criteria to be Matched by Packet Length 00:01:00 Modify Matching Conditions using Set Statements 00:01:00 Set Conditions 00:03:00 Set Commands used in PBR 00:02:00 Specify the Next Hop IP Address for Matching Packets 00:01:00 Specify Interfaces Through which Packets Can be Routed 00:01:00 Specify a List of Default Next-Hop IP Addresses 00:02:00 Specify a List of Default Interfaces 00:02:00 Mark Packets Using the IP ToS Field 00:02:00 Set the 3 IP Precedence Bits in the IP Packet Header 00:01:00 Set IP Precedence Parameters 00:02:00 Identify a Route Map to Use for Policy Routing on an Interface 00:01:00 Various Methods to Verify PBR 00:02:00 Advanced Path Control Tools 00:02:00 Implementing a Border Gateway Protocol Solution for ISP Connectivity BGP Terminology, Concepts, and Operation 00:20:00 EGP and IGP 00:01:00 AS 00:02:00 IANA 00:01:00 RIRs 00:02:00 AS Numbers 00:03:00 Facts about BGP 00:03:00 BGP Neighbors 00:03:00 BGP Operational Overview 00:02:00 BGP Use between ASs 00:01:00 BGP and IGPs 00:01:00 Connecting Enterprise Networks to Internet Service Providers 00:02:00 Configuring BGP 00:12:00 Questions for Deploying Routing and Connection 00:02:00 Public IP Address Space 00:02:00 Configure Static Routes 00:02:00 Configure the Default Local Preference 00:01:00 Define BGP as the IP Routing Protocol 00:03:00 Router BGP Command Parameters 00:01:00 Identify Peer Router to Establish a BGP Session 00:02:00 Create a Peer Group 00:02:00 Assign Neighbors as Part of the Peer Group 00:02:00 Disable an Existing BGP Neighbor or Peer Group Relationship 00:02:00 Establish the IBGP Session Using a Loopback Interface 00:02:00 IBGP Source IP 00:03:00 Increase the TTL for EBGP Connections 00:03:00 Configure the Router as the Next Hop for a BGP Speaking Peer 00:02:00 Verifying and Troubleshooting BGP 00:01:00 Basic BGP Path Manipulation Using Route Maps 00:05:00 Filtering BGP Routing Updates 00:02:00 Implementing Routing Facilities for Branch Offices and Mobile Workers Planning the Branch Office Implementations 00:15:00 NAT 00:09:00 Planning for Mobile Worker Implementations 00:03:00 Routing Traffic to the Mobile Worker 00:02:00 Implementing IPv6 in the Enterprise Network Introducing IPv6 00:07:00 Configuring and Verifying IPv6 Unicast Addresses 00:06:00 Routing IPv6 Traffic 00:01:00 Configuring Static Routing 00:04:00 Configuring OSPFv3 00:07:00 OSPFv3 00:22:00 Configuring EIGRP for IPv6 00:03:00 EIGRP for IPv6 00:18:00 Multiprotocol BGP (MP-BGP) 00:03:00 Mock Exam Mock Exam- Cisco CCNP Implementing Cisco IP Routing (Route) v2.0 Training 00:20:00 Final Exam Final Exam- Cisco CCNP Implementing Cisco IP Routing (Route) v2.0 Training 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Course Overview Build your confidence in maths and gain the skills you need to pass your maths exam with flying colours, in this complete Mathematics Masterclass.  This mathematics course is ideal for those who already have a basic understanding of everyday maths and want to learn more complex skills. Through this training, you will explore key topics such as trigonometry, linear programming, and algebra, learning how to apply them in a practical way. By the end of this course, you will have excellent problem-solving, logical and linear thinking skills, with the confidence to master any complex mathematical problem. You will also have an excellent grasp of matrix multiplication and addition. This best selling Mathematics Masterclass has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Mathematics Masterclass is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Mathematics Masterclass is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Mathematics Masterclass is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Mathematics Masterclass, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Mathematics Masterclass will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Mathematics Masterclass to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

Description: This course follows up from the Beginners Excel 2010 course by delving even deeper into features and functions of this powerful spreadsheet software. This Microsoft Office 2010 Excel Advanced - Complete Video Course builds on the skills and concepts taught in Excel 2010: intermediate. In this series you will learn to work with advanced formulas, as well lookup functions such as VLOOKUP, MATCH, and INDEX. In addition, you will learn about data validation and database functions such as DSUM. You will learn how to work with Pivot Tables and PivotCharts, how to import and export data, and how to query external databases. Finally, you will learn about the analytical features of Excel, running and recording macros, SmartArt graphics and conditional formatting with graphics, and more. Before you taking this course you should have a firm grasp of the basics. This course will pull up your basic knowledge. So join this course to be an expert. 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? Microsoft Office 2010 Excel Advanced - Complete Video Course 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 Microsoft Office 2010 Excel Advanced - Complete Video Course 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. Logical and Statistical Functions Logical Functions FREE 00:17:00 Math and Statistical Functions 00:19:00 Financial and Date Functions Financial Functions 00:04:00 Date and Time Functions 00:10:00 Array Formulas 00:09:00 Displaying and Printing Formulas 00:08:00 Lookups and Data Tables Using Lookup Functions 00:14:00 Using MATCH and INDEX 00:06:00 Array Formulas 00:07:00 Advanced Data Management Validating Cell Entries 00:08:00 Exploring Database Functions 00:06:00 Exporting and Importing Exporting and Importing Text Files 00:11:00 Exporting and Importing XML Data 00:03:00 Querying External Databases 2 hours agoMore 00:09:00 Analytical Tools Goal Seek and Solver 00:15:00 The Analysis ToolPak 00:05:00 Scenarios 1 hour agoMore 00:06:00 Macros and Custom Functions Running and Recording a Macro 00:19:00 Working with VBA Code 00:07:00 Creating Functions 00:05:00 Mock Exam Mock Exam- Microsoft Office 2010 Excel Advanced - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2010 Excel Advanced - Complete Video Course 00:20:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

Description: This Microsoft Office 2007 Excel Advanced - Complete Video Course builds on knowledge gained in the Introduction and Intermediate courses. In Advanced Microsoft Office Excel 2007, you will explore the many data analysis tools available in Excel, such as formula auditing, goal seek, Scenario Manager and subtotals. Additionally, during this course you will use advanced functions, learn how to apply conditional formatting, filter and manage your data lists, create and manipulate PivotTables and PivotCharts and record basic macros. You will also learn to use key advanced financial, logical, text, statistical and math, and lookup functions, audit formulas for errors, analyze data using subtotals, goal seek and the scenario manager, use custom and conditional formatting, manage data with tables, filtering and sorting, create, edit and format PivotTables and PivotCharts, import and export date to and from a workbook, create and use macros. So, by taking this course you will have a complete understanding of the higher functions of Excel. 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? Microsoft Office 2007 Excel Advanced - Complete Video Course 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 Microsoft Office 2007 Excel Advanced - Complete Video Course 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. Advanced Functions Logical Functions FREE 00:08:00 Math and Statistical Functions 00:06:00 Financial Functions 00:03:00 Displaying and Printing Formulas 00:02:00 Lookups and Data Tables Using Lookup Functions 00:03:00 Using MATCH and INDEX 00:01:00 Creating Data Tables 00:03:00 Advanced List Management Validating Cell Entries 00:01:00 Exploring Database Functions 00:01:00 PivotTables and PivotCharts Working with PivotTables 00:04:00 Rearranging PivotTables 00:02:00 Formatting PivotTables 00:02:00 PivotCharts 00:01:00 Exporting and Importing Exporting and Importing Text Files 00:07:00 Exporting and Importing XML Data 00:02:00 Querying External Databases 00:03:00 Analytical Options Goal Seek and Solver 00:05:00 The Analysis ToolPak 00:01:00 Scenarios 00:02:00 Views 00:01:00 Macros and Custom Functions Running and Recording a Macro 00:02:00 Working with VBA Code 00:01:00 Creating Functions 00:05:00 Conditional Formatting and SmartArt Conditional Formatting with Graphics 00:03:00 SmartArt Graphics 00:02:00 Mock Exam Mock Exam- Microsoft Office 2007 Excel Advanced - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2007 Excel Advanced - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

This Microsoft Power BI course will help you become a Power BI expert. It'll enhance your skills by offering you comprehensive knowledge on Power BI Desktop and Power BI Online, and unleash the capabilities of Power BI to perform a comprehensive analysis of data from multiple sources and present the data using the perfect visualization.

Master React and Redux with our comprehensive App Development Training course. Learn to build dynamic web applications, manage state, and integrate with backend services like Firebase. Ideal for aspiring UI/UX developers and frontend developers. Enroll now to start your journey in app development!

Technical Writing Online Course Overview Welcome to the Technical Writing Online Course, your comprehensive guide to mastering the art and science of effective technical communication. Whether you're a seasoned professional looking to enhance your skills or a newcomer to the field seeking a solid foundation, this course is designed to meet your needs. Module 1: Introduction to Technical Writing In Module 1, we lay the groundwork for your journey into the world of technical writing. You'll learn about the fundamental principles of technical communication, understanding its purpose, audience, and context. We'll explore the importance of clarity, conciseness, and accuracy in technical writing, setting the stage for your success in subsequent modules. Module 2: Writing for Different Audiences Effective communication hinges on understanding and adapting to your audience. Module 2 delves into the nuances of tailoring your writing to different readerships, whether they are technical experts, laypersons, or stakeholders with varying levels of expertise. You'll master strategies for conveying complex information in a clear and accessible manner, ensuring your message resonates with your target audience. Module 3: Researching and Gathering Information Technical writing is grounded in robust research and accurate data. Module 3 equips you with the skills to conduct thorough research, gather relevant information, and discern credible sources. From leveraging online databases to conducting interviews and surveys, you'll learn how to gather the data necessary to support your technical documents effectively. Module 4: Planning and Organizing Technical Documents Organizing technical content is crucial for facilitating comprehension and usability. Module 4 guides you through the process of structuring your documents for maximum clarity and coherence. You'll explore various organizational frameworks, such as hierarchical structures, chronological sequences, and logical flowcharts, to effectively present your information and guide your readers through complex technical material. Module 5: Writing Effective Technical Documents In the final module, we bring together everything you've learned to craft polished and impactful technical documents. From technical reports and manuals to user guides and specifications, you'll learn the principles of writing with precision, coherence, and persuasiveness. Through practical exercises and real-world examples, you'll hone your writing skills and gain the confidence to produce professional-grade technical documents. Throughout the course, you'll benefit from a blend of instructional materials, interactive exercises, and feedback from industry experts. By the end of the Technical Writing Online Course, you'll emerge equipped with the knowledge, skills, and confidence to excel in the dynamic field of technical communication. Course Curriculum Module 1_ Introduction to Technical Writing. Introduction to Technical Writing. 00:00 Module 2_ Writing for Different Audiences. Writing for Different Audiences. 00:00 Module 3_ Researching and Gathering Information. Researching and Gathering Information. 00:00 Module 4_ Planning and Organizing Technical Documents. Planning and Organizing Technical Documents. 00:00 Module 5_ Writing Effective Technical Documents. Writing Effective Technical Documents. 00:00

📄 Report Writing Training Course Overview: Transform Your Reports into Masterpieces Ready to take your report writing skills to the next level? Our comprehensive 'Report Writing Training' course is your key to crafting impactful and professional reports. From the fundamentals to advanced editing techniques, this course is designed to empower you with the skills needed to communicate information effectively through written reports. 📝 Module 1: Introduction to Report Writing Embark on your journey with a foundational understanding of the principles of effective report writing. Explore the purpose, significance, and various types of reports. Gain insights into tailoring your reports to different audiences and purposes, setting the stage for mastery in report creation. 🗂️ Module 2: Planning and Structuring a Report Learn the art of strategic planning and structuring for impactful reports. Discover how to outline your content, establish clear objectives, and create a logical flow of information. Master the skills to develop a well-organized structure that captivates your audience and enhances comprehension. 📊 Module 3: Collecting and Analyzing Data Delve into the core of report creation by understanding the importance of data collection and analysis. Learn effective methods for gathering relevant information, evaluating data accuracy, and drawing meaningful conclusions. Develop the skills to present data in a compelling and insightful manner. 📄 Module 4: Writing the Report Unlock the secrets to creating clear, concise, and compelling reports. Explore writing techniques that enhance readability, convey complex ideas, and maintain the interest of your audience. Master the art of using language effectively to convey your message with precision and impact. ️ Module 5: Editing and Proofreading Polish your reports to perfection with advanced editing and proofreading techniques. Learn how to review your work critically, identify errors, and refine your writing for clarity and coherence. Develop an eye for detail to ensure your reports meet the highest standards of professionalism. 🌐 Why Choose Our Report Writing Training Course? Practical Application: Hands-on exercises and real-world scenarios for practical skill development. Expert Guidance: Learn from seasoned writers and editors with extensive experience. Interactive Learning: Engage in activities designed to enhance your report writing dynamically. Career Advancement: Open doors to diverse opportunities where effective written communication is essential. 📈 Enroll Now and Transform Your Report Writing Skills! Don't miss the opportunity to become a skilled and influential report writer. Our Report Writing Training course is your gateway to mastering the art of effective written communication. Enroll now and unlock the keys to creating reports that stand out and make a lasting impact! Course Curriculum Module 1_ Introduction to Report Writing. Introduction to Report Writing. 00:00 Module 2_ Planning and Structuring a Report. Planning and Structuring a Report. 00:00 Module 3_ Collecting and Analyzing Data. Collecting and Analyzing Data. 00:00 Module 4_ Writing the Report. Writing the Report. 00:00 Module 5_ Editing and Proofreading. Editing and Proofreading. 00:00