TY - BOOK AU - BarCharts,Inc TI - Excel 2013 Formulas - Advanced SN - 9781423223320 PY - 2014/// CY - Boca Raton PB - BarCharts, Inc. KW - Electronic books N1 - Introduction -- Financial Functions -- To create running totals -- Creating an Amortization Chart -- Logical Functions -- IF Function -- OR and AND Functions -- Combining Logical Functions -- Text -- Extracting First Names -- Extracting Last Names -- Extracting Middle Names -- CONCATENATE Function -- Lookup & Reference -- INDEX Function -- MATCH Function -- Combining INDEX and MATCH Functions -- Math -- Statistical -- To use COUNT functions -- T-Tests -- Database Functions -- Referencing Cells in Different Workbooks UR - https://ebookcentral.proquest.com/lib/bcsl-ebooks/detail.action?docID=4876975 ER -