Experts offer best practices for helping students and faculty get up to speed.
Accounting education
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.
Secrets of master accounting teachers
This year’s Cook Prize winners share their best teaching advice.
Awards recognize achievements in education and accounting literature
Stephen Moehrle received the 2019 AICPA Distinguished Achievement in Accounting Education Award, and Panos N. Patatoukas and Yaniv Konchitchki received the 2019 Notable Contributions to Accounting Literature Award.
Student earns Medal of Inspiration
Indira Karimova, a student pursuing her master’s degree at the University of Texas at Tyler in hopes of earning her CPA, received Beta Alpha Psi’s Medal of Inspiration Award.
How to identify your students’ stage of cognitive development
Susan Wolcott, CPA, Ph.D., recommends some practical ways to determine what stage of cognitive development your students have reached.
Prepare students today for accountants’ shifting roles
Show students how emerging technologies could affect their careers.
Features
SPONSORED REPORT
How to find the right CAS clients
The key to success with CAS is selecting the best clients. Tools like ideal client profiles (ICPs), buyer personas, and even artificial intelligence can help identify the businesses that best fit each CAS practice.
