Advanced function in Microsoft Excel
| Code | Completion | Credits | Range | Language |
|---|---|---|---|---|
| 2366004 | Z | 2 | 0+2 | Czech |
- Lecturer:
- Jiří Čáp (gar.)
- Tutor:
- Jiří Čáp (gar.)
- Synopsis:
-
A practice in programming macros and using advanced function of Microsoft Excel software.
- Requirements:
-
An attendance on lessens, elaboration of final work.
- Syllabus of lectures:
- Syllabus of tutorials:
-
Advanced internal function of software (automatic solver, statistics function, data analysis). Using macros in program. Basic orientation in recorded code. Visual basic language overview, variables types, command, functions and procedures. Visual Basic integration in Excel, interface commands. Particular calculation tasks solving and data processing. Import data from external sources. Table and chart formatting from Visual Basic programming environment.
- Study Objective:
-
To learn students use larger potential of spread sheet.
- Study materials:
-
Documents for lessens, system software helps
- Note:
- Time-table for winter semester 2011/2012:
-
06:00–08:0008:00–10:0010:00–12:0012:00–14:0014:00–16:0016:00–18:0018:00–20:0020:00–22:0022:00–24:00
Mon Tue Fri Thu Fri - Time-table for summer semester 2011/2012:
- Time-table is not available yet
- The course is a part of the following study plans: