Spreadsheet Templates to Accompany Horngren et al, Introduction to Management Accounting 14e
Templates by Albert Fisher

EXCEL TUTORIAL ___

This tutorial is written for you, the student, to help you complete the Excel templates that your instructor may assign as needed. These templates are partially completed to allow you to concentrate on solving the problem and not worry about the formatting or presentation of the answer. All cells that need to be completed are shaded in blue and will require you to enter one of the following: a formula, an account title, a number, or a function. These four items will be covered in a later section of this tutorial. Finally, there a few problems that have no shaded cells and you will be required to complete the entire template.

BASIC SKILLS

Starting Excel is similar to starting other Windows applications. The following steps are required:

Launching Excel

Double click the Microsoft Excel icon from your desktop icons. If Excel does not have a desktop icon, then do the following:

a. Click Start to display the start menu.
b. Click Program to display the programs available on your computer.
c. Scroll down until you find the Excel program and double click on it.

Opening a Worksheet File

a. Make sure your student CD is in the disc drive.

b. There are two ways to open a worksheet file.

1. The first way is to click the Open button. Buttons are shortcuts for many worksheet tasks. We will be using some of these buttons to facilitate the student’s work. The four we will be using are Open, Print, Save As, and Save. Notice the Open icon.

Opening a Worksheet File (continued)

Open icon

[pic]

2. The second way is to click File from the main menu bar and then Open to display the Open File dialog box. A dialog box is used to select options and identify data you want a command to work