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

🡆 Are you interested in building your own computer from scratch? 🡆 Do you want to learn how to install software and networking? Then Building the Computer and Software Installation Course is perfect for you! This course will teach you everything you need to know about building a computer, including an overview of hardware and parts, software installation, input and output devices, and computer networking. By the end of this course, you will have built your own computer and gained the skills to install software and connect to networks. Learning Outcomes: Understand the components of a computer and their functions Learn how to build a computer from scratch Gain the knowledge to install and troubleshoot software Connect to networks and configure internet settings Build a gaming PC with high-performance components Learn the basics of computer maintenance In today's digital age, computers have become an essential part of our lives. In the UK alone, 91% of households have access to the internet, which means that knowing how to build and maintain a computer is an invaluable skill. Module 01: Introduction to Computer & Building PC This module provides an introduction to computers and hardware, as well as an overview of the course. You'll learn about the different types of systems and the essential components that make up a computer. Module 02: Overview of Hardware and Parts This module provides an in-depth look at the hardware components that make up a computer, including the motherboard, processor, memory, hard drive, and graphics card. You'll learn how these components work together to create a functioning pc. Module 03: Building the Computer This module will cover how to assemble the components and connect them to create a fully functional computer. Module 04: Input and Output Devices This module covers the different types of input and output devices that are used with computers, including keyboards, mice, printers, and displays. You'll learn how to connect and configure these devices to work. Module 05: Software Installation This module covers the installation and configuration of software on a computer. You'll learn how to install an operating system, device drivers, and applications. Module 06: Computer Networking This module covers the basics of computer networking, including how to set up a network and connect to the internet. You'll learn about different types of networks and network devices, such as routers and switches. Module 07: Building a Gaming PC This module provides a step-by-step guide to building a gaming PC. You'll learn how to choose the right components and assemble them to create a high-performance gaming machine. Module 08: Maintenance of Computers This module covers the maintenance and troubleshooting of computers. You'll learn how to diagnose and fix common hardware and software issues, as well as how to keep your PC running smoothly. By the end of this course, you will have the knowledge and skills to build a computer from scratch, install software on it, and maintain it properly. You will also be able to troubleshoot common hardware and software issues. Certification Upon completion of the course, learners can obtain a certificate as proof of their achievement. You can receive a free PDF Certificate sent via email, a £9.99 Printed Hardcopy Certificate for delivery in the UK, or a £19.99 Printed Hardcopy Certificate for international delivery. Each option depends on individual preferences and locations. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The target audience for the course is: Individuals who want to learn how to build a computer Students who want to pursue a career in computer building and maintenance Gamers who want to build a high-performance gaming PC Requirements Without any formal requirements, you can delightfully enrol in this course. Career path Some career paths related to this industry in the UK are: Computer Technician: £18,000 - £28,000 per year Network Administrator: £25,000 - £40,000 per year Computer Support Specialist: £22,000 - £35,000 per year Gaming PC Builder: £25,000 - £50,000 per year

Embarking on the journey of constructing a personal computer can be a transformative experience, blending the art of technology with practical ingenuity. 'Learn How to Build a Computer Course from Scratch' is your gateway to mastering this skill. This course isn't just about assembling parts; it's a holistic approach to understanding the intricacies of computer hardware and software.  Whether you're intrigued by the mechanics of PCs or aspiring to create an elite gaming system, this programme offers a comprehensive curriculum that guides you through each step of the process. From identifying the core components in Module 01 to the specialized focus on gaming systems in Module 07, every session is crafted to enhance your knowledge and confidence in building a computer. Learning Outcomes: Acquire the foundational knowledge of computer assembly, including selecting and handling various hardware components. Develop the ability to construct a high-performance gaming computer, incorporating advanced hardware suitable for demanding games. Gain proficiency in software installation and configuration, ensuring optimal performance and compatibility. Understand computer networking principles, enabling you to integrate your PC into various network environments effectively. Learn essential maintenance techniques to ensure the long-term reliability and performance of your custom-built computer. Why buy this Learn How to Build a Computer Course from Scratch? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Certification After studying the course materials of the Learn How to Build a Computer Course from Scratch there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this Learn How to Build a Computer Course from Scratch for? Enthusiasts seeking to create their custom PC from scratch. Gamers looking to construct a high-performance gaming system. Individuals interested in learning about computer hardware and software. Hobbyists wanting to upgrade their technical skills in PC assembly. Career seekers aiming to develop skills in computer hardware maintenance and repair. Prerequisites This Learn How to Build a Computer Course from Scratch does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Learn How to Build a Computer Course from Scratch was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Computer Technician: £20,000 - £30,000 Per Annum Network Administrator: £25,000 - £40,000 Per Annum System Administrator: £30,000 - £50,000 Per Annum IT Support Specialist: £22,000 - £35,000 Per Annum Hardware Engineer: £28,000 - £50,000 Per Annum Gaming PC Builder: £18,000 - £35,000 Per Annum Course Curriculum Module 01: Introduction to Computer & Building PC Introduction to Computer & Building PC 00:17:00 Module 02: Overview of Hardware and Parts Overview of Hardware and Parts 00:27:00 Module 03: Building the Computer Building the Computer 00:25:00 Module 04: Input and Output Devices Input and Output Devices 00:22:00 Module 05: Software Installation Software Installation 00:35:00 Module 06: Computer Networking Computer Networking 00:21:00 Module 07: Building a Gaming PC Building a Gaming PC 00:19:00 Module 08: Maintenance of Computers Maintenance of Computers 00:20:00 Assignment Assignment - Learn How to Build a Computer Course from Scratch 00:00:00

