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.