• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

40400 Courses delivered Online

Computer Specialist Diploma

4.3(43)

By John Academy

Description: Computer Specialist Diploma Course is intended for those who wants to gain computer skills and knowledge. It has modules which will give you all the ins and outs of operating on a personal computer and its broad applications. First of all, it will cover all the fundamental computing terms, input, output, and storage devices. You will also learn about the operating systems, interface and its applications. As you step up through the hierarchy of the basic to intermediate to expert levels, you will be exposed to several contents which will teach you about networking, internet basic, ergonomics, safeguarding your data from malware, customization, etc. And the end, you will have a profound knowledge about computers. Learning Outcomes: Realise the common computing concepts Figure out the difference between hardware and software, as well as how they work Realise the operations of information networks Be conscious of security measures as well as learn working safely Obtain knowledge of the primary steps of operating a computer, involving using the keyboard,mouse, and Windows desktop Become competent to manage and use files and folders with proficiency Get knowledge of how to implement the fundamental Windows Applications,at the same time, learn Wordpad, Notepad, Task Manager, Calculator, Paint and Internet Explorer. Understand general computing concepts Understand the difference between hardware and software, and how each works Understand how information networks operate Become aware of security concerns and how to work safely Learn the first steps of using a computer, including using the keyboard, mouse, and Windows desktop Be able to effectively manage and use files and folders Learn how to use the basic Windows applications, including WordPad, NotePad, Task Manager, Calculator, Paint, and Internet Explorer Basic computing terms The fundamental computing skills Anatomy of a PC Input, output, and storage devices Operating systems and applications Legal issues, including licensing of software Networking and Internet basics Computers in the workplace Telecommuting and the electronic world Ergonomics, safety, and the environment Being proactive about security Protecting your data Understanding malware Using the mouse, keyboard, and desktop Customizing your computer Printing Understand and using files and folders Basic Windows applications Working with a window Working with applications Browsing the Web Realise the common computing concepts Figure out the difference between hardware and software, and how they function Interpret how information networks work Be alert of security measures as well as how you can work safely Acquire the knowledge of operating the first steps of a computer, learn how to use the keyboard, mouse, as well as Windows desktop Become competent to proficiently handle and apply files and folders Attain knowledge of operating fundamental Windows applications, along with Wordpad, Notepad, Task Manager, Calculator, Paint and Internet Explorer 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? Computer Specialist Diploma 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 Computer Specialist Diploma 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. Module 01 Basic Terms 00:15:00 Types of Computers 00:15:00 Anatomy of a PC 00:30:00 How a PC Works 00:15:00 CPU and Memory 00:30:00 Input Devices 00:15:00 Output Devices 00:15:00 Secondary Storage Devices 00:30:00 The Basics 00:15:00 Operating Systems and Applications 00:30:00 How is Software Built 00:15:00 Types of Software 00:15:00 Legal Issues 00:15:00 Module 02 Basic Terms 00:15:00 Advanced Terms 00:15:00 Networking Basics 00:15:00 Basic Internet Concepts 00:30:00 Internet Security 00:30:00 Computers in the Workplace 00:15:00 Tele-Commuting 00:15:00 The Electronic World 00:15:00 Ergonomics 00:15:00 Safety and the Environment 00:15:00 Being Proactive 00:15:00 Identifying Yourself 00:15:00 Protecting Your Data 01:00:00 Understanding Malware 00:15:00 Protecting Against Malware 00:15:00 Module 03 Application Basics 00:30:00 Basic Applications 01:00:00 Working with a Window 01:00:00 Working with WordPad 01:00:00 Working With Applications 01:00:00 Basics of Web Browsers 01:00:00 Browsing the Web 00:15:00 Working with Bookmarks 01:00:00 Working With Web Pages 01:00:00 Printing Web Pages 01:00:00 Module 04 First Steps 00:30:00 Basic Tasks 01:00:00 Using the Desktop 00:15:00 Customizing Your Computer 00:15:00 Printing 00:15:00 The Basics of Files and Folders 00:10:00 Managing Files and Folders, Part I 01:00:00 Managing Files and Folders, Part II 00:15:00 Viewing File or Folder Properties 00:30:00 Working With Files and Folders 00:30:00 Compressed Files 00:05:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Computer Specialist Diploma
Delivered Online On Demand22 hours 45 minutes
£22

