8420 ET courses delivered Online

Microsoft Excel® in Depth: Virtual In-House Training 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

Microsoft Excel® in Depth: In-House Training 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

Do you need a qualification in data protection or are you thinking about learning more about data protection for your organisation? The BCS Foundation Certificate in Data Protection designed for those who need to have an understanding of data protection, and the GDPR in particular, to do their job and knowledge of data protection law would be effective in their role.

Getting Started The OTHM Level 7 Diploma in Occupational Health and Safety Management is a qualification for ambitious health and safety professionals. It is intended to make learners accountable for developing and applying health and safety procedures daily in an organisation. This course aids the learners to improve their knowledge and skills. The objective of the OTHM Level 7 Diploma in Occupational Health and Safety Management qualification is to advance occupational health and safety management expertise for managers with the authority and personal attributes to translate organisational strategy into effective operational performance. This qualification reflects current practice in Occupational Health and Safety Management and allows learners to develop and expand their high-level understanding of occupational health and safety. Key Benefits   The course taker will benefit from gaining in-depth knowledge on multidisciplinary topics such as health and safety management practice and systems, strategic risk intervention and its factors, strategies to improve occupational wellbeing, and sustainability and ethics. The Advanced Research Methods unit will allow learners to develop a critical understanding of research and philosophical, practical and ethical concepts within a health and safety environment. The qualification will enable learners to become autonomous, self-directed learners with tools and motivation to continue learning, developing, and reflecting on practice throughout their careers. The OTHM Level 7 Diploma in Occupational Health and Safety Management qualification enables learners to progress into or within employment or continue their further study. As this qualification is approved and regulated by Ofqual (Office of the Qualifications and Examinations Regulation), learners can progress to a Master's top-up at many universities in the UK and overseas with advanced standing. About Awarding Body OTHM is an established and recognised Awarding Organisation (Certification Body) launched in 2003. OTHM has already made a mark in the UK and global online education scenario by creating and maintaining a user-friendly and skill based learning environment. OTHM has both local and international recognition which aids OTHM graduates to enhance their employability skills as well as allowing them to join degree and/or Master top-up programmes. OTHM qualifications has assembled a reputation for maintaining significant skills in a wide range of job roles and industries which comprises Business Studies, Leadership, Tourism and Hospitality Management, Health and Social Care, Information Technology, Accounting and Finance, Logistics and Supply Chain Management. What is included?   Outstanding tutor support that gives you supportive guidance all through the course accomplishment through the SBTL Support Desk Portal. Access our cutting-edge learning management platform to access vital learning resources and communicate with the support desk team. Quality learning materials such as structured lecture notes, study guides, and practical applications, which include real-world examples and case studies, will enable you to apply your knowledge. Learning materials are provided in one of the three formats: PDF, PowerPoint, or Interactive Text Content on the learning portal. The tutors will provide Formative assessment feedback to improve the learners' achievements. Assessment materials are accessible through our online learning platform. Supervision for all modules. Multiplatform accessibility through an online learning platform facilitates SBTL in providing learners with course materials directly through smartphones, laptops, tablets or desktops, allowing students to study at their convenience. Live Classes (for Blended Learning Students only) Assessment Time-constrained scenario-based assignments No examinations Entry Requirements   For entry into the OTHM Level 7 Diploma in Occupational Health and Safety Management, learners must possess the following: An honours degree in a related subject or a UK level 6 diploma or an equivalent overseas qualification Mature learners (over 21 years) with management experience International students whose first language is not English will need to have a score of 5.5 or above in the IELTS (International English Language Testing System)   Learners must request before enrolment to interchange unit(s) other than the preselected units shown in the SBTL website because we need to make sure the availability of learning materials for the requested unit(s). SBTL will reject an application if the learning materials for the requested interchange unit(s) are unavailable. Learners are not allowed to make any request to interchange unit(s) once enrolment is complete. UNIT1- Health and Safety Management Practice Reference No : M/618/8236 Credit : 20 || TQT : 200 The aim of this unit is to provide learners with the knowledge, understanding and skills to translate organisational policy into an effective occupational health and safety management operation, including evaluating and reviewing health and safety management practices and operations. UNIT2- Effectiveness of Health and Safety Management Systems Reference No : T/618/8237 Credit : 20 || TQT : 200 The aims of this unit are to provide learners with extensive knowledge and understanding to demonstrate their influence of effective system management and operation. Learners will determine the core drivers for effective health and safety systems within an organisation, evaluating traditional and proactive safety management models, along with the importance of communication systems for the organisation. UNIT3- Factors Affecting Risk and Strategic Risk Intervention Reference No : A/618/8238 Credit : 20 || TQT : 200 This unit aims to develop learners' understanding of the principles of implementing and maintaining a sensible risk management programme. Learners will also gain knowledge on how to assess health and safety risks within the organisation and develop appropriate risk control measures. UNIT4- Strategic Commitment to Health and Well-Being Reference No : F/618/8239 Credit : 20 || TQT : 200 This unit will explore strategies for securing commitment to improve occupational health and well-being. UNIT5- Sustainability and Ethics in Health and Safety Practice Reference No : T/618/8240 Credit : 20 || TQT : 200 The aim of the unit is to evaluate the influences the workplace has on the safety and health of workers and evaluate the evidence for creating an all-inclusive approach to improving safety, health and wellbeing at work. UNIT6- Advanced Research Methods Reference No : Y/618/8246 Credit : 20 || TQT : 200 The unit aim is to allow learners to develop key knowledge, understanding and skills relating to health and safety research and the theoretical and methodological problems that may be associated with the research. Learners will be able to cover key topics relating to research problem, conducting literature reviews, referencing, data collection and analysis techniques, and drawing conclusions from the analyzed data. This unit will enable learners to develop critical awareness of key research skills as researchers and/or independent health and safety practitioners. Delivery Methods School of Business & Technology London provides various flexible delivery methods to its learners, including online learning and blended learning. Thus, learners can choose the mode of study as per their choice and convenience. The program is self-paced and accomplished through our cutting-edge Learning Management System. Learners can interact with tutors by messaging through the SBTL Support Desk Portal System to discuss the course materials, get guidance and assistance and request assessment feedbacks on assignments. We at SBTL offer outstanding support and infrastructure for both online and blended learning. We indeed pursue an innovative learning approach where traditional regular classroom-based learning is replaced by web-based learning and incredibly high support level. Learners enrolled at SBTL are allocated a dedicated tutor, whether online or blended learning, who provide learners with comprehensive guidance and support from start to finish. The significant difference between blended learning and online learning methods at SBTL is the Block Delivery of Online Live Sessions. Learners enrolled at SBTL on blended learning are offered a block delivery of online live sessions, which can be booked in advance on their convenience at additional cost. These live sessions are relevant to the learners' program of study and aim to enhance the student's comprehension of research, methodology and other essential study skills. We try to make these live sessions as communicating as possible by providing interactive activities and presentations. Resources and Support School of Business & Technology London is dedicated to offering excellent support on every step of your learning journey. School of Business & Technology London occupies a centralised tutor support desk portal. Our support team liaises with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receives a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and streamline all the support processes efficiently. Quality learning materials made by industry experts is a significant competitive edge of the School of Business & Technology London. Quality learning materials comprised of structured lecture notes, study guides, practical applications which includes real-world examples, and case studies that will enable you to apply your knowledge. Learning materials are provided in one of the three formats, such as PDF, PowerPoint, or Interactive Text Content on the learning portal. How does the Online Learning work at SBTL? We at SBTL follow a unique approach which differentiates us from other institutions. Indeed, we have taken distance education to a new phase where the support level is incredibly high.Now a days, convenience, flexibility and user-friendliness outweigh demands. Today, the transition from traditional classroom-based learning to online platforms is a significant result of these specifications. In this context, a crucial role played by online learning by leveraging the opportunities for convenience and easier access. It benefits the people who want to enhance their career, life and education in parallel streams. SBTL's simplified online learning facilitates an individual to progress towards the accomplishment of higher career growth without stress and dilemmas. How will you study online? With the School of Business & Technology London, you can study wherever you are. You finish your program with the utmost flexibility. You will be provided with comprehensive tutor support online through SBTL Support Desk portal. How will I get tutor support online? School of Business & Technology London occupies a centralised tutor support desk portal, through which our support team liaise with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receive a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and to streamline all the support process efficiently. Learners should expect to receive a response on queries like guidance and assistance within 1 - 2 working days. However, if the support request is for assessment feedback, learners will receive the reply with feedback as per the time frame outlined in the Assessment Feedback Policy.

