Programs and Courses
OptionTrain offers a wide variety of programs and courses built on adaptive curriculum and led by leading industry experts.
Filter by
Excel-I (Basic)
The Excel-I (Basic) course offered at OptionTrain.com provides a course that takes the learner through the basics of Microsoft Excel. This program is broken down into eight units: an overview of Excel, data input, functions, and formulas, working with worksheets, charts, sorting and filtering data, PivotTables, and a summary, quiz. You will be introduced to the basic functionalities of Excel, how to perform calculations, create charts, and acquire basic data management skills. At the end of this course, you will be in an excellent position to perform most Excel functions, from data entry to data analysis. Come and discover how Excel can help you in your daily and working life.
Excel-II (Intermediate)
The Excel-II (Intermediate) course offered at OptionTrain.com provides a course on Microsoft Excel skills with an emphasis on advanced functions, data analysis, and automation. First, we briefly refresh the general Excel knowledge, providing tips on how to move around the worksheet and type in the data effectively. Next, you will learn more complex functions and formulas, such as logical functions, lookup and text functions, and nesting. Learn how to apply data validation rules and safeguard your worksheets and workbooks. Learn about more complex data visualization methods and data analysis tools such as What-If Analysis and Solver. Learn how macros can help you automate your work and how data consolidation and collaboration work. The course concludes with a final summary and an open discussion to ensure you are prepared for the next steps in your Excel experience.
Excel-III (Advanced)
The Excel-III (Advanced) course at OptionTrain.com provides a course to level up your Excel knowledge with a focus on advanced functions and data processing. Get to know how to use array functions, database functions, and financial functions to make complex calculations easy. Submerge yourself into Power Query to load and clean data from different sources. Learn how to work with PivotTables and enhance them with additional features and dynamic charts. Learn about VBA (Visual Basic for Applications) for automation and coding. Explore Power Pivot for more complex data manipulation. At the end of this course, you will be fully prepared to handle challenging data problems and get the most out of Excel. Come and take your Excel skills to the next level.
Primavera P6
The Primavera P6 program, available in the Greater Toronto Area, Ontario, Canada, offers comprehensive training on project management with a focus on the Primavera software. During the course, you will dive into the intricacies of project planning, from creating project plans and WBS to managing resources and setting baselines. You will learn to create, organize, and track activities, apply constraints, and work with filters for effective scheduling. The training includes exercises on critical path analysis, data transfer, and project optimization. Whether you are new to Primavera P6 or looking to enhance your existing skills, this course will guide you through the essential features and best practices for managing projects efficiently and successfully.
CAPM [Certified Associate In Project Management]
The Certified Associate in Project Management (CAPM)® course at OptionTrain College offers a comprehensive journey into the world of project management. Over the course tenure, you will dive into the essential components of project management, guided by the latest PMBOK® Guide 7th Edition. The program covers topics such as project integration, scope, schedule, cost, quality, resource, communications, risk, procurement, and stakeholder management. You will also receive valuable test questions review and tips to prepare you for the CAPM® exam. This course is designed to equip you with the knowledge and skills needed to excel in the field of project management and pursue CAPM® certification with confidence.
Project Management Professional (PMP)®
The PMP course at OptionTrain College covers a comprehensive curriculum divided into three key domains. Domain I, "People" focuses on equipping you with essential skills to lead and manage teams effectively, collaborate with stakeholders, and negotiate project agreements. In Domain II, "Process" you will delve deep into project execution, risk management, budgeting, quality control, and various project management activities. Finally, Domain III, "Business Environment" will prepare you to handle project compliance, assess business benefits, and adapt to external changes. This course provides a well-rounded foundation for aspiring project managers and emphasizes the critical areas of project management knowledge and expertise.
Six Sigma - Yellow Belt
The Six Sigma Yellow Belt course at OptionTrain College provides an introduction to the principles of Six Sigma and Lean methodologies. Over two days, you will delve into the fundamentals, understand the key differences between Lean and Six Sigma, and explore the renowned Toyota Production System. You will learn the DMAIC, DMADV, and DFSS approaches, and gain skills in identifying improvement opportunities, developing project charters, and building effective teams. This course equips you with the knowledge and tools needed to assess process performance, identify root causes, conduct hypothesis testing, and measure process capability. By the end, you will have a strong foundation in Six Sigma principles and methodologies.
Six Sigma - Green Belt
The Six Sigma Green Belt course at OptionTrain College is a program that sharpens problem-solving skills using the DMAIC model, an exceptionally effective process improvement methodology. This method is precision-crafted to identify and eliminate issues, reduce waste and inefficiency, and optimize work environments to meet customer demands more effectively. Incorporating real-world examples throughout the training, students gain practical experience in applying a range of Six Sigma problem-solving techniques and statistical tools, all with the ultimate goal of driving their organization to success. The primary aim of this course is to empower students to skillfully apply statistical methods to elevate and refine business processes.
SAS Programming Data Analysis
The Data Analysis with SAS Programming course at OptionTrain.com is designed to equip students with a comprehensive understanding of data analysis using the SAS software. Module 1 introduces fundamental SAS concepts, data handling, and analysis with practical experience. Module 2 covers advanced topics like data validation, modeling, and automation with SAS Macros. The course integrates practical lab work and hands-on projects, offering students the opportunity to apply their knowledge to real datasets, such as health-related data, breast cancer survival data, and marketing data. By the end of this course, students will be proficient in using SAS for data analysis and interpretation, making them well-prepared for a career in the field of data analytics.