4739 Courses 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 classroom, one to one, tailored and bespoke courses. Tailored In Company training: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. 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. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Certificates Certificates Certificate of completion Digital certificate - Included

This course will help you master Spring, Spring Boot, Spring Modules - JDBC, AOP, and Data JPA through a hands-on, step-by-step approach. You will also be introduced to unit testing with JUnit and Mockito and learn how to communicate with the database using the Spring framework.

Uncovering Emotional Root Causes of Health Challenges Instructor Craig Weiner, DC, Licensed MetaHealth Foundation Trainer, EFT Master Trainer of Trainers. Learn to apply a method of analysis that effectively guides the application and integration of EFT, Matrix Reimprinting and other alternative healing modalities you may already currently use for yourself and on your clients. Discover how symptoms and disease are actually an intelligent process that is the body’s attempt to heal stress and trauma. With this knowledge, fear can be greatly reduced and a therapeutic intervention can then be utilized in a more precise way. You and your clients will achieve results faster and will be amazed at the insights, connections and progress they make in their healing journey. META-Health is the science, practice and art of Body-Mind-Social Health with a focus on how specific stress triggers, emotions and beliefs affect specific organ symptoms. META-Health is a methodology based on Integrative Medicine and Prevention and is practiced by all types of health professionals interested in a precise and effective Body-Mind-Social analysis and approach towards most effectively supporting individuals working to find emotional and physical healing. Your trainer for this Foundation weekend will be Craig Weiner, who has worked in the complementary health care field for over 30 years. He brings his professional clinical experience, his years as an educator and certified trainer in the Emotional Freedom Techqniques and Matrix Reimprinting and as a licensed META-Health Foundation Trainer. In the Foundation Course you will get the overview of the META-Health concepts and its implications for self-healing, assistance in transforming disease, and achieving sustainable health and resilience, including: Rhythms of life, and the organism’s self-regulating intelligence How the bio-logical needs change your perception and create life strategies How to decode the language of your organs Recognize the key points and phases of the healing process Experience the powerful META-Analytics questions Use the 8 milestones of META-Health to address the whole system and its soil Find META-meanings to create resilience Demonstrations and practical exercises will lead you to deeply integrate the wisdom of your body, and inspire you to actively claim and support your health. You will understand the natural, dynamic path of healing, and be empowered to lift your – and others’ – consciousness to make use of our potential! During this weekend we will spend time reviewing the core META-Health Principles: Our body-mind is highly intelligent Bio-logical survival and stress strategies, regeneration and resilience are at play in our brain, nervous system and hormonal system Significant emotional experiences shape our beliefs, personality and lifestyle Specific individual stress triggers influence typical organ tissues and functions The cycle of stress, regeneration and learning goes through distinct points and phases Awareness and imagination are capabilities of our brain which can recreate meaning and reprogram body-mind’s reactions There is no pre-requisite to taking this weekend course. Anyone who is interested can participate in the META-Health Foundation Training. The Foundation Training is the first step in becoming a certified META-Health Practitioner. Times: The course is a 12 hours training and will be held from 9:00 to 4:00 Seattle/Pacific time on both Friday and Saturday with a 60 minute lunch break held at approximately 12:30pm.

An exciting 10-week course to build your Spanish skills from scratch. Practical applications for travel & conversation. Enlarge your vocabulary, improve your grammar in a pain-free, step-by-step way, working with a tutor with 10+ years' experience & a small group of learners.

