Formatting Worksheets Autoformat Labels

Editing Cell Contents Copy and Paste Drag and drop vs cut and paste

referencing cells Find Smart Tag Named Ranges

Advanced Math Functions Real numbers The QUOTIENT() function The PRODUCT() function The SIGN() function Complex numbers The IMAGINARY() function The IMREAL() function The IMPRODUCT() function The IMSUB The IMSUM The IMABS The COMPLEX() function The IMCONJUGATE() function Matrices The MMULT() function The MINVERSE() function The MDETERM() function The TRANSPOSE() function

Advanced Stats Functions The descriptive statistics tool Standard deviations The STDEVA fucntion The STDEVP function The STDEVPA function The DEVSQ() function The VAR() function The VARA() function The VARP() function The VARPA() function The COVAR() function The SKEW() function The GEOMEAN() function The HARMEAN() function The QUARTILE() function The interquartile range The CONFIDENCE() function The RAND() function The RANDBETWEEN() function Rand function Bugs The PROB() function The LINEST() function The LOGEST function

Distribution Functions Continuous Distributions The NORMDIST() function The NORMSDIST function The BETADIST() function The GAMMADIST() function The CHIDIST() function The FDIST() function Discrete Distributions The BINOMDIST() function The CRTBINOM() function The HYPGEOMDIST() function The NEGBINOMDIST() function The POSSION() function Continuous Distribution Inverse functions The NORMSIV() function The BETAINV() function The GAMMAINV() function The CHIINV() function The FINV() function The TINV() function

Advanced Trig Functions The COSH() function The SINH() function The TANH() function The ACOSH function The ASINH() function The ATANH() function

Reference Functions The IS function The VLOOKUP() functions VLOOKUP across multiple sheets The LOOKUP() function The HLOOKUP function The MATCH() function The HYPERLINK() functions The ADRESS() function The COLUMN() function The COLUMS()function The ROW() function The ROWS() function

Database Functions The DTRANSPOSE() function The DAVERAGE() function The DCOUNT() function TheDCOUNTA() function The DMAX() function The MIN() function The DSUM function The DPRODUCT function Sum of squares functions The DSTDEV function The DSTDEVP function The DSTDEVA function The DVAR() function The DVARP() function

Charts The Area chart The Stock chart The Surface chart 3D Pie chart The Bubble chart The Doughnut chart The Radar chart Cylinder, Cone and Pyramid Charts