Microsoft Office Specialist: Excel 2003 Study Guide

  • 9h 59m
  • Linda F. Johnson
  • Sybex
  • 2006

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

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

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

In this Book

  • Navigating in Excel and Understanding the Interface
  • Formats, Graphics, and Excel's Templates
  • Organizing Data, Changing Views, and Printing
  • Editing Tools, Comments, and Hyperlinks
  • Formulas and Functions in Excel
  • Advanced Functions, Table Arrays, and Database Features
  • Advanced Data Organization and Display
  • Data Analysis and Sharing Workbooks
  • Advanced Template Design and Workbook Security
  • Data In and Data Out
  • Working with Macros
  • Customizing Excel and Setting Defaults
SHOW MORE
FREE ACCESS