13932 Courses

Microsoft Excel® in Depth The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses. This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you Will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables Getting Started The building blocks of Excel, built-in functions, will be examined The basics of formatting your data will be examined Shortcuts and data manipulation will be explored Built-in features like those mentioned in the 'What you will learn' section above will be explored in detail Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more Using Named ranges, Data Validation, Sorting, and Filtering Learn the Name manager; Learn the difference between local and global names; Ensure correct access to linked workbooks; Ensure data accuracy; Learn how to use cascading data validation (for example, once a user chooses 'cars', another cell allows only Ford, Toyota, etc.); Sorting by more than 3 fields; Filtering by font, pattern, or value; See your data based on things like dates in the 3rd quarter, or fields where quantity x price is greater than some fixed value Conditional formatting and data formatting Make relevant data stand out Isolate highs and lows Make error cells invisible Learn about Data bars, Icon sets, and Color scales Highlight differences between worksheets Learn all the codes in the Format/Number list Using cell Styles Learn all about alignment, protection, borders, colors and more Pivot Tables Learn how to summarize large amounts of data with a few clicks Learn various ways of presenting the data Learn the various pivot table tools Learn how to customize and format a pivot table to suit your needs Learn how to group data Learn how to use the various options to present your data Charts Learn how to create a chart with one keystroke! Learn the 11 types of built-in charts Learn how to create a chart with one keystroke! Learn how to customize the charts to make the information tell the right story Learn how to use the design, layout, and formatting available to charts in Excel 2007 Learn embedded charts versus chart sheets Learn how to use modify all the pieces of a chart Array formulas Learn how to use the most powerful formulas in Excel Learn how to combine many formulas into one compact array-formula Learn the real power of these formulas and why regular formulas can't do the job Learn how to use built-in array formulas, like TREND or TRANSPOSE

Schools of Kung Fu (Harrow) is an Martial Arts club that strives to bring out the best in your kids through teaching proper Wing Chun Kung Fu and practical self defence.

Duration 2 Days 12 CPD hours This course is intended for The primary audience for this course is any IT, facilities or data centre professional who works in and around the data centre and who has the responsibility to achieve and improve the availability and manageability of the data centre. Overview After completion of the course the participant will be able to:? Choose an optimum site for mission-critical data centre based on current and future needs? Describe all components that are important for high availability in a data centre and how to effectively setup the data centre? Name and apply the various industry standards? Describe the various technologies for UPS, fire suppression, cooling, monitoring systems, cabling standards, etc, and to select and apply them effectively to cost-efficiently enhance the high-availability of the data centre.? Review the electrical distribution system to avoid costly downtime? Enhance cooling capabilities and efficiency in the data centre by using existing and new techniques and technologies for the increased cooling requirements of the future? Design a highly reliable and scalable network architecture and learn how to ensure installers apply proper testing techniques? Create effective maintenance contracts with equipment suppliers ensuring the best return on investment? Setup effective data centre monitoring ensuring the right people get the right message? Ensure proper security measures, both procedural and technical, are established to safeguard your company's valuable information in the data centre The course will address how to setup and improve key aspects such as power, cooling, security, cabling, safety, etc., to ensure a high available data centre. It will also address key operations and maintenance aspects. The Data Centre, it?s Importance and Causes for DowntimeData Centre Standards and Best PracticesData Centre Location, Building and Construction Selecting appropriate sites and buildings and how to avoid pitfalls Various components of an effective data centre and supporting facilities setup Raised Floor/Suspended Ceiling Uniform, concentrated and rolling load definitions Applicable standards Raised Floor guidelines Signal Reference Grid, grounding of racks Disability act and regulations Suspended ceiling usage and requirements Light Standards Light fixture types and placement Emergency lighting, Emergency Power Supply (EPS) Power Infrastructure Power infrastructure layout from generation to rack level ATS and STS systems Redundancy levels and techniques Three-phase and single-phase usage Power distribution options within the computer room Power cabling versus bus bar trunking Bonding versus grounding Common Mode Noise and isolation transformers Distribution boards, form factors and IP-protection grades Power quality guidelines Real power versus apparent power How to size and calculate load in the data centre Generators Static and dynamic UPS systems, selection criteria, how they operate and energy efficiency option Battery types, correct selection and testing Thermo-graphics Electro Magnetic Fields Electrical fields and magnetic fields definitions and units of measurements Sources of EMF Effects of EMF on human health and equipment (H)EMP Standards EMF shielding solutions Equipment Racks Rack standards, properties and selection criteria Security considerations Power rail/strip options Cooling Infrastructure Temperature and humidity recommendations Cooling measurement units and conversion rates Sensible and latent heat definitions Differences between comfort and precision cooling Overview of different air conditioner technologies Raised floor versus non-raised floor cooling Placement of air conditioner units and limitations to be observed Supplemental cooling options Cold aisle/hot aisle containment Water Supply Importance of water supply and application areas Backup water supply techniques Designing a Scalable Network Infrastructure The importance of a Structured Cabling System Planning considerations Copper and Fiber cable technology and standards ANSI/TIA-942 Cabling hierarchy and recommendations Testing and verification SAN storage cabling Network redundancy Building-to-building connectivity Network monitoring system requirements Fire Suppression Standards for fire suppression Detection systems Various total flooding fire suppression techniques and systems, their benefits and disadvantages Handheld extinguishers Signage and safety Regulatory requirements and best practices Data Centre Monitoring Data centre monitoring requirements EMS versus BMS Water leak detection systems Notification options and considerations Operational Security and Safety Practices Data centre security layers Physical, infrastructure and organisational security Safety measures and essential signage Labelling Choosing a labelling scheme Recommended labelling practices Network labelling Documentation How to setup proper documentation Document management policies and procedures Cleaning Cleaning practices for the data centre MTBF/MTTR Standards and definitions Calculation models The ?real? value Maintenance Contracts/SLA/OLAEXAM: Certified Data Centre Professional Additional course details: Nexus Humans Certified Data Centre Professional (CDCP) 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 Certified Data Centre Professional (CDCP) 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.

