01:198:170 Lecture 19: Chapter 14 Advanced Spreadsheets for Planning

• School: Rutgers University
• Department: Computer Science
• Course: 01:198:170
• Professor: S Stoll

Document Summary

Defining names: would you rather work with this, or this: Filtering: filter data to improve your ability to review and analysis, create subsets of data. What if analysis: a speculative or what if analysis tool to stage different scenarios based on a cell"s value, 2 methods, goal seeker. Determine a value we need to obtain to achieve the result we wish: scenario manager. If,ifs,iferror: ppmt, ppmt, ipmt, subtotal, and, or, not, averageif, countif, sumif, averageifs, countifs, sumifs. If function: test (condition) represents a logical test that returns. True or false: or an if statement can have two results. The first result is if your comparison is true, the second if your comparison is false: can be nested, multiple if statements require multiple open and closing parentheses (, multiple if statements can become very difficult to maintain. The excel weekday takes a date & returns a number between 1-7 representing day of week.