347 Computing Skills courses

Overview This comprehensive course on Ultimate PHP & MySQL Web Development Course & OOP Coding will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Ultimate PHP & MySQL Web Development Course & OOP Coding comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Ultimate PHP & MySQL Web Development Course & OOP Coding. It is available to all students, of all academic backgrounds. Requirements Our Ultimate PHP & MySQL Web Development Course & OOP Coding is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 15 sections • 133 lectures • 10:06:00 total length •Introduction: 00:02:00 •Setup On Windows: 00:15:00 •Setup On Mac: 00:11:00 •Setup On Linux: 00:12:00 •Online Code Editor: 00:03:00 •Basic File Syntax: 00:05:00 •Printing (echo): 00:06:00 •Comments: 00:05:00 •Variables: 00:06:00 •Variable Data Types: 00:07:00 •Variable Naming: 00:03:00 •Constants: 00:02:00 •Arrays: 00:05:00 •Associative Arrays: 00:06:00 •Multidimensional Arrays: 00:04:00 •if Statement: 00:06:00 •ifelse Statement: 00:02:00 •ifelseifelse Statement: 00:05:00 •Switch Statement: 00:06:00 •while Loop: 00:06:00 •doWhile Loop: 00:03:00 •for Loop: 00:03:00 •foreach Loop: 00:05:00 •Break Statement: 00:02:00 •Continue Statement: 00:02:00 •Basic Function: 00:03:00 •Passing Function Arguments: 00:03:00 •Passing Function Arguments By Reference: 00:04:00 •Default Argument Value: 00:02:00 •Function Returning Values: 00:05:00 •Dynamic Function Calls: 00:03:00 •Variable Scope: 00:04:00 •Simple HTML Form: 00:07:00 •GET vs POST: 00:05:00 •$_SERVER ['PHP_SELF']: 00:07:00 •Validating Form Data With PHP: 00:07:00 •Required Fields: 00:05:00 •Display Error Messages: 00:05:00 •Validate Name: 00:03:00 •Validate Email: 00:03:00 •Validate URL: 00:07:00 •Keep The Values In The Form: 00:04:00 •Read File (readfile()): 00:02:00 •Open, Read & Close A File (fopen(), fread(), fclose()): 00:04:00 •Read Single Line (fgets()): 00:03:00 •Check End-Of-File (feof()): 00:02:00 •Read Single Character (fgetc()): 00:02:00 •Write To File (fwrite()): 00:03:00 •Configure php.ini File For File Uploading: 00:02:00 •Front End HTML Upload Form: 00:04:00 •PHP Upload Script: 00:15:00 •Check If File Exists: 00:03:00 •Limit File Size: 00:05:00 •Limit File Type: 00:04:00 •MySQL vs MySQLi vs PDO: 00:05:00 •Creating A Database & Table (phpMyAdmin): 00:06:00 •Connecting To A Database: 00:06:00 •Get Data Using SELECT Query: 00:10:00 •WHERE Property For Filtering: 00:03:00 •LIKE Property For Pattern Search: 00:02:00 •Sorting Results Using ORDER BY Property: 00:01:00 •Using JOINS: 00:08:00 •Insert Data Using INSERT Query: 00:04:00 •Get ID Of The Last Inserted Row: 00:02:00 •Insert Multiple Rows: 00:05:00 •Update Data Using UPDATE Query: 00:03:00 •Delete Data Using DELETE Query: 00:02:00 •Delete All Rows In A Table Using TRUNCATE Query: 00:02:00 •Delete Table Using DROP Query: 00:02:00 •Limit Data Selections Using LIMIT, ROWNUM: 00:04:00 •Create Table Using CREATE Query: 00:03:00 •Clone/Duplicate Table: 00:03:00 •Alter Table: 00:05:00 •Create Database: 00:02:00 •Drop Database: 00:02:00 •SQL Injection & Prepared Statements: 00:09:00 •What Is XML?: 00:02:00 •What Is SimpleXML?: 00:02:00 •Parse XML String: 00:08:00 •Parse XML File: 00:02:00 •Get Node Values: 00:02:00 •Get Node Values of Specific Elements: 00:03:00 •Get Node Values - Loop: 00:03:00 •Get Attribute Values: 00:02:00 •What Is The XML Expat Parser?: 00:02:00 •Initializing The XML Expat Parser: 00:10:00 •Load and Output XML Using DOM Parser: 00:02:00 •Looping Through XML Using DOM Parser: 00:03:00 •What Is AJAX?: 00:02:00 •Load Simple Data Using AJAX Front End: 00:08:00 •Load Simple Data Using AJAX Back End: 00:05:00 •Load Data From A Database Using AJAX: 00:08:00 •Send A Plain Text Email: 00:04:00 •Send A HTML Email: 00:06:00 •Email Attachments: 00:17:00 •PHPMailer Setup: 00:03:00 •Send Email Using PHPMailer: 00:04:00 •Send HTML Email Using PHPMailer: 00:04:00 •Email Attachments Using PHPMailer: 00:02:00 •What Is Object Oriented Programming (OOP)?: 00:03:00 •Basic Class With Variables: 00:04:00 •Functions: 00:05:00 •Constructor: 00:04:00 •Destructor: 00:02:00 •Inheritance: 00:06:00 •Multi Class Inheritance: 00:03:00 •Function Overriding: 00:03:00 •Public vs Private vs Protected: 00:05:00 •Interfaces: 00:04:00 •Constants: 00:03:00 •Abstract Class: 00:06:00 •Static Keyword: 00:03:00 •Final Keyword: 00:02:00 •Initiating Parent Constructor: 00:02:00 •die() Function: 00:02:00 •Custom Error Handler: 00:04:00 •Triggering An Exception: 00:03:00 •Exception Handling: 00:05:00 •Create Database & Table: 00:04:00 •User Class & Database Connection: 00:15:00 •Register User Form: 00:09:00 •Inserting User Data Into Database: 00:10:00 •Registration Form Field Validation: 00:12:00 •Securing User Password: 00:03:00 •Check If Username or Email Already Exists: 00:11:00 •Retain Data After Failed Registration: 00:03:00 •Validate an Integer Within a Range: 00:04:00 •Validate IPv6 Address: 00:03:00 •Validate URL - Must Contain QueryString: 00:03:00 •Remove Characters With ASCII Value > 127: 00:04:00 •Including & Requiring External PHP Files: 00:05:00 •Resource: 00:00:00 •Assignment - Ultimate PHP & MySQL Web Development Course & OOP Coding: 00:00:00

