Beyond basic Excel use, intermediate Excel introduces us to the world of complex formulas and equation solving. We will explore the top-rated functions that power users use to build financial models as well as automated tools. In this course, we will build a golf course reservation system using only formulas (no coding macros) as well and build a large statistical model for distribution of funds for a huge lottery payout.
The golf reservations system will show you real-world uses for all the formulas, interfaces, and lookups. You will learn shortcuts for developing models and systems and will get a deep understanding of how everything ties together into one system. For many users, the intermediate training is more like advanced, but I break the technology down into bite-sized pieces to make it easy to understand and utilize.
- This is the intermediate class for Microsoft Excel. Students need a copy of Excel 2010, 2013, or preferably 2016, or Office 365 subscription. Students should also understand references (relative and absolute) as well as using the Excel interface.