746 Courses in London

Blue CSCS Card NVQ Level 2 Craft This qualification provides you with the opportunity to showcase their knowledge, skills and understanding in their chosen craft. You will have the relevant experience in one of the trade specific areas. You will work in one of the following areas: Trowel Occupations (Bricklayer) Building Maintenance Painting and Decorating Wall and Floor Tiling Stone Masonry Wood Occupations (site Carpentry) Plastering Roofing Induction - As soon as you register you will be given a dedicated assessor. They will arrange an induction and together with your assessor, you will get to decide on the pathway which best proves your competency. The induction is used to plan out how you will gather the relevant evidence to complete the course. During the course - The assessor will work with you to build a portfolio of evidence that allows you to showcase your knowledge, skills and experience. The assessor will also regularly review and provide you with feedback. This will allow you to keep on track to progress quickly. You will be assessed through various methods such as observations, written questions, evidence generated from the workplace, professional discussion, and witness testimonials. On completion - Once all feedback has been agreed, the Internal Quality Assurer will review your portfolio and in agreement with your assessor the certificate will be applied for. To download our PDF for this course then please click here.

Blue CSCS Card NVQ Level 2 Craft This qualification provides you with the opportunity to showcase their knowledge, skills and understanding in their chosen craft. You will have the relevant experience in one of the trade specific areas. You will work in one of the following areas: Trowel Occupations (Bricklayer) Building Maintenance Painting and Decorating Wall and Floor Tiling Stone Masonry Wood Occupations (site Carpentry) Plastering Roofing Induction - As soon as you register you will be given a dedicated assessor. They will arrange an induction and together with your assessor, you will get to decide on the pathway which best proves your competency. The induction is used to plan out how you will gather the relevant evidence to complete the course. During the course - The assessor will work with you to build a portfolio of evidence that allows you to showcase your knowledge, skills and experience. The assessor will also regularly review and provide you with feedback. This will allow you to keep on track to progress quickly. You will be assessed through various methods such as observations, written questions, evidence generated from the workplace, professional discussion, and witness testimonials. On completion - Once all feedback has been agreed, the Internal Quality Assurer will review your portfolio and in agreement with your assessor the certificate will be applied for. To download our PDF for this course then please click here.

This is the Alan d signature course. Aimed at barbers returning to the industry or experience barbers feeling ‘bogged down’ with their everyday routine and looking for inspiration. It’s also ideal for those trained in Ladies Hairdressing who haven’t been formally trained in the latest barbering techniques. You will learn the 5 Alan d Foundation Barbering haircuts along with use of clippers, fading, and beard & moustache trimming.

Certified Business Analysis Professional™ (CBAP®) Boot Camp: In-House Training The course provides targeted exam preparation support for IIBA® Level 3 - CBAP® exam candidates, including both a BABOK® Guide Version 3.0 content review and exam preparation tutorial. The class is interactive, combining discussion, application of concepts, study tips, and a practice exam. Knowledge Check quizzes and self-assessments allow candidates to identify areas of weakness and create a custom study plan tailored to their individual needs as well as study aids to support their exam preparation after the course. The course materials include a copy of A Guide to the Business Analysis Body of Knowledge® (BABOK® Guide) Version 3.0. What you will Learn Upon completion, participants will be able to: Demonstrate familiarity with the structure and content of the IIBA® BABOK® Guide Improve their probability of passing the Level 3 - CBAP® Exam Identify their knowledge gaps through the use of module Knowledge Check quizzes Gauge their readiness for taking the exam by IIBA® BABOK® Guide Knowledge Are Foundation Concepts for IIBA® CBAP® Prep IIBA® - the Organization Business Analysis - the Profession Knowledge Check Terminology and Key Concepts IIBA®'s BABOK® Guide - the Standard Underlying Competencies BA Techniques Business Analysis Planning and Monitoring Knowledge Check Overview BAP&M Tasks BAP&M Techniques Elicitation and Collaboration Knowledge Check Overview E&C Tasks E&C Techniques Requirements Life Cycle Management Knowledge Check Overview RLCM Tasks RLCM Techniques Strategy Analysis Knowledge Check Overview SA Tasks SA Techniques Requirements Analysis and Design Definition Knowledge Check Overview RA&DD Tasks RA&DD Techniques Solution Evaluation Knowledge Check Overview SE Tasks SE Techniques Exam Preparation Practice Exam and debrief Exam Preparation Study Tips Manage Study Plan Exam Process Exam day

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

