New
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
7 Dec 2020 - 13:00 to 16:00

Confirmed

Virtual Class
12 Jan 2021 - 9:00 to 12:00

Virtual Class
19 Feb 2021 - 9:00 to 12:00

Virtual Class
24 Mar 2021 - 13:00 to 16:00

Virtual Class
26 Apr 2021 - 9:00 to 12:00

Virtual Class
1 Jun 2021 - 13:00 to 16:00

Virtual Class
6 Jul 2021 - 9:00 to 12:00

Virtual Class
11 Aug 2021 - 13:00 to 16:00

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