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.
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.
Make mundane tasks easier by harnessing the power of automation.
Improve the way you appear on camera with a few simple tweaks.
Try these suggestions from faculty and other experts for reducing the strain and taking better care of yourself and your students.
Preparation can make the difference between a great experience and a mediocre one.
Four professors offer insight and advice on this challenging subject.
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)!
Use this trend as a springboard into discussing the impact of technology on accounting.
Try this tip and have your most-used functions right at your fingertips.
These teaching tools liven up both in-person and virtual classes.
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.
Try these fun and engaging ways of teaching accounting topics.
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.
Faculty can take these motives into account when attempting to deter cheating in their courses.
Amid the challenges of suddenly pivoting to online teaching midway through the semester, many accounting professors learned new techniques and principles that will inform their teaching this fall.
Keep these principles in mind when assigning and teaching case studies to increase your chances of success.
Try these easy ways to create relatable lessons in accounting.
Simple to create, sparklines are tiny graphs that help you make sense of data at a glance.
Design lessons and class participation so students arrive prepared.
How to view and edit two worksheets from the same Excel workbook side-by-side.
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 email@example.com
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.