• MS Excel essentials. Cells labelling, absolute and relative references, data validation, the design of user application using the control elements of the form. Practical example from the field of the thermal processes.
• The design of the tables in the MS Excel environment, the auto-searching methods. Practical example from the field of the thermal processes.
• Approximation of thermophysical properties by regression functions.
• Use of logic functions in convective heat transfer using critical equations.
• The determination of the extreme values of a function and the equations roots. Practical example from the field of the thermal processes.
• The principle of stationary heat conduction by iterative method.
• The processing of the measured data. The statistics essentials – the moving average, the median, t-test, and the like. Data filtering.
• Design of results presentation, pictures and graphs. Creating static and interactive graphs.
• The finite element analysis. The mesh design, the determination of the sample time. The influence of the different kind of the boundary conditions on the computation results.
• Using macros in MS Excel - View card developer, creating macros, use the the control elements of the form.
• Basics of programming in VBA - Sub and Function, variable declarations, creation of custom formulas. Creating and using supplements.
• A method InputBox Excel and VBA, the function MsgBox of VBA, work with objects Range
• Design With-End With, For Each-Next, GoTo, If-Then, Select Case. Object variable.
• Error handling.
• Creation of user forms.
• Creating technical text in MS Word.
• The design of the tables in the MS Excel environment, the auto-searching methods. Practical example from the field of the thermal processes.
• Approximation of thermophysical properties by regression functions.
• Use of logic functions in convective heat transfer using critical equations.
• The determination of the extreme values of a function and the equations roots. Practical example from the field of the thermal processes.
• The principle of stationary heat conduction by iterative method.
• The processing of the measured data. The statistics essentials – the moving average, the median, t-test, and the like. Data filtering.
• Design of results presentation, pictures and graphs. Creating static and interactive graphs.
• The finite element analysis. The mesh design, the determination of the sample time. The influence of the different kind of the boundary conditions on the computation results.
• Using macros in MS Excel - View card developer, creating macros, use the the control elements of the form.
• Basics of programming in VBA - Sub and Function, variable declarations, creation of custom formulas. Creating and using supplements.
• A method InputBox Excel and VBA, the function MsgBox of VBA, work with objects Range
• Design With-End With, For Each-Next, GoTo, If-Then, Select Case. Object variable.
• Error handling.
• Creation of user forms.
• Creating technical text in MS Word.