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

35812 Courses in Cardiff delivered Online

Diploma in Child Safety Online

4.3(43)

By John Academy

Description A good childhood and youth development completely depend on the environment they live in and grow up. Social networking is hugely popular nowadays. Due to the modern channels of communication and entertainments children tend to spend more time in online than sports and so parents should be ever more vigilant in making sure that their children are not being harmed through online or their safety are not being compromised. Many young people are sophisticated in the way they use social media apps and websites, tailoring their communication for different audiences, and accessing them from a range of devices including smartphones, tablets, and games consoles. But social media, like all forms of public communication, comes with some risks. Not all of these risks turn into actual problems; and if children never face any risks, they never learn how to deal with them. By helping your child understand what the risks are, you can play a big part in preventing them from turning into problems. This course has been designed to teach you all fundamental elements of child safety online and the strategies how to protect your children from harm. Who is the course for?  This course is for people who are willing to teach the children about their personal safety around the neighbourhood. This course is for individuals who are willing to help in keeping the neighbourhood safe. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Diploma in Child Safety Online is a useful qualification to possess, and would be beneficial for the following careers: Child care worker Social worker Child care instructor. Diploma in Child Safety Introduction to Child Safety 00:30:00 Warning Signs 01:00:00 Parental Monitoring 00:15:00 Monitoring and Protection Software 01:00:00 Tips to Avoid Sexual Predators 00:30:00 The Truth About Online Content 01:00:00 Identity Theft 00:30:00 Spyware And Malware 01:00:00 The Children's Online Privacy Protection Act (COPPA) 00:15:00 Privacy Policy 00:15:00 Social Networking Safety 01:00:00 Additional Rules For Child Safety Online 00:30:00 Warnings For Children Online 00:15:00 Additional Tips For Parents 01:00:00 Mock Exam Mock Exam- Diploma in Child Safety Online 00:20:00 Final Exam Final Exam- Diploma in Child Safety Online 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Diploma in Child Safety Online
Delivered Online On Demand9 hours 40 minutes
£11.99

Clinical Governance Course

4.3(43)

By John Academy

Overview Clinical governance ensures the healthcare services people receive are of the highest standards. This Clinical Governance Training will give you a comprehensive introduction to clinical governance and explain how its various components can improve the quality of patient care.  Here, you'll understand how clinical governance is described using 7 key pillars and what NHS is in clinical governance. Moving forward, you'll discover a range of mechanisms to measure clinical effectiveness. Then, you'll explore the stages of clinical audit and understand what health information technology is used in health care. The course will also educate you about the ethical and legal aspects of health safety and how to maintain a safer workplace. Course Preview Learning Outcomes Discover the fundamentals of clinical governance Understand what NHS clinical governance is Enrich your knowledge of clinical audit to improve the quality of care Know the importance of information technology in healthcare Learn about the legal and ethical aspects of healthcare Why Take This Course From John Academy? Affordable, well-structured and high-quality e-learning study materials Meticulously crafted engaging and informative tutorial videos and materials Efficient exam systems for the assessment and instant result Earn UK & internationally recognised accredited qualification Easily access the course content on mobile, tablet, or desktop from anywhere, anytime Excellent career advancement opportunities Get 24/7 student support via email What Skills Will You Learn From This Course? Clinical Governance Clinical Governance Auditing Who Should Take this Clinical Governance Training? Whether you're an existing practitioner or an aspiring professional, this course is an ideal training opportunity. It will elevate your expertise and boost your CV with key skills and a recognised qualification attesting to your knowledge. Are There Any Entry Requirements? This Clinical Governance Training is available to all learners of all academic backgrounds. But learners should be aged 16 or over to undertake the qualification. And a good understanding of the English language, numeracy, and ICT will be helpful. Certificate of Achievement After completing this course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates & Transcripts can be obtained either in Hardcopy at £14.99 or in PDF format at £11.99. Career Path​ The Clinical Governance Training Course provides essential skills that will make you more effective in your role. It would be beneficial for any related profession in the industry, such as: Clinical Manager Healthcare Administration Specialist Healthcare Administrative Assistant Facility Operations Specialist Facility Project Manager Health Information Manager Front Desk Executive Module 01: Introduction to Clinical Governance Introduction to Clinical Governance 00:16:00 Module 02: The 7 Pillars of Clinical Governance The 7 Pillars of Clinical Governance 00:14:00 Module 03: National Health Services National Health Services 00:28:00 Module 04: Clinical Effectiveness: Part 1 Clinical Effectiveness Part 1 00:23:00 Module 05: Clinical Effectiveness: Part 2 Clinical Effectiveness Part 2 00:22:00 Module 06: Clinical Audit Clinical Audit 00:33:00 Module 07: Confidentiality in a Medical Environment Confidentiality in a Medical Environment 00:14:00 Module 08: Information Technology in Health Care Information Technology in Health Care 00:14:00 Module 09: Legal aspects and Ethics Legal aspects and Ethics 00:19:00 Module 10: Maintaining Workplace Safety Maintaining Workplace Safety 00:20:00 Module 11: Covid-19 Awareness Covid-19 Awareness 00:29:00 Assignment Assignment - Clinical Governance - Level 3 00:00:00 Order Your Certificate and transcript Order Your Certificate 00:00:00

