Working with SkyDrive in Office 2011 for Mac
Collaboration is built into Office 2011 for mac. You can save your documents directly to the cloud (like SkyDrive) by choosing File→Share. Choose your public cloud using Save to SkyDrive. SkyDrive offers [more…]
Opening Files in Office 2011 for Mac
Every program in Office 2011 for Mac is associated with files that must be opened from the File menu. Whenever you choose File→Open or when you insert content into existing files using a file browser, [more…]
Saving Files in Office 2011 for Mac
Saving a file that you're working on in Office 2011 for Mac is as easy as clicking the Save button on the Standard toolbar, pressing Command-S, or choosing File→Save. If your file has been saved previously [more…]
Signing Up for and Managing SkyDrive in Office 2011 for Mac
SkyDrive offers online file storage and file sharing to Office 2011 for Mac users in exchange for being subjected to advertising. If you already have a Hotmail, Microsoft Messenger, or Windows Live account [more…]
Managing Files with SkyDrive in Office 2011 for Mac
If you’ve decided to use SkyDrive to store and share your Office 2011 files, you have two ways to save to SkyDrive without your Web browser. You can save directly from Office to SkyDrive, or you can save [more…]
Office 2011 for Mac: How to Insert a SmartArt Graphic
Sometimes you need visual aids to convey your message, and Office 2011 for Mac can help you there. SmartArt graphics are sophisticated design combinations of shapes and text used to present data that you [more…]
Edit and Manipulate SmartArt Graphics in Office 2011 for Mac
In Office 2011 for Mac, SmartArt is a component that allows you to represent your data or ideas visually. If you select a SmartArt graphic, you can use the Edit SmartArt group of the SmartArt tab of the [more…]
Office 2011 for Mac: Insert and Delete Excel Cells, Rows, Columns
Cells, rows, and columns in Excel 2011 for Mac work just like a table in Word or PowerPoint, but have many more capabilities. Adding rows and columns is almost as easy as pressing a button: [more…]
Opening the Excel Workbook Gallery in Office 2011 for Mac
The default behavior for opening Excel for Mac 2011 is the display All Templates option of the Excel Workbook Gallery. You can also display the Templates Gallery by choosing File→New from Template from [more…]
Using Excel’s Common Interface in Office 2011 for Mac
When you're working in Excel for Mac 2011, you have your choice of two views: Page Layout view and Normal view. Whether you prefer to work in Page Layout view or Normal view, most interface components [more…]
Working with Excel Sheet Types in Office 2011 for Mac
If you're working in Office 2011 for Mac, you'll find that Excel sheets can be general or dedicated to a specific purpose. You don’t have to be an expert in Excel 2011 for Mac to use the various sheet [more…]
Setting Excel Preferences in Office 2011 for Mac
Although it's true that you can gain a better knowledge of any application if you visit its preferences and try to figure them out, it's almost essential for Excel for Mac 2011. Choose Excel→Preferences [more…]
Choosing Excel File Formats in Office 2011 for Mac
You expect Excel for Mac 2011 to open Excel files, of course, but the program can do more than that. You can actually open, work on, and save a file in several formats. Choose File→Save As and then click [more…]
Automating Web Pages with Excel in Office 2011 for Mac
Suppose you post daily updates to Excel for Mac 2011 spreadsheets and charts that you save as Web pages for your intranet. You can set up your Mac so that the Web site is refreshed automatically on any [more…]
Office 2011 for Mac: Save Excel Workbooks in Old File Formats
Excel for Mac 2011 lets you save a workbook in the following old Excel formats if you’re creating a spreadsheet for or with someone who has a version of Excel prior to Excel 2007: [more…]
Excel for Mac 2011: Set Up and Use AutoRecover
Office 2011 for Mac is full of useful features, including the autorecovery tool in Excel. Although crashes in Excel for Mac 2011 are extremely rare, it doesn't hurt to make sure Excel 2011 is backing up [more…]
How to Select Worksheet Cells in Excel for Mac 2011
When working in an Excel spreadsheet or workbook in Office 2011 for Mac, click a cell to select it. Excel for Mac 2011 will indicate the selected cell in several different ways: [more…]
Editing and Clearing Worksheet Cells in Excel for Mac 2011
When you start typing in a cell in Excel in Office 2011 for Mac, the border gets a nice, soft shadow and seems to be closer to you than the rest of the sheet. The blinking insertion cursor displays inside [more…]
Identifying Cursors in Excel in Office 2011 for Mac
Excel for Mac 2011 is always trying to tell you what it can do. When you’re in a worksheet, the cursor changes as you move the mouse around. The cursor’s appearance reveals what you can do: [more…]
Excel for Mac 2011 Worksheets: How to Drag a Series of Typing
In Office 2011 for Mac, Excel is pretty smart, because it can automatically fill in a series of either numbers or dates. Excel for Mac 2011 can even make intelligent guesses about a series of numbers. [more…]
Office 2011 for Mac: Using the Custom Lists Feature in Excel
The Custom Lists feature is about making lists that Excel for Mac 2011 can refer to when filling in a series by dragging a selected cell’s fill handle [more…]
How to Type a Formula Manually in Excel for Mac 2011
Cell formulas are equations that perform calculations or logical operations. In Excel in Office 2011 for Mac, you can enter a formula on your own, or you can use the Formula Builder. When learning to type [more…]
Let Excel for Mac 2011 Type a Cell Formula for You
Cell formulas are equations that perform calculations or logical operations. In Excel for Mac 2011, you can enter a formula on your own, or you can use the Formula Builder, which helps you build formulae [more…]
Using Built-In Functions and Arguments in Excel for Mac 2011
In Office 2011 for Mac, Excel has hundreds of built-in functions that you can use in cell formulas. While you type a function in a cell formula, a pop-up menu appears. The following example uses Excel’s [more…]










