| 1.Introduction | ||
| 1.1.Introduction( 10 ) | 1.9.ScreenTips( 3 ) | |
| 1.2.Ribbon( 6 ) | 1.10.Status Bar( 2 ) | |
| 1.3.Office Button( 1 ) | 1.11.Dialog Box( 3 ) | |
| 1.4.KeyTips( 1 ) | 1.12.Excel Window View( 8 ) | |
| 1.5.Live Preview( 2 ) | 1.13.Task and Window Panes( 2 ) | |
| 1.6.Message Bar( 1 ) | 1.14.Compatibility( 2 ) | |
| 1.7.Mini Toolbar( 1 ) | 1.15.Diagnostics( 1 ) | |
| 1.8.Quick Access Toolbar( 6 ) | ||
| 2.Editing | ||
| 2.1.Workbook Create( 2 ) | 2.19.Link( 2 ) | |
| 2.2.Workbook Open( 5 ) | 2.20.AutoComplete( 2 ) | |
| 2.3.Workbook Close( 2 ) | 2.21.AutoCorrect( 2 ) | |
| 2.4.Workbook Save( 5 ) | 2.22.AutoFormat( 1 ) | |
| 2.5.Cell Edit( 7 ) | 2.23.AutoRecover( 2 ) | |
| 2.6.Paste( 2 ) | 2.24.Redo Undo( 2 ) | |
| 2.7.Smart Tag( 2 ) | 2.25.Workbook Properties( 2 ) | |
| 2.8.Selection( 5 ) | 2.26.FTP Site( 2 ) | |
| 2.9.Cell Fill( 3 ) | 2.27.Research( 2 ) | |
| 2.10.AutoFill( 1 ) | 2.28.Signature Line( 2 ) | |
| 2.11.Cell Clear( 2 ) | 2.29.Special Symbol( 1 ) | |
| 2.12.Clipboard( 4 ) | 2.30.Spelling( 4 ) | |
| 2.13.Drag Drop( 2 ) | 2.31.Thesaurus( 1 ) | |
| 2.14.Find Replace( 7 ) | 2.32.View( 2 ) | |
| 2.15.Value Format( 13 ) | 2.33.Template( 3 ) | |
| 2.16.Value Input( 5 ) | 2.34.PDF( 1 ) | |
| 2.17.Keyboard( 2 ) | 2.35.XPS( 1 ) | |
| 2.18.Hyperlink( 6 ) | ||
| 3.Format Style | ||
| 3.1.Cell Border( 8 ) | 3.9.Theme Fonts( 2 ) | |
| 3.2.Cell Color( 4 ) | 3.10.Conditional Formatting( 8 ) | |
| 3.3.Cell Font( 3 ) | 3.11.Header Footer( 2 ) | |
| 3.4.Cell Format( 7 ) | 3.12.Margin( 3 ) | |
| 3.5.Cell Style( 6 ) | 3.13.Page( 3 ) | |
| 3.6.Theme( 4 ) | 3.14.Page Break( 4 ) | |
| 3.7.Theme Color( 4 ) | 3.15.Text Format( 2 ) | |
| 3.8.Theme Effects( 2 ) | 3.16.Watermark( 1 ) | |
| 4.Table | ||
| 4.1.Table( 6 ) | 4.4.Table Filter( 1 ) | |
| 4.2.Table Row Column( 4 ) | 4.5.Table Sort( 4 ) | |
| 4.3.Table Format( 6 ) | 4.6.Table Calculation( 2 ) | |
| 5.Chart | ||
| 5.1.Chart( 5 ) | 5.6.Chart Title( 4 ) | |
| 5.2.Chart Edit( 6 ) | 5.7.Chart Axis( 3 ) | |
| 5.3.Chart Format Style( 9 ) | 5.8.Chart Data( 9 ) | |
| 5.4.Chart Legend( 1 ) | 5.9.Chart Gridlines( 1 ) | |
| 5.5.Chart Template( 3 ) | 5.10.Pie Chart( 3 ) | |
| 6.Formula | ||
| 6.1.Formula( 12 ) | 6.9.Formula Review Watch( 5 ) | |
| 6.2.AutoSum( 3 ) | 6.10.Formula Trace( 1 ) | |
| 6.3.Cell Reference( 9 ) | 6.11.Operators( 7 ) | |
| 6.4.Cells Name( 11 ) | 6.12.Range( 3 ) | |
| 6.5.Circular Reference( 2 ) | 6.13.Subtotal( 1 ) | |
| 6.6.Formula AutoComplete( 2 ) | 6.14.Error Type( 1 ) | |
| 6.7.Formula Bar( 4 ) | 6.15.Custom function( 1 ) | |
| 6.8.Formula Enter( 2 ) | ||
| 7.Workbook Worksheet | ||
| 7.1.Worksheet( 13 ) | 7.6.Workbook Inspect( 1 ) | |
| 7.2.Column Row( 11 ) | 7.7.Workbook Password( 7 ) | |
| 7.3.Freeze( 2 ) | 7.8.Workbook Sharing( 7 ) | |
| 7.4.Print( 11 ) | 7.9.Workbook( 5 ) | |
| 7.5.Split( 1 ) | 7.10.Workspace( 1 ) | |
| 8.Wordart Clip Art Shape Picture | ||
| 8.1.Clip Art( 4 ) | 8.7.Shape( 12 ) | |
| 8.2.WordArt( 11 ) | 8.8.Shape Format Style( 22 ) | |
| 8.3.SmartArt( 21 ) | 8.9.Shape Object Group( 8 ) | |
| 8.4.Text Box( 2 ) | 8.10.Object( 2 ) | |
| 8.5.Picture( 21 ) | 8.11.Organization Chart( 5 ) | |
| 8.6.Line Arrow( 3 ) | 8.12.Flash( 1 ) | |
| 9.PivotTable PivotChart | ||
| 9.1.PivotChart( 6 ) | 9.2.PivotTable( 9 ) | |
| 10.Data Analysis | ||
| 10.1.Data Analysis( 2 ) | 10.4.Solver( 2 ) | |
| 10.2.Group( 1 ) | 10.5.Validation( 3 ) | |
| 10.3.Outline( 3 ) | 10.6.What If Scenario( 4 ) | |
| 11.Macro ActiveX Add in | ||
| 11.1.Macro( 12 ) | 11.3.ActiveX Control( 6 ) | |
| 11.2.Add ins( 5 ) | ||
| 12.Security | ||
| 12.1.Digital Signature( 3 ) | 12.3.Security Settings( 6 ) | |
| 12.2.Encryption( 2 ) | 12.4.Trust Center( 2 ) | |
| 13.Collaboration | ||
| 13.1.Comments( 5 ) | 13.6.SharePoint( 1 ) | |
| 13.2.Track Changes( 2 ) | 13.7.Web Page( 4 ) | |
| 13.3.Import Export( 4 ) | 13.8.Web Query( 3 ) | |
| 13.4.Access Database( 2 ) | 13.9.XML( 7 ) | |
| 13.5.Database Query( 3 ) | ||
| 14.Database functions | ||
| 14.1.Database functions( 7 ) | 14.7.DPRODUCT( 1 ) | |
| 14.2.DCOUNT( 1 ) | 14.8.DSTDEV( 1 ) | |
| 14.3.DCOUNTA( 1 ) | 14.9.DSTDEVP( 1 ) | |
| 14.4.DGET( 1 ) | 14.10.DSUM( 1 ) | |
| 14.5.DMAX( 1 ) | 14.11.DVAR( 1 ) | |
| 14.6.DMIN( 1 ) | 14.12.DVARP( 1 ) | |
| 15.Date Time functions | ||
| 15.1.DATE( 15 ) | 15.11.SECOND( 2 ) | |
| 15.2.DATEDIF( 2 ) | 15.12.TIME( 8 ) | |
| 15.3.DateValue( 1 ) | 15.13.TIMEVALUE( 2 ) | |
| 15.4.EDATE( 2 ) | 15.14.TODAY( 4 ) | |
| 15.5.EOMONTH( 2 ) | 15.15.WEEKDAY( 3 ) | |
| 15.6.HOUR( 2 ) | 15.16.WEEKNUM( 1 ) | |
| 15.7.MINUTE( 1 ) | 15.17.WORKDAY( 2 ) | |
| 15.8.MONTH( 5 ) | 15.18.YEAR( 5 ) | |
| 15.9.NETWORKDAYS( 3 ) | 15.19.YEARFRAC( 3 ) | |
| 15.10.NOW( 3 ) | ||
| 16.Engineering functions | ||
| 16.1.BESSELI( 1 ) | 16.21.IMAGINARY( 3 ) | |
| 16.2.BESSELJ( 1 ) | 16.22.IMARGUMENT( 1 ) | |
| 16.3.BESSELK( 1 ) | 16.23.IMCONJUGATE( 1 ) | |
| 16.4.BESSELY( 1 ) | 16.24.IMCOS( 1 ) | |
| 16.5.BIN2DEC( 2 ) | 16.25.IMDIV( 1 ) | |
| 16.6.BIN2HEX( 3 ) | 16.26.IMEXP( 1 ) | |
| 16.7.BIN2OCT( 3 ) | 16.27.IMLN( 1 ) | |
| 16.8.COMPLEX( 4 ) | 16.28.IMLOG10( 1 ) | |
| 16.9.CONVERT( 15 ) | 16.29.IMLOG2( 1 ) | |
| 16.10.DEC2BIN( 2 ) | 16.30.IMPOWER( 1 ) | |
| 16.11.DEC2HEX( 2 ) | 16.31.IMPRODUCT( 2 ) | |
| 16.12.DEC2OCT( 2 ) | 16.32.IMREAL( 1 ) | |
| 16.13.DELTA( 1 ) | 16.33.IMSIN( 1 ) | |
| 16.14.ERF( 2 ) | 16.34.IMSQRT( 1 ) | |
| 16.15.ERFC( 1 ) | 16.35.IMSUB( 1 ) | |
| 16.16.GESTEP( 1 ) | 16.36.IMSUM( 1 ) | |
| 16.17.HEX2BIN( 3 ) | 16.37.OCT2BIN( 2 ) | |
| 16.18.HEX2DEC( 3 ) | 16.38.OCT2DEC( 2 ) | |
| 16.19.HEX2OCT( 3 ) | 16.39.OCT2HEX( 2 ) | |
| 16.20.IMABS( 1 ) | ||
| 17.Information functions | ||
| 17.1.Cell( 14 ) | 17.9.ISNA( 2 ) | |
| 17.2.ERROR.TYPE( 4 ) | 17.10.ISNONTEXT( 1 ) | |
| 17.3.Info( 9 ) | 17.11.ISNUMBER( 1 ) | |
| 17.4.ISBLANK( 1 ) | 17.12.ISODD( 3 ) | |
| 17.5.ISERR( 1 ) | 17.13.ISREF( 1 ) | |
| 17.6.ISERROR( 2 ) | 17.14.ISTEXT( 2 ) | |
| 17.7.ISEVEN( 3 ) | 17.15.NA( 1 ) | |
| 17.8.ISLOGICAL( 2 ) | 17.16.TYPE( 4 ) | |
| 18.Logical functions | ||
| 18.1.AND( 4 ) | 18.5.NOT( 2 ) | |
| 18.2.FALSE( 1 ) | 18.6.OR( 3 ) | |
| 18.3.IF( 7 ) | 18.7.TRUE( 1 ) | |
| 18.4.IFERROR( 2 ) | ||
| 19.Lookup Reference functions | ||
| 19.1.ADDRESS( 7 ) | 19.9.INDIRECT( 4 ) | |
| 19.2.AREAS( 3 ) | 19.10.LOOKUP( 8 ) | |
| 19.3.CHOOSE( 5 ) | 19.11.Match( 4 ) | |
| 19.4.COLUMN( 7 ) | 19.12.OFFSET( 7 ) | |
| 19.5.FIND( 2 ) | 19.13.ROW( 5 ) | |
| 19.6.HLOOKUP( 4 ) | 19.14.TRANSPOSE( 1 ) | |
| 19.7.HYPERLINK( 1 ) | 19.15.VLOOKUP( 4 ) | |
| 19.8.INDEX( 7 ) | ||
| 20.Math Trigonometry functions | ||
| 20.1.ABS( 1 ) | 20.31.ODD( 1 ) | |
| 20.2.ACOS( 3 ) | 20.32.PI( 2 ) | |
| 20.3.ACOSH( 1 ) | 20.33.POWER( 3 ) | |
| 20.4.ASIN( 3 ) | 20.34.PRODUCT( 2 ) | |
| 20.5.ASINH( 1 ) | 20.35.QUOTIENT( 3 ) | |
| 20.6.ATAN( 3 ) | 20.36.RADIANS( 1 ) | |
| 20.7.ATAN2( 3 ) | 20.37.RAND( 1 ) | |
| 20.8.ATANH( 1 ) | 20.38.RANDBETWEEN( 2 ) | |
| 20.9.CEILING( 2 ) | 20.39.ROMAN( 2 ) | |
| 20.10.COMBIN( 1 ) | 20.40.ROUND( 4 ) | |
| 20.11.COS( 3 ) | 20.41.ROUNDDOWN( 2 ) | |
| 20.12.COSH( 1 ) | 20.42.ROUNDUP( 2 ) | |
| 20.13.DEGREES( 2 ) | 20.43.SERIESSUM( 1 ) | |
| 20.14.EVEN( 1 ) | 20.44.SIGN( 1 ) | |
| 20.15.EXP( 1 ) | 20.45.SIN( 2 ) | |
| 20.16.FACT( 1 ) | 20.46.SINH( 1 ) | |
| 20.17.FACTDOUBLE( 1 ) | 20.47.SQRT( 1 ) | |
| 20.18.FLOOR( 2 ) | 20.48.SQRTPI( 1 ) | |
| 20.19.GCD( 1 ) | 20.49.SUBTOTAL( 1 ) | |
| 20.20.INT( 1 ) | 20.50.SUM( 4 ) | |
| 20.21.LCM( 1 ) | 20.51.SUMIF( 2 ) | |
| 20.22.LN( 1 ) | 20.52.SUMIFS( 2 ) | |
| 20.23.LOG( 2 ) | 20.53.SUMPRODUCT( 1 ) | |
| 20.24.LOG10( 3 ) | 20.54.SUMSQ( 1 ) | |
| 20.25.MDETERM( 2 ) | 20.55.SUMX2PY2( 2 ) | |
| 20.26.MINVERSE( 1 ) | 20.56.SUMXMY2( 4 ) | |
| 20.27.MMULT( 1 ) | 20.57.TAN( 3 ) | |
| 20.28.MOD( 1 ) | 20.58.TANH( 1 ) | |
| 20.29.MROUND( 1 ) | 20.59.TRUNC( 3 ) | |
| 20.30.MULTINOMIAL( 1 ) | ||
| 21.Statistical functions | ||
| 21.1.AVERAGE( 4 ) | 21.42.LOGINV( 1 ) | |
| 21.2.AVERAGEA( 2 ) | 21.43.LOGNORMDIST( 1 ) | |
| 21.3.AVERAGEIF( 3 ) | 21.44.MAX( 2 ) | |
| 21.4.AVERAGEIFS( 2 ) | 21.45.MAXA( 1 ) | |
| 21.5.BETADIST( 1 ) | 21.46.MEDIAN( 1 ) | |
| 21.6.CHIDIST( 1 ) | 21.47.MIN( 2 ) | |
| 21.7.CHIINV( 1 ) | 21.48.MINA( 1 ) | |
| 21.8.CHITEST( 1 ) | 21.49.MODE( 1 ) | |
| 21.9.CONFIDENCE( 1 ) | 21.50.NEGBINOMDIST( 1 ) | |
| 21.10.CORREL( 1 ) | 21.51.NORMDIST( 2 ) | |
| 21.11.COUNT( 3 ) | 21.52.NORMINV( 1 ) | |
| 21.12.COUNTA( 4 ) | 21.53.NORMSDIST( 1 ) | |
| 21.13.COUNTBLANK( 3 ) | 21.54.NORMSINV( 1 ) | |
| 21.14.COUNTIF( 7 ) | 21.55.PEARSON( 1 ) | |
| 21.15.COUNTIFS( 2 ) | 21.56.PERCENTILE( 1 ) | |
| 21.16.COVAR( 1 ) | 21.57.PERCENTRANK( 1 ) | |
| 21.17.CRITBINOM( 1 ) | 21.58.PERMUT( 1 ) | |
| 21.18.DATEVALUE( 4 ) | 21.59.POISSON( 2 ) | |
| 21.19.DAY( 1 ) | 21.60.PROB( 2 ) | |
| 21.20.DAYS360( 1 ) | 21.61.QUARTILE( 3 ) | |
| 21.21.DEVSQ( 1 ) | 21.62.RANK( 1 ) | |
| 21.22.EXPONDIST( 2 ) | 21.63.RSQ( 1 ) | |
| 21.23.FDIST( 1 ) | 21.64.SKEW( 1 ) | |
| 21.24.FINV( 1 ) | 21.65.SLOPE( 1 ) | |
| 21.25.FISHER( 1 ) | 21.66.SMALL( 1 ) | |
| 21.26.FISHERINV( 1 ) | 21.67.STANDARDIZE( 1 ) | |
| 21.27.FORECAST( 1 ) | 21.68.STDEV( 1 ) | |
| 21.28.FREQUENCY( 1 ) | 21.69.STDEVA( 2 ) | |
| 21.29.FTEST( 1 ) | 21.70.STDEVP( 1 ) | |
| 21.30.GAMMADIST( 2 ) | 21.71.STEYX( 1 ) | |
| 21.31.GAMMAINV( 1 ) | 21.72.TDIST( 1 ) | |
| 21.32.GAMMALN( 1 ) | 21.73.TINV( 1 ) | |
| 21.33.GEOMEAN( 1 ) | 21.74.TREND( 1 ) | |
| 21.34.GROWTH( 1 ) | 21.75.TRIMMEAN( 1 ) | |
| 21.35.HARMEAN( 1 ) | 21.76.TTEST( 1 ) | |
| 21.36.HYPGEOMDIST( 1 ) | 21.77.VAR( 1 ) | |
| 21.37.INTERCEPT( 1 ) | 21.78.VARA( 1 ) | |
| 21.38.KURT( 1 ) | 21.79.VARP( 1 ) | |
| 21.39.LARGE( 1 ) | 21.80.VARPA( 1 ) | |
| 21.40.LINEST( 1 ) | 21.81.WEIBULL( 2 ) | |
| 21.41.LOGEST( 1 ) | 21.82.ZTEST( 2 ) | |
| 22.Text functions | ||
| 22.1.ASC( 1 ) | 22.14.MID( 2 ) | |
| 22.2.BAHTTEXT( 1 ) | 22.15.PHONETIC( 1 ) | |
| 22.3.CHAR( 4 ) | 22.16.PROPER( 1 ) | |
| 22.4.CLEAN( 2 ) | 22.17.REPLACE( 3 ) | |
| 22.5.CODE( 3 ) | 22.18.REPT( 6 ) | |
| 22.6.CONCATENATE( 1 ) | 22.19.RIGHT( 2 ) | |
| 22.7.DOLLAR( 4 ) | 22.20.SEARCH( 6 ) | |
| 22.8.EXACT( 2 ) | 22.21.SUBSTITUTE( 11 ) | |
| 22.9.FIND( 3 ) | 22.22.TEXT( 11 ) | |
| 22.10.FIXED( 4 ) | 22.23.TRIM( 1 ) | |
| 22.11.LEFT( 5 ) | 22.24.UPPER( 2 ) | |
| 22.12.LEN( 7 ) | 22.25.VALUE( 1 ) | |
| 22.13.LOWER( 1 ) | ||