Sumários

Analysis ToolPak

28 Novembro 2025, 11:00 Pedro Soares

Moving average, Correlation, Regression and sensivity analysis


Solver and pivot tables

24 Novembro 2025, 08:00 Pedro Soares

Solver: optimization problems.

Pivot tables: grouping items, frequency distribution.


Import data and Data Analysis

21 Novembro 2025, 11:00 Pedro Soares

Import data from csv. Statistical functions.
Descriptive statistics.


Graphical visualization of data

17 Novembro 2025, 08:30 Pedro Soares

Manipulating text. Logical formulas.
Conditional formatting.

Identifying errors.

Financial Functions: PMT, PV, FV.


Introduction to excel

14 Novembro 2025, 11:00 Pedro Soares

Cell References. Lookup & Reference Functions

Solve a System of Linear Equations.