Predict, analyze and protect data.

Create formulas and groupings in a PivotTable.

Create links between sheets, workbooks and files with or without a Link.

Expert

• Knowledge of the Windows environment.
• Having completed Microsoft Excel Advanced course or have equivalent knowledge.
• Having access to a computer and Microsoft Excel (2013, 2016 or OFFICE 365).

• Predict and analyze data.
• Create formulas and groupings in a PivotTable.
• Adequately protect data.
• Create links between sheets, workbooks and files with or without a Link.

CONSOLIDATION

• Consolidate by category

FORECAST

• Scenario analysis
• Target value
• Table
• Scenario Manager

CONDITIONAL FORMATTING

• With formulas
• Even and odd
• WEEKDAY

LINK

• To other sheets
• To other files
• Copy and paste to other files with LINK
• Watch Window

ADVANCED FORMULAS

• SI. ENS
• Date
• VLOOKUP, HLOOKUP (Value 1)

OUTLINE MODE

• Group
• Ungroup
• Select visible cells under formulas only, and others…

DATA PROTECTION

• Read-only
• Password on opening
• Protect formulas
• Allow range modification to certain users
• Protect the structure of a workbook

PIVOT TABLE

• Group by text
• Calculated field
• Calculated item