The Complete Excel Guide: Beginners to Advanced - Module 19 - Practice Exercise

The video tutorial covers several Excel features. It begins with using the Goal Seeker tool to determine the interest rate needed for a specific monthly payment. Next, it explains how to adjust the principal for a different payment amount. The tutorial then demonstrates using the text to columns feature to separate names into individual columns. It also shows how to create a watch window to monitor changes in a specific cell. The session concludes with a wrap-up of the current module and a brief introduction to the next module, focusing on shortcuts.

What is the interest rate needed for a monthly payment of $350.00?

Where does the principal need to be for the monthly payment to be $375?

How do you separate first names and last names into individual columns?

What steps do you take to create a watch window for cell F4?

What should you do after finishing the tasks in module 19?