EXCEL, Advanced functions | Virtual classroom

Course Overview

Exploring data analysis tools.

Prerequisites

Microsoft Excel Database and Pivot table

Syllabus

Functions and Data Analysis Tools:

  • Mastering the rules used for naming cells;
  • Creating formulas using functions;
  • Understanding Excel’s functions;
  • Using Search functions;
  • Using Logical functions;
  • Using Statistical and Mathematical functions;
  • Using Text functions;
  • Using Financial functions and the Goal Seek tool.

Exploring Data Analysis Tools:

  • Managing views;
  • Managing reports;
  • Managing scenarios.
Duration : 3 h
Regular Rate : 79.00 $
Note :
Upcoming Dates :
qty
Virtual Class
6 Jun 2022 - 9:00 to 12:00

Virtual Class
11 Jul 2022 - 13:00 to 16:00

Virtual Class
16 Sep 2022 - 9:00 to 12:00

Virtual Class
3 Nov 2022 - 9:00 to 12:00

Virtual Class
9 Dec 2022 - 13:00 to 16:00