Excel for Accounting, Modeling, and Valuation
Excel taught by experts in accounting, finance, and modeling
Our Excel training is is tightly integrated with the needs of professionals in accounting, finance, and modeling because it is taught by experts in these areas. All examples used are directly applicable to everyday advanced tasks in these areas.
- Data validation
- Custom formatting
- Functions used build flexible models for different scenarios: IF, Offset, Indirect, Index, Match, Choose, VLookup, HLookup
- Data tables
- Sumproduct
- Arrays
- Visual Basic for Applications
- Excel Add-Ins and Interface Customization
- Iterations
- Form controls and ActiveX controls: Spinners and List boxes
- Financial functions: XIRR, XNPV