Getting Answers For Your Excel Questions

NOTE: Please do not reply to this post with a question. Read this post to see where and how to ask your question.

You’ve exhausted the built-in and online help provided by Microsoft, and don’t have what you need. So where do you go to get help in Excel?

There are a large number of resources available to you. Search engines, online forums, and a number of useful general Excel topic web sites, and a huge selection of Excel books.

What Have You Tried?

In What Have You Tried?, Matt Gemmell bemoans the questions from people who have not done their homework. Here are some preliminary suggestions from Matt to ensure that you are ready to be helped:

  • Have you broken the question or problem down sufficiently to really ask something concrete?
  • Is your problem the sort of standard question for which there’s definitely already some sample code and documentation available? Skim the documentation, or do a quick search.
  • Try searching the web. If you’re having trouble getting a decent result, you need to narrow things down. Someone else has probably asked your question – or maybe a hundred someones.

Direct Inquiries

It’s tempting to send an email directly to me or to another expert whose previous website or forum post has been helpful. I get a dozen or more unsolicited emails a week asking for general Excel help. I welcome questions and clarifications regarding topics posted on my web site, but I don’t often have the time (or motivation) to address emails out of the blue. It’s more effective to post a question on a forum with a broader audience (see below), because many more people will see the question, and several people will respond to a public post before a single busy individual even notices a stray email. I’d rather answer a public question, because it becomes part of the body of public knowledge, more people will see it, and Google will have a chance to pick it up.

Posting a question in a comment to an unrelated blog post is also not very effective. You’ll either have your comment deleted, or if you’re lucky you might get a link to a more relevant post. If you’re on someone’s blog, use their search box to find a more relevant post yourself.

Search Engines

Go to the source, Google. Search for a few related keywords. If the results aren’t what you need, they may at least give you ideas for better keywords. I even use Google to search Microsoft’s site. Use site:microsoft.com as one of your keywords to focus the search on microsoft.com.

Forums

There are a large number of forums devoted to Excel. For some reason, new forums keep popping up, even though a new forum lacks the core of experts and depth of archived information of an established forum. The established forums include Mr Excel, OzGrid, Excel Help Forum, Experts Exchange. I visit various forums from time to time to see if I can answer a few questions.

Choosing a Forum

Qualities of a good forum include:

  • Lots of traffic: dozens or hundreds of new threads each day.
  • A long history: archives extending back five years or more.
  • Recognized experts: members with designations indicating expertise (but watch out for too much game-like clutter, like badges and medals and point counts).
  • Relatively few unanswered threads.

How to Ask a Forum Question

  • Take a couple minutes to try Google first. Many questions have been asked and answered a thousand times before.
  • Spend a few minutes searching the forum’s archives.
  • Use a descriptive subject line. I skip posts with subjects like Help!! or Excel Question.
  • Write a concise and clear problem statement. State what you are trying to do, what steps you took, and what happened. (Sometimes framing a question well is enough to clarify the problem in your own mind, and you figure it out yourself.) If you get an error message, include the description in its entirety and not just the error number. Sure it’s an effort to retype it, but the error number may correspond to several different descriptions. Error number 1004 means a procedure halted during execution: very informative.
  • Include the Excel version somewhere in your problem statement.
  • Write clearly, DON’T TYPE IN ALL CAPITALS, don’t use text message shorthand LOL, proofread your post.
  • Don’t look for a button to upload your workbook. If you can’t describe your problem without attachments, most people won’t bother trying to answer. If someone wants more information, they will ask for a workbook.
  • Be courteous and patient. If your question isn’t answered within several hours or a day, reread the question.
  • Don’t bump your own post to bring it to the top of the list. Not everyone is in your time zone or takes breaks when you do, so let your question mellow until someone finds it. Also, adding a post to the thread, even just yourself bumping it, makes the thread look answered, so someone who is looking for unanswered questions will skip yours.

Why isn’t the Forum Answering My Question?

  • Is the subject line vague, as in I need excel help!!!?
  • Is it so simple that a Google search would have uncovered the answer in 60 seconds?
  • Is it written so poorly that nobody wants to try to decipher it?
  • Does it look too much like you want someone to do your homework?
  • Does it look like you’re asking for someone to do a whole project for free?
  • Is it written discourteously?

A Few Forums

Mr Excel is undoubtedly the best of the forums. Mr Excel receives more traffic than the rest, hosts a huge archive of solved issues, and has a large number of knowledgeable users willing to answer questions.

OzGrid used to be focused more on revenue than on the content of the forum, but this has improved in recent years. OzGrid has decent traffic, a good archive, and a number of experts who respond to posts.

