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] F2 key ( putting cell in edit mode) FACT( ) function FACTDOUBLE( ) function factorials FALSE( ) function fancy fills [See Fill Effects dialog box] File Locations tab File menu Close command 2nd Do Not Distribute command Exit command 2nd New command Open command Page Setup command Print Area submenu Print command Print Preview command Properties command Restrict Permission As command Save As command Save As Web Page command Save command Save Workspace command Web Page Preview command File Search command Fill (cell appearance formatting) Fill Color button Fill Effects dialog box 2nd Gradient tab Pattern tab Picture tab Texture tab Fill menu Filter submenu filtering pivot tables page filtering versus group filtering financial concepts calculating investments or loans compound interest cumulative interest depreciation declining balance double declining balance straight-line sum-of- years -digits discount rate interest rates internal rate of return net present value nper number of payment periods present value principal financial functions Find All feature 2nd Find and Replace dialog box 2nd tips Find feature 2nd 3rd [See also searching] cells that contain numeric or date information Find Format dialog box specifying format settings Find Next 2nd 3rd Find tool launching FIND( ) function finding and replacing values FIX (Status bar indicator) fixed decimal places fixed width text FIXED( ) function FLOOR( ) function Flowchart (shape category) Font tab fonts attributes color 2nd default changing proportional size special characters footers FORECAST( ) function Format Axis dialog box Category (X) axis crosses at maximum value changing font, alignment, or number style Display units Logarithmic scale specialized options Values in reverse order Format Axis title Format Cells dialog box 2nd 3rd Alignment tab ’Wrap text “ checkbox Border tab Numbers tab Patterns tab Format Chart Title Format Comment dialog box Format Data Point dialog box 2nd Format Data Series Format Data Series dialog box Gap width setting Overlap setting Format Gridlines dialog box Format menu AutoFormat command Cells command Column command Conditional Formatting command Row command Sheet command Style command Format Painter Format Picture dialog box options Format Plot Area format strings codes date and time displaying positive and negative values empty numbers text Format Trendline dialog box FormatHeader macro FormatRow macro formatting smart ways to apply AutoFormat [See AutoFormat command] conditional formatting [See Conditional Formatting] Format Painter Formatting toolbar [See Formatting toolbar] styles Formatting toolbar 2nd 3rd Borders toolbar formatting individual characters shrinking Formula Auditing submenu Formula bar 2nd formula errors, solving error checking step-by-step evaluation tracing precedents and dependents formulas [See also functions] advanced array AutoSum building calculating values before entering in worksheet cell references [See cell references] conditional conditions in [See conditional formulas] controlling recalculation copying absolute cell references creating exact copies partially fixed references data validation and defined entering in cells errors how changing cell location affects ingredients of linked naming naming existing operations, order of printing referencing in other worksheets/workbooks rules shortcuts Analysis ToolPak Insert Function button point-and-click formula creation point-and-click formula editing showing spaces in under the hood variable data table [See variable data table] Fraction format Freeze Panes command 2nd 3rd freezing columns or rows FREQUENCY( ) function 2nd Full Screen command Full Screen mode FUNCRES.XLA function keys F2 (putting cell in edit mode) functions 2nd 3rd [See also formulas] ABS( ) ACCRINT( ) ACCRINTM( ) ACOS( ) ACOSH( ) ADDRESS( ) Analysis ToolPak EDATE( ) EOMONTH( ) NETWORKDAYS( ) WEEKNUM( ) WORKDAY( ) YEARFRAC( ) AND( ) AREAS( ) ASIN( ) ATAN( ) ATAN2( ) ATANH( ) AVEDEV( ) AVERAGE( ) 2nd AVERAGEA( ) CEILING( ) 2nd CELL( ) CHAR( ) CHOOSE( ) CLEAN( ) CODE( ) COLUMN( ) COLUMNS( ) COMBIN( ) 2nd CONCATENATE( ) CORREL( ) COS( ) COSH( ) COUNT( ) 2nd COUNTA( ) 2nd COUNTBLANK( ) COUNTIF( ) COUPDAYBS( ) COUPDAYS( ) COUPDAYSNC( ) COUPNCD( ) COUPNUM( ) COUPPCD( ) COVAR( ) CUMIPMT( ) CUMPRINC( ) custom database DATE( ) DATEDIF( ) DATEVALUE( ) DAVERAGE( ) DAY( ) DAYS360( ) DB( ) DCOUNT( ) DCOUNTA( ) DDB( ) DEGREES( ) DGET( ) DISC( ) DMAX( ) DMIN( ) DOLLAR( ) DPRODUCT( ) DSTDEV( ) DSUM( ) DURATION( ) DVAR( ) DVARP( ) EFFECT( ) ERROR.TYPE( ) EVEN( ) EXACT( ) EXP( ) FACT( ) FACTDOUBLE( ) FALSE( ) financial FIND( ) FIXED( ) FLOOR( ) FORECAST( ) FREQUENCY( ) 2nd FV( ) function) [See FV( ] FVSCHEDULE( ) GCD( ) HLOOKUP( ) function) [See HLOOKUP( ] HOUR( ) HYPERLINK( ) IF( ) INDEX( ) INDIRECT( ) INFO ( ) information 2nd INT( ) INTRATE( ) IPMT( ) IRR( ) ISBLANK( ) ISERR( ) ISERROR( ) ISEVEN( ) ISLOGICAL( ) ISNA( ) ISNONTEXT( ) ISNUMBER( ) ISODD( ) ISREF( ) ISTEXT( ) LARGE( ) LCM( ) learning new LEFT( ) 2nd LEN( ) LINEST( ) LN( ) LOG( ) LOG10( ) lookup 2nd LOOKUP( ) function) [See LOOKUP( ] LOWER( ) MATCH( ) mathematical MAX( ) 2nd MDETERM( ) MDURATION( ) MEDIAN( ) MID( ) 2nd MIN( ) 2nd MINUTE( ) MINVERSE( ) MIRR( ) MMULT( ) MOD( ) MODE( ) MONTH( ) MROUND( ) MULTINOMIAL( ) N( ) NOMINAL( ) NORMDIST( ) NORMINV( ) NOT( ) NOW( ) NPER( ) function) [See NPER( ] NPV( ) subtle problems with ODD( ) ODDFPRICE( ) ODDFYIELD( ) ODDLPRICE( ) ODDLYIELD( ) OFFSET function) [See OFFSET( ] optional arguments OR( ) PERCENTILE( ) PERCENTRANK( ) 2nd PERMUT( ) PI( ) PMT( ) function) [See PMT( ] POWER( ) PPMT( ) PRICE( ) PRICEDISC( ) PRICEMAT( ) PRODUCT( ) 2nd PROPER( ) 2nd PV( ) function) [See PV( ] quickly finding and using QUOTIENT( ) RADIANS( ) RAND( ) RANDBETWEEN( ) RANK( ) RATE( ) RECEIVED( ) reference 2nd REPT( ) RIGHT( ) 2nd ROMAN( ) ROUND( ) 2nd ROUNDDOWN( ) rounding ROUNDUP( ) ROW( ) ROWS( ) SEARCH( ) SECOND( ) SERIESSUM( ) SIGN( ) SIN( ) SINH( ) SLN( ) SLOPE( ) SMALL( ) SQRT( ) SQRTPI( ) statistical STDEV( ) 2nd STDEVA( ) STDEVP( ) SUBSTITUTE( ) SUBTOTAL( ) 2nd SUM( ) 2nd SUMIF( ) 2nd SUMPRODUCT( ) function [See SUMPRODUCT( ] SYD( ) T( ) TAHNH( ) TAN( ) TBILLEQ( ) TBILLPRICE( ) TBILLYIELD( ) text TEXT( ) that return arrays TIME( ) TIMEVALUE( ) TODAY( ) 2nd 3rd TRANSPOSE( ) 2nd TREND( ) 2nd trigonometry TRIM( ) TRUE( ) TRUNC( ) 2nd TYPE( ) understanding UPPER( ) VALUE( ) VAR( ) 2nd VARA( ) VARP( ) VDB( ) VLOOKUP( ) function) [See VLOOKUP( ] volatile WEEKDAY( ) with no arguments XIRR( ) XNPV( ) YEAR( ) YIELD( ) YIELDDISC( ) YIELDMAT( ) future value 2nd [See also FV( function)] FV( ) function break down caveat difficult problems to solve FVSCHEDULE( ) function |