Page 1107 - Get_Training_Catalogo_presencial_2026

MICROSOFT EXCEL (BASE) MICROSOFT EXCEL (BASE) 16.01 | Microsoft Office
16.01 | Microsoft Office
Requirements
No Requirements

Excel is the spreadsheet more used worldwide. With Microsoft Excel create tables from the simplest to the most complex documents,
graphics and involving numerous types of functions.
Excel lets you create and format the data for further analysis and thus allow the decision-making. Excel can be used to create data analysis
models, create formulas, using functions, organize the data and present them in various types of charts to facilitate understanding.

CONTENTS
OBJECTIVES
Module 1 - Basic Concepts Module 5 - Using Functions
This course aims to equip graduates initial knowledge of - Graphic Representation of the - Sum
Excel. At the end of the training, trainees will be able to Excel Interface - Average
handle documents in Excel, or in terms of formatting, create - Start Microsoft Excel - Maximum
formulas.
- Spreadsheet Structure, Book and - Minimum
Cell
ADDRESSEES - Handling and File View Module 6 - Illustrations and
Graphics
Any user who needs to use a spreadsheet tool, Excel is one Module 2 - Cells and Sheets - Introduction to the Insert tab
of the most used apps on business and so it is important for Handling
all professionals from all areas. - Illustrations: Images, Shapes,
- Sheet Manipulation (Insert, Delete, SmartArt
Copy) - Construction of Several Types of
AVAILABLE IN THE FOLLOWING VERSIONS - Change of Name of the Sheets Graphics
- 2007 and Separator Color
- 2010 - Hide and Show Rows, Columns Module 7 - Configuring and
- 2013 and Sheets Printing
- 2016 - Cell Manipulation - Margins
- Navigation Between Sheets and - Page Orientation
Books - Header and Footer
- Preview Printing
Module 3 - Cell Formatting
- Introduction to Base tab Module 8 - Sorting and Filters
- Fonts - Data Ordering
- Text Alignment - Custom Order
- Borders and Fill - Text Filters Application and
INFORMATION - Format Cells: Decimal Places, Numerical Filters
Hours: 20h Percentages - Subtotal of Use
Time: See Training Plan - Copy, Cut and Paste
Material Delivered: Training Support Material - Sequences
Training: Attendance Required - Format Styles
Regime: Working Hours / Post-Working Hours
Module 4 - Calculations
Preparation
- Building Formulas
- Addition
METHODOLOGIES - Subtraction

Methodologies used by the trainer will be - Multiplication
- Division
expository, demonstrative and/or active, favouring - Calculations of Several Sheets
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 7