Arranging and Querting Data
  • Understanding Excel Tables
  • Advanced Filtering
  • Tricks For Importing Data
  • Using Microsoft Query
  • Running Web Queries
Validating and Qualifying Data
  • Text Cleaning Functions
  • Functions that manipulate Text Strings
  • Using Data Validation
Working with PivotTables and PivotCharts
  • Understanding Pivot Tables
  • Adding Calculations in Pivot Tables
  • Creating Pivot Charts
  • Customizing Your Pivot Charts
Using Criteria-Based Functions
  • Using DMAX and DIMN
  • Using DGET to Find Specific Values
  • Using DSUM to Add Values Based on Selection Criteria
  • Counting Values
Calculating and Displaying Statistics
  • Percentiles and Quartile
  • Understanding Standard Deviation
  • Calculating Rank and Percent Rank
  • Functions That Create Descriptive Statistics
  • Creating a Histogram
  • Calculating Moving Averages
Creating Data Models
  • Using a Scatter Plot to Show Relationships
  • Understanding Linear Regression
  • Using Solver to Model Data
Ten Jobs For Excel Gurus
  • Ten Jobs For Excel Gurus
eBook Excel Data Analysis For Dummies, 2nd edition
  • eBook Excel Data Analysis For Dummies, 2nd edition PART 1
  • eBook Excel Data Analysis For Dummies, 2nd edition PART 2