Page 1189 - Get_Training_Catalogo_presencial_2026

» »

Continuação / Continuation 16.01 | Microsoft Office
16.01 | Microsoft Office

Module 14 - Sorting and Data Filter Module 22 - Calculations with Financial Data
- Sort Ascending and Descending Data - Table Creation with Financial Calculations
- Selection Filters and Advanced - Percentage Calculations
- Financial Management Exercise
Module 15 - Sheets and Book Protection - Calculations Coordinates Fixed
- Protect and Unprotect Sheets - Exercise Connection to Multiple Sheets
- Zones Selection - Freeze Panes
- Protecting the Book with Password - Subtotal of Use
Module 16 - Data Consolidation Module 23 - Graphics
- Consolidation by Position - Charting for Data Analysis
- Consolidation by Category - Graphics Configuration

Module 17 - Data Validation Module 24 - Use of Models Available
- Data Entry Validation - Use of Financial Models Office
- Change Models
Module 18 - Charts and PivotTables
- Dynamic Table Creation
- Filters in PivotTables
- Dynamic Charting

Module 19 - Creating Macros and Assign Buttons to
Macros
- Creating Macros
- Customization Quick Access Toolbar
- Assign Buttons to Macros

EXCEL (FINANCIAL)

Module 20 - Development and Maps Formatting
- Domestic Budget
- Protect / Unprotect Sheet
- Amounts Sold by Quadrimester
- Maps Formatting and Conditional Formatting
- Custom Formatting Cells

Module 21 - Using Functions
- Statistical Functions
- Mathematical Functions
- Financial Functions
- IF Function Logic
- Function VLOOKUP

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 89