Softpanorama

May the source be with you, but remember the KISS principle ;-)
Contents Bulletin Scripting in shell and Perl Network troubleshooting History Humor

Best Books about Excel Macro Programming

News Reviews Definitive Guide to Excel VBA Excel 2003 Power Programming with VBA Excel Programming Writing Excel Macros with VBA, 2nd Edition  
See also   Financial modelling Random Findings Humor Etc

Excel is a very powerful (and much underestimated) analytical tool that is as capable (or sometimes more capable) then many more expensive packages.  People view Excel as a spreadsheet program for mass users. It fills this role quite well but in its capabilities is not a regular consumer program, it is a powerful professional analytical tool disguised as a commodity spreadsheet.

There are very few good books about Excel programming (and generally advanced Excel usage).  I really hate John Walkenbach books, the author who actually almost monopolised the field.

Among few good books that are encounter I like Excel 2007 VBA Macro Programming by Richard Shepherd.

I once mistakenly bought weak and disorganized  Excel 2003 Formulas Books John Walkenbach. Excel 2003 Power as well as  Programming with VBA by the same author.  After that I really hate John Walkenbach books, the author who actually almost monopolized the field :-).  

Of course much depends on what are do actually doing with Excel. My experience is limited to simple financial modeling (although it does used complex recurrent formulas). 

Reviews

[Nov 4, 2006]Excel 2003 Formulas Books John Walkenbach

Very weak and expensive cookbook, November 4, 2006
 
Reviewer: Nikolai N Bezroukov "kievite" (Budd Lake, NJ) - See all my reviews
This is an eclectic collection of various recipies for Excel. This is a strange "lemmings" effect that the book has such a high rating on Amazon.

The book is essentially a badly written cookbook as it does not provide underling mechanics and key ideas behind the Excel formulas. Chapters are more or less disconnected and most of them can be read in any order.

At the end the reader is left with very new good findings that probably are not worth the price of the book.

Pagecount is very deceptive -- considerable part of the book is fluff -- brainless reproduction of basic things that one can find in help and that is not worth even one dollar. Many examples are very trivial and not worth reading.

Tricks like Appendix B are simply disgusting -- the author just copied the listing of functions that has no practical value whatsoever to inflate the pagecount.

Explanations mostly are extremely fuzzy. The author has real talent to make simple things complex and complex things impossible. Also this is just "do like I said" type of cookbook: the author never tries to explain concepts that are used (use of absolute adressing vs relative, the syntax intricacies of the second argument of countif and similar functions, etc)

Also the book suffers from frequent references to previous versions of Excel, which only distract the reader. One can assume that if the reader really wants to use one of the previous versions of Excel he can buy prev. edition of the book and save money.

In few places were things became more interesting they are also incomplete and/or incorrect (creation of your own VBA functions and collection of functions, usage of array functions like frequency, etc).

My impression is the author is just a book writer and does not have rich real world experience with Excel, the experience that is necessary to distinguish between important and trivial things.

As a result he cannot provide the reader any help in getting the grasp of underling architectural ideas, that are often very non-trivial (Excel is extremely powerful analytical tool disguised as a commodity spreadsheet).

NEWS CONTENTS

Old News ;-)

Business Analysis with Microsoft Excel, Third Edition (3rd Edition) (Business Solutions) Books Conrad Carlberg

by Conrad Carlberg

Microsoft Excel Data Analysis and Business Modeling by Wayne L. Winston

Microsoft Press

February 25, 2004 Non-Traditional Uses of Excell, May 24, 2005

Reviewer: Lena (Toronto, Canada) - See all my reviews
Overall, I like this book, even though it is somewhat confusing, both in scope and in the target audience.
The techniques of "naming the range" or writing the "if" formula are certainly targeted for beginners, but most of statistical tools are normally used by more advanced users.

The worst thing, though, is that the book is full of errors, both typos and mistakes in problem solutions on the disk. I consider myself an intermediate user, so finding an error in "instructor solution" was more like an additional challenge for me, but for the beginner this could be very frustrating.

On the positive side - I really liked the idea of problems in the end of each chapter; so many books just give you the theory and then you do not know how to solve a real life problem. For most of chapters, I knew the tools, but still had to spend time figuring out the best way to implement it for problem solving.