Clinical Governance Course
Delivered Online On Demand3 hours 52 minutes
£11.99

Microsoft Office 2007 Excel Advanced - Complete Video Course

4.3(43)

By John Academy

Description: This Microsoft Office 2007 Excel Advanced - Complete Video Course builds on knowledge gained in the Introduction and Intermediate courses. In Advanced Microsoft Office Excel 2007, you will explore the many data analysis tools available in Excel, such as formula auditing, goal seek, Scenario Manager and subtotals. Additionally, during this course you will use advanced functions, learn how to apply conditional formatting, filter and manage your data lists, create and manipulate PivotTables and PivotCharts and record basic macros. You will also learn to use key advanced financial, logical, text, statistical and math, and lookup functions, audit formulas for errors, analyze data using subtotals, goal seek and the scenario manager, use custom and conditional formatting, manage data with tables, filtering and sorting, create, edit and format PivotTables and PivotCharts, import and export date to and from a workbook, create and use macros. So, by taking this course you will have a complete understanding of the higher functions of Excel. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2007 Excel Advanced - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2007 Excel Advanced - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Advanced Functions Logical Functions FREE 00:08:00 Math and Statistical Functions 00:06:00 Financial Functions 00:03:00 Displaying and Printing Formulas 00:02:00 Lookups and Data Tables Using Lookup Functions 00:03:00 Using MATCH and INDEX 00:01:00 Creating Data Tables 00:03:00 Advanced List Management Validating Cell Entries 00:01:00 Exploring Database Functions 00:01:00 PivotTables and PivotCharts Working with PivotTables 00:04:00 Rearranging PivotTables 00:02:00 Formatting PivotTables 00:02:00 PivotCharts 00:01:00 Exporting and Importing Exporting and Importing Text Files 00:07:00 Exporting and Importing XML Data 00:02:00 Querying External Databases 00:03:00 Analytical Options Goal Seek and Solver 00:05:00 The Analysis ToolPak 00:01:00 Scenarios 00:02:00 Views 00:01:00 Macros and Custom Functions Running and Recording a Macro 00:02:00 Working with VBA Code 00:01:00 Creating Functions 00:05:00 Conditional Formatting and SmartArt Conditional Formatting with Graphics 00:03:00 SmartArt Graphics 00:02:00 Mock Exam Mock Exam- Microsoft Office 2007 Excel Advanced - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2007 Excel Advanced - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft Office 2007 Excel Advanced - Complete Video Course
Delivered Online On Demand1 hour 51 minutes
£11.99

Accredited Time Management Skills Training

4.3(43)

By John Academy

