• Logical functions such as IF, Nested IF, OR, AND, NOT, IFERROR, SUMSIF, AFERAGEIF, COUNTIF, SUMIFS, COUNTIFS, AVERAGEIFS, ROUND, PMT,
• Displaying, Hiding and Printing of Formulas
• Maths and statistical functions
• Financial functions
• Using Lookup Functions (Vlookup, Hlookup)
• Using MATCH and INDEX
• Creating Data tables
• Validating cell entries
• Exploring database functions
• Working with PivotTables
• Rarranging PivotTables
• Formatting PivotTables
• PivotCharts
• Exporting and importing text files
• Queries
• Goal Seek and Solver
• The Analysis ToolPak
• Scenarios
• Views
• Running and recording macros
• Intro to VBA
• Conditional Formatting with Graphics
• SmartArt Graphics

Vereistes: Excel 1-2.
Leerders moet vertroud wees met die vorige 2 vlakke van Excel.

Bring asb. afskrif van ID dokument en pen/potlood saam.