Leisure Management and Travel - Endorsed Training

By Imperial Academy

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

Leisure Management and Travel - Endorsed Training
Delivered Online On Demand
£300

Revit Basic to Advanced Training Course

By ATL Autocad Training London

Why Book Revit Basic to Advanced Training Course? Learn BIM and Revit for engineers and architects, supporting 2-D and 3-D design for large-scale projects and combing with AutoCAD. Check our Website How to Book? 1-on-1 training tailored to your schedule. Book your sessions from Monday to Saturday between 9 am and 7 pm or call 02077202581 to book over the phone. Training Details: Duration: 16 hours Flexible scheduling, split across multiple days Method: 1-on-1 (In-person or Live Online) and Personalized attention Course Overview: I. Revit Fundamentals (1 hour) Understanding Revit's Purpose and Applications Navigating the Revit Interface and Essential Tools Mastering Navigation and Viewport Controls Creating and Managing Projects II. Project Setup (1 hour) Initiating a New Project Configuring Project Levels, Grids, and Site Information Defining Project Units for Precision III. Basic Modeling Techniques (2 hours) Building Walls, Doors, and Windows Designing Floors, Ceilings, Roofs, Stairs, and Railings IV. Advanced Modeling Skills (4 hours) Crafting Custom Parametric Families Utilizing Conceptual Modeling Tools Designing Complex Forms and Shapes Enhancing Models with Lighting and Materials Achieving Realism through 3D Rendering V. Views, Sheets, and Annotations (2 hours) Managing Views and Sheets Effectively Incorporating Schedules and Tags Crafting Detail Annotations for Construction Documents VI. Phasing, Worksharing, and Collaboration (2 hours) Understanding Phasing and Design Options Mastering Work Sharing and Collaboration Techniques VII. Project Collaboration and Management (1 hour) Establishing Work Sharing Environments Monitoring Worksets and User Activities Synchronizing Worksets for Seamless Collaboration VIII. Advanced Documentation Skills (2 hours) Creating Advanced Schedules and Legends Developing Construction Documents with Sheets and Title Blocks Customizing Schedules and Keynotes for Precision IX. Course Conclusion and Next Steps (1 hour) Reviewing Course Highlights Exploring Further Learning Resources and Tips Interactive Q&A Session and Feedback Opportunities Download Revit Master Revit Proficiency: Acquire advanced skills in Revit for 3D modeling, parametric design, and efficient project management. Craft Complex Architectural Designs: Create intricate building components, custom families, and detailed construction documents. Seamless Collaboration: Expertise in project collaboration, phasing, and work sharing, ensuring smooth teamwork and synchronization. Enhanced Visualization: Learn advanced rendering techniques for realistic 3D visualizations of architectural concepts. Customize Workflows: Adapt Revit tools, optimize workflows, and enhance efficiency in project execution. Career Opportunities: Architectural Designer: Create architectural plans, 3D models, and construction documents. BIM Specialist: Develop detailed digital models in collaboration with architects and engineers. Construction Documenter: Prepare comprehensive construction documents, including plans and schedules. Project Manager: Oversee projects, ensuring timely completion and adherence to design specifications. Revit Specialist/Trainer: Provide Revit training and support services to individuals, firms, or educational institutions. Elevate Your Revit Skills with Our Advanced Training! Our Revit Basic to Advanced Training Course is tailored to enhance your expertise in Autodesk Revit. Delivered through in-person or live online sessions, this program covers advanced modeling, parametric families, collaboration tools, and project phasing. Course Benefits: Master Advanced Skills: Learn intricate 3D modeling, design complex building components, and implement advanced BIM workflows. Expert Instruction: Industry professionals guide you through advanced concepts via engaging demonstrations and hands-on exercises. Flexible Learning: Choose in-person or live online sessions with interactive instruction and personalized guidance. Lesson Recordings: Access class recordings for convenient review and practice, reinforcing your learning. Lifetime Support: Benefit from lifetime email support for ongoing guidance from our experienced instructors. Enhance your Revit proficiency, streamline design processes, and boost project efficiency. Whether you're an architect, engineer, or design professional, this course unlocks advanced Revit skills. Join our training for comprehensive learning and expert support! Individualized Training: Experience personalized attention and tailored guidance. Flexible Learning Hours: Select your preferred schedule for training sessions. Ongoing Support: Access complimentary online assistance even after course completion. Comprehensive Learning Materials: Receive detailed PDF resources for effective learning. Certificate of Attendance: Earn a certificate acknowledging your course completion. Affordable Pricing: Enjoy budget-friendly training rates. Software Setup Help: Get assistance with software configuration on your device. Referral Benefits: Receive discounts on future courses by referring a friend. Group Discounts: Avail special rates for group training sessions. Extended Availability: Access training sessions every day with extended operating hours. Customized Curriculum: Engage in tailored training designed to meet your specific requirements.

