• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

345 Computing Skills courses delivered Online

SQL Programming

By Compete High

Overview With the ever-increasing demand for SQL in personal & professional settings, this online training aims at educating, nurturing, and upskilling individuals to stay ahead of the curve - whatever their level of expertise in SQL may be. Learning about SQL or keeping up to date on it can be confusing at times, and maybe even daunting! But that's not the case with this course from Compete High. We understand the different requirements coming with a wide variety of demographics looking to get skilled in SQL . That's why we've developed this online training in a way that caters to learners with different goals in mind. The course materials are prepared with consultation from the experts of this field and all the information on SQL is kept up to date on a regular basis so that learners don't get left behind on the current trends/updates. The self-paced online learning methodology by compete high in this SQL course helps you learn whenever or however you wish, keeping in mind the busy schedule or possible inconveniences that come with physical classes. The easy-to-grasp, bite-sized lessons are proven to be most effective in memorising and learning the lessons by heart. On top of that, you have the opportunity to receive a certificate after successfully completing the course! Instead of searching for hours, enrol right away on this SQL course from Compete High and accelerate your career in the right path with expert-outlined lessons and a guarantee of success in the long run. Who is this course for? While we refrain from discouraging anyone wanting to do this SQL course or impose any sort of restrictions on doing this online training, people meeting any of the following criteria will benefit the most from it: Anyone looking for the basics of SQL , Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in SQL , Anyone looking for a certificate of completion on doing an online training on this topic, Students of SQL , or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity Career Path This SQL course smoothens the way up your career ladder with all the relevant information, skills, and online certificate of achievements. After successfully completing the course, you can expect to move one significant step closer to achieving your professional goals - whether it's securing that job you desire, getting the promotion you deserve, or setting up that business of your dreams.  Course Curriculum Module 1- Introduction to SQL Introduction to SQL 00:00 Module 2 - SQL Installation SQL Installation 00:00 Module 3 - Beginner SQL Beginner SQL 00:00 Module 4 - Queries Queries 00:00 Module 5 - Intermediate SQL Intermediate SQL 00:00 Module 6 - Advanced SQL Operators Advanced SQL Operators 00:00

SQL Programming
Delivered Online On Demand6 hours
£25

Best Techniques To Speed Up Your Mathematics

By iStudy UK

