42989 Learning 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

Why Choose 3ds Max and Photoshop Training Course? Click here for more info 3D modeling and rendering potential with our specialized 3ds Max and Photoshop Training Course! Learn from modeling to rendering in 3ds Max and enhance visuals with Photoshop. Personalized, live online sessions with an experienced instructor. Enroll now and bring your 3D visualizations to life. Duration: 20 hrs Method: 1-on-1, Personalized attention. Schedule: Tailor your own hours of your choice, available from Mon to Sat between 9 am and 7 pm. The 3ds Max and Photoshop Training Course offers comprehensive learning for beginners, focusing on core skills to create 3D models, rendered images, animations, and games using 3ds Max and Photoshop. Led by Autodesk Certified Instructors with expertise in 3D design, CGI, and visualizations, the course provides hands-on and practical training. 20-hour 3ds Max and Photoshop Training Course Course Description: 20-hour 3ds Max and Photoshop Training Course to master 3D modeling, rendering, and post-production. Learn to create 3D models, apply textures, animate objects, and utilize lighting techniques in 3ds Max. Gain expertise in Photoshop for post-processing and creating photorealistic textures. Ideal for 3D artists of all levels. Course Outline: Part 1: Introduction to 3ds Max (6 hours) - Understanding the user interface and workspace of 3ds Max - Navigating the viewport and utilizing basic tools for modeling - Creating and manipulating primitive objects for design purposes - Modifying objects with modifiers to achieve specific effects - Working with materials and textures to add realistic detail to 3D models - Basic lighting and rendering techniques to present the 3D scenes Part 2: Intermediate 3ds Max Techniques (6 hours) - Modeling using splines and polygons for more complex shapes - Creating and animating cameras to simulate real-world perspectives - Rigging and animating characters with bones for animation projects - Utilizing particle systems for visual effects and dynamic simulations - Designing realistic environments using landscape tools for outdoor scenes - Exploring advanced lighting and rendering techniques for enhanced visuals Part 3: Introduction to Photoshop for 3D Artists (4 hours) - Understanding the Photoshop workspace and essential tools for editing - Importing and exporting 3D models and textures between 3ds Max and Photoshop - Creating and editing textures and materials in Photoshop for realistic surfaces - Utilizing Photoshop for post-production and compositing to enhance 3D renders Part 4: Advanced Photoshop Techniques for 3D Artists (4 hours) - Creating custom brushes and textures for unique artistic elements - Using layer masks and adjustment layers for non-destructive editing - Exploring advanced compositing techniques for seamless integration of 3D elements - Creating photorealistic textures and materials for stunning 3D visuals Part 5: Project-Based Learning (4 hours) - Applying 3ds Max and Photoshop techniques to a real-world project - Creating a 3D model, texturing it in Photoshop, and rendering the final image - Receiving instructor feedback for critiquing and refining the project - Final presentation of the completed project showcasing skills learned.