Master the AutoCAD to perfection by learning from the best Learning AutoCAD has never been easier Do you want to master AutoCAD to exceed in your profession? Now you can do it by joining an interactive AutoCAD course created by an expert designer. Forget about multi-volume AutoCAD manuals and random tutorials found on the web. Learn how to create projects like a master designer. Learn from the best, receive step-by-step guidance, exercise in practice and design your own project to solidify your new skills. You will learn how to create professional designs according to the latest standards and how to work with AutoCAD quickly and flawlessly. Previous experience with AutoCAD is not obligatory. This AutoCAD course is perfect for people with a little experience as well as for complete newbies. The course consists of interactive modules, tests, and practical exercises to help you gain proficiency faster than ever before. At the end, you’ll receive a certificate of completion that’ll serve as proof of your newly acquired abilities. Are you ready to join the ranks of professional designers? Get the course today and start learning. Join the AutoCAD course today and get the benefits: Learning from a professional instructor24/7 access from any devicePractical exercisesTests, quizzes and recapsCertificate of completionExtra materials and downloadable bonuses100% satisfaction guarantee Your Singing Instructor: Daniel Stern AutoCAD expert Daniel Stern is a designer and trainer with over 15 years of experience. He’s been creating commercial AutoCAD projects since 2002 and you can feel his passion for design from the very start of the course. With over 2800 hours of training experience, he is also a great couch who can explain even the most challenging concepts clearly and easily.  No matter if you are in architecture, installations or mechanics, he will guide you step-by-step through the most important features of AutoCAD. Thanks to his guidance, you will be able to create designs in an efficient and organized manner. Detailed Video Presentations: Knowledge of design and CAD CAD software basics, applications and capabilities AutoCAD versions and modules File and print formats CAD software alternatives AutoCad interface Workspace Controls Menus Toolbars Coordinates Command line Training Videos Foundations of AutoCAD operation Views and layers Drawing shapes and objects Tools and features Editing and manipulating objects Printing and exporting Twelve Practical Exercises in: Navigating interface Using views and coordinates Creating and editing objects Precise drawing Advanced tools Finishing the project Tests and Repetitions: Tests and repetitions of acquired knowledge CAD knowledge test Navigation Drafting and modification of elements, tools and properties of elements in AutoCAD, layers, text, blocks and print Final Examination Comprehensive repetition of the material Final exam Summary of the completed project Bonus Reference Materials: Additional materials for use in daily work Compendium of AutoCAD shortcuts and tools AutoCAD best practices Essential AutoCAD commands AutoCAD productivity boost manual Experience Beginner-IntermediateLanguage English, German, French, Polish, Portuguese A letter from your expert instructor: I’m pleased to invite you to this one-of-a kind course. Step by step you will learn everything about the program. In a few days you will use advanced tools and techniques that even professionals have trouble with. Choosing the right scale, setting units, drawing complex elements and their transformation, hatching, dimensioning, counting areas, working with objects and blocks – these are only a few of the topics that will be discussed during this training.After completing this AutoCAD course, you will be able to work on an equal level with professionals and jump-start your career in design.You will receive an exceptionally comprehensive package of knowledge and skills with access, practical exercises, concrete examples, repetitions, tests, support materials and, on top of everything, a valuable certificate.Believe in yourself and make the most of your opportunities. See you at the course!Daniel Stern,Designer and AutoCAD expert

