# Spreadsheets: Most Popular Articles

These articles are the most popular over the last month.

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 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 Multiply in Excel

How to multiply in Excel gives step by step instructions on how to multiply two numbers in Excel using a simple formula.

How to multiply in Excel gives step by step instructions on how to multiply two numbers in Excel using a simple formula.

Excel Beginner? Start Here

How to Use Excel is a series of free tutorials for the absolute beginner. Learn the names of Excel screen elements, how to enter data, how to use Excel formulas and functions, add/remove columns and rows, and how to create charts.

How to Use Excel is a series of free tutorials for the absolute beginner. Learn the names of Excel screen elements, how to enter data, how to use Excel formulas and functions, add/remove columns and rows, and how to create charts.

A Beginner's Guide to Excel Formulas

This tutorial covers basic information about formulas and includes a step by step example of how to create a formula in Excel. This tutorial is intended for those just getting started with Excel.

This tutorial covers basic information about formulas and includes a step by step example of how to create a formula in Excel. This tutorial is intended for those just getting started with Excel.

How to Divide in Excel

How to divide in Excel shows you how easy it is to divide two numbers using a formula. Also covered are #DIV/O! errors and how to calculate percents.

How to divide in Excel shows you how easy it is to divide two numbers using a formula. Also covered are #DIV/O! errors and how to calculate percents.

Quickly Sum Columns or Rows of Numbers in Excel

The Excel SUM function makes it easy to quickly sum or add up columns, rows, or individual cells of data in a worksheet.

The Excel SUM function makes it easy to quickly sum or add up columns, rows, or individual cells of data in a worksheet.

How to Use Excel to Count Days Between Two Dates

The tutorials listed here cover Excel functions that will count the number of days between two dates. Each tutorial includes a step by step example of using the functions.

The tutorials listed here cover Excel functions that will count the number of days between two dates. Each tutorial includes a step by step example of using the functions.

Learn a Basic Excel Formula with These Easy Tips

How to add in Excel shows you how easy it is to add two or more numbers together using a formula. Step by step instructions are included.

How to add in Excel shows you how easy it is to add two or more numbers together using a formula. Step by step instructions are included.

How to Create a Database in Excel

This step by step tutorial shows you how to create a database in Excel. The tutorial covers entering data, creating the database, and using the built in sorting and filter tools.

This step by step tutorial shows you how to create a database in Excel. The tutorial covers entering data, creating the database, and using the built in sorting and filter tools.

How to use Excel's VLOOKUP Function

How to use VLOOKUP in Excel to retrieve specific data from a database or table of data. Step by step instructions are included.

How to use VLOOKUP in Excel to retrieve specific data from a database or table of data. Step by step instructions are included.

Use Today's Date in Excel Worksheet Calculations

Use Excel's TODAY function in date calculations and to add the current date to a worksheet. Step by step instructions are included.

Use Excel's TODAY function in date calculations and to add the current date to a worksheet. Step by step instructions are included.

Generate Random Numbers with Excel's RANDBETWEE...

Use Excel's RANDBETWEEN function to generate random integers between two numbers that you choose. Use the function in coin toss and dice roller simulators.

Use Excel's RANDBETWEEN function to generate random integers between two numbers that you choose. Use the function in coin toss and dice roller simulators.

Finding the Average Value with Excel's AVERAGE...

Use Excel's AVERAGE function to find the average, or arithmetic mean for selected data. A step by step example is included.

Use Excel's AVERAGE function to find the average, or arithmetic mean for selected data. A step by step example is included.

5 Steps to Making/Formatting a Line Graph in...

This tutorial covers how to create and format a basic line graph in Microsoft Excel. The tutorial includes a step by step example.

This tutorial covers how to create and format a basic line graph in Microsoft Excel. The tutorial includes a step by step example.

Use Excel's NOW Function in Date and Time...

Use Excel's NOW function to add the current time or date to worksheets or for use in formulas. Step by step instructions are included.

Use Excel's NOW function to add the current time or date to worksheets or for use in formulas. Step by step instructions are included.

Take Advantage of a Free Flowchart Template for...

This article walks through how to download and use the free flowchart template available from Microsoft.

This article walks through how to download and use the free flowchart template available from Microsoft.

Test Multiple Conditions with Excel's AND and...

How to use the AND and/or OR function in Excel to test for multiple true or false conditions. A step by step example is included.

How to use the AND and/or OR function in Excel to test for multiple true or false conditions. A step by step example is included.

Easy as Pie Charts in Excel