Want to get rid of the burden of heavy calculations? On the off chance that you have ever been keen on speeding up your Mathematics multiple times quicker with Vedic Math, Mental Math tricks and shortcuts for GMAT, Olympiad, then Best Techniques To Speed Up Your Mathematics will be the best opportunity for you. Through this course, you will receive lots of tips and tricks which will become a component of your calculations. Besides, numerous know-how of Vedic Mathematics also covered in this course which can easily apply in today's Math. By the time you complete this course, you will be set to perform large calculations and enhanced your Mathematics skills. To sum up, this course will be remarkably helpful for individuals who have interest in doing complicated multiplication in less time. What Will I Learn? Apply ' Digital Sum' technique of vedic Mathematics to find right options in multiple choice questions with in a few seconds. Short cuts for 'Time & Work' explained in 11 lectures with lots of practice problems. Find day of the week when any old or coming date is given without counting odd days and leap years Count number of squares , rectangles and triangles with the help of short cut tricks Find answer in 2 seconds of simplification problems like 1/6 +1/12+1/20+1/30+1/42+1/50+1/72+1/90+1/110+1/132 Apply short cuts to solve fraction series like 3/1²×2² + 5/ 2²×3² + 7/ 3²×4² +.............19/9²×10² Simplify in 2 seconds problems like ( 1 - 1/3 ) ( 1 - 1/4 ) ( 1 - 1/5 ) ( 1 - 1/6) ........ ( 1 - 1/50 ) Find the solution of complicated repeated square root problems like √5(√5(√5(√5))) in two seconds Squaring any two digit numbers,decimal and non decimal with the help of vedic math technique Squaring any three digit numbers,decimal and non decimal with the help of vedic math technique Able to find square root of any digit number which are not perfect square easily with a special short trick Able to find cube root of any digit number which are not perfect cube easily with a special short trick With Vedic Maths techniques, Multiplying any digit number by 9 ; 99 ; 999 ; 9999999 etc faster than calculator like 47356 × 99999 and 345 × 99999 Multiplying two numbers of any digit in a single line with the help of very fast technique of Vedic mathematics 'Vertically and Crosswise' Multiply any two digit number or any big number by 11,22 and 33 in brain faster than the calculator . Learn how to find remainder when any big digit number is divided by 9 without actually dividing , faster than calculator With Vedic Maths techniques, Multiplying two large numbers of same digits below the base 1000 ;10000 ;100000 etc in 2 seconds like 996 ×995, 9991 × 9992 Multiplying two numbers of same digits above the base 1000 ;10000 ;100000 etc in 2 seconds like 105 ×106 , 1003 × 1007, 100001 × 100006 Multiplication of numbers one above the base and the other less than the base like 1 0 5 × 9 4 ; 1 0 02 × 996 etc in 2 seconds Multiplying any digit number by 5 , 25 and 125 very fast within 2 seconds. Squaring numbers that end in 5 faster than calculator Requirements Knowledge of mathematics up to fifth grade Knowledge of the Times Tables up to 9 A pen/ pencil and paper Who is the target audience? GMAT, GRE, CAT, Maths Olympiad, Banking Exams and University entrance exams students looking to increase calculation power with the help of Vedic Maths Shortcuts Whoever wants to learn to do calculations without calculator Whoever wants to increase Math power, skill and get rid of fear of Maths School students want to learn short tricks , wants to increase concentration Middle school and High school students want to do calculations many times faster Introduction Lecture 1 Introduction.mp4 FREE 00:02:00 Section 2 Lecture 2 Multiplying any digit number by 11, 22, and 33 00:09:00 Section 3 Lecture 3 Finding remainder when a number of any digits is divided by 9.mp4 00:04:00 Section 4 Lecture 4 Multiplying any digit number by series of 9; 99; 999; 99999 Part 1.mp4.TS 00:08:00 Lecture 5 Multiplying any digit number by series of 9; 99 ; 999 ; 99999 Part 2.mp4 00:07:00 Section 5 Lecture 6 Product of two numbers below the base number 100; 1000 etc.mp4 00:08:00 Lecture 7 Multiplication of Numbers above the base 1000; 10000; 100000 etc.mp4 00:08:00 Lecture 8 Multiplication of numbers one above the base and second less than the base.mp4 00:06:00 Section 6 Lecture 9 multiplying any two digit numbers using Vertically and Crosswise.mp4 00:04:00 Lecture 10 Multiplying three digit numbers using Vertically and Crosswise.mp4 00:05:00 Section 7 Lecture 11 Multiplying any digit number by 5, 25, and 125 faster than calculator.mp4 00:07:00 Section 8 Lecture 12 Squaring numbers that end in 5 using Vedic Math.mp4.TS 00:04:00 Lecture 13 Squaring two digit numbers mentally Using Vedic Math technique.mp4 00:06:00 Lecture 14 Squaring three digit numbers mentally Using Vedic Math technique.mp4 00:05:00 Section 9 Lecture 15 Finding cube of any two digit number faster than calculator.mp4 00:10:00 Section 10 Lecture 16 Approximate value of square root of numbers which are not perfect squares.mp4 00:09:00 Lecture 17 Approximate value of cube root of numbers which are not perfect cubes.mp4 00:05:00 Section 11 Lecture 18 Short tricks to count Number of Squares in given figure.mp4 00:05:00 Lecture 19 Short tricks to count Number of Rectangles in given figure.mp4 00:03:00 Lecture 20 Short tricks to count Number of triangles in given figure.mp4.TS 00:04:00 Section 12 Lecture 21 Finding Day of the week when any date is given in 2 Seconds mentally.mp4 00:12:00 Simplify calculations super fast Lecture 22 Digital sum of a number.mp4 00:04:00 Lecture 23 Digital sum- Addition and Subtraction.mp4 00:10:00 Lecture 24 Digital sums- Multiplication.mp4 00:07:00 Lecture 25 Digital sum- divisions.mp4 00:08:00 Simplification short cuts for complicated fractions and square root problems Lecture 26 Simplification short tricks for complicated fractions.mp4 00:10:00 Lecture 27 Simplification short tricks for fractions series part 1.mp4 00:07:00 Lecture 28 Simplification short tricks for fractions series part 2.mp4 00:05:00 Lecture 29 Simplification short tricks for complicated square root problems.mp4 00:09:00

Best Techniques To Speed Up Your Mathematics
Delivered Online On Demand3 hours 11 minutes
£25

Diploma in Healthy Computing

4.3(43)

By John Academy

