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

1545 Courses delivered Online

Level 2 Certificate in Understanding Children and Young People's Mental Health Courses

4.5(3)

By Studyhub UK

24 Hour Flash Deal **33-in-1 Children and Young People's Mental Health Mega Bundle** Children and Young People's Mental Health Enrolment Gifts **FREE PDF Certificate**FREE PDF Transcript ** FREE Exam** FREE Student ID ** Lifetime Access **FREE Enrolment Letter ** Take the initial steps toward a successful long-term career by studying the Children and Young People's Mental Health package online with Studyhub through our online learning platform. The Children and Young People's Mental Health bundle can help you improve your CV, wow potential employers, and differentiate yourself from the mass. This Children and Young People's Mental Health course provides complete 360-degree training on Children and Young People's Mental Health. You'll get not one, not two, not three, but thirty-three Children and Young People's Mental Health courses included in this course. Plus Studyhub's signature Forever Access is given as always, meaning these Children and Young People's Mental Health courses are yours for as long as you want them once you enrol in this course This Children and Young People's Mental Health Bundle consists the following career oriented courses: Course 01: Diploma in Children and Young People's Mental Health Problems Course 02: Early Childhood Mental Health: Strategies and Interventions Course 03: Child and Adolescent Counselling Course 04: Play Therapy, Mental Health and Child Psychology Diploma Course 05: Counselling Children & Supporting Their Wellbeing Course 06: Crisis and Trauma Counselling in Early Childhood Course 07: Bereavement and Grief Counselling Course 08: Child Psychology Course 09: Reactive Strategies for Challenging Behaviour of Young People Course 10: Young People and Challenging Behaviour Diploma Course 11: Child Behaviour Course 12: Positive Behaviour in Children and Youth Course 13: Self Regulation in Young Children Course 14: Residential Childcare & Cognitive Development Training Course 15: Child Development and Care Course 16: The Importance of Preschool Education in Child Development Course 17: EYFS Teaching Assistant and Child Development Course 18: Socialisation and Adaptation in Early Childhood Course 19: Special Education Needs (SEN) Teaching Methodologies Course 20: SENCO - Special Educational Needs Coordination Course Course 21: Autism Training Course 22: Teaching Assistant with Autism Essential Course 23: Effective Strategies for Teaching Students with Learning Disabilities Course Course 24: Child Protection Course 25: Child Protection in Education Course 26: Parental Mental Health & Child Protection Course 27: Child Safeguarding Course 28: Internet Safety: Safeguarding Children Course 29: Child Sexual Exploitation Awareness Diploma Course 30: Safeguarding Children & Child Risk Assessment Course 31: Child Neglect Awareness Certificate Course 32: How to Save Children from Abuse | Interactive Training Course 33: The Purpose of Professional Boundaries: Ethical and Professional Practice In this exclusive Children and Young People's Mental Health bundle, you really hit the jackpot. Here's what you get: Step by step Children and Young People's Mental Health lessons One to one assistance from Children and Young People's Mental Health professionals if you need it Innovative exams to test your knowledge after the Children and Young People's Mental Health course 24/7 customer support should you encounter any hiccups Top-class learning portal Unlimited lifetime access to all thirty-three Children and Young People's Mental Health courses Digital Certificate, Transcript and student ID are all included in the price PDF certificate immediately after passing Original copies of your Children and Young People's Mental Health certificate and transcript on the next working day Easily learn the Children and Young People's Mental Health skills and knowledge you want from the comfort of your home The Children and Young People's Mental Health course has been prepared by focusing largely on Children and Young People's Mental Health career readiness. It has been designed by our Children and Young People's Mental Health specialists in a manner that you will be likely to find yourself head and shoulders above the others. For better learning, one to one assistance will also be provided if it's required by any learners. The Children and Young People's Mental Health Bundle is one of the most prestigious trainings offered at StudyHub and is highly valued by employers for good reason. This Children and Young People's Mental Health Bundle course has been created with thirty-three premium courses to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Children and Young People's Mental Health Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into Children and Young People's Mental Health Elementary modules, allowing our students to grasp each lesson quickly. The Children and Young People's Mental Health course is self-paced and can be taken from the comfort of your home, office, or on the go! With our Student ID card you will get discounts on things like music, food, travel and clothes etc. CPD 330 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Children and Young People's Mental Healthtraining is suitable for - Students Recent graduates Job Seekers Individuals who are already employed in the relevant sectors and wish to enhance their knowledge and expertise in Children and Young People's Mental Health and who wants to further enrol in Level 2 Certificate for the Children and Young People's Workforce (RQF) RQF Children and Young People's Workforce Level 2 Certificate for the Children and Young People's Workforce (RQF) Level 3 Diploma for the Children and Young People's Workforce (Early Years Educator) (RQF) TQUK Level 2 Certificate in Understanding Children and Young People's Mental Health (RQF) Level 2 Award in Safeguarding and Protecting Children and Young People Level 2 Award in Safeguarding and Protecting Children and Young People (RQF) Level 2 Certificate in Introducing Caring Children & Young People Level 2 Certificate in Introducing Caring for Children and Young People (RQF) Level 5 Diploma in Leadership for Health and Social Care and Children and Young People's Services (England (RQF) Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Requirements To participate in this Children and Young People's Mental Health course, all you need is - A smart device A secure internet connection And a keen interest in Children and Young People's Mental Health Career path You will be able to kickstart your Children and Young People's Mental Healthcareer because this course includes various courses as a bonus. This bundle is an excellent opportunity for you to learn multiple skills from the convenience of your own home and explore Children and Young People's Mental Health career opportunities. Certificates CPD Accredited Certificate Digital certificate - Included CPD Accredited e-Certificate - Free CPD Accredited Hardcopy Certificate - Free Enrolment Letter - Free Student ID Card - Free

