Programme Excel 2013 advanced

In this very practice-oriented training, you will be given custom instruction that is tailored to your regular tasks and your present use of and experience with one of more of these programs. You are free to enrol in the whole training or a training day of your choice.

Day 1

Morning 9:30 a.m. – 12:30 p.m.

Functions and formulas

  • AutoSum
  • Frequently used functions: VLOOKUP, COUNT.IF, SUM.IF
  • Text functions: LEFT, RIGHT, PART, FIND
  • Logical functions: AND, OR and IF
  • Financial functions: PMT, PV and FV
  • Nested functions

Afternoon 1:30 p.m. – 4:30 p.m.

Pivot tables and charts

  • Subtotals
  • Pivot table and report
  • Slicers
  • Pivot table chart

Day 2

Morning 9:30 a.m. – 12:30 p.m.

Databases

  • Working with tables
  • Subtotals
  • Advanced filter
  • Database functions: DBSUM, DBMAX, DBAVERAGE, DBMAX and DBMIN
  • Adding a dropdown box

Afternoon 1:30 p.m. – 4:30 p.m.

Macros

  • Automating functions
  • Relative and absolute references
  • Personal Macro Workbook
  • Adding buttons to worksheets and ribbons
  • Editing macros
  • VBA Editor
  • Creating functions yourself

Competencies

Realisation and Evaluation: planning and organising, accuracy, progress monitoring

Personal Effectiveness: resistance to stress

Instructor

The training will be given by Roy Nieuwenhuizen of Learnit. 

Target group

This hands-on training is intended for everyone who wishes to learn more about the possibilities offered by Excel in the areas set out above.

Course material

You will be provided with a course book if you decide to participate the whole course. If you attend 1 day, you will be working with a hand-out.

Certificate

After completing the training course, you will receive a certificate of participation.