Expand your VBA knowledge further and learn some of the more advanced coding features. Course overview Duration: 2 days (13 hours) This course is aimed at experienced VBA users or those who have attended our Part 1 course and have started to use the language. Part 2 expands on the huge array of commands and elements of the data model that can be used and looks at building more complex VBA models Objectives By the end of the course you will be able to: Use comparison operators and system functions Use Arrays Work with ranges Work with the worksheets and workbooks collections and objects Use application objects Use the FileSystemObject Create function procedures Import and save text files Connect to other applications Content Comparison operators Using Comparison operators and functions The LIKE function Wildcards Using SELECT Case System functions The VAL function Case functions Trim functions Text functions Date functions Excel worksheet functions Using Excel functions in VBA Arrays Creating arrays Using arrays Ubound and Lbound Single and multi dimensional arrays Static vs dynamic arrays Working with ranges Creating range objects Passing data between range objects and arrays Using Transpose The Excel object model The object browser Working with collections Collections Creating object variables Setting object variables The For Each . . . Next Loo Sheet collections The worksheets collection The worksheet object The sheets collection Using object Grouping worksheets Using Typename The Workbook collection The workbooks collection Setting workbook variables Application objects Excel default information Display/alerts Screen updating Status bar On Time Using Wait Systems dialog boxes Showing dialog boxes Using dialog boxes Working with files Searching for files and folders The DIR function The FileSystemObject Function procedures Creating functions Adding arguments Calling functions Working with text files Searching for files and folders The DIR function The FileSystemObject Using the FILE and FOLDER collections Sharing data with other applications Early vs Late Binding Setting references to other applications Creating application variables Setting application variables
Getting Started The Master of Business Administration Top Up is a prestigious postgraduate qualification that leading employers highly value. The programme is designed to enhance business managers' strategic thinking and decision-making and develop their critical understanding of business management. The programme is designed for individuals who hold a Qualifi Level 7 Diploma in Strategic Management and Leadership. This programme covers the core business sectors: entrepreneurship, marketing, accounting, statistics, finance, business ethics, business law, managerial economics, business strategy and analysis, operations, administration and communication. This programme, qualified from UK business schools, is well acknowledged and globally respected as it dominates critical thinking and research. MBA can also help you specialise in a new industry you want to move to or in your current sector. This professional qualification improves the chances of progression in a career path. This qualification helps the learner to oversee, supervise and allocate the operations in a business firm. The programme aims to make the candidate capable of understanding the functional aspects of a company and acquiring the skills for communication and decision-making. The MBA Top-Up programme is awarded and delivered 100% online by Anglia Ruskin University. At Anglia Ruskin University, you will study through Canvas, a world-class online Learning Management System (LMS), accessed from your phone, pc or tablet at home or on the move. Canvas provides instant access to study materials, forums, and support from tutors and classmates, as well as enabling easy submission of your assignments. After successfully completing your studies, you'll be invited to attend a graduation ceremony on campus at Anglia Ruskin University. If attending the ceremony in person is not possible, we'll arrange to send your certificate to you. School of Business and Technology London partners with Chestnut Education Group to promote this programme. About Awarding Body Anglia Ruskin University began in 1858 as the Cambridge School of Art founded by William Beaumont. It was then merged with the Cambridge shire College of Arts and Technology and the Essex Institute of Higher Education and was renamed Anglia Polytechnic. It was then given university status in 1992 and renamed Anglia Ruskin University in 2005. The university has campuses in the UK (Cambridge, Chelmsford, London and Peterborough), as well as they are partnered with institutions around the world including Berlin, Budapest, Trinidad, Singapore and Kuala Lumpur. Assessment Major Project No examinations Entry Requirements Qualifi Level 7 Diploma in Strategic Management and Leadership or any equivalent diploma Further, candidates are also required to demonstrate their English language proficiency. Progression An MBA graduate can pursue a fruitful career in many industries. MBA can open career opportunities in various sectors such as banking and financial services, investment banking, management consulting, insurance, hospitality, media, information technology (IT) and marketing. MBA is often a pathway to promotion or a career change as you will gain a professional reputation and develop essential skills in the sector one chooses to pursue. Learners must request before enrolment to interchange unit(s) other than the preselected units shown in the SBTL website because we need to make sure the availability of learning materials for the requested unit(s). SBTL will reject an application if the learning materials for the requested interchange unit(s) are unavailable. Learners are not allowed to make any request to interchange unit(s) once enrolment is complete. Structure MBA Top-Up Programme Structure Dissertation (Major Project) Delivery Methods The MBA Top-Up programme is awarded and delivered 100% online by Anglia Ruskin University. At Anglia Ruskin University, you will study through Canvas, a world-class online Learning Management System (LMS), accessed from your phone, pc or tablet at home or on the move. Canvas provides instant access to study materials, forums, and support from tutors and classmates, as well as enabling easy submission of your assignments. After successfully completing your studies, you'll be invited to attend a graduation ceremony on campus at Anglia Ruskin University. If attending the ceremony in person is not possible, we'll arrange to send your certificate to you. School of Business and Technology London partners with Chestnut Education Group to promote this programme. Resources and Support School of Business & Technology London is dedicated to offering excellent support on every step of your learning journey. School of Business & Technology London occupies a centralised tutor support desk portal. Our support team liaises with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receives a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and streamline all the support processes efficiently. Quality learning materials made by industry experts is a significant competitive edge of the School of Business & Technology London. Quality learning materials comprised of structured lecture notes, study guides, practical applications which includes real-world examples, and case studies that will enable you to apply your knowledge. Learning materials are provided in one of the three formats, such as PDF, PowerPoint, or Interactive Text Content on the learning portal. How does the Online Learning work at SBTL? We at SBTL follow a unique approach which differentiates us from other institutions. Indeed, we have taken distance education to a new phase where the support level is incredibly high.Now a days, convenience, flexibility and user-friendliness outweigh demands. Today, the transition from traditional classroom-based learning to online platforms is a significant result of these specifications. In this context, a crucial role played by online learning by leveraging the opportunities for convenience and easier access. It benefits the people who want to enhance their career, life and education in parallel streams. SBTL's simplified online learning facilitates an individual to progress towards the accomplishment of higher career growth without stress and dilemmas. How will you study online? With the School of Business & Technology London, you can study wherever you are. You finish your program with the utmost flexibility. You will be provided with comprehensive tutor support online through SBTL Support Desk portal. How will I get tutor support online? School of Business & Technology London occupies a centralised tutor support desk portal, through which our support team liaise with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receive a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and to streamline all the support process efficiently. Learners should expect to receive a response on queries like guidance and assistance within 1 - 2 working days. However, if the support request is for assessment feedback, learners will receive the reply with feedback as per the time frame outlined in the Assessment Feedback Policy.
Getting Started The MBA in Educational Leadership and Management programme is a dynamic educational offering that aims to equip future educational leaders with essential skills. This programme is designed for individuals with a Postgraduate (Level 7) Diploma in Educational Management and Leadership or equivalent. This programme places a strong emphasis on effective leadership, educational policy, and management within a variety of educational settings. Graduates from this programme emerge well-prepared to take on leadership roles within academic institutions and drive positive changes in the field of education. The MBA in Educational Leadership and Management empower educators and education professionals with advanced knowledge and skills in leadership and management. This programme presents an excellent opportunity for individuals with a relevant postgraduate diploma or an equivalent qualification to "top up" their credentials to earn a full MBA degree. Throughout this programme, students engage deeply with the intricacies of educational leadership and management, gaining valuable insights into the latest theories, practices, and strategies relevant to the educational sector. The curriculum strongly focuses on critical areas such as leadership theory, organisational management, policy development, and educational change management. The programme provides students with the tools needed to address the complex challenges that educational organisations face today, ultimately enhancing the quality of education. This MBA in Educational Leadership and Management enhances career prospects and actively contributes to improving educational systems. The MBA in Educational Leadership and Management Top Up is awarded and delivered 100% online by Anglia Ruskin University. At Anglia Ruskin University, you will study through Canvas, a world-class online Learning Management System (LMS), accessed from your phone, pc or tablet at home or on the move. Canvas provides instant access to study materials, forums, and support from tutors and classmates, as well as enabling easy submission of your assignments. After successfully completing your studies, you'll be invited to attend a graduation ceremony on campus at Anglia Ruskin University. If attending the ceremony in person is not possible, we'll arrange to send your certificate to you. School of Business and Technology London partners with Chestnut Education Group to promote this programme. About Awarding Body Anglia Ruskin University began in 1858 as the Cambridge School of Art founded by William Beaumont. It was then merged with the Cambridge shire College of Arts and Technology and the Essex Institute of Higher Education and was renamed Anglia Polytechnic. It was then given university status in 1992 and renamed Anglia Ruskin University in 2005. The university has campuses in the UK (Cambridge, Chelmsford, London and Peterborough), as well as they are partnered with institutions around the world including Berlin, Budapest, Trinidad, Singapore and Kuala Lumpur. Assessment Assignments and Project No examinations Entry Requirements Applicant with significant years of experience despite not having formal qualifications. The criteria for admission will be through an interview for those who can demonstrate the skills to cope with the demands of the course. A good command of English (IELTS 6.0 or equivalent). A Postgraduate (Level 7) Diploma in Educational Management and Leadership or equivalent. Learners must request before enrolment to interchange unit(s) other than the preselected units shown in the SBTL website because we need to make sure the availability of learning materials for the requested unit(s). SBTL will reject an application if the learning materials for the requested interchange unit(s) are unavailable. Learners are not allowed to make any request to interchange unit(s) once enrolment is complete. Structure MBA in Educational Leadership and Management Top-Up Programme Structure Developing Effective Management Systems Dissertation (Major Project) Delivery Methods The MBA in Educational Leadership and Management Top Up is awarded and delivered 100% online by Anglia Ruskin University. At Anglia Ruskin University, you will study through Canvas, a world-class online Learning Management System (LMS), accessed from your phone, pc or tablet at home or on the move. Canvas provides instant access to study materials, forums, and support from tutors and classmates, as well as enabling easy submission of your assignments. After successfully completing your studies, you'll be invited to attend a graduation ceremony on campus at Anglia Ruskin University. If attending the ceremony in person is not possible, we'll arrange to send your certificate to you. School of Business and Technology London partners with Chestnut Education Group to promote this programme. Resources and Support School of Business & Technology London is dedicated to offering excellent support on every step of your learning journey. School of Business & Technology London occupies a centralised tutor support desk portal. Our support team liaises with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receives a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and streamline all the support processes efficiently. Quality learning materials made by industry experts is a significant competitive edge of the School of Business & Technology London. Quality learning materials comprised of structured lecture notes, study guides, practical applications which includes real-world examples, and case studies that will enable you to apply your knowledge. Learning materials are provided in one of the three formats, such as PDF, PowerPoint, or Interactive Text Content on the learning portal. How does the Online Learning work at SBTL? We at SBTL follow a unique approach which differentiates us from other institutions. Indeed, we have taken distance education to a new phase where the support level is incredibly high.Now a days, convenience, flexibility and user-friendliness outweigh demands. Today, the transition from traditional classroom-based learning to online platforms is a significant result of these specifications. In this context, a crucial role played by online learning by leveraging the opportunities for convenience and easier access. It benefits the people who want to enhance their career, life and education in parallel streams. SBTL's simplified online learning facilitates an individual to progress towards the accomplishment of higher career growth without stress and dilemmas. How will you study online? With the School of Business & Technology London, you can study wherever you are. You finish your program with the utmost flexibility. You will be provided with comprehensive tutor support online through SBTL Support Desk portal. How will I get tutor support online? School of Business & Technology London occupies a centralised tutor support desk portal, through which our support team liaise with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receive a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and to streamline all the support process efficiently. Learners should expect to receive a response on queries like guidance and assistance within 1 - 2 working days. However, if the support request is for assessment feedback, learners will receive the reply with feedback as per the time frame outlined in the Assessment Feedback Policy.
Getting Started The MSc in Project Management programme is designed for graduates and professionals aiming to pursue or advance their careers in project management. It equips students with the necessary skills and knowledge to effectively plan, develop, manage, and execute complex projects. This comprehensive programme gives students a deep understanding of the project manager role, covering various management processes and practices relevant to project management. Students will gain proficiency in applying their expertise across different sectors. Enrolling in the MSc in Project Management programme enables students to develop the expertise needed to excel in the field and pursue rewarding careers in managing projects effectively. The programme offers an engaging and comprehensive learning experience for individuals seeking career advancement in senior management. The MSc in Project Management (Advanced Entry) delivered by the London Graduate School and awarded by the University of Buckingham through distance learning. School of Business and Technology London partners with LGS to promote this programme with the University of Buckingham. About Awarding Body Buckingham is unique. It is the only independent University in the UK with a Royal Charter and probably the smallest, with around 2,700 students (approx 1,600 on campus). The University campus is well known for being one of the most attractive locations in the region. The Great Ouse River, home to much wildlife, winds through the heart of campus. Each student mixes with over 100 other different nationalities, so being at Buckingham is just like being in a mini global village. These contacts, acquaintances and friendships carry on long after life at Buckingham is over. Ranked Top 10 for Student Satisfaction Ranked Top 10 for Graduate Prospect Recognised by World Education Services (WES) OTHM Qualifications are approved and regulated by Ofqual (Office of Qualifications and Examinations Regulation) and recognised by Qualifications Wales. OTHM qualifications have achieved a reputation for maintaining significant skills in various job roles and industries like Business Studies, Leadership, Tourism and Hospitality Management, Health and Social Care, Information Technology, Accounting and Finance, Logistics and Supply Chain Management. OTHM serves the progression option with several UK universities that acknowledges the ability of learners after studying Level 3-7 qualifications to be considered for advanced entry into corresponding degree year/top-up and Master's/top-up programmes. Regulated by ofqual.gov.uk Recognised by World Education Services (WES) Assessment Assignments and Project No Examinations Entry Requirements A Bachelor's degree or an equivalent or higher qualification. A copy of a valid photo ID. A Statement of Purpose outlines your motivations for joining the course and your career aspirations in project management. An updated Curriculum Vitae (CV) that highlights at least two years of work experience at the graduate level in either a managerial or professional capacity. English Requirements A pass in English at A-level. A Bachelor's degree that was studied and assessed in English. An IELTS overall score of 6.5, with a minimum of 6.0 in each component. A TOEFL score of 72 overall, with a minimum of 18 in reading, 17 in listening, 20 in speaking, and 17 in writing. This includes the TOEFL Home Edition. In addition to the above requirements, all applicants will be scheduled for a live virtual interview with a staff member from the London Graduate School. Learners must request before enrolment to interchange unit(s) other than the preselected units shown in the SBTL website because we need to make sure the availability of learning materials for the requested unit(s). SBTL will reject an application if the learning materials for the requested interchange unit(s) are unavailable. Learners are not allowed to make any request to interchange unit(s) once enrolment is complete. Structure MSc in Project Management Advanced Entry Programme Structure Research Methods Consultancy Project Report Delivery Methods The MSc in Project Management (Advanced Entry) is delivered by the London Graduate School and awarded by the University of Buckingham through distance learning. You will receive excellent support from academic team of London Graduate School, including your programme manager and your supervisor who will be with you every step of the way. Resources and Support School of Business & Technology London is dedicated to offering excellent support on every step of your learning journey. School of Business & Technology London occupies a centralised tutor support desk portal. Our support team liaises with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receives a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and streamline all the support processes efficiently. Quality learning materials made by industry experts is a significant competitive edge of the School of Business & Technology London. Quality learning materials comprised of structured lecture notes, study guides, practical applications which includes real-world examples, and case studies that will enable you to apply your knowledge. Learning materials are provided in one of the three formats, such as PDF, PowerPoint, or Interactive Text Content on the learning portal. How does the Online Learning work at SBTL? We at SBTL follow a unique approach which differentiates us from other institutions. Indeed, we have taken distance education to a new phase where the support level is incredibly high.Now a days, convenience, flexibility and user-friendliness outweigh demands. Today, the transition from traditional classroom-based learning to online platforms is a significant result of these specifications. In this context, a crucial role played by online learning by leveraging the opportunities for convenience and easier access. It benefits the people who want to enhance their career, life and education in parallel streams. SBTL's simplified online learning facilitates an individual to progress towards the accomplishment of higher career growth without stress and dilemmas. How will you study online? With the School of Business & Technology London, you can study wherever you are. You finish your program with the utmost flexibility. You will be provided with comprehensive tutor support online through SBTL Support Desk portal. How will I get tutor support online? School of Business & Technology London occupies a centralised tutor support desk portal, through which our support team liaise with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receive a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and to streamline all the support process efficiently. Learners should expect to receive a response on queries like guidance and assistance within 1 - 2 working days. However, if the support request is for assessment feedback, learners will receive the reply with feedback as per the time frame outlined in the Assessment Feedback Policy.
Getting Started Fast-track your journey to becoming a transformative leader through the MBA Advanced Entry route. This route is designed to expedite your progress towards impactful leadership roles. An MBA is a significant milestone for senior managers and aspiring directors, as it combines essential theoretical knowledge with practical skills needed to lead teams and achieve tangible results effectively. Typically pursued after gaining several years of professional experience, an MBA offers numerous benefits, such as enhanced career prospects, a high professional reputation, and an expanded business network. The programme provides access to a global network, a diverse student community, promising career opportunities, and a rigorous academic curriculum. The MBA Advanced Entry route is tailored for individuals with relevant hands-on management experience, a recognised Postgraduate Diploma (PgD) in management, or a comparable qualification. The programme is designed for individuals aspiring to advance their careers in senior management. It comprises two key components: the Research Methods module and the Consultancy Project Report. The Research Methods module begins with Induction and Research Methods webinars, allowing students to finalise their project research proposals. On the other hand, the Consultancy Project Report module offers an opportunity to explore a specific area of interest within an organisational context. The module emphasises independent thought, continuous learning, and critical reflection. Students must produce a Consultancy Project Report that provides a practical and realistic solution to a strategic business challenge supported by theoretical and conceptual analysis. The MBA Advanced Entry is delivered by the London Graduate School and awarded by the University of Buckingham. School of Business and Technology London partners with the London Graduate School to promote this programme. Throughout the programme, students receive support from the academic team, including a dedicated supervisor to guide them through the Consultancy Project Report module. The MBA Advanced Entry route typically takes 6 to 9 months to complete. Upon successful completion, students are awarded the degree of Master of Business Administration from the University of Buckingham. They also have the option to attend the graduation ceremony held in the UK, commemorating their achievements. The programme aims to provide students with comprehensive support and valuable opportunities for personal and professional growth, ensuring they make the most of their investment in their future. About Awarding Body Buckingham is unique. It is the only independent University in the UK with a Royal Charter and probably the smallest, with around 2,700 students (approx 1,600 on campus). The University campus is well known for being one of the most attractive locations in the region. The Great Ouse River, home to much wildlife, winds through the heart of campus. Each student mixes with over 100 other different nationalities, so being at Buckingham is just like being in a mini global village. These contacts, acquaintances and friendships carry on long after life at Buckingham is over. Ranked Top 10 for Student Satisfaction Ranked Top 10 for Graduate Prospect Recognised by World Education Services (WES) OTHM Qualifications are approved and regulated by Ofqual (Office of Qualifications and Examinations Regulation) and recognised by Qualifications Wales. OTHM qualifications have achieved a reputation for maintaining significant skills in various job roles and industries like Business Studies, Leadership, Tourism and Hospitality Management, Health and Social Care, Information Technology, Accounting and Finance, Logistics and Supply Chain Management. OTHM serves the progression option with several UK universities that acknowledges the ability of learners after studying Level 3-7 qualifications to be considered for advanced entry into corresponding degree year/top-up and Master's/top-up programmes. Regulated by ofqual.gov.uk Recognised by World Education Services (WES) Assessment Assignments and Projects No Examinations Entry Requirements To be eligible for the MBA Advanced Entry route, you must meet the following criteria: OTHM Level 7 Diploma in Strategic Management and Leadership A Bachelor's degree or an equivalent higher qualification. Submission of a copy of your valid photo ID to verify your identity. A well-crafted Statement of Purpose outlining your motivations, career aspirations, and reasons for pursuing the MBA Advanced Entry route. An updated Curriculum Vitae (CV) demonstrating a minimum of two years of work experience at the graduate level, either in a managerial or professional capacity. By meeting these application requirements, you will take the initial steps towards joining the MBA Advanced Entry programme, enabling you to enhance your managerial and leadership skills significantly. English Requirements A pass in English at the A level. Completion of a Bachelor's degree programme conducted and assessed in English. An overall score of 6.5 or higher in the International English Language Testing System (IELTS) with a minimum score of 6.0 in each component. A Test of English as a Foreign Language (TOEFL) score of 72 or higher, with a minimum of 18 in reading, 17 in listening, 20 in speaking, and 17 in writing. This includes scores from the Home Edition of TOEFL. In addition to the requirements above, all applicants must participate in a live virtual interview with a staff member from the London Graduate School. Progression An MBA graduate can pursue a fruitful career in many industries. MBA can open career opportunities in various sectors such as banking and financial services, investment banking, management consulting, insurance, hospitality, media, information technology (IT) and marketing. An MBA is often a pathway to promotion or a career change as you will gain a professional reputation and develop essential skills in the sector you choose to pursue. Learners must request before enrolment to interchange unit(s) other than the preselected units shown in the SBTL website because we need to make sure the availability of learning materials for the requested unit(s). SBTL will reject an application if the learning materials for the requested interchange unit(s) are unavailable. Learners are not allowed to make any request to interchange unit(s) once enrolment is complete. Structure MBA Advanced Entry Programme Structure Research Methods Consultancy Project Report Delivery Methods The MBA Advanced Entry delivered by London Graduate School, awarded by the University of Buckingham through distance learning. You will receive excellent support from academic team of London Graduate School, including your programme manager and your supervisor who will be with you every step of the way. Resources and Support School of Business & Technology London is dedicated to offering excellent support on every step of your learning journey. School of Business & Technology London occupies a centralised tutor support desk portal. Our support team liaises with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receives a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and streamline all the support processes efficiently. Quality learning materials made by industry experts is a significant competitive edge of the School of Business & Technology London. Quality learning materials comprised of structured lecture notes, study guides, practical applications which includes real-world examples, and case studies that will enable you to apply your knowledge. Learning materials are provided in one of the three formats, such as PDF, PowerPoint, or Interactive Text Content on the learning portal. How does the Online Learning work at SBTL? We at SBTL follow a unique approach which differentiates us from other institutions. Indeed, we have taken distance education to a new phase where the support level is incredibly high.Now a days, convenience, flexibility and user-friendliness outweigh demands. Today, the transition from traditional classroom-based learning to online platforms is a significant result of these specifications. In this context, a crucial role played by online learning by leveraging the opportunities for convenience and easier access. It benefits the people who want to enhance their career, life and education in parallel streams. SBTL's simplified online learning facilitates an individual to progress towards the accomplishment of higher career growth without stress and dilemmas. How will you study online? With the School of Business & Technology London, you can study wherever you are. You finish your program with the utmost flexibility. You will be provided with comprehensive tutor support online through SBTL Support Desk portal. How will I get tutor support online? School of Business & Technology London occupies a centralised tutor support desk portal, through which our support team liaise with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receive a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and to streamline all the support process efficiently. Learners should expect to receive a response on queries like guidance and assistance within 1 - 2 working days. However, if the support request is for assessment feedback, learners will receive the reply with feedback as per the time frame outlined in the Assessment Feedback Policy.
About this Course This 5 full-day course provides a comprehensive understanding of all the commissioning procedures for combined cycle power plants. The Commissioning Management System (CMS) of combined cycle 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 gas turbines, steam 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 combined cycle power plant, instrumentation, trial run of the equipment, safety and precautions, commissioning of combined cycle power plant systems, safety rules clearance certificates, procedure for the control and handling of defects, commissioning reports, operational testing, first fire, generator synchronization, performance testing, heat rate testing, emission testing, contract testing, CO2 concentration tests, electrical full-load rejection test, duct burner testing, partial load stability test, and reliability test. This course is a MUST for anyone who is involved in the pre-commissioning or commissioning of any combined cycle power plant equipment because it provides detailed pre-commissioning checks and tests, and detailed tests and commissioning procedures and instructions for every component in a combined cycle power plant. In addition, the seminar provides an in-depth coverage of all preparation, planning activities, commissioning schedules, trial run of each combined cycle 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 Combined Cycle Power Plants: Gain a thorough understanding of all pre-commissioning checks and tests, and all commissioning procedures and instructions for every equipment in combined cycle power plants Commissioning Management System (CMS) of Combined Cycle Power Plants: Discover the benefits of the CMS of combined cycle 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 Heat Recovery Steam Generators, Air Blow and Steam Blow of Steam and Gas Piping in Combined Cycle Power Plants: Learn about the commissioning procedures and instructions for heat recovery steam generators, chemical cleaning of heat recovery steam generators, air blow and gas blow of steam and gas piping in combined cycle power plants, safety valve setting and soot blowers Commissioning Procedures and Instructions for Gas Turbines and Steam Turbines: Gain a thorough understanding of all the commissioning procedures and instructions for gas and steam turbines 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 start-up of generators 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 Operational Testing, Performance Testing, Heat Rate Testing, Emission Testing of Combine Cycle Power Plants: Gain a thorough understanding of operational testing, first fire, generator synchronization, performance testing, heat rate testing, emission testing, contract testing, CO2 concentration tests, electrical full-load rejection test, duct burner testing, partial load stability test, and reliability test of combined cycle power plants Target Audience Engineers of all disciplines Managers Technicians Maintenance personnel Other technical individuals Training Methods The instructor relies on a highly interactive training method to enhance the learning process. This method ensures that all the delegates gain a complete understanding of all the 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. 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
Helping customers buy products or services from retail organisations such as department stores, garden centres, high street chains, supermarkets and online and mail order businesses.
Scottish Gaelic Beginner Conversation Course for online learners worldwide.
Nursery School teacher Training is a complete course that imparts the systems, ways and process needed to educate children at Primary, Pre Primary, Montessori and Nursery Schools. You can pursue the course from any part of the world without worrying about time constraints since we offer Class room ( Offline), online and distance learning mode. A aspirant can choose between any of the three modes of learning. The course puts special emphasis on “ Child Psychology ” that a school teacher has to know to educate children. therefore, the Nursery school teacher Training is a complete course which enables one to become a skilled & Resourceful school teacher.