Description Sitting at a computer for long period of time can harm your body and mind. If you don't sit with the correct posture, you can easily end up with back pain, neck pain, knee pains, and a tingling of the hands and fingers. In this course, we share some good tips that help you maintain good ergonomics and stay healthy and comfortable at your desk during the day. This course will cover the matters which increase productivity at work, enhance employee safety by preventing injury, learning about the factors that could lead to back, neck and hip pain, learning how to set-up the desk to use the computer safely and understanding the risks associated with the use of laptop and how to avoid them etc. Who is the course for? Anyone who works on a computer or sit on their mobiles for a very long time such as bloggers, entrepreneurs, businessmen and university students. Entry Requirement This course is available to all learners, of all academic backgrounds. Learners should be ages 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, 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 hard copy at a cost of £39 or in PDF format at a 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 recognised 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 Carrying out healthy computing at your workstation makes ensures you're comfortable, safe and productive at the office. Diploma in Healthy Computing Introduction 01:00:00 Body Position 01:00:00 Monitors 01:00:00 Keyboards 01:00:00 Mouse or Pointer 02:00:00 Document Holders and Desk 01:00:00 Chairs 02:00:00 Telephones 00:30:00 What Have We Learned 01:00:00 Work Process and Recognition 01:00:00 Lighting 01:00:00 Ventilation 00:30:00 Awkward Postures 02:00:00 Musculoskeletal Disorders (MSD) 02:00:00 4 Steps to Setting Up The Computer Workstation 01:00:00 Exercises and Breaks 01:00:00 Conclusion 00:15:00 Mock Exam Mock Exam- Diploma in Healthy Computing 00:20:00 Final Exam Final Exam- Diploma in Healthy Computing 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Diploma in Healthy Computing
Delivered Online On Demand19 hours 55 minutes
£25

Microsoft Internet Explorer 6,7,8 Training

4.3(43)

By John Academy