Use a pie chart in Excel to show the percentage each slice of the pie represents of the total chart value. This tutorial includes a step by step example.

Use a pie chart in Excel to show the percentage each slice of the pie represents of the total chart value. This tutorial includes a step by step example.

Customize Cell Data with Excel's IF Function

Use Excel's IF function to customize data displayed in one or more worksheet cells based on conditions that you specify. A step by step example is included.

Use Excel's IF function to customize data displayed in one or more worksheet cells based on conditions that you specify. A step by step example is included.

Show Formulas in Excel using Shortcut Keys

Show the formulas in a Excel worksheet instead of the formulas' answers. Use this feature to quickly and easily check and find errors in formulas.

Show the formulas in a Excel worksheet instead of the formulas' answers. Use this feature to quickly and easily check and find errors in formulas.

Cell Reference

Definition of the terms cell reference, relative cell reference, absolute cell reference, and mixed cell reference as used in spreadsheet programs such as Excel and Google Spreadsheets.

Definition of the terms cell reference, relative cell reference, absolute cell reference, and mixed cell reference as used in spreadsheet programs such as Excel and Google Spreadsheets.

Worksheet

class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: A

class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: A

Keep Column & Row Headings On Screen with...

Freezing panes in Excel keeps the headings at the top and down the side of the sheet from disappearing while scrolling. A step by step example is included.

Freezing panes in Excel keeps the headings at the top and down the side of the sheet from disappearing while scrolling. A step by step example is included.

A Simple Guide to Data Entry Forms in Excel

This tutorial covers how to use a data entry form to add data to a database in Excel. A step by step example of how to create and use a data entry form is included in the tutorial.

This tutorial covers how to use a data entry form to add data to a database in Excel. A step by step example of how to create and use a data entry form is included in the tutorial.

Google Spreadsheet's IF Function

The IF function lets you set conditions and returns different results depending on whether the condition is TRUE or FALSE. A step by step example is included.

The IF function lets you set conditions and returns different results depending on whether the condition is TRUE or FALSE. A step by step example is included.

Absolute Cell References

Definition of the term Absolute Cell Reference as used in Excel and Google Spreadsheets.

Definition of the term Absolute Cell Reference as used in Excel and Google Spreadsheets.

How to Add, Subtract, Divide, and Multiply in...

These tutorial cover how to carry out basic math operations in Excel using formulas. The tutorials cover how to add, subtract, multiply, or divide numbers in Excel using formulas.

These tutorial cover how to carry out basic math operations in Excel using formulas. The tutorials cover how to add, subtract, multiply, or divide numbers in Excel using formulas.

6 Ways to Sort Data in Excel

Six ways to sort data values in Excel - includes quick sorts on one column, sorting by date or time, multi-column sorts, and sorting by custom lists.

Six ways to sort data values in Excel - includes quick sorts on one column, sorting by date or time, multi-column sorts, and sorting by custom lists.

Row

: Rows run horizontally in an Excel worksheet . Each row is identified by a number in the row header

: Rows run horizontally in an Excel worksheet . Each row is identified by a number in the row header

Generate Random Numbers with Excel's RAND...

Use Excel's RAND function to generate random numbers between zero and one, one and ten or any other chosen range. A step by step example is included.

Use Excel's RAND function to generate random numbers between zero and one, one and ten or any other chosen range. A step by step example is included.

Range

class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: A

class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: A

Make a Column Chart in Excel

This tutorial covers how to create and format a column chart in Microsoft Excel. The tutorial includes a step by step example.

This tutorial covers how to create and format a column chart in Microsoft Excel. The tutorial includes a step by step example.

#NULL!, #REF!, #DIV/0!, and ##### Errors in Excel

The main causes for #NULL!, #REF!, #DIV/0!, and ##### errors in Excel worksheets are listed along with the most likely cures for these problems.

The main causes for #NULL!, #REF!, #DIV/0!, and ##### errors in Excel worksheets are listed along with the most likely cures for these problems.

Excel's Fill Down Command

Copy data to multiple cells in Excel using a keyboard shortcut.

Copy data to multiple cells in Excel using a keyboard shortcut.

Function

class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: A

class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: A

Cell

class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: In

class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: In

Spreadsheet

Definition of the term spreadsheet as it is used in Excel and Google Spreadsheets.

Definition of the term spreadsheet as it is used in Excel and Google Spreadsheets.

Convert Angles from Radians to Degrees in Excel

Use the DEGREES function in Excel to convert angles measured in radians to degrees. A step by step example of converting radians to degrees