Description: Time management is the ability to know how to plan your time and how to utilise it well. Knowing about time management is very important to everyone, especially to professionals. This course in time management is specifically designed for sales entrepreneurs who want to know how to manage their time well. Learning about time management is essential to avoid wasting time for unnecessary things. You can learn and improve your time management skills through this course and become the best time manager and sales entrepreneur at the same time. Who is the course for? Entrepreneurs who are interested in learning about time management. People who have an interest in knowing how time management works. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: This Course would be beneficial for the following careers: Businessmen Entrepreneur Executive Director Management Consultant Sales Entrepreneur Top Executive. Time Management 1: Module One - Getting Started 00:30:00 Module Two - Setting SMART Goals 01:00:00 Module Three - Prioritizing Your Time 01:00:00 Module Four - Planning Wisely 01:00:00 Module Five - Tackling Procrastination 01:00:00 Module Six - Crisis Management 01:00:00 Module Seven - Organizing Your Workspace 01:00:00 Module Eight - Delegating Made Easy 01:00:00 Module Nine - Setting a Ritual 01:00:00 Module Ten - Meeting Management 01:00:00 Module Eleven - Alternatives to Meetings 00:30:00 Module Twelve - Wrapping Up 01:00:00 Level 3 Diploma in Time Management- Activities 00:00:00 Time Management 2: Introduction 00:15:00 What Is Time Management? 01:00:00 Why Do I Need to Manage My Time Effectively Anyway? 00:30:00 What Happens When We Don't Manage Our Time Effectively? 00:30:00 How Do I Get Started With Good Time Management? 01:00:00 Refining the Process of Time Management 01:00:00 Can Time Management Become An Obsession? 00:30:00 So How Do I Stop Obsessing And Get Back On Track? 01:00:00 Keeping It Real - Setting Realistic Goals With Your Time Management 01:00:00 Conclusion 00:15:00 Mock Exam Mock Exam- Accredited Time Management Skills Training 00:30:00 Final Exam Final Exam- Accredited Time Management Skills Training 00:30:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Accredited Time Management Skills Training
Delivered Online On Demand19 hours
£11.99

Level 3 Diploma in Microsoft Outlook 2007

4.3(43)

By John Academy

Description: Microsoft Outlook is a free email and calendar application that can help you stay organised and be more productive. To know about Microsoft Outlook, you will not only help in organising emails but it can also help you in being more efficient and effective in working. Through this course, you will learn the skills, knowledge, and information needed to learn about Microsoft Outlook 2007. Know how to organise your emails and files the way you want it. Who is the course for? Professionals who want to learn about Microsoft Outlook 2007 functions and features. People who have an interest in knowing advanced Microsoft Outlook 2007 features. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Level 3 Diploma in Microsoft Outlook 2007 is a useful qualification to possess and will be very beneficial and helpful, especially to the following professionals: Administrative Assistant Administrator Office Manager Personal Assistant Microsoft Outlook 2007 for Beginners Module One - Getting Started 00:30:00 Module Two - Opening and Closing Outlook 01:00:00 Module Three - Working with E-mail 01:00:00 Module Four - Creating a New E-mail 01:00:00 Module Five - Managing E-mail 01:00:00 Module Six - Managing Junk Mail 01:00:00 Module Seven - Outlook's Organization Tools 01:00:00 Module Eight - Searching for Items 01:00:00 Module Nine - An Introduction to the Calendar 01:00:00 Module Ten - An Introduction to Tasks 01:00:00 Module Eleven - An Introduction to Contacts 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft Outlook 2007 for Beginners 00:00:00 Microsoft Outlook 2007 Advanced Level Module One - Getting Started 00:30:00 Module Two - Customizing Outlook 01:00:00 Module Three - Adding Word Elements to an E-mail 01:00:00 Module Four - Customizing Your Profile 01:00:00 Module Five - Advanced E-Mail Tasks 01:00:00 Module Six - Advanced Calendar Tasks 01:00:00 Module Seven - Doing More with Tasks 01:00:00 Module Eight - Using Notes 01:00:00 Module Nine - Viewing RSS Feeds 01:00:00 Module Ten - Managing Outlook Data, Part One 01:00:00 Module Eleven - Managing Outlook Data, Part Two 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft Outlook 2007 Advanced Level 00:00:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Level 3 Diploma in Microsoft Outlook 2007
Delivered Online On Demand22 hours
£11.99

Diploma in Team Building

4.3(43)

By John Academy

