69 Courses delivered Live Online

Immerse yourself in the ancient practice of yoga, a transformative journey that extends far beyond the mere physical postures. Our comprehensive yoga sessions are meticulously curated and led by seasoned professionals, offering a serene sanctuary tailored for the demands of modern-day professionals yearning for holistic balance and wellness. Delve into innate human abilities such as intuition, telepathy, clairvoyance, lucid dreaming, and energy healing. Uncover these dormant gifts existing within and enjoy awakening them fully.

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

Miss Date Doctor’s Emotional Intelligence coaching is designed to help you develop the skills and knowledge needed to understand and manage your emotions effectively. Emotional intelligence is a critical factor in building strong, healthy relationships, and our coaching can provide you with the tools needed to enhance your emotional intelligence and improve your relationships. Our Emotional Intelligence coaching includes a range of techniques and strategies, such as self-awareness, self-regulation, empathy, and social skills. We can help you learn to identify and manage your emotions, as well as to understand and respond effectively to the emotions of others. With our Emotional Intelligence coaching, you can learn to build stronger, more fulfilling relationships by improving your ability to communicate effectively, resolve conflicts, and understand the needs of your partner or potential partner. Whether you’re looking to enhance your personal relationships or to improve your professional performance, our Emotional Intelligence coaching can help you achieve your goals. Have 3 one hour sessions with a certified qualified experienced professional The Miss Date Doctor Emotional Intelligence package includes the following: Relationship Emotional Intelligence, Emotional Intelligence Coaching, Self-Awareness, Self-Regulation, Empathy, Social Skills, Emotion Management, Emotion Understanding, Emotional Intelligence Training, Communication, Conflict Resolution, Relationship Building, Emotional Intelligence Techniques. https://relationshipsmdd.com/product/emotional-intelligence-package/

Duration 2 Days 12 CPD hours This course is intended for Delegates should be PC literate, i.e., familiar with PC'S/Laptops and have used a mouse and keyboard; be able to launch and close programs; navigate to information stored on the computer; manage files and folders and be comfortable using Microsoft Office applications such as MS Excel, MS Word etc. Overview The purpose of this course is to provide delegates with the practical skills to build and manage project schedules. It is designed to provide techniques and tips that will help users of the software apply it as a powerful tool to develop competent and unambiguous schedules - while avoiding some of the traps associated with the incorrect application of scheduling features. Techniques learned will also facilitate communicating deliverables and milestones to project stakeholders. This course covers management practices and methodologies and an in-depth knowledge of MS Project functionality. Delegates will be able to create and manage project schedules during the course and reinforce attained skills through practical applications. Project Management Overview Concepts of project management and scheduling The project lifecycle and phases Fundamental importance of defining ? and agreeing ? project scope Developing a Work Breakdown Structure (WBS) to define project scope 4 steps to create a schedule based on the WBS Understanding task dependencies Understanding the concept of the project baseline Developing a Project Schedule Setting the ?Scheduling Mode? Creating Tasks, Recurring Tasks (e.g. progress or review meetings) and Milestones Defining task Dependencies Applying Lag and Lead Time Working with the Critical Path Managing Tasks in the schedule Add Notes and attach project documents to tasks Setting and removing task Constraints and Deadlines Applying the ?Task Path? feature to view dependencies Working with Resources Creating a Resource Pool Working with Resource Calendars Creating Team/Group Calendars Understanding Effort Driven and Non-Effort Driven scheduling Assigning Resources to tasks Working with Project Costs Managing Project Information Applying Field, Tables and Views Applying Filters and Groups Creating custom Fields, Tables and Views (Drop-down menus, Traffic Light reports, Flag Fields) Using the ?Organiser? feature for customised elements Communicating Project Information Applying formats to Views and Tables Using the ?Copy Picture? command Create and Print Project Reports Exporting to Excel Managing Resources Finding Resource Overallocations Resolving Overallocations (reassigning, splitting tasks, utilising float, changing work contours) Applying Resource Levelling features Tracking Progress Setting the Project Baseline Applying the Tracking Gantt and Tracking Table Using the ?Mark on Track? and ?Update Tasks? features Working with Dashboards and Burndown Reports Programme Management Methods to consolidate multiple Project Files Resource sharing - setting up a Master Resource Pool Creating and managing Master Project Files