Description: Are thinking to improve your skills and knowledge on Windows system? Then you are welcome to join this course! Microsoft Internet Explorer 6,7,8 Training is a combined course and designed especially for your benefit. Microsoft Internet Explorer 6 is the sixth major revision of Internet Explorer for Windows operating systems. In the course, you will be introduced to Internet Explorer basics, the Internet Explorer interface, ways to access a website, printing from the web, working with data, set your options, security features and so much more. You will get the basic knowledge of Windows functions, and how to use the mouse and keyboard. Following that, Microsoft Internet Explorer 7 will help you to understand the basics of Internet Explorer, Internet Explorer interface and windows, toolbar, using tabs, searching the web, managing information and history, RSS feeds and much more. Windows Internet Explorer 8 is the latest version of Microsoft's broadly used Windows operating system. With the help of this course, you will get a complete overview of the new start screen, a comprehensive look at touch gesture, an introduction to the default applications and information on using the desktop and its uses. Learning Outcomes: Learn how to understand secure sites Get knowledge of accessing the protected sites Get to know the Internet Explorer's security features Learn to keep yourself safe Learn to manage the information Know of setting your options Learn of managing history Get additional components Commence with Internet Explorer 7 Learn to browse the Internet Know how to set up favourites Learn how to be safe as you are browsing Realise the advanced features Understanding the requirements of internet connection, different types of connections, and opening, setting up and closing Internet Explorer Get an overview of the user interface by using the command area, menu bar, explorer bar, search bar and status bar Discover the application window by learning how to minimize, maximize, restore, and manually resize the window; differences between full screen vs. normal mode; and using zoom feature Enabling, disabling and locking toolbars, along with customizing the command toolbar Get help from help menu, help file, using the table of contents, searching the help file, taking internet explorer tour and online support Learn how to use the navigation buttons, understand parts of web addresses, access your homepage, access websites using address bar and/or hyperlink, and opening page in a new window Opening and closing tabs, switching between tabs, access tabbed help, using tabbed thumbnails and tab list Search the web using search boxes, search engines, within a page, and get some general tips for searching and change the search options Copying text and pictures from the web, saving pictures and web pages, and sending page, link or picture using emails Examine the print preview, page setup, printing page or selection options Understand Favourites; opening, pinning and closing favourites centre; and accessing favourites without Internet Explorer Marking pages or multiple tabs, deleting, maintaining and accessing favourites Organise your favourites by renaming them, adding folders to favourites, and saving and moving them into the folders Understand and manage accelerators, use and get new ones Get to know what are web slices, and how to get, use and find them See the differences between secure and non-secure sites, learn about encryption, digital signatures, cookies, browser cache, and display options Protect your sites using passwords, form filling, learning about the Password Manager, and CAPTCHA Discover more about information bar, pop-up blocker, phishing filter, InPrivate browsing and filtering, and finally managing add-ons Get safety tips and learn about antiviral software, anti-spam software, and firewalls Import and export favourites and cookies Understand and open dialog boxes, set up your homepage, delete temporary internet files, setup parental filtering, automatically disconnect, and set internet explorer as default browser Manage browser history by understanding what it is, access history from address bar, manually delete history items, clear entire history, and set up history options Discover the meaning of RSS Feed, how to view it, subscribing and using feeds, changing feed properties and unsubscribing from feeds Explore HTML, JavaScript, and ActiveX; view and edit HTML source code, more plugins and add-ons, and reset options for internet explorer Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Internet Explorer 6,7,8 Training is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Internet Explorer 6,7,8 Training is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Module : 1 DEFINITIONS 00:30:00 INTERNET EXPLORER BASICS 00:30:00 THE INTERNET EXPLORER INTERFACE 00:30:00 MORE ABOUT TOOLBARS 00:30:00 GETTING HELP 00:30:00 ACCESSING A WEB SITE 00:30:00 SEARCHING THE WEB 00:30:00 WORKING WITH DATA 00:30:00 PRINTING FROM THE WEB 00:30:00 FAVOURITE BASICS 00:30:00 CREATING AND USING FAVOURITES 00:30:00 ORGANIZING FAVOURITES 00:30:00 THE LINKS TOOLBAR 00:30:00 SECURE SITES 00:30:00 ACCESSING PROTECTED SITES 00:30:00 SECURITY FEATURES 00:30:00 KEEPING YOURSELF SAFE 00:30:00 MANAGING INFORMATION 00:30:00 SETTING YOUR OPTIONS, PART ONE 00:30:00 SETTING YOUR OPTIONS, PART TWO 00:30:00 MANAGING YOUR HISTORY 00:30:00 ADDITIONAL COMPONENTS 00:30:00 Module : 2 Definitions to Microsoft Internet Explorer 7 00:15:00 Internet Explorer Basics 00:15:00 The Internet Explorer Interface 00:15:00 The Internet Explorer Window 00:15:00 More About Toolbars 00:15:00 Getting Help 00:30:00 Access a Web Site 00:15:00 Using Tabs 00:15:00 Searching the Web 00:15:00 Working with Data 00:30:00 Printing from the Web 00:15:00 Favorite Basics 00:15:00 Creating and Using Favorites 00:15:00 Organizing Favorites 00:15:00 The Links Folder 00:15:00 Secure Sites 00:15:00 Accessing Protected Sites 00:15:00 Security Features 00:22:00 Keeping Yourself Safe 00:15:00 Managing Information 00:15:00 Setting Your Options 00:15:00 Managing Your History 00:15:00 RSS Feeds 00:15:00 Additional Components 00:15:00 Module : 3 Definitions 00:15:00 Internet Explorer Basics 00:30:00 The Internet Explorer Interface 01:00:00 The Internet Explorer Window 00:30:00 More about Toolbars 00:15:00 Getting Help 01:00:00 Accessing a Web Site 00:30:00 Using Tabs 00:30:00 Searching the Web 01:00:00 Working with Data 01:15:00 Printing from the Web 00:30:00 Favorite Basics 00:15:00 Creating and Using Favorites 00:30:00 Organizing Favorites 00:30:00 Accelerators 01:00:00 Web Slices 00:15:00 Secure Sites 00:15:00 Accessing Protected Sites 00:15:00 Security Features 01:00:00 Keeping Yourself Safe 00:15:00 Managing Information 00:30:00 Setting Your Options 01:00:00 Managing your History 00:30:00 RSS Feeds 00:30:00 Additional Components 00:30:00 Mock Exam Mock Exam- Microsoft Internet Explorer 6,7,8 Training 00:30:00 Final Exam Final Exam- Microsoft Internet Explorer 6,7,8 Training 00:30:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft Internet Explorer 6,7,8 Training
Delivered Online On Demand33 hours
£22

Computer Maintenance

By Compete High

