Page 1151 - Get_Training_Catalogo_presencial_2026

PACK OFFICE XVIII - ADVANCED
(WORD + EXCEL + ACCESS) 16.01 | Microsoft Office

16.01 | Microsoft Office
Requirements
Knowledge on Base Word, Excel and Access

Nowadays, computers are an essential work tool in most professional activities. With this reality in mind, Gestinfor developed Office Pack
III 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 database (Access).

CONTENTS
OBJECTIVES
WORD Module 8 - Using Functions
To give trainees advanced knowledge on the use of Word, - Date and Time Functions
Excel and Access tools. Module 1 - Advanced Editor - Mathematical Functions
- Font Formatting - Information Functions
ADDRESSEES - Paragraph Formatting - Text Functions
- Definition and use Styles - Statistical Functions
Everyone who wants to have advanced knowledge on Word, - Working with Templates - Search Function
Excel and Access. - 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: 60h
Time: See Training Plan Module 4 - Print and protect Module 12 - Sorting and Data Filter
Material Delivered: Training Support Material documents - Sort Ascending and Descending
Training: Attendance Required - Preview a Document Data
Regime: Working Hours / Post-Working Hours - Print Settings - Selection Filters and Advanced
- Protect a Document with Passwords
Module 13 - Sheets and Book
Module 5 - References and Indices Protection
- Insert and Update Indexes - Protect and Unprotect Sheets
METHODOLOGIES - Insert Footnotes - Zones Selection

Methodologies used by the trainer will be - Insert Caption - Protecting the Book with Password
expository, demonstrative and/or active, favouring Module 6 - Mailings Module 14 - Data Consolidation
the latter whenever possible. - Create Envelopes - Consolidation by Position
- 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 51