796 Teaching courses in Colne delivered Live Online

Course Objectives At the end of this course you will be able to: Record and edit a Macro Assign macros to keyboard shortcuts, Quick Access Toolbar, Buttons and Shape objects. Use the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks Create an error handling routine in case things go wrong with VBA code ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The trainer was very knowledgeable, kept everyone involved and was enthusiastic. A great experience.. Simon Harper - Lloyd's of London My learning experience was awesome. Perdinand Reagan - Subsea7 Very nice and relaxed approach to teaching. Was definitely a good learning experience. Jerome Pupe - S5 Agency World The Trainer – Very positive + patient + helpful + thorough Agnes Souza - Direct Wines ' With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Introduction to Macros and VBA Introducing Visual Basic for Applications Recording a Macro Naming conventions for Macro Procedures Running a Macro Absolute or Relative Cell Referencing Saving and Opening Files with Macros Making macros always available Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, Buttons and Shapes Editing a Macro in the Visual Basic Editor Understanding the Development Environment Customising the Editor Tips for General Typing in VBA Using Visual Basic Help Working with Procedures Program Design Understanding Modules Naming Rules Creating a Module Understanding Procedures Programming Macro Concepts Creating a Subroutine Creating a Function Understanding Arguments Exiting Procedures Calling Procedures Objects, Properties, Methods and Events Understanding Objects Properties, Methods, and Events Navigating the Object Hierarchy Understanding Collections Accessing a Member of a Collection Understanding Hierarchy Using the Object Browser Using the With Statement Working with Properties Working with Methods Creating an Event Procedure Reserved Macro Names Using Expressions, Variables and Intrinsic Functions Understanding Expressions and Statements Declaring Variables Understanding Data Types Determining the Value of Variables Working with Variable Scope Using Built-in VBA Functions Understanding Constants Using Message Boxes Controlling the Answer to a Message Box Using Input Boxes Declaring and Using Object Variables Controlling Program Execution Understanding Control-of-Flow Structures Using the If...End If Decision Structures Nested If Statements Using the Select Case ... End Select Structure Using the Do ... Loop Structure Using the For ... Next Structure Using the For Each ... Next Structure Guidelines for Use of Control-of-Flow Structures Debugging and Handling Errors Understanding Errors Using Debugging Tools Setting Breakpoints and Using Break Mode Stepping Through Code Trapping Errors with the On Error Statement Understanding the Err Object Working with Inline Error Handling Writing an Error-Handling Routine Working with Forms and Controls Understanding UserForms Creating a Form Displaying and Removing a Form Aligning and Sizing Controls Using the Toolbox Working with a Form's Properties, Methods, and Events Working with Form and Control Properties, Methods and Event Setting the Tab Order Populating a Control Who is this course for? Who is this course for? This course is designed to give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, understanding Object's Properties, Events and Methods, basic VBA Object oriented programming, event handling, control structures, and debugging tools. Requirements Requirements Preferably, delegates should have attended the Excel Advanced course. Certificates Certificates Certificate of completion Digital certificate - Included