Diploma in Special Education Needs (SEN) A career in the SEN field may be ideal for people who appreciate working with and assisting children with learning disabilities. It is crucial to identify children with learning problems as soon as possible to meet their special education needs. Teaching strategies and tactics for SEN students will differ from those used with other students. As a result, learning the required knowledge and skills before beginning a career in SEN is important. Our Course Cave diploma in Diploma in Special Education Needs (SEN) course is designed to provide you with the necessary knowledge and skills for a career in SEN. This Diploma in Special Education Needs (SEN) course is highly recommended for special education professionals who desire to develop their professions. If you finish this course, your chances of finding a relevant job will improve. Experts have designed this course to help you learn fast and efficiently, at your own speed and convenience. Enrol in our diploma in Special Education Needs (SEN) course to start a great career in the field of SEN. Learning Outcomes After completing this Diploma in Special Education Needs (SEN) course successfully, you will be able to: Describe everything about Special Education Needs. Examine the latest SEND code of practice's various provisions. Describe the various SEN-related laws. Recognize the most common SEN conditions in schools. Describe the SENCO's position, value, and how to work with other agencies. Create an effective plan to address the special educational needs and disabilities of your students. Dealing successfully with other organizations that offer assistance to children with disabilities. Why Choose Diploma in Special Education Needs (SEN) Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials of Diploma in Special Education Needs (SEN) Course developed by industry experts. MCQ quiz after each module to assess your learning. Automated and instant assessment results. 24/7 support via live chat, phone call or email. Free PDF certificate as soon as completing the course. Diploma in Special Education Needs (SEN) Course Curriculum of Diploma in Special Education Needs (SEN) Module 01: Introduction What is Special Education Needs (SEN) Some Essential Terminology Related to SEN What Can You Do if You are Worried that Your Child May Have Difficulties? What is the Graduated Approach? What is a Statutory Assessment? Module 02: A Quick Overview of the New SEND Code of Practice What is the SEND Code of Practice? Different Sections of This Code of Practice Changes from the SEN Code of Practice (2001) Module 03: Legislation Related to SEN The Children and Families Act and associated Code of Practice 2014 Module 04: SEN Assessments and Descriptors SEN Information Form to Inform Assessment Initial Screening Test SEN Descriptors Module 05: Education for Children with Disabilities Why is Disability Such an Essential Issue for Education? What are the Barriers to Educating Children with Disabilities? Segregation, Integration or Inclusion? Action Required Making Interventions Effective for Children with Disabilities How to Improve the Quality of Education for Children with Disabilities? How to Get Children with Disabilities in Schools? Module 06: Common SEN Conditions Found Within Mainstream Schools Specific Learning Difficulties (SLD) Cerebral Palsy Learning about Autism Spectrum Disorders (ASD) Module 07: Assessment and Planning for Children with Special Educational Needs The Place of Assessment in Supporting Learning and Behaviour Needs Formal, Norm-referenced (standardised) Tests Criterion-referencing Assessment of Behaviour Assessment of Visual Impairment Auditory Impairment Taking Students' Views into Account Engaging with Parents' or Carers' Perspectives Planning to Meet Pupils' Special Educational Needs and Disabilities Planning for Differentiation Module0 8: The Broader Children's Workforce Associated with Special Education Needs Provisions In-class Support Arrangements Effective Use of Support Staffs in Classroom Issues Inter-agency Collaboration Module 9: Working with Other Professionals and Other Sources of Support and Information Involving Specialists The Local Offer Professionals Who Maybe in Your Support and Advice Network Other Professionals Certificate of Completion You will receive a course completion certificate for free as soon as you complete the course. Module 01: Introduction 13:41 1: Introduction 09:41 2: Introduction 04:00 Module 02: A Quick Overview of the New SEND Code of Practice 23:59 3: A Quick Overview of the New SEND Code of Practice 18:59 4: A Quick Overview of the New SEND Code of Practice 05:00 Module 03: Legislation Related to SEN 08:36 5: Legislation Related to SEN 04:36 6: Legislation Related to SEN 04:00 Module 04: SEN Assessments and Descriptors 16:34 7: SEN Assessments and Descriptors 12:34 8: SEN Assessments and Descriptors 04:00 Module 05: Education for Children with Disabilities 33:37 9: Education for Children with Disabilities 29:37 10: Education for Children with Disabilities 04:00 Module 06: Common SEN Conditions Found Within Mainstream Schools 20:43 11: Common SEN Conditions Found Within Mainstream Schools 17:43 12: Common SEN Conditions Found Within Mainstream Schools 03:00 Module 07: Assessment and Planning for Children with Special Educational Needs 59:41 13: Assessment and Planning for Children with Special Educational Needs 55:41 14: Assessment and Planning for Children with Special Educational Needs 04:00 Module 08: The Broader Children's Workforce Associated with SEN Provisions 19:11 15: The Broader Children's Workforce Associated with SEN Provisions 15:11 16: The Broader Children's Workforce Associated with SEN Provisions 04:00 Module 09: Working with Professionals and Other Sources of Support 13:48 17: Working with Professionals and Other Sources of Support 09:48 18: Working with Professionals and Other Sources of Support 04:00 Who is this course for? Diploma in Special Education Needs (SEN) This course is applicable for: SEN counsellors Teachers Parents with special needs children Behavioural Analysts Requirements Diploma in Special Education Needs (SEN) There are no specific requirements for this Diploma in Special Education Needs (SEN) course because it does not require any advanced knowledge or skills. Certificates Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

