984 Courses delivered Online

Whether you’re starting out in private practice, or have been in business for a while, this inspiring course will SAVE you time and money and help you build the practice and lifestyle you want … Accredited CPD Certificate: 6 hours Length: 1 day (9.30am - 4.00pm GMT) Extremely helpful course. The real life, practical examples and advice were invaluable...EMMA WARDROPPER Live Online Training – Join Jennifer Broadley for this inspiring, practical training – you will have plenty of opportunity to ask questions. Simply book your place and we will email you details of how to join the Zoom training the day before the event. BONUS RECORDING – the training is recorded in case anyone experiences technical difficulties on the day, so you also get a recording for a limited time afterwards to maximise your learning. Why take this course Although word of mouth is one of the best ways to get business, being a good counsellor or therapist isn’t always enough to fill your practice with clients – and that’s where the easy-to-learn, simple but effective business and marketing skills you will learn on this online course come in. Jennifer Broadley has been a qualified and practising psychotherapist for 10 years and has been in business for herself for well over 20 years. She brings her extensive knowledge of the personal and professional ups and downs to life in this practical and motivating day. You will also gain a wealth of time-saving devices and tips that others who have successfully built their thriving practices have used, all of which will allow you to focus more time on your clients. Jennifer built her business, Healthy Chat, from no clients to full practice within 2 years. She has tried-and-tested marketing strategies and will share with you the ones that have worked for her and the ones that haven’t. She is fully transparent with her client numbers, systems and finances so that you will leave the course clear about whether a full-time or part-time therapy practice is for you – and how to go about getting the work/life balance you want. I’ve learned so much! A must for everyone setting up a therapy businessHEALTH VISITOR What will you learn The essential actions to take when starting your practice from scratch – what’s worth spending money on and what’s not Confidence to take on your first client(s) or increase your client intake until you have a full practice Clear systems for starting or growing your counselling / therapy practice Tools to ensure clients easily find you, trust that you can help, and then book sessions with you Clarity about how long to work with a client – average timings and outliers (for stress, trauma, panic attacks, relationships, etc); when to keep a client and when to let a client go Key information that will help you decide how much to charge and when/whether to be flexible Important things to remember if you work with clients online Time-saving methods for client management: intake, treatment, ending well and future follow up How to manage yourself as a business owner – when to work hard, when to take time out How to make your therapy practice fit in with the lifestyle you want to live – and what to do to avoid becoming overwhelmed When (or whether) to let go of your full or part-time work and shift to letting your counselling practice support you financially How to get your 9 emotional needs met while working for yourself How to define your ideal client(s) and where to find them Practicalities: taking payments, tracking your numbers, meeting your targets, turnover v’s net income, paying VAT (or not), paying tax, chasing non-payments Creating a healthy, open attitude and language around money and finances How to set up your therapy practice to be financially successful and more… Brilliant, this online course has shown me what I need to focus on to build a successful private practice – and where to put my energy, money and time!COUNSELLOR Course Programme The ‘Obsessive Compulsive Disorder – understanding OCD and how best to treat it’ online course starts at 9.15am and runs until 4.00pm. (GMT). 9.15am Join the Zoom meeting 9.30am A context for the demand for HG therapy and counselling 11.00am Comfort break and discussion 11.30am Private Practice Design 1.00pm Lunch break 1.45pm Marketing your practice 2.45pm Comfort break and discussion 3.00pm Effective Therapy Sessions & Client Follow up 4.00pm Day ends Who is this course suitable for? Anyone who wants to set up a private therapy or counselling practice If you’re already in private practice and want to increase your client numbers, work less and earn more, you’ll also benefit from attending Anyone who is presently in full or part time salaried work and is considering moving to self employment or entrepreneurialism This course has been independently accredited by the internationally recognised CPD Standards Office for 6 hours of CPD training. On completion of this training you’ll receive CPD certificates from the College and the CPD Standards Office.

