• Share

# Articles Index

### Excel CONVERT Function

The CONVERT function can be used to convert measurement data from one set of units to another. A step by step example is included with this tutorial.

### Excel Negative Number Format

This tutorial covers how to format negative numbers in Excel to display in a different color. A step by step example is included in the tutorial.

### How to Subtract in Excel

How to subtract in Excel shows you how easy subtracting numbers in Excel can be. The tutorial includes a step by step example of how to subtract two numbers in Excel.

### How to Add in Excel

How to add in Excel shows you how easy adding numbers in Excel can be. The tutorial includes a step by step example of how to add two numbers in Excel.

### Date Functions in Excel

There are a number of date functions available in Excel. Depending on your needs, you can use a date function in Excel to return the current date, the current time, or the day of the week. This tutorial covers the most common date functions used in Excel.

### How to Multiply in Excel

How to multiply in Excel shows you how easy multiplying numbers in Excel can be. The tutorial includes a step by step example of how to multiply two numbers in Excel.

### Find the Cosine of an Angle in Excel

Excel's COS function can be used to find the cosine of an angle measured in radians. A step by step example of using this function is included in the tutorial.

### Excel SIGN Function

The SIGN function will tell you whether the number in a cell is negative or positive in value or whether it is equal to zero. This tutorial includes a step by step example of using the SIGN function in Excel.

### Excel QUOTIENT Function

The QUOTIENT function is used to divide numbers in Excel. This tutorial includes an example to walk you through using the QUOTIENT function.

### Excel ROUND Function

Using the ROUND function to round numbers in Excel

### Excel Paste Link

Automatically update copied data between cells using paste link. Cells can be on different Excel worksheets or even different workbooks. A step by step example of using paste link is included.

### Calculate the Number of Days Between Dates in Excel

The DATEDIF function can be used to calculate the number of days between dates. This tutorial includes a step by step example of using the DATEDIF function to calculate the number of days between two dates in Excel.

### Excel COUNTBLANK

The COUNTBLANK function is used to count up the number of cells in a selected range that do not contain data. This tutorial contains a step by step example of using the COUNTBLANK function in Excel.

### Count in Excel

Excel's COUNT function can be used to count up the number of cells containing numbers in a selected range. This tutorial includes a step by step example of using the COUNT function in Excel

### Excel COUNT - INDIRECT Formula

This tutorial combines the INDIRECT and COUNT functions to create a count formula with a dynamic range that is easily changed. A step by step example is included.

### Nested Functions in Excel

Nested functions in Excel combine the operations of two or more functions in one cell. This tutorial includes a step by step example on nested functions in Excel.

### Excel MAX IF Formula

This tutorial uses a MAX - IF array formula in Excel to find the largest positive or negative value for a range of data. A step by step example is included.

### Shading Multiple Rows of Data in Excel

This tutorial covers shading multiple rows of data in Excel using conditional formatting.

### Excel AutoMAX

Excel's AutoMAX feature is a shortcut to using the MAX function to find the largest number in a range of data. A step by step example is included.

### Excel MEDIAN IF Array Formula Tutorial

By combining the MEDIAN and the IF functions in an array formula in Excel, we can find the middle value for a range of data when a specific criterion is met. A step by step example is included on how to create a MEDIAN IF array formula.

### Excel MIN IF Array Formula Tutorial

By combining the MIN and the IF functions in an array formula in Excel, we can find the smallest or minimum value for a range of data when a specific criterion is met. A step by step example is included on how to create a MIN IF array formula.

### Excel MAX IF Array Formula Tutorial

By combining the MAX and the IF functions in an array formula in Excel, we can find the largest or maximum value for a range of data when a specific criterion is met. A step by step example is included on how to create a MAX IF array formula.

### #DIV/O! - Divide by Zero Error

#DIV/0! - Divide by 0 errors indicate an error in a formula. This article discusses the causes and cures for this common problem.

### #NULL! - Null Error

#NULL! Null errors occur in Excel. This article covers the causes and cures for #NULL! errors in Excel spreadsheets

### Excel MAX Function

The MAX function, is used to find the largest or maximum number in a given list of values. This tutorial includes a step by step example.