Course Objectives At the end of this course you will be able to: Manage project costs Consolidate and reuse project plan information Exchange project plan data with other applications Update a project plan Customise Project to meet specific requirements ' 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk Customer Feedback Really useful and engaging course. Learnt a lot that will be very beneficial in my job. Trainer was great. Kelly Moreley - TACT Very happy with the course. Worked as a good refresher from what I knew already and enhanced my knowledge further Jenny Price - Acer ' 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. Exchanging Project Plan Data with Other Applications Import a list of tasks from Outlook Import a Task List from an Excel File Create a Custom Import Map Export Project Plan Cost Data into Excel Save Project Plan Information as a Web Page Updating a Project Plan Enter Task Progress Information View Task Progress Split a Task Reschedule a Task Creating Custom Fields Text fields Lookup fields Calculated fields with the use of formulas and functions Inserting Graphical Indicators Customizing how you look at data Filter Tasks in a Project Plan Create a Custom Table Create a Custom View Copy custom Views and Tables between projects Earned value analysis Understanding Earned Value Fields View Multiple Baselines in a Single Project Tracking progress between interim plans Creating Custom Reports Create a Custom Report Modify a Custom Report's Header and Footer Add a Picture to a Report Modify a Custom Report's Margins Print a Custom Report Re-using Project Plan Information Create a Project Plan Template Create a Custom Combination View Make Custom Views Available to Other Project Plans Share Resources between Projects, Create a Master Project Plan with sub projects Who is this course for? Who is this course for? This course is designed for those that who already have the skills to create and modify project plans and would like to acquire a more in depth and thorough knowledge of more advanced functionalities in project planning and tracking. Requirements Requirements Preferably, delegates would have attended the MS Project Introduction course. Career path Career path Microsoft Office 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