3ds max face to face training customised and bespoke. Live online or Face to Face.

Develop true expertise with our DMI Specialist, Learn social strategy, research and content from industry Skills Experts. Get the latest platform knowledge and strategies including Tik-Tok, Twitch and WeChat. Course Overview Develop true expertise and learn every aspect of Social Media Marketing across 10 modules of interactive content such as Facebook, LinkedIn, Snapchat, YouTube and Instagram. Gain relevant and deep knowledge of social strategy, research and content from industry skills experts. Become a certified social media marketing specialist: Join over 200,000 members around the world, working for some of the world’s top companies using DMI to keep their careers and skills relevant. 81% of our members have been promoted upon completion of one of our courses and 53% have got a salary increase. Get certified with the DMI SPECIALIST digital marketing certification and become a professional digital marketer. Get world class, specialist knowledge and insight: Develop true expertise with our DMI Specialist, Learn social strategy, research and content from industry Skills Experts. Get the latest platform knowledge and strategies including Tik-Tok, Twitch and WeChat. With 10 modules focused on every aspect of social media marketing, DMI Specialist is the most comprehensive Social Media Course available anywhere. Program learning outcomes and content: What Will I Learn? Get the know-how, experience and the insights to be able to work and speak with authority in this face-paced industry. In short, you’ll be a skilled digital marketer, capable of building digital marketing strategies from scratch. We’ve added 8 new soft skill lessons to give you the most industry ready certification available, anywhere. Who is this for? The DMI Specialist Social is for individuals who are responsible for social media marketing campaigns. This includes: • Digital marketing generalists • Marketing Specialists • Marketing Managers • Content creators • Social media consultants • Individuals pursuing profession in social media marketing. • Anyone who wants a career change Course Content: Social Research: Just who are your audience? What do they do, think, feel, eat, love, hate and ‘like’? And what do they think about you? Knowledge is power. And both knowledge and power are fascinating. This module gives you the research techniques to know your audience, and cultural and industry trends. Every day the very people you want to reach throw up gigantic amounts of data. Without the right tools and thinking, it’s a critical mass of meaningless banality. With the right tools and thinking, you have insight deep into hearts and souls. Delve into these tools and put them to use, including the new Google Analytics 4 platform. Social Content: Facebook kittens. Twitter debates. Instagram filters. People can’t get enough content on social media – so better content means better opportunities. So, what does your audience want to see, like and share? With streamlined planning, clever strategy and targeted scheduling, putting the right content in front of the right people is no longer a shot in the dark! Now, you can create amazing content formats that capture the attention of audiences across all social platforms. You can strategize and plan using cutting-edge tools that make your channels stand out from all the others. This module covers the various content formats across platforms, the power and practice of scheduling content and how you can bring it all together with super strategies. Facebook, Instagram and Pinterest: Facebook, Instagram and Pinterest are powerhouses of the social media world. They provide you and your brand with the chance to interact with your customers across the globe at scale. But, each of them has unique features, analytics, and quirks. The module gives you a deep understanding of how these platforms work, how to make your brand stand out in these different spaces, and why you need a spread of messaging across each to succeed. • Build an active, engaged and captive community across each channel. • Create compelling and clever ads that target your audience at the right time. • Use analytics to understand what your audience is doing. Then tweak your content to resonate in all the right ways. • Master the key features of each channel to advertise, strategize and optimize. • Manage each platform so you get the best reach and results. • Reach billions of social loving people every day! Twitter: Twitter marches to its own drum in the social media world – less post and wait, more what’s happening right now. It’s a platform that allows your audience to see, report and comment on world events in almost real-time. It’s also a place where the audience is young, wealthy and educated. Twitter literally challenges you to be ‘more clever’, and this module shows you how. • What a successful Twitter account looks and acts like. • How to use Twitter Ads Manager to advertise effectively. • The right Twitter Ad format for your campaign. • Using Twitter Analytics to react and connect better. • How to create more Tweet-friendly content – snappy, shareable and short. • When to post for maximum impact and engagement. LinkedIn: This module will introduce you to the platform and show you how to use features such as Company pages and Showcase pages, to create a stellar presence for your company – and gain a deep understanding of what that means on LinkedIn. You will understand the unique advertising features and content formats on offer such as Text ads, Sponsored ads, Sponsored InMails, Display ads, and the aptly named Dynamic ads. See what best practice means on this platform, strategize like a CEO and measure the effectiveness of your campaigns. Linkedin can be a tricky platform to master as the tone is hard to crack. But do Linkedin well and your competitors will be scrambling to copy you! You’ve got this – because we do. YouTube & Social Video: YouTube because you have eyes to see. And a picture speaks a thousand words – and this being social, should inspire a few thousand too. Social video is one of the most awesome tools in your new bag of digital tricks. And video is no longer the preserve of guys with film study degrees. This superpower is now yours, and here we give you all the tech and thought basics to make it happen, including how to set up and manage a YouTube channel and create strategies that don’t treat creativity like a buzzword. Learn how video sits within the rest of your mix across platforms, build your online audience and use advertising and analytics for visual campaigns that mesmerise. • Set up and manage a dynamic YouTube channel. • Get creative with social video strategies that engage and convert. • Learn how video sits within the rest of your social media mix. • Build and develop your online audience in a way that benefits your brand. • Use advertising and analytics to deliver mesmerizing visual. Social Apps: If you’re looking to create a buzz online, then social apps are the place to be. Think fun, engaging, and ‘out of the box’ as that’s what these platforms are made for and audiences flock to them (particularly a young demographic). Discover how to use TikTok, Snapchat, WeChat, WhatsApp, and Twitch to tune into your audience effectively. Take a dive into features and understand how to manage content to make the most of everything you post. You’ll also understand how to advertise on the apps that suit your brand. Plus, take inspiration from the best by seeing what campaigns worked and why, so you can TikTok your way to social success. Social Commerce and Affiliate Marketing: With so many eyes on social media, it pays (literally) to know how to market and sell your products online. Social commerce happens when an astute marketer combines the best of social media with the best of e-commerce. You’ll explore the ins and outs of social commerce along with how to create a successful online shop. The latest tactics and tools will be covered so you can make social buying seamless from the first click to the last. You’ll also explore how to optimize paid commerce activity – including cart abandonment – to get the best results. Looking for a way to earn extra money while you grow? Use your social media to tap into affiliate marketing – a great way to earn commission by promoting another company’s products or brand you admire. When it comes to influencing, social media allows you to think BIG. Tap into the world of social influencers by connecting and collaborating with people that think like you. Or reach out to your influencer crush and shine a light on your brand by getting into their social feed. Social Customer Service: One of the best dynamics of social media is how it manages to be collective – the thoughts of billions – yet also personal (it’s about what I ‘like’). This leaves scope for important personal interaction – meaning social customer service is an opportunity for your brand to stand out. This module examines the customer experience. It looks at how to break your audience down into buyer personas so you know them better – and so serve them better. It shows you which platforms do service best and how. Need a social customer service strategy? – no problem. Want to understand how to manage social customer service effectively? – that’s easy. Not sure how to measure and analyze customer service performance? – well, you will now! This module focuses on your customer’s happiness so you can build a contented online community. An audience that feels connected to your brand, so they’ll tell everyone else how great it really is. Social Strategy: So, you have the skills, tools, followers, know-how, tech, smarts and big ideas. Now learn to tie it all together with cutting-edge social strategies practiced by the world’s leading brands. And work out how your social offering sits with – or carries – the rest of your marketing mix. Here we look at planning a dynamic social media strategy that works for you. We dive into setting objectives and social KPIs so you know what you want and can track how you’re getting there. Social media and content production budgets are also explored so you put your money in the places that work, rather than those that don’t. Turn your social media dream into a reality by crafting a social strategy that lets you and your brand sparkle. DURATION 8-10 Weeks WHATS INCLUDED Course Material Case Study Experienced Lecturer Refreshments Certificate

