Advertisement
TOPICS

Reaching the SUMIF

The SUMIF function provides a quick and simple way to create a sum based on a specific criterion, such as the type of audit.

The IF function mastered

Once you master the IF function, you will wonder how you ever lived without it.

Excel vs. Tableau: See your data differently

This article compares the data visualization program Tableau to Excel, examines their relative strengths, and provides a simple walk-through on how to use Tableau.

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.

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.

FROM THIS MONTH'S ISSUE

Real-life ways small firms use AI

Learn how four small firms use artificial intelligence to automate processes while maintaining strong oversight.