Accounting education news and resources

TOPICS

April 14, 2020

Use Excel’s AutoSum button to add up rows and columns with just one click

Want to quickly add up rows or columns of data in your gradebook (or elsewhere)? The AutoSum function makes it easy.

April 14, 2020

An online pivot can be an opportunity

A faculty member reconfigured her finance class in the wake of the COVID-19 crisis to teach soft skills.

April 14, 2020

How to get started making videos for your classes

Video-savvy faculty present their best tips and techniques for shooting your own educational videos.

March 10, 2020

Sort by color to group highlighted cells in Excel

Highlighting cells with different colors can help you quickly identify information in a spreadsheet. Excel also lets you sort by color to easily group all the information you’ve highlighted with a given color. Learn how.

March 10, 2020

Finding the fun in entry-level accounting

These creative approaches show students accounting is not that intimidating.

March 10, 2020

How (and why) to write for practitioner journals

By writing for these publications, you can introduce your research to a wide audience and have a large impact upon the accounting profession.

February 11, 2020

Mental health concerns on campus: What faculty can do

There are steps you can take even if you’re uncertain about the best response.

February 11, 2020

Get started teaching blockchain

Experts offer best practices for helping students and faculty get up to speed.

February 11, 2020

Use Excel’s Flash Fill to automatically fill in data quickly

How to use Excel’s Flash Fill feature, including a keyboard shortcut for both Windows and Excel for Mac.

January 14, 2020

#EngagedStudents: Boost skills with social media

These fun projects encourage more professional communications.

January 14, 2020

Use IFS function to calculate letter grades in Excel

Added by Microsoft in 2016, the IFS function replaces the need for multiple nested IF statements. You can put all your conditions (percentage grade cutoffs in this example) in one function, making it easier to follow.

January 14, 2020

Improve your teaching evaluations

Here are some practical ways to improve your teaching evaluations, without lowering your standards or becoming an easier grader.

January 1, 2020

Fellowships support minority doctoral students

The AICPA Foundation granted fellowships to 25 minority doctoral students.

January 1, 2020

Inaugural program provides scholarships and internships to ethnically diverse students

Five students received the inaugural George Willie Ethnically Diverse Student Scholarship and Internship.

January 1, 2020

Young CPAs attend annual AICPA Leadership Academy

Thirty-six young CPAs attended the 2019 AICPA Leadership Academy, a four-day program created to inspire, nurture, and empower the next generation of leaders.

December 10, 2019

Help nontraditional accounting students thrive

Follow these tips to make all students more welcome in your classroom.

December 1, 2019

Awards recognize innovative teaching methods

Nine accounting educators received 2019 Effective Learning Strategies Awards.

December 1, 2019

APBP-graduate high school students receive Foundation Scholarship

Ten high school students received the AICPA Foundation High School Scholarship, which provides $2,000 to students who intend to continue their accounting studies.

December 1, 2019