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.)

C & Data Structures
C & Data Structures

Divided into three separate sections, C & Data Structures covers C programming, as well as the implementation of data structures and an analysis of advanced data structure problems. Beginning with the basic concepts of the C language (including the operators, control structures, and functions), the book progresses to show these...

Crystal Reports 2008: The Complete Reference (Complete Reference Series)
Crystal Reports 2008: The Complete Reference (Complete Reference Series)

Your One-Stop Guide to Enterprise Reporting with Crystal Reports 2008

Transform disconnected corporate data into compelling, interactive business intelligence using all of the powerful tools available in Crystal Reports 2008. Through detailed explanations, real-world examples, and expert advice, this comprehensive guide...

Learning Docker - Second Edition: Build, ship, and scale faster
Learning Docker - Second Edition: Build, ship, and scale faster

Docker lets you create, deploy, and manage your applications anywhere at anytime – flexibility is key so you can deploy stable, secure, and scalable app containers across a wide variety of platforms and delve into microservices architecture

About This Book

  • This up-to-date edition...

Being Agile: Your Roadmap to Successful Adoption of Agile
Being Agile: Your Roadmap to Successful Adoption of Agile

Being Agile is your roadmap to successfully transforming your organization to an Agile culture. Veteran agile coach Mario Moreira teaches new adopters how to implement a robust Agile framework to derive from it the maximum business benefit in terms of customer value, revenue, and employee engagement. 

...
Angular 5 Projects: Learn to Build Single Page Web Applications Using 70+ Projects
Angular 5 Projects: Learn to Build Single Page Web Applications Using 70+ Projects

Learn to build single page web apps using Angular 5 and TypeScript by working through 70+ mini-projects. With hundreds of code examples you gain a thorough understanding of the Angular 5 ecosystem and how to work within it.

You'll begin by understanding the benefits of Angular 5 vs older versions, and how this...

Oracle SQL*Plus Pocket Reference (2nd Edition)
Oracle SQL*Plus Pocket Reference (2nd Edition)
SQL*Plus is available at every Oracle site--from the largest data warehouse to the smallest single-user system--and it's a critical tool for virtually every Oracle user. Despite its wide use, few developers and DBAs know how powerful a tool SQL*Plus can be.

This pocket reference provides quick reference information that will help you use...

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