Next cohorts · Spreadsheet Fundamentals: Part 1 · Jan 11

Spreadsheet Fundamentals: Part 2

Build speed and confidence using core spreadsheet formulas. Practice with larger datasets and problems that span multiple sheets.

Live · Feb 1with Suzanne Corley

Who it’s forPart 1 graduates or similar experience

What you’ll learn.

Dive deeper, gain more practice, and increase your comfort and proficiency to feel confident every time you open a spreadsheet.

Curriculum

Session 01

Fundamentals

Increase speed and intuition:

  • Navigating without your mouse and using keyboard shortcuts
  • Applying formatting best practices
  • Linking and locking cell references
Session 02

Summarizing data

Gain repetition:

  • Summarizing data with sumifs and countifs
  • Summarizing data by month to highlight trends
  • Text manipulation for easy data cleanup and maintenance
Session 03

Data analysis

Master understanding of how and when to use:

  • Dynamic data filtering and sorting
  • Lookup formulas
  • Dropdown menus
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 2.