The Master Practitioner in Emotional Intelligence course explores the concept of emotional intelligence in detail building upon what you know to give you a much deeper understanding. The Master Practitioner in Emotional Intelligence course covers the application of emotional intelligence in different circumstances to improve and enhance performance throughout an organisation and extends to decision making stakeholders outside the organisation. The skills and competencies are also applicable in many situations in families, communities and social settings.

Conflict Resolution Skills: In-House Training Many organizations have assumed that workplace conflict is always destructive. So, they have often believed that conflict is best dealt with by managers or even via policies and procedures. After all, conflict creates workplace stress and leads to many performance problems, generating very real organizational costs! However, savvy organizations have embraced the fact that when conflict is understood and harnessed, it can be leveraged to add value to teams and even enhance performance. With the right knowledge, skills, training, and practice, conflict can be productive and make organizations better! In this highly interactive course, learners will discover the connection between individual conflict response and team-empowering conflict resolution skills. Participants will explore conflict's visceral dynamics and the nuanced behaviors we individually engage in to communicate and respond to conflict. Learners will apply techniques for transforming unproductive conflict responses into productive ones. Additionally, learners will use a systematic method that prepares them to objectively dissect real-world conflict, while practicing many strategies for resolving it. They will also develop proactive conflict approach plans, which they can transfer back to their own workplaces. What you will Learn At the end of this program, you will be able to: Recognize the organizational costs of conflict Explain our physical and mental responses to conflict Communicate proactively and effectively with different types of people during conflict Replace unproductive conflict responses with productive ones Use the Conflict Resolution Diagram (CRD) process and conflict resolution approaches Relate team stages of development to shifts in conflict Develop a proactive conflict approach for your organization Create a conflict resolution plan for a real-world scenario Getting Started Introductions and social agreements Course goal and objectives Opening activities Conflict Facilitation Readiness Conflict responses and perceptions Conflict basics Conflict and organizations Dynamics of conflict Conflict Styles and Communication A look at the color energies model Conflict through the color energies and DiSC® lens Communication with opposite color energies Individual Response to Conflict The anatomy of conflict Recognizing unproductive conflict responses 4 steps to productive conflict Choosing productive conflict responses Team Performance and Conflict High-performing team relationships Conflict and project team performance Conflict Resolution Diagram (CRD) and process Conflict Facilitation - Preparation Recognizing context and stakeholder needs Using team conflict resolution approaches Preparing for Crucial Conversations® Conflict Facilitation - Clarity Exposing assumptions and biases Defining the conflict and using the CRD Conflict Facilitation - Action Proactive conflict management Conflict facilitation practice Summary and Next Steps Review Personal action plans

Our online Focus Awards Level 5 Diploma in Education & Training (RQF) course will provide you with a strong background in understanding the skills you need to progress in the workplace and earn a recognised qualification.

This course bundle is ideal for anyone looking to establish their Cisco networking career. It consists of one Cisco Certified Network Associate (CCNA) certification, one Cisco Certified DevNet Associate (CCDA) certification, and four Cisco Certified Networking Professional (CCNP) certifications. Although there are no formal prerequisites to enrol on the CCNA, CCDA, or CCNP certification courses and sit the exams, learners should have a good foundation knowledge in networking. The newly retooled CCNA covers a breadth of topics, including: Network fundamentals Network access IP connectivity IP services Security fundamentals Automation and programmability Achieving CCNA certification is the first step in preparing for a career in networking technologies. To earn your CCNA certification, you only need to pass one exam – which covers a broad range of fundamentals for IT careers, based on the latest networking technologies. The Cisco Certified DevNet Associate certification validates your skills and knowledge in understanding and using APIs, Cisco platforms and development, application development and security, and infrastructure and automation. Ideally, DevNet Associates candidates also have one or more years of experience with software development including Python programming. The CCNP is the next level from the CCNA and CCDA. As with the CCNA, there are no formal prerequisites to enrol on the CCNP certification course and sit for the exams. Learners taking a CCNP course generally have an in-depth knowledge of networking, as well as a good understanding of Cisco technologies. The typical certification path for most learners would begin with either the CCDA or CCNA, then progress onto the CCNP. Learners need to pass two exams (one core exam and one concentration exam) in order to gain one CCNP certification. This course bundle includes the core exam and three concentration exams. Once a learner has passed the core exam, they can choose to specialise in one or all three of the CCNP concentration areas listed in this course. The core exam’s focus is based around implementing and operating Cisco enterprise network core technologies.

