5829 Computing courses in Amesbury delivered Online

Duration 2 Days 12 CPD hours This course is intended for SAP professionals Overview Explain the motivation and need for a next generation business suite and how SAP S/4HANA enables a digital organizationDescribe the SAP S/4HANA business and technical architectureGain basic knowledge about SAP Activate to accelerate SAP S/4HANA adoptionExplain how SAP S/4HANA supports the business users with a new user experience (e.g.: SAP Fiori UX)Describe key business processes of SAP S/4HANA Enterprise ManagementExplain SAP S/4HANA embedded analytics capabilitiesGain basic knowledge about SAP S/4HANA LoB solutions and add-on supportDescribe integration scenarios between SAP S/4HANA and SAP Cloud solutions In this course, students learn a broad range of topics including the motivation behind the development of SAP S/4HANA. Course Outline Introduction to SAP S/4HANA SAP S/4HANA user experience SAP HANA powers SAP S/4HANA SAP Activate for SAP S/4HANA SAP S/4HANA Enterprise Management, LoB solutions and add-ons SAP S/4HANA embedded analytics Integration between SAP S/4HANA Core and SAP Cloud solutions Additional course details: Nexus Humans S4H01 SAP Business Suite to SAP S/4HANA Delta training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the S4H01 SAP Business Suite to SAP S/4HANA Delta course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 5 Days 30 CPD hours This course is intended for Network security engineers Network security architects ISE administrators Senior Security Operations Center (SOC) personnel responsible for Incidence Response Cisco integrators and partners Overview After taking this course, you should be able to: Describe the Cisco Identity Services Engine (ISE) Explain Cisco ISE deployment Describe Cisco ISE policy enforcement components Describe Cisco ISE policy configuration Troubleshoot Cisco ISE policy and third-party Network Access Device (NAD) support Configure guest access Configure hotspots and guest portals Describe the Cisco ISE profiler services Describe profiling best practices and reporting Configure a Cisco ISE BYOD solution Configure endpoint compliance Configure client posture services Configure Cisco ISE device administration Describe Cisco ISE TrustSec configurations The Implementing and Configuring Cisco Identity Services Engine (SISE) v4.0 course teaches you to deploy and use Cisco© Identity Services Engine (ISE) v3.x, an identity and access control policy platform that simplifies the delivery of consistent, highly secure access control across wired, wireless, and VPN connections. This hands-on course provides you with the knowledge and skills to implement and apply Cisco ISE capabilities to support use cases for Zero Trust security posture. These use cases include tasks such as policy enforcement, profiling services, web authentication and guest access services, BYOD, endpoint compliance services, and Terminal Access Controller Access Control Server (TACACS+) device administration. Through hands-on practice via lab exercises, you will learn how to use Cisco ISE to gain visibility into what is happening in your network, streamline security policy management, and contribute to operational efficiency. This course helps you prepare to take the Implementing and Configuring Cisco Identity Services Engine (300-715 SISE) exam, which leads to CCNP© Security and the Cisco Certified Specialist - Security Identity Management Implementation certifications. This course also earns you 40 Continuing Education (CE) credits toward recertification Course Outline Introducing Cisco ISE Architecture Introducing Cisco ISE Deployment Introducing Cisco ISE Policy Enforcement Components Introducing Cisco ISE Policy Configuration Troubleshooting Cisco ISE Policy and Third-Party NAD Support Introducing Web Authentication and Guest Services Configuring Hotspots and Guest Portals Introducing the Cisco ISE Profiler Introducing Profiling Best Practices and Reporting Configuring Cisco ISE BYOD Introducing Cisco ISE Endpoint Compliance Services Configuring Client Posture Services and Compliance Working With Network Access Devices Exploring Cisco TrustSec Additional course details: Nexus Humans Cisco Implementing and Configuring Cisco Identity Services Engine v4.0 (SISE) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Cisco Implementing and Configuring Cisco Identity Services Engine v4.0 (SISE) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 3 Days 18 CPD hours In this 3 day customized Intermediate SQL course students will learn additional commands and functions using labs/activities/content that correlates with this content. By understanding SQL, you get the knowledge of fundamental queries associated with data management so that you can verify, monitor, and control all the activities operating in the database. Lesson 1 Substring Instr / CharIndex Convert (data types and with Formatting) Replace RowCount / RowNum / Top )n) ÿ(Oracle/SQL Server functions) Case / If Then Else statements Exists Clause Find Duplicates using Group by and have clause (and other tips for analyzing data) Lesson 2 Set operations (UNION, UNION ALL, INTERSECT, MINUS) GROUP BY extensions (ROLLUP, CUBE, and GROUPING SETS) Loops / Cursors Common Table Expressions (CTEs) Lesson 3 Temp Tables / Views Advanced Subqueries Regular Expressions (RegEx) Linked Server Queries Qualified subquery predicates Aggregate functions Optimizing queries SQL Injection Lesson 4 JSON Parsing With Partition By With Over Fuzzy Logic - MDS.mdq.[Similarity]ÿ Additional course details: Nexus Humans Intermediate SQL Custom 3-Day Private Class Outline training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Intermediate SQL Custom 3-Day Private Class Outline course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 2 Days 12 CPD hours This course is intended for This course is designed for security administrators and Check Point resellers who need to manage and monitor issues that may occur within their Security Management environment. Overview Understand how to use Check Point resources for support. Understand how to perform packet captures using tcmdump and FW Monitor command tools. Understand the basic process of kernel debugging, and how debug commands are structured. Recognize how to use various Linux commands for troubleshooting system issues. Recognize communication issues that may occur between SmartConsole and the SMS and how to resolve them. Understand how to troubleshoot SmartConsole login and authentication issues. Understand how to prevent and resolve licensing and contract issues. Understand how to troubleshoot issues that may occur during policy installation. Understand communication issues that may occur when collecting logs and how to resolve them. Recall various tools to use when analyzing issues with logs. Understand how to restore interrupted communications during heavy logging. Understand how NAT works and how to troubleshoot issues. Understand Client Side and Server Side NAT. Understand how the Access Control Policy functions and how the access control applications work together. Understand how to troubleshoot issues that may occur with Application Control and URL Filtering. Understand how the HTTPS Inspection process works and how to resolve issues that may occur during the process. Understand how to troubleshoot Content Awareness issues. Recognize how to troubleshoot VPN-related issues. Understand how to monitor cluster status and work with critical devices. Recognize how to troubleshoot State Synchronization. Understand how to troubleshoot communication issues between Identity Sources and Security Gateways. Understand how to troubleshoot and debug issues with internal Identity Awareness processes. The goal of this course is to provide an understanding of the concepts and skills necessary to troubleshoot issues which may occur when managing the Check Point Security Management architecture and Security Gateways. Course Outline An Introduction to Troubleshooting SmartConsole and Policy Management Troubleshooting Monitoring Logging Activity Troubleshooting Issues with NAT Understanding the Unified Access Control Policy Basic VPN Troubleshooting Monitoring ClusterXL Connections Understanding Identity Awareness Additional course details: Nexus Humans CCTA Check Point Troubleshooting Administration training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the CCTA Check Point Troubleshooting Administration course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 5 Days 30 CPD hours This course is intended for This course is intended for Developers and architects who will be developing applications for iOS devices. In this course you'll be shown a complete introduction to iPhone and iPad development, emphasizing the newest technologies and best practices for iOS. Introduction & Setup Start Here Joining the Apple iOS Developer Program Installing Xcode and the iOS SDK A Guided Tour of Xcode An Introduction to Xcode Playgrounds Swift Programming Language Swift Data Types, Constants, and Variables Swift Operators and Expressions Swift Flow Control The Swift Switch Statement An Overview of Swift Functions The Basics of Object Oriented Programming in Swift An Introduction to Swift Subclassing and Extensions Working with Array and Dictionary Collections in Swift Understanding Error Handling in Swift Views, Layouts, & Storyboards iOS Application and Development Architecture Creating an Interactive iOS App Understanding Views, Windows and the View Hierarchy An Introduction to Auto Layout in iOS Working with iOS Auto Layout Constraints in Interface Builder Implementing iOS Auto Layout Constraints in Code Implementing Cross-Hierarchy Auto Layout Constraints in iOS Understanding the iOS Auto Layout Visual Format Language Using Trait Variations to Design Adaptive User Interfaces Using Storyboards in Xcode An Overview of iOS Table Views Using Xcode Storyboards to Build Dynamic TableViews Implementing TableView Navigation Working with the iOS Stack View Class A Guide to Multitasking in iOS Implementing a Page based iOS Application using UIPageViewController Data Storage with Files, iCloud, & Databases Working with Directories in Swift on iOS Working with Files in Swift on iOS Preparing an iOS App to use iCloud Storage Managing Files using the iOS UIDocument Class Using iCloud Storage in an iOS Application Synchronizing iOS Key-Value Data using iCloud iOS Database Implementation using SQLite Working with iOS Databases using Core Data CloudKit Data Storage on iOS Touch, Taps, & Gestures An Overview of iOS Multitouch, Taps and Gestures An Example iOS Touch, Multitouch and Tap Application Detecting iOS Touch Screen Gesture Motions Identifying Gestures using iOS Gesture Recognizers iOS 3D Touch Implementing TouchID Authentication in iOS Apps Advanced View Options Drawing iOS 2D Graphics with Core Graphics Interface Builder Live Views and iOS Embedded Frameworks Using Core Graphics and Core Image iOS Animation using UIViewPropertyAnimator iOS UIKit Dynamics iOS Sprite Kit Programming iOS Multitasking, Background Transfer Service and Fetching iOS Application State Preservation and Restoration Integrating Maps into iOS Applications Getting Location Information using the iOS Core Location Framework Extensions An Introduction to Extensions in iOS An iOS Today Extension Widget Tutorial Creating an iOS Photo Editing Extension Creating an iOS Action Extension Receiving Data from an iOS Action Extension Building iOS Message Apps Using Event Kit to Create Date and Location Based Reminders Multimedia and Social Media Accessing the iOS Camera and Photo Library iOS Video Playback using AVPlayer and AVPlayerViewController An iOS Multitasking Picture in Picture Tutorial Playing Audio on iOS using AVAudioPlayer Recording Audio on iOS with AVAudioRecorder iOS Speech Recognition Introduction to SiriKit Integrating Twitter and Facebook into iOS Applications The App Store Making Store Purchases with SKStoreProductViewController Class Building In-App Purchasing into iOS Applications Configuring and Creating App Store Hosted Content for iOS In-App Purchases Preparing and Submitting an iOS Application to the App Store Additional course details: Nexus Humans iOS App Development Essentials training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the iOS App Development Essentials course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 5 Days 30 CPD hours This course is intended for This is a basic-level programming course designed for attendees with prior development experience in another language, such as COBOL, 4GL, Mainframe or other non-object oriented languages. This course is not geared for non-developers. Overview This 'skills-centric' course is about 50% hands-on lab and 50% lecture, designed to train attendees in core OO coding and Java development skills, coupling the most current, effective techniques with the soundest industry practices. Our engaging instructors and mentors are highly experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Working within in a hands-on learning environment, guided by our expert team, attendees will learn to: Understand what OO programming is and what the advantages of OO are in today's world Work with objects, classes, and OO implementations Understand the basic concepts of OO such as encapsulation, inheritance, polymorphism, and abstraction Understand not only the fundamentals of the Java language, but also its importance, uses, strengths and weaknesses Understand the basics of the Java language and how it relates to OO programming and the Object Model Work with the Modular system (Project Jigsaw) Understand and use classes, inheritance and polymorphism Understand and use collections, generics, autoboxing, and enumerations Process large amount of data using Lambda expressions and the Stream API Abstract, static and private methods in interfaces Take advantage of the Java tooling that is available with the programming environment being used in the class Java 11 features covered: Using the Local Variable Type in Lambda expressions; Updates made to the String API This course provides hands-on Java 11 training for developers who have little or no prior working knowledge of object-oriented programming languages such as C, COBOL, and 4GL. You will learn the best practices for writing great object-oriented programs in Java 11, using sound development techniques, new improved features for better performance, and new capabilities for addressing rapid application development. Special emphasis is placed on object oriented concepts and best practices. A First Look The Java Platform Using the JDK The Eclipse Paradigm Getting Started with Java Writing a Simple Class Adding Methods to the Class OO Concepts Object-Oriented Programming Inheritance, Abstraction, and Polymorphism Essential Java Programming Language Statements Using Strings Specializing in a Subclass Fields and Variables Using Arrays Local-Variable Type Inference Java Packages and Visibility Object Oriented Development Inheritance and Polymorphism Interfaces and Abstract Classes Introduction to Exception Handling Exceptions Java Developer's Toolboxÿ Utility Classes Java Date/Time Advanced Java Programming Introduction to Generics Lambda Expressions and Functional Interface Working with Collections Collections Using Collections Stream APIÿ Streams Collectors The Java Module System Introduction to the Module System Time Permitting Formatting Strings Introduction to Annotations Java 12 and beyond Additional course details: Nexus Humans Basic Java 11 and OO Programming for Developers New to OO (TT2120-J11) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Basic Java 11 and OO Programming for Developers New to OO (TT2120-J11) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

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

