Working With Formulas

This chapter contains fundamentals, shortcuts, tips, and techniques that are essential when working with Formulas & Functions. It includes the following sections:

• Inserting, Editing, & Copying Formulas : This section covers easy techniques on inserting, editing, and copying formulas, understanding the correct use of relative/absolute references, and creating power formulas.
• Selecting, Displaying, Printing & Pasting Formulas: In this section you will find techniques on displaying formula syntax, displaying formulas and values, selecting cells containing formulas, pasting values, adding comments to formulas, and printing formula syntax. Array Formulas, page 12: This section provides an explanation of the concept of an Array and how Excel uses Arrays in formulas, You will also learn how to create an Array formula. Using Range Names in Formulas, page 13: In this section, learn about range name rules, how to define range names, and how to use range Names in formulas.
• Auditing Formulas: In this section, find essential shortcuts and techniques on tracing and moving between precedent and dependent cells, stepping into formulas, and tracing errors in a formula.
• Protecting Formulas: In this section, you will learn how to protect formulas in both protected and unprotected sheets.

3:17 AM | 0 comments | Read More

What's New in Excel 2007

Here's a quick and dirty overview of the new features in Excel 2007:

• A new tab/Ribbon user interface
• New XML file formats
• Worksheet tables
• Significantly larger worksheet grid (1,048,576 rows x 16,384 columns)
• Ability to use more memory
• Unlimited conditional formats per cell
• 100 levels of undo
• Maximum formula length increased to 8,000 characters
• Support for 64 levels of nesting in a formula
• Formula autocomplete
• Better-looking charts
• Workbook themes
• Skins
• Page Layout view
• New conditional formatting options
• Less confusing Excel Options dialog box
• New collaboration features (requires SharePoint)
• SmartArt and Improved WordArt
• Compatibility checker
• Easier pivot tables
• Twelve new worksheet functions, plus integration of the Analysis ToolPak functions
• PDF output (via a downloadable add-in)
• Resizable formula bar
• Many new templates
• More control over the status bar

9:44 AM | 0 comments | Read More