Excel - Spreadsheet: Advanced features

Go back

Excel - Spreadsheet: Advanced features

Initiative Description

The University of Beira Interior promotes training actions to address the needs of company employees, in order to achieve a level of excellence in the use of Microsoft Excel.


Training Objectives

Perform links between multiple spreadsheets. Perform data analysis. Automate actions through the use of macros.

Training Contents

Multiple sheets; Spreadsheets meeting; Link between sheets; Inserting subtotals; Highlights; Reports; Analysis of data in tables and lists; (Data creation, sorting and filtering; Forms); Creating and formatting a pivot table; Use of totals and subtotals; Pivot table formulas; Graphing; Predefined macros; Toolbar customization macros; Creating and recording a macro; Assigning a macro to a button; Running a macro.

Digital Innovation Hubs




  • Practical exercices
  • Practical session in lab


  • Face to face
  • Blended

Technology Absortion Cycle

  • Operation: supports knowing how to operate the technologies during daily operations.

Target Group

  • Directors
  • Plant Manager
  • Engineers
  • Operators
  • Other

Instruction Level

  • Intermediate


  • Computer - Software

Education Level

  • High School
  • Ocupational Studies
  • Bachelor


  • 10 to 20

Countries where training is provided

  • Portugal

Cities where training is provided

  • Covilhã

Languages this training can be provided

  • Portuguese