It is almost impossible to even imagine a corporate world without a healthy and trained group of people working together to achieve the tasks which would be unachievable otherwise. With this course, learn how to make a solid team-building strategy that can create an environment of greater collaboration and unity. Learn the concepts that make up a great team, the factors that help it to be successful and also how to be an inspiring team role model. You will also learn how to face obstacles as a team and overcome them. With teams at the heart of corporate strategy, your success as an organization can often depend on how well you and other team members operate together. This course can definitely help you get there! Learning Outcomes: The price of working as a team How to develop team standard, ground rules, and team contracts Their team player methods as well as how it can be applied effectively Mediums to create team belief The phases of team development and how to assist a team go through them The sensitive role communication skills will contribute to building and managing a team atmosphere Paths in which team members can get engaged in and boost in a team setting 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? Diploma in Team Building 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 Diploma in Team Building 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: 1 Defining Teams 00:15:00 Establishing Team Norms 00:15:00 Working as a Team 00:15:00 Your Team Player Type 01:00:00 Building Team Trust 00:15:00 The Stages of Team Development 00:30:00 Communication 00:30:00 Becoming a Good Team Player 00:15:00 Module: 2 Types of Teams 00:15:00 The TORI Team Building Model 00:15:00 The Five Stages of Team Development 00:30:00 Characteristics of Great Teams 00:15:00 Clear Roles and Assignments 00:15:00 Team Player Types 00:30:00 The Trust/Relationship Model 00:05:00 Lateral and Vertical Thinking 00:05:00 Creative Team Thinking 00:45:00 Team Shaping Factors 00:15:00 Solving Problems 00:30:00 Interventions for Team Leaders 00:30:00 Resolving Conflict 00:15:00 SWOT Analysis 00:15:00 Developing Team Action Plans 00:15:00 Mock Exam Mock Exam- Diploma in Team Building 00:30:00 Final Exam Final Exam- Diploma in Team Building 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Diploma in Team Building
Delivered Online On Demand9 hours 10 minutes
£11.99

Excel VBA/Macros Foundations

4.5(3)

By Studyhub UK