Overview With the ever-increasing demand for Computer Maintenance in personal & professional settings, this online training aims at educating, nurturing, and upskilling individuals to stay ahead of the curve - whatever their level of expertise in Computer Maintenance may be. Learning about Computer Maintenance or keeping up to date on it can be confusing at times, and maybe even daunting! But that's not the case with this course from Compete High. We understand the different requirements coming with a wide variety of demographics looking to get skilled in Computer Maintenance . That's why we've developed this online training in a way that caters to learners with different goals in mind. The course materials are prepared with consultation from the experts of this field and all the information on Computer Maintenance is kept up to date on a regular basis so that learners don't get left behind on the current trends/updates. The self-paced online learning methodology by compete high in this Computer Maintenance course helps you learn whenever or however you wish, keeping in mind the busy schedule or possible inconveniences that come with physical classes. The easy-to-grasp, bite-sized lessons are proven to be most effective in memorising and learning the lessons by heart. On top of that, you have the opportunity to receive a certificate after successfully completing the course! Instead of searching for hours, enrol right away on this Computer Maintenance course from Compete High and accelerate your career in the right path with expert-outlined lessons and a guarantee of success in the long run. Who is this course for? While we refrain from discouraging anyone wanting to do this Computer Maintenance course or impose any sort of restrictions on doing this online training, people meeting any of the following criteria will benefit the most from it: Anyone looking for the basics of Computer Maintenance , Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in Computer Maintenance , Anyone looking for a certificate of completion on doing an online training on this topic, Students of Computer Maintenance , or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity Career Path This Computer Maintenance course smoothens the way up your career ladder with all the relevant information, skills, and online certificate of achievements. After successfully completing the course, you can expect to move one significant step closer to achieving your professional goals - whether it's securing that job you desire, getting the promotion you deserve, or setting up that business of your dreams.  Course Curriculum Computer Maintenance Module 01 - Introduction to Computers Module 01 - Introduction to Computers 00:00 Computer Maintenance Module 02 - Structure of Computers Module 02 - Structure of Computers 00:00 Computer Maintenance Module 03 - Hardware Module 03 - Hardware 00:00 Computer Maintenance Module 04 - Software and Interface Module 04 - Software and Interface 00:00 Computer Maintenance Module 05 - Viruses and Computer Maintenance Module 05 - Viruses and Computer Maintenance 00:00 Computer Maintenance Module 06 - Internet and IT Module 06 - Internet and IT 00:00 Computer Maintenance Module 07 - Cyber Security Module 07 - Cyber Security 00:00

Computer Maintenance
Delivered Online On Demand7 hours
£25

Microsoft Excel 2019 - Advanced Level Training

By Compete High

🌟 Unlock the Full Power of Microsoft Excel 2019! 🌟 Ready to take your Excel skills to the next level? Dive into our comprehensive online course - 'Microsoft Excel 2019 - Advanced Level Training' - designed to transform you into an Excel maestro! 🚀 Here's What You'll Master: 📊 Section 1: Excel - Advanced - Get hands-on with advanced techniques and shortcuts to streamline your workflow. 📂 Section 2: Working with Multiple Workbooks - Seamlessly manage multiple workbooks and boost your productivity effortlessly. 🔒 Section 3: Protecting Worksheets and Workbooks - Learn how to safeguard your data with robust protection strategies. 📝 Section 4: Conditional Formulas - Unravel the power of conditional logic and unleash the true potential of formulas. 🧮 Section 5: Advanced Functions - Elevate your Excel expertise by mastering complex functions for data analysis. 📚 Section 6: Text Based Functions - Manipulate text effortlessly and efficiently with advanced text-based functions. 🔍 Section 7: What IF Tools - Explore the 'What If' analysis tools to make informed decisions and predictions. 🏁 Section 8: Excel Advanced - Conclusion - Wrap up with a comprehensive understanding and practical application of advanced Excel features. 🎁 Section 9: Bonus #1 - Advanced Pivot Tables - Delve into bonus content covering advanced techniques for Pivot Tables, a must-have skill for data analysis pros. 🌟 Why Choose Our Course? 🔐 Expert Guidance: Led by seasoned Excel professionals, ensuring clarity and depth in learning. 🔄 Practical Assignments: Apply your newfound skills through real-world exercises. 📈 Career Growth: Elevate your career prospects by mastering sought-after Excel abilities. 🌐 Accessible Learning: Study at your own pace from anywhere, anytime with our user-friendly online platform. 🤝 Join our vibrant community of learners dedicated to mastering Excel's advanced functionalities. 💡 Enroll now and revolutionize your Excel prowess with 'Microsoft Excel 2019 - Advanced Level Training'! Don't miss this chance to become an Excel wizard! 💡   Course Curriculum Section 1 - Excel - Advanced Excel Advanced Introduction 01:39 Advanced Shortcut Keys 02:58 Section 2 - Working with Multiple Workbooks Tracing Precedents 00:00 Tracing Dependants 00:00 Watch Window 00:00 Show Formulas 00:00 Section 3 - Protecting Worksheets and Workbooks Protecting Cells in a Worksheet 00:00 Protecting the Workbook Structure 00:00 Encryption with Passwords 00:00 Section 4 - Conditional Formulas Name Ranges 00:00 Simple IF Function 00:00 IF, AND 00:00 IF, OR 00:00 Nested Formulas 00:00 CountIF and CountIFs 00:00 SumIF and SumIFs 00:00 Section 5 - Advanced Functions Advanced VLookUp 00:00 IF and IS Error - Part 1 00:00 IF and IS Error - Part 2 00:00 Advanced Index Match 00:00 Dates - Part 1 00:00 Dates - Part 2 00:00 Replace and Substitute - Part 1 00:00 Replace and Substitute - Part 2 00:00 Section 6 - Text Based Functions Left, Right and Mid Function 00:00 Search Function 00:00 Concatenate and Search 00:00 Indirect - Static 00:00 Indirect - Dynamic 00:00 Section 7 - What IF Tools Goal Seek 00:00 Data Tables 00:00 Scenarios 00:00 Solver 00:00 Section 8 - Excel Advanced - Conclusion Excel Advanced - Conclusion 00:00 Section 9 - Bonus # 1 - Advanced Pivot Tables Building a Mini Dashboard 00:00

