locked
Cheapest and most effecitve study guide for Microsoft Excel 2007? RRS feed

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


    http://www.amazon.com/Microsoft-Official-Academic-Course/dp/0470164840/ref=sr_1_2?ie=UTF8&s=books&qid=1278978329&sr=8-2

    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.


    http://www.amazon.com/Microsoft-Official-Academic-Course/dp/0470164840/ref=sr_1_2?ie=UTF8&s=books&qid=1278978329&sr=8-2

    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 Mei
    Tuesday, 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