You are previewing Show Me Microsoft® Office Excel 2003.
O'Reilly logo
Show Me Microsoft® Office Excel 2003

Book Description

See it done, do it yourself! Spend less time reading and more time doing with this simple, step-by-step approach.

  • Excel 2003 provides powerful new tools with which to create, analyze, and share spreadsheet information.

  • Based on a proven, successful series format, this book uses a visual page design with easy-to-read text to teach beginning to intermediate level Excel tasks.

  • Troubleshooting guides, "see also" referencing, sample projects, and MOS objectives add even more for the ambitious learner.

  • Author Steve Johnson is a professional trainer and author of several best-selling books.

  • Table of Contents

    1. Copyright
      1. Dedication
    2. Acknowledgements
      1. Perspection, Inc.
      2. Acknowledgements
      3. About The Author
      4. We Want To Hear From You!
    3. Introduction
      1. Find the Best Place to Start
      2. What's New
      3. How This Book Works
      4. Step-by-Step Instructions
      5. Real World Examples
      6. Troubleshooting Guide
      7. Show Me Live Software
      8. Microsoft Office Specialist
    4. 1. Getting Started with Excel
      1. Introduction
      2. Starting Excel
        1. Start Excel from the Start Menu
      3. Viewing the Excel Window and Task Panes
      4. Starting a New Workbook
        1. Start a New Workbook from the Task Pane
        2. Start a New Workbook from the New Button
        3. Create a File Using a Template or Wizard
        4. Get Templates on the Web
      5. Opening an Existing Workbook
        1. Open a Workbook from the Excel Window
        2. Open a Recently Opened Workbook from the Start Menu
      6. Moving Around the Workbook
        1. Use the Mouse to Navigate
        2. Use the Keyboard to Navigate
        3. Go To a Specific Location
      7. Working with Menus and Toolbars
        1. Choose a Command Using a Menu
        2. Choose a Command Using a Toolbar Button
        3. Choose a Command Using a Shortcut Key
        4. Display or Hide a Toolbar
      8. Working with Dialog Boxes
        1. Choose Dialog Box Options
      9. Using Task Panes
        1. Open and Close Task Panes
        2. Use the Task Pane
      10. Arranging Windows
        1. Resize and Move a Window
        2. Use the Mouse to Move a Window
        3. Use the Mouse to Resize a Window
        4. Arrange Multiple Windows
      11. Getting Help
        1. Get Help Without the Office Assistant
        2. Get Help While You Work
        3. Get Help in a Dialog Box
      12. Getting Help from the Office Assistant
        1. Ask the Office Assistant for Help
        2. Choose an Office Assistant
        3. Turn Off the Office Assistant
      13. Saving a Workbook
        1. Save a Workbook for the First Time
        2. Save a File with Another Name
        3. Save a File in a New Folder
      14. Saving a File with Different Formats
        1. Save a File as a Different Type
        2. Create a Template
      15. Getting Excel Updates on the Web
        1. Get Office Updates on the Web
      16. Recovering a Workbook
        1. Recover a File
        2. Using AutoRecover
      17. Exiting Excel
        1. Close a Workbook
        2. Quit Excel
    5. 2. Basic Workbook Skills
      1. Introduction
      2. Making Label Entries
      3. Selecting Cells
        1. Select a Contiguous Range
        2. Select a Non-contiguous Range
      4. Entering Labels on a Worksheet
        1. Enter a Text Label
        2. Enter a Number as a Label
        3. Enter a Label Using AutoComplete
      5. Entering Values on a Worksheet
        1. Enter a Value
        2. Enter a Date or Time
        3. Change Date or Time Format
      6. Entering Values Quickly with AutoFill
        1. Enter Repeating Data Using AutoFill
        2. Create a Complex Series Using AutoFill
      7. Editing Cell Contents
        1. Edit Cell Contents
      8. Clearing Cell Contents
        1. Clear the Contents of a Cell
        2. Clear Cell Contents, Formatting, and Comments
      9. Undoing and Redoing an Action
        1. Undo an Action
        2. Redo an Action
      10. Understanding How Excel Pastes Data
      11. Storing Cell Contents
        1. Copy Data to the Office Clipboard
        2. Paste Data from the Office Clipboard
      12. Copying Cell Contents
        1. Copy Data Using the Windows Clipboard
        2. Copy Data Using Drag-and-Drop
        3. Paste Data with Special Results
      13. Moving Cell Contents
        1. Move Data Using the Clipboard
        2. Move Data Using Drag-and-Drop
        3. Paste Cells from Rows to Columns or Columns to Rows
      14. Inserting and Deleting Cell Contents
        1. Insert a Cell
        2. Delete a Cell
      15. Finding and Replacing Cell Contents
        1. Find Cell Contents
        2. Replace Cell Contents
      16. Correcting Cell Contents with AutoCorrect
        1. Add an AutoCorrect Entry
        2. Edit an AutoCorrect Entry
        3. Change AutoCorrect Exceptions
      17. Using Smart Tags
        1. Change Smart Tag Options
        2. Get a Stock Quote Using a Smart Tag
      18. Checking Your Spelling
        1. Check Spelling
        2. Turn On AutoCorrect
    6. 3. Working with Formulas and Functions
      1. Introduction
      2. Creating a Simple Formula
        1. Enter a Formula
        2. Display Formulas in Cells
      3. Editing a Formula
        1. Edit a Formula Using the Formula Bar
        2. Copy a Formula Using AutoFill
        3. Copy a Formula Using the Windows Clipboard
      4. Understanding Cell Referencing
        1. Cell References in Formulas
        2. Relative Cell References
        3. Absolute Cell References
      5. Using Absolute Cell References
        1. Use an Absolute Reference
      6. Using Labels for Cell References
        1. Define Label Ranges
        2. Remove a Label Range
      7. Naming Cells and Ranges
        1. Name a Cell or Range
        2. Select a Named Cell or Range
        3. Let Excel Name a Cell or Range
        4. Apply a Name to a Cell or Range Address
      8. Simplifying a Formula with Ranges
        1. Use a Range in a Formula
        2. Use a Range Name in a Formula
      9. Displaying Calculations with AutoCalculate
        1. Calculate a Range Automatically
      10. Calculating Totals with AutoSum
        1. Calculate Totals with AutoSum
        2. Calculate with Extended AutoSum
        3. Calculate Subtotals and Totals
      11. Correcting Calculation Errors
        1. Review and Correct Errors
      12. Correcting Formulas
        1. Watch Cells and Formulas
        2. Correct Errors
      13. Auditing a Worksheet
        1. Trace Worksheet Relationships
      14. Performing Calculations Using Functions
        1. Enter a Function
      15. Creating Functions
        1. Enter a Function Using Insert Function
    7. 4. Modifying Worksheets and Workbooks
      1. Introduction
      2. Selecting and Naming a Worksheet
        1. Select a Worksheet
        2. Name a Worksheet
      3. Inserting and Deleting a Worksheet
        1. Insert a Worksheet
        2. Delete a Worksheet
      4. Moving and Copying a Worksheet
        1. Move a Worksheet Within a Workbook
        2. Copy a Worksheet
      5. Hiding and Unhiding Worksheets and Workbooks
        1. Hide or Unhide a Worksheet
        2. Hide or Unhide a Workbook
      6. Selecting a Column or Row
        1. Select a Column or Row
        2. Select Multiple Columns or Rows
      7. Hiding and Unhiding a Column or Row
        1. Hide a Column or Row
        2. Unhide a Column or Row
      8. Inserting a Column or Row
        1. Insert a Column or Row
        2. Insert Multiple Columns or Rows
      9. Deleting a Column or Row
        1. Delete a Column or Row
        2. Delete Multiple Columns or Rows
      10. Adjusting Column Width and Row Height
        1. Adjust Column Width or Row Height
        2. Adjust Column Width or Row Height Using the Mouse
        3. Change Column Width or Row Height Using AutoFit
      11. Freezing a Column or Row
        1. Freeze a Column or Row
        2. Unfreeze a Column or Row
      12. Splitting a Worksheet in Panes
        1. Split a Worksheet in Panes
      13. Creating a Template
        1. Create a Template
      14. Opening a Template
        1. Open a Template
      15. Changing a Template
        1. Change an Excel Template
    8. 5. Formatting a Worksheet
      1. Introduction
      2. Formatting Text and Numbers
        1. Format Text Quickly
        2. Format Numbers Quickly
        3. Format a Number Using the Format Cells Dialog Box
      3. Designing Conditional Formatting
        1. Establish a Conditional Format
        2. Delete a Conditional Format
      4. Copying Cell Formats
        1. Copy a Cell Format
      5. Changing Fonts
        1. Change Font, Font Style, and Font Size
        2. Change Font and Font Size Using the Formatting Toolbar
      6. Changing Data Alignment
        1. Change Alignment Using the Format Dialog Box
        2. Change Alignment Using the Formatting Toolbar
      7. Controlling Text Flow
        1. Control the Flow of Text in a Cell
      8. Changing Data Color
        1. Change Font Color Using the Formatting Toolbar
      9. Adding Color and Patterns to Cells
        1. Apply Color and Patterns
        2. Apply Color Using the Formatting Toolbar
      10. Adding Borders to Cells
        1. Apply a Border
        2. Apply a Border Using the Formatting Toolbar
      11. Formatting Data with AutoFormat
        1. Apply an AutoFormat
      12. Modifying an AutoFormat
        1. Modify an AutoFormat
      13. Formatting Tabs and Background
        1. Add Color to Worksheet Tabs
        2. Add or Remove a Background
      14. Creating and Applying Styles
        1. Create a New Style
        2. Apply a Style
      15. Modifying a Style
        1. Modify a Style
        2. Merge Styles
        3. Delete a Style
      16. Finding and Replacing Formatting
        1. Find or Replace Formatting
    9. 6. Printing Worksheets and Workbooks
      1. Introduction
      2. Inserting Page Breaks
        1. Insert a Page Break
        2. Preview and Move a Page Break
      3. Setting Up the Page
        1. Change Page Orientation
        2. Change the Margin Settings
      4. Adding Headers and Footers
        1. Change a Header or Footer
      5. Customizing Worksheet Printing
        1. Print Part of a Worksheet
        2. Print Row and Column Titles on Each Page
        3. Print Gridlines, Column Letters, and Row Numbers
        4. Fit Your Worksheet on a Specific Number of Pages
      6. Setting the Print Area
        1. Set the Print Area
        2. Clear the Print Area
      7. Previewing a Worksheet
        1. Preview a Worksheet
      8. Printing a Worksheet and Workbook
        1. Print All or Part of a Worksheet
    10. 7. Inserting Graphics and Related Material
      1. Introduction
      2. Working with the Clipboard
        1. Paste Items from the Office Clipboard
        2. Delete Items from the Office Clipboard
        3. Change Clipboard Options
      3. Inserting Research Material
        1. Locate and Insert Research Material
        2. Use the Thesaurus
        3. Translate a Word
        4. Change Research Options
      4. Inserting and Deleting Pictures
        1. Insert Clip Art from the Clip Gallery
        2. Insert a Picture from an Existing File
        3. Delete a Picture
      5. Inserting Media Clips
        1. Insert a Clip Gallery Sound or Motion Clip
        2. Insert a Picture from a Scanner or Camera
      6. Modifying Pictures
        1. Change Contrast
        2. Change Brightness
        3. Choose a Color Type
        4. Restore Original Settings
      7. Cropping Pictures
        1. Crop a Picture
        2. Redisplay a Cropped Picture
      8. Stylizing Text with WordArt
        1. Create WordArt
      9. Editing WordArt Text
        1. Change the Shape of WordArt Text
        2. Rotate WordArt Text
        3. Color WordArt Text
        4. Edit or Format WordArt Text
      10. Applying WordArt Text Effects
        1. Make All Letters the Same Height
        2. Align WordArt
        3. Adjust Character Spacing
      11. Inserting an Organization Chart
        1. Create an Organization Chart
        2. Use the Style Gallery
        3. Type Text in a Chart Box
      12. Modifying an Organization Chart
        1. Add a Chart Box
        2. Change the Organization Chart Layout
        3. Rearrange a Chart Box
        4. Format a Chart Box
      13. Creating a Diagram
        1. Create a New Diagram
        2. Modify a Diagram
      14. Formatting a Diagram
        1. Format a Diagram
    11. 8. Drawing and Modifying Objects
      1. Introduction
      2. Drawing Lines and Arrows
        1. Draw a Straight Line
        2. Edit a Line
        3. Draw and Edit an Arrow
      3. Drawing AutoShapes
        1. Draw an Oval or Rectangle
        2. Draw an AutoShape
        3. Adjust an AutoShape
        4. Resize an AutoShape
      4. Inserting AutoShapes from the Clip Gallery
        1. Insert an AutoShape from the Clip Gallery
        2. Find Similar AutoShapes in the Clip Gallery
        3. Add Text to an AutoShape
      5. Moving and Resizing an Object
        1. Move an Object
        2. Nudge an Object
        3. Resize a Drawing Object with the Mouse
        4. Resize an Object Precisely
      6. Rotating and Flipping an Object
        1. Rotate an Object to Any Angle
        2. Rotate or Flip a Object Using Preset Increments
        3. Rotate a Drawing Object Around a Fixed Point
        4. Rotate a Object Precisely
      7. Choosing Object Colors
        1. Change a Drawing Object's Fill Color
        2. Change Colors and Lines in the Format AutoShape Dialog Box
        3. Create a Line Pattern
      8. Adding Object Shadows
        1. Use a Preset Shadow
        2. Change the Location of a Shadow
        3. Change the Color of a Shadow
      9. Creating a 3-D Object
        1. Apply a Preset 3-D Style
        2. Spin a 3-D Object
        3. Set Lighting for a 3-D Object
        4. Set Depth for a 3-D Object
      10. Aligning and Distributing Objects
        1. Align Objects
        2. Distribute Objects
      11. Arranging and Grouping Objects
        1. Change the Order of Objects
        2. Group Objects Together
        3. Ungroup an Object
        4. Regroup an Object
      12. Changing Object View Settings
        1. Change View Settings for Objects
    12. 9. Creating and Modifying Charts
      1. Introduction
      2. Understanding Chart Terminology
      3. Choosing the Right Type of Chart
      4. Creating a Chart
        1. Create a Chart Using the Chart Wizard
      5. Editing a Chart
      6. Selecting and Editing a Chart Object
        1. Select and Edit a Chart Object
      7. Changing a Chart Type
        1. Change a Chart Type Quickly
      8. Moving and Resizing a Chart
        1. Move an Embedded Chart
        2. Resize an Embedded Chart
      9. Pulling Out a Pie Slice
        1. Explode a Single Pie Slice
        2. Explode an Entire Pie
        3. Undo a Pie Explosion
      10. Adding and Deleting a Data Series
        1. Add a Data Series Quickly
        2. Delete a Data Series
        3. Change a Data Series
        4. Change Data Series Order
      11. Enhancing a Data Series
        1. Change a Data Series Color or Pattern
        2. Add a Picture to a Data Series
        3. Delete a Picture from a Data Series
      12. Enhancing a Chart
        1. Add a Title
        2. Add or Delete a Legend
        3. Add a Text Annotation
      13. Drawing on a Chart
        1. Add a Drop Shadow to a Text Annotation
        2. Add a Drop Shadow to a Chart Title
        3. Draw an Arrow on a Chart
      14. Formatting Chart Elements
        1. Format Chart Text
        2. Format a Chart Axis
      15. Adding Chart Gridlines
        1. Add Gridlines
    13. 10. Analyzing Worksheet Data
      1. Introduction
      2. Understanding Lists
      3. Creating a List
        1. Create a List
      4. Understanding a Data Form
      5. Adding Records Using a Data Form
        1. Add to a List Using a Data Form
      6. Managing Records Using a Data Form
        1. Display Selected Records
        2. Edit a Record
        3. Delete a Record
      7. Sorting Data in a List
        1. Sort Data Quickly
        2. Display Parts of a List
        3. Sort a List Using More Than One Field
      8. Displaying Parts of a List with AutoFilter
        1. Display Specific Records Using AutoFilter
      9. Creating Custom Searches
        1. Create a Custom Search Using AutoFilter
      10. Entering Data in a List
        1. Enter Data in a List Using Pick From Drop-Down List
      11. Working with Lists
        1. Insert a Row in a List
        2. Convert a List to a Range
      12. Analyzing Data Using a PivotTable
        1. Create a PivotTable Report
      13. Updating a PivotTable and PivotChart
        1. Update a PivotTable Report
        2. Add or Remove a Field in a PivotTable or PivotChart Report
      14. Modifying a PivotTable and PivotChart
        1. AutoFormat a PivotTable Report
        2. Change Field Settings in a PivotTable or PivotChart Report
        3. Create a PivotTable Report from an Existing PivotTable or PivotChart
      15. Charting a PivotTable
        1. Create a PivotChart Report from a PivotTable Report
        2. Modify a PivotChart Report
        3. Create a PivotChart Report with a PivotTable Report
      16. Creating Groups and Outlines
        1. Create an Outline or Group
        2. Work an Outline or Group
      17. Using Database Functions in a List
        1. Use the DSUM or DAVERAGE Function
      18. Adding Data Validation to a Worksheet
        1. Create Validation Rules
    14. 11. Building More Powerful Worksheets
      1. Introduction
      2. Loading and Unloading Add-Ins
        1. Load or Unload Add-Ins
      3. Using Data Analysis Tools
        1. Use Data Analysis Tools
      4. Looking at Alternatives with Data Tables
        1. Create a One-Input Data Table
      5. Asking “What If” with Goal Seek
        1. Create a “What-If” Scenario with Goal Seek
      6. Creating Scenarios
        1. Create and Show a Scenario
        2. Show a Scenario
      7. Using Solver
        1. Use Solver
      8. Using Lookup and Reference Functions
        1. Use the VLOOKUP Function
        2. Use the HLOOKUP Function
      9. Understanding How Macros Automate Your Work
      10. Recording a Macro
        1. Record a Macro
      11. Running a Macro
        1. Run a Macro Using a Menu Command
      12. Understanding Macro Code
      13. Debugging a Macro Using Step Mode
        1. Debug a Macro Using Step Mode
      14. Editing a Macro
        1. Edit a Macro
      15. Restricting Workbook Access
        1. Set Up Information Rights Management
        2. Create a Workbook with Restricted Permission
      16. Protecting Your Data
        1. Apply a Password to a Worksheet
        2. Apply a Password to Edit Parts of a Worksheet
      17. Using Digital Signatures
        1. Set Digital Signature
        2. Set a Macro Security Option
      18. Applying Security Settings
        1. Apply File Encryption
    15. 12. Sharing Workbook Data
      1. Introduction
      2. Sharing Workbooks
        1. Enable Workbook Sharing
        2. Change Sharing Options
      3. Creating and Reading a Cell Comment
        1. Add a Comment
        2. Read a Comment
      4. Editing and Deleting a Cell Comment
        1. Edit a Comment
        2. Delete a Comment
      5. Tracking Changes
        1. Turn On the Track Changes Feature
        2. Accept or Reject Tracked Changes
      6. Comparing and Merging Workbooks
        1. Merge Workbook Data
      7. Sending a Workbook for Review
        1. Send a Workbook for Review Using E-Mail
      8. Sharing Information Between Programs
        1. Importing and Exporting
        2. Embedding
        3. Linking
        4. Hyperlinking
        5. Deciding Which Method to Use
      9. Exporting and Importing Data
        1. Export Excel Data Using Copy and Paste
        2. Export an Excel File to Another Program Format
        3. Import a Text File
      10. Working with XML
        1. Attach a Schema
        2. Create an XML Data Map
        3. Import XML Data
      11. Exporting and Saving Data in XML
        1. Export XML Data
        2. Save XML Data
      12. Linking and Embedding Files
        1. Create a Link to Another File
        2. Modify a Link
        3. Embed a New Object
        4. Embed or Link to an Existing Object
      13. Linking Data
        1. Create a Link Between Worksheets or Workbooks
        2. Break a Link
      14. Consolidating Data
        1. Consolidate Data from Other Worksheets or Workbooks
      15. Getting Data from a Database
        1. Define a New Data Source
        2. Create a Database Query
      16. Getting Data from Another Program
        1. Export an Access Database Table into an Excel Workbook
        2. Create an Excel Workbook PivotTable from an Access Database
    16. 13. Publishing Data on the Web
      1. Introduction
      2. Opening a Workbook as a Web Page
        1. Open a Workbook as a Web Page in Excel
      3. Previewing a Web Page
        1. View the Web Page
      4. Creating a Hyperlink
        1. Create a Hyperlink
        2. Jump to a Hyperlink
        3. Remove a Hyperlink
      5. Saving a Worksheet as a Web Page
        1. Save a Workbook or Worksheet as a Web Page
        2. Save a Workbook or Worksheet as a Single File Web Page
      6. Publishing a Web Page
        1. Save and Publish a Worksheet as an Interactive Web Page
      7. Getting Data from the Web
        1. Get Data from the Web Using the Web Toolbar
      8. Copying a Web Table to a Worksheet
        1. Copy a Web Table to a Worksheet
      9. Creating Refreshable Web Queries
        1. Copy and Paste Refreshable Data from the Web
      10. Getting Data from Web Queries
        1. Get Data from a New Web Query
      11. Saving Web Queries
        1. Save a Web Query
        2. Import a Query
      12. Holding an Online Meeting
        1. Schedule a Meeting
        2. Hold a Meeting
        3. Collaborate in an Online Meeting
        4. Participate in an Online Meeting
      13. Sending Workbooks Using E-Mail
        1. Send a Worksheet in an E-Mail Message
        2. Send a Workbook as an E-Mail Attachment
        3. Route a Workbook in an E-Mail Message
      14. Getting Documents from the Web
        1. Add or Modify FTP Locations
        2. Access an FTP Site
    17. 14. Tools for Working More Efficiently
      1. Introduction
      2. Modifying Workbook Properties
        1. Display Workbook Properties
        2. Customize Workbook Properties
        3. Link to Workbook Properties
      3. Finding a File or Contents in a File
        1. Find a File or Contents in a File
        2. Find a Property in a File
      4. Changing Options
        1. Change General Options
        2. Change Edit Options
      5. Changing Your Worksheet View
        1. Change View Options
      6. Creating a Custom View
        1. Create a Custom View
        2. Create a Custom View
      7. Creating a Toolbar
        1. Create a Toolbar
        2. Change Toolbars and Menus Options
      8. Customizing a Toolbar
        1. Personalize a Toolbar Quickly
        2. Delete a Button from a Toolbar
        3. Add a Button to a Toolbar
      9. Adding Menus and Menu Items
        1. Add a Menu Item
        2. Create a New Menu
      10. Playing Back Worksheet Data
        1. Speak the Value of Cells
      11. Controlling Excel with Your Voice
        1. Work with the Language Bar
        2. Train Your Computer to Your Voice
      12. Executing Voice Commands
        1. Execute Voice Commands
      13. Dictating Text
        1. Dictate Text
      14. Recognizing Handwriting
        1. Insert Handwritten Text into a Document
        2. Insert Handwritten Text on a Writing Pad
      15. Repairing and Recovering Office Programs
        1. Detect and Repair Problems
        2. Recover an Office Program
        3. Perform Maintenance on Office Programs
      16. Using Multiple Languages
        1. Add a Language to Office Programs
    18. 15. Working Together on Office Documents
      1. Introduction
      2. Viewing SharePoint Team Services
      3. Administering SharePoint Team Services
      4. Storing Documents in the Library
        1. Upload a Document
      5. Viewing Team Members
        1. Add New Members to the Site
      6. Setting Up Alerts
        1. Create Your E-Mail Alert
      7. Assigning Project Tasks
        1. Add a Task Item to Your Site
      8. Creating an Event
        1. Setup New Events
        2. Link to Events in Outlook
      9. Creating Contacts
        1. Create a Contact List
        2. Link to Contacts in Outlook
      10. Holding Web Discussions
        1. Hold a Web Discussion
      11. Working with Shared Workspace
        1. Use Shared Workspace in an Office 2003 Program
      12. Publishing a List
        1. Publish a Data List
        2. Work with a Published Data List on the SharePoint Server
      13. Installing Windows 2003 and SharePoint Server 2003
    19. Microsoft Office Specialist
      1. About the Microsoft Office Specialist Program
      2. What Does This Logo Mean?
      3. Preparing for a Microsoft Office Specialist Exam
      4. Taking a Microsoft Office Specialist Exam
        1. The Exam Experience
        2. Tips for Taking an Exam
        3. Exam Results
      5. Getting More Information
    20. New! Features
      1. Microsoft Office Excel 2003
    21. Troubleshooting
      1. Cells
      2. Charts
      3. Clip art and objects
      4. Clipboard
      5. Data
      6. Database and lists
      7. Entering and selecting data
      8. Formatting data
      9. Formulas and functions
      10. Help
      11. Importing and exporting
      12. Languages and voice options
      13. Menus, toolbars, and task panes
      14. Microsoft Office Specialist
      15. Navigation
      16. Printing
      17. Reviewing changes
      18. Saving
      19. Security
      20. SharePoint
      21. Spelling
      22. Templates and styles
      23. Web
      24. Worksheets and workbooks