4114 Computing courses in Knottingley delivered On Demand

Course Overview Build a solid foundation on Excel Spreadsheet with the Basic Excel Spreadsheet course. This course is designed to introduce you to the ins and outs of excel spreadsheets. Within no time, you will be able to add a new and valuable skill set to your resume. The Basic Excel Spreadsheet course will show you the essential components of the excel spreadsheet. You will understand the method of entertaining data. The course will enrich your knowledge of Autofill and Autosum. From the bite-sized modules, you will pick up skills to use the basic formulas. The course will show you how to format and manage spreadsheets. You will gain the expertise for linking the sheets together. This comprehensive course will also provide you with a detailed introduction to functions. Upon completing the course you will be equipped with the basic skills to operate a spreadsheet. The Basic Excel Spreadsheet course is the online platform to train yourself on the fundamentals of spreadsheets. Enroll in the course to elevate your abilities and increase your employability in the relevant sectors. Learning Outcomes Understand the fundamentals of Excel spreadsheets Learn the process of entering data into spreadsheets Enrich your knowledge of formula basics and copywriting formulas Grasp the skills for formatting spreadsheets Know the process of linking the sheets together Become competent in managing the sheets Who is this course for? Individuals who want to learn the basics of Excel Spreadsheet Entry Requirement This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Certification After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path  The Basic Excel Spreadsheet course is a useful qualification to possess and would be beneficial for any related profession or industry such as: Business Professional Data Operator Data Specialist Basic Excel Spreadsheet Tour of the Excel screen 00:10:00 Entering Data 00:13:00 Autofill Speedfill 00:09:00 Saving the file 00:02:00 Autosum 00:04:00 Formula Basics 00:11:00 Copying formulas - Relative Formulas 00:04:00 Totals and Averages 00:04:00 Formatting the Spreadsheet 00:07:00 Managing the Sheets 00:06:00 Copying formulas - absolute formulas 00:08:00 Linking the Sheets together 00:06:00 Introduction to Functions 00:05:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Course Overview Take your Excel skills to the next level with the help of the Need to Know Advanced Excel Formulas and Functions course. In this course, the expert instructor will show you how to optimize the use of excel. You will learn a handful of useful functions and formulas that will increase your proficiency in excel. The Need to Know Advanced Excel Formulas and Functions course aims to increase your competence in excel. The course will teach you the fundamental math functions. You will understand the concept of relative reference and absolute reference. The course will educate you on Autosum. You will receive lectures on how to link sheets and workbooks. The course will enrich your understanding of vlookup and hlookup functions. You will become skilled in training functions. From this course, you will achieve the essential training to upgrade your MS excel skills in no time. This Need to Know Advanced Excel Formulas, and Functions course will help you build excellent expertise in excel. Enroll in the course to boost your abilities and your employability in the relevant job market. Learning Outcomes Understand how to build basic math formulas Enrich your understanding of Autosum and relative references Learn how to link sheets and workbooks Gain the skills for tracking functions Deepen your knowledge of Vlookup and Hlookup functions Build your skills to work with text functions Who is this course for? Those who want to upgrade their excel skills Entry Requirement This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Certification After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path  The Need to Know Advanced Excel Formulas and Functions course is a useful qualification to possess and would be beneficial for any related profession or industry such as: Business Professional Administrative Officer Need to Know Advanced Excel Formulas and Functions 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 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Course Overview Learn Java programming from the Fundamental Concepts of Java course and be able to create object-oriented programs using your skill. This course will help you to create interactive object-oriented programS for your desktop, phone or website. In this Fundamental Concepts of Java course, you will learn about the modern Java programming tools, Java 9 and 11, inheritance, abstraction, interference, different Java features and many other functions that will help you to program using Java language. You will be able to understand how Java programming works for websites, desktops and Android mobiles. You will also be able to understand why the functions work instead of only understanding how to use them. This course will help you to understand how to create Java programming from scratch. This is an ideal course for anyone who wants to learn Java programming understand the use of it and start their career as a programmer. Learning Outcomes Learn the fundamentals of the Java programming language Understand object-oriented programming Know about exception handling enums and type wrapper Be able to understand the concept of inserting animation into programming Learn how Java works and convert code to the understandable computer language Who is this course for? This course is ideal for anyone who wants to learn the Java programming language and build their career as a programmer. This course will help you understand the function of Java programming from scratch. Entry Requirement This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Certification After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path Fundamental Concepts of Java is a useful qualification to possess and would be beneficial for any related profession or industry such as: Programmer Web Developer Android App Developer Web Designer Data Security Officer Fundamental Concepts of Java Module 01: Hello World _ IDE 00:07:00 Module 02: What is Java? 00:13:00 Module 03: Working With Variables 00:12:00 Module 04: Variable Types 00:14:00 Module 05: Non-Numeric Data Types 00:10:00 Module 06: Strings 00:16:00 Module 07: Arithmetic Operators 00:14:00 Module 08: Relational Operators 00:10:00 Module 09: Logical Operators 00:10:00 Module 10: Assignment Operators 00:10:00 Module 11: Solving Problems with Google 00:09:00 Module 12: If in Java 00:11:00 Module 13: Else If Else 00:16:00 Module 14: Switch 00:12:00 Module 15: While Loop 00:14:00 Module 16: For Loop 00:13:00 Module 17: Arrays 00:14:00 Module 18: Sorting Array 00:15:00 Module 19: Methods 00:15:00 Module 20: Recursion 00:07:00 Module 21: OOP #1 - Classes _Object 00:12:00 Module 22: OOP #2 - Constructors 00:08:00 Module 23: OOP #3 - Inheritance 00:14:00 Module 24: OOP #4 - Modifier Types 00:17:00 Module 25: OOP #5 - Encapsulation 00:12:00 Module 26: OOP #6 - Abstraction 00:16:00 Module 27: OOP #7 - Polymorphism 00:09:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Course Overview Microsoft Excel has brought a revolutionary change in the field of data management. It is one of the key skills that every employer looks for in a potential employee. The 50 MS Excel Tips to Upgrade your Excel Skill to the Next Level course is designed to equip you with adequate expertise in Excel. This course is a golden opportunity to add a highly beneficial skill to your resume and impress your employers. In this 50 MS Excel Tips to Upgrade your Excel Skill to the Next Level course, you will receive a wide range of valuable tips to elevate your MS Excel skills. The course will show you the process of adding a link in the formula bar and adding multiple columns and rows within a blink. You will become skilled in quick calculations in the status bar. From the informative modules, you will identify the shortcut keys and learn to navigate between worksheets. The lessons will introduce you to the method of ZIP code format. You will understand how to move cell directions and convert numbers to text.  This 50 MS Excel Tips to Upgrade your Excel Skill to the Next Level course is packed with valuable information about MS Excel. So enroll in the course and become a proficient MS Excel user. Learning Outcomes Learn how to navigate between worksheets using shortcut keys Understand the process of creating a custom autofill list and importing data from webpages Build the skills to hide workbook elements Enrich your understanding of advanced transpose Grasp the techniques of moving cell directions and deleting data Know how to convert text to numbers Who is this course for? This 50 MS Excel Tips to Upgrade your Excel Skill to the Next Level course is for those who want to improve their Excel skills. Entry Requirement This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Certification After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path  The 50 MS Excel Tips to Upgrade your Excel Skill to next Level course is a useful qualification to possess and would be beneficial for any related profession or industry such as: Administrative Assistant Data Analyst Accountants Financial Analyst Retail Store Manager Project Manager Business Analyst Unit 01: Introduction Welcome 00:02:00 Unit 02: Excel Productivity Tips -Part 1 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 Unit 03: Excel Productivity Tips - Part 2 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 Unit 04: Excel Productivity Tips - Part 3 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 Unit 05: Excel Productivity Tips - Part 4 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 Unit 05: Excel Productivity Tips - Part 5 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 Unit: 06 Wrap Up Thank You 00:01:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Start on a transformative journey into the world of web design with our masterclass. Unleash your creative prowess and conquer the digital realm.