Revit Basic to Advanced Training Course
Delivered in London or OnlineFlexible Dates
£636

Level 2 Certificate in Travel & Tourism Course- CPD Certified

5.0(3)

By School Of Health Care

Travel & Tourism: Travel & Tourism Course Online Even in the wake of intensifying economic and political pressures on a global basis, the travel and tourism industry continues to grow, expand, and diversify. The Travel & Tourism: Travel & Tourism Course is designed to provide students with a thorough understanding of this industry. More countries than ever before rely on tourism to fuel both local and national economies, and the industry is always in need of talented, dedicated, and resourceful professionals. As the majority of modern business sectors falter, global travel remains unaffected and grows in importance. With so many countries and regions around the world relying on travel and tourism as key economic drivers, those with the required backgrounds and talents are in high demand. Travel and tourism is a thriving industry, and those who want to travel are always in need of assistance when it comes to vacation and travel plans. If you enjoy traveling and providing excellent customer service, this Travel & Tourism: Travel & Tourism Course is just what you need. This Travel & Tourism: Travel & Tourism Course aims to provide you in-depth knowledge of Travel and Tourism, putting you on the right track to starting a career in Travel and Tourism. After completing this Travel & Tourism: Travel & Tourism Course, you will have a solid understanding of working in the travel and tourism industry, and you may even be able to start your own Travel and Tourism business. Main Course: Level 2 Certificate in Travel and Tourism Course Free Courses included with Travel & Tourism: Travel & Tourism Course: Along with Level 2 Certificate in Travel and Tourism Course you will get free Level 5 Diploma in Business Analysis Along with Level 2 Certificate in Travel and Tourism Course you will get free Level 3 Business Administration Special Offers of this Travel & Tourism: Travel & Tourism Course; This Travel & Tourism: Travel & Tourism Course includes a FREE PDF Certificate. Lifetime access to this Travel & Tourism: Travel & Tourism Course Instant access to this Travel & Tourism: Travel & Tourism Course 24/7 Support Available to this Travel & Tourism: Travel & Tourism Course Travel & Tourism: Travel & Tourism Course Online Airports, airlines, and international aviation are all covered in our Travel & Tourism: Travel & Tourism Course. The management of tour operations and the significance of efficient distribution in the travel and tourism sector are part of this Travel & Tourism: Travel & Tourism Course. Also, the Travel & Tourism: Travel & Tourism Course includes human resource management. You will learn how to manage the countryside for tourism in the Travel & Tourism: Travel & Tourism Course. Who is this course for? Travel & Tourism: Travel & Tourism Course Online This Travel & Tourism: Travel & Tourism Course is suitable for anyone who is looking to work in the travel industry. Requirements Travel & Tourism: Travel & Tourism Course Online To enrol in this Travel & Tourism: Travel & Tourism Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Travel & Tourism: Travel & Tourism Course. Be energetic and self-motivated to complete our Travel & Tourism: Travel & Tourism Course. Basic computer Skill is required to complete our Travel & Tourism: Travel & Tourism Course. If you want to enrol in our Travel & Tourism: Travel & Tourism Course, you must be at least 15 years old. Career path Travel & Tourism: Travel & Tourism Course Online After completing this Travel & Tourism: Travel & Tourism Course, you may be able to pursue a variety of promising career opportunities. This Travel & Tourism: Travel & Tourism Course includes: Travel agent Holiday rep Sales coordinator Customer care representative

Level 2 Certificate in Travel & Tourism Course- CPD Certified
Delivered Online On Demand1 hour
£12

