281 Courses in London

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

NPORS Crane / Lift Supervisor (N405)

Live online course with study materials and certificate of completion included This HTML course will provide you with an easy to follow, hands-on introduction to HTML and CSS, the basic coding languages which drive the internet. Participants will learn how to create an attractive and well-structured web page using basic HTML and CSS. This workshop is highly recommended for anyone wishing to learn how to create websites and also for people who already use applications such as Dreamweaver or WordPress and need more control over their web output. Resources Introduction to HTML & CSS Course Information Description Completing this course will enable you to do the following and more: Understand what HTML and CSS are and how they work together Learn basic HTML elements Learn how to create hyperlinks Work with images Use DIVs, forms and lists to arrange content Create page structure Use Cascading Style Sheets to control the layout and look of HTML elements Use Developer Tools to preview CSS changes Know how and when to use Inline CSS Create code that is both readable, compliant with HTML5 standards Understand what makes good SEO For the full course content please download the course information pdf listed above. Who is this course for? This workshop is suitable for anyone with basic PC or Mac skills who wants to understand how the web works. No previous knowledge or experience of HTML or CSS is necessary. Requirements Attendees should have basic PC or Mac skills. You will need a broadband internet connection to participate in this live online course. Certificates Certificate of completion Digital certificate - Included

Enhance your drilling skills with our Directional, Horizontal, and Multilateral Drilling Simulator Assisted course. Join EnergyEdge for comprehensive training.

Why Choose Revit Basic to Advanced Training Course? Course info. Revit Basic to Advanced Master complex 3D modeling, BIM workflows, and project phasing. In-person or live online options available. Enroll now to elevate your architectural, engineering, and construction projects with advanced Revit techniques. Duration: 16 hours Methof: Personalized 1-on-1. Customized Schedule: Choose a convenient hour from Mon to Sat between 9 am and 7 pm to create your own schedule.   Revit Basic to Advanced Training Course: Learn the fundamentals of Revit for architecture and structural design, supporting BIM workflows for efficient building construction. Delivery Options: In-class at our center Live online sessions Who Should Attend? Ideal for architects, building designers, structural engineers, and general users. Course Outline: I. Introduction to Revit  Explore Revit's purpose and applications Familiarize yourself with the user-friendly interface and essential tools Navigate efficiently and control viewports Initiate and save projects for future reference II. Setting up a Project  Create new projects and use templates for efficiency Establish project levels, grids, and crucial building information Configure project units for precision and consistency III. Basic Modeling  Master the creation and customization of walls, doors, and windows Develop floors, ceilings, and roofs for complete building structures Craft functional and aesthetically pleasing stairs and railings IV. Advanced Modeling  Learn to design custom parametric families to enhance productivity Explore conceptual modeling tools for creative freedom Integrate lighting and materials for realistic 3D rendering V. Views and Sheets  Efficiently manage views and organize them effectively Generate informative and well-structured sheets for documentation Integrate schedules and tags to enhance information clarity VI. Annotation and Detailing  Add clear and concise text and dimensions to your designs Customize detail components for precise annotations Employ symbols and keynote legends for standardized documentation VII. Phasing and Worksharing Grasp the concepts of phasing and design options Manage and modify phases effectively Collaborate seamlessly with worksharing features VIII. Project Collaboration and Management Establish a productive worksharing environment Monitor and track worksets and user activities Synchronize worksets for a coordinated team effort IX. Advanced Documentation  Create specialized and advanced schedules for comprehensive project insights Develop legends and keynotes to enhance documentation clarity Finalize construction documents with professional-looking sheets and title blocks X. Conclusion and Next Steps  Recapitulate the course content and achievements Receive valuable tips for continuous learning and further resources Engage in a Q&A session to address any remaining queries or concerns For more information and to start your learning journey, visit our website or download the free trial of Autodesk Revit from the provided link: https://www.autodesk.co.uk/autodesk/revit

