#MICROSOFT EXCEL 2011 FOR MAC TUTORIAL HOW TO#
#MICROSOFT EXCEL 2011 FOR MAC TUTORIAL UPGRADE#
#MICROSOFT EXCEL 2011 FOR MAC TUTORIAL FULL#
#MICROSOFT EXCEL 2011 FOR MAC TUTORIAL PC#

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.

#MICROSOFT EXCEL 2011 FOR MAC TUTORIAL 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. See a list of known issues as well as potential workarounds.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. Rearrange, show, and hide tabs on the ribbon.ДЇixes or workarounds for recent issues in Excel for Mac

#MICROSOFT EXCEL 2011 FOR MAC TUTORIAL FULL#

See the full list of keyboard shortcuts, organized into logical categories. Use Excel for Mac 2011 to check out a SharePoint file so that only you can make changes.

#MICROSOFT EXCEL 2011 FOR MAC TUTORIAL HOW TO#

Learn the two different ways to create a Pivot Table and how to use the Pivot Table Field Lists to add, move, and arrange fields.Д¬reate a projection based on an existing series of data. Use error bars to indicate potential error amounts in relation to each data point.ДЄdd pictures or clip art to a worksheet by using the Media Browser. Learn the basics of charts, including the elements of a chart, which chart is appropriate for your data, and how to apply chart layouts and styles.ДЄdd chart and axis titles, change the axis scale, add data labels, and more.ДЄdd, change, or remove error bars in a chart Learn the difference between relative and absolute cell references and how to switch between them.

Switch between relative and absolute references Learn about the different kinds of operators (for example, +, -, /, and *) and the order in which they are applied. Learn the elements of a formula as well as how to enter a formula on a sheet.Д¬alculation operators and order of operations Highlight patterns and trends with conditional formattingД¬hange the appearance of cells based on certain criteria, for example, all cell values in the top 10% of a range. Prevent unauthorized changes, moves, or deletions of important data. Keep column headings visible while you scroll.Д¬hange the width of columns so that you can see all the data in cells. Use the Paste Special command to copy and paste special cell contents or attributes.

#MICROSOFT EXCEL 2011 FOR MAC TUTORIAL UPGRADE#

Upgrade to Microsoft 365 for Mac to work anywhere from any device and continue to receive support. Support for Office 2011 for Mac ended on October, 2017.

Microsoft excel 2011 for mac tutorial