| 1 |
Introduction to data analysis with Excel 2013 |
| 2 |
IF statements and business applications |
| 3 |
Advanced IF, IF-AND, IF-OR, VLOOKUP and business applications |
| 4 |
Statistics and database functions and business applications |
| 5 |
Exam practice and case study |
| 6 |
Sensitivity Analysis with data tables, goal seek command and data tables, real word applications |
| 7 |
Matrix functions and business applications |
| 8 |
Financial functions & business applications I |
| 9 |
Financial functions & business Applications II |
| 10 |
Rounding functions and business applications |
| 11 |
Introduction to “Solver” applications |
| 12 |
“Solver” applications II |
| 13 |
Histograms and descriptive statistics |
| 14 |
Exam practice and case study |
