You can easily arrange two Word documents on screen so you can look at both at once. But when you open two Excel workbooks, the default is that they open in the same window and you have to switch between them when looking at both. But opening them in separate windows is easiest if you know the trick.
First open one workbook by any method.
Then open another instance of Excel via the start menu and open the second workbook in that using File > open.