[TBD]Useful Microsoft excel info

Tips

Formula to calculate sigmoid

=1/(1+EXP(-L4))

Method to transpose an array

Example: =TRANSPOSE(S2:S4)

Useful link: https://support.office.com/en-us/article/transpose-function-ed039415-ed8a-4a81-93e9-4b6dfac76027

Method to multiply matrix

Example: =MMULT(A18:C21,P12:R14)

Useful link: https://support.office.com/en-us/article/mmult-function-40593ed7-a3cd-4b6b-b9a3-e4ad3c7245eb