Excel_Gurus_Gone_Wild__2009_.pdf

H OLY M ACRO ! B OOKS

PO Box 82, Uniontown, OH 44685

Excel Gurus Gone Wild

form or by any means, electronic or mechanical, including photocopying, recording,

or by any information or storage retrieval system without written permission from

the publisher.

All terms known in this book known to be Trademarks have been appropriately

capitalized. Trademarks are the property of their respective owners and are not

afﬁ liated with Holy Macro! Books

Every effort has been made to make this book as complete and accurate as

possible, but not warranty or ﬁ tness is implied. The information is provided on

an “as is” basis. The authors and the publisher shall have neither liability nor

responsibility to any person or entity with respect to any loss or damages arising

from the information contained in this book.

Printed in USA by Malloy

First Printing: March 2009

Author: Bill Jelen

Technical Editor: Bob Umlas

Editor: Kitty Wilson

Interior Design: Fine Grains (India) Private Limited, New Delhi, India

Cover Design: Shannon Mattiza, 6Ft4 Productions

Published by: Holy Macro! Books, 13386 Judy Ave, PO Box 82,

Uniontown OH 44685

Distributed by Independent Publishers Group

ISBN 978-1-932802-49-8

Library of Congress Control Number: 2008923727

ABOUT THE AUTHOR

Bill Jelen is the host of MrExcel.com and the author of 24 books. But

this book was really written by thousands of people who contributed to

the MrExcel.com message board or who have spoken up at one of my

Power Excel seminars with a cool trick. In many cases, new ideas at the

board happen through a collaborative process – someone asks a question,

others answer, others build on that answer, Someone posts something

simply amazing, more people build on the amazing concept, and then a

whole bunch of really talented Excel gurus will offer kudos for a really

slick solution. If you are one of the people who have participated in this

process, this this book is also written by you.

About the MrExcel Message Board: While MrExcel.com debuted on

November 21, 2008, the message board did not debut until 2009. Using a

script from Matt’s Script Archive, the original message board was born.

Bill wrote, “you can still keep sending your questions to me via e-mail, or

you can post them at the message board. And, if you happen to be at the

message board and see an easy question, give that person an answer.”

He ﬁ gured it would be sort of like the take-a-penny, leave-a-penny cup

that you see by the cash register. In the early months, Ivan Moala,

Dave and Cecilia became frequent regulars at the board. Today, over

100,000 people have signed up as members, there are many hundreds of

regulars, and six million unique visitors pass through the site annually.

The community at the MrExcel.com message board continues to provide

answers to 30,000 questions a year. In fact, with 365,000 answers

archived, it is likely that the answer to nearly any Excel question has

already been posted.

ACKNOWLEDGMENTS

Thank you to the entire community at the MrExcel.com message

board. This includes everyone who has posted a question, suggested an

answer and those who lurk without posting.

MrExcel.com was started in 1998. Over the years, a number of folks

have been on the payroll and helped grow the site: Anne Troy. Mala

Singh. Juan Pablo Gonzalez. Tracy Syrstad. Suat Ozgur. Far more

people volunteer and keep the community humming. Kristy Sharpe,

iii

Greg Truby, Nate Oliver, Paddy Davies, Richard Schollar, Chris Smith,

Suat Ozgur, Zack Barresse, Ivan Moala, Joe4, all volunteer as admins

and moderators.

Thanks to the pioneers – the ﬁ rst regulars, back when it might take

4 hours before Ivan Moala, Dave from Oz or Cecilia from the Paciﬁ c

Northwest would check in with an answer.

Mala Singh of XLSoft Consulting wrote the speedometer and

macroeconomic supply curve add-ins and does all of our engineering

projects (see examples at http://www.mrexcel.com/graphics.shtml). Mala

pitched in to help write up some topics in this book. Thanks to Mala for

helping to get the book to press.

Aladin Akyurek is the king of Ctrl+Shift+Enter formulas. Like

everyone else, I usually have to run his formulas through the Auditor

Toolbar’s Evaluate Formula feature before I can ﬁ gure out how it is

working, but they always impress. Aladin’s tireless formula examples

have raised many to the level of Excel guru.

This list could ﬁ ll an entire book, but thanks to the folks who answer a

lot of questions: Norie, Aladin Akyurek, Andrew Poulsom, Smitty, Jindon,

Erik.Van.Geit, Richardschollar, Vog, Jonmo1, Von Pookie, Paddyd,

Joe4, Barry Houdini, Juan Pablo González, Mark W., Yogi Anand,

HOTPEPPER, Peter_Sss, Just_Jon, Zack Barresse, Nateo, Fairwinds,

Tusharm, Tom Urtis, Greg Truby, Sydneygeek, Brian From Maui, Joe

Was, Lenze, Oaktree, Halface, Domenic, Brianb, Glennuk, Datsmart,

Donkeyote, Nimrod, Tom Schreiner, Rorya, Mikerickson, Pgc01, NBVC,

Acw, Onlyadrafter, Andrew Fergus, Daniels012, Tommygun, Tazguy37,

Steveo59l, Ivan F Moala, Schielrn, Texasalynn, Fazza, Barry Katcher,

Lewiy, Alexander Barnes, Phantom1975, Damon Ostrander, DRJ, Ralpha,

Domski, Mark O’Brien, Tactps, Stanleydgromjr, Mudface, Richie(UK),

Starl, Parry, Al_B_Cnu, Cbrine, Jack In The UK, Todd Bardoni, Jon

Von Der Heyden, Gerald Higgins, Iridium, Jon Peltier, Dougstroud,

Seti, Thenooch, Stormseed, Jaafar Tribak, Dk, PA HS Teacher, Xlgibbs,

Xld, Anne Troy, Ravishankar, Dave3009, Hatman, Jimboy, Barrie

Davidson, Venkat1926, Krishnakumar, Njimack, Jay Petrulis, Vicrauch,

Iliace, P Sitaram, Gates Is Antichrist, Oorang, XL-Dennis, Shajueasow,

Markandrews, RAM, Santeria, SIXTH SENSE, Giacomo, Chris Davison,

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika: