Course Code: 1338

Excel Formulas: Advanced

Class Dates:
5/19/2020
6/23/2020
Length:
1 Days
Cost:
$295.00
Class Time:
Technology:
Office
Delivery:

Overview

  • Course Overview
  • 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

  • Audience
  • This course is intended for experienced excel users with a basic understanding of functions and forumas

Prerequisites

Course Details