Overview This comprehensive course on C++ Development: The Complete Coding Guide will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This C++ Development: The Complete Coding Guide comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this C++ Development: The Complete Coding Guide. It is available to all students, of all academic backgrounds. Requirements Our C++ Development: The Complete Coding Guide is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 14 sections • 79 lectures • 05:35:00 total length •Introduction: 00:04:00 •What Is C++?: 00:03:00 •Setting up A Project: 00:07:00 •Console Out: 00:04:00 •Data Types: 00:03:00 •Variables: 00:04:00 •Console In: 00:03:00 •Strings: 00:04:00 •Constants: 00:05:00 •Assignment Operator: 00:03:00 •Arithmetic Operators: 00:04:00 •Compound Assignment Operator: 00:03:00 •Increment & Decrement Operators: 00:04:00 •Relation & Comparison Operators: 00:06:00 •Logical Operators: 00:07:00 •Conditional Ternary Operator: 00:04:00 •Comma Operator: 00:03:00 •Type Casting Operator: 00:02:00 •Bitwise Operators: 00:12:00 •Size of Operator: 00:03:00 •Operator Precedence: 00:05:00 •String Streams: 00:04:00 •Conditional Statements: 00:07:00 •For Loop: 00:04:00 •While Loop: 00:03:00 •Do While Loop: 00:04:00 •Range-Based For Loop: 00:03:00 •GoTo Statement: 00:04:00 •Switch Statement: 00:05:00 •Switch Statement: 00:05:00 •Functions: 00:03:00 •Function Return Statement: 00:04:00 •Function Arguments Passed By Value: 00:05:00 •Function Arguments Passed By Reference: 00:05:00 •Function Parameter Default Values: 00:03:00 •Overloaded Functions: 00:04:00 •Function Templates: 00:04:00 •Namespaces: 00:06:00 •Arrays: 00:03:00 •Multidimensional Arrays: 00:03:00 •References: 00:02:00 •Pointers: 00:04:00 •Delete Operator: 00:02:00 •Struct: 00:04:00 •Type Aliasing: 00:03:00 •Unions: 00:04:00 •Enumerators: 00:04:00 •Introduction to Classes: 00:05:00 •Class Access: 00:04:00 •Class Constructor: 00:05:00 •Class Pointers: 00:04:00 •Overloading Operators: 00:06:00 •This Keyword: 00:04:00 •Constant Objects: 00:03:00 •Getters and Setters: 00:05:00 •Static Variables: 00:04:00 •Static Functions: 00:06:00 •Template Classes: 00:05:00 •Class Destructor: 00:04:00 •Class Copy Constructor: 00:03:00 •Friend Function: 00:06:00 •Friend Class: 00:06:00 •Class Inheritance: 00:07:00 •Multiple Class Inheritance: 00:05:00 •Virtual Methods: 00:04:00 •Abstract Base Class: 00:03:00 •Error Handling: 00:04:00 •Preprocessor Macro Definitions: 00:04:00 •Preprocessor Conditional Directives: 00:05:00 •Preprocessor Line Directive: 00:04:00 •Preprocessor Source File Inclusion: 00:02:00 •Opening A File: 00:06:00 •Writing to a File: 00:04:00 •Commenting: 00:04:00 •Class Header and Implementation: 00:09:00 •Lists: 00:04:00 •Vectors: 00:05:00 •Resource: 00:00:00 •Assignment - C++ Development: The Complete Coding Guide: 00:00:00

