When you think of double quotation marks, you probably remember your English lessons in school. However, in Microsoft Excel, ...

Functions are the driving force of any Microsoft Excel spreadsheet, generating a single value or an array of results based on certain arguments you input. However, combining—or nesting—functions ...

If you need to conditionally split values into multiple columns in Microsoft Excel, consider using the IF() function. Here's how.

Excel has over 475 formulas in its Functions Library, but we've selected the most popular, from date and time functions to mathematics and simple data manipulation.

Learn to write complex formulas in Microsoft Excel with ease by breaking them down into smaller chunks using the technique outlined in this post.

When you need to see the last value in an Excel Table or data range, these formulas will get the job done. This walk-through details the necessary formulas and some VBA code that performs the same ...

A. Microsoft Excel is best known for crunching numbers, but it’s also a powerful tool for organizing tasks. Checkboxes can ...

The third column, Column C, will display the count of days when we subtract the value of Column A from the value of Column B, for each row in the spreadsheet.

Column_num is the column number in the range that contains the data you’re looking for. The INDEX formula doesn’t recognize column letters, so you must use numbers (counting from the left).

Learn how to use the VLOOKUP formula to compare a maximum of two columns to have common values returned or to locate missing data.

This formula instructs Excel to display only the employee's regular hours. Copy the Formula for Each Employee Click cell "E2" and place your mouse at the lower-right corner of the cell.

Add a column to any data set in an Excel spreadsheet and fill it with random numbers generated with RAND () b_y dragging the _RAND formula down the column.