Why take this course
  • Get proficient and efficient in Excel 2007 (even if you are already familiar with Excel 2003 or prior versions)
  • Essential "on-the-job" skill for either internships or full time positions
  • Enhances the learning experience in finance and financial statement analysis classes
  • Compatible with PC Excel 2007 / 2010 / 2013 / 2016

EXCEL BEST PRACTICES

Physical Book and Videos
DESCRIPTION

Want to be more proficient and efficient in Excel? By the end of this self-study course, you’ll be able to quickly and efficiently use keyboard shortcuts to navigate, format, and build formulas and projections in Excel. The skills and speed you’ll gain from this course will be valuable regardless of your prior Excel background or Excel skill level and whether you’re in finance, consulting, technology, or at any business. This course is the self-study version of one of our most popular live training programs at the top investment banks, consulting firms, and other Fortune 500 companies, as well as the top MBA programs and satisfies the Excel prerequisite for our other courses.

KEY FEATURES

  • Flip Chart book with shortcut keys and techniques
  • Excel drills and exercises
  • Over 4 hours of online video instruction
  • Estimated time to complete is 6 hours
  • 12 months free access to Online Companion
  • Compatible with PC Excel 2007 / 2010 / 2013 / 2016
  • Note: This course is not optimized for Mac Versions of Excel

TOPICS COVERED

  • Navigating in Excel
  • Optimizing your modeling environment
  • Modeling standards used by practitioners
  • Modeling and Excel efficiencies
  • Advanced modeling techniques
  • Data table analysis
  • Conditional formatting
  • TTS’ famous shortcut keys and function keys
  • TTS’ popular macro toolkit (TTS Turbo Macros)

PREREQUISITES

  • None, this course assumes no prior accounting knowledge

TESTIMONIALS

  • “TTS is the best on the Street. I've had training with them through a bulge bracket investment bank for summer internship and through business school classes. Their courses deliver a simple to follow natural progression. It’s all based on real world application and not just theoretical.”
  • “My first year of B School included a two day workshop where TTS came to campus and worked us through this entire course in person. The conceptual and technical information within this coursepack is great. I actually used them my first week of my MBA internship when valuing an acquisition target and presenting my valuation, along with a comps analysis, to senior management.”
  • “As someone who has passed all three CFA exams and worked in private equity, this course is a great tool in applying acquired knowledge.”
  • “Better than my MBA!”