Getting Started with Excel 2011

View:  
Sorted by:  

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…]

Sign Up for RSS Feeds

Computers & Software
Great Gadget Giveaway -- Enter to Win!

Inside Dummies.com