1912 Concept courses delivered Live Online

Revit face to face training customised and bespoke. Online or Face to Face

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

Face to face training customised and bespoke. Online or Face to Face

Public Healthcare Course Overview This course provides a comprehensive introduction to public healthcare, offering learners a deeper understanding of the policies, concepts, and challenges involved in providing healthcare services to the public. It explores key aspects of public health, including health promotion, the role of religion, and the foundational quality features of health coverage. By the end of the course, learners will be equipped with a strong theoretical foundation in public healthcare and its practical application. With a focus on global healthcare systems, this course prepares learners for roles in healthcare management, policy development, and public health advocacy. Course Description In this course, learners will delve into the core concepts of public healthcare, covering a broad spectrum of topics such as health policies, the definition of health, and the intersection of religion and healthcare. The course offers a detailed exploration of health promotion, public health concepts, and the quality features essential to effective healthcare coverage. Learners will gain insights into the barriers that hinder healthcare delivery and the strategies to overcome them. This learning experience will help learners develop a thorough understanding of the systems, challenges, and opportunities within public healthcare, equipping them with the knowledge to engage effectively in healthcare discussions, policy making, and strategic planning. Public Healthcare Curriculum Module 01: Definitions and Healthcare Policies Module 02: Concepts of Health Module 03: Religion and Health Module 04: Understanding the Role of Health Promotion Module 05: Concept of Public Health Module 06: Fundamental Quality Features of Health Coverage Module 07: Practical Barriers to Provision of Healthcare (See full curriculum) Who is this course for? Individuals seeking to understand public healthcare systems. Professionals aiming to enhance their career in healthcare policy, management, or advocacy. Beginners with an interest in healthcare and public health. Anyone seeking to contribute to the improvement of health services. Career Path Healthcare policy analyst Public health advisor Healthcare management professional Health promotion officer Public health researcher Policy maker in healthcare organisations

  The GDPR Foundation training enables delegates to understand how to define and implement a privacy compliance framework aligned to best practice. During this training course, you will be able to understand the fundamental privacy principles and become familiar with the role of the Data Protection team and the DPO. About This Course   At Foundational level, candidates prove they have understood the fundamental methodologies, requirements, best practice and management approach of a Privacy Compliance Framework. Learning principles;   Understand the General Data Protection Regulation requirements and the fundamental principles of privacy Understand the obligations, roles and responsibilities of the Data Protection Officer Understand the concepts, approaches, methods and techniques to effectively participate in the implementation process of a compliance framework with regard to the protection of personal data.   Educational approach; Lecture sessions are illustrated with practical questions and examples Practical exercises include examples and discussions Practice tests are similar to the Certification Exam   Course Agenda Day 1: Introduction to GDPR and Data Protection Principles Day 2: The General Data Protection Regulation requirements and Certification Exam Prerequisites   There are no prerequisites for this course. What's Included?   Refreshments & Lunch (Classroom courses only Course Slide Deck CPD Certificate   Who Should Attend?   Individuals involved in the processing of Personal Data and Information Security Individuals seeking to gain knowledge about the main privacy principles Individuals interested to pursue a career in Data Protection Provided by   This course is Accredited by NACS and Administered by the IECB Assessment   Delegates sit a combined exam, consisting of in-course quizzes and exercises, as well as a final 40 question, multiple choice exam on Day 2 of the course. The overall passing score is 70%, to be achieved within the 60 minute time allowance. Exam results are provided within 24 hours, with both a Certificate and a digital badge provided as proof of success.

This one-day course introduces the field of user experience and provides an excellent entry point to our other specialised training courses. UX processes and practices have become a central component of product design, service design and web design.

