Excel Data Analysis for dummies

  • Chapter 1 Learning Basic Data-Analysis Techniques
  • Chapter 2 Working with Data-Analysis Tools
  • Chapter 3 Introducing Excel Tables
  • Chapter 5 Cleaning Data
  • Chapter 6 Analyzing Table Data with Database Function
  • Chapter 7 Creating and Using PivotTables
  • Chapter 8 Performing PivotTable Calculations
  • Chapter 9 Building PivotCharts
  • Chapter 10 Tracking Trends and Making Forecasts
  • Chapter 11 Analyzing Data with Statistics
  • Chapter 12 Analyzing Data with Descriptive Statistics
  • Chapter 13 Analyzing Data with Inferential Statistics

    Excel Data Analysis

  • T-test
  • Regression

    Excel Charts

  • Interactive HeatMap

    Excel tips

  • Index after filter
  • Create Sheet Contents
  • Create Hyperlink of Sheet
  • Compare two columns