Yes.   You must have the Office enhancement. 

In Excel you will have to LINK to the BW database of the company you wish to view.

The setup is not for the newbie. But the results would be exactly what you desire

Thanks. How can I check if I have the Office enhancement?

From the Welcome module, I go to Utilities and Registration Information then click the Module Registration button. Custom Office should be the last module listed. 

I don't have appropriate permissions to check apparently. Do you know where I can go in Excel to Link it in case I have it

In Excel, under DATA ribbon.

I can not teach how to use .

There used to be some training in Sage University, but it was years ago.

Last, the computer needs to have the DSN enabled for the company  for the Sage connections to work.

see the utilities in the Sage Businessworks folder from the Start menus