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 site uses cookies to store information on your computer. Some are essential to make our site work; others help us improve the user experience. By using the site, you consent to the placement of these cookies. Read our privacy policy to learn more.
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.
When analyzing grades (especially for a large class) the COUNTIF function in Excel can be extremely helpful.
Learn about some of the assignments and activities that won AICPA Effective Learning Strategies Educator Awards this year.
Having ESG knowledge can set graduates apart. Get students excited about this emerging area of accounting.
Did you know that you can edit PDF documents in Microsoft Word? Simply open a PDF document in Word.
Here are some ways accounting faculty have rethought tests and quizzes to promote critical thinking.
The right apps can improve online discussions, group work, and student feedback.
Pique students’ interest in accounting with a subject relevant to their lives.
Four accounting and academic experts offer advice on teaching this all-important topic.
Call your students’ attention to calculations or other details of PowerPoint slides as you present.
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.
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.
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.
Learn three simple formatting tricks to make column headings – or other cells – more readable in Excel.
As students search out their own career paths, faculty can help by preparing them for both virtual and in-person career events.
A professor explains how and why to incorporate the technology into the curriculum.
Learn how to use Excel to quickly calculate basic descriptive statistics for a dataset, including mean, standard deviation, minimums, and maximums.
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.
Excel’s Data Analysis ToolPak allows you to perform many advanced data analytics functions. Here’s how to enable it.
Experts offer their advice on teaching this emerging technology.
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.
SPONSORED REPORT
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.