Formulas and Functions with Microsoft Office Excel 2007 (Rough Cuts)

Description

• Copyright 2007
• Dimensions: 7 X 9-1/8
• Pages: 504
• Edition: 1st

• Rough Cuts
• ISBN-10: 0-7686-7460-3
• ISBN-13: 978-0-7686-7460-6

This is a working draft of a pre-release book. It is available before the published date as part of the Rough Cuts service.

“If you’ve never quite grasped formulas and functions, Paul McFedries will radically expand your understanding and use of Excel. And if you’re already an expert and you’re moving up to Excel 2007, this book will quickly show you features you’ve only dreamed of until now...”

—Thomas ‘Duffbert’ Duff, Duffbert’s Random Musings, http://www.twduff.com

Develop your Microsoft Excel expertise instantly with proven techniques

• Master Excel Ranges
• Create Powerful Arrays
• Troubleshoot Formula Problems
• Validate Worksheet Data
• Perform What-If Analysis
• Model Your Business
• Track Trends and Make
• Forecasts
• Analyze Data
• Find Optimal Solutions
• Build Dynamic Loan
• Schedules 

Most Microsoft® Excel users learn only a small percentage of the program’s features. They know they could get more out of Excel if they could just get a leg up on building formulas and using functions. Unfortunately, this side of Excel appears complex and intimidating to the uninitiated—shrouded in the mysteries of mathematics, finance, and impenetrable spreadsheet jargon.

Sound familiar? If you’re a businessperson who needs to use Excel as an everyday part of your job, then you’ve come to the right book.  Formulas and Functions with Microsoft® Office Excel 2007 demystifies worksheet formulas and presents the most useful Excel functions in an accessible,  jargon-free way.  This book not only takes you through Excel’s intermediate and advanced formula-building features, it also tells you why these features are useful to you and shows you how to use them in everyday situations. Throughout the book you’ll find no-nonsense, step-by-step tutorials and lots of practical examples aimed directly at business users.

     •    Focuses like a laser on the four technologies that you must master to get the most out of Excel: ranges, formulas, functions, and data analysis tools.

     •    Shuns spreadsheet theory in favor of practical know-how that you can put to use right away.

     •    Provides numerous real-world examples and techniques to help you learn and understand the importance of each section.

 

Introduction

1    Getting the Most Out of Ranges

2    Using Range Names

3    Building Basic Formulas

4    Creating Advanced Formulas

5    Troubleshooting Formulas
II    Harnessing the Power of Functions   

6    Understanding Functions

7    Working with Text Functions



Sample Content

Table of Contents

Introduction

    What’s in the Book

    This Book’s Special Features

    I    Mastering Excel Ranges and Formulas

1    Getting the Most Out of Ranges

    Advanced Range-Selection Techniques

        Mouse Range-Selection Tricks

        Keyboard Range-Selection Tricks

        Working with 3D Ranges

        Selecting a Range Using Go To

        Using the Go To Special Dialog Box

    Data Entry in a Range

    Filling a Range

    Using the Fill Handle

        Using AutoFill to Create Text and Numeric Series

        Creating a Custom AutoFill List

        Filling a Range

    Creating a Series

    Advanced Range Copying

        Copying Selected Cell Attributes

        Combining the Source and Destination Arithmetically

        Transposing Rows and Columns

    Clearing a Range

    Applying Conditional Formatting to a Range

        Creating Highlight Cells Rules

        Creating Top/Bottom Rules

        Adding Data Bars

        Adding Color Scales

        Adding Icon Sets

        From Here

2    Using Range Names

    Defining a Range Name

        Working with the Name Box

        Using the New Name Dialog Box

        Changing the Scope to Define Sheet-Level Names

        Using Worksheet Text to Define Names

        Naming Constants

    Working with Range Names

        Referring to a Range Name

        Working with Name AutoComplete

        Navigating Using Range Names

        Pasting a List of Range Names in a Worksheet

        Displaying the Name Manager

        Filtering Names

   &



Updates

Submit Errata

