| Screen Action |
Audio Script |
|
Excel 2003 is open showing a blank worksheet.
|
In business, it’s essential to track performance using defined metrics for key business processes and procedures.
With Excel 2003, I can find, analyze, and report performance gaps and make necessary improvements.
|
|
The pointer opens the Data menu, points to XML, and then chooses Import on the submenu. The Import XML dialog box opens.
The pointer selects a file called Allwarehouses.xml and clicks Import. The Import Data dialog box opens with XML list in existing worksheet, the default import option, selected.
The pointer selects OK and the scene changes to show the data from the XML file successfully imported into the worksheet.
|
The best analysis begins with having all the information in one place.
In this case, I’m going to import warehouse data stored in an XML format.
I just choose my XML file, and Excel brings the data onto my worksheet.
XML enables me to organize and work with data in ways that used to be difficult or impossible.
|
|
The pointer opens the Data menu and clicks PivotTable and PivotChart Report. The PivotTable and PivotChart Report Wizard appears.
The pointer clicks Next twice to accept the default options in Steps 1 and 2 of the wizard.
In Step 3 of the wizard, the pointer clicks Finish, and the scene changes to show a new worksheet with an empty PivotTable report and the PivotTable Field List available to the right.
|
Once the data has been imported, I’ll go ahead and create a PivotTable® report to analyze the performance of my various warehouses.
With just a few clicks, the PivotTable report is created, and I can slice and dice the data however I want.
|
|
The pointer drags the warehouse_name, warehouse_cost, warehouse_sales, and division items from the PivotTable Field List to the empty PivotTable report fields.
The data is automatically arranged to display the columns and rows of data as they correspond to each other.
|
I just drag the key business elements that I want to analyze onto my PivotTable report, such as the
warehouse name,
warehouse cost,
warehouse sales,
and division.
Now, I can analyze the performance of my various warehouses and quickly develop solutions to key issues.
|
|
The pointer clicks the Format Report toolbar button. The AutoFormat dialog box opens.
The pointer selects Report 6 and then clicks OK. The scene changes to show the Excel worksheet with a formatted PivotTable report. The pointer closes the PivotTable Field List.
|
Before sharing this data with my team, I’ll format the PivotTable report so the data is a little easier to read.
With one click I choose the formatting that I want, and that’s it.
Now, I can share this data with others, allowing them to see potential problems and providing them with the information they need to take action.
|
|
The pointer selects Save as Web Page on the File menu, and the Save As dialog box opens.
The pointer clicks Publish to accept the default options and, in the Publish to Web dialog box, clicks Publish again. The scene changes to show the formatted PivotTable report reproduced as a Web page.
|
There are many ways to share this data, but in this case, I’ll publish it to the Web.
I just choose to publish the sheet, and, there you go
…
… Excel creates an HTML representation of my data that I can put on my Web site.
|
|
The scene changes back to show the PivotTable report in the Excel worksheet.
|
With Excel 2003, I’m able to quickly
compile business data, analyze it,
and create a report that I can share with others.
Now, I can turn information into business impact!
|
|
Excel 2003 disappears. The animated text Experience your own great moments appears. Under it appears the URL http://www.microsoft.com/office.
|
|
United Kingdom
![Work Essentials: [title]](/global/images/default.aspx?AssetID=ZA101951221033)
Play Demo 
Printer-Friendly Version
Show All
Hide All