Level 2 Certificate in Understanding Children and Young People's Mental Health Courses
Delivered Online On Demand7 days
£329

Safety First: Understanding COSHH in the Workplace

4.5(3)

By Studyhub UK

24 Hour Flash Deal **25-in-1 Safety First: Understanding COSHH in the Workplace Mega Bundle** Safety First: Understanding COSHH in the Workplace Enrolment Gifts **FREE PDF Certificate**FREE PDF Transcript ** FREE Exam** FREE Student ID ** Lifetime Access **FREE Enrolment Letter ** Take the initial steps toward a successful long-term career by studying the Safety First: Understanding COSHH in the Workplace package online with Studyhub through our online learning platform. The Safety First: Understanding COSHH in the Workplace bundle can help you improve your CV, wow potential employers, and differentiate yourself from the mass. This Safety First: Understanding COSHH in the Workplace course provides complete 360-degree training on Safety First: Understanding COSHH in the Workplace. You'll get not one, not two, not three, but twenty-five Safety First: Understanding COSHH in the Workplace courses included in this course. Plus Studyhub's signature Forever Access is given as always, meaning these Safety First: Understanding COSHH in the Workplace courses are yours for as long as you want them once you enrol in this course This Safety First: Understanding COSHH in the Workplace Bundle consists the following career oriented courses: Course 01: COSHH Training Course 02: COSHH Basics for a Safe Working Environment Course 03: Asbestos Awareness Course 04: Hydrogen Sulphide Training: Safety and Awareness in Hazardous Environments Course 05: Working in Confined Spaces Course 06: Safety & Precautions in Medication Management Course 07: Risk Assessment & Management Course 08: Manual Handling Training Course 09: Fire Safety Course 10: Emergency First Aid at Work Course 11: Environmental Health Course 12: Infection Control Diploma Course 13: Preventing Contamination in the Laboratory: Best Practices in Lab Safety Course 14: Laboratory Safety Course Course 15: Spill Management Training Course 16: Health and Safety at Workplace Course 17: Hand-arm Vibration and HAVS Training Course Certificate Course 18: Accident Investigation Course 19: Site Management Safety Training Scheme (SMSTS) Course 20: Environmental Impact Assessment: Evaluating Sustainability Course 21: Crowd Management Course 22: Injury and Illness Prevention Programmes: Promoting Workplace Safety Course 23: Food Safety & Hygiene Course 24: Navigating the Fast-Moving Consumer Goods (FMCG) Industry Course 25: Cleaning, Decontamination and Waste Management The Safety First: Understanding COSHH in the Workplace course has been prepared by focusing largely on Safety First: Understanding COSHH in the Workplace career readiness. It has been designed by our Safety First: Understanding COSHH in the Workplace specialists in a manner that you will be likely to find yourself head and shoulders above the others. For better learning, one to one assistance will also be provided if it's required by any learners. The Safety First: Understanding COSHH in the Workplace Bundle is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Safety First: Understanding COSHH in the Workplace bundle course has been created with twenty-five premium courses to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Safety First: Understanding COSHH in the Workplace Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into Safety First: Understanding COSHH in the Workplace Elementary modules, allowing our students to grasp each lesson quickly. The Safety First: Understanding COSHH in the Workplace course is self-paced and can be taken from the comfort of your home, office, or on the go! With our Student ID card you will get discounts on things like music, food, travel and clothes etc. In this exclusive Safety First: Understanding COSHH in the Workplace bundle, you really hit the jackpot. Here's what you get: Step by step Safety First: Understanding COSHH in the Workplace lessons One to one assistance from Safety First: Understanding COSHH in the Workplaceprofessionals if you need it Innovative exams to test your knowledge after the Safety First: Understanding COSHH in the Workplacecourse 24/7 customer support should you encounter any hiccups Top-class learning portal Unlimited lifetime access to all twenty-five Safety First: Understanding COSHH in the Workplace courses Digital Certificate, Transcript and student ID are all included in the price PDF certificate immediately after passing Original copies of your Safety First: Understanding COSHH in the Workplace certificate and transcript on the next working day Easily learn the Safety First: Understanding COSHH in the Workplace skills and knowledge you want from the comfort of your home CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Safety First: Understanding COSHH in the Workplace training is suitable for - Students Recent graduates Job Seekers Individuals who are already employed in the relevant sectors and wish to enhance their knowledge and expertise in Safety First: Understanding COSHH in the Workplace Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Requirements To participate in this Safety First: Understanding COSHH in the Workplace course, all you need is - A smart device A secure internet connection And a keen interest in Safety First: Understanding COSHH in the Workplace Career path You will be able to kickstart your Safety First: Understanding COSHH in the Workplace career because this course includes various courses as a bonus. This Safety First: Understanding COSHH in the Workplace is an excellent opportunity for you to learn multiple skills from the convenience of your own home and explore Safety First: Understanding COSHH in the Workplace career opportunities. Certificates CPD Accredited Certificate Digital certificate - Included CPD Accredited e-Certificate - Free CPD Accredited Hardcopy Certificate - Free Enrolment Letter - Free Student ID Card - Free

