Page 1111 - Get_Training_Catalogo_presencial_2026

MICROSOFT EXCEL (FINANCEIRO) WORKSHOP EXCEL (FINANCIAL) 16.01 | Microsoft Office
16.01 | Microsoft Office
Requirements
Knowledge on Base Excel

Excel is the spreadsheet more used worldwide. With Microsoft Excel to create tables from the simplest to the most complex documents,
graphics and involving numerous types of formulas and functions.
Excel allows you to create and format data in order to improve the analysis and thus allow an improvement in decision-making in financial
terms.

CONTENTS
OBJECTIVES
Module 1 - Development and Maps Formatting
This course aims to provide students knowledge of Excel - Domestic Budget
potential as an essential support tool in the financial - Protect / Unprotect Sheet
management tasks, making the most of this powerful - Amounts Sold by Quadrimester
application.
- Maps Formatting and Conditional Formatting
- Custom Formatting Cells
ADDRESSEES
Module 2 - Using Functions
Financial professionals; commercial and administrative; - Statistical Functions
economists; managers; accountants; financial auditors;
chartered accountants and students. - Mathematical Functions
Excel is one of the most used apps on business and so it is - Financial Functions
important for all professionals with an interest in finance. - IF Function Logic
- Function VLOOKUP
AVAILABLE IN THE FOLLOWING VERSIONS Module 3 - Calculations with Financial Data
- 2007 - Table Creation with Financial Calculations
- 2010 - Percentage Calculations
- 2013 - Financial Management Exercise
- 2016 - Calculations Coordinates Fixed
- Exercise Connection to Multiple Sheets
- Freeze Panes
- Subtotal of Use
Module 4 - Graphics
- Charting for Data Analysis
INFORMATION - Graphics Configuration
Hours: 20h
Time: See Training Plan Module 5 - Use of Models Available
Material Delivered: Training Support Material - Use of Financial Models Office
Training: Attendance Required - Change Models
Regime: Working Hours / Post-Working Hours

METHODOLOGIES

Methodologies used by the trainer will be
expository, demonstrative and/or active, favouring
the latter whenever possible.

ANGOLA +244 225 400 399 | www.get-ao.com ∙ PORTUGAL +351 244 820 630 | www.get-pt.pt ∙ MOÇAMBIQUE +258 857 367 374 | www.get-mz.com 11