Course Code: 1338

Excel Formulas: Advanced

Class Dates:
1/16/2019
12/3/2018
2/8/2019
3/11/2019
Length:
1 Days
Cost:
$295.00
Class Time:
Technology:
Office
Delivery:

Overview

  • Course Overview
  • This course covers the advanced excel formulas and 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
    - Logicalfunctions
    - 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