Learn the Art and Science of EFT (Emotional Freedom Techniques or “The Tapping Technique”) in this EFT workshop and join millions worldwide who are learning this life-changing technique. EFT, commonly referred to as Tapping, has gained rapid popularity because it has been demonstrated to quickly and effectively resolve dysfunctional feelings, thoughts, behaviors and beliefs which can lead to challenges in relationships, health, work and more. Basically, if there are negative emotions and stress involved, EFT may well be able to resolve those aspects that can lead to significant relief and ease in one’s life. Learn to implement this powerful mind-body approach which is supported by peer-reviewed research, drawing from the fields of interpersonal neurobiology, neuroplasticity models and the field of epigenetics. If you are ready to transform your health, your relationships and your vision of who you truly are, then come join us to learn EFT Tapping techniques. If your life is grounded in being of service to others, then EFT will quickly become your tool of choice. Whether you are curious about EFT for self-help or you are in the healing/helping professions, this training will give you confidence in the art of its delivery. From the professional working with clients to the laymen looking for self-application, everyone walks away having the skills to succeed with this extraordinary healing modality. This online format did not at all hinder the delivery of the content and technique whatsoever and we were able to do everything that we could have done in person. Alina and Craig created a very safe space, gave us plenty of demos, lots of practice time and welcomed all of our questions. They also broke up the day with ample breaks and Eden energy exercises to help avoid screen fatigue. Alina and Craig are experts in their field and top-notch EFT instructors. I highly recommend their online courses.— CARSON HILL EFT LEVEL 1 The Basics The preparation for the EFT Level 1 includes approximately 3 hours of advance work, including watching several short online videos and the reading of 2 articles that explore both the history of EFT and the scientific premises for how EFT works. Note that last minute signups will not be allowed without contacting us due to this requirement. EFT Level 1, The Basics, is the foundation of any EFT training. It covers the core aspects of EFT with a focus on how you can use tapping as a self help tool and how to teach your clients how to apply it as a self-regulating technique. Learn how to apply EFT for issues related to physical symptoms, for cravings and addictions and more. See below for an outline of materials covered. An outline of subject matter covered in this first day include: The Science Behind EFT Understanding Shifting Aspects The Importance of Being Specific Psychological Reversal & Secondary Gain Cognitive Belief Shifts How Traumatic Events Imprint on the Brain Finding the Right Words to Use An introduction to both Tell the Story and the Movie Techniques for working with traumatic events The Movie Technique Working with Pain and Physical Symptoms EFT for Cravings and Aspects of Addictions Participants who take this program will be issued a Certificate of Attendance that they have completed EFT Level 1. This is the first step along the path to obtain Certified EFT Practitioner through EFT International, but should not be put forth as a certification in itself. I wholeheartedly recommend training in EFT with Craig and Alina. I recently took their EFT level 1 and 2 live online training and it was a fantastic experience. The virtual environment in Zoom was great and everything worked perfectly, and I learned so many things. I appreciate the way they break down important concepts and share their many years of experience, and the emphasis they put on generating and maintaining safety and rapport with the client at all times.— BRUNO SADE, PSYCHOLOGIST EFT LEVEL 2 Foundational Skills The two-day EFT Level 2 workshop is designed for those practitioners who have taken the pre-requisite EFT Level 1 and are either in practice or preparing to be and will be able to apply EFT when working with clients. This may include but not be limited to social workers, counselors, therapists, health care practitioners, life coaches and those who may be wishing to pursue EFT certification. It reviews and expands upon the basic aspects of the Art and Science of EFT taught in the EFT 1 course. Additional techniques are taught to expand your repertoire and offer skillful and effective ways of working with different client populations and expanding your ability to work with deeper issues. Of course, as in all EFT Tapping Training workshops, new material is presented using a variety of learning styles including partnered teaching methods, demonstrations, paired and small group experiential applications, video examples and more to ensure that no one walks away without fully understanding everything that is taught. Most importantly, this EFT Level 2 workshop will hone your practice skills. Greater attention and time will be spent on personal observation to assist you in mastering the techniques learned. Enhanced instruction on asking key questions for uncovering core issues will be provided. The following subject matter will be taught in Level 2 with an emphasis on personal practice of techniques learned with direct observation and support from the trainers: The Gentle Techniques for Intense Issues including Sneaking Up on the problem, Tearless Trauma and the somato-emotional process of Chasing the Pain (Sensation) Understanding the Nature of and working with Traumatic Events Clearing Limiting Beliefs Questions for Uncovering Core Issues Core Issues and Physical Symptoms Working over the Telephone or Internet EFT in Groups Using EFT with Children Scope of Practice, Informed Consent and the EFT Ethics Code Participants who take this program will be issued a Certificate of Attendance that they have completed EFT Level 2. This is the second instructional step along the certification path for EFT International Accredited Certified EFT Practitioner, but should not be put forth as a certification in itself. Read about EFT and course descriptions Presenting Certified Trainers Alina Frank and Craig Weiner, DC Cost For the combination three day Level 1 and 2 combined training, the tuition is $799 ($749 early bird special if purchased 30 days prior to the workshop start date). Both EFT Levels 1 and 2 are pre-requisites for EFT International EFT certification. Location Online Hours Both EFT Level 1 and 2 training courses begin promptly at 9 am with registration beginning at 8:30 am Seattle/Los Angeles time zone. A 15 minute break is provided in the morning and afternoon. A 90 minute lunch break is offered beginning at approximately 12:30 pm. The class ends each day at 6 pm. EFT International Certification Process Attendance and completion of this training in no way constitutes “certification” and no attendee should consider themselves or promote themselves as a Certified EFT Practitioner based solely upon attendance of this training. All the requirements for completing certification will be discussed during the workshop and can be found on our EFT Certification page. Alina Frank and Dr Craig Weiner have taught and mentored thousands of individuals and professionals throughout the North America and Europe and are sought after speakers and presenters in the field of EFT instruction and EFT practice development and are EFT International Accredited Master Trainers and EFT International Supervising Mentors. CEUs, Certificates & Letters of Completion Approved Continuing Education Hours 24 CEUs have been pre-approved for NY LMHCs and may be available through 716CEU, LLC which is recognized by the New York State Education Department’s State Board for Mental Health Practitioners as an approved provider of continuing education for licensed mental health counselors. #MHC-0241. Please inquire for further details regarding whether this specific training will have CEs offered and any requirements and costs involved for receiving CEs. 24 CE hours for NY Social Workers have been pre-approved and may be available through Tree of Hope Counseling, an approved NYS Continuing Education Contact Hours (CEU) provider for Social Workers (#SW0322). Please inquire for further details regarding whether this specific training will have CEs offered and any requirements and costs involved for receiving CEs. The EFT Tapping Training Institute, with Craig Weiner and Alina Frank as trainers, have been pre-approved for 24 continuing education credit hours for online Emotional Freedom Techniques Level 1-2 training for the Canadian Counselling and Psychotherapy Association. Members of CCPA will receive transcripts at no cost listing all attended events assessed as Continuing Education Credit. Non‐members must attach a cheque for $30.00 payable to CCPA to have CEC’s recorded and to have a transcript issued. Every person who fully attends the workshop training will receive a completion certificate with the course hours listed. Certificates of Completion Official Letters of Completion are available upon request for courses. They are signed by our Trainers, has the attendees name, date of completion and the number of educational hours. The letter will be sent to the course participant as a PDF email attachment. It is the responsibility of each participant to submit the letter to the appropriate certifying board in order to determine if they will receive any type of credit. Certificates of Completion for Courses Participants of the following courses offered by the EFT Tapping Training Institute may receive a Certificate of Completion upon graduation (provided in a PDF format and sent via email): EFT Levels 1-2 EFT Level 3 Matrix Reimprinting Foundational Training Other courses may be able to provide either a Certificate of Completion or a Letter of Completion upon graduation. BIPOC Scholarship Program Please visit our Scholarship Guidelines & Application page for details. Cancellation Policy A complete refund, minus $150 administration fee, is given up to 3 weeks (21 days) prior to workshop’s start date. If cancellation occurs for any reason within the 3 weeks prior to the event, the student may apply the tuition paid towards any future EFT or Matrix Reimprinting workshops offered by us. AS THERE IS MATERIAL TO REVIEW PRIOR TO THE FIRST DAY OF TRAINING, REGISTRATION CLOSES 24 HOURS BEFORE THE START OF THE TRAINING SO THAT YOU CAN REVIEW THE MATERIALS IN ADVANCE. IF YOU DO NOT RECEIVE THE LINK OF THIS MATERIAL VIA EMAIL WITHIN 24 HOURS OF REGISTERING, PLEASE CONTACT US IMMEDIATELY.

