Analytical and Statistical methods

Guarantee: Ing. Hana Šrámková

Range: 0/2

Semester: winter

Source information: graduation subject Applied Information Technologies

End-subject: credit

---

Contents subject:

1. Sensitivity analysis
2. Sensitivity analysis
3. Mathematical and Statistic Functions
4. Database Function
5. Linking date
6. Pivot tables (create)
7. Pivot tables (actualization, format)
8. Pivot graph (create, format)
9. Macro – create
10. Macro – call
11. Assign a macro
12. Macro - modification
13. Create complex macro

Recommended literature:

Microsoft Office Excel 2003 Bible, John Walkenbach, Wiley 2003

Microsoft Office Word 2003 Bible, Brent Heslo, David Angell, Peter Kent, Wiley 2003