As a paediatric hypnotherapist, you have the power to positively impact the lives of children and young people on the autism spectrum. Unlock your potential with our inspiring, blended-learning course that provides you with safe, effective, and ethical techniques. Our accreditation and ongoing support will help you enhance your expertise in positive psychology and solution-focused counselling, empowering you to guide your clients towards personal growth and positive outcomes. Explore our flexible course today and start making a difference in the lives of those you care about.

Business Relationship Management Fundamentals: In-House Training Business Relationship Management (BRM) Fundamentals introduces BRM as a capability, role, and discipline. What you will Learn Participants can expect an interactive and lively one-day session, with a high-level introduction to successfully navigate the complexity of BRM. Topics include: Defining BRM as a capability, role, and discipline Understanding what a BRM does and does not do Providing the language needed to change perceptions and perspectives Learn how the BRM discipline interacts with other disciplines (project management, architecture, Business Analysts, Business functions, strategy, etc.) inside an organization Basic introduction to the different frameworks, processes, and models to bring structure and guidance to BRM Introductions Why BRM? BRM defined BRM in action BRM value Reflection and next steps Resources

Step into the future with our 'Cyber Security Law & Ethical Hacking' bundle. This comprehensive package includes three QLS-endorsed courses: 'Cyber Security Advanced Training', 'Cyber Security Law Online Course', and 'Cyber Security & Ethical Hacking To The Next Level'. Each course comes with a hardcopy certificate, offering you recognised credentials in this vital field. This bundle is further enriched by five CPD QS accredited courses: 'Cyber Intelligence Officer', 'Cyber Security Incident Handling and Incident Response', 'Linux Security and Hardening', 'Cyber Security Awareness Training', and 'Computer Networks Security from Scratch to Advanced'. Key Features of the Cyber Security Law & Ethical hacking- 3 QLS Course Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Cyber Security Law & Ethical hacking- 3 QLS Course bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Cyber Intelligence Officer QLS Course 02: Cyber Security Incident Handling and Incident Response QLS Course 03: Linux Security and Hardening 5 CPD QS Accredited Courses: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices. Course 01: Cyber Intelligence Officer Course 02: Cyber Security Incident Handling and Incident Response Course 03: Linux Security and Hardening Course 04: Cyber Security Awareness Training Course 05: Computer Networks Security from Scratch to Advanced In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle. Course 01: Professional CV Writing Course 02: Job Search Skills Course 03: Self Esteem & Confidence Building Course 04: Professional Diploma in Stress Management Course 05: Complete Communication Skills Master Class Convenient Online Learning: Our Cyber Security Law & Ethical hacking- 3 QLS Course courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Secure your career in the cyber realm by mastering the legal landscape, advanced protection techniques, and ethical hacking principles through this immersive learning experience. Learning Outcomes: Grasp advanced cyber security concepts and strategies. Gain a comprehensive understanding of Cyber Security Law. Learn and apply ethical hacking principles. Become proficient in cyber intelligence and incident response. Understand Linux security and hardening techniques. Enhance awareness of cyber security threats and countermeasures. Learn about computer network security from scratch to advanced. The 'Cyber Security Law & Ethical Hacking' bundle delivers an extensive theoretical foundation in critical areas of cyber security. With the three QLS-endorsed courses, you'll delve into advanced cyber security practices, the legal framework surrounding cyber security, and ethical hacking principles. The five additional CPD QS accredited courses cover a broad spectrum of vital cyber security topics, from intelligence and incident response, to Linux security and cyber security awareness. This knowledge allows you to understand and navigate the increasingly complex digital security landscape and protect vital information and systems. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring professionals in the field of cyber security. Law students interested in specialising in cyber security law. IT professionals aiming to broaden their skill set with cyber security knowledge. Anyone interested in understanding the foundations of ethical hacking. Career path Cyber Security Analyst: Implement security measures to protect systems (£26,000 - £60,000). Cyber Security Lawyer: Advise on legal aspects of cyber threats (£40,000 - £80,000). Ethical Hacker: Identify vulnerabilities in systems using hacking techniques (£30,000 - £70,000). Cyber Intelligence Officer: Monitor and analyse cyber threats (£35,000 - £65,000). Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included