Microsoft Excel 2019 - Advanced Level Training
Delivered Online On Demand2 hours 34 minutes
£25

Functional IT Skills Training (ICT)

By Compete High

Overview   With the ever-increasing demand for Information Technology in personal & professional settings, this online training aims at educating, nurturing, and upskilling individuals to stay ahead of the curve - whatever their level of expertise in Information Technology may be.   Learning about Information Technology or keeping up to date on it can be confusing at times, and maybe even daunting! But that's not the case with this course from Compete High. We understand the different requirements coming with a wide variety of demographics looking to get skilled in Information Technology. That's why we've developed this online training in a way that caters to learners with different goals in mind. The course materials are prepared with consultation from the experts of this field and all the information on Information Technology is kept up to date on a regular basis so that learners don't get left behind on the current trends/updates.   The self-paced online learning methodology by compete high in this Basic IT Skills course helps you learn whenever or however you wish, keeping in mind the busy schedule or possible inconveniences that come with physical classes. The easy-to-grasp, bite-sized lessons are proven to be most effective in memorising and learning the lessons by heart. On top of that, you have the opportunity to receive a certificate after successfully completing the course!   Instead of searching for hours, enrol right away on this Basic IT Skills course from Compete High and accelerate your career in the right path with expert-outlined lessons and a guarantee of success in the long run.   Who is this course for?   While we refrain from discouraging anyone wanting to do this Basic IT Skills course or impose any sort of restrictions on doing this online training, people meeting any of the following criteria will benefit the most from it: Anyone looking for the basics of Information Technology, Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in Information Technology, Anyone looking for a certificate of completion on doing an online training on this topic, Students of Information Technology, or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity   Career Path   This Basic IT Skills course smoothens the way up your career ladder with all the relevant information, skills, and online certificate of achievements. After successfully completing the course, you can expect to move one significant step closer to achieving your professional goals - whether it's securing that job you desire, getting the promotion you deserve, or setting up that business of your dreams.  Course Curriculum Module 1: Introduction to Computers Introduction to Computers 00:00 Module 2: Structure of Computers Structure of Computers 00:00 Module 3: Hardware Hardware 00:00 Module 4: Software and Interface Software and Interface 00:00 Module 5: Viruses and Computer maintenance Viruses and Computer maintenance 00:00 Module 6: Internet and IT Internet and IT 00:00 Module 7: Cyber Security Cyber Security 00:00

Functional IT Skills Training (ICT)
Delivered Online On Demand7 hours
£25

Functional Skills Maths Level 2

By Compete High

