Microsoft Excel

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.

A quick tip for breaking links in Excel

This action will remove all links from your workbook but leave your formulas intact so your recipients can still edit the data to produce “what-if ” scenarios for deeper analysis.

A dozen Excel time-savers

I've compiled a list of a dozen Excel tricks that will help any CPA become more efficient and effective.

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.