Answered by:
Cheapest and most effecitve study guide for Microsoft Excel 2007?

Question
-
Hello,
What is the cheapest and most effective study guide for Microsoft Excel 2007?
thank you,
Saturday, July 10, 2010 1:53 AM
Answers
-
I would buy Microsoft Office Excel 2007 self-study guide.
I always use self-study guide to prepare MS exams, this is the cheapest way to prepare. I have taken 12 MS exams so far since 1998 and this has always been my preferred study method.
Hope this help!
Thanks, Michael Mei- Marked as answer by Rubel Khan Sunday, July 25, 2010 4:08 AM
Monday, July 12, 2010 11:53 PM -
I would say Step by Step book: http://www.microsoft.com/learning/en/us/book.aspx?ID=9612&locale=en-us
Check Amazon, you can buy this very cheap.
Hope this is helpful.
Rubel Khan - MY BLOG!
If your question was truly answered, please mark it as Answered and Vote as helpful. Thank you in advance.- Marked as answer by Rubel Khan Sunday, July 25, 2010 4:08 AM
Saturday, July 10, 2010 2:15 AM -
I took and failed 70-602 2 weeks ago
I re-took it last week and passed.
No study guides or practice....ps I have more than a few certs already
This was all I needed to complete my MOS Master
You need basic knowledge and the advanced components cover functions
Know your functions - sum-counta-countif-avg
know how to sort, filter, remove duplicates, validate data, effect properties and data integrity.
the rest is basic functionality (MS tells us exactly what we need to know - MS learning)
I perused the ElementK book after the fact and it was reasonably thorough- Marked as answer by Rubel Khan Sunday, July 25, 2010 4:08 AM
Thursday, July 15, 2010 7:31 PM
All replies
-
I would say Step by Step book: http://www.microsoft.com/learning/en/us/book.aspx?ID=9612&locale=en-us
Check Amazon, you can buy this very cheap.
Hope this is helpful.
Rubel Khan - MY BLOG!
If your question was truly answered, please mark it as Answered and Vote as helpful. Thank you in advance.- Marked as answer by Rubel Khan Sunday, July 25, 2010 4:08 AM
Saturday, July 10, 2010 2:15 AM -
Thank you for you input!
So, if I buy this and do the worksheet, I should be prepared for the exam?
Saturday, July 10, 2010 3:01 AM -
That will sure give you the knowledge but have you ever taken any Office 2003 or 2007 exam. If not I would strongly recommend you to use a test prep to get familiar with the exam format. There are two which you may want to consider.
Certiprep from Certiport http://www.certiport.com/Portal/desktopdefault.aspx?page=common/pagelibrary/certiprep_home.html
Or MeasureUp.
Hope this is helpful.
Rubel Khan - MY BLOG!
If your question was truly answered, please mark it as Answered and Vote as helpful. Thank you in advance.Saturday, July 10, 2010 3:13 AM -
I would buy Microsoft Office Excel 2007 self-study guide.
I always use self-study guide to prepare MS exams, this is the cheapest way to prepare. I have taken 12 MS exams so far since 1998 and this has always been my preferred study method.
Hope this help!
Thanks, Michael Mei- Marked as answer by Rubel Khan Sunday, July 25, 2010 4:08 AM
Monday, July 12, 2010 11:53 PM -
Note that exam for Excel 2010 just came out on June 30, 2010.
http://www.microsoft.com/learning/en/us/Exam.aspx?ID=77-882&Locale=en-us#tab1
Below is for Excel 2007:
http://www.microsoft.com/learning/en/us/exam.aspx?ID=77-602&locale=en-us#tab3
I am a BI Consultant so I have been using Excel 2010 for the past few months.
The best way is to view what "Skills Being Measured" in the exam and to see what kind of books/trainings/mock exams you will need.
Thanks, Michael MeiTuesday, July 13, 2010 12:09 AM -
I took and failed 70-602 2 weeks ago
I re-took it last week and passed.
No study guides or practice....ps I have more than a few certs already
This was all I needed to complete my MOS Master
You need basic knowledge and the advanced components cover functions
Know your functions - sum-counta-countif-avg
know how to sort, filter, remove duplicates, validate data, effect properties and data integrity.
the rest is basic functionality (MS tells us exactly what we need to know - MS learning)
I perused the ElementK book after the fact and it was reasonably thorough- Marked as answer by Rubel Khan Sunday, July 25, 2010 4:08 AM
Thursday, July 15, 2010 7:31 PM -
Oh by the way - you can see this in greater detail -per Microsoft
check out MS website or certiport website for a list of exactly what 'may' be on the test.
MS has tons of training nuggets and little videos and short articles that can get you 90% of the way there
if you have general Excel knowledge
Thursday, July 15, 2010 7:34 PM