Microsoft Excel is one of the most popular spreadsheet applications that helps you manage data, create visually persuasive charts, and thought-provoking graphs. Excel is supported by both Mac and PC platforms. Microsoft Excel can also be used to balance a checkbook, create an expense report, build formulas, and edit them.
CREATING A NEW DOCUM ENTOPENING MICROSOFT EXCEL ON A MAC
To begin Microsoft Excel, Go to Macintosh HD > Applications > Microsoft Office 2008 > Microsoft Excel (Figure 1). When opened a new spreadsheet will pop up on the screen, if this does not happen click File > New Workbook.
Figure 1. Navigate to Microsoft Excel on a Mac.
Figure 2. Opening a new workbook
SAVING YOUR DOCUMENT
Computers crash and documentsare lost all the time, so it is best to save often.
Before you begin you should save your document. To do this, go to File > Save As. Microsoft Excel will open a dialog box (Figure 3) where you can specify the new file’s name, location of where you want it saved, and format of the document. Once you have specified a name, place, and format for your new file, press the Savebutton. Note: Specifying your file format will allow you to open your document on a PC as well as a MAC. To do this you use the drop down menu next to the Format option. Also, when you are specifying a file extension (i.e. .doc) make sure you know what you need to use.
Figure 3. Saving dialog box.
After you have initially saved your blank document under a new name, you can beginyour project. However, you will still want to periodically save your work as insurance against a computer freeze or a power outage. To save, click File > Save or Command S for a shortcut on a MAC.
Microsoft Excel uses toolbars to allow you to modify your document. When you first open Excel, usually the three toolbars discussed below will open. However, each computer may set up thesetoolbars differently, so they may look different than the toolbars below. If you do not see these toolbars, or to open up other toolbars, go to View > Toolbars and place a checkmark by the toolbar you wish to open. If you do not see an icon you expect on a toolbar, click on the arrow at the end of the toolbar
to reveal hidden icons. Excel will also allow you to customize your toolbars by going toView > Customize Toolbars and Menus.
THREE COMMONLY USED TOOLBARS
The Menu bar: (Figure 4). This toolbar is constructed of word commands and not icons (pictures). The Menu bar contains all the options available to you in Microsoft Excel. Using this toolbar to format and change your document will often allow you greater control than using the icons on the other toolbars. However, the othertoolbars may be more convenient. Figure 4. Menu bar. The Standard toolbar: (Figure 5). This toolbar contains icons from common commands such as Save, Print, Copy, and Paste. These icons are convenient but will not bring up the dialogue boxes that allow you to change the settings of these actions. You should use whichever method works the best for you.
Figure 5. Standard toolbar. The FormattingPalette: (Figure 6). This palette contains icons for common formatting actions, such as Font Style, Font Size, Bold, Italic, Underline, Alignment, Borders and Shading, Orientation, Gridlines, and Margins. These icons are convenient but will not bring up dialogue boxes that allow you to change the settings of these actions. You should use whichever method works the best for you.
Figure 6. FormattingPalette.
FORM ATTING FORMATTING THE SPREADSHEET
The default page view for Microsoft Excel spreadsheets display all gridlines and open up in portrait orientation. To change the gridlines look at the fifth tab on the Formatting Palette, under Sheet uncheck the view box. This will eliminate any gridlines from the spreadsheet. To change the page orientation look at the fifth tab on the...