Use the DEGREES function in Excel to convert angles measured in radians to degrees. A step by step example of converting radians to degrees

Column

class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: Columns

class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: Columns

10 Spreadsheet Terms Every Excel User Should Know

Ten of the most common spreadsheet terms and definitions used in programs such as Excel, Microsoft Works, and Google Docs Spreadsheets

Ten of the most common spreadsheet terms and definitions used in programs such as Excel, Microsoft Works, and Google Docs Spreadsheets

7 DOs and DON'Ts of Data Entry in Excel

Entering data DOs and DON'Ts covers the dangers of blank rows and columns, and why locking formulas, sorting, saving, and cell references are good in Excel.

Entering data DOs and DON'Ts covers the dangers of blank rows and columns, and why locking formulas, sorting, saving, and cell references are good in Excel.

Excel SUM - INDIRECT Dynamic Range Formula

Combine Excel's INDIRECT and SUM functions can make it easy to change the range of data added up by the formula. Step by step instructions are included.

Combine Excel's INDIRECT and SUM functions can make it easy to change the range of data added up by the formula. Step by step instructions are included.

Select Rows, Columns, and Worksheets in Excel...

How to quickly select entire rows, columns, data table, or worksheets or data tables in Excel using shortcut keys or the mouse. Step by step instructions are included.

How to quickly select entire rows, columns, data table, or worksheets or data tables in Excel using shortcut keys or the mouse. Step by step instructions are included.

Add/Format Dates and Times in Excel using...

Add and format the current date or time in Excel using keyboard shortcuts. Step by step examples are included.

Add and format the current date or time in Excel using keyboard shortcuts. Step by step examples are included.

Nesting the AND, OR and IF Functions in Excel

By nesting or combining the OR and/or AND functions with Excel's IF function, the range of conditions tested for in the worksheet can be greatly increased.

By nesting or combining the OR and/or AND functions with Excel's IF function, the range of conditions tested for in the worksheet can be greatly increased.

Finding Squares Roots, Cube Roots, and nth...

How to find square, cube, and nth roots in Excel using exponents and functions in formulas. A step by step example is included.

How to find square, cube, and nth roots in Excel using exponents and functions in formulas. A step by step example is included.

Finding the Arithmetic Mean with the AVERAGE...

Use Google Spreadsheets AVERAGE function to find the average, or arithmetic mean, of values for selected data. A step by step example is included.

Use Google Spreadsheets AVERAGE function to find the average, or arithmetic mean, of values for selected data. A step by step example is included.

Identifying Excel Screen Elements

This labeled diagram identifies the main elements of the Excel screen. Descriptions for each element are included.

This labeled diagram identifies the main elements of the Excel screen. Descriptions for each element are included.

3 Ways to Sort by Color in Excel

Sorting by Color in Excel In addition to sorting by values - such as text or numbers - Excel has custom

Sorting by Color in Excel In addition to sorting by values - such as text or numbers - Excel has custom

Formatting Numbers in Excel

Applying currency, percent, or number formatting using shortcut keys and ribbon options in Excel. Step by step instructions are included.

Applying currency, percent, or number formatting using shortcut keys and ribbon options in Excel. Step by step instructions are included.

Ribbon

How to customize the ribbon in Microsoft Excel and other Microsoft Office programs. Step by step instructions are included..

How to customize the ribbon in Microsoft Excel and other Microsoft Office programs. Step by step instructions are included..

Moving Around and Between Worksheets in Excel

How to move around and between worksheets in Excel using keyboard shortcuts keys, the Name Box, and Go To. Step by step instructions are included.

How to move around and between worksheets in Excel using keyboard shortcuts keys, the Name Box, and Go To. Step by step instructions are included.

When Excel's TRIM Function Doesn't Work -...

If the TRIM function on its own can't remove extra spaces from text data, try this alternative formula using the TRIM, SUBSTITUTE and CHAR functions.

If the TRIM function on its own can't remove extra spaces from text data, try this alternative formula using the TRIM, SUBSTITUTE and CHAR functions.

Understanding Excel's Goal Seek Function

Excel's Goal Seek feature allows you to alter data in formulas to get different results. Goal Seek can be used when planning new projects. Cost projections for different scenarios can be quickly created and the results compared.

Excel's Goal Seek feature allows you to alter data in formulas to get different results. Goal Seek can be used when planning new projects. Cost projections for different scenarios can be quickly created and the results compared.

Need a Timeline Template for Excel? This One's...

