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
SHOW MORE
FREE ACCESS

YOU MIGHT ALSO LIKE

Course Finding and analyzing data with formulas in Excel 365
Rating 4.5 of 449 users Rating 4.5 of 449 users (449)
Book Mastering Advanced Excel - With ChatGPT Integration: Learn Formulas and Functions, Advance Pivot Tables, Macros, VBA Coding, ChatGPT Integration with Exercises
Course Entering data in Excel 365 (2023)
Rating 3.9 of 21 users Rating 3.9 of 21 users (21)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Building Presentations in PowerPoint iPad
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Course Creating PivotTables and PivotCharts in Excel 365
Rating 4.4 of 438 users Rating 4.4 of 438 users (438)
Course Complete Guide to Excel 365: Validating, Cleaning, & Performing Lookups on Data
Rating 4.6 of 538 users Rating 4.6 of 538 users (538)