18271 Courses in Nottingham delivered Online

Historical Association webinar series: Making GCSE history accessible: supporting all learners at Key Stage 4 Presenters: Gemma Hargraves  This session explores some of the hidden barriers faced by neurodivergent pupils in the history classroom, including anxiety and low self-confidence. It offers practical strategies to create an inclusive and supportive environment that enables all learners to engage meaningfully with historical learning. Key topics: • Recognising common anxiety triggers in history education • Building learner confidence through inclusive pedagogical approaches • Understanding and responding to the needs of neurodivergent pupils in GCSE history To use your corporate recording offer on this webinar please fill in this form: https://forms.office.com/e/bdNUSwLNrL Image: A Squire "Old English" padlock on a gate latch in Devon (Image: Partonez/Wikimedia Commons)

Historical Association webinar series: Practical approaches to disciplinary concepts in primary history Presenter: Emmy Quinn This session will give teachers tips on how to explore similarity and difference in a meaningful way in the primary classroom. It will look at introducing the concept in Key Stage 1 to more developed use of it in Key Stage 2, for example similarity and difference in the earliest civilisations. The session will show how to demonstrate that similarity and difference can be nuanced and will support with getting children to move beyond basic ideas To use your corporate webinar offer for this webinar please complete this form: https://forms.office.com/e/95945xGxdh

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

Duration 2 Days 12 CPD hours This course is intended for Team leaders, managers, executives and other business professionals, as well as those who would benefit by being able to assert themselves more effectively in a professional environment will benefit from this course. Overview Develop the necessary skills to communicate with confidence Apply communication styles that maximize benefits Augment your listening and hearing skills to increase engagement Utilize that art of asking questions to elicit more from others Leverage your body language for full communication Make the best first impressions by looking, sounding and being confident In this course, students will discover the best techniques to be properly assertive, and what are the ideal approaches in differing situations. Private classes on this topic are available. We can address your organization?s issues, time constraints, and save you money, too. Contact us to find out how. 1. What is Assertiveness? Differentiating Self-confidence from Assertiveness Understanding the Four Styles of Communication What Separates Assertiveness from Passiveness, Aggressiveness, and Passive-Aggressiveness 2. Dimensions of Communication Differentiating Listening from Hearing Developing Emphatic Listening Skills Utilizing Question Types - Open, Clarifying, and Closed Converting Negative Thinking into Positive Thinking 3. Body Language Says It All Managing Your Appearance Understanding Non-verbal Communication Making the Right First Impression Speaking with Confidence Relaxing and Reducing Anxiety 4. Dealing with Difficult Situations Dealing with Difficult People Building Rapport and Trust Appreciating the Different Ways that People Send and Receive Information Breaking Down Barriers and Building Consensus Applying PEGASUS Utilizing a Tactical Approach Choosing the Proper Form of Communication

Overview This comprehensive course on MS Access Databases Forms and Reports Level 3 will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This MS Access Databases Forms and Reports Level 3 comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this MS Access Databases Forms and Reports Level 3. It is available to all students, of all academic backgrounds. Requirements Our MS Access Databases Forms and Reports Level 3 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 2 sections • 16 lectures • 02:49:00 total length •Creating a form with Autoform: 00:14:00 •Using the Form Wizard: 00:09:00 •Changing a form with design view: 00:26:00 •Adding form controls: 00:21:00 •Subforms: 00:15:00 •Creating reports with Autoreport: 00:03:00 •Using the Report Wizard to create a report: 00:07:00 •Changing a report in design view: 00:11:00 •Adding calculations: 00:09:00 •Grouping, sorting and adding totals to reports: 00:16:00 •Using the Label Wizard: 00:04:00 •Form and table properties: 00:06:00 •Exporting a report to Excel: 00:03:00 •Using the Switchboard Manager to create a nice menu: 00:17:00 •Finalizing the application: 00:08:00 •Assignment - MS Access Databases Forms and Reports Level 3: 00:00:00