Overview This comprehensive course on Computer Science With Python will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Computer Science With Python comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Computer Science With Python. It is available to all students, of all academic backgrounds. Requirements Our Computer Science With Python is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 5 sections • 152 lectures • 04:54:00 total length •Introduction: 00:03:00 •Quiz 1: 00:02:00 •Quiz 1 Solution: 00:01:00 •What is Programming: 00:03:00 •Quiz 2: 00:01:00 •Quiz 2 Solution: 00:01:00 •Meeting the interpreter and Problem Quiz 3: 00:01:00 •Quiz 3 solution: 00:01:00 •Congratulations: 00:01:00 •Why programming and Quiz 4: 00:02:00 •Quiz 4 Solution: 00:03:00 •Grammar and Python Rules: 00:04:00 •Backus Naur Form: 00:03:00 •Quiz 4 part 2: 00:01:00 •Quiz 4 part 2 Solution: 00:01:00 •Python Grammar and Quiz 5: 00:05:00 •Quiz 5 Solution: 00:03:00 •Quiz 6: 00:01:00 •Quiz 6 Solution: 00:02:00 •Processors: 00:02:00 •Introducing Variables: 00:05:00 •Variables Quiz 7: 00:02:00 •Variables Can Vary: 00:03:00 •Variables Quiz 8: 00:01:00 •Quiz 8 Solution: 00:01:00 •Variables Quiz 9: 00:01:00 •Quiz 9 Solution: 00:01:00 •Variables Quiz 10: 00:01:00 •Quiz 10 Solution: 00:03:00 •Introducing Strings: 00:04:00 •Using Strings Quiz 11: 00:01:00 •Quiz 11 Solution: 00:03:00 •Strings and Numbers - String Concatenation Quiz Solution: 00:03:00 •String indexing: 00:02:00 •Quiz 13: 00:01:00 •Quiz 13 Solution: 00:03:00 •String subsequences: 00:04:00 •String subsequences quiz 14: 00:01:00 •Quiz 14 solution: 00:02:00 •Understanding selection quiz 15: 00:01:00 •Quiz 15 solution: 00:04:00 •Finding string in string quiz 16: 00:04:00 •Quiz 16 solution: 00:02:00 •Testing and quiz 17: 00:02:00 •Quiz 17 solution: 00:03:00 •Find With Parameter Quiz 18: 00:02:00 •Quiz 18 solution: 00:01:00 •Extracting links from a web page Quiz 19: 00:03:00 •Extracting links from a web page Quiz 19 Solution: 00:02:00 •Final Quiz: 00:01:00 •Final Quiz Solution: 00:02:00 •Congratulations: 00:01:00 •Unit Overview: 00:03:00 •Procedural Abstraction: 00:03:00 •Introducing Procedures: 00:04:00 •Procedure code quiz 1: 00:04:00 •Quiz 1 Solution: 00:01:00 •Output and quiz 2: 00:01:00 •Quiz 2 Solution: 00:02:00 •Return Statement and Quiz 3: 00:03:00 •Quiz 3 solution: 00:02:00 •Inc Procedure Quiz 4: 00:01:00 •Quiz 4 Solution: 00:01:00 •Sum Procedure and Quiz 5: 00:01:00 •Quiz 5 Solution: 00:02:00 •Sum procedure with a return statement: 00:02:00 •Square procedure quiz 6: 00:01:00 •Quiz 6 Solution: 00:02:00 •Sum 3 Quiz 7: 00:01:00 •Quiz 7 Solution: 00:02:00 •Double string procedure quiz 8: 00:01:00 •Quiz 8 Solution: 00:01:00 •Find second quiz 9: 00:02:00 •Quiz 9 Solution: 00:02:00 •Equality Comparison Quiz 10: 00:04:00 •Quiz 10 Solution: 00:01:00 •If statement quiz 11: 00:03:00 •Quiz 11 Solution: 00:03:00 •Is friend quiz 12: 00:02:00 •Quiz 12 solution: 00:02:00 •Is friend quiz 13: 00:02:00 •Quiz 13 Solution: 00:02:00 •The Or construct: 00:03:00 •Quiz 14 solution: 00:06:00 •While loop quiz 15: 00:05:00 •Quiz 15 solution: 00:03:00 •While loop quiz 16: 00:01:00 •Quiz 16 solution: 00:02:00 •Print numbers quiz 17: 00:01:00 •Quiz 17 solution: 00:02:00 •Factorial quiz 18: 00:02:00 •Quiz 18 solution: 00:02:00 •Break quiz 19: 00:04:00 •Quiz 19 solution: 00:03:00 •Quiz 20: 00:05:00 •Quiz 20 Solution: 00:01:00 •No links quiz 21: 00:01:00 •Print all links quiz 21 solution: 00:03:00 •Final Quiz: 00:01:00 •Final Quiz Solution: 00:02:00 •Unit Overview: 00:03:00 •Stooges and quiz 1: 00:01:00 •Quiz 1 Solution: 00:01:00 •Countries quiz: 00:01:00 •Quiz 3 solution: 00:01:00 •Relative Size Quiz: 00:01:00 •Quiz 4 Solution: 00:01:00 •Lists Mutation: 00:01:00 •Different Stooges quiz: 00:01:00 •Quiz 5 Solution: 00:01:00 •Secret Agent Man Quiz: 00:01:00 •Replace Spy Quiz: 00:01:00 •Quiz 7 Solution: 00:03:00 •Python List Addition and Length: 00:02:00 •List Operations In Python: 00:02:00 •Python lists length quiz: 00:01:00 •Quiz 8 Solution: 00:01:00 •Append Quiz: 00:01:00 •Hard drive quiz: 00:01:00 •Quiz 11 Solution: 00:01:00 •Python Loops on Lists Quiz: 00:02:00 •Quiz 12 solution: 00:02:00 •Python For loops: 00:03:00 •Sum List Quiz: 00:01:00 •Measure a String Quiz: 00:01:00 •Find Element Quiz: 00:02:00 •Quiz 15 solution: 00:04:00 •Quiz 16 solution: 00:01:00 •Python Union Procedure Quiz: 00:01:00 •Quiz 17 solution: 00:01:00 •Pop in Python Quiz 18: 00:02:00 •Quiz 18 solution: 00:03:00 •Collecting Links: 00:01:00 •Get All Links: 00:02:00 •Starting Get All Links Quiz: 00:01:00 •Quiz 19 solution: 00:01:00 •Updating Links Quiz: 00:01:00 •Quiz 20 Solution: 00:01:00 •Finishing Get All Links Quiz: 00:01:00 •Quiz 21 Solution: 00:01:00 •Finishing the Python Web Crawler: 00:03:00 •Crawling Process Quiz: 00:01:00 •Quiz 22 Solution: 00:01:00 •Crawl Web Quiz: 00:01:00 •Quiz 23 Solution: 00:01:00 •Crawl Web Loop Quiz: 00:01:00 •Quiz 24 Solution: 00:02:00 •Crawl If Quiz: 00:01:00 •Quiz 25 Solution: 00:01:00 •Finishing Crawl Web and Final Quiz: 00:02:00 •Final Quiz Solution & Conclusion: 00:03:00 •Assignment - Computer Science With Python: 00:00:00