Very practical book, good for an intermediate users. Just be aware of the typos !
Reviewer: John Matlock "Gunny" (Winnemucca, NV) - See all my reviews
(REAL NAME)
This book is aimed at a level slightly higher than the total beginner. On page one, for instance he assumes that you understand the statement SUM(A5000:A5049) means. Then he points out that writing SUM(USSales) would make it easier to understand. He then describes how to name a range of cells -- Not exactly what I'd call advanced, but certainly above novice.

The first third, or so, of the book is on these kinds of slightly advanced procedures that you could get out of several Excell books. After that he kind of turns the approach around to things like "Estimating a Demand Curve." This is looking for what you want to do rather than just looking at a technique within Excell.

Many of his chapters have fairly sophisticated subjects, "Incorporating Qualitative Factors into Multiple Regression." In this chapter he then looks at multiple factors that might go into predicting things like predicting sales, predicting the Presidential race - with fairly surprising results.

In a couple of chapters he has a bit of fun, i.e. Chapter 73 is "Picking Your Fantasy Football Team."

Excell is quite a powerful package. It can be used for a lot of things beyond just filling out an expense account. In this book a lot of non traditional uses are described in a very light but informative manner. It is a very well done book. Very practical, but full of errors, April 2, 2007

[Nov 3, 2006] Professional Excel Development The Definitive Guide to Developing Applications Using Microsoft(R) Excel and VBA(R) (The Addison-Wesley Microsoft Technology Series) Books Stephen Bullen, Rob Bovey, John Green

A remarkable book on creating complete Excel-based apps, April 13, 2005
Reviewer: Raymond Lodato "grey geek" (Boston, MA) - See all my reviews
(REAL NAME)

Over the years, I've read a number of books on Excel programming. Each one seemed much like the previous one, generally talking about writing macros and creating data-entry forms. Professional Excel Development takes the concept quite a bit farther. Rather than giving you the same old tired lessons, this book goes into detail on exactly how to build professional level applications. It even explains how to make your Excel-based application look as though Excel had nothing to do with it. Suffice it to say, this ain't your daddy's Excel book.

The authors, Stephen Bullen, Rob Bovey, and John Green, show a level of sophistication well beyond the norm. They'd rather teach you the proper way to program instead of teaching you how to use Excel. In fact, the first thing they do is distinguish five different levels of usage: Excel users, Excel power users, VBA developers, Excel developers, and professional Excel developers. The book is written for the highest level, so expect a lot of depth. The entire structure of the book builds around a time-entry application that is developed from a simple spreadsheet to a full-blown, production quality program. A CD-ROM is also included with all of the source code and multiple examples that are scattered throughout the book.

Reading Professional Excel Development is not something to be taken lightly. The authors have done a fine job putting together a cohesive methodology for using Excel as an application development platform. I know of no other book that covers this platform in such depth. At times I found myself lost in the details, but I suspect a "professional Excel developer" (which I am not) would be delighted in the depth of description and copious examples provided.

Professional Excel Development is an extremely well-written book that covers the use of Excel to a depth few authors have dared to tread. The text gives you the tools to build applications that are much more than automated spreadsheets. Almost any program your imagination can devise can be created using the techniques given, which is a testimony to the power of Excel.

Bash Microsoft if you want, but they do sometimes come up with a winner, and Professional Excel Development allows you to take full advantage of its capabilities. I highly recommend this book...

Used and New Excel 2002 VBA Programmers Reference

Reviewer: Ruslan Moskalenko "Ruslan Moskalenko" (Pleasanton, CA United States) - See all my reviews
(REAL NAME) It's a great book! It actually consists of two parts: a brief but very useful VBA overview with all popular tricks and hints in the beginning and a deep and complete reference at the end. Normally you need to buy two separate books to get this coverage. This book can get you started in a few hours and answer virtually all your questions going forward. Really, really good!

If you are reading this review, buy this book now., December 2, 2003

Reviewer: Dennis Eichenlaub (Kingsville, MD United States) - See all my reviews
If you are interested enough to read this review, then buy this book. Now. I have done quite a bit of programming ... The only problem was, I had never programmed VBA/Excel and was having a very rough time getting started.

