Week 5 - Exploring the Function Library (Ch6) | Capstone 1
The Excel Function Library includes functions that perform complex and sophisticated calculations for use in business, government, education, and research. In this chapter, you learn about functions in the Database, Logical, Date & Time, Financial, and Text categories. You also nest functions and build time, date, and statistical calculations.
You will also work through our mid-semester capstone project which is assigned as a SIMnet Project putting into practice some of the new skills and knowledge that you've gained during the past several weeks. You will also have a chance to "catch up" on any assignments that you might have yet to complete. Or, if you didn't score as high as you would have liked on one or more of the SIMnet Projects in chapters 1-6, remember you can resubmit (even past the due date with a 20% late deduction) and the highest score will be taken.
At the end of this week, you will be able to:
- Use Database functions such as DSUM and DAVERAGE.
- Build AND, OR, nested, and IFS functions.
- Explore the Lookup & Reference category with INDEX, MATCH, and TRANSPOSE.
- Build date, time, and statistical calculations.
- Use Financial functions such as PV, FV, and NPV.
- Work with Text functions including TEXTJOIN, CONCAT, EXACT, and REPLACE.
- Use multiple criteria in SUMIFS, AVERAGEIFS, and COUNTIFS functions.
- Monitor and edit functions with the Watch Window and Find and Replace.
- Put recently acquired knowledge/skills into practice building your own specific Excel spreadsheet.
- Check out the informational items for some in-depth specifics.
- Read Ch 6 (SIMBook) in SIMnet.
- Complete Excel Ch 6 SIMBook Let Me Try in-reading tasks.
- Complete Excel Ch 6 SIMpath.
- Complete Excel Ch 6 SIMnet Project 1.
- Complete Excel Ch 6 SIMnet Project 2.
- Complete Mid-semester Capstone Project.