Advertisement
TOPICS

Transposing data in Excel

You can easily convert horizontal data to
vertical and vertical data to horizontal by using the
Transpose feature in Excel.

How to spill formulas in Excel

With spilling, you can create a formula in one cell, and that formula will then spill over into other adjacent cells when a set of values is calculated.

How to hide zero values

In certain scenarios, showing zero values can be
very distracting. They can be easily hidden in Excel.

Using stocks and other data types in Excel

You can convert text in Excel to linked data types. This is referred to as “linked” data types because the data is connected to an online data source.

Journal-entry testing using Excel

In this example walk-through, learn how to use Microsoft’s spreadsheet application to perform several tasks, including sampling.

Add Favorites to the Ribbon

You can add all your favorite or frequently used Excel features in one tab on your Ribbon.

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.