Page 1109 - Get_Training_Catalogo_presencial_2026

MICROSOFT EXCEL (AVANÇADO) MICROSOFT EXCEL (ADVANCED) 16.01 | Microsoft Office
16.01 | Microsoft Office
Requirements
Knowledge on Base Excel

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

CONTENTS
OBJECTIVES
Module 1 - Advanced Formatting Module 6 - Sorting and Data Filter
This course aims to provide students with advanced - Formatting Cells - Sort Ascending and Descending
knowledge of Excel. At the end of the training, trainees will - Styles Formatting Data
be able to use in detail, the most advanced features that - Conditional Formatting - Selection Filters and Advanced
allow you to perform calculations more elaborate form,
taking full advantage of this powerful application.
Module 2 - Using Functions Module 7 - Sheets and Book
- Date and Time Functions Protection
ADDRESSEES - Mathematical Functions - Protect and Unprotect Sheets
- Information Functions - Zones Selection
Any user who needs to use a spreadsheet tool. Excel is
one of the most used applications in business and so it is - Text Functions - Protecting the Book with
important for all professionals in all areas who want to learn - Statistical Functions Password
to do complex calculations and professional and pleasant - Search Function
aspect. - Logic Functions Module 8 - Data Consolidation
- Consolidation by Position
Module 3 - the Graphics Study - Consolidation by Category
AVAILABLE IN THE FOLLOWING VERSIONS - Creation and Graphics
- 2007 Manipulation Module 9 - Data Validation
- 2010 - Configuration Various Types of - Data Entry Validation
- 2013 Graphics
- 2016 - Sparklines Module 10 - Charts and
PivotTables
Module 4 - Creation and Audit - Dynamic Table Creation
Formulas - Filters in PivotTables
- Advanced Formula Creation - Dynamic Charting
- Audit Formulas
INFORMATION Module 11 - Creating Macros and
Module 5 - Configuring and Assign Buttons to Macros
Hours: 20h
Time: See Training Plan Printing - Creating Macros
Material Delivered: Training Support Material - Margins - Customization Quick Access
Training: Attendance Required - Page Orientation Toolbar
Regime: Working Hours / Post-Working Hours - Page Breaks - Assign Buttons to Macros
- Printing Titles
- Page Setup

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 9