Microsoft Office Specialist Excel 2003 Study Guide

by
Edition: 1st
Format: Paperback
Pub. Date: 2006-05-09
Publisher(s): Sybex
  • Free Shipping Icon

    This Item Qualifies for Free Shipping!*

    *Excludes marketplace orders.

List Price: $31.50

Buy New

Usually Ships in 8 - 10 Business Days.
$31.47

Rent Book

Select for Price
There was a problem. Please try again later.

Used Book

We're Sorry
Sold Out

eBook

We're Sorry
Not Available

How Marketplace Works:

  • This item is offered by an independent seller and not shipped from our warehouse
  • Item details like edition and cover design may differ from our description; see seller's comments before ordering.
  • Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
  • Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
  • Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.

Summary

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.

Author Biography

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.

Table of Contents

Introduction xxiii
Navigating in Excel and Understanding the Interface
1(44)
Understanding Excel's Interface
2(7)
Investigating the Default Bars at the Top of Your Screen
3(2)
Task Pane
5(2)
Workbook Components
7(1)
Worksheet Components
8(1)
Navigating in Excel
9(3)
Moving Around in Workbooks
9(1)
Moving Around in Worksheets
10(2)
Adding and Editing Data in a Workbook
12(17)
Managing Data in Cells
12(4)
Managing Cells
16(1)
Managing Rows and Columns
17(5)
Organizing Worksheets
22(5)
Saving and Managing Workbooks
27(2)
Moving and Copying Data
29(12)
Copy and Paste
29(2)
Cut and Paste
31(1)
Selecting Contiguous and Noncontiguous Ranges
32(4)
Using the Office Clipboard
36(2)
Using the Mouse to Drag and Drop or Fill Data
38(3)
Summary
41(1)
Exam Essentials
42(1)
Sample MOS Scenarios
42(3)
Formats, Graphics, and Excel's Templates
45(52)
Using the Format Cells Dialog Box and the Formatting Toolbar
46(13)
Font Formatting
48(3)
Using the Different Cell Formats
51(4)
Cell Alignment
55(2)
Applying Cell Borders and Patterns
57(2)
Formatting Shortcuts
59(3)
Creating and Modifying Styles
60(1)
The Format Painter
61(1)
Formatting Worksheets
62(3)
Using AutoFormats
62(2)
Formatting Backgrounds
64(1)
Excel and Graphics
65(13)
Understanding the Drawing Toolbar
65(4)
Adding and Editing Graphics in a Worksheet
69(6)
Adding and Editing Diagrams and Organization Charts in a Worksheet
75(3)
Creating and Modifying Charts
78(14)
Using the Chart Wizard
78(5)
Using the Chart Toolbar
83(3)
Customizing Charts
86(2)
Editing the Data Used to Produce Charts
88(3)
Combination Charts
91(1)
Using Excel's Templates
92(2)
Understanding Templates
92(1)
Adding Data Using Templates
93(1)
Summary
94(1)
Exam Essentials
94(1)
Sample MOS Scenarios
95(2)
Organizing Data, Changing Views, and Printing
97(34)
Organizing Data
98(7)
Sorting Data, Based on Single and Multiple Columns
99(3)
Using AutoFilters
102(3)
Working with Views
105(8)
Freezing Panes and Splitting Worksheets
106(1)
Using Multiple Windows to View and Edit Data
107(3)
Creating Workspaces
110(2)
Understanding Custom Views
112(1)
Controlling Page Layout
113(11)
Orienting a Page and Repeating Rows and Columns
114(3)
Adding Headers and Footers
117(4)
Setting Margins
121(1)
Managing Page Breaks
122(2)
Printing
124(4)
Printing Selections
125(1)
Printing Multiple Copies and Specific Pages
126(2)
Summary
128(1)
Exam Essentials
129(1)
Sample MOS Scenarios
129(2)
Editing Tools, Comments, and Hyperlinks
131(28)
Using Excel's Editing Tools
132(20)
Using the Spelling Tool
132(3)
Using AutoCorrect
135(2)
Using Find And Replace
137(5)
Using Automated Features to Maintain Accuracy and Consistency
142(4)
Using the Research Pane
146(4)
Converting Text to Columns
150(2)
Comments and Hyperlinks
152(5)
Working with Comments
153(2)
Hyperlinks in Excel
155(2)
Summary
157(1)
Exam Essentials
157(1)
Sample MOS Scenarios
158(1)
Formulas and Functions in Excel
159(34)
Creating Basic Arithmetic Formulas
160(6)
Simple Arithmetic Using Operators
161(3)
Simple Addition Using the SUM Function
164(2)
Working with Statistical Functions
166(4)
Entering Statistical Functions Directly into Cells
166(2)
Using the Insert Function Utility
168(2)
Working with Date and Time Functions
170(4)
Date and Time Formats in Formulas
171(1)
Calculating Dates and Times
172(2)
Working with Financial Functions
174(6)
Using the PMT Function
175(3)
Using the FV Function
178(2)
Working with Logical Functions
180(9)
The IF Statement
181(2)
More Logical Functions
183(3)
Adding Multiple Nested Conditions and Multiple Return Values in IF Statements
186(3)
Printing Formulas
189(1)
Summary
190(1)
Exam Essentials
191(1)
Sample MOS Scenarios
191(2)
Advanced Functions, Table Arrays, and Database Features
193(36)
Understanding Cell References
194(3)
Using Named Ranges, Cells, and Constants
197(8)
Named Ranges
198(4)
Naming Cells as Bookmarks
202(2)
Naming Constant Values
204(1)
Using Lookup and Reference Functions
205(10)
The Lookup Functions
206(7)
The Reference Functions
213(2)
Using Database Functions and Features
215(7)
Excel's Database Features
215(5)
The Database Functions
220(2)
More Functions
222(2)
Text Functions
222(1)
Math & Trig Functions
223(1)
Information Functions
223(1)
Array-Entered Formulas
224(2)
Constructing Array-Entered Formulas
224(2)
Using Array-Entered Formulas
226(1)
Summary
226(1)
Exam Essentials
227(1)
Sample MOS Scenarios
228(1)
Advanced Data Organization and Display
229(44)
Summarizing Data
230(6)
Using Outlining When Data Is Already Subtotaled
231(3)
Creating Subtotals and Outlines at the Same Time
234(2)
Consolidating Data
236(4)
Linking Data
240(7)
Creating Simple Links to External Data
240(2)
Using Linked Data in Formulas
242(2)
Dealing with Broken Links
244(3)
Using Pivotal Reports
247(11)
Manipulating Data Layout with a PivotTable Report
248(8)
Producing a Pivot Chart
256(2)
Using Advanced Formatting Techniques
258(11)
Controlling Data Display with Custom Formats
258(7)
Controlling Data Display Using Conditional Formatting
265(4)
Summary
269(1)
Exam Essentials
269(1)
Sample MOS Scenarios
270(3)
Data Analysis and Sharing Workbooks
273(32)
Troubleshooting Formula Errors
274(11)
Locating Formula Errors
276(4)
Evaluating and Correcting Formula Errors
280(5)
Understanding What-If Analysis
285(9)
Using Goal Seek and Trendlines
285(3)
Using Scenarios to Compare Predictions
288(3)
Excel's Add-Ins
291(3)
Sharing Data
294(8)
Creating a Shared Workbook
296(2)
Using a Shared Workbook
298(4)
Summary
302(1)
Exam Essentials
302(1)
Sample MOS Scenarios
303(2)
Advanced Template Design and Workbook Security
305(34)
Designing Templates
306(17)
Understanding Templates and How They Work
307(1)
Editing Existing Templates
308(3)
Creating Your Own Templates
311(10)
Organizing Your Templates
321(2)
Workbook Security and Protection
323(13)
The Importance of Workbook Properties
324(2)
Worksheet and Workbook Protection
326(5)
File Protection
331(3)
Macro Security
334(2)
Summary
336(1)
Exam Essentials
337(1)
Sample MOS Scenarios
337(2)
Data In and Data Out
339(32)
Introduction to Converters
340(1)
Data In
341(15)
Opening Different File Types in Excel
341(5)
Bringing Data into Excel Using Alternative Methods
346(10)
Data Out
356(11)
Moving and Copying Data Out of a Worksheet
357(3)
Saving and Editing Excel Files in Different Formats
360(5)
Importing and Inserting Excel Worksheets into Other File Types
365(1)
Saving Workbook Structure Using XML
366(1)
Summary
367(1)
Exam Essentials
368(1)
Sample MOS Scenarios
369(2)
Working with Macros
371(24)
Working with Macros in One Workbook
372(14)
Recording New Macros
374(5)
Editing Macros
379(3)
Copying Macros
382(3)
Assigning Macros to Command Buttons
385(1)
Working with Macros in All Workbooks
386(5)
Creating a Personal Macro Workbook to Store Global Macros
387(2)
Assigning Macros to Toolbars and Menus
389(2)
Summary
391(1)
Exam Essentials
392(1)
Sample MOS Scenarios
393(2)
Customizing Excel and Setting Defaults
395(30)
Customizing Toolbars and Menus
397(10)
Setting Toolbar and Menu Options
398(3)
Creating New Toolbars and Adding Buttons
401(3)
Editing Toolbar Buttons and Menu Items
404(3)
Working with Excel's Options Dialog Box
407(13)
Excel's View Options
408(1)
Excel's Calculation Options
409(1)
Excel's Edit Options
410(1)
Excel's General Options
411(1)
Excel's Transition Options
412(1)
Excel's Chart Options
413(1)
Excel's Color Options
414(1)
Excel's International Options
415(1)
Excel's Save Options
416(1)
Excel's Error Checking Options
417(1)
Excel's Spelling Options
418(1)
Excel's Security Options
419(1)
Creating Default Workbooks and Worksheets
420(3)
Changing Your Default Workbook
420(2)
Changing Your Default Worksheet
422(1)
Restoring Excel's Default Workbook and Worksheet
422(1)
Summary
423(1)
Exam Essentials
423(1)
Sample MOS Scenarios
424(1)
Appendix. Scenario Solutions
425(18)
Scenario Solutions
426(1)
Scenario 1, Suggested Steps
426(1)
Scenario 2, Suggested Steps
426(1)
Scenario 3, Suggested Steps
427(1)
Scenario Solutions
427(2)
Scenario 4, Suggested Steps
427(1)
Scenario 5, Suggested Steps
428(1)
Scenario 6, Suggested Steps
428(1)
Scenario Solutions
429(2)
Scenario 7, Suggested Steps
429(1)
Scenario 8, Suggested Steps
429(1)
Scenario 9, Suggested Steps
430(1)
Scenario Solutions
431(1)
Scenario 10, Suggested Steps
431(1)
Scenario 11, Suggested Steps
431(1)
Scenario Solutions
432(1)
Scenario 12, Suggested Steps
432(1)
Scenario 13, Suggested Steps
432(1)
Scenario 14, Suggested Steps
432(1)
Scenario Solutions
433(1)
Scenario 15, Suggested Steps
433(1)
Scenario 16, Suggested Steps
433(1)
Scenario 17, Suggested Steps
434(1)
Scenario Solutions
434(2)
Scenario 18, Suggested Steps
434(1)
Scenario 19, Suggested Steps
435(1)
Scenario 20, Suggested Steps
435(1)
Scenario Solutions
436(2)
Scenario 21, Suggested Steps
436(1)
Scenario 22, Suggested Steps
436(1)
Scenario 23, Suggested Steps
437(1)
Scenario Solutions
438(1)
Scenario 24, Suggested Steps
438(1)
Scenario 25, Suggested Steps
438(1)
Scenario Solutions
439(1)
Scenario 26, Suggested Steps
439(1)
Scenario 27, Suggested Steps
439(1)
Scenario 28, Suggested Steps
440(1)
Scenario Solutions
440(1)
Scenario 29, Suggested Steps
440(1)
Scenario 30, Suggested Steps
440(1)
Scenario Solutions
441(2)
Scenario 31, Suggested Steps
441(1)
Scenario 32, Suggested Steps
441(2)
Glossary 443(16)
Index 459

An electronic version of this book is available through VitalSource.

This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.

By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.

Digital License

You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.

More details can be found here.

A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.

Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.

Please view the compatibility matrix prior to purchase.