Our courses have been designed by experienced teachers to make getting TEFL qualified as convenient as possible. These online courses are entirely self-paced, meaning you can fit study around your life in a way that works best for you. Throughout the course, you will have the support of your own personal tutor who is with you from beginning to end to mark your work, provide helpful feedback, and answer all your questions. 120-hour Premier Online TEFL Course: 50-hour Online TEFL Course Learn about classroom management, teaching styles and advanced TEFL methodology. Includes units on business English, young learners, and teaching English one-to-one. Study with a personal tutor and meet fellow students on our course forums. 30-hour Online Grammar Course Do not know your irregular verbs from auxiliary verbs? This course will improve your basic grammar and give you the grounding you will need to communicate complicated language rules to a student audience. 20-hour Online Video Course Seeing an English teacher in action is a potent learning tool and really brings the theory to life. Feel free to steal the ideas in these video courses to use in your first lessons. We do not mind! Two 10-hour specialist mini-modules. Two mini-modules designed for specific TEFL jobs, which will help your CV stand out. One 10-hour unit is about teaching online, and the other 10-hour unit will help you teach large classes. Included in the 120-hour Premier Online TEFL Course: Lifetime access to the TEFL Job Centre The TEFL Virtual Educators course doesn’t just train you to teach; it helps you find and be offered great TEFL jobs around the world. From exclusive access to our job vacancies to a lifetime of free TEFL career advice, we’re here to help you kick-start your new career. Internationally recognised TEFL certificate – hard copy & PDF A widely-recognised certificate posted straight to your door which shows your achievements on our course, something you can show to TEFL employers to secure you a job. Personal online TEFL tutor Work through your course with the help of an experienced and qualified TEFL tutor. Throughout the course, you’ll have the same tutor, so you have one point of contact for advice and assistance. Online TEFL Class breakdown Lesson Planning Teaching English Vocabulary Teaching Pronunciation Understanding English Grammar Teaching Receptive Skills: Listening and Reading Teaching Productive Skills: Speaking and Writing Teaching English Grammar Principles of Teaching English as a Foreign Language Materials and Aids for Teaching English/Classroom Management Strategies Using Resources Effectively when Teaching English as a Foreign Language Case Study, CV and Cover Letter, Job Sites and Resources You will explore the latest theories in topics such as second language acquisition and social discourse and have the chance to apply these to your own classroom practice and curriculum development. You will also learn to conduct your own research, compile and analyse qualitative and quantitative data and develop your critical-evaluative skills. These skills will be used on your own research project at the end of the course, as well as in your future career. Core modules: Second Language Acquisition You will focus on the major themes that have emerged from literature on second language learning over the last three decades. You will examine some of the research on the second-language acquisition process, look critically at reports of second-language research, and examine some of the theories which endeavour to interpret research evidence. You will be encouraged to use your own language learning and teaching experience to assess the relative merits of such materials. Discourse in Society You will examine the relationship between language and society and the construction of discourse in various domains. You will explore sociological and sociolinguistic models and theories, such as speech communities, communities of practice and ethnolinguistic vitality, with a particular focus on social variation and stratification across various linguistic levels (phonology, lexicon, syntax). You will explore discourse's notion (or notions) in both its linguistic and wider meaning and its construction in and through society and language use. You will study methods for collecting and transcribing data and discover various linguistic and discourse analysis approaches. These methods and approaches will then be put into context and used in the analysis of the relevant social spheres and domains, such as educational or institutional discourse. Research Methods in Applied Linguistics This module will provide you with an introduction to research methods in preparation for the MA dissertation. It will familiarise you with the basic processes of conducting research, including general methodological approaches as well as research ethics. You will analyse and discuss both qualitative and quantitative data in order to develop your critical-evaluative skills. Materials and Course Design You will explore the factors involved in the design of language courses and teaching materials, reflecting on one possible course design process. You will start with an analysis of the context in which the course will take place, the needs of the learners, and current theories of language and language learning. You will move on to consider how course content can be selected and ordered in a principled way, how assessment relates to course design, and how and when courses should be evaluated. Finally, you will consider the evaluation, adaptation, and creation of course materials. Classroom Theory and Practice You will examine current research on modern classroom operations, exploring key concepts and issues through relevant professional and academic literature. A more practical element will be realised through filmed observation of teachers in practice. You will also be encouraged to reflect on your teaching and learning experience and analyse and discuss your beliefs and attitudes towards learning and teaching. Major Project This module will support you in the preparation and submission of a master’s dissertation, allowing you to explore in-depth a particular topic that reflects your academic interest. Assessment You will show your understanding of theoretical issues and their practical application through a combination of portfolios, classroom observation tasks and critical essays. After completing your final module, you will also research and prepare a 15,000-word dissertation.