Electronic Device and Circuits Protection Training

4.9(27)

By Apex Learning

Overview This comprehensive course on Electronic Device and Circuits Protection Training will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Electronic Device and Circuits Protection Training comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Electronic Device and Circuits Protection Training. It is available to all students, of all academic backgrounds. Requirements Our Electronic Device and Circuits Protection Training is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 13 sections • 33 lectures • 13:07:00 total length •1.1 Introduction to the Course: 00:01:00 •2.1 Diode Introduction: 00:01:00 •2.2 Diode Working: 00:04:00 •2.3 Using Diode in Series: 00:02:00 •2.4 Using Diode in Parallel: 00:02:00 •2.5 Diode Protection: Relay Example: 00:01:00 •2.6 Diode Selection: 00:01:00 •3.1 Introduction to Fuses: 00:01:00 •3.2 Fast Blow Fuse vs Slow Blow Fuse: 00:02:00 •3.3 Selection of Fuses: 00:01:00 •4.1 Re-settable Fuse Introduction: 00:01:00 •4.2 Re-settable Fuse Working: 00:01:00 •4.3 Re-settable Fuse Selection: 00:01:00 •5.1 Introduction: 00:01:00 •5.2 Selection of Circuits: 00:01:00 •6.1 Transient Voltage Suppressors: 00:02:00 •7.1 Bypass capacitors: 00:02:00 •8.1 Zener Diode Introduction: 00:01:00 •8.2 Zener Diode Circuit: 00:01:00 •8.3 Zener Diode Selection: 00:01:00 •9.1 TVS Diode Introduction: 00:01:00 •9.2 TVS Diode Working: 00:03:00 •9.3 TVS Diode Selection: 00:01:00 •10.1 MOV Introduction: 00:01:00 •10.2 MOV Characteristics: 00:01:00 •10.3 MOV Selection: 00:01:00 •11.1 GDT Working: 00:03:00 •11.2 GDT Selection: 00:01:00 •12.1 Power Supply Introduction: 00:01:00 •12.2 Under-voltage Protection: 00:02:00 •12.3 Over-voltage Protection: 00:01:00 •12.4 Short Circuit Protection: 00:02:00 •Assignment - Electronic Device and Circuits Protection Training: 2 days, 12 hours

Electronic Device and Circuits Protection Training
Delivered Online On Demand13 hours 7 minutes
£12

Agile Scrum Master Certification

4.5(3)

By Studyhub UK