Safety First: Understanding COSHH in the Workplace
Delivered Online On Demand6 days
£279

Programming and Data Wrangling with VBA and Excel

By Nexus Human

Duration 3 Days 18 CPD hours This course is intended for This course is primarily designed for students who want to gain the skills necessary to use VBA to automate tasks in Excel such as collecting data from external sources, cleaning, and manipulating data. The target student may also want to learn how to create custom worksheet functions to streamline worksheet formulas and make complex worksheets easier to support, maintain, and understand. Overview In this course, you will develop and deploy VBA modules to solve business problems. You will: Identify general components of VBA and their appropriate use in solving business solutions. Record VBA macros to automate repetitive tasks. Use reference tools built into Excel to get help on VBA programming language and objects used in the Excel VBA environment. Write VBA code to create a custom worksheet function. Eliminate, avoid, or handle errors in VBA code, and optimize its performance. Control how and when macros run. Develop UserForm objects to create custom dialog boxes and windows. Use VBA to read and write data from local files and cloud services. Use VBA to clean and transform data. Run programs and commands outside of Excel and share VBA projects with other users VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft© Excel© and other applications in the Microsoft© Office application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks involving the collection, processing, analysis, and visualization of data. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks, show you how to work with data across different applications, and how to package the macros and functions you create so you can back them up, move them to other computers, and share them with other users Prerequisites To ensure your success in this course, you should be an experienced Excel user who is comfortable creating and working with Excel workbooks, including tasks such as entering worksheet formulas, using absolute and relative addressing, formatting cells, and creating pivot tables and charts. This level of skill could be acquired by taking the Microsoft Excel for Office 365? (Desktop or Online) courses, Parts 1, 2, and 3 1 - Using VBA to Solve Business Problems Topic A: Use Macros to Automate Tasks in Excel Topic B: Identify Components of Macro-Enabled Workbooks Topic C: Configure the Excel VBA Environment 2 - Automating Repetitive Tasks Topic A: Use the Macro Recorder to Create a VBA Macro Topic B: Record a Macro with Relative Addressing Topic C: Delete Macros and Modules Topic D: Identify Strategies for Using the Macro Recorder 3 - Getting Help on VBA Topic A: Use VBA Help Topic B: Use the Object Browser to Discover Objects You Can Use in VBA Topic C: Use the Immediate Window to Explore Object Properties and Methods 4 - Creating Custom Worksheet Functions Topic A: Create a Custom Function Topic B: Make Decisions in Code Topic C: Work with Variables Topic D: Perform Repetitive Tasks 5 - Improving Your VBA Code Topic A: Debug VBA Errors Topic B: Deal with Errors Topic C: Improve Macro Performance 6 - Controlling How and When Macros Run Topic A: Prompt the User for Information Topic B: Configure Macros to Run Automatically 7 - Developing Custom Forms Topic A: Display a Custom Dialog Box Topic B: Program Form Events 8 - Using VBA to Work with Files Topic A: Use VBA to Get File and Directory Structure Topic B: Use VBA to Read Text Files Topic C: Use VBA to Write Text Files 9 - Using VBA to Clean and Transform Data Topic A: Automate Power Query Topic B: Transform Data Using VBA and Workbook Functions Topic C: Use Regular Expressions Topic D: Manage Errors in Data 10 - Extending the Programming Environment Beyond the Workbook Topic A: Run Other Programs and Commands Topic B: Share Your VBA Projects

