Formulas and functions, Microsoft Excel 2010 /
MASTER CORE EXCEL 2010 TOOLS FOR BUILDING POWERFUL, RELIABLE SPREADSHEETS! Excel expert Paul McFedries shows how to use Excel 2010's core features to solve problems and get the answers you need! Using real-world examples, McFedries helps you get the absolute most out of breakthrough Excel 2010...
Saved in:
| Main Author: | |
|---|---|
| Format: | Electronic eBook |
| Language: | English |
| Published: |
[Indianapolis, Ind.] :
[Que Pub.],
[©2011]
|
| Series: | MrExcel library.
|
| Subjects: | |
| Online Access: | CONNECT |
Table of Contents:
- Cover13;
- Contents
- Introduction
- Whats in the Book
- This Books Special Features
- I: MASTERING EXCEL RANGES AND FORMULAS
- 1 Getting the Most Out of Ranges
- Advanced Range-Selection Techniques
- Data Entry in a Range
- Filling a Range
- Using the Fill Handle
- Creating a Series
- Advanced Range Copying
- Copying Selected Cell Attributes
- Clearing a Range
- Applying Conditional Formatting to a Range
- 2 Using Range Names
- Defining a Range Name
- Working with Range Names
- 3 Building Basic Formulas
- Understanding Formula Basics
- Understanding Operator Precedence
- Controlling Worksheet Calculation
- Copying and Moving Formulas
- Displaying Worksheet Formulas
- Converting a Formula to a Value
- Working with Range Names in Formulas
- Working with Links in Formulas
- Formatting Numbers, Dates, and Times
- 4 Creating Advanced Formulas
- Working with Arrays
- Understanding Array Formulas
- Using Array Constants
- Using Iteration and Circular References
- Consolidating Multisheet Data
- Applying Data-Validation Rules to Cells
- Using Dialog Box Controls on a Worksheet
- 5 Troubleshooting Formulas
- Understanding Excels Error Values
- Fixing Other Formula Errors
- Handling Formula Errors with IFERROR()
- Using the Formula Error Checker
- Auditing a Worksheet
- II: HARNESSING THE POWER OF FUNCTIONS
- 6 Understanding Functions
- About Excels Functions
- The Structure of a Function
- Typing a Function into a Formula
- Using the Insert Function Feature
- Loading the Analysis ToolPak
- 7 Working with Text Functions
- Excels Text Functions
- Working with Characters and Codes
- Converting Text
- Formatting Text
- Manipulating Text
- Removing Unwanted Characters from a String
- Extracting a Substring
- Searching for Substrings
- Case Study: Generating Account Numbers
- Substituting One Substring for Another
- Case Study: Generating Account Numbers, Part 2
- 8 Working with Logical and Information Functions
- Adding Intelligence with Logical Functions
- Case Study: Building an Accounts Receivable Aging Worksheet
- Getting Data with Information Functions
- 9 Working with Lookup Functions
- Understanding Lookup Tables
- The CHOOSE() Function
- Looking Up Values in Tables
- 10 Working with Date and Time Functions
- How Excel Deals with Dates and Times
- Using Excels Date Functions
- Using Excels Time Functions
- Case Study: Building an Employee Time Sheer
- 11 Working with Math Functions
- Understanding Excels Rounding Functions
- Case Study: Rounding Billable Time
- Summing Values
- MOD() Function
- Generating Random Numbers
- 12 Working with Statistical Functions
- Understanding Descriptive Statistics
- Counting Items with the COUNT() Function
- Calculating Averages
- Calculating Extreme Values
- Calculating Measures of Variation
- Working with Frequency Distributions
- Using the Analysis ToolPak Statistical Tools
- III: BUILDING BUSINESS MODELS
- 13 Analyzing Data with Tables
- Converting a Range to a Table
- Basic Table Operations
- Sorting a Table
- Filtering Table Data
- Referencing Tables in Formulas
- Excel82.
