Advertisement
TOPICS

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.

FROM THIS MONTH'S ISSUE

Handling increased enforcement of unclaimed property notices

States are changing enforcement of unclaimed property notices. Learn best practices of how companies can tackle compliance and prevent penalties and audits.