A Complete Guide for Effective LinkedIn Ads' is a comprehensive course that covers the fundamentals of setting up and managing successful LinkedIn Ads campaigns. Participants will learn to drive website traffic, utilize sponsored messages, generate leads, and effectively manage billing centers on the platform. Learning Outcomes: Understand the basics of LinkedIn Ads and their role in digital marketing. Learn how to set up LinkedIn Ads to drive targeted website traffic. Discover techniques for leveraging sponsored messages to engage with the audience. Acquire the skills to create and optimize LinkedIn Ads for lead generation. Gain proficiency in managing the billing center for efficient campaign budgeting and monitoring. Why buy this Excel VBA/Macros Foundations? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Excel VBA/Macros Foundations there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Excel VBA/Macros Foundations course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Excel VBA/Macros Foundations does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Excel VBA/Macros Foundations 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. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Excel VBA/Macros Foundations is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Section 01: Introduction Recording Macros vs Writing VBA 00:04:00 Understanding Objects in Excel VBA 00:07:00 Understanding VBA Syntax and Parts of Speech 00:10:00 Activating the Developer tab 00:01:00 Recording a basic Macro 00:05:00 Absolute vs Relative Macro recording 00:04:00 Section 02: Exploring the Visual Basic Environment Introduction to the Visual Basic Environment 00:02:00 The Project Explorer 00:02:00 The Properties Window 00:02:00 The Code Window 00:04:00 Immediate, Locals and Watch Window 00:03:00 Dealing with Modules 00:03:00 Comments in Excel VBA 00:01:00 Section 03: The Range Object Introduction and Changing Cell Values 00:10:00 Adding a text to a cell 00:01:00 Dealing with Named Ranges 00:03:00 Value vs Text Property 00:04:00 Row and Column properties 00:02:00 The Select Method 00:02:00 The Count Property 00:04:00 The Address Property 00:09:00 The Formula Property 00:03:00 The Number Format Property 00:07:00 The Font Property 00:08:00 Section 04: Understanding the Cells Collection Object What is the cells object? 00:06:00 Using the Cells collection to affect cells positionally within a range 00:05:00 Affecting all cells within a sheet 00:02:00 Combining Range and cells objects 00:03:00 Section 05: Working with Sheets/Worksheets Selecting Sheets 00:06:00 Adding Sheets 00:11:00 Sheets vs Worksheets 00:04:00 Copying Sheets 00:05:00 Moving Sheets 00:01:00 Deleting Sheets 00:04:00 Section 06: Understanding Variables in Excel VBA Introduction to Variables 00:06:00 Variable Data Types 00:09:00 Declaring Variables 00:14:00 Object Variables 00:08:00 Calling a procedure from Another Procedure & Variable Scope 00:03:00 Public and Private Variables 00:07:00 Declaring Constants 00:04:00 Exercises-Variables 00:06:00 Section 07: Dealing with Workbooks Referring to Workbooks-Different ways 00:04:00 Closing Workbooks 00:03:00 Adding and Saving Workbooks Part 1 - Save method 00:04:00 Adding and Saving Workbooks Part 2 - Save as method 00:10:00 Opening Workbooks 00:06:00 Section 08: Must Know Excel VBA Logic Finding the Last row 00:09:00 Finding the Last Column 00:04:00 Finding the next row 00:04:00 The WITH Statement 00:04:00 Comparison operators in Excel VBA 00:01:00 IF Statements- Simple IF Statements 00:07:00 IF THEN ELSE Structure 00:03:00 IF THEN ELSEIF Structure 00:07:00 Nested IFs 00:04:00 OR - AND logical operators 00:07:00 NOT Logical operator 00:03:00 CASE Statements Part 1 - Single Case Statements 00:09:00 CASE Statements Part 2 - Nested Case Statements 00:06:00 Case Statements-Exercise 00:01:00 GOTO and Labels 00:03:00 Section 09: Looping in Excel VBA Loops-Introduction 00:01:00 FOR NEXT Loop 00:11:00 Exit For 00:09:00 Exercise - For Next loop 00:01:00 FOR EACH Loop - Intro 00:07:00 FOR EACH Loops - More examples 00:05:00 Do Loop - Introduction 00:04:00 Do Loop Example 00:01:00 Do Until 00:02:00 Do While 00:02:00 Do while vs Do until - Movies Example 00:04:00 Exit Do Statement 00:05:00 Exercise - Do Loop 00:01:00 Section 10: Interacting with Your Users The Messagebox - Introduction 00:03:00 Messagebox -Inputs 00:07:00 Messagebox - Capturing the User's input 00:05:00 Adding a new line to your VBA Strings 00:02:00 The Inputbox - introduction 00:04:00 Inputbox - Example1 - Capturing a user's name 00:05:00 Inputbox -Employee Database Example Part 1 00:05:00 Inputbox -Employee Database Example Part 2 00:04:00 Exercise - InputBox 00:02:00 Section 11: Error Handling in Excel VBA Error Handling - Introduction 00:09:00 Different Error types in action 00:04:00 On Error Goto statement 00:04:00 Resetting the error handling Status with On Error Goto 00:02:00 The Err Object 00:07:00 Setting a Breakpoint 00:02:00 Section 12: Triggering Code with Events! Worksheet Events -Selection change 00:08:00 Worksheet Events - Worksheet Activate event 00:03:00 Worksheet Events - Deactivate event 00:02:00 Worksheet Events - Before Delete Event 00:02:00 Worksheet Events - Before Double click event 00:08:00 Worksheet Events - Before Right Click event 00:03:00 Worksheet Events - Calculate event 00:03:00 Enabling and Disabling Events 00:03:00 Worksheet events - Worksheet change event 00:11:00 Workbook Events - Follow Hyperlink event 00:02:00 Worksheet events -Exercise 00:01:00 Workbook Events - Workbook open event 00:05:00 Workbook Events - Workbook Activate event 00:02:00 Workbook Events - Workbook Before save event 00:06:00 Workbook Events - Workbook Aftersave event 00:04:00 Workbook Events - Workbook Beforeclose event 00:09:00 Workbook Events - Workbook BeforePrint event 00:03:00 Workbook Events -Workbook De-activate events 00:02:00 Workbook Events - New Chart event 00:08:00 Workbook Events -New sheet event 00:03:00 Workbook Events - Sheet calculate event 00:03:00 Workbook Events - Sheet De-activate event 00:06:00 Workbook Events - Follow Hyperlink event 00:02:00 Workbook Events - Workbook Window Activate event 00:06:00 Workbook Events - Workbook Window De-Activate event 00:02:00 Workbook Events - Window Resize event 00:02:00 Exercise- Workbook Events 00:01:00 Resources Resources - Excel VBA/Macros Foundations 00:00:00 Assignment Assignment - Excel VBA/Macros Foundations 00:00:00

Excel VBA/Macros Foundations
Delivered Online On Demand8 hours 52 minutes
£10.99

Level 3 Diploma in Autism

4.3(43)

By John Academy

