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 Formulas & Functions

View:  
Sorted by:  

Writing and Editing Equations in Office 2011 for Mac

Writing and editing equations in Office 2011 for Mac is easy, whether you're working with simple or complex equations. Office 2011 for Mac offers two ways for you to represent numeric equations that aren’t [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…]

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

Sign Up for RSS Feeds

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

Inside Dummies.com

Dummies.com Sweepstakes

Win $500. Easy.