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.
I spent the last seven years of my career in Excel, and was once told by the co-founder of my previous company that "Watching you use Excel is like watching Mozart play the piano." I also love to teach.
Thu, Feb 9th, 2012
6:30 pm – 8:00 pm EST