Diploma in Autism Description: Are you curious about the different types of autism? Do you have a loved one who is autistic? What are the common signs to look out for? Whether you want to become a social support worker or broaden your knowledge of this topic, learn more about autism in this online course and understand how to provide appropriate support for autistic people. You may have seen an autistic child or grown-up and never realised that the individual is diagnosed with autism, but it is understandable that you are confused and didn't identify the signs, since people on the autistic spectrum can display very subtle symptoms of autism. This course will give you comprehensive lessons on understanding autism, and digs into a large portion of the related issues related to autism and how you can support someone who is diagnosed with autism, as well as spread awareness about this topic. Some autistic people on the autism spectrum might have the capacity to impart their needs and needs or communicate well, while others on the other end of the spectrum will have difficulty expressing themselves and understanding their emotions. Autistic kids act diversely to typical circumstances than the average child. This autism course is an in-depth investigation of autism theories, with points of view related to supporting methods of reasoning. You are given the chance to discuss all of these viewpoints in your own composition. Who is the course for? People on the autistic spectrum or a parent, teacher, physician, or professionals associated with autistic children. To different kinds of people from all professional and personal backgrounds who want to learn about autism and how to handle people suffering from it. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment:  At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days.  Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Diploma in Autism is a useful qualification to possess, and would be beneficial for the following careers: Autism Spectrum Disorder Specialist Behavior Analyst Clinical Psychologist Occupational Therapist Psychologist Social Worker Special Education Teacher Level 3 Diploma in Autism - Updated Version Module 01: Autism Spectrum Disorder (ASD) 00:25:00 Module 02: Learning Difficulties Related to Autism 00:23:00 Module 03: Autism Diagnosis 00:16:00 Module 04: Cognitive Approaches in Autism 00:17:00 Module 05: Dealing with Autistic Individuals 00:22:00 Module 06: Other Considerations for Dealing with Autistic Individuals 00:19:00 Module 07: Engagement in Autism Awareness 00:13:00 Level 3 Diploma in Autism - Old Version Introduction to Autism 00:10:00 Causes and Diagnosis of Autism 00:20:00 Other Conditions Associated with ASD 01:00:00 In-depth Understanding and Dealing with Autistic Behaviour 01:10:00 Socialising and Communication 00:30:00 Choosing Schools 00:35:00 What Should Teachers Do? 00:20:00 Sex Education and Puberty 00:25:00 Interventions: Treatments and Therapies for Autism 00:20:00 Government policies on autism in England 00:15:00 Refer A Friend Refer A Friend 00:00:00 Mock Exam Mock Exam - Level 3 Diploma in Autism 00:20:00 Final Exam Final Exam - Level 3 Diploma in Autism 00:20:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

Level 3 Diploma in Autism
Delivered Online On Demand8 hours
£11.99

Teaching Assistant - Level 2 CPD Certified

4.3(43)

By John Academy

[vc_row][vc_column][vc_column_text] Description: If you wish to become a skilled teaching assistant, then this course is your complete guide to supporting teaching and learning. This Teaching Assistant - Level 2 CPD Certified Course will provide you with the necessary skills and practical knowledge you need to kickstart your career and progress in your field. This teaching assistant course is designed to provide expert training for learners who are or will be, working in schools and working with children and young people. You will first learn the fundamentals of teaching assistant support such as safeguarding, child development and relationships. You will then move onto teaching methodologies, exploring classroom planning and learning activities. Next, you will learn how to support children with special educational needs (SEN), familiarising with the role of an SEN teacher. Want to become a fully qualified classroom assistant? Enrol in this support learning course today and use your teaching assistant qualification to fast-track your career. Who is the course for? Professionals who are helping people build their dreams in becoming a teacher People who have an interest in teaching and different teaching jobs Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment:  At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Teaching Assistant - Level 2 CPD Certified is a useful qualification to possess, and would be beneficial for the following careers: Career Coach Guidance Counsellors Life Coach Mentors Teaching Assistants. [/vc_column_text][/vc_column][/vc_row] Fundamentals of Teaching Understanding the Development of Children and Young Person 01:00:00 Communication and Professional Relationships with Pupils and Family 01:00:00 Safeguarding the Welfare of Children and Young Person 01:00:00 Teaching Methodologies Chapter (i) 01:00:00 Chapter (ii) 01:00:00 Chapter (iii) 01:00:00 Chapter (iv) 01:00:00 Chapter (v) 01:00:00 Chapter (vi) 01:00:00 Chapter (vii) 00:30:00 Chapter (viii) 00:30:00 Chapter (ix) 01:00:00 Chapter (x) 00:30:00 Chapter (xi) 01:00:00 Chapter (xii) 01:00:00 Chapter (xiii) 01:00:00 Chapter (xiv) 01:00:00 Chapter (xv) 01:00:00 SEN Teaching Introduction to Special Educational Needs (SEN) 00:30:00 Understand Constructivism in the Classroom and Know Your Role as a Teacher 01:00:00 SEN Code of Practice 01:00:00 Get an Understanding on SENCO 01:00:00 Classroom Management Strategies for Children with Special Needs 00:30:00 Physical Difficulties, Sensory Difficulties, Cognitive Impairments of Pupils 01:00:00 How to Deal with Pupils with Autism 00:30:00 Understanding Learning Difficulties 01:00:00 Anger Management Methods for Pupils With Special Needs 00:30:00 Teaching Children with Down Syndrome 00:30:00 Conclusion SEN 00:30:00 Refer A Friend Refer A Friend 00:00:00 Mock Exam Mock Exam- Teaching Assistant - Level 2 CPD Certified 00:30:00 Final Exam Final Exam- Teaching Assistant - Level 2 CPD Certified 00:30:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

