Hafta | Teori Konu Başlıkları |
---|---|
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 |