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.