Page 1113 - Get_Training_Catalogo_presencial_2026

MICROSOFT EXCEL (INTERMÉDIO) MICROSOFT EXCEL (INTERMEDIATE) 16.01 | Microsoft Office
16.01 | Microsoft Office
Requirements
Knowledge on Base Excel

Excel lets you create and format the data for further analysis and thus improve decision making. Excel allows you to use formulas and
functions, validate data entry, organize the data and present them in various types of charts to facilitate understanding.

CONTENTS
OBJECTIVES
Module 1 - Development and Maps formatting
This course aims to provide the trainees with intermediate - Map Development Miscellaneous
knowledge of Excel. At the end of the training, trainees will - Cell Formatting
be able to handle documents in Excel, format tables, create - Sort and Filter Data
formulas, using functions and create charts.
- Maps Formatting
- Conditional Formatting
ADDRESSEES
Module 2 - Creating formulas
Any user who needs to use a spreadsheet tool, and having - Using Arithmetic Operators
already knowledge base, intends to acquire intermediate
knowledge in this area. Excel is one of the most used apps - Formula Creation
on business and so it is important for all professionals from - Absolute References and Composite
all areas.
Module 3 - Using Functions
- Date and Time Functions
AVAILABLE IN THE FOLLOWING VERSIONS - Mathematical Functions and Statistics
- 2007 - Search and Text Function
- 2010 - Function Logic
- 2013
- 2016 Module 4 - the Graphics Study
- Charting for Data Analysis
- Graphics Configuration
- Use of Different Types of Graphics
Module 5 - Page Layout
- Margins
INFORMATION - Page Orientation
Hours: 20h - Page Breaks
Time: See Training Plan - Configuration and Document Printing
Material Delivered: Training Support Material
Training: Attendance Required Module 6 - Data Validation
Regime: Working Hours / Post-Working Hours - Validate Data Entry

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 13