Author Description

This is an in-depth look at the topics from Bill's Power Excel Seminar. In the process of solving 512 real-world business problems, you will learn how to use Excel more efficiently than you ever thought possible. The new topics include features unique to Excel 2010, and new techniques available in all versions of Excel. 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 512 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". Of the 195 new topics, you will find that 44 of them are applicable to Excel 2010 only. However, throughout the book, you will find 151 brand new tips that will apply equally well to Excel 2007 through Excel 2010. - Publisher.