While Mr Excel and OzGrid receive a meaningful amount of traffic, most other forums don’t seem to have critical mass.

StackOverflow and SuperUser, which are respectively developer- and power-user-targeted partner forums, have moderate amounts of Excel traffic, and I like the flow of their layout. They are relatively new, but their Excel traffic and archive are expanding.

Microsoft has a number of relevant forums, such as Microsoft Office ExcelExcel for Developers, and VBA. Microsoft’s used to host very good newsgroups, but they ditched the newsgroups in favor of their own forums. The early versions of the forums were unusable. (MS suffers from an incredible case of Not Invented Here, so they are continuously reinventing the wheel, and as we know, Wheel 1.0 is often square.)

The Microsoft forums have improved, and they get a huge amount of traffic, redirected no doubt from the helpless online help, but they lost most of their knowledgeable members when the newsgroups were liquidated. Instead, numerous helpdesk-style contractors respond semi-intelligibly on Microsoft’s behalf.

Excel Help Forum is somewhat active, but you can scroll through a few days’ new posts in just a couple minutes.

Experts Exchange is a good quality forum, but it’s a paid membership service, and its structure is very constraining. Plus it’s overly concerned about scoring answers, to the extent that once a responder got upset that I added to his answer, because he didn’t want to share points. Sheesh, if I’m trying to answer someone’s question, I care if the answer helped. Why do I need points to prove how smart I am?

VBA Express and XL Guru are of good quality, but unfortunately their traffic is too low. Tek-Tips has Office and VBA forums which are intermediate in quality and traffic.

LinkedIn has recently appeared on the scene with its forums. So far most of these these forums have had no value. Most members have no apparent experience with forums, have not developed forum etiquette, and ask dumb questions with answers found easily elsewhere. Then someone will give a lame answer as if it’s actually helpful, and seventeen others will respond with “Me, too!”

I once suggested that a member of a LinkedIn forum visit Mr Excel, and was told by several forum members that the personal interaction on the LinkedIn forum was a great feature. Uh, what? You get the same interaction on Mr Excel and the other forums, only it’s with smart people who can actually help. I no longer spend any time on the LinkedIn forums.

Specific Web Sites

There are a large number of useful Excel web sites and blogs. You’ll find most of them if you use Google well, and if you take note of who is answering questions on the forums. But here are a few noteworthy sites.

Chip Pearson’s Excel Source has hundreds of pages covering a wide variety of topics using worksheet formulas and VBA.

The Spreadsheet Page is John Walkenbach (Mr Spreadsheet)’s site filled with free tips, downloads, and other stuff, plus information about his books and other Excel products.

ExcelUser is Charley Kyd’s site directed toward business users of Microsoft Excel. ExcelUser has written about Excel dashboards, and offered dashboard-related products for Excel, since authors of other dashboard web sites were still in grade school.

Contextures is Debra Dalgleish’s site of Excel Tips and Tutorials. If you have a question about pivot tables, autofilters, conditional formatting, data validation, you’ll find the answer here.

Chandoo.org has a number of free and paid Excel learning resources by everyone’s favorite, Chandoo.

Excel Books

There are innumerable books on all aspects of working with Excel. I won’t list them here; instead I’ll direct you to my web page that lists the Excel Books that I own and actually use. (I own others that I don’t find useful, and I’ve left them off the list.) I update this book list every so often, when I’ve gotten a couple new books or when a new version of Excel has been released. Disclosure: the book page contains Amazon Affiliate links, as does the sidebar of this page, so if enough of you buy enough books, I’ll be able to start posting from exotic vacation destinations.

Peltier Tech Chart Utility