Join Dr Andrew Morrice for a deep dive into what the latest mind-body research tells us about the impact of sleep, the microbiome, nutrition, culinary practices and more on our mental and physical health, and recovery … Accredited CPD: 6 hours Length: 1 day (9.15am - 4.00pm GMT) Excellent content and practical applications for treating OCDPETA DUNN, GP Live training delivered online – Join Miriam Chachamu on Tuesday 13th February 2024 for this live online OCD course workshop via Zoom. The content covered is the same as our original attended workshop, with some modifications to the exercises – you will have plenty of opportunities to ask Miriam questions. We will send details of how to join the Zoom workshop by email the day before the event. BONUS RECORDING – the training is recorded, in case anyone experiences technical difficulties on the day, so you will also get a recording for a limited time afterwards to maximise your learning. Why take this course Obsessive compulsive disorder (OCD) is not only distressing for sufferers but for their family members and friends too. Contrary to the popular view of OCD being harmless over-cleanliness or simply checking things over and over again, people living with OCD experience a high level of anxiety – and the condition can damage their relationships, social and work lives, and physical health. Many sufferers are ashamed of their problem and hide it. Sometimes therapists fail to recognise the rarer forms of OCD and therefore fail to offer effective treatment. And many people with milder forms of OCD do not realise that they can be helped, and do not seek help until their condition becomes much more severe. This accredited live online course offers an in-depth look at OCD in all its guises and focuses on practical and effective methods of treatment – OCD recovery is possible in most cases. The day is interactive and includes demonstration videos of therapy sessions, short video clips, in-depth discussions and case studies. The films of the therapy sessions and the video of dealing with intrusive thoughts were particularly usefulSCHOOL NURSE What will you learn New information that will enable you to help OCD sufferers more effectively A better understanding of OCD, what it is and how it develops The ability to recognise the less familiar types of OCD – these are often missed by both client and therapist An effective 4-step method for treating OCD New ways to help people overcome their compulsive tendencies Illuminating video clips of OCD sufferers describing their experience Helpful ways parents and educators can prevent signs of OCD in children and teenagers from developing further The important role of guided imagery in treatment and why it improves success rates How to separate the person from their OCD ‘Pure O’ – we look at ‘purely obsessional’ OCD, where people experience distressing intrusive thoughts without any external signs of compulsions The chance to observe effective therapy for OCD and discuss case studies How obsessive compulsive disorder fits with other psychological conditions – and with autism What to do when OCD symptoms are firmly entrenched The opportunity to discuss some of your own cases with a highly knowledgeable tutor How to handle challenging cases successfully and more… Course Programme The ‘Obsessive Compulsive Disorder – understanding OCD and how best to treat it’ online course starts at 9.15am and runs until 4.00pm. (GMT). 9.15am Join the Zoom meeting 9.30am Understanding OCD 11.00am Comfort break and discussion 11.30am How to treat OCD successfully and quickly 1.00pm Lunch break 1.45pm OCD treatment – what to do when symptoms persist 2.45pm Comfort break and discussion 3.00pm Dealing with unusual or challenging cases 4.00pm Day ends Who is this online course suitable for? Anyone who works with, lives with, teaches or treats people suffering from OCD, or who thinks they may have OCD but isn’t sure Psychotherapists, counsellors, health and social care professionals, mental health and wellbeing professionals, educators, school counsellors, individuals working in a variety of capacities in any number of organisations who are looking for OCD training for professionals Anyone who has family members or friends who suffer from OCD would also benefit from this live online course – it contains essential, practical information about how to help OCD sufferers The day is also valuable for anyone struggling to deal with their own obsessive thoughts or actions Please Note: This course is not a substitute for individual therapy This course looks at a range of OCD behaviours, including: Compulsive checkingContamination / Mental ContaminationSymmetry and orderingRuminations / Intrusive thoughts (Pure O)HOCD – Homosexual OCDPOCD – Paedophile OCD / Prenatal and postpartum OCDand more This course has been independently accredited by the internationally recognised CPD Standards Office for 6 hours of CPD training. On completion of this training you’ll receive CPD certificates from the College and the CPD Standards Office.

