Spreadsheets
Oct 30, 2011
By articleman 
Views : 9 Excel SUM Function Using Shortcut Keys
Excel Pivot Tables© Ted French
A pivot table is a great tool for sorting and summarizing the data in a worksheet or database file.
It can automatically sort, count, and total spreadsheet ...
Comments : 0
Oct 26, 2011 By articleman Views : 8 Using Data from a Separate Worksheet in a Drop Down List
One of the most common calculations performed in spreadsheet programs is summing columns or rows of data.
It is carried out so often, that Excel has a built in SUM function ...
Comments : 0
Oct 23, 2011 By articleman Views : 12 Excel SIN Function
Creating a Drop Down List in Excel © Ted French
If you enter the same data repeatedly into a worksheet using a drop down list can you save time and ...
Comments : 0
Oct 19, 2011 By articleman Views : 14 Excel TAN Function
Excel has several functions that can be used to change the case of data in a spreadsheet. Case refers to the use of capital (upper case) and small ...
Comments : 0
Oct 16, 2011 By articleman Views : 9 Divide the Excel Screen using the Split Box
Sometimes when data is imported or copied into an Excel spreadsheet numbers get converted to text.
This means that they cannot be used in formulas or functions such as ...
Comments : 0