75 Essential Excel tips - CBS Interactive

On the General tab, set the value in the Sheets In New Workbook box to 1, and click OK. ... Analyzing external data in Excel. You can use Excel to analyze data from the various databases in your organization. ... displays outline symbols to the left of the spreadsheet. Using these symbols, you can collapse the data to show only the subtotals ... ................
................