Page 1179 - Get_Training_Catalogo_presencial_2026

OFFICE PACK IX - ADVANCED
(WORD + EXCEL + POWERPOINT) 16.01 | Microsoft Office

16.01 | Microsoft Office
Requirements
Knowledge on Base Word Excel and PowerPoint

Nowadays, computers are an essential work tool in most professional activities. With this reality in mind, Get Training developed Office
Pack Advanced training course so that, in a comfortable, practical and effective way, you may be acquainted with the most commonly used
computer software: text processor (Word), spreadsheet (Excel) and presentation manager (PowerPoint).

CONTENTS
OBJECTIVES
WORD Module 8 - Using Functions
This course aims to provide trainees knowledge on Word, - Date and Time Functions
Excel and PowerPoint. Module 1 - Advanced Editor - Mathematical Functions
- Font Formatting - Information Functions
ADDRESSEES - Paragraph Formatting - Text Functions
- Definition and use Styles - Statistical Functions
This training course addresses everyone who wants to be - Working with Templates - Search Function
acquainted with computers. - Logic Functions
Module 2 - Inserting and Formatting
AVAILABLE IN THE FOLLOWING VERSIONS Objects Module 9 - the Graphics Study
- Insert and Custom Cover Page - Creation and Graphics Manipulation
- 2007 - Insert and Format Tables - Configuration Various Types of
- 2010 - Insert and Format Images Graphics
- 2013 - Insert and Format Forms - Sparklines
- 2016 - Insert and Format SmartArt
- Insert and Format Graphics Module 10 - Creation and Audit
- Links and Bookmarks Formulas
- Insert and Format Header and Footer - Advanced Formula Creation
- Audit Formulas
Module 3 - Format documents
- Configuration Pages Module 11 - Configuring and Printing
- Page Size - Margins
- Adjust Text Columns - Page Orientation
- breaks Page and Section - Page Breaks
- Watermark - Printing Titles
INFORMATION - Page Limits - Page Setup

Hours: 54h Module 4 - Print and protect Module 12 - Sorting and Data Filter
Time: See Training Plan documents - Sort Ascending and Descending
Material Delivered: Training Support Material - Preview a Document Data
Training: Attendance Required - Print Settings - Selection Filters and Advanced
Regime: Working Hours / Post-Working Hours - Protect a Document with Passwords
Module 13 - Sheets and Book
Module 5 - References and Indices Protection
- Insert and Update Indexes - Protect and Unprotect Sheets
- Insert Footnotes - Zones Selection
METHODOLOGIES - Insert Caption
- Protecting the Book with Password
Methodologies used by the trainer will be Module 6 - Mailings
expository, demonstrative and/or active, favouring - Create Envelopes Module 14 - Data Consolidation
- Consolidation by Position
the latter whenever possible. - Merge - Consolidation by Category
- Preview and Results Print
Module 15 - Data Validation
EXCEL - Data Entry Validation

Module 7 - Advanced Formatting Module 16 - Charts and PivotTables
- Formatting Cells - Dynamic Table Creation
- Styles Formatting - Filters in PivotTables
- Conditional Formatting - Dynamic Charting

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 79