Among the templates offered for free by Microsoft is one for creating a timeline in Excel. This template works in all versions from Excel 97 on. This article walks through how to download and use the timeline template in Excel.

Among the templates offered for free by Microsoft is one for creating a timeline in Excel. This template works in all versions from Excel 97 on. This article walks through how to download and use the timeline template in Excel.

How to Lock Cells and Protect Worksheets in Excel

Use Excel's security features to protect specific cells containing formulas and other important data by locking cells and protecting the worksheet.

Use Excel's security features to protect specific cells containing formulas and other important data by locking cells and protecting the worksheet.

Bothered by Excel AutoComplete? Here's How to...

How to disable or re-enable Excel's AutoComplete feature. Step by step instructions are included.

How to disable or re-enable Excel's AutoComplete feature. Step by step instructions are included.

Excel SUM OFFSET Formula Tutorial

By combining Excel's OFFSET function with the SUM function you can create formulas that will find totals for dynamic ranges of data.

By combining Excel's OFFSET function with the SUM function you can create formulas that will find totals for dynamic ranges of data.

Organize and Find Data without Formulas using...

Excel pivot tables makes it easy to organize and extract information from tables of data without the use of formulas. A step by step example is included.

Excel pivot tables makes it easy to organize and extract information from tables of data without the use of formulas. A step by step example is included.

Free Excel Templates From Microsoft

This article covers templates in Excel: how to make your own as well as free templates that you can download.

This article covers templates in Excel: how to make your own as well as free templates that you can download.

Counting Numbers with Excel's COUNT Function...

Use Excel's COUNT function or Counting Numbers shortcut to count only those cells in a range containing numbers. A step by step example is included.

Use Excel's COUNT function or Counting Numbers shortcut to count only those cells in a range containing numbers. A step by step example is included.

Use Custom Conditional Formatting Rules for...

Using formulas to customize conditional formatting rules in Excel. This tutorial uses a date formula and conditional formatting to highlight past due dates. A step by step example is included.

Using formulas to customize conditional formatting rules in Excel. This tutorial uses a date formula and conditional formatting to highlight past due dates. A step by step example is included.

Relative Cell References

Definition of the term Relative Cell Reference as it is used in spreadsheet programs such as Excel and Google Spreadsheets.

Definition of the term Relative Cell Reference as it is used in spreadsheet programs such as Excel and Google Spreadsheets.

COUNTIF - COUNTA Percentage Formula

Find the percentage of yes or no responses in a data range using the COUNTIF and COUNTA functions in Excel. The same formula can be used to find the percentage of any one value - not just yes and no. This tutorial includes a step by step example.

Find the percentage of yes or no responses in a data range using the COUNTIF and COUNTA functions in Excel. The same formula can be used to find the percentage of any one value - not just yes and no. This tutorial includes a step by step example.

A Free Excel Biweekly Time Sheet Template from...

This article shows you how to quickly download and use a free employee time sheet template in Excel.

This article shows you how to quickly download and use a free employee time sheet template in Excel.

Workbook

Definition of the term workbook as it is used in Excel and Google Spreadsheets.

Definition of the term workbook as it is used in Excel and Google Spreadsheets.

How to Subtract in Google Spreadsheets

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

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

Charts and Graphs

class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: Charts

class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: Charts

Active Cell

Definition of the term Active Cell as it is used in spreadsheet programs such as Excel and Google Spreadsheets.

Definition of the term Active Cell as it is used in spreadsheet programs such as Excel and Google Spreadsheets.

Dialog Box

class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: A

class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: A

Column and Row Headings

Definition of the terms column and row headings or headers as they are used in Excel and Google Spreadsheets.

Definition of the terms column and row headings or headers as they are used in Excel and Google Spreadsheets.

How to Use the AutoMAX Function in Excel

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'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.

Formula Bar

: The formula bar in Excel is located above the work area of the spreadsheet . The formula bar displays

: The formula bar in Excel is located above the work area of the spreadsheet . The formula bar displays

Syntax

Spreadsheet definition - Syntax. This glossary entry defines the term syntax as it is used in Excel and Google Spreadsheets

Spreadsheet definition - Syntax. This glossary entry defines the term syntax as it is used in Excel and Google Spreadsheets

Copy Formulas and Data with Excel's Fill Handle

Use Excel Fill Handle to copy formulas, data, a series of numbers, days of the week, and months of the year. Step by step examples are included.

Use Excel Fill Handle to copy formulas, data, a series of numbers, days of the week, and months of the year. Step by step examples are included.

How to Add Headers and Footers to Excel...

How to add headers and footers to worksheets in Excel.