Overview This comprehensive course on Mastering Java for Beginners & Experts will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Mastering Java for Beginners & Experts comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Mastering Java for Beginners & Experts. It is available to all students, of all academic backgrounds. Requirements Our Mastering Java for Beginners & Experts is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 13 sections • 70 lectures • 05:35:00 total length •Introduction To This Course.: 00:02:00 •Setup Eclipse On Windows: 00:05:00 •Setup Eclipse On Mac OS X: 00:05:00 •Setup Eclipse On Linux: 00:05:00 •Run Code Online: 00:02:00 •Printing To The Console: 00:04:00 •Comments.: 00:06:00 •Variables.: 00:05:00 •Datatypes: 00:16:00 •Constant Variables: 00:03:00 •Console Input: 00:04:00 •Operators: 00:06:00 •If statement (Conditional Statement): 00:08:00 •Switch statement (Conditional Statement): 00:07:00 •For Loop.: 00:05:00 •While Loop.: 00:05:00 •Do While Loop.: 00:05:00 •Loop Control Statements: 00:03:00 •Numbers: 00:08:00 •Characters: 00:06:00 •Strings.: 00:05:00 •Arrays: 00:08:00 •For Each Loop: 00:04:00 •Date & Time: 00:04:00 •Regular Expressions.: 00:07:00 •Simple Example 1: 00:05:00 •Passing Values To Functions: 00:03:00 •Method Overloading: 00:05:00 •Command Line Arguments: 00:04:00 •Multiple Arguments Simplified: 00:06:00 •Byte Streams: 00:07:00 •Character Streams: 00:02:00 •Standard Streams: 00:04:00 •Listing Files & Folders: 00:02:00 •Creating Folders: 00:02:00 •Simple Example 2: 00:05:00 •Multiple Catch Blocks: 00:04:00 •Throw and Throws Keywords: 00:03:00 •Finally Block: 00:03:00 •User Created Exceptions: 00:08:00 •Simple Class Example: 00:08:00 •Constructor: 00:04:00 •This keyword: 00:05:00 •Inheritance.: 00:06:00 •Modifier Types: 00:04:00 •Overriding: 00:05:00 •Abstraction: 00:05:00 •Interfaces: 00:04:00 •Enum: 00:03:00 •Stacks.: 00:04:00 •Vector.: 00:06:00 •BitSet: 00:05:00 •Properties: 00:05:00 •Hashtable: 00:04:00 •List.: 00:04:00 •Set.: 00:04:00 •SortedSet: 00:03:00 •Map: 00:03:00 •Map.Entry: 00:03:00 •Sorted Map: 00:02:00 •Enumeration.: 00:05:00 •Client Example.: 00:07:00 •Server Example.: 00:11:00 •Creating Threads Using a Runnable Interface: 00:09:00 •Creating Threads by Extending a Thread Class: 00:03:00 •Simple Example 3: 00:04:00 •Keyboard Events: 00:04:00 •Mouse Events: 00:04:00 •Resource.: 00:00:00 •Assignment - Mastering Java for Beginners & Experts: 00:00:00

