Microsoft Excel

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.

Journal-entry testing using Excel

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

Excel depreciation methods, part 1

Kelly L. Williams, CPA, Ph.D., explains four depreciation functions, which have three required arguments in common: cost, salvage, and life.

Where to find January’s flipbook issue

Starting this month, all Association magazines — the Journal of Accountancy, The Tax Adviser, and FM magazine (coming in February) — are completely digital. Read more about the change and get tips on how to access the new flipbook digital issues.

SPONSORED REPORT

Get your clients ready for tax season

Upon its enactment in March, the American Rescue Plan Act (ARPA) introduced many new tax changes, some of which retroactively affected 2020 returns. Making the right moves now can help you mitigate any surprises heading into 2022.