Excel 2010: The Missing Manual
|
Index
[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Y] [Z]
Save As command 2nd Save As dialog box Save as Web Page command Save command 2nd Save tab Save Workspace command saving files scale (chart) changing for value axis controlling setting Scale tab scatter charts formatting with no data markers with smooth lines with straight lines Scenario Manager dialog box 2nd 3rd Scenario Summary dialog box Scenario Values dialog box scenarios changing cell references creating multiple creating new creating summary report deleting managing merging naming storing results in using scientific data, adding error bars to Scientific format SCRL (Status bar indicator) scroll bars and split worksheets Search pop-up menu Search Results task 2nd Search task SEARCH( ) function searching [See also find feature] across multiple worksheets advanced searches By Columns By Rows formatted cells numbers ’Match case “ option ’Match entire cell contents “ with wildcards searching for files advanced search feature SECOND( ) function security macros and security, password protection ’Select Changes to Accept or Reject “ dialog box Send To feature Send To submenu SERIESSUM( ) function server-side databases Service Options dialog box Set Print Area command 2nd Share Workbook dialog box 2nd Shared Workspace task 2nd 3rd SharePoint Server and Windows 2003 Sheet command shortcuts [See keyboard shortcuts] Show Detail command 2nd Show Formula Auditing Toolbar Show Outline Symbols 2nd ’Show Text To Speech Toolbar “ command Show the Office Assistant command 2nd SIGN( ) function SIN( ) function SINH( ) function SLN( ) function SLOPE( ) function SMALL( ) function smart documents social security numbers Solver 2nd advanced solutions configuring creating special reports defining problems in model Add Constraint dialog box advanced examples changing cells constraints decision variables saving target cells unchanging cells Options dialog box Parameters dialog box 2nd settings Convergence Iterations Max Time Precision resetting to default Restore Original Values Show Iteration Results Tolerance storing results in scenarios types of optimization web site SOLVER.XLA Sort dialog box sort keys, multiple Source Data dialog box spaces as intersection operators in formulas Special format speech, text-to-speech feature spell checker 2nd Add to Dictionary options Ignore Internet and file addresses Ignore words in UPPERCASE Ignore words with numbers Suggest from main dictionary only Split command 2nd splitting worksheets spreadsheet modification AutoSelect deleting columns and rows inserting columns inserting copied or cut cells inserting rows making selections with keyboard moving cells around non-contiguous cell selection selecting cells selecting cells with Go To selecting continuous range of cells Spreadsheet Solutions templates spreadsheets [See also workbooks; worksheets] common types linking to XML opening opening multiple programming [See VBA, programming spreadsheets with] saving in other formats saving with a password SQL tutorial SQRT( ) function SQRTPI( ) function squares, method of least stacked column charts stacked line charts standalone charts printing Standard toolbar Stars and Banners (shape category) statistical functions Status bar status bar Status bar indicators CAPS END EXT FIX NUM OVR SCRL Status bar calculations STDEV( ) function SUBTOTAL ( ) function codes and STDEVA( ) function STDEVP( ) function SUBTOTAL ( ) function codes and stock charts High-Low-Close Open -High-Low-Close Volume-High-Low-Close Volume-Open-High-Low-Close Stop Recording toolbar disappearing straight-line depreciation string literals Style dialog box 2nd styles applying Comma Comma [0] creating Currency default Normal outline Percent transferring urrency [0] sub-expressions submenus, creating SUBSTITUTE( ) function Subtotal tool SUBTOTAL( ) function calculation code function codes for visible only cells subtotaling, automatic Subtotals dialog box 2nd subtraction Sum (Status bar shortcut) SUM( ) function SUBTOTAL ( ) function codes and sum-of- years -digits depreciation SUMIF( ) function 2nd 3rd SUMIF.XLA summary tables SUMPRODUCT( ) function 2nd evaluating more than one condition underlying principles using as counting tool using to create reports surface charts SYD( ) function Symbol dialog box 2nd 3rd
|