Agile techniques and management frameworks are changing the way organisations operate. Evolving to realise that organisations are no longer static and structured entities is the key to unlocking new ways to achieve better results. Agile can be utilised at an organisation, team, and project level. Transforming to an Agile way of working requires knowledge, commitment, and frameworks to lead change. The Applying Professional Scrum training teaches key implementation techniques and Scrum frameworks. Course Description Applying Professional Scrum Training ONLINE Getting results with the Scrum framework Scrum is the most used Agile framework for complex product development and project management. It is a proven system, in use for over 25 years by companies large and small. Scrum training introduces an iterative and incremental approach to product or project development – aiming to reduce complexity and achieve results faster. A Scrum team works simultaneously rather than sequentially, with more flexibility. Scrum teams learn to work better together, delivering more value for project stakeholders. Applying professional scrum training The Applying professional Scrum (APS) course introduces the Scrum framework and demonstrates its power over traditional approaches to project or product development. It is an interactive course that aims to familiarise participants with its iterative and 'Sprint' based methodology. The Scrum framework is commonly used in software development but is relevant in any industry or to any complex project. Course contents and key objectives The course will teach participants how to apply Professional Scrum and the Scrum framework. It is appropriate for anyone, whether or not they have previous exposure to Scrum. Contents of the two-day course include: Understanding more about Agile development and the value that an Agile mindset can bring. Explain how Scrum differs from traditional work models and the advantages this offers. Explain the details of the Scrum methodology and its practical application. Understand how to apply Scrum to projects and teamwork. This includes the concepts of the Scrum team, Sprints, Sprint reviews, and the Daily Scrum. Course attendees will work in Scrum teams to simulate a Scrum project. This will involve a series of 'sprints' to solve complex problems and demonstrate the Scrum approach's power. Such Sprints are key to the Scrum framework. They bring in the iterative way of working, giving teams the chance to review success and quickly adapt to meet business requirements. As part of this practical approach, participants will learn to recognize and understand common missteps and misunderstandings when using Scrum. Expected Outcomes from Applying professional scrum training Applying professional scrum training will teach attendees what Scrum is, the value it can deliver, and how to implement it. The practical and example-based nature of the course will help develop a thorough understanding of the Scrum framework. Experience is the key to implementing it in practice. As such, the course is designed to mimic this and teach the problems to look out for and their solution. Participants will emerge as proficient Scrum practitioners – ready to transform the development of their projects. Who Should Attend This Course? Scrum is beneficial for any company, or individual, with complex projects or products. This course provides an introduction and solid grounding in Scrum, enabling participants to work effectively within the Scrum team and to go on to further training if desired. It is ideal for anyone: Working in or joining a team that uses Scrum. Considering the use of Scrum or investigating its benefits. Working alongside or managing Scrum teams – even if not using the methodology directly. 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

This is an online course sat at your own pace to introduce you to clinical coaching. During the course we will go into the concept of training a student, learning methods, tutorial techniques, safeguarding and how to use the Central Skills Log (CSL). The course is open for 2 months. Once completed we can then arrange access to the CSL for one of Abbeydale’s students.

Develop a deep understanding of electricity pricing and marginal cost analysis with EnergyEdge's virtual instructor-led training course. Enroll now for a rewarding learning journey!

Learners will be introduced to EAS as part of the fire safety solution for tall residential properties. This CPD course provides learners with an understanding of the requirements of BS 5839-1 in relation to, design, installation, commissioning, and maintenance of EAS.

Computer Science GCSE Syllabus The GCSE Computer Science Tutor Syllabus is designed to provide tutors in England with a comprehensive framework for teaching the GCSE Computer Science curriculum effectively. This syllabus aims to equip tutors with the necessary knowledge and skills to support students in their understanding and application of core computer science concepts.  Module 1: Introduction to Computer Science - Overview of computer science and its relevance in today's world - Understanding the components of a computer system - Introduction to algorithms and problem-solving techniques - Exploration of programming languages and their uses Module 2: Computer Hardware - Understanding the main components of a computer system, including CPU, memory, and storage devices - Exploring input and output devices and their functionalities - Understanding the role of operating systems and software in computer systems Module 3: Software Development - Introduction to programming concepts and languages (e.g., Python or Java) - Understanding variables, data types, and operators - Building algorithms and logical reasoning skills - Introduction to flowcharts and pseudocode - Implementation of simple programs and debugging techniques Module 4: Data Representation - Understanding binary, hexadecimal, and denary number systems - Representation of text, images, and sound using binary - Introduction to data compression and encryption techniques Module 5: Computer Networks - Understanding the basics of computer networks, including LAN, WAN, and the Internet - Introduction to network topologies, protocols, and security - Exploring the impact of digital communication on society Module 6: Cybersecurity and Ethical Issues - Understanding the importance of cybersecurity and data protection - Introduction to common threats and vulnerabilities - Exploring ethical issues related to computer science, such as privacy and intellectual property rights Module 7: Algorithms and Programming Techniques - Advanced programming concepts, including conditionals, loops, and functions - Introduction to sorting and searching algorithms - Exploring data structures, such as arrays and lists Module 8: System Architecture - Understanding the structure and function of a CPU - Introduction to memory hierarchy and cache - Exploring the Von Neumann architecture and its limitations Module 9: Computational Thinking and Problem Solving - Advanced problem-solving techniques using computational thinking - Introduction to algorithms for complex problems - Exploring algorithmic efficiency and optimization techniques Module 10: Exam Preparation and Revision - Reviewing key concepts covered throughout the syllabus - Practicing past exam questions and providing guidance on exam techniques - Supporting students with exam preparation strategies Please note that the duration and depth of each module can vary depending on the level of expertise required and the specific needs of the learners. Additionally, it's important to adapt the curriculum to the learners' proficiency levels, whether they are A Level/GCSE students or adult learners with different experience levels.

