Class Details

Manipulating and Understanding Data in Excel Price: $1,500

Training promotions may be available, contact a training consultant at 240-667-7507 for more information!

This two-day training will take attendees from performing basic data analyses in Excel to cleaning and processing data and creating regression models and visualizations. The course will introduce foundational statistical concepts and train students in key data operations in Excel. Students will become comfortable with data manipulation, formatting, and visualization in Excel. The workshop optimizes learning by integrating practice time and discussion time in class to improve retention and provide individualized support throughout the session. The course will also include pre-work videos and exercises, as well as take-home exercises that reinforce the concepts taught in the course.

Price Match Guarantee Phoenix TS

Manipulating and Understanding Data in Excel Course Includes:

  • 2 days of instructor-led training
  • Class exercises in addition to training instruction
  • Courseware books, notepads, pens, highlighters and other materials
  • Course retake option
  • A second voucher included with full purchase 
  • Full breakfast with variety of bagels, fruits, yogurt, doughnuts and juice
  • Tea, coffee, and soda available throughout the day
  • Freshly baked cookies every afternoon - *only at participating locations

Course Outline

Overview of data science and Excel:

  • What is data science?
  • Excel basics – tool capabilities

Data manipulation in Excel:

  • Data sorting, aggregation, and cleaning
  • Filtering data
  • Pivot tables
  • If-statements and formulas vlookups and hlookups
  • Introductory text cleanup

Basic visualizations and best practices:

  • Formula lookup
  • Introductory data formatting
  • Exploratory data visualization
  • Shortcut keys

Introduction to statistics:

  • Basic statistics
  • Summary statistics
  • Data distribution and variance
  • Covariance and correlation
  • Introduction to regression
  • Distribution of errors: Q-Q plot, heteroscedasticity
  • R2
  • p-values and t-test

Objectives

Manipulating and Understanding Data in Excel Training Objectives: 

  • Have facility with basic functions in Excel
  • Manipulate, aggregate and re-order data in Excel
  • Clean and prepare data for analysis
  • Perform basic regression analyses in Excel and check for model validity
  • Create basic visualizations in Excel

 

 

Register for Class

Date Location
01/14/19 - 01/15/19, 2 days, 8:30AM – 4:30PM Online Register
01/28/19 - 01/29/19, 2 days, 8:30AM – 4:30PM Online Register
02/13/19 - 02/14/19, 2 days, 8:30AM – 4:30PM Columbia, MD Register
02/27/19 - 02/28/19, 2 days, 8:30AM – 4:30PM Tysons Corner, VA Register
03/25/19 - 03/26/19, 2 days, 8:30AM – 4:30PM Tysons Corner, VA Register
04/03/19 - 04/04/19, 2 days, 8:30AM – 4:30PM Columbia, MD Register
04/29/19 - 04/30/19, 2 days, 8:30AM – 4:30PM Online Register
05/06/19 - 05/07/19, 2 days, 8:30AM – 4:30PM Online Register
05/22/19 - 05/23/19, 2 days, 8:30AM – 4:30PM Columbia, MD Register
06/05/19 - 06/06/19, 2 days, 8:30AM – 4:30PM Tysons Corner, VA Register
07/08/19 - 07/09/19, 2 days, 8:30AM – 4:30PM Tysons Corner, VA Register
07/17/19 - 07/18/19, 2 days, 8:30AM – 4:30PM Columbia, MD Register
08/05/19 - 08/06/19, 2 days, 8:30AM – 4:30PM Online Register
08/12/19 - 08/13/19, 2 days, 8:30AM – 4:30PM Online Register
08/28/19 - 08/29/19, 2 days, 8:30AM – 4:30PM Columbia, MD Register
09/11/19 - 09/12/19, 2 days, 8:30AM – 4:30PM Tysons Corner, VA Register
10/07/19 - 10/08/19, 2 days, 8:30AM – 4:30PM Tysons Corner, VA Register
10/23/19 - 10/24/19, 2 days, 8:30AM – 4:30PM Columbia, MD Register
11/11/19 - 11/12/19, 2 days, 8:30AM – 4:30PM Online Register
11/18/19 - 11/19/19, 2 days, 8:30AM – 4:30PM Online Register
12/11/19 - 12/12/19, 2 days, 8:30AM – 4:30PM Columbia, MD Register
12/18/19 - 12/19/19, 2 days, 8:30AM – 4:30PM Tysons Corner, VA Register