Accounting education news and resources

TOPICS

February 8, 2022

How to easily transpose data in Excel

The Transpose feature allows you to rotate data from columns to rows and vice versa from rows to columns without reentering any of the data.

January 25, 2022

What one CPA calls ‘the best job in the world’

Find out why the subject of January’s Last Word feature enjoys her work, plus get a preview of the annual tax filing season quick guide in this podcast with transcript.

January 11, 2022

Help students tell the story behind the numbers

Tweak your assignments to bolster students’ communication skills.

January 11, 2022

7 steps to help stop cheating

Demonstrate the importance of integrity to the profession.

January 11, 2022

Using range names in Excel

Using range names in Excel allows you to quickly navigate to areas of your worksheet and makes formulas much easier to create.

January 1, 2022

Nancy Bagranoff, CPA, DBA

Finding a way to establish a connection is the key to communicating and collaborating with young people, according to Nancy Bagranoff, CPA, DBA.

December 7, 2021

Work with other departments to bring more tech to your curricula

Follow these tips for successful interdepartmental collaborations.

December 7, 2021

Calculating the issue price of a bond using the NPV function in Excel

When teaching financial accounting, faculty often discuss bonds payable and how to calculate the issue price of a bond. Consider teaching students to calculate the issue price by using the net present value function in Excel.

December 7, 2021

A road map for learning data analytics

Models can help faculty teach — and students grasp — this important subject.

November 19, 2021

AICPA, NASBA publish revised CPA Evolution Model Curriculum

In response to feedback, the AICPA and the National Association of State Boards of Accountancy on Friday updated the curriculum resource that was launched in June to help faculty align their programs with the new Core + Disciplines licensure model created by the CPA Evolution initiative.

November 9, 2021

Make your classes more accessible to everyone

A few small changes can help you reach students with and without disabilities.

November 9, 2021

Performing a simple linear regression in Excel

When teaching cost behavior in a managerial or cost accounting course, we explain that there are various methods a company can use to estimate its fixed and variable costs, including regression analysis. The next time you cover this topic, consider teaching students how to perform a simple linear regression analysis in Excel.

October 12, 2021

The Excel Advanced Filter function gives you flexibility

Advanced Filter allows you to generate a unique list of items and extract those items to another place in your worksheet or workbook.

October 12, 2021

The abilities employers seek from accounting graduates

Today’s accounting graduates are tasked with learning new technologies at a more rapid pace, dealing with larger datasets, and solving more complex problems earlier on in their careers than their predecessors did.

September 14, 2021

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.

September 14, 2021

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.

September 14, 2021

Tips for teaching ESG and sustainability accounting

Having ESG knowledge can set graduates apart. Get students excited about this emerging area of accounting.

August 10, 2021

Innovative approaches to accounting tests and quizzes

Here are some ways accounting faculty have rethought tests and quizzes to promote critical thinking.

August 10, 2021

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.

August 10, 2021

Tools to enhance your teaching this semester

The right apps can improve online discussions, group work, and student feedback.

FROM THIS MONTH'S ISSUE

Cannabis dispensary denied ERC

The Court of Federal Claims held that Sec. 280E, which prohibits deductions and credits for businesses trafficking in controlled substances, applies to the employee retention credit (ERC), including its refundable portion, and denied a cannabis business’s claim for a refundable ERC.