How Excel COUNTIF function saves time when analyzing final grades
When analyzing grades (especially for a large class) the COUNTIF function in Excel can be extremely helpful.
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.
Teach students tech (and more) with award-winning assignments
Learn about some of the assignments and activities that won AICPA Effective Learning Strategies Educator Awards this year.
Tips for teaching ESG and sustainability accounting
Having ESG knowledge can set graduates apart. Get students excited about this emerging area of accounting.
Edit PDF documents in Word to save time
Did you know that you can edit PDF documents in Microsoft Word? Simply open a PDF document in Word.
Innovative approaches to accounting tests and quizzes
Here are some ways accounting faculty have rethought tests and quizzes to promote critical thinking.
Tools to enhance your teaching this semester
The right apps can improve online discussions, group work, and student feedback.
Reach your students with financial literacy
Pique students’ interest in accounting with a subject relevant to their lives.
Fit cybersecurity into your accounting courses
Four accounting and academic experts offer advice on teaching this all-important topic.
Zoom in on part of a slide during a PowerPoint presentation
Call your students’ attention to calculations or other details of PowerPoint slides as you present.
6 ways to include more technology in the accounting curriculum
Here are some ways accounting departments and faculty can integrate technology throughout the curriculum to better prepare graduates to meet the needs of the profession.
Resilient accounting students suffer less burnout
A study of accounting students revealed that more resilient students had stronger mental health and were less likely to experience burnout. Kenneth J. Smith, CPA, one of the study’s authors, observes that resilience is a skill that can be learned.
Use the Camera tool in Excel to create dynamic screenshots
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.
Format column headings in Excel to make them easier to read
Learn three simple formatting tricks to make column headings – or other cells – more readable in Excel.
Prepare your students for hybrid recruiting
As students search out their own career paths, faculty can help by preparing them for both virtual and in-person career events.
How one accounting program introduces students to RPA
A professor explains how and why to incorporate the technology into the curriculum.
See descriptive statistics in Excel
Learn how to use Excel to quickly calculate basic descriptive statistics for a dataset, including mean, standard deviation, minimums, and maximums.
How an academic fellowship can boost your career
Taking an academic fellowship with an institution such as the SEC or the PCAOB is a big commitment. But doing so could reap benefits for your scholarship and teaching, and even change the course of your career.
Add the Data Analysis ToolPak to Excel
Excel’s Data Analysis ToolPak allows you to perform many advanced data analytics functions. Here’s how to enable it.
Get started with robotic process automation
Experts offer their advice on teaching this emerging technology.
What faculty should know about Alteryx
Don't be afraid of teaching this easy-to-learn data analysis software.
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.