Learners will be introduced to the design, installation, commissioning, and maintenance of Access Control systems.

Who is this course for? The "3ds Max and Unity 3D Game Designing Training Course" is ideal for aspiring game designers, developers, graphic designers, students, and creative professionals. It's tailored for individuals keen on mastering 3D modeling, animation, and interactive game development using industry-standard software like 3ds Max and Unity 3D. Click here for more info: Website Scheduling: Available from Monday to Saturday, 9 a.m. to 7 p.m. Choose in-person or live online sessions over Zoom. Duration: 40 hours. Module 1: Introduction to 3ds Max (8 hours) Overview of 3ds Max interface and tools Basic 3D modeling techniques: primitives, Editable Poly, modifiers Material creation and application Introduction to lighting and rendering concepts Module 2: Advanced 3ds Max Techniques (8 hours) Advanced modeling: Splines, Loft, Extrude, and ProBoolean Animation basics: Keyframes, paths, and controllers Particle systems and dynamics Introduction to character rigging and animation Module 3: Introduction to Unity 3D (8 hours) Unity interface and project setup Importing 3D assets from 3ds Max Physics and colliders in Unity Basic scripting and interactions Module 4: Advanced Unity 3D Features (8 hours) Unity scripting: C# fundamentals Advanced physics and particle systems User interface design and implementation Integrating audio and visual effects Module 5: Game Design and Optimization (8 hours) Game design principles and mechanics Level design and interactive gameplay elements Optimizing game performance: LOD, batching, and asset optimization User testing and feedback incorporation Final Project (4 hours) Collaborative game development project using 3ds Max and Unity 3D Implementation of learned skills in a real-world scenario Presentation and feedback session Note: The course outline is designed to provide a comprehensive understanding of both 3ds Max and Unity 3D, covering fundamental and advanced topics. The final project aims to apply the acquired skills in a practical context, fostering creativity and collaboration among participants. Unity - Real-time 3D https://www.unity.com/. 3ds Max Trial  https://www.autodesk.co.uk › products › free-trial Upon completion of the 40-hour 3ds Max and Unity 3D Game Design Masterclass, students will: Master 3D Modeling: Acquire proficient skills in creating detailed 3D models, understanding various techniques, and utilizing advanced tools in 3ds Max. Expertise in Animation: Gain expertise in animating characters and objects, employing keyframes, paths, and controllers for realistic motion. Material Creation and Texturing: Understand material creation, application, and advanced texturing techniques for creating visually appealing game assets. Unity Game Development: Learn Unity's interface, project setup, and scripting fundamentals to create interactive games. Physics and Interactivity: Explore physics systems, colliders, and interactive elements, enhancing gameplay experiences. Advanced Scripting: Develop proficiency in C# scripting, enabling the implementation of complex game mechanics and interactions. Optimization Techniques: Understand techniques to optimize game assets, improving performance and ensuring smooth gameplay. Game Design Principles: Grasp essential game design principles, including level design, user experience, and gameplay mechanics. Real-World Application: Apply learned skills in a collaborative final project, integrating 3D models, animations, scripting, and game design principles. Presentation Skills: Develop the ability to present and explain game concepts, designs, and mechanics effectively. Troubleshooting and Debugging: Gain skills in identifying and resolving common issues and errors in both 3ds Max and Unity 3D projects. Team Collaboration: Enhance teamwork and collaboration skills through the final project, working effectively with peers in a creative environment. Upon completing the course, students will have a well-rounded skill set in 3D modeling, animation, game design, and Unity development, making them proficient candidates for roles in game development studios, animation companies, or freelance projects. 3ds Max and Unity 3D Game Designing Training Course: Skills & Careers! Skills Acquired: Advanced 3D Modeling Texturing and Animation Unity 3D Game Development Lighting and Rendering Interactive UI/UX Design Career Opportunities: Game Developer 3D Modeler Texture Artist Game Tester UI/UX Designer Embrace Personalized Learning. Why Us? Discover the Benefits: One-on-One Training: Experience tailored coaching from practicing architects and designers, either face-to-face at (SW96DE) or in live online sessions. Available Monday to Saturday, 9 am to 7 pm. Customized Tutorials: Take home exclusive video tutorials crafted to enhance your learning journey. Comprehensive Resources: Access a digital reference book for thorough revision, ensuring a deep understanding of every concept. Free Ongoing Support: Enjoy continuous post-course assistance via phone or email, ensuring your success even after class completion. Flexible Syllabus: We adapt syllabus and projects to your needs, ensuring focused learning on what matters most to you. Official Certificate: Certificate upon course completion. Why Choose Us? Individualized Support: Our courses, ranging from 10 to 120 hours, offer unwavering assistance at every stage. With personalized homework assignments and free after-course support, we guide you toward mastering software with unparalleled expertise. Personal Attention, No Crowded Classrooms: Experience the intimacy of one-on-one learning. Bid farewell to crowded classrooms, ensuring you receive the undivided attention you deserve in a confident and comfortable environment. Financial Flexibility: Embarking on your educational journey shouldn't strain your finances. Diverse payment plans tailored to your needs. Explore available options and embark on your learning adventure today. Expert Instructors, Real-world Experience: Our instructors, chosen for their industry expertise and passion for teaching, are dedicated to imparting invaluable skills to eager learners.

