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.

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.