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.
Accounting Education
Motivate students to do the assigned reading
Design lessons and class participation so students arrive prepared.
Succeed at teaching no matter your temperament
You don’t have to be very outgoing to be an effective educator.
AICPA Council supports advancement of new CPA licensure model
The AICPA governing Council voted to support advancement of a new CPA licensure model that is designed to maintain the credential’s relevance long into the future.
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.
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.
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.
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.
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.
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.
Get started teaching blockchain
Experts offer best practices for helping students and faculty get up to speed.
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.
#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.
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.
