This would help you in making u comfortable in Microsoft Excel.
Advanced Excel Formulas
officeDeskripsi lengkap
Guia de formulas DAXDescripción completa
Descripción completa
Deskripsi lengkap
Descrição completa
officeDescrição completa
officeFull description
Excel Formulas & Macros
Full description
L:earn advanced formula techniques for all versions of MS Excel - advanced lookups, array formulas, advanced concepts using everyday formulas.
Descripción completa
Excel-formulas-functions-pdf
Descrição completa
excel macrosFull description
Descripción completa
Formulas de excel
fSrc fSrc
fTyp fType e
STD ATP ATP STD STD STD ATP ATP STD STD STD STD STD STD STD STD STD STD STD STD ATP ATP ATP ATP STD STD ATP ATP ATP STD STD STD STD STD STD STD STD STD STD STD STD STD ATP STD STD ATP STD STD STD STD STD STD STD ATP ATP ATP ATP ATP ATP STD STD ATP
F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F
fGroup Math Financial Financial Math Math Lookup Financial Financial Logical Lookup Text Math Math Math Math Math Statistical Statistical Statistical Text Engineering Engineering Engineering Engineering Statistical Statistical Engineering Engineering Engineering Statistical Math Information Text Statistical Statistical Statistical Lookup Text Text Lookup Lookup Math Engineering Text Statistical Engineering Statistical Math Math Statistical Statistical Information Math Financial Financial Financial Financial Financial Financial Statistical Statistical Financial
ATP STD STD STD STD STD STD STD STD STD STD STD STD ATP ATP ATP STD ATP STD STD ATP STD STD STD ATP ATP STD STD STD STD ATP STD STD ATP ATP ATP ATP ATP STD a dd i n STD STD STD STD STD ATP STD STD STD STD STD STD STD STD STD STD STD STD STD ATP STD STD STD ATP
F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F
Financial Date Undocumented Undocumented Date Database Date Date Financial Text DoubleByte Database Database Financial Engineering Engineering Engineering Math Engineering Statistical Database Financial Database Database Text Financial Financial Database Database Database Database Financial Database Database Date Financial Date Engineering Engineering Information External Math Text Math Statistical Math Math Logical Statistical Text Text DoubleByte Statistical Statistical Statistical Text Math Statistical Statistical Statistical Financial Financial Statistical Statistical Statistical Math
STD ATP STD STD STD ATP ATP ATP STD STD STD STD STD ATP ATP ATP ATP ATP ATP ATP ATP ATP ATP ATP ATP ATP ATP ATP ATP ATP STD STD STD STD STD ATP STD STD STD STD STD ATP STD STD STD STD ATP STD STD STD STD STD STD ATP STD STD STD STD STD STD STD STD STD STD
F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F
GEOMEAN GESTEP GETPIVOTDATA GROWTH HARMEAN HEX2BIN HEX2DEC HEX2OCT HLOOKUP HOUR HYPERLINK HYPGEOMDIST IF IMABS IMAGINARY IMARGUMENT IMCONJUGATE IMCOS IMDIV IMEXP IMLN IMLOG10 IMLOG2 IMPOWER IMPRODUCT IMREAL IMSIN IMSQRT IMSUB IMSUM INDEX INDIRECT INFO INT INTERCEPT INTRATE IPMT IRR ISBLANK ISERR ISERROR ISEVEN ISLOGICAL ISNA ISNONTEXT ISNUMBER ISODD ISPMT ISREF ISTEXT JIS KURT LARGE LCM LEFT LEFTB LEN LENB LINEST LN LOG LOG10 LOGEST LOGINV
Statistical Engineering Database Statistical Statistical Engineering Engineering Engineering Lookup Date Lookup Statistical Logical Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Lookup Lookup Information Math Statistical Financial Financial Financial Information Information Information Information Information Information Information Information Information Financial Information Information Text DoubleByte Statistical Statistical Math Text Text DoubleByte Text Text DoubleByte Statistical Math Math Math Statistical Statistical
STD STD STD STD STD STD STD ATP STD STD STD STD STD STD STD STD STD STD STD STD ATP ATP STD STD STD ATP ATP STD STD STD STD STD STD STD STD STD ATP ATP ATP STD ATP ATP ATP ATP STD STD STD STD STD STD STD STD STD STD STD STD ATP ATP ATP STD STD STD STD STD
F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F
DISTR.LOG.NORM BUSCAR MINUSC COINCIDIR MAX fnNA:MAXA MDETERM DURACION.MODIF MEDIANA EXTRAE EXTRAE MIN fnNA:MINA MINUTO MINVERSA TIRM MMULT RESIDUO MODA MES REDOND.MULT MULTINOMIAL N NOD NEGBINOMDIST DIAS.LAB TASA.NOMINAL DISTR.NORM DISTR.NORM.INV DISTR.NORM.ESTAND DISTR.NORM.ESTAND.INV NO AHORA NPER VNA CADENA.NUMERO OCT.A.BIN OCT.A.DEC OCT.A.HEX REDONDEA.IMPAR PRECIO.PER.IRREGULAR.1 RENDTO.PER.IRREGULAR.1 PRECIO.PER.IRREGULAR.2 RENDTO.PER.IRREGULAR.2 DESREF O PEARSON PERCENTIL RANGO.PERCENTIL PERMUTACIONES fnNA:PHONETIC PI PAGO POISSON POTENCIA PAGOPRIN PRECIO PRECIO.DESCUENTO PRECIO.VENCIMIENTO PROBABILIDAD PRODUCTO NOMPROPIO VA CUARTIL
LOGNORMDIST LOOKUP LOWER MATCH MAX MAXA MDETERM MDURATION MEDIAN MID MIDB MIN MINA MINUTE MINVERSE MIRR MMULT MOD MODE MONTH MROUND MULTINOMIAL N NA NEGBINOMDIST NETWORKDAYS NOMINAL NORMDIST NORMINV NORMSDIST NORMSINV NOT NOW NPER NPV NUMBERSTRING OCT2BIN OCT2DEC OCT2HEX ODD ODDFPRICE ODDFYIELD ODDLPRICE ODDLYIELD OFFSET OR PEARSON PERCENTILE PERCENTRANK PERMUT PHONETIC PI PMT POISSON POWER PPMT PRICE PRICEDISC PRICEMAT PROB PRODUCT PROPER PV QUARTILE
Statistical Lookup Text Lookup Statistical Statistical Math Financial Statistical Text Text DoubleByte Statistical Statistical Date Math Financial Math Math Statistical Date Math Math Information Information Statistical Date Financial Statistical Statistical Statistical Statistical Logical Date Financial Financial Undocumented Engineering Engineering Engineering Math Financial Financial Financial Financial Lookup Logical Statistical Statistical Statistical Statistical Text Math Financial Statistical Math Financial Financial Financial Financial Statistical Math Text Financial Statistical
ATP STD STD ATP STD STD ATP STD STD STD STD STD STD STD STD STD STD STD STD STD STD STD STD ATP STD STD STD STD STD STD STD addin STD ATP STD STD STD STD STD STD STD STD STD STD STD STD STD STD STD STD STD STD STD ATP ATP ATP STD STD STD STD STD STD STD STD
F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F
QUOTIENT RADIANS RAND RANDBETWEEN RANK RATE RECEIVED REPLACE REPLACEB REPT RIGHT RIGHTB ROMAN ROUND ROUNDDOWN ROUNDUP ROW ROWS RSQ RTD SEARCH SEARCHB SECOND SERIESSUM SIGN SIN SINH SKEW SLN SLOPE SMALL SQL.REQUEST SQRT SQRTPI STANDARDIZE STDEV STDEVA STDEVP STDEVPA STEYX SUBSTITUTE SUBTOTAL SUM SUMIF SUMPRODUCT SUMSQ SUMX2MY2 SUMX2PY2 SUMXMY2 SYD T TAN TANH TBILLEQ TBILLPRICE TBILLYIELD TDIST TEXT TIME TIMEVALUE TINV TODAY TRANSPOSE TREND
Math Math Math Math Statistical Financial Financial Text Text DoubleByte Text Text Text DoubleByte Math Math Math Math Lookup Lookup Statistical Lookup Text Text DoubleByte Date Math Math Math Math Statistical Financial Statistical Statistical External Math Math Statistical Statistical Statistical Statistical Statistical Statistical Text Math Math Math Math Math Math Math Math Financial Text Math Math Financial Financial Financial Statistical Text Date Date Statistical Date Lookup Statistical
STD STD STD STD STD STD STD STD STD STD STD STD STD STD STD STD ATP STD ATP ATP ATP STD ATP ATP ATP ATP STD STD STD STD STD STD STD STD STD STD STD STD STD STD STD STD STD STD STD STD ATP ATP ATP ATP ATP ATP STD STD STD STD STD STD STD STD STD STD STD STD
F F F F F F F F F F F F F F F F F F F F F F F F F F F C C C C C C C C C C C C C C C C C C C C C C C C C C C C C C C C C C C C C
MEDIA.ACOTADA TRIMMEAN ADMINISTRACIÓN DE CONTRATOS MEDIA.ARMO HARMEAN MEDIA.GEOM GEOMEAN MEDIANA MEDIAN MES MONTH MIN MIN MINUSC LOWER MINUTO MINUTE MINVERSA MINVERSE MMULT MMULT MODA MODE MONEDA DOLLAR MOSTRAR.BARRA SHOW.BAR MOVIE.COMMAND MOVIE.COMMAND MULTIPLO.INFERIOR FLOOR MULTIPLO.SUPERIOR CEILING N N NEGBINOMDIST NEGBINOMDIST NO NOT NOD NA NOMBRES NAMES NOMPROPIO PROPER NORMALIZACION STANDARDIZE NOTA NOTE NPER NPER NSHORA TIME NUMERO.ROMANO ROMAN O OR STAS ET PAGO PMT PAGOINT IPMT PAGOPRIN PPMT PASO.A.PASO STEP PAUSA PAUSE PEARSON PEARSON PENDIENTE SLOPE PERCENTIL PERCENTILE PERMUTACIONES PERMUT CER CUSTOM.UNDO IR CUSTOM.REPEAT PI PI POISSON POISSON POSICIONA FPOS POTENCIA POWER NTA PRESS.TOOL PROBABILIDAD PROB PRODUCTO PRODUCT PROMEDIO AVERAGE PRONOSTICO FORECAST PRUEBA.CHI CHITEST PRUEBA.CHI.INV CHIINV PRUEBA.F FTEST PRUEBA.FISHER.INV FISHERINV \\vboxsrv\conversion_tmp\scratch31837\90782665.xlsx.ms_office
4/1/2012
Page 19 of 21
PRUEBA.T PRUEBA.Z RADIANES RAIZ RANGO.PERCENTIL REANUDAR REDONDEA.IMPAR REDONDEA.PAR REDONDEAR REDONDEAR.MAS REDONDEAR.MENOS REEMPLAZAR REEMPLAZARB REFABS REFREL REFTEXTO REGISTRAR REINICIAR REPETIR RESIDUO RESTABLECER.BARRA RESULTADO CA SEGUNDO SELECCION SENO SENOH SERIES SI SIFECHA SIGNO SLN SOLICITAR SUBTOTALES SUMA SUMA.CUADRADOS SUMAPRODUCTO SUMAR.SI SUMAX2MASY2 SUMAX2MENOSY2 SUMAXMENOSY2 SUSTITUIR SYD T DATOS TAMAÑOA TAN TANH TASA TENDENCIA TERMINAR TEXTO TEXTOREF
ADMINISTRACIÓN DE CONTRATOS TTEST ZTEST RADIANS SQRT PERCENTRANK RESUME ODD EVEN ROUND ROUNDUP ROUNDDOWN REPLACE REPLACEB ABSREF RELREF REFTEXT REGISTER RESTART REPT MOD RESET.TOOLBAR RESULT SPELLING.CHECK SECOND SELECTION SIN SINH SERIES IF DATEDIF SIGN SLN REQUEST SUBTOTAL SUM SUMSQ SUMPRODUCT SUMIF SUMX2PY2 SUMX2MY2 SUMXMY2 SUBSTITUTE SYD T PIVOT.ADD.DATA FSIZE TAN TANH RATE TREND TERMINATE TEXT TEXTREF
TIPO TIPO.DE.ERROR TIR TIRM TRANSFERIR TRANSPONER TRUNCAR ULTIMO.ERROR USDOLLAR VA VALOR VALREF VAR VARP VENTANA.TITULO VENTANAS VF VINCULOS VNA VOLATIL Y FALSO VERDADERO
ADMINISTRACIÓN DE CONTRATOS TYPE ERROR.TYPE IRR MIRR POKE TRANSPOSE TRUNC LAST.ERROR USDOLLAR PV VALUE DEREF VAR VARP WINDOW.TITLE WINDOWS FV LINKS NPV VOLATILE AND FALSE TRUE