Mastering English and Maths is pivotal in both daily life and professional endeavors. English facilitates effective communication, enabling clear expression of ideas and successful interactions. Maths equips us with problem-solving skills and numerical literacy vital for budgeting, decision-making, and various tasks. Elevate your career prospects with our comprehensive Functional Skills Maths Level 2 & Functional Skills English course. Sharpen practical mathematical abilities, enhance language proficiency, and gain a competitive edge in the job market. Acquire skills employers highly value, boosting your employability and paving the way for personal growth and success. Invest in yourself today and reap the rewards tomorrow. 4 Exclusive Courses with 4 Free CPD Accredited PDF Certificates! Limited Time Offer!! Hurry Up and Enrol Now!!! Course 01: Functional Skills Maths Course 02: Functional Skills English Course 03: Functional Skills IT Course 04: Functional Skills Fitness This Functional Skills course starts with the basics of Functional Skills and gradually progresses towards advanced topics. Therefore, each lesson of this Functional Skills is intuitive and easy to understand. Why would you choose the Functional Skills course: Lifetime access to the Functional Skills course materials Full tutor support is available from Monday to Friday with the Functional Skills course Learn Functional Skills at your own pace from the comfort of your home Gain a complete understanding of the Functional Skills course Accessible, informative learning Functional Skills course modules designed by experts Get 24/7 help or advice from our email and live chat teams with the Functional Skills course Study Functional Skills in your own time through your computer, tablet or mobile devic A 100% learning satisfaction guarantee with your Functional Skills course Curriculum Breakdown of the Functional Skills (Maths, English, IT & Fitness) Level 2 Bundle Take a look at the training modules of the Functional Skills Maths Level 2 Numbers and Negative Numbers Multiples Factors Fractions and Power Percentages Expressions Decimals Ratio and Proportion Exponents and Radicals Graphs The Profit and Loss Perimeter and Area Averages Probability Take a look at the training modules of the Functional Skills English Level 2 Basics of Grammar The Basics of Sentence Structure of Sentence Punctuation & Capitalisation Spelling Take a look at the training modules of the Functional Skills IT How People Use Computers System Hardware Device Ports and Peripherals Data Storage and Sharing Understanding Operating Systems Setting Up and Configuring a PC Setting Up and Configuring a Mobile Device Managing Files Using and Managing Application Software IT Security Threat Mitigation Computer Maintenance and Management IT Troubleshooting Understanding Databases Take a look at the training modules of the Functional Skills Fitness Introduction Introduction To Functional Fitness Training What Is Functional Fitness Benefits Of Functional Fitness Benefits Of Functional Fitness Functional Fitness & Other Exercises Common Mistakes With Functional Fitness Functional Fitness Training Areas Functional Fitness & Power Functional Fitness & Strength Functional Fitness & Range Of Motion Functional Fitness & Balance & Endurance Conclusion to Functional Fitness Training Conclusion CPD 40 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Functional Skills course. Requirements To enrol in this Functional Skills course, all you need is a basic understanding of the English Language and an internet connection. Career path The Functional Skills (Maths, English, IT & Fitness) Level 2 bundle will enhance your knowledge and improve your confidence in exploring opportunities in various sectors related to Functional Skills (Maths, English, IT & Fitness) Level 2 are following- Teacher of Mathematics Teacher of English Teacher of IT Mathematics/ English/ IT Lecturer SEND Maths/ English/ IT Teacher Functional Skills Tutor Certificates CDP Accerdited PDF Certificate Digital certificate - Included 4 CPD Accredited PDF Certificates for Free CPD Accredited Hardcopy Certificate Hard copy certificate - £9.99 Delivery Charge Inside the UK: Free Outside the UK: £9.99 for each.

