Next cohorts · Spreadsheet Fundamentals: Part 1 · Jan 11

Spreadsheet Fundamentals: Part 1

Build a strong foundation in Excel or Google Sheets. Learn to organize data, write formulas, and create useful analyses for work.

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 our courses.

Choose one or more Live cohorts or Self-paced courses and buy the seats your team needs online. For an invoice, private training, 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.