About this training course This 5 full-day course provides a comprehensive understanding of all the commissioning and start-up activities of all electrical equipment including transformers, switchgear, induction and synchronous motors, generators and auxiliaries. All commissioning activities are covered in detail in this course. This includes all the commissioning procedures and documents, purpose of commissioning, responsibilities, system description, documentation, testing and commissioning schedules, test reports, safety, certification, and plant completion report. The course provides also a thorough understanding of all the commissioning requirements for transformers, switchgear, induction and synchronous motors and, generator and auxiliaries including its switchgear equipment, switchgear, and transformers. All the stages of the commissioning procedure are covered in-depth in this course. This includes preparation - planning various activities, pre-commissioning checks and tests, typical commissioning schedule, detailed tests and commissioning procedures for every type of transformers, switchgear, induction and synchronous motors, and generators and auxiliary systems, instrumentation, trial run of the equipment, safety and precautions, commissioning of electrical systems, Safety Rules Clearance Certificates, procedure for the control and handling of defects, Commissioning Reports. This course is a MUST for anyone who is involved in the pre-commissioning or commissioning of any electrical equipment because it provides detailed pre-commissioning checks and tests and detailed tests and commissioning procedures for every electrical equipment. In addition, the course provides in-depth coverage of all preparation, planning activities, commissioning schedules, trial run of each electrical equipment, safety and precautions, Safety Rules Clearance Certificates, Procedures for handling defects, and Commissioning Reports. Training Objectives Pre-Commissioning Checks and Tests, Detailed Tests and Commissioning Procedures and Instructions for all Electrical Equipment: Gain a thorough understanding of all pre-commissioning checks and tests, and all commissioning procedures and instructions for all electrical equipment Commissioning Procedures, Documents, and Certification of Electrical Equipment: Discover the benefits of the Commissioning Management System of electrical equipment including all commissioning procedures and documents, purpose of commissioning, responsibilities, system description, documentation, testing and commissioning schedules, test reports, safety, equipment certification, and commissioning completion report Commissioning Procedures for Transformers: Learn about the commissioning procedures for transformers including functional checks, pre-commissioning tests, commissioning tests, and records. Commissioning Procedures for Switchgear Assemblies: Gain a thorough understanding of all the commissioning procedures for switchgear assemblies including substation commissioning, electrical testing, code requirements, safety rules, grounding and shorting, high power testing, NETA acceptance testing procedures, test values analysis, and commissioning forms Commissioning Procedures for Generator and Auxiliaries: Discover all the commissioning procedures for generator and auxiliaries including generator, seal oil system, hydrogen gas system, stator water system, rolling and payment of generator Commissioning Procedures and Instructions for Generator Electrical Equipment: Learn about all the commissioning procedures and instructions for generator electrical equipment including switchyard equipment, switchgear, transformers, and motors Code Requirements for Commissioning Electrical Equipment and Systems: Learn about the code requirements for commissioning transformers, switchgear, inductions and synchronous motors, and generators and auxiliaries Target Audience Engineers of all disciplines Managers Technicians Maintenance personnel Other technical individuals Course Level Basic or Foundation Training Methods Your specialist course leader relies on a highly interactive training method to enhance the learning process. This method ensures that all participants gain a complete understanding of all topics covered. The training environment is highly stimulating, challenging, and effective because the participants will learn by case studies which will allow them to apply the material taught to their own organization. Each delegate will receive a copy of the following materials written by the instructor: 'ELECTRICAL EQUIPMENT HANDBOOK' published by McGraw-Hill in 2003 (600 pages) ELECTRICAL EQUIPMENT COMMISSIONING MANUAL (includes practical information about all pre-commissioning checks and tests, typical commissioning schedule, detailed tests and commissioning procedures and instructions for all electrical equipment - 500 pages) Trainer Your specialist course leader has more than 32 years of practical engineering experience with Ontario Power Generation (OPG), one of the largest electric utility in North America. He was previously involved in research on power generation equipment with Atomic Energy of Canada Limited at their Chalk River and Whiteshell Nuclear Research Laboratories. While working at OPG, he acted as a Training Manager, Engineering Supervisor, System Responsible Engineer and Design Engineer. During the period of time, he worked as a Field Engineer and Design Engineer, he was responsible for the operation, maintenance, diagnostics, and testing of gas turbines, steam turbines, generators, motors, transformers, inverters, valves, pumps, compressors, instrumentation and control systems. Further, his responsibilities included designing, engineering, diagnosing equipment problems and recommending solutions to repair deficiencies and improve system performance, supervising engineers, setting up preventive maintenance programs, writing Operating and Design Manuals, and commissioning new equipment. Later, he worked as the manager of a section dedicated to providing training for the staff at the power stations. The training provided by him covered in detail the various equipment and systems used in power stations. In addition, he has taught courses and seminars to more than four thousand working engineers and professionals around the world, specifically Europe and North America. He has been consistently ranked as 'Excellent' or 'Very Good' by the delegates who attended his seminars and lectures. He written 5 books for working engineers from which 3 have been published by McGraw-Hill, New York. Below is a list of the books authored by him; Power Generation Handbook: Gas Turbines, Steam Power Plants, Co-generation, and Combined Cycles, second edition, (800 pages), McGraw-Hill, New York, October 2011. Electrical Equipment Handbook (600 pages), McGraw-Hill, New York, March 2003. Power Plant Equipment Operation and Maintenance Guide (800 pages), McGraw-Hill, New York, January 2012. Industrial Instrumentation and Modern Control Systems (400 pages), Custom Publishing, University of Toronto, University of Toronto Custom Publishing (1999). Industrial Equipment (600 pages), Custom Publishing, University of Toronto, University of Toronto, University of Toronto Custom Publishing (1999). Furthermore, he has received the following awards: The first 'Excellence in Teaching' award offered by PowerEdge, Singapore, in December 2016 The first 'Excellence in Teaching' award offered by the Professional Development Center at University of Toronto (May, 1996). The 'Excellence in Teaching Award' in April 2007 offered by TUV Akademie (TUV Akademie is one of the largest Professional Development centre in world, it is based in Germany and the United Arab Emirates, and provides engineering training to engineers and managers across Europe and the Middle East). Awarded graduation 'With Distinction' from Dalhousie University when completed Bachelor of Engineering degree (1983). Lastly, he was awarded his Bachelor of Engineering Degree 'with distinction' from Dalhousie University, Halifax, Nova Scotia, Canada. He also received a Master of Applied Science in Engineering (M.A.Sc.) from the University of Ottawa, Canada. He is also a member of the Association of Professional Engineers in the province of Ontario, Canada. 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 post training support and fees applicable Accreditions And Affliations

