extra-credit-header-2018


This monthly e-newsletter brings you a roundup of the top stories affecting accounting education, ideas for innovation in the classroom, and resources from the AICPA to support educators.

Subscribe to the Extra Credit newsletter >

Various ways to display formulas in Excel

There are a number of different ways that you can display formulas in Excel. This can be useful when investigating why a certain formula isn’t working correctly or when grading your students’ worksheets to ensure they are using formulas correctly.

Use VLOOKUP to help manage your gradebook

VLOOKUP is a formula that allows you to “look up” certain data and retrieve it into another table, by row. This function can be especially useful when you have a well-structured table with information organized by rows (such as a gradebook)!

Variety is the spice of online learning

Variety is the spice of not only life but also teaching and learning. Here are some simple ways to add some S-P-I-C-E to a classroom to break the monotony of an online lecture or hybrid class.

Calculating depreciation using the SLN function

When teaching depreciation in Introduction to Accounting, faculty always cover a variety of different depreciation methods, including straight-line depreciation. Next time you teach this topic, build your students’ Excel skills by showing them how to use the straight-line (SLN) function in Excel.


Do you have an article or news story idea?

To submit a news piece or contribute to an article for the Extra Credit newsletter, please email academicnews@aicpa.org 

If you are interested in submitting a proposal or manuscript to the Journal of Accountancy, please click here to review the author guidelines and submission instructions. 

Where to find August’s flipbook issue

The Journal of Accountancy is now completely digital. 

 

 

 

SPONSORED REPORT

Better decision-making with data analytics

Data analytics has become a hot topic, but many organizations have not yet managed to understand its potential, let alone put it to work. This report will take a deep-dive on how to best introduce or enhance the use of data in decision-making.