Microsoft Excel

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.

Using range names in Excel

Using range names in Excel allows you to quickly navigate to areas of your worksheet and makes formulas much easier to create.

How to hide zero values

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

Performing a simple linear regression in Excel

When teaching cost behavior in a managerial or cost accounting course, we explain that there are various methods a company can use to estimate its fixed and variable costs, including regression analysis. The next time you cover this topic, consider teaching students how to perform a simple linear regression analysis in Excel.

Where to find December’s flipbook issue

The Journal of Accountancy is now completely digital. 

 

 

 

SPONSORED REPORT

Get Clients Ready for Tax Season

This comprehensive report looks at the changes to the child tax credit, earned income tax credit, and child and dependent care credit caused by the expiration of provisions in the American Rescue Plan Act; the ability e-file more returns in the Form 1040 series; automobile mileage deductions; the alternative minimum tax; gift tax exemptions; strategies for accelerating or postponing income and deductions; and retirement and estate planning.