Preface

Excel is everywhere, one of the most widely used desktop applications ever created. Over the years its power and versatility have grown, and so has its complexity. Today, most Excel users do not know all the things that it can do. There are plenty of good books that explain functions and features, but making Excel solve problems is not just a matter of learning new workbook functions or mastering Visual Basic. The real challenge is to understand what Excel's many features can accomplish, and especially how you can combine them to make your job easier.

Most of the chapters in this book start with a business problem or question, and then show how Excel can be used in that situation. Several of the chapters include complete applications that you can use and modify as you like. Each solution basically shows the reader how I would handle the problem. In nearly every case, Excel offers many ways to do things so the solutions presented are not the only option. You could produce solutions that do the same thing as the ones in this book using a different approach. This is not a manual and it doesn't include every workbook function. The object is to show the reader what can be done and to explain at least one way to do it.