This is the PDF edition of "Power Excel with MrExcel" - by Bill Jelen. Master Pivot Tables, Subtotals, Charts, VLOOKUP, IF, Data Analysis in Excel 2010-2013.
Each of the 567 featured topics has a problem statement and description, followed by a broad strategy for solving the problem. 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?