2078 IT Certifications courses delivered Online

Whether you use excel for work or study, this online course covers beginner, intermediate and advanced lessons in excel. This course is designed to enable you to analyse lots of data and tell a story quickly and interactively. Explore various time-saving Formulas, create automated reports with the press of a button, amaze your manager with professional Excel Charts and get noticed by top management & prospective employers. Course Highlights Certified Diploma in Microsoft Excel is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Certified Diploma in Microsoft Excel into 39 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 1 day, 9 hours hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Certified Diploma in Microsoft Excel Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Certified Diploma in Microsoft Excel is CPD certified and IAO accredited. 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 backgrounds. Requirements Our Certified Diploma in Microsoft Excel 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 You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Microsoft Excel for Beginners Module One - Getting Started FREE 00:30:00 Module Two - Opening Excel FREE 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Worksheet 01:00:00 Module Five - Viewing Excel Data 01:00:00 Module Six - Building Formulas 01:00:00 Module Seven - Using Excel Functions 01:00:00 Module Eight - Using Quick Analysis 01:00:00 Module Nine - Formatting Your Data 01:00:00 Module Ten - Using Styles, Themes, and Effects 01:00:00 Module Eleven - Printing and Sharing Your Workbook 01:00:00 Module Twelve - Wrapping Up 01:00:00 Activities - Microsoft Excel for Beginners CPD & IAO Accredited 00:00:00 Microsoft Excel - Intermediate Level Module One - Getting Started 00:30:00 Module Two - Working with Permissions and Options 00:30:00 Module Three - Sharing Workbooks 00:30:00 Module Four - Performing Advanced Formula and Function Tasks 00:30:00 Module Five - Working with Array Formulas 01:00:00 Module Six - Working With Macros 00:30:00 Module Seven - Working With Forms 00:30:00 Module Eight - Applying Advanced Chart Features 01:00:00 Module Nine - Working With Slicers and Timelines 00:30:00 Module Ten - Working With Multiple Tables, Relationships and External Data 00:30:00 Module Eleven - Working With PowerView 00:30:00 Module Twelve - Wrapping Up 01:00:00 Activities- Microsoft Excel Intermediate Level CPD & IAO Accredited 00:00:00 Microsoft Excel - Advanced Level Module One - Getting Started FREE 01:00:00 Module Two - SmartArt and Objects FREE 01:00:00 Module Three - Auditing 01:00:00 Module Four - Creating Charts 01:00:00 Module Five - Working with Charts 01:30:00 Module Six - Creating Pivot Tables and Pivot Charts 01:00:00 Module Seven - Macros 01:00:00 Module Eight - Solving Formula Errors 01:00:00 Module Nine - Using What If Analysis 01:00:00 Module Ten - Managing Your Data 02:00:00 Module Eleven - Grouping and Outlining Data 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft Excel Advanced CPD & IAO Accredited 00:00:00 Mock Exam Mock Exam- Certified Diploma in Microsoft Excel 00:30:00 Final Exam Final Exam- Certified Diploma in Microsoft Excel 00:30:00

Thinking about learning about Knowledge-Based Systems? The BCS Foundation Certificate in Artificial Intelligence teaches learners to recognise Knowledge-Based Systems (such as chat bots), gain an understanding of how they work, and consider how they can add value to an organisation. This award will also enable candidates to understand the concept of Uncertainty and Fuzzy Logic, and how Knowledge-Based Systems can be used to help organisations to make decisions and act where there is higher level of uncertainty. You will learn an understanding of Knowledge-Based Systems and their role within AI, the use of rules within a Knowledge-Based System, an understanding of the principles of case-based reasoning, an understanding of uncertainty and the use of fuzzy logic and an understanding of the role of the inference engine.

