Book Description
Master core Excel 2013 tools for building powerful, reliable spreadsheets!
Excel expert Paul McFedries shows how to use Excel 2013’s core features to solve problems and get the answers you need. Using realworld examples, McFedries helps you get the absolute most out of features and improvements ranging from FlashFill to Excel’s newest functions. Along the way, you discover the fastest, best ways to handle essential daytoday tasks ranging from generating account numbers to projecting the impact of inflation.
Becoming an Excel expert has never been easier! You’ll find crystalclear instructions; insider insights; even complete stepbystep projects for building timesheets, projecting cash flow, aging receivables, analyzing defects, and more..
• Quickly create powerful spreadsheets with FlashFill
• Use conditional formatting to instantly reveal anomalies, problems, or opportunities
• Analyze your data with standard tables and PivotTables
• Use complex criteria to filter data in lists
• Understand correlations between data
• Perform sophisticated whatif analyses
• Use regression to track trends and make forecasts
• Build loan, investment, and discount formulas
• Validate data, troubleshoot problems, and build more accurate, trustworthy spreadsheets
About MrExcel Library: Every book in the MrExcel Library pinpoints a specific set of crucial Excel tasks and presents focused skills and examples for performing them rapidly and effectively. Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these books will
• Dramatically increase your productivity—saving you 50 hours a year or more
• Present proven, creative strategies for solving realworld problems
• Show you how to get great results, no matter how much data you have
• Help you avoid critical mistakes that even experienced users make
CATEGORY: Spreadsheets
COVERS: Microsoft Office Excel 2013
Table of Contents
 Title Page
 Copyright Page
 Contents at a Glance
 Contents
 About the Author
 Dedication
 Acknowledgments
 We Want to Hear from You!
 Reader Services
 Introduction

Part I. Mastering Excel Ranges and Formulas
 1. Getting the Most Out of Ranges
 2. Using 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
 From Here
 4. Creating Advanced Formulas
 5. Troubleshooting Formulas
 Part II. Harnessing the Power of Functions
 Part III. Building Business Models
 Part IV. Building Financial Formulas
 Index
Product Information
 Title: Excel® 2013 Formulas and Functions
 Author(s):
 Release date: February 2013
 Publisher(s): Que
 ISBN: 9780133260717