About this training course This 5 full-day course provides a comprehensive understanding of all the commissioning and start-up activities of circulating fluidized bed (CFB) boiler coal power plants. The Commissioning Management System of CFB boiler coal power plants is covered in detail in this course. This includes all the commissioning procedures and documents, purpose of commissioning, responsibilities, system description, organization, working parties, test teams, documentation, testing and commissioning schedules, test reports, safety, plant certification, and plant completion report. The course provides also a thorough understanding of all the commissioning requirements for CFB boiler and auxiliaries, turbines and auxiliaries, generator and auxiliaries, electrical equipment, switchgear equipment, switchgear, and transformers. All the stages of the commissioning procedure are covered in-depth in this course. This includes preparation - planning various activities, pre-commissioning checks and tests, typical commissioning schedule, detailed tests and commissioning procedures and instructions for every component in a coal power plant, instrumentation, trial run of the equipment, safety and precautions, commissioning of CFB boiler coal power plant systems, Safety Rules Clearance Certificates, procedure for the control and handling of defects, Commissioning Reports. This course is a MUST for anyone who is involved in the pre-commissioning or commissioning of any CFB boiler coal power plant equipment because it provides detailed pre-commissioning checks and detailed tests and commissioning procedures and instructions for every component in a CFB boiler coal power plant. In addition, the course provides in-depth coverage of all preparation, planning activities, commissioning schedules, trial run of each CFB boiler coal power plant equipment, safety and precautions, Safety Rules Clearance Certificates, Procedures for handling defects, and Commissioning Reports. Training Objectives Pre-Commissioning Checks and Tests, Detailed Tests and Commissioning Procedures and Instructions for Every Equipment in CFB Boiler Coal Power Plants: Gain a thorough understanding of all pre-commissioning checks and tests, and all commissioning procedures and instructions for every equipment in CFB boiler coal power plants Commissioning Management System of CFB Boiler Coal Power Plants: Discover the benefits of the Commissioning Management System of CFB boiler coal power plants including all commissioning procedures and documents, purpose of commissioning, responsibilities, system description, organization, working parties, test teams, documentation, testing and commissioning schedules, test reports, safety, plant certification, and plant completion report Commissioning Procedures and Instructions for CFB Boiler and Auxiliaries in Coal Power Plants: Learn about the commissioning procedures and instructions for CFB boiler and auxiliaries including all commissioning activities, typical commissioning schedule, hydraulic test and wet preservation, air and gas tightness test, trial run of equipment, electronic precipitators, fuel oil system, preparation for first light up, alkali boil - out, acid cleaning and passivation, thermal flow test of economizer, water walls, and superheater, valves, steam boiling, and safety valve setting Commissioning Procedures and Instructions for Turbine and Auxiliaries: Gain a thorough understanding of all the commissioning procedures and instructions for turbine and auxiliaries including acid cleaning of oil pipelines, lubrication and governing system (oil flushing and hydraulic testing), jacking oil system, governing system, regenerative system, barring gear, vacuum tightness test, first rolling of turbine and data logging Commissioning Procedures and Instructions for Generator and Auxiliaries: Discover all the commissioning procedures and instructions for generator and auxiliaries including generator, seal oil system, hydrogen gas system, stator water system, rolling and payment of generator Commissioning Procedures and Instructions for Electrical Equipment: Learn about all the commissioning procedures and instructions for electrical equipment including switchyard equipment, switchgear, transformers, and motors CFB Boiler Coal Power Plant Equipment and Systems: Learn about various CFB boiler coal power plant equipment and systems including: CFB boilers, superheaters, reheaters, steam turbines, governing systems, deaerators, feedwater heaters, coal-handling equipment, transformers, generators and auxiliaries Target Audience Engineers of all disciplines Managers Technicians Maintenance personnel Other technical individuals Training Methods Your specialist course leader relies on a highly interactive training method to enhance the learning process. This method ensures that all participants gain a complete understanding of all topics covered. The training environment is highly stimulating, challenging, and effective because the participants will learn by case studies which will allow them to apply the material taught to their own organization. Each delegate will receive a copy of the following materials written by the instructor: 'POWER GENERATION HANDBOOK' second edition published by McGraw-Hill in 2012 (800 pages) Excerpt of the relevant chapters from the 'POWER PLANT EQUIPMENT OPERATION AND MAINTENANCE GUIDE' published by McGraw-Hill in 2012 (800 pages) CFB BOILER COAL POWER PLANT COMMISSIONING MANUAL (includes practical information about all pre-commissioning checks and tests, typical commissioning schedule, detailed tests and commissioning procedures and instructions for every component and system in CFB boiler coal power plants - 400 pages) Trainer Your specialist course leader has more than 32 years of practical engineering experience with Ontario Power Generation (OPG), one of the largest electric utility in North America. He was previously involved in research on power generation equipment with Atomic Energy of Canada Limited at their Chalk River and Whiteshell Nuclear Research Laboratories. While working at OPG, he acted as a Training Manager, Engineering Supervisor, System Responsible Engineer and Design Engineer. During the period of time, he worked as a Field Engineer and Design Engineer, he was responsible for the operation, maintenance, diagnostics, and testing of gas turbines, steam turbines, generators, motors, transformers, inverters, valves, pumps, compressors, instrumentation and control systems. Further, his responsibilities included designing, engineering, diagnosing equipment problems and recommending solutions to repair deficiencies and improve system performance, supervising engineers, setting up preventive maintenance programs, writing Operating and Design Manuals, and commissioning new equipment. Later, he worked as the manager of a section dedicated to providing training for the staff at the power stations. The training provided by him covered in detail the various equipment and systems used in power stations. In addition, he has taught courses and seminars to more than four thousand working engineers and professionals around the world, specifically Europe and North America. He has been consistently ranked as 'Excellent' or 'Very Good' by the delegates who attended his seminars and lectures. He written 5 books for working engineers from which 3 have been published by McGraw-Hill, New York. Below is a list of the books authored by him; Power Generation Handbook: Gas Turbines, Steam Power Plants, Co-generation, and Combined Cycles, second edition, (800 pages), McGraw-Hill, New York, October 2011. Electrical Equipment Handbook (600 pages), McGraw-Hill, New York, March 2003. Power Plant Equipment Operation and Maintenance Guide (800 pages), McGraw-Hill, New York, January 2012. Industrial Instrumentation and Modern Control Systems (400 pages), Custom Publishing, University of Toronto, University of Toronto Custom Publishing (1999). Industrial Equipment (600 pages), Custom Publishing, University of Toronto, University of Toronto, University of Toronto Custom Publishing (1999). Furthermore, he has received the following awards: The first 'Excellence in Teaching' award offered by PowerEdge, Singapore, in December 2016 The first 'Excellence in Teaching' award offered by the Professional Development Center at University of Toronto (May, 1996). The 'Excellence in Teaching Award' in April 2007 offered by TUV Akademie (TUV Akademie is one of the largest Professional Development centre in world, it is based in Germany and the United Arab Emirates, and provides engineering training to engineers and managers across Europe and the Middle East). Awarded graduation 'With Distinction' from Dalhousie University when completed Bachelor of Engineering degree (1983). Lastly, he was awarded his Bachelor of Engineering Degree 'with distinction' from Dalhousie University, Halifax, Nova Scotia, Canada. He also received a Master of Applied Science in Engineering (M.A.Sc.) from the University of Ottawa, Canada. He is also a member of the Association of Professional Engineers in the province of Ontario, Canada. 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 post training support and fees applicable Accreditions And Affliations

Course Objectives The goal of this course is to provide you with the knowledge required to use more advanced functions and formulas and work with various tools to analyse and present data in spreadsheets, such as sorting, filtering, applying conditional formatting and charting the data. ' 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 in formulas + vlookup and shortcut keys. Jenny Price - Acer 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk 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. Tailored training courses: In, 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. Recap on Excel formulas and calculations Overview of formulas in Excel Relative, Absolute and Mixed cell references Group editing worksheets Autofill and Flash Fill Changing Excel’s environment Options Changing the default number of sheets Creating an Autofill Custom List Adding tools to the Quick Access Toolbar Mastering Excel Tables Introducing Excel Tables Formatting a Table Creating Calculated Columns Using Slicers to filter your data Using Totals to get statistics out of your data Removing duplicates Converting Tables back to normal Ranges Using names Ranges In Excel formulas As a way of navigating through the workbook Advanced Formulas Simple IF examples Using IF to check if a cell is blank Nested IFs VLOOKUP HLOOKUP Text Functions Date Functions Conditional formatting Apply Conditional Formatting Customising Conditional Formatting Using Icons in Conditional Formatting Using Formulas to conditionally format cells Linking spreadsheets and workbooks Making a reference to another worksheet Making a reference to another workbook Editing links Troubleshooting links Analysing databases Quick analysis Sorting a database Apply filters to a database Advance filter Sorting and Filtering by Conditional Formats Charts Analyse trends in data using Sparklines Creating charts from start to finish Exploring the different Chart Types Apply Chart Styles Formatting Chart Elements Filtering Charts by Series or Categories Adding a Trendline to a Chart Create a Chart Template Attaching security to a spreadsheet and workbook Protect Cells Protect Structure of worksheets Protect a Workbook by adding passwords Introduction to Pivot Tables What are Pivot Tables? Using recommended pivot tables to analyse your data Who is this course for? Who is this course for? For those who want to explore in more detail formulas and functions, data analysis and data presentation. Requirements Requirements Preferably, delegates would have attended the Excel Introduction 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