PCT 02 – Excel: Intermediate

Course Presenter: K-H. Schulte/J. Robberts/P. Van Schalkwyk

Duration: 3 hours

Maximum Attendees: 30

Course Level: Beginner/Intermediate

Costs: (FCS Clients, NIPA, ICAN) N$ 1,765.00

Costs: (all others) N$ 2,355.00

Aimed at:  Trainees; Excel users.

This presentation is aimed at Excel users with a sound basic knowledge of Excel:

  1. Using Pivot tables / ordinary tables and grouping data;
  2. Lookup functionalities & range names;
  3. Graphs;
  4. Data sorting, filtering, validations;
  5. Formulas – selection of formulas used commonly by accountants;
  6. Protecting sheets and workbooks, tracking changes.