I bought "Excel 2002 VBA Programmer's Reference". I sat down and started reading Chapter 2. Before long, I was so excited that I was firing up my laptop. Four hours after I started reading the book, I had a prototype up and running. This book is amazing. Chapter 2 gave me more useful information than I sometimes get from an entire book. ...

The authors are simply bursting with knowledge and give it freely. Ideas are expressed clearly and succinctly. Knowledge is well-organized and easy to find. Whether you want to approach the topic methodically or flip through looking for gems, you will find what you want here.

Getting the object model is a great bonus. I'm going to enjoy spending a few days going through this one.

[Oct 25, 2006] Microsoft Excel Data Analysis and Business Modeling

by Wayne L. Winston

John Matlock "Gunny Non-Traditional Uses of Excell, May 24, 2005

This book is aimed at a level slightly higher than the total beginner. On page one, for instance he assumes that you understand the statement SUM(A5000:A5049) means. Then he points out that writing SUM(USSales) would make it easier to understand. He then describes how to name a range of cells -- Not exactly what I'd call advanced, but certainly above novice.

The first third, or so, of the book is on these kinds of slightly advanced procedures that you could get out of several Excell books. After that he kind of turns the approach around to things like "Estimating a Demand Curve." This is looking for what you want to do rather than just looking at a technique within Excell.

Many of his chapters have fairly sophisticated subjects, "Incorporating Qualitative Factors into Multiple Regression." In this chapter he then looks at multiple factors that might go into predicting things like predicting sales, predicting the Presidential race - with fairly surprising results.

In a couple of chapters he has a bit of fun, i.e. Chapter 73 is "Picking Your Fantasy Football Team."

Excell is quite a powerful package. It can be used for a lot of things beyond just filling out an expense account. In this book a lot of non traditional uses are described in a very light but informative manner. It is a very well done book.

Patrick B. Meegan Worthwhile in spite of shortcomings, May 26, 2006

I readily admit that the mistakes in the CD are an impediment to learning, but I think the book still has value for users who are looking for the application to business. Many of the CD's chapters were fine and proved very useful and I don't agree with other reviewers that the CD is flawed beyond use. Users of this book can glean a great deal from the unflawed majority of the book.

D. Lamont "cloud" CD has MANY, MANY mistakes...., August 25, 2004

The idea behind this book is great.

The book introduces and expands on many different 'useful' formulas and tools included within Excel.
The problems at the end of each chapter allows the reader to use what was just learned in developing spreadsheets to solve realistic accounting problems.

Even the 'above average' user of Excel, I believe, will learn from this book.

The CD even has an electronic version of the book, so you don't have to carry the book around everywhere.
The main problem: the CD STINKS !!!! It has MANY, MANY errors.
From forgetting to take into account given growth rates detailed in a problem (therefore yielding incorrect answers) to just plain sloppy copying of sheets (forgetting to delete the drawings and numbers not pertinent to the current sheet).
As said in a prior review, if an updated CD were to become available, with the CORRECT ANSWERS on it, this would be a definite 5 star.
(This said, perhaps finding the errors on the CD could be a means of developing your spreadsheets skills):)

"wallstbully11729" Great Book!! Very Useful, March 23, 2004

I love this book. This Book is a must for anyone who wants to learn how to use Excel to perform Data Analysis and Business modeling. I learned alot from this book. Winston shows us how to use Excel functions and shows us with examples. Plenty of examples and answers provided with the CD. This is a very good "foundational" book. You should also check out the book by Jackson and Staunton "Advanced modeling in finance using Excel and VBA". A book by Sengupta "Financial Modeling using Excel and VBA" is also worth looking at. I own all 3 books

Practical Management Science: Spreadsheet Modeling and Applications (with CD-ROM Update) by Wayne L. Winston

Edition: Hardcover 35 used & new from $19.45 7 of 7 people found the following review helpful:

Master Modeling employing Excel, September 23, 2005
This book focuses on several management science modeling problems and explains clearly how to implement them with Excel.

