18365 Teaching courses in Southport delivered Online

Course Objectives At the end of this course you will be able to: Record and edit a Macro Assign macros to keyboard shortcuts, Quick Access Toolbar, Buttons and Shape objects. Use the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks Create an error handling routine in case things go wrong with VBA code ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk 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 trainer was very knowledgeable, kept everyone involved and was enthusiastic. A great experience.. Simon Harper - Lloyd's of London My learning experience was awesome. Perdinand Reagan - Subsea7 Very nice and relaxed approach to teaching. Was definitely a good learning experience. Jerome Pupe - S5 Agency World The Trainer – Very positive + patient + helpful + thorough Agnes Souza - Direct Wines ' 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 public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: 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. Introduction to Macros and VBA Introducing Visual Basic for Applications Recording a Macro Naming conventions for Macro Procedures Running a Macro Absolute or Relative Cell Referencing Saving and Opening Files with Macros Making macros always available Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, Buttons and Shapes Editing a Macro in the Visual Basic Editor Understanding the Development Environment Customising the Editor Tips for General Typing in VBA Using Visual Basic Help Working with Procedures Program Design Understanding Modules Naming Rules Creating a Module Understanding Procedures Programming Macro Concepts Creating a Subroutine Creating a Function Understanding Arguments Exiting Procedures Calling Procedures Objects, Properties, Methods and Events Understanding Objects Properties, Methods, and Events Navigating the Object Hierarchy Understanding Collections Accessing a Member of a Collection Understanding Hierarchy Using the Object Browser Using the With Statement Working with Properties Working with Methods Creating an Event Procedure Reserved Macro Names Using Expressions, Variables and Intrinsic Functions Understanding Expressions and Statements Declaring Variables Understanding Data Types Determining the Value of Variables Working with Variable Scope Using Built-in VBA Functions Understanding Constants Using Message Boxes Controlling the Answer to a Message Box Using Input Boxes Declaring and Using Object Variables Controlling Program Execution Understanding Control-of-Flow Structures Using the If...End If Decision Structures Nested If Statements Using the Select Case ... End Select Structure Using the Do ... Loop Structure Using the For ... Next Structure Using the For Each ... Next Structure Guidelines for Use of Control-of-Flow Structures Debugging and Handling Errors Understanding Errors Using Debugging Tools Setting Breakpoints and Using Break Mode Stepping Through Code Trapping Errors with the On Error Statement Understanding the Err Object Working with Inline Error Handling Writing an Error-Handling Routine Working with Forms and Controls Understanding UserForms Creating a Form Displaying and Removing a Form Aligning and Sizing Controls Using the Toolbox Working with a Form's Properties, Methods, and Events Working with Form and Control Properties, Methods and Event Setting the Tab Order Populating a Control Who is this course for? Who is this course for? This course is designed to give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, understanding Object's Properties, Events and Methods, basic VBA Object oriented programming, event handling, control structures, and debugging tools. Requirements Requirements Preferably, delegates should have attended the Excel Advanced course. Certificates Certificates Certificate of completion Digital certificate - Included

Particle Physics is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Particle Physics and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 03 Hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Module-01: Introduction to Particle Physics Introduction to Particle Physics 00:24:00 Module-02: Elementary Particles Elementary Particles 00:22:00 Module-03: The Nucleus The Nucleus 00:25:00 Module-04: Nuclear Physics Nuclear Physics 00:20:00 Module-05: Particle Accelerators Particle Accelerators 00:25:00 Module-06: Radiation detectors Radiation detectors 00:39:00 Module-07: The Standard Model The Standard Model 00:15:00

ONLINE LEVEL 3 AET TEACHER TRAINER COURSE What is the course about? The course has been designed to provide an introduction to teaching: For individuals who are not in a teaching/training role, or who have just started a teaching/training role For individuals who work, or want to work as teachers/trainers in their beauty training academy For individuals who want a short qualification to enable them to make career choices For individuals currently teaching and training, including those new to the profession For individuals who have completed some introduction to training qualifications What will I learn? Understand your roles, responsibilities and boundaries about teaching/training Understand appropriate teaching and learning approaches within a specialist area Demonstrate session planning skills – plan deliver, observe and evaluate a micro-teach session Understand how to deliver inclusive sessions that motivate learners Understand the use of different assessment methods Understand and analyse the need for accurate record-keeping and procedures including internal and external verification Prerequisites You must be a minimum of 19 years old Good reading & writing skills in English A lot of patience. We must advise there is a lot of reading Knowledge of the subject you wish to teach and deliver Does this Level 3 Teacher Training Course offer me a qualification? This level 3 teacher training course is an accredited course and not a full OFQUAL. This Level 3 course will still allow you to teach students if you wish to set up your academy. How do Online Courses work? http://www.kbhtrainingacademy.com/online-courses Duration of Course? You will have 6 months to complete the course before it expires How will I be assessed? You will have to complete theory assignments You will have to provide a 15-30 minute, micro-teaching video

