35713 Courses

Explore using JavaScript XHR and fetch to connect to multiple web API endpoints retrieve JSON data and update HTML

Emergency First Responders When emergency strikes, response time and the right knowledge can make all the difference. The Emergency First Responders Course offers in-depth, structured training for those looking to gain essential first response knowledge. From ambulance basics to trauma emergencies, CPR, paediatric care, and oxygen equipment handling—this course is tailored to provide a strong foundation in emergency response procedures. With clearly outlined modules, it ensures learners understand how to assess situations swiftly, apply safe first aid techniques, and manage a wide range of medical incidents with confidence. Whether you're aiming to support your workplace, community, or simply boost your knowledge, this course covers what matters when every second counts. You’ll explore how to deal with fractures, catastrophic bleeding, unresponsiveness, airway issues, and more. The content is laid out in a logical sequence, building your understanding step by step. Suitable for both new learners and those refreshing their knowledge, this course is accessible online with flexible learning to suit your schedule. Whether you're a teacher, security personnel, carer, or simply a proactive citizen—this is an ideal way to become more prepared for emergency situations. Key Features CPD Certified Emergency First Responders course Instant e-certificate Fully online, interactive Emergency First Responders course with audio voiceover Developed by professionals in the field Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance From mastering the basics of ambulance care to navigating through trauma emergencies, our course leaves no stone unturned. You'll delve into the intricacies of dealing with fractures, catastrophic bleeding, and airway management with the precision of a seasoned professional. But it doesn't stop there. We guide you through the nuances of paediatric first aid, loss of responsiveness, CPR, and beyond, ensuring you're prepared for any medical emergency that comes your way. So, if you're ready to take on a journey where your knowledge becomes the beacon of hope for those in need, join us in redefining what it means to be an Emergency First Responders. Course Curriculum Module 01: Basics of Ambulance Care Module 02: Incident Survey: Primary & Secondary Survey Module 03: Dealing With Fractures and Dislocations Module 04: Catastrophic Bleeding and Airway Management Module 05: Trauma Emergencies Module 06: First Aid Treatment for Critical Injuries Module 07: First Aid: What to do & What not to do? Module 08: Medical Emergency Module 09: Paediatric First Aid for Common Illnesses Module 10: Loss of Responsiveness and CPR Module 11: Oxygen Equipment for First Aiders Module 12: Delivery Devices and Associated Risks Module 13: Oxygen Safety Learning Outcomes: Demonstrate proficiency in administering basic ambulance care procedures effectively. Conduct primary and secondary surveys proficiently during emergency incidents. Apply appropriate techniques for managing fractures and dislocations safely. Implement strategies for managing catastrophic bleeding and ensuring proper airway management. Identify and respond effectively to various trauma emergencies using first aid. Demonstrate competency in providing first aid for critical injuries confidently. Accreditation All of our courses, including this Emergency First Responders course, are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in Emergency First Responders. Certification Once you've successfully completed your Emergency First Responders course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). Our Emergency First Responders course certification has no expiry dates, although we do recommend that you renew them every 12 months. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Emergency First Responders course can be taken by anyone who wants to understand more about the topic. With the aid of this course, you will be able to grasp the fundamental knowledge and ideas. Additionally, this Emergency First Responders course is ideal for: Healthcare professionals seeking emergency response skills enhancement. Individuals pursuing careers in emergency first responders or paramedicine. Workers in high-risk environments requiring basic emergency response capabilities. Parents or guardians interested in learning paediatric first aid techniques. Community members keen on acquiring essential first aid knowledge. Requirements Learners do not require any prior qualifications to enrol on this Emergency First Responders course. You just need to have an interest in Emergency First Responders. Career path After completing this Emergency First Responders Course you will have a variety of careers to choose from. The following job sectors of Emergency First Responders are: Ambulance Care Assistant Emergency Medical Technician First Responder Paramedic Paediatric First Aider Oxygen Equipment Technician Certificates Digital certificate Digital certificate - Included Once you've successfully completed your course, you will immediately be sent a FREE digital certificate. Hard copy certificate Hard copy certificate - Included Also, you can have your FREE printed certificate delivered by post (shipping cost £3.99 in the UK). For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

