Microsoft Excel 2013 Open License

A highly practical software that takes the mystery out of modeling by working a number of problems, each introduced in small chunks, and all using Excel's built in functionality. It covers most of the most important options you need for a proper usage. The "lots of small chapters" approach allows the user to learn both Excel and modeling capabilities in a relatively painless way. Multiple editions have stood the test of time, and I've found that other people independently have come to the conclusion that this is the right place to start on both using Excel more effectively and thinking about decisions from a modeling perspective.

I have used excel for very long time but this book just takes your excel skills to whole another level. The best thing about the book are the exercises. Each chapter has anywhere between 10 -20 exercises, and if you diligently do them, you can be pretty confident that you have a reasonable functional mastery of the subject. SOME EXAMPLES: Here are some examples of what you can accomplish with this book. Use it as a checklist to see if you will find the book helpful.

> Write A formula to calculate the distance between two cities
> You have a paid event with multiple fee levels and several expenses. How many people need to attend to break even ?
> Create a Pivot Table that gives average salary broken down by department?
> How are monthly stock returns of Microsoft , GE, and Cisco Related?

I've been learning Excel 2013 powerpivot for the last year. It's revolutionized the way the organization I work for does it's financial analysis and reporting. I've trained 30 of my staff on the basics of powerpivot. This book to me is the top resource for learning powerpivot and as a reference for both beginner and advanced users. I've bought almost every book there is on powerpivot and this is the best. The other books I've bought have been helpful and useful but this is the best.