Adobe After Effects Training Fundamentals to Essentials. Learn essential techniques for creating visual effects and animations. Adobe After Effects Essentials VFX Course to learn auto-correction methods and tools, adjust video effects or presets to layers, and utilize 3D space for modifying composition. Click here for more info: Website Duration: 20 hours Approach: 1-on-1 personalized sessions and Tailored content. Flexibility: Book a time convenient for you, Monday to Saturday, between 9 am and 5 pm. Duration: 20 Hours Module 1: Introduction to After Effects (2 hours) Understanding the After Effects interface Project planning and organization techniques Module 2: Asset Preparation and Composition Setup (3 hours) Importing and organizing multimedia assets Setting up compositions for different media formats Module 3: Applying Transformations and Effects (5 hours) Animating images, videos, and text Applying diverse transformations and effects for dynamic visuals Module 4: Mastering Masking and Compositing (5 hours) Creating and refining masks for precise editing Advanced compositing techniques for seamless integration Module 5: Rendering High-Quality Videos (3 hours) Configuring rendering settings for various output formats Ensuring optimal quality in the final video output Module 6: Project Review and Q&A Session (2 hours) Reviewing projects and addressing individual queries Fine-tuning techniques based on participants' needs Course Benefits: Hands-on learning with personalized attention Mastering crucial After Effects skills for diverse media projects Access to recorded lessons for future reference Continuous email support for post-course inquiries After Effects Download  https://www.adobe.com Upon completing the Essential After Effects Skills Mastery course, participants will: Proficiency in After Effects: Master the After Effects interface, gaining confidence in navigating the software effectively. Strategic Project Planning: Acquire skills in project organization and planning, ensuring a systematic approach to video projects. Advanced Asset Management: Learn efficient techniques for importing, organizing, and managing multimedia assets within After Effects projects. Dynamic Composition Creation: Gain expertise in setting up compositions tailored to various media formats, understanding their intricacies and potential applications. Creative Animation Techniques: Apply diverse transformations and effects to images, videos, and text, enhancing the visual appeal of multimedia content. Precision in Masking and Compositing: Master the art of masking, enabling precise editing, and explore advanced compositing techniques for seamless visual integration. High-Quality Video Rendering: Understand rendering settings, ensuring optimal video quality for different output formats, whether for online platforms or professional presentations. Project Review and Refinement: Engage in project reviews and Q&A sessions, refining techniques and addressing individual queries for comprehensive learning. Confidence in Video Production: Develop confidence in producing high-quality videos, equipped with a robust skill set essential for various creative projects. Continuous Learning Support: Benefit from continuous email support, providing assistance with post-course inquiries, ensuring ongoing learning and skill refinement. In this course, you will learn: Efficient workflow planning and asset organization in After Effects projects. Creative project development techniques for engaging visuals. Image and video asset preparation using Photoshop. After Effects project setup, compositions, and asset integration. Animation of transformations and effects on layers. Advanced mask creation and animation for creative compositing. Dynamic text animation and 3D exploration. Keying and seamless visual integration techniques. Understanding export settings, project backup, and archiving. Learning Objectives: Upon completion, you will master asset organization, animations, masks, text effects, and seamless integration, ensuring proficiency in After Effects projects. Prerequisites: Basic computer skills and a fast-paced learning mindset are required. No prior experience is necessary, making this course suitable for beginners. Key Features: Personalized one-on-one or live online coaching sessions. Suitable for both beginners and professionals in motion graphics and animation. Tailored Training: Courses customized to meet your specific requirements. Flexible scheduling options to suit your availability. Industry Standard: Adobe After Effects, the industry-preferred software for visual effects, motion graphics, and compositing. Widely used in filmmaking, video games, and TV production. Learning Approach: Hands-on training with detailed, step-by-step demonstrations. Real-time feedback during sessions, along with access to session recordings. Course Benefits: Certificate of Attendance upon completion. Comprehensive practical training guide for reference. Lifetime email and phone support for continuous assistance. Help with software installation for a seamless learning experience. Lifetime Support: Ongoing email and phone/WhatsApp support for lifelong learning assistance. Elevate your motion graphics expertise with our Adobe After Effects Basic to Fundamentals Training Course. Open doors to exciting opportunities in the ever-evolving realm of visual effects.

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.

Resolving serious conflict Assessment speak to each individual separately Emotional intelligence Mediation Ascertain root cause Love languages Trust building Compromise and understanding each other 4 sessions 1 hour x 4 https://relationshipsmdd.com/product/marriage-counselling-package/

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