Description: Corel Quattro Pro X3 is a spreadsheet program; it is practically designed for storing, calculating and analyzing massive amount of data in an efficient way. In this {course_title] you will learn the basic concepts that revolves around this program. Spreadsheet applications are essential for running any office work. In this course, you will start off with an introduction in the basic functions and interactions with the program. After learning the basics, you will categorically move up through the hierarchy to advanced levels. This course will sharpen your skills and help you in the professional field. Learning Outcomes: Review common spreadsheet applications, opening and closing the spreadsheet application Creating a blank spreadsheet, entering, editing and deleting data Creating a spreadsheet from a template, saving it multiple times, changing default directory, opening and closing the program, and switching between open spreadsheets Utilizing the editing tools like select, undo, cut, copy, changing cell dimensions, sort and other related options Using zoom, showing and hiding toolbars, locking and unlocking rows and columns, changing basic options Inserting, naming, deleing, moving and copying worksheets Creating basic formulas, identifying errors, using cell referencing, advanced formulas and IF functions Formatting cells to include decimals, commas, date, currency, percentage; while also changing font size, type and adding effects More formatting options through quick format, text wrapping, aligning cell contents, centring titles, modifying cell orientation and applying borders and shading Creating a chart and changing its titles, background colour, and colour of other chart elements; also find out how to edit charts through the cut, copy, paste, resize, move and delete options Setting up worksheet by modifying margins, orientation, paper size and fitting the worksheet into a page How to prepare to print and carry out the printing job by creating header and footers and using print preview respectively, and explore many other related options 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? Corel Quattro Pro X3 Application 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 Corel Quattro Pro X3 Application 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. Spreadsheet Basics Getting Started 01:00:00 Creating a Spreadsheet 00:15:00 Working with Files 01:00:00 Editing Tools Part 1 00:15:00 Editing Tools, Part 2 01:00:00 Viewing Tools 00:30:00 Working With Spreadsheets Working with Worksheets 00:15:00 Working With Formulas 00:30:00 Formatting Cells 00:15:00 Advanced Formatting 00:30:00 Advanced Spreadsheet Tasks Creating a Basic Chart 01:00:00 Editing Charts 00:15:00 Setting up the Worksheet 00:15:00 Preparing to Print 00:30:00 Printing the Worksheet 00:15:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 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

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