This 1-day course covers the advanced excel formulas, functions and types of financial analysis. This Advanced Excel training course builds on the knowledge that the user is already proficient and/or has taken the Excel Formulas Basic course and looking to take their skills to an advanced level. Course topics will include:
1) finding the perfect, most suitable function
2) methods of function entry
3) functions using relative, absolute, and named references
4) reusing functions (copy, autofill, drag and more!)
5) Functions by type
- Multiple and cross sheet functions
- Date functions
- Text(String) functions
- Logical functions
- Lookup functions
- Aggregate functions
- Rounding Functions
*Course cost listed does not include the cost of courseware. Please contact us at learn@vtec.org or 207-775-0244 for additional pricing information, or if you have any questions.
Course to run is subject to a minimum enrollment. Course may run as a virtual instructor led course if the minimum enrollment has not been met