Duration 5 Days 30 CPD hours This course is intended for The primary audience for this course is as follows: Cisco Unified Communications system channel partners and resellers who are responsible for deployment and application engineering for Cisco Unified Contact Center Express customers. System and technical support engineers. Day 1 and Day 2 support personnel. Customers deploying and maintaining Cisco Unified CCX Overview Upon completing this course, the learner will be able to meet these overall objectives: Review Cisco Unified CCX environment components Create prompt recording tools Create a helpdesk script Apply common sense principles for scripting and system management, such as: Prompt, document, and grammar management Using the default script Scripting for proper call termination and ending a script Abandon rates Exception handling Check Agent Availability before and after entering queue Using Java Methods for Holiday and Time of Day routing Setup access and use an external database Define and use skills Script for conditional routing Script for basic callback scenarios Setup and use enterprise data and session management Script for queuing and scheduled callback scenarios Building on the knowledge base and scripting experience learned in the UCCXD class, the student will explore advanced techniques in scripting and overall Cisco Unified CCX functionality. During this five day class the students will use advanced scripting to implement features that extend the functionality of Cisco Unified CCX using many of the tools that are already available in the premium version of the product. Students should expect to spend time using the script editor and other tools to create developer tools and enhanced scripts to provide for a more functional and user-friendly customer experience. Activities include creating prompt recording tools, applying common sense scripting principles, creating simple and complex ACD routing scripts, holiday routing, external database access, various callback scenarios such as non-queuing, queuing, and scheduled callbacks, defining and using enterprise data, passing data from one script to another using session management, and much more. Additionally, since this class focuses on complex scripting concepts, it requires the student to learn more about fundamental scripting requirements such as data manipulation and formatting, using variables and array variables, and using Java programming methods. Course Introduction Learner Prerequisite Skills and Knowledge Course Goal Course Objectives Course Flow General Administration Lab Diagram Please Introduce Yourself Lesson 1: Cisco Unified CCX Overview Components of the Cisco Unified CCX Environment Gateways Routers Cisco Unified Communications Manager Cisco Unified CCX Script Editor Cisco Finesse Cisco Unified Intelligence Center Cisco Unified CCX Agent External Servers Cisco Unified CCX System Cluster Components Engine Database Server Call Flow Terms The Call Flow The Debug Process Reactive Non-Reactive Lesson 2: Prompt Recording Utilities Prompt Recorder Emergency Message Recorder Lesson 3: Basic ACD Routing Review Script Steps used in a Simple ACD Routing Script Resource Group Routing Defining the Contact Service Queue Create a Simple ACD routing script Lesson 4: Common Scripting Concepts Prompt Management Using the Default Script Terminating a Call and Ending a Script Abandon Rates Exception Handling Script Interruptions Check Agent Availability before and after entering queue Using Java Methods for Holiday and Time of Day routing Lesson 5: Accessing an External Database Database architecture and supported databases Setting up the Database Subsystem Using Database script steps Lesson 6: Skills Based Routing Appling skills to agents Defining the Contact Service Queue Specifying the CSQ in the Script Lesson 7: Advanced ACD Routing Overflow Routing When to Overflow How to get the Data Needed for Making Decisions Describe Methods of Overflowing Lesson 8: Basic ACD Callback Options Setup the Email Subsystem Script for Email Notification Script for Leaving a Recorded Message Script for Callback when Queue Times have Decreased Lesson 9: Enterprise Data and Session Management Define Enterprise Data in Cisco Finesse Define a Call Variable Layout in Cisco Finesse Define ECC Variables in the script editor Set Enterprise Data in the script Define Session Management Setup Session Management Use Session Management to Pass Variable Information Between Scripts Lesson 10: Advanced ACD Callback Options Leave Queued Message with an Option for Callback Scheduled Callback

Coaching, Workplace coaching, Floor walking coaching, Organisational coaching,

