
Excellence With Excel
HDRips | MP4/AVC, ~291 kb/s | 1024x768 | Duration: 7.5 hours | English: AAC, 52 kb/s (2 ch) | 968 MB
Genre: Economics and finances
Excellence With Excel teaches you everything you need to know about Excel for investment banking and private equity, from navigation basics and formatting all the way up to formulas, macros, and advanced topics like pivot tables.
These lessons are based on two real-life case studies: how to format, manipulate, and analyze customer due diligence data, and how to build and format a 3-statement model and valuation of Wal-Mart.
In addition, each video is captioned with the shortcut keys we use throughout so that you can easily follow along and learn by watching and by doing.
- Lessons cover navigation, manipulating data and worksheets, formatting, formulas, and advanced topics like lookup functions, pivot tables, VBA, macros, and custom shortcuts.
- Introductory Excel Lessons include how to set up Excel properly, navigation, data manipulation, formatting, printing, and key formulas used in finance.
- Advanced Excel Lessons teach you lookup, array, and database functions, scenarios, iterations and circular references, error handling, graphs and charts, and introduce you to VBA, macros, form controls, custom shortcuts, and user-defined functions.
- 63 videos total (23 hours of footage).
- Time-Saving Excel Shortcuts: includes 7 quick reference guides for Excel 2003, Excel 2007 / 2010 / 2013, and Mac Excel 2008 / 2011 shortcuts.
- Test your knowledge of Excel and how to use it in finance with 146+ in-video quiz questions that you can take as you complete the lessons.
- 31 lessons on Excel setup, data manipulation, and formatting: includes everything from inserting, editing, and deleting cells, rows, and columns to color coding financial models, using the Ctrl + 1 and Alt + H shortcuts, grouping, hiding, and printing, and cleaning up data with text, date, and other functions.
- 17 lessons on functions and formulas, including built-in functions, key built-in math, logical, lookup, and financial functions, database functions and pivot tables, array functions, scenarios, comments and formula auditing, circular references, and more advanced functions such as Indirect and Address.
- 6 lessons on VBA and macros, including how to record and edit macros, use VBA for loops and conditionals, write user-defined functions, use form controls for dynamic charts, and create custom keyboard shortcuts.
Buy Premium Account To Get Resumable Support & Max Speed
rapidgator_net:
http://rapidgator.net/file/083a6a3047f3cc79eca450bb4bd9a1b7/uyf2t.Excellence.With.Excel.part1.rar.html
http://rapidgator.net/file/01d680478d3a64716841b8f4d37d8aae/uyf2t.Excellence.With.Excel.part2.rar.html
http://rapidgator.net/file/665259545891d6d10083ce01582d2c80/uyf2t.Excellence.With.Excel.part3.rar.html
http://rapidgator.net/file/d724fc3f00ab5fd0b9b81077647676ba/uyf2t.Excellence.With.Excel.part4.rar.html
nitroflare_com:
http://nitroflare.com/view/F33CC2B734A0216/uyf2t.Excellence.With.Excel.part1.rar
http://nitroflare.com/view/C145284E92529A3/uyf2t.Excellence.With.Excel.part2.rar
http://nitroflare.com/view/494F8EF7FFF9E02/uyf2t.Excellence.With.Excel.part3.rar
http://nitroflare.com/view/9DE0C2981B2AAEC/uyf2t.Excellence.With.Excel.part4.rar
uploaded_net:
http://uploaded.net/file/ysss7wtl/uyf2t.Excellence.With.Excel.part1.rar
http://uploaded.net/file/7lldiky2/uyf2t.Excellence.With.Excel.part2.rar
http://uploaded.net/file/mqnz4xs5/uyf2t.Excellence.With.Excel.part3.rar
http://uploaded.net/file/e8zjauwa/uyf2t.Excellence.With.Excel.part4.rar
http://rapidgator.net/file/083a6a3047f3cc79eca450bb4bd9a1b7/uyf2t.Excellence.With.Excel.part1.rar.html
http://rapidgator.net/file/01d680478d3a64716841b8f4d37d8aae/uyf2t.Excellence.With.Excel.part2.rar.html
http://rapidgator.net/file/665259545891d6d10083ce01582d2c80/uyf2t.Excellence.With.Excel.part3.rar.html
http://rapidgator.net/file/d724fc3f00ab5fd0b9b81077647676ba/uyf2t.Excellence.With.Excel.part4.rar.html
nitroflare_com:
http://nitroflare.com/view/F33CC2B734A0216/uyf2t.Excellence.With.Excel.part1.rar
http://nitroflare.com/view/C145284E92529A3/uyf2t.Excellence.With.Excel.part2.rar
http://nitroflare.com/view/494F8EF7FFF9E02/uyf2t.Excellence.With.Excel.part3.rar
http://nitroflare.com/view/9DE0C2981B2AAEC/uyf2t.Excellence.With.Excel.part4.rar
uploaded_net:
http://uploaded.net/file/ysss7wtl/uyf2t.Excellence.With.Excel.part1.rar
http://uploaded.net/file/7lldiky2/uyf2t.Excellence.With.Excel.part2.rar
http://uploaded.net/file/mqnz4xs5/uyf2t.Excellence.With.Excel.part3.rar
http://uploaded.net/file/e8zjauwa/uyf2t.Excellence.With.Excel.part4.rar
Links are Interchangeable - No Password
We need your support!
Make a donation to help us stay online
Bitcoin (BTC)
bc1q08g9d22cxkawsjlf8etuek2pc9n2a3hs4cdrld
Bitcoin Cash (BCH)
qqvwexzhvgauxq2apgc4j0ewvcak6hh6lsnzmvtkem
Ethereum (ETH)
0xb55513D2c91A6e3c497621644ec99e206CDaf239
Litecoin (LTC)
ltc1qt6g2trfv9tjs4qj68sqc4uf0ukvc9jpnsyt59u
USDT (ERC20)
0xb55513D2c91A6e3c497621644ec99e206CDaf239
USDT (TRC20)
TYdPNrz7v1P9riWBWZ317oBgJueheGjATm