Excel 2013 Formulas and Function

Description

Aster core Excel 2013 tools for building powerful, reliable spreadsheets!

Excel expert Paul McFedries shows how to use Excel 2013s core features to solve problems and get the answers you need. Using real-world examples, McFedries helps you get the absolute most out of features and improvements ranging from FlashFill to Excels newest functions. Along the way, you discover the fastest, best ways to handle essential day-to-day tasks ranging from generating account numbers to projecting the impact of inflation.

Becoming an Excel expert has never been easier! You’ll find crystal-clear instructions insider insights even complete step-by-step projects for building timesheets, projecting cash flow, aging receivables, analyzing defects, and more.

Key Features

• The power users guide to building powerful, reliable spreadsheet models with Excel 2013 data analysis tools, formulas, functions and lists!
• No-nonsense, step-by-step tutorials and practical examples from a world-renowned expert in demystifying complex technology, Paul McFedries
• Thoroughly updated to reflect Excel 2013s newest and best improvements
• Includes specific techniques for analyzing complex data, modeling business problems, tracking trends, making forecasts, and building financial formulas
• Part of the popular MrExcels Library series, edited by Excel legend Bill Jelen

Table of Contents

1. Part I: Mastering Excel Ranges and Formulas
   1. Chapter 1 Getting the Most Out of Ranges
   2. Chapter 2 Using Range Names
   3. Chapter 3 Building Basic Formulas
   4. Chapter 4 Creating Advanced Formulas
   5. Chapter 5 Troubleshooting Formulas
2. Part II: Harnessing the Power of Functions
   1. Chapter 6 Understanding Functions
   2. Chapter 7 Working with Text Functions
   3. Chapter 8 Working with Logical and Information Functions
   4. Chapter 9 Working with Lookup Functions
   5. Chapter 10 Working with Date and Time Functions
   6. Chapter 11 Working with Math Functions
   7. Chapter 12 Working with Statistical Functions
3. Part III: Building Business Models
   1. Chapter 13 Analyzing Data with Tables
   2. Chapter 14 Analyzing Data with PivotTables
   3. Chapter 15 Using Excels Business-Modeling Tools
   4. Chapter 16 Using Regression to Track Trends and Make Forecasts
   5. Chapter 17 Solving Complex Problems with Solver
4. Part IV: Building Financial Formulas
   1. Chapter 18 Building Loan Formulas
   2. Chapter 19 Building Investment Formulas
   3. Chapter 20 Building Discount Formulas

Author Biography

Paul McFedries is an Excel expert and full-time technical writer. Paul has been authoring computer books since 1991 and has more than 80 books to his credit, which combined have sold more than four million copies worldwide. His titles include the Que Publishing books Windows 8 In Depth (with coauthor Brian Knittel), PCs for Grownups, and Tweak It and Freak It: A Killer Guide to Making Windows Run Your Way, as well as the Sams Publishing book Windows 7 Unleashed.