Interesting title huh? This is an article I found on Forbes and it does present a case for being very careful with Excel. Many, if not most, companies use Excel extensively, including Investment Banks. They also make mistakes. If they are copying/pasting data (they are) then it is very easy to make a mistake and the model will potentially help manager make faulty decisions that can lose millions maybe billions of dollars. Use VLOOKUP instead! 🙂
Uncategorized
Formula Tips and Tricks
Please go to the new and improved sign up page to get your follow along workbookshttp://markmoorebooks.com/book/mastering-excel-formula-tips-and-tricks/
Excel 3D Maze
Take a look at what amazing things can be done with VBA and Excel. There’s even a tutorial so you can see how it is done.
Preview: http://carywalkin.files.wordpress.com/2013/09/maze1.gif
Workbook: http://carywalkin.files.wordpress.com/2013/09/maze-example.xlsm
Tutorial: http://carywalkin.ca/tag/maze/
Tablas Dinamicas
Vaya a la página web nueva para obtener sus libros de trabajo.http://markmoorebooks.com/book/dominando-excel-tablas-dinamicas/
MS Query
Please go to the new and improved sign up page to get your follow along workbookshttp://markmoorebooks.com/book/mastering-excel-ms-query/
Using Excel to Win at Monopoly
Monopoly has a major element of chance in it, and the best part about games of chance is that people with Microsoft Excel can basically solve them.
Very nice write up.