Overview With the ever-increasing demand for Functional Skills in personal & professional settings, this online training aims at educating, nurturing, and upskilling individuals to stay ahead of the curve - whatever their level of expertise in Functional Skills may be. Learning about Functional Skills or keeping up to date on it can be confusing at times, and maybe even daunting! But that's not the case with this course from Compete High. We understand the different requirements coming with a wide variety of demographics looking to get skilled in Functional Skills . That's why we've developed this online training in a way that caters to learners with different goals in mind. The course materials are prepared with consultation from the experts of this field and all the information on Functional Skills is kept up to date on a regular basis so that learners don't get left behind on the current trends/updates. The self-paced online learning methodology by compete high in this Functional Skills course helps you learn whenever or however you wish, keeping in mind the busy schedule or possible inconveniences that come with physical classes. The easy-to-grasp, bite-sized lessons are proven to be most effective in memorising and learning the lessons by heart. On top of that, you have the opportunity to receive a certificate after successfully completing the course! Instead of searching for hours, enrol right away on this Functional Skills course from Compete High and accelerate your career in the right path with expert-outlined lessons and a guarantee of success in the long run. Who is this course for? While we refrain from discouraging anyone wanting to do this Functional Skills course or impose any sort of restrictions on doing this online training, people meeting any of the following criteria will benefit the most from it: Anyone looking for the basics of Functional Skills , Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in Functional Skills , Anyone looking for a certificate of completion on doing an online training on this topic, Students of Functional Skills , or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity Career Path This Functional Skills course smoothens the way up your career ladder with all the relevant information, skills, and online certificate of achievements. After successfully completing the course, you can expect to move one significant step closer to achieving your professional goals - whether it's securing that job you desire, getting the promotion you deserve, or setting up that business of your dreams.    Course Curriculum Functional Skills Maths Level 2 Module 01 Introduction Introduction 00:00 Functional Skills Maths Level 2 Module 2 Basic arithmetic Basic arithmetic 00:00 Functional Skills Maths Level 2 Module 3 Fractions Fractions 00:00 Functional Skills Maths Level 2 Module 4 Decimals Decimals 00:00 Functional Skills Maths Level 2 Module 5 Using a calculator Using a calculator 00:00 Functional Skills Maths Level 2 Module 6 Percentages Percentages 00:00 Functional Skills Maths Level 2 Module 7 Ratio and proportion Ratio and proportion 00:00 Functional Skills Maths Level 2 Module 8 Powers, roots and laws of indices Powers, roots and laws of indices 00:00 Functional Skills Maths Level 2 Module 9 Units, prefixes and engineering notation Units, prefixes and engineering notation 00:00

Functional Skills Maths Level 2
Delivered Online On Demand9 hours
£25

Diploma in Information Technology

4.3(43)

By John Academy

Description: Our Diploma in Information Technology establishes frameworks in figuring, computer equipment and engineering, web and multimedia technologies, operating frameworks and database advances. It is delivered as a hands-on practical experience and learning course with different computer technologies, in both individual and community oriented modes. It likewise gives appropriate section focuses on working in the IT business or entry into the second year of a relevant Bachelor course. In this course you will learn the necessary skills, knowledge and information about Information Technology.  Who is this course for? This course would be ideal for people who want be ideal for people who want to work in IT business. 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. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, 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 hard copy 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 Diploma In Information Technology course will be very beneficial and helpful, especially to the following professionals: Software Specialists Project Managers Technopreneurs IT Consultants IT Analyst Software Developer System and Network Administrator Technical Support Engineer Cloud Operation Engineer. Computer Fundamentals Basic Computer Terms 00:15:00 Advanced Terms 00:15:00 Networking Basics 00:15:00 Basic Internet Concepts 00:30:00 Internet Security 00:30:00 Computers in the Workplace 00:15:00 Tele-Commuting 00:15:00 The Electronic World 00:15:00 Ergonomics 00:15:00 Safety and the Environment 00:15:00 Being Proactive 00:15:00 Identifying Yourself 00:15:00 Protecting your Data 00:15:00 Understanding Malware 00:15:00 Protecting Against Malware 00:15:00 Computer Maintenance Introduction 00:15:00 Understanding The Components Of A PC 01:30:00 Do You Need To Upgrade Your PC? 01:00:00 Essential Softwares You Must Have On Your PC 01:00:00 Installing And Organizing Your PC 01:00:00 Troubleshooting Guidelines 01:00:00 How To Speak To A Technician 00:30:00 Summary 00:30:00 Computer Programming COMPUTER PROGRAMMING 101 01:00:00 WHAT IS COMPUTER PROGRAMMING AND WHY SHOULD I CARE? 00:30:00 What a Programmer Does 01:00:00 SOFTWARE LESSONS FOR BEGINNERS 01:00:00 Other Places to Find Computer Instruction 00:30:00 Comprehensive Computer Training for the Beginner 01:00:00 A Course in Computer Literacy 01:00:00 COMPUTER PROGRAMMING AT A GLANCE 01:00:00 UNDERSTANDING THE LANGUAGE OF THE COMPUTER 00:30:00 Computer Program Definitions 00:30:00 Choosing a Language 00:30:00 Computer Programming 01:00:00 Employment Outlook 00:15:00 How to Find A Great Job After Graduation 01:00:00 Computer Networking Basics Introduction to Computer Networking 00:30:00 Types of Computer Networks 01:00:00 Types of Network Equipment 00:30:00 Ethernet 00:30:00 Wireless Local Area Networking 01:00:00 Internet Service 01:00:00 TCP/IP and Other Internet Protocols 01:00:00 Network Routing, Switching and Bridging 01:00:00 IT Communication Basics of Computer Networking 00:30:00 Computer Networking Design and Solutions 00:30:00 Getting the Right Computer Network Hardware 00:30:00 Setting Up Your Computer Network 00:30:00 Wireless vs Wired 00:30:00 Cable Management for Wired Computer Network 01:00:00 Managing Your Network With Network Monitoring Tools 00:30:00 Computer Network Maintenance and Repair 00:30:00 Troubleshooting Computer Network Wrapping Up 01:00:00 Internet Security Internet Security- The Truth About Identify Theft 01:00:00 Internet Security for Teens- What You Need to Do 01:00:00 Internet Security-Downloading Email Attachments 00:15:00 Internet Security- 5 Tips for Using Facebook 00:30:00 Internet Security- 8 Tips to Protect Yourself When Dating Online 00:30:00 Internet Security for Teens and Tweens- 10 Tips to Keep You Protected 00:15:00 Internet Security- Parental Control Software 00:30:00 Internet Security- Online Safety for Your Children 00:30:00 Cyber Bullying- Another Aspect of Breaking Internet Security 00:30:00 Tips to Ensure Internet Security 00:30:00 Internet Security- Downloading Music off the Internet 01:00:00 Internet Security- Protect Your Wireless Connection 00:30:00 Internet Security- How to Deal with Spyware 00:15:00 Internet Security- Protecting Yourself When You Shop Online 00:15:00 Internet Security- Make Sure Your Passwords Protect You 00:15:00 Make Sure Your Emails Are Safe: Tips for Internet Security 01:00:00 Internet Security- Why Should You Use a Firewall? 01:00:00 Internet security-Signs That Your Child's Safety Might Be Compromised 01:00:00 Internet Security- Safety When Using Public Computers 01:00:00 Internet Security- Storing Your Password on Your Computer 01:00:00 Internet Security-Using Social Utility Sites 00:30:00 Recommended Reading Recommended Reading: Diploma in Information Technology 00:00:00 Mock Exam Mock Exam- Diploma In Information Technology 00:30:00 Final Exam Final Exam- Diploma In Information Technology 00:30:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