Duration 3 Days 18 CPD hours Overview ?The OS X Sierra troubleshooting process?How to use OS X Sierra tools and resources to troubleshoot OS X Sierra?OS X Sierra features and functionality, including how to find more information about OS X Sierra?How to prepare for Apple Certified Support Professional (ACSP) 10.12 certification In this course students will receive an in-depth exploration of troubleshooting on OS X Sierra. Installation and Configuration Install OS X Sierra Setup and Configuration OS X Recovery OS X Software Updates User Accounts User Accounts User Home Folders System Security Keychain Management File Systems File Systems and Storage FileVault 2 Permissions and Sharing File System Troubleshooting SIP Data Management Hidden Items and Shortcuts System resources Metadata and Spotlight File Archives Time Machine Applications and Processes Application Installation Document Management Application Management and Troubleshooting Network Configuration Network Essentials Advanced Network Configuration Network Troubleshooting Network Services Network Services Host Sharing and Personal Firewall System Management Peripherals and Drivers Print and Scan System Troubleshooting Additional course details: Nexus Humans Sierra 101 - OS X Support Essentials 10.12 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 Sierra 101 - OS X Support Essentials 10.12 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.

Unlock the power of information with our comprehensive course on Information Management Fundamentals. Whether you're a seasoned professional or just starting your journey in the world of data, this course will equip you with essential knowledge and skills to navigate the complexities of information management. Key Features: CPD Certified Free Certificate Developed by Specialist Lifetime Access In the course "Information Management Fundamentals," learners delve into various aspects of handling and utilizing information effectively. They start by understanding the basics of information management, including its importance and how it is applied in different contexts. They explore management information systems, learning how organizations use technology to gather and process data for decision-making. Diving deeper, learners study databases and how information is organized and retrieved efficiently. They also examine strategies for managing information within an organization, focusing on planning and implementation. Ethical considerations are another crucial aspect covered, including issues related to data protection and social responsibility when handling information. Finally, learners gain insights into auditing information systems, ensuring they understand how to assess and improve information management practices. Throughout the course, emphasis is placed on practical applications and ethical considerations to prepare learners for roles where they manage and utilize information responsibly and effectively. Course Curriculum Module 01: Introduction to Information Management Module 02: Management Information Systems Module 03: Databases and Information Management Module 04: Information Management Strategy Module 05: Ethical and Social Issues and Data Protection Module 06: Auditing Information Systems Learning Outcomes: Understand foundational concepts in Information Management and its importance in organisations. Analyse the role of Management Information Systems in enhancing business operations. Evaluate different types of databases used in effective information management. Formulate strategies for efficient Information Management within organisational contexts. Examine ethical and social implications concerning data protection and privacy. Apply auditing techniques to assess the effectiveness of Information Systems. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? IT professionals seeking deeper insights into information management strategies. Business managers aiming to enhance organisational data handling capabilities. Students pursuing careers in data analysis and information governance. Consultants advising on technology-driven business solutions. Government officials involved in policy-making for data protection. Career path Data Analyst Information Systems Manager Database Administrator IT Security Consultant Compliance Officer Business Intelligence Analyst Certificates Digital certificate Digital certificate - Included Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

Description: This Microsoft Office 2013 Excel Advanced - Complete Video Course covers the advanced functions and features of Excel 2013. You will learn about working with multiple worksheets and automating and auditing worksheets, how to update workbook properties, and how to apply conditional formatting. You will also learn how to export, analyze and present Excel data. This Advanced level is designed for you to gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros. This course is intended for them who have intermediate skills with Microsoft Excel 2013, and want to learn more advanced skills or want to learn the topics covered in this course in the 2013 interface. So, brush up your basic and intermediate knowledge and be an expert with the help of this course. 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 Office 2013 Excel Advanced - Complete Video Course 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 Office 2013 Excel Advanced - Complete Video Course 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. Automating Worksheet Functionality Update Workbook Properties FREE 00:07:00 Create and Edit a Macro 00:15:00 Apply Conditional Formatting 00:09:00 Add Data Validation Criteria 00:10:00 Auditing Worksheets Trace Cells 00:05:00 Troubleshoot Invalid Data and Formula Errors 00:12:00 Watch and Evaluate Formulas 00:10:00 Create a Data List Outline 00:09:00 Analyzing and Presenting Data Create Sparklines 00:13:00 Create Scenarios 00:12:00 Perform a What If Analysis 00:19:00 Perform a Statistical Analysis with the Analysis ToolPak 00:06:00 Create Interactive Data with Power View 00:10:00 Working With Multiple Workbooks Consolidate Data 00:10:00 Link Cells in Different Workbooks 00:10:00 Merge Workbooks 00:08:00 Exporting Excel Data Export Excel Data 00:06:00 Import a Delimited Text File 00:09:00 Integrate Excel Data with the Web 00:11:00 Create a Web Query 00:08:00 Mock Exam Mock Exam- Microsoft Office 2013 Excel Advanced - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2013 Excel Advanced - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

