Programs and Courses
OptionTrain offers a wide variety of programs and courses built on adaptive curriculum and led by leading industry experts.
The Excel-I (Basic) course at OptionTrain.com offers a journey to master Microsoft Excel's fundamental features and functions. This program is divided into eight units, starting with an introduction to Excel and progressing through data entry, basic functions and formulas, worksheet management, data visualization with charts, data sorting and filtering, data analysis using PivotTables, and a final review and Q&A session. You will learn to navigate Excel's interface, perform calculations, create charts, and gain essential data management skills. By the end of this course, You will be well-equipped to use Excel efficiently for tasks ranging from simple data entry to complex data analysis. Join us and unlock the power of Excel for your personal and professional needs.
The Excel-II (Intermediate) course at OptionTrain.com offers a journey to master Microsoft Excel's skills with a focus on advanced functions, data analysis, and automation. We begin with a quick review of Excel basics, offering navigational shortcuts and efficient data entry techniques. Then, you will delve into advanced functions and formulas, including logical, lookup, and text functions, as well as nesting for complex calculations. Learn to implement data validation rules and protect your worksheets and workbooks. Explore advanced data visualization techniques and data analysis tools, including What-If Analysis and Solver. Discover the power of macros for automating tasks, and master data consolidation and collaboration. The course ends with a comprehensive review and open Q&A session to ensure you're ready to excel in your Excel journey.
The Excel-III (Advanced) course at OptionTrain.com offers a journey to take your Excel skills to the next level with a focus on advanced functions and data manipulation. Learn to harness the power of array functions, database functions, and financial functions, making complex calculations a breeze. Dive into Power Query to import and transform data from various sources. Master PivotTables with advanced customization and dynamic visualizations. Explore VBA (Visual Basic for Applications) for automation and coding. Delve into Power Pivot for advanced data analysis. By the end of this course, you will be well-equipped to tackle complex data tasks and unleash the full potential of Excel. Join us and elevate your Excel expertise to new heights.
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.