Skip to ContentSkip to Navigation
Corporate AcademyPart of University of Groningen

Corporate Academy

Corporate Academy

Excel 2016 advanced

CIT

Duration: 5 half days
Audience: PC users who master the basics of Excel and and wish to set up advanced models.

Course fee

Enrollment
Students and PhD students: € 50
Staff
UG, UMCG, Hanze: € 225
External: € 525

Course dates and enrollment

Contact: CIT secretariat (050 - 36 39200)

Course fee includes CIT-course documentation.

Global content

The course will include the following topics:

  • How to make large models easy to handle
  • Working with advanced formulas and functions
  • Working with databases
  • Summarizing data with pivot tables
  • Detecting and preventing errors
  • Automate operations by means of simple (recorded) macros

Table of contents

Excel Advanced

Course format

Presentation of theory, demonstrations, self study and hands-on practice.

Aim

Increasing the understanding of Excel, so that problems can be solved more efficiently and professional models can be created.

Prerequisites

Extensive experience with the basic functions of Excel, including the making of (simple) calculations. Furthermore is some experience with setting up models in Excel, a prerequisite for the highest possible efficiency.

Last modified:26 August 2019 12.23 p.m.
printView this page in: Nederlands