About > AllExperts  
Search for
  Main Menu Ask a Question Browse Past Answers Meet Top Experts Be an Expert 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
KnowlClarityTimePolitenessDate
1010101012/03/08
1010101012/02/08
1010101012/01/08
1010101012/02/08
1010101012/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...
More Answers for "Excel"


Advertise on This Site | User Agreement | Privacy Policy | Kids' Privacy Policy
Copyright  © 2008 All rights reserved. AllExperts is a property of About, Inc.
The About logo, About and About.com are registered trademarks of About, Inc.