Cheapest and most effecitve study guide for Microsoft Excel 2007?

All replies

• 

  

  1

  Sign in to vote

  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 KhanModerator Sunday, July 25, 2010 4:08 AM

  Saturday, July 10, 2010 2:15 AM

  Reply

  |

  Quote

  Moderator
• 

  

  0

  Sign in to vote

  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

  Reply

  |

  Quote
• 

  

  0

  Sign in to vote

  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

  Reply

  |

  Quote

  Moderator
• 

  

  2

  Sign in to vote

  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 KhanModerator Sunday, July 25, 2010 4:08 AM

  Monday, July 12, 2010 11:53 PM

  Reply

  |

  Quote
• 

  

  0

  Sign in to vote

  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

  Reply

  |

  Quote
• 

  

  0

  Sign in to vote

  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 KhanModerator Sunday, July 25, 2010 4:08 AM

  Thursday, July 15, 2010 7:31 PM

  Reply

  |

  Quote
• 

  

  0

  Sign in to vote

  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

  Reply

  |

  Quote