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.


Details

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

PTCentroDiH

Technology

Technique

  • Practical exercices
  • Practical session in lab

Channel

  • 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

Sector

  • Computer - Software

Education Level

  • High School
  • Ocupational Studies
  • Bachelor

Capacity

  • 10 to 20

Countries where training is provided

  • Portugal

Cities where training is provided

  • Covilhã

Languages this training can be provided

  • Portuguese