Programming and Data Wrangling with VBA and Excel
Delivered OnlineFlexible Dates
£885

Mental Health Certificate

4.5(212)

By The Learning College Group

The TQUK LEVEL 2 Certificate in Understanding Children & Young People’s Mental Health (RQF) Qualification is to enable you to gain a recognised (RQF) qualification to support those with mental health difficulties. As a staffing member working with children and young people, you are responsible for the safeguarding of each person and as such having an understanding in supporting children and young people with difficulties in mental health.

Mental Health Certificate
Delivered Online On Demand
£50 to £299

Professional Scrum Product Owner Advanced

By Fractal Training

Join the Scrum.org accredited Live Virtual Class - Professional Scrum Product Owner Advanced™ training (PSPO Advanced) to master the role of a Product Owner. Learn how to advance your training of Product Ownership and apply it to deliver even more value. Course Description Agile techniques and the Scrum framework revolutionise project and product delivery, enabling teams to work faster and align closely with business needs. A product owner's role within this delivery is critical. Unlike traditional team managers, Product Owners focus on maximising product value rather than individual elements of project delivery. To excel in this role, product owners must combine business strategy with product vision and delivery roadmaps. The ability to operate within complex environments highlights the need for specific training and qualifications. Product Owner Advanced training is specifically designed to empower experienced Product Owners to deliver greater value. An exceptional Product Owner requires skillsets beyond core Agility and Scrum. These include clear decision-making, vision, communication, and influence. Practical experience is highly valued, and the PSPO 2 course emphasises interactive workshops, discussions, and exercises to provide a comprehensive understanding of the multifaceted Product Owner role. This course elevates existing Product Owners' capabilities, providing a clear path for your professional growth and delivering increased value to product stakeholders. Through collaborative and exploratory training, Product Owners' knowledge and experience will reach new heights, improving various aspects of your role. Key areas covered include: Deepening understanding of the Product Owner role, including product understanding, customer identification, and effective communication of product vision and strategy. Leveraging product vision and strategy to gain a competitive edge. Embracing diverse roles and stances essential for Product Owners. Enhancing stakeholder communication and management skills with a focus on different stakeholder groups. Navigating Agile governance, budgeting, and contracting within the Scrum framework. Scaling the Product Owner role for larger projects and products. By the end of this product owner advanced training, participants will be equipped to excel as Product Owners, driving success and value across their product journey. Why Train With Us? Develop advanced product owner skillsets that build on your existing knowledge of the Scrum framework and product owner accountabilities with our immersive two-day online PSPO Advanced course. Led by experienced industry professionals and support Professional Scrum Trainers & Product Owners, the course values team-based exercises and a hands-on learning experience. We help you grow within your Product Owner role through this advanced training, enabling you to better communicate product vision and strategy to teams, ultimately delivering higher value through projects and products with larger scopes. Who Should Attend This Course? The Professional Product Owner – Advanced course is designed for: Experienced Product Owners, ideally with at least one year of experience in the role Scrum Masters and stakeholders collaborating with Product Owners Your Professional Scrum Trainer Meet Jay, founder of Fractal Systems and a dedicated Professional Scrum Trainer. With over 20 years of experience in team and leadership roles, Jay is well-versed in delivering continuous value. His unique teaching approach involves zero PowerPoint and instead relies on engaging, experience-based sessions using techniques from Liberating Structures and Neuro Linguistic Programming. Jay's expertise lies in business transformations, offering training, mentoring, coaching, and consulting to foster success through collaborative efforts. Rapid learning and practical application are the hallmarks of his approach. Jay & the entire Fractal team are invested in your learning journey and are here to support you from start to end, including offering additional valuable support: Free practice assessments for certification success Free resource bundle to master Scrum Free exam revision sheets Free access to an exam simulator Free exam coaching sessions for first-time success Free 1:1 coaching to excel at work Our Clients Our Testimonials

