Everyday Computing Advanced Computing The Internet At Home Health, Mind & Body Making & Managing Money Sports & Leisure Travel Beyond The Classroom
Handheld Computing
Hardware
Money Management Software
Multimedia
Office Productivity Software
Operating Systems
Excel Formulas and Functions For Dummies

Excel Formulas and Functions For Dummies


By Ken Bluttman, Peter G. Aitken

ISBN: 978-0-7645-7556-3
Format: Paper
Pages: 408 Pages
Pub. Date: January 2005

E-mail a Friend About This Book
Price: $24.99
Description
Author Information
Table of Contents
Read Excerpt: Chapter (PDF)
Read Excerpt: Index (PDF)
Read Excerpt: Table of Contents (PDF)
Introduction.

Part I: Getting Started with Excel Formulas and Functions.

Chapter 1: Understanding Fundamentals, Formulas, and Functions.

Chapter 2: Saving Time with the Insert Function Dialog Box.

Chapter 3: Understanding Array Formulas and Functions.

Chapter 4: Correcting Formulas.

Part II: Evaluating Loans and Investments.

Chapter 5: Calculating Loan Payments and Interest Rates.

Chapter 6: Performing Advanced Financial Calculations.

Part III: Working with Numbers.

Chapter 7: Using Math Functions to Figure Basic Math Answers.

Chapter 8: Getting More Advanced with Math.

Chapter 9: Using Descriptive Statistical Functions.

Chapter 10: Using Significance Tests.

Chapter 11: Using Prediction and Probability Functions.

Part IV: Working with Data.

Chapter 12: Working with Date Functions.

Chapter 13: Keeping Track with Time Functions.

Chapter 14: Using Lookup, Logical, and Reference Functions.

Chapter 15: Working with Information Functions.

Chapter 16: Working with Text Functions.

Chapter 17: Summarizing Data with Database Functions.

Part V: The Part of Tens.

Chapter 18: Ten + One Great Tips for Working with Formulas.

Chapter 19: Top Ten Functions You Must Know to Be an Excel Guru.

Chapter 20: Ten Cool Things to Do with the Analysis ToolPak Add-In.

Index.

Related Articles
Knowing How Crystal Xcelsius Works
Aligning and Positioning in Crystal Xcelsius
Creating a Visual Report in Microsoft Project 2007
Defining Excel Dashboards and Reports
Adding the Excel Camera Tool to the Quick Access Toolbar
Related Titles
Office 2007 For Dummies
Excel 2007 Data Analysis For Dummies
Microsoft Office Excel 2007 Formulas & Functions For Dummies
Microsoft Office Live For Dummies
Crystal Xcelsius For Dummies