Logo ČVUT
CZECH TECHNICAL UNIVERSITY IN PRAGUE
STUDY PLANS
2019/2020

Advanced function in Microsoft Excel

The course is not on the list Without time-table
Code Completion Credits Range Language
2366004 Z 2 0P+2C Czech
Lecturer:
Tutor:
Supervisor:
Department of Instrumentation and Control Engineering
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:
Further information:
No time-table has been prepared for this course
The course is a part of the following study plans:
Data valid to 2019-10-18
For updated information see http://bilakniha.cvut.cz/en/predmet9302.html