Unlock the door to innovation and efficiency with our 'Agile Scrum Master Certification' course. Dive into a transformative learning experience that transcends traditional development models, equipping you with the skills to thrive in the dynamic landscape of Agile methodologies. This course, guided by the 2020 Scrum Guide, is your gateway to mastering Scrum principles, events, artifacts, and scaling techniques. Delight in a bonus full eBook, providing you with a comprehensive resource to solidify your Agile expertise. Learning Outcomes Understand the evolution from traditional development models to the Agile framework. Master the core principles and practices outlined in the 2020 Scrum Guide. Navigate the intricacies of Scrum teams, events, and artifacts for effective project management. Explore advanced topics such as Agile requirements, estimation techniques, and metrics. Prepare for the PSM1 certification with expert guidelines, tips, and tricks. Why choose this Agile Scrum Master Certification? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Agile Scrum Master Certification for? Project managers seeking to enhance their project delivery efficiency. Aspiring Scrum Masters eager to lead Agile teams to success. Professionals transitioning to Agile methodologies for project management. Team members looking to contribute effectively in Agile environments. Individuals preparing for the PSM1 certification. Career path Agile Scrum Master: £40,000 - £65,000 Project Manager (Agile Focus): £45,000 - £70,000 Agile Coach: £50,000 - £80,000 Product Owner: £42,000 - £68,000 Senior Project Manager (Agile): £55,000 - £90,000 Scrum Trainer: £60,000 - £100,000 Prerequisites This Agile Scrum Master Certification does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Agile Scrum Master Certification was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum OBJECTIVES AND TARGETS Objectives and Targets 00:09:00 Download: course curriculum in pdf 00:05:00 FROM THE TRADITIONAL DEVELOPMENT MODEL TO THE AGILE Waterfall. Typical challenges 00:05:00 Agile history and 2001's Manifesto 00:11:00 Agile. A different approach 00:04:00 Agile benefits 00:02:00 When agile is best applied + success factors 00:03:00 Download: Agile Vs Waterfall. Overview diagram 00:01:00 Download: Agile Vs Waterfall side by side by project stage 00:04:00 2020 SCRUM GUIDE: WHAT'S NEW! 2020 SCRUM GUIDE: WHAT'S NEW! 00:22:00 BONUS: FULL EBOOK OF THE COURSE! BONUS - Full eBOOK of the Course 00:01:00 SCRUM Download: the Scrum Guide 00:14:00 Download: the Scrum Glossary 00:08:00 Download: Framework Navigator 00:01:00 Scrum introduction 00:12:00 Theory and values 00:08:00 THE SCRUM TEAM The Scrum Team - Introduction 00:08:00 Product, Product Goal and Product Owner 00:14:00 Developers 00:03:00 The scrum master 00:08:00 Characteristics of a perfect scrum master 00:23:00 SCRUM EVENTS Introduction 00:03:00 The Sprint 00:06:00 Download: Diagram of a typical Sprint (with events, roles, artifacts) 00:01:00 The sprint planning 00:10:00 The daily scrum 00:04:00 The sprint review 00:06:00 The sprint retrospective 00:05:00 SCRUM ARTIFACTS Product backlog 00:08:00 Sprint backlog 00:02:00 Increment and definition of done 00:04:00 Commitments 00:04:00 SCALING SCRUM Introduction 00:02:00 Scrum of scrums 00:02:00 Nexus framework 00:05:00 Download: the Nexus Framework poster 00:01:00 SCRUM IN PRACTICE ! A day in the life of a typical Sprint 00:32:00 AGILE REQUIREMENTS Products, Initiatives, Epics, Features, Stories and Tasks 00:11:00 ESTIMATION TECHNIQUES Underlying theory, t-shirt sizing, planning poker 00:09:00 Bucket system, affinity mapping, time unit 00:04:00 AGILE METRICS Underlying theory. Velocity 00:07:00 Sprint burn-down 00:08:00 Release burn-up, cumulative flow, other metrics 00:06:00 PSM1 CERTIFICATION PREPARATION GUIDELINES, TIPS & TRICKS How to best prepare for PSM I Certification 00:09:00 PSM1 CERTIFICATION PREPARATION GUIDELINES, TIPS & TRICKS PSM I EXAM SIMULATOR #1 and #2 (80+80 HIGH QUALITY QUESTIONS. REAL MODE) 00:01:00 Assignment Assignment - Agile Scrum Master Certification 00:00:00

Agile Scrum Master Certification
Delivered Online On Demand5 hours 16 minutes
£10.99

Financial Investigator Complete Bundle - QLS Endorsed

By Imperial Academy

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

Financial Investigator Complete Bundle - QLS Endorsed
Delivered Online On Demand
£599

Microsoft Excel Advanced

By Microsoft Office Training

Course Objectives At the end of this course you will be able to: Work with advanced lookup and reference functions Create macros to automate common tasks Use advanced techniques to analyse data Create PivotTables and PivotCharts Work with data validation tools Import and export data ' Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic. Marving Lopez - AM Best Europe Pedro was excellent. Very knowledgeable, clear and great rapport with class. Darren Barkey - Direct Wines Great content and learnt a lot. Really enjoyable :) Kristie-Lee Ryan - Stirling Ackroyd 1 year email support service Take a closer look at the consistent excellent feedback visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering classrom, one to one, tailored and bespoke courses. Tailored In Company training: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Advanced Functions COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL IF, OR, AND, IFERROR VLOOKUP to lookup Exact Values and Approximate values MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET Analysing Data PMT function to calculate a monthly payment of a loan What If Analysis using Goal Seek Use scenarios to consider many different variables Using Solver Add-in to optimize variables PivotTables Create a PivotTable to analyse worksheet data Add or remove fields in a PivotTable Change the data source for a PivotTable Working with external data sources Using different Statistical Functions Calculate a Running Total, % of Grant Total, Difference From… Using the Slicer and Timeline to filter the PivotTable Using Filters in a PivotTable Group by Date, Auto Group by ranges of values, Custom Group Create a PivotChart The GETPIVOTDATA function Formula auditing Precedents and dependents Error checking Watch a formula and its result by using the Watch Window Evaluate a nested formula one step at a time Data Validation Number Validation Data List Validation Message Prompts and Alerts Conditional Data Validation Data Validation Errors Consolidation Consolidate data by position Consolidate data by category Use a formula to consolidate data Outline (group) data in a worksheet Create an outline of rows Create an outline of columns Copy outlined data Hide or remove an outline Connect external data to your workbook Using the Power Query Editor to import data From Text and CSV, From Access, From Web, From another Workbook Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more. Deleting Applied Steps Refreshing your data Working with Form Controls; Buttons, Option Buttons and Scroll Bars Introduction to Macros Change Macro Security settings How to Record a macro Some Macro Examples Delete a macro Edit the macro to view the VBA code Copy part of a macro to create another macro Assign a macro to a button Who is this course for? Who is this course for? This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros. Requirements Requirements Preferably, delegates should have attended the Excel Intermediate course. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Certificates Certificates Certificate of completion Digital certificate - Included