The Carpet Cleaning Methods Course offers a thorough exploration of the essential techniques and knowledge needed to maintain and restore carpets to their best condition. Beginning with a solid introduction, the course guides learners through understanding different carpet types, recognising common stains, and applying the most effective cleaning methods. Each module builds upon the last, providing clear, detailed insight into the cleaning process and even carpet restoration. This course is ideal for anyone seeking to enhance their expertise in carpet care through a well-structured and accessible format. In addition, the course includes a complementary Life Coaching section designed to enrich personal development and communication skills. From self-awareness and emotional intelligence to effective client interaction and ethical considerations, these modules provide valuable tools that support professional growth. Together, these elements create a balanced learning experience focused on skill development without requiring physical attendance, making it an excellent option for flexible, online study. Whether you are beginning a new path or looking to refine your existing knowledge, this course delivers focused, practical information tailored to your needs. Key Features of This Carpet cleaner Course CPD Accredited Carpet cleaner Course Instant e-certificate Fully online, interactive Carpet cleaner course with audio voiceover Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Free Gifts Life Coaching Course Enrol now in this Carpet cleaner course to excel! To become successful in your profession, you must have a specific set of skills to succeed in today's competitive world. In this in-depth Carpet Cleaning Methods training course, you will develop the most in-demand skills to kickstart your career, as well as upgrade your existing knowledge & skills. The curriculum of the Carpet Cleaning Methods course has been designed by experts with years of experience behind them which is extremely dynamic and well-paced to help you understand the subject matter with ease. Course Curriculum of This Carpet cleaner Course: Carpet Cleaner Module 01: Introduction to Carpet Cleaning Module 02: Understanding Carpets Module 03: Identifying Carpet Stains Module 04: Carpet Cleaning Methods Module 05: Carpet Cleaning Process Module 06: Carpet Restoration Life Coaching Module 01: Life Coaching: The Purpose and Fundamentals Module 02: Develop Your Self-Awareness Module 03: The Development of Core Beliefs and Managing Fears Module 04: Life Coaching Types and Key Attributes of a Life Coach Module 05: Understanding Emotional Intelligence Module 06: Body Language and Communication Techniques Module 07: A Structure for Client Work and Goal Setting Module 08: Basic Principles for Business Development and Growth Module 09: The Ethical Coach: Protect Yourself and Your Clients Learning Outcomes: Understand the fundamentals of carpet cleaning methods. Identify different types of stains on carpets effectively. Execute efficient carpet cleaning processes with precision. Master the techniques for carpet restoration. Gain insights into various carpet types and their characteristics. Develop skills to maintain and preserve carpets in optimal condition. Accreditation All of our courses are fully accredited, including this Carpet cleaner Course, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in Carpet cleaner. Certification Once you've successfully completed your Carpet cleaner Course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). Our Carpet cleaner Course certification has no expiry dates, although we do recommend that you renew them every 12 months. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Carpet cleaner Course can be taken by anyone who wants to understand more about the topic. With the aid of this Carpet cleaner course, you will be able to grasp the fundamental knowledge and ideas. Additionally, this Carpet cleaner Course is ideal for: Individuals aspiring to start a career in carpet cleaning. Professionals seeking to enhance their expertise in carpet maintenance. Business owners aiming to train their cleaning staff. Anyone interested in learning about effective carpet cleaning methods and processes. Requirements Learners do not require any prior qualifications to enrol on this Carpet cleaner Course. You just need to have an interest in Carpet cleaner Course. Career path After completing this Carpet cleaner Course you will have a variety of careers to choose from. The following job sectors of Carpet cleaner Course are: Carpet Cleaner - £18K to 25K/year Carpet Cleaning Technician - £20K to 28K/year Carpet Restoration Specialist - £22K to 30K/year. Carpet Maintenance Supervisor - £24K to 32K/year. Carpet Cleaning Business Owner - £30K to 40K/year. Certificates Digital certificate Digital certificate - Included Once you've successfully completed your course, you will immediately be sent a FREE digital certificate. Hard copy certificate Hard copy certificate - Included Also, you can have your FREE printed certificate delivered by post (shipping cost £3.99 in the UK). For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

FREE Certification:QLS Endorsed + CPD Accredited | Instant Access | Round-the-Clock Tutor Support

Duration 5 Days 30 CPD hours This course is intended for Network engineers and technicians that are working in the enterprise sector. Overview - Describe the factors that led to the development of IPv6 and possible uses of this new IP structure - Describe the structure of the IPv6 address format, how IPv6 interacts with data link layer technologies, and how IPv6 is supported in Cisco IOS Software - Implement IPv6 services and applications - Understand the updates to IPv4 routing protocols needed to support IPv6 topologies - Understand multicast concepts and IPv6 multicast specifics - Evaluate the scenario and desired outcome and identify the best transition mechanism for the situation - Describe security issues, how security for IPv6 is different than for IPv4, and emerging practices for IPv6-enabled networks - Describe the standards bodies that define IPv6 address allocation, in addition to one of the leading IPv6 deployment issuesâ€'multihoming - Describe the deployment strategies that service providers might consider when deploying IPv6 - Describe case studies for enterprise, service provider, and branch networks This course is a five-day course aimed at providing network engineers and technicians that are working in the enterprise sector with the knowledge and skills that are needed to study and configure Cisco IOS Software IPv6 features. Introduction to IPv6 Explaining the Rationale for IPv6 Evaluating IPv6 Features and Benefits Understanding Market Drivers IPv6 Operations Understanding the IPv6 Addressing Architecture Describing the IPv6 Header Format Enabling IPv6 on Hosts Enabling IPv6 on Cisco Routers Using ICMPv6 and Neighbor Discovery IPv6 Services IPv6 Mobility Describing DNS in an IPv6 Environment Understanding DHCPv6 Operations Understanding QoS Support in an IPv6 Environment Using Cisco IOS Software Features IPv6-Enabled Routing Protocols Routing with RIPng Examining OSPFv3 Examining Integrated IS-IS Examining EIGRP for IPv6 Understanding MP-BGP Configuring IPv6 Policy-Based Routing Configuring FHRP for IPv6 Configuring Route Redistribution IPv6 Multicast Services Implementing Multicast in an IPv6 Network Using IPv6 MLD IPv6 Transition Mechanisms Implementing Dual-Stack Describing IPv6 Tunneling Mechanisms IPv6 Security Configuring IPv6 ACLs Using IPsec, IKE, and VPNs Discussing Security Issues in an IPv6 Transition Environment Understanding IPv6 Security Practices Configuring Cisco IOS Firewall for IPv6 Deploying IPv6 Examining IPv6 Address Allocation Understanding the IPv6 Multihoming Issue Identifying IPv6 Enterprise Deployment Strategies IPv6 and Service Providers Identifying IPv6 Service Provider Deployment Understanding Support for IPv6 in MPLS Understanding 6VPE Understanding IPv6 Broadband Access Services IPv6 Case Studies Planning and Implementing IPv6 in Enterprise Networks Planning and Implementing IPv6 in Service Provider Networks Planning and Implementing IPv6 in Branch Networks Lab Exercises Lab 2-1: Enabling IPv6 on Hosts Lab 2-2: Using Neighbor Discovery Lab 3-1: Using Prefix Delegation Lab 4-1: Routing with OSPFv3 Lab 4-2: Routing with IS-IS Lab 4-3: Routing with EIGRP Lab 4-4: Routing with BGP and MP-BGP Lab 5-1: Multicasting Lab 6-1: Implementing Tunnels for IPv6 Lab 7-1: Configuring Advanced ACLs Lab 7-2: Implementing IPsec and IKE Lab 7-3: Configuring Cisco IOS Firewall Lab 9-1: Configuring 6PE and 6VPE Configuration Files Summary Lab Activity Solutions Teardown and Restoration Additional course details: Nexus Humans Cisco IPv6 Fundamentals, Design and Deployment 3.0 (IP6FD) 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 Cisco IPv6 Fundamentals, Design and Deployment 3.0 (IP6FD) 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.

