Microsoft Excel

Using range names in Excel allows you to quickly navigate to areas of your worksheet and makes formulas much easier to create.

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.