Microsoft Office Tutorials and References
In Depth Information
Analysis Tools
You can also create Web queries to bring in data stored in a corporate intranet or on the Internet.
Such a query can be refreshed, so the data updates as new information is posted. Figure 2-25
shows an example of a Web query.
Figure 2-25: Create a Web query to import data into a worksheet.
Analysis Tools
Excel is certainly no slouch when it comes to analysis. After all, that’s what most people use a
spreadsheet for. You can handle most analysis tasks with formulas, but Excel offers many other
options:
h Outlines: A worksheet outline is often an excellent way to work with hierarchical data
such as budgets. Excel can create an outline (horizontal, vertical, or both) automatically,
or you can do so manually. After you create the outline, you can collapse or expand it to
display various levels of detail.
h Analysis ToolPak: In previous versions of Excel, the Analysis ToolPak add-in provided
additional special-purpose analysis tools and worksheet functions, primarily statistical in
nature. Beginning with Excel 2007, these features are built in. These tools make Excel
suitable for casual statistical analysis.
 
Search JabSto ::




Custom Search