The Agile PMO: Can It Really Exist? Does an Agile PMO really exist? Can it? How would it work? This session will answer these questions and bring together two seemingly opposing concepts. We'll go back to basics to understand the fundamental purpose of PMOs, and how they benefit projects and organizations. Once we recognize the overall mission and vision of an Agile PMO, we will design a PMO Charter that will show how it adds value. Finally, we'll discuss how to gain buy-in for such a critical function. This and other IIL Learning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topics may qualify for other continuing education credits such as SEUs, or CEUs. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies. Fractions of PDUs may also be reported. The smallest increment of a PDU that can be reported is 0.25. This means that if you spent 15 minutes participating in a qualifying PDU activity, you may report 0.25 PDU. If you spend 30 minutes in a qualifying PDU activity, you may report 0.50 PDU.

Scrum Transformation for Publicly Traded Companies Scrum for Publicly Traded Companies shares what the Scrum Inc. team has learned about maximizing investor returns with Scrum, valuations and acquisitions and spinoffs with scrum, and completing initiatives with high investor scrutiny. Our presenter, Joe Justice, will be focusing on examples from Tesla, 3M, and Toyota. This and other IIL Learning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topics may qualify for other continuing education credits such as SEUs, or CEUs. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies. Fractions of PDUs may also be reported. The smallest increment of a PDU that can be reported is 0.25. This means that if you spent 15 minutes participating in a qualifying PDU activity, you may report 0.25 PDU. If you spend 30 minutes in a qualifying PDU activity, you may report 0.50 PDU.

Blending Concepts for Success Have you ever finished a Release Planning Meeting thinking everyone understood the features to be built but found out halfway through the third (3) sprint that was not the case? Clearly understood Stories is key to building a solid sprint. Blending Lean UX with Agile Scrum will provide usable techniques to enhance clarity so Agile teams can select stories they understand. This and other IIL Learning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topics may qualify for other continuing education credits such as SEUs, or CEUs. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies. Fractions of PDUs may also be reported. The smallest increment of a PDU that can be reported is 0.25. This means that if you spent 15 minutes participating in a qualifying PDU activity, you may report 0.25 PDU. If you spend 30 minutes in a qualifying PDU activity, you may report 0.50 PDU.

Get the Most from Agile and Scrum When Working on Projects! Most of what is written about Scrum and Agile focusses on a context where an existing product is evolving. But what about developing new products from scratch? ...and what about difficult situations where there are many 'moving parts' that need to be synchronized?There are times when the basics of agile, and particularly Scrum, are not enough on their own to ensure the successful delivery of a complicated piece of work such as when dealing with a project.By combining PRINCE2® with agile, you can get all of the benefits of agile and Scrum, whilst at the same time harnessing the control and governance of one of the world's most well-known project management frameworks.Why not take a look at this presentation? You may be surprised by the result! This and other IIL Learning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topics may qualify for other continuing education credits such as SEUs, or CEUs. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies. Fractions of PDUs may also be reported. The smallest increment of a PDU that can be reported is 0.25. This means that if you spent 15 minutes participating in a qualifying PDU activity, you may report 0.25 PDU. If you spend 30 minutes in a qualifying PDU activity, you may report 0.50 PDU.

Scrum Transformation for Publicly Traded Companies Scrum for Publicly Traded Companies shares what the Scrum Inc. team has learned about maximizing investor returns with Scrum, valuations and acquisitions and spinoffs with scrum, and completing initiatives with high investor scrutiny. Our presenter, Joe Justice, will be focusing on examples from Tesla, 3M, and Toyota. This and other IIL Learning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topics may qualify for other continuing education credits such as SEUs, or CEUs. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies. Fractions of PDUs may also be reported. The smallest increment of a PDU that can be reported is 0.25. This means that if you spent 15 minutes participating in a qualifying PDU activity, you may report 0.25 PDU. If you spend 30 minutes in a qualifying PDU activity, you may report 0.50 PDU.