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.

You’ll learn everything via practice exercises included in each lesson, as you manipulate and format customer due diligence data – as you would at a real investment bank.

In addition, each video is captioned with the shortcut keys we use throughout so that you can easily fall along and learn by watching and by doing.

Here’s the full run-down:

• Lessons cover navigation, manipulating data and worksheets, formatting, formulas, and advanced topics like lookup functions, pivot tables, macros, and custom shortcuts.
• 33 videos total (7.5 hours of footage).
• Both Excel 2003 and Excel 2007 / 2010 shortcuts are covered.
• 11 lessons on data manipulation: navigation; inserting, editing, and deleting cells, rows and columns; grouping; hiding; freezing and zooming; manipulating workbooks and worksheets; sorting data.
• 10 lessons on formatting: numbers, alignment, fonts, borders, fills, custom number formats, cleaning up data, conditional formatting, and printing.
• 12 lessons on formulas: built-in functions, circularity, auditing formulas, leaving comments, modeling scenarios, validating data, data tables, lookup functions, pivot tables, macros, and custom shortcuts.
• You receive instant access when you sign up because everything is delivered online – no shipping charges or physical products to worry about.
• Free lifetime updates and support.
• Sample Excel Video – Cleaning Up Data.
• Sample Excel Video – Custom Shortcuts.
• Full Course Outline & Offer.