Advertisement
TOPICS

Microsoft Excel

Creating a data-entry form in Excel

The use of a data-entry form makes data entry faster and more efficient because you don’t have to go to multiple different cells to enter data, row by row.

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.

SPONSORED REPORT

Agentic accounting has arrived: What’s hype and what’s real?

Artificial intelligence (AI) is moving beyond chatbots and into accounting workflows. A new generation of agentic AI tools can plan, execute, and adapt as they complete tasks, raising expectations for what automation can do inside firms and finance departments. What can agentic AI realistically do today and what challenges are there in its implementation? Find out in this Journal of Accountancy sponsored report.

From The Tax Adviser

August 31, 2026

What today’s clients expect from their CPA and how firms are responding

August 31, 2026

2026 tax software survey

August 31, 2026

A risk framework for AI use in tax administration and preparation

July 31, 2026

Current developments in S corporations