Microsoft Office Specialist: Excel 2003 Study Guide [Paperback]

Linda F. Johnson (Author)

Book Description

Publication Date: May 9, 2006 | ISBN-10: 047194002X | ISBN-13: 978-0471940029 | Edition: 1

Validate your expertise and get the attention of employers with Microsoft Office Specialist certification. This comprehensive guide is what you need to prepare for certification in Excel 2003, both the Specialist and Expert levels.

Carefully planned by a seasoned Microsoft Office Specialist instructor, this invaluable study guide uses real-world scenarios to teach the full range of Excel 2003 skills you need-not only to prepare for the certification exams, but also to increase your ability and productivity in the workplace. Covering twenty-four Specialist exam objectives and thirty-three Expert exam objectives, the book progresses through the functions and features of Excel software. Even entry-level Excel users can rapidly build their skills.

Excel 2003 Specialist Certification Skill Sets
* Creating Data and Content
* Analyzing Data
* Formatting Data and Content
* Collaborating
* Managing Workbooks

Excel 2003 Expert Certification Skill Sets
* Organizing and Analyzing Data
* Formatting Data and Content
* Collaborating
* Managing Data and Workbooks
* Customizing Excel

Plus, you'll find additional career preparation tools, including:
* Solutions for real-world scenarios
* Structured learning for quick productivity
* Full glossary of terms

Go to www.sybex.com/go/mosexcel2003 for downloadable sample files from the exercises in the book. Practice what you've learned on your own.

Visit www.sybex.com for all of your professional certification needs.

Editorial Reviews

From the Back Cover

Validate your expertise and get the attention of employers with Microsoft Office Specialist certification. This comprehensive guide is what you need to prepare for certification in Excel 2003, both the Specialist and Expert levels.

Carefully planned by a seasoned Microsoft Office Specialist instructor, this invaluable study guide uses real-world scenarios to teach the full range of Excel 2003 skills you need—not only to prepare for the certification exams, but also to increase your ability and productivity in the workplace. Covering twenty-four Specialist exam objectives and thirty-three Expert exam objectives, the book progresses through the functions and features of Excel software. Even entry-level Excel users can rapidly build their skills.

Excel 2003 Specialist Certification Skill Sets

• Creating Data and Content
• Analyzing Data
• Formatting Data and Content
• Collaborating
• Managing Workbooks

Excel 2003 Expert Certification Skill Sets

• Organizing and Analyzing Data
• Formatting Data and Content
• Collaborating
• Managing Data and Workbooks
• Customizing Excel

Plus, you'll find additional career preparation tools, including:

• Solutions for real-world scenarios
• Structured learning for quick productivity
• Full glossary of terms

Go to www.sybex.com/go/mosexcel2003 for downloadable sample files from the exercises in the book. Practice what you've learned on your own.

Visit www.sybex.com for all of your professional certification needs.

About the Author

Linda F. Johnson, is a seasoned instructor who teaches the Specialist and Expert level classes for the Microsoft Office Specialist certification at Lansdale School of Business. She also owns and maintains a website, Linda's Computer Stop, at http://personal-computer-tutor.com.

Product Details

• Paperback: 504 pages
• Publisher: Sybex; 1 edition (May 9, 2006)
• Language: English
• ISBN-10: 047194002X
• ISBN-13: 978-0471940029
• Product Dimensions: 9.3 x 7.5 x 1.1 inches
• Shipping Weight: 1.6 pounds (View shipping rates and policies)
• Average Customer Review: 4.7 out of 5 stars  See all reviews (35 customer reviews)
• Amazon Best Sellers Rank: #735,380 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

13 of 13 people found the following review helpful:

5.0 out of 5 stars Excel ent, January 4, 2007

By 

Lisa - See all my reviews

This review is from: Microsoft Office Specialist: Excel 2003 Study Guide (Paperback)

I've taken a loooong time over this review. Mainly because I didn't believe a book about Excel could be so good!

It would be easy to go on and on but I'm desperately trying to keep it short!!... Soooo... here goes!

This book could easilly be renamed ... "How to... in Excel". I mean it. It's absolutely full of tips hints and suggestions for stuff you didn't think you could do... but can!! The "real world scenarios" are a great touch.

I thought I was pretty well versed in Excel. Reading this book... I'm not saying I was wrong... I just learnt so much more!!!

But..It's an MOS book.. and in that context it walks through all of the items needed to become certified. Actually it strolls.. with an easy gait. I tried this on my non cumputer litrate mum and actually bought her the book becuase I wouldn't have got it back otherwise!! Likewise my brother.. who uses Excel in his work daily.. just had to have a copy of his own... another birthday present solved!

As an MOS book... everything is there. *All* the stuff you need to get qualified with examples downloadable from the Wiley site. My copy is a christmas tree of coloured sticky tags to go back to. The explanations are step by step and have clearly been worked on till they are on the money. I know. Because I didn't want my mum to come back at me and say "but it said.."... I took a lot of time working through them all... each and every instruction for every example.. and all worked as stated for me, which is in itself unusual!

You may have gathered by now that this is not just an MOS book. It's a book for anyone who wants to do something with Excel... and it's got pictures!!

Linda has done a remarkable nee miraculous job of producing a book that is readable as well as useable by both novices and experts.

If you get this book you will definately not be dissapointed.

Linda... if you ever do an access or word book please give me a heads up so I can order in advance of the rush!!!

Lisa

8 of 8 people found the following review helpful:

4.0 out of 5 stars A Good Study Guide, July 2, 2006

By 

C. McDonald - See all my reviews
(REAL NAME)   

This review is from: Microsoft Office Specialist: Excel 2003 Study Guide (Paperback)

This is a very well written book that thoughtfully and clearly explains the concepts presented. If you are planning on taking the exam to become MOS certified in Excel, this is an excellent book to use. The book starts out fairly simply; the first chapter goes over the basics of navigating and understanding Excel's interface. Even with a fairly good knowledge of Excel, I found the chapters informative and even in areas I thought I already had a good understanding I usually picked up a tip or two. The chapters have easy to follow examples that put to use the information previously presented. The scenarios provide a chance to actually use what was presented in the chapter without step by step instructions, by letting you think through it yourself. The book provides examples of each area, but you will still need to explore Excel on your own as stated in the book. I wish I had this book about 2 months ago when we were struggling with creating a formula that would calculate elapsed hours over more than one day. Had I had a better understanding of how Excel handles dates (as explained in this book) we would have figured out a solution much quicker. I would recommend this book to anyone who is either thinking of or planning on taking the MOS exam. It's pushed me further in that direction.

8 of 8 people found the following review helpful:

5.0 out of 5 stars Hope She Does a Book on Access!, April 28, 2007

By 

Kate Kelsey "Savedays" (Philadelphia) - See all my reviews

This review is from: Microsoft Office Specialist: Excel 2003 Study Guide (Paperback)

After countless books and in-house training classes on Microwoft software (which included handbooks), I've finally found an Excel Book that was not only written by someone with in-depth knowledge/skills, but is able to communicate in a clear, well organized and easy-to-follow manner. This book painlessly took me from a Beginner/Intermediate to an Intermediate/Advanced in a relatively short time. I'm looking forward to more from Ms. Johnson on Access and Word!