5935 Computing & IT courses

Level 3 & 5 Endorsed Diploma | QLS Hard Copy Certificate Included | Plus 5 CPD Courses | Lifetime Access

Level 3 & 5 Endorsed Diploma | QLS Hard Copy Certificate Included | Plus 5 CPD Courses | Lifetime Access

Excel Advanced Course, 1-Day. Who should attend: Excel Advanced is for Excel Experts: Your work daily with Excel and your work revolves around spreadsheets and Excel databases. Course Details: Location: Instructor-led, Online. Our Style: Hands-on, Practical Course. Group Size: Max 4 people per group. Qualification: PCWorkshops Excel Advanced Certification Hours: 1 Day, 10am-5pm Delivery Style: 1-1, because we understand that individuals have varying skill levels and varying applications. Excel Advanced Course Description General Editing Standard Formatting Rules Input Validate rules Using Formulas in Conditional Formatting Group and Outline Filter and Sorting Excel Tables and Advanced Filter Working with Excel tables Copy specific datasets from sheets, workbooks or external data Consilidate Goal seek, consolidate and scenarios Using Form Templates Creating Templates Advanced Excel Lookup Functions VLookup Function Hlookup Function Using the Index Function, Using the Match Function, Index and Match Together Using the Indirect Function Excel Advanced Functions Using Error Functions, Logical Functions, Array Functions, Rounding Functions Advanced Excel Pivot Table Tools Importing Pivot Table Data, Calculated Fields in Pivot Tables, Showing Pivot Data as a Percentage, Creating Custom Pivot Tables Styles Pivot Charts Excel Macros Creating, amending and deleting macros Running macros Macro menus, toolbars and shortcuts Alternative Excel Courses Inlcuded with the Excel Advanced Course PCWorkshops Excel Advanced Certificate on completion Excel Advanced Notes Excel Code Examples Practical Excel Advanced exercises Personalised attention in a 1-1 session About us Our experienced trainers are award winners. FAQ's Client Comments

Information Technology (IT) is a vast and growing field that offers many opportunities for career growth. Whether you're a student or a professional, there's an IT career path that's right for you. The skills required to succeed in IT are continuously changing because the industry is continually evolving. Therefore, being open to learning new things and adjusting to the most recent technologies is necessary if you want to stay ahead of the curve. If you're thinking about working in IT, here is an easy way to get started. You can take these online information technologies (IT) training courses. In this package, you will receive 11 premium courses, an original hard copy, and 11 PDF certificates (Main Course + Additional Courses) in addition to this IT bundle. Learning Outcomes Master functional skills in IT to be able to troubleshoot problems Learn about the hardware, software, computer network, operating systems etc Familiarise with ethical hacking, become well versed in cyber security Master CompTIA networking and learn how to build up a secure network Learn the basics of Linux and complete Windows 10 troubleshooting for the IT helpdesk tasks Understand information management, GDPR data protection and much more throughout this bundle IT is a fast-growing field, and the demand for skilled professionals is increasing every day. So sign up for our IT training bundle today, get ahead, and start your career. This IT Courses Bundle Consists of the following Premium courses: Course 1: Functional Skills IT Course 2: Ethical Hacking Course 3: Level 3 Cyber Security Course 4: CompTIA Networking - Level 4 Course 5: Network Security Level 2 Course 6: Secure Programming of Web Applications Course 7: Linux for Absolute Beginners! Course 8: Complete Windows 10 Troubleshooting for IT HelpDesk Course 9: Information Management Course 10: GDPR Data Protection Level 5 Course 11: Decision-Making and Critical Thinking Enrol now in IT Courses To advance your career and use the premium study materials from Apex Learning. The IT bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your IT Courses Expertise and essential knowledge, which will assist you in reaching your goal. Certificate: PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) CPD 125 CPD hours / points Accredited by CPD Quality Standards Who is this course for? It is recommended for anyone interested in learning more about this topic. Requirements This IT Training course has been designed to be fully compatible with tablets and smartphones. Career path Your resume will be more valuable if you have this knowledge, and you'll be more employable in various IT-related fields. Like as: Learning and Development Trainer Systems Administrator IT Security Service Desk Analyst Information Technology Specialist In the UK, an information technology specialist makes an average salary of £36,290 per year.

