Many Excel books try to go in a serial fashion through every single Excel option. These books are tough to use. No one at my dinner table ever uses the word “concatenation” in dinner conversation. How would you know to turn to the chapter on concatenation when you need to learn how to join a column of first names with a column of last names?

This book offers 654 real-life business problems. Each topic starts with a problem and then provides a strategy for solving the problem. Some topics may offer additional details, alternate strategies, results, gotchas, and other elements, as appropriate to the topic. You will never have to go hunting for “Concatenation”. Instead, turn to the topic on “How to join two text columns”.

Updated to include features through early 2019. Updates include Dynamic Arrays (SORT, FILTER, UNIQUE), Geography Data Types, Stock Data Types, and Column from Examples in Power Query.

If you use Excel 20-40 hours per week, you will save 50 hours a year with the tips in this book.