Shelly Cashman Excel 2019 Module 4:Textbook Project ALMA RAMIREZ 1

Shelly Cashman Excel 2019 Module 4:Textbook Project

ALMA RAMIREZ

1. Project: Mortgage Payment Calculator with Data Table and Amortization Schedule

To Apply a Theme to a Worksheet

To Enter the Section and Row Titles and the System Date

To Adjust the Column Widths and Row Heights

To Change the Sheet Tab Name

2. Creating Cell Names

To Format Cells Before Entering Values

To Enter the Loan Data

To Create Names Based on Row Titles

To Enter the Loan Amount Formula Using Names

To Enter the PMT Function

To Determine the Total Interest and Total Cost

To Enter the Original Loan Data

3. Using a Data Table to Analyze Worksheet Data

To Enter the Data Table Title and Column Titles

To Create a Percentage Series Using the Fill Handle

To Enter the Formulas in the Data Table

To Define a Range as a Data Table

4. Creating an Amortization Schedule

To Change Column Widths and Enter Titles

To Create a Series of Integers Using the Fill Handle

To Enter the Formula in the Amortization Schedule

To Enter the Total Formulas in the Amortization Schedule

To Format the Numbers in the Amortization Schedule

To Add Custom Borders to a Range

To Add Borders to the Varying Interest Rate Schedule

To Add Borders to the Amortization Schedule

To Use Borders and Fill Color to Visually Define and Group the Financial Tools

To Add a Pointer to the Data Table Using Conditional Formatting

5. Printing Sections of the Worksheet

To Set Up a Worksheet to Print

6. Protecting and Hiding Worksheets and Workbooks

7. Non-graded - Formula Checking