Health and Safety for Managers and Supervisors course offers a transformative journey through the realm of workplace safety. This meticulously crafted course not only equips participants with essential knowledge but also instills a sense of responsibility towards creating a secure work environment. The curriculum commences with a detailed study of regulations and risk assessments, essential for understanding the legal frameworks governing workplace safety. As learners progress, they encounter modules focused on planning for emergencies, a crucial skill in ensuring staff preparedness and resilience. The course provides a robust foundation in communication and record-keeping concerning health and safety matters, an often-understated aspect of workplace management. In the latter half, the course transitions to more advanced topics. Participants will engage with techniques for inspecting and auditing health and safety systems, a skill vital for maintaining and improving existing protocols. A significant focus is placed on enhancing safety standards through employee training, a key strategy for proactive safety management. The final module broadens the learner's perspective by addressing the adaptation of health and safety strategies to diverse work environments, preparing them for the varied challenges they may face in different organisational contexts. This course is more than an educational experience; it is an essential step towards becoming a leader in workplace safety. Learning Outcomes Understand and apply workplace safety regulations and risk assessment procedures. Plan and execute emergency response strategies in workplace settings. Communicate effectively about health and safety issues and maintain accurate records. Conduct thorough inspections and audits of health and safety systems. Enhance safety training for employees and tailor safety strategies to diverse environments. Why choose this Health and Safety for Managers and Supervisors course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Health and Safety for Managers and Supervisors course for? Individuals aiming to assume managerial or supervisory roles with a focus on safety. Existing managers and team leaders eager to bolster their safety management capabilities. HR professionals interested in integrating comprehensive safety practices into organisational policies. Business owners committed to ensuring a safe working environment for their employees. Health and safety officers seeking to broaden their managerial perspective in safety protocol implementation. Career path Safety Manager: £35,000 - £50,000 Health and Safety Advisor: £25,000 - £35,000 Risk Management Specialist: £30,000 - £45,000 Quality Assurance Officer: £28,000 - £40,000 Employee Safety Trainer: £32,000 - £48,000 Workplace Safety Analyst: £26,000 - £39,000 Prerequisites This Health and Safety for Managers and Supervisors does not require you to have any prior qualifications or experience. You can just enrol and start learning. This course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Course Promo Health and Safety Promo 00:01:00 Module 01: Regulations and Risk Assessments in the Workplace Regulations and Risk Assessments in the Workplace 00:17:00 Module 02: Planning for Emergencies in Work Environments Planning for Emergencies in Work Environments 00:19:00 Module 03: Communicating and Recording Health and Safety Issues Communicating and Recording Health and Safety Issues 00:17:00 Module 04: Inspecting and Auditing Health and Safety Systems Inspecting and Auditing Health and Safety Systems 00:17:00 Module 05: Improving Safety Standards and Employee Training at Work Improving Safety Standards and Employee Training at Work 00:16:00 Module 06: Adapting Health and Safety Strategies in Various Environments Adapting Health and Safety Strategies in Various Environments 00:16:00

