Microsoft Office Tutorials and References
In Depth Information
Tutorial E: Guidance for Excel Cases
GUIDANCE FOR EXCEL CASES
The Excel cases in this topic require the student to write a memorandum that includes a table. Guidelines for
preparing a memo in Microsoft Word and instructions for entering a table in a Word document are provided
to begin this tutorial. Also, some of the cases in this topic require the use of advanced Excel techniques.
Those techniques are explained in this tutorial rather than in the cases themselves:
Using data tables
Using pivot tables
Using built-in functions
You can refer to Sheet 1 of TutEData.xlsx when reading about data tables. Refer to Sheet 2 when reading
about pivot tables.
PREPARING A MEMORANDUM IN WORD
A business memo should include proper headings, such as TO, FROM, DATE, and SUBJECT. If you want to
use a Word memo template, follow these steps:
1. In Microsoft Word, click File.
2. Click New.
3. Click the Memos button in the Office.com Templates section.
4. Double-click the Contemporary design memo.
The first time you do this, you may need to click Download to install the template.
ENTERING A TABLE INTO A WORD DOCUMENT
Enter a table into a Word document using the following procedure:
1. Click the cursor where you want the table to appear in the document.
2. In the Insert group, select the Table drop-down menu.
3. Select Insert Table.
4. Choose the number of rows and columns.
5. Click OK.
An Excel data table is a contiguous range of data that has been designated as a table. Once you make this
designation, the table gains certain properties that are useful for data analysis. (Note that in some previous
versions of Excel, data tables were called data lists.) Suppose you have a list of runners who have completed
a race, as shown in Figure E-1.