In "Data > Get Data > From Web" there should be an option to authenticate using cookies.
On the Data ribbon, there is option to Import data tables from web pages. But the authentication options for web-sites is pretty limited.
I am unable to import "private" data in excel from the following URL:
I believe that my authentication data is stored in cookies, it is not a form based authentication.