Teaching Assistant - Level 2 CPD Certified
Delivered Online On Demand25 hours
£11.99

Office Administration

4.3(43)

By John Academy

Course Overview Learn all the essential skills to become an expert in Office Administrator. From this comprehensive Office Administration course, you will be able to understand the principles of Office Administrator. In the step-by-step training process, you will acquire practical skills along with theoretical knowledge. The Qualified professionals will assist you throughout this learning process. This Office Administration is structured to ensure you have all the adequate skills to secure a position in this competitive industry. You will achieve the confidence and competency to bear all the responsibilities of this profession. The course will add all the right credentials to your resume and increase your employability in this growing industry. Learning Outcomes Explain the office administration Acquire the skills of an effective administration Master the negotiation techniques Learn and implement skills like conflict management, stress management, and time management Who is this course for? Anyone who is now employed in this field or who aspires to be one should take this course. Your knowledge will grow through taking this course, which will also strengthen your resume. To demonstrate your newly gained knowledge, develop crucial abilities and receive a professional credential. Entry Requirement This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Certification After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path The Office Administration course is intended to assist you in obtaining the dream job or maybe the promotion you've always desired. With the assistance and direction of our Office Administration course, learn the vital abilities and knowledge you require to succeed in your life. Office Administration Introduction to Office Administration 00:14:00 Skills of an Effective Administrator 00:15:00 Business Writing Skills 00:40:00 Communication Skills 00:25:00 Managing Meetings and Giving Feedback 01:24:00 Organisational Skills 01:16:00 Telephone Etiquette 01:07:00 Negotiation Techniques 00:16:00 Conflict Management 00:14:00 Stress Management 00:16:00 Time Management 00:37:00 Microsoft Excel Module One - Getting Started 00:30:00 Module Two - SmartArt 01:00:00 Module Three - Inserting Objects 01:00:00 Module Four - Creating Charts 01:00:00 Module Five - Creating Pivot Tables 01:00:00 Module Six - Working with Pivot Tables 01:00:00 Module Seven - Creating Pivot Charts 01:00:00 Module Eight - Solving Formula Errors 01:00:00 Module Nine - Using What-If Analysis 01:00:00 Module Ten - Managing Your Data 01:00:00 Module Eleven - Grouping and Outlining Data 01:00:00 Module Twelve - Wrapping Up 00:30:00 Microsoft PowerPoint Edit Text 00:13:00 Build a Presentation 00:27:00 Format Characters 00:11:00 Format Paragraphs 00:16:00 Format Text Boxes 00:09:00 Insert Images 00:10:00 Insert Shapes 00:15:00 Edit Objects 00:16:00 Format Objects 00:06:00 Group Objects 00:04:00 Arrange Objects 00:07:00 Animate Objects 00:07:00 Create a Table 00:09:00 Format a Table 00:03:00 Insert a Table from Other Microsoft Office Applications 00:06:00 Create a Chart 00:10:00 Format a Chart 00:10:00 Insert a Chart from Microsoft Excel 00:05:00 Review Your Presentation 00:11:00 Apply Transitions 00:05:00 Assignment Assignment - Office Administration 00:00:00 Recommended Materials Workbook - Office Administration 00:00:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Office Administration
Delivered Online On Demand21 hours 4 minutes
£11.99