How to add headers and footers to worksheets in Excel.

How to Make a Stock Market High, Low, and Close...

This tutorial covers creating a High-Low-Close stock market chart in Microsoft Excel. The tutorial includes a step by step example of creating a High-Low-Close stock market chart in Excel.

This tutorial covers creating a High-Low-Close stock market chart in Microsoft Excel. The tutorial includes a step by step example of creating a High-Low-Close stock market chart in Excel.

Replace or Add Characters to Data with Excel's...

Use Excel's REPLACE function to replace bad text data with good data or with nothing at all. A step by step example is included.

Use Excel's REPLACE function to replace bad text data with good data or with nothing at all. A step by step example is included.

Argument

Definition of the term arguments as used in Excel and Google Spreadsheets

Definition of the term arguments as used in Excel and Google Spreadsheets

'Table Array

Table Array. Spreadsheets terms - definition of the term table array as used in spreadsheets such as Excel.

Table Array. Spreadsheets terms - definition of the term table array as used in spreadsheets such as Excel.

Adding Borders in Excel Using Shortcut Keys

Adding and formatting borders in Excel using shortcut keys and options on the ribbon. Step by step instructions are included.

Adding and formatting borders in Excel using shortcut keys and options on the ribbon. Step by step instructions are included.

How to Use Excel's 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.

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.

Paste Links for Data, Charts, and Formulas in...

Paste links for data, charts and formulas in Excel, Word and PowerPoint that update between source and destination files. Step by step examples included.

Paste links for data, charts and formulas in Excel, Word and PowerPoint that update between source and destination files. Step by step examples included.

How to Use QUOTIENT Functions in Excel

The QUOTIENT function is used to divide numbers in Excel. This tutorial includes an example to walk you through using the 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.

Choosing the Right Graph - Excel Graphs and...

This article covers the main types of Excel graphs and their uses. The graphs covered include the bar graph, line graph, scatter plot graph, and the pie chart.

This article covers the main types of Excel graphs and their uses. The graphs covered include the bar graph, line graph, scatter plot graph, and the pie chart.

Convert Angles from Degrees to Radians in Excel

Use the RADIANS function to convert angles measured in degrees into radians for use with Excel's trig functions. A step by step example is included.

Use the RADIANS function to convert angles measured in degrees into radians for use with Excel's trig functions. A step by step example is included.

Label

class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: The

class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: The

Macro

class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: An

class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: An

Rank Numbers by Numerical Value with Excel's...

Use the RANK function in Excel to rank the value of a number compared to other numbers in a list. A step by step example is included.

Use the RANK function in Excel to rank the value of a number compared to other numbers in a list. A step by step example is included.

Excel Rolling Dice Tutorial

This tutorial covers how to create a pair of rolling dice in Excel. The tutorial makes use of the IF, AND, OR, and RANDBETWEEN functions to simulate the rolling of a pair of dice.

This tutorial covers how to create a pair of rolling dice in Excel. The tutorial makes use of the IF, AND, OR, and RANDBETWEEN functions to simulate the rolling of a pair of dice.

Google Spreadsheet Formula Tutorial

This tutorial covers creating and using a simple Google Spreadsheet formula. The tutorial includes a step by step example of creating a Google Spreadsheet formula.

This tutorial covers creating and using a simple Google Spreadsheet formula. The tutorial includes a step by step example of creating a Google Spreadsheet formula.

Changing Column Widths and Row Heights in Excel...

How to change column widths and row heights in Excel and Google Spreadsheets using the mouse or menu options. Step by step are included.

How to change column widths and row heights in Excel and Google Spreadsheets using the mouse or menu options. Step by step are included.

Shade Alternate Rows in Excel with Conditional...

This tutorial covers shading alternate rows of data in Excel using a formula and conditional formatting. A step by step example is included.

This tutorial covers shading alternate rows of data in Excel using a formula and conditional formatting. A step by step example is included.

How to Use the MIN Function in Excel

The MIN function is used to find the smallest or minimum value in a given list of numbers. This tutorial includes a step by step example on using the MIN function in Excel.

The MIN function is used to find the smallest or minimum value in a given list of numbers. This tutorial includes a step by step example on using the MIN function in Excel.

Data

class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: Data

class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: Data

Transpose or Flip Rows or Columns of Data in...

Use Excel's TRANSPOSE function to switch or flip data from a row into a column or from a column into a row. A step by step example is included.

Use Excel's TRANSPOSE function to switch or flip data from a row into a column or from a column into a row. A step by step example is included.

