Hope College CSCI 140

This video demonstrates the creation of use of defined names in formulas

This video demonstrates the use of the VLOOKUP and IFERROR functions to implement an Excel worksheet that allows conversion from one country's currency to another

This video discusses the use of Nested IF statements and the VLOOKUP function

This video demonstrates how the INDIRECT function can be used to carry over the ending cash balance from one month to the beginning cash balance for the next month.

This video discusses solutions to the practice exercises using AND/OR

This video contains notes on using the AND/OR boolean functions

This video outlines the steps to add the Monthly Payment column to the table, and then create a pivot table summarizing the data, including a Report Filter grouped by month (and a slicer with the same capability).

This outlines the solution to case 2 in tutorial 5, demonstrating working with tables, subtotals and pivot tables, as well as a conditional formatting review

This video demonstrates the solution to the Poweder1.xlsx portion of the practice chart exercises.