will introduce you to the exciting new pivot table features in Excel 2007. Create quick summaries and pivot charts, add impact with traffic light icons, design calculated fields, group dates and numbers.
Get Free Help With Your Excel Problems
Here’s a favourite message from my mailbox this week:
Subject: help me in excel
Dear sir,
I have a problem in excel i requesting to you solve this. I am sending the data of excel sheet pls look in to that
If you have want any information on that please get back to me
I am waiting for your replyRegards
Anonymous
Those “Dear Sir” emails make me feel like Peppermint Patty. At least the attached Excel file was small, unlike some of the multi-megabyte files I’ve been sent.
Sorry Anonymous, but I can’t help with your Excel problem today. My desk is piled high with work, and I won’t have any extra time to decipher your file.
Where to Get Help
Fortunately, there are places where Anonymous, or you, can get free help with your Excel problems, or ask questions about other Microsoft products.
- You can post questions in the Microsoft newsgroups, which provide free peer-to-peer support for most Microsoft products.
- Nick Hodge hosts the Excel User Group, which has a very helpful forum for Excel questions.
- You could even post a short cry for help in Twitter, and it’s likely that someone will respond.
These are much better options than emailing me, and asking for private help. Why?
- There are people reading those messages 24 hours a day, 7 days a week – you have a much better chance of getting a quick reply.
- Thousands of people are reading the messages, and probably some of them are experts in the area where you need help.
- Responses are usually very quick, and you’ll sometimes get multiple replies, giving you a variety of solutions.
- When you post a question and get a response, it might help someone else who has the same question later. They can find your question and answer by searching in Google.
Good luck, Anonymous! I hope you find someone who can help with that Excel question.
_______________________
June 24th, 2009 at 7:22 am
Debrah,
I am a friend of Roger Govier - met him in London a few years back. I've tried to contact him recently and get no response. Is he okay, or maybe ill?
Regards,
Phil
June 24th, 2009 at 9:15 am
Phil, all's well with Roger, as far as I know. I emailed him to let him know that you're trying to get in touch.
Debra
June 24th, 2009 at 9:23 am
Thanks Debra, and apologies for misspelling your name.
June 24th, 2009 at 10:50 am
My favorite is the follow-up email guy. You know, the one that writes:
"Did you get a chance to look at my file? What's the status on that file I sent."
I'll try to help with quick fixes, but sorry, I can't build the next PeopleSoft in Excel.
June 24th, 2009 at 11:08 am
Gee Mike, are you slipping? I was expecting that PeopleSoft Excel release last week
Maybe I'll try it myself - should only take 4 or 5 hours. I'll follow up with you if it doesn't work. (Again with the :-))
June 24th, 2009 at 7:22 pm
You should have just sent a link to your book on Amazon. NEVER miss a sales opportunity.
June 25th, 2009 at 9:32 am
I think you are "Anonymous" ...
August 5th, 2009 at 12:02 am
[...] do you go when you’ve got an Excel question? A while ago, I recommended the Excel newsgroups as a great place to ask questions and get one (or several) solutions. Is that what you use, or [...]
March 25th, 2010 at 6:02 pm
i have problem using excel vba code for data entry in range to offset a row in 2 columns via userform (e.g)
Receipt Payment
Row1 1250 Leave this cell empty
Row2 100 Leave this cell empty
Roow3 leave empty cell 200
June 30th, 2010 at 12:07 am
[...] }); } In the past, I highly recommended the Excel newsgroups as a place to go for help. Earlier this month, Microsoft shut down their newsgroup servers, where [...]
July 1st, 2010 at 2:26 pm
[...] the past, I highly recommended the Excel newsgroups as a place to go for help. Earlier this month, Microsoft shut down their newsgroup servers, where [...]
July 19th, 2010 at 4:46 am
Case 1 Column E Column H Column I ColumnJ Column L
fx102030 4-Jul-10 1-Jan-10 31-Jan-10 52
bm405060 3-Mar-10 1-Feb-10 28-Feb-10 48
1-Mar-10 31-Mar-10 51
1-Apr-10 30-Apr-10 50
1-May-10 31-May-10 46
1-Jun-10 30-Jun-10 49
1-Jul-10 31-Jul-10 55
1-Aug-10 31-Aug-10 43
1-Sep-10 30-Sep-10 42
1-Oct-10 31-Oct-10 47
1-Nov-10 30-Nov-10 54
1-Dec-10 31-Dec-10 53
If the dates in column "E" falls within the date range in column "H" and "I" then the rates in column "J" should come in Column "L"
July 19th, 2010 at 4:49 am
oops
the question didnt come properly because of the format
can any one provide your email address so that i can forward you the same question
awaiting your reply
Hanif Ahmed
my email is hanif_ahmed80@hotmail.com
please write in subject "excel help"