Bill Hermanson - Excel - Business Software - Computing/Technology

About > AllExperts
	Search for

Main Menu

Login (Experts Only)

About Us · FAQ · Tell Friends About Us · Link To Us · Free Encyclopedia · Disclaimer · Tech Support

You are here: AllExperts > Computing/Technology > Business Software > Excel

Expert Profile: Bill Hermanson

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

Ask a Question	View Past Answers	View Ratings

What do you like about this subject? I love solving problems! The more complex, the better!

Something interesting about this subject that others may not know: Excel is more complex than your wildest dreams!

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.

Average Ratings
Prestige Points: 7420
Knowledge	9.89 Best of the best
Clarity of Response	9.70 Best of the best
Timeliness	9.83 Best of the best
Politeness	9.98 Best of the best
Number Of Questions (in Past 24 Hours)		0
Max Questions to be Asked (in 24 Hour period)		10
Total Questions (since joining AllExperts)		1039

Recent Reviews from Users

Knowl	Clarity	Time	Politeness	Date
10	10	10	10	12/03/08
10	10	10	10	12/02/08
10	10	10	10	12/01/08
10	10	10	10	12/02/08
10	10	10	10	12/02/08

User Comments

Excellent service.... Thank you very much. I am a fishery scientist. If I can ever donate my services, let me know.
(DANIEL on 12/03/08)

Bill, clarified that I needed to perform an operation in a certain matter. He answered my question quickly so that I can keep going. He provide me an
(Frank on 12/02/08)

Thanks for the great info. I researched the functions you suggested. Based on my knowledge this is quite cerative. Thanks for the tip on making the sp
(Rachael on 12/01/08)

Absolutely terrific advice. Really like this OFFSET function, will be using it loads now. The formulas weren't really a mistake, it's just that some w
(Simon on 12/02/08)

Yeh, I did laugh, thank you very much, your the best!!!
(Arno on 12/02/08)

View All Comments

Ask a Question	View Past Answers	View Ratings

Recent Answers from Bill Hermanson

2008-12-02 random assignment: Daniel, It is probably almost that simple. The random numbers will be between zero and one, so if you want, you can multiply them each by 100 and then TRUNC(number,0) to get integers from 0...

2008-12-02 IF functions: Arno, very good! You just have some extra parentheses which are confusing poor TRUNC. =TRUNC((((632-C16)/50)*35),(0)) should be =TRUNC( ( (632-C16) / 50) *35...

2008-12-02 Cell Formatting / Display: Frank, This is possible, but only via a running macro. In order for a cell to appear as 'cleared', without using a macro to actually clear it, there would have to be an equation in the cell...

2008-12-01 lookup function not working: Rich, You have undoubtedly messed up the VLOOKUP function by adding & deleting (and ESPECIALLY by MOVING) rows in your database. These type of operations are generally a no-no, but if you must do...

2008-12-01 if statment contains this then: Alex, What you want to do is called PARSING the text string. You can use various Excel TEXT functions to determine the location of significant parts of the string, extract them, and put them together...