Professional Scrum Product Owner Advanced
Delivered OnlineFlexible Dates
£950

2nd Women in Local Government Leadership Workshop

5.0(1)

By Own Your Success

Women in Local Government Leadership Workshop is for Local Government professionals looking to learn new skills with like-minded peers and further or advance their within Local government.

2nd Women in Local Government Leadership Workshop
Delivered OnlineJoin Waitlist
£475 to £625

Microsoft Excel Macros & VBA - In-company

By Microsoft Office Training

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

Microsoft Excel Macros & VBA - In-company
Delivered in London or UK Wide or OnlineFlexible Dates
£750

VBA with Microsoft Excel

By Nexus Human

Duration 1 Days 6 CPD hours This course is intended for This course is primarily designed for students who want to gain the skills necessary to use VBA to automate tasks in Excel such as collecting data from external sources, cleaning, and manipulating data. The target student may also want to learn how to create custom worksheet functions to streamline worksheet formulas and make complex worksheets easier to support, maintain, and understand. Overview Identify general components of VBA and their appropriate use in solving business solutions. Record VBA macros to automate repetitive tasks. Write VBA code to create VBA subroutines and functions. Use various programming elements to solve problems through code, including variables,objects, conditional statements, and loops. Eliminate, avoid, or handle errors in VBA code, and optimize its performance. VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft Excel and other applications in the Microsoft 365 application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks so they can be performed faster, more consistently, and with less effort than performing them manually. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks. You will learn how to use the macro recorder effectively, as well as how to write your own VBA code from scratch. You will use tools built into Excel to explore and learn VBA's capabilities and to optimize and debug your code. Prerequisites To ensure your success in this course, you should be an experienced Excel user who is comfortable creating and working with Excel workbooks, including tasks such as entering worksheet formulas, using absolute and relative addressing, formatting cells, and creating pivot tables and charts. This level of skill could be acquired by taking the Microsoft Excel for Office 365 (Desktop or Online) courses, Parts 1, 2, and 3. 1. Using VBA to Solve Business Problems Use Macros to Automate Tasks in Excel Identify Components of Macro-Enabled Workbooks Configure the Excel VBA Environment 2. Recording a Macro Use the Macro Recorder to Create a VBA Macro Record a Macro with Relative Addressing Delete Macros and Modules Identify Strategies for Using the Macro Recorder 3. Writing VBA Code Directly Write VBA Code Discover Objects You Can Use Create a Custom Function 4. Solving Problems through Code Make Decisions in Code Work with Variables Perform Repetitive Tasks 5. Improving Your VBA Code Debug VBA Errors Deal with Errors Improve Macro Performance 6. Controlling How and When Macros Run Prompt the User for Information Configure Macros to Run Automatically Additional course details: Nexus Humans VBA with Microsoft Excel (v1.2) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the VBA with Microsoft Excel (v1.2) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