Overview Mastering Meetings Course is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Mastering Meetings Course and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 05 Hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Section 01: Introduction What to Expect From This Course 00:04:00 About Your Lecturer 00:03:00 Section 02: What Are Meetings? What Are Meetings & Why Do We Have Them? 00:03:00 The Cost of Meetings 00:02:00 Section 03: Types of Meeting Red, Amber & Green Meetings 00:06:00 Section 04: Scheduling Your Meetings Do You Need A Meeting? 00:04:00 Getting the Timing Right 00:07:00 Essential Contents of Your Meeting Invitation 00:03:00 Scheduling Best Practices 00:07:00 Considerations for External Attendees 00:05:00 The Meeting as an Opportunity 00:02:00 Section 05: Chairing Your Meeting The Importance of the Chairperson 00:01:00 Starting Your Meeting Well 00:06:00 Running the Meeting like A Pro 00:08:00 Building A Great Meeting Agenda 00:08:00 Section 06: After the Meeting Minutes & Follow-Ups 00:06:00 Section 07: Considerations as a Meeting Attendee How to Be an Attendee That People Want 00:06:00 Section 08: Conclusion - Let's Recap Conclusion - Let's Recap 00:02:00 Assignment Assignment - Mastering Meetings 00:00:00

Overview Essentials of Becoming a Manager and Managing Teams Course is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Essentials of Becoming a Manager and Managing Teams Course and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 05 Hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs.

Overview Safeguarding Children Training Course is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Safeguarding Children Training Course and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 05 Hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training After you have successfully completed your assignment, you will be qualified to apply for a CPD Certification from The Teachers Training. The PDF certificate can be downloaded after you have completed your course. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Module 01: Why We Need to Safeguard Children Why We Need to Safeguard Children 00:13:00 Module 02: Child Protection History and Laws in the UK Child Protection History and Laws in the UK 00:13:00 Module 03: The Danger of Child Abuse and Exploitation The Danger of Child Abuse and Exploitation 00:19:00 Module 04: Assessing Risks and Responding to Disclosure Assessing Risks and Responding to Disclosure 00:15:00 Module 05: Keeping Records and Identifying Trafficking Keeping Records and Identifying Trafficking 00:11:00 Module 06: Supporting Children's Mental Health and Basic Needs Supporting Children's Mental Health and Basic Needs 00:13:00

Feeling stuck in your career? Struggling to keep up with the ever-changing demands of the industry? You're not alone. But there's good news: Paediatrics - CPD Certified career bundle is here to equip you with the essential skills and knowledge you need to break free and achieve your goals. With this Paediatrics course you will get 20 CPD Accredited PDF Certificates, Hard Copy Certificate of Paediatrics Course and our exclusive student ID card absolutely free. Courses Are Included In This Paediatrics Bundle: Course 01: Paediatrics Course Course 02: Paediatric First Aid Level 3 Course 03: Paediatric Care Training Course 04: Paediatric First Aid (Emergency Care) Course 05: Paediatric Vaccination Course 06: Introduction to Caring for Children and Young People Course 07: Safeguarding Children Course Course 08: Child and Adolescent Mental Health Course 09: Neuropsychology & Development of Children Course 10: Early Years Primary Teaching Course 11: The Whole Brain Learning Approach in Child Development Course 12: Executive Functions in Child Development Course 13: Nursery Nurse for Development of Children Course 14: Child Psychology Course 15: SEN Teaching Course 16: Learning Disability Awareness Course 17: ADHD Awareness Training Course 18: Understanding Autism Course 19: Speech & Language Therapy for Children Course 20: Childcare and Nutrition Embarking on Paediatrics - CPD Certified is more than just taking an online course; it's an investment in your future. By completing this Paediatrics bundle, you'll not only gain invaluable skills but also open doors to new career opportunities and advancements, boosting your earning potential. Don't miss this chance to elevate your career and skillset. Enrol in Paediatrics - CPD Certified today and take the first step towards achieving your goals and dreams. Why buy this Paediatrics bundle course? Free CPD Accredited Certificate upon completion of Paediatrics - CPD Certified Get a free student ID card with Paediatrics course Lifetime access to the Paediatrics course materials Get instant access to this Paediatrics course Learn Paediatrics from anywhere in the world 24/7 tutor support with the Paediatrics course. Paediatrics - CPD Certified is an entirely online, interactive lesson with voice-over audio. Start your learning journey straightaway with our Paediatrics Training! Paediatrics premium bundle consists of 20 precisely chosen courses on a wide range of topics essential for anyone looking to excel in this field. Each segment of Paediatrics is meticulously designed to maximise learning and engagement, blending interactive content and audio-visual modules for a truly immersive experience. Certification You have to complete the assignment given at the end of the Paediatrics course and score a minimum of 60% to pass each exam. Our expert trainers will assess your assignment and give you feedback after you submit the assignment. After passing the Paediatrics exam You will be entitled to claim a PDF & Hardcopy certificate accredited by CPD completely free. CPD 320 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Paediatrics course is ideal for: Students seeking mastery in Paediatrics Professionals seeking to enhance Paediatrics skills Individuals looking for a Paediatrics-related career. Anyone passionate about Paediatrics Requirements This Paediatrics course doesn't require prior experience and is suitable for diverse learners. Career path This Paediatrics bundle will allow you to kickstart or take your career in the related sector to the next stage. Certificates CPD Accredited Digital certificate Digital certificate - Included CPD Accredited Hard copy certificate Hard copy certificate - Included