The COLP role goes beyond just ensuring your firm follows the rules in the SRA Standards and Regulations, it also comes with a personal accountability factor that demands your attention. Fear not! This 3 hour course will usher you through the intricacies of being a COLP, ensuring you not only meet but excel in your regulatory obligations.  The course will cover: Navigating the Regulatory Landscape: Understanding the Framework for COLPs Dive into the intricate regulatory framework that Compliance Officers for Legal Practice (COLPs) operate under. Shouldering the Responsibility: Unpacking the Duties of a COLP Explore the multifaceted responsibilities that come with the role of a COLP. Choosing the Right Leader: Identifying the Ideal COLP Candidate Learn the criteria for selecting the most suitable individual to take on the crucial role of COLP. Cracking the Codes: Key Elements of Codes and SRA Principles Delve into the essential components of the Codes and SRA Principles that form the backbone of legal compliance. Building a Robust Foundation: Understanding Compliance Systems for All Firms Explore the concept of compliance systems, what they entail, and why every firm should have one in place. Reporting Matters: Recognising 'Serious' Issues, SRA Enforcement Strategy, and Reporting Protocols Uncover the definition of 'serious' matters, grasp the SRA Enforcement Strategy, and gain practical insights on making effective reports to the SRA. Paper Trails Matter: Effective Record Keeping, Including Non-material Breaches Master the art of comprehensive record-keeping, including strategies for recording non-material breaches, and understand why it's integral to compliance. Personal Liability: Understanding and Mitigating Risks Navigate the landscape of personal liability for COLPs and develop strategies to mitigate associated risks. Staying Ahead: Keeping Abreast of Regulatory Changes and Guidance Develop effective strategies for staying up to date with dynamic regulatory changes and evolving guidance. Planning for Compliance: Crafting a Robust Strategy, Assessing Risk, and File Reviewing Formulate a comprehensive plan for tackling compliance, including risk assessment, maintaining risk registers, and implementing effective file reviewing. Across the Board: Legal and Regulatory Compliance Areas Every COLP Must Master Gain a high-level overview of crucial legal and regulatory compliance areas, including AML, transparency rules, and other pivotal aspects that demand the attention of all COLPs. Target Audience This online course is suitable for those new to the COLP role, or those supporting the COLP and for those that would like a refresher of the role and their responsibilities. Resources Comprehensive and up to date course notes will be provided to all delegates which may be useful for ongoing reference or cascade training. Please note a recording of the course will not be made available. Speaker Helen Torresi, Consultant, DG Legal Helen is a qualified solicitor with a diverse professional background spanning leadership roles in both the legal and tech/corporate sectors. Throughout her career, she has held key positions such as COLP, HOLP, MLCO, MLRO and DPO for law firms and various regulated businesses and services. Helen’s specialised areas encompass AML, complaint and firm negligence handling, DPA compliance, file review and auditing, law management, and operational effectiveness in law firms, particularly in conveyancing (CQS).

Are you interested in pursuing a rewarding career as a web developer? Alternatively, perhaps you'd want to brush up on your skills and take things to a whole new level? Then this course is for you. A carefully structured course for both beginners and intermediate-level learners.

In this course, we will learn about the Google Apps Script to create custom functions within G Suite that will help you increase your productivity. This course contains 100+ coding examples. For this course, you need JavaScript and basic HTML and CSS knowledge, a Google account, and a basic web development understanding.

Description Tai Chi Diploma  Tai Chi, also called Tai Chi Chuan, is a Chinese martial art form and physical exercise distinguished by its slow but graceful movements. This non-combative and flexible exercise form lays great emphasis on improving health. This diploma course attempts to enlighten students with introductory or zero-knowledge regarding this exercise. This Tai Chi Diploma course will help those already familiar with the practice but want to learn more about its advantages and forms. At the outset, this Tai Chi Diploma course briefly introduces students to what the course entails, elucidating how the course will pan out and how students will benefit from each unit. Then comes an explanation of how to get the most out of this well-constructed diploma course. The Tai Chi Diploma course begins with a run-through of Tai Chi and eases into a detailed account of the motives, origin story, plus the four primary forms of the practice. Each topic is designed comprehensively, allowing students to deepen their perception of Tai Chi. The Tai Chi Diploma course explains the many health benefits from both a physical and mental point of view. Taoism, the philosophy that heavily influences Tai Chi, is explored in detail, emphasising its fundamentals. This will further strengthen the students' perception of this unique martial art. Qigong, a sister practice to Tai Chi, may not sound familiar to pupils who have recently started dabbling in this exercise form. This much older practice, Qigong, will be discussed, followed by an enumeration and explanation of the ten fundamentals that the various forms of Tai Chi stand by. This diploma course paints a picture of the primary stances, gestures, and postures employed in Tai Chi. It explains how these exercises should be timed, the ideal locations for practising, and how one should be dressed. The course also illustrates how one should warm up before easing into the exercises of Tai Chi. This follows an in-depth explanation coupled with adequately explained figures of the 21 posture Beijing Short Form of this one-of-a-kind martial art. Students will receive additional helpful information and resources to benefit those keen on taking up this practice as a profession. A list of essential links to visual media and websites will also come with this diploma course for Tai Chi. What you will learn   1: Tai Chi and its benefits  2: Qigong Basics and the philosophy of Tai Chi  3: Preparation for Tai Chi  4: Warming Up  5: Qigong Exercises  6: Tai Chi Exercises  7: Adaptations of Qigong and Tai Chi in the seated posture  8: Meditative Exercises  9: Tai Chi and Rehabilitation  10: Traditional Chinese Medicine  Course Outcomes After completing the course, you will receive a diploma certificate and an academic transcript from Elearn college. Assessment Each unit concludes with a multiple-choice examination. This exercise will help you recall the major aspects covered in the unit and help you ensure that you have not missed anything important in the unit. The results are readily available, which will help you see your mistakes and look at the topic once again. If the result is satisfactory, it is a green light for you to proceed to the next chapter. Accreditation Elearn College is a registered Ed-tech company under the UK Register of Learning( Ref No:10062668). After completing a course, you will be able to download the certificate and the transcript of the course from the website. For the learners who require a hard copy of the certificate and transcript, we will post it for them for an additional charge.

Historical Association webinar series: Practical approaches to disciplinary concepts in primary history Presenter: Emmy Quinn This session will show teachers how to introduce the concept of significance to children using both individuals and events. It will give ideas of units around individuals and events and how to move beyond significance being “important”, for example significant at the time and significant today. The session will explore how significance can be used in a local study rather than focusing on a well-known event or individual. To use your corporate webinar offer for this webinar please complete this form: https://forms.office.com/e/95945xGxdh