Advanced Excel

•    Duration: 1 Month
•    Eligibility: Graduate/ Professional

Learn the most advanced formulas, functions and types of financial analysis to be an Excel power user. This advanced Excel training course builds on our free Excel Crash Course and is designed specifically for spreadsheet users who are already proficient and looking to take their skills to an advanced level. This advanced tutorial will help you become a world-class financial analyst for careers in investment banking, private equity, corporate development, equity research and FP&A. By watching the instructor build all the formulas and functions right on your screen, you can easily pause, rewatch, and repeat exercises until you've mastered them. The main formulas & functions covered in this training course include:

Syllabus:

• Overview of the Basics of Excel
• Working with Functions (AND, OR, NOT, VLOOKUP, HLOOKUP, MATCH, INDEX)
• Data Validations
• Working with Templates - standardization
• Sorting and Filtering Data (AutoFilter)
• Working with Reports - Pivot tables
• More Functions- Date and time, Text, Database, CountIf, CountIFS, SumIF, SumIfS
• Formatting
• Relative & Absolute Macros
• What If Analysis - Goal Seek, Data Tables, Scenario Manager
• Charts
• New Features Of Excel - Sparkline, Inline Charts, data Charts

Assignment:  Self-Assessment by Faculty

Exit Profile: Expert in Excel Application Software