VBA with Microsoft Excel
Delivered OnlineFlexible Dates
£655

Management & Leadership Foundation Course

5.0(1)

By Generation Leader

The most comprehensive, concise and impactful 6 weeks online course available. 14 CPD Credits & CMI Certificate of Recognition Mapped to the leadership & management requirements of the UK’s Royal Colleges Duration: 6 weeks starting immediately Suitable for: All levels of seniority Language: English Effort: 13 hours of self-paced online learning Award: 14 CPD Credits & CMI Certificate of Recognition  Accreditors: CMI, FMLM, CPD Certification Service  Content format: Videos with optional reading  Assessment Method: Multiple choice, instant result. Retake if required. In total there are 16 video courses to watch. This includes 7 CPD accredited courses that require you to complete a multiple choice assessment to confirm your understanding of the topic. A pass mark of 70% is required and this can be re-taken as many times as required. Optional reading and audio book resources are provided to enable you to explore a topic deeper if required. The content of the course is of the highest global standard and has been created by MIT Sloan Management Review. Our learning platform, called Skillsoft Percipio, provides a stunning learning experience. Key learning areas: Leading innovation Understanding change Leading with strategic thinking Building and leading teams Building trust Leading through change Strategic thinking Managing virtual teams On completion of this course, you will receive: A certificate stating 14 CPD Credits- Awarded by the CPD Certification Service A Certificate of Recognition from the prestigious Chartered Management Institute (CMI) Chartered Management Institute Affiliate membership for 1 year A digital badge to share on LinkedIn and add to your resume Your official CPD Certificate Your official CMI Certificate You will also be awarded the following additional benefits: Chartered Management Institute alumni network access for 1 year Access to Chartered Management Institute networking and learning events for 1 year World leading content supported by cutting edge technology. Made for healthcare professionals.  Did you know this course can be covered by the NHS study budget? The study budget covers: Courses and education activities to support you achieving the curriculum Courses to help you prepare for postgraduate exams Discretionary courses that add value to you individually and support the wider system To access the study budget you should discuss this with your educational supervisor or line manager. To help you with this process, view our example study budget application letter here.  For the duration of this course, you will work through the content below to obtain your CPD Credits and CMI Certificate. You can track your progress on the platform. You can complete the course sooner than 6 weeks if you wish. Course curriculum Building and Leading Successful teams Leading with Values and Ethic Leadership Insights on Leading with Executive Presenc Leadership Insights on Building & Leading Team Leadership Toolkit: Facilitating a Workshop Leadership Toolkit: Facilitating a Brainstorming Sessio Leadership Toolkit: Running a Team Debrie The Characteristics of an Accountable Leade Leading through Shared Vision Evaluating Your Management Style The Adaptive Leader: Be an Iceberg The Collaborative Leader Leading through Problem Solving and Decision Making Leadership Insights on Leading Diversity Leadership Insights on Judgment and Decisiveness Leading with Judgment and Decisiveness Accountable Leadership Leadership Insights on Being Accountable Expert Insights on Networking & Building Relationships Building Your Professional Network Leadership Insights on Networking with your Peers Networking to Improve Leadership Effectiveness Empowering Employees MIT Sloan Management Review on New Leader Transitions All the Leader You Can Be: The Science of Achieving Extraordinary Executive Presence MIT Sloan Management Review on The Adaptive Leader MIT Sloan Management Review Article on Looking for Opportunity in the Midst of Crisis Executive Presence: The Art of Commanding Respect like a CEO, Second Edition MIT Sloan Management Review on Leader as Motivator The Accountable Leader: Developing Effective Leadership Through Managerial Accountability From Bud to Boss: Secrets to a Successful Transition to Remarkable Leadership Strategic Connections: The New Face of Networking in a Collaborative World The Courage Way: Leading and Living with Integrity Executive Presence: The Art of Commanding Respect Like a CEO

Management & Leadership Foundation Course
Delivered Online On Demand
£620

Photoshop Training Course Basics to Advanced

By ATL Autocad Training London

