The Wayback Machine - http://web.archive.org/web/20160314100114/http://spreadsheets.about.com/

Spreadsheets

Excel Data Points, Data Markers, Data Labels, and Data Series Definitions - © Ted French

Data Points/Data Markers/Data Labels/Data Series

Formulas on a blackboard - Jon Boyes/Photographer's Choice RF/Getty Images

A Beginner's Guide to Excel Formulas

Find Data in Excel with VLOOKUP - © Ted French

Excel VLOOKUP Example

Our Spreadsheets Expert
Spreadsheets Essentials
Spreadsheets Categories
Readers Recommend
View More
The Latest in Spreadsheets
How to Add Numbers in Excel Using a Formula - © Ted French
How to Add in Excel
Step by step instructions on how to add two or more numbers in Excel using a simple formula. Also covered - cell references and copying formulas.
Finding the Weighted Average with SUMPRODUCT in Excel - © Ted French
Calculate Weighted Averages in Excel with SUMPRODUCT
Use the SUMPRODUCT function to calculate weighted averages in Excel. You set the weighting factors for each value. Step by step examples included.
What is Excel? and What would I Use it For? - The Uses and Features of Spreadsheet Programs - © Ted French
What is Microsoft Excel and What Would I Use it for?
The uses and major features of Excel and other spreadsheets are covered such as storing, organizing and manipulating data, and creating charts and formulas.
Rank Numbers in a List with the RANK Function in Excel 2007 - © Ted French
Rank Numbers by Numerical Value with Excel's RANK Function
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.
Estimating Standard Deviation with the STDEV Function in Excel 2007 - © Ted French
Excel STDEV (Standard Deviation) Function
Use Excel's STDEV function to estimate standard deviation for each number in a list from the overall average. A step by step example is included.
Find Duplicate and Unique Data with Conditional Formatting in Excel - © Ted French
Find Duplicate or Unique Data in Excel with Conditional Formatting
Find and highlight duplicate or unique data in Excel with conditional formatting. A step by step example is included.
Converting Angles from Degrees to Radians with Excel's RADIANS Function - © Ted French
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.
Column and Row Headings in Excel and Google Spreadsheets - © Ted French
Column and Row Headings
Definition of the terms column and row headings or headers as they are used in Excel and Google Spreadsheets.
Using SUMPRODUCT to Count Cells of Data in Excel - © Ted French
Count Cells that Meet Multiple Criteria with Excel SUMPRODUCT
Use Excel's SUMPRODUCT function to count cells containing data that meets multiple criteria that you set. A step by step example is included.
Finding Random Integers with Excel's RANDBETWEEN Function - © Ted French
Generate Random Numbers with Excel's RANDBETWEEN Function
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.
Counting Cells Containing Data Using COUNTA in Excel - © Ted French
Count Cells with Text or Other Data with Excel's COUNTA Function
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.
Round Numbers Up or Down to the Nearest 5 or 10 cents in Excel - © Ted French
Round Numbers Up or Down to the Nearest 5 or 10 in Excel
Round numbers up or down to the nearest 5, 10, or other specified multiple in Excel. Step by step instructions are included.
Adding a Default Chart to an Excel Workbook using Keyboard Shortcut Keys - © Ted French
Create a Chart in Excel using Shortcut Keys
How to add a chart to a worksheet using keyboard shortcut keys and how to change the default chart type in Excel. Step by step instructions are included.
Round Numbers Up or Down to the Nearest 5 or 10 in Google Spreadsheets - © Ted French
Round Numbers Up or Down to the Nearest 5 or 10 in Google Spreadsheets
Round numbers up or down to the nearest 5, 10, or other specified multiple in Google Spreadsheets. A step by step example is included.
Test Multiple Conditions with Google Spreadsheets AND/OR Functions - © Ted French
Test Multiple Conditions with Google Spreadsheets' AND and OR Functions
How to use the AND and/or OR functions in Google Spreadsheets to test for multiple true or false conditions. A step by step example is included.
Prev
1
2
3
4