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.