Microsoft Excel

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.

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.

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.

RESOURCES

Keeping you informed and prepared amid the coronavirus outbreak

We’re gathering the latest news stories along with relevant columns, tips, podcasts, and videos on this page, along with curated items from our archives to help with uncertainty and disruption.

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.