Excel/Expert Profile

Bill Hermanson

U.S.
Maxed Out
Expertise

Please tell me WHICH EXCEL VERSION you are using!

DO NOT ASK ME me about Macros or VBA.

Please read my "instructions to questioners" in my full profile [use View Profile, at right], to help you write a question that I can understand, without having to ask you what you mean.

If your question contains any of the words THIS, IT, THAT, THOSE, or THEY, I likely won't understand IT. Please rewrite!

My Expertise: I am an expert at data manipulation, the use of incredibly complex logical statements, databases, combining tables and extracting data, all the LOGICAL, LOOKUP & REFERENCE functions, dynamic ranges, creating professional appearing spreadsheets, complex functions, integrated charts and visual displays, user interfaces.... I can make Excel do anything!

But PLEASE... NO MACRO or VBA QUESTIONS!

Experience in the area

25 years development of complex spreadsheets for personal and professional use. I've developed hundreds (or thousands!) of spreadsheets in all fields, from complex engineering calculations to game scoring, financial analysis, scheduling, cost-of-doing-business, and analysis of home energy use. I even used Excel to assist in design of the flight computers presently on board the Hubble Space Telescope (1984-1991)

Education/Credentials

BSEE Electrical Engineering, CU Boulder CO USA
Use of spreadsheets since 1982
Boulder Valley School District, Life Long Learning, Instructor
Owner & Operator of Excel Expert, LLC

What do you like about this subject?

I love solving problems! The more complex, the better!

What do you still hope to achieve/learn in this field?

There is so much to know about Excel, I am constantly discovering new tricks, techniques, and functions.

Something interesting about this subject that others may not know:

Excel is more complex than your wildest dreams!

Something controversial or provocative about this subject

Most people resort to macros when they can't figure out how to use the equations. In most cases macros aren't needed.

Average Ratings

  • Knowledgeability 9.87
  • Clarity of Response 9.67
  • Timeliness 9.85
  • Politeness 9.91
  • Number of Questions (in Past 24 Hours) 1
  • Max Questions to be Asked (in 24 Hour Period) 1
  • Total Questions (since joining AllExperts) 2675
  • Volunteer Since 2008-04-08
  • Prestige Points 21420

Recent Reviews from Users

Read More Comments

    K = Knowledgeability    C = Clarity of Response    T = Timeliness    P = Politeness
UserDateKCTPComments
Andy11/07/09109 1010Hi Bill. Just wanted to say thanks .....
Len11/03/0910101010Perfect, thanks Bill
Tim10/29/0910101010Not the answer i wanted but it .....
Isabella10/25/0910101010right on thanks SO MUCH Bill. Youve .....
Carrie10/24/0910101010Thanks!! Terrific answer; would never have known .....

Recent Answers from Bill Hermanson

2009-11-06 Finding a value in a column:

Andy, Take a look at MATCH and INDEX. MATCH() can look down the column and return the row number (relative to the top of the column, not the absolute row number of the sheet) which contains the

2009-11-05 Filling blank cells according to specified weighting:

Rob, I have the impression that once you have this column of heads and tails, you are going to do something else with it... some other calculation that you didn't identify. It may not be necessary

2009-11-03 Excel totaling catorgories:

Kevin, You can use the SUMIF function to do exactly this. I shouldn't have bother to ask about Excel versions, because SUMIF exists in both 2003 and 2007. Use the multiple-range form of

2009-11-02 Conditional Format:

Len, Its easy to do this with Excel 2007, as well as with 2003. Select the cells you want to format... ALL of them. Then open the CF (Conditional Formatting) ribbon option. Choose New

2009-10-30 Excel Counting the max amount of consecutive positive numbers:

Ed, You need to add a column of Logical Equations next to your column of numbers. each logical equation will say: "IF the number to the left is POSITIVE, increment the number above me by

 

Ask A Question

About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here

All Answers

Answers by Expert:

Ask Experts

Volunteer

©2009 About.com, a part of The New York Times Company. All rights reserved.