Information management and technology assurance

Open source information and forensic accountants

Veteran investigator Cynthia Hetherington offers practical tips and guidance on how forensic accountants can use the open source information found on the internet to make themselves smarter, better investigators while staying within privacy laws.

Where accounting really stands with blockchain

Erik Asgeirsson, president and CEO of CPA.com, and Ron Quaranta, founder and chairman of the Wall Street Blockchain Alliance, examine tax and accounting issues related to cryptoassets and explore assurance opportunities blockchain is creating for accountants.

The easy way to join text in Excel

If you have Excel 2019 or Excel 365, you can use the function TEXTJOIN to quickly join text in one cell and separate the text with any delimiter, even if you have many rows or columns of data to join.

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.

2 simple ways to visualize data

Supplementing spreadsheet data with visual representation aids the user in identifying trends and patterns that may not be evident otherwise.

2020s vision: Tech transformation on tap

Data analytics, blockchain, artificial intelligence, and other technologies will drive big changes in the accounting profession over the next 10 years. Are you ready for what’s next?

VIDEO

Excel walk-through: Sparklines

Want to liven up your spreadsheets with some color and graphical elements? Kelly L. Williams, CPA, Ph.D., shows how to use Excel sparklines, which illustrate data trends and patterns via small charts that fit in a single Excel cell.

PODCAST

What’s next for potential CPA licensure changes

A new model proposed by NASBA and the AICPA is designed with an eye on the future for newly licensed CPAs. The AICPA's Carl Mayes, CPA, provides background on the project and a look ahead to 2020.