Duration 2 Days 12 CPD hours This course is intended for This course is intended for network engineers, network support personnel, reseller support personnel and anyone else needing a working knowledge of Network and Security Manager. Overview After successfully completing this course, you should be able to: Explain Network and Security Manager concepts and terminology. Set up and administer Network and Security Manager servers. Configure domains and administrators. Add devices using modeling and importing. Work with objects and templates. Configure policies. Perform routine device management tasks Work with logs and reports Configure VPNs with the VPN Manager tool This course discusses the basic operations of Network and Security Manager. Key topics include server and domain administration, device configuration, template creation and management, policy creation and management, logging, and report generation. Through demonstrations and hands-on labs, students gain experience in configuring, testing, and troubleshooting features of Network and Security Manager. Labs will be done on a ScreenOS platform Chapter 1: Course IntroductionChapter 2: Network and Security Manager Concepts Chapter 3: Server Administration Chapter 4: Domains and Administrators Chapter 5: Adding Devices Chapter 6: Abstraction Objects and TemplatesChapter 7: Abstraction Policies Chapter 8: Managing Devices Chapter 9: Logging, Reporting and Monitoring Chapter 10: Central ManagerChapter 11: Virtual Private Networks Additional course details: Nexus Humans Network and Security Manager Fundamentals 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 Network and Security Manager Fundamentals 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.

Level 1 health and safety in a construction environment Preparation to CSCS Green Card Are you excited to learn informative knowledge essential for working safely in construction? Then, our level 1 health and safety in a construction environment Preparation to CSCS Green Card course will be very helpful for you. This level 1 health and safety in a construction environment course includes risk assessment, hazard identification, and safe working practices. Participants in this level 1 health and safety in a construction environment Preparation to CSCS Green Card course learn about personal protective equipment (PPE) and accident prevention. Also, the level 1 health and safety in a construction environment Preparation to CSCS Green Card course is perfect to learn about risk assessment and emergency procedures. Moreover, this level 1 health and safety in a construction environment Preparation to CSCS Green Card course equips learners with the skills to maintain a safe work environment. Enrol in our level 1 health and safety in a construction environment Preparation to CSCS Green Card course to ensure compliance with health and safety regulations in construction settings. Learning outcome of level 1 health and safety in a construction environment Preparation to CSCS Green Card course Upon completion of this level 1 health and safety in a construction environment Preparation to CSCS Green Card course, you will learn: Overview of safety in construction, plumbing, and safeguarding. This level 1 health and safety in a construction environment Preparation to CSCS Green Card course teaches identifying risks. Building codes and regulations for construction are part of this level 1 health and safety in a construction environment Preparation to CSCS Green Card course. Our level 1 health and safety in a construction environment Preparation to CSCS Green Card course is also ideal for learning first aid basics and HVAC industry's safety. How to follow safety protocols for fire, electrical, and gas is described in this level 1 health and safety in a construction environment Preparation to CSCS Green Card course. Also, this level 1 health and safety in a construction environment Preparation to CSCS Green Card course explains chemicals and other onsite hazards. Vehicles, personal protective equipment (PPE), and general safety are also included in this level 1 health and safety in a construction environment course. After finishing this level 1 health and safety in a construction environment course, you will be fully prepared for CSCS. Special Offers of this CSCS - Health and Safety in a Construction Environment - Preparation to CSCS Green Card Course This Health and Safety in a Construction Environment - Preparation to CSCS Green Card Course includes a FREE PDF Certificate. Lifetime access to this Health and Safety in a Construction Environment - Preparation to CSCS Green Card Course Instant access to this Health and Safety in a Construction Environment - Preparation to CSCS Green Card Course Get FREE Tutor Support to this Health and Safety in a Construction Environment - Preparation to CSCS Green Card Course Level 1 health and safety in a construction environment Preparation to CSCS Green Card Through this Level 1 health and safety in a construction environment Preparation to CSCS Green Card course, you can learn the fundamentals of the HVAC sector and how to adhere to safety regulations for gas, electricity, and fire. Moreover, the Level 1 health and safety in a construction environment Preparation to CSCS Green Card course explains vehicles, personal protective equipment (PPE), and general safety. Who is this course for? Health and Safety in a Construction Environment - Preparation to CSCS Green Card This Level 1 health and safety in a construction environment Preparation to CSCS Green Card certified course is required if you intend to begin working in the construction business in the United Kingdom. Special Note: Our Health and Safety in a Construction Environment - Preparation to CSCS Green Card Course is not a regulated course. If You want to get qualified, you can consider following options: Level 1 Award in the Principles of Health and Safety within the Workplace (RQF) NEBOSH National Certificate in Construction Health and Safety Level 1 Award in Health and Safety at Work (RQF) Health and Safety Management for Construction (UK) Level 1 Award in Health and Safety in a Construction Environment - Health and Safety in Construction - for the CSCS Green Card Level 1 Award in Health and Safety in a Construction Environment (RQF) Health and Safety Management for Construction (UK) Level 1 Award in Health and Safety in a Construction Environment (RQF) Level 1 Award in Health and Safety in a Construction Environment - Health and Safety in Construction - for the CSCS Green Card Requirements Health and Safety in a Construction Environment - Preparation to CSCS Green Card To enrol in this Preparation to CSCS Green Card Course, students must fulfil the following requirements. To join in our Preparation to CSCS Green Card Course, you must have a strong command of the English language. To successfully complete our Preparation to CSCS Green Card Course, you must be self driven. To complete our Preparation to CSCS Green Card Course, you must have a basic understanding of computers. A minimum age limit of 15 is required to enrol in this Preparation to CSCS Green Card Course. Career path Health and Safety in a Construction Environment - Preparation to CSCS Green Card This Level 1 health and safety in a construction environment Preparation to CSCS Green Card course paves the way for entry-level positions in construction, such as labourer, apprentice, or construction site assistant.

