MENY

Excel Expert course (in English)

This course is intended for those who want to produce more advanced spreadsheet models, and gain some understanding of the use of macro in complex models. The course is aimed at users who have worked extensively in Excel and who want a more in-depth understanding of the functionality in advanced topics.

Excel banner

Aim of course
Create sophisticated spreadsheet models and gain some understanding of the use of macros in complex models.

Prerequisites
In line with UiS-IKT’s advanced course or equivalent knowledge of the program.

Audience
The course is aimed at experienced users who want more in-depth of functionality in advanced topics.

Teaching methods
Classroom instruction with a maximum of 12 participants. One computer per participant.

Price
Kr. 6.900, -
Includes lunch and course documentation

Duration
2 days - from 09 am to 3 pm

Subjects

  • Naming of cells
  • Guidelines for names
  • Data Validation
  • Table Functionality Vs. OFFSET function
  • Use of form controls
  • Data exchange
  • Importing text files
  • Retrieving data from databases
  • Web queries
  • Pasting data from the web
  • Preparation of data
  • Removing initial information from column
  • Using the TEXT function
  • Pivot Tables
  • Charts
  • “What if” analysis
  • Data Tables
  • Use of scenarios
  • Using the Formula Auditing toolbar
  • Evaluate formulas
  • Macros
  • Recording macros
  • Editing Macros
  • User-Defined Functions
  • Matrix Functions
  • Array formulas

Please contact us by e-mail uis-ikt@uis.no or give us a call 51831073