About Course Sage 50 Accounts: Master the Popular Accounting Software Learn how to use Sage 50 Accounts, one of the most popular accounting software solutions available, with this comprehensive online course. This course is designed for everyone, from beginners to experienced professionals. You will learn everything you need to know to use Sage 50 Accounts effectively, from setting up a new company to creating year-end reports. The course is taught by industry experts and covers a wide range of topics, including: Setting up and managing a company Recording transactions Payroll processing Creating reports Tax compliance You will learn through a combination of video lessons, interactive exercises, and self-paced assessments. By the end of the course, you will be able to: Use Sage 50 Accounts to manage all aspects of your accounting Create accurate and timely financial reports Comply with all relevant tax regulations Why study this course? Sage 50 Accounts is a powerful accounting software solution used by millions of businesses worldwide. Learning how to use Sage 50 Accounts can help you to save time and improve the efficiency of your accounting processes. Sage 50 Accounts is a highly sought-after skill by employers. This course is perfect for: Small business owners Bookkeepers and accountants Anyone who wants to learn a new accounting skill Enroll today and start your journey to becoming a Sage 50 Accounts expert! Course features: Taught by industry expert Comprehensive coverage of all aspects of Sage 50 Accounts Interactive exercises and self-paced assessments Requirements: For practice purposes, you should have Sage 50 Software installed on your PC. The software is not included with this course. What Will You Learn? Use Sage 50 Accounts to manage all aspects of your accounting Create accurate and timely financial reports Comply with all relevant tax regulations Course Content Getting Started Getting Started Setting up of the System Virtual Tour of Sage 50cloud Accounts Edit and Modify Default Chart of Accounts Add a Business Bank Account, Credit Card Account and Petty Cash Account Creating and Deleting Departments Customers and Suppliers Setting up Customers and Suppliers Create a Project List Entering Purchase (Supplier Invoice), Purchase Credit Note, Purchase Order.. Entering Sales Fixed Assets Fixed Asset Register Bank Payments and Receipts Bank Payments and Transfer Recording Customer Receipts and Supplier Payments Adding Recurring Items Petty Cash Petty Cash Account Bank Reconciliation with Bank Feed Bank Reconciliation - Current Account Bank Reconciliation - Petty Cash and Credit Card Aged Reports Aged Reports Payroll Journals Payroll Posting and Payroll Journal Vat Return (Making Tax Digital) Vat Return Opening balances on Sage 50 Cloud Accounts Opening Balances on Sage 50 Year End Journals Year End Journals Cash Flow, Budgets and Accountant's Report Cash Flow, Budgets and Accountant's Reports Apps and Add-ons Apps and Add-ons Correction of Error, Backup and Restore Correction of Error, Back Up and Restore Course Book Coursebook for Sage 50 Cloud Accounts (V.29) - 2023 A course by Ujjwala D'Souza MAAT, Sage/Xero/Quickbooks Trainer/Advisor RequirementsFor practice purposes, you should have Sage 50 Software installed on your PC. The software is not included with this course. Audience Small business owners Bookkeepers and accountants Anyone who wants to learn a new accounting skill Audience Small business owners Bookkeepers and accountants Anyone who wants to learn a new accounting skill

Our Safeguarding Vulnerable Adults course is written for people who work in the adult care industry for them to gain an understanding of the requirements of Safeguarding Vulnerable Adults legislation such as the Safeguarding Vulnerable Adults Groups Act 2006 and how to implement this into the workplace.

