Microsoft Excel

Using SUMIFS to sum with multiple conditions

If you need to create a sum based on more than one criteria, you can use SUMIFS.

Add color to your Excel workbooks

There are several ways to add color to your Excel workbooks.

Create your own custom Excel functions with LAMBDA

If you are routinely creating formulas that accomplish the same purpose, spending a little extra time upfront to create a function that can be reused will save you time in the end.

What is so special about Paste Special in Excel?

This month’s column walks you through all the special ways you can paste text, data, and even application capabilities in Excel.

Combining formulas and text in the same cell in Excel

You can include both a formula and text in the same cell in Excel.

Creating a drop-down list in Excel

Creating drop-down lists in your spreadsheets is a great way to ensure that only certain information is entered into a cell.

How to easily transpose data in Excel

The Transpose feature allows you to rotate data from columns to rows and vice versa from rows to columns without reentering any of the data.

A blockchain glossary, the CPA firm of the future, and Excel malware

Blockchain — what does it mean to you? A glossary of terms offers clarity. Also, hear or read more about accounting firms’ tech-integrated future.

Cyberattacks via Excel add-ins jump nearly 600%

Report finds huge surge in malware infections via .XLL files.

Transposing data in Excel

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

Automate routine data entry with Excel Flash Fill

If Excel can sense a pattern in what you are doing, it will try to complete the task for you.

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.

Calculating the issue price of a bond using the NPV function in Excel

When teaching financial accounting, faculty often discuss bonds payable and how to calculate the issue price of a bond. Consider teaching students to calculate the issue price by using the net present value function 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.

Using the Excel personal assistant

Excel Personal Assistant can help you locate all the features Excel has to offer.

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.

The Excel Advanced Filter function gives you flexibility

Advanced Filter allows you to generate a unique list of items and extract those items to another place in your worksheet or workbook.