People working in a variety of fields often need to create complex spreadsheets to illustrate budgets and business proposals, or manage data and provide analysis. Developing complicated worksheets requires specific knowledge and skills for manipulating large quantities of data. Adding flow charts, querying data from external sources or creating PivotTables using Microsoft’s Excel software not only makes creating and using complex spreadsheets easier, it also can make the information clear to others. Open the Excel worksheet and click on the “Data” tab, and “From Web.” The New Web Query dialog box appears. Type in the Web address of the site that has the data you want to import to your worksheet. Click the “Go” button and the Web page will appear in the New Web Query dialog box. Click and drag your cursor across the information to select the data you want to include in the PivotTable. Make sure you include the row and column headings. Click the “OK” button, Excel opens the “PivotTable Field List” pane to the right. Check the fields you want to add to your report. Excel automatically makes the “PivotTable Tools” available for you to format your report. Writer Bio
