Microsoft Excel

When teaching financial accounting, faculty often discuss bonds payable and how to calculate the issue price of a bond. Consider teaching students to calculate the issue price by using the net present value function in Excel.

When teaching cost behavior in a managerial or cost accounting course, we explain that there are various methods a company can use to estimate its fixed and variable costs, including regression analysis. The next time you cover this topic, consider teaching students how to perform a simple linear regression analysis in Excel.

Advanced Filter allows you to generate a unique list of items and extract those items to another place in your worksheet or workbook.

When analyzing grades (especially for a large class) the COUNTIF function in Excel can be extremely helpful.

The Camera tool is a handy function that allows you and your students to see how part of one spreadsheet changes in real time when you make changes to another.