Microsoft Excel Advanced
Delivered OnlineFlexible Dates
£550

Understanding Adverse Childhood Experiences

By Online Training Academy

Understanding Adverse Childhood Experiences Course is pivotal in today's world as it delves into the profound impact of adverse childhood experiences (ACEs) on individuals' lives. This course comprehensively examines the effects of ACEs, including physical and emotional abuse, neglect, sexual abuse, household dysfunction, bullying, parental substance abuse, discrimination, and racism. By understanding these factors, individuals gain insights into the root causes of various behavioral and psychological issues, equipping them with valuable skills to address and mitigate these challenges effectively. This knowledge is not only beneficial in personal growth but also holds significant relevance in professional settings, particularly in fields like social work, counseling, and education. In the UK job market, proficiency in handling ACEs-related issues enhances one's employability, with opportunities in social services, mental health organizations, and educational institutions. Salaries in this sector can range from £25,000 to £40,000 annually, depending on qualifications and experience. With the prevalence of ACEs on the rise, there is a growing demand for professionals equipped to address these issues, making this course increasingly valuable in today's society. Key Features: CPD Certified Free Certificate from Reed CIQ Approved Developed by Specialist Lifetime Access Course Curriculum Module 01: Introduction to Adverse Childhood Experiences Module 02: Effects of Adverse Childhood Experiences Module 03: Risk and Protective Factors Module 04: Physical and Emotional Abuse Module 05: Physical and Emotional Neglect Module 06: Sexual Abuse Module 07: Household dysfunction Module 08: Bullying Module 09: Parental Substance Abuse Module 10: Discrimination and Racism Learning Outcomes: Identify factors influencing adverse childhood experiences for comprehensive understanding. Evaluate the impact of abuse and neglect on emotional well-being critically. Analyze the complexities of sexual abuse, fostering a deeper understanding. Recognize household dysfunction and bullying, developing insights into prevention strategies. Assess the effects of parental substance abuse, gaining tools for intervention. Examine discrimination and racism, fostering awareness and promoting inclusivity. CPD 10 CPD hours / points Accredited by CPD Quality Standards Understanding Adverse Childhood Experiences 3:01:57 1: Module 01: Introduction to Adverse Childhood Experiences 18:38 2: Module 02: Effects of Adverse Childhood Experiences 17:58 3: Module 03: Risk and Protective Factors 21:07 4: Module 04: Physical and Emotional Abuse 18:21 5: Module 05: Physical and Emotional Neglect 15:46 6: Module 06: Sexual Abuse 16:21 7: Module 07: Household dysfunction 18:43 8: Module 08: Bullying 18:16 9: Module 09: Parental Substance Abuse 18:08 10: Module 10: Discrimination and Racism 17:39 11: CPD Certificate - Free 01:00 Who is this course for? This Understanding Adverse Childhood Experiences course is accessible to anyone eager to learn more about this topic. Through this course, you'll gain a solid understanding of Understanding Adverse Childhood Experiences. Moreover, this course is ideal for: Psychologists seeking advanced insights into human behaviour. Social workers aiming to enhance their support strategies. Educators committed to creating nurturing learning environments. Healthcare professionals dedicated to holistic patient care. Community advocates striving for social change. Requirements There are no requirements needed to enrol into this Understanding Adverse Childhood Experiences course. We welcome individuals from all backgrounds and levels of experience to enrol into this Understanding Adverse Childhood Experiences course. Career path After finishing this Understanding Adverse Childhood Experiences course you will have multiple job opportunities waiting for you. Some of the following Job sectors of Understanding Adverse Childhood Experiences are: Child Psychologist - £35K to 60K/year. Social Worker - £27K to 40K/year. Counsellor - £24K to 40K/year. Youth Worker - £20K to 35K/year. School Counsellor - £22K to 38K/year. Certificates Digital certificate Digital certificate - Included Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

