1
,1 Wat te verwachten?...........................................................................6
1.1 Wel..........................................................................................................6
1.2 Misschien...............................................................................................6
1.3 Niet.........................................................................................................6
2 Tips.....................................................................................................6
3 Examen afleggen...............................................................................6
3.1 Voor examen.........................................................................................6
3.1.1 Op PC.........................................................................................................6
3.2 Tijdens examen.....................................................................................7
4 Basisfuncties.....................................................................................8
4.1 Vermenigvuldigen.................................................................................8
4.2 Delen......................................................................................................8
4.3 Macht......................................................................................................8
4.4 Tegengestelde.......................................................................................8
4.5 Groter dan..............................................................................................8
4.6 Verschillend van...................................................................................8
4.7 Totaal.....................................................................................................8
4.8 Gemiddelde...........................................................................................8
4.9 Kleinste getal.........................................................................................8
4.10 Grootste getal......................................................................................8
4.11 Aantal...................................................................................................8
4.12 Verschil................................................................................................9
5 Formules............................................................................................9
5.1 Evolutie / Verschil in procent..............................................................9
5.2 % van totaal...........................................................................................9
6 Groeperen..........................................................................................9
6.1 Werkbladen............................................................................................9
2
, 6.2 Cellen...................................................................................................10
7 Flash Fill...........................................................................................10
8 Meer functies....................................................................................10
1 Grafiek..............................................................................................11
1.1 Kolommen stapelen............................................................................11
1.2 Gegevens in grafiek toevoegen / Wegnemen..................................11
1.3 Leeftijd.................................................................................................11
1.4 Thema..................................................................................................11
2 Leeftijd..............................................................................................11
3 Count functie....................................................................................12
3.1 Aantal getallen....................................................................................12
3.2 Aantal cellen (Telt alle cellen, ook zonder cijfers in).......................12
3.3 Aantal met voorwaarde......................................................................12
4 If functie............................................................................................12
4.1 Aantal geven met voorwaarde...........................................................12
4.2 Optellen met voorwaarde...................................................................12
4.3 Gemiddelde geven met voorwaarde.................................................13
5 Speciale opmaak..............................................................................13
5.1 Euroteken............................................................................................13
5.2 Woord toevoegen................................................................................13
6 Sorteren............................................................................................14
7 Conditional formatting....................................................................14
7.1 Highlight cells rules............................................................................14
7.2 Top / Bottom rules..............................................................................14
7.3 Data bars / Color scales / Icon sets..................................................14
7.4 Clear rules...........................................................................................14
3
, 7.5 Manage rules.......................................................................................15
7.6 New rule...............................................................................................15
7.6.1 Voorbeeld met formule...........................................................................16
1 Kolombreedte...................................................................................17
2 Rijen vastzetten...............................................................................17
3 Kopiëren (en bronvermelding behouden).....................................17
4 Mediaan functie................................................................................18
5 Vastzetten (dollar teken).................................................................18
1 Concatenate functie........................................................................19
2 Upper (= Hoofdletters) functie........................................................19
2.1 Upper functie in concatenate functie................................................19
3 Left / Right functie...........................................................................20
4 Sumif functie in grote bestanden...................................................20
5 Zoekfunctie.......................................................................................21
5.1 LOOKUP...............................................................................................21
5.2 VLOOKUP functie...............................................................................21
5.3 HLOOKUP functie...............................................................................22
6 IFNA functie......................................................................................22
7 Datums.............................................................................................23
7.1 Data......................................................................................................23
7.2 Today...................................................................................................23
7.2.1 Week verder.............................................................................................23
8 Meerdere functies............................................................................24
8.1 If functie...............................................................................................24
8.2 If functie in if functie...........................................................................25
9 RANK.EQ functie.............................................................................26
4
,1 Wat te verwachten?...........................................................................6
1.1 Wel..........................................................................................................6
1.2 Misschien...............................................................................................6
1.3 Niet.........................................................................................................6
2 Tips.....................................................................................................6
3 Examen afleggen...............................................................................6
3.1 Voor examen.........................................................................................6
3.1.1 Op PC.........................................................................................................6
3.2 Tijdens examen.....................................................................................7
4 Basisfuncties.....................................................................................8
4.1 Vermenigvuldigen.................................................................................8
4.2 Delen......................................................................................................8
4.3 Macht......................................................................................................8
4.4 Tegengestelde.......................................................................................8
4.5 Groter dan..............................................................................................8
4.6 Verschillend van...................................................................................8
4.7 Totaal.....................................................................................................8
4.8 Gemiddelde...........................................................................................8
4.9 Kleinste getal.........................................................................................8
4.10 Grootste getal......................................................................................8
4.11 Aantal...................................................................................................8
4.12 Verschil................................................................................................9
5 Formules............................................................................................9
5.1 Evolutie / Verschil in procent..............................................................9
5.2 % van totaal...........................................................................................9
6 Groeperen..........................................................................................9
6.1 Werkbladen............................................................................................9
2
, 6.2 Cellen...................................................................................................10
7 Flash Fill...........................................................................................10
8 Meer functies....................................................................................10
1 Grafiek..............................................................................................11
1.1 Kolommen stapelen............................................................................11
1.2 Gegevens in grafiek toevoegen / Wegnemen..................................11
1.3 Leeftijd.................................................................................................11
1.4 Thema..................................................................................................11
2 Leeftijd..............................................................................................11
3 Count functie....................................................................................12
3.1 Aantal getallen....................................................................................12
3.2 Aantal cellen (Telt alle cellen, ook zonder cijfers in).......................12
3.3 Aantal met voorwaarde......................................................................12
4 If functie............................................................................................12
4.1 Aantal geven met voorwaarde...........................................................12
4.2 Optellen met voorwaarde...................................................................12
4.3 Gemiddelde geven met voorwaarde.................................................13
5 Speciale opmaak..............................................................................13
5.1 Euroteken............................................................................................13
5.2 Woord toevoegen................................................................................13
6 Sorteren............................................................................................14
7 Conditional formatting....................................................................14
7.1 Highlight cells rules............................................................................14
7.2 Top / Bottom rules..............................................................................14
7.3 Data bars / Color scales / Icon sets..................................................14
7.4 Clear rules...........................................................................................14
3
, 7.5 Manage rules.......................................................................................15
7.6 New rule...............................................................................................15
7.6.1 Voorbeeld met formule...........................................................................16
1 Kolombreedte...................................................................................17
2 Rijen vastzetten...............................................................................17
3 Kopiëren (en bronvermelding behouden).....................................17
4 Mediaan functie................................................................................18
5 Vastzetten (dollar teken).................................................................18
1 Concatenate functie........................................................................19
2 Upper (= Hoofdletters) functie........................................................19
2.1 Upper functie in concatenate functie................................................19
3 Left / Right functie...........................................................................20
4 Sumif functie in grote bestanden...................................................20
5 Zoekfunctie.......................................................................................21
5.1 LOOKUP...............................................................................................21
5.2 VLOOKUP functie...............................................................................21
5.3 HLOOKUP functie...............................................................................22
6 IFNA functie......................................................................................22
7 Datums.............................................................................................23
7.1 Data......................................................................................................23
7.2 Today...................................................................................................23
7.2.1 Week verder.............................................................................................23
8 Meerdere functies............................................................................24
8.1 If functie...............................................................................................24
8.2 If functie in if functie...........................................................................25
9 RANK.EQ functie.............................................................................26
4