Overview This comprehensive course on 50 Tips to Upgrade your Excel Skill will deepen your understanding on this topic.After successful completion of this course you can acquire the required skills in this sector. This 50 Tips to Upgrade your Excel Skill comes with accredited certification which will enhance your CV and make you worthy in the job market.So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this 50 Tips to Upgrade your Excel Skill. It is available to all students, of all academic backgrounds. Requirements Our 50 Tips to Upgrade your Excel Skill is fully compatible with PC's, Mac's, Laptop,Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G.There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 7 sections • 52 lectures • 02:57:00 total length •Welcome: 00:02:00 •Camera Tool: 00:05:00 •Add Line Break in Formula Bar: 00:03:00 •Advanced Copy-Paste using Office Clipboard: 00:03:00 •Navigation between Worksheets using Shortcut Keys: 00:01:00 •Flash Fill: 00:02:00 •Add Multiple Rows and Columns Quickly: 00:02:00 •Delete Blank Rows: 00:03:00 •Multi Level Row and Column Sorting: 00:04:00 •Add Sparklines: 00:03:00 •Paste Special - Transpose: 00:03:00 •Snap to Grid: 00:03:00 •Create Custom Auto fill List: 00:06:00 •Absolute Cell Reference: 00:03:00 •Import Data from Web page: 00:04:00 •Move Cell Direction: 00:03:00 •Delete Data using Mouse: 00:02:00 •Status Bar Quick Calculations: 00:03:00 •Link Text Boxes to Cell: 00:04:00 •Phone Number and ZIP Code Format: 00:04:00 •Speaking Cell: 00:05:00 •Invisible Text: 00:03:00 •Worksheet Grouping: 00:04:00 •Advanced Transpose: 00:04:00 •XLStart Folder: 00:03:00 •Use Slicers: 00:05:00 •Convert Text to Numbers: 00:03:00 •Hiding Workbook Elements: 00:02:00 •Useful Shortcut Keys: 00:03:00 •Sort data from Left to Right: 00:03:00 •Advanced Filter (Complex): 00:11:00 •Email as PDF: 00:02:00 •Synchronous Scrolling: 00:03:00 •Quick Analysis of data within Excel: 00:02:00 •Fill blank cells with Value: 00:03:00 •Hidden Chart Source Data: 00:03:00 •Two more Shortcuts: 00:03:00 •Add Blank Rows: 00:03:00 •Custom views in Excel: 00:06:00 •EMBED Feature: 00:04:00 •Adding Country code in Mobile Numbers: 00:04:00 •Plot an Average Line to a Chart: 00:04:00 •3D Referencing: 00:04:00 •Extract Unique Values: 00:03:00 •Excel Array Formula: 00:04:00 •Forecast Sheet: 00:04:00 •Add Spin Controls in Excel: 00:05:00 •Move Data using Mouse: 00:01:00 •Add new entry in Auto Correct to use across Office Applications: 00:05:00 •Find Differences between Two Lists: 00:02:00 •Find formulas Quickly: 00:02:00 •Thank You: 00:01:00

