About This Class
Virtually everyone who works with data could benefit by gaining a better understanding of Microsoft Excel. This class will extend beyond the simple addition of data and will put students in a position where Excel is no longer a chore, but a powerful tool to assist in manipulating data efficiently. You'll learn various functions to help you organize and analyze data and go through situational overviews of time-saving shortcuts to improve your efficiency dramatically.
Prereqs & Preparation
Students should have a basic understanding of Excel and rudimentary functions (IF, SUMIF statements) as well as how to organize data into functional tables (i.e. how to create a data table in Excel with a simple understanding of sort and filter functionality).
Students should bring a laptop with Excel 2010 installed. PC-based laptops are preferable, though not required (certain shortcuts may not transfer directly into Excel for Mac).
Students should try to arrive a few minutes early to class, if possible.
Takeaways
-Learn how to easily manipulate datasets using pivot tables and other functions.
-Find out how to leverage the onboard statistical analysis tools to make effective conclusions on data.
-Master the art of shortcuts to streamline the process of analysis in Excel.
About the Instructor
Michael Ciolli
Principal,
Piton Advisors
Michael J. Ciolli is a Principal at Piton Advisors, a consultancy which provides strategic, financial, and corporate development advisory. Through Piton, Michael often serves as a virtual CFO for early stage companies and a coach for AMT, the leading training company to Wall Street. Prior to Piton, Michael was an M&A banker and equity research analyst covering the IT and business services industries. He received his MBA from Columbia Business School and a BA from Colgate University. He lives in NYC and enjoys skiing, fishing, and cooking.