Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
Learn Excel from Mr. Excel: 277 Excel Mysteries Solved

Buy
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.
(HTML tags aren't allowed.)

Beginning Perl
Beginning Perl
That was the subtitle for this book that was sadly, but wisely, rejected. However, it conveys two things about this book that I’ve tried to focus on: getting a job and having fun while learning the skills you need. Well, as much fun as you can reasonably have while learning how to program. Although many books aren’t...
Service-Oriented Architecture (SOA): A Planning and Implementation Guide for Business and Technology
Service-Oriented Architecture (SOA): A Planning and Implementation Guide for Business and Technology

In 2002, Web services were a hot topic and the concept of serviceoriented architecture (SOA), while not a new idea, was beginning to pick up steam. It did not take long for organizations to realize that Web services mandated the concept and organizational model of SOA to guide their selection, design, implementation, and management....

Energy Efficient Servers: Blueprints for Data Center Optimization
Energy Efficient Servers: Blueprints for Data Center Optimization

Energy Efficient Servers: Blueprints for Data Center Optimization introduces engineers and IT professionals to the power management technologies and techniques used in energy efficient servers. The book includes a deep examination of different features used in processors, memory, interconnects, I/O devices, and other...


The Birth of Satan: Tracing the Devil's Biblical Roots
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
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
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...

©2021 LearnIT (support@pdfchm.net) - Privacy Policy