Comments

  1. Hi John,

    I’d like to add my blog into the mix as well if I may (www.tips-for-excel.com). I’m still working on expanding each tip and I’m starting to focus some tips that are aimed at helping digital marketers who use Excel. My Chart tips are not a patch on yours either(!) but hopefully I’ve helped out a few people so far.

  2. I would also add, please don’t bump your own posts. MrExcel allows this and it is annoying!

    I don’t sit on the forums all day long, I stop by every few days and do a search for “unanswered” posts (replies = 0). When you bump your own posts, you take them out of the unanswered queue, even though they technically remain unanswered. Not to mention that bumping is poor etiquette — not everyone is in your time zone. Also, you may have either a) asked a question so simple that Google could have solved it, or b) the question is so poorly worded that nobody can even begin to answer it.

  3. I prefer stack overflow just because of how well it was put together, using other forums is like going back in time.

    Great post, wish more people would find their questions on the web first, it is very rare that I need a question answered that hasn’t been answered in the past already. It’s also annoying when people ask questions that would basically require that you do the work for them, it’s like, are you going to pay me to do this for you?

  4. Chandoo.org/wp is also a good resource

  5. i need to fine water bill code using ms Excel
    =100 = 300 charge 10

  6. So read my guidelines above, and ask your question in a forum where it’s likely to be read.

  7. i have three column 1Employee Name, 2-Department Name, and 3rd is Present/Absent. now i want to know presents that how many presents in admin department or else
    example
    Employee Name Department Name Present/Absent
    Alex admin y
    jolie admin y
    amir R&d y
    laila admin n
    Direct civil n

  8. Please ask this in a forum.

  9. I am looking to change the color of text based on the value in an adjacent cell.
    Excel Starter 2010

    “If the value in cell B74 = “AP”, then change the font color in cell A74 to blue, if not = to “AP” then do nothing.”

    I have tried conditional formatting but I was only able to change the same cell not an adjacent one.

    Thanks in advance.
    Steve

  10. Select the cell whose formatting you wish to change.
    On the Home tab of the ribbon, click Conditional Formatting, select New Rule, then select “Use a formula…”.
    Write a formula describing the rule, related to the cell whose change you want to affect the cell you’re applying CF to.
    Define your format for when the formula is true.

  11. I want to start with a number(say 50) in a cell (say B4). Then put a number(say 5) in the cell B5 and have it subtract that number from cell B4 (50-5=45). Then I want to put a new number (say 7) in cell B5 and have it subtracted from the result of the first equation (45-7=38). I want to be able to repeat these step over and over. The answer to these equation would alway appear in the same cell.ie (B7).
    I am uanble to figure out how to write these formula in excel 2007.
    I would appreciate any help yon can give me.

    Thanks, Scott

  12. Ironically, you asked a question at the bottom of an article entitled “Getting Answers For Your Excel Questions” without heeding any of the suggestions in the article. Reread the article and try again. Hint: the question should not reappear in this blog, since it is unrelated to any topic that has ever appeared here.

  13. Wilfred Kurukulasuriya says:

    Hello Jon,
    I have been getting a lot of free help from your very useful Chart Utility. Thank you for being such an extrovert. I have not seen anywhere a solution to the following:
    I have two independent line charts (both series charts, not XY scatters) with stock price as the Y axis. (X axes are time series one with 4 hour intervals and the other with one hour intervals). Price range on 4 hour chart is much wider than that of 1 hour chart. I need to align the Y axes of both charts and lay them side by side by adjusting the size of the chart with the smaller price range. Can you help as you do always. Thank you and kind regards – Wilfred

  14. Names Sales What sales figures contains the numbers 1,1,2
    John 112 *
    Carl 102 John 112 Count
    Mike 123 Frank 121 3
    Frank 121 * Dave 211
    Sam 321
    Dave 211 *
    What formula in excel can I use to figure out the answer ?????????

  15. Tony –
    Please follow the guidelines in the article.

  16. Someone help me: I have spread sheet that use to track hours client used every two week and my employees hrs. For example: column1= week #1 hrs, column2= week #2 hrs, column3= total of week #1& week #2 hrs (for employees pay hrs) and last column4= track hours client use this year. I reuse same sheet every 2 week and I clear data from column#1 & #2 and automatically clears Colum3 & Column4 data. My question is how I can keep column4 data all the time(whole year). thanks

  17. Please reread this post, and actually follow the suggestions.
    In other words, don’t post general questions here.

  18. Jon just close the comments for this post, it seems to be drawing in the folks who find these posts and don’t read them.

  19. JP, Closing the comments would make it so I couldn’t have the occasional chuckle. I find it hilarious.

  20. In that case, carry on :)

  21. Priyabrata Sahu says:

    I have a lot of excel employee file month wise with same format one column as employee ID all files are in a single folder and I want to retrieve all the employee file data as per the employee ID in one excel file with the help of excel VBA any one help me

  22. Priyabrata –
    Reread the article, then follow its suggestions.

  23. I have made a formula based user entry form. the problem is that my first entry is not saved as soon as I change the inputs…..pls help me to save the previous records as well.

  24. I’m turning off comments to this post. Too many people don’t read the article, but just go straight to the comment to ask their questions.

    Read what I suggest, and go to an appropriate forum to ask your question.

Subscribe without commenting

Write a Comment

I welcome comments from my readers. If you have an opinion on this post, if you have a question, or if there is anything to add, I want to hear from you. Whether you agree or disagree, please join the discussion. If you want to include an image in your comment, post it on your own site or on one of the many free image sharing sites, and include a link in your comment. I'll download your image and insert the necessary html to display the image inline.

Subscribe without commenting

Peltier Tech Chart Utility

 

Create Excel dashboards quickly with Plug-N-Play reports.