Course Overview As English is an international language, proficiency in this subject helps you both in your personal life and professional life. Develop a solid foundation in English with the Functional Skills English level 2 course. Within a few steps, this curse will take your English skills to the next level. In this Functional skills English level 2 course, first you will develop a clear understanding of English grammar. Then the detailed lessons will educate you on the basic sentence structure. From the easy-to-follow modules, you will enrich your knowledge of punctuation and capitalisation. In addition, this valuable course will assist you in improving your spelling skills. Finally, you will get introduced to the common mistakes and grasp the strategies to avoid them. This comprehensive Functional skills English level 2 course will assist you in increasing your excellence in the English language. It will give you the opportunity to add a valuable skill set to your resume. So join now and start learning today! What You Will Learn  Get introduced to the basics of English grammar Familiarise yourself with the English sentence structure Learn the principles of forming questions Enrich your knowledge and understanding of punctuation Develop a clear understanding of capitalisation Improve your spelling skills Build the competence to identify and avoid common mistakes Why Should You Choose this Functional skills English level 2 Course Lifetime access to the course No hidden fees or exam charges CPD Qualification Standards certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment, and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential Who is this Course for? The Functional Skills English level 2 course is designed for anyone interested in developing their English skills. It will be highly advantageous for aspiring professionals in the relevant industries.  Requirements Our Functional Skills English level 2 course is fully compatible with any kind of device. Whether you are using a Windows computer, Mac, smartphone or tablet, 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 This Functional Skills English level 2 course will assist you in pursuing a career in the relevant fields  English Teacher (Salary Range £40,000-£53,000) Teaching Assistant (Salary Range £19,000-£21,000) Functional skills English level 2 Module 01: Introduction to the Course 00:10:00 Module 02: Basics of Grammar 00:13:00 Module 03: The Basics of Sentence 00:08:00 Module 04: Structure of Sentence 00:16:00 Module 05: Questions 00:11:00 Module 06: Punctuation and Capitalisation 00:21:00 Module 07: Spelling 00:24:00 Module 08: Common Mistakes and Ways to Improve 00:18:00

Overview Introduction to Urban Planning Course is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Introduction to Urban Planning Course and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 05 Hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Module 01: Urban Planning Fundamentals Urban Planning Fundamentals 00:17:00 Module 02: Process of Urban Planning Process of Urban Planning 00:08:00 Module 03: Urban Planning Policies and Regulations Urban Planning Policies and Regulations 00:16:00 Module 04: Urban Infrastructure and Transportation Planning Urban Infrastructure and Transportation Planning 00:21:00 Module 05: Urban Design and Landscape Planning Urban Design and Landscape Planning 00:17:00 Module 06: Residential Buildings and Neighbourhood Planning Residential Buildings and Neighbourhood Planning 00:12:00 Module 07: Street Design and Transportation Planning Street Design and Transportation Planning 00:13:00 Module 08: Parks, Open Spaces and Recreation Planning Parks, Open Spaces and Recreation Planning 00:09:00 Module 09: Environmental Considerations in Urban Planning Environmental Considerations in Urban Planning 00:28:00 Module 10: Sustainable Urban Planning Practices Sustainable Urban Planning Practices 00:15:00 Module 11: Future Trends in Urban Planning Future Trends in Urban Planning 00:17:00

Overview Are you finding it difficult to pass an English literature exam or master it as a second language? We can help you overcome all the obstacles in your way. This course delivers an expertly written masterclass on the standard contents of a UK GCSE curriculum and will help you embed that knowledge. The Learning English Language Level 2 course provides comprehensive overviews of all the learning required to pass this essential exam and secure good educational standards. You will be taught how to appreciate and analyse the works of Shakespeare and English novels, alongside poetry, drama, and the basic structure of essays, documents and letters for everyday use. 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 Learning English Language Level 2. It is available to all students, of all academic backgrounds. Requirements Our Learning English Language Level 2 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 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 Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 3 sections • 14 lectures • 06:15:00 total length •English Language: 00:30:00 •Learning English: 00:15:00 •Punctuation in English: 00:30:00 •Capitalisation: 00:15:00 •Sentence Structure: 00:15:00 •Spelling: 00:30:00 •Verbs: 00:30:00 •Verb tenses and aspects: 00:45:00 •The future: 00:30:00 •Be, have and do: 00:45:00 •Modal verbs: 00:45:00 •English Writing: 00:15:00 •Tips to Improve in English: 00:30:00 •Assignment - Learning English Language Level 2: 00:00:00