At Black & Gold Audio we offer beginner, intermediate, advanced and expert sessions for anyone aged 14 and over. The sessions are carried out either within our studios in Truro, Cornwall or remotely using ZOOM. They are designed around you the learner and your own specific wants and needs. Our tutor is an expert in the fields of acoustics, recording, traditional and electronic music composition, music production, sequencing, sound design, mixing and mastering, film, TV and game audio. Who is this course for?  Candidates who are interested in a more one to one based learning program remotely or within a professional industry standard environment, tuition is flexible regarding days, hours and regularity. Most importantly the tutor can design a program that it suited to you and your requirements, a meeting with the tutor can be arranged beforehand to discuss a learning plan for you. Flexible 1 to 1 tutoring is a great way to learn at your own pace with no pressures and with the support of an industry expert. You may also be interested in the RSL Music Production Grades 1-8 which we deliver on a 1 to 1 basis too, see HERE. What will I learn?  This is a very open ended question for these types of sessions, its about what you want to learn and our tutor will talk with you to figure out the a suitable program for your needs. We cater for beginners, intermediates, advanced and expert students. How will I learn? The aim of these courses is to build a basic to advanced knowledge and understanding in various specialist areas of the industry, each tailor made course will support your learning through progress tracking and access to some amazing learning resources provided by our tutor. Each session will focus and build upon the last so that you are eventually able to meet your desired end goal. What equipment do I use on the course? The Black & Gold Studio is equipped with a huge range of both industry standard recording equipment, hardware synthesizers, drum machines, fx processing and control surfaces, and that’s before we even get inside the computer!! You can be taught to use DAW’s such as Logic Pro X, Cubase, Pro Tools & Ableton Live as well as explore other 3rd party softwares such as NI Komplete, Izotope, Fabfilter, Waves and so many more.

