Overview of our Academic Training Package
Excel Training Designed for Students
Complete Excel Ninja Skills: Excel Shortcuts Training & Excel Functions
Designed for professionals to be as proficient in excel as those in Finance without learning to financially modal
Includes: Complete Excel Ninja Guidebook, Skills Reinforcement Exercises, Exercise Answer Guide
Perfect for: Anyone that will ever use Excel(especially bankers, consultants, analysis)
Academic Training Package: The Complete Guide to Becoming an Excel Ninja
While financial modeling training gets the most attention in new hire analyst programs, the reality is that too many new hires emerge from training lacking the accounting, Excel and corporate finance skills required for effective performance on the desk. Our online Basic Skills program equips finance professionals with the foundational skill set that live training builds upon.
Trainees follow a curriculum, meet deadlines for completing assignments and are thoroughly tested via online assessments. Progress is shared with training managers in real time, and we bring struggling trainees up to speed with additional coursework, assessments and individualized action plans.
Please Enter the Following Information:
Note: The additional cost of $50 to include admin panel will be added directly to your cart.
Select Excel Ninja Topics Include:
SHORTCUTS/FUNCTIONALITY
- Navigation Ninja
- Copy & Paste
- Auto Fill
- Sheet Formatting
- Formatting/Customizing Rows & Columns
- Formatting/Customizing Worksheets
- Paste Special
- Font/Text Formatting
- Cell Comments
FORMULAS
- TEXT Formula
- YEAR, MONTH, DAY & DATE Formla
- Concatenation
- Mathematical Formulas
- SUBTOTAL Formulas
- SUMPRODUCT
- CEILING, FLOOR & ABS Formulas
Select Excel Ninja Topics Include:
SHORTCUTS/FUNCTIONALITY
- Conditional Formatting
- Page Setup
- Advanced Custom Formatting
- Filtering and Sorting
- Data Validation
- Goal Seek
- One & Two Dimensional Data Tables
- Pivot Tables
- VBA / Recording Macros
FORMULAS
- COUNT Formulas
- Present Value & Future Value
- NPV & IRR Formulas
- IF Formulas
- SUMIF & SUMIFS Formulas
- ISNUMBER, ISTEXT & IFERROR Formulas
- Scenario Formulas
- Lookup Formulas
Feel confident in your Excel skills for any interview
Wall Street Prep’s on-boarding training fills the knowledge gaps common of new hires who have never experienced life on the desk. Our experienced instructor-practitioners focus on the practical application of topics most trainees have only seen on an theoretical level. We work with all group sizes to deliver the “core analyst skill set” of financial and valuation modeling with a focus on Excel best practices and efficiency.