Recovering Troubled Projects: On-Demand Despite our best intentions, many of the projects that organizations undertake either don't achieve their intended business results or end in complete failure. Most seasoned project managers have had their share of experiences with difficult or troubled projects and unless they are careful, they will encounter more. This workshop does not focus on 'failed' projects but rather on those projects which without appropriate intervention would be headed for failure. Failed projects are those beyond help and which should be terminated. Here we focus on projects that are salvageable. It is an exercise-driven, no-nonsense, professional practice-focused workshop positioning the participant to immediately apply the tools and lessons learned in the classroom. The workshop employs the use of both illustrative and practical/working case studies. Illustrative case studies will examine insights from real-world troubled projects. Participants will be asked to bring descriptions of their own examples of troubled projects on which they're currently working or on which they have worked in the past. A number of these will be used as the basis for the practical/working case studies. The approach builds on and complements the disciplines addressed in Project Management Institute's PMBOK® Guide and also addresses issues that arise when managing projects in a complex environment. What You Will Learn You will learn to: Recognize the value of a structured project recovery process Explain the reasons most projects fail Analyze the causes of a project's troubles Construct a negotiation process to use with key stakeholders Apply an effective strategy to planning the recovery effort Manage, evaluate, and adjust the ongoing recovery effort Foundation Concepts Recognizing a troubled project Defining the project recovery process The Reasons Projects Fail Putting failure in perspective Reviewing management issues Analyzing planning issues Exploring complexity issues Assess the Project Stabilizing the project Determining preliminary Go / No-Go Conducting a detailed recovery assessment Negotiate the Recovery Reviewing the basics of negotiation Setting reasonable expectations Obtaining appropriate PM authority Securing key stakeholder support Plan the Recovery Planning for recoveries Rebuilding the project team Reshaping the project plan Managing parallel activities Planning for change management Implement and Adjust the Project Implementing project recoveries Facilitating change Enabling continuous learning Fostering the project team Sustaining stakeholder engagement

The Microsoft Office Specialist (MOS) is a globally recognised qualification. Having a Microsoft Office Specialist certification on your CV demonstrates that you have gained the necessary expertise to competently use Microsoft applications, giving you a competitive advantage when job hunting as well as in the workplace. It will significantly increase your confidence, skills and employability. It will serve to objectively validate your IT skills and assist in your advancement in your chosen career.

This course explains what strategic planning really means, how businesses and companies successfully initiate and develop a strategic planning process to create value for customers and stakeholders. In this course, you will learn how to develop the best strategic planning process to support your company's goals and what brings the strategic planning process into action. The course modules combine a few proven-by-practice methods for executing the plan and provide new insights and approaches from a broad range of modern strategic planning. Moreover, you will understand the impact of strategic planning on your work and your organization's success. In just 2 Hours 30 Minutes you will: Gain a deeper perspective of the strategic planning process Develop the best strategic planning process to support your organisation's goals Successfully implement the strategic planning process Develop the skills and knowledge to successfully implement strategic planning that produces real results Appropriately respond to intricate and unpredictable business moves Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessment Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £69.00. Please note that overseas students may be charged an additional £10 for postage. CPD Certificate of Achievement from Janets Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Endorsement This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment To successfully complete the course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the course. After successfully passing the exam, you will be able to apply for Quality Licence Scheme endorsed certificate of achievement. To verify your enhanced skills in the subject, we recommend that you also complete the assignment questions. These can be completed at any time which is convenient for yourself and will be assessed by our in-house specialised tutors. Full feedback will then be given on your current performance, along with any further advice or support. Who is this course for? Strategic Planning Process is suitable for anyone who want to gain extensive knowledge, potential experience and expert skills in the related field. This course is designed by industry experts so you don't have to worry about the quality. Most importantly, this course does not require any experience or lesson to get enrolled. You will learn everything that is required from this course directly. This is a great opportunity for all students from any academic backgrounds to learn more on this subject. This qualification is ideal for: Managers Team Leaders Executives Administrators Employees Businesspeople Directors