Online Test Banks
Score higher
See Online Test Banks
eLearning
Learning anything is easy
Browse Online Courses
Mobile Apps
Learning on the go
Explore Mobile Apps
Dummies Store
Shop for books and more
Start Shopping

Excel 2011

View:  
Sorted by:  

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

Office 2011 for Mac: Applying Number and Text Formats in Excel

One of the things you might find you do frequently in Excel 2011 for Mac is change the way cells look, and you do so with options on the Home tab of the Ribbon. Other than the visual effect, format also [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…]

Excel for Mac 2011: Create Formulas with the Formula Builder

Excel’s Formula Builder in Office 2011 for Mac is a tool in Toolbox designed to help you build cell formulas. You start at the top of the Formula Builder and work your way down to put a finished cell formula [more…]

Excel for Mac 2011: Make Relative References on Worksheets

Copying and pasting cells and cell formulas works differently from text and other objects in Excel in Office 2011 for Mac, so they can be a little bit puzzling if you don’t know the secrets about references [more…]

Make Sparklines in Excel in Office 2011 for Mac

If you're really in a hurry, or if space on your Excel 2011 for Mac worksheet is at a premium and you want a quick visual representation of your data, sparklines are worth investigating. It only takes [more…]

Office 2011 for Mac: Apply Number and Text Formats in Excel

One of the things you might find you do frequently in Excel 2011 for Mac is change the way cells look, and you do so with options on the Home tab of the Ribbon. Other than the visual effect, format also [more…]

Excel for Mac 2011: Fit and Position Cell Content in Worksheets

You can align and position cell contents in Excel using the Alignment group on the Office 2011 for Mac Ribbon’s Home tab at the top of the Excel window: [more…]

Office 2011 for Mac: Format Cell Borders in Excel Worksheets

Formatting cells and cell ranges in Excel 2011 for Mac is like formatting tables. In the Font group of the Ribbon’s Home tab, clicking Borders button displays a drop-down gallery of border styles. [more…]

Office 2011 for Mac: Format Dates and Times in Excel

Excel 2011 for Mac has fantastic date and time calculation capabilities. When using Excel worksheets, you need to know just two secrets: Each day is represented by a whole number, called a [more…]

Office 2011 for Mac: Choosing Conditional Formatting Rules in Excel

You can set Excel 2011 for Mac to change the format of a cell, cell range, table, or pivot table based on conditions you specify. Use these settings when you want a cell’s appearance to change as the result [more…]

Excel for Mac 2011: Add a Picture to a Worksheet Background

Behind the cells on each Excel worksheet in Office 2011 for Mac is a background layer that you can format. Excel for Mac 2011 doesn't offer a lot of customization to this feature, but you can place an [more…]

Excel for Mac 2011: Sort and Filter in Tables and Worksheets

When sorting your Excel tables and worksheets in Office 2011 for Mac, you’re likely to use ascending and descending sort orders most often. The quick way to sort a table or data range is to select a cell [more…]

How to Make a PivotTable in Excel for Mac 2011

In Excel 2011 for mac, a PivotTable is a special kind of table that summarizes data from a table, data range, or database external to the workbook. If you’re PivotTable aficionado, you will be in seventh [more…]

How to Make an Excel Chart in Office 2011 for Mac

Charts are a strongpoint in Excel for Mac 2011. Students, businesses, scientists, news organizations, economists, and many other groups use charts. When you make charts in Office 2011 for Mac, you find [more…]

Listings:1-2526-5051-7576-100more...

Sign Up for RSS Feeds

Computers & Software
Win $500. Easy. Enter to win now.

Inside Dummies.com

Dummies.com Sweepstakes

Win $500. Easy.