» » » Excellence With Excel
uploaded.to



Information of news
2-02-2016, 02:59

Excellence With Excel

Category: Tutorials / Other

Excellence With Excel

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.

You’ll learn everything via practice exercises included in each lesson, as well as with in-video, interactive quizzes in the key lessons - and when it’s time to review, you’ll get full transcripts for all the lessons.

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.
- 9 lessons on charts and graphs: from simple line and column charts to combination charts to price-volume graphs, the “football field” valuation graph, graphing public comps, and waterfall bridge charts.
- 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.

rapidgator_net:
http://rapidgator.net/file/7673d0cf40bb599d2b0654bdbf71716b/go9ui.Excellence.With.Excel.part1.rar.html
http://rapidgator.net/file/2baa8a6a50b15d9fdca818a672411b4f/go9ui.Excellence.With.Excel.part2.rar.html
http://rapidgator.net/file/4a15bebe58ce083b26d3a4dc97d58ed0/go9ui.Excellence.With.Excel.part3.rar.html
http://rapidgator.net/file/b997bcd72681316d605bee288bf7faf2/go9ui.Excellence.With.Excel.part4.rar.html

secureupload_eu:
https://www.secureupload.eu/89qd4d5ayde6/go9ui.Excellence.With.Excel.part1.rar
https://www.secureupload.eu/dlg3y130wx9c/go9ui.Excellence.With.Excel.part2.rar
https://www.secureupload.eu/3yjqjj45f9sx/go9ui.Excellence.With.Excel.part3.rar
https://www.secureupload.eu/3l2qyolnlh9x/go9ui.Excellence.With.Excel.part4.rar

uploaded_net:
http://uploaded.net/file/hkvskid4/go9ui.Excellence.With.Excel.part1.rar
http://uploaded.net/file/7njs6kvc/go9ui.Excellence.With.Excel.part2.rar
http://uploaded.net/file/omnlki5y/go9ui.Excellence.With.Excel.part3.rar
http://uploaded.net/file/61ikkxb0/go9ui.Excellence.With.Excel.part4.rar

nitroflare_com:
http://nitroflare.com/view/B708F58399FAC83/go9ui.Excellence.With.Excel.part1.rar
http://nitroflare.com/view/3EAC0A279828207/go9ui.Excellence.With.Excel.part2.rar
http://nitroflare.com/view/671ACC30E0D4BF7/go9ui.Excellence.With.Excel.part3.rar
http://nitroflare.com/view/0C621172A760614/go9ui.Excellence.With.Excel.part4.rar

uploadrocket_net:
http://uploadrocket.net/uvlb5nelgrkz/go9ui.Excellence.With.Excel.part1.rar.html
http://uploadrocket.net/edhqry821qta/go9ui.Excellence.With.Excel.part2.rar.html
http://uploadrocket.net/bbo1ic0ix154/go9ui.Excellence.With.Excel.part3.rar.html
http://uploadrocket.net/w565bcs71161/go9ui.Excellence.With.Excel.part4.rar.html


uploaded


Rapidgator.net

Site BBcode/HTML Code:
Dear visitor, you went to the site as unregistered user.
We recommend you Sign up or Login to website under your name.
Information
Would you like to leave your comment? Please Login to your account to leave comments. Don't have an account? You can create a free account now.

Tag Cloud

archive of news

^
 
free html hit counter