Join our Microsoft Excel course and discover your hidden skills, setting you on a path to success in this area. Get ready to improve your skills and achieve your biggest goals. The Microsoft Excel course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The Microsoft Excel course is designed to teach you the important stuff quickly and well, helping you to get off to a great start in the field. So, what are you looking for? Enrol now! You will Learn The Following Things: Learn strategies to boost your workplace efficiency. Hone your skills to help you advance your career. Acquire a comprehensive understanding of various topics and tips. Learn in-demand skills that are in high demand among UK employers This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Microsoft Excel. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-to-one support from a dedicated tutor throughout your course. Study online - whenever and wherever you want. Instant Digital/ PDF certificate 100% money back guarantee 12 months access Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement After completing the Microsoft Excel course, you will receive your CPD-accredited Digital/PDF Certificate for £5.99. To get the hardcopy certificate for £12.99, you must also pay the shipping charge of just £3.99 (UK) and £10.99 (International). Who Is This Course for? This Microsoft Excel is suitable for anyone aspiring to start a career in relevant field; even if you are new to this and have no prior knowledge, this course is going to be very easy for you to understand.  On the other hand, if you are already working in this sector, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Microsoft Excel course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career Path The certification and skills you get from this Microsoft Excel Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors. Course Curriculum Unit 01: Excel from A-Z Course Introduction Excel from A-Z Course Intro 00:03:00 Excel Job Opportunities 00:03:00 Excel Job Types 00:04:00 Microsoft Excel Marketplace 00:04:00 What is Microsoft Excel? 00:04:00 Who is This Course For? 00:03:00 Unit 02: Getting Started With Excel Finding & Opening Excel 00:01:00 Excel's Start Screen 00:03:00 Explaining the Excel Interface 00:03:00 Excel Interface Continued 00:01:00 Excel Workbook vs. Excel Worksheet 00:02:00 Saving an Excel Document 00:04:00 Customizing the Quick Access Toolbar 00:02:00 Customizing the Excel Ribbon 00:03:00 Excel Shortcut Keys 00:02:00 Unit 03: Values, Referencing and Formulas Creating Excel Labels 00:03:00 Entering Numeric Values in Excel 00:03:00 Formatting Date Values in Excel 00:05:00 Building Basic Formulas in Excel 00:05:00 Order of Operations 00:06:00 Relative vs. Absolute Cell References 00:07:00 Unit 04: Intro to Excel Functions Excel Functions Explained 00:03:00 The SUM() Function 00:08:00 The MIN() & MAX() Function 00:04:00 The AVERAGE() Function 00:02:00 COUNT() Functions 00:05:00 Unit 05: Adjusting Excel Worksheets Moving & Copying Data 00:07:00 Insert & Delete Rows and Columns 00:05:00 Adjusting the Width and Height of Cells 00:05:00 Hiding and Unhiding Excel Rows and Columns 00:04:00 Renaming, Moving & Deleting Excel Worksheets 00:05:00 Adding Protection to Specific Cells 00:04:00 Protecting the Structure of a Workbook 00:02:00 Adding a Workbook Password to Open File 00:02:00 Unit 06: Visually Pleasing Cell Formatting Formatting Fonts and Cell Background Color 00:05:00 Adding Cell Borders 00:05:00 Formatting Data Appropriately 00:05:00 The Magic behind Excel's Format Painter 00:03:00 Creating Styles for Formatting Efficiency 00:06:00 Merging Cells for a Cleaner Look 00:03:00 The Power of Conditional Formatting 00:06:00 Unit 07: How to Insert Images and Shapes! Grab User's Attention using Illustrations 00:09:00 Customizing Icons 00:05:00 Create Compelling Graphics with SmartArt 00:06:00 Unit 08: Visualize Data with Charts The Commonly Used Column Chart 00:03:00 Changing the Chart Design.mp4 00:02:00 Formatting Elements of a Chart 00:06:00 Modifying the Data, Type & Location of a Chart 00:06:00 Unit 09: Excel's Printing Options Print Preview Options 00:04:00 Excel's Page Layout View 00:07:00 Printing a Specific Range of Cells 00:03:00 Converting Spreadsheets to PDF Files 00:02:00 Unit 10: Benefits of Using Excel Templates Why Create an Excel Template 00:01:00 How to Create an Excel Template 00:05:00 Unit 11: Working with Excel Datasets How to Prepare Data for Analysis 00:04:00 How to Sort Data in Excel 00:03:00 Multi-Level Sorting 00:03:00 Custom Sorting Datasets in Excel 00:02:00 Applying Filters to Datasets 00:05:00 Creating Subtotals within a Dataset 00:06:00 Converting Datasets into Tables 00:06:00 Little Slice of Pie Charts 00:05:00 Finding & Removing Duplicate Values 00:07:00 Unit 12: Excel Database Functions The SUMIF() Function 00:09:00 The DSUM() Function 00:08:00 The DSUM() Function Cont. 00:07:00 The SUBTOTAL() Function 00:06:00 Unit 13: Excel Data Validation What is Excel Data Validation? 00:02:00 Creating a Drop Down List with Data Validation 00:07:00 Different Types of Excel Data Validation 00:06:00 Adding Custom Alerts to Data Validation 00:07:00 Creating a Dynamic Drop Down List 00:03:00 Complex Validation: Dependent Drop Down List! 00:09:00 Unit 14: Excel PivotTables Creating an Excel Pivot Table 00:06:00 Modifying Excel PivotTables 00:06:00 Grouping & Filtering PivotTable Data 00:06:00 Drilling Down into PivotTable Data 00:02:00 Creating Pivot Charts & Utilizing Slicers 00:08:00 Unit 15: Excel's PowerPivot Add-In What is PowerPivot? 00:04:00 Activating the Excel PowerPivot Add-In 00:02:00 Creating Relationships between Data Tables.mp4 00:06:00 Using Data Models to Create PivotTables 00:05:00 How to Create PowerPivot KPI's 00:08:00 Unit 16: Excel's Conditional Functions Excels IF Function 00:05:00 IF() Function with AND() Criteria 00:05:00 IF() Function with OR() Criteria 00:05:00 Nesting Multiple IF() Functions 00:07:00 The COUNTIF() Function 00:04:00 Key Benefits of Named Ranges 00:04:00 Unit 17: Excel's Lookup Function VLOOKUP() Function 00:09:00 The Beauty of Excel's IFERROR() Function 00:04:00 HLOOKUP() Function 00:06:00 The INDEX Function 00:05:00 MATCH() Function 00:05:00 INDEX() and MATCH() Combined 00:05:00 Two-Way Lookup with INDEX() and MATCH() 00:04:00 Unit 18: Text Based Functions in Excel LEFT(), RIGHT() and MID() Function 00:07:00 Extracting Specific Text using LEN() & SEARCH() 00:13:00 Combining Text with CONCATENATE() 00:06:00 Quick Tips & Other Text Based Functions 00:06:00 Unit 19: Auditing Formulas and Views in Excel Tracing Precedents & Dependents in Formulas 00:04:00 Showing Formulas 00:02:00 Grouping Data 00:03:00 3D Referencing in Formulas 00:05:00 Utilizing the Watch Window in Excel 00:03:00 How to Freeze Panes in Excel 00:03:00 Unit 20: Excel's 'what If?' Tools Excel's Scenario Manager Tool 00:06:00 Goal Seek in Excel 00:06:00 Compare Results with Excel Data Tables 00:04:00 Solver Tool 00:11:00 Unit 21: Welcome to Excel VBA The Power Behind Excel VBA 00:03:00 A Look Inside the Visual Basic Editor (VBE) 00:04:00 Recording a Macro 00:09:00 Saving & Opening a Macro-Enabled Workbook 00:02:00 Unit 22: The VBA Language Modules and Procedures 00:07:00 Objects, Methods and Properties 00:06:00 Excel VBA Variables 00:05:00 Unit 23: Writing VBA Code Referencing a Range 00:13:00 InputBox & MsgBox 00:06:00 Using Variables in VBA Code 00:05:00 If Then Else Statement 00:10:00 Worksheet Functions inside VBA 00:08:00 Creating User Defined Functions 00:09:00 User Defined Functions within VBA Scripts 00:06:00 Unit 24: Important VBA Tools and Logic Find Last Row of Data 00:06:00 Find Last Column of Data 00:03:00 With Statement 00:05:00 Debugging & Error Handling 00:07:00 Debugging & Error Handling Cont. 00:07:00 Unit 25: Excel VBA Loop For Next Loop 00:09:00 Do Until Loop 00:06:00 For Each Loop 00:04:00 Unit 26: Triggering Macros Assigning Macros to Shapes 00:04:00 Form Controls vs ActiveX Controls 00:08:00 Worksheet Events 00:04:00 Workbook Events 00:03:00 Fun with VBA Events! 00:07:00 Unit 27: Excel User Forms Creating an Excel UserForm 00:03:00 Adding Controls to UserForms 00:10:00 How to Show an UserForm 00:03:00 Passing TextBox Values to Desired Cells 00:07:00 Passing Option Buttons to Desired Cells 00:07:00 UserForm ComboBoxes 00:08:00 Clearing Values from UserForm Controls 00:03:00 How to Close an UserForm 00:02:00 UserForms and Protected Sheets 00:05:00 Unit 28: Starting a Career in Excel Creating an Excel Resume 00:05:00 Getting Started with Freelancing 00:06:00 How to Become an Excel Freelancer 00:05:00 Top Freelance Websites 00:05:00 How to Get Your First Client 00:08:00 Personal Branding 00:07:00 Networking Do's and Don'ts 00:04:00 Importance of Having a Website 00:04:00 Resources Resources - Microsoft Excel 00:00:00

