We use cookies to provide essential features and services. By using our website you agree to our use of cookies .


Free Worldwide Shipping

Shop over 1 Million Toys in our Huge New Range

Microsoft Excel 2019 Formulas and Functions


Product Description
Product Details

Table of Contents

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

About the Author

Paul McFedries is an Excel expert and full-time technical writer. Paul has been authoring computer books since 1991 and has more than 95 books to his credit, which combined have sold more than 4 million copies worldwide. His titles include the Que Publishing books My Office 2016, Windows 10 In Depth (with coauthor Brian Knittel), and PCs for Grownups, as well as the Sams Publishing book Windows 7 Unleashed. Paul is also the proprietor of Word Spy (www.wordspy.com), a website devoted to lexpionage, the sleuthing of new words and phrases that have entered the English language. Please drop by Paul's personal website at mcfedries.com or follow Paul on Twitter, at twitter.com/ paulmcf and twitter.com/wordspy.

Ask a Question About this Product More...
Write your question below:
Look for similar items by category
Item ships from and is sold by Fishpond World Ltd.
Back to top