About this Virtual Instructor Led Training (VILT) This Virtual Instructor Led Training (VILT) course presents advanced methodologies that implement demand response and energy conservation programs in light of the integration of new technologies, regulatory changes and the accelerated penetration of renewable energy resources. This VILT course provides examples and case studies from North American and European jurisdictions covering the operational flexibilities on the demand side including requirements for new building codes to achieve zero net energy. The course describes a public agency's goals and objectives for conserving and otherwise reducing energy consumption and managing its demand for energy. This course presents the demand response implemented for economics and system security such as system balancing and relieving transmission congestion, or for system adequacy. The course also presents the principal attributes of conservation programs and the associated success criteria. In a system with increased penetration of renewable resources, demand response provides flexibility to system operators, helping them to maintain the reliability and the security of supply. Demand response is presented as a competitive alternative to additional power sources, enhancing competition and liquidity in electricity markets. The unique characteristics are discussed from a local, consumer centric and also from a system perspective bringing to life the ever changing paradigm for delivery energy to customers. Interoperability aspects and standards are discussed, as well as the consumer centric paradigm of Transactive Energy with IOT enabled flexibilities at system level, distribution networks and microgrids. The VILT course introduces the blockchain as a new line of defense against cyber threats and its increasing application in P2P transactions and renewable certificates. Our trainer's industry experience spans three decades with one of the largest Canadian utilities where she led or contributed to large operational studies and energy policies and decades of work with IEEE, NSERC and CIGRE. Our key expert also approaches to the cross sectional, interdisciplinary state of the art methodologies brings real life experience of recent industry developments. Training Objectives Innovative Digital Technologies How systems Facilitate Operational Flexibility on the Demand Side The Ecosystem of Demand Side Management Programs Advanced Machine Learning techniques with examples from CAISO Regulatory Policy Context and how to reduce regulatory barriers Industry Examples from NERC and ENTSO Relevant Industry standards: IEEE and IEC Manage Congestion with Distributed Operational Flexibilities: Grid to Distribution Controls; examples from NERC (NA) and ENTSO (Europe) Grid solutions with IEC 61850 communication protocols Decentralized grid controls The New Grid with accelerated V2G and Microgrids How DSM is and will be applied in Your System: Examples and discussions Target Audience Regulators and government agencies advising on public energy conservation programs All professionals interested in expanding their expertise, or advancing their career, or take on management and leadership roles in the rapidly evolving energy sector Energy professionals implementing demand side management, particularly in power systems with increased renewable penetration, to allow the much needed operational flexibility paramount to maintaining the reliability and stability of the power system and in the same time offering all classes of customers flexible and economical choices Any utility professional interested in understanding the new developments in the power industry Course Level Basic or Foundation Training Methods The VILT course will be delivered online in 5 half-day sessions comprising 4 hours per day, with 2 x 10 minutes break per day, including time for lectures, discussion, quizzes and short classroom exercises. Course Duration: 5 half-day sessions, 4 hours per session (20 hours in total). Trainer Your first expert course leader is a Utility Executive with extensive global experience in power system operation and planning, energy markets, enterprise risk and regulatory oversight. She consults on energy markets integrating renewable resources from planning to operation. She led complex projects in operations and conducted long term planning studies to support planning and operational reliability standards. Specializing in Smart Grids, Operational flexibilities, Renewable generation, Reliability, Financial Engineering, Energy Markets and Power System Integration, she was recently engaged by the Inter-American Development Bank/MHI in Guyana. She was the Operations Expert in the regulatory assessment in Oman. She is a registered member of the Professional Engineers of Ontario, Canada. She is also a contributing member to the IEEE Standards Association, WG Blockchain P2418.5. With over 25 years with Ontario Power Generation (Revenue $1.2 Billion CAD, I/S 16 GW), she served as Canadian representative in CIGRE, committee member in NSERC (Natural Sciences and Engineering Research Council of Canada), and Senior Member IEEE and Elsevier since the 90ties. Our key expert chaired international conferences, lectured on several continents, published a book on Reliability and Security of Nuclear Power Plants, contributed to IEEE and PMAPS and published in the Ontario Journal for Public Policy, Canada. She delivered seminars organized by the Power Engineering Society, IEEE plus seminars to power companies worldwide, including Oman, Thailand, Saudi Arabia, Malaysia, Indonesia, Portugal, South Africa, Japan, Romania, and Guyana. Your second expert course leader is the co-founder and Director of Research at Xesto Inc. Xesto is a spatial computing AI startup based in Toronto, Canada and it has been voted as Toronto's Best Tech Startup 2019 and was named one of the top 10 'Canadian AI Startups to Watch' as well as one of 6th International finalists for the VW Siemens Startup Challenge, resulting in a partnership. His latest app Xesto-Fit demonstrates how advanced AI and machine learning is applied to the e-commerce industry, as a result of which Xesto has been recently featured in TechCrunch. He specializes in both applied and theoretical machine learning and has extensive experience in both industrial and academic research. He is specialized in Artificial Intelligence with multiple industrial applications. At Xesto, he leads projects that focus on applying cutting edge research at the intersection of spatial analysis, differential geometry, optimization of deep neural networks, and statistics to build scalable rigorous and real time performing systems that will change the way humans interact with technology. In addition, he is a Ph.D candidate in the Mathematics department at UofT, focusing on applied mathematics. His academic research interests are in applying advanced mathematical methods to the computational and statistical sciences. He earned a Bachelor's and MSc in Mathematics, both at the University of Toronto. Having presented at research seminars as well as instructing engineers on various levels, he has the ability to distill advanced theoretical concept to diverse audiences on all levels. In addition to research, our key expert is also an avid traveler and plays the violin. 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

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

