Excel 2013 Formulas
- 10h 33m
- John Walkenbach
- John Wiley & Sons (US)
- 2013
John Walkenbach, known as "Mr. Spreadsheet," is a master at deciphering complex technical topics and Excel formulas are no exception. This fully updated book delivers more than 800 pages of Excel 2013 tips, tricks, and techniques for creating formulas that calculate, developing custom worksheet functions with VBA, debugging formulas, and much more.
- Demonstrates how to use all the latest features in Excel 2013
- Shows how to create financial formulas and tap into the power of array formulas
- Serves as a guide to using various lookup formulas, working with conditional formatting, and developing custom functions
- Shares proven solutions for handling typical (and not-so-typical) Excel formula challenges
From charts to PivotTables and everything in between, Excel 2013 Formulas is your formula for Excel success.
About the Author
John Walkenbach, arguably the foremost authority on Excel, has written 50+ books, including multiple editions of the bestselling Excel Bible and Excel Power Programming with VBA, as well as more than 300 articles for publications such as PC World, InfoWorld, and Windows. He created the award-winning Power Utility Pak, and provides Excel information and insight at spreadsheetpage.com.
In this Book
-
Introduction
-
Excel in a Nutshell
-
Basic Facts about Formulas
-
Working with Names
-
Introducing Worksheet Functions
-
Manipulating Text
-
Working with Dates and Times
-
Counting and Summing Techniques
-
Using Lookup Functions
-
Working with Tables and Lists
-
Miscellaneous Calculations
-
Borrowing and Investing Formulas
-
Discounting and Depreciation Formulas
-
Financial Schedules
-
Introducing Arrays
-
Performing Magic with Array Formulas
-
Importing and Cleaning Data
-
Charting Techniques
-
Pivot Tables
-
Conditional Formatting
-
Using Data Validation
-
Creating Megaformulas
-
Tools and Methods for Debugging Formulas
-
Introducing VBA
-
Function Procedure Basics
-
VBA Programming Concepts
-
VBA Custom Function Examples
