Spreadsheet Fundamentals: Part 1
The most complete course to learn the basics of spreadsheet data analysis
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
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
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
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
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.