Excel for Finance
-
Level: Beginner
-
Duration: 8 hours
-
Access: 1 Year
Course Outline
What You Will Learn
Topics List
- Topic 1: Menus & Shortcut Basics
- Topic 2: Basic Operators
- Topic 3: Mathematical Operations
- Topic 4: Formulas & Calculation Functions (Part 1)
- Topic 5: Formulas & Calculation Functions (Part 2)
- Topic 6: Naming & Referencing Cells
- Topic 7: Editing Cell Names
- Topic 8: Formatting Basics
- Topic 9: Date Functions
- Topic 10: Pivot Tables
- Topic 11: Lookup Functions
- Topic 12: Conditional Statements
- Topic 13: Conditional Formatting
- Topic 14: Data Validation
- Topic 15: Data Tables
- Topic 16: Combo Box Control for Dashboards
- Topic 17: Goal Seek & Scenario Manager
- Topic 18: Solver
- Topic 19: Common Errors

Gain Industry Knowledge and a Certification
regular review questions.