If you make a selection and then click the Add Excel Data, it will use that selection. You can do the same multiple times and then change the symbol for the layer by selecting "Style" from the menu or the right click context menu. Another option is to add all the data to the map and then use the "Grouping" option to create a map of sized symbols based on Number ranges or categories.