Name Box

Definition of the term Name Box as it is used in Excel and Google Spreadsheets.

Definition of the term Name Box as it is used in Excel and Google Spreadsheets.

Excel UPPER Function

Use the UPPER function in Excel to convert text data to all upper case letters (capital letters). A step by step example is included.

Use the UPPER function in Excel to convert text data to all upper case letters (capital letters). A step by step example is included.

Excel AutoFormat

Excel's Autoformat option gives you 17 AutoFormat styles to use to give your spreadsheets a professional look. Instructions on how to apply an autoformat style are included.

Excel's Autoformat option gives you 17 AutoFormat styles to use to give your spreadsheets a professional look. Instructions on how to apply an autoformat style are included.

Find the Middle or Median Value in a Range of...

Find the middle value in a list of numbers with the MEDIAN function in Excel. A step by step example is included.

Find the middle value in a list of numbers with the MEDIAN function in Excel. A step by step example is included.

Value

class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: The

class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: The

Excel's HLOOKUP Function

Excel’s HLOOKUP function is used to find specific information that has been stored in a table of data stored in a spreadsheet. This tutorial includes an example of how to use the HLOOKUP function in Excel.

Excel’s HLOOKUP function is used to find specific information that has been stored in a table of data stored in a spreadsheet. This tutorial includes an example of how to use the HLOOKUP function in Excel.

Creating Custom Conditional Formatting Rules in...

Use formulas to create custom conditional formatting rules in Excel. This tutorial includes a step by step example on using a formula to create a custom conditional formatting rule.

Use formulas to create custom conditional formatting rules in Excel. This tutorial includes a step by step example on using a formula to create a custom conditional formatting rule.

Database

class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: A

class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: A

Count Data that Matches Set Criterion with...

Use Google Spreadsheets' COUNTIF function to find the number of cells in a range that meet criteria that you specify. A step by step example is included.

Use Google Spreadsheets' COUNTIF function to find the number of cells in a range that meet criteria that you specify. A step by step example is included.

Nesting the ROUND and SUM Functions in Excel

Nesting the SUM and ROUND functions in Excel combines the operations of these two functions in a single worksheet cell. A step by step example is included.

Nesting the SUM and ROUND functions in Excel combines the operations of these two functions in a single worksheet cell. A step by step example is included.

6 Steps to Customizing a Column Chart in Excel

Change the column colors and show percent values for a single data series in an Excel column chart - 6 steps max. A step by step example is included.

Change the column colors and show percent values for a single data series in an Excel column chart - 6 steps max. A step by step example is included.

Count Cells with Text or Other Data with...

Use Excel's COUNTA function to count cells containing text or other types of data. Blank cells are ignored. Step by step instructions are included.

Use Excel's COUNTA function to count cells containing text or other types of data. Blank cells are ignored. Step by step instructions are included.

How to Calculate Due Dates with Excel's...

The EOMONTH function can be used to calculate a due date of a project or investment that falls on at the end of the month. This article includes an example of using the EOMONTH function to calculate a due date in Excel 2007.

The EOMONTH function can be used to calculate a due date of a project or investment that falls on at the end of the month. This article includes an example of using the EOMONTH function to calculate a due date in Excel 2007.

Round Numbers Up or Down to the Nearest 5 or 10...

Round numbers up or down to the nearest 5, 10, or other specified multiple in Excel. Step by step instructions are included.

Round numbers up or down to the nearest 5, 10, or other specified multiple in Excel. Step by step instructions are included.

How to Use Freeze Panes to Lock Columns and...

Lock Columns and Rows in Excel 2003 with Freeze Panes Related tutorial: Excel 2007 / 2010 Freeze Panes

Lock Columns and Rows in Excel 2003 with Freeze Panes Related tutorial: Excel 2007 / 2010 Freeze Panes

How to Use 'DAYS360' Functions in Excel

The Excel DAYS360 Function can be used in accounting systems to calculate the number of days between two dates based on a 360-day year(twelve 30-day months). This tutorial includes a step by step example of using the DAYS360 function in Excel.

The Excel DAYS360 Function can be used in accounting systems to calculate the number of days between two dates based on a 360-day year(twelve 30-day months). This tutorial includes a step by step example of using the DAYS360 function in Excel.

Text String

class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: A

class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: A

Open Office Calc Tutorial - Step by Step

This tutorial covers creating a basic spreadsheet in Open Office Calc. The topics covered include how to enter data, using formulas and functions, and formatting the spreadsheet.

