| | |
|---|
| association |
Statistics. |
| Car_loan (.XLS) |
../content/car_loan.xls (.XLS, Excel Spreadsheet) |
| Conditional_formatting |
if(A30>70,big,tiny) |
| Data_types |
![http://www.usd.edu/trio/tut/excel/ [excel_data_types.jpg]](image_files/excel_data_types.jpg) |
| First_steps |
http://office.microsoft.com/en-gb/novice/FX102704831033.aspx |
| Function |
AVERAGE, arithmetic average |
| Function |
PMT, gives payments for a loan |
| Function |
TEXT, converts a value to text |
| Function |
TODAY, todays date |
| Function |
UPPER, converts to upper case |
| Function |
VALUE(text), converts a text string to a number |
| Function |
WEEKDAY, the number of day for a given date |
| graphic |
![http://oreilly.com/pub/a/windows/archive/whatisapivottable.html?page=5 [excel.jpg]](image_files/excel.jpg) |
| is_type_of |
Software. |
| Macro |
Creating_Macros |
| Number_format |
Accounting, aligns decimal points |
| Number_format |
Currency, can specify currency symbol |
| Number_format |
Date |
| Number_format |
Fraction |
| Number_format |
General, not formated |
| Number_format |
Number, has display options |
| Number_format |
Percentage, multiplies cell by 100 puts % at end |
| Number_format |
Scientific |
| Number_format |
Text |
| Number_format |
Time |
| Number_formats |
![http://www.helpwithpcs.com/courses/excel-formats.html [excel_number_formats.gif]](image_files/excel_number_formats.gif) |
| Oreilly |
http://oreilly.com/pub/a/windows/archive/whatisapivottable.html?page=5 |
| Pick_from_list |
Enter a datum already entered for this column |
| Pivot_tables |
http://www.cpearson.com/excel/pivots.htm |
| Pivot_table_output |
![../content/pivot_table.xls [excel_pivot_table.jpg]](image_files/excel_pivot_table.jpg) |
| Pivot_table_source |
![../content/pivot_table.xls [excel_pivot_source.jpg]](image_files/excel_pivot_source.jpg) |
| Series_data_entry |
Type 1, 2. Highlight both. Click square to make cross, now drag down to autofill a 1,2,3,4...series |
| Tutorial |
http://www.usd.edu/trio/tut/excel/ |
..