The Professional Agile Leadership Essentials (PAL-E) is a 2-day hands-on workshop that uses a combination of instruction and hands-on exercises to help managers and other leaders who work directly with agile teams understand how to best support, guide, and coach their teams to improve their agile capabilities. Course Description Professional Agile Leadership Essentials (Scrum.org) Training ONLINE PAL E - Professional Agile Leadership Essentials Agile leadership has a lot to offer businesses today. Organizations have changed a great deal over the years and are no longer the static, structured entities they once were. Agile teams and agile leadership respond to these changes, offering a new way to achieve better results. PAL-E training is designed to help managers, and other leaders, understand how to approach an Agile transformation, and to guide teams to be successful.  Agile teams and leadership bring real benefit Agile organisations and teams thrive in unpredictable and changing environments. They are able to improve efficiency and react quickly to changing markets and customer needs. Achieving this is not something that just happens. The transformation to become an agile organisation is profound, requiring senior leaders, managers, and team members to change how they organise themselves and others, alongside how they work and measure results.  According to consultancy McKinsey: "the key to a successful Agile transformation is for leaders, particularly senior leaders, to develop substantially new mind-sets and capabilities." Scrum Training is a perfect first step in this. Professional Agile Leadership Essentials training The Professional Agile Leadership Essentials (PAL-E) course is a certified 2-day online workshop for team managers and leaders. It will show managers how to effectively develop, support, and guide agile teams to improve their performance. Agile teams are different from traditional structures. There is much more focus on continuous development and learning, as well as self-organisation. The course provides a foundation for managers' and leaders' roles in creating the conditions for a successful Agile transformation. Through detailed instruction and practical exercises, this course will teach leaders and managers how to form, support, and enhance Agile teams. It will guide them through the business, cultural and behavioural changes that must be made to take full advantages of the possibilities of Agile teams. PAL-E Course contents and key objectives The Professional Agile Leadership Essentials course will provide a solid grounding in the background and importance of agile leadership and how to apply it in leading teams.  The main content and learning includes: An understanding of what Agile is, the benefits and impact it can have on business, and the role a manager plays in achieving this. Challenges and techniques of Agile management, and the role management plays in an Agile organisation. How to develop and support Agile teams. How to measure and guide Agile product delivery, and an understanding of core problems in product development. An understanding of how to measure the benefits and impacts of agility in your organisation. Expected Outcomes from a PAL-E workshop PAL-E training highlights how Agile teams perform and the role of leaders and managers in establishing and developing their teams. Agile can help an organisation thrive through a framework that provides a flexible approach to challenges and problem solving. Thje Professional Agile Leadership Essentials course enables you to lead your teams and implement core Agile frameworks that deliver real business benefits. Who Should Attend This Course? Professional Agile Leadership essentials course is designed for leaders and managers in Agile organisations. It is suited to anyone responsible for setting up or establishing Agile techniques and for those managing teams and improving ongoing methods and techniques. After completing the course, participants can obtain industry-recognised certification. This will require passing a rigorous online assessment following the training. There are then plenty more courses that can take you further into Agile techniques. Scrum Master Training, for example, will guide participants through the industry-leading scrum framework for Agile practices. 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