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
- Copyright
- Acknowledgements
- Introduction
-
1. Getting Started with Excel
- Introduction
- Starting Excel
- Viewing the Excel Window and Task Panes
- Starting a New Workbook
- Opening an Existing Workbook
- Moving Around the Workbook
- Working with Menus and Toolbars
- Working with Dialog Boxes
- Using Task Panes
- Arranging Windows
- Getting Help
- Getting Help from the Office Assistant
- Saving a Workbook
- Saving a File with Different Formats
- Getting Excel Updates on the Web
- Recovering a Workbook
- Exiting Excel
-
2. Basic Workbook Skills
- Introduction
- Making Label Entries
- Selecting Cells
- Entering Labels on a Worksheet
- Entering Values on a Worksheet
- Entering Values Quickly with AutoFill
- Editing Cell Contents
- Clearing Cell Contents
- Undoing and Redoing an Action
- Understanding How Excel Pastes Data
- Storing Cell Contents
- Copying Cell Contents
- Moving Cell Contents
- Inserting and Deleting Cell Contents
- Finding and Replacing Cell Contents
- Correcting Cell Contents with AutoCorrect
- Using Smart Tags
- Checking Your Spelling
-
3. Working with Formulas and Functions
- Introduction
- Creating a Simple Formula
- Editing a Formula
- Understanding Cell Referencing
- Using Absolute Cell References
- Using Labels for Cell References
- Naming Cells and Ranges
- Simplifying a Formula with Ranges
- Displaying Calculations with AutoCalculate
- Calculating Totals with AutoSum
- Correcting Calculation Errors
- Correcting Formulas
- Auditing a Worksheet
- Performing Calculations Using Functions
- Creating Functions
-
4. Modifying Worksheets and Workbooks
- Introduction
- Selecting and Naming a Worksheet
- Inserting and Deleting a Worksheet
- Moving and Copying a Worksheet
- Hiding and Unhiding Worksheets and Workbooks
- Selecting a Column or Row
- Hiding and Unhiding a Column or Row
- Inserting a Column or Row
- Deleting a Column or Row
- Adjusting Column Width and Row Height
- Freezing a Column or Row
- Splitting a Worksheet in Panes
- Creating a Template
- Opening a Template
- Changing a Template
-
5. Formatting a Worksheet
- Introduction
- Formatting Text and Numbers
- Designing Conditional Formatting
- Copying Cell Formats
- Changing Fonts
- Changing Data Alignment
- Controlling Text Flow
- Changing Data Color
- Adding Color and Patterns to Cells
- Adding Borders to Cells
- Formatting Data with AutoFormat
- Modifying an AutoFormat
- Formatting Tabs and Background
- Creating and Applying Styles
- Modifying a Style
- Finding and Replacing Formatting
- 6. Printing Worksheets and Workbooks
-
7. Inserting Graphics and Related Material
- Introduction
- Working with the Clipboard
- Inserting Research Material
- Inserting and Deleting Pictures
- Inserting Media Clips
- Modifying Pictures
- Cropping Pictures
- Stylizing Text with WordArt
- Editing WordArt Text
- Applying WordArt Text Effects
- Inserting an Organization Chart
- Modifying an Organization Chart
- Creating a Diagram
- Formatting a Diagram
-
8. Drawing and Modifying Objects
- Introduction
- Drawing Lines and Arrows
- Drawing AutoShapes
- Inserting AutoShapes from the Clip Gallery
- Moving and Resizing an Object
- Rotating and Flipping an Object
- Choosing Object Colors
- Adding Object Shadows
- Creating a 3-D Object
- Aligning and Distributing Objects
- Arranging and Grouping Objects
- Changing Object View Settings
-
9. Creating and Modifying Charts
- Introduction
- Understanding Chart Terminology
- Choosing the Right Type of Chart
- Creating a Chart
- Editing a Chart
- Selecting and Editing a Chart Object
- Changing a Chart Type
- Moving and Resizing a Chart
- Pulling Out a Pie Slice
- Adding and Deleting a Data Series
- Enhancing a Data Series
- Enhancing a Chart
- Drawing on a Chart
- Formatting Chart Elements
- Adding Chart Gridlines
-
10. Analyzing Worksheet Data
- Introduction
- Understanding Lists
- Creating a List
- Understanding a Data Form
- Adding Records Using a Data Form
- Managing Records Using a Data Form
- Sorting Data in a List
- Displaying Parts of a List with AutoFilter
- Creating Custom Searches
- Entering Data in a List
- Working with Lists
- Analyzing Data Using a PivotTable
- Updating a PivotTable and PivotChart
- Modifying a PivotTable and PivotChart
- Charting a PivotTable
- Creating Groups and Outlines
- Using Database Functions in a List
- Adding Data Validation to a Worksheet
-
11. Building More Powerful Worksheets
- Introduction
- Loading and Unloading Add-Ins
- Using Data Analysis Tools
- Looking at Alternatives with Data Tables
- Asking âWhat Ifâ with Goal Seek
- Creating Scenarios
- Using Solver
- Using Lookup and Reference Functions
- Understanding How Macros Automate Your Work
- Recording a Macro
- Running a Macro
- Understanding Macro Code
- Debugging a Macro Using Step Mode
- Editing a Macro
- Restricting Workbook Access
- Protecting Your Data
- Using Digital Signatures
- Applying Security Settings
-
12. Sharing Workbook Data
- Introduction
- Sharing Workbooks
- Creating and Reading a Cell Comment
- Editing and Deleting a Cell Comment
- Tracking Changes
- Comparing and Merging Workbooks
- Sending a Workbook for Review
- Sharing Information Between Programs
- Exporting and Importing Data
- Working with XML
- Exporting and Saving Data in XML
- Linking and Embedding Files
- Linking Data
- Consolidating Data
- Getting Data from a Database
- Getting Data from Another Program
-
13. Publishing Data on the Web
- Introduction
- Opening a Workbook as a Web Page
- Previewing a Web Page
- Creating a Hyperlink
- Saving a Worksheet as a Web Page
- Publishing a Web Page
- Getting Data from the Web
- Copying a Web Table to a Worksheet
- Creating Refreshable Web Queries
- Getting Data from Web Queries
- Saving Web Queries
- Holding an Online Meeting
- Sending Workbooks Using E-Mail
- Getting Documents from the Web
-
14. Tools for Working More Efficiently
- Introduction
- Modifying Workbook Properties
- Finding a File or Contents in a File
- Changing Options
- Changing Your Worksheet View
- Creating a Custom View
- Creating a Toolbar
- Customizing a Toolbar
- Adding Menus and Menu Items
- Playing Back Worksheet Data
- Controlling Excel with Your Voice
- Executing Voice Commands
- Dictating Text
- Recognizing Handwriting
- Repairing and Recovering Office Programs
- Using Multiple Languages
-
15. Working Together on Office Documents
- Introduction
- Viewing SharePoint Team Services
- Administering SharePoint Team Services
- Storing Documents in the Library
- Viewing Team Members
- Setting Up Alerts
- Assigning Project Tasks
- Creating an Event
- Creating Contacts
- Holding Web Discussions
- Working with Shared Workspace
- Publishing a List
- Installing Windows 2003 and SharePoint Server 2003
- Microsoft Office Specialist
- New! Features
-
Troubleshooting
- Cells
- Charts
- Clip art and objects
- Clipboard
- Data
- Database and lists
- Entering and selecting data
- Formatting data
- Formulas and functions
- Help
- Importing and exporting
- Languages and voice options
- Menus, toolbars, and task panes
- Microsoft Office Specialist
- Navigation
- Printing
- Reviewing changes
- Saving
- Security
- SharePoint
- Spelling
- Templates and styles
- Web
- Worksheets and workbooks
Product information
- Title: Show Me Microsoft® Office Excel 2003
- Author(s):
- Release date: September 2003
- Publisher(s): Que
- ISBN: 9780789730053
You might also like
book
Microsoft® Office Excel 2003 Inside Out
Take your Microsoft Excel experience to the next level! This supremely organized reference packs hundreds of …
book
Special Edition Using® Microsoft® Office Excel 2003
Does your life play out in a spreadsheet? Are numbers in columns and rows what make …
book
Microsoft® Office Excel® 2003 Step by Step
Teach yourself how to use the data-presentation and number-crunching power in the latest version of Microsoft …
book
Excel 2003 for Starters: The Missing Manual
The dominant spreadsheet program and one of the most widely used software applications in the world, …