Excel 2013 Advanced

MS Excel requires a specific way of thinking. Do you work with Excel on a regular basis? And do you feel like you’re not taking advantage of all the options it offers? In this training, you will be using your own Excel file to learn more about your selected program features.  After completing the training, you will have:

  • Expanded your knowledge of Excel;
  • Have a good command of the specific program features that you require in the course of your work, without wasting time on features that you already know how to use or do not need.

Practical information

Dates:7 & 14 May 2018
Times:9.45 - 16.30
Duration::2 days or 1 day of your choice
Location:EUR Woudestein
Costs:€ 350 for the entire 2-day training or € 200 per day.
  • 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.

      • 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
      • 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
    • Realisation and Evaluation: planning and organising, accuracy, progress monitoring

      Personal Effectiveness: resistance to stress

    • The training will be given by Roy Nieuwenhuizen of Learnit. 

    • 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.

    • 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.

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