This tutorial covers creating a basic spreadsheet in Open Office Calc. The topics covered include how to enter data, using formulas and functions, and formatting the spreadsheet.

Convert Text to Numbers with Excel Paste Special

Use Paste Special in Excel to convert values from text to numbers so they can be used in calculations. A step by step example is included.

Use Paste Special in Excel to convert values from text to numbers so they can be used in calculations. A step by step example is included.

Arithmetic Operators

Definition of the term arithmetic or mathematical operators as used in Excel and Google Spreadsheets.

Definition of the term arithmetic or mathematical operators as used in Excel and Google Spreadsheets.

Boolean Value

Boolean value definition as used in Excel and Google Spreadsheets. How Boolean values are used in formulas.

Boolean value definition as used in Excel and Google Spreadsheets. How Boolean values are used in formulas.

Find the Sine of an Angle in Excel

Use Excel's SIN function to find the sine of an angle measured in radians. A step by step example is included.

Use Excel's SIN function to find the sine of an angle measured in radians. A step by step example is included.

OpenOffice Calc Formulas Tutorial

This step by step tutorial covers creating formulas in OpenOffice Calc. This tutorial covers the basics of creating a formula in Openoffice Calc.

This step by step tutorial covers creating formulas in OpenOffice Calc. This tutorial covers the basics of creating a formula in Openoffice Calc.

Highlight Cells

class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: To

class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: To

How to Use the MONTH Function in Excel

Use the MONTH function to subtract dates in Excel. This tutorial includes an example of using the MONTH function to subtract two dates in Excel.

Use the MONTH function to subtract dates in Excel. This tutorial includes an example of using the MONTH function to subtract two dates in Excel.

Sort Order

class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: Sorting

class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: Sorting

How to Print the Gridlines and Headings on Your...

This article shows you how to print gridlines and headings in Excel. A step by step example is included showing you how to print gridlines and headings in Excel.

This article shows you how to print gridlines and headings in Excel. A step by step example is included showing you how to print gridlines and headings in Excel.

Find Information in Data Tables with Excel's...

The Array form of Excel's LOOKUP function can be used to find a single value from a multi-row or multi-column range of data. A step by step example is included.

The Array form of Excel's LOOKUP function can be used to find a single value from a multi-row or multi-column range of data. A step by step example is included.

A Quick Guide to Using Formatting and Charting...

This list of Excel tips will give you straightforward answers on how to carry out a variety of tasks in Microsoft Excel.

This list of Excel tips will give you straightforward answers on how to carry out a variety of tasks in Microsoft Excel.

Convert Case with Excel's PROPER Function

The PROPER function is used to convert text data to proper case letters (combination upper and lower case). A step by step example is included.

The PROPER function is used to convert text data to proper case letters (combination upper and lower case). A step by step example is included.

A Quick Guide to Using PRODUCT Function to...

In Excel, the PRODUCT function can be used for multiplying numbers or a range of values together. A function is just a built-in formulas. Functions have been added to simplify performing specific mathematical operations in the spreadsheet.

In Excel, the PRODUCT function can be used for multiplying numbers or a range of values together. A function is just a built-in formulas. Functions have been added to simplify performing specific mathematical operations in the spreadsheet.

Find the Smallest Number in Excel with AutoMIN

This article shows you how to use the AutoMIN function, a shortcut to using Excel's MIN function to find the smallest number in a list. Included is a step by step example of using the AutoMIN function.

This article shows you how to use the AutoMIN function, a shortcut to using Excel's MIN function to find the smallest number in a list. Included is a step by step example of using the AutoMIN function.

Find Duplicate or Unique Data in Excel with...

Find and highlight duplicate or unique data in Excel with conditional formatting. A step by step example is included.

Find and highlight duplicate or unique data in Excel with conditional formatting. A step by step example is included.

Using Labels in Excel Formulas and Functions

Using labels in functions and formulas in Excel 2003 is a easy way to refer to a block of data in an Excel spreadsheet. Labels refer to the data directly under or to the right of a label such as

Using labels in functions and formulas in Excel 2003 is a easy way to refer to a block of data in an Excel spreadsheet. Labels refer to the data directly under or to the right of a label such as

How to Use Excel's 'DGET' Function to Summarize...

The DGET function is one of Excel's database functions. It is used to count the number of records in a database that meet specific conditions that you set. A step by step example is included in this tutorial.

The DGET function is one of Excel's database functions. It is used to count the number of records in a database that meet specific conditions that you set. A step by step example is included in this tutorial.

How to Divide in Google Spreadsheets