Photoshop Training Course Basics to Advanced designed for individuals of every skill level, ranging from beginners to advanced image editing professionals. Immerse yourself in the realm of potent image manipulation tools at our school in London. Personalized Photoshop courses either at our facility or directly at your location. Click here for more info: Website Duration: 20 hours. Method: Personalized 1-on-1. Schedule: Customize your learning with pre-booked sessions available Monday to Saturday, from 9 am to 7 pm. Course Title: Mastering Photoshop: From Basics to Advanced Proficiency Course Duration: 20 hours Module 1: Introduction to Photoshop (2 hours) Understanding the Photoshop interface Navigating tools and panels Basic keyboard shortcuts for efficient workflow Introduction to different file formats and their uses Module 2: Essential Tools and Techniques (3 hours) Selection tools and techniques for precise editing Working with layers: management and blending modes Understanding brushes, gradients, and patterns Introduction to basic filters and their applications Module 3: Image Editing and Retouching (4 hours) Color correction and adjustment layers Advanced retouching techniques: Healing Brush, Clone Stamp, and Content-Aware tools Removing backgrounds and unwanted elements Restoring old or damaged photographs Module 4: Advanced Photo Manipulation (3 hours) Compositing multiple images seamlessly Advanced blending modes and layer effects Creative use of masks and clipping paths Special effects: lighting, shadows, and reflections Module 5: Text and Typography (2 hours) Working with text layers and formatting options Creating custom typography and text effects Utilizing layer styles for creative text designs Text manipulation along paths and shapes Module 6: Web and UI Design (3 hours) Designing web banners, buttons, and interfaces Slicing and optimizing images for the web Creating interactive prototypes and mockups Exporting assets for web and app development Module 7: Print Design and Prepress (2 hours) Understanding color modes: CMYK vs. RGB Setting up documents for print: bleed, margins, and resolution Designing print materials: brochures, business cards, and posters Preparing files for professional printing Module 8: Project-Based Learning (1 hour) Applying learned techniques to real-world projects Instructor-led project: creating a digital artwork or advertisement Feedback and critique session for skill refinement Final presentation of completed projects Upon completion, you will: Master Photoshop Skills: Gain proficiency in fundamental and advanced Photoshop techniques, enabling professional-level image editing and creative design. Enhance Creativity: Develop creative problem-solving abilities, enabling innovative and visually appealing design solutions. Job Opportunities: Graphic Designer: Craft compelling visual content for ads, websites, and marketing materials. Photo Retoucher: Edit and enhance photographs to meet professional standards. Digital Artist: Create digital artwork and illustrations for various purposes. Web/UI/UX Designer: Design user-friendly interfaces and engaging online experiences. Marketing Content Creator: Generate eye-catching promotional visuals and social media content. Video Editor: Enhance video footage and create engaging video content for online platforms. Professional Adobe Photoshop Training in London - On-Site & Live Virtual Classes Being the industry-leading image editing software, Photoshop empowers users to manipulate images, enhance colors, and create visually striking designs. Its extensive toolkit allows for intricate adjustments, retouching, and even editing videos, graphic design, and 3D imagery. Enroll in our Photoshop course to establish a strong foundation in creative visuals, focusing on essential skills like image adjustment, composition, and common troubleshooting. For a more in-depth understanding, our Advanced course delves into advanced techniques such as color fills, text and layer styling, and creating web-ready artwork. Explore our masterclass options for advanced training and deeper insights. Both beginner courses are available in physical classrooms and online, providing flexible learning opportunities.   Holistic Design Education: Comprehensive training across diverse design fields. Industry-Experienced Instructors: Learn from seasoned professionals in the field. Flexible Learning: Accommodating schedules for busy professionals and students. Practical Projects: Hands-on projects for real-world design experience. Career-Focused Skills: Acquire industry-relevant skills for professional growth. Cutting-Edge Facilities: Access state-of-the-art technology and facilities. Personalized Training: Tailored programs to suit individual learning needs. Networking Opportunities: Connect with design professionals for valuable connections. Innovation Exploration: Explore creative trends and emerging technologies. Ongoing Support: Continuous assistance and post-course guidance.

Photoshop Training Course Basics to Advanced
Delivered in London or OnlineFlexible Dates
£720