1. Tech

Your suggestion is on its way!

An email with a link to:

http://spreadsheets.about.com/popular.htm

was emailed to:

Thanks for sharing About.com with others!

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.
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.
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 Multiply in Excel
How to multiply in Excel shows you how to easily multiply numbers in Excel using a formula. The tutorial includes a step by step example of how to multiply two numbers in Excel.
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.
Add Today's Date with the "TODAY" Function in...
Use the TODAY function to add today's date to a worksheet in Excel. A step by step example is included.
Learn a Basic Excel Formula with These Easy Tips
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.
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.
How to Divide in Excel
How to divide in Excel shows you how easy it is to dividing numbers in Excel can be. The tutorial includes a step by step example of how to divide two numbers in Excel.
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.
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 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.
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.
What is Microsoft Excel and When Would I Use it?
What is Microsoft Excel? It is an electronic spreadsheet program used for storing, organizing and manipulating data. Excel uses formulas to perform mathematical calculations ranging from the simple to the very complex. The program can also be used for graphing data.
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.
Excel's RANDBETWEEN Function
Use Excel's RANDBETWEEN function to generate a random integer between two values that you specify - such as one and ten.
Using Date Functions in Excel: A Quick How-To
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.
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.
Take Advantage of a Free Flowchart Template for...
This article walks through how to download and use the free flowchart template available from Microsoft.
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.
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.
Syntax
Spreadsheet definition - Syntax. This glossary entry defines the term syntax as it is used in Excel and Google Spreadsheets
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.
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.
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.
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.
Worksheet
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.
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.
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.
How Does the CONCATENATE Function in Excel Work?
The CONCATENATE function is used to join two or more words or text strings together. This tutorial includes a step by step example of using Excel's CONCATENATE function.
Which Excel Function Calculates the Number of...
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.
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.
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.
Formatting Numbers in Excel
Applying currency, percent, or number formatting using shortcut keys and ribbon options in Excel. 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.
Excel's Fill Down Command
Copy data to multiple cells in Excel using a keyboard shortcut.
Ribbon
Definition of the term. Spreadsheets.
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.
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.
Excel TRIM Function Alternative Formula
The TRIM function cannot always remove extra spaces from text data. An alternative formula for removing extra spaces from data in Excel is covered in this example.
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.
Adding/Formatting the Date and Time in Excel...
The keyboard shortcut and the functions listed below can be used to add the current date to an Excel spreadsheet. Each tutorial includes step by step examples of working with dates in Excel.
Function
class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: A
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
Spreadsheet
Definition of the term spreadsheet as it is used in Excel and Google Spreadsheets.
Which Function Do You Use to Find the Square...
This article covers finding the square root of numbers in Excel. The article includes a step by step example of finding square roots in Excel.
Absolute Cell References
Definition of the term Absolute Cell Reference as used in Excel and Google Spreadsheets.
Excel Can Subtract Dates With These Commands
There are a number of functions in Excel that can be used to subtract dates. They can be used to subtract days, months, or years. The following tutorials include examples of subtracting two dates in Excel using the different date functions.
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.
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.
Bothered by Excel AutoComplete? Here's How to...
This quick tip covers how to turn AutoComplete on or off in Excel.
Row
: Rows run horizontally in an Excel worksheet . Each row is identified by a number in the row header
How to Find the Weighted Average in Excel
This tutorial covers finding the weighted average for data using Excel's SUMPRODUCT function. A step by step example is included with the tutorial.
Using a Dynamic Range in Excel Formulas
Excel's INDIRECT function makes it easy to create a dynamic range of cell references in formulas without having to edit the formula itself. This tutorial combines INDIRECT with the SUM function to create an easy way to change the range of data added up by the formula. A step by step example is included.
Here's How to Fix '#REF!' Errors in Excel
A #REF! error message in Excel refers to an invalid cell reference. Read this article to find the causes and cures for this common problem.
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.
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.
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.
Cell
class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: In
Column
class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: Columns
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.
Identifying Excel Screen Elements
This labeled diagram identifies the main elements of the Excel screen. Descriptions for each element are included.
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.
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.
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
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.
Transpose Rows to Columns in Excel
The TRANSPOSE function is used to transfer data located in a row into a column or data located in a column into a row. This tutorial includes a step by step example of using Excel's TRANSPOSE function
Range
class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: A
Understanding Excel's Conditional Formatting
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.
Understanding Excel's COUNT Function
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
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
Dialog Box
class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: A
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.
How to Perform Basic Calculations in Excel...
This series of Excel Tutorials will teach you the basics of using formulas and functions to perform basic calculations in Excel spreadsheets.
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 Add Headers and Footers to Excel...
How to add headers and footers to worksheets in Excel.
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.
Create a Bar Graph in Excel
This tutorial covers creating a bar graph (or column chart in Microsoft Excel. This tutorial includes a step by step example of creating a bar graph in Excel.
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.
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.
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.
How to Use Excel's 'REPLACE' Function to...
The REPLACE function is used to replace unwanted characters with good data. The tutorial includes a step by step example.
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.
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.
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.
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.
How to Fix '#####' Error Messages in Excel
A ##### error message in Excel can be caused by several factors. This article discusses the causes and cures for this common error in Excel.
Formula Bar
: The formula bar in Excel is located above the work area of the spreadsheet . The formula bar displays
Name Box
Definition of the term Name Box 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.
Active Cell
Definition of the term Active Cell as it is used in spreadsheet programs such as Excel and Google Spreadsheets.
Workbook
Definition of the term workbook as it is used in Excel and Google Spreadsheets.
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.
'Table Array
Table Array. Spreadsheets terms - definition of the term table array as used in spreadsheets such as Excel.
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.
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.
Data
class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: Data
Undoing Changes or Mistakes in Excel
class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >This Excel shortcut
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.
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
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.
Convert Angles from Degrees to Radians in Excel
Use Excel's RADIANS function to easily convert angles measured in degrees into radians for use with Excel's trig functions.
Argument
Definition of the term arguments as used in Excel and Google Spreadsheets
How Do I Use the Undo and Redo Buttons in Excel...
The Undo and Redo commands are wonderful features in Excel spreadsheets. You can undo errors easily or have Excel redo a specific formatting on a different area of the spreadsheet, saving you time.
Create a Column Chart with the Excel Chart Wizard
How to create a column chart with the Excel Chart Wizard. 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.
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.
How to Use the AutoCOUNT Function in Excel
Excel's AutoCount feature uses the COUNT function to total cells in a range that contain numbers. Astep by step example is included with the tutorial.
How to Find Duplicates in Excel With Conditiona...
This tutorial shows you how find duplicate data - formulas, numbers, dates, data records - in Excel using conditional formatting. The tutorial includes a step by step example of using conditional formatting to find duplicates in Excel.
Tips and Tricks for Formulas in Microsoft Excel
This list of Excel tips on formulas will give you straightforward answers on how to carry out a variety of tasks related to formulas in Microsoft Excel.
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.
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.
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.
Chart
class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: Charts
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.
How to Use the COUNT Function in Google...
The COUNT function in Google Spreadsheets is used to count up the cells in a selected range that contain numbers - the function ignores blank cells, text and other types of data. This tutorial includes a step by step example .
What is a Mixed Cell Reference in Excel?
Mixed Cell Reference. Spreadsheets Terms - Definition of the term mixed cell reference as used in spreadsheets such as Excel.
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.
How Conditional Formatting Works in Excel
Adding conditional formatting to a cell in Excel allows you to apply different formatting options, such as color, to a cell or cells based on the data entered into the cell(s). This tutorial includes an example of using conditional formatting to find above and below average values.
Open Office Calc Basic Spreadsheet Tutorial
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.
Excel Error Message Help
If you get an error message in Excel you might not get much help from the program in finding out the cause. The articles listed here cover the cause and cures for a number of common error messages in Excel, such as #REF!, #NULL!, and #####.
Macros
class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: An
How to Count the Days Between Dates in Excel...
Converting imported text to dates in an Excel worksheet using the DATEVALUE function. A step by step example is included.
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.
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.
How to Create a Drop Down List in Excel Part 2
Use a drop down list in Excel to make data entry easier or to limit what data can be added to a spreadsheet. This tutorial shows you how to create a drop down list in Excel sing data from a different worksheet.
How to Use the COUNTIF Function in a Google...
The COUNTIF function in a Google Spreadsheets is used to count up the number of cells in a selected range that meet criteria that you specify. An example of using the COUNTIF function is included in this tutorial.
Highlight Cells
class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: To
How to Use 'YEAR' Functions to Subtract 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.
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.
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.
Rounding Numbers in Excel Online
Use the ROUND function in Excel Online to round numbers up or down a set number of decimal places or digits. A step by step example is included.
Excel CHOOSE Function Tutorial
The CHOOSE function can be used to return a value from a list based upon its position in the list. A step by step example is included with this tutorial.
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.
How to Share Google Spreadsheets
One of the key features of a Google Spreadsheet is that people can collaborate and share information over the Internet. This article covers the steps necessary to share a Google Spreadsheet.
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.
Arithmetic Operators
Definition of the term arithmetic or mathematical operators as used in Excel and Google Spreadsheets.
An Easy Guide to Using Data Entry Forms in Excel
These tutorials cover how to use a form for data entry in an Excel database. There are separate tutorials for Excel 2010 / 2007 and Excel 2003. Each tutorial includes a step by step example of how to use a form for data entry in an Excel database.
Link Files in Excel with Paste Link
Link data located in two separate Excel files using Paste Link. When the source file changes the destination file will update as well. 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
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.
How to Undo Changes You've Made in Excel
This tip shows you how to undo accidental or unintended changes made to an Excel worksheet.
Label
class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: The
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.
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.
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.
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.
How to Make Pivot Tables in Excel
These tutorials cover how to create a pivot table in Excel. Each tutorial includes a step by step example of how to create a pivot table in Excel.

©2015 About.com. All rights reserved.