The main subject areas of the course are: Legislation and guidance for asbestos practitioners. The properties of asbestos and health effects of exposure to asbestos fibres. The types of asbestos and its uses in buildings. The types of asbestos surveys. The asbestos register, risk assessment and management plan. Asbestos remediation. The role of asbestos analysts and laboratory procedures.

Microsoft Project Orange Belt ® 2013 - Español: On-Demand This course is intended for both novice and experienced project managers, or any user of Project 2013. Participants must be involved in or be responsible for scheduling, estimating, budgeting, coordinating, controlling, and staffing projects and supporting projects. Project 2013 users. This course is intended for both new and experienced project managers, or any user of Project 2013. Participants must be involved in or responsible for scheduling, estimating, budgeting, coordinating, controlling, and staffing projects and supporting Project 2013 users. What You Will Learn Understand what's new in the Project 2013 release. Initialize Project to start flattening. Create a good project schedule, including WBS, estimates, dependencies, constraints, deadlines, and calendar usage. Assign resources and costs to tasks. Understand the types of tasks and the scheduling formula. Analyze the use of resources and optimize the schedule. Establish a baseline and a progress monitoring strategy. Use Earned Value Explain the potential of managing multiple projects. Ready to Go with Project 2013 Summary of Project 2013 Establish a new Project Schedule (Options, templates, files, etc.) Set the Project Schedule Enter Tasks The Planning Process Importar Tareas (Word, Excel, SharePoint) Create and manage a WBS (includes tasks, manual tasks, summary tasks, milestones, and WBS coding) Enter Estimates Trends in estimates The Gradual Planning Approach Enter Estimates on Duration and Effort Task types Enter Dependencies The principles of Dynamic Programming Types of Dependencies Selecting the right type of dependency Enter Dependencies in Project 2013 Understanding Due Dates, Restrictions and Task Calendar Use Deadlines and Restrictions Enter Deadlines and Restrictions in Project 2013 Enter Resources and Costs Resource Types Enter Resources in Project 2013 Calendars and Resources Enter Costs in Project 2013 Enter Assignments Assignments on a Schedule Assignments and Task Types Enter Assignments in Project 2013 Allocations and Costs Optimize the Schedule The Critical Path Method and the Resource Critical Path Resource Leveling Optimize Time, Cost and Resources in Project 2013 Update Schedule the baseline Strategies and Update Situations Prepare the Status and Forecast Report in Project 2013 Reports Using reports and dashboards Using visual reports Format and print reports Customize fields and views Earned Value Management (EVM) Earned Value Summary Applying Earned Value in Project 2013 Evaluate the Project Why evaluate? Compare results against baselines Generate templates for future projects Consolidated Schedules Creating a Consolidated Schedule Use a resource group Links between projects Solving common problems Baseline and follow-up

