If your argument is in the degrees multiply by PI ()/180 or use the Radian function to convert it to radians. In the cell you want to place the result, type =TAN (30*PI ()/180) and press Enter.

In addition to these trigonometric functions, Excel also provides functions for converting angles between radians and degrees.