

- #Excel for mac tutorial pdf for mac os
- #Excel for mac tutorial pdf pdf
- #Excel for mac tutorial pdf Pc
Formatting Palette.ĥ F O R M A T T I N G FORMATTING THE SPREADSHEET The default page view for Microsoft Excel spreadsheets display all gridlines and open up in portrait orientation. You should use whichever method works the best for you. These icons are convenient but will not bring up dialogue boxes that allow you to change the settings of these actions. 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 the dialogue boxes that allow you to change the settings of these actions. This toolbar contains icons from common commands such as Save, Print, Copy, and Paste. However, the other toolbars may be more convenient. Using this toolbar to format and change your document will often allow you greater control than using the icons on the other toolbars. The Menu bar contains all the options available to you in Microsoft Excel. This toolbar is constructed of word commands and not icons (pictures). THREE COMMONLY USED TOOLBARS The Menu bar: (Figure 4). Excel will also allow you to customize your toolbars by going to View > Customize Toolbars and Menus. 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. 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. However, each computer may set up these toolbars differently, so they may look different than the toolbars below.

When you first open Excel, usually the three toolbars discussed below will open. T O O L B A R S Microsoft Excel uses toolbars to allow you to modify your document. To save, click File > Save or Command S for a shortcut on a MAC. However, you will still want to periodically save your work as insurance against a computer freeze or a power outage. SAVING LATER After you have initially saved your blank document under a new name, you can begin your project. Also, when you are specifying a file extension (i.e.doc) make sure you know what you need to use. To do this you use the drop down menu next to the Format option.
#Excel for mac tutorial pdf Pc
Note: Specifying your file format will allow you to open your document on a PC as well as a MAC. Once you have specified a name, place, and format for your new file, press the Save button. 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. SAVING INITIALLY Before you begin you should save your document. You should also have the basic skills of file management and folder navigations.3 S A V I N G Y O U R D O C U M E N T Computers crash and documents are lost all the time, so it is best to save often. Prerequisitesīefore proceeding with this tutorial, you should have a basic understanding of Computer peripherals like mouse, keyboard, monitor, screen etc. It will be highly useful for those learners who do not have prior exposure to Microsoft applications. This tutorial has been designed for computer users who would like to learn Microsoft Excel in easy and simple steps.

xlsx extension whereas the file extension of the prior Excel versions are. Microsoft Excel is a spreadsheet tool capable of performing calculations, analyzing data and integrating information from different programs.īy default, documents saved in Excel 2010 are saved with the.

#Excel for mac tutorial pdf for mac os
At the time of writing this tutorial the Microsoft excel version was 2010 for Microsoft Windows and 2011 for Mac OS X. Microsoft Excel is a commercial spreadsheet application, written and distributed by Microsoft for Microsoft Windows and Mac OS X.
#Excel for mac tutorial pdf pdf
PDF Version Quick Guide Resources Job Search Discussion
