| Containing 277 business case studies that illustrate nearly every aspect of Excel, this book presents real-life business problems and works them through to their solutions. In addition to exemplary solutions, each case analysis considers alternate approaches and gotchas, and includes a summary of the necessary commands and functions. Excel files that can be downloaded and worked through step-by-step are included for each case.
In each chapter, a problem and its solution will be discussed. There are plenty of books that go through all of Excel’s menus in a serial fashion. The trouble with those books is that you have NO CLUE what to look up when you are having a problem. The last time I checked, no one at my dinner table ever used the word “CONCATENATION”, so why would anyone ever think of looking up that word when they want to join a fi rst name in column A with the last name in column B?
I expect this book will be a quick read. You can probably skim all 277 topics in a couple of hours to get a basic idea of what is in here. When you face a similar situation, fi nd the case study, apply it to your own problem, and you should be all set.
This book takes a different approach than others I have tried to use. I am MrExcel, but I am hopelessly clueless with PhotoShop. Wow! This is an intimidating program. I own a ton of books on PhotoShop. There must be a bazillion toolbars in there. Most books that I pick up tell me to press the XYZ button on the ABC toolbar. I can’t even begin to fi gure out where that toolbar is. I hate those books. So, my philosophy here is to explain the heck out of things. If you ever fi nd yourself on a case study where I tell you to do something without explaining how to do it, please send me an e-mail to yell at me for not being clear.
Each chapter will start with a problem and then a strategy for solving the problem. Various chapters may offer additional details, alternate strategies, results, gotchas, and other elements as is appropriate to the topic. Each chapter wraps up with a summary and a list of any Excel commands or functions used in the chapter.
I hate books where the text refers to a fi gure that is on the next two page spread. In the interest of readability, I’ve chosen to allow white space at the bottom of the right-hand page if it will allow the text and fi gure to remain together. This is a conscious decision. I’m not trying to pad the page count or increase the cost of paper in the book. I believe this layout will maximize the ease of use of the book.
About the Author Bill Jelen the principal of MrExcel.com and the author of Mr. Excel on Excel and Guerilla Data Analysis Using Microsoft Excel. He lives in Uniontown, Ohio. |
|
|
The Birth of Satan: Tracing the Devil's Biblical Roots"An informative study of the biblical origins of Satan…With resourceful though never excessive citation, Mobley and Wray make a good job of pinning down the roots of a notoriously protean character."--The Times Literary Supplement
"Let's admit it. Even in a secular age we are all still ... | | Encyclopedia of Finance
The Encyclopedia of Finance, Second Edition, comprised of over 1000 individual definitions and chapters, is the most comprehensive and up-to-date resource in the field, integrating the most current terminology, research, theory, and practical applications. Showcasing contributions from an international array of experts, the revised edition of... | | SamsTeachYourself TweetDeck
Do you like to tweet? Or follow other people’s tweets? Are you a heavy Facebook user? Do you like to follow your favorite entertainers on MySpace? Do you network with other business professionals on LinkedIn? If you engage in one or more of these activities, you know how time consuming the whole social networking thing can be. This is... |
|