Click here for info. Training duration: 20 hrs. Method: 1-2-1, Personalized attention, Tailored content, Flexible pace, Individual support. Schedule: Personalized training experience with our flexible 1-2-1 sessions. Tailor your own schedule by pre-booking a convenient hour of your choice, available from Monday to Saturday between 9 am and 7 pm. Maya Basic to Intermediate Course Course Duration: 20 hours Course Description: Discover Autodesk Maya's potential in our 20-hour course. Master 3D modeling and animation, explore texturing, rigging, rendering, and special effects. Unleash your creativity with advanced modeling techniques. Join us on this exciting journey to unlock the full power of Maya. Course Outline: I. Introduction to Maya (1.5 hours) - Discover the vast applications of Maya and its significance in diverse industries - Navigate seamlessly through Maya's interface, understanding essential tools - Master viewport controls and proficiently manage projects II. Creating 3D Models (3 hours) - Build a strong foundation in polygon modeling, creating basic shapes and objects - Hone your skills in editing and modifying objects with precision - Master complex object creation using extrusions, bevels, and NURBS for organic shapes III. Texturing and Materials (1.5 hours) - Step into the captivating world of texturing, adding depth to your creations - Create and expertly apply materials to breathe life into your models - Unwrap textures with precision and import images seamlessly IV. Lighting and Rendering (2 hours) - Illuminate your scenes with fundamental lighting techniques - Compose visually captivating compositions with camera setup - Harness the power of rendering for still images and dynamic animations V. Animation (4 hours) - Embrace the art of animation, unlocking its potential in your projects - Master keyframe animation, animation curves, and animation clips - Rig and animate characters, adding life and movement to your creations - Explore motion paths and animation layers for added depth and complexity VI. Rigging (2 hours) - Delve into the world of rigging and its significance in animation - Create joints and skeletons, laying the foundation for character animation - Bind skin to joints and craft weight maps for smooth animation - Implement simple rigging systems and rig characters for animation VII. Special Effects (1.5 hours) - Unleash your creativity with mesmerizing particle systems and dynamics - Create captivating fluid and fire effects, manipulating them with finesse - Craft and edit special effects, from explosions to captivating smoke VIII. Advanced Modeling Techniques (1.5 hours) - Elevate your modeling skills with advanced techniques using Booleans and deformers - Master the art of creating and modifying curves and surfaces - Explore the world of sculpting tools to craft high-resolution and intricate models IX. Conclusion and Next Steps (0.5 hours) - Recap the rich knowledge acquired during the course - Discover valuable tips and resources for continuous learning and growth - Engage in a dynamic Q&A session, providing valuable feedback Note: The course outline can be customized to meet the specific needs and proficiency levels of learners. Throughout the course, you will receive lifetime email support, ensuring you have assistance for any queries or challenges you encounter. Embrace the world of Autodesk Maya, and unveil your creative potential in 3D modeling and animation.   Unlock your potential in Autodesk Maya with our comprehensive Basics to Intermediate Training Course. Whether you're a budding 3D artist, animator, or visual effects enthusiast, this program provides a structured learning path to master essential tools and techniques. Join us for interactive in-person or live online sessions, and receive guidance from experienced instructors. Enroll now to create captivating 3D visuals and animations and explore the creative possibilities of Autodesk Maya. In this course, explore the world of Maya 2023 and master the skills to create high-quality 3D models and animations. Discover a real-world, project-based workflow applicable to film, motion graphics, and game design. Learn Basic to Intermediate techniques like customizing the interface, object manipulation, and scene organization. Dive into polygonal, sculpting, and NURBS modeling, and apply materials for color, texture, and reflectivity. Integrate cameras, lighting, and depth-of-field effects with the Arnold renderer. Finally, learn animation tools to add movement and bring your creations to life, guided by instructor Autodesk certified trainers In this course, explore the world of Maya 2023 and master the skills to create high-quality 3D models and animations. Discover a real-world, project-based workflow applicable to film, motion graphics, and game design. Learn Basic to Intermediate techniques like customizing the interface, object manipulation, and scene organization. Dive into polygonal, sculpting, and NURBS modeling, and apply materials for color, texture, and reflectivity. Integrate cameras, lighting, and depth-of-field effects with the Arnold renderer. Finally, learn animation tools to add movement and bring your creations to life, guided by instructor Autodesk certified trainers In this course, explore the world of Maya 2023 and master the skills to create high-quality 3D models and animations. Discover a real-world, project-based workflow applicable to film, motion graphics, and game design. Learn Basic to Intermediate techniques like customizing the interface, object manipulation, and scene organization. Dive into polygonal, sculpting, and NURBS modeling, and apply materials for color, texture, and reflectivity. Integrate cameras, lighting, and depth-of-field effects with the Arnold renderer. Finally, learn animation tools to add movement and bring your creations to life, guided by instructor Autodesk certified trainers Master 3D modeling and animation. Create realistic textures and materials. Understand rigging for character animation. Illuminate scenes with effective lighting. Create mesmerizing special effects. Explore advanced modeling techniques. Gain practical skills for real-world projects. Unlock creative potential in film, animation, and game design.