Video-savvy faculty present their best tips and techniques for shooting your own educational videos.
Accounting education
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.
Finding the fun in entry-level accounting
These creative approaches show students accounting is not that intimidating.
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.
Mental health concerns on campus: What faculty can do
There are steps you can take even if you’re uncertain about the best response.
Get started teaching blockchain
Experts offer best practices for helping students and faculty get up to speed.
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.
#EngagedStudents: Boost skills with social media
These fun projects encourage more professional communications.
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.
Improve your teaching evaluations
Here are some practical ways to improve your teaching evaluations, without lowering your standards or becoming an easier grader.
Fellowships support minority doctoral students
The AICPA Foundation granted fellowships to 25 minority doctoral students.
Inaugural program provides scholarships and internships to ethnically diverse students
Five students received the inaugural George Willie Ethnically Diverse Student Scholarship and Internship.
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.
Help nontraditional accounting students thrive
Follow these tips to make all students more welcome in your classroom.
Awards recognize innovative teaching methods
Nine accounting educators received 2019 Effective Learning Strategies Awards.
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.
AICPA Legacy Scholars program benefits 129 students
The AICPA granted $666,000 in academic scholarships to 129 students as part of the AICPA Legacy Scholars program.
SEC accepting Professional Accounting Fellow applications
The program provides opportunities for public service and personal development.
Scholarship funds accounting Ph.D. candidates
The AICPA awarded the first William (Bill) Ezzell Scholarships to five CPAs pursuing doctorates in accounting.
6 tips to get students career-ready
Minding their p’s and q’s can be as important as knowing about debits and credits.
Features
SPONSORED REPORT
Smart Strategies in Data Security and Risk Management
In an increasingly digital profession, data security has become one of the most critical challenges facing finance and accounting professionals today. Stay up to date with practical guidance to help you mitigate these risks and strengthen your security posture.