Basics of Data Analysis

• Introduction to Data Analysis
• Data: The basics
• How do we analyze data ? methodologies, tools and techniques
• How to summarize and describe raw information - the data
• The main purpose of statistics: Testing a hypothesis
• Statistics: Turning information into knowledge
• Simple graphical and numerical summaries of a data set

The Role of Statistics and the Data Analysis Process

• Understanding Statistics
• Understanding basic probability concepts
• Collecting data sensibly
• Use of simulations in data analysis investigations
• Foundations for inference: Sampling distributions
• Foundations for inference: Confidence intervals
• Inference for numerical data
• Inference for categorical data
• Sampling distributions and the Central Limit Theorem
• Introduction to linear regression
• Multiple linear regression
• T tests, including paired and two sample, assuming equal and unequal variances
• Z tests
• The Normal Distribution and Z-Scores
• P-value, or the degree of disagreement between the data and the hypothesis
• And more

Customizing the Excel Environment

• Configure Excel Options
• Customize the Ribbon and the Quick Access Toolbar
• Enable Excel Add-Ins

Creating Advanced Functions and Formulas

• Logical functions
• Conditional functions
• Financial functions
• Text functions
• Date and time functions
• Specialized Functions
• Range Names in Formulas
• Array Formulas
• Calculation options

Analyzing Data with Functions and Conditional Formatting

• Analyze Data by Using Text and Logical Functions
• Apply Advanced Conditional Formatting

Lookups and Data Tables

• Using lookup functions
• Creating data tables

Organizing and Analyzing Datasets and Tables

• Create and Modify Tables
• Advanced data management
• Validating cell entries
• Sort Data
• Filter Data
• Advanced filtering
• SUBTOTAL and Database Functions

Hypothesis Testing

• Using Excel to get the critical values and the P-values needed to complete the test
  • Functions used to get critical values and P-values
  • Hypothesis Tests About a Proportion
  • Functions that use the standard normal (z) distribution
  • Hypothesis Tests About a Mean: Not Known (t-test)
  • Functions that use the t-distribution
  • Hypothesis Tests About a Mean: Known
  • Functions that use the standard normal (z) distribution.

Visualizing Data with Basic Charts

• Create Charts
• Modify and Format Charts

Advanced Charting

• Chart formatting options
• Combination charts
• Graphical objects

Preparing Data and Creating PivotTables

• Prepare Data
• Working with PivotTables
• Create a PivotTable from a Local Data Source
• Create a PivotTable from Multiple Local Data Sources
• Create a PivotTable from an External Data Source
• Modifying PivotTable data

Examining Data Using PivotTables

• Format a PivotTable
• Filter PivotTable Data
• Refresh and Change PivotTable Data
• PowerPivot

Analyzing Data with PivotTables, Slicers, and PivotCharts

• Organize PivotTable Data
• Summarize PivotTable Data
• Analyze PivotTable Data
• Using PivotCharts
• Present Data with PivotCharts
• Filter Data by Using Slicers

Working with PivotCharts

• Create a PivotChart
• Manipulate PivotChart Data
• Format a PivotChart