Overview This comprehensive course on Advanced Excel Course (Formula, VLOOKUP & Power Query) will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Advanced Excel Course (Formula, VLOOKUP & Power Query) comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Advanced Excel Course (Formula, VLOOKUP & Power Query). It is available to all students, of all academic backgrounds. Requirements Our Advanced Excel Course (Formula, VLOOKUP & Power Query) is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more!   Course Curriculum 5 sections • 41 lectures • 02:56:00 total length •How to Get the most of the course: 00:01:00 •Text formulas in Excel: 00:08:00 •Text Formulas Exercise: 00:01:00 •Text Formulas Exercise (answers): 00:01:00 •Mathematical Formulas In Excel: 00:04:00 •Mathematical Formulas Exercise: 00:01:00 •Mathematical Formulas Exercise (answers): 00:01:00 •Date and Time Formulas In Excel: 00:05:00 •Date and Time Formulas Exercise: 00:01:00 •Date and Time Exercise Formulas (answers): 00:01:00 •Logic Formulas In Excel: 00:12:00 •Logic Formula Exercise: 00:01:00 •Logic Formula Exercise (answers): 00:01:00 •Financial Formula In Excel: 00:06:00 •Financial Formula Exercise: 00:01:00 •Financial Formula Exercise (answers): 00:02:00 •Informational Formula In Excel: 00:04:00 •Informational Formula Exercise: 00:01:00 •Informational Formula Exercise (answers): 00:01:00 •Menu Example with Excel Vlookup: 00:08:00 •Wildcard Search with Excel Vlookup: 00:09:00 •Looking to the Left with Excel Vlookup: 00:17:00 •2-Way Lookup: 00:14:00 •Comparing Lists with Excel Vlookup: 00:03:00 •Microsoft Excel Vlookup Tips and Tricks: 00:14:00 •Power Query Intro and Excel version: 00:03:00 •Excel Power Query - Introduction: 00:03:00 •Enabling M in Power Query: 00:02:00 •Transform Data - Trim in Excel Power Query: 00:05:00 •Transform Data - Format Dates and Values in Excel Power Query: 00:02:00 •Simple Expressions: 00:08:00 •Simple Expressions - Nested Expressions: 00:03:00 •Transform Data - Parsing URLs in Excel Power Query: 00:05:00 •Variables: 00:08:00 •Formatting Excel Keyboard Shortcuts: 00:02:00 •Table Excel Keyboard Shortcuts: 00:02:00 •Editing Excel Keyboard Shortcuts: 00:05:00 •Formula Excel Keyboard Shortcuts: 00:03:00 •Workbook Excel Keyboard Shortcuts: 00:02:00 •Handy Excel Shortcuts Keyboard Shortcuts: 00:05:00 •Assignment - Advanced Excel Course (Formula, VLOOKUP & Power Query): 00:00:00