Understanding Adverse Childhood Experiences
Delivered Online On Demand3 hours
£12

OTHM Level 5 Extended Diploma in Information Technology

By School of Business and Technology London

Getting Started The OTHM Level 5 Extended Diploma in Information Technology, aims to offer learners a strong groundwork for a career across various organisations. This program prepares each learner to be 'business ready,' possessing confidence, independent thinking abilities, a comprehensive understanding of Information Technology, and the aptitude to adapt to evolving circumstances swiftly. Certainly, here are the key points: - This qualification suits individuals either embarking on or contemplating a private or public sector business career. - Attaining the Level 5 Diploma in Information Technology opens up avenues for further educational pursuits or employment opportunities. Key Benefits Comprehend methods and strategies for protecting against cyber security threats and vulnerabilities. Acquire the capability to develop a software program that addresses a problem using object-oriented programming principles. Acquire the ability to create a system design utilising modelling techniques. Acquire the capability to develop a website or mobile application that meets client and user requirements. Develop the ability to assist and resolve computing issues and problems effectively. Comprehend the compliance requirements and regulations associated with digital information. Key Highlights Are you worried about the recent changes in the IT sector? Then, OTHM Level 5 Extended Diploma in Information Technology is the ideal starting point for your career journey. The course will ensure access to the first-class education needed to achieve your goals and dreams and maximise future opportunities. Remember! The assessment for the qualification is done based on assignments only, and you do not need to worry about writing any exam. With the School of Business and Technology London, you can complete the qualification at your own pace, choosing online or blended learning from the comfort of your home. Learning and pathway materials and study guides developed by our OTHM-approved tutors will be available around the clock in our cutting-edge learning management system. Most importantly, at the School of Business and Technology London, we will provide comprehensive tutor support through our dedicated support desk. If you choose your course with blended learning, you will also enjoy live sessions with an assigned tutor, which you can book at your convenience.   Career Pathways After completing a Level 5 Extended Diploma in Information Technology, individuals can explore various career opportunities in the legal field and related professions. Here are some potential career paths:  Software Developer with an average salary of £46,384 per year Cyber security Analyst with an average salary of £49,002 per year Database Administrator, with an average salary of £41,063 per year IT Support Specialist with an average salary of £33,824 per year. 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 Assignment-based assessment (Formative and Summative) No exam Entry Requirements These qualifications are intended for learners typically 18 years and older. Learners' entry profiles are expected to encompass at least one of the following criteria:  A relevant Level 3 Diploma qualification or its equivalent credential. Completion of GCE Advanced level courses in 2 subjects or an equivalent qualification. Mature learners aged over 21 with pertinent management experience (prior experience verification required from the delivery centre before registration) International students whose first language is not English must score 5.5 or above in IELTS (International English Language Testing System).   Progression Successful completion of the OTHM Level 5 Extended Diploma in Information Technology provides learners the opportunity to: Option for OTHM Level 6 Extended Diploma in Information Technology or Learners may be eligible to gain direct entry into the final year of a three-year UK Bachelor's degree. Why gain a OTHM Qualification? Quality, Standards and Recognitions- OTHM qualifications are approved and regulated by Ofqual (Office of the Qualifications and Examinations Regulation); hence, the learners can be very confident about the quality of the qualifications as well. Career Development to increase credibility with employers- All OTHM qualifications are developed to equip learners with the skills and knowledge every employer seeks. The learners pursuing an OTHM qualification will obtain an opportunity to enhance their knowledge and grow key competencies to tackle situations and work on projects more effectively, which will, in turn, give learners the potential to get promotions within the workplace. Alternatively, it allows them to progress onto an MBA top-up/Bachelor's degree / Master's degree programme around the World. Flexible study options- All OTHM qualifications have a credit value, which tells you how many credits are awarded when a unit is completed. The credit value will indicate how long it will normally take you to prepare for a unit or qualification. Three different types of qualification are: The award is achieved with 1 - 12 credits The certificate is completed with 13 - 36 credits The diploma is completed with at least 37 credits 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- CYBER SECURITY Reference No : D/650/3383 Credit : 20 || TQT : 200 In this unit, learners will acquire foundational knowledge about cyber security, including its historical evolution, legal and regulatory aspects, risk assessment and management, and its repercussions on individuals and organisations. Additionally, learners will gain insights into methods for safeguarding against cyber threats and how to respond to a cyber security breach effectively. UNIT2- PRINCIPLES OF COMPUTER PROGRAMMING Reference No : F/650/3384 Credit : 20 || TQT : 200 This unit aims to provide learners with a foundational comprehension of object-oriented programming languages and the ability to create efficient code. Additionally, it offers learners insight into software development and fundamental principles of algorithms. UNIT3- SYSTEMS ANALYSIS AND DESIGN Reference No : F/617/2266 Credit : 20 || TQT : 200 This unit aims to cultivate learners' understanding of system analysis and design within an organisational context. This unit introduces learners to various techniques employed in systems analysis and design and the methodologies utilised in system development. UNIT4- WEB AND MOBILE APPLICATIONS Reference No : H/650/3385 Credit : 20 || TQT : 200 This unit aims to provide learners with knowledge about contemporary web and mobile application design technology, along with the practices and tools commonly employed in this field. Learners will gain the skills needed to develop websites or mobile applications according to the provided design specifications. UNIT5- COMPUTER AND NETWORK TECHNOLOGY Reference No : L/617/2268 Credit : 20 || TQT : 200 This unit offers learners an insight into the fundamental concepts of computer networking and cloud technologies, including their operational principles, protocols, standards, security aspects, and associated prototypes. Learners will delve into various hardware and software alternatives and gain proficiency in configuring and installing these technologies. UNIT6- MANAGING DIGITAL INFORMATION Reference No : J/650/3386 Credit : 20 || TQT : 200 This unit aims to demonstrate how communication, knowledge, and information can be enhanced within an organisation, including optimising the utilisation of IT systems. UNIT7- SOFTWARE ENGINEERING Reference No : K/617/2276 Credit : 20 || TQT : 200 This unit aims to provide learners with an understanding of software development, its evolution as an engineering discipline, and the ability to develop, maintain, and enhance high-quality software systems. UNIT8- DATABASE SYSTEMS Reference No : H/617/2275 Credit : 20 || TQT : 200 This unit aims to equip learners with knowledge in the development of database systems and to facilitate the development of robust skills in database design and development. UNIT9- ADVANCED SYSTEMS ANALYSIS & DESIGN Reference No : D/617/2274 Credit : 20 || TQT : 200 This unit aims to impart a comprehensive understanding of the roles of systems analysts and designers and enable learners to apply contemporary techniques associated with these roles. UNIT10- MANAGEMENT INFORMATION SYSTEMS Reference No : Y/617/2273 Credit : 20 || TQT : 200 This unit aims to provide learners with an understanding of how organisations utilise information to create, implement, maintain, and oversee secure information systems that facilitate their operations. This unit explores how systems can support essential business functions and empower organisations to enhance productivity and competitiveness in the global marketplace. UNIT11- NETWORK INFORMATION SYSTEMS Reference No : R/617/2272 Credit : 20 || TQT : 200 This unit aims to foster learners' understanding and proficiency in the planning, configuration, establishment, and administration of various network types, including LANs, PANs, MANs, and WANs. Additionally, it aims to cultivate skills in network monitoring and impart knowledge about Network Security, network protocols, and industry standards. UNIT12- IT PROJECT MANAGEMENT Reference No : L/617/2271 Credit : 20 || TQT : 200 This unit aims to cultivate learners' competencies in overseeing Information Technology projects aimed at implementing systems or effecting organisational change. 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.

OTHM Level 5 Extended Diploma in Information Technology
Delivered Online On Demand11 months
£1,439.94