Training duration: 10 hrs Click here for info 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. Autodesk Maya Training Course with our flexible evening training course. Designed to accommodate busy schedules, this course allows you to learn Maya at your convenience, either in-person or through live online sessions. Master essential features and workflows to create captivating 3D models, animations, and visual effects. Benefit from expert guidance, hands-on projects, and lifetime email support, ensuring a rewarding learning experience. Enroll now to ignite your creativity and open doors to exciting opportunities in the animation and visual effects industry. The Autodesk Maya Evening Training Course offers a flexible learning option for busy professionals and students with daytime commitments. Master the powerful tools and capabilities of Autodesk Maya during convenient evening sessions. Participants will receive comprehensive training in 3D modeling, materials, animation, lighting, and rendering. The course progresses to advanced topics, including dynamics, character rigging, shading, and compositing. Enroll in this course to develop valuable skills in 3D computer graphics and animation. Benefit from interactive learning experiences and expert guidance, whether attending in-person or joining live online sessions. Maya Evening Training Courses Duration: 10 hours Course Outline: I. Introduction to Maya (1 hour) Gain insights into Maya's versatile applications and interface. Master navigation and project management. II. Creating 3D Models (2 hours) Learn polygon modeling basics and refine objects with precision. III. Texturing and Materials (1 hour) Apply and customize materials for enhanced visuals. IV. Lighting and Rendering (1.5 hours) Explore lighting techniques and rendering. V. Animation (2.5 hours) Understand animation principles and rig characters. VI. Special Effects (1 hour) Harness particle systems and create captivating effects. VII. Intermediate Modeling Techniques (1 hour) Venture into NURBS modeling and sculpting tools. VIII. Conclusion and Next Steps (0.5 hour) Recap and explore further learning resources. Autodesk Maya Evening Training Course Topics Covered: Modeling, Texturing, Animation, Lighting, Rendering, and more. Download Autodesk Maya! Create expansive worlds, characters, and effects. Subscribe now for a year and start your 3D model and animation journey. Visit https://www.autodesk.co.uk/maya for a free trial. Upon completing the Autodesk Maya Evening Training Course, participants will gain proficiency in 3D modeling, texturing, animation, lighting, and rendering using Autodesk Maya. They will acquire the skills to create captivating visuals and animations, opening up opportunities in diverse industries such as entertainment, gaming, and architectural visualization. The flexible evening schedule allows for convenient learning, accommodating busy professionals and students.

Why AutoCAD Mac Basics-Advanced Training Course? Click here for more info Learn 2D drawing, Plans, Sections, Elevations and advanced features. Choose in-person or live online sessions. Certified tutors, practical exercises, and career advice. Access recorded lessons and lifetime email support.  Duration: 16 hrs. Method: 1-on-1, Personalized attention. Schedule: Tailor your own schedule by pre-booking a convenient hour of your choice, available from Mon to Sat between 9 am and 7 pm. AutoCAD for Mac Essentials to Advanced Training Course: Learn AutoCAD for Mac and master its popular functionalities, tailored for Mac users. Course Highlights: Thorough grounding for beginners in using AutoCAD for Mac. Develop the skills to create precise and high-quality 2D layouts and designs. Generic drawing techniques applicable to all industries. In-class or live online options available. Ideal for newcomers to AutoCAD for Mac, self-taught users, and those transitioning from other CAD tools. Autodesk Certified Tutors: Autocad Mac 1-2-1 training courses. Expert trainers with extensive experience in AutoCAD and various CAD applications. Hands-On Learning: Practical and hands-on training with demonstrations and step-by-step techniques. Support and Prerequisites: Lifetime post-course email support. Good working knowledge of the Mac OS required, no prior CAD experience needed. AutoCAD Mac Course Content: Fundamental Drawing:Creating Basic ObjectsWorking with LinesWorking with ArcsHandling Polylines Object Manipulation Techniques:Utilizing GripsMastering Object SnapsTracking Object Snap PointsEmploying Polar Tracking File Management:Saving Your WorkAuto-backupsUnderstanding Different File Formats (DXF, etc.)Disaster Recovery Accurate Object Creation:Working with UnitsUtilizing Dynamic InputUsing Inquiry Commands for Measurements Object Viewing and Navigation:Zooming TechniquesPanning Techniques Object Manipulation:Selecting Objects in the DrawingNoun/Verb SelectionQuick SelectMoving, Copying, Rotating, Mirroring, and Arraying ObjectsScaling, Trimming, and Extending Objects Organizing Drawings:Managing LayersChanging Object PropertiesExploring the Properties PaletteUsing Different Linetypes Layouts and Annotations:Working with Layouts and Page SetupsScaling Drawing ViewsAnnotating the Drawing with Text and DimensionsCreating MultileadersApplying Hatching to Objects Reusable Content:Creating and Inserting Blocks and SymbolsUsing Tool PalettesWorking with Groups Paper Space and Model Space: Understanding Model Space and Paper Space Creating Layouts and Managing Viewports Setting Viewport Scales Plotting and Output: Plotting Drawings Generating PDF Output Handling Multiple Sheet Drawings Using Plotstyles Drawing Templates and AutoCAD Tools: Creating Drawing Templates Exploring AutoCAD Toolsets Advance Plans, Sections, Elevations and Construction detailing. This course provides comprehensive instruction in AutoCAD, equipping participants with essential skills to create and manage drawings effectively for various design projects.

Empower your parkinson's disease care with comprehensive training from experienced healthcare professionals