Have you ever felt overwhelmed or stressed when faced with everyday mathematical challenges? Whether it's working out your monthly budget, understanding taxes, or planning a home renovation, the importance of functional maths skills cannot be overstated. Our Functional Skills Maths course is here to empower you with the essential knowledge and tools to overcome these obstacles and excel in all aspects of daily life. By enrolling in our carefully crafted course, you will gain the confidence to tackle real-world mathematical problems head-on. From mastering fractions, decimals, and percentages to navigating the complexities of ratios and proportions, our curriculum offers a comprehensive approach to functional maths. Develop your skills in areas such as money management, unit conversions, and 2-D and 3-D shape calculations, all while discovering the fascinating world of statistics and probability. Not only will you be equipped to handle everyday mathematical situations, but your newfound expertise will also open doors to a variety of career opportunities. Employers across numerous industries value strong numeracy skills, and our course can serve as a stepping stone to roles in retail management, financial administration, construction estimation, bookkeeping, and more. So why wait? Enrol in our Functional Skills Maths course and start unlocking your true potential. Experience the satisfaction and sense of accomplishment that comes with mastering essential mathematical skills, and watch as new opportunities unfold before your eyes. Invest in your future and gain the confidence to excel in all aspects of your daily life. This Advanced Diploma in Functional Skills Maths at QLS Level 2 course is endorsed by The Quality Licence Scheme and accredited by CPDQS (with 60 CPD points) to make your skill development & career progression more accessible than ever! Learning Outcomes: Develop numeracy skills through reading, writing, and comparing numbers. Apply substitution techniques to solve formulas in various contexts. Master fractions, decimals, and percentages and understand their interrelations. Gain proficiency in calculating ratio, proportion, profit, and loss. Acquire knowledge of simple and compound interest, discounts, taxes, and money concepts. Confidently convert between metric and imperial units and work with compound measures. Calculate perimeters, areas, volumes, and surface areas of 2-D and 3-D shapes. Interpret and analyse statistical data and calculate probabilities. Why Prefer This Functional Skills Maths (Updated 2023) Course? Opportunity to earn certificate a certificate endorsed by the Quality Licence Scheme & another accredited by CPD QS after completing the Functional Skills Maths (Updated 2023) course Get a free student ID card! (£10 postal charge will be applicable for international delivery) Innovative and engaging content. Free assessments 24/7 tutor support. ****Course Curriculum**** Here is the curriculum breakdown of this Functional Skills Maths (Updated 2023) Section 01: Introduction Section 02: Read, Write, Compare and Order Numbers of any size Section 03: Substitution in Given Formula Section 04: Fractions Section 05: Decimal Numbers Section 06: Percentages Section 07: Equivalence between fractions, decimals and percentages Section 08: Ratio and Proportion Section 09: Profit & Loss Section 10: Discounts and Taxes Section 11: Simple Interest and Compound Interest Section 12: Money Section 13: Convert between metric and imperial units Section 14: Compound Measures including speed, density & rates of pay Section 15: Perimeters and Areas of 2-D shapes Section 16: Volumes and Surface Areas of 3-D shapes Section 17: Scale Drawings Section 18: Statistics Section 19: Probability Section 20 Bonus Section (Time Topic 11 Video Lectures) Assessment Process You have to complete the assignment questions given at the end of the course and score a minimum of 60% to pass each exam.Our expert trainers will assess your assignment and give you feedback after you submit the assignment. After passing the Advanced Diploma in Functional Skills Maths at QLS Level 2 course exam, you will be able to request a certificate at an additional cost that has been endorsed by the Quality Licence Scheme. CPD 60 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course is designed for individuals seeking to improve their functional maths skills for personal, educational, or professional purposes. By focusing on practical applications of maths, learners will gain a solid foundation in numeracy and problem-solving. The course is suitable for individuals who may be returning to education, preparing for exams, or looking to enhance their skills for the workplace. It is ideal for those who need a refresher in maths or are aiming to develop confidence in working with numbers. Career path Retail Manager - £22-35k/year Financial Administrator - £18-30k/year Construction Estimator - £25-50k/year Bookkeeper - £18-30k/year Teaching Assistant - £14-20k/year Certificates Certificate of completion Digital certificate - £10 Advanced Diploma in Functional Skills Maths at QLS Level 2 Hard copy certificate - £79 Show off Your New Skills with a Certificate of Completion After successfully completing the Advanced Diploma in Functional Skills Maths at QLS Level 2, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme. The certificate will be home-delivered, with a pricing scheme of - £79 inside the UK £10 (including postal fees) for International Delivery Certificate Accredited by CPDQS £29 for Printed Hard Copy Certificate inside the UK £39 for Printed Hard Copy Certificate outside the UK (International Delivery)

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

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 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 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 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 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