Next cohorts · Spreadsheet Fundamentals: Part 1 · Jan 11

Spreadsheet Fundamentals: Part 1

The most complete course to learn the basics of spreadsheet data analysis

Live · Jan 11Beginner · with Suzanne Corley

Who it’s forBeginners

What you’ll learn.

Build comfort in Excel and Google Sheets, save time dealing with lists of data, create effective data summaries, and present well-formatted analysis. Three live, 90-minute classes include 1:1 office hours, video recordings, and practice exercises.

Curriculum

Session 01

Fundamentals & lists

Build comfort in Excel/Sheets and save time dealing with lists of data.

  • Keyboard shortcuts
  • Linking and locking cell references
  • Text manipulation for easy list clean-up and maintenance
  • Remove duplicates, unique
  • Static filter, filter views, and sort
Session 02

Intro to summarizing data

Learn to create effective data summaries

  • Summarizing data with sumifs and countifs
  • Summarizing data with pivot tables
  • Dynamic data filtering
  • Create dropdowns
  • Conditional formatting
Session 03

Data analysis & presentation

Create more advanced data analysis and well-formatted summaries.

  • Formatting best practices for effective presentation of data
  • Summarize data by month to highlight trends
  • Introduction to lookups
  • Dynamic sort
Buying for a smaller team?

Buy seats in an open course.

If one live cohort or self-paced course already fits your needs, you can purchase seats online without creating a private program. For a larger group, an invoice, multiple topics, or a program shaped to your team, talk with us first.

Choose how you want to learn.

Review the available Live cohort for Spreadsheet Fundamentals: Part 1.