This IT Support Technician course aims to teach you the fundamentals of 12 critical IT Topics in a simple and brain-friendly way. This is the place to start if you aim for an IT Support/HelpDesk/Technician career. At the end of this course, you will be able to apply for jobs and face interviews confidently. If you are already working in an IT role, you will be able to progress forward in your career by cementing your foundations. These fundamentals will bring clarity to many functions that you already do daily and propel you to be the technician everyone looks up to. Furthermore, to help you showcase your expertise in IT Support Technician, we have prepared a special gift of 1 hardcopy certificate and 1 PDF certificate for the title course completely free of cost. These certificates will enhance your credibility and encourage possible employers to pick you over the rest. This IT Support Technician Bundle Consists of the following Premium courses: Course 01: IT Support Technician Training Course 02: Functional Skills IT Course 03: Encryption Course 04: Cloud Computing / CompTIA Cloud+ (CV0-002) Course 05: Learning Computers and Internet Level 2 Course 06: Windows 10 Pro Complete Training Course 07: Building Your Own Computer Course 08: Level 3 Cyber Security Course 09: Secure Programming of Web Applications Course 10: Data Center Training Essentials: General Introduction Course 11: Information Management Course 12: GDPR Data Protection Level 5 Course 13: Cisco ASA Firewall Training Course 14: Level 2 Microsoft Office Essentials Benefits you'll get choosing Apex Learning: One payment, but lifetime access to 14 CPD courses Certificates, student ID for the title course included in a one-time fee Full tutor support available from Monday to Friday Free up your time - don't waste time and money travelling for classes Accessible, informative modules taught by expert instructors Learn at your ease - anytime, from anywhere Study IT support the course from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills Curriculum of Bundle IT Support Technician Training 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 Configuring Network and Internet Connectivity IT Security Threat Mitigation Computer Maintenance and Management IT Troubleshooting Understanding Databases Developing and Implementing Software How will I get my Certificate? After successfully completing the course, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (For The Title Course) Hard Copy Certificate: Free (For The Title Course) If you want to get hardcopy certificates for other courses, generally you have to pay £20 for each. But this Fall, Apex Learning is offering a Flat 50% discount on hard copy certificates, and you can get each for just £10! P.S. The delivery charge inside the U.K. is £3.99 and the international students have to pay £9.99. CPD 165 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this IT Support Technician bundle. Requirements Our IT Support Technician is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. Certificates Certificate of completion Digital certificate - Included

Portfolio, Programs, & Project Offices Practitioner: Virtual In-House Training P3O® is the AXELOS standard for the design of decision-making processes regarding changes in organizations. P3O provides a guideline for the design of portfolio, programme, and project offices in organizations. The P3O Practitioner Course is an interactive learning experience. The P3O Practitioner-level content provides you with sufficient knowledge and understanding of the P3O guidance to design, implement, manage or work within any component office of a P3O model. It enables participants to successfully complete the associated P30 Practitioner exam and achieve the qualification. In this course, you will be prepared to successfully attempt the P3O Practitioner exam and learn how to implement or re-energize a P3O model in their own organization. What you will Learn At the end of the P3O Practitioner course, you will be able to: Define a business case to get senior management approval for P3O Build a right P3O model to adapt to the organization's needs, taking account of the organization's size and portfolio, programme and project management maturity Identify the elements, roles, and functions deployed in a generalized P3O model Use tools and techniques in running the P3O and advising those who shape the portfolio of programmes and projects Introduction to P3O What is the purpose of P3O? Definitions What are P3Os? Portfolio, programme, and project lifecycles Governance and the P3O Designing a P3O Model Factors that affect the design Design considerations What functions and services should the P3O offer? Roles and responsibilities Sizing and tailoring of the P3O model Why have a P3O? How a P3O adds value Maximizing that value Getting investment for the P3O Overcoming common barriers Timescales Why have a P3O (Extension)? The P3O Business Case The P3O Model Blueprint Vision Statement Demonstrating the Value KPIs The Benefits of Claimed Capabilities Benefit Realisation and Strategic Objectives Benefit Profile How to Implement or Re-Energize a P3O Implementation lifecycle for a permanent P3O Identify Define Deliver Close Implementation lifecycle for a temporary programme or project office Organizational context Definition and implementation Running Closing Recycling How to operate a P3O Overview of tools and techniques Benefits of using standard tools and techniques Critical success factors P3O tools P3O techniques

This course will teach you how Selenium WebDriver is used to test web applications. You will start by understanding the concepts of Java and gradually move toward understanding Selenium, TestNG framework, Maven, Jenkins, Cucumber, Gherkin, and a lot more interesting topics that will make you a pro in automation testing.

