Page 1187 - Get_Training_Catalogo_presencial_2026

PACK EXCEL
(BASE + ADVANCED + FINANCIAL) 16.01 | Microsoft Office

16.01 | Microsoft Office
Requirements
No Requirements

Excel allows to create and format data for a posterior analysis and, consequently, decision-making. Excel may be used to follow data, to
create data analysis models, to create formulas, to organise data and present them in several types of graphics.
Excel is an indispensable business tool in most occupations. Thinking about this reality, Get Training developed Excel course pack.

CONTENTS
OBJECTIVES
EXCEL (BASE) - Construction of Several Types of
This training course aims to give trainees knowledge on Graphics
base, advanced and financial Excel. Module 1 - Basic Concepts
- Graphic Representation of the Excel Module 7 - Configuring and Printing
ADDRESSEES Interface - Margins
- Start Microsoft Excel - Page Orientation
Every professionals and students and, in general, to - Spreadsheet Structure, Book and - Header and Footer
everyone who wants to acquire more knowledge on Excel. Cell - Preview Printing
- Handling and File View
AVAILABLE IN THE FOLLOWING VERSIONS Module 8 - Sorting and Filters
Module 2 - Cells and Sheets Handling - Data Ordering
- 2007 - Sheet Manipulation (Insert, Delete, - Custom Order
- 2010 Copy) - Text Filters Application and
- 2013 - Change of Name of the Sheets and Numerical Filters
- 2016
Separator Color - Subtotal of Use
- Hide and Show Rows, Columns and
Sheets EXCEL (ADVANCED)
- Cell Manipulation
- Navigation Between Sheets and Module 9 - Advanced Formatting
Books - Formatting Cells
- Styles Formatting
Module 3 - Cell Formatting - Conditional Formatting
- Introduction to Base tab
- Fonts Module 10 - Using Functions
- Text Alignment - Date and Time Functions
INFORMATION - Borders and Fill - Mathematical Functions
- Format Cells: Decimal Places, - Information Functions
Hours: 50h
Time: See Training Plan Percentages - Text Functions
Material Delivered: Training Support Material - Copy, Cut and Paste - Statistical Functions
Training: Attendance Required - Sequences - Search Function
Regime: Working Hours / Post-Working Hours - Format Styles - Logic Functions

Module 4 - Calculations Preparation Module 11 - the Graphics Study
- Building Formulas - Creation and Graphics Manipulation
- Addition - Configuration Various Types of
METHODOLOGIES - Subtraction Graphics

Methodologies used by the trainer will be - Multiplication - Sparklines
- Division
expository, demonstrative and/or active, favouring - Calculations of Several Leaves Module 12 - Creation and Audit
the latter whenever possible. Formulas
Module 5 - Using Functions - Advanced Formula Creation
- Sum - Audit Formulas
- Average
- Maximum Module 13 - Configuring and Printing
- Minimum - Margins
- Page Orientation
Module 6 - Illustrations and Graphics - Page Breaks
- Introduction to the Insert tab - Printing Titles
- Illustrations: Images, Shapes, - Page Setup
SmartArt

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 87