Information management and technology assurance

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?

Should CPAs embrace 5G?

Fifth generation (5G) wireless communication technology beats 4G in at least three key areas — speed, bandwidth, and efficiency. Let’s take a brief look at each.

What to expect in 2020

CPAs are likely to proceed with caution next year amid unpredictable external forces. But technological innovation seems certain to continue its forward march.

Ask the expert: Technology

Aaron Harris has more than 25 years of high-tech engineering experience in business applications and software development strategies. As Sage’s Global CTO, he is responsible for Sage’s technology and product vision.

California proposes guidance for privacy law

The California attorney general’s office is seeking feedback on proposed regulations on the California Consumer Privacy Act, which will become the nation’s toughest data privacy law when it goes into effect Jan. 1.

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.

VIDEO

What RPA is and how it works

Robotic process automation is like an Excel macro that can work on multiple applications, says Danielle Supkis Cheek, CPA. RPA can complete routine, repetitive tasks such as data entry, freeing up employee time from lower-level chores.