Agile Sprint Planning: In-House Training The goal of the course is to provide you and your team with the ability to develop effective and realistic Sprint plans. Without effective Sprint Plans, iterations are set up for failure. But Sprint Planning cannot be improved on its own, in isolation. The Scrum processes are highly intertwined and influence each other. The surrounding artifacts, events, and roles must be examined closely, and enhanced, in order to improve Sprint Planning. This course will remind you of the theory to reinforce the principles, but will concentrate on next-level skills, so that you and the team are able to create realistic and usable Sprint Plans. This course is not introductory. You are already aware of the Scrum framework and have been implementing Scrum on your projects. Now is the time to improve efficiency and effectiveness, to facilitate successful Agile projects. What you will Learn You'll learn how to: Identify and correlate the key symptoms and root causes of ineffective sprint plans Improve key Product Backlog elements Evaluate Agile roles in sprint planning Appraise key product practices Enhance project transparency The Product Backlog User stories Acceptance Criteria Backlog Refinement Supporting Roles Product Owner (the Backlog) Development Team Stakeholders and SMEs Supporting Product Practices Roadmaps and release plans and story maps Definition of Done Technical Debt Transparency Daily Scrums Information radiators Retrospectives Sprint Planning Capacity and Velocity Sprint Planning Meetings The Sprint Backlog Summary What did we learn, and how can we implement this in our work environments?

Duration 2 Days 12 CPD hours This course is intended for The audience for this course is anyone who wants to acquire foundation level knowledge on data centre infrastructure. This course is ideally suited for data centre new hires, internal data centre support staff, IT support staff who work in the data centre, helpdesk staff, vendors/suppliers who install/maintain data centre equipment, building maintenance staff including data centre cleaners and other supporting functions, and fresh graduates. This course is also well suited for individuals working in data centre business support functions such as sales/pre-sales, HR, Finance and business administration. Overview The DCFC course will prepare participants for entry into the exciting and high-growth data centre industry. It will ensure that participants acquire the required basic knowledge to take on a wide variety of jobs in the data centre industry. It will also provide the required knowledge and skill to further their training into specialised areas on data centre design/build, operations/governance or standards/compliance. The Data Centre Foundation Certificate (DCFC©) is a 2-day course designed to deliver foundation knowledge about data centre facilities infrastructure. It provides participants with global overview and knowledge on data centres which will be of advantage to the participants who are looking at joining the ranks of professionals working in the data centre, ICT, infrastructure or the mechanical and electrical (M&E) design industries. It will also form a solid foundation for participants who wish to pursue his/her studies either academically or to further his/her industry specialisation with professional certification courses on data centre design/build, operations/governance and/or standards/compliance. With the tremendous growth of data and the data centres to support it, the demand for data centre professionals will grow in tandem. Introduction to Data Centres History of data centres Definition of different type data centres Data Centre Standards List of standards Rating definitions Data Centre Facilities Areas Listing of all areas and their functions Topology Designs Definition of Ratings Components of the Power Infrastructure Utility power Transformers Generators Fuel systems ATS UPS systems Batteries Electric panels Cabling/busbar systems Power rails/strips Lights Lights Emergency lights Cooling Infrastructure Chillers DX Systems Evaporators CRAC/CRAU/HVAC Raised floor Non-raised floor Containment ICT/Network Infrastructure Equipment racks Network cabling (fibre, copper) Cable trays and pathways TIA-606 labelling Data Centre Security Perimeter security Physical protection CCTV Access control Security management Fire Suppression Detection systems Suppression systems Prevention systems Fire extinguishers Fire Safety Monitoring and reporting DCIM EMS/BMS

RESILIA Foundation Passport: On-Demand The RESILIA Foundation qualification takes participants through a lifecycle approach to organizational cyber resilience, from creating a strategy aligned to business objectives through to operational cyber resilience activities. The course is suitable for anyone who needs an awareness of how to protect an organization's information assets, as well as how to recover from a cyber breach. What You Will Learn At the end of this course, you will be able: Demonstrate your knowledge of the purpose, benefits, and key terms of cyber resilience Demonstrate your knowledge of the risk management and the key activities needed to address risks and opportunities Demonstrate your knowledge of the purpose of a management system and how best practices and standards can contribute Demonstrate your knowledge of the cyber resilience strategy, the associated control objectives, and their interactions with ITSM activities Demonstrate your knowledge of cyber resilience design, the associated control objectives, and their interactions with ITSM activities Demonstrate your knowledge of cyber resilience transition, the associated control objectives, and their interactions with ITSM activities Demonstrate your knowledge of cyber resilience operation, the associated control objectives, and their interactions with ITSM activities Demonstrate your knowledge of cyber resilience continual improvement, the associated control objectives, and their interactions with ITSM activities Demonstrate your knowledge of the purpose and benefits of segregation of duties and dual controls Course Introduction Introduction to Cyber Resilience Risk Management Managing Cyber Resilience Cyber Resilience Strategy Cyber Resilience Design Cyber Resilience Transition Cyber Resilience Operation Cyber Resilience Continual Improvement Cyber Resilience Roles & Responsibilities