Data Analysis Tools

Here you will step-by-step videos to guide you as you create various data analysis tools using spreadsheets, specifically Microsoft Excel or Google Sheets.

Time Series Chart
Step by Step Video (Excel)
Step by Step Video (Excel)
0:00 / 0:00
Step by Step Video (Google Sheets)
Step by Step Video (Google Sheets)
0:00 / 0:00
Pareto Chart
Step by Step Video (Excel)
Step by Step Video (Excel)
0:00 / 0:00
Step by Step Video (Google Sheets)
Step by Step Video (Google Sheets)
0:00 / 0:00
Histogram
Step by Step Video (Excel)
Step by Step Video (Excel)
0:00 / 0:00
Step by Step Video (Google Sheets)
Step by Step Video (Google Sheets)
0:00 / 0:00
Scatter Plot
  • Step by Step Video (Google Sheets — Arriving April 2026)
Step by Step Video (Excel)
Step by Step Video (Excel)
0:00 / 0:00
Descriptive Statistics
  • Step by Step Video (Excel — Arriving April 2026)
VLookup Function
  • Step by Step Video (Google Sheets — same as Excel)
Step by Step Video (Excel)
Step by Step Video (Excel)
0:00 / 0:00
XLookup Function
  • Step by Step Video (Google Sheets — same as Excel)
Step by Step Video (Excel)
Step by Step Video (Excel)
0:00 / 0:00
Filter Function
  • Step by Step Video (Google Sheets — same as Excel)
Pivot Table
Step by Step Video (Excel)
Step by Step Video (Excel)
0:00 / 0:00