Spreadsheets

The scripting language for Microsoft Excel, Visual Basic, lets you extend Excel's already ample set of tools. However, coding directly in Visual Basic can be difficult because some functions (like...

Microsoft Excel's scripting language, Visual Basic, not only increases the functionality of Excel, but also can make that functionality easier to use--through user forms. User forms are small...

The VLOOKUP function is very powerful function in the Microsoft Excel application. And it can be easy to use if you follow these steps! The function allows you to compare one column of...

The SUMIF function allows for conditional sums based on specified criteria. In this article I will be showing you a quick practical example of using this function, for extracting the sales of a...

Average is a statistical measure used to gauge what the middle number is in a range of data. It is the most common descriptive statistic used in statistical analysis. The average value of a given...

The range is a statistic that provides information on the statistical dispersion of a data sample. It is calculated by subtracting the lowest number from the highest number. It's easy to calculate...

The median is an important statistic that separates the higher half of the sample of data from the lower half of the sample. Learn how to easily calculate the median in a Microsoft Excel spreadsheet.

A lot of people are familiar with Excel's COUNT function - but when they use it to count cells with text, they get a 0 or some other unexpected value if the range contains numbers and...

You may come across a spreadsheet with a huge amount of data in it and need to find out what is the largest value it contains. Here is how you do that.

Microsoft includes a lot of very useful functions in its Excel Spreadsheet software. One of them which is continually being improved for accuracy is the Intercept function. What Intercept does is...

Among the many great functions included in Microsoft's Excel spreadsheet software, Index is a neat command that can "pick out" a value in a specific cell range. Excel programmers use Index as an...

The "Rand" function in Microsoft Excel will automatically create random numbers for your Excel spreadsheet. You can use the "RandBetween" function to create random numbers that fall in a range...

A range name is a name that is given to a group of cells within Microsoft Excel 2007. Once you have created a range name you can then reference the range name instead of the cell reference inside...

Range names are a name that you have previously assigned a group of cells in Microsoft Excel 2007. If you have several range names in your workbook, you will want to manage those names so you can...

The SMALL function in Microsoft Excel returns the smallest value from a range of values. You can also use it to return other values in relation to the smallest value. This function can be quite...

Elementary addition becomes cumbersome when it includes large volumes of data, however, using an Excel spreadsheet to perform calculations saves time if you are familiar with functions such as...

Excel's CountBlank function counts the number of empty cells in the specified range. The CountBlank function syntax is CountBlank(range), where range is a range of cells of the form cell_1:cell_2...

Excel's CountIf function counts the number of cells in a specified range that meet the specified criteria. The syntax is CountIf (range,criteria), where range is the cell range for which you wish...

The Excel function VLOOKUP stands for vertical look up. It searches for a specified value in the first column of a table. It returns the value from the same row in a specified column of that...

Creating a table in Microsoft Excel 2007 allows you to work with that data independently of the rest of the worksheet. First you must define your table, though, which you can do either from...

When you name cells or groups of cells in a spreadsheet, it is called a range name. Using this can make your work easier to read and modify, plus it will make it easier for you to navigate your...

In Excel 2000, you can define names for cell ranges to make it easier to create and understand your formulas. For example, if the cells from J20 to J33 are all sources of income, you could name...