View and edit 2 worksheets in the same workbook side by side
How to view and edit two worksheets from the same Excel workbook side-by-side.
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.
Succeed at teaching no matter your temperament
You don’t have to be very outgoing to be an effective educator.
Make the last day of class meaningful
Ending a course on a bright note can leave your students with a positive impression of your class and reinforce key concepts they’ve learned.
Redesign your final exams to truly promote learning
Try these tips to put together a final exam that helps students retain more, improves their study habits, and encourages them to practice critical thinking.
Use Excel PivotTables to quickly analyze grades
Use Excel PivotTables to quickly analyze grades Want to quickly sort the data in your Excel gradebook by category, such as section number or teaching assistant’s name? PivotTables let you view this data with ease.
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.
How to get started making videos for your classes
Video-savvy faculty present their best tips and techniques for shooting your own educational videos.
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.
Finding the fun in entry-level accounting
These creative approaches show students accounting is not that intimidating.
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.
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.
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.
Get started teaching blockchain
Experts offer best practices for helping students and faculty get up to speed.
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.
#EngagedStudents: Boost skills with social media
These fun projects encourage more professional communications.
Help nontraditional accounting students thrive
Follow these tips to make all students more welcome in your classroom.
Secrets of master accounting teachers
This year’s Cook Prize winners share their best teaching advice.
6 tips to get students career-ready
Minding their p’s and q’s can be as important as knowing about debits and credits.
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.
