Description

Theory
2

Laboratory
2

Instructors

Carlos Vaz de Carvalho

Contents

1 - Excel spreadsheet (50%)
1.1-Basic concepts, conditional and automatic formatting
1.2-Functions and formulas
1.3-Order functions, filters, series, graphics
1.4-Search and reference functions
1.5-Data validation, pivot Tables, array formulas
1.6-Introduction to macros and VBA

2 - Introduction to Programming in VBA (50%)
2.1-The IDE "Excel/VBA": objects, I/O operations, basic visual interface
2.2-Analysis and program development: data structure, algorithm, program and test
2.3-Structure of a VBA program
2.3.1-Data Types and Variables
2.3.2-Operators and Expressions
2.3.3-Conditional and repetitive flow control structures
2.3.4-Functions and Subroutines
2.3.5-Indexed structures: arrays
 

Learning Outcomes

OB1: Organise, manipulate, and analyse data using spreadsheets.

OB2: Apply the main functionalities of Microsoft Excel, including formulas, functions, filters, charts, searches, pivot tables, validations, and arrays.

OB3: Automate spreadsheet tasks through the development and use of Excel macros.

OB4: Apply fundamental algorithmic concepts and principles to solve simple problems.

OB5: Design and implement VBA programs for data processing and task automation.

OB6: Interpret and use VBA instructions to extend the functionality of Microsoft Excel.

OB7: Exchange and manage data between Microsoft Excel and VBA applications.

OB8: Test, debug, and validate VBA programs by analysing expected and obtained results.