Overview This comprehensive course on Intermediate Python Coding will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Intermediate Python Coding comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Intermediate Python Coding. It is available to all students, of all academic backgrounds. Requirements Our Intermediate Python Coding is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 10 sections • 59 lectures • 05:21:00 total length •Course Introduction: 00:02:00 •Course Curriculum: 00:05:00 •How to get Pre-requisites: 00:02:00 •Getting Started on Windows, Linux or Mac: 00:01:00 •How to ask Great Questions: 00:02:00 •Introduction to Class: 00:07:00 •Create a Class: 00:09:00 •Calling a Class Object: 00:08:00 •Class Parameters - Objects: 00:05:00 •Access Modifiers(theory): 00:10:00 •Summary: 00:02:00 •Introduction to methods: 00:06:00 •Create a method: 00:07:00 •Method with parameters: 00:12:00 •Method default parameter: 00:06:00 •Multiple parameters: 00:05:00 •Method return keyword: 00:04:00 •Method Overloading: 00:05:00 •Summary: 00:02:00 •Introduction to OOPs: 00:05:00 •Classes and Objects: 00:08:00 •Class Constructors: 00:07:00 •Assessment Test1: 00:01:00 •Solution for Assessment Test1: 00:03:00 •Summary: 00:01:00 •Introduction: 00:04:00 •Inheritance: 00:13:00 •Getter and Setter Methods: 00:12:00 •Polymorphism: 00:13:00 •Assessment Test2: 00:03:00 •Solution for Assessment Test2: 00:03:00 •Summary: 00:01:00 •Introduction: 00:03:00 •Access Modifiers (public, protected, private): 00:21:00 •Encapsulation: 00:07:00 •Abstraction: 00:07:00 •Summary: 00:02:00 •Introduction: 00:01:00 •Dice Game: 00:06:00 •Card and Deck Game Playing: 00:07:00 •Summary: 00:01:00 •Introduction: 00:01:00 •PIP command installations: 00:12:00 •Modules: 00:12:00 •Naming Module: 00:03:00 •Built-in Modules: 00:03:00 •Packages: 00:08:00 •List Packages: 00:03:00 •Summary: 00:02:00 •Introduction: 00:02:00 •Reading CSV files: 00:11:00 •Writing CSV files: 00:04:00 •Summary: 00:01:00 •Introduction: 00:01:00 •Errors - Types of Errors: 00:08:00 •Try - ExceptExceptions Handling: 00:07:00 •Creating User-Defined Message: 00:05:00 •Try-Except-FinallyBlocks: 00:07:00 •Summary: 00:02:00

Overview This comprehensive course on Excel Must know Formulas and Functions will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Excel Must know Formulas and Functions comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Excel Must know Formulas and Functions. It is available to all students, of all academic backgrounds. Requirements Our Excel Must know Formulas and Functions is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 2 sections • 13 lectures • 01:53:00 total length •Building basic math formulas: 00:08:00 •Autosum and Relative references: 00:09:00 •Absolute references: 00:06:00 •Named Ranges: 00:06:00 •Linking sheets and workbooks: 00:06:00 •If, And, Or, and the nested If functions: 00:16:00 •Countif, Sumif, Averageif, Sumifs, and Countifs functions: 00:09:00 •Vlookup and Hlookup functions: 00:15:00 •Match and Index functions: 00:07:00 •Date and time formulas and functions: 00:12:00 •Text functions: 00:11:00 •Tracing formulas: 00:08:00 •Assignment - Excel Must know Formulas and Functions: 00:00:00

