Bille Jelen

Bestselling Author of 20+ Microsoft Excel books

We may earn commissions for purchases made via this page

Book Recommendations:

Recommended by Bille Jelen

The authors give great examples of each function in the book. The first page for each function shows the syntax for the function. The following pages that show examples of the functions in use are very handy. I love that they cover functions that everyone wants but don't yet exist: 'Is there a BETWEEN function? Not yet, but here is how to do it with existing functions.' This shows they have a deep level of understanding of Excel's gaps and what people want to do with Excel. (from Amazon)

101 Most Popular Excel Formulas (101 Excel Series) book cover

John Michaloudis, Bryan Hong(you?)

Learn the Most Popular Excel Formulas Ever: VLOOKUP, IF, SUMIF, INDEX/MATCH, COUNT, SUMPRODUCT plus Many More! With this book, you’ll learn to apply the must know Excel Formulas & Functions to make your data analysis & reporting easier and will save time in the process. With this book you get the following: ✔ 101 Ready Made Formulas Covering: LOOKUP, LOGICAL, MATH, STATISTICAL, TEXT, DATE, TIME & INFORMATION ✔ Easy to Read Step by Step Guide with Screenshots ✔ Downloadable Practice Workbooks for each Formula with Solutions ✔ New Excel Formulas For Excel 2019 & Office 365 ✔ You also get a FREE BONUS downloadable PDF version of this book! ✔ Exclusive to Hardcover: You also get a FREE BONUS 20+ Hour Excel Course with 77 video tutorials! This book is a MUST-HAVE for Beginner to Intermediate Excel users who want to learn Excel Formulas FAST & stand out from the crowd!