How to use Excel’s Flash Fill feature, including a keyboard shortcut for both Windows and Excel for Mac.
2020 CPA Insider newsletter articles
Tough interview questions: ‘Tell me about yourself’
Human resources experts share what this prompt is designed to reveal about a candidate, and good ways to reply to it.
Help staff let off steam during busy season
Accounting firms share their favorite methods for cutting tension, promoting camaraderie, and building good will during the busiest time of the year.
Develop your team — or lose them
This article discusses the importance of providing employees with professional development opportunities.
3 ways to defeat ransomware: Plan, prevent, not pay
This article discusses ways to prepare for this kind of cyberthreat.
Topics to avoid during job interviews
Career experts share subjects you should handle with care or avoid altogether in your next job interview.
Interesting CPA stories of how tech has transformed accounting
Technology-savvy accounting professionals describe their old and new ways of doing things, and the pros and cons of those changes.
Evolve your firm with these 12 questions
To survive change, CPAs need to be willing to alter business models and revamp legacy processes and services.
The financial and human cost of loneliness in retirement
Isolation and loneliness can have serious emotional, social, and financial consequences, and can contribute to declines in clients’ physical and mental health and quality of life.
#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.
Keeping a virtual team on track
CPAs offer advice on the processes and technology that help them effectively manage remote teams.
4 ways to shine at your next meeting
This article discusses ways you can make the most of your time spent in meetings.
Position yourself for promotion
Many CPAs could benefit from taking a proactive approach to career strategy.
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.
