Spreadsheets can combine user-selected inputs with raw data to create powerful, dynamic models for pricing, forecasting, finance, and so on. Learning how to create these models, however, is not always straightforward. This class will teach you how to create a flexible, attractive model in a spreadsheet.
Who is this class for? This class is designed for people who know some advanced spreadsheet features ("IF" tests and the "SUM" function, for example), but want to take that knowledge to the next level to create dynamic, flexible models. If you're looking for an introductory class, check out this Spreadsheets 101 class. Note: if you don't know how to use an IF test, I recommend you take the 101 and 201 classes in sequence.
What will I learn?
What should I bring? The class is structured as an interactive tutorial, so please bring a laptop, your sense of humor, and any questions you have. I will email you a spreadsheet in advance of the class. Although I'll be using Excel to teach, you can use either of Google Docs or Excel for the class.
58 E 11th St 8th Floor
New York, NY
6:30 pm - 8:00 pm ESTAdd to Cal
I’m the Director of Community at FirstMark Capital. I’ve taught nearly 400 students on Skillshare and am a Master Teacher, a distinction which only a small group of teachers have. My class topics range from SQL intro classes to workshops on learning to code in 120 minutes. You can read my 100+ student endorsements here. I taught myself to code in high school, then majored in computer science (and TA'd intro to CS) in college. Then I forgot most of it. Then I started coding again and got most of it back. Also, I love to teach.