Opening the iTunes Store.If iTunes doesn't open, click the iTunes application icon in your Dock or on your Windows desktop.Progress Indicator
Opening the iBooks Store.If iBooks doesn't open, click the iBooks app in your Dock.Progress Indicator
iTunes

## iTunes is the world's easiest way to organize and add to your digital media collection.

We are unable to find iTunes on your computer. To download from the iTunes Store, get iTunes now.

Already have iTunes? Click I Have iTunes to open it now.

iTunes for Mac + PC

# Creating and Auditing Formulas In Microsoft® Excel® 2010

### In Three Quick and Easy Lessons

#### Description

Creating and Auditing Formulas In Microsoft® Excel® 2010: In Three Quick and Easy Lessons guides you through creating, copying and pasting, reviewing, and auditing basic and complex formulas in Excel 2010 using step-by-step hands-on activities.
In Lesson 1, you will learn about the syntax of formulas and about Excel’s predefined formulas, called functions. Then you will create basic formulas by entering the formulas into cells manually, by using the Sum (AutoSum) feature, and by copying and pasting existing formulas into other cells. You will also learn how to use status bar options to quickly find the sum, average, minimum, maximum, and number of values for a range without creating a formula.
In Lesson 2, you will learn how to use the Formula AutoComplete feature, how to enter formulas on grouped worksheets, and how to create formulas with 3-dimensional references—references that span worksheets and workbooks. Next, you will use the Function Library to add the current date and time to a worksheet and to create a formula that performs two logical tests. Then you will learn to use defined names and column or row labels as function arguments. Finally, you will learn how to apply conditional formatting to formulas.
In Lesson 3, you will learn how to use tools that help you identify and correct errors in formulas and other kinds of worksheet errors including the Error Checking feature and the Trace Error icon, the Formula Auditing tools, the Watch Window toolbar, displaying a workbook in more than one window and splitting a worksheet into multiple viewing panes, and protecting a worksheet.

## Customers Also Bought

View in iTunes
• \$2.99
• Available on iPhone, iPad, iPod touch, and Mac.
• Category: Computers
• Published: Apr 28, 2011
• Publisher: FreeTutorialCentral, LLC
• Seller: Napier-Rivers LLC
• Print Length: 116 Pages
• Language: English
• Requirements: To view this book, you must have an iOS device with iBooks 1.3.1 or later and iOS 4.3.3 or later, or a Mac with iBooks 1.0 or later and OS X 10.9 or later.

#### Customer Ratings

We have not received enough ratings to display an average for this book.