Overview

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 aeo Creating Data and Content aeo Analyzing Data aeo Formatting Data and Content aeo Collaborating aeo Managing Workbooks Excel 2003 Expert Certification Skill Sets aeo Organizing and Analyzing Data aeo Formatting Data and Content aeo Collaborating aeo Managing Data and Workbooks aeo Customizing Excel Plus, youa ll find additional career preparation tools, including: aeo Solutions for real--world scenarios aeo Structured learning for quick productivity aeo Full glossary of terms Go to www.sybex.com/go/mosexcel2003 for downloadable sample files from the exercises in the book. Practice what youa ve learned on your own. Visit www.sybex.com for all of your professional certification needs.

Full Product Details

Author:   Linda F. Johnson
Publisher:   John Wiley and Sons Ltd
Imprint:   John Wiley & Sons Inc
Dimensions:   Width: 19.10cm , Height: 3.00cm , Length: 23.90cm
Weight:   0.760kg
ISBN:  

9780471940029

ISBN 10:   047194002
Pages:   504
Publication Date:   01 April 2006
Audience:   Professional and scholarly ,  Professional & Vocational
Format:   Paperback
Publisher's Status:   Unknown
Availability:   Out of print, replaced by POD  
We will order this item for you from a manufatured on demand supplier.

Table of Contents

Introduction. Chapter 1. Navigating in Excel and Understanding the Interface. Chapter 2. Formats, Graphics, and Excel's Templates. Chapter 3. Organizing Data, Changing Views, and Printing. Chapter 4. Editing Tools, Comments, and Hyperlinks. Chapter 5. Formulas and Functions in Excel. Chapter 6. Advanced Functions, Table Arrays, and Database Features. Chapter 7. Advanced Data Organization and Display. Chapter 8. Data Analysis and Sharing Workbooks. Chapter 9. Advanced Template Design and Workbook Security. Chapter 10. Data In and Data Out. Chapter 11. Working with Macros. Chapter 12. Customizing Excel and Setting Defaults. Appendix. Scenario Solutions. Glossary. Index.

Reviews

Author Information

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, Lindaa s Computer Stop, at http://personal--computer--tutor.com.

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions