Appearing offline in Steam prevents others from seeing your current status, but you still have all the functionality of Steam ...

Steam has multiple settings for how you appear to other players, including a setting to appear offline even when you’re not.