How to divide in Google Spreadsheets shows you how easy dividing numbers can be. The tutorial includes a step by step example of how to divide two numbers in Google Spreadsheets.

How to divide in Google Spreadsheets shows you how easy dividing numbers can be. The tutorial includes a step by step example of how to divide two numbers in Google Spreadsheets.

An Easy Guide to Creating Pictographs in Excel

In a pictograph or pictogram, pictures replace the colored columns or bars in a regular bar graph. This step by step tutorial shows you how to create a pictograph in Excel.

In a pictograph or pictogram, pictures replace the colored columns or bars in a regular bar graph. This step by step tutorial shows you how to create a pictograph in Excel.

Count Cells that Meet Multiple Criteria with...

Use Excel's SUMPRODUCT function to count cells containing data that meets multiple criteria that you set. A step by step example is included.

Use Excel's SUMPRODUCT function to count cells containing data that meets multiple criteria that you set. A step by step example is included.

How to Locate and Display an Excel Toolbar

This quick tip shows you how to find and show a toolbar that isn't visible in Excel. Good for finding a toolbar in Excel 97 to Excel 2003.

This quick tip shows you how to find and show a toolbar that isn't visible in Excel. Good for finding a toolbar in Excel 97 to Excel 2003.

How to Get Started Using Spreadsheets in...

Beginners Guide to Microsoft Works Spreadsheets is a series of articles and tutorials for the absolute beginner. Learn about the parts of the Microsoft Works Spreadsheets screen, how to enter data, how to use formulas and functions, adding and removing columns and rows, how to create charts, and how to use the program's format options.

Beginners Guide to Microsoft Works Spreadsheets is a series of articles and tutorials for the absolute beginner. Learn about the parts of the Microsoft Works Spreadsheets screen, how to enter data, how to use formulas and functions, adding and removing columns and rows, how to create charts, and how to use the program's format options.

Subtract Dates in Excel with the YEAR Function

Use the YEAR function to subtract dates in Excel. This tutorial includes an example of using the DAY function to subtract two dates in Excel.en two dates.

Use the YEAR function to subtract dates in Excel. This tutorial includes an example of using the DAY function to subtract two dates in Excel.en two dates.

A Quick Guide to Using Excel's Clipboard Feature

This tutorial shows you how to use the clipboard in Excel to simplify re-entering frequently used data.

This tutorial shows you how to use the clipboard in Excel to simplify re-entering frequently used data.

Excel VLOOKUP Example

Using the VLOOKUP function in Excel to find the discount pricing of an item based on the amount purchased. A step by step example is included.

Using the VLOOKUP function in Excel to find the discount pricing of an item based on the amount purchased. A step by step example is included.

Conditionally Formatting Above/Below Average...

Find and display data that is above or below the average value using Excel's built-in conditional formatting. Step by step instructions are included.

Find and display data that is above or below the average value using Excel's built-in conditional formatting. Step by step instructions are included.

Copy Formatting Between Cells with Excel's...

Quickly copy formatting options from one cell or group of cells to another with Excel's format painter. Step by step instructions are included.

Quickly copy formatting options from one cell or group of cells to another with Excel's format painter. Step by step instructions are included.

How to Use Spreadsheets Formulas in MS Works

Formulas in a MS Works Spreadsheets are one of the most useful features of the program. Once you learn the basic steps of creating a formula, MS Works does all the calculations for you.

Formulas in a MS Works Spreadsheets are one of the most useful features of the program. Once you learn the basic steps of creating a formula, MS Works does all the calculations for you.

Find the Largest Negative or Positive Number in...

Use the 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.

Use the 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.

Data Label Definition

class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: In

class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: In

How to Combine Chart Types in Excel

Combine two or more chart or graph types in Excel 2010 in order to display related information together. This tutorial combines a column chart and line graph using a second Y axis.

Combine two or more chart or graph types in Excel 2010 in order to display related information together. This tutorial combines a column chart and line graph using a second Y axis.

How to Use the DAY Function in Excel

Use the DAY function to subtract dates in Excel. This tutorial includes an example of using the DAY function to subtract two dates in Excel.

Use the DAY function to subtract dates in Excel. This tutorial includes an example of using the DAY function to subtract two dates in Excel.

Emphasizing Chart Data - Exploding Pie Charts...

Explode out a single slice of an Excel pie chart or create pie of pie or bar of pie charts to emphasize important data. Step by step instructions included.

Explode out a single slice of an Excel pie chart or create pie of pie or bar of pie charts to emphasize important data. Step by step instructions included.