Unlock the Doors to a Successful Career with Understanding the Association of Accounting Technicians Text Course! Are you looking to embark on a rewarding journey in the world of finance and accounting? Do you aspire to become a proficient accounting technician, equipped with the knowledge and skills to excel in various financial settings? Look no further! Our comprehensive text course, 'Understanding the Association of Accounting Technicians,' is your key to unlocking a world of opportunities in the dynamic field of accounting.   🎓 Why Choose Our Course? Our text course is meticulously designed to provide you with a solid foundation in the principles, practices, and regulations governing accounting and finance. Whether you're a beginner seeking to kickstart your career or a seasoned professional aiming to enhance your skills, our course offers something for everyone. Here are just a few reasons why our course stands out: Comprehensive Curriculum: Our course covers essential topics such as financial accounting, management accounting, taxation, and ethics, ensuring you gain a well-rounded understanding of accounting principles. Flexible Learning: Access the course material anytime, anywhere, at your own pace. Whether you're a full-time student, a working professional, or a busy parent, our flexible learning format allows you to study at your convenience. Expert Guidance: Learn from industry experts and experienced professionals who bring real-world insights and practical knowledge to the table. Benefit from their guidance and expertise as you navigate through the course material. Practical Assignments: Put your knowledge to the test with hands-on assignments and case studies designed to reinforce learning and enhance practical skills. Gain confidence in your abilities as you tackle real-world accounting scenarios. Recognized Certification: Upon successful completion of the course, receive a certification that validates your expertise and enhances your credibility in the eyes of employers and clients.   🔍 Who is this for? Our course is ideal for: Aspiring accounting professionals seeking to kickstart their careers. Finance students looking to supplement their academic studies with practical knowledge. Working professionals aiming to enhance their accounting skills and advance their careers. Small business owners and entrepreneurs who want to gain a better understanding of financial management. No matter your background or experience level, our course is designed to accommodate learners of all profiles and help you achieve your career goals in the field of accounting.   🚀 Career Path Upon completing our course, you'll be well-equipped to pursue a variety of exciting career opportunities in the accounting and finance sector. Some potential career paths include: Accounting Technician: As an accounting technician, you'll play a vital role in supporting the financial operations of organizations, handling tasks such as bookkeeping, payroll processing, and financial reporting. Tax Assistant: Specialize in taxation and assist individuals and businesses with tax planning, preparation, and compliance. Financial Analyst: Analyze financial data, trends, and performance metrics to provide insights and recommendations for strategic decision-making. Auditing Clerk: Conduct internal audits to ensure compliance with regulatory requirements and identify areas for improvement in financial processes and controls. Small Business Advisor: Provide financial advice and support to small businesses and startups, helping them navigate financial challenges and achieve their growth objectives. With the demand for skilled accounting professionals on the rise, the possibilities are endless for those who possess the knowledge and expertise gained from our course.   📚 FAQs Q: Is this course suitable for beginners with no prior accounting knowledge? A: Absolutely! Our course is designed to cater to learners of all levels, including beginners. We start with the fundamentals and gradually build upon them to ensure a comprehensive understanding of accounting principles. Q: How long does it take to complete the course? A: The duration of the course varies depending on your pace of learning and availability. On average, most learners complete the course within a few weeks to a few months. Q: Will I receive a certificate upon completion of the course? A: Yes, upon successful completion of the course and any associated assessments, you will receive a certificate of completion that can be showcased to employers and clients. Q: Can I access the course material on mobile devices? A: Yes, our platform is mobile-friendly, allowing you to access the course material on your smartphone or tablet for convenient learning on the go. Q: Is there any support available if I have questions or need assistance during the course? A: Absolutely! Our dedicated support team is here to assist you every step of the way. Whether you have questions about course content or technical issues, we're here to help.   Don't miss out on this opportunity to take your accounting career to new heights! Enroll in our Understanding the Association of Accounting Technicians text course today and embark on a journey toward professional success and fulfillment. Unlock your potential and achieve your goals with us! Course Curriculum Module 1_ Introduction to Financial Accounting Introduction to Financial Accounting 00:00 Module 2_ Recording Financial Transactions Recording Financial Transactions 00:00 Module 3_ Accounting Standards and Principles Accounting Standards and Principles 00:00 Module 4_ Financial Analysis and Interpretation Financial Analysis and Interpretation 00:00 Module 5_ Budgeting and Financial Planning Budgeting and Financial Planning 00:00 Module 6_ Internal Controls and Risk Management. Internal Controls and Risk Management. 00:00

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

Are you doing sanction checks in your law firm? In the intricate landscape of legal practice, understanding and adhering to the UK's sanctions regime is not just a recommendation; it is mandatory and it is imperative. This course aims to set clear expectations and offer practical support to firms, guiding them away from the pitfalls of breaching the UK's sanctions regime. Who is this for? This 90 minute course is for all legal firms, irrespective of the services you provide. Whether you are navigating the sanctions regime independently or operating under a license from the Office of Financial Sanctions Implementation (OFSI), this course is for you. The course will cover: What are sanctions What do you need to know about the sanctions for your firm How is it different to the AML regime? What controls to put in place? If the firm offers services to sanction areas – what controls? My client has been sanctioned – what do I do? Reporting obligations Using screening tools Licensing How does this impact Legal Professional Privilege? Sanction Risk Assessment Red flags factors Enforcement actions 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).