Information on the risks and practical advice to address them TSC's eBooks, whitepapers, and reports cover some of the most important risks in information and cyber security — risks that constantly challenge information and cyber security professionals who work tirelessly to reduce them across their organisations and home users alike.

Information on the risks and practical advice to address them TSC's eBooks, whitepapers, and reports cover some of the most important risks in information and cyber security — risks that constantly challenge information and cyber security professionals who work tirelessly to reduce them across their organisations and home users alike.

Overview Help others overcome their fear of mathematics and teach students how to reach their career potentials with numerology. This unique course will train you to become an accomplished mathematical teacher and advance the knowledge of pupils in this area. The Functional Skills Maths course is packed with information regarding Functional Maths and uses varied educational methods to embed the knowledge. You will find that you will quickly attain the ability to teach Maths in a lively and personal way, giving you a genuine advantage in the UK education system. From integers to fractions, and percentages, enrol now and learn to make maths easy. 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 Functional Skills Maths. It is available to all students, of all academic backgrounds. Requirements Our Functional Skills Maths 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 13 sections • 67 lectures • 06:56:00 total length •Lecture 1 Introduction: 00:02:00 •Lecture 2 Multiplying any digit number by 11, 22, and 33: 00:09:00 •Lecture 3 Integers and ordering of integers: 00:06:00 •Lecture 4 Addition and Subtractions of Integers: 00:07:00 •Lecture 5 Operations on Integers: 00:04:00 •Lecture 6 Multiplication and Division of Integers: 00:04:00 •Lecture 7 Powers of Integers (Exponents): 00:04:00 •Lecture 8 Complete knowledge about factors and multiples: 00:06:00 •Lecture 9 Divisibility tests for 2,3,4,5,6: 00:07:00 •Lecture 10 Divisibility rules 7,8,9,10,11: 00:06:00 •Lecture 11 Prime Factorization: 00:06:00 •Lecture 12 Highest Common Factor HCF: 00:10:00 •Lecture 13 Least Common Multiple LCM: 00:16:00 •Lecture 14 Relation between LCM and HCF: 00:04:00 •Lecture 15 Classification of Fractions: 00:04:00 •Lecture 16 Convert mixed to improper and improper to mixed fractions: 00:03:00 •Lecture 17 Equivalent Fractions: 00:04:00 •Lecture 18 Comparing Fractions after converting to like fractions: 00:09:00 •Lecture 19 Reducing a fraction to lowest term: 00:04:00 •Lecture 20 Addition and subtraction OF fractions: 00:08:00 •Lecture 21 Multiplication and division of fractions: 00:11:00 •Lecture 22 Word problems on fractions: 00:16:00 •Lecture 23 BODMAS and rules to remove brackets: 00:03:00 •Lecture 24 Simplify expressions using BODMAS rules: 00:05:00 •Lecture 25 Simplify expressions involving fractions using BODMAS: 00:07:00 •Lecture 26 Decimal numbers in relation to fractions: 00:08:00 •Lecture 27 Like and unlike Decimals: 00:05:00 •Lecture 28 Ordering of Decimal numbers: 00:10:00 •Lecture 29 Addition and subtraction of Decimal: 00:07:00 •Lecture 30 Multiplication of Decimal: 00:03:00 •Lecture 31 Division of Decimal: 00:05:00 •Lecture 32 Rational number: 00:02:00 •Lecture 33 Representation of Rational Numbers on Number line: 00:04:00 •Lecture 34 Determining which fraction is terminating or non terminating: 00:05:00 •Lecture 35 shortcut method of writing decimal expansion of fraction to decimal: 00:08:00 •Lecture 36 Rounding to whole number: 00:06:00 •Lecture 37 Rounding to required number of decimals (1 d.p. ): 00:05:00 •Lecture 38 rounding to significant digits: 00:07:00 •Lecture 39 Practice question on three methods of approximation: 00:05:00 •Lecture 40 Estimation: 00:05:00 •Lecture 41 Scientific Notation: 00:07:00 •Lecture 42 Operation on numbers when they are in scientific notation: 00:06:00 •Lecture 43 Percentage to fraction and fraction to percentage: 00:06:00 •Lecture 44 Percentage of a quantity and conversation to decimal: 00:06:00 •Lecture 45 Expressing one quantity as percentage of another quantity: 00:06:00 •Lecture 46 Finding increase decrease percent: 00:05:00 •Lecture 47 Uses of percentages-Word Problems: 00:09:00 •Lecture 48 Ratio- How to express as simple ratio: 00:09:00 •Lecture 49 How to compare Ratios: 00:04:00 •Lecture 50 Word problems on finding ratios: 00:07:00 •Lecture 51To divide a given quantity into a given Ratio: 00:11:00 •Lecture 52 Proportion: 00:04:00 •Lecture 53 Practice problems on Proportion: 00:06:00 •Lecture 54 Continued proportion: 00:06:00 •Lecture 55 Direct Variation ( or proportion): 00:04:00 •Lecture 56 Problems based on Direct proportion: 00:10:00 •Lecture 57 Inverse Variation ( or proportion): 00:10:00 •Lecture 58 Multiple Ratios: 00:10:00 •Lecture 59 Basics - Profit and Loss: 00:04:00 •Lecture 60 More practice problems on Profit & Loss: 00:06:00 •Lecture 61 Selling price formula and Problems: 00:04:00 •Lecture 62 Cost price formula and Problems: 00:03:00 •Lecture 63 Higher problems on Profit and Loss: 00:08:00 •Lecture 64 Basics - Discount.mp4: 00:05:00 •Lecture 65 Practice problems on Discount: 00:04:00 •Lecture 66 Tax: 00:06:00 •Assignment - Functional Skills Maths - Level 2: 00:00:00