That's odd. If you installed everything local, Excel should find SSAS just fine.

Can you log into SSAS using Management Studio?

ps: to use TCP to connect to SSAS, you just replace the hostname with the following:

TCP:ipAddress,portnumber