Certified Associate in Project Management (CAPM)® Exam Prep: On-Demand: On-Demand This course gives you the knowledge you need to pass the exam and covers CAPM®-critical information on project management theory, principles, techniques, and methods Are you planning on taking the CAPM® examination? This course gives you the knowledge you need to pass the exam and covers CAPM®-critical information on project management theory, principles, techniques, and methods. You'll also have an opportunity for practical applications and time to review the kinds of questions you'll find in the CAPM® Exam. What you Will Learn Apply for the CAPM® Examination Develop a personal exam preparation plan Describe the structure, intent, and framework principles of the current edition of the PMBOK® Guide Explain the PMBOK® Guide Knowledge Areas, as well as their inter-relationships with the each other and the Process Groups Getting Started Program orientation The CAPM® certification process Certified Associate in Project Management (CAPM®) Examination Content Outline CAPM® eligibility requirements Code of Ethics and Professional Conduct Application options Foundation Concepts Skills and qualities of a project manager Project management terminology and definitions Relationship of project, program, portfolio, and operations management Project lifecycle approaches Project Integration Management Review Project Integration Management Knowledge Area Develop Project Charter Develop Project Management Plan Direct and Manage Project Work Manage Project Knowledge Monitoring and Controlling Perform Integrated Change Control Close Project or Phase Project Stakeholder Management Review Project Stakeholder Management Knowledge Area Identify Stakeholders Plan Stakeholder Engagement Manage Stakeholder Engagement Monitor Stakeholder Engagement Project Scope Management Review Project Scope Management Knowledge Area Plan Scope Management Collect Requirements Define Scope Create WBS Validate Scope Control Scope Project Schedule Management Review Project Schedule Management Knowledge Area Plan Schedule Management Define Activities Sequence Activities Estimate Activity Durations Develop Schedule Control Schedule Project Cost Management Review Project Cost Management Knowledge Area Plan Cost Management Estimate Costs Determine Budget Control Schedule Project Resource Management Review Project Resource Management Knowledge Area Plan Resource Management Estimate Activity Resources Acquire Resources Develop Team Manage Team Control Resources Project Quality Management Review Project Quality Management Knowledge Area Plan Quality Management Manage Quality Control Quality Project Risk Management Review Project Risk Management Knowledge Area Plan Risk Management Identify Risks Perform Qualitative Risk Analysis Perform Quantitative Risk Analysis Plan Risk Responses Implement Risk Responses Monitor Risks Project Communications Management Review Project Communications Management Knowledge Area Plan Communications Management Manage Communications Monitor Communications Project Procurement Management Review Project Procurement Management Knowledge Area Plan Procurement Management Conduct Procurements Control Procurements Summary and Next Steps Program Review Mock CAPM® Exam Getting Prepared for the CAPM® Exam After the CAPM® Exam