Overcoming the challenge of public speaking - dealing with nerves, fine tuning delivery and engaging your audience with authentic confidence.

10 QLS Endorsed Courses for Financial Analyst | 10 Endorsed Certificates Included | Life Time Access

Accelerate Your Cyber Career: Fast-Track Program with Exams, TOTUM Card & 5-Year Support. Enrol Today! Study methodOnline Duration9 months · Self-paced Access to content5 years CertificationsCompTIA A+CompTIA Network+CompTIA Security+CompTIA IT Fundamentals CertificationCompTIA CySA+CompTIA PenTest+ Certificates Official CompTIA Certification - Free Additional info Exam(s) / assessment(s) is included in price Tutor is available to students TOTUM card included in price Job guarantee programme is included in this course Overview Learn the most in-demand digital skills in the world today with the Nuyew Tech Academy With the increase in cyberattacks and the number of new connected devices, the need for skilled cybersecurity professionals is growing at a rapid pace, and cybersecurity professionals must nurture their practical, hands-on skills. If you are looking for employment in cybersecurity, then this programme will provide you with an endorsement of your skills that is respected globally and industry-wide. Certifications CompTIA A+ CompTIA Network+ CompTIA Security+ CompTIA IT Fundamentals Certification CompTIA CySA+ CompTIA PenTest+ Awarded by CompTIA Description With a national shortage of Cyber Security Engineers, starting salaries of up to £25,000 per annum (average UK Salary £72,500) and amazing future employed and self-employed career prospects, take the next step today with our Fast Track Cyber Security Programme. What you can expect from our Fast Track Programme: World Class Education Energetic and unlimited 24/7 Student Support Real, tangible Career Outcomes 5 Years Career Support What our programme includes: Industry Recognised Qualifications CompTIA ITF+ (IT Fundamentals) CompTIA A+ CompTIA Network+ CompTIA Security+ CompTIA CySA+ OR CompTIA PenTest+ Exams Includes all Exams and Unlimited Re-Sits 5 Years Career Support Guarantee As part of our unique Support Guarantee, our Career Support Team will assist you with: CV writing Expert careers advice Interview preparation Identifying and applying for the best opportunities in your area As a student in the Nuyew Tech Academy you will also be given exclusive access to our AdvancedCareer Skills Academy which includes advanced courses on Employability, CV Preparation, Interview Skills and Technique and everything else you need to get ready for your new Career. Who is this course for? This course is open to anyone interested in pursuing a Career in Cyber Security. Our Foundation Level provides the flexibility for us to accommodate students with any level of previous knowledge and experience. Requirements This course is open to all and has no pre-requisites All you need is a passion for technology and a strong desire to succeed. Career path Our programme is designed to enable you to achieve an Entry Level/Helpdesk role during training (£18k-£24K) ensuring that you also have the vital work experience required to enter the Tech Industry at a higher level (Av Salary £72.5K). Our Career Support Guarantee gives you exclusive access to our dedicated Career Support Team and Advanced Career Skills Academy for 5 Years following Graduation. Certificates Official CompTIA Certification Hard copy certificate - Included We provide Official CompTIA Certificates for all courses included (ITF+, A+(2), Network+, Security+, CySA+ or PenTest+.

  ISO 45001 is the first global occupational health and safety management system standard that replaces OHSAS 18001. The IECB Certified ISO 45001 Lead Auditor training course helps in developing the necessary skillset to perform occupational health and safety management system (OH&S MS) audits by applying widely recognized audit principles, procedures, and methods.   About This Course   This training course has been developed to reflect the importance of an effective internal audit. It strengthens your knowledge and skills to plan and carry out an OH&S MS audit in compliance with the guidelines for auditing management systems provided in ISO 19011 and the certification process described in ISO/IEC 17021-1. The exercises provided for this training course are designed to help you practice the most important aspects of an OH&S MS audit: ISO 45001 requirements, auditing principles, tools and techniques used to obtain evidence, leading a team of auditors, conducting interviews with auditees, reviewing documented information, drafting nonconformity reports, and preparing the final audit report. The successful completion of the training course is followed by an exam. If you pass the exam, you gain the 'Certified ISO 45001 Internal Auditor' credential, which validates your professional capabilities and demonstrates your ability to audit an OH&S MS based on ISO 45001.   Learning objectives By the end of this training course, the participants will be able to: Explain the foundational concepts and principles of an occupational health and safety management system (OH&S MS) based on ISO 45001 Interpret the ISO 45001 requirements for an OH&S MS from the perspective of an auditor Evaluate the OH&S MS conformity to ISO 45001 requirements, in accordance with the foundational audit concepts and principles Plan, conduct, and close an ISO 45001 internal audit, in accordance with ISO/IEC 17021-1 requirements, ISO 19011 guidelines, and other best practices of auditing Manage an ISO 45001 internal audit programme   Educational approach This training course is participant centred and contains: Theories, best practices used in occupational health and safety management auditing Lecture sessions, which are illustrated with practical exercises based on a case study that includes role-playing and discussions Interactions, made between participants by means of questions and suggestions Quizzes, which are a simulation and preview of the certification exam   Course Overview Module 1 Foundational principles and concepts of an occupational health and safety management system Module 2 ISO 45001 requirements for an OH&S MS - Clauses 4 to 10 Module 3 Foundational audit concepts and principles Module 4 Preparing for an ISO 45001 audit Module 5 Conducting an internal ISO 45001 audit Module 6 Closing an ISO 45001 audit Module 7 Managing an ISO 45001 internal audit programme   Course Agenda Day 1: Introduction to OH&S MS and ISO 45001 Day 2: Audit principles and the preparation for and initiation of an audit Day 3: On-site audit activities and closing the audit, as well as the Certification exam Accreditation Assessment   All candidates at official training courses are tested throughout their course with quizzes and exercises, in combination with a final exam held on the last day of the course. Both elements are a part of the overall score. For this course, the final exam constitutes a 10 question essay type exam which should be completed within 125 minutes. A passing score is achieved at 70%. Self-study candidates can purchase an exam voucher from our Store. Exam results are returned within 24 hours, with successful candidates receiving both a digital badge and a Certificate of Achievement   Prerequisites   The main requirements for participating in this training course are: a foundational understanding of ISO 45001 and a comprehensive knowledge of audit principles. Provided by   This course is Accredited by NACSand Administered by the IECB What's Included?   Refreshments & Lunch (Classroom courses only) Course Slide Deck Official Study Guides CPD Certificate The Exam Who Should Attend?   Auditors interested in performing OH&S MS internal audits Managers or consultants interested in advancing their knowledge of the OH&S MS audit process Internal auditors and individuals responsible for maintaining conformity to the requirements of ISO 45001 Technical experts interested in preparing for an OH&S MS audit Expert advisors in occupational health and safety management

The objective of the Level 7 Diploma in Education Management and Leadership qualification (accredited by OTHM) is to develop learners' understanding of: Policy, Management Theory and Practice in Education. The main objective of studying Level 7 Diploma in Education Management and Leadership is that: It provides learners with an opportunity to engage with the Challenges facing professionals and policy makers in their own country. It will provide you with the knowledge that underpins the ability to work as an effective manager in the education sector. This course combines both theoretical and practical knowledge in the education profession and will develop and enhance your knowledge and skills in the areas of Leading Change, Effective Performance and Team Leadership. Learners will be able to work in a variety of roles within Education Administration and/or Management. Key Highlights Program Duration: 9 Months (Can be Fast tracked) Program Credits: 120 credits Designed for working Professionals Format: Online No Written Exam. The Assessment is done via Submission of Assignment Tutor Assist available Dedicated Student Success Manager Timely Doubt Resolution Regular Networking Events with Industry Professionals Become eligible to gain direct entry into relevant Master's degree programme. LSBR Alumni Status No Cost EMI Option This Diploma in Education Management and Leadership - Level 7 programme will provide you with the knowledge and skills required by a middle or senior manager in Education sector to understand the Policy, Management Theory and Practice in Education. It will also provides you with an opportunity to engage with the challenges facing professionals and policy makers in education sector as well as provide you with the knowledge that underpins the ability to work as an effective manager in the education sector. You will be able to work in a variety of roles within Education Administration and/or Management in an Education sector. Upon successful completion of the programme, you will also become eligible to gain direct entry into relevant Master's degree programme. Mandatory units (Total Credits: 120) The OTHM Level 7 Diploma in Education Management and Leadership qualification consists of 6 mandatory units for a combined total of 120 credits Contemporary Issues in Education: Theory, Policy and Practice (20 credits) The Management of Educational Change (20 credits) Managing Effective Intercultural Communication and Perspectives (20 credits) Pedagogy and Practice in Education (20 credits) Leading Reflective Practice in Education (20 credits) Research Methods in Education (20 credits) Who is this course for? Working Professionals Level 6 / Year 3 of a three-year UK Bachelor's degree holders or learners who are looking for Career Progression. A formal Postgraduate qualification leading to award of degrees in future. Requirements For entry onto the Level 7 Diploma in Education Management and Leadership qualification, learners must possess an honours degree in related subject or UK level 6 diploma or an equivalent overseas qualification. Learner must be 18 years or older at the beginning of the course. No formal qualification is required from mature learners (over 21 years) who have relevant management experience. Please speak to the Admission Counselors for waiver information. Career path Become eligible to gain direct entry into relevant Master's degree programme after completion of your Level 7 Diploma in Education Management and Leadership. Completion of your qualification will meet the University standard academic entry requirements. However, each applicant will be subject to individual assessment and other entry requirements which may affect university entry.

This Python Machine Learning online instructor led course is an excellent introduction to popular machine learning algorithms. Python Machine Learning 2-day Course Prerequisites: Basic knowledge of Python coding is a pre-requisite. Who Should Attend? This course is an overview of machine learning and machine learning algorithms in Python SciKitLearn. Practical: We cover the below listed algorithms, which is only a small collection of what is available. However, it will give you a good understanding, to plan your Machine Learning project We create, experiment and run machine learning sample code to implement a short selected but representative list of available the algorithms. Course Outline: Supervised Machine Learning: Classification Algorithms: Naive Bayes, Decision Tree, Logistic Regression, K-Nearest Neighbors, Support Vector Machine Regression Algorithms: Linear, Polynomial Unsupervised Machine Learning: Clustering Algorithms: K-means clustering, Hierarchical Clustering Dimension Reduction Algorithms: Principal Component Analysis Latent Dirichlet allocation (LDA) Association Machine Learning Algorithms: Apriori, Euclat Other machine learning Algorithms: Ensemble Methods ( Stacking, bagging, boosting ) Algorithms: Random Forest, Gradient Boosting Reinforcement learning Algorithms: Q-Learning Neural Networks and Deep Leaning Algorithms: Convolutional Network (CNN) Data Exploration and Preprocessing: The first part of a Machine Learning project understands the data and the problem at hand. Data cleaning, data transformation and data pre-processing are covered using Python functions to make data exploration and preprocessing relatively easy. What is included in this Python Machine Learning: Python Machine Learning Certificate on completion Python Machine Learning notes Practical Python Machine Learning exercises and code examples After the course, 1 free, online session for questions or revision Python Machine Learning. Max group size on this Python Machine Learning is 4. Refund Policy No Refunds