Winston teaches you how to employ standards (colors, borders, etc) to make your spreadsheet more professional. You will learn much about Excel even if you are not interested in management science models.

Contrary to Optimization and Operations Research books, it does not worry about algorithm details, being directed mainly to develop the student modeling skills.

And as a friend told me "I guess anything by this author is worth the money"

Then, if your goal is to find a text that contains excel-based ways of solving managerial problems, and you are not concerned with solver details (simplex method, transport algorithms, nonlinear programming algorithms, interior point methods) this book is for you.

Another information: Chris Albright has a Modeling book directed to people that want to learn how to use VBA in modeling, that is, if you are a "want to be advanced" Excel user. He says that his VBA book is the natural next step to "Practical Management Science".

Excel 2003 Power Programming with VBA (Excel Power Programming With Vba)

by John Walkenbach (Paperback - Jan 13, 2004)

An average book. For beginners only.

Excel Scientific and Engineering Cookbook (Cookbooks (O'Reilly)) Books David Bourg

Great showcase of Excel's mathematical capabilities, February 6, 2006
Reviewer: calvinnme "Texan refugee" (Fredericksburg, Va) - See all my reviews
It is often either inconvenient or financially unfeasible to solve every mathematical problem with a standalone procedural language or an expensive application such as Matlab or Mathematica.

Since Excel has such advanced computational capabilities built into it and is ubiquitous in offices and homes, it would make sense to mine this application for numerical problem solving techniques.

Bourg does a masterful job of presenting the tools available in Excel and showing the reader how to put them to work to solve real world engineering and mathematical problems.

First, he spends a couple of chapters briefly going over Excel and its language VBA (Visual Basic for Applications). Next he goes over some intermediate level tasks such as collecting and cleaning up data, charting including 3D charts, and statistical analysis tasks such as correlating data and generating random numbers.

Next Bourg moves into purely mathematical tasks such as working with discrete Fourier transforms, manipulating matrices and vectors, as well as working with basic mathematical functions.

Once you have learned to use these mathematical tools in Excel, Bourg uses them to show you how to perform curve fitting and regression, solve equations, perform integration and differentiation, and solve both ordinary and partial differential equations. He even spends time on performing multivariable calculus and the finite element method in Excel. Chapter 13, on optimization, was my favorite chapter.

Here, Bourg is actually getting into a little algorithm analysis and design via linear programming and genetic algorithms. This chapter showed me some truly innovative uses of Excel. The final chapter deviates from the scientific flavor of the book and concentrates on more traditional financial applications.

The writing is very accessible, the examples are clear and very creative, and the author does a tremendous job of capturing the range of Excel's mathematical capabilities. Do not expect mathematical theory in this book. Bourg assumes you already know how to set up a mathematical problem and that you just need a computational platform and tools with which to perform your work. It is nice to know I am not necessarily held hostage by Mathworks(maker of Matlab) every time I need to solve a mathematical problem of any level of sophistication. Highly recommended.

The table of contents is as follows:
1. Using Excel
2. Getting Acquainted with Visual Basic for Applications
3. Collecting and Cleaning Up Data
4. Charting
5. Statistical Analysis
6. Time Series Analysis
7. Mathematical Functions
8. Curve Fitting and Regression
9. Solving Equations
10. Numerical Integration and Differentiation
11. Solving Ordinary Differential Equations
12. Solving Partial Differential Equations
13. Performing Optimization Analyses in Excel
14. Introduction to Financial Calculations

Analyzing Business Data with Excel

by Gerald Knight

Definitive Guide to Excel VBA,

Definitive Guide to Excel VBA, Second Edition

by Michael Kofler, David Kramer (Translator)

5 out of 5 stars One of the definitive guides to Excel VBA books, August 21, 2002
Reviewer: Weiqin Xie (see more about me) from Plainsboro, NJ United States

I won't say this book is "the only Excel VBA book you will need" -- there is no such kind of thing for programming books. However, I like to say it is one of the best and definitive guides to Excel VBA.

The most important thing is that there are several advanced topics you won't find on the other popular Excel VBA books (such as Excel 2002 VBA programminer's Reference by Stephen Bullen, John Green et al. or Excel 2002 Power Programming with VBA by John Walkenback): for instance, recursion, details of random numbers generation, matrix functions, automatic data reporting, OLAP functionality and using Excel as ActiveX server.

However, I also must say this book is definitely not for the beginners to learn VBA. --This text refers to an out of print or unavailable edition of this title

About the Author
Michael Kofler was born in 1967 in Innsbruck, Austria. He completed his PhD in Computer Science at the Graz Technical University in 1998. Kofler has written a number of successful computer books on topics such as Visual Basic 5 and 6, Client/Server Databases with VB, VBA programming for Excel, Linux, Mathematica and Maple. --This text refers to an out of print or unavailable edition of this title.

 

4 out of 5 stars Good organization, a bit terse, January 4, 2001
 

  Reviewer: John Robert Brews from Santa Fe, NM
Probably the two books to compare with are Walkenbach's "EXCEL 2000 Power Programming", and Green's "EXCEL 2000 VBA". A related book that is a description of the language with nothing about the EXCEL object model is Lomax "VB & VBA in a Nutshell".

Kofler can be cryptic at times. As explanation, he says (p. 336) "The long and the short of it is that you [dear reader] will not be spared the opportunity to do a bit of experimenting yourself". An example of this brevity is the treatment of the MsgBox, which is used to interrogate the user of the spreadsheet and offer a variety of choices. Kofler provides an example on p. 220, and refers the reader to the online help for amplification. In contrast, Julitta Korol offers over 7 pages of examples and tables using this function. The pro of brevity is many features can be outlined, and the reader can find the additional info for free. The con is that the reader won't appreciate the full utility of the feature without perusing the online help in some detail.

Compared to Walkenbach,  Kofler has more about features new to EXCEL 2000. For instance, Kofler has subroutines illustrating the use of the Implements statement in VBA, while Walkenbach lists it as a statement with no comment, Green doesn't even mention it. Lomax has a complete discussion pp. 373 - 375. Kofler also describes the manipulation of files using the FSO (File System Objects) Library (pp. 245ff.), a new feature.

Compared to Green, Kofler is almost entirely exposition, while pp. 343-695 of Green is a listing of the EXCEL 2000 and VBE object models, which I personally find not too useful. However, because the first 245 pages of Green is compact, I find it easier to find information there.

Kofler definitely is a notch more advanced than Walkenbach, at least as knowledgeable, and much better organized. In fact, although there is a lot of overlap, it is handy to have both books because it is usually possible to find what you want in Kofler, and then (sometimes) use Walkenbach for a more detailed hand-holding example. However, finding something in Walkenbach by itself requires luck because of his poor organization and index.

None of the three EXCEL books describes the special status of sub main().

Bottom line: Buy Green first (cheapest), Kofler second and Walkenbach last. --This text refers to an out of print or unavailable edition of this title
 

4 out of 5 stars Great reference book!, August 21, 2003
 

  Reviewer: A reader from Kansas City, MO
This book has proved a life saver on more than one occasion. It is written in easy to understand language and organized in a way that doesn't force you to read the entire chapter to glean the one tidbit of information you were searching for. If you are looking for a tutorial style book, this isn't it, however if you are looking for a book that gives you answers quick - you're in luck. It has a thorough, helpful index. My one gripe is that I have found that the examples are a little scarce. I would like to see more examples of actual code. All in all, I am very pleased with my decision to purchase this book. --This text refers to an out of print or unavailable edition of this title  

5 out of 5 stars This book was my bible, June 12, 2003

  Reviewer: Michael R Mayer (see more about me) from Fort Worth, TX United States
This book was my bible for VBA & Excel while creating an application for work. I thought about getting Walkenbach's "EXCEL 2000 Power Programming", but my dad owned that one so I figured I could always borrow it if needed - but I never did need it.

I had not written a single line of Visual Basic or VBA prior to getting this book - I learned everything I needed here. (Although I had plenty of experience in C++/Java).

A few comments - I liked his style of mostly providing textual descriptions of all the different Excel classes, methods, and properties. There's not a lot of code in the book - but I never missed it. He provided clear enough descriptions of how to use the Excel object model, that I didn't need a ton of printed code to reinforce (don't get me wrong, there IS code within the book + the sample CD, just not pages and pages reflecting an entire application he's building up, like you get in a cookbook). If you prefer to just cut&paste code from a book into your own app, then you might be better off with Walkenbach's book.

The book was originally written in German and then translated to English, but I only remember one or two times where that became evident.

I wholeheartedly recommend this book.

Excel 2002 Power Programming with VBA

Excel 2003 Power Programming with VBA

by John Walkenbach (Author); Paperback 

An average book. For beginners only.
5 out of 5 stars Good for beginners and intermediate alike, June 13, 2003
 
  Reviewer: dansa28 (see more about me) from Dansa28, Whangarei, New Zealand
As someone who has some programming experience, this book was very helpful to me.
The project I am working on was already defined, and all I had to do was look in the books where an example was given or a syntax reference existed. Note that I used it in alongside O'Reilly Press' 'Writing Excel Macros with VBA'. Where certain areas aren't covered in this book (rare), there will almost certainly be something in the other.

As an intermediate level part-time but somewhat rusty programmer (mostly self-taught) of Java, C, Javascript, HTML, CSS, XML, Assembly and others, this book certainly had what I was looking for.

It offers useful language references and the descriptions are ample, although occasionally apparently useful methods that were covered in 'the other' book and were overlooked in this one; it's just not possible to include everything though, even in ~1000 pages.

It assumes some prior knowledge of programming techniques, and is therefore not for the absolute beginner, but will serve it's purpose very well indeed to the majority.

I would recommend this book all except the absolute beginner and the advanced programmer/expert (who probably wouldn't be reading this anyway!). Definitely worth the money.

I rarely buy books on the internet without having a good flick through them at the local bookshop first. In this case I would  advise likeminded thinkers to make an exception.

The included CDROM is worth it's weight in gold and is all too often a crucial ommission by authours/publishers. I can now take the book with me on my laptop in PDF format (hooray!) and all of the book examples are included too. BONUS!

3 out of 5 stars Very light in content. Cannot do much after reading it, July 25, 2003
 
  Reviewer: book_addict1 (see more about me) from SOMEWHERE
First of all, I am non-English speaker (forgive my English). I am an Electrical Engineer, not a programmer. But I have many years programming experiences in different languages (on my own!).

I have finished up to chapter 10. The contents is very light. It talks about very basic syntax that are almost the same in any language (e.g. C, Java, Perl C++...) It puts hundreds of pages that can be done in a half of the volume. It does not tell you much about the object details. It seems to tell you to explore the objects and methods by recording macro and learning by trial and error. If so, I don't need this book.

First of all, time is money. I spent money, time to read hundreds of pages. The author suggests you to trial and error. I really don't think it is a very good book. But I still give 3 stars (I am quite generous!)

Maybe most audiences of this book are never program in his/her life. This may be good for them. For someone who has experiences in programming. It is not very useful.

The author should really concentrate on objects and methods after some basic syntax. That is the most important. I can learn the syntax in few days. But I don't know much about all the objects and methods. Without knowing the objects and methods, nobody can do much. Just like learning English, you know all the syntax but you don't know any WORDS and USAGE. What do you think you can write!

Writing Excel Macros with VBA, 2nd Edition

Writing Excel Macros with VBA, 2nd Edition -- by Steven Roman; Paperback
Amazon price: $24.47

 2 out of 5 stars The Title of the Book has Been Mistaken, December 4, 2003
 Reviewer: J. Polihronov from London, UK

When I bought the book, I was impressed by its title and TOC since they give the promise of leading the reader into macro programming. However, it is rather a large-volume Excel/VBA reference, not a book on how to write macros.
Unfortunately, there is no system of introducing the reader gradually into the language (as in all usual programming textbooks) by introducing concepts, giving examples and requesting particular exercises.

On a positive note, the book contains (all) VBA concepts relevant to Excel macros and can very well serve as a future reference once the reader has bought another book to learn how to code within some range of macro programming.  

4 out of 5 stars VERY USEFUL COMPANION, June 13, 2003
 Reviewer: A reader from Dansa28, Whangarei, New Zealand

As someone who has some programming experience, this book was very helpful to me.

The project I am working on was already defined, and all I had to do was look in the books where an example was given or a syntax reference existed. Note that I used it in alongside Walkenbach's Excel 2002 Power Programming with VBA. Where certain areas aren't covered in this book (as it's only 500 pages), there will almost certainly be something in the other.

As an intermediate level part-time programmer (mostly self-taught) of Java, C, Javascript, HTML, CSS, XML, Assembly and others, this book certainly had what I was looking for.

It mainly offers concise language references and the descriptions are kept to the necessary, and this O'Reilly book is a vast improvement on some that I have bought for other languages in the past.

It does however assume some prior knowledge of programming techniques, and is therefore not for the beginner.
I would recommend THIS book only to those who have either a very keen interest in programming or those who have had some formal programming teaching. Definitely worth the money though.

Excel Dashboards

Excel® 2007 Dashboards & Reports For Dummies

By: Michael Alexander

Publisher: John Wiley & Sons

Pub. Date: March 04, 2008

 

Excel Programming

Excel 2007 VBA Macro Programming by Richard Shepherd.

VBA and Macros- Microsoft Excel 2010 (MrExcel Library)

Excel Programming: Your Visual Blueprint for Creating Interactive Spreadsheets (With CD-ROM)
by Jinjer Simon (Editor) (Paperback)
Avg. Customer Rating: 5.0 out of 5 stars
List Price: $26.99

Random Findings



Etc

FAIR USE NOTICE This site contains copyrighted material the use of which has not always been specifically authorized by the copyright owner. We are making such material available in our efforts to advance understanding of environmental, political, human rights, economic, democracy, scientific, and social justice issues, etc. We believe this constitutes a 'fair use' of any such copyrighted material as provided for in section 107 of the US Copyright Law. In accordance with Title 17 U.S.C. Section 107, the material on this site is distributed without profit exclusivly for research and educational purposes.   If you wish to use copyrighted material from this site for purposes of your own that go beyond 'fair use', you must obtain permission from the copyright owner. 

ABUSE: IPs or network segments from which we detect a stream of probes might be blocked for no less then 90 days. Multiple types of probes increase this period.  

Society

Groupthink : Two Party System as Polyarchy : Corruption of Regulators : Bureaucracies : Understanding Micromanagers and Control Freaks : Toxic Managers :   Harvard Mafia : Diplomatic Communication : Surviving a Bad Performance Review : Insufficient Retirement Funds as Immanent Problem of Neoliberal Regime : PseudoScience : Who Rules America : Neoliberalism  : The Iron Law of Oligarchy : Libertarian Philosophy

Quotes

War and Peace : Skeptical Finance : John Kenneth Galbraith :Talleyrand : Oscar Wilde : Otto Von Bismarck : Keynes : George Carlin : Skeptics : Propaganda  : SE quotes : Language Design and Programming Quotes : Random IT-related quotesSomerset Maugham : Marcus Aurelius : Kurt Vonnegut : Eric Hoffer : Winston Churchill : Napoleon Bonaparte : Ambrose BierceBernard Shaw : Mark Twain Quotes

Bulletin:

Vol 25, No.12 (December, 2013) Rational Fools vs. Efficient Crooks The efficient markets hypothesis : Political Skeptic Bulletin, 2013 : Unemployment Bulletin, 2010 :  Vol 23, No.10 (October, 2011) An observation about corporate security departments : Slightly Skeptical Euromaydan Chronicles, June 2014 : Greenspan legacy bulletin, 2008 : Vol 25, No.10 (October, 2013) Cryptolocker Trojan (Win32/Crilock.A) : Vol 25, No.08 (August, 2013) Cloud providers as intelligence collection hubs : Financial Humor Bulletin, 2010 : Inequality Bulletin, 2009 : Financial Humor Bulletin, 2008 : Copyleft Problems Bulletin, 2004 : Financial Humor Bulletin, 2011 : Energy Bulletin, 2010 : Malware Protection Bulletin, 2010 : Vol 26, No.1 (January, 2013) Object-Oriented Cult : Political Skeptic Bulletin, 2011 : Vol 23, No.11 (November, 2011) Softpanorama classification of sysadmin horror stories : Vol 25, No.05 (May, 2013) Corporate bullshit as a communication method  : Vol 25, No.06 (June, 2013) A Note on the Relationship of Brooks Law and Conway Law

History:

Fifty glorious years (1950-2000): the triumph of the US computer engineering : Donald Knuth : TAoCP and its Influence of Computer Science : Richard Stallman : Linus Torvalds  : Larry Wall  : John K. Ousterhout : CTSS : Multix OS Unix History : Unix shell history : VI editor : History of pipes concept : Solaris : MS DOSProgramming Languages History : PL/1 : Simula 67 : C : History of GCC developmentScripting Languages : Perl history   : OS History : Mail : DNS : SSH : CPU Instruction Sets : SPARC systems 1987-2006 : Norton Commander : Norton Utilities : Norton Ghost : Frontpage history : Malware Defense History : GNU Screen : OSS early history

Classic books:

The Peter Principle : Parkinson Law : 1984 : The Mythical Man-MonthHow to Solve It by George Polya : The Art of Computer Programming : The Elements of Programming Style : The Unix Hater’s Handbook : The Jargon file : The True Believer : Programming Pearls : The Good Soldier Svejk : The Power Elite

Most popular humor pages:

Manifest of the Softpanorama IT Slacker Society : Ten Commandments of the IT Slackers Society : Computer Humor Collection : BSD Logo Story : The Cuckoo's Egg : IT Slang : C++ Humor : ARE YOU A BBS ADDICT? : The Perl Purity Test : Object oriented programmers of all nations : Financial Humor : Financial Humor Bulletin, 2008 : Financial Humor Bulletin, 2010 : The Most Comprehensive Collection of Editor-related Humor : Programming Language Humor : Goldman Sachs related humor : Greenspan humor : C Humor : Scripting Humor : Real Programmers Humor : Web Humor : GPL-related Humor : OFM Humor : Politically Incorrect Humor : IDS Humor : "Linux Sucks" Humor : Russian Musical Humor : Best Russian Programmer Humor : Microsoft plans to buy Catholic Church : Richard Stallman Related Humor : Admin Humor : Perl-related Humor : Linus Torvalds Related humor : PseudoScience Related Humor : Networking Humor : Shell Humor : Financial Humor Bulletin, 2011 : Financial Humor Bulletin, 2012 : Financial Humor Bulletin, 2013 : Java Humor : Software Engineering Humor : Sun Solaris Related Humor : Education Humor : IBM Humor : Assembler-related Humor : VIM Humor : Computer Viruses Humor : Bright tomorrow is rescheduled to a day after tomorrow : Classic Computer Humor

The Last but not Least


Copyright © 1996-2016 by Dr. Nikolai Bezroukov. www.softpanorama.org was created as a service to the UN Sustainable Development Networking Programme (SDNP) in the author free time. This document is an industrial compilation designed and created exclusively for educational use and is distributed under the Softpanorama Content License.

The site uses AdSense so you need to be aware of Google privacy policy. You you do not want to be tracked by Google please disable Javascript for this site. This site is perfectly usable without Javascript.

Original materials copyright belong to respective owners. Quotes are made for educational purposes only in compliance with the fair use doctrine.

FAIR USE NOTICE This site contains copyrighted material the use of which has not always been specifically authorized by the copyright owner. We are making such material available to advance understanding of computer science, IT technology, economic, scientific, and social issues. We believe this constitutes a 'fair use' of any such copyrighted material as provided by section 107 of the US Copyright Law according to which such material can be distributed without profit exclusively for research and educational purposes.

This is a Spartan WHYFF (We Help You For Free) site written by people for whom English is not a native language. Grammar and spelling errors should be expected. The site contain some broken links as it develops like a living tree...

You can use PayPal to make a contribution, supporting development of this site and speed up access. In case softpanorama.org is down you can use the at softpanorama.info

Disclaimer:

The statements, views and opinions presented on this web page are those of the author (or referenced source) and are not endorsed by, nor do they necessarily reflect, the opinions of the author present and former employers, SDNP or any other organization the author may be associated with. We do not warrant the correctness of the information provided or its fitness for any purpose.

Last modified: October 20, 2015