TLDR; If you just want the step-by-step on how to work with Excel and work items
without installing Team Explorer, jump down to the Non-Developer's Short Guide
to Using Excel with TFS/VSTS Work Items on this page.
For years, if you wanted to work with Team Foundation Server (TFS)