I was wondering how you'd go about creating a visible cone of light that fades

Question

I was wondering if it was possible to do something like this but also apply the effect used in this to the cone of light in Cycles. I was told by someone else that I need volumetrics, but I'm not quite sure how to do this.