Absolute Beginners Guide to Microsoft Office Excel 2003
| [SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Z]
fields (databases) formatting 2nd File menu commands Exit Open Page Setup Print Preview Save As Save as Web Page File Name text box(Save As dialog box) files workbooks saving in XML format 2nd 3rd 4th Fill Color button Formatting toolbar Fill Color tool (Drawing toolbar) 2nd fill handles (Auto Fill) 2nd 3rd Filter command (Data menu) filters (databases) records displaying (AutoFilter) 2nd floating toolbars 2nd Font button Formatting toolbar Font Color button Formatting toolbar Font Color tool (Drawing toolbar) 2nd Font Size button Formatting toolbar fonts worksheets changing footers worksheets adding 2nd 3rd Form command (Data menu) Format Axis dialog box Format Cells dialog box 2nd 3rd 4th Alignment tab 2nd 3rd Border tab 2nd 3rd column labels 2nd database field formatting Font tab Number tab Patterns tab 2nd Protection tab 2nd 3rd text attributes modifying 2nd Format Char Area dialog box Format menu commands AutoFormat Cells 2nd 3rd 4th 5th 6th 7th 8th Column Column Hide Conditional Formatting Row Row Hide Style 2nd 3rd Format Object dialog box Format Painter cell formatting copying Format Painter button Standard toolbar Format Picture tool (Picture toolbar) Format Tab Color dialog box Format tool (Chart toolbar) Format WordArt tool (WordArt toolbar) formatting axes charts cells AutoFormat 2nd copying styles from other workbooks 2nd saving styles in templates style creation 2nd style modifications charts Chart menu 2nd Chart toolbar 2nd 3rd database fields 2nd dates/times 2nd numbers 2nd 3rd 4th accounting currency custom date fraction general percentage scientific notation special text time text charts 2nd 3rd times/dates 2nd worksheets comma style currency style normal style percent style style specifications Formatting toolbar buttons Align Left Align Right Bold Borders Center Comma Style Currency Style Decrease Decimal Decrease Indent Fill Color Font Font Color Font Size Increase Decimal Increase Indent Italic Merge and Center Percent Style Toolbar Options Underline text attributes modifying 2nd forms (databases) creating 2nd 3rd data manipulation 2nd 3rd Formula Auditing command (Tools menu) formula bar appearance of formulas absolute references marking cells 2nd arithmetic operators Auto Calculate feature activating AutoSum tool activating 2nd cell data entries cell entry 2nd copying 2nd creating (manual method) creating (point-and-click method) 2nd displaying (formula-display mode) 2nd editing errors troubleshooting 2nd 3rd functions elements 2nd inserting 2nd 3rd PMT (payment) 2nd mathematical order of operations 2nd order of operations overview pasting 2nd recalculation setting changing 2nd versus functions 2nd Forward button Help window fraction format (numbers) freeze panes headings locking 2nd Freeze Panes command (Window menu) Function command (Insert menu) functions Average (AutoSum tool) cell data entries cells inserting Count (AutoSum tool) errors troubleshooting 2nd 3rd formulas elements 2nd inserting 2nd 3rd Max (AutoSum tool) Min (AutoSum tool) overview 2nd PMT (payment) 2nd versus formulas 2nd
|