Excel/Expert Profile

Bill Hermanson

U.S.
Unavailable
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
  • Politeness 9.91
  • Response Time(hr) N/A
  • Response Time(hr, last 90 days) N/A
  • Number of Questions Today 0
  • Max Questions to be Asked in a Day 1
  • Total Questions (since joining AllExperts) 2686
  • Volunteer Since 2008-04-08
  • Prestige Points 21550

Recent Reviews from Users

Read More Comments

    K = Knowledgeability    C = Clarity of Response    P = Politeness
UserDateKCPComments
Russell12/30/09101010 
Andy11/12/09107 10Thanks very much for your assistance, I'll .....
Andy11/10/09107 8 Went to post a follow up, but .....
Terrence11/09/09101010you have done a wonderful job. thanks .....
Andy11/07/09109 10Hi Bill. Just wanted to say thanks .....

Recent Answers from Bill Hermanson

2009-11-11 Use of Macro in Excel:

Umesh,        In general, Macros are used to replace operations which can only be done by using the mouse and keyboard.  If you have repetitive task to perform, like updating a workbook every Friday, then

2009-11-10 How do I make IF statement is DATE Tue, Fri?:

Andy,         You should learn to use the excellent Excel function reference to answer this question.  It will explain the meaning of the '1' much better than I can.  Type the Fx symbol next to the formula

2009-11-10 How do I make IF statement is DATE Tue, Fri?:

Andy,        You can convert the date to a weekday number (0 to 6 , or 1 to 7) with the WEEKDAY() function.  Then, compare the result to a number (3= Tuesday) to get true or false.       =WEEKDAY(date

2009-11-09 Copy values from one sheet to the other:

Terrance,       You will use the VLOOKUP function to compare the characters (hopefully you mean WORDS) between W1 and W2.  VLOOKUP can compare words, find a match from one table to the next, and import

2009-11-07 Excel formula needed:

Mark,        Your problem is most likely more complex than a simple formula, especially given your last little statement, which indicates that you need to keep track of multiple dental appointments for

 

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

Excel

All Answers

Answers by Expert:

Ask Experts

Volunteer

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