The Wayback Machine - http://web.archive.org/web/20150905080758/http://spreadsheets.about.com/
The Latest in Spreadsheets
Testing Multiple Conditions with Excel's AND and OR Functions - © Ted French
Test Multiple Conditions with Excel's AND and OR Functions
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.
Nested AND, OR, and IF Functions in Excel - © Ted French
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.
Excel VLOOKUP Alternative Formula - © Ted French
Excel VLOOKUP Alternative Formula
Excel’s VLOOKUP function can be used to find specific data that is stored in a table of data. This tutorial includes a step by step example of using Excel's VLOOKUP function.
Inserting Blank Cells into an Excel Worksheet - © Ted French
Insert Blank Cells into an Excel Worksheet
How to insert single or multiple cells into an Excel worksheet using shortcut keys, the context menu, or ribbon options. Step by step examples are included.
Shading Alternate Rows with Conditional Formatting Forumulas in Excel - © Ted French
Shade Alternate Rows in Excel with Conditional Formatting
This tutorial covers shading alternate rows of data in Excel using a formula and conditional formatting. A step by step example is included.
Convert Angles from Degrees to Radians with the RADIANS Function in Google Spreadsheets - © Ted French
Convert Angles From Degrees to Radians in Google Spreadsheets
Use the RADIANS function to quickly convert angles from degrees to radians in Google Spreadsheets for use with trig functions. A step by step example is included.
Cut, Copy, and Paste Options in Excel - © Ted French
Cut, Copy, and Paste Data in Excel
Use shortcut keys or context menu options to copy or move formulas, charts, or other data to different parts of the same or different worksheets in Excel.
Removing Unwanted Text with the LEFT Function in Google Spreadsheets - © Ted French
Google Spreadsheet's LEFT Function
Use Google Spreadsheets' LEFT function to remove unwanted text characters from data. Step by step instructions are included.
Removing unwanted characters from text with the RIGHT Function in Google Spreadsheets - © Ted French
Google Spreadsheets' RIGHT Function
Use Google Spreadsheets' RIGHT function to remove unwanted characters from imported data or to truncate existing text. A step by step example is included.
Extracting text with the MID function in Google Spreadsheets - © Ted French
Google Spreadsheets MID Function
Use Google Spreadsheets' MID function to extract good text data from bad. Step by step instructions are included.
Select Entire Rows in an Excel Worksheet with Shortcut Keys - © Ted French
Select Rows, Columns, and Worksheets in Excel with Shortcut Keys
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.
Moving Around and Between Worksheets in Excel with Shortcut Keys - © Ted French
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.
Using the MODE.SNGL Function to Find the MODE for a Range of Values in Excel - © Ted French
Find the Most Frequently Occurring Value with Excel's MODE.SNGL Function
Use Excel's MODE.SNGL function to find the mode - the most frequently occurring value in a group of numbers . A step by step example is included.
Finding the Middle Value with the MEDIAN Function in Excel - © Ted French
Find the Middle or Median Value in a Range of Numbers in Excel
Find the middle value in a list of numbers with the MEDIAN function in Excel. A step by step example is included.
Find the Arithmetic Mean or Average with the Excel Average Function - © Ted French
Finding the Average Value with Excel's AVERAGE Function
Use Excel's AVERAGE function to find the average, or arithmetic mean for selected data. A step by step example is included.
Previous
1
2
3
4