Using Custom Style (Sheets)

I was wondering how easy it might be to use drupal functions in order to load custom style sheets besides those which are somehow defined to load via modules.

Thanks & Regards.