Overview Enrol in our Coding with HTML, CSS, & Javascript today and build the necessary skills, knowledge and experience to transform your career. The Coding with HTML, CSS, & Javascript could enhance your continuing professional development thus propelling you more towards your dream job. This Coding with HTML, CSS, & Javascript could be your key, if you are interested in a long term career in the field of Coding with HTML, CSS, & Javascript. This Coding with HTML, CSS, & Javascript course consists of a number of easy to digest, in-depth modules which are designed to provide you with detailed knowledge on Coding with HTML, CSS, & Javascript. This Coding with HTML, CSS, & Javascript aims to accompany you through your journey to help you become a master of Coding with HTML, CSS, & Javascript. Learn through a mixture of interactive lessons and online study materials. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Coding with HTML, CSS, & Javascript. It is available to all students, of all academic backgrounds. Requirements Our Coding with HTML, CSS, & Javascript is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 7 sections • 66 lectures • 08:06:00 total length •1.1 Intro: 00:03:00 •1.2 Install the Tools and Get Started: 00:05:00 •2.1 Intro to HTML: 00:01:00 •2.2 What is HTML: 00:11:00 •2.3 Start a New HTML File & Use Tags: 00:12:00 •2.4 Header Tags: 00:05:00 •2.5 Edit Text: 00:09:00 •2.6 Links: 00:09:00 •2.7 Images: 00:10:00 •2.8 Lists: 00:04:00 •2.9 Challenge 1: 00:16:00 •2.10 HTML Outro: 00:01:00 •3.1 CSS Intro: 00:04:00 •3.2 Add CSS Styles: 00:16:00 •3.3 Classes and IDs: 00:07:00 •3.4 Borders: 00:06:00 •3.5 Sizing: 00:04:00 •3.6 Padding and Margin: 00:07:00 •3.7 Text Styles: 00:04:00 •3.8 DIVs: 00:08:00 •3.9 Postioning: 00:08:00 •3.10 Hover: 00:03:00 •3.11 Easily Center Elements: 00:02:00 •3.12 Fonts: 00:06:00 •3.13 Challenge: 00:23:00 •3.14 CSS Outro: 00:01:00 •4.1 Intro to Bootstrap: 00:02:00 •4.2 Install Bootstrap: 00:10:00 •4.3 Indenting and Containers: 00:07:00 •4.4 The Grid System: 00:16:00 •4.5 Images: 00:07:00 •4.6 Buttons: 00:06:00 •4.7 Challenge 3: 00:11:00 •4.8 Bootstrap Outro: 00:01:00 •5.1 Landing Page Intro: 00:01:00 •5.2 Sketch Your Landing Page: 00:05:00 •5.3 The Top Section: 00:16:00 •5.4 Polish the Top Section: 00:06:00 •5.5 Adding Images: 00:11:00 •5.6 The Main Points Section: 00:14:00 •5.7 Collecting Emails With an Opt-In Form: 00:11:00 •5.8 Challenge 4: 00:03:00 •5.9 Landing Page Outro: 00:02:00 •6.1 Business Site Intro: 00:01:00 •6.2 Sketch Up: 00:03:00 •6.3 Using Fancy Font Logo: 00:07:00 •6.4 Carousel Basics: 00:10:00 •6.5 Carousel Extras: 00:09:00 •6.6 Text on Images: 00:15:00 •6.7 Phone Number Icon: 00:04:00 •6.8 Google Maps: 00:13:00 •6.9 Font Awesome: 00:09:00 •6.10 Challenge 4: 00:08:00 •6.11 Business Site Outro: 00:01:00 •7.1 Intro: 00:01:00 •7.2 Portfolio Sketch: 00:08:00 •7.3 Jumbotron: 00:10:00 •7.4 Nav Bar: 00:24:00 •7.5 Panels: 00:11:00 •7.6 Challenge 5: 00:13:00 •7.7 Portfolio Outre: 00:01:00 •8.1 Hosting: 00:01:00 •8.2 Bluehost: 00:06:00 •8.3 Uploading: 00:05:00 •8.4 Tips: 00:11:00 •8.5 Hosting Outro: 00:01:00

Overview This comprehensive course on CNC Programming will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This CNC Programming  comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast-track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this CNC Programming. It is available to all students, of all academic backgrounds. Requirements Our CNC Programming is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 1 sections • 16 lectures • 01:19:00 total length •Section 01: Scope of the Course: 00:03:00 •Section 02: Numerical Control of Machine Tools: 00:04:00 •Section 03: CNC- Computer Numerical Control Syst: 00:02:00 •Section 04: Components of CNCs: 00:04:00 •Section 05: Point to Point CNC Machines: 00:03:00 •Section 06: Incremental & Absolute CNC Machines: 00:03:00 •Section 07: Open & Close Control Loop CNC Machines: 00:02:00 •Section 08: 2 &3 Axes CNC Machines: 00:02:00 •Section 09: Importance of Higher axes Machining: 00:02:00 •Section 10: Programming Format: 00:06:00 •Section 11: Cartesian Coordinate System: 00:03:00 •Section 12: How to Write a Program: 00:08:00 •Section 13: Basic CNC Programming (Absolute Mode): 00:09:00 •Section 14: Basic CNC Programming (Incremental): 00:04:00 •Section 15: A Simple Coding Exercise: 00:17:00 •Section 16: Applications of CNC: 00:07:00