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 : 99.00 $
Preferential Rate : 84.15 $
Note :

Upcoming Dates

qty

Virtual Class

18 Mar 2024 - 13:00 to 16:00

Virtual Class

8 Apr 2024 - 13:00 to 16:00

Virtual Class

27 May 2024 - 13:00 to 16:00

Virtual Class

22 Jul 2024 - 13:00 to 16:00

Virtual Class

11 Sep 2024 - 9:00 to 12:00

Virtual Class

31 Oct 2024 - 9:00 to 12:00

Virtual Class

16 Dec 2024 - 9:00 to 12:00