Cover -- Contents -- Introduction -- Chapter 1 An Overview of Excel -- Excel Components -- Cells -- Tables -- Pivot Tables -- Charts and Pivot Charts -- External Data -- Add-Ins -- Data Analysis -- Chapter 2 The Excel User Interface -- Worksheets and Cells -- The Ribbon -- Home Commands -- View Commands -- Page Layout Commands -- Review Commands -- The Backstage View -- Chapter 3 Getting External Data -- Data from Text Files -- Data from Microsoft Access -- Managing Connections -- Data from SQL Server -- Microsoft Query -- Chapter 4 Tables -- Table Basics -- Table Tools -- Sorting -- Filters -- Chapter 5 Pivot Table Basics -- The Field List -- Field Arrangement and Layout -- Expanding and Collapsing Fields -- Showing Details -- Filters -- Slicers -- Timelines -- Sorting -- Chapter 6 Pivot Table Calculations -- Subtotals and Totals -- Grouping -- Calculated Items and Fields -- Percentages and Ranks -- Summarization -- Relationships and Data Models -- Chapter 7 Charts and Pivot Charts -- Pivot Chart Basics -- Layout Options -- Column and Bar Charts -- Pie Charts -- Line and Radar Charts -- Standard Charts -- Sparklines -- Chapter 8 Data Commands -- Sorting and Filtering -- Subtotals and Grouping -- Text to Columns and Flash Fill -- Data Validation -- Chapter 9 Formulas -- Formula Basics -- Relative and Absolute Cell References -- The Name Manager -- Formula Auditing -- Functions -- Nested Functions -- Chapter 10 Text Functions -- Joining Text -- Text Substrings -- Finding and Replacing Text -- Splitting Text -- Case Conversion -- Converting to and from Text -- Chapter 11 Numeric and Date Functions -- Arithmetic -- Rounding -- Unit Conversion -- Financial Analysis -- Dates and Time -- Chapter 12 Aggregate and Statistical Functions -- Sums -- Counts -- Averages -- Percentiles and Ranks -- Frequencies and Variability -- Correlation and Regression.

Array Functions and the Sum of Products -- Chapter 13 Logical and Lookup Functions -- Logical Functions -- IS Functions -- Lookup Functions -- Chapter 14 Analysis Tools -- Data Analysis -- Data Tables -- Scenario Manager -- Goal Seek -- Solver -- Index -- 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.