Exercise 1

Pagina 1

BEM01 – Excel and Weather Data 13/03/17 In these exercises, Excel software will be used as first to analyze data given by TRNSYS simulation and secondly to realize input files that will be used in Simulation Studio. Be aware that the comma for decimals, should be changed in dot/full stop. Tools > Options > International > SET Decimal separator: [.] – “Thousands separator: [‘] An easier use of EXCEL is allowed by some shortcuts (by mouse or keys combination). The use of macros can be seen as an advanced use of Excel to pre-/post-processing data. The use of the macros is allowed reducing the security properties in Excel by changing the setting options: Tools > Options > Security > Macro Security > Medium (You can choose whether or not to run potentially unsafe macros.) Excel Tips & Tricks CLICK on the letter: select the whole column on the number: select the whole line on the intersection (line-column): select the whole sheet SHIFT Shift+F12: save (Italian version) Shift+directional arrows: select cells CTRL Ctrl+ directional arrows: move to the first/last empty cell Ctrl+shift+ directional arrows: select to the first/last not-empty cell Ctrl+F4: close the file without closing the program Ctrl+1: cell format Ctrl+z: undo Ctrl+y: redo Ctrl+x: cut Ctrl+c: copy Ctrl+v: paste Ctrl+b: crossed (Italian version), bold (English version) Ctrl+n: open a new file Ctrl+s: underlined (Italian version), save (English version) Ctrl+g: bold (Italian version) Ctrl+i: cursive script FUNCTION KEYS F1: online guide F2: go inside the cell and allow modifying the equation F4: absolute reference to keep a row and/or column constant F12: save with a new name (Italian version) Useful EXCEL Functions in ITALIAN and their equivalent in ENGLISH CONTA.SE COUNTIF CONTA.VALORI COUNTA CONTA.VUOTE…