Goal Seek feature in Microsoft Office Excel is used to find out the correct input value to a formula in order to get a desired formula result. This video shows how to use the Goal Seek feature to calculate loan period for a given monthly payment amount and interest rate.
Posted inPower of Microsoft Office
Calculate Loan Terms using Goal Seek in Microsoft Excel
Barakat holds a B.Sc. degree in Industrial Engineering from the University of Jordan and has 23 years of experience in diverse industries.
Throughout his career Mohammed focused on Process Management and Improvement. He leveraged the concepts of Lean and Six Sigma in the workplace. He has been involved in the field of Data Science and Machine Learning to leverage improvement through Data Analytics.
In his capacity as a process improvement professional he has managed and implemented a multitude of improvement projects using Six Sigma, Lean, Theory of Constraints, and Kaizen.
As a programmer and data analyst, he started his journey in early 2000’s with programming by developing Excel-VBA macros to provide quick solutions in his work. He managed to develop robust applications in MS Access that cut down on labor cost and made processes more efficient. Barakat developed several R codes and reproducible researches handling statistical and machine learning algorithms.
Mohammed is a Jordan Consultant Engineer (JCE), and he holds several certifications in Project Management (PMP and PMI-RMP) and Six Sigma (ASQ Six Sigma Black Belt and Green Belt). He is also a Microsoft Certified Trainer and Technology Specialist from Microsoft.
Post navigation
Previous Post
Summarize your data with PivotTables