Who is this course for? Beginner to Intermediate 3ds Max Training Program. Learn 3D modeling with our in-depth 3ds Max training program. Beginners to intermediate learners, this course is led by certified instructors and industry professionals. Learn 3D modeling, animation, and visualization. In-person or live online sessions. Click here for more info: Website Duration: 20 hours Method: 1-on-1 Personalized Attention. Schedule: Design your own schedule, hours of your choice, offered Mon to Sat from 9 am to 7 pm. 3ds Max and Vray Basic to Intermediate Training Course - 20 Hours Course Outline: Module 1: Introduction to 3ds Max (2 hours) Familiarizing with the 3ds Max interface and navigation Understanding the workspace setup for efficient workflow Mastering object creation, modification, and manipulation Exploring the basics of scene organization and management Module 2: 3D Modeling in 3ds Max (4 hours) Creating primitive and complex shapes using standard tools Utilizing modifiers for advanced modeling techniques Mastering spline modeling for precision and creativity Combining multiple objects for seamless compositions Module 3: Texture Mapping and Material Creation (4 hours) Understanding UVW mapping and texture coordinates Applying materials and shaders for realistic surfaces Utilizing Vray materials for enhanced visual effects Customizing materials for unique and captivating designs Module 4: Lighting and Rendering with Vray (4 hours) Implementing Vray lights for various lighting setups Exploring Vray's global illumination for realism Configuring render settings for high-quality output Fine-tuning the rendering process for efficiency and speed Module 5: Animation and Camera Techniques (4 hours) Setting up animation keyframes for dynamic motion Utilizing cameras for captivating viewpoints and perspectives Creating smooth camera animations and walkthroughs Incorporating animated objects to bring scenes to life Module 6: Scene Optimization and Advanced Features (2 hours) Streamlining scene organization for better workflow Leveraging Vray proxies for optimized performance Exploring advanced Vray features for stunning effects Using Vray render elements for post-processing control Module 7: Project Work and Review (2 hours) Applying the learned skills in hands-on projects Reviewing and refining the projects with instructor guidance Consolidating knowledge and addressing any remaining queries Course Requirements: A computer with 3ds Max and Vray installed (trial versions available on Autodesk and Chaos Group websites) Basic familiarity with 3D modeling concepts is beneficial but not mandatory Enthusiasm for learning 3ds Max and Vray to create impressive 3D models, visualizations, and animations By the end of the 3ds Max and Vray Basic to Intermediate Training Course, participants will be able to: Navigate and utilize the 3ds Max interface with ease for efficient 3D modeling and scene management. Create a variety of 3D models using different techniques, including primitive shapes, modifiers, and spline modeling. Apply textures and materials to their models, utilizing Vray materials for enhanced visual effects. Set up lighting and render scenes using Vray, understanding global illumination for realistic renders. Animate objects and cameras, producing dynamic and engaging animations within their 3D scenes. Optimize scenes and use advanced Vray features, like proxies and render elements, for improved performance and post-processing control. Apply the learned skills to hands-on projects, gaining practical experience in creating captivating 3D models and animations. Review and refine their projects, receiving instructor guidance and feedback to enhance their work. Gain confidence in using 3ds Max and Vray, allowing them to continue exploring and advancing their 3D modeling and rendering skills independently. Showcase their newfound abilities through an impressive portfolio of 3D models and animations, ready to take on new creative challenges in various industries. Skills Acquired: Mastering Fundamental 3D Modeling Techniques in 3ds Max Developing Texturing and Material Application Skills Understanding Lighting and Rendering Fundamentals Grasping Animation Basics and Keyframe Animation Gaining Proficiency in Scene Composition and Camera Setup Career Opportunities: Entry-Level 3D Modeler Junior 3D Animator Texturing and Lighting Assistant CAD Designer in Architectural Firms Product Visualization Artist in Marketing Agencies Upon completing our 3ds Max Beginner Course, students will acquire foundational 3D modeling and animation skills, opening doors to entry-level positions in various industries, including animation studios, architectural firms, and marketing agencies. Personalized Guidance: Expert trainers cater to your unique learning needs through tailored one-on-one coaching. Hands-On Learning: Engage in practical demonstrations, reinforcing skills applicable to industries like design, gaming, and film. Comprehensive Resources: Access a Certificate of Attendance and detailed training guides for continuous reference. Interactive Sessions: Interact live with tutors, receiving valuable feedback and access to recorded sessions. Flexible Options: Choose between online or in-person sessions, fitting your schedule and preferences. Value and Support: Enjoy competitive rates, discounts for referrals, and lifetime assistance via email and phone. Smooth Start: Receive assistance with software installation, ensuring a seamless learning experience.

face to face training customised and bespoke. Online or Face to Face

A fantastic online one-to-one diploma course for those looking to become a successful graphic designer