Page 1183 - Get_Training_Catalogo_presencial_2026

OFFICE PACK XXI - ADVANCED
(WORD+EXCEL INTERMEDIATE+EXCEL ADVANCED) 16.01 | Microsoft Office

16.01 | Microsoft Office
Requirements
Knowledge on Base Word and Excel

Microsoft Word is a text processing program, designed to assist the user to create attractive and professional-quality documents such as
letters and reports, allows you to include graphics, pictures, flowcharts and tables with ease. 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
MICROSOFT WORD MICROSOFT EXCEL INTERMEDIATE
This training course will give trainees advanced knowledge Module 1 - Advanced Editor Module 1 - Development and Maps
in Word and Excel which will allow them to design complex - Font Formatting formatting
documents.
- Paragraph Formatting - Map Development Miscellaneous
- Definition and use Styles - Cell Formatting
ADDRESSEES - Working with Templates - Sort and Filter Data
- Maps Formatting
This training course addresses everyone who, despite Module 2 - Inserting and - Conditional Formatting
already know some characteristics of Word and Excel, want Formatting Objects
to deepen their potentialities in this field.
- Insert and Custom Cover Page Module 2 - Creating formulas
- Insert and Format Tables - Using Arithmetic Operators
AVAILABLE IN THE FOLLOWING VERSIONS - Insert and Format Images - Formula Creation
- Insert and Format Forms - Absolute References and
- 2010 - Insert and Format SmartArt Composite
- 2013
- 2016 - Insert and Format Graphics
- Links and Bookmarks Module 3 - Using Functions
- Insert and Format Header and - Date and Time Functions
Footer - Mathematical Functions and
Statistics
Module 3 - Format Documents - Search and Text Function
- Configuration Pages - Function Logic
- Page Size
- Adjust Text Columns Module 4 - the Graphics Study
- breaks Page and Section - Charting for Data Analysis
- Watermark - Graphics Configuration
INFORMATION - Page Limits - Use of Different Types of Graphics
Hours: 60h
Time: See Training Plan Module 4 - Print and protect Module 5 - Page Layout
Material Delivered: Training Support Material documents - Margins
Training: Attendance Required - Preview a Document - Page Orientation
Regime: Working Hours / Post-Working Hours - Print Settings - Page Breaks
- Protect a Document with - Configuration and Document
Passwords Printing
Module 5 - References and Indices Module 6 - Data Validation
METHODOLOGIES - Insert and Update Indexes - Validate Data Entry

Methodologies used by the trainer will be - Insert Footnotes MICROSOFT EXCEL ADVANCED
- Insert Caption
expository, demonstrative and/or active, favouring Module 1 - Advanced Formatting
the latter whenever possible. Module 6 - Mailings - Formatting Cells
- Create Envelopes - Styles Formatting
- Merge - Conditional Formatting
- Preview and Results Print

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 83