Level 3 – Analyze

Text & Date formulas – Basic    
Calucate with dates    Working with text – 2
Working with time

Remove Duplicates
Data Validation
Sumifs with 2 criteria (absolute)
Simple management report

VLOOKUP
HLOOKUP
Remove Gridlines
Protecting
Save as .pdf
Invoice automation ( no dropdown but entry 1000-5000)

Pivot Tables vs Sumifs

Conditional Formatting

Freeze Panes

Logical Formulas II (AND/OR)

General
Nesting
Entering a formula in a formula

Logical Formula – Basic  
NESTEN (OR binnen IF etc.)
Grouping in pivot tables

Report building Essentials  
Automated Charts
Sparklines

Go back to overview