Diploma in Information Technology
Delivered Online On Demand48 hours
£25

Beginners Guide to Computers

By iStudy UK

Description: Computer operation can be difficult if you have no idea how to do it. However, it only takes a complete beginner course on the computer to learn how. You need to learn the basics, operation systems and how healthy computing works which this course provides. If you think you are ready to start your journey in learning all about the computer, then you don't have to wait for. Start learning now and understand why the computer is considered as a necessity in this modern age. Who is the course for? Beginner to advanced level users can benefit from the lessons we provide People who have an interest in learning about computer and computer maintenance 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. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, 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 hard copy 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 applying for NUS Extra Discount Card; 24/7 student support via email. Career Path: The Beginners Guide to Computers is a very useful qualification to possess, and will be very helpful to have especially for these careers: Computer Maintenance Staff IT Department Manager Computer Engineer Computer Specialist Computer Technician. Computer Basics Introduction FREE 00:15:00 Understanding The Components Of A PC FREE 01:30:00 Do You Need To Upgrade Your PC? 01:00:00 Essential Softwares You Must Have On Your PC 01:00:00 Installing And Organizing Your PC 01:00:00 Troubleshooting Guidelines 01:00:00 How To Speak To A Technician 00:30:00 Summary 00:30:00 Operating Systems Introduction 00:15:00 What is an Operating System? 00:30:00 History of Operating System 00:30:00 What an Operating System Does 01:00:00 Microsoft Windows 01:00:00 MAC OS 01:00:00 UNIX 00:30:00 LINUX 00:30:00 GNU 00:30:00 Other Operating Systems 01:00:00 Installing an Operating System 01:00:00 Defining The Processes 01:00:00 Conclusion 00:15:00 Healthy Computing Introduction 01:00:00 Body Position 01:00:00 Monitors 01:00:00 Keyboards 01:00:00 Mouse or Pointer 02:00:00 Document Holders and Desk 01:00:00 Chairs 02:00:00 Telephones 00:30:00 What Have We Learned 01:00:00 Work Process and Recognition 01:00:00 Lighting 01:00:00 Ventilation 00:30:00 Awkward Postures 02:00:00 Musculoskeletal Disorders (MSD) 02:00:00 4 Steps to Setting Up The Computer Workstation 01:00:00 Exercises and Breaks 01:00:00 Conclusion 00:15:00 Mock Exam Final Exam

Beginners Guide to Computers
Delivered Online On Demand35 hours
£25