Basics of data analysis in spreadsheets.
Cost per seat: $595
3 live classes
90 mins each
1:1 office hours
and practice exercises
What you’ll learn
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
How do the courses work?
Each course is taught over multiple highly-interactive Zoom-based classes. They are designed so you can follow along in your own spreadsheet and try out what you’re learning during the class. Participants can also attend individual office hours to help connect in-class concepts to their real work.
Can I arrange training for my team?
Yes, we primarily offer training for corporate and investment teams. Please contact us at email@example.com to discuss and schedule training for your team.
I am not part of a team. Can I still join training?
I use Google Sheets. Can I still take this training?
Yes! We teach Excel and Google Sheets. And if you feel like you lost efficiency by moving from Excel to Google Sheets, we’re here to help! You’ll learn the shortcuts and formulas to help you save time and learn to love Sheets.
I use a Mac. Can I still take this training?
Yes! We teach PC and Mac users.
Can you tailor the content to my business?
Yes, we are happy to incorporate your company’s data or other examples that are relevant to your business to make it highly relatable and impactful for your team.
How much does training cost?
Please reach out to us at firstname.lastname@example.org for more information on courses and pricing.
I’m not sure I’m ready to take a course. Can I try any free classes?
Yes, you can try our free weekly classes to experience our teaching first-hand. Check out our Try A Class page for upcoming times.