About - spreadsheets.about.com
General Information:
Latest News:
Excel INDIRECT Function 27 Aug 2013 | 12:13 pm
Excel INDIRECT Function © Ted French The INDIRECT function, as its name suggests, can be used to indirectly reference a cell in a worksheet. This is done by entering a cell reference as text string ...
Excel Drop Down List Tutorial Pt 2 23 Aug 2013 | 08:38 am
Excel Drop Down List © Ted French A drop down list gives you a set number of entries to choose from when entering data. Not only can this speed up data entry, but it can also prevent people from miss...
Creating a Drop Down List in Excel 21 Aug 2013 | 07:37 am
Excel Drop Down List © Ted French Since entering data into a spreadsheet is probably the most commonly performed operation in Excel, There are a number of ... Read Full Post
Excel DGET Function 19 Aug 2013 | 08:19 am
A third member of Excel's group of database functions is DGET. As a group, these functions make it easy to retrieve information from an Excel database file. What DGET does is find specific informati...
Excel DSUM Function 16 Aug 2013 | 10:08 am
Another of Excel's database functions is DSUM. How DSUM differs from the regular SUM function is that DSUM lets you specify one or more criteria which act as data filters . ... Read Full Post
Excel DMIN Function 14 Aug 2013 | 10:54 am
Excel's database functions are designed specifically to work with an Excel database file. For the most part, these functions are variations of commonly used Excel functions such as SUM, AVERAGE, MAX,...
Splitting the Screen in Excel 12 Aug 2013 | 05:52 pm
Using the Split Box in Excel 2010 © Ted French Splitting the screen in Excel can be used as an alternative to freeze panes for keeping worksheet titles or headings on screen as you scroll. ... Read...
Google Spreadsheets MODE Function 9 Aug 2013 | 12:35 pm
The MODE function can be used to find the value that occurs the most often in a range of data. The mode, like the average and median, is a measure of central tendency and can be used for such things ...
Google Spreadsheets MEDIAN Function 7 Aug 2013 | 05:48 pm
The median, another method of finding central tendency in your data, shows you the middle value in a list of numbers. Middle, in this case, refers to mathematical size rather than the location of the...
Measuring Central Tendency in Google Spreadsheets 5 Aug 2013 | 05:27 pm
There are a number of ways of measuring central tendency or, as it is more commonly called, the average, for a set of values. Google Spreadsheets has a number of functions that make it easy to find s...