Accelerate Your Cyber Career: Fast-Track Program with Exams, TOTUM Card & 5-Year Support. Enrol Today! Study methodOnline Duration9 months · Self-paced Access to content5 years CertificationsCompTIA A+CompTIA Network+CompTIA Security+CompTIA IT Fundamentals CertificationCompTIA CySA+CompTIA PenTest+ Certificates Official CompTIA Certification - Free Additional info Exam(s) / assessment(s) is included in price Tutor is available to students TOTUM card included in price Job guarantee programme is included in this course Overview Learn the most in-demand digital skills in the world today with the Nuyew Tech Academy With the increase in cyberattacks and the number of new connected devices, the need for skilled cybersecurity professionals is growing at a rapid pace, and cybersecurity professionals must nurture their practical, hands-on skills. If you are looking for employment in cybersecurity, then this programme will provide you with an endorsement of your skills that is respected globally and industry-wide. Certifications CompTIA A+ CompTIA Network+ CompTIA Security+ CompTIA IT Fundamentals Certification CompTIA CySA+ CompTIA PenTest+ Awarded by CompTIA Description With a national shortage of Cyber Security Engineers, starting salaries of up to £25,000 per annum (average UK Salary £72,500) and amazing future employed and self-employed career prospects, take the next step today with our Fast Track Cyber Security Programme. What you can expect from our Fast Track Programme: World Class Education Energetic and unlimited 24/7 Student Support Real, tangible Career Outcomes 5 Years Career Support What our programme includes: Industry Recognised Qualifications CompTIA ITF+ (IT Fundamentals) CompTIA A+ CompTIA Network+ CompTIA Security+ CompTIA CySA+ OR CompTIA PenTest+ Exams Includes all Exams and Unlimited Re-Sits 5 Years Career Support Guarantee As part of our unique Support Guarantee, our Career Support Team will assist you with: CV writing Expert careers advice Interview preparation Identifying and applying for the best opportunities in your area As a student in the Nuyew Tech Academy you will also be given exclusive access to our AdvancedCareer Skills Academy which includes advanced courses on Employability, CV Preparation, Interview Skills and Technique and everything else you need to get ready for your new Career. Who is this course for? This course is open to anyone interested in pursuing a Career in Cyber Security. Our Foundation Level provides the flexibility for us to accommodate students with any level of previous knowledge and experience. Requirements This course is open to all and has no pre-requisites All you need is a passion for technology and a strong desire to succeed. Career path Our programme is designed to enable you to achieve an Entry Level/Helpdesk role during training (£18k-£24K) ensuring that you also have the vital work experience required to enter the Tech Industry at a higher level (Av Salary £72.5K). Our Career Support Guarantee gives you exclusive access to our dedicated Career Support Team and Advanced Career Skills Academy for 5 Years following Graduation. Certificates Official CompTIA Certification Hard copy certificate - Included We provide Official CompTIA Certificates for all courses included (ITF+, A+(2), Network+, Security+, CySA+ or PenTest+.

Accelerate Your Cloud Engineer Career: Fast-Track Program with Exams, TOTUM Card & 5-Year Support. Enrol Today! Study methodOnline Duration9 months · Self-paced Access to content5 years CertificationsCompTIA A+CompTIA Cloud+CompTIA Network+CompTIA Security+CompTIA IT Fundamentals CertificationMicrosoft Azure Data Fundamentals Certificates Official CompTIA Certification - Free Additional info Exam(s) / assessment(s) is included in price Tutor is available to students TOTUM card included in price Job guarantee programme is included in this course Overview Learn the most in-demand digital skills in the world today with the Nuyew Tech Academy If you enjoy problem solving and have good analytical skills, this could be the career for you. Cloud Network Engineers implement, maintain, support, develop and sometimes design communications networks and can work as part of an Internal Support Team or for an outsourced IT Networking Consultancy. In bigger companies, you may look after one specific area of a network or if working for smaller businesses you could be expected to troubleshoot any IT related problem. Certifications CompTIA A+ CompTIA Cloud+ CompTIA Network+ CompTIA Security+ CompTIA IT Fundamentals Certification Awarded by CompTIA Microsoft Azure Data Fundamentals Awarded by Microsoft Description With a national shortage of Cloud Network Engineers, starting salaries of up to £25,000 per annum (average UK Salary £52,500) and amazing future employed and self-employed career prospects, take the next step today with our Fast Track Cloud Network Engineer Programme. What you can expect from our Fast Track Programme: World Class Education Energetic and unlimited 24/7 Student Support Real, tangible Career Outcomes 5 Years Career Support What our programme includes: Industry Recognised Qualifications CompTIA ITF+ (IT Fundamentals) CompTIA A+ CompTIA Network+ CompTIA Security+ CompTIA Cloud+ OR CompTIA Server+ OR CompTIA Linux+ Exams Includes all Exams and Unlimited Re-Sits 5 Years Career Support Guarantee As part of our unique Support Guarantee, our Career Support Team will assist you with: CV writing Expert careers advice Interview preparation Identifying and applying for the best opportunities in your area As a student in the Nuyew Tech Academy you will also be given exclusive access to our Career Skills Academy which includes advanced courses on Employability, CV Preparation, Interview Skills and Technique and everything else you need to get ready for your new Career. Who is this course for? This course is open to anyone interested in pursuing a Career in Cloud Network Engineering. Our Foundation Level provides the flexibility for us to accommodate students with any level of previous knowledge and experience. Requirements This course is open to all and has no pre-requisites All you need is a passion for technology and a strong desire to succeed. Career path Our programme is designed to enable you to achieve an Entry Level/Helpdesk role during training (£18k-£24K) ensuring that you also have the vital work experience required to enter the Tech Industry at a higher level (Av Salary £52.5K). Our Career Support Guarantee gives you exclusive access to our dedicated Career Support Team and Advanced Career Skills Academy for 5 Years following Graduation. Certificates Official CompTIA Certification Hard copy certificate - Included We provide Official CompTIA Certificates for all courses included (ITF+, A+(2), Network+, Security+, Cloud+.

Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified Teaching Assistant, Remote teaching and Phonics Teaching bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our 37 course mega bundle that will exceed your expectations within your budget. This Teaching Assistant, Remote teaching and Phonics Teaching Bundle consists of the following 30 CPD Accredited Premium courses - Course 1: Teaching Assistant Diploma Course 2: The Complete Guide To Getting A Teaching Job Course 3: SEND Teaching Assistant Course 4: EYFS Teaching Assistant Course 5: Phonics Teaching Certificate Course 6: Remote Teaching Course 7: Lesson Planning for Teaching Course 8: Learning Disability Nursing Course 9: Nursery Nurse Course 10: Mental Health Teaching Assistant Course 11: ADHD Awareness Course 12: Leadership in Teaching Course 13: Positive Handling in Schools Course 14: Learning to Learn - Super Learning Course 15: Educational Psychology Course 16: Education Management Course 17: Education and Pedagogy Course 18: Blended Learning Course for Teachers Course 19: Understanding Autism Level 3 Course 20: Health and Safety Training for School Administrators Course 21: Child Language Disorder (CLD) Course 22: Child Playwork Course 23: Child Neglect Awareness & Protection Course 24: Communication Skills Course 25: Team Management Course 26: Problem Solving Skills Course 27: Leadership Skills Course 28: Presentation Skills Course 29: Microsoft Office Course 30: Cross-Cultural Awareness Training 7 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 1: Career Development Plan Fundamentals Course 2: CV Writing and Job Searching Course 3: Interview Skills: Ace the Interview Course 4: Video Job Interview for Job Seekers Course 5:Create a Professional LinkedIn Profile Course 6:Business English Perfection Course Course 7:Networking Skills for Personal Success Learning Outcome Uncover your skills and aptitudes to break new ground in the related fields Deep dive into the fundamental knowledge Acquire some hard and soft skills in this area Gain some transferable skills to elevate your performance Maintain good report with your clients and staff Gain necessary office skills and be tech savvy utilising relevant software Keep records of your work and make a report Know the regulations around this area Reinforce your career with specific knowledge of this field Know your legal and ethical responsibility as a professional in the related field This Teaching Assistant, Remote teaching and Phonics Teaching Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments. Certification After studying the complete training you will be able to take the assessment. After successfully passing the assessment you will be able to claim all courses pdf certificates and 1 hardcopy certificate for the Title Course completely free. Other Hard Copy certificates need to be ordered at an additional cost of •8. CPD 370 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Ambitious learners who want to strengthen their CV for their desired job should take advantage of the Teaching Assistant, Remote teaching and Phonics Teaching bundle! This bundle is also ideal for professionals looking for career advancement. Requirements To participate in this course, all you need is - A smart device A secure internet connection And a keen interest in Teaching Assistant, Remote teaching and Phonics Teaching Career path Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields.

Overview This comprehensive course on Train the Trainer - Part 1 will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Train the Trainer - Part 1 comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? After successfully completing the course you will be able to order your certificate, these are included in the price. Who is This course for? There is no experience or previous qualifications required for enrolment on this Train the Trainer - Part 1. It is available to all students, of all academic backgrounds. Requirements Our Train the Trainer - Part 1 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 5 sections • 23 lectures • 04:43:00 total length •Introduction to Trainer Bootcamp: 00:12:00 •What Makes a Great Trainer?: 00:18:00 •Make Them Feel Safe Before Class Introduction: 00:05:00 •Make Comfortable Small Talk - Part 1: 00:17:00 •Make Comfortable Small Talk - Part 2: 00:20:00 •Make Comfortable Small Talk - Activity Feedback: 00:09:00 •Make an Impressive First Impression: 00:15:00 •Give Last Minute Reminders - Part 1: 00:19:00 •Give Last Minute Reminders - Part 2: 00:15:00 •Give Your Introduction - Part 1: 00:18:00 •Give Your Introduction - Part 2: 00:20:00 •Give Your Introduction - Part 3: 00:04:00 •Find Out About Them: 00:18:00 •Reveal the Takeaways: 00:13:00 •Set Boundaries and Expectations - Part 1: 00:18:00 •Set Boundaries and Expectations - Part 2: 00:06:00 •Give the Lesson Hook: 00:07:00 •Do an Oral Review - Part 1: 00:17:00 •Do an Oral Review - Part 2: 00:04:00 •Send Them to Break: 00:04:00 •Walk and Talk During Break: 00:11:00 •Bring Them Back From Break: 00:13:00 •Workbook - Train the Trainer - Part 1: 00:00:00

Course Overview Did you know that Fortune 500 companies are moving to recurring revenue models? There is a steady rise of people making a passive income through affiliate marketing, and you could be one of them. The Passive Income with Affiliate Marketing course is an in-depth masterclass for anyone looking to set up a passive income stream through affiliate marketing. It will break down the different types of passive incomes, as well as introduce some building wealth strategies to get your started in your new business venture.  This course will also reveal secrets that a financial advisor wouldn't tell you, that will help you get into the wealthy mindset. Start generating your passive income today and join millions of people making a steady stream of money from home! This best selling Passive Income with Affiliate Marketing has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Passive Income with Affiliate Marketing is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Passive Income with Affiliate Marketing is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Passive Income with Affiliate Marketing is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Passive Income with Affiliate Marketing, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Passive Income with Affiliate Marketing will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Passive Income with Affiliate Marketing to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

The Level 5 qualifications in Management and Leadership are aimed at those who are working as middle managers and those who are aspiring to be senior managers. This qualification is mainly focused on the improvement of the student’s capabilities and core management skills such as resource management, recruitment, and information management. The Level 5 Diploma in Management and Leadership has been devised for developing the key skills of middle managers and those who are striving to be senior managers. This diploma is a benchmark qualification for full CMI membership which will take you one step closer to the status of a Chartered Manager. We have a 100% pass rate due to the high levels of support delivered through our online learning platform and individual coaches/assessors are assigned to all students. Our speed of response is second to none and our 5-star rating from our students speaks for itself. We are delighted to have supported students to unleash their potential from a diverse range of organisations both within the UK and internationally from organisations that have most recently included: Michelin Barclays Firstsource Mercedes Benz Shangrila Hotels and Resorts Virgin Money UK Person College London North Norfolk District Council G&L Scientific Coca Cola New Balance PureGym As a CMI accredited Chartered Manager Centre, many of our students go on to achieve recognition as Chartered Managers through our centre. Study method Online, self-paced Duration 9 months Access to content Access until course completion Qualification Level 5 Diploma - Extended Diploma in Business and Management CPD 540 CPD hours / points Additional info Exam(s) / assessment(s) is included in price Tutor is available to students CPD 540 CPD hours / points Accredited by Chartered Management Institute Key Benefits Latest and emerging as well as classical leadership and management concepts, theories and models. Practical guidance and support from our coaches and assessors who are all CMI Chartered Managers or Fellows. An internationally – recognised professional qualification. The credits earned at this course can be transferred to other courses if the students want to pursue MBA or any other Masters. On successful completion of the programme, students will be able to demonstrate their understanding and ability to apply leadership and management good practice which will improve their attractiveness to employers. The programme covers a choice of the following Units to a Total Qualification Time of 540 hours: CMI 502 Developing, Managing and Leading Individuals and Teams to Achieve Success (60 Hours TUT) CMI 504 Managing Performance (50 Hours TUT) CMI 506 Managing Equality, Diversity and Inclusion (50 Hours TUT) CMI 514 Managing Change (50 Hours TUT) CMI 513 Managing Projects to Achieve Results (60 Hours TUT) CMI 515 Creating and Delivering Operational Plans (60 Hours TUT) CMI 517 Principles of innovation (50 Hours TUT) CMI 520 Managing finance (60 Hours TUT) CMI 523 Principles of marketing products and services (60 Hours TUT) CMI 524 Conducting a Management Project (100 Hours TUT) CMI 525 Using Reflective Practice to Inform Personal and Professional Development (50 Hours TUT) We also provide students with access to the full CMI syllabus and support them if they wish to choose alternative Units. What the programme offers Level 5 Diploma in Leadership & Management from Chartered Management Institute (CMI) Student membership of the Chartered Management Institute Full learning support and all course materials All registration and assessment fees (We don't believe in hidden costs) Unrivalled one-to-one tutor support throughout the entire learning journey. A dedicated Chartered Manager as your programme coach/assessor 24-7 access to our extensive online Academy and CMI's Management Direct learning platform. All assessment and support materials are accessible through our online learning platform Assessment feedback within 48 hours to keep students motivated and on track The opportunity to progress to become recognised as a Chartered Manager upon successful completion Who is this course for? Middle Managers, potential middle managers and senior managers/business owners who want to consolidate their understanding of leadership and management good practice and gain formal recognition of their leadership and management abilities from the Chartered Management Institute – the only worldwide Chartered leadership and management professional body. Requirements None - we offer an inclusive and welcoming learning environment to all our students and there are no barriers to entry. Prospective students should be aware this CMI level 5 qualification is approximately equivalent to an academic degree level. Students will be required to submit assignments to this level. Career path A career in leadership and management. A possible progression route on successful completion of a Level 5 qualification in Strategic Management and Leadership would be to, Progress to other qualifications at the next level (e.g. from Level 5 Certificate to Level 6 or 7 Certificate)