Unleash your inner storyteller and craft compelling tales of intrigue, mystery, and suspense. This Level 2 Crime Fiction Writing course is designed for aspiring authors who are fascinated by the art of writing whodunits, psychological thrillers, and detective fiction. With carefully structured modules, you’ll explore narrative techniques, character psychology, plot architecture, and the secrets to building tension that keeps readers hooked from page one to the final reveal. Whether you're polishing your manuscript or scribbling your first murder mystery, this course guides you through essential concepts in crime fiction writing. From red herrings to gripping dialogue, you’ll learn how to shape authentic storylines that keep readers second-guessing. Study flexibly, sharpen your craft at your own pace, and enjoy the satisfaction of shaping narratives where every detail matters—especially the ones you don’t reveal until the end. Learning Outcomes: Develop well-rounded, realistic characters that drive the story forward. Construct a compelling plot that keeps readers engaged from start to finish. Use settings effectively to enhance the mood and tone of their writing. Write effective dialogue that reveals the character and advances the story. Understand the key elements of crime fiction and how to use them to create a unique voice and style. The Crime Fiction Writing Certificate Level 2 course is designed to provide students with a comprehensive understanding of crime fiction writing. The course is divided into three lessons, each of which covers a different aspect of crime fiction writing. In the first lesson, students will learn about the basic elements of crime fiction writing, including character development, plot, setting, and dialogue. This lesson provides a solid foundation for the rest of the course and sets the stage for students to develop their skills further. In the second lesson, students will focus on refining their writing skills, with an emphasis on creating engaging characters and compelling plots. This lesson covers techniques for developing characters that readers will care about, as well as strategies for creating tension and suspense in the plot. In the third and final lesson, students will learn about the business of writing, including how to submit their work to publishers and agents. This lesson also covers strategies for building a platform and marketing their work. How is the course assessed? Upon completing an online module, you will immediately be given access to a specifically crafted MCQ test. For each test, the pass mark will be set to 60%. Exam & Retakes: It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable. Certification Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The course is ideal for highly motivated individuals or teams who want to enhance their professional skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path The Crime Fiction Writing Certificate Level 2 course prepares students for a range of careers in the writing industry. Some potential career paths include: Crime fiction author £10,000 to £100,000 per year. Screenwriter £25,000 to £80,000 per year, Copywriter £20,000 to £50,000 per year Editor £18,000 to £50,000 per year Certificates Certificate of completion Digital certificate - £9 You can apply for a CPD Accredited PDF Certificate at the cost of £9. Certificate of completion Hard copy certificate - £15 Hard copy can be sent to you via post at the expense of £15.