Advanced function in Microsoft Excel

Garant předmětu:

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: