DAY 1

Data Collection

In Data Collection and Working with Excel®, participants learn how to build flexible models in Excel®, load data from files and the web, analyze data in tables and pivot tables, shape data through text processing, handle errors in formulas, use lookup tables, and construct customized charts and graphs.

Topics

Introduction to the Data Analytics Pipeline

  • Overview and Learning Objectives
  • The Data Analytics Pipeline

Essentials of Excel

  • Value, Type, and Format
  • Conditional Formatting
  • References and Formulas
  • Named Ranges
  • Working with Dates
  • Testing Conditions

Loading Data

  • Sources of Data
  • Delimited Files
  • Web Scraping

Working with Data in Tables

  • Tables
  • Slicers
  • Pivot Tables

Shaping Data with Text Processing

  • Data Shaping
  • Text Processing Functions
  • Converting Text to Numbers

Exploring Data Through Charts and Graphs

  • Common Charts
  • Customizing Charts
  • Sparklines

Building Flexible Models with Lookup Tables

  • Exact Match Lookup
  • Approximate Match
  • Handling Errors
  • Alternate Lookup Functions

Practicum (optional)

Data Collection Summary


Practical Application and Demonstrations

The Data Collection portion of the program features over 10 demonstrations, 5 hands-on exercises, examples, and formal discussions.

Provided with multiple real-world data sets, participants gain in-depth practice using Microsoft® Excel.

Practicum

The day culminates with a practicum, where participants work individually to build a complete spreadsheet model.