Access confidential and personalized private counselling in London. Our experienced therapists provide one-on-one sessions to address your unique mental health needs, including anxiety, depression, stress, and more. With a focus on privacy and individualized care, our therapy services aim to support your journey towards mental well-being and personal growth. Key areas: confidential therapy, one-on-one counselling, private therapy, individual counselling, personal therapy sessions, private mental health support, discreet counselling. 3 x 1 hour sessions
Access affordable mental health support with low-cost counselling in London. Our qualified counsellors offer budget-friendly therapy sessions to help you through difficult times, including stress, anxiety, depression, and more. We believe that financial constraints should not be a barrier to receiving quality mental health care, and our services are designed to provide effective support at a manageable cost. Key areas: affordable therapy, budget counselling, cheap counselling, cost-effective therapy, economical mental health support, low-cost therapy, financial counselling support. 3 x 1 hour sessions
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
Description: Discover free counselling services in London to support your mental health. Our compassionate counsellors offer no-cost therapy sessions for individuals facing financial difficulties, ensuring that everyone has access to the help they need. From stress and anxiety to depression and grief, our free counselling services are designed to provide essential mental health support without the financial burden. Key areas: no-cost counselling, free therapy, mental health support, free mental health services, accessible therapy, community counselling, pro bono therapy. 3 x 1 hour sessions
PgMP® Exam Prep This course is designed and developed by PgMP® certified consultants and instructors. Its aim is to prepare professionals who are familiar with the principles of program management for the Program Management Professional (PgMP)® Examination. The course is based on PMI's The Standard for Program Management, A Guide to the Project Management Body of Knowledge (PMBOK® Guide), and PMI's Program Management Professional (PgMP)® Examination Content Outline (current versions). Through this learning experience, you will explore: Program management from a PMI standard perspective, including the interdependencies between the five performance domains, the three program phases, and the ten supporting activities in this new and improved program management standard The difference between the five performance domains in the new program management standard and the five practice domains in the examination content outline The role and competencies of the program manager The difference between project managers and program managers - and their relationship in a program environment The difference between program managers and portfolio managers - and their relationship in a program environment How program managers align and manage benefits The best ways to engage and involve program stakeholder groups How to establish governance across the program life cycle What You Will Learn At the end of this course, you will be able to: Differentiate between the practice domains in the PMI PgMP® Examination Content Outline and the performance domains in The Standard for Program Management - Fourth Edition Name and describe the three phases in the program management life-cycle phases Describe the mapping of the life-cycle phases with the supporting program activities Identify the key outputs of the supporting program activities Articulate the interrelationships between the program management supporting processes and the mapping of processes to Knowledge Areas and Process Groups in the PMBOK® Guide - Sixth Edition Apply program management knowledge to answer foundation and scenario-based questions Summarize the process and eligibility criteria for earning the PgMP® credential Getting Started Introductions Course structure Course goals and objectives Foundation Concepts Programs, projects, and portfolio definitions differences, and how they relate The definition of a component and how it relates to a program Representative program management life cycle Role of the program manager and the program office The difference between the program management practice and performance domains Program Register and Knowledge Asset Management Program registers, and how they are used to manage knowledge assets Knowledge asset management, beginning with the data, information, knowledge, and wisdom (DIKW) Model Knowledge assets and relationship to the performance domains The program manager as a knowledge asset manager Types of Programs Perspectives on programs to establish the 'right' perspective Categories of programs based on the program standard Scenario-based questions Program and Organization Strategy Alignment An overview of the Program Strategy Alignment performance domain Exploration of the elements of strategic alignment, i.e., the business case, program charter, and program roadmap Exploration of organization maturity and strategic alignment Scenario-based questions that reference both the Program Strategy Alignment performance domain and the Strategic Program Management practice domain Program Benefits An overview of the Program Benefits Management performance domain Exploration of each benefits management interaction with the representative program management life cycle: Benefits IdentificationBenefits Analysis and PlanningBenefits DeliveryBenefits TransitionBenefits SustainmentScenario-based questions that reference both the Program BenefitsManagement performance domain and the Benefits Management practice domain Program Stakeholder Engagement An overview of the Program Stakeholder Engagement performance domain Exploration of each stakeholder engagement performance domain activity: Program Stakeholder IdentificationProgram Stakeholder AnalysisProgram Stakeholder Engagement PlanningProgram Stakeholder EngagementProgram Stakeholder CommunicationsScenario-based questions that reference both the Program StakeholderEngagement performance domain and the Stakeholder Management practice domain Program Governance An overview of the Program Governance performance domain Exploration of each program governance performance domain activity: Program governance practicesProgram governance roles and responsibilitiesProgram governance design and implementationGovernance relationship within programsScenario-based questions that reference both the Program Governance performance domain and the Governance practice domain Program Life Cycle Management An overview of the Program Life Cycle Management performance domain Exploration of the three phases in the representative program life cycle: Program DefinitionProgram DeliveryProgram ClosureExploration of the interaction between program activities and integration managementScenario-based questions that reference both the Program Life CycleManagement performance domain and the Program Life Cycle practice domain Program Management Supporting Activities - Part 1 An overview of the program management supporting activities Exploration of 5 of 10 supporting activities: Program change managementProgram communications managementProgram financial managementProgram information managementProgram procurement managementScenario-based question(s) presented after each supporting activity Program Management Supporting Activities - Part 2 Exploration of the remaining 6 of 10 supporting activities: Program quality managementProgram resource managementProgram risk managementProgram schedule managementProgram scope managementScenario-based question(s) presented after each supporting activity Program Management Professional (PgMP®) Examination Application process and timeline General and special eligibility criteria International Institute's Online Learning Tool - access to sample examination questions Program Management Professional (PgMP®) Examination breakdown of domains and subdomains Terms and conditions of the exam PgMP® Professional Code of Conduct
The NVQ Level 2 Diploma in Curtain Wall is appropriate for individuals aged 16 and over working in the construction sector who specialise in the installation if Curtain Wall and Aluminium Architectural Glazing Systems and are looking to become eligible for the Blue CSCS Card. The aim of this qualification is to recognise the knowledge, skills and competence of individuals who specialise in this area and upon completion of the qualification, you will be awarded the NVQ Level 2 Certificate in Curtain Wall CSCS Cards Candidates can undertake the CSCS test and obtain the red (Provisional) CSCS card on signing up for this qualification. The red CSCS card can usually be obtained within 7 to 14 days and can be used to access the construction sites for a period of 12 months. In order for candidates to obtain their CSCS Card for Curtain Wall Installation they must also fulfil the requirements for technical knowledge as set out by the Council for Aluminium in Building and are generally required to complete CAB 1 day Curtain Wall essential knowledge training course. For more information regarding the CAB Course and CSCS requirements, please see the information below.
students learn a variety of different brow tattooing techniques, so we will spend two days learning the shaded brow effects possible with a digital device and three days focused on our most-requested Hairstroke Brows.
About this Virtual Instructor Led Training (VILT) This 2 half-day Virtual Instructor-Led Training (VILT) course will guide participants on the technoeconomic aspects of capture, utilization and geological storage of carbon dioxide. The VILT course will address the methods and techniques used in the technoeconomic assessment of Carbon Capture, Utilization & Storage (CCUS) projects. It will explore in detail the factors that affect the cost-effectiveness of current and emerging technologies for CO2 capture, transport and geological storage, including monitoring and verification. Given that the successful deployment of CCUS may require economic incentives, technical and economic drivers such as technological innovation, optimization, source sink matching and emerging opportunities will also be discussed. In addition, using several worked examples and case studies, this VILT course will explain the principles behind the analysis of the costs and opportunities of a CCS / CCUS project from source to sink and examines the possibilities of using carbon dioxide from an economic perspective. Training Objectives Upon completion of this VILT course, participants will be able to: Describe the economic considerations for CCS / CCUS projects Measure and calculate the cost-effectiveness of CCS / CCUS Identify the economic drivers for CCS / CCUS Understand the value of source to sink matching Outline the economic and environmental opportunities as well as challenges with using carbon dioxide injection in a range of applications Recognize niche opportunities for CO2 storage (coal seams, basalts, salt and others) Target Audience This VILT course is ideally suited for a technical audience such as geoscientists, petroleum and chemical engineers as well as professionals such as economists, regulators, legal staff and managers wishing to learn more about the details of economic aspects and the basis for techno-economic analysis of Carbon Capture, Utilization and Storage projects. The VILT course is presented in an interactive workshop format, allowing for discussions. Participants should have: Basic background knowledge of CCUS technologies Experience with oil and gas, coal or other energy projects Basic understanding of the energy industry Course Level Basic or Foundation Training Methods The VILT course will be delivered online in 2 half-day sessions comprising 4 hours per day, with 2 breaks of 15 minutes per day. The VILT course is presented in an interactive workshop format that allows discussion. Course Duration: 2 half-day sessions, 4 hours per session (8 hours in total). Trainer Your expert course leader received his B.Eng. in Chemical and Environmental Systems in 2002 from Tecnológico de Monterrey, Mexico, and his Ph.D. in Chemical Engineering in 2008 from the University of New South Wales (UNSW), in Sydney, Australia, at the UNESCO Centre for Membrane Science and Technology. His doctoral used computational fluid dynamics (CFD) to analyse the flows within membrane modules used for water treatment and desalination. He also worked on a desalination linkage project between the UNSW and the European Union, as part of Framework Programme 6. From 2009 to 2014, he worked for the Cooperative Research Centre for Greenhouse Gas Technologies (CO2CRC), where he led the research into CO2 Transport Networks, co-led the development of a techno-economic model for the analysis of Carbon Capture and Storage (CCS) projects, and collaborated on several consultancy and feasibility studies conducted by CO2CRC for both Government and Industry. From 2014 to 2019, he held a CONACYT Research Fellowship at the Instituto Tecnológico de Sonora (ITSON) in Mexico, where he led collaborative research projects dealing with RO membrane biofouling (IHE-Delft), membrane modifications, solar energy use for desalination (CSIR-CSMCRI India) and CFD modelling of the hydrodynamics in membrane modules (UMP Malaysia). Since July 2019, he is a Research Fellow in the School of Chemical and Biomolecular Engineering at the University of Sydney, where his research focuses on finding ways to reduce the cost, energy use and environmental impact of technologies for providing clean energy and water. From 2015 to 2020, he was a Member of the Board of Directors of the Mexican Society of Membrane Science and Technology. He guest edited a special edition on CCS for the Journal 'Technologies' and is currently an Editorial Board member for the journal, 'Energies', a peer-reviewed open-access scientific journal. His research interests include improving the efficiency of osmotic membrane separation processes, modelling complex processes involving heat and mass transfer, and exploring the economic drivers of low emission technologies such as the Carbon Capture and Storage (CCS) chain. POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information about post training coaching support and fees applicable for this. Accreditions And Affliations
Who is this course for? The Architecture and Interior Design course is ideal for individuals aiming to master both interior design and architecture. Guided by certified tutors from Autodesk and Adobe, students will gain comprehensive skills in these fields. Click here for more info: Website Duration: 40 hours.1-on-1 Training. In-Person or Live online. When can I book: 9 am - 7 pm (Choose your preferred day and time once a week). Flexible timing with advance booking Course Features: Compatibility: Our training courses are compatible with both Mac and Windows operating systems, ensuring accessibility for all users. Price Assurance: We guarantee the best value for your investment, ensuring competitive pricing for high-quality training. Personalized Training: Benefit from one-on-one training sessions tailored to your specific needs and skill level, ensuring a personalized learning experience. Flexible Scheduling: Enjoy the flexibility to choose your preferred training time and day. Sessions are available seven days a week, from Monday to Sunday, between 9 am and 8 pm, accommodating your busy schedule. Lifetime Support: Receive lifetime email and phone support, ensuring that you have access to assistance even after completing the course. Technical Assistance: Get help with configuring your computer for software installation, ensuring a smooth learning experience without technical hurdles. Referral Discounts: Earn special discounts when you refer a friend to our courses, making learning a rewarding experience for you and your network. Group Training Savings: Avail significant savings on group training courses, encouraging collaborative learning and making education more accessible for groups. When can you schedule this Training Course? Personalized training experience with our flexible 1-on-1 sessions. Design your own timetable by pre-booking a convenient hour of your choice, available from Monday to Saturday between 9 a.m. and 7 p.m. Alternatively, you can call 02077202581 to book over the phone. How long is the training? The course spans 40 hours, which you can divide over as many days as needed to fit your ideal schedule. What's the teaching method? Our sessions are 1-on-1, offered either in-person face to face or live online. You'll receive personalized attention, tailored content, a flexible learning pace, and individual support. Live online 1-on-1 sessions over Zoom are also an option. What will you learn? In this comprehensive training program, you'll gain proficiency in a thoughtfully curated selection of software tools. Option A: AutoCAD (13 hours) SketchUp (10 hours) Vray (6 hours) Photoshop (6 hours) InDesign (5 hours) Additionally, you'll receive free online portfolio design assistance, career growth guidance, and mock interviews to enhance your job market readiness. Option B: AutoCAD (10 hours) 3ds Max (17 hours) Vray (4 hours) Photoshop (5 hours) InDesign (4 hours) Certified trainers in AutoCAD, 3ds Max, SketchUp, and Adobe software will conduct this training program. It caters to beginners, intermediate, and advanced learners, focusing on core skills for creating 2D drawings, plans, sections, elevations, construction details, and 3D visualizations. Our experienced instructors will guide you through essential commands and methodologies for producing precise 2D and 3D drawings. We have developed these CAD courses, utilizing the expertise of our professionals to provide the most efficient and effective instruction. Upon completion, participants will: Master Software Tools: Excel in AutoCAD, SketchUp, Vray, Photoshop, and InDesign for digital design. Advanced Design Skills: Create intricate 2D/3D designs, plans, and visualizations. Project Management: Manage layouts, plotting, and projects efficiently. Realistic Rendering: Produce lifelike visualizations using Vray. Creative Composition: Understand design principles for impactful creations. Portfolio Development: Create a professional online portfolio. Career Readiness: Prepare for job interviews and enhance resumes. Potential Jobs: Architect Interior/Exterior Designer CAD Technician Visualization Specialist Design Consultant Project Manager These skills open doors to varied roles in architecture and design, ensuring career growth and job readiness. Course Features: Compatibility: Our training courses are compatible with both Mac and Windows operating systems, ensuring accessibility for all users. Price Assurance: We guarantee the best value for your investment, ensuring competitive pricing for high-quality training. Personalized Training: Benefit from one-on-one training sessions tailored to your specific needs and skill level, ensuring a personalized learning experience. Flexible Scheduling: Enjoy the flexibility to choose your preferred training time and day. Sessions are available seven days a week, from Monday to Sunday, between 9 am and 8 pm, accommodating your busy schedule. Lifetime Support: Receive lifetime email and phone support, ensuring that you have access to assistance even after completing the course. Technical Assistance: Get help with configuring your computer for software installation, ensuring a smooth learning experience without technical hurdles. Referral Discounts: Earn special discounts when you refer a friend to our courses, making learning a rewarding experience for you and your network. Group Training Savings: Avail significant savings on group training courses, encouraging collaborative learning and making education more accessible for groups. When can you schedule this Training Course? Personalized training experience with our flexible 1-on-1 sessions. Design your own timetable by pre-booking a convenient hour of your choice, available from Monday to Saturday between 9 a.m. and 7 p.m. Alternatively, you can call 02077202581 to book over the phone. How long is the training? The course spans 40 hours, which you can divide over as many days as needed to fit your ideal schedule. What's the teaching method? Our sessions are 1-on-1, offered either in-person face to face or live online. You'll receive personalized attention, tailored content, a flexible learning pace, and individual support. Live online 1-on-1 sessions over Zoom are also an option. What will you learn? In this comprehensive training program, you'll gain proficiency in a thoughtfully curated selection of software tools. Option A: AutoCAD (13 hours) SketchUp (10 hours) Vray (6 hours) Photoshop (6 hours) InDesign (5 hours) Additionally, you'll receive free online portfolio design assistance, career growth guidance, and mock interviews to enhance your job market readiness. Option B: AutoCAD (10 hours) 3ds Max (17 hours) Vray (4 hours) Photoshop (5 hours) InDesign (4 hours) Certified trainers in AutoCAD, 3ds Max, SketchUp, and Adobe software will conduct this training program. It caters to beginners, intermediate, and advanced learners, focusing on core skills for creating 2D drawings, plans, sections, elevations, construction details, and 3D visualizations. Our experienced instructors will guide you through essential commands and methodologies for producing precise 2D and 3D drawings. We have developed these CAD courses, utilizing the expertise of our professionals to provide the most efficient and effective instruction.
The Level 2 NVQ Diploma in Trowel Occupations provides a nationally recognised qualification for those working in the construction and the built environment and specialise in the erection of masonry structures. Upon completion of the qualification, you will be awarded the NVQ Level 2 Diploma in Trowel Occupations which allows the holder to obtain the Blue Skilled Worker CSCS Card. The qualification modules will be discussed and agreed upon with each individual candidate to ensure that the qualification will be suited to your job role. Each candidate will be allocated a qualified assessor to provide support throughout the qualification and provide information, advice and guidance to candidates in order that they can achieve the qualification. If you require further information or are looking to undertake this qualification, please contact us. CSCS Cards Candidates can undertake the CSCS test and obtain the red (Provisional) CSCS card on signing up for various qualifications. The red card can usually